{"text_format":"3","workbook":"xlsx","n_sheets":14,"sheets":["1 Admin block","2 Classroom A","3 Classroom B","4 Ablution block - Boys","5 Ablution block - Girls","SCH3","SCH2.3","SCH2.4","SCH2.5","SCH2.6","M1","6 Septic Tank","7 Electrical","Summary"],"not_rendered":{"external_links":3,"defined_names":508},"read":"whole","date_system":"1900"}

{"sheet":"1 Admin block","index":0,"n_rows":316,"n_cols":9,"rows_kept":316,"merged":[[0,2,0,4],[1,0,1,1],[2,0,2,1],[2,2,2,4],[3,2,3,4],[5,2,5,4],[6,3,6,4],[7,2,7,4],[8,2,8,4],[9,2,9,4],[10,3,10,4],[11,2,11,4],[12,3,12,4],[13,3,13,4],[14,2,14,4],[19,2,19,4],[20,2,20,4],[21,2,21,4],[22,2,22,4],[24,3,24,4],[26,3,26,4],[28,3,28,4],[30,3,30,4],[32,3,32,4],[33,0,33,7],[34,0,34,1],[34,2,34,4],[35,2,35,4],[36,2,36,4],[37,2,37,4],[38,3,38,4],[39,12,39,13],[40,3,40,4],[42,2,42,4],[43,3,43,4],[47,2,47,4],[48,3,48,4],[51,2,51,4],[52,2,52,4],[53,2,53,4],[54,3,54,4],[56,3,56,4],[58,2,58,4],[59,2,59,4],[61,2,61,4],[62,3,62,4],[63,3,63,4],[64,3,64,4],[65,3,65,4],[68,3,68,4],[70,2,70,4],[71,2,71,4],[72,2,72,4],[73,3,73,4],[74,3,74,4],[76,2,76,4],[77,2,77,4],[78,3,78,4],[79,3,79,4],[80,3,80,4],[82,2,82,4],[83,3,83,4],[84,3,84,4],[85,3,85,4],[86,3,86,4],[87,3,87,4],[88,2,88,4],[89,2,89,4],[90,2,90,4],[90,12,90,14],[91,3,91,4],[95,2,95,4],[98,3,98,4],[99,10,99,13],[99,14,99,15],[100,14,101,15],[102,3,102,4],[107,2,107,4],[114,2,114,4],[115,3,115,4],[126,3,126,4],[135,3,135,4],[141,2,141,4],[142,2,142,4],[143,3,143,4],[144,3,144,4],[145,2,145,4],[146,3,146,4],[148,2,148,4],[149,3,149,4],[153,2,153,4],[154,2,154,4],[155,2,155,4],[156,3,156,4],[162,3,162,4],[170,2,170,4],[171,2,171,4],[172,2,172,4],[173,3,173,4],[176,3,176,4],[179,3,179,4],[186,3,186,4],[193,2,193,4],[194,2,194,4],[195,3,195,4],[196,3,196,4],[197,3,197,4],[198,3,198,4],[199,2,199,4],[200,3,200,4],[201,0,201,7],[202,0,202,1],[202,2,202,4],[203,2,203,4],[204,3,204,4],[211,3,211,4],[217,3,217,4],[221,2,221,4],[222,3,222,4],[225,3,225,4],[233,2,233,4],[234,3,234,4],[238,3,238,4],[240,3,240,4],[244,3,244,4],[246,3,246,4],[248,2,248,4],[249,3,249,4],[252,3,252,4],[255,3,255,4],[257,3,257,4],[259,3,259,4],[260,3,260,4],[261,3,261,4],[262,2,262,4],[263,3,263,4],[264,2,264,4],[265,3,265,4],[269,2,269,4],[270,2,270,4],[271,2,271,4],[272,3,272,4],[275,2,275,4],[277,3,277,4],[278,2,278,4],[279,2,279,4],[280,3,280,4],[281,2,281,4],[284,2,284,4],[285,2,285,4],[286,2,286,4],[287,3,287,4],[288,3,288,4],[289,2,289,4],[290,3,290,4],[294,3,294,4],[298,3,298,4],[300,2,300,4],[301,2,301,4],[302,3,302,4],[303,3,303,4],[304,3,304,4],[305,2,305,4],[306,3,306,4],[307,3,307,4],[308,3,308,4],[309,0,309,7],[311,0,311,7]]}
["PAYMENT REFERS TO","ITEM NO","DESCRIPTION",null,null,"UNIT","QUANTITY","RATE","AMOUNT"]
["1: ADMINISTRATION BLOCK"]
["SCHEDULE 1.1:",null,{"$f":"[3]Defaults!B8","v":"PRELIMINARY AND GENERAL"}]
["SANS",null,"GENERAL"]
["1200 A"]
[null,"1.1.1","Scheduled fixed-charge and value-related items:"]
[null,null,".01","Fixed preliminary and general charges",null,"sum",1,null,{"$f":"G7*H7","v":0}]
[null,"1.1.2","Scheduled time-related items:",null,null,"Month",8,null,{"$f":"G8*H8","v":0}]
[null,null,"TEMPORARY WORKS"]
[null,"1.1.3","Location and protection of existing services:"]
["8.4 c",null,".01","Excavate by hand to expose existing services",null,"m3",150,null,{"$f":"G11*H11","v":0}]
[null,"1.1.4","Additional tests"]
[null,null,".01","Additional tests required by the Engineer",null,"Prov Sum",1,null,{"v":20000,"d":"20,000.00"}]
[null,null,".02","Attendance and profit",null,"%",{"$f":"I13","v":{"v":20000,"d":"20,000.00"}},null,{"$f":"G14*H14","v":0}]
[null,"1.1.5","Update existing key plans of",null,null,"sum",1,null,{"$f":"G15*H15","v":0}]
[null,"1.1.6","OCCUPATIONAL HEALTH AND SAFETY"]
[null,null,".01","Compliance with OHS Act and"]
[{"$nulls":3},"Construction Regulations 2003",null,"sum",1,null,{"$f":"G18*H18","v":0}]
["SH01","1.1.7","HIV/AIDS AWARENESS"]
[null,null,"It is required of the Contractor to thoroughly study the Additional Specification SH: HIV / AIDS Requirements (PW 1544) of the Department that must be read together with and is deemed to be incorporated under this Section of the Bills of Quantities.  "]
[null,null,"Provision for pricing of HIV/AIDS awareness is made under the items hereafter and it is explicitly pointed out that all requirements of the aforementioned specification are deemed to be priced hereunder, as the said items represent the only method of measurement and no additional items or extras to the contract in this regard shall be entertained."]
[null,null,"The Contractor must take note that compliance with the HIV/AIDS Specification is compulsory. In the event of partial or total non-compliance, the Representative/Agent, notwithstanding the provisions of Clause 52 of the General Conditions of Contract for Works of Civil Engineering Construction or any other clause to the contrary, reserves the right to delay issuing any progress payment certificate until the Contractor provides satisfactory proof of compliance. "]
[null,null,"The Contractor shall not be entitled to any compensation of whatsoever nature, including interest, due to such delay of payment."]
["SH 07",null,".01","Awareness Campaign",null,"sum",1,null,{"$f":"G24*H24","v":0}]
[{"$nulls":3},"Selection, appointment, briefing and making available of an Awareness Campaign including provision of all relevant services."]
["SH 04.01",null,".02","Awareness Workshops",null,"sum",1,null,{"$f":"G26*H26","v":0}]
[{"$nulls":3},"Selection and appointment of a competent Service Provider approved by the Representative/Agent, provision of a Service Provider Workshop Plan and a suitable venue, conducting of awareness workshops by means of traditional and/or modern multi-media techniques, including follow-up courses, making available all tuition material and performing assessment procedures."]
["SH 04.03",null,".03","Posters, Booklets, Videos, etc.",null,"sum",1,null,0]
[{"$nulls":3},"Provision, displaying, maintaining and replacing when necessary of four plastic laminated posters, booklets and educational videos, etc. for the duration of the construction period."]
["SH 05",null,".04","Access to Condoms",null,"sum",1,null,0]
[{"$nulls":3},"Provision and maintenance of condom dispensers fixed in position, including male and female condoms, replenishing male and female condoms on a daily basis as required for the duration of the construction period."]
["SH 08",null,".05","Monitoring",null,"sum",1,null,0]
[{"$nulls":3},"Monitoring HIV/AIDS awareness of workers, providing the Representative/Agent with access to information including making available all reports, thoroughly completed and reflecting the correct information, for the duration of the construction period and close out."]
["TOTAL PRELIMINARY AND GENERAL",{"$f":"\"TOTAL \"&$A$3&\" CARRIED TO SUMMARY:  GENERAL MAINTENANCE WORK\"","v":"TOTAL SCHEDULE 1.1: CARRIED TO SUMMARY:  GENERAL MAINTENANCE WORK"},{"$nulls":6},{"$f":"SUM(I7:I32)","v":{"v":20000,"d":"20,000.00"}}]
["SCHEDULE 1.2",null,{"$f":"[3]Defaults!B9","v":"STRUCTURAL AND BUILDING"}]
[null,null,"BA : ROOFS"]
[null,null,"CLADDING AND SHEETING"]
["BA.01","1.2.1","Supply and install cladding and sheeting:"]
[null,null,".01","0,6 mm Corrugated Chromakek Roof Sheeting (Colour to match existing buildings) @17'' on insulation on 76x50mm SA Pine purlins (Chromadek or similar approved)"]
[{"$nulls":3},".01","Roof covering with pitches exceeding 15°, fixed to timber or steel purlins.","m2",465,null,{"$f":"G40*H40","v":0}]
[null,null,".02","Roof insulation"]
["BA.07",null,null,".01","Roof insulation with Class 1 fire rating. Eviro-foil 201FR, Sisolation HF2 or similar approved","m2",450,null,{"$f":"G42*H42","v":0}]
["BA.06","1.2.2","Supply and install sundry items, etc.:"]
[null,null,".01","0,6 mm Chromadek metal ridge cap or with ridge closer to manufacturer spec."]
[{"$nulls":3},".01","Ridge flashing","m",40,null,{"$f":"G45*H45","v":0}]
[{"$nulls":3},".02","Side wall flashing","m",25,null,{"$f":"G46*H46","v":0}]
[{"$nulls":3},".03","Gable flashing","m",25,null,{"$f":"G47*H47","v":0}]
["BA.08","1.2.3","Supply and install rainwater goods:"]
[null,null,".01","0,6 mm Thick seamless aluminium gutter and downpipe(complete):"]
[{"$nulls":3},".01","100 x 150 mm (6\") self-supporting box gutter ","m",65,null,{"$f":"G50*H50","v":0}]
[{"$nulls":3},".02","100 mm Down pipe (including sundries)","m",30,null,{"$f":"G51*H51","v":0}]
[null,null,"BB:  CARPENTRY"]
[null,null,"Supply and install listed items in accordance with relevant standard. Rates include full installation and sundry items."]
["BB.02","1.2.4","Ceilings: "]
[null,null,".01","Gypsum board with metal H-profile jointing strips: "]
[{"$nulls":3},".01","6.4 mm ceilings ","m2",375,null,{"$f":"G56*H56","v":0}]
[null,null,".02","Gypsum cornices: "]
[{"$nulls":3},".01","76 mm gypsum coved cornices ","m",350,null,{"$f":"G58*H58","v":0}]
[]
["SANS",null,"EARTHWORKS (SMALL WORKS)"]
["1200 DA"]
[8.3,"1.2.5","SCHEDULED ITEMS"]
["8.3.1",null,".01","Remove topsoil to nominal depth of 150mm , stockpile and maintain",null,"m2",652.5,null,{"$f":"G63*H63","v":0}]
["8.3.2",null,".02","Excavate for restricted foundation, footings and trenches in all materials and use for backfill or embankment or dispose.",null,"m3",565.5,null,{"$f":"G64*H64","v":0}]
["8.3.4",null,".03","Importing, placing and compacting approved G4 material in layers of 150mm from commercial sources or from borrow pits to 95% MOD AASTHO.",null,"m3",507.5,null,{"$f":"G65*H65","v":0}]
[null,null,".04","Excavate for restricted trenches in compacted G4 material for raft foundation rib beams. Use for backfill or embankment or dispose.",null,"m3",50.75,null,{"$f":"G66*H66","v":0}]
[null,null,".05","Extra over item 8.3.2 above for:"]
[null,null,".06",".01","Intermediate excavation  ","m³",145,null,{"$f":"G68*H68","v":0}]
[null,null,".07","Soil and Termite poisoning underneath building work as per SANS 10400 (Include certificates)",null,"m2",652.5,null,{"$f":"G69*H69","v":0}]
[]
["SANS",null,"CONCRETE (STRUCTURAL)"]
["1200 G",null,"FORMWORK"]
[8.2,"1.2.6","Formwork to side of concrete surfaces"]
["8,2,1",null,".01","Rough vertical formwork to side of concrete foundations",null,"m2",34,null,{"$f":"G74*H74","v":0}]
[null,null,".02","Smooth formwork to side of concrete channels",null,"m2",10,null,{"$f":"G75*H75","v":0}]
[]
[8.4,null,"SCHEDULED CONCRETE ITEMS"]
["8.4.3","1.2.7","Strength concrete:"]
[null,null,".01","Class 20Mpa/19mm concrete in aprons / Stormwater Channel D55mm including rough formwork as in 8.2.1",null,"m3",5,null,{"$f":"G79*H79","v":0}]
[null,null,".02","Class 25Mpa/19mm concrete in floors and rib beams",null,"m3",75,null,{"$f":"G80*H80","v":0}]
[null,null,".03","Class 25Mpa/19mm concrete in strip footings, including minor rough formwork for beam sides.",null,"m3",10,null,{"$f":"G81*H81","v":0}]
["SANS",null,"SCHEDULED REINFORCEMENT ITEMS"]
["1200 H","1.2.8","High-tensile steel welded mesh and steel bars:"]
[null,null,".01","Ref No 617 mesh in concrete floor",null,"m2",350,null,{"$f":"G84*H84","v":0}]
[null,null,".02","Ref No 311 mesh in concrete floor",null,"m2",350,null,{"$f":"G85*H85","v":0}]
[null,null,".03","Ref No 200 mesh in concrete floor",null,"m2",80,null,0]
[null,null,".04","Y12 high tensile steel bars ",null,"kg",650,null,{"$f":"G87*H87","v":0}]
[null,null,".05","R8 high tensile steel bars ",null,"kg",900,null,{"$f":"G88*H88","v":0}]
[null,null,"BUILDING WORK  "]
[null,null,"Supply and install listed items in accordance with relevant standard. Rates include full installation and sundry items."]
["BD.01","1.2.9","Doors and windows:"]
[null,null,".01","Steel door frames:"]
[{"$nulls":3},".01","1,6 mm thick pressed steel door frame for door size 813 mm x 2 032 mm high suitable for 230 mm wall","number",1,null,{"$f":"G93*H93","v":0}]
[{"$nulls":3},".02","1,6 mm thick pressed steel door frame for door size 813 mm x 2 032 mm high suitable for 110 mm wall","number",17,null,{"$f":"G94*H94","v":0}]
[{"$nulls":3},".03","1,6 mm thick pressed steel door frame for double door size 1636 mm x 2 032 mm high suitable for 230 mm wall. D11","number",2,null,0]
[null,null,"Strongroom doors etc. suitable for 230mm walls fixed to brickwork or concrete"]
[{"$nulls":3},".01","Single ended strongroom ventilator","number",2]
[{"$nulls":3},".02","Record room door with 6mm thick door plate, door inclusive of front frame 1935 x 872mm and back frame 1905 x 825mm - D03","number",1]
[null,null,".02","Galvanized Security Screen and Gates :"]
[{"$nulls":3},".01","Double gate and security screen 3639mm x 2308mm high overall, the frame of 45 x 45 x 3mm hollow section bolted to wall with including minimum Ten 70mm M80 expansion bolts and the gates 813mm x 2032mm high of 40 x 60 x 2mm hollow section frame with 40 x 6mm flat section horizontal rails filled in with 20mm diameter vertical rails at 110mm centres fitted with one and half pairs of suitable pin hinges welded to hollow section frame, complete with and including 150mm barrelbolt and padlock.Refer to DWG 2426-G03. Remeasure on site","number",1,null,0]
[{"$nulls":3},".02","Double gate and security screen 2235mm x 2308mm high overall, the frame of 45 x 45 x 3mm hollow section bolted to wall with including minimum Ten 70mm M80 expansion bolts and the gates 813mm x 2032mm high of 40 x 60 x 2mm hollow section frame with 40 x 6mm flat section horizontal rails filled in with 20mm diameter vertical rails at 110mm centres fitted with one and half pairs of suitable pin hinges welded to hollow section frame, complete with and including 150mm barrelbolt and padlock.Refer to DWG 2426-G03. Remeasure on site.","number",1,null,{"$f":"G101*H101","v":0}]
[{"$nulls":3},".03","Coated Expanding Security Gate; standard size door gates (813 mm wide x 2032mm) with tamper proof lock. Maxidor/Xpanda or similar approved","number",2,null,{"$f":"G102*H102","v":0}]
[null,null,".03","Steel window frames",{"$nulls":4},0]
[{"$nulls":3},".01","D2F - opening outwards,window size 1022mm wide x 1245mm, Galvanised, Including standard brass fittings and 4mm clear float glass","number",21,null,0]
[{"$nulls":3},".02","C2F - opening outwards,window size 1022mm wide x 945mm, Galvanised, Including standard brass fittings and 4mm clear float glassobscured glass","number",4,null,0]
[{"$nulls":3},".03","E1 - opening outwards,window size 533mm wide x 654mm, Galvanised, Including standard brass fittings and 4mm clear float glassobscured glass","number",4,null,0]
[{"$nulls":3},".04","E2 - opening outwards,window size 1022mm wide x 654mm, Galvanised, Including standard brass fittings and 4mm clear float glassobscured glass","number",4,null,0]
["BD.03","1.2.10","Joinery:"]
[null,null,".01","Items measured by number:"]
[{"$nulls":3},".01"," Type A - Standard Steel doors 1524 x 2134mm Opening Outwards (D01)","number",2,null,0]
[{"$nulls":3},".02"," Type B - 2032 x 813 x 44mm Solid core hardwood panel door with commercial veneer finish (D06,10,20)","number",5,null,0]
[{"$nulls":3},".03","Type C - 2032 x 813 x 44mm Semi-solid core hardwood panel door with commercial veneer finish (D09,12,13,19)","number",8,null,0]
[{"$nulls":3},".04","Type D - Record Room door with door plate 6mm thick; Door inclusive of front frame 1935 x 872 and Back frame 1905 x 825 (D03)","number",1,null,0]
[{"$nulls":3},".05","Type E - 2032 x 813 x 44mm Hollow core hardwood panel door with commercial veneer finish (D14,17)","number",4,null,0]
["BD.04","1.2.11","Ironmongery, steelwork, glass, wall finishings, etc:"]
[null,null,".01","Items measured by number:"]
[{"$nulls":3},".01","Solid Art 390/13 4 Lever Mortice Lockset and satin chrome plated handles (External Doors) with 1 pair of brass cabin hooks","number",2,null,0]
[{"$nulls":3},".02","Solid Art 390/13 4 Lever Mortice Lockset and satin chrome plated handles (Internal Doors)","number",17,null,0]
[{"$nulls":3},".03","38mm Diameter Door stop plugged and screwed to floor with 50mm long brass screw","number",17,null,0]
[{"$nulls":3},".04","Stainless steel mirror, 300mm x 400mm Manufactured from 18/10 1mm flat stainless steel with high polish finish and with 4 drillings for no.8 mirror screw; Franke item no CRH 401 or similar","number",7,null,{"$f":"G120*H120","v":0}]
[{"$nulls":3},".05","Soap dispenser, surface mounted, manufactured from 18/10 1.2mm stainless steel, satin finish with cylinder lock, Franke item no STRX 618 or similar","number",6,null,{"$f":"G121*H121","v":0}]
[{"$nulls":3},".06","Toilet Roll holder, Surface mounted, manufactured from 18/10 stainless steel, satin finish with cylinder lock, Franke item  STRX 671 or similar","number",5,null,0]
[{"$nulls":3},".07","Paper towel dispenser, Surface mounted, manufactured from 18/10 1.2mm Stainless steel, satin finish with cylinder lock; Franke item no STRX 600 or similar","number",6,null,0]
[{"$nulls":3},".08","150mm Natural Anodized Aluminium male sign type B2313 or similar approved","number",1,null,0]
[{"$nulls":3},".09","150mm Natural Anodized Aluminium female sign type B2314 or similar approved","number",1,null,0]
[{"$nulls":3},".10","200mm x 200mm Terracota Airbrick or similar approved","number",20,null,{"$f":"G126*H126","v":0}]
[null,null,".02","Items measured by linear meter:"]
[{"$nulls":3},".01","2x110mm wide pre cast lintel","m",75,null,0]
[{"$nulls":3},".02","External window cills - Roller course face brick set at an angle of 15 degrees; 375 micron embossed DPC below cill","m",33,null,0]
[{"$nulls":3},".03","Internal window cills - Everite Nutec fibre cement (Product no 031-509) complete with fixing lugs and selg tapping screws","m",33,null,0]
[{"$nulls":3},".04","External cement plaster in beam filling","m",75,null,0]
["BD03",null,null,".05","Brickwork Reinforcement - 75mm (galvanized)","m",650,null,{"$f":"G132*H132","v":0}]
[{"$nulls":3},".06","Brickwork Reinforcement - 150mm (galvanized)","m",1100,null,{"$f":"G133*H133","v":0}]
[{"$nulls":3},".07","110 x 70mm Precast concrete lintels, not exceeding 3 meters length, to be placed on top of record room for the entire length of the room","m",34,null,{"$f":"G134*H134","v":0}]
[{"$nulls":3},".08","110 x 70mm Lintels in lengths not exceeding 3m","m",45]
[null,null,".03","Items measured by area:",{"$nulls":4},0]
[{"$nulls":3},".01","6mm thick white glazed wall tiles to existing painted or plastered walls as approved by the Engineer","m2",2,null,0]
[{"$nulls":3},".04","230 mm thick Stock brick walls - NFP type brick","m2",{"$f":"80+G140","v":405},null,0]
[{"$nulls":3},".06","110 mm thick Slock brick walls - NFP type brick","m2",{"$f":"560-G140","v":235},null,0]
[{"$nulls":3},".07","Extra over 230mm thick walls for face brick walls; Corobrik FBA walls (\"Roan Satin\") in stretcher bond with ruled joints and perpends","m2",325,null,0]
[{"$nulls":3},".08","Internal cement plaster to walls","m2",900,null,0]
[null,null,"BE:  FLOORS"]
["BE.01","1.2.12","Floor screeds:"]
[null,null,".01","30 mm thick screed  ",null,"m2",325,null,0]
[null,null,".02","30 mm thick screed  on top of lintels in record room",null,"m2",8]
["BE.02","1.2.13","Joinery:"]
[null,null,".01","Items measured by linear meter:"]
[{"$nulls":3},".01","19 mm x 76 mm hardwood skirting with quadrant bead","m",0,null,0]
["BE.03","1.2.14","Floor tiling and finishes, etc:"]
[null,null,".01","Items measured by area:"]
[{"$nulls":3},".01","250 micron damp proofing under solid floors","m2",325,null,0]
[{"$nulls":3},".02","300 x 300mm non slip ceramic tiles fixed with adhesive to screeds and flush pointed with tinted waterproof jointing compound (screeds elsewhere measured). Provide the nett prime cost of R150/m2 for the supply of tiles.","m2",325,null,0]
[{"$nulls":3},".03","150 mm high ceramic tile skirting fixed with adhesive to screeds/plaster to mach floor tiles.","m",330,null,{"$f":"G153*H153","v":0}]
[null,null,"BH: FITTINGS"]
["BH.02","1.2.15","Steelwork and joinery:"]
[null,null,"Items listed include installation cost and sundry items required for the installation (bolts, silicone, etc)"]
[null,null,".01","Items measured by number:"]
[{"$nulls":3},".01","Cupboard and ironmongery 0.8mm thick steel baked enamel with 32mm Formica tops"]
[{"$nulls":4},".01  Base single bowl sink and unit size 1500 mm x 533 mm x 865 mm high with three doors, and one shelf inclusive of all fittings and handles","number",1,null,{"$f":"G159*H159","v":0}]
[{"$nulls":3},".02","3m x 0,6m x 0,902m high Laminated pressed wood kitchen cupboard. Comprising of shelves, bottoms, sides, devisions, backs, doors etc.","number",1,null,{"$f":"G160*H160","v":0}]
[{"$nulls":3},".03","1m x 0,332m x 0,540m high Laminated pressed wood kitchen wall cupboard. Comprising of shelves, bottoms, sides, devisions, backs, doors etc.","number",2,null,{"$f":"G161*H161","v":0}]
[{"$nulls":3},0.4,"2,0 m x 0,865m high Laminated folding stacking doors. Installation to include lock, guide rails and sundries complete.","number",1,null,{"$f":"G162*H162","v":0}]
["BH.01",null,".02","Items measured by linear meter:"]
[{"$nulls":3},".01","32 mm chipboard with \"Formica\" laminated finish on one side and profiled edges where so described:"]
[{"$nulls":4},".01  Work top 600 mm wide with profiled front edge and fitted on top of kitchen cupboard floor unit. Installation to include fastners, supports, brackets etc","m",10,null,{"$f":"G165*H165","v":0}]
[{"$nulls":4},".02  Work top 750 mm wide with profiled front edge and fitted on top desk level column supports . Installation to include fastners, supports, brackets etc","m",20,null,{"$f":"G166*H166","v":0}]
[{"$nulls":3},".02","32 mm hardwood meranti shelves and profiled edges where so described:"]
[{"$nulls":4},".01 Work top 500mm wide with profiled front edge and fitted on top of cupboard including supports, brackets fastners etc.","m",15,null,{"$f":"G168*H168","v":0}]
[{"$nulls":3},".03","25 mm hardwood meranti shelves and profiled edges where so described:"]
[{"$nulls":4},".01 Fixed shelving 350mm wide with profiled front edge. Installation to include brackets, supports (spaced at 600mm intervals), fastners etc.","m",50,null,{"$f":"G170*H170","v":0}]
[null,null,"BJ: PAINT WORK"]
[null,null,"NEW UNPAINTED SURFACES"]
["BJ.02","1.2.16","Paint to various surfaces:"]
[null,null,".01","Plaster surfaces:"]
[{"$nulls":3},".01","Prepare and apply one coat professional plaster primer and two coats acrylic PVA paint suitable for washing with a mild detergent and with a mat finish. Provide 1 coat alcaline resistant 100% pure acrylic fillercoat. Spread rate 6m square per liter. "]
[{"$nulls":4},".01  Walls","m2",900,null,{"$f":"G176*H176","v":0}]
[null,null,".02","Fibre cement surfaces:"]
[{"$nulls":3},".01","Exterior quality pure acrylic emulsion paint with Teflon:"]
[{"$nulls":4},".01  Ceilings and cornices","m2",375,null,{"$f":"G179*H179","v":0}]
[null,null,".03","Steel surfaces:"]
[{"$nulls":3},".01","Prepare surfaces, apply spot primer, one undercoat and two coats non-drip polyurethane, semi gloss, enamel paint:"]
[{"$nulls":4},".01 Window burglar proofing or mentis expanded metal grid to steel frame in burglar proofing","m2",32,null,{"$f":"G182*H182","v":0}]
[{"$nulls":4},".02  Door frames (including Primer)","m2",15,null,{"$f":"G183*H183","v":0}]
[{"$nulls":4},".03 Security gates (including Primer)","m2",13,null,{"$f":"G184*H184","v":0}]
["BJ.02",null,".04",".01",".04 Rails, Posts, Pipes, steel structures etc. exceeding 50 mm dia not exceeding 110 mm diameter","m",30,null,{"$f":"G185*H185","v":0}]
[{"$nulls":3},".02","Roof Sheeting (If Required)","m2",50,null,{"$f":"G186*H186","v":0}]
[null,null,".05","Wood surfaces:"]
[{"$nulls":3},".01","Protective and decorative solvent based polyurethane alkyd semi-gloss non-drip enamel paint: (Inside)"]
[{"$nulls":4},".01  Doors","m2",60,null,{"$f":"G189*H189","v":0}]
[{"$nulls":4},".02  Skirtings and quadrant beads not exceeding 150 mm girth","m",0,null,{"$f":"G190*H190","v":0}]
[{"$nulls":3},".02","Water resistant polyurethane clear matt varnish: (Outside)"]
[{"$nulls":4},".01  Doors","m2",40,null,{"$f":"G192*H192","v":0}]
[{"$nulls":4},".02  Skirtings and quadrant beads not exceeding 150 mm girth","m",0,null,{"$f":"G193*H193","v":0}]
[null,null,"BB:  CARPENTRY FOR ROOFS"]
["BB.01","1.2.17","Supply and install new items measured by length:"]
[null,null,".01","225 x 10 mm Thick Nutec pressed fibre cement fascia or similar approved (including painting, etc)",null,"m",23,null,{"$f":"G196*H196","v":0}]
[null,null,".02","275 x 80 mm Thick Nutec fibre cement barge board, or similar approved (including painting, etc).",null,"m",35,null,{"$f":"G197*H197","v":0}]
[null,null,".03","75 x 50 mm SAP purlins",null,"m",400,null,{"$f":"G198*H198","v":0}]
[null,null,".04","Design, supply and install Wrought sloping SAP trusses for administration building complete (including installation engineers certificate) according to drawing 2426 - G02",null,"Sum",1,null,{"$f":"G199*H199","v":0}]
["BB.08","1.2.18","Painting of existing members in overhangs:"]
[null,null,".01","Members with creosote (2 coats) ",null,"m",50,null,{"$f":"G201*H201","v":0}]
["TOTAL STRUCTURAL AND BUILDING",{"$nulls":7},{"$f":"SUM(I40:I201)","v":0}]
["SCHEDULE 1.3:",null,"PLUMBING, DRAINAGE, SEWER AND WATER "]
["PAA.05","1.3.1","Supply and installation of sanitary ware and brassware:"]
[null,null,".01","Water closets:"]
[{"$nulls":3},".01","360mm x 405mm high Vitreous china WC washdown pan with enlarged pedestal.","number",5,null,{"$f":"G206*H206","v":0}]
[{"$nulls":3},".02","Vitreous china WC cistern - white 9 liters complete with lid and fitments.","number",5,null,{"$f":"G207*H207","v":0}]
[{"$nulls":3},".03","100 mm ø PVC pan connector","number",5,null,0]
[{"$nulls":3},".04","15 mm ø CP ball-o-stop valve with CP flexi tail pipe to WC cistern.","number",5,null,0]
[{"$nulls":3},".05","Heavy duty white buckalite type toilet seat and cover with CP hinge and spindle.","number",5,null,0]
[{"$nulls":3},".06","Complete water closet for disable people","number",1,null,0]
[null,null,".02","Wash hand basins:"]
[{"$nulls":3},".01","Vitreous china 520 x 415mm rounded wall mounted  wash hand basin - white.","number",7,null,0]
[{"$nulls":3},".02","Flexi rubber P-trap","number",7,null,0]
[{"$nulls":3},".03","15 mm ø CP pillar taps SABS 226 Type 1 (BS 5412), JASWIC Listed.","number",7,null,0]
[{"$nulls":3},".04","15 mm ø flexi pipe tailpipe connections  to pillar taps including 15mm CP ball-o-stop valve.","number",7,null,0]
[{"$nulls":3},".05","Complete wash hand basin for disable people, including soap dispenser and all fittings","number",1,null,0]
[null,null,".03","Urinal"]
[{"$nulls":3},".01","Vitreous chine wall hung urinal with top inlet including fittings.","number",2,null,0]
[{"$nulls":3},".02","3/4\" 'Flushmaster Junior' Urinal Flush valve, CP, exposed type with integral ball-o-stop valve and wall plate.","number",2,null,0]
[{"$nulls":3},".03","Bottle trap with 75mm deep re-seal and adjustable telescopic pipe.","number",2,null,0]
["PAA.06","1.3.2","Installation of above ground sanitary drainage piping system:"]
[null,null,".01","uPVC soil and waste pipes:"]
[{"$nulls":3},".01","50 mm ø pipe fixed to walls and soffits","m",{"$f":"20+5","v":25},null,0]
[{"$nulls":3},".02","110mm ø soil pipe fixed to walls and soffits","m",25,null,0]
[null,null,".02","uPVC soil and waste pipe fittings:"]
[{"$nulls":3},".01","50 mm dia plain bend 87.5º ","number",12,null,0]
[{"$nulls":3},".02","50 mm dia access bend 87.5º ","number",11,null,0]
[{"$nulls":3},".03","50 mm dia plain bend 135º","number",3,null,0]
[{"$nulls":3},".04","50 mm dia access bend 135º","number",3,null,0]
[{"$nulls":3},".05","110 mm dia access bend 95º","number",5,null,0]
[{"$nulls":3},".06","110 mm vent horn bend access heel 95º","number",3,null,0]
[{"$nulls":3},".07","110 mm junction single access heel 95º","number",3,null,0]
["PAA.06","1.3.3","Supply and installation of underground sanitary drainage pipes:"]
[null,null,".01","Pipe trench excavations, bedding and backfilling:"]
[{"$nulls":3},".01","Excavate in all materials for pipe trenches to depth of 1100 mm x 600 mm wide.","m³",50,null,0]
[{"$nulls":3},".02","Supply and installation of pipe bedding 400mm thick river sand.","m³",20,null,0]
[{"$nulls":3},".03","Backfilling and compacting to 93% modified AASTHO density with selected material.","m³",40,null,0]
[null,null,".02","PVC-U Solid wall sewer pipes Class 34 - 300 KPA to SABS 791 specifications."]
[{"$nulls":3},".01","160 mm dia","m",45,null,{"$f":"G240*H240","v":0}]
[null,null,".03","uPVC soil and waste pipe fittings "]
[{"$nulls":3},".01","160 mm ø plain bend 135°","number",4,null,{"$f":"G242*H242","v":0}]
[{"$nulls":3},".02","160 mm ø square double junction","number",2,null,0]
[{"$nulls":3},".03","160 mm ø 135° junction ","number",3,null,0]
[null,null,".04","Cleaning eyes:"]
[{"$nulls":3},".01","100 mm ø inline cleaning eye, constructed complete with Square inspection eye cast iron cover and frame Type 14A (SANS 558) daylight opening size 295 x 295mm and 500 x 500 x 75mm thick concrete encasement.","number",5,null,0]
[null,null,".05","Grease Trap:"]
[{"$nulls":3},".02","Installation of Grease Trap, with allowable flow rate of 1.5l/sec. Must be easy to clean and maintain. Installation in accordance with SANS 1321","number",1,null,{"$f":"G248*H248","v":0}]
["PAA.07","1.3.4","Supply and installation of domestic water piping installation:"]
[null,null,".01","Copper piping Class 0 SABS 460 with capillary soldered type joints for cold-water piping installed in voids inclusive of bracketing:"]
[{"$nulls":3},".01","22 mm ø including fittings ","m",40,null,0]
[{"$nulls":3},".02","15 mm ø including fittings ","m",20,null,0]
[null,null,".02","Copper piping Class 0 SABS 460 with capillary soldered type joints for hot-water piping installed in voids including bracketing, lagging and cladding:"]
[{"$nulls":3},".01","22 mm ø including fittings ","m",20,null,0]
[{"$nulls":3},".02","15 mm ø including fittings ","m",15,null,0]
[null,null,".03","Copper piping Class 0 SABS 460 with capillary soldered type joints for hot and cold-water piping chased in walls including wrapping of pipes with builders paper, chasing and reinstatement of chased surfaces:"]
[{"$nulls":3},".01","15 mm ø including fittings ","m",25,null,0]
[null,null,".04","Supply and installation of Class 6 pressure HDPE piping, including fittings, jointing and testing:"]
[{"$nulls":3},".01","20 mm ø HDPE pipe, including fittings","m",30,null,0]
[null,null,".05","Replace 20 mm ø shut-off ball-o-stop valve",null,"number",1,null,0]
[null,null,".06","Supply, installation and commisioning of 10 000 l water tank on a 6m high steel stand complete, including suitable booster pump and sundries.",null,"Prov Sum",{"v":100000,"d":"100,000.00"},null,{"v":100000,"d":"100,000.00"}]
[null,null,".07","Attendance and profit",null,"%",{"$f":"I261","v":{"v":100000,"d":"100,000.00"}},null,{"$f":"G262*H262","v":0}]
["PAA.13","1.3.5","Supply and Installation of  Wall Mounted Hydroboil in kitchen, above sink:"]
[null,null,".01","10 liter electric Hyfroboil",null,"number",1,null,0]
[null,"1.3.6","Manhole covers and grid inlets:"]
["CF.01.04.02",null,".01","Manholes and inspection chambers"]
[{"$nulls":3},".01","New pre-cast concrete manhole up to 1.2m deep, including pre-cast cover and frame","number",2,null,0]
[{"$nulls":3},".02","New pre-cast concrete manhole from 1.2m up to 2.4m deep, including pre-cast cover and frame","number",1,null,0]
[]
[null,null,"BULK WATER AND EXTERNAL WATER RETICULATION"]
["1200 DB",null,"EXCAVATIONS"]
["8.3.2(a)","1.3.9","Excavate in all materials for trenches, backfill, compact, and dispose of surplus/ unsuitable material, for the following pipe diameters for total trench depths:"]
[null,null,".01","Not exceeding 1m deep x 600mm wide",null,"m",60,null,{"$f":"G273*H273","v":0}]
["8.3.2(b)",null,".02","Extra-over item .01 above for:",{"$nulls":4},0]
[{"$nulls":3},".01","Intermediate Excavation","m3",10,null,0]
["1200 LB ","1.3.10","Provision of bedding from trench excavations"]
["8.2.1"]
[null,null,".01","300mm x 600mm bedding",null,"m3",15,null,0]
[null,null,"PIPES AND FITTINGS"]
["1200 L","1.3.11","Connection to existing water network"]
["2.6.1",null,".01","Supply all labour and material to connect to main supply pipeline including excavation backfill, disposal of surplus material, cutting of pipes and moving of fittings and making good",null,"Sum",1,null,0]
["1200 L     8.2.1","1.3.12","Supply, lay and bed pipes complete with couplings, including testing"]
[null,null,".01",".01","32 mm dia. HDPE pipe Class 10, jointed with Plasson high compression fittings","m",20,null,0]
["1200 L     8.2.1",null,null,".02","50 mm dia. HDPE pipe Class 10, jointed with Plasson high compression fittings","m",70,null,0]
[null,null,"CONVENTIONAL FIRE FIGHTING EQUIPMENT"]
[null,null,"GENERAL"]
["PJC 02","1.3.13","Labeling of all conventional fire fighting equipment with identifying tags and recording of details in accordance with SANS 10400:"]
["PJC 04",null,".01","Fire Hose Reel",null,"number",1,null,0]
["PJC 06",null,".02","Fire Exstinguisher",null,"number",12,null,0]
["PJC 10","1.3.14","Signage for fire fighting equipment"]
[null,null,".01","Photo luminescent escape and fire fighting equipment signs installed complete with, aluminium frame, mountings, brackets, etc. "]
[{"$nulls":3},".01","190mm x 190mm","number",12,null,0]
[{"$nulls":3},".02","190mm x 384mm","number",5,null,0]
[{"$nulls":3},".03","190mm x 578mm","number",3,null,0]
[null,null,".02","Silk-screened escape and fire fighting equipment signs installed complete with aluminium frame, mountings, brackets, etc."]
[{"$nulls":3},".01","190mm x 190mm","number",12,null,0]
[{"$nulls":3},".02","190mm x 384mm","number",5,null,0]
[{"$nulls":3},".03","190mm x 578mm","number",5,null,0]
[null,null,".03","Silk-screened fire fighting equipment signs installed behind backboards"]
[{"$nulls":3},".01","400mm x 666mm","number",8,null,0]
[null,null,"DETAIL WORK"]
["PJC.04","1.3.15","Supply and installation of fire hydrant equipment:"]
[null,null,".01","Fire hose cabinet large enough to hold four 30m coils of fire hose.",null,"number",1,null,0]
[null,null,".02","30m long, 64mm, percolating fire hose coils complete with quick couplings.",null,"number",1,null,0]
[null,null,".03","Natural anodized Fire Hydrant keys with four sizes in one",null,"number",3,null,0]
["PJC.06","1.3.16","Supply and installation of fire extinguisher equipment:"]
[null,null,".01","9 kg Dry chemical powder (STP) fire extinguisher",null,"number",2,null,0]
[null,null,".02","5kg Carbon dioxide fire extinguisher complete with 520\nx 22mm thick timber backboard plugged to wall and varnished (SafeQuip, Chubb or similar approved)",null,"number",10,null,0]
[null,null,".03","Lockable, metal cabinet for fire extinguisher",null,"number",3,null,0]
["TOTAL PLUMBING, DRAINAGE, SEWER AND WATER ","TOTAL PLUMBING  AND DRAINAGE",{"$nulls":6},{"$f":"SUM(I206:I309)","v":{"v":100000,"d":"100,000.00"}}]
[]
["SUMMARY OF SCHEDULE OF QUANTITIES: MHLWAZINI HIGH SCHOOL - ADMINISTRATION BLOCK",{"$nulls":7},"AMOUNT"]
["SCHEDULE NO 1.1 :",null,null,"PRELIMINARY AND GENERAL",{"$nulls":4},{"$f":"I34","v":{"v":20000,"d":"20,000.00"}}]
["SCHEDULE NO 1.2 :",null,null,"STRUCTURAL AND BUILDING",{"$nulls":4},{"$f":"I202","v":0}]
["SCHEDULE NO 1.3 :",null,null,"PLUMBING, DRAINAGE, SEWER AND BULK WATER",{"$nulls":4},{"$f":"I310","v":{"v":100000,"d":"100,000.00"}}]
["SUB TOTAL C: ADMINISTRATION BLOCK (carry to summary page)",{"$nulls":7},{"$f":"SUM(I313:I315)","v":{"v":120000,"d":"120,000.00"}}]

{"sheet":"2 Classroom A","index":1,"n_rows":196,"n_cols":9,"rows_kept":196,"merged":[[0,2,0,4],[1,0,1,2],[2,0,2,1],[2,2,2,4],[3,2,3,4],[4,2,4,4],[5,3,5,4],[6,2,6,4],[7,2,7,4],[8,2,8,4],[9,3,9,4],[10,2,10,4],[11,3,11,4],[12,3,12,4],[13,2,13,4],[18,2,18,4],[19,2,19,4],[20,2,20,4],[21,2,21,4],[23,3,23,4],[25,3,25,4],[27,3,27,4],[29,3,29,4],[31,3,31,4],[32,0,32,7],[33,0,33,1],[33,2,33,4],[34,2,34,4],[35,2,35,4],[36,2,36,4],[37,3,37,4],[39,3,39,4],[41,2,41,4],[42,3,42,4],[45,2,45,4],[46,3,46,4],[49,2,49,4],[50,2,50,4],[51,3,51,4],[53,3,53,4],[56,2,56,4],[58,2,58,4],[59,3,59,4],[60,3,60,4],[61,3,61,4],[62,3,62,4],[65,3,65,4],[67,2,67,4],[69,2,69,4],[70,2,70,4],[71,3,71,4],[72,3,72,4],[73,3,73,4],[76,2,76,4],[77,3,77,4],[78,3,78,4],[79,3,79,4],[80,3,80,4],[81,3,81,4],[83,3,83,4],[84,3,84,4],[87,3,87,4],[88,3,88,4],[89,2,89,4],[90,2,90,4],[91,2,91,4],[92,3,92,4],[94,3,94,4],[95,3,95,4],[98,2,98,4],[101,2,101,4],[102,3,102,4],[106,3,106,4],[113,3,113,4],[119,2,119,4],[120,2,120,4],[121,3,121,4],[122,2,122,4],[123,3,123,4],[125,2,125,4],[126,3,126,4],[130,2,130,4],[133,2,133,4],[134,2,134,4],[135,2,135,4],[136,3,136,4],[139,3,139,4],[142,3,142,4],[148,3,148,4],[155,2,155,4],[156,2,156,4],[157,3,157,4],[158,3,158,4],[159,3,159,4],[160,3,160,4],[161,2,161,4],[162,3,162,4],[163,0,163,7],[164,0,164,1],[164,2,164,4],[165,2,165,4],[166,2,166,4],[167,3,167,4],[168,2,168,4],[169,3,169,4],[173,3,173,4],[177,3,177,4],[179,2,179,4],[180,2,180,4],[181,3,181,4],[182,3,182,4],[183,3,183,4],[184,0,184,7],[185,0,185,1],[185,2,185,4],[186,2,186,4],[187,2,187,4],[188,0,188,7],[190,0,190,7]]}
["PAYMENT REFERS TO","ITEM NO","DESCRIPTION",null,null,"UNIT","QUANTITY","RATE","AMOUNT"]
["2: STANDARD SINGLE CLASS ROOM A"]
["SCHEDULE NO 2.1 :",null,"PRELIMINARY AND GENERAL"]
["SANS",{"v":2.1,"d":"2"},"GENERAL "]
["1200A","2.1.1","Scheduled fixed - charge and value - related items:"]
[null,null,".01","Fixed prelimiary and general chages ",null,"sum",1,null,{"$f":"G6*H6","v":0}]
[null,"2.1.2","Scheduled time-related items:",null,null,"Month",3,null,{"$f":"G7*H7","v":0}]
[null,null,"TEMPORARY WORKS "]
[null,"2.1.3","Location and protection of existing services:"]
["8.4 c",null,".01","Excavate by hand to expose existing services",null,"m3 ",100,null,{"$f":"G10*H10","v":0}]
[null,"2.1.4","Additional tests "]
[null,null,".01","Additional tests required by Engineer ",null,"Prov sum ",1,null,{"v":5000,"d":"5,000.00"}]
[null,null,".02","Attendance and profit ",null,"% ",{"$f":"I12","v":{"v":5000,"d":"5,000.00"}},null,{"$f":"G13*H13","v":0}]
[null,"2.1.5","Update existing key plants ",null,null,"sum",1,null,{"$f":"G14*H14","v":0}]
[null,"2.1.6","OCCUPATIONAL HEALTH AND SAFETY"]
[null,null,".01","Compliance with OHS Act and"]
[{"$nulls":3},"Construction Regulations 2003",null,"sum",1,null,{"$f":"G17*H17","v":0}]
["SH01","2.1.7","HIV/AIDS AWARENESS"]
[null,null,"It is required of the Contractor to thoroughly study the Additional Specification SH: HIV / AIDS Requirements (PW 1544) of the Department that must be read together with and is deemed to be incorporated under this Section of the Bills of Quantities.  "]
[null,null," Provision for pricing of HIV/AIDS awareness is made under the items hereafter and it is explicitly pointed out that all requirements of the aforementioned specification are deemed to be priced hereunder, as the said items represent the only method of measurement and no additional items or extras to the contract in this regard shall be entertained"]
[null,null,"The Contractor must take note that compliance with the HIV/AIDS Specification is compulsory. In the event of partial or total non-compliance, the Representative/Agent, notwithstanding the provisions of Clause 52 of the General Conditions of Contract for Works of Civil Engineering Construction or any other clause to the contrary, reserves the right to delay issuing any progress payment certificate until the Contractor provides satisfactory proof of compliance. "]
[null,null,"The Contractor shall not be entitled to any compensation of whatsoever nature, including interest, due to such delay of payment  "]
["SH 07",null,".01","Awareness Compain",null,"sum",1,null,{"$f":"G23*H23","v":0}]
[{"$nulls":3},"Selection, appointment, briefing and making available of an Awareness Compain including provision of all relevant services."]
["SH 04.01",null,".02","Awareness Workshops",null,"sum",1,null,{"$f":"G25*H25","v":0}]
[{"$nulls":3},"Selection and appointment of a competent Service Provider approved by the Representative/Agent, provision of a Service Provider Workshop Plan and a suitable venue, conducting of awareness workshops by means of traditional and/or modern multi-media techniques, including follow-up courses, making available all tuition material and performing assessment procedures."]
[null,null,".03","Posters, Booklets, Videos, etc.",null,"sum",1,null,{"$f":"G27*H27","v":0}]
[{"$nulls":3},"Provision, displaying, maintaining and replacing when necessary of four plastic laminated posters, booklets and educational videos, etc. for the duration of the construction period."]
["SH 05",null,".04","Access to Condoms",null,"sum",1,null,{"$f":"G29*H29","v":0}]
[{"$nulls":3},"Provision and maintenance of condom dispensers fixed in position, including male and female condoms, replenishing male and female condoms on a daily basis as required for the duration of the construction period."]
["SH 08",null,".05","Monitoring",null,"sum",1,null,{"$f":"G31*H31","v":0}]
[{"$nulls":3},"Monitoring HIV/AIDS awareness of workers, providing the Representative/Agent with access to information including making available all reports, thoroughly completed and reflecting the correct information, for the duration of the construction period and close out."]
["TOTAL PRELIMINARY AND GENERAL",{"$f":"\"TOTAL \"&$A$3&\" CARRIED TO SUMMARY:  GENERAL MAINTENANCE WORK\"","v":"TOTAL SCHEDULE NO 2.1 : CARRIED TO SUMMARY:  GENERAL MAINTENANCE WORK"},{"$nulls":6},{"$f":"SUM(I5:I32)","v":{"v":5000,"d":"5,000.00"}}]
["SCHEDULE NO 2.2 :",null,"STRUCTURAL AND BUILDING"]
[null,null,"BA : ROOFS"]
[null,null,"CLADDING AND SHEETING"]
["BA.01","2.2.1","Supply and install cladding and sheeting:"]
[null,null,".01","0,6 mm Corrugated Chromakek Roof Sheeting (Colour to match existing buildings) @17'' on insulation on 76x50mm SA Pine purlins (Chromadek or similar approved)"]
[{"$nulls":3},".01","Roof covering with pitches exceeding 15°, fixed to timber or steel purlins.","m2",80,null,{"$f":"G39*H39","v":0}]
[null,null,".02","Roof insulation"]
[{"$nulls":3},".01","Roof insulation with Class 1 fire rating. Eviro-foil 201FR or similar approved","m2",80,null,{"$f":"G41*H41","v":0}]
["BA.06","2.2.2","Supply and install sundry items, etc.:"]
[null,null,".01","0,6 mm Chromadek metal ridge cap or with ridge closer to manufacturer spec."]
[{"$nulls":3},".01","Ridge flashing","m",8,null,{"$f":"G44*H44","v":0}]
[{"$nulls":3},".02","Gable flashing","m",25,null,0]
["BA.08","2.2.3","Supply and install rainwater goods:"]
[null,null,".01","0,6 mm Thick seamless aluminium gutter and downpipe(complete):"]
[{"$nulls":3},".01","100 x 150 mm (6\") self-supporting box gutter ","m",16,null,0]
[{"$nulls":3},".02","100 mm Down pipe (including sundries)","m",12,null,0]
[null,null,"BB:  CARPENTRY"]
["BB.02","2.2.4","Ceilings: "]
[null,null,".01","Gypsum board with metal H-profile jointing strips: "]
[{"$nulls":3},".01","6.4 mm ceilings ","m2",50,null,0]
[null,null,".03","Gypsum cornices: "]
[{"$nulls":3},".01","76 mm gypsum coved cornices ","m",45,null,0]
[]
["SANS",null,"EARTHWORKS (SMALL WORKS)"]
["1200 DA"]
[8.3,"2.2.5","SCHEDULED ITEMS"]
["8.3.1",null,".01","Remove topsoil to nominal depth of 150mm , stockpile and maintain",null,"m2",145,null,{"$f":"G60*H60","v":0}]
["8.3.2",null,".02","Excavate for restricted foundation, footings and trenches in all materials and use for backfill or embankment or dispose.",null,"m3",87,null,0]
["8.3.4",null,".03","Importing, placing and compacting approved G4 material in layers of 150mm from commercial sources or from borrow pits to 95% MOD AASTHO.",null,"m3",72.5,null,0]
[null,null,".04","Excavate for restricted trenches in compacted G4 material for raft foundation rib beams. Use for backfill or embankment or dispose.",null,"m3",14.5,null,0]
[null,null,".05","Extra over item 8.3.2 above for:"]
[null,null,".06",".01","Intermediate excavation  ","m³",36.25,null,0]
[null,null,".07","Soil and Termite poisoning underneath building work as per SANS 10400 (Include certificates)",null,"m2",145,null,0]
[]
["SANS",null,"CONCRETE (STRUCTURAL)"]
["1200 G"]
[8.4,null,"SCHEDULED CONCRETE ITEMS"]
["8.4.3","2.2.6","Strength concrete:"]
[null,null,".01","Class 20Mpa/19mm concrete in aprons / Stormwater Channel D55mm including rough formwork as in 8.2.1",null,"m3",3,null,0]
[null,null,".02","Class 25Mpa/19mm concrete in floors and rib beams",null,"m3",75,null,0]
[null,null,".03","Class 25Mpa/19mm concrete in strip footings, including minor rough formwork for beam sides.",null,"m3",10,null,0]
[]
["SANS",null,"SCHEDULED REINFORCEMENT ITEMS"]
["1200 H","2.2.7","High-tensile steel welded mesh and steel bars:"]
[null,null,".01","Ref No 617 mesh in concrete floor",null,"m2",80,null,{"$f":"G78*H78","v":0}]
[null,null,".02","Ref No 311 mesh in concrete floor",null,"m2",80,null,{"$f":"G79*H79","v":0}]
[null,null,".03","Ref No 200 mesh in concrete floor",null,"m2",20,null,0]
[null,null,".04","Y12 high tensile steel bars ",null,"kg",200,null,{"$f":"G81*H81","v":0}]
[null,null,".05","R8 high tensile steel bars ",null,"kg",300,null,{"$f":"G82*H82","v":0}]
[null,"2.2.8","SCHEDULED FORMWORK ITEMS"]
["8,2,1",null,".01","Rough vertical formwork to side of concrete foundations",null,"m2",10,null,{"$f":"G84*H84","v":0}]
[null,null,".02","Smooth formwork to side of concrete channels",null,"m2",5,null,{"$f":"G85*H85","v":0}]
[null,null,".03","Wooden Floating finishing ",null,"m2",75,null,0]
[null,"2.2.9","SCHEDULED STEEL COLUMN ITEMS"]
[null,null,".01","Supply and installation of 100 ø x 4 mm (3 m high)RHS column. The column to be tied into a laminated beam and concrete floor",null,"No",3,null,{"$f":"G88*H88","v":0}]
[]
[null,null,"BUILDING WORK "]
[null,null,"Supply and install listed items in accordance with relevant standard. Rates include full installation and sundry items."]
["BD.01","2.2.10","Doors and windows : "]
[null,null,".01","Steel door frames:"]
[{"$nulls":3},".01","1,2 mm thick pressed steel door frame for door size 813 mm x 2 032 mm high suitable for 230 mm wall ","number",1,null,0]
[null,null,".02","Security Screen and Gates:"]
[null,null,".03","Steel window frames"]
[{"$nulls":4},"WO5 - Steel small payne window, opening outwards, Type 14-BH + 9-F/LT, window size 889mm wide x 1311mm, Galvanised, Including standard brass fittings and 4mm clear float glass","number",5,null,0]
[{"$nulls":4},"WO6 - Steel small payne window, opening outwards, Type 4-BH, window size 889mm wide x 457mm, Galvanised, Including standard brass fittings and 4mm obscured glass","number",8,null,0]
["BD.03","2.2.11","Joinery:"]
[null,null,".01","Items measured by number:"]
["BD.03",null,null,".01"," Type B - 2032 x 813 x 44mm Solid core hardwood panel door with commercial veneer finish","number",1,null,{"$f":"G101*H101","v":0}]
["BD.04","2.2.12","Ironmongery, steelwork, glass, wall finishings, etc:"]
[null,null,".01","Items measured by number:"]
[{"$nulls":3},".01","Solid Art 390/13 4 Lever Mortice Lockset and satin chrome plated handles (External Doors) with 1 pair of brass cabin hooks","number",1,null,0]
[{"$nulls":3},".02","38mm Diameter Door stop plugged and screwed to floor with 50mm long brass screw","number",1,null,0]
[{"$nulls":3},".03","200mm x 200mm Terracota Airbrick or similar approved","number",4,null,{"$f":"G106*H106","v":0}]
[null,null,".02","Items measured by linear meter:"]
[{"$nulls":3},".01","2x110mm wide pre cast lintel","m",15,null,0]
[{"$nulls":3},".02","External window cills - Roller course face brick set at an angle of 15 degrees; 375 micron embossed DPC below cill","m",9,null,0]
[{"$nulls":3},".03","Internal window cills - Everite Nutec fibre cement (Product no 031-509) complete with fixing lugs and selg tapping screws","m",9,null,{"$f":"G110*H110","v":0}]
[{"$nulls":3},".04","External cement plaster in beam filling","m",35,null,{"$f":"G111*H111","v":0}]
["BD03",null,null,".05","Brickwork Reinforcement - 75mm (galvanized)","m",0,null,{"$f":"G112*H112","v":0}]
[{"$nulls":3},".06","Brickwork Reinforcement - 150mm (galvanized)","m",350,null,{"$f":"G113*H113","v":0}]
[null,null,".03","Items measured by area:"]
[{"$nulls":3},".01","230 mm thick Stock brick walls - NFP type brick","m2",{"$f":"55+10","v":65},null,0]
[{"$nulls":3},".02","Extra over 230mm thick walls for face brick walls; Corobrik FBA walls (\"Roan Satin\") in stretcher bond with ruled joints and perpends","m2",55,null,0]
[{"$nulls":3},".03","230mm thick face brick walls; Corobrik FBA walls (\"Roan Satin\") in stretcher bond with ruled joints and perpends","m2",25,null,{"$f":"G117*H117","v":0}]
[{"$nulls":3},".04","Internal cement plaster to walls","m2",55,null,{"$f":"G118*H118","v":0}]
[{"$nulls":3},".05","Supply and Installation of 250x50 laminated beam. Beam to be measured on site. Beam to be manufactured in accordance SANS 10400 and 1460","m",8,null,{"$f":"G119*H119","v":0}]
[null,null,"BE:  FLOORS"]
["BE.01","2.2.13","Floor screeds:"]
[null,null,".01","30 mm thick screed with smooth finish",null,"m2",75,null,0]
["BE.02","2.2.14","Joinery:"]
[null,null,".01","Items measured by linear meter:"]
[{"$nulls":3},".01","19 mm x 76 mm hardwood skirting with quadrant bead","m",35,null,0]
["BE.03","2.2.15","Floor tiling and finishes, etc:"]
[null,null,".01","Items measured by area:"]
[{"$nulls":3},".01","250 micron damp proofing under solid floors","m2",75,null,0]
[{"$nulls":3},".02","Vinyl Floor Tiling or similar approved ","m2",60,null,0]
[{"$nulls":4},"FloorworX Superflex fully flexible vinyl floor sheeting 1,2m wide x 2mm thick in similar colour finish, manufactured in accordance with SANS 786:2000, laid in FloorworX No. 60 Plus acrylic adhesive spread with a notched trowel on suitably prepared subfloor (elsewhere specified) with a hygrometer reading showing a moisture content of less than 70%, with joints welded with a fully flexible coloured 'Marley Welding Rod' to provide a smooth, hygienic sealed finish and rolled with 68kg three section metal roller on completion. Upon completion, floor to be sealed with three coats of FloorX Silk Matt."]
[null,"2.2.16","BH: FITTINGS"]
[{"$nulls":3},".01","Chalk Board (4,7 m x 1,2 m) with ledge, or similar approved","number",1,null,{"$f":"G132*H132","v":0}]
[{"$nulls":3},".02","Pin Board (4,7 m x 0,9 m) with cork inner, velt cover and timber border, or similar approved ","number",1,null,{"$f":"G133*H133","v":0}]
[null,null,"BJ: PAINT WORK"]
[null,null,"NEW UNPAINTED SURFACES"]
["BJ.02","2.2.17","Paint to various surfaces:"]
[null,null,".01","Plaster surfaces:"]
[{"$nulls":3},".01","Prepare and apply one coat professional plaster primer and two coats acrylic PVA paint suitable for washing with a mild detergent and with a mat finish. Provide 1 coat alcaline resistant 100% pure acrylic fillercoat. Spread rate 6m square per liter. "]
[{"$nulls":4},".01  Walls","m2",60,null,{"$f":"G139*H139","v":0}]
[null,null,".02","Fibre cement surfaces:"]
[{"$nulls":3},".01","Exterior quality pure acrylic emulsion paint with Teflon:"]
[{"$nulls":4},".01  Ceilings and cornices","m2",85,null,{"$f":"G142*H142","v":0}]
[null,null,".03","Steel surfaces:"]
[{"$nulls":3},".01","Prepare surfaces, apply spot primer, one undercoat and two coats non-drip polyurethane, semi gloss, enamel paint:"]
[{"$nulls":4},".02 Window burglar proofing or mentis expanded metal grid to steel frame in burglar proofing","m2",20,null,{"$f":"G145*H145","v":0}]
[{"$nulls":4},".03  Door frames","m2",1,null,0]
[null,null,".03",".01",".06 Rails, Posts, Pipes, steel structures etc. not exceeding 50 mm diameter","m",5,null,0]
[{"$nulls":4},".08 Steel structures (Roof - If required)","m2",95,null,0]
[null,null,".06","Wood surfaces:",{"$nulls":4},0]
[{"$nulls":3},".01","Protective and decorative solvent based polyurethane alkyd semi-gloss non-drip enamel paint: (Inside)"]
[{"$nulls":4},".01  Doors","m2",2,null,0]
[{"$nulls":4},".02  Skirtings and quadrant beads not exceeding 150 mm girth","m",30,null,0]
[{"$nulls":3},".02","Water resistant polyurethane clear matt varnish: (Outside)"]
[{"$nulls":4},".01  Doors","m2",2,null,0]
[{"$nulls":4},".02  Skirtings and quadrant beads not exceeding 150 mm girth","m",10,null,0]
[null,null,"BB:  CARPENTRY FOR ROOFS",{"$nulls":5},0]
["BB.01","2.2.18","Supply and install new items measured by length:"]
[null,null,".01","225 x 10 mm Thick pressed fibre cement fascia, including painting, etc.",null,"m",20]
[null,null,".02","225 x 10 mm Thick fibre cemet barge board, including painting, etc.",null,"m",25,null,0]
[null,null,".03","75 x 50 mm SAP purlins",null,"m",100,null,0]
[null,null,".04","Design, supply and install Wrought sloping SAP trusses for single classroom complete according to drawing 2426 - G05",null,"Sum",1,null,0]
["BB.08","2.2.19","Painting of existing members in overhangs:"]
[null,null,".01","Members with creosote (2 Coats)",null,"m",10,null,0]
["TOTAL STRUCTURAL AND BUILDING",{"$nulls":7},{"$f":"SUM(I39:I163)","v":0}]
["SCHEDULE NO 2.3 :",null,"CONVENTIONAL FIRE FIGHTING EQUIPMENT"]
[null,null,"GENERAL"]
["PJC 02","2.3.1","Labeling of all conventional fire fighting equipment with identifying tags and recording of details in accordance with SANS 10400:"]
["PJC 06",null,".02","Fire extinguishers",null,"number",3,null,{"$f":"G168*H168","v":0}]
["PJC 10","2.3.2","Signage for fire fighting equipment"]
[null,null,".01","Photo luminescent escape and fire fighting equipment signs installed complete with, aluminium frame, mountings, brackets, etc. "]
[{"$nulls":3},".01","190mm x 190mm","number",2,null,{"$f":"G171*H171","v":0}]
[{"$nulls":3},".02","190mm x 384mm","number",2,null,0]
[{"$nulls":3},".03","190mm x 578mm","number",1,null,0]
[null,null,".02","Silk-screened escape and fire fighting equipment signs installed complete with aluminium frame, mountings, brackets, etc."]
[{"$nulls":3},".01","190mm x 190mm","number",2,null,{"$f":"G175*H175","v":0}]
[{"$nulls":3},".02","190mm x 384mm","number",2,null,0]
[{"$nulls":3},".03","190mm x 578mm","number",1,null,0]
[null,null,".03","Silk-screened fire fighting equipment signs installed behind backboards"]
[{"$nulls":3},".01","400mm x 666mm","number",2,null,{"$f":"G179*H179","v":0}]
[null,null,"DETAIL WORK"]
["PJC.06","2.3.3","Supply and installation of fire extinguisher equipment:"]
[null,null,".01","9 kg Dry chemical powder (STP) fire extinguisher",null,"number",1,null,{"$f":"G182*H182","v":0}]
[null,null,".02","5kg Carbon dioxide fire extinguisher complete with 520\nx 22mm thick timber backboard plugged to wall and varnished (SafeQuip, Chubb or similar approved)",null,"number",2,null,0]
[null,null,".03","Lockable, metal cabinet for fire extinguisher",null,"number",1,null,0]
["TOTAL PLUMBING, DRAINAGE, SEWER AND WATER ",{"$nulls":7},{"$f":"SUM(I167:I184)","v":0}]
["SCHEDULE NO 2.4 :",null,"AUXILIARY WORKS (moving of existing building)"]
[]
[null,"2.4.1","Dismantle, Move and Re-asemble existing 6m x 6m mobile classroom (on site)",null,null,"Sum",1,null,{"$f":"G188*H188","v":0}]
["TOTAL AUXILIARY WORKS","TOTAL PLUMBING  AND DRAINAGE",{"$nulls":6},{"$f":"I188","v":0}]
[]
["SUMMARY OF SCHEDULE OF QUANTITIES: MHLWAZINI HIGH SCHOOL - STANDARD SINGLE CLASSROOM A",{"$nulls":7},"AMOUNT"]
["SCHEDULE NO 2.1 :",null,"PRELIMINARY AND GENERAL",{"$nulls":5},{"$f":"I33","v":{"v":5000,"d":"5,000.00"}}]
["SCHEDULE NO 2.2 :",null,"STRUCTURAL AND BUILDING",{"$nulls":5},{"$f":"I164","v":0}]
["SCHEDULE NO 2.3 :",null,{"$f":"C165","v":"CONVENTIONAL FIRE FIGHTING EQUIPMENT"},{"$nulls":5},{"$f":"I185","v":0}]
["SCHEDULE NO 2.4 :",null,"AUXILIARY WORKS",{"$nulls":5},{"$f":"I189","v":0}]
["SUB TOTAL B: STANDARD SINGLE CLASSROOM A (carry to summary page)",{"$nulls":7},{"$f":"SUM(I192:I195)","v":{"v":5000,"d":"5,000.00"}}]

{"sheet":"3 Classroom B","index":2,"n_rows":194,"n_cols":9,"rows_kept":194,"merged":[[0,2,0,4],[1,0,1,2],[2,0,2,1],[2,2,2,4],[3,2,3,4],[4,2,4,4],[5,3,5,4],[6,2,6,4],[7,2,7,4],[8,2,8,4],[9,3,9,4],[10,2,10,4],[11,3,11,4],[12,3,12,4],[13,2,13,4],[18,2,18,4],[19,2,19,4],[20,2,20,4],[21,2,21,4],[23,3,23,4],[25,3,25,4],[27,3,27,4],[29,3,29,4],[31,3,31,4],[32,0,32,7],[33,0,33,1],[33,2,33,4],[34,2,34,4],[35,2,35,4],[36,2,36,4],[37,3,37,4],[39,3,39,4],[41,2,41,4],[42,3,42,4],[45,2,45,4],[46,3,46,4],[49,2,49,4],[50,2,50,4],[51,3,51,4],[53,3,53,4],[55,2,55,4],[57,2,57,4],[58,3,58,4],[59,3,59,4],[60,3,60,4],[61,3,61,4],[64,3,64,4],[66,2,66,4],[68,2,68,4],[69,2,69,4],[70,3,70,4],[71,3,71,4],[72,3,72,4],[74,2,74,4],[75,3,75,4],[76,3,76,4],[77,3,77,4],[78,3,78,4],[79,3,79,4],[81,3,81,4],[82,3,82,4],[85,3,85,4],[86,3,86,4],[88,2,88,4],[89,2,89,4],[90,3,90,4],[92,3,92,4],[93,3,93,4],[96,2,96,4],[99,2,99,4],[100,3,100,4],[104,3,104,4],[111,3,111,4],[117,2,117,4],[118,2,118,4],[119,3,119,4],[120,2,120,4],[121,3,121,4],[123,2,123,4],[124,3,124,4],[128,2,128,4],[131,2,131,4],[132,2,132,4],[133,2,133,4],[134,3,134,4],[137,3,137,4],[140,3,140,4],[146,3,146,4],[153,2,153,4],[154,2,154,4],[155,3,155,4],[156,3,156,4],[157,3,157,4],[158,3,158,4],[159,2,159,4],[160,3,160,4],[161,0,161,7],[162,0,162,1],[162,2,162,4],[163,2,163,4],[164,2,164,4],[165,3,165,4],[166,2,166,4],[167,3,167,4],[171,3,171,4],[175,3,175,4],[177,2,177,4],[178,2,178,4],[179,3,179,4],[180,3,180,4],[181,3,181,4],[182,0,182,7],[183,0,183,1],[183,2,183,4],[184,2,184,4],[185,2,185,4],[186,0,186,7],[188,0,188,7]]}
["PAYMENT REFERS TO","ITEM NO","DESCRIPTION",null,null,"UNIT","QUANTITY","RATE","AMOUNT"]
["3: STANDARD SINGLE CLASS ROOM B"]
["SCHEDULE NO 3.1 :",null,"PRELIMINARY AND GENERAL"]
["SANS",3.1,"GENERAL "]
["1200A","3.1.1","Scheduled fixed - charge and value - related items:"]
[null,null,".01","Fixed prelimiary and general chages ",null,"sum",1,null,{"$f":"G6*H6","v":0}]
[null,"3.1.2","Scheduled time-related items:",null,null,"Month",3,null,{"$f":"G7*H7","v":0}]
[null,null,"TEMPORARY WORKS "]
[null,"3.1.3","Location and protection of existing services:"]
["8.4 c",null,".01","Excavate by hand to expose existing services",null,"m3 ",100,null,{"$f":"G10*H10","v":0}]
[null,"3.1.4","Additional tests "]
[null,null,".01","Additional tests required by Engineer ",null,"Prov sum ",1,null,{"v":5000,"d":"5,000.00"}]
[null,null,".02","Attendance and profit ",null,"% ",{"$f":"I12","v":{"v":5000,"d":"5,000.00"}},null,{"$f":"G13*H13","v":0}]
[null,"3.1.5","Update existing key plants ",null,null,"sum",1,null,{"$f":"G14*H14","v":0}]
[null,"3.1.6","OCCUPATIONAL HEALTH AND SAFETY"]
[null,null,".01","Compliance with OHS Act and"]
[{"$nulls":3},"Construction Regulations 2003",null,"sum",1,null,{"$f":"G17*H17","v":0}]
["SH01","3.1.7","HIV/AIDS AWARENESS"]
[null,null,"It is required of the Contractor to thoroughly study the Additional Specification SH: HIV / AIDS Requirements (PW 1544) of the Department that must be read together with and is deemed to be incorporated under this Section of the Bills of Quantities.  "]
[null,null," Provision for pricing of HIV/AIDS awareness is made under the items hereafter and it is explicitly pointed out that all requirements of the aforementioned specification are deemed to be priced hereunder, as the said items represent the only method of measurement and no additional items or extras to the contract in this regard shall be entertained"]
[null,null,"The Contractor must take note that compliance with the HIV/AIDS Specification is compulsory. In the event of partial or total non-compliance, the Representative/Agent, notwithstanding the provisions of Clause 52 of the General Conditions of Contract for Works of Civil Engineering Construction or any other clause to the contrary, reserves the right to delay issuing any progress payment certificate until the Contractor provides satisfactory proof of compliance. "]
[null,null,"The Contractor shall not be entitled to any compensation of whatsoever nature, including interest, due to such delay of payment  "]
["SH 07",null,".01","Awareness Compain",null,"sum",1,null,{"$f":"G23*H23","v":0}]
[{"$nulls":3},"Selection, appointment, briefing and making available of an Awareness Compain including provision of all relevant services."]
["SH 04.01",null,".02","Awareness Workshops",null,"sum",1,null,{"$f":"G25*H25","v":0}]
[{"$nulls":3},"Selection and appointment of a competent Service Provider approved by the Representative/Agent, provision of a Service Provider Workshop Plan and a suitable venue, conducting of awareness workshops by means of traditional and/or modern multi-media techniques, including follow-up courses, making available all tuition material and performing assessment procedures."]
[null,null,".03","Posters, Booklets, Videos, etc.",null,"sum",1,null,{"$f":"G27*H27","v":0}]
[{"$nulls":3},"Provision, displaying, maintaining and replacing when necessary of four plastic laminated posters, booklets and educational videos, etc. for the duration of the construction period."]
["SH 05",null,".04","Access to Condoms",null,"sum",1,null,{"$f":"G29*H29","v":0}]
[{"$nulls":3},"Provision and maintenance of condom dispensers fixed in position, including male and female condoms, replenishing male and female condoms on a daily basis as required for the duration of the construction period."]
["SH 08",null,".05","Monitoring",null,"sum",1,null,{"$f":"G31*H31","v":0}]
[{"$nulls":3},"Monitoring HIV/AIDS awareness of workers, providing the Representative/Agent with access to information including making available all reports, thoroughly completed and reflecting the correct information, for the duration of the construction period and close out."]
["TOTAL PRELIMINARY AND GENERAL",{"$f":"\"TOTAL \"&$A$3&\" CARRIED TO SUMMARY:  GENERAL MAINTENANCE WORK\"","v":"TOTAL SCHEDULE NO 3.1 : CARRIED TO SUMMARY:  GENERAL MAINTENANCE WORK"},{"$nulls":6},{"$f":"SUM(I5:I32)","v":{"v":5000,"d":"5,000.00"}}]
["SCHEDULE NO 3.2 :",null,"STRUCTURAL AND BUILDING"]
[null,null,"BA : ROOFS"]
[null,null,"CLADDING AND SHEETING"]
["BA.01","3.2.1","Supply and install cladding and sheeting:"]
[null,null,".01","0,6 mm Corrugated Chromakek Roof Sheeting (Colour to match existing buildings) @17'' on insulation on 76x50mm SA Pine purlins (Chromadek or similar approved)"]
[{"$nulls":3},".01","Roof covering with pitches exceeding 15°, fixed to timber or steel purlins.","m2",80,null,{"$f":"G39*H39","v":0}]
[null,null,".02","Roof insulation"]
[{"$nulls":3},".01","Roof insulation with Class 1 fire rating. Eviro-foil 201FR or similar approved","m2",80,null,{"$f":"G41*H41","v":0}]
["BA.06","3.2.2","Supply and install sundry items, etc.:"]
[null,null,".01","0,6 mm Chromadek metal ridge cap or with ridge closer to manufacturer spec."]
[{"$nulls":3},".01","Ridge flashing","m",8,null,{"$f":"G44*H44","v":0}]
[{"$nulls":3},".02","Gable flashing","m",25,null,0]
["BA.08","3.2.3","Supply and install rainwater goods:"]
[null,null,".01","0,6 mm Thick seamless aluminium gutter and downpipe(complete):"]
[{"$nulls":3},".01","100 x 150 mm (6\") self-supporting box gutter ","m",16,null,0]
[{"$nulls":3},".02","100 mm Down pipe (including sundries)","m",12,null,0]
[null,null,"BB:  CARPENTRY"]
["BB.02","3.2.4","Ceilings: "]
[null,null,".01","Gypsum board with metal H-profile jointing strips: "]
[{"$nulls":3},".01","6.4 mm ceilings ","m2",50,null,0]
[null,null,".03","Gypsum cornices: "]
[{"$nulls":3},".01","76 mm gypsum coved cornices ","m",45,null,0]
["SANS",null,"EARTHWORKS (SMALL WORKS)"]
["1200 DA"]
[8.3,"3.2.5","SCHEDULED ITEMS"]
["8.3.1",null,".01","Remove topsoil to nominal depth of 150mm , stockpile and maintain",null,"m2",145,null,{"$f":"G59*H59","v":0}]
["8.3.2",null,".02","Excavate for restricted foundation, footings and trenches in all materials and use for backfill or embankment or dispose.",null,"m3",87,null,0]
["8.3.4",null,".03","Importing, placing and compacting approved G4 material in layers of 150mm from commercial sources or from borrow pits to 95% MOD AASTHO.",null,"m3",72.5,null,0]
[null,null,".04","Excavate for restricted trenches in compacted G4 material for raft foundation rib beams. Use for backfill or embankment or dispose.",null,"m3",14.5,null,0]
[null,null,".05","Extra over item 8.3.2 above for:"]
[null,null,".06",".01","Intermediate excavation  ","m³",36.25,null,0]
[null,null,".07","Soil and Termite poisoning underneath building work as per SANS 10400 (Include certificates)",null,"m2",145,null,0]
[]
["SANS",null,"CONCRETE (STRUCTURAL)"]
["1200 G"]
[8.4,null,"SCHEDULED CONCRETE ITEMS"]
["8.4.3","3.2.6","Strength concrete:"]
[null,null,".01","Class 20Mpa/19mm concrete in aprons / Stormwater Channel D55mm including rough formwork as in 8.2.1",null,"m3",3,null,0]
[null,null,".02","Class 25Mpa/19mm concrete in floors and rib beams",null,"m3",75,null,0]
[null,null,".03","Class 25Mpa/19mm concrete in strip footings, including minor rough formwork for beam sides.",null,"m3",10,null,0]
["SANS",null,"SCHEDULED REINFORCEMENT ITEMS"]
["1200 H","3.2.7","High-tensile steel welded mesh and steel bars:"]
[null,null,".01","Ref No 617 mesh in concrete floor",null,"m2",80,null,{"$f":"G76*H76","v":0}]
[null,null,".02","Ref No 311 mesh in concrete floor",null,"m2",80,null,{"$f":"G77*H77","v":0}]
[null,null,".03","Ref No 200 mesh in concrete floor",null,"m2",20,null,0]
[null,null,".04","Y12 high tensile steel bars ",null,"kg",200,null,{"$f":"G79*H79","v":0}]
[null,null,".05","R8 high tensile steel bars ",null,"kg",300,null,{"$f":"G80*H80","v":0}]
[null,"3.2.8","SCHEDULED FORMWORK ITEMS"]
["8,2,1",null,".01","Rough vertical formwork to side of concrete foundations",null,"m2",10,null,{"$f":"G82*H82","v":0}]
[null,null,".02","Smooth formwork to side of concrete channels",null,"m2",5,null,{"$f":"G83*H83","v":0}]
[null,null,".03","Wooden Floating finishing ",null,"m2",75,null,0]
[null,"3.2.9","SCHEDULED STEEL COLUMN ITEMS"]
[null,null,".01","Supply and nstallation of 100 ø x 4 mm (3 m high)RHS column. The column to be tied into a laminated beam and concrete floor",null,"No",3,null,{"$f":"G86*H86","v":0}]
[]
[null,null,"BUILDING WORK "]
[null,null,"Supply and install listed items in accordance with relevant standard. Rates include full installation and sundry items."]
["BD.01","3.2.10","Doors and windows : "]
[null,null,".01","Steel door frames:"]
[{"$nulls":3},".01","1,2 mm thick pressed steel door frame for door size 813 mm x 2 032 mm high suitable for 230 mm wall ","number",1,null,0]
[null,null,".02","Security Screen and Gates:"]
[null,null,".03","Steel window frames"]
[{"$nulls":4},"WO5 - Steel small payne window, opening outwards, Type 14-BH + 9-F/LT, window size 889mm wide x 1311mm, Galvanised, Including standard brass fittings and 4mm clear float glass","number",5,null,0]
[{"$nulls":4},"WO6 - Steel small payne window, opening outwards, Type 4-BH, window size 889mm wide x 457mm, Galvanised, Including standard brass fittings and 4mm obscured glass","number",8,null,0]
["BD.03","3.2.11","Joinery:"]
[null,null,".01","Items measured by number:"]
["BD.03",null,null,".01"," Type B - 2032 x 813 x 44mm Solid core hardwood panel door with commercial veneer finish","number",1,null,{"$f":"G99*H99","v":0}]
["BD.04","3.2.12","Ironmongery, steelwork, glass, wall finishings, etc:"]
[null,null,".01","Items measured by number:"]
[{"$nulls":3},".01","Solid Art 390/13 4 Lever Mortice Lockset and satin chrome plated handles (External Doors) with 1 pair of brass cabin hooks","number",1,null,0]
[{"$nulls":3},".02","38mm Diameter Door stop plugged and screwed to floor with 50mm long brass screw","number",1,null,0]
[{"$nulls":3},".03","200mm x 200mm Terracota Airbrick or similar approved","number",4,null,{"$f":"G104*H104","v":0}]
[null,null,".02","Items measured by linear meter:"]
[{"$nulls":3},".01","2x110mm wide pre cast lintel","m",15,null,0]
[{"$nulls":3},".02","External window cills - Roller course face brick set at an angle of 15 degrees; 375 micron embossed DPC below cill","m",9,null,0]
[{"$nulls":3},".03","Internal window cills - Everite Nutec fibre cement (Product no 031-509) complete with fixing lugs and selg tapping screws","m",9,null,{"$f":"G108*H108","v":0}]
[{"$nulls":3},".04","External cement plaster in beam filling","m",35,null,{"$f":"G109*H109","v":0}]
["BD03",null,null,".05","Brickwork Reinforcement - 75mm (galvanized)","m",0,null,{"$f":"G110*H110","v":0}]
[{"$nulls":3},".06","Brickwork Reinforcement - 150mm (galvanized)","m",350,null,{"$f":"G111*H111","v":0}]
[null,null,".03","Items measured by area:",{"$nulls":4},0]
[{"$nulls":3},".01","230 mm thick Stock brick walls - NFP type brick","m2",{"$f":"55+10","v":65},null,0]
[{"$nulls":3},".02","Extra over 230mm thick walls for face brick walls; Corobrik FBA walls (\"Roan Satin\") in stretcher bond with ruled joints and perpends","m2",55,null,0]
[{"$nulls":3},".03","230mm thick face brick walls; Corobrik FBA walls (\"Roan Satin\") in stretcher bond with ruled joints and perpends","m2",25,null,{"$f":"G115*H115","v":0}]
[{"$nulls":3},".04","Internal cement plaster to walls","m2",55,null,{"$f":"G116*H116","v":0}]
[{"$nulls":3},".05","Supply and Installation of 250x50 laminated beam. Beam to be measured on site. Beam to be manufactured in accordance SANS 10400 and 1460","m",8,null,{"$f":"G117*H117","v":0}]
[null,null,"BE:  FLOORS"]
["BE.01","3.2.13","Floor screeds:"]
[null,null,".01","30 mm thick screed with smooth finish",null,"m2",75,null,0]
["BE.02","3.2.14","Joinery:"]
[null,null,".01","Items measured by linear meter:"]
[{"$nulls":3},".01","19 mm x 76 mm hardwood skirting with quadrant bead","m",35,null,0]
["BE.03","3.2.15","Floor tiling and finishes, etc:"]
[null,null,".01","Items measured by area:"]
[{"$nulls":3},".01","250 micron damp proofing under solid floors","m2",75,null,0]
[{"$nulls":3},".02","Vinyl Floor Tiling or similar approved ","m2",60,null,0]
[{"$nulls":4},"FloorworX Superflex fully flexible vinyl floor sheeting 1,2m wide x 2mm thick in similar colour finish, manufactured in accordance with SANS 786:2000, laid in FloorworX No. 60 Plus acrylic adhesive spread with a notched trowel on suitably prepared subfloor (elsewhere specified) with a hygrometer reading showing a moisture content of less than 70%, with joints welded with a fully flexible coloured 'Marley Welding Rod' to provide a smooth, hygienic sealed finish and rolled with 68kg three section metal roller on completion. Upon completion, floor to be sealed with three coats of FloorX Silk Matt."]
[null,"3.2.16","BH: FITTINGS"]
[{"$nulls":3},".01","Chalk Board (4,7 m x 1,2 m) with ledge, or similar approved","number",1,null,{"$f":"G130*H130","v":0}]
[{"$nulls":3},".02","Pin Board (4,7 m x 0,9 m) with cork inner, velt cover and timber border, or similar approved ","number",1,null,{"$f":"G131*H131","v":0}]
[null,null,"BJ: PAINT WORK"]
[null,null,"NEW UNPAINTED SURFACES"]
["BJ.02","3.2.17","Paint to various surfaces:"]
[null,null,".01","Plaster surfaces:"]
[{"$nulls":3},".01","Prepare and apply one coat professional plaster primer and two coats acrylic PVA paint suitable for washing with a mild detergent and with a mat finish. Provide 1 coat alcaline resistant 100% pure acrylic fillercoat. Spread rate 6m square per liter. "]
[{"$nulls":4},".01  Walls","m2",60,null,{"$f":"G137*H137","v":0}]
[null,null,".02","Fibre cement surfaces:"]
[{"$nulls":3},".01","Exterior quality pure acrylic emulsion paint with Teflon:"]
[{"$nulls":4},".01  Ceilings and cornices","m2",85,null,{"$f":"G140*H140","v":0}]
[null,null,".03","Steel surfaces:"]
[{"$nulls":3},".01","Prepare surfaces, apply spot primer, one undercoat and two coats non-drip polyurethane, semi gloss, enamel paint:"]
[{"$nulls":4},".02 Window burglar proofing or mentis expanded metal grid to steel frame in burglar proofing","m2",20,null,{"$f":"G143*H143","v":0}]
[{"$nulls":4},".03  Door frames","m2",1,null,0]
[null,null,".03",".01",".06 Rails, Posts, Pipes, steel structures etc. not exceeding 50 mm diameter","m",5,null,0]
[{"$nulls":4},".08 Steel structures (Roof - If required)","m2",95,null,0]
[null,null,".06","Wood surfaces:",{"$nulls":4},0]
[{"$nulls":3},".01","Protective and decorative solvent based polyurethane alkyd semi-gloss non-drip enamel paint: (Inside)"]
[{"$nulls":4},".01  Doors","m2",2,null,0]
[{"$nulls":4},".02  Skirtings and quadrant beads not exceeding 150 mm girth","m",30,null,0]
[{"$nulls":3},".02","Water resistant polyurethane clear matt varnish: (Outside)"]
[{"$nulls":4},".01  Doors","m2",2,null,0]
[{"$nulls":4},".02  Skirtings and quadrant beads not exceeding 150 mm girth","m",10,null,0]
[null,null,"BB:  CARPENTRY FOR ROOFS",{"$nulls":5},0]
["BB.01","3.2.18","Supply and install new items measured by length:"]
[null,null,".01","225 x 10 mm Thick pressed fibre cement fascia, including painting, etc.",null,"m",20]
[null,null,".02","225 x 10 mm Thick fibre cemet barge board, including painting, etc.",null,"m",25,null,0]
[null,null,".03","75 x 50 mm SAP purlins",null,"m",100,null,0]
[null,null,".04","Design, supply and install Wrought sloping SAP trusses for single classroom complete according to drawing 2426 - G05",null,"Sum",1,null,0]
["BB.08","3.2.19","Painting of existing members in overhangs:"]
[null,null,".01","Members with creosote (2 Coats)",null,"m",10,null,0]
["TOTAL STRUCTURAL AND BUILDING",{"$nulls":7},{"$f":"SUM(I39:I161)","v":0}]
["SCHEDULE NO 3.3 :",null,"CONVENTIONAL FIRE FIGHTING EQUIPMENT"]
[null,null,"GENERAL"]
["PJC 02","3.3.1","Labeling of all conventional fire fighting equipment with identifying tags and recording of details in accordance with SANS 10400:"]
["PJC 06",null,".02","Fire extinguishers",null,"number",3,null,{"$f":"G166*H166","v":0}]
["PJC 10","3.3.2","Signage for fire fighting equipment"]
[null,null,".01","Photo luminescent escape and fire fighting equipment signs installed complete with, aluminium frame, mountings, brackets, etc. "]
[{"$nulls":3},".01","190mm x 190mm","number",2,null,{"$f":"G169*H169","v":0}]
[{"$nulls":3},".02","190mm x 384mm","number",2,null,0]
[{"$nulls":3},".03","190mm x 578mm","number",1,null,0]
[null,null,".02","Silk-screened escape and fire fighting equipment signs installed complete with aluminium frame, mountings, brackets, etc."]
[{"$nulls":3},".01","190mm x 190mm","number",2,null,{"$f":"G173*H173","v":0}]
[{"$nulls":3},".02","190mm x 384mm","number",2,null,0]
[{"$nulls":3},".03","190mm x 578mm","number",1,null,0]
[null,null,".03","Silk-screened fire fighting equipment signs installed behind backboards"]
[{"$nulls":3},".01","400mm x 666mm","number",2,null,{"$f":"G177*H177","v":0}]
[null,null,"DETAIL WORK"]
["PJC.06","3.3.3","Supply and installation of fire extinguisher equipment:"]
[null,null,".01","9 kg Dry chemical powder (STP) fire extinguisher",null,"number",1,null,{"$f":"G180*H180","v":0}]
[null,null,".02","5kg Carbon dioxide fire extinguisher complete with 520\nx 22mm thick timber backboard plugged to wall and varnished (SafeQuip, Chubb or similar approved)",null,"number",2,null,0]
[null,null,".03","Lockable, metal cabinet for fire extinguisher",null,"number",1,null,0]
["TOTAL PLUMBING, DRAINAGE, SEWER AND WATER ",{"$nulls":7},{"$f":"SUM(I165:I182)","v":0}]
["SCHEDULE NO 3.4 :",null,"AUXILIARY WORKS (moving of existing building)"]
[]
[null,"3.4.1","Dismantle, Move and Re-asemble existing 6m x 6m mobile classroom (on site)",null,null,"Sum",1,null,{"$f":"G186*H186","v":0}]
["TOTAL AUXILIARY WORKS","TOTAL PLUMBING  AND DRAINAGE",{"$nulls":6},{"$f":"I186","v":0}]
[]
["SUMMARY OF SCHEDULE OF QUANTITIES: MHLWAZINI HIGH SCHOOL - STANDARD SINGLE CLASSROOM B",{"$nulls":7},"AMOUNT"]
["SCHEDULE NO 3.1 :",null,"PRELIMINARY AND GENERAL",{"$nulls":5},{"$f":"I33","v":{"v":5000,"d":"5,000.00"}}]
["SCHEDULE NO 3.2 :",null,"STRUCTURAL AND BUILDING",{"$nulls":5},{"$f":"I162","v":0}]
["SCHEDULE NO 3.3 :",null,{"$f":"C163","v":"CONVENTIONAL FIRE FIGHTING EQUIPMENT"},{"$nulls":5},{"$f":"I183","v":0}]
["SCHEDULE NO 3.4 :",null,"AUXILIARY WORKS",{"$nulls":5},{"$f":"I187","v":0}]
["SUB TOTAL B: STANDARD SINGLE CLASSROOM B (carry to summary page)",{"$nulls":7},{"$f":"SUM(I190:I193)","v":{"v":5000,"d":"5,000.00"}}]

{"sheet":"4 Ablution block - Boys","index":3,"n_rows":231,"n_cols":9,"rows_kept":231,"merged":[[0,2,0,4],[1,0,1,1],[2,0,2,1],[2,2,2,4],[3,2,3,4],[4,2,4,4],[5,3,5,4],[6,2,6,4],[7,2,7,4],[8,2,8,4],[9,3,9,4],[10,2,10,4],[11,3,11,4],[12,3,12,4],[13,2,13,4],[14,2,14,4],[18,2,18,4],[19,2,19,4],[20,2,20,4],[21,2,21,4],[23,3,23,4],[25,3,25,4],[27,3,27,4],[29,3,29,4],[31,3,31,4],[32,0,32,7],[33,0,33,1],[33,2,33,4],[34,2,34,4],[35,2,35,4],[36,2,36,4],[37,3,37,4],[39,3,39,4],[41,2,41,4],[42,3,42,4],[45,2,45,4],[46,3,46,4],[50,2,50,4],[51,2,51,4],[53,2,53,4],[54,3,54,4],[55,3,55,4],[56,3,56,4],[57,3,57,4],[60,3,60,4],[61,3,61,4],[62,2,62,4],[64,2,64,4],[65,2,65,4],[66,3,66,4],[67,3,67,4],[68,3,68,4],[69,3,69,4],[71,2,71,4],[72,3,72,4],[73,3,73,4],[74,3,74,4],[75,3,75,4],[76,3,76,4],[77,3,77,4],[79,3,79,4],[80,3,80,4],[82,2,82,4],[83,2,83,4],[84,2,84,4],[85,2,85,4],[86,3,86,4],[88,3,88,4],[90,3,90,4],[92,2,92,4],[96,2,96,4],[97,3,97,4],[108,3,108,4],[115,3,115,4],[123,2,123,4],[124,3,124,4],[125,2,125,4],[126,3,126,4],[128,2,128,4],[129,3,129,4],[133,2,133,4],[134,2,134,4],[135,2,135,4],[136,3,136,4],[139,3,139,4],[146,3,146,4],[150,2,150,4],[151,2,151,4],[152,3,152,4],[153,3,153,4],[154,3,154,4],[155,3,155,4],[156,2,156,4],[157,3,157,4],[158,0,158,7],[159,0,159,1],[159,2,159,4],[160,2,160,4],[161,3,161,4],[166,13,166,14],[167,3,167,4],[171,13,171,14],[172,3,172,4],[176,2,176,4],[176,13,176,14],[177,3,177,4],[179,3,179,4],[184,2,184,4],[184,12,184,14],[185,3,185,4],[185,13,185,14],[189,3,189,4],[191,3,191,4],[193,2,193,4],[194,3,194,4],[197,3,197,4],[199,3,199,4],[200,2,200,4],[201,3,201,4],[205,2,205,4],[206,3,206,4],[208,2,208,4],[209,2,209,4],[210,2,210,4],[211,3,211,4],[215,2,215,4],[216,3,216,4],[217,2,217,4],[218,2,218,4],[219,2,219,4],[220,2,220,4],[224,0,224,7],[226,0,226,7]]}
["PAYMENT REFERS TO","ITEM NO","DESCRIPTION",null,null,"UNIT","QUANTITY","RATE","AMOUNT"]
["4: ABLUTION BLOCK BOYS"]
["SCHEDULE 4.1",null,"PRELIMINARY AND GENERAL"]
["SANS",null,"GENERAL "]
["1200A","4.1.1","Scheduled fixed - charge and value - related items:"]
[null,null,".01","Fixed prelimiary and general chages ",null,"sum",1,null,{"$f":"G6*H6","v":0}]
[null,"4.1.2","Scheduled time-related items:",null,null,"Month",3,null,{"$f":"G7*H7","v":0}]
[null,null,"TEMPORARY WORKS "]
[null,"4.1.3","Location and protection of existing services:"]
["8.4 c",null,".01","Excavate by hand to expose existing services",null,"m3",150,null,{"$f":"G10*H10","v":0}]
[null,"4.1.4","Additional tests "]
[null,null,".01","Additional tests required by Engineer ",null,"Prov sum ",1,null,{"v":20000,"d":"20,000.00"}]
[null,null,".02","Attendance and profit ",null,"% ",{"$f":"I12","v":{"v":20000,"d":"20,000.00"}},null,{"$f":"G13*H13","v":0}]
[null,"4.1.5","Update existing key plants ",null,null,"sum",1,null,{"$f":"G14*H14","v":0}]
[null,"4.1.6","OCCUPATIONAL HEALTH AND SAFETY"]
[null,null,".01","Compliance with OHS Act and"]
[{"$nulls":3},"Construction Regulations 2003",null,"sum",1,null,{"$f":"G17*H17","v":0}]
["SH01","4.1.7","HIV/AIDS AWARENESS"]
[null,null,"It is required of the Contractor to thoroughly study the Additional Specification SH: HIV / AIDS Requirements (PW 1544) of the Department that must be read together with and is deemed to be incorporated under this Section of the Bills of Quantities.  "]
[null,null," Provision for pricing of HIV/AIDS awareness is made under the items hereafter and it is explicitly pointed out that all requirements of the aforementioned specification are deemed to be priced hereunder, as the said items represent the only method of measurement and no additional items or extras to the contract in this regard shall be entertained."]
[null,null,"The Contractor must take note that compliance with the HIV/AIDS Specification is compulsory. In the event of partial or total non-compliance, the Representative/Agent, notwithstanding the provisions of Clause 52 of the General Conditions of Contract for Works of Civil Engineering Construction or any other clause to the contrary, reserves the right to delay issuing any progress payment certificate until the Contractor provides satisfactory proof of compliance. "]
[null,null,"The Contractor shall not be entitled to any compensation of whatsoever nature, including interest, due to such delay of payment  "]
["SH 07",null,".01","Awareness Campaign",null,"sum",1,null,{"$f":"G23*H23","v":0}]
[{"$nulls":3},"Selection, appointment, briefing and making available of an Awareness Champion including provision of all relevant services."]
["SH 04.01",null,".02","Awareness Workshops",null,"sum",1,null,{"$f":"G25*H25","v":0}]
[{"$nulls":3},"Selection and appointment of a competent Service Provider approved by the Representative/Agent, provision of a Service Provider Workshop Plan and a suitable venue, conducting of awareness workshops by means of traditional and/or modern multi-media techniques, including follow-up courses, making available all tuition material and performing assessment procedures."]
["SH 04.03",null,".03","Posters, Booklets, Videos, etc.",null,"sum",1,null,{"$f":"G27*H27","v":0}]
[{"$nulls":3},"Provision, displaying, maintaining and replacing when necessary of four plastic laminated posters, booklets and educational videos, etc. for the duration of the construction period."]
["SH 05",null,".04","Access to Condoms",null,"sum",1,null,{"$f":"G29*H29","v":0}]
[{"$nulls":3},"Provision and maintenance of condom dispensers fixed in position, including male and female condoms, replenishing male and female condoms on a daily basis as required for the duration of the construction period."]
["SH 08",null,".05","Monitoring",null,"sum",1,null,{"$f":"G31*H31","v":0}]
[{"$nulls":3},"Monitoring HIV/AIDS awareness of workers, providing the Representative/Agent with access to information including making available all reports, thoroughly completed and reflecting the correct information, for the duration of the construction period and close out."]
["TOTAL PRELIMINARY AND GENERAL",{"$f":"\"TOTAL \"&#REF!&\" CARRIED TO SUMMARY:  GENERAL MAINTENANCE WORK\"","v":{"$error":"#REF!"}},{"$nulls":6},{"$f":"SUM(I5:I32)","v":{"v":20000,"d":"20,000.00"}}]
["SCHEDULE NO 4.2 :",null,"STRUCTURAL AND BUILDING"]
[null,null,"BA : ROOFS"]
[null,null,"CLADDING AND SHEETING"]
["BA.01","4.2.1","Supply and install cladding and sheeting:"]
[null,null,".01","0,6 mm Corrugated Chromakek Roof Sheeting (Colour to match existing buildings) @17'' on insulation on 76x50mm SA Pine purlins (Chromadek or similar approved)"]
[{"$nulls":3},".01","Roof covering with pitches exceeding 15°, fixed to timber or steel purlins","m2",18,null,{"$f":"G39*H39","v":0}]
[null,null,2,"Roof insulation"]
["BA.07",null,null,".01","Roof insulation with Class 1 fire rating. Eviro-foil 201FR, Sisolation HF2 or similar approved","m2",{"$f":"G39","v":18},null,{"$f":"G41*H41","v":0}]
["BA.06","4.2.2","Supply and install sundry items, etc.:"]
[null,null,".01","0,6 mm Chromadek metal ridge cap or with ridge closer to manufacturer spec."]
[{"$nulls":3},".01","Ridge flashing","m",6,null,{"$f":"G44*H44","v":0}]
[{"$nulls":3},".03","Gable flashing","m",15,null,{"$f":"G45*H45","v":0}]
["BA.08","4.2.3","Supply and install rainwater goods:"]
[null,null,".01","0,6 mm Thick seamless aluminium gutter and downpipe(complete):"]
[{"$nulls":3},".01","100 x 150 mm (6\") self-supporting box gutter ","m",11,null,{"$f":"G48*H48","v":0}]
[{"$nulls":3},".02","100 mm Down pipe","m",6,null,{"$f":"G49*H49","v":0}]
[{"$nulls":3},".03","5000 litre Water Tank","number",1,null,{"$f":"G50*H50","v":0}]
[]
["SANS",null,"EARTHWORKS (SMALL WORKS)"]
["1200 DA"]
[8.3,"4.2.4","SCHEDULED ITEMS"]
["8.3.1",null,".01","Remove topsoil to nominal depth of 150mm , stockpile and maintain",null,"m2",45,65.25,{"$f":"G55*H55","v":{"v":2936.25,"d":"2,936.25"}}]
["8.3.2",null,".02","Excavate for restricted foundation, footings and trenches in all materials and use for backfill or embankment or dispose.",null,"m3",30,{"v":43.5,"d":"43.50"},{"$f":"G56*H56","v":{"v":1305,"d":"1,305.00"}}]
["8.3.4",null,".03","Importing, placing and compacting approved G4 material in layers of 150mm from commercial sources or from borrow pits to 95% MOD AASTHO.",null,"m3",25,36.25,{"$f":"G57*H57","v":906.25}]
[null,null,".04","Excavate for restricted trenches in compacted G4 material for raft foundation rib beams. Use for backfill or embankment or dispose.",null,"m3",5,7.25,{"$f":"G58*H58","v":36.25}]
[null,null,".05","Extra over item 8.3.2 above for:"]
[{"$nulls":3},".01","Intermediate excavation  ","m³",5,7.25,{"$f":"G60*H60","v":36.25}]
[null,null,".06","Soil and Termite poisoning underneath building work as per SANS 10400 (Include certificates)",null,"m2",{"$f":"G55","v":45},65.25,{"$f":"G61*H61","v":{"v":2936.25,"d":"2,936.25"}}]
[]
["SANS",null,"CONCRETE (STRUCTURAL)"]
["1200 G"]
[8.4,null,"SCHEDULED CONCRETE ITEMS"]
["8.4.3","4.2.6","Strength concrete:"]
[null,null,".01","Class 20Mpa/19mm concrete in aprons / Stormwater Channel D55mm including rough formwork as in 8.2.1",null,"m3",5,null,{"$f":"G67*H67","v":0}]
[null,null,".02","Class 25Mpa/19mm concrete in floors and rib beams",null,"m3",10,null,{"$f":"G68*H68","v":0}]
[null,null,".03","Class 25Mpa/19mm concrete in strip footings, including minor rough formwork for beam sides.",null,"m3",2,null,{"$f":"G69*H69","v":0}]
[null,null,".04","Supply and install 250 mm ø, 3m high, 25 Mpa concrete column in fibre cement casing, as supplied by Nutec or similar approved. ",null,"No",0,null,{"$f":"G70*H70","v":0}]
["SANS",null,"SCHEDULED REINFORCEMENT ITEMS"]
["1201 H","4.2.7","High-tensile steel welded mesh and steel bars:"]
[null,null,".01","Ref No 617 mesh in concrete floor",null,"m2",30,null,{"$f":"G73*H73","v":0}]
[null,null,".02","Ref No 311 mesh in concrete floor",null,"m3",30,null,{"$f":"G74*H74","v":0}]
[null,null,".03","Ref No 200 mesh in concrete floor",null,"m4",10,null,0]
[null,null,".04","Y12 high tensile steel bars ",null,"kg",250,null,{"$f":"G76*H76","v":0}]
[null,null,".05","R8 high tensile steel bars ",null,"kg",100,null,{"$f":"G77*H77","v":0}]
["SANS"]
["1200 G","4.2.8","SCHEDULED FORMWORK ITEMS"]
["8,2,1",null,".01","Rough vertical formwork to side of concrete foundations",null,"m2",10,null,{"$f":"G80*H80","v":0}]
[null,null,".02","Smooth formwork to side of concrete channels",null,"m2",5,null,{"$f":"G81*H81","v":0}]
[null,null,".03","Wooden Floating finishing ",null,"m2",40,null,{"$f":"G82*H82","v":0}]
[null,null,"BUILDING WORK "]
[null,null,"Supply and install listed items in accordance with relevant standard. Rates include full installation and sundry items."]
[null,null,"BD:  WALLS"]
["BD.01","4.2.9","Doors and windows : "]
[null,null,".01","Steel door frames:"]
[{"$nulls":3},".01","1,2 mm thick pressed steel door frame for door size 813 mm x 2 032 mm high suitable for 230 mm  thick wall ","number",1,null,{"$f":"G88*H88","v":0}]
[null,null,".02","Security Screen and Gates:"]
[{"$nulls":3},".01","Galvanised Security Screen; inclusive of 2 x lockable standard size single gates (813 mm wide x 2032mm) to open 180 deg","number",1,null,{"$f":"G90*H90","v":0}]
[null,null,".03","Steel window frames"]
[{"$nulls":3},".01","Steel small payne window, opening outwards,Type NE 2,window size 1022mm wide x 654mm, Galvanised, Including standard brass fittings and 4mm clear float glassobscured glass","number",2,null,{"$f":"G92*H92","v":0}]
["BD.03","4.2.10","Joinery:"]
[null,null,".01","Items measured by number:"]
["BD.03",null,null,".01","Type E - 2032 x 813 x 44mm Hollow core hardwood panel door with commercial veneer finish","number",1,null,{"$f":"G95*H95","v":0}]
[{"$nulls":3},".02","Type F - 1550 x 610 x 44mm Hollow core hardwood panel toilet door with commercial veneer finish","number",4,null,0]
["BD.04","4.2.11","Ironmongery, steelwork, glass, wall finishings, etc:"]
[null,null,".01","Items measured by number:"]
[{"$nulls":3},".01","Solid Art 390/13 4 Lever Mortice Lockset and satin chrome plated handles (Internal Doors)","number",5,null,0]
[{"$nulls":3},".02","38mm Diameter Door stop plugged and screwed to floor with 50mm long brass screw","number",5,null,0]
[{"$nulls":3},".03","Stainless steel mirror, 300mm x 400mm Manufactured from 18/10 1 mm flat stainless steel with high polis finish and with 4 drillings for no. 8 mirror screw; Franke item no CRH 401 or similar","number",4,null,0]
[{"$nulls":3},".04","Soap dispenser, surface mounted, manufactured from 18/10 1.2mm stainless steel, satin finish with cylinder lock, Franke item no STRX 618 or similar ","number",4,null,0]
[{"$nulls":3},".05","Toilet Roll holder, Surface mounted, manufactured from 18/10 stainless steel, satin finish with cylinder lock, Franke item STRX 671 or similar ","number",4,null,0]
[{"$nulls":3},".06","Paper towel dispenser, Surface mounted, manufactured from 18/10 1.2mm Stainless steel, satin finish with cylinder lock; Franke items no STRX 600 or similar ","number",2,null,0]
[{"$nulls":3},".07","150mm Natural Anodized Aluminium male sign type B2313 or similar approved ","number",2,null,0]
[{"$nulls":3},".08","150mm Natural Anodized Aluminium female sign type B2314 or similar approved ","number",2,null,0]
[{"$nulls":3},".09","200x300 Glass Brickor Similar approved","number",4,null,0]
[{"$nulls":3},".10","200x300 Ventilation / Airbrick or Similar approved","number",4,null,0]
[null,null,".02","Items measured by linear meter:"]
[{"$nulls":3},".01","2x110mm wide pre cast lintel","m",20,null,0]
[{"$nulls":3},".02","External window cills - Roller course face brick set at an angle of 15 degrees; 375 micron embossed DPC below cill","m",5,null,0]
[{"$nulls":3},".03","Internal window cills - Everite Nutec fibre cement (Product no 031-509) complete with fixing lugs and selg tapping screws","m",5,null,0]
[{"$nulls":3},".04","External cement plaster in beam filling","m",15,null,0]
["BD03",null,null,".05","Brickwork Reinforcement - 75mm (galvanized)","m",90,null,{"$f":"G114*H114","v":0}]
[{"$nulls":3},".06","Brickwork Reinforcement - 150mm (galvanized)","m",300,null,{"$f":"G115*H115","v":0}]
[null,null,".03","Items measured by area:"]
[{"$nulls":3},".01","6mm thick white glazed wall tiles to existing painted or plastered walls as approved by the Engineer","m2",10,null,0]
[{"$nulls":3},".02","230 mm thick Stock brick walls - NFP type brick","m2",70,null,{"$f":"G118*H118","v":0}]
[{"$nulls":3},".03","110 mm thick Slock brick walls - NFP type brick","m2",20,null,0]
[{"$nulls":3},".04","Extra over 230mm thick brick walls for face brick walls; Corobrik FBA walls (\"Roan Satin\") in stretcher bond with ruled joints and perpends","m2",60,null,0]
[{"$nulls":3},".05","230mm thick face brick walls; Corobrik FBA walls (\"Roan Satin\") in stretcher bond with ruled joints and perpends","m2",10,null,{"$f":"G121*H121","v":0}]
[{"$nulls":3},".06","Internal cement plaster to walls","m2",85,null,{"$f":"G122*H122","v":0}]
[null,null,"BE:  FLOORS"]
["BE.01","4.2.12","Floor screeds:"]
[null,null,".01","30 mm thick smooth screed finish",null,"m2",45,null,{"$f":"G125*H125","v":0}]
["BE.02","4.2.13","Joinery:"]
[null,null,".01","Items measured by linear meter:"]
[{"$nulls":3},".01","19 mm x 76 mm hardwood skirting with quadrant bead","m",35,null,{"$f":"G128*H128","v":0}]
["BE.03","4.2.14","Floor tiling and finishes, etc:"]
[null,null,".01","Items measured by area:"]
[{"$nulls":3},".01","250 micron damp proofing under solid floors / surface beds","m2",{"$f":"G125","v":45},null,{"$f":"G131*H131","v":0}]
[{"$nulls":3},".02","Vinyl Floor Tiling or similar approved ","m2",0,null,{"$f":"G132*H132","v":0}]
[{"$nulls":4},"FloorworX Superflex fully flexible vinyl floor sheeting 1,2m wide x 2mm thick in similar colour finish, manufactured in accordance with SANS 786:2000, laid in FloorworX No. 60 Plus acrylic adhesive spread with a notched trowel on suitably prepared subfloor (elsewhere specified) with a hygrometer reading showing a moisture content of less than 70%, with joints welded with a fully flexible coloured 'Marley Welding Rod' to provide a smooth, hygienic sealed finish and rolled with 68kg three section metal roller on completion. Upon completion, floor to be sealed with three coats of FloorX Silk Matt."]
[null,null,"BJ: PAINT WORK"]
[null,null,"NEW UNPAINTED SURFACES"]
["BJ.02","4.2.15","Paint to various surfaces:"]
[null,null,".01","Plaster surfaces:"]
[{"$nulls":3},".01","Prepare and apply one coat professional plaster primer and two coats acrylic PVA paint suitable for washing with a mild detergent and with a mat finish. Provide 1 coat alcaline resistant 100% pure acrylic fillercoat. Spread rate 6m square per liter. "]
[{"$nulls":4},".01  Walls","m2",85,null,{"$f":"G139*H139","v":0}]
[null,null,".02","Steel surfaces:"]
[{"$nulls":3},".01","Prepare surfaces, apply spot primer, one undercoat and two coats non-drip polyurethane, semi gloss, enamel paint:"]
[{"$nulls":4},".01 Window burglar proofing or mentis expanded metal grid to steel frame in burglar proofing","m2",2,null,{"$f":"G142*H142","v":0}]
[{"$nulls":4},".02 Door Frames (including Primer)","m3",2,null,{"$f":"G143*H143","v":0}]
[{"$nulls":4},".03 Security gates (Including Primer)","m2",4,null,{"$f":"G144*H144","v":0}]
["BJ.02","4.2.16",".01",".01",".01Rails, Posts, Pipes, steel structures etc. exceeding 50 mm dia not exceeding 110 mm diameter","m",20,null,{"$f":"G145*H145","v":0}]
[{"$nulls":4},".02 Steel structures (Roof) - If required.","m2",25,null,0]
[null,null,".02","Wood surfaces:"]
[{"$nulls":3},".01","Protective and decorative solvent based polyurethane alkyd semi-gloss non-drip enamel paint: (Inside)"]
[{"$nulls":4},".01  Doors","m2",25,null,0]
[{"$nulls":4},".02  Skirtings and quadrant beads not exceeding 150 mm girth","m",40,null,0]
[null,null,"BB:  CARPENTRY FOR ROOFS"]
["BB.01","4.2.17","Supply and install new items measured by length:"]
[null,null,".01","225 x 10 mm Thick Nutec pressed fibre cement fascia or similar approved (including painting, etc)",null,"m",10,null,0]
[null,null,".02","275 x 80 mm Thick Nutec fibre cement barge board, or similar approved (including painting, etc).",null,"m",12,null,0]
[null,null,".03","75 x 50 mm SAP purlins",null,"m",30,null,0]
[null,null,".04","Design, supply and install Wrought sloping SAP trusses for administration building complete according to drawing 2426 - G07(including painting with creaosote and wall plate)",null,"Sum",1,null,0]
["BB.08","4.2.18","Painting of existing members in overhangs:"]
[null,null,".01","Members with creosote (min 2 coats)",null,"m",20,null,0]
["TOTAL STRUCTURAL AND BUILDING",{"$nulls":7},{"$f":"SUM(I39:I158)","v":{"v":8156.25,"d":"8,156.25"}}]
["SCHEDULE NO 4.3 :",null,"PLUMBING, DRAINAGE, SEWER AND BULK WATER"]
["PAA.05","4.3.1","Supply and installation of sanitary ware and brassware:"]
[null,null,".01","Water closets:"]
[{"$nulls":3},".01","360mm x 405mm high Vitreous china WC washdown pan with enlarged pedestal.","number",4,null,{"$f":"G163*H163","v":0}]
[{"$nulls":3},".02","Vitreous china WC cistern - white 9 liters complete with lid and fitments","number",4,null,{"$f":"G164*H164","v":0}]
[{"$nulls":3},".03","100 mm ø PVC pan connector","number",4,null,0]
[{"$nulls":3},".04","15 mm ø CP ball-o-stop valve with CP flexi tail pipe to WC cistern","number",4,null,0]
[{"$nulls":3},".05","Heavy duty white buckalite type toilet seat and cover with CP hinge and spindle","number",4,null,0]
[null,null,".02","Wash hand basins:"]
[{"$nulls":3},".01","Vitreous china 520 x 415mm rounded wall mounted  wash hand basin - white","number",4,null,0]
[{"$nulls":3},".02","Flexi rubber P-trap","number",8,null,0]
[{"$nulls":3},".03","15 mm ø CP pillar taps SABS 226 Type 1 (BS 5412), JASWIC Listed","number",8,null,0]
[{"$nulls":3},".04","15 mm ø flexi pipe tailpipe connections  to pillar taps including 15mm CP ball-o-stop valve","number",8,null,0]
[null,null,".03","Urinal"]
[{"$nulls":3},".01","Vitreous chine wall hung urinal with top inlet including fittings.","number",4,null,0]
[{"$nulls":3},".02","3/4\" 'Flushmaster Junior' Urinal Flush valve, CP, exposed type with integral ball-o-stop valve and wall plate","number",4,null,0]
[{"$nulls":3},".03","Bottle trap with 75mm deep re-seal and adjustable telescopic pipe.","number",4,null,0]
["PAA.06","4.3.2","Installation of above ground sanitary drainage piping system:"]
[null,null,".01","uPVC soil and waste pipes:"]
[{"$nulls":3},".01","110 mm ø pipe fixed to walls and soffits","m",60,null,{"$f":"G179*H179","v":0}]
[null,null,".02","uPVC soil and waste pipe fittings:"]
[{"$nulls":3},".01","110 mm dia plain bend 87.5º ","number",20,null,0]
[{"$nulls":3},".04","110 mm dia access bend 135º","number",4,null,0]
[{"$nulls":3},".05","110 mm junction plain 87.5º","number",4,null,0]
[{"$nulls":3},".06","110 mm junction access heel 87.5º","number",8,null,0]
["PAA.06","4.3.3","Supply and installation of underground sanitary drainage pipes:"]
[null,null,".01","Pipe trench excavations, bedding and backfilling:"]
[{"$nulls":3},".01","Excavate in all materials for pipe trenches to depth of 1100 mm x 600 mm wide","m³",35,null,{"$f":"G187*H187","v":0}]
[{"$nulls":3},".02","Supply and installation of pipe bedding 400mm thick river sand","m³",15,null,{"$f":"G188*H188","v":0}]
[{"$nulls":3},".03","Backfilling and compacting to 93% modified AASTHO density with selected material","m³",15,null,{"$f":"G189*H189","v":0}]
[null,null,".02","PVC-U Solid wall sewer pipes Class 34 - 300 KPA to SABS 791 specifications"]
[{"$nulls":3},".01"," 160 mm dia","m",50,null,{"$f":"G191*H191","v":0}]
[null,null,".03","Cleaning eyes:"]
[{"$nulls":3},".01","160 mm ø inline cleaning eye, constructed complete with Square inspection eye cast iron cover and frame Type 14A (SANS 558) daylight opening size 295 x 295mm and 500 x 500 x 75mm thick concrete encasement","number",3,null,0]
["PAA.07","4.3.4","Supply and installation of domestic water piping installation:"]
[null,null,".01","Copper piping Class 0 SABS 460 with capillary soldered type joints for cold-water piping installed in voids inclusive of bracketing:"]
[{"$nulls":3},".01","22 mm ø including fittings ","m",15,null,{"$f":"G196*H196","v":0}]
[{"$nulls":3},".02","15 mm ø including fittings ","m",15,null,0]
[null,null,".04","Supply and installation of Class 6 pressure HDPE piping, including fittings, jointing and testing:"]
[{"$nulls":3},".01","20 mm ø HDPE pipe, including fittings","m",50,null,0]
[null,null,".05","Replace 20 mm ø shut-off ball-o-stop valve",null,"number",2,null,0]
[null,"4.3.5","Manhole covers and grid inlets:"]
["CF.01.04.02",null,".01","Manholes and inspection chambers"]
[{"$nulls":3},".01","New pre-cast concrete manhole up to 1.2m deep, including pre-cast cover and frame","number",2,null,0]
[{"$nulls":3},".02","New pre-cast concrete manhole from 1.2m up to 2.4m deep, including pre-cast cover and frame","number",2,null,0]
["1200 DA"]
[8.3,"4.3.6","SCHEDULED ITEMS (French Drain / Soakaway)"]
["PAA.06",null,".01","Complete installation PVC-U Slotted subsoil drainage pipes complete with integral sockets"]
[{"$nulls":3},".01"," 110 mm dia","m",50,null,{"$f":"G208*H208","v":0}]
[null,null,"BULK WATER AND EXTERNAL WATER RETICULATION"]
["SANS 1200DB",null,"EXCAVATIONS"]
["8.3.2(a)","4.3.7","Excavate in all materials for trenches, backfill, compact, and dispose of surplus/ unsuitable material, for the following pipe diameters for total trench depths:"]
[null,null,".01","Not exceeding 1m deep x 600mm wide",null,"m",35,null,{"$f":"G212*H212","v":0}]
["8.3.2(b)",null,".02","Extra-over item .01 above for:"]
[{"$nulls":3},".01","Intermediate Excavation","m3",20,null,{"$f":"G214*H214","v":0}]
[{"$nulls":3},".02","Hard rock excavation","m3",0,null,{"$f":"G215*H215","v":0}]
["1200LB ","4.3.8","Provision of bedding from trench excavations"]
["8.2.1",null,".01","300mm x 600mm bedding",null,"m3",5,null,{"$f":"G217*H217","v":0}]
[null,null,"PIPES AND FITTINGS"]
["1200L","4.3.9","Connection to existing water network"]
["2.6.1",null,"Supply all labour and material to connect to main supply pipeline including excavation backfill, disposal of surplus material, cutting of pipes and moving of fittings and making good",null,null,"Sum",1,null,{"$f":"G220*H220","v":0}]
["1200L     8.2.1","4.3.10","Supply, lay and bed pipes complete with couplings, including testing"]
["PAA.07",null,".01",".01","20mm dia.. HDPE pipe Class 10, jointed with Plasson high compression fittings (Domestic Installation)","m",30]
[{"$nulls":3},".02","32mm dia.. HDPE pipe Class 10, jointed with Plasson high compression fittings","m",20,null,{"$f":"G223*H223","v":0}]
["1200L     8.2.1",null,null,".03","50mm dia.. HDPE pipe Class 10, jointed with Plasson high compression fittings","m",30,null,{"$f":"G224*H224","v":0}]
["TOTAL PLUMBING, DRAINAGE, SEWER AND BULK WATER ","TOTAL PLUMBING  AND DRAINAGE",{"$nulls":6},{"$f":"SUM(I163:I224)","v":0}]
[]
["SUMMARY OF SCHEDULE OF QUANTITIES: MHLWAZINI HIGH SCHOOL - ABLUTION BLOCK (BOYS)",{"$nulls":7},"AMOUNT"]
["SCHEDULE 4.1",{"$nulls":3},"PRELIMINARY AND GENERAL",{"$nulls":3},{"$f":"I33","v":{"v":20000,"d":"20,000.00"}}]
["SCHEDULE  4.2",{"$nulls":3},"STRUCTURAL AND BUILDING",{"$nulls":3},{"$f":"I159","v":{"v":8156.25,"d":"8,156.25"}}]
["SCHEDULE  4.3",{"$nulls":3},"PLUMBING, DRAINAGE, SEWER AND BULK WATER",{"$nulls":3},{"$f":"I225","v":0}]
["SUB TOTAL A: ABLUTION BLOCK BOYS (carry to summary page)",{"$nulls":7},{"$f":"SUM(I228:I230)","v":{"v":28156.25,"d":"28,156.25"}}]

{"sheet":"5 Ablution block - Girls","index":4,"n_rows":229,"n_cols":11,"rows_kept":229,"merged":[[0,2,0,4],[1,0,1,1],[2,0,2,1],[2,2,2,4],[3,2,3,4],[4,2,4,4],[5,3,5,4],[6,2,6,4],[7,2,7,4],[8,2,8,4],[9,3,9,4],[10,2,10,4],[11,3,11,4],[12,3,12,4],[13,2,13,4],[14,2,14,4],[18,2,18,4],[19,2,19,4],[20,2,20,4],[21,2,21,4],[23,3,23,4],[25,3,25,4],[27,3,27,4],[29,3,29,4],[31,3,31,4],[32,0,32,7],[33,0,33,1],[33,2,33,4],[34,2,34,4],[35,2,35,4],[36,2,36,4],[37,3,37,4],[39,3,39,4],[41,2,41,4],[42,3,42,4],[45,2,45,4],[46,3,46,4],[50,2,50,4],[52,2,52,4],[53,3,53,4],[54,3,54,4],[55,3,55,4],[56,3,56,4],[59,3,59,4],[60,2,60,4],[62,2,62,4],[63,2,63,4],[64,3,64,4],[65,3,65,4],[66,3,66,4],[67,3,67,4],[70,2,70,4],[71,3,71,4],[72,3,72,4],[73,3,73,4],[74,3,74,4],[75,3,75,4],[80,2,80,4],[81,2,81,4],[82,2,82,4],[83,2,83,4],[84,3,84,4],[86,3,86,4],[88,3,88,4],[90,2,90,4],[94,2,94,4],[95,3,95,4],[106,3,106,4],[113,3,113,4],[121,2,121,4],[122,3,122,4],[123,2,123,4],[124,3,124,4],[126,2,126,4],[127,3,127,4],[131,2,131,4],[132,2,132,4],[133,2,133,4],[134,3,134,4],[137,3,137,4],[144,3,144,4],[148,2,148,4],[149,2,149,4],[150,3,150,4],[151,3,151,4],[152,3,152,4],[153,3,153,4],[154,2,154,4],[155,3,155,4],[156,0,156,7],[157,0,157,1],[157,2,157,4],[158,2,158,4],[159,3,159,4],[164,13,164,14],[165,3,165,4],[170,3,170,4],[174,2,174,4],[175,3,175,4],[177,3,177,4],[182,2,182,4],[183,3,183,4],[183,13,183,14],[187,3,187,4],[189,3,189,4],[191,2,191,4],[192,3,192,4],[195,3,195,4],[197,3,197,4],[198,2,198,4],[199,3,199,4],[203,2,203,4],[204,3,204,4],[206,2,206,4],[207,2,207,4],[208,2,208,4],[209,3,209,4],[213,2,213,4],[214,3,214,4],[215,2,215,4],[216,2,216,4],[217,2,217,4],[218,2,218,4],[222,0,222,7],[224,0,224,7]]}
["PAYMENT REFERS TO","ITEM NO","DESCRIPTION",null,null,"UNIT","QUANTITY","RATE","AMOUNT"]
["5: ABLUTION BLOCK GIRLS"]
["SCHEDULE 5.1",null,"PRELIMINARY AND GENERAL"]
["SANS",null,"GENERAL "]
["1200A","5.1.1","Scheduled fixed - charge and value - related items:"]
[null,null,".01","Fixed prelimiary and general chages ",null,"sum",1,null,{"$f":"G6*H6","v":0}]
[null,"5.1.2","Scheduled time-related items:",null,null,"Month",3,null,{"$f":"G7*H7","v":0}]
[null,null,"TEMPORARY WORKS "]
[null,"5.1.3","Location and protection of existing services:"]
["8.4 c",null,".01","Excavate by hand to expose existing services",null,"m3",150,null,{"$f":"G10*H10","v":0}]
[null,"5.1.4","Additional tests "]
[null,null,".01","Additional tests required by Engineer ",null,"Prov sum ",1,null,{"v":20000,"d":"20,000.00"}]
[null,null,".02","Attendance and profit ",null,"% ",{"$f":"I12","v":{"v":20000,"d":"20,000.00"}},null,{"$f":"G13*H13","v":0}]
[null,"5.1.5","Update existing key plants ",null,null,"sum",1,null,{"$f":"G14*H14","v":0}]
[null,"5.1.6","OCCUPATIONAL HEALTH AND SAFETY"]
[null,null,".01","Compliance with OHS Act and"]
[{"$nulls":3},"Construction Regulations 2003",null,"sum",1,null,{"$f":"G17*H17","v":0}]
["SH01","5.1.7","HIV/AIDS AWARENESS"]
[null,null,"It is required of the Contractor to thoroughly study the Additional Specification SH: HIV / AIDS Requirements (PW 1544) of the Department that must be read together with and is deemed to be incorporated under this Section of the Bills of Quantities.  "]
[null,null," Provision for pricing of HIV/AIDS awareness is made under the items hereafter and it is explicitly pointed out that all requirements of the aforementioned specification are deemed to be priced hereunder, as the said items represent the only method of measurement and no additional items or extras to the contract in this regard shall be entertained."]
[null,null,"The Contractor must take note that compliance with the HIV/AIDS Specification is compulsory. In the event of partial or total non-compliance, the Representative/Agent, notwithstanding the provisions of Clause 52 of the General Conditions of Contract for Works of Civil Engineering Construction or any other clause to the contrary, reserves the right to delay issuing any progress payment certificate until the Contractor provides satisfactory proof of compliance. "]
[null,null,"The Contractor shall not be entitled to any compensation of whatsoever nature, including interest, due to such delay of payment  "]
["SH 07",null,".01","Awareness Campaign",null,"sum",1,null,{"$f":"G23*H23","v":0}]
[{"$nulls":3},"Selection, appointment, briefing and making available of an Awareness Champion including provision of all relevant services."]
["SH 04.01",null,".02","Awareness Workshops",null,"sum",1,null,{"$f":"G25*H25","v":0}]
[{"$nulls":3},"Selection and appointment of a competent Service Provider approved by the Representative/Agent, provision of a Service Provider Workshop Plan and a suitable venue, conducting of awareness workshops by means of traditional and/or modern multi-media techniques, including follow-up courses, making available all tuition material and performing assessment procedures."]
["SH 04.03",null,".03","Posters, Booklets, Videos, etc.",null,"sum",1,null,{"$f":"G27*H27","v":0}]
[{"$nulls":3},"Provision, displaying, maintaining and replacing when necessary of four plastic laminated posters, booklets and educational videos, etc. for the duration of the construction period."]
["SH 05",null,".04","Access to Condoms",null,"sum",1,null,{"$f":"G29*H29","v":0}]
[{"$nulls":3},"Provision and maintenance of condom dispensers fixed in position, including male and female condoms, replenishing male and female condoms on a daily basis as required for the duration of the construction period."]
["SH 08",null,".05","Monitoring",null,"sum",1,null,{"$f":"G31*H31","v":0}]
[{"$nulls":3},"Monitoring HIV/AIDS awareness of workers, providing the Representative/Agent with access to information including making available all reports, thoroughly completed and reflecting the correct information, for the duration of the construction period and close out."]
["TOTAL PRELIMINARY AND GENERAL",{"$f":"\"TOTAL \"&#REF!&\" CARRIED TO SUMMARY:  GENERAL MAINTENANCE WORK\"","v":{"$error":"#REF!"}},{"$nulls":6},{"$f":"SUM(I5:I32)","v":{"v":20000,"d":"20,000.00"}}]
["SCHEDULE NO 5.2 :",null,"STRUCTURAL AND BUILDING"]
[null,null,"BA : ROOFS"]
[null,null,"CLADDING AND SHEETING"]
["BA.01","5.2.1","Supply and install cladding and sheeting:"]
[null,null,".01","0,6 mm Corrugated Chromakek Roof Sheeting (Colour to match existing buildings) @17'' on insulation on 76x50mm SA Pine purlins (Chromadek or similar approved)"]
[{"$nulls":3},".01","Roof covering with pitches exceeding 15°, fixed to timber or steel purlins","m2",40,null,{"$f":"G39*H39","v":0}]
[null,null,2,"Roof insulation"]
["BA.07",null,null,".01","Roof insulation with Class 1 fire rating. Eviro-foil 201FR, Sisolation HF2 or similar approved","m2",{"$f":"G39","v":40},null,{"$f":"G41*H41","v":0}]
["BA.06","5.2.2","Supply and install sundry items, etc.:"]
[null,null,".01","0,6 mm Chromadek metal ridge cap or with ridge closer to manufacturer spec."]
[{"$nulls":3},".01","Ridge flashing","m",7.5,null,{"$f":"G44*H44","v":0}]
[{"$nulls":3},".03","Gable flashing","m",15,null,{"$f":"G45*H45","v":0}]
["BA.08","5.2.3","Supply and install rainwater goods:"]
[null,null,".01","0,6 mm Thick seamless aluminium gutter and downpipe(complete):"]
[{"$nulls":3},".01","100 x 150 mm (6\") self-supporting box gutter ","m",15,null,{"$f":"G48*H48","v":0}]
[{"$nulls":3},".02","100 mm Down pipe","m",7,null,{"$f":"G49*H49","v":0}]
[{"$nulls":3},".03","5000 litre Water Tanks","number",1,null,{"$f":"G50*H50","v":0}]
["SANS",null,"EARTHWORKS (SMALL WORKS)"]
["1200 DA"]
[8.3,"5.2.4","SCHEDULED ITEMS"]
["8.3.1",null,".01","Remove topsoil to nominal depth of 150mm , stockpile and maintain",null,"m2",50,{"v":72.5,"d":"72.50"},{"$f":"G54*H54","v":{"v":3625,"d":"3,625.00"}}]
["8.3.2",null,".02","Excavate for restricted foundation, footings and trenches in all materials and use for backfill or embankment or dispose.",null,"m3",35,50.75,{"$f":"G55*H55","v":{"v":1776.25,"d":"1,776.25"}}]
["8.3.4",null,".03","Importing, placing and compacting approved G4 material in layers of 150mm from commercial sources or from borrow pits to 95% MOD AASTHO.",null,"m3",25,36.25,{"$f":"G56*H56","v":906.25}]
[null,null,".04","Excavate for restricted trenches in compacted G4 material for raft foundation rib beams. Use for backfill or embankment or dispose.",null,"m3",7,10.15]
[null,null,".05","Extra over item 8.3.2 above for:"]
[{"$nulls":3},".01","Intermediate excavation  ","m³",10,{"v":14.5,"d":"14.50"},{"$f":"G59*H59","v":{"v":145,"d":"145.00"}}]
[null,null,".06","Soil and Termite poisoning underneath building work as per SANS 10400 (Include certificates)",null,"m2",{"$f":"G54","v":50},{"v":72.5,"d":"72.50"},{"$f":"G60*H60","v":{"v":3625,"d":"3,625.00"}}]
["SANS",null,"CONCRETE (STRUCTURAL)"]
["1200 G"]
[8.4,null,"SCHEDULED CONCRETE ITEMS"]
["8.4.3","5.2.5","Strength concrete:"]
[null,null,".01","Class 15Mpa/19mm concrete in aprons / Stormwater Channel D55mm including rough formwork as in 8.2.1",null,"m3",5,null,{"$f":"G65*H65","v":0}]
[null,null,".02","Class 25Mpa/19mm concrete in floors and rib beams",null,"m3",15,null,{"$f":"G66*H66","v":0}]
[null,null,".03","Class 15Mpa/19mm concrete in strip footings, including minor rough formwork for beam sides.",null,"m3",2,null,{"$f":"G67*H67","v":0}]
[null,null,".04","Supply and install 250 mm ø, 3m high, 25 Mpa concrete column in fibre cement casing, as supplied by Nutec or similar approved. ",null,"No",0,null,{"$f":"G68*H68","v":0}]
["SANS",null,"SCHEDULED REINFORCEMENT ITEMS"]
["1200 H"]
[null,"5.2.6","High-tensile steel welded mesh and steel bars:"]
[null,null,".01","Ref No 617 mesh in concrete floor",null,"m2",40,null,{"$f":"G72*H72","v":0}]
[null,null,".02","Ref No 311 mesh in concrete floor",null,"m3",40,null,{"$f":"G73*H73","v":0}]
[null,null,".03","Ref No 200 mesh in concrete floor",null,"m4",12,null,0]
[null,null,".04","Y12 high tensile steel bars ",null,"kg",250,null,{"$f":"G75*H75","v":0}]
[null,null,".05","R8 high tensile steel bars ",null,"kg",100,null,{"$f":"G76*H76","v":0}]
["SANS","5.2.7","SCHEDULED FORMWORK ITEMS"]
["1200 G",null,".01","Rough vertical formwork to side of concrete foundations",null,"m2",15,null,{"$f":"G78*H78","v":0}]
[8.2,null,".02","Smooth formwork to side of concrete channels",null,"m2",10,null,{"$f":"G79*H79","v":0}]
["8,2,1",null,".03","Wooden Floating finishing ",null,"m2",45,null,{"$f":"G80*H80","v":0}]
[null,null,"BUILDING WORK "]
[null,null,"Supply and install listed items in accordance with relevant standard. Rates include full installation and sundry items."]
[null,null,"BD:  WALLS"]
["BD.01","5.2.8","Doors and windows : "]
[null,null,".01","Steel door frames:"]
[{"$nulls":3},".01","1,2 mm thick pressed steel door frame for door size 813 mm x 2 032 mm high suitable for 230 mm  thick wall ","number",1,null,{"$f":"G86*H86","v":0}]
[null,null,".02","Security Screen and Gates:"]
[{"$nulls":3},".01","Galvanised Security Screen; inclusive of 2 x lockable standard size single gates (813 mm wide x 2032mm) to open 180 deg","number",1,null,{"$f":"G88*H88","v":0}]
[null,null,".03","Steel window frames"]
[{"$nulls":3},".01","Steel small payne window, opening outwards,Type NE 2,window size 1022mm wide x 654mm, Galvanised, Including standard brass fittings and 4mm clear float glassobscured glass","number",2,null,{"$f":"G90*H90","v":0}]
["BD.03","5.2.9","Joinery:"]
[null,null,".01","Items measured by number:"]
["BD.03",null,null,".01","Type E - 2032 x 813 x 44mm Hollow core hardwood panel door with commercial veneer finish","number",1,null,{"$f":"G93*H93","v":0}]
[{"$nulls":3},".02","Type F - 1550 x 610 x 44mm Hollow core hardwood panel toilet door with commercial veneer finish","number",8,null,0]
["BD.04","5.2.10","Ironmongery, steelwork, glass, wall finishings, etc:"]
[null,null,".01","Items measured by number:"]
[{"$nulls":3},".01","Solid Art 390/13 4 Lever Mortice Lockset and satin chrome plated handles (Internal Doors)","number",9,null,0]
[{"$nulls":3},".02","38mm Diameter Door stop plugged and screwed to floor with 50mm long brass screw","number",9,null,0]
[{"$nulls":3},".03","Stainless steel mirror, 300mm x 400mm Manufactured from 18/10 1 mm flat stainless steel with high polis finish and with 4 drillings for no. 8 mirror screw; Franke item no CRH 401 or similar","number",6,null,0]
[{"$nulls":3},".04","Soap dispenser, surface mounted, manufactured from 18/10 1.2mm stainless steel, satin finish with cylinder lock, Franke item no STRX 618 or similar ","number",6,null,0]
[{"$nulls":3},".05","Toilet Roll holder, Surface mounted, manufactured from 18/10 stainless steel, satin finish with cylinder lock, Franke item STRX 671 or similar ","number",6,null,0]
[{"$nulls":3},".06","Paper towel dispenser, Surface mounted, manufactured from 18/10 1.2mm Stainless steel, satin finish with cylinder lock; Franke items no STRX 600 or similar ","number",4,null,0]
[{"$nulls":3},".07","150mm Natural Anodized Aluminium female sign type B2313 or similar approved ","number",2,null,0]
[{"$nulls":3},".08","150mm Natural Anodized Aluminium female sign type B2314 or similar approved ","number",2,null,0]
[{"$nulls":3},".09","200x300 Glass Brick or Similar approved","number",8,null,0]
[{"$nulls":3},".10","200x300 Ventilation / Airbrick or Similar approved","number",8,null,0]
[null,null,".02","Items measured by linear meter:"]
[{"$nulls":3},".01","2x110mm wide pre cast lintel","m",20,null,0]
[{"$nulls":3},".02","External window cills - Roller course face brick set at an angle of 15 degrees; 375 micron embossed DPC below cill","m",3,null,0]
[{"$nulls":3},".03","Internal window cills - Everite Nutec fibre cement (Product no 031-509) complete with fixing lugs and selg tapping screws","m",3,null,0]
[{"$nulls":3},".04","External cement plaster in beam filling","m",15,null,0]
["BD03",null,null,".05","Brickwork Reinforcement - 75mm (galvanized)","m",250,null,{"$f":"G112*H112","v":0}]
[{"$nulls":3},".06","Brickwork Reinforcement - 150mm (galvanized)","m",500,null,{"$f":"G113*H113","v":0}]
[null,null,".03","Items measured by area:"]
[{"$nulls":3},".01","6mm thick white glazed wall tiles to existing painted or plastered walls as approved by the Engineer","m2",15,null,0]
[{"$nulls":3},".02","230 mm thick Stock brick walls - NFP type brick","m2",75,null,{"$f":"G116*H116","v":0}]
[{"$nulls":3},".03","110 mm thick Slock brick walls - NFP type brick","m2",25,null,0]
[{"$nulls":3},".04","Extra over 230mm thick brick walls for face brick walls; Corobrik FBA walls (\"Roan Satin\") in stretcher bond with ruled joints and perpends","m2",65,null,0]
[{"$nulls":3},".05","230mm thick face brick walls; Corobrik FBA walls (\"Roan Satin\") in stretcher bond with ruled joints and perpends","m2",10,null,{"$f":"G119*H119","v":0}]
[{"$nulls":3},".06","Internal cement plaster to walls","m2",85,null,{"$f":"G120*H120","v":0}]
[null,null,"BE:  FLOORS"]
["BE.01","5.2.11","Floor screeds:"]
[null,null,".01","30 mm thick smooth screed finish",null,"m2",70,null,{"$f":"G123*H123","v":0}]
["BE.02","5.2.12","Joinery:"]
[null,null,".01","Items measured by linear meter:"]
[{"$nulls":3},".01","19 mm x 76 mm hardwood skirting with quadrant bead","m",50,null,{"$f":"G126*H126","v":0}]
["BE.03","5.2.13","Floor tiling and finishes, etc:"]
[null,null,".01","Items measured by area:"]
[{"$nulls":3},".01","250 micron damp proofing under solid floors / surface beds","m2",{"$f":"G123","v":70},null,{"$f":"G129*H129","v":0}]
[{"$nulls":3},".02","Vinyl Floor Tiling or similar approved ","m2",0,null,{"$f":"G130*H130","v":0}]
[{"$nulls":4},"FloorworX Superflex fully flexible vinyl floor sheeting 1,2m wide x 2mm thick in similar colour finish, manufactured in accordance with SANS 786:2000, laid in FloorworX No. 60 Plus acrylic adhesive spread with a notched trowel on suitably prepared subfloor (elsewhere specified) with a hygrometer reading showing a moisture content of less than 70%, with joints welded with a fully flexible coloured 'Marley Welding Rod' to provide a smooth, hygienic sealed finish and rolled with 68kg three section metal roller on completion. Upon completion, floor to be sealed with three coats of FloorX Silk Matt."]
[null,null,"BJ: PAINT WORK"]
[null,null,"NEW UNPAINTED SURFACES"]
["BJ.02","5.2.14","Paint to various surfaces:"]
[null,null,".01","Plaster surfaces:"]
[{"$nulls":3},".01","Prepare and apply one coat professional plaster primer and two coats acrylic PVA paint suitable for washing with a mild detergent and with a mat finish. Provide 1 coat alcaline resistant 100% pure acrylic fillercoat. Spread rate 6m square per liter. "]
[{"$nulls":4},".01  Walls","m2",130,null,{"$f":"G137*H137","v":0}]
[null,null,".02","Steel surfaces:"]
[{"$nulls":3},".01","Prepare surfaces, apply spot primer, one undercoat and two coats non-drip polyurethane, semi gloss, enamel paint:"]
[{"$nulls":4},".01 Window burglar proofing or mentis expanded metal grid to steel frame in burglar proofing","m2",2,null,{"$f":"G140*H140","v":0}]
[{"$nulls":4},".02 Door Frames (including Primer)","m3",2,null,{"$f":"G141*H141","v":0}]
[{"$nulls":4},".03 Security gates (Including Primer)","m2",4,null,{"$f":"G142*H142","v":0}]
["BJ.02","5.2.15",".01",".01",".01Rails, Posts, Pipes, steel structures etc. exceeding 50 mm dia not exceeding 110 mm diameter","m",20,null,{"$f":"G143*H143","v":0}]
[{"$nulls":4},".02 Steel structures (Roof) - If required.","m2",40,null,0]
[null,null,".02","Wood surfaces:"]
[{"$nulls":3},".01","Protective and decorative solvent based polyurethane alkyd semi-gloss non-drip enamel paint: (Inside)"]
[{"$nulls":4},".01  Doors","m2",45,null,0]
[{"$nulls":4},".02  Skirtings and quadrant beads not exceeding 150 mm girth","m",40,null,0]
[null,null,"BB:  CARPENTRY FOR ROOFS"]
["BB.01","5.2.16","Supply and install new items measured by length:"]
[null,null,".01","225 x 10 mm Thick Nutec pressed fibre cement fascia or similar approved (including painting, etc)",null,"m",15,null,0]
[null,null,".02","275 x 80 mm Thick Nutec fibre cement barge board, or similar approved (including painting, etc).",null,"m",12,null,0]
[null,null,".03","75 x 50 mm SAP purlins",null,"m",40,null,0]
[null,null,".04","Design, supply and install Wrought sloping SAP trusses for administration building complete according to drawing 2424 - G015(including painting with creaosote and wall plate)",null,"Sum",1,null,0]
["BB.08","5.2.17","Painting of existing members in overhangs:"]
[null,null,".01","Members with creosote (min 2 coats)",null,"m",30,null,0]
["TOTAL STRUCTURAL AND BUILDING",{"$nulls":7},{"$f":"SUM(I39:I156)","v":{"v":10077.5,"d":"10,077.50"}}]
["SCHEDULE NO 5.3 :",null,"PLUMBING, DRAINAGE, SEWER AND BULK WATER"]
["PAA.05","5.3.1","Supply and installation of sanitary ware and brassware:"]
[null,null,".01","Water closets:"]
[{"$nulls":3},".01","360mm x 405mm high Vitreous china WC washdown pan with enlarged pedestal.","number",8,null,{"$f":"G161*H161","v":0}]
[{"$nulls":3},".02","Vitreous china WC cistern - white 9 liters complete with lid and fitments","number",8,null,{"$f":"G162*H162","v":0}]
[{"$nulls":3},".03","100 mm ø PVC pan connector","number",8,null,0]
[{"$nulls":3},".04","15 mm ø CP ball-o-stop valve with CP flexi tail pipe to WC cistern","number",8,null,0]
[{"$nulls":3},".05","Heavy duty white buckalite type toilet seat and cover with CP hinge and spindle","number",8,null,0]
[null,null,".02","Wash hand basins:"]
[{"$nulls":3},".01","Vitreous china 520 x 415mm rounded wall mounted  wash hand basin - white","number",6,null,{"$f":"G167*H167","v":0}]
[{"$nulls":3},".02","Flexi rubber P-trap","number",12,null,0]
[{"$nulls":3},".03","15 mm ø CP pillar taps SABS 226 Type 1 (BS 5412), JASWIC Listed","number",12,null,0]
[{"$nulls":3},".04","15 mm ø flexi pipe tailpipe connections  to pillar taps including 15mm CP ball-o-stop valve","number",12,null,0]
[null,null,".03","Urinal"]
[{"$nulls":3},".01","Vitreous chine wall hung urinal with top inlet including fittings.","number",0,null,0,null,"kan ook plastic"]
[{"$nulls":3},".02","3/4\" 'Flushmaster Junior' Urinal Flush valve, CP, exposed type with integral ball-o-stop valve and wall plate","number",0,null,0]
[{"$nulls":3},".03","Bottle trap with 75mm deep re-seal and adjustable telescopic pipe.","number",0,null,0]
["PAA.06","5.3.2","Installation of above ground sanitary drainage piping system:"]
[null,null,".01","uPVC soil and waste pipes:"]
[{"$nulls":3},".01","110 mm ø pipe fixed to walls and soffits","m",60,null,{"$f":"G177*H177","v":0}]
[null,null,".02","uPVC soil and waste pipe fittings:"]
[{"$nulls":3},".01","110 mm dia plain bend 87.5º ","number",40,null,0]
[{"$nulls":3},".04","110 mm dia access bend 135º","number",8,null,0]
[{"$nulls":3},".05","110 mm junction plain 87.5º","number",8,null,0]
[{"$nulls":3},".06","110 mm junction access heel 87.5º","number",16,null,0]
["PAA.06","5.3.3","Supply and installation of underground sanitary drainage pipes:"]
[null,null,".01","Pipe trench excavations, bedding and backfilling:"]
[{"$nulls":3},".01","Excavate in all materials for pipe trenches to depth of 1100 mm x 600 mm wide","m³",35,null,{"$f":"G185*H185","v":0}]
[{"$nulls":3},".02","Supply and installation of pipe bedding 400mm thick river sand","m³",15,null,{"$f":"G186*H186","v":0}]
[{"$nulls":3},".03","Backfilling and compacting to 93% modified AASTHO density with selected material","m³",15,null,{"$f":"G187*H187","v":0}]
[null,null,".02","PVC-U Solid wall sewer pipes Class 34 - 300 KPA to SABS 791 specifications"]
[{"$nulls":3},".01"," 160 mm dia","m",50,null,{"$f":"G189*H189","v":0}]
[null,null,".03","Cleaning eyes:"]
[{"$nulls":3},".01","160 mm ø inline cleaning eye, constructed complete with Square inspection eye cast iron cover and frame Type 14A (SANS 558) daylight opening size 295 x 295mm and 500 x 500 x 75mm thick concrete encasement","number",3,null,0]
["PAA.07","5.3.4","Supply and installation of domestic water piping installation:"]
[null,null,".01","Copper piping Class 0 SABS 460 with capillary soldered type joints for cold-water piping installed in voids inclusive of bracketing:"]
[{"$nulls":3},".01","22 mm ø including fittings ","m",15,null,{"$f":"G194*H194","v":0}]
[{"$nulls":3},".02","15 mm ø including fittings ","m",15,null,0]
[null,null,".04","Supply and installation of Class 6 pressure HDPE piping, including fittings, jointing and testing:"]
[{"$nulls":3},".01","20 mm ø HDPE pipe, including fittings","m",50,null,0]
[null,null,".05","Replace 20 mm ø shut-off ball-o-stop valve",null,"number",2,null,0]
[null,"5.3.5","Manhole covers and grid inlets:"]
["CF.01.04.02",null,".01","Manholes and inspection chambers"]
[{"$nulls":3},".01","New pre-cast concrete manhole up to 1.2m deep, including pre-cast cover and frame","number",2,null,{"$f":"G201*H201","v":0}]
[{"$nulls":3},".02","New pre-cast concrete manhole from 1.2m up to 2.4m deep, including pre-cast cover and frame","number",2,null,{"$f":"G202*H202","v":0}]
["1200 DA"]
[8.3,"5.3.6","SCHEDULED ITEMS (French Drain / Soakaway)"]
["PAA.06",null,".01","Complete installation PVC-U Slotted subsoil drainage pipes complete with integral sockets"]
[{"$nulls":3},".01"," 110 mm dia","m",50,null,{"$f":"G206*H206","v":0}]
[null,null,"BULK WATER AND EXTERNAL WATER RETICULATION"]
["SANS 1200DB",null,"EXCAVATIONS"]
["8.3.2(a)","5.3.7","Excavate in all materials for trenches, backfill, compact, and dispose of surplus/ unsuitable material, for the following pipe diameters for total trench depths:"]
[null,null,".01","Not exceeding 1m deep x 600mm wide",null,"m",40,null,{"$f":"G210*H210","v":0}]
["8.3.2(b)",null,".02","Extra-over item .01 above for:"]
[{"$nulls":3},".01","Intermediate Excavation","m3",10,null,{"$f":"G212*H212","v":0}]
[{"$nulls":3},".02","Hard rock excavation","m3",0,null,{"$f":"G213*H213","v":0}]
["1200LB ","5.3.8","Provision of bedding from trench excavations"]
["8.2.1",null,".01","300mm x 600mm bedding",null,"m3",5,null,{"$f":"G215*H215","v":0}]
[null,null,"PIPES AND FITTINGS"]
["1200L","5.3.9","Connection to existing water network"]
["2.6.1",null,"Supply all labour and material to connect to main supply pipeline including excavation backfill, disposal of surplus material, cutting of pipes and moving of fittings and making good",null,null,"Sum",1,null,{"$f":"G218*H218","v":0}]
["1200L     8.2.1","5.3.10","Supply, lay and bed pipes complete with couplings, including testing"]
["PAA.07",null,".01",".01","20mm dia.. HDPE pipe Class 10, jointed with Plasson high compression fittings (Domestic Installation)","m",30]
[{"$nulls":3},".02","32mm dia.. HDPE pipe Class 10, jointed with Plasson high compression fittings","m",20,null,{"$f":"G221*H221","v":0}]
["1200L     8.2.1",null,null,".03","50mm dia.. HDPE pipe Class 10, jointed with Plasson high compression fittings","m",30,null,{"$f":"G222*H222","v":0}]
["TOTAL PLUMBING, DRAINAGE, SEWER AND BULK WATER ","TOTAL PLUMBING  AND DRAINAGE",{"$nulls":6},{"$f":"SUM(I161:I222)","v":0}]
[]
["SUMMARY OF SCHEDULE OF QUANTITIES: MHLWAZINI HIGH SCHOOL - ABLUTION BLOCK (GIRLS)",{"$nulls":7},"AMOUNT"]
["SCHEDULE 5.1",{"$nulls":3},"PRELIMINARY AND GENERAL",{"$nulls":3},{"$f":"I33","v":{"v":20000,"d":"20,000.00"}}]
["SCHEDULE  5.2",{"$nulls":3},"STRUCTURAL AND BUILDING",{"$nulls":3},{"$f":"I157","v":{"v":10077.5,"d":"10,077.50"}}]
["SCHEDULE  5.3",{"$nulls":3},"PLUMBING, DRAINAGE, SEWER AND BULK WATER",{"$nulls":3},{"$f":"I223","v":0}]
["SUB TOTAL A: ABLUTION BLOCK GIRLS (carry to summary page)",{"$nulls":7},{"$f":"SUM(I226:I228)","v":{"v":30077.5,"d":"30,077.50"}}]

{"sheet":"SCH3","index":5,"n_rows":106,"n_cols":9,"rows_kept":106,"hidden":true,"merged":[[0,2,0,8],[1,2,1,4],[2,2,2,4],[3,2,3,4],[4,3,4,4],[10,3,10,4],[15,3,15,4],[19,2,19,4],[20,3,20,4],[23,3,23,4],[36,2,36,4],[37,3,37,4],[43,0,43,7],[44,0,44,7],[45,3,45,4],[51,3,51,4],[53,2,53,4],[54,3,54,4],[57,3,57,4],[60,3,60,4],[63,3,63,4],[65,3,65,4],[66,2,66,4],[67,3,67,4],[68,2,68,4],[69,3,69,4],[72,2,72,4],[74,3,74,4],[75,2,75,4],[77,2,77,4],[78,3,78,4],[82,0,82,7],[83,0,83,7],[84,3,84,4],[85,3,85,4],[87,2,87,4],[88,2,88,4],[89,2,89,4],[90,3,90,4],[94,3,94,4],[96,2,96,4],[98,3,98,4],[99,2,99,4],[100,2,100,4],[101,3,101,4],[102,2,102,4],[105,0,105,7]]}
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
["PAYMENT REFERS TO","ITEM NO","DESCRIPTION",null,null,"UNIT","QUANTITY","RATE","AMOUNT"]
[null,{"v":3,"d":"3.00"},"PLUMBING AND DRAINAGE"]
["PAA.05",{"$f":"MAX($B$3:B3)+0.01","v":3.01},"Supply and installation of sanitary ware and brassware:"]
[null,null,".01","Water closets:"]
[{"$nulls":3},".01","360mm x 405mm high Vitreous china WC washdown pan with enlarged pedestal.","number",5]
[{"$nulls":3},".02","Vitreous china WC cistern - white 9 liters complete with lid and fitments","number",5]
[{"$nulls":3},".03","100 mm ø PVC pan connector","number",5]
[{"$nulls":3},".04","15 mm ø CP ball-o-stop valve with CP flexi tail pipe to WC cistern","number",5]
[{"$nulls":3},".05","Heavy duty white buckalite type toilet seat and cover with CP hinge and spindle","number",5]
[null,null,".02","Wash hand basins:"]
[{"$nulls":3},".01","Vitreous china 520 x 415mm rounded wall mounted  wash hand basin - white","number",7]
[{"$nulls":3},".02","Flexi rubber P-trap","number",7]
[{"$nulls":3},".03","15 mm ø CP pillar taps SABS 226 Type 1 (BS 5412), JASWIC Listed","number",7]
[{"$nulls":3},".04","15 mm ø flexi pipe tailpipe connections  to pillar taps including 15mm CP ball-o-stop valve","number",7]
[null,null,".06","Urinal"]
[{"$nulls":3},".01","Vitreous chine wall hung urinal with top inlet including fittings.","number",2]
[{"$nulls":3},".02","3/4\" 'Flushmaster Junior' Urinal Flush valve, CP, exposed type with integral ball-o-stop valve and wall plate","number",2]
[{"$nulls":3},".03","Bottle trap with 75mm deep re-seal and adjustable telescopic pipe.","number",2]
["PAA.06",{"$f":"MAX($B$4:B19)+0.01","v":{"v":3.0199999999999996,"d":"3.02"}},"Installation of above ground sanitary drainage piping system:"]
[null,null,".01","uPVC soil and waste pipes:"]
[{"$nulls":3},".01","50 mm ø pipe fixed to walls and soffits","m",20]
[{"$nulls":3},".02","110mm ø soil pipe fixed to walls and soffits","m",25]
[null,null,".02","uPVC soil and waste pipe fittings:"]
[{"$nulls":3},".01","50 mm dia plain bend 87.5º ","number",10]
[{"$nulls":3},".02","50 mm dia access bend 87.5º ","number",10]
[{"$nulls":3},".03","50mm dia plain bend 135º","number",2]
[{"$nulls":3},".04","50mm dia access bend 135º","number",2]
[{"$nulls":3},".05","50mm junction plain 87.5º","number",0]
[{"$nulls":3},".06","50mm junction access heel 87.5º","number",0]
[{"$nulls":3},".07","110mm dia plain bend 135º ","number",0]
[{"$nulls":3},".08","110mm dia access bend 135º","number",0]
[{"$nulls":3},".09","110mm dia access bend 95º","number",5]
[{"$nulls":3},".10","110mm dia plain bend 95º ","number",0]
[{"$nulls":3},".11","110mm vent horn bend access heel 95º","number",3]
[{"$nulls":3},".12","110mm junction single access heel 95º","number",3]
["PAA.06",{"$f":"MAX($B$4:B35)+0.01","v":{"v":3.0299999999999994,"d":"3.03"}},"Supply and installation of underground sanitary drainage pipes:"]
[null,null,".01","Pipe trench excavations, bedding and backfilling:",null,"m³",35]
[{"$nulls":3},".01","Excavate in all materials for pipe trenches to depth of 1100 mm x 600 mm wide"]
[{"$nulls":3},".02","Supply and installation of pipe bedding 400mm thick river sand","m³",15]
[{"$nulls":3},".03","Backfilling and compacting to 93% modified AASTHO density with selected material","m³",20]
[null,null,".02",null,"PVC-U Solid wall sewer pipes Class 34 - 300                          KPA to SABS 791 specifications"]
[{"$nulls":3},".01"," 110 mm dia","m",25]
["BALANCE CARRIED FORWARD"]
["BALANCE BROUGHT FORWARD"]
[null,null,".03","uPVC soil and waste pipe fittings "]
[{"$nulls":3},".01","110 mm ø plain bend 87,5°","number",0]
[{"$nulls":3},".02","110 mm ø plain bend 135°","number",4]
[{"$nulls":3},".03","110 mm ø square double junction","number",2]
[{"$nulls":3},".04","110 mm ø 135° junction ","number",3]
[{"$nulls":3},".05","110 mm ø 90° junction ","number",0]
[null,null,".04","Cleaning eyes:"]
[{"$nulls":3},".01","100 mm ø inline cleaning eye, constructed complete with Square inspection eye cast iron cover and frame Type 14A (SANS 558) daylight opening size 295 x 295mm and 500 x 500 x 75mm thick concrete encasement","number",5]
["PAA.07",{"$f":"MAX($B$4:B53)+0.01","v":{"v":3.039999999999999,"d":"3.04"}},"Supply and installation of domestic water piping installation:"]
[null,null,".01","Copper piping Class 0 SABS 460 with capillary soldered type joints for cold-water piping installed in voids inclusive of bracketing:"]
[{"$nulls":3},".01","22 mm ø including fittings ","m",35]
[{"$nulls":3},".02","15 mm ø including fittings ","m",14]
[null,null,".02","Copper piping Class 0 SABS 460 with capillary soldered type joints for hot-water piping installed in voids including bracketing, lagging and cladding:"]
[{"$nulls":3},".01","22 mm ø including fittings ","m",20]
[{"$nulls":3},".02","15 mm ø including fittings ","m",15]
[null,null,".03","Copper piping Class 0 SABS 460 with capillary soldered type joints for hot and cold-water piping chased in walls including wrapping of pipes with builders paper, chasing and reinstatement of chased surfaces:"]
[{"$nulls":3},".01","22 mm ø including fittings ","m",0]
[{"$nulls":3},".02","15 mm ø including fittings ","m",25]
[null,null,".04","Supply and installation of Class 6 pressure HDPE piping, including fittings, jointing and testing:"]
[{"$nulls":3},".01","20 mm ø HDPE pipe, including fittings","m",20]
[null,null,".05","Replace 20 mm ø shut-off ball-o-stop valve",null,"number",1]
["PAA.13",{"$f":"MAX($B$4:B66)+0.01","v":{"v":3.049999999999999,"d":"3.05"}},"Supply and Installation of geyser inclusive of element, thermostat, safety valve, vacuum breakers and all required pipe work and fittings for external vertical installation:"]
[null,null,".01","150 liter electric geyser",null,"number",1]
[null,{"$f":"MAX($B$4:B68)+0.01","v":{"v":3.0599999999999987,"d":"3.06"}},"Manhole covers and grid inlets:"]
["CF.01.04.02",null,".01","Manholes and inspection chambers"]
[{"$nulls":3},".01","New pre-cast concrete manhole up to 1.2m deep, including pre-cast cover and frame","number",1]
[{"$nulls":3},".02","New pre-cast concrete manhole from 1.2m up to 2.4m deep, including pre-cast cover and frame","number",1]
[null,{"$f":"MAX($B$4:B72)+0.01","v":{"v":3.0699999999999985,"d":"3.07"}},"Supply and install a prefabricated septic tank approved according to SANS 0400 - PP10 & 52566 , including excavation and backfilling with selected material and all necessary soil pipe connections"]
[null,null,".01","3600 liters septic tank system",null,"number",0]
[null,null,".02","5400 liters septic tank system",null,"number",1]
[null,null,"French drains constructed according to SANS 10400 - PP10 and DPW drawing 048182/006B"]
["1200 DA"]
[8.3,{"$f":"MAX($B$3:B77)+0.01","v":{"v":3.0799999999999983,"d":"3.08"}},"SCHEDULED ITEMS (French Drain)"]
["8.3.2",null,".01","Excavate trenches in all materials and use for backfill or embankment or dispose.",null,"m3",30]
[null,null,".02","Extra over item 01 above for:"]
[{"$nulls":3},".01","Intermediate excavation  ","m³",5]
[{"$nulls":3},".01","Hard rock excavation  ","m³",2]
["BALANCE CARRIED FORWARD"]
["BALANCE BROUGHT FORWARD"]
["8.3.4",null,".03","Importing and placing of approved \n65-125mm rock fill from commercial sources.",null,"m3",30]
["PAA.06",null,".04","PVC-U Slotted subsoil drainage pipes complete with integral sockets"]
[{"$nulls":3},".01"," 110 mm dia","m",30]
[null,{"$f":"302","v":{"v":302,"d":"302.00"}},"BULK WATER AND EXTERNAL WATER RETICULATION"]
["SANS 1200DB",null,"EXCAVATIONS"]
["8.3.2(a)",{"$f":"MAX($B$4:B89)+0.01","v":302.01},"Excavate in all materials for trenches, backfill, compact, and dispose of surplus/ unsuitable material, for the following pipe diameters for total trench depths:"]
[null,null,".01","Not exceeding 1m deep x 600mm wide",null,"m",60]
["8.3.2(b)",null,".02","Extra-over item .01 above for:"]
[{"$nulls":3},".01","Intermediate Excavation","m3",5]
[{"$nulls":3},".02","Hard rock excavation","m3",2]
["8.3.3",null,".03","Excavation ancillaries"]
["8.3.3.3",null,null,".01","Compaction in road reserves","m3"]
["SANS 1200LB ",{"$f":"MAX($B$4:B90)+0.01","v":302.02},"Provision of bedding from trench excavations"]
["8.2.1"]
[null,null,".01","300mm x 600mm bedding",null,"m3",3]
[null,null,"PIPES AND FITTINGS"]
["SANS 1200L",{"$f":"MAX($B$4:B100)+0.01","v":302.03},"Connection to existing water network"]
["2.6.1",null,null,"Supply all labour and material to connect to main supply pipeline including excavation backfill, disposal of surplus material, cutting of pipes and moving of fittings and making good",null,"Sum"]
["SANS 1200 L     8.2.1",{"$f":"MAX($B$4:B102)+0.01","v":{"v":302.03999999999996,"d":"302.04"}},"Supply, lay and bed pipes complete with couplings, including testing"]
[null,null,".01",".01","32mm dia.. HDPE pipe Class 10, jointed with Plasson high compression fittings","m",40]
["SANS 1200 L     8.2.1",{"$f":"MAX($B$4:B104)+0","v":{"v":302.03999999999996,"d":"302.04"}},null,".02","63mm dia.. HDPE pipe Class 10, jointed with Plasson high compression fittings","m"]
["TOTAL BUILDING AND DRAINAGE","TOTAL PLUMBING  AND DRAINAGE"]

{"sheet":"SCH2.3","index":6,"n_rows":710,"n_cols":19,"rows_kept":710,"hidden":true,"merged":[[1,2,1,8],[5,2,5,4],[7,2,7,4],[9,2,9,4],[11,3,11,4],[13,3,13,4],[15,3,15,4],[17,3,17,4],[19,3,19,4],[21,3,21,4],[23,3,23,4],[25,3,25,4],[27,3,27,4],[29,2,29,4],[31,3,31,4],[33,3,33,4],[35,3,35,4],[37,3,37,4],[39,3,39,4],[41,3,41,4],[43,3,43,4],[45,2,45,4],[47,3,47,4],[49,3,49,4],[51,3,51,4],[60,2,60,4],[62,3,62,4],[64,2,64,4],[66,3,66,4],[68,2,68,4],[70,3,70,4],[72,2,72,4],[74,3,74,4],[75,3,75,4],[77,3,77,4],[78,3,78,4],[118,2,118,4],[120,2,120,4],[122,3,122,4],[124,3,124,4],[126,3,126,4],[128,3,128,4],[130,3,130,4],[131,2,131,4],[132,3,132,4],[134,3,134,4],[136,2,136,4],[138,2,138,4],[140,3,140,4],[142,3,142,4],[144,3,144,4],[146,3,146,4],[148,3,148,4],[150,3,150,4],[152,3,152,4],[154,3,154,4],[156,3,156,4],[158,3,158,4],[160,2,160,4],[162,3,162,4],[164,3,164,4],[173,3,173,4],[175,3,175,4],[177,3,177,4],[179,3,179,4],[181,3,181,4],[183,3,183,4],[185,3,185,4],[187,3,187,4],[189,3,189,4],[191,3,191,4],[193,3,193,4],[195,2,195,4],[197,3,197,4],[199,3,199,4],[201,3,201,4],[203,3,203,4],[205,3,205,4],[207,3,207,4],[209,3,209,4],[211,3,211,4],[213,3,213,4],[215,3,215,4],[217,3,217,4],[219,3,219,4],[228,3,228,4],[229,3,229,4],[230,3,230,4],[231,3,231,4],[233,3,233,4],[235,3,235,4],[237,3,237,4],[239,3,239,4],[241,2,241,4],[243,3,243,4],[245,3,245,4],[247,3,247,4],[249,3,249,4],[251,3,251,4],[253,2,253,4],[255,3,255,4],[257,3,257,4],[259,3,259,4],[261,2,261,4],[263,3,263,4],[265,2,265,4],[267,2,267,4],[269,3,269,4],[271,3,271,4],[273,3,273,4],[275,3,275,4],[277,3,277,4],[285,2,285,4],[287,3,287,4],[289,2,289,4],[291,2,291,4],[293,2,293,4],[295,3,295,4],[297,3,297,4],[299,3,299,4],[301,2,301,4],[303,3,303,4],[305,3,305,4],[307,3,307,4],[309,3,309,4],[311,2,311,4],[313,3,313,4],[315,3,315,4],[317,2,317,4],[319,3,319,4],[321,3,321,4],[323,3,323,4],[325,3,325,4],[339,2,339,4],[341,3,341,4],[343,3,343,4],[345,2,345,4],[347,2,347,4],[349,3,349,4],[351,3,351,4],[353,2,353,4],[355,3,355,4],[357,3,357,4],[359,3,359,4],[361,3,361,4],[363,3,363,4],[365,3,365,4],[367,2,367,4],[369,3,369,4],[371,3,371,4],[381,2,381,4],[383,2,383,4],[391,2,391,4],[393,2,393,4],[395,3,395,4],[397,3,397,4],[399,3,399,4],[401,2,401,4],[403,3,403,4],[405,3,405,4],[411,3,411,4],[416,3,416,4],[418,3,418,4],[420,3,420,4],[422,2,422,4],[424,3,424,4],[426,2,426,4],[428,3,428,4],[430,3,430,4],[432,3,432,4],[434,3,434,4],[453,2,453,4],[455,2,455,4],[457,2,457,4],[459,2,459,4],[461,2,461,4],[463,3,463,4],[465,2,465,4],[467,2,467,4],[469,2,469,4],[471,2,471,4],[473,2,473,4],[484,2,484,4],[486,3,486,4],[489,3,489,4],[491,3,491,4],[499,2,499,4],[501,2,501,4],[503,2,503,4],[505,2,505,4],[507,3,507,4],[509,3,509,4],[511,3,511,4],[513,3,513,4],[515,3,515,4],[517,3,517,4],[519,3,519,4],[521,3,521,4],[523,3,523,4],[525,2,525,4],[527,3,527,4],[529,3,529,4],[531,3,531,4],[533,3,533,4],[535,3,535,4],[537,3,537,4],[539,3,539,4],[541,3,541,4],[543,3,543,4],[553,2,553,4],[555,3,555,4],[557,3,557,4],[559,3,559,4],[561,3,561,4],[563,3,563,4],[565,3,565,4],[567,3,567,4],[569,3,569,4],[571,3,571,4],[573,2,573,4],[575,3,575,4],[577,3,577,4],[579,3,579,4],[581,3,581,4],[583,3,583,4],[585,3,585,4],[587,3,587,4],[589,2,589,4],[591,3,591,4],[593,3,593,4],[595,3,595,4],[597,3,597,4],[609,3,609,4],[611,3,611,4],[613,3,613,4],[615,2,615,4],[617,3,617,4],[619,3,619,4],[621,2,621,4],[623,3,623,4],[625,3,625,4],[627,3,627,4],[629,3,629,4],[631,2,631,4],[633,3,633,4],[635,3,635,4],[637,3,637,4],[639,2,639,4],[641,3,641,4],[643,2,643,4],[645,2,645,4],[647,2,647,4],[649,2,649,4],[651,3,651,4],[653,3,653,4],[655,3,655,4],[663,2,663,4],[665,2,665,4],[667,2,667,4],[669,2,669,4],[671,2,671,4],[673,2,673,4],[675,2,675,4],[677,2,677,4],[679,2,679,4],[681,2,681,4],[683,3,683,4],[685,2,685,4],[686,2,686,4],[687,2,687,4],[688,2,688,4],[690,2,690,4],[701,2,701,4]]}
[]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
["PAYMENT REFERS TO","ITEM NO","DESCRIPTION",null,null,"UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,null,"BUILDING ELECTRICAL REPAIR WORK",{"$nulls":7},{"$f":"IF($G6=\"\",\"\",$G6*J6)","v":""}]
[{"$nulls":10},""]
[null,{"v":3,"d":"3.00"},"DISTRIBUTION BOARDS",{"$nulls":7},""]
[{"$nulls":10},""]
["AB.01.01",{"$f":"MAX($B$5:B9)+0.01","v":3.01},"Service distribution board",{"$nulls":7},""]
[{"$nulls":10},""]
[null,null,".01","Floorstanding DB Gen Room                ",null,"number",{"$nulls":4},{"$f":"IF($G12=\"\",\"\",$G12*J12)","v":""}]
[{"$nulls":10},""]
[null,null,".02","Surface Mounted DB Police Building                ",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".03","Surface Mounted DB Customs Building                ",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".04","Surface Mounted DB OPS building Derdepoort              ",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".05","Surface Mounted DB OPS Building Swartkopfontein                ",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".06","Flush mounted DB (+/- 400 x 200mm)",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".07","Flush mounted DB (+/- 200 x 200mm)",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".08","Domestic single phase(+/- 500 x 400mm) ",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".09","Domestic single phase(+/- 250 x 400mm) ",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
["AB.01.13",{"$f":"MAX($B$5:B28)+0.01","v":{"v":3.0199999999999996,"d":"3.02"}},"Supply and installation of circuit breakers  (SABS approved)",{"$nulls":7},""]
[{"$nulls":10},""]
[null,null,".01","10-40A, 6kA single pole",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".02","40-60A, 6kA single pole",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".03","10-40A, 6kA double pole",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".04","10-40A, 6kA tripple pole",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".05","40-80A, 6kA tripple pole",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".06","80-100A 15kA triple pole",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".07","100-160A 15kA triple pole",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
["AB.01.14",{"$f":"MAX($B$5:B44)+0.01","v":{"v":3.0299999999999994,"d":"3.03"}},"Supply and installation of isolators (SABS approved)",{"$nulls":7},""]
[{"$nulls":10},""]
[null,null,".01","20-40A, 6kA double pole",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".02","60A, 6kA double pole",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".03","60A, 6kA tripple pole",null,"number",{"$nulls":4},""]
[]
[]
[null,"Carried forward",{"$nulls":8},{"$f":"SUM(K5:K54)","v":{"v":0,"d":"0.00"}}]
[]
[]
[null,"Brought forward",{"$nulls":8},{"$f":"K55","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":10},{"$f":"IF($G60=\"\",\"\",$G60*J60)","v":""}]
["AB.01.15",{"$f":"MAX($B$5:B60)+0.01","v":{"v":3.039999999999999,"d":"3.04"}},"Supply and install contactors",{"$nulls":7},""]
[{"$nulls":10},""]
[null,null,".01","30A, 3 pole",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
["AB.01.16",{"$f":"MAX($B$5:B64)+0.01","v":{"v":3.049999999999999,"d":"3.05"}},"Supply and install switching timers",{"$nulls":7},""]
[{"$nulls":10},""]
[null,null,".01","Electronic timer with 24hr time reserve",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
["AB.01.17",{"$f":"MAX($B$5:B68)+0.01","v":{"v":3.0599999999999987,"d":"3.06"}},"Supply and install earth leakage units (SABS approved)",{"$nulls":7},""]
[{"$nulls":10},""]
[null,null,".01","60A, 5kA double pole",null,"number",{"$nulls":4},""]
[]
["AB.01.19",{"$f":"MAX($B$5:B69)+0.01","v":{"v":3.0699999999999985,"d":"3.07"}},"Supply and install surge arrestors",{"$nulls":7},{"$f":"IF($G73=\"\",\"\",$G73*J73)","v":""}]
[{"$nulls":10},""]
[null,null,".01","1 Pole and Neutral 275V 5kA with Indication",{"$nulls":6},""]
[{"$nulls":3},"with indication",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".02","3 Pole and Neutral 275V 5kA with Indication",{"$nulls":6},""]
[{"$nulls":3},"with indication",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
["AB.01.11",{"$f":"MAX($B$5:B77)+0.01","v":{"v":3.0799999999999983,"d":"3.08"}},"Supply and install earth continuity ",{"$nulls":7},""]
[null,null,"conductor:",{"$nulls":7},""]
[{"$nulls":10},""]
[null,null,".01","70 mm² BCEW",null,"m",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".02","16 mm² BCEW",null,"m",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".03","10 mm² BCEW",null,"m",{"$nulls":4},""]
[]
[null,null,".04","50 mm² aluminium",null,"m",{"$nulls":4},{"$f":"IF($G90=\"\",\"\",$G90*J90)","v":""}]
[]
["AB.01.12",{"$f":"MAX($B$5:B88)+0.01","v":{"v":3.089999999999998,"d":"3.09"}},"Terminate earth continuity conductor:",{"$nulls":7},{"$f":"IF($G92=\"\",\"\",$G92*J92)","v":""}]
[{"$nulls":10},""]
[null,null,".01","70 mm² BCEW",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".02","16 mm² BCEW",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".03","10 mm² BCEW",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".04","50 mm² aluminium",null,"number",{"$nulls":4},""]
{"$rows_empty":11}
[null,"Carried forward",{"$nulls":8},{"$f":"SUM(K58:K111)","v":{"v":0,"d":"0.00"}}]
[]
[]
[null,"Brought forward",{"$nulls":8},{"$f":"K112","v":{"v":0,"d":"0.00"}}]
[]
[]
[{"$nulls":10},{"$f":"IF($G118=\"\",\"\",$G118*J118)","v":""}]
[null,{"$f":"B8+2","v":{"v":5,"d":"5.00"}},"WIRING",{"$nulls":7},""]
[{"$nulls":10},""]
["AB01.04",{"$f":"MAX($B$5:B120)+0.01","v":5.01},"Replace wiring :",{"$nulls":7},""]
[{"$nulls":10},""]
[null,null,".01","2,5 mm² PVC insulated",null,"meter",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".02","4 mm² PVC insulated",null,"meter",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".03","6 mm² PVC insulated",null,"meter",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".04","10 mm² PVC insulated",null,"meter",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".05","2,5 mm² BCEW",null,"meter",{"$nulls":4},""]
[]
[null,null,".06","4 mm² BCEW ",null,"meter",{"$nulls":4},{"$f":"IF($G133=\"\",\"\",$G133*J133)","v":""}]
[{"$nulls":10},""]
[null,null,".07","6mm² BCEW",null,"meter",{"$nulls":4},""]
[{"$nulls":10},""]
[null,{"v":403,"d":"403.00"},"LIGHTING INSTALLATION",{"$nulls":7},""]
[{"$nulls":10},""]
["AB.02.01",{"$f":"MAX($B$5:B138)+0.01","v":403.01},"Re-lamp luminaire",{"$nulls":7},""]
[{"$nulls":10},""]
[null,null,".01","58W Fluorescent",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".02","36W Fluorescent",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".03","18W Fluorescent",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".04","80W MV Lamp",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".05","150W HPS Lamp",null,"number",{"$nulls":4},""]
[]
[null,null,".06","70W HPS Lamp",null,"number",{"$nulls":4},{"$f":"IF($G151=\"\",\"\",$G151*J151)","v":""}]
[{"$nulls":10},""]
[null,null,".07","PL9 W",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".08","16W/E27",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".09","400W MV Lamp",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".10","100W GLS Lamp",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
["AB.02.02",{"$f":"MAX($B$5:B160)+0.01","v":403.02},"Service luminaire",{"$nulls":7},""]
[{"$nulls":10},""]
[null,null,".01","Type A",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".02","Type B",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[]
[null,"Carried forward",{"$nulls":8},{"$f":"SUM(K115:K167)","v":{"v":0,"d":"0.00"}}]
[]
[]
[null,"Brought forward",{"$nulls":8},{"$f":"K168","v":{"v":0,"d":"0.00"}}]
[]
[]
["AB.02.02",{"$f":"MAX($B$5:B173)+0","v":403.02},".03","Type D",null,"number",{"$nulls":4},{"$f":"IF($G174=\"\",\"\",$G174*J174)","v":""}]
[{"$nulls":10},""]
[null,null,".04","Type H",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".05","Type I",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".06","Type K",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".07","Type R",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".08","Type T",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".09","Type U",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".10","Type W",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".11","Type X",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".12","Type Y",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".13","Type AA",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
["AB.02.03",{"$f":"MAX($B$5:B175)+0.01","v":403.03},"Replace luminaire",{"$nulls":7},""]
[{"$nulls":10},""]
[null,null,".01","Type A",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".02","Type B",null,"number",{"$nulls":4},""]
[]
[null,null,".03","Type C",null,"number",{"$nulls":4},{"$f":"IF($G202=\"\",\"\",$G202*J202)","v":""}]
[{"$nulls":10},""]
[null,null,".04","Type D",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".05","Type E",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".06","Type F",null,"number",{"$nulls":4},""]
[]
[null,null,".07","Type G",null,"number",{"$nulls":4},{"$f":"IF($G210=\"\",\"\",$G210*J210)","v":""}]
[]
[null,null,".08","Type H",null,"number",{"$nulls":4},{"$f":"IF($G212=\"\",\"\",$G212*J212)","v":""}]
[]
[null,null,".09","Type J",null,"number",{"$nulls":4},{"$f":"IF($G214=\"\",\"\",$G214*J214)","v":""}]
[]
[null,null,".10","Type K",null,"number",{"$nulls":4},{"$f":"IF($G216=\"\",\"\",$G216*J216)","v":""}]
[]
[null,null,".11","Type S",null,"number",{"$nulls":4},{"$f":"IF($G218=\"\",\"\",$G218*J218)","v":""}]
[{"$nulls":10},{"$f":"IF($G219=\"\",\"\",$G219*J219)","v":""}]
[null,null,".12","Type T",null,"number",{"$nulls":4},{"$f":"IF($G220=\"\",\"\",$G220*J220)","v":""}]
[]
[{"$nulls":10},{"$f":"IF($G222=\"\",\"\",$G222*J222)","v":""}]
[]
[null,"Carried forward",{"$nulls":8},{"$f":"SUM(K171:K223)","v":{"v":0,"d":"0.00"}}]
[]
[]
[null,"Brought forward",{"$nulls":8},{"$f":"K224","v":{"v":0,"d":"0.00"}}]
[]
[]
["AB.02.03",{"$f":"MAX($B$5:B204)+0","v":403.03},".13","Type U",null,"number",{"$nulls":4},{"$f":"IF($G230=\"\",\"\",$G230*J230)","v":""}]
[{"$nulls":10},""]
[null,null,".14","Type V",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".15","Type W",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".16","Type X",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".17","Type Z",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".18","Type AA",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
["AB.02.06",{"$f":"MAX($B$5:B241)+0.01","v":{"v":403.03999999999996,"d":"403.04"}},"Replace luminaire diffuser or lens",{"$nulls":7},""]
[{"$nulls":10},""]
[null,null,".01","Type H",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".02","Type K",null,"number",{"$nulls":4},""]
[]
[null,null,".03","Type T",null,"number",{"$nulls":4},{"$f":"IF($G248=\"\",\"\",$G248*J248)","v":""}]
[{"$nulls":10},""]
[null,null,".04","Type U",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".05","Type V",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
["AB.02.10",{"$f":"MAX($B$5:B249)+0.01","v":{"v":403.04999999999995,"d":"403.05"}},"Supply and installation of internal  luminaire components :"]
[{"$nulls":10},{"$f":"IF($G255=\"\",\"\",$G255*J255)","v":""}]
[null,null,".01","Choke for 36W Fluorescent",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".02","Choke for 58W Fluorescent",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".03","Fluorescent starter",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
["AB.02.08",{"$f":"MAX($B$5:B259)+0.01","v":{"v":403.05999999999995,"d":"403.06"}},"Ceiling replacement:",{"$nulls":7},""]
[{"$nulls":10},""]
[null,null,".01","Luminaire removal and reinstallation",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
["AB.02.07",{"$f":"MAX($B$5:B263)+0.01","v":{"v":403.06999999999994,"d":"403.07"}},"Service light switch",null,null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
["AB.02.04",{"$f":"MAX($B$5:B267)+0.01","v":{"v":403.0799999999999,"d":"403.08"}},"Replace light switch",{"$nulls":7},""]
[{"$nulls":10},""]
[null,null,".01","16A, one lever, one way",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".02","16A, two lever, one way",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".03","16A, three lever, one way",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".04","16A, one lever, two way",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".05","16A water tight, robust ",null,"number",{"$nulls":4},""]
[]
[null,"Carried forward",{"$nulls":8},{"$f":"SUM(K227:K279)","v":{"v":0,"d":"0.00"}}]
[]
[]
[null,"Brought forward",{"$nulls":8},{"$f":"K280","v":{"v":0,"d":"0.00"}}]
[]
[]
["AB.02.05",{"$f":"MAX($B$5:B285)+0.01","v":{"v":403.0899999999999,"d":"403.09"}},"Replace Photo-electric switch",{"$nulls":7},{"$f":"IF($G286=\"\",\"\",$G286*J286)","v":""}]
[{"$nulls":10},""]
[null,null,".01","16A unit with bracket and mounted in dummy bulkhead fitting",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
["AB.02.09",{"$f":"MAX($B$5:B289)+0.01","v":{"v":403.0999999999999,"d":"403.10"}},"Replace lampholder (Ceramic)",null,null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,{"$f":"B8+4","v":{"v":7,"d":"7.00"}},"POWER OUTLETS",{"$nulls":7},""]
[{"$nulls":10},""]
["AB.03.07",{"$f":"MAX($B$5:B293)+0.01","v":{"v":403.1099999999999,"d":"403.11"}},"Service socket outlet",{"$nulls":7},""]
[{"$nulls":10},""]
[null,null,".01","16A, single SSO",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".02","16A, double SSO",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".03","16A, dedicated SSO",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
["AB.03.01",{"$f":"MAX($B$5:B301)+0.01","v":{"v":403.1199999999999,"d":"403.12"}},"Replace socket outlet"]
[]
[null,null,".01","16A, single SSO",null,"number",{"$nulls":4},{"$f":"IF($G304=\"\",\"\",$G304*J304)","v":""}]
[{"$nulls":10},""]
[null,null,".02","16A, double SSO",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".03","16A, single SSO  powerskirting mounted",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".04","16A, dedicated SSO  powerskirting mounted",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
["AB.03.08",{"$f":"MAX($B$5:B311)+0.01","v":{"v":403.1299999999999,"d":"403.13"}},"Service isolator",{"$nulls":7},""]
[{"$nulls":10},""]
[null,null,".01","60 A, 2 pole ",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".02","30A, 2 pole",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
["AB.03.02",{"$f":"MAX($B$5:B317)+0.01","v":{"v":403.1399999999999,"d":"403.14"}},"Replace isolators",{"$nulls":7},""]
[{"$nulls":10},""]
[null,null,".01","30A, 2 pole",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".02","30A 2 pole with cord grip",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".03","30A 2 pole in York box S15",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".04","60A 2pole",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[]
[]
[]
[]
[]
[]
[null,"Carried forward",{"$nulls":8},{"$f":"SUM(K283:K333)","v":{"v":0,"d":"0.00"}}]
[]
[]
[null,"Brought forward",{"$nulls":8},{"$f":"K334","v":{"v":0,"d":"0.00"}}]
[]
[]
["AB.03.03",{"$f":"MAX($B$5:B332)+0.01","v":{"v":403.14999999999986,"d":"403.15"}},"Replace plug tops:",{"$nulls":7},{"$f":"IF($G340=\"\",\"\",$G340*J340)","v":""}]
[{"$nulls":10},""]
[null,null,".01","3-pin 16A ",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".02","3-pin square 13A ",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,{"$f":"B8+5","v":{"v":8,"d":"8.00"}},"FIXED APPLIANCE AND COMPONENTS",{"$nulls":7},""]
[{"$nulls":10},""]
["AB.03.19",{"$f":"MAX($B$6:B347)+0.01","v":{"v":403.15999999999985,"d":"403.16"}},"Replace geyser components",{"$nulls":7},""]
[{"$nulls":10},""]
[null,null,".01","Replace domestic geyser element",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".02","Replace geyser thermostat",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
["AB.03.18",{"$f":"MAX($B$6:B353)+0.01","v":{"v":403.16999999999985,"d":"403.17"}},"Replace domestic stove components :",{"$nulls":7},""]
[{"$nulls":10},""]
[null,null,".01","150 - 160 dia solid plate",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".02","170 - 190 dia solid plate",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".03","200 - 220 dia solid plate",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".04","Five / six heat switch",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".05","Oven bottom element",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".06","Oven top element",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
["AB.03.06",{"$f":"MAX($B$6:B367)+0.01","v":{"v":403.17999999999984,"d":"403.18"}},"Replace connection from isolator to fixed appliance, with flexible copex (spraque) conduit and conductors, e.g. stove or geyser :",{"$nulls":7},""]
[{"$nulls":10},""]
[null,null,".01","Stove : 2 x 6 mm² PVC and 2,5 mm²  BCEW conductors.",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".02","Geyser : 2 x 4 mm² PVC and 2,5 mm² BCEW conductors.",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
{"$rows_empty":12}
[null,"Carried forward",{"$nulls":8},{"$f":"SUM(K337:K385)","v":{"v":0,"d":"0.00"}}]
[]
[]
[null,"Brought forward",{"$nulls":8},{"$f":"K386","v":{"v":0,"d":"0.00"}}]
[]
[]
[null,{"$f":"B8+6","v":{"v":9,"d":"9.00"}},"WIRE WAYS CONDUITS AND ACCESSORIES"]
[]
["AB.03.04",{"$f":"MAX($B$5:B393)+0.01","v":{"v":403.1899999999998,"d":"403.19"}},"Replace conduit :"]
[{"$nulls":10},{"$f":"IF($G395=\"\",\"\",$G395*J395)","v":""}]
[null,null,".01","20 mm dia Galv. Steel",null,"meter",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".02","25 mmdia Galv. Steel",null,"meter",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".03","32 mmdia Galv. Steel",null,"meter",{"$nulls":4},""]
[{"$nulls":10},""]
["AB.03.11",{"$f":"MAX($B$6:B401)+0.01","v":{"v":403.1999999999998,"d":"403.20"}},"Supply and install outlet (draw) boxes :",{"$nulls":7},""]
[{"$nulls":10},""]
[null,null,".01","100 x 50 Galv. Steel",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".02","100 x 100 Galv.Steel",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".03","50 x 100 mm white enamel extension box",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".04","100 x 100 mm white enamel extension box",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".05","Circular 20mm",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
["AB.03.12",{"$f":"MAX($B$6:B413)+0.01","v":{"v":403.2099999999998,"d":"403.21"}},"Supply and install draw box cover",{"$nulls":7},""]
[null,null,"plates(white enamel) to fit:",{"$nulls":7},""]
[]
[null,null,".01","To fit 100 x 50 box",null,"number",{"$nulls":4},{"$f":"IF($G417=\"\",\"\",$G417*J417)","v":""}]
[{"$nulls":10},""]
[null,null,".02","To fit 100 x 100 box",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".03","Circular galvanised box",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
["AB.03.09",{"$f":"MAX($B$6:B422)+0.01","v":{"v":403.2199999999998,"d":"403.22"}},"Replace power skirting :",{"$nulls":7},""]
[{"$nulls":10},""]
[null,null,".01","2-tier powder-coated galvanised steel",null,"m",{"$nulls":4},""]
[{"$nulls":10},""]
["AB.03.05",{"$f":"MAX($B$6:B426)+0.01","v":{"v":403.2299999999998,"d":"403.23"}},"Replace wiring channel:",{"$nulls":7},""]
[{"$nulls":10},""]
[null,null,".01","OL 2000, 41.3 x 41.3 mm",null,"m",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".02","OL 9000, 127 x 76 mm",null,"m",{"$nulls":4},""]
[]
[null,null,".03","White pvc 100 x 76 mm",null,"m",{"$nulls":4},{"$f":"IF($G433=\"\",\"\",$G433*J433)","v":""}]
[{"$nulls":10},{"$f":"IF($G434=\"\",\"\",$G434*J434)","v":""}]
[null,null,".04","White pvc 40 x 40 mm",null,"m",{"$nulls":4},{"$f":"IF($G435=\"\",\"\",$G435*J435)","v":""}]
[]
[]
[]
[]
[]
[]
[null,"Carried forward",{"$nulls":8},{"$f":"SUM(K389:K441)","v":{"v":0,"d":"0.00"}}]
[]
[]
[null,"Brought forward",{"$nulls":8},{"$f":"K442","v":{"v":0,"d":"0.00"}}]
[]
[]
["AB.03.10",{"$f":"MAX($B$6:B447)+0.01","v":{"v":403.2399999999998,"d":"403.24"}},"Supply and install Pratley boxes"]
[{"$nulls":10},{"$f":"IF($G449=\"\",\"\",$G449*J449)","v":""}]
[null,null,".01","83 mm ø - double entry",null,"No",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".02","127 mm ø - 3 way",null,"No",{"$nulls":4},""]
[{"$nulls":10},""]
[null,{"$f":"MAX($B$6:B453)+0.01","v":{"v":403.2499999999998,"d":"403.25"}},"Supply and install 4 plate stove with oven and warm drawer",null,null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,{"$f":"B392+1","v":{"v":10,"d":"10.00"}},"EARTHING AND BONDING",{"$nulls":7},""]
[{"$nulls":10},""]
["AB.04.01",{"$f":"MAX($B$5:B457)+0.01","v":{"v":403.25999999999976,"d":"403.26"}},"Provide earthing and bonding in all ablution rooms, laundries and kitchens",null,null,"Sum",null,"-"]
[{"$nulls":10},{"$f":"IF($G459=\"\",\"\",$G459*J459)","v":""}]
[null,{"$f":"B456+1","v":{"v":11,"d":"11.00"}},"LIGHTNING PROTECTION",{"$nulls":7},""]
[{"$nulls":10},""]
["AB.04.03",{"$f":"MAX($B$5:B461)+0.01","v":{"v":403.26999999999975,"d":"403.27"}},"Supply and install earth electrodes:",{"$nulls":7},""]
[{"$nulls":10},""]
[null,null,".01","16 mm dia 1.2 m long Cu rod and clamp",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
["AB.04.04",{"$f":"MAX($B$5:B465)+0.01","v":{"v":403.27999999999975,"d":"403.28"}},"Provide cadweld joint on 70 mm² cable",null,null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
["AB.04.05",{"$f":"MAX($B$5:B467)+0.01","v":{"v":403.28999999999974,"d":"403.29"}},"Earth building roof structure",null,null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
["AB.04.02",{"$f":"MAX($B$5:B469)+0.01","v":{"v":403.2999999999997,"d":"403.30"}},"Testing of lightning earthing by a   specialist contractor",null,null,"Sum",null,"-"]
[]
["AB.03.21",{"$f":"MAX($B$5:B471)+0.01","v":{"v":403.3099999999997,"d":"403.31"}},"Provide Certificate of Compliance for all buildings under Installation A3, B3 & C3",null,null,"Sum",null,"-"]
{"$rows_empty":21}
[null,"Carried forward",{"$nulls":8},{"$f":"SUM(K445:K493)","v":{"v":0,"d":"0.00"}}]
[]
[]
[null,"Brought forward",{"$nulls":8},{"$f":"K494","v":{"v":0,"d":"0.00"}}]
[]
[]
[null,{"$f":"B460+1","v":{"v":12,"d":"12.00"}},"EXTERNAL LIGHTING"]
[]
["HE 08.06(a)",{"$f":"MAX($B$5:B501)+0.01","v":{"v":403.3199999999997,"d":"403.32"}},"Excavate in all materials for trenches, backfill, compact and dispose of surplus material",null,null,"m3",{"$nulls":4},{"$f":"ROUND(G502*J502,2)","v":{"v":0,"d":"0.00"}}]
[]
["HE 08.06(f)",{"$f":"MAX($B$5:B503)+0.01","v":{"v":403.3299999999997,"d":"403.33"}},"Supply and install cable warning tape",null,null,"m",{"$nulls":4},{"$f":"ROUND(G504*J504,2)","v":{"v":0,"d":"0.00"}}]
[]
["HE 08.06(g)",{"$f":"MAX($B$5:B505)+0.01","v":{"v":403.3399999999997,"d":"403.34"}},"Supply and delivery of PVC/SWA/PVC Cu low-voltage cable:"]
[]
[null,null,".01","50 mm2, 4-core",null,"m",{"$nulls":4},{"$f":"ROUND(G508*J508,2)","v":{"v":0,"d":"0.00"}}]
[]
[null,null,".02","35 mm2, 4-core",null,"m",{"$nulls":4},{"$f":"ROUND(G510*J510,2)","v":{"v":0,"d":"0.00"}}]
[]
[null,null,".03","25 mm2, 4-core",null,"m",{"$nulls":4},{"$f":"ROUND(G512*J512,2)","v":{"v":0,"d":"0.00"}}]
[]
[null,null,".04","16 mm2, 4-core",null,"m",{"$nulls":4},{"$f":"ROUND(G514*J514,2)","v":{"v":0,"d":"0.00"}}]
[]
[null,null,".05","10 mm2, 4-core",null,"m",{"$nulls":4},{"$f":"ROUND(G516*J516,2)","v":{"v":0,"d":"0.00"}}]
[]
[null,null,".06","6 mm2, 4-core",null,"m",{"$nulls":4},{"$f":"ROUND(G518*J518,2)","v":{"v":0,"d":"0.00"}}]
[]
[null,null,".07","16 mm2, 2-core",null,"m",{"$nulls":4},{"$f":"ROUND(G520*J520,2)","v":{"v":0,"d":"0.00"}}]
[]
[null,null,".08","10 mm2, 2-core",null,"m",{"$nulls":4},{"$f":"ROUND(G522*J522,2)","v":{"v":0,"d":"0.00"}}]
[]
[null,null,".09","4 mm2, 3-core",null,"m",{"$nulls":4},{"$f":"ROUND(G524*J524,2)","v":{"v":0,"d":"0.00"}}]
[]
["HE 08.06(h)",{"$f":"MAX($B$5:B525)+0.01","v":{"v":403.3499999999997,"d":"403.35"}},"Lay PVC/SWA/PVC Cu LV cable:"]
[]
[null,null,".01","50 mm2, 4-core",null,"m",{"$nulls":4},{"$f":"ROUND(G528*J528,2)","v":{"v":0,"d":"0.00"}}]
[]
[null,null,".02","35 mm2, 4-core",null,"m",{"$nulls":4},{"$f":"ROUND(G530*J530,2)","v":{"v":0,"d":"0.00"}}]
[]
[null,null,".03","25 mm2, 4-core",null,"m",{"$nulls":4},{"$f":"ROUND(G532*J532,2)","v":{"v":0,"d":"0.00"}}]
[]
[null,null,".04","16 mm2, 4-core",null,"m",{"$nulls":4},{"$f":"ROUND(G534*J534,2)","v":{"v":0,"d":"0.00"}}]
[]
[null,null,".05","10 mm2, 4-core",null,"m",{"$nulls":4},{"$f":"ROUND(G536*J536,2)","v":{"v":0,"d":"0.00"}}]
[]
[null,null,".06","6 mm2, 4-core",null,"m",{"$nulls":4},{"$f":"ROUND(G538*J538,2)","v":{"v":0,"d":"0.00"}}]
[]
[null,null,".07","16 mm2, 2-core",null,"m",{"$nulls":4},{"$f":"ROUND(G540*J540,2)","v":{"v":0,"d":"0.00"}}]
[]
[null,null,".08","10 mm2, 2-core",null,"m",{"$nulls":4},{"$f":"ROUND(G542*J542,2)","v":{"v":0,"d":"0.00"}}]
[]
[null,null,".09","4 mm2, 3-core",null,"m",{"$nulls":4},{"$f":"ROUND(G544*J544,2)","v":{"v":0,"d":"0.00"}}]
[]
[]
[]
[null,"Carried forward",{"$nulls":8},{"$f":"SUM(K497:K546)","v":{"v":0,"d":"0.00"}}]
[]
[]
[null,"Brought forward",{"$nulls":8},{"$f":"K548","v":{"v":0,"d":"0.00"}}]
[]
[]
["HE 08.06(i)",{"$f":"MAX($B$5:B553)+0.01","v":{"v":403.3599999999997,"d":"403.36"}},"Termination of PVC/SWA/PVC Cu LV cable:"]
[]
[null,null,".01","50 mm2, 4-core",null,"number",{"$nulls":4},{"$f":"ROUND(G556*J556,2)","v":{"v":0,"d":"0.00"}}]
[]
[null,null,".02","35 mm2, 4-core",null,"number",{"$nulls":4},{"$f":"ROUND(G558*J558,2)","v":{"v":0,"d":"0.00"}}]
[]
[null,null,".03","25 mm2, 4-core",null,"number",{"$nulls":4},{"$f":"ROUND(G560*J560,2)","v":{"v":0,"d":"0.00"}}]
[]
[null,null,".04","16 mm2, 4-core",null,"number",{"$nulls":4},{"$f":"ROUND(G562*J562,2)","v":{"v":0,"d":"0.00"}}]
[]
[null,null,".05","10 mm2, 4-core",null,"number",{"$nulls":4},{"$f":"ROUND(G564*J564,2)","v":{"v":0,"d":"0.00"}}]
[]
[null,null,".06","6 mm2, 4-core",null,"number",{"$nulls":4},{"$f":"ROUND(G566*J566,2)","v":{"v":0,"d":"0.00"}}]
[]
[null,null,".07","16 mm2, 2-core",null,"number",{"$nulls":4},{"$f":"ROUND(G568*J568,2)","v":{"v":0,"d":"0.00"}}]
[]
[null,null,".08","10 mm2, 2-core",null,"number",{"$nulls":4},{"$f":"ROUND(G570*J570,2)","v":{"v":0,"d":"0.00"}}]
[]
[null,null,".09","4 mm2, 3-core",null,"number",{"$nulls":4},{"$f":"ROUND(G572*J572,2)","v":{"v":0,"d":"0.00"}}]
[]
["HE 08.06(m)",{"$f":"MAX($B$5:B573)+0.01","v":{"v":403.36999999999966,"d":"403.37"}},"Jointing of low voltage cable:"]
[]
[null,null,".01","25 mm2, 4-core",null,"number",{"$nulls":4},{"$f":"ROUND(G576*J576,2)","v":{"v":0,"d":"0.00"}}]
[]
[null,null,".02","16 mm2, 4-core",null,"number",{"$nulls":4},{"$f":"ROUND(G578*J578,2)","v":{"v":0,"d":"0.00"}}]
[]
[null,null,".03","10 mm2, 4-core",null,"number",{"$nulls":4},{"$f":"ROUND(G580*J580,2)","v":{"v":0,"d":"0.00"}}]
[]
[null,null,".04","6 mm2, 4-core",null,"number",{"$nulls":4},{"$f":"ROUND(G582*J582,2)","v":{"v":0,"d":"0.00"}}]
[]
[null,null,".05","16 mm2, 3-core",null,"number",{"$nulls":4},{"$f":"ROUND(G584*J584,2)","v":{"v":0,"d":"0.00"}}]
[]
[null,null,".06","10 mm2, 3-core",null,"number",{"$nulls":4},{"$f":"ROUND(G586*J586,2)","v":{"v":0,"d":"0.00"}}]
[]
[null,null,".07","6 mm2, 3-core",null,"number",{"$nulls":4},{"$f":"ROUND(G588*J588,2)","v":{"v":0,"d":"0.00"}}]
[]
["HE 08.06(q)",{"$f":"MAX($B$5:B589)+0.01","v":{"v":403.37999999999965,"d":"403.38"}},"Supply and installation of circuit breakers:"]
[]
[null,null,".01","10-20A, 5 kA, single pole",null,"number",{"$nulls":4},{"$f":"ROUND(G592*J592,2)","v":{"v":0,"d":"0.00"}}]
[]
[null,null,".02","25-60A, 5 kA single pole",null,"number",{"$nulls":4},{"$f":"ROUND(G594*J594,2)","v":{"v":0,"d":"0.00"}}]
[]
[null,null,".03","25-60A, 5 kA triple pole",null,"number",{"$nulls":4},{"$f":"ROUND(G596*J596,2)","v":{"v":0,"d":"0.00"}}]
[]
[null,null,".04","70-80A, 5 kA triple pole",null,"number",{"$nulls":4},{"$f":"ROUND(G598*J598,2)","v":{"v":0,"d":"0.00"}}]
[]
[]
[]
[]
[]
[null,"Carried forward",{"$nulls":8},{"$f":"SUM(K551:K602)","v":{"v":0,"d":"0.00"}}]
[]
[]
[null,"Brought forward",{"$nulls":8},{"$f":"K604","v":{"v":0,"d":"0.00"}}]
[]
[]
["HE 08.06(q)",{"$f":"MAX($B$5:B609)+0","v":{"v":403.37999999999965,"d":"403.38"}},".05","70-100A, 15 kA triple pole",null,"number",{"$nulls":4},{"$f":"ROUND(G610*J610,2)","v":{"v":0,"d":"0.00"}}]
[]
[null,null,".06","125-160A, 15 kA triple pole",null,"number",{"$nulls":4},{"$f":"ROUND(G612*J612,2)","v":{"v":0,"d":"0.00"}}]
[]
[null,null,".07","200-250A, 25 kA triple pole",null,"number",{"$nulls":4},{"$f":"ROUND(G614*J614,2)","v":{"v":0,"d":"0.00"}}]
[]
["HE 08.06(s)",{"$f":"MAX($B$7:B612)+0.01","v":{"v":403.38999999999965,"d":"403.39"}},"Supply and installation of contactors:"]
[]
[null,null,".01","30A, 3 pole",null,"number",{"$nulls":4},{"$f":"ROUND(G618*J618,2)","v":{"v":0,"d":"0.00"}}]
[]
[null,null,".02","60A, 3 pole",null,"number",{"$nulls":4},{"$f":"ROUND(G620*J620,2)","v":{"v":0,"d":"0.00"}}]
[]
["HE 08.06(o)",{"$f":"MAX($B$7:B621)+0.01","v":{"v":403.39999999999964,"d":"403.40"}},"Supply and installation of internal   luminaire components:"]
[]
[null,null,".01","Ballast for 250 W HPS",null,"number",{"$nulls":4},{"$f":"ROUND(G624*J624,2)","v":{"v":0,"d":"0.00"}}]
[]
[null,null,".02","Igniter for 250 W HPS",null,"number",{"$nulls":4},{"$f":"ROUND(G626*J626,2)","v":{"v":0,"d":"0.00"}}]
[]
[null,null,".03","Capacitor for 250 W HPS",null,"number",{"$nulls":4},{"$f":"ROUND(G628*J628,2)","v":{"v":0,"d":"0.00"}}]
[]
[null,null,".04","GES porcelain lamp holder",null,"number",{"$nulls":4},{"$f":"ROUND(G630*J630,2)","v":{"v":0,"d":"0.00"}}]
[]
["HE 08.06(z)",{"$f":"MAX($B$7:B631)+0.01","v":{"v":403.4099999999996,"d":"403.41"}},"Replace Luminaire diffuser"]
[]
[null,null,".01","250W HPSE streetlight diffuser",null,"number",{"$nulls":4},{"$f":"ROUND(G634*J634,2)","v":{"v":0,"d":"0.00"}}]
[]
[null,null,".02","250W HPS Floodlight ",null,"number",{"$nulls":4},{"$f":"ROUND(G636*J636,2)","v":{"v":0,"d":"0.00"}}]
[]
[null,null,".03","Post Top diffuser",null,"number",{"$nulls":4},{"$f":"ROUND(G638*J638,2)","v":{"v":0,"d":"0.00"}}]
[]
["HE 08.06(y)",{"$f":"MAX($B$7:B639)+0.01","v":{"v":403.4199999999996,"d":"403.42"}},"Replace Pole cover"]
[]
[null,null,".01","Acess door mounting -R55",null,"number",{"$nulls":4},{"$f":"ROUND(G642*J642,2)","v":{"v":0,"d":"0.00"}}]
[]
["HE 08.06(u)",{"$f":"MAX($B$7:B643)+0.01","v":{"v":403.4299999999996,"d":"403.43"}},"Supply and install photocell (plug-in type)",null,null,"number",{"$nulls":4},{"$f":"ROUND(G644*J644,2)","v":{"v":0,"d":"0.00"}}]
[]
["HE 08.06(v)",{"$f":"MAX($B$7:B645)+0.01","v":{"v":403.4399999999996,"d":"403.44"}},"Supply and install Electronic QAT-R-clip-in timer",null,null,"number",{"$nulls":4},{"$f":"ROUND(G646*J646,2)","v":{"v":0,"d":"0.00"}}]
[]
["HE 08.06(x)",{"$f":"MAX($B$7:B647)+0.01","v":{"v":403.4499999999996,"d":"403.45"}},"Supply and install end connectors and insulating sleeves",null,null,"number",{"$nulls":4},{"$f":"ROUND(G648*J648,2)","v":{"v":0,"d":"0.00"}}]
[]
["HE 08.06(z)",{"$f":"MAX($B$7:B649)+0.01","v":{"v":403.4599999999996,"d":"403.46"}},"Supply and install 3 way parallel entry cable boxes\" Pratley\""]
[]
[null,null,".01","No 1",null,"number",{"$nulls":4},{"$f":"ROUND(G652*J652,2)","v":{"v":0,"d":"0.00"}}]
[]
[null,null,".02","No 2",null,"number",{"$nulls":4},{"$f":"ROUND(G654*J654,2)","v":{"v":0,"d":"0.00"}}]
[]
[null,null,".03","No 3",null,"number",{"$nulls":4},{"$f":"ROUND(G656*J656,2)","v":{"v":0,"d":"0.00"}}]
[]
[null,"Carried forward",{"$nulls":8},{"$f":"SUM(K607:K656)","v":{"v":0,"d":"0.00"}}]
[]
[]
[null,"Brought forward",{"$nulls":8},{"$f":"K658","v":{"v":0,"d":"0.00"}}]
[]
[]
[null,{"v":410,"d":"410.00"},"DISTRIBUTION KIOSKS"]
[]
["HC 12.03 (a)",{"$f":"MAX($B$6:B665)+0.01","v":410.01},"Service Distribution kiosk",null,null,"number",{"$nulls":4},{"$f":"ROUND(G666*J666,2)","v":{"v":0,"d":"0.00"}}]
[]
["HC 12.03 (b)",{"$f":"MAX($B$6:B667)+0.01","v":410.02},"Remove rust and paint kiosk",null,null,"number",{"$nulls":4},{"$f":"ROUND(G668*J668,2)","v":{"v":0,"d":"0.00"}}]
[]
["HC 12.03 (c)",{"$f":"MAX($B$6:B669)+0.01","v":410.03},"Label kiosks",null,null,"number",{"$nulls":4},{"$f":"ROUND(G670*J670,2)","v":{"v":0,"d":"0.00"}}]
[]
["HC 12.03 (d)",{"$f":"MAX($B$6:B671)+0.01","v":{"v":410.03999999999996,"d":"410.04"}},"Supply and install padlocks (key-alike)",null,null,"number",{"$nulls":4},{"$f":"ROUND(G672*J672,2)","v":{"v":0,"d":"0.00"}}]
[]
["HC 12.03 (f)",{"$f":"MAX($B$6:B673)+0.01","v":{"v":410.04999999999995,"d":"410.05"}},"Replace door hinges",null,null,"number",{"$nulls":4},{"$f":"ROUND(G674*J674,2)","v":{"v":0,"d":"0.00"}}]
[]
["HC 12.03 (g)",{"$f":"MAX($B$6:B675)+0.01","v":{"v":410.05999999999995,"d":"410.06"}},"Supply and install door handles",null,null,"number",{"$nulls":4},{"$f":"ROUND(G676*J676,2)","v":{"v":0,"d":"0.00"}}]
[]
[null,{"$f":"B664+1","v":{"v":411,"d":"411.00"}},"STANDBY POWER",{"$nulls":8},{"$f":"SUM(M678:AQ678)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},{"v":0,"d":"0.00"}]
[null,null,"MANUALS, TRAINING AND RECORDING",{"$nulls":8},{"v":0,"d":"0.00"}]
[{"$nulls":11},{"v":0,"d":"0.00"}]
["SB.01",{"$f":"MAX($B$6:B681)+0.01","v":411.01},"Compile and supply a complete set of operating and Maintenance Manuals for Standby Generator as specified:",{"$nulls":8},{"v":0,"d":"0.00"}]
[{"$nulls":11},{"v":0,"d":"0.00"}]
[null,null,".01","Generator system",null,"sum",null,"-",{"$nulls":3},{"v":1,"d":"1.00"},null,1]
[]
["PHB.33.01",{"$f":"MAX($B$6:B684)+0.01","v":411.02},"Supply and Install 100 kVA, Three phase ",{"$nulls":8},{"$f":"SUM(M686:AQ686)","v":{"v":0,"d":"0.00"}}]
[null,null,"water-cooled emergency generator complete with",{"$nulls":8},{"$f":"SUM(M687:AQ687)","v":{"v":0,"d":"0.00"}}]
[null,null,"Engine, Aleternator,day tank and Base frame",{"$nulls":7},{"$f":"J688*G688","v":{"v":0,"d":"0.00"}},{"$f":"SUM(M688:AQ688)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},"number",{"$nulls":4},{"$f":"J689*G689","v":{"v":0,"d":"0.00"}},{"$f":"SUM(M689:AQ689)","v":{"v":0,"d":"0.00"}},null,"1"]
[]
["PHB.33.03",{"$f":"MAX($B$6:B688)+0.01","v":411.03},"Supply and install a Automatic Mains Failure Panel complete with cabling between the Engine and Alternator",null,null,"number",{"$nulls":4},{"$f":"J691*G691","v":{"v":0,"d":"0.00"}},{"$f":"SUM(M691:AQ691)","v":{"v":0,"d":"0.00"}},null,"1"]
[{"$nulls":10},{"$f":"J692*G692","v":{"v":0,"d":"0.00"}},{"$f":"SUM(M692:AQ692)","v":{"v":0,"d":"0.00"}}]
["PHB.33.02",{"$f":"MAX($B$6:B692)+0.01","v":{"v":411.03999999999996,"d":"411.04"}},"Installation, commissioning and site",null,null,"number",null,null,{"$f":"IF(OR(AND(G693=\"Prov\",H693=\"Sum\"),(H693=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G693*H693),\"\",IF(G693*H693=0,\"\",ROUND(G693*H693,2))))","v":""},null,{"$f":"J693*G693","v":{"v":0,"d":"0.00"}},{"$f":"SUM(M693:AQ693)","v":{"v":0,"d":"0.00"}},null,"1"]
[null,null,"testing",{"$nulls":7},{"$f":"J694*G694","v":{"v":0,"d":"0.00"}},{"$f":"SUM(M694:AQ694)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":10},{"$f":"J695*G695","v":{"v":0,"d":"0.00"}},{"$f":"SUM(M695:AQ695)","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"MAX($B$6:B694)+0.01","v":{"v":411.04999999999995,"d":"411.05"}},"Removal costs",{"$nulls":10},{"$f":"IF(G696<>0,ROUND(Q696*J696,2),\"\")","v":""},{"$f":"IF(F696<>0,ROUND(R696*J696,2),\"\")","v":""},{"$f":"IF(F696<>0,ROUND(S696*J696,2),\"\")","v":""},{"$f":"IF(F696<>0,S696-R696,\"\")","v":""},null,{"$f":"IF(F696<>0,SUM(T696:GO696),\"\")","v":""}]
[{"$nulls":13},"","","","",null,""]
[null,null,".01","Existing Set: Clean, plug and moth-ball",null,"number",{"$nulls":4},{"$f":"IF($G698=\"\",\"\",$G698*J698)","v":""},null,{"v":0,"d":"0.00"},"",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[{"$nulls":10},{"$f":"IF($G699=\"\",\"\",$G699*J699)","v":""},null,{"$f":"IF($G699=\"\",\"\",$G699*L699)","v":""},"","","","",null,""]
[null,null,".02","Existing day tank: Clean and plug",null,"number",{"$nulls":4},{"$f":"IF($G700=\"\",\"\",$G700*J700)","v":""},null,{"v":0,"d":"0.00"},"",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[{"$nulls":10},{"$f":"IF($G701=\"\",\"\",$G701*J701)","v":""},null,{"$f":"IF($G701=\"\",\"\",$G701*L701)","v":""},"","","","",null,""]
[null,{"$f":"MAX($B$6:B698)+0.01","v":{"v":411.05999999999995,"d":"411.06"}},"Traveling for delivery of Standby Generator",null,null,"km",{"$nulls":4},{"$f":"IF($G702=\"\",\"\",$G702*J702)","v":""},0,{"$f":"IF($G702=\"\",\"\",$G702*L702)","v":""},"",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
{"$rows_empty":7}
[null,{"$f":"\"TOTAL \"&$A$3&\" CARRIED TO SUMMARY:  CORRECTIVE MAINTENANCE WORK\"","v":"TOTAL  CARRIED TO SUMMARY:  CORRECTIVE MAINTENANCE WORK"},{"$nulls":8},{"$f":"SUM(K660:K709)","v":{"v":0,"d":"0.00"}}]

{"sheet":"SCH2.4","index":7,"n_rows":283,"n_cols":11,"rows_kept":283,"hidden":true,"merged":[[1,2,1,8],[5,2,5,4],[6,2,6,4],[7,2,7,4],[11,3,11,4],[13,2,13,4],[14,3,14,4],[20,2,20,4],[22,3,22,4],[24,3,24,4],[26,3,26,4],[28,3,28,4],[29,3,29,4],[30,3,30,4],[31,3,31,4],[32,3,32,4],[49,2,49,4],[51,3,51,4],[53,3,53,4],[55,2,55,4],[64,3,64,4],[66,3,66,4],[68,3,68,4],[72,3,72,4],[96,2,96,4],[97,2,97,4],[111,3,111,4],[117,3,117,4],[144,2,144,4],[145,2,145,4],[159,3,159,4],[165,3,165,4],[169,2,169,4],[171,3,171,4],[173,3,173,4],[175,3,175,4],[178,3,178,4],[187,2,187,4],[189,2,189,4],[191,2,191,4],[193,3,193,4],[194,3,194,4],[195,3,195,4],[242,3,242,4],[244,3,244,4],[246,3,246,4],[248,3,248,4],[250,3,250,4],[252,3,252,4],[254,3,254,4],[256,3,256,4],[258,3,258,4],[260,3,260,4],[262,3,262,4]]}
[]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
["PAYMENT REFERS TO","ITEM NO","DESCRIPTION",null,null,"UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,null,"REFER TO DRAWING 048182/004B & 005B FOR FENCING DETAILS"]
[]
[null,{"v":4,"d":"4.00"},"SOLID WASTE MANAGEMENT",{"$nulls":7},{"$f":"IF($G8=\"\",\"\",$G8*J8)","v":""}]
[{"$nulls":10},""]
["CG.05",{"$f":"MAX($B$8:B9)+0.01","v":4.01},"SUPPLY OF WASTE BINS",{"$nulls":7},""]
[{"$nulls":10},""]
[null,null,".01","Square black 240 liter waste bins including wheels",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
["SANS 1200C",{"$f":"B8+1","v":{"v":5,"d":"5.00"}},"SITE MAINTENANCE",{"$nulls":7},""]
[" 8.2.2",{"$f":"MAX($B$8:B14)+0.01","v":5.01},".01","Removal and grubbing of large trees and tree stumps:",{"$nulls":6},""]
[{"$nulls":10},""]
[{"$nulls":3},".01","Girth exceeding 1 m up to and including 2 m","number",{"$nulls":4},""]
[{"$nulls":10},""]
[{"$nulls":3},".02","Girth exceeding 2 m up to and including 3 m","number",{"$nulls":4},""]
[]
["CJ.05",{"$f":"B14+1","v":{"v":6,"d":"6.00"}},"SUPPLY OF EQUIPMENT FOR ABLUTIONS AS DESCRIBED IN ITEM CJ.09 OF THE PROJECT SPECIFICATIONS",{"$nulls":7},{"$f":"IF($G21=\"\",\"\",$G21*J21)","v":""}]
[]
["CJ.05.01",null,".01","Stainless Steel Hand dryer unit with blower output of 450 watt @ 20' 000 rpm similar or equal to Excelarator",null,"number",{"$nulls":4},{"$f":"IF($G23=\"\",\"\",$G23*J23)","v":""}]
[{"$nulls":10},{"$f":"IF($G24=\"\",\"\",$G24*J24)","v":""}]
["CJ.05.02",null,".02","Auto digital aerosol dispenser with stainless steel cover",null,"number",{"$nulls":4},{"$f":"IF($G25=\"\",\"\",$G25*J25)","v":""}]
[{"$nulls":10},{"$f":"IF($G26=\"\",\"\",$G26*J26)","v":""}]
["CJ.05.03",null,".03","Stainless steel toilet paper dispensing units, capable of holding two toilet paper rolls per unit",null,"number",{"$nulls":4},{"$f":"IF($G27=\"\",\"\",$G27*J27)","v":""}]
[]
["CJ.05.04",null,".04","Stainless steel she bins",null,"number",{"$nulls":4},{"$f":"IF($G29=\"\",\"\",$G29*J29)","v":""}]
[{"$nulls":10},{"$f":"IF($G30=\"\",\"\",$G30*J30)","v":""}]
["CJ.05.05",null,".05","Stainless steel soap dispenser ",null,"number",{"$nulls":4},{"$f":"IF($G31=\"\",\"\",$G31*J31)","v":""}]
[{"$nulls":10},{"$f":"IF($G32=\"\",\"\",$G32*J32)","v":""}]
["CJ.05.06",null,".06","Stainless steel urinal sanitizer",null,"number",{"$nulls":4},{"$f":"IF($G33=\"\",\"\",$G33*J33)","v":""}]
{"$rows_empty":10}
[null,"Carried forward",{"$nulls":8},{"$f":"SUM(K5:K42)","v":{"v":0,"d":"0.00"}}]
[]
[]
[null,"Brought forward",{"$nulls":8},{"$f":"K44","v":{"v":0,"d":"0.00"}}]
[]
[]
["CC.03",{"$f":"B8+4","v":{"v":8,"d":"8.00"}},"REPAIR WORK TO FENCES",{"$nulls":4},"",{"$f":"IF($G50=\"\",\"\",$G50*H50)","v":""},null,{"$f":"IF($G50=\"\",\"\",$G50*J50)","v":""}]
[{"$nulls":7},"",{"$f":"IF($G51=\"\",\"\",$G51*H51)","v":""},null,""]
[null,null,".01","Repair of wire and mesh fences less than 1,3m high",null,"m",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".02","Repair of wire and mesh fences between 1,3m and 2,0m high",null,"m",{"$nulls":4},""]
[{"$nulls":10},""]
[null,{"$f":"B8+5","v":{"v":9,"d":"9.00"}},"RESIDENTIAL FENCE - 1,2 m DIAMOND MESH, TUBULAR STEEL POSTS AND STANDARDS",{"$nulls":7},""]
[{"$nulls":10},""]
["CC.02",{"$f":"MAX($B$11:B57)+0.01","v":9.01},"Supply and erection of new fencing ",{"$nulls":7},{"$f":"IF($G58=\"\",\"\",$G58*J58)","v":""}]
[null,null,"material to replace old material:",{"$nulls":7},""]
[{"$nulls":10},""]
[null,null,".01","Diamond mesh:",{"$nulls":6},""]
[{"$nulls":10},""]
[{"$nulls":3},".01","1,2 m diamond mesh fence","m",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".02","110mm tubular post with concrete footing for 1.2m high fence",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".03","65mm dia Stay for 1,2 m post",null,"number",{"$nulls":4},""]
[]
[null,null,".04","Y-standards for 1,2 m high fence",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".05","Straining wire",null,"m",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".06","Gates",{"$nulls":6},{"$f":"IF($G73=\"\",\"\",$G73*J73)","v":""}]
[{"$nulls":10},""]
[{"$nulls":3},".01","In 1,2 m high fences",{"$nulls":5},""]
[{"$nulls":10},""]
[{"$nulls":4},".01 single and double gates less than 1,5 m wide","number",{"$nulls":4},""]
[{"$nulls":10},""]
[{"$nulls":4},".02 single and double gates between 1,5 m and 5,0 m wide","number",{"$nulls":4},""]
[{"$nulls":10},""]
{"$rows_empty":10}
[null,"Carried forward",{"$nulls":8},{"$f":"SUM(K46:K89)","v":{"v":0,"d":"0.00"}}]
[]
[]
[null,"Brought forward",{"$nulls":8},{"$f":"K91","v":{"v":0,"d":"0.00"}}]
[]
[]
[null,{"$f":"+B8+6","v":{"v":10,"d":"10.00"}},"1.8m PERIMETER FENCE - DIAMOND MESH, TUBULAR STEEL POSTS"]
[]
["CC.02",{"$f":"MAX($B$10:B98)+0.01","v":10.01},"Supply and erection of new fencing ",{"$nulls":7},{"$f":"IF($G99=\"\",\"\",$G99*J99)","v":""}]
[null,null,"material to replace old material:",{"$nulls":7},""]
[{"$nulls":10},""]
[null,null,".01","Diamond mesh:",{"$nulls":6},""]
[{"$nulls":10},""]
[{"$nulls":3},".01","1.8 m diamond mesh","m",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".02","Tubular posts:",{"$nulls":6},""]
[{"$nulls":10},""]
[{"$nulls":3},".01","75 mm tubular posts with additional 600 mm overhang at 45° and with concrete footing for 1.8m high fence","number",{"$nulls":4},""]
[]
[{"$nulls":3},"02","110 mm tubular posts with additional 600 mm overhang at 45° and with concrete footing for 1.8m high fence","number",{"$nulls":4},{"$f":"IF($G110=\"\",\"\",$G110*J110)","v":""}]
[{"$nulls":10},{"$f":"IF($G111=\"\",\"\",$G111*J111)","v":""}]
[null,null,".03","65mm dia Stay for 1.8 m post",null,"number",{"$nulls":4},{"$f":"IF($G112=\"\",\"\",$G112*J112)","v":""}]
[]
[null,null,".04","Straining wire",null,"m",{"$nulls":4},{"$f":"IF($G114=\"\",\"\",$G114*J114)","v":""}]
[{"$nulls":10},{"$f":"IF($G115=\"\",\"\",$G115*J115)","v":""}]
[null,null,".05","Barbed wire",null,"m",{"$nulls":4},{"$f":"IF($G116=\"\",\"\",$G116*J116)","v":""}]
[]
[null,null,".07","Gates in 1.8 m high fences",{"$nulls":6},{"$f":"IF($G118=\"\",\"\",$G118*J118)","v":""}]
[]
[{"$nulls":3},".01","Double gate between 5.0 m and 10.0m wide","number",{"$nulls":4},{"$f":"IF($G120=\"\",\"\",$G120*J120)","v":""}]
{"$rows_empty":18}
[null,"Carried forward",{"$nulls":8},{"$f":"SUM(K93:K137)","v":{"v":0,"d":"0.00"}}]
[]
[]
[null,"Brought forward",{"$nulls":8},{"$f":"K139","v":{"v":0,"d":"0.00"}}]
[]
[]
[null,{"$f":"B97+1","v":{"v":11,"d":"11.00"}},"3.0m PERIMETER FENCE - DIAMOND MESH, TUBULAR STEEL POSTS"]
[]
["CC.02",{"$f":"MAX($B$10:B146)+0.01","v":11.01},"Supply and erection of new fencing ",{"$nulls":7},{"$f":"IF($G147=\"\",\"\",$G147*J147)","v":""}]
[null,null,"material to replace old material:",{"$nulls":7},""]
[{"$nulls":10},""]
[null,null,".01","Diamond mesh:",{"$nulls":6},""]
[{"$nulls":10},""]
[{"$nulls":3},".01","3.0 m diamond mesh","m",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".02","Tubular posts:",{"$nulls":6},""]
[{"$nulls":10},""]
[{"$nulls":3},".01","75 mm tubular posts with additional 600 mm overhang at 45° and with concrete footing for 3.0m high fence","number",{"$nulls":4},""]
[]
[{"$nulls":3},"02","110 mm tubular posts with additional 600 mm overhang at 45° and with concrete footing for 3.0m high fence","number",{"$nulls":4},{"$f":"IF($G158=\"\",\"\",$G158*J158)","v":""}]
[{"$nulls":10},{"$f":"IF($G159=\"\",\"\",$G159*J159)","v":""}]
[null,null,".03","65mm dia Stay for 3.0 m post",null,"number",{"$nulls":4},{"$f":"IF($G160=\"\",\"\",$G160*J160)","v":""}]
[]
[null,null,".04","Straining wire",null,"m",{"$nulls":4},{"$f":"IF($G162=\"\",\"\",$G162*J162)","v":""}]
[{"$nulls":10},{"$f":"IF($G163=\"\",\"\",$G163*J163)","v":""}]
[null,null,".05","Barbed wire",null,"m",{"$nulls":4},{"$f":"IF($G164=\"\",\"\",$G164*J164)","v":""}]
[]
[null,null,".06","Gates in 3.0 m high fences",{"$nulls":6},{"$f":"IF($G166=\"\",\"\",$G166*J166)","v":""}]
[]
[{"$nulls":3},".01","Double gate between 5.0 m and 10.0m wide","number",{"$nulls":4},{"$f":"IF($G168=\"\",\"\",$G168*J168)","v":""}]
["SABS"]
["1200 G",{"$f":"MAX($B$6:B169)+0.01","v":11.02},"SCHEDULED ITEMS",{"$nulls":7},{"$f":"IF($G170=\"\",\"\",$G170*J170)","v":""}]
[8.3,{"$nulls":9},{"$f":"IF($G171=\"\",\"\",$G171*J171)","v":""}]
["8.3.2",null,".01","Excavate for restricted foundation, footings and trenches in all materials and use for backfill or embankment or dispose.",null,"m3",{"$nulls":4},{"$f":"IF($G172=\"\",\"\",$G172*J172)","v":""}]
[{"$nulls":10},{"$f":"IF($G173=\"\",\"\",$G173*J173)","v":""}]
[null,null,".02","Break up, hack of and remove existing concrete",null,"m3",{"$nulls":4},{"$f":"IF($G174=\"\",\"\",$G174*J174)","v":""}]
[]
["8.3.4",null,".03","Importing, placing and compacting approved G6 material in layers of 150mm from commercial sources or from borrow pits to 95% MOD AASTHO.",null,"m3",{"$nulls":4},{"$f":"IF($G176=\"\",\"\",$G176*J176)","v":""}]
[]
[]
[{"$nulls":10},{"$f":"IF($G179=\"\",\"\",$G179*J179)","v":""}]
[]
[null,"Carried forward",{"$nulls":8},{"$f":"SUM(K141:K179)","v":{"v":0,"d":"0.00"}}]
[]
[]
[null,"Brought forward",{"$nulls":8},{"$f":"K181","v":{"v":0,"d":"0.00"}}]
[]
[]
[]
["SABS",null,"CONCRETE (STRUCTURAL)",{"$nulls":7},{"$f":"IF($G188=\"\",\"\",$G188*J188)","v":""}]
["1200 G",{"$nulls":9},""]
[8.4,null,"SCHEDULED CONCRETE ITEMS",{"$nulls":7},""]
[{"$nulls":10},""]
["8.4.3",{"$f":"MAX($B$6:B191)+0.01","v":11.03},"Strength concrete:",{"$nulls":7},""]
[{"$nulls":10},""]
[null,null,".01","Class 25 Mpa concrete in strip footings",null,"m3",{"$nulls":4},""]
[]
[null,null,".02","Class 25 Mpa concrete in walls",null,"m3",{"$nulls":4},""]
[]
["SABS",null,"STRUCTURAL STEELWORK - ",{"$nulls":7},{"$f":"IF($G198=\"\",\"\",$G198*J198)","v":""}]
["1200 H",null,"REPAIR TO EXISTING SLIDING GATES",{"$nulls":7},""]
[]
["8.3.1",{"$f":"MAX($B$13:B199)+0.01","v":11.04},"Supply and fabrication of steelwork:",{"$nulls":7},""]
[{"$nulls":10},""]
[null,null,".01","Jointing by with 6mm fillet welds:",{"$nulls":6},""]
[{"$nulls":10},""]
[{"$nulls":3},".01","Square-section column guides with ",{"$nulls":5},""]
[{"$nulls":4},"500 x 500 x 8mm flat section base "]
[{"$nulls":4},"plates and end cap plates","t",{"$nulls":4},""]
[]
[{"$nulls":3},".02","Square-section frame work in existing",{"$nulls":5},{"$f":"IF($G209=\"\",\"\",$G209*J209)","v":""}]
[{"$nulls":4},"sliding gates","t",{"$nulls":4},""]
[{"$nulls":10},""]
[null,{"$f":"MAX($B$13:B208)+0.01","v":{"v":11.049999999999999,"d":"11.05"}},"Delivery to Site:",{"$nulls":7},""]
[{"$nulls":10},""]
["8.3.2.1",null,".01","Normal delivery:",{"$nulls":6},""]
[{"$nulls":10},""]
[{"$nulls":3},".01","Columns, rafters, purlins and braces",{"$nulls":5},""]
[{"$nulls":4},"for carport structures complete as",{"$nulls":5},""]
[{"$nulls":4},"scheduled under item 8.3.1 above","t",{"$nulls":4},""]
[{"$nulls":10},""]
["8.3.3",{"$f":"MAX($B$13:B219)+0.01","v":{"v":11.059999999999999,"d":"11.06"}},"Erection on Site:",{"$nulls":7},""]
[{"$nulls":10},""]
[null,null,".01","Steel framework and guides for",{"$nulls":6},""]
[{"$nulls":3},"existing steel sliding gates",null,"t",{"$nulls":4},""]
[{"$nulls":10},""]
{"$rows_empty":10}
[null,"Carried forward",{"$nulls":8},{"$f":"SUM(K183:K233)","v":{"v":0,"d":"0.00"}}]
[]
[]
[null,"Brought forward",{"$nulls":8},{"$f":"K235","v":{"v":0,"d":"0.00"}}]
[]
[]
["8.3.12",{"$f":"MAX($B$13:B224)+0.01","v":{"v":11.069999999999999,"d":"11.07"}},"Additional Items:",{"$nulls":7},{"$f":"IF($G241=\"\",\"\",$G241*J241)","v":""}]
[{"$nulls":10},{"$f":"IF($G242=\"\",\"\",$G242*J242)","v":""}]
["(e)",null,".01","Dismantling and removal of existing steel sliding gates.",null,"no",{"$nulls":4},{"$f":"IF($G243=\"\",\"\",$G243*J243)","v":""}]
[]
["(e)",null,".02","Dismantling and removal of existing steel sliding gate guides.",null,"no",{"$nulls":4},{"$f":"IF($G245=\"\",\"\",$G245*J245)","v":""}]
[]
["(e)",null,".03","Dismantling and removal of existing steel panels.",null,"no",{"$nulls":4},{"$f":"IF($G247=\"\",\"\",$G247*J247)","v":""}]
[]
["(f)",null,".04","Re-erection of existing steel sliding gates.",null,"no",{"$nulls":4},{"$f":"IF($G249=\"\",\"\",$G249*J249)","v":""}]
[]
["(f)",null,".05","Re-erection of existing steel sliding gate guides.",null,"no",{"$nulls":4},{"$f":"IF($G251=\"\",\"\",$G251*J251)","v":""}]
[]
["(f)",null,".06","Re-erection of existing steel panels.",null,"no",{"$nulls":4},{"$f":"IF($G253=\"\",\"\",$G253*J253)","v":""}]
[]
["(g)",null,".07","Tying in to existing steel sliding gates.",null,"no",{"$nulls":4},{"$f":"IF($G255=\"\",\"\",$G255*J255)","v":""}]
[]
["(g)",null,".08","Tying in to existing steel sliding gate guides.",null,"no",{"$nulls":4},{"$f":"IF($G257=\"\",\"\",$G257*J257)","v":""}]
[]
["(g)",null,".09","Tying in to existing steel panels.",null,"no",{"$nulls":4},{"$f":"IF($G259=\"\",\"\",$G259*J259)","v":""}]
[]
[null,null,".10","Replace 150mm sliding gate wheels",null,"no",{"$nulls":4},{"$f":"IF($G261=\"\",\"\",$G261*J261)","v":""}]
[]
[null,null,".11","Replace sliding gate guide wheels",null,"no",{"$nulls":4},{"$f":"IF($G263=\"\",\"\",$G263*J263)","v":""}]
{"$rows_empty":19}
[null,{"$f":"\"TOTAL \"&#REF!&\" CARRIED TO SUMMARY:  CORRECTIVE MAINTENANCE WORK\"","v":{"$error":"#REF!"}},{"$nulls":8},{"$f":"SUM(K237:K281)","v":{"v":0,"d":"0.00"}}]

{"sheet":"SCH2.5","index":8,"n_rows":82,"n_cols":11,"rows_kept":82,"hidden":true,"merged":[[1,2,1,8],[5,2,5,4],[7,2,7,4],[13,3,13,4],[21,3,21,4],[25,3,25,4],[46,3,46,4],[52,2,52,4],[54,3,54,4],[56,3,56,4],[58,3,58,4],[60,2,60,4],[62,3,62,4],[64,3,64,4],[66,3,66,4]]}
[]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},"ESTIMATE"]
["PAYMENT REFERS TO","ITEM NO","DESCRIPTION",null,null,"UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,{"v":5,"d":"5.00"},"ROADS"]
[]
["CA.01",{"$f":"MAX($B$6:B7)+0.01","v":5.01},"Repair of gravel wearing course and gravel shoulders"]
[]
[null,null,".01",".01","Ripping, redistributing and compacting to a density of 93% of Modified AASHTO","m²",{"$nulls":4},{"$f":"IF($G10=\"\",\"\",$G10*J10)","v":""}]
[{"$nulls":10},""]
[{"$nulls":3},".02","Importing, placing and compacting material from commercial sources to a density of 93% of Modified AASHTO","m³",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".02","Backfilling and reinstatement of pavement layers",{"$nulls":6},""]
[{"$nulls":10},""]
[{"$nulls":3},".01","Selected layers compacted to 93 % of modified AASHTO density","m3",{"$nulls":4},""]
[{"$nulls":10},""]
[{"$nulls":3},".02","Cement stabilized subbase layers compacted to 95 % of modified AASHTO density","m³",{"$nulls":4},""]
[{"$nulls":10},""]
[{"$nulls":3},".03","Cement stabilized base layers compacted to 97 % of modified AASHTO density","m³",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".03","Cast in situ concrete and formwork in edge beams, intermediate beams and kerbing:",{"$nulls":6},""]
[{"$nulls":10},""]
[{"$nulls":3},".01","Class 30 concrete","m³",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".04","Steel reinforcement in edge beams, intermediate beams and kerbing:",{"$nulls":6},""]
[{"$nulls":10},""]
[{"$nulls":3},".01","Mild steel bars","t",{"$nulls":4},""]
[{"$nulls":10},""]
[{"$nulls":3},".02","High-tensile steel bars","t",{"$nulls":4},""]
[{"$nulls":10},""]
[]
[{"$nulls":10},""]
[]
[]
[]
[]
[]
[]
[{"$nulls":10},{"$f":"IF($G40=\"\",\"\",$G40*J40)","v":""}]
[null,"Carried forward",{"$nulls":8},{"$f":"SUM(K5:K39)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":10},{"$f":"IF($G42=\"\",\"\",$G42*J42)","v":""}]
[{"$nulls":10},{"$f":"IF($G43=\"\",\"\",$G43*J43)","v":""}]
[null,"Brought forward",{"$nulls":8},{"$f":"K41","v":{"v":0,"d":"0.00"}}]
[{"$nulls":10},{"$f":"IF($G45=\"\",\"\",$G45*J45)","v":""}]
[]
["CA.05",{"$f":"MAX($B$6:B46)+0","v":5.01},".05","Concrete block paving:",{"$nulls":6},{"$f":"IF($G47=\"\",\"\",$G47*J47)","v":""}]
[{"$nulls":10},""]
[{"$nulls":3},".01","SABS approved 80mm, Class 35 Mpa interlocking grey concrete paving blocks for areas carrying mainly vehicular traffic","m²",{"$nulls":4},""]
[{"$nulls":10},""]
[{"$nulls":3},".02","SABS approved 80mm, Class 35 Mpa interlocking grey concrete paving blocks for areas carrying pedestrian traffic only","m²",{"$nulls":4},""]
[{"$nulls":10},""]
["CA.06",{"$f":"MAX($B$6:B44)+0.01","v":5.02},"Repair of existing concrete block paving",{"$nulls":7},""]
[{"$nulls":10},""]
[null,null,".01","Removal of existing concrete block paving from site",null,"m²",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".02","Reinstalling existing concrete block paving ",null,"m",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".03","Break out, hack of and remove existing conrete edge beams and storm water structures",null,"m³",{"$nulls":4},""]
[{"$nulls":10},""]
["CA.06",{"$f":"MAX($B$6:B55)+0.01","v":{"v":5.029999999999999,"d":"5.03"}},"Repair of kerbing",{"$nulls":7},""]
[{"$nulls":10},""]
[null,null,".01","Patching of kerbs",null,"m",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".02","Reinstalling pre-cast kerbs",null,"m",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".03","Replacing of kerbs",{"$nulls":6},""]
[{"$nulls":10},""]
[{"$nulls":3},".01","Barrier kerbs similar to existing undamaged barrier kerbs","m",{"$nulls":4},""]
{"$rows_empty":12}
[null,{"$f":"\"TOTAL \"&#REF!&\" CARRIED TO SUMMARY:  CORRECTIVE MAINTENANCE WORK\"","v":{"$error":"#REF!"}},{"$nulls":8},{"$f":"SUM(K43:K80)","v":{"v":0,"d":"0.00"}}]

{"sheet":"SCH2.6","index":9,"n_rows":98,"n_cols":11,"rows_kept":98,"hidden":true,"merged":[[1,2,1,8],[5,2,5,4],[7,2,7,4],[9,3,9,4],[11,3,11,4],[13,3,13,4],[15,3,15,4],[17,3,17,4],[18,3,18,4],[19,3,19,4],[21,3,21,4],[23,3,23,4],[25,3,25,4],[27,3,27,4],[29,3,29,4],[31,3,31,4],[33,3,33,4],[35,3,35,4],[37,3,37,4],[39,3,39,4],[49,2,49,4],[51,3,51,4],[53,3,53,4],[55,3,55,4],[57,3,57,4],[59,2,59,4],[61,2,61,4],[63,2,63,4],[65,2,65,4],[67,3,67,4],[69,3,69,4],[71,3,71,4],[73,3,73,4],[75,2,75,4],[77,3,77,4],[79,3,79,4],[81,2,81,4],[83,3,83,4],[85,3,85,4],[87,3,87,4],[89,3,89,4],[91,2,91,4]]}
[]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},"ESTIMATE"]
["PAYMENT REFERS TO","ITEM NO","DESCRIPTION",null,null,"UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,{"v":6,"d":"6.00"},"GENERAL"]
[]
["PFD 05.01.01",{"$f":"B6+0.01","v":6.01},"SERVICE AC UNITS"]
[]
[null,null,".01","Clean air intake screen",null,"number",{"$nulls":4},{"$f":"IF($G10=\"\",\"\",$G10*J10)","v":""}]
[{"$nulls":10},""]
[null,null,".02","Replace filters",null,"set",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".03","De-rust neutralize and touch up paintwork",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".04","Check setting and operation of all pressure switches and reset",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".05","Check setting and operation of all safety switches, i.a. LP&HP switches, oil pressure switch",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".06","Check setting and operation of thermostat",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".07","Check running current of fans and compressor and settings and operation of overloads",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".08","Check tightness of all electrical terminals",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".09","Ensure operation of local and remote isolators",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".10","Reposition and strap cables",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".11","Carry out a leak test on all refrigeration piping and components inclusive of evaporator and condenser",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".12","Replace compressor vibration mounts",null,"set",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".13","Check refrigerant charge sight glass being clear or flashing ",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".14","Clean condensate tray and test drainage operation",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".15","Clean evaporator and condenser fan blades and check unbalance",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".16","Galvanized unistrut brackets",null,"number",{"$nulls":4},""]
[]
[]
[]
[null,"Carried forward",{"$nulls":8},{"$f":"SUM(K5:K42)","v":{"v":0,"d":"0.00"}}]
[]
[]
[null,"Brought forward",{"$nulls":8},{"$f":"K44","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":10},{"$f":"IF($G49=\"\",\"\",$G49*J49)","v":""}]
["PFD 05.01.04",{"$f":"MAX($B$6:B49)+0.01","v":6.02},"REPLACE AIR CONDITIONING UNIT",{"$nulls":7},{"$f":"IF($G50=\"\",\"\",$G50*J50)","v":""}]
[{"$nulls":10},""]
[null,null,".01","54000 btu cassette unit",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".02","26000 btu high wall split unit",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".03","18000 btu high wall split unit",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".04","12000 btu high wall split unit",null,"number",{"$nulls":4},""]
[]
["PFD 05.01.02",{"$f":"MAX($B$6:B51)+0.01","v":{"v":6.029999999999999,"d":"6.03"}},"Replace temperature control unit (Remote)",null,null,"number",{"$nulls":4},{"$f":"IF($G60=\"\",\"\",$G60*J60)","v":""}]
[{"$nulls":10},""]
["PFD 05.01.03",{"$f":"MAX($B$6:B61)+0.01","v":{"v":6.039999999999999,"d":"6.04"}},"REGAS AC UNIT",null,null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
["PFD 05.01.05",{"$f":"MAX($B$6:B63)+0.01","v":{"v":6.049999999999999,"d":"6.05"}},"Replace 25mm Thermaflex isolation",null,null,"m",{"$nulls":4},""]
[{"$nulls":8},{"$f":"IF($G65=\"\",\"\",$G65*H65)","v":""},null,""]
["PFD 05.01.09",{"$f":"MAX($B$6:B65)+0.01","v":{"v":6.059999999999999,"d":"6.06"}},"REPLACE CAPACITOR",null,null,"m",{"$nulls":4},""]
[{"$nulls":8},{"$f":"IF($G67=\"\",\"\",$G67*H67)","v":""},null,""]
[null,null,".01","54000 btu cassette unit",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".02","26000 btu high wall split unit",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".03","18000 btu high wall split unit",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".04","12000 btu high wall split unit",null,"number",{"$nulls":4},""]
[]
["PFD 05.01.06",{"$f":"MAX($B$6:B69)+0.01","v":{"v":6.0699999999999985,"d":"6.07"}},"Replace Control (PC) Board",{"$nulls":5},{"$f":"IF($G76=\"\",\"\",$G76*H76)","v":""},null,{"$f":"IF($G76=\"\",\"\",$G76*J76)","v":""}]
[{"$nulls":8},{"$f":"IF($G77=\"\",\"\",$G77*H77)","v":""},null,""]
[null,null,".01","High wall split unit",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".02","Cassette unit",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
["PFD 05.01.07",{"$f":"MAX($B$6:B79)+0.01","v":{"v":6.079999999999998,"d":"6.08"}},"Replace Compressor",{"$nulls":7},""]
[{"$nulls":10},""]
[null,null,".01","54000 btu cassette unit",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".02","26000 btu high wall split unit",null,"number",{"$nulls":4},""]
[{"$nulls":10},""]
[null,null,".03","18000 btu high wall split unit",null,"number",{"$nulls":4},""]
[{"$nulls":8},{"$f":"IF($G89=\"\",\"\",$G89*H89)","v":""}]
[null,null,".04","12000 btu high wall split unit",null,"number",{"$nulls":4},{"$f":"IF($G90=\"\",\"\",$G90*J90)","v":""}]
[{"$nulls":8},{"$f":"IF($G91=\"\",\"\",$G91*H91)","v":""}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"\"TOTAL \"&$A$3&\" CARRIED TO SUMMARY:  CORRECTIVE MAINTENANCE WORK\"","v":"TOTAL  CARRIED TO SUMMARY:  CORRECTIVE MAINTENANCE WORK"},{"$nulls":8},{"$f":"SUM(K46:K96)","v":{"v":0,"d":"0.00"}}]

{"sheet":"M1","index":10,"n_rows":55,"n_cols":11,"rows_kept":55,"hidden":true,"merged":[[5,0,5,8],[17,2,17,8],[19,9,19,10],[24,2,24,4],[26,2,26,4],[28,3,28,4]]}
[]
["DEPARTMENT OF PUBLIC WORKS"]
[]
[{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[]
[]
["SCHEDULE OF QUANTITIES"]
[]
[]
[]
["NB","TENDERERS MUST COMPLETE THE SCHEDULE OF QUANTITIES IN BLACK INK"]
[]
[]
[]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!&\" - MAINTENANCE WORK\"","v":{"$error":"#REF!"}}]
[]
[{"$nulls":9},"TENDER"]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},"GENERAL - MAINTENANCE WORK"]
{"$rows_empty":29}
[null,{"$f":"\"TOTAL \"&$A$18&\" CARRIED TO SUMMARY:  MAINTENANCE WORK\"","v":{"$error":"#REF!"}}]

{"sheet":"6 Septic Tank","index":11,"n_rows":81,"n_cols":9,"rows_kept":81,"merged":[[0,2,0,4],[1,0,1,1],[2,0,2,1],[2,2,2,4],[3,2,3,4],[4,2,4,4],[5,3,5,4],[6,2,6,4],[7,2,7,4],[8,2,8,4],[9,3,9,4],[10,3,10,4],[11,2,11,4],[12,3,12,4],[13,3,13,4],[14,2,14,4],[19,2,19,4],[20,2,20,4],[21,2,21,4],[22,2,22,4],[24,3,24,4],[26,3,26,4],[28,3,28,4],[30,3,30,4],[32,3,32,4],[33,0,33,7],[34,0,34,1],[34,2,34,4],[35,2,35,4],[36,2,36,4],[37,2,37,4],[39,2,39,4],[40,3,40,4],[41,3,41,4],[46,2,46,4],[48,2,48,4],[49,2,49,4],[50,3,50,4],[53,2,53,4],[54,3,54,4],[55,3,55,4],[70,2,70,4],[72,2,72,4],[74,2,74,4],[75,0,75,7],[77,0,77,7],[81,3,81,4],[82,3,82,4],[83,3,83,4],[84,3,84,4],[85,3,85,4],[90,2,90,4],[91,2,91,4],[92,3,92,4],[94,3,94,4],[96,3,96,4],[98,2,98,4],[101,2,101,4],[102,3,102,4],[112,3,112,4],[116,3,116,4],[124,2,124,4],[125,3,125,4],[126,2,126,4],[127,3,127,4],[129,2,129,4],[130,3,130,4],[133,2,133,4],[134,2,134,4],[135,2,135,4],[136,3,136,4],[139,3,139,4],[145,3,145,4],[149,2,149,4],[150,2,150,4],[151,3,151,4],[152,3,152,4],[153,3,153,4],[154,3,154,4],[155,2,155,4],[156,3,156,4],[157,0,157,7],[159,2,159,4],[160,3,160,4],[166,3,166,4],[171,3,171,4],[175,2,175,4],[176,3,176,4],[178,2,178,4],[179,3,179,4],[182,2,182,4],[184,2,184,4],[185,3,185,4],[187,2,187,4],[188,2,188,4],[189,2,189,4],[190,3,190,4],[194,2,194,4],[195,3,195,4],[196,2,196,4],[197,2,197,4],[198,3,198,4],[199,2,199,4],[202,0,202,7],[205,2,205,4],[206,0,206,7]]}
["PAYMENT REFERS TO","ITEM NO","DESCRIPTION",null,null,"UNIT","QUANTITY","RATE","AMOUNT"]
["6: 50m3 SEPTIC TANK"]
["SCHEDULE NO 6.1 :",null,"PRELIMINARY AND GENERAL"]
[null,null,"GENERAL "]
[null,"6.1.1","Scheduled fixed - charge and value - related items:"]
[null,null,".01","Fixed prelimiary and general chages ",null,"sum",1,null,{"$f":"G6*H6","v":0}]
[null,"6.1.2","Scheduled time-related items:",null,null,"Month",1,null,{"$f":"G7*H7","v":0}]
[null,null,"TEMPORARY WORKS "]
[null,"6.1.3","Location and protection of existing services:"]
[null,null,".01","Water and sewer pipes ",null,"sum ",1,null,{"$f":"G10*H10","v":0}]
[null,null,".02","Electrical and other cables ",null,"sum ",1,null,{"$f":"G11*H11","v":0}]
[null,"6.1.4","Additional tests "]
[null,null,".01","Additional tests required by Engineer ",null,"Prov sum ",1,null,{"v":2000,"d":"2,000.00"}]
[null,null,".02","Attendance and profit ",null,"% ",{"v":2000,"d":"2,000.00"},null,{"$f":"G14*H14","v":0}]
[null,"6.1.5","Update existing key plants ",null,null,"sum",1,null,{"$f":"G15*H15","v":0}]
[null,"6.1.6","OCCUPATIONAL HEALTH AND SAFETY"]
[null,null,".01","Compliance with OHS Act and"]
[{"$nulls":3},"Construction Regulations 2003",null,"sum",1,null,{"$f":"G18*H18","v":0}]
[null,"6.1.7","HIV/AIDS AWARENESS"]
[null,null,"It is required of the Contractor to thoroughly study the Additional Specification SH: HIV / AIDS Requirements (PW 1544) of the Department that must be read together with and is deemed to be incorporated under this Section of the Bills of Quantities.  "]
[null,null," Provision for pricing of HIV/AIDS awareness is made under the items hereafter and it is explicitly pointed out that all requirements of the aforementioned specification are deemed to be priced hereunder, as the said items represent the only method of measurement and no additional items or extras to the contract in this regard shall be entertained"]
[null,null,"The Contractor must take note that compliance with the HIV/AIDS Specification is compulsory. In the event of partial or total non-compliance, the Representative/Agent, notwithstanding the provisions of Clause 52 of the General Conditions of Contract for Works of Civil Engineering Construction or any other clause to the contrary, reserves the right to delay issuing any progress payment certificate until the Contractor provides satisfactory proof of compliance. "]
[null,null,"The Contractor shall not be entitled to any compensation of whatsoever nature, including interest, due to such delay of payment  "]
["SH 07",null,".01","Awareness Campaign",null,"sum",1,null,{"$f":"G24*H24","v":0}]
[{"$nulls":3},"Selection, appointment, briefing and making available of an Awareness Campaign including provision of all relevant services."]
["SH 04.01",null,".02","Awareness Workshops",null,"sum",1,null,{"$f":"G26*H26","v":0}]
[{"$nulls":3},"Selection and appointment of a competent Service Provider approved by the Representative/Agent, provision of a Service Provider Workshop Plan and a suitable venue, conducting of awareness workshops by means of traditional and/or modern multi-media techniques, including follow-up courses, making available all tuition material and performing assessment procedures."]
["SH 04.03",null,".03","Posters, Booklets, Videos, etc.",null,"sum",1,null,{"$f":"G28*H28","v":0}]
[{"$nulls":3},"Provision, displaying, maintaining and replacing when necessary of four plastic laminated posters, booklets and educational videos, etc. for the duration of the construction period."]
["SH 05",null,".04","Access to Condoms",null,"sum",1,null,{"$f":"G30*H30","v":0}]
[{"$nulls":3},"Provision and maintenance of condom dispensers fixed in position, including male and female condoms, replenishing male and female condoms on a daily basis as required for the duration of the construction period."]
["SH 08",null,".05","Monitoring",null,"sum",1,null,{"$f":"G32*H32","v":0}]
[{"$nulls":3},"Monitoring HIV/AIDS awareness of workers, providing the Representative/Agent with access to information including making available all reports, thoroughly completed and reflecting the correct information, for the duration of the construction period and close out."]
["TOTAL PRELIMINARY AND GENERAL",{"$f":"\"TOTAL \"&$A$3&\" CARRIED TO SUMMARY:  GENERAL MAINTENANCE WORK\"","v":"TOTAL SCHEDULE NO 6.1 : CARRIED TO SUMMARY:  GENERAL MAINTENANCE WORK"},{"$nulls":6},{"$f":"SUM(I6:I32)","v":{"v":2000,"d":"2,000.00"}}]
["SCHEDULE NO 6.2 :",null,"STRUCTURAL AND BUILDING"]
[null,null,"BD:  WALLS"]
[null,null,"NEW WORK"]
["SANS",null,"EARTHWORKS (SMALL WORKS)"]
["1200 DA"]
["8.3","6.2.1","SCHEDULED ITEMS"]
["8.3.1",null,".01","Remove topsoil to nominal depth of 150mm , stockpile and maintain",null,"m2",36.25,null,{"$f":"G41*H41","v":0}]
["8.3.2",null,".02","Excavate for restricted foundation, footings and trenches in all materials and use for backfill or embankment or dispose.",null,"m3",130.5,null,{"$f":"G42*H42","v":0}]
[null,null,".03","Extra over item 8.3.2 above for:"]
[{"$nulls":3},".01","Intermediate Excavation","m3",58,null,0]
[{"$nulls":3},".02","Hard Rock Excavation","m4",29,null,0]
[null,null,".03","Backfilling using material obtained from excavation",null,"m³",36.25,null,0]
["SANS",null,"CONCRETE (STRUCTURAL)"]
["1200 G"]
[8.4,null,"SCHEDULED CONCRETE ITEMS"]
["8.4.3","6.2.2","Strength concrete:"]
[null,null,".01","Class 25Mpa/19mm concrete in floors, walls and slab",null,"m3",30,null,0]
["SANS",null,"SCHEDULED REINFORCEMENT ITEMS"]
["1200 H & GA"]
[null,"6.2.3","High-tensile steel welded mesh and steel bars:"]
[null,null,".01","R 8 Mild Steel bars",null,"kg",200,null,{"$f":"G55*H55","v":0}]
[null,null,".02","Y12 High Tensile Steel bars",null,"kg",2000,null,0]
[null,null,".02","Y16 ","High Tensile Steel bars","kg",2000,null,0]
[null,null,".03","Y20","High Tensile Steel bars","kg",1500,null,0]
[null,"6.2.4","Benching"]
[null,null,"Benching formed with dolomitic aggregate",null,null,"m3",4,null,0]
["SANS","6.2.5","SCHEDULED FORMWORK ITEMS"]
["1200GA",null,".01","Strip Formwork",null,"m",20,null,0]
[null,null,".02","Horizontal Plane Formwork (Smooth)",null,"m1",20,null,0]
[null,null,".03","Double Sided Vertical Plane Formwork (Smooth)",null,"m2",50,null,0]
[null,"6.2.6","Finishing"]
[null,null,".01","Wood float to coverslab",null,"m²",40,null,0]
[null,null,".02","Steel float to top of benching",null,"m²",20,null,0]
[null,"6.2.7","Manhole Cover"]
[null,null,"600 diameter concrete manhole cover",null,null,"number",1,null,0]
[null,"6.2.8","Overflow"]
[null,null,"110 diameter uPVC overflow pipe coumplete as per drawing 2426-G10",null,null,"number",1,null,0]
[null,"6.2.9","Ventilation"]
[null,null,"680 x 680 brick column (semi face bricks) with 110 diameter uPVC vent pipe 1 785 high complete as per drawing",null,null,"number",1,null,0]
[null,"6.2.10","Overflow Trench"]
[null,null,"Excavate and form overflow trench 500 mm wide at 1:100 fall to day light. Max length 10 m. Embankment at 1:1",null,null,"m",10,null,0]
["TOTAL STRUCTURAL AND BUILDING",{"$nulls":7},{"$f":"SUM(I41:I75)","v":0}]
[]
["SUMMARY OF SCHEDULE OF QUANTITIES: MHLWAZINI HIGH SCHOOL - SEPTIC TANK",{"$nulls":7},"AMOUNT"]
["SCHEDULE NO 7.1 :",{"$nulls":3},"PRELIMINARY AND GENERAL",{"$nulls":3},{"$f":"I34","v":{"v":2000,"d":"R 2,000.00"}}]
["SCHEDULE NO 7.2 :",{"$nulls":3},"STRUCTURAL AND BUILDING",{"$nulls":3},{"$f":"I76","v":0}]
["SUB TOTAL G: SEPTIC TANK (carry to summary page)",{"$nulls":7},{"$f":"SUM(I79:I80)","v":{"v":2000,"d":"R 2,000.00"}}]

{"sheet":"7 Electrical","index":12,"n_rows":242,"n_cols":9,"rows_kept":242,"merged":[[0,2,0,4],[1,0,1,4],[2,0,2,1],[2,2,2,4],[3,2,4,4],[5,2,5,4],[6,2,6,4],[7,2,7,4],[8,2,8,4],[9,2,9,4],[10,2,10,4],[11,2,11,4],[12,0,12,1],[12,2,12,4],[13,2,14,4],[15,2,15,4],[16,2,16,4],[17,2,17,4],[18,2,18,4],[19,2,19,4],[20,0,20,7],[21,0,21,4],[22,0,22,1],[22,2,22,4],[23,2,25,4],[26,2,26,4],[27,2,27,4],[28,2,28,4],[29,1,30,1],[29,2,30,4],[29,5,30,5],[29,6,30,6],[29,8,30,8],[31,2,31,4],[32,2,32,4],[33,2,33,4],[34,1,35,1],[34,2,35,4],[34,5,35,5],[34,6,35,6],[34,8,35,8],[36,0,36,1],[36,2,36,4],[37,2,39,4],[40,2,40,4],[41,2,41,4],[42,2,42,4],[43,2,43,4],[44,2,44,4],[45,2,45,4],[46,2,46,4],[47,2,47,4],[48,0,48,1],[48,2,48,4],[49,2,50,4],[51,2,51,4],[52,2,52,4],[53,2,53,4],[54,2,54,4],[55,2,55,4],[56,2,56,4],[57,2,57,4],[58,2,58,4],[59,0,59,7],[60,0,60,4],[61,0,61,1],[61,2,61,4],[62,2,62,4],[63,2,65,4],[66,2,66,4],[67,2,67,4],[68,2,68,4],[69,2,69,4],[70,2,70,4],[71,1,72,1],[71,2,72,4],[71,5,72,5],[71,6,72,6],[71,8,72,8],[73,2,73,4],[74,2,74,4],[75,2,75,4],[76,2,76,4],[77,2,77,4],[78,2,80,4],[81,2,81,4],[82,2,82,4],[83,2,83,4],[84,2,84,4],[85,2,85,4],[86,2,86,4],[87,2,87,4],[88,2,88,4],[89,2,89,4],[90,2,90,4],[91,2,91,4],[92,2,92,4],[93,2,93,4],[94,2,94,4],[95,0,95,1],[95,2,95,4],[96,2,96,4],[97,2,99,4],[100,2,100,4],[101,2,101,4],[102,2,102,4],[103,2,103,4],[104,2,105,4],[106,2,106,4],[107,2,107,4],[108,2,108,4],[109,2,109,4],[110,2,112,4],[113,2,113,4],[114,2,115,4],[114,5,115,5],[114,6,115,6],[114,8,115,8],[116,2,116,4],[117,2,118,4],[117,5,118,5],[117,6,118,6],[117,8,118,8],[119,2,119,4],[120,2,121,4],[120,5,121,5],[120,6,121,6],[120,7,121,7],[120,8,121,8],[122,2,122,4],[123,2,123,4],[124,2,124,4],[125,2,125,4],[126,2,126,4],[127,2,127,4],[128,0,128,1],[128,2,128,4],[129,2,129,4],[130,2,130,4],[131,2,131,4],[132,2,132,4],[133,2,133,4],[134,2,134,4],[135,2,135,4],[136,2,137,4],[136,5,137,5],[136,6,137,6],[136,8,137,8],[138,2,138,4],[139,2,139,4],[140,2,140,4],[141,2,141,4],[142,2,142,4],[143,2,143,4],[144,2,144,4],[145,2,145,4],[146,2,146,4],[147,2,147,4],[148,2,148,4],[149,2,149,4],[150,2,150,4],[151,2,151,4],[152,0,152,1],[152,2,152,4],[153,2,153,4],[154,2,155,4],[156,2,156,4],[157,2,158,4],[157,5,158,5],[157,6,158,6],[157,8,158,8],[159,2,159,4],[160,2,160,4],[161,2,162,4],[161,5,162,5],[161,6,162,6],[161,8,162,8],[163,2,163,4],[164,0,164,7],[165,0,165,4],[166,0,166,1],[166,2,166,4],[167,2,167,4],[168,2,170,4],[171,2,171,4],[172,2,172,4],[173,2,173,4],[174,2,174,4],[175,2,176,4],[177,2,177,4],[178,2,178,4],[179,2,179,4],[180,2,180,4],[181,2,183,4],[184,2,184,4],[185,2,185,4],[186,2,186,4],[187,2,188,4],[189,2,189,4],[190,2,190,4],[191,2,191,4],[192,2,192,4],[193,1,194,1],[193,2,194,4],[193,5,194,5],[193,6,194,6],[193,8,194,8],[195,0,195,7],[196,0,196,4],[197,0,197,1],[197,2,197,4],[198,1,200,1],[198,2,200,4],[198,5,200,5],[198,6,200,6],[198,7,200,7],[198,8,200,8],[201,0,201,1],[201,2,201,4],[202,1,206,1],[202,2,206,4],[202,5,206,5],[202,6,206,6],[202,7,206,7],[202,8,206,8],[207,0,207,1],[207,2,207,4],[208,1,211,1],[208,2,211,4],[208,5,211,5],[208,6,211,6],[208,7,211,7],[208,8,211,8],[212,0,212,1],[212,2,212,4],[213,1,215,1],[213,2,215,4],[213,5,215,5],[213,6,215,6],[213,7,215,7],[213,8,215,8],[216,0,216,1],[216,2,216,4],[217,1,218,1],[217,2,218,4],[217,5,218,5],[217,6,218,6],[217,7,218,7],[217,8,218,8],[219,2,219,4],[220,2,220,4],[221,2,221,4],[222,2,222,4],[223,0,223,7],[224,0,224,4],[225,0,226,1],[225,2,226,4],[227,2,227,4],[228,2,229,4],[230,2,230,4],[231,3,231,4],[232,0,232,7],[233,2,233,4],[234,0,234,7],[235,0,235,7],[236,0,236,7],[237,0,237,7],[238,0,238,7],[239,0,239,7],[240,0,240,7]]}
["PAYMENT REFERS TO","ITEM NO","DESCRIPTION",null,null,"UNIT","QUANTITY","RATE","AMOUNT"]
["2 : SITE WORK - ELECTRICAL"]
["SCHEDULE NO 2.1",null,"EXCAVATIONS, BEDDING AND BACKFILLING FOR SLEEVES"]
[null,null,"Cable trenching as well as bedding below and above sleeves plus backfilling and compaction in layers as specified."]
[]
[null,null,"The volume will be calculated as follows : (length x 0.45 x 0.7)"]
[null,null,"Total measured length :",null,null,{"v":60,"d":"60.00"}]
[null,"A","Hard rock (10% Allowed for)",null,null,"m3",{"v":0,"d":"0.00"},null,{"$f":"G8*H8","v":0}]
[null,"B","Soft rock (15% Allowed for)",null,null,"m3",{"v":0,"d":"0.00"},null,{"$f":"G9*H9","v":0}]
[null,"C","Soil (75% Allowed for)",null,null,"m3",{"v":0,"d":"0.00"},null,0]
[null,"D","Sifted and/or imported bedding sand.     (20%)",null,null,"m3",{"v":0,"d":"0.00"},null,0]
[null,"E","Backfilling and compaction in layers.    (80%)",null,null,"m3",{"v":0,"d":"0.00"},null,0]
["SCHEDULE NO 2.2",null,"SLEEVES FOR SERVICES"]
[null,null,"The supply, delivery and installation of the following PVC sleeves for road crossings and/or DB entries."]
[]
[null,null,"All Telkom sleeves shall be complete with drawwire"]
[null,"F","PVC 50 mm diametre                                     Supply & delivery :",null,null,"m ",{"v":30,"d":"30.00"},null,{"$f":"G17*H17","v":0}]
[null,"G","PVC 50 mm diametre                                                 Installation :",null,null,"m",{"v":30,"d":"30.00"},null,{"$f":"G18*H18","v":0}]
[null,"H","PVC 50 mm diametre  Slow bends                 Supply & delivery :",null,null,"each",{"v":2,"d":"2.00"},null,0]
[null,"I ","PVC 50 mm diametre  Slow bends                             Installation :",null,null,"each",{"v":2,"d":"2.00"},null,0]
["TOTAL : SITE WORK",{"$f":"\"TOTAL \"&$A$1&\" CARRIED TO SUMMARY:  GENERAL MAINTENANCE WORK\"","v":"TOTAL PAYMENT REFERS TO CARRIED TO SUMMARY:  GENERAL MAINTENANCE WORK"},{"$nulls":6},{"$f":"SUM(I8:I20)","v":0}]
["3 : DISTRIBUTION BOARDS & CABLES"]
["SCHEDULE NO 3.1",null,"DISTRIBUTION BOARDS"]
[null,null,"The supply, delivery and installation of the electrical + Telk / Data Distribution Boards as specified, indicated on the drawings and/or implied, completely wired in the manufacturers factory with all equipment."]
[]
[]
[null,null,"The supply and delivery only of the following :-"]
[null,"A","MAIN   DB  (In Admin Block)",null,null,"each",{"v":1,"d":"1.00"},null,{"$f":"H28*G28","v":0}]
[null,"B","MAIN   CR  (Class Room)",null,null,"each",{"v":1,"d":"1.00"},null,{"$f":"H29*G29","v":0}]
[null,"C","Telk/Data DB in Admin Block (450 x 450 x 150 deep) with Softwood board inside for mounting of equipment",null,null,"each",{"v":1,"d":"1.00"},null,{"$f":"H30*G30","v":0}]
[]
[null,null,"The installation only of the following :-"]
[null,"D","MAIN   DB  (In Admin Block)",null,null,"each",{"v":1,"d":"1.00"},null,{"$f":"G33*H33","v":0}]
[null,"E","MAIN   CR  (Class Room)",null,null,"each",{"v":1,"d":"1.00"},null,{"$f":"G34*H34","v":0}]
[null,"F","Telk/Data DB in Admin Block (450 x 450 x 150 deep) with Softwood board inside for mounting of equipment",null,null,"each",{"v":1,"d":"1.00"},null,{"$f":"H35*G35","v":0}]
[]
["SCHEDULE NO 3.2",null,"SUPPLY CABLES AND EARTH WIRES TO DB's"]
[null,null,"The supply, delivery and installation of the electrical cables through sleeves, in trenches, on cable ladders, against walls, structural steelwork or in conduits as shown on the drawings and/or implied by the specification."]
[]
[]
[null,null,"The supply and delivery only of the following  cables  & BCE:-"]
[null,"G","Cu PVC/SWA  Cable, cores x 4 x mm² = 35",null,null,"m",{"v":200,"d":"200.00"},null,{"$f":"G42*H42","v":0}]
[null,"H","BCE x mm² = 16",null,null,"m",{"v":0,"d":"0.00"},null,{"$f":"G43*H43","v":0}]
[null,"I","Cu PVC/SWA  Cable, cores x 3 x mm² = 4",null,null,1,{"v":80,"d":"80.00"},null,0]
[null,null,"The installation only of the following  cables  & BCE:-"]
[null,"J","Cu PVC/SWA  Cable, cores x 4 x mm² = 35",null,null,"m",{"v":200,"d":"200.00"},null,{"$f":"G46*H46","v":0}]
[null,"K","BCE x mm² = 16",null,null,"m",{"v":0,"d":"0.00"},null,{"$f":"G47*H47","v":0}]
[null,"L","Cu PVC/SWA  Cable, cores x 3 x mm² = 4",null,null,"m",{"v":80,"d":"80.00"},null,0]
["SCHEDULE NO 3.3",null,"CABLE TERMINATIONS"]
[null,null,"The supply, delivery and installation of the following cable terminations, including glands, shrouds, lugs etc to ensure a complete termination as specified or implied."]
[]
[null,null,"The supply and delivery only of the following cable termination material."]
[null,"M","Cu PVC/SWA  Cable, cores x 4 x mm² = 35",null,null,"each",{"v":2,"d":"2.00"},null,{"$f":"H53*G53","v":0}]
[null,"N","BCE x mm² = 16",null,null,"each",{"v":2,"d":"2.00"},null,{"$f":"H54*G54","v":0}]
[null,"O","Cu PVC/SWA  Cable, cores x 3 x mm² = 4",null,null,"each",{"v":2,"d":"2.00"},null,0]
[null,null,"The installation only of the following cable terminations"]
[null,"P","Cu PVC/SWA  Cable, cores x 4 x mm² = 35",null,null,"each",{"v":2,"d":"2.00"},null,0]
[null,"Q","BCE x mm² = 16",null,null,"each",{"v":2,"d":"2.00"},null,0]
[null,"R","Cu PVC/SWA  Cable, cores x 3 x mm² = 4",null,null,"each",{"v":2,"d":"2.00"},null,0]
["TOTAL : DISTRIBUTION BOARDS & CABLES",{"$f":"\"TOTAL \"&$A$1&\" CARRIED TO SUMMARY:  GENERAL MAINTENANCE WORK\"","v":"TOTAL PAYMENT REFERS TO CARRIED TO SUMMARY:  GENERAL MAINTENANCE WORK"},{"$nulls":6},{"$f":"SUM(I28:I59)","v":0}]
["4 : ADMIN BLOCK"]
["SCHEDULE NO 4.1",null,"ELECTRICAL LIGHTING AND POWER PLUS TELKOM + INTERCOM INSTALLATION"]
[null,"4.1.1","CONDUIT"]
[null,null,"The supply, delivery and installation of the following conduit incl. all couplings, male- & female bushes, threading, reaming, bending, fixing saddles and screws for wiring purposes of circuits."]
[]
[]
[null,null,"Supply and delivery on site of the following PVC conduit;"]
[null,"A","20 mm diametre",null,null,"m",{"v":210,"d":"210.00"},null,{"$f":"H68*G68","v":0}]
[null,"B","25 mm diametre",null,null,"m",{"v":10,"d":"10.00"},null,{"$f":"H69*G69","v":0}]
[null,"C","32 mm diametre",null,null,"m",{"v":10,"d":"10.00"},null,0]
[null,"D","20 mm diametre flexible \"Kopex\" with 2 end connectors for Geyser or Stove",null,null,"m",{"v":1,"d":"1.00"},null,0]
[null,null,"Installation of the following PVC conduit irrespective of surface, in brick or in concrete;"]
[]
[null,"E","20 mm diametre",null,null,"m",{"v":210,"d":"210.00"},null,{"$f":"H74*G74","v":0}]
[null,"F","25 mm diametre",null,null,"m",{"v":10,"d":"10.00"},null,0]
[null,"G","32 mm diametre",null,null,"m",{"v":10,"d":"10.00"},null,0]
[null,"H","20 mm diametre flexible \"Kopex\" with 2 end connectors for Geyser or Stove",null,null,"m",{"v":1,"d":"1.00"},null,0]
[null,"4.1.2","Cu PVC INSULATED CONDUCTOR AND BARE COPPER EARTH WIRE"]
[null,null,"The supply, delivery and installation of the following Cu PVC insulated conductors and bare copper earth wire through conduit, in wiring channel or power skirting etc. as specified and/or implied."]
[]
[]
[null,null,"Supply and delivery on site of the following :-"]
[null,"I","Cu PVC insulated conductor   -  6 mm² (Stove)",null,null,"m",{"v":0,"d":"0.00"},null,{"$f":"H83*G83","v":0}]
[null,"J","Cu PVC insulated conductor   -  4 mm² (All socket circuits)",null,null,"m",{"v":400,"d":"400.00"},null,{"$f":"H84*G84","v":0}]
[null,"K","Cu PVC insulated conductor   - 2.5 mm² (All lighting circuits)",null,null,"m",{"v":425,"d":"425.00"},null,0]
[null,"L","Stranded bare copper earth wire    -  4 mm² (BCE)",null,null,"m",{"v":0,"d":"0.00"},null,0]
[null,"M","Stranded bare copper earth wire    -  2.5 mm² (BCE)",null,null,"m",{"v":370,"d":"370.00"},null,0]
[null,"N","Galvanised draw wire   -  1,5 mm²",null,null,"m",{"v":60,"d":"60.00"},null,0]
[null,null,"Installation only of the following :-"]
[null,"O","Cu PVC insulated conductor   -  6 mm² (Stove)",null,null,"m",{"v":0,"d":"0.00"},null,{"$f":"G90*H90","v":0}]
[null,"P","Cu PVC insulated conductor   -  4 mm² (All socket circuits)",null,null,"m",{"v":400,"d":"400.00"},null,{"$f":"G91*H91","v":0}]
[null,"Q","Cu PVC insulated conductor   - 2.5 mm² (All lighting circuits)",null,null,"m",{"v":425,"d":"425.00"},null,0]
[null,"R","Stranded bare copper earth wire    -  4 mm² (BCE)",null,null,"m",{"v":0,"d":"0.00"},null,0]
[null,"S","Stranded bare copper earth wire    -  2.5 mm² (BCE)",null,null,"m",{"v":370,"d":"370.00"},null,0]
[null,"T","Galvanised draw wire   -  1,5 mm²",null,null,"m",{"v":60,"d":"60.00"},null,0]
["SCHEDULE NO 4.2",null,"ELECTRICAL LIGHTING AND POWER PLUS TELKOM + INTERCOM INSTALLATION"]
[null,"4.2.1","DRAWBOXES FOR LIGHTING AND POWER"]
[null,null,"The supply, delivery and installation of the following draw boxes for installtion with conduit complete with craddles etc. as specified indicated on the drawings and/or implied."]
[]
[]
[null,null,"Supply and delivery on site of the following :-"]
[null,"A","100 x 50 x 50 mm for light switches",null,null,"each",{"v":22,"d":"22.00"},null,{"$f":"G102*H102","v":0}]
[null,"B","100 x 100 x 50 mm without cover plates",null,null,"each",{"v":47,"d":"47.00"},null,{"$f":"G103*H103","v":0}]
[null,"C","Shallow 60 mm round for 20 mm dia conduit with cover plates",null,null,"each",{"v":60,"d":"60.00"},null,0]
[null,null,"Installation of the following PVC draw boxes irrespective of surface, in brick or in concrete;"]
[]
[null,"D","100 x 50 x 50 mm for light switches",null,null,"each",{"v":22,"d":"22.00"},null,{"$f":"H107*G107","v":0}]
[null,"E","100 x 100 x 50 mm without cover plates",null,null,"each",{"v":47,"d":"47.00"},null,{"$f":"H108*G108","v":0}]
[null,"F","Shallow 60 mm round for 20 mm dia conduit with cover plates",null,null,"each",{"v":60,"d":"60.00"},null,0]
[null,"4.2.2","COVER PLATES FOR TEL/DATA & TV SOCKETS"]
[null,null,"The supply, delivery and installation of the following cover plates with cutouts for Telkom/Data (RJ11/RJ45) sockets as specified implied. The actual sockets will be supplied & installed by others."]
[]
[]
[null,null,"Supply and delivery on site of the following :-"]
[null,"G","100 x 100 Cover plate for 1 x RJ11 & 1 x RJ45 next to each other. One cutout for both Tel and Data socket only.",null,null,"each",{"v":10,"d":"10.00"},null,{"$f":"G115*H115","v":0}]
[]
[null,null,"Installation only of the following :-"]
[null,"H","100 x 100 Cover plate for 1 x RJ11 & 1 x RJ45 next to each other. One cutout for both Tel and Data socket only.",null,null,"each",{"v":10,"d":"10.00"},null,{"$f":"G118*H118","v":0}]
[]
[null,"4.3.1","LIGHT SWITCHES"]
[null,null,"The supply, delivery and installation of the following light switches complete with craddles and coverplates as specified and/or implied."]
[]
[null,null,"Supply and delivery on site of the following :-"]
[null,"I","16A Complete with cover plate   -   1 Way / 1 Lever",null,null,"each",{"v":14,"d":"14.00"},null,{"$f":"G124*H124","v":0}]
[null,"J","16A Complete with cover plate   -   1 Way / 2 Lever",null,null,"each",{"v":0,"d":"0.00"},null,{"$f":"G125*H125","v":0}]
[null,"K","16A Complete with cover plate   -   1 Way / 3 Lever",null,null,"each",{"v":0,"d":"0.00"},null,0]
[null,"L","16A Complete with cover plate   -   2 Way / 1 Lever",null,null,"each",{"v":2,"d":"2.00"},null,0]
[null,"M","Photocell.",null,null,"each",{"v":2,"d":"2.00"},null,0]
["SCHEDULE NO 4.3",null,"LIGHT SWITCHES - CONTINIOUS"]
[null,"4.3.1","Installation and connecting up of light switches as specified"]
[null,"A","16A Complete with cover plate   -   1 Way / 1 Lever",null,null,"each",{"v":14,"d":"14.00"},null,{"$f":"H131*G131","v":0}]
[null,"B","16A Complete with cover plate   -   1 Way / 2 Lever",null,null,"each",{"v":0,"d":"0.00"},null,{"$f":"H132*G132","v":0}]
[null,"C","16A Complete with cover plate   -   1 Way / 3 Lever",null,null,"each",{"v":0,"d":"0.00"},null,0]
[null,"D","16A Complete with cover plate   -   2 Way / 1 Lever",null,null,"each",{"v":2,"d":"2.00"},null,0]
[null,"E","Photocell.",null,null,"each",{"v":2,"d":"2.00"},null,0]
[null,"4.3.2","SOCKET OUTLETS AND ISOLATORS"]
[null,null,"The supply, delivery and installation of the following SSO's and Isolators complete as specified and/or implied."]
[]
[null,null,"Supply and delivery on site of the following :-"]
[null,"F","Switched socket outlet - Single for 100 x  100 box.",null,null,"each",{"v":37,"d":"37.00"},null,{"$f":"G140*H140","v":0}]
[null,"G","Switched socket outlet - Double for 100 x 100 box",null,null,"each",{"v":1,"d":"1.00"},null,{"$f":"G141*H141","v":0}]
[null,"H","5A Unswitched socket outlet for shallow round box",null,null,"each",{"v":0,"d":"0.00"},null,0]
[null,"I","20 Amp 2P isolator complete as specified. (Geyser)",null,null,"each",{"v":1,"d":"1.00"},null,0]
[null,"J","30 Amp 2P isolator complete for Stoves",null,null,"each",{"v":0,"d":"0.00"},null,0]
[null,"K","30 Amp 2P isolator complete for A/C units",null,null,"each",{"v":0,"d":"0.00"},null,0]
[null,null,"Installation and connecting up of the following as specified"]
[null,"L","Switched socket outlet - Single for 100 x  100 box.",null,null,"each",{"v":37,"d":"37.00"},null,{"$f":"G147*H147","v":0}]
[null,"M","Switched socket outlet - Double for 100 x 100 box",null,null,"each",{"v":1,"d":"1.00"},null,{"$f":"G148*H148","v":0}]
[null,"N","5A Unswitched socket outlet for shallow round box",null,null,"each",{"v":0,"d":"0.00"},null,0]
[null,"O","20 Amp 2P isolator complete as specified. (Geyser)",null,null,"each",{"v":1,"d":"1.00"},null,0]
[null,"P","30 Amp 2P isolator complete for Stoves",null,null,"each",{"v":0,"d":"0.00"},null,0]
[null,"Q","30 Amp 2P isolator complete for A/C units",null,null,"each",{"v":0,"d":"0.00"},null,0]
["SCHEDULE NO 4.4",null,"ELECTRICAL LIGHTING AND POWER PLUS TELKOM + INTERCOM INSTALLATION"]
[null,"4.1.4","LUMINAIRES (LIGHT FITTINGS)"]
[null,null,"The supply, delivery and installation of the following light fittings complete with all cords, plugtops etc. and lamps as specified an/or implied."]
[]
[null,null,"Supply and delivery of the following Light Fittings :-"]
[null,"A","Light fitting complete as specied with lamp/s - Type BH = Same for wall- and ceiling mounting",null,null,"each",{"v":29,"d":"29.00"},null,{"$f":"H158*G158","v":0}]
[]
[null,"B","Light fitting complete as specied with lamp/s - Type F2",null,null,"each",{"v":31,"d":"31.00"},null,{"$f":"H160*G160","v":0}]
[null,null,"Installation of the following Light Fittings :-"]
[null,"C","Light fitting complete as specied with lamp/s - Type BH = Same for wall- and ceiling mounting",null,null,"each",{"v":29,"d":"29.00"},null,{"$f":"H162*G162","v":0}]
[]
[null,"D","Light fitting complete as specied with lamp/s - Type F2",null,null,"each",{"v":31,"d":"31.00"},null,{"$f":"H164*G164","v":0}]
["TOTAL : ADMIN BLOCK",{"$f":"\"TOTAL \"&$A$1&\" CARRIED TO SUMMARY:  GENERAL MAINTENANCE WORK\"","v":"TOTAL PAYMENT REFERS TO CARRIED TO SUMMARY:  GENERAL MAINTENANCE WORK"},{"$nulls":6},{"$f":"SUM(I68:I164)","v":0}]
["5 : INTERCOM AND PERIOD BELL INSTALLATION"]
["SCHEDULE NO 5.1",null,"INTERCOM AND PERIOD BELL INSTALLATION"]
[null,"5.1.1","CONDUIT"]
[null,null,"The supply, delivery and installation of the following conduit incl. all couplings, male- & female bushes, threading, reaming, bending, fixing saddles and screws for wiring purposes of circuits."]
[]
[]
[null,null,"Supply and delivery on site of the following PVC conduit;"]
[null,"A","20 mm diametre",null,null,"m",{"v":40,"d":"40.00"},null,{"$f":"G173*H173","v":0}]
[null,"B","25 mm diametre",null,null,"m",{"v":20,"d":"20.00"},null,{"$f":"G174*H174","v":0}]
[null,"C","Galvanized draw wire   -  1,5 mm²",null,null,"m",{"v":60,"d":"60.00"},null,0]
[null,null,"Installation of the following PVC conduit irrespective of surface, in brick or in concrete;"]
[]
[null,"D","20 mm diametre",null,null,"m",{"v":40,"d":"40.00"},null,{"$f":"G178*H178","v":0}]
[null,"E","25 mm diametre",null,null,"m",{"v":20,"d":"20.00"},null,{"$f":"G179*H179","v":0}]
[null,"F","Galvanized draw wire   -  1,5 mm²",null,null,"m",{"v":60,"d":"60.00"},null,0]
[null,"4.1.2","DRAWBOXES"]
[null,null,"The supply, delivery and installation of the following draw boxes for installtion with conduit complete with craddles etc. as specified indicated on the drawings and/or implied."]
[]
[]
[null,null,"Supply and delivery on site of the following :-"]
[null,"G","100 x 100 x 50 mm without cover plates",null,null,"m",{"v":5,"d":"5.00"},null,{"$f":"G186*H186","v":0}]
[null,"H","Shallow 60 mm round for 20 mm dia conduit with cover plates",null,null,"m",{"v":4,"d":"4.00"},null,{"$f":"G187*H187","v":0}]
[null,null,"Installation of the following PVC draw boxes irrespective of surface, in brick or in concrete;"]
[]
[null,"I","100 x 100 x 50 mm without cover plates",null,null,"m",{"v":5,"d":"5.00"},null,{"$f":"G190*H190","v":0}]
[null,"J","Shallow 60 mm round for 20 mm dia conduit with cover plates",null,null,"m",{"v":4,"d":"4.00"},null,{"$f":"G191*H191","v":0}]
[null,null,"The supply, delivery and installation of the following equipment complete;",null,null,"m"]
[null,"K","Bell Pushbutton for mounting in a 100 x 50 x 50 draw box",null,null,"m",{"v":1,"d":"1.00"},null,{"$f":"H193*G193","v":0}]
[null,"L","Audible school period clock for surface mounting against wall over a 60mm dia. Round box",null,null,"m",{"v":1,"d":"1.00"},null,{"$f":"H194*G194","v":0}]
[]
["TOTAL : INTERCOM AND PERIOD BELL INSTALLATION",{"$f":"\"TOTAL \"&$A$1&\" CARRIED TO SUMMARY:  GENERAL MAINTENANCE WORK\"","v":"TOTAL PAYMENT REFERS TO CARRIED TO SUMMARY:  GENERAL MAINTENANCE WORK"},{"$nulls":6},{"$f":"SUM(I173:I195)","v":0}]
["6 : SUNDRIES"]
["SCHEDULE NO 6.1",null,"GENERAL EARTHING AND BONDING"]
[null,"A","The tenderer shall allow against this item for the general earthing and bonding (not lightning protection) of the complete installation in accordance with SANS 0142 as amended.",null,null,"sum",{"v":1,"d":"1.00"},null,{"$f":"G199*H199","v":0}]
[]
[]
["SCHEDULE NO 6.2",null,"LIGHTNING PROTECTION BY SPECIALIST"]
[null,"B","The amount/rate to be entered here need to be obtained from a specialist earthing and lightning protection company which will ensure that the Building is properly protected against lightning strike. This cvompany will also issue a COC in accordance with the latest SANS 03 specifications upon completion of the works undertaken by them.",null,null,"sum",{"v":1,"d":"1.00"},null,{"$f":"G203*H203","v":0}]
[]
[]
[]
[]
["SCHEDULE NO 6.3",null,"TESTING AND COMMISIONING"]
[null,"C","The tenderer shall allow against this item for the complete testing, attending of inspections as needed, as well as the commissioning and handing over of the entire installation to the satisfaction of the engineer, his representative and/or the client or his representative",null,null,"sum",{"v":1,"d":"1.00"},null,{"$f":"G209*H209","v":0}]
[]
[]
[]
["SCHEDULE NO 6.4",null,"CERTIFICATE OF COMPLIANCE (C.O.C.'s)"]
[null,"D","The amount allowed for under this item shall be for the testing and recording of measurements (electrical) per DB area in order to issue a C.O.C. in accordance with SANS 0142 as amended per DB or Block",null,null,"sum",{"v":1,"d":"1.00"},null,{"$f":"G214*H214","v":0}]
[]
[]
["SCHEDULE NO 6.5",null,"OTHER ITEMS"]
[null,"E","If so required, any and all items to ensure a 100% complete installation must be entered here.",null,null,"sum",{"v":1,"d":"1.00"},null,{"$f":"G218*H218","v":0}]
[]
[null,"i",{"$nulls":3},"sum",{"v":1,"d":"1.00"},null,0]
[null,"ii",{"$nulls":3},"sum",{"v":1,"d":"1.00"},null,0]
[null,"iii",{"$nulls":3},"sum",{"v":1,"d":"1.00"},null,0]
[null,"iv",{"$nulls":3},"sum",{"v":1,"d":"1.00"},null,0]
["TOTAL : SUNDRIES",{"$f":"\"TOTAL \"&$A$1&\" CARRIED TO SUMMARY:  GENERAL MAINTENANCE WORK\"","v":"TOTAL PAYMENT REFERS TO CARRIED TO SUMMARY:  GENERAL MAINTENANCE WORK"},{"$nulls":6},{"$f":"SUM(I199:I223)","v":0}]
["7 : LOCAL SUPPLY AUTHORITY ELECTRICAL SUPPLY"]
["SCHEDULE NO 7.1",null,"ACTUAL AMOUNT FOR UPGRADED / NEW SUPPLY PAYABLE TO LOCAL AUTHORITY"]
[]
[]
[null,null,"The allowance in this BOQ is for the successful electrical contractor to carry out the following physical work;"]
[]
[null,"A","The Actual connection/ termination of the supply cable to the New Main Admin DB",null,null,"Prov.sum",{"v":1,"d":"1.00"},{"v":10000,"d":"10,000.00"},{"$f":"H231*G231","v":{"v":10000,"d":"10,000.00"}}]
[{"$nulls":3},"Attendance and profit ",null,"% ",{"$f":"I231","v":{"v":10000,"d":"10,000.00"}},null,{"$f":"G232*H232","v":0}]
["TOTAL :  LOCAL SUPPLY AUTHORITY ELECTRICAL SUPPLY",{"$f":"\"TOTAL \"&$A$1&\" CARRIED TO SUMMARY:  GENERAL MAINTENANCE WORK\"","v":"TOTAL PAYMENT REFERS TO CARRIED TO SUMMARY:  GENERAL MAINTENANCE WORK"},{"$nulls":6},{"$f":"SUM(I231:I232)","v":{"v":10000,"d":"10,000.00"}}]
[]
["SUMMARY OF SCHEDULE OF QUANTITIES: MHLWAZINI HIGH SCHOOL - ELECTRICAL",{"$nulls":7},"AMOUNT"]
[{"$f":"A2","v":"2 : SITE WORK - ELECTRICAL"},{"$nulls":7},{"$f":"I21","v":0}]
[{"$f":"A22","v":"3 : DISTRIBUTION BOARDS & CABLES"},{"$nulls":7},{"$f":"I60","v":0}]
[{"$f":"A61","v":"4 : ADMIN BLOCK"},{"$nulls":7},{"$f":"I165","v":0}]
[{"$f":"A166","v":"5 : INTERCOM AND PERIOD BELL INSTALLATION"},{"$nulls":7},{"$f":"I196","v":0}]
[{"$f":"A197","v":"6 : SUNDRIES"},{"$nulls":7},{"$f":"I224","v":0}]
[{"$f":"A225","v":"7 : LOCAL SUPPLY AUTHORITY ELECTRICAL SUPPLY"},{"$nulls":7},{"$f":"I233","v":{"v":10000,"d":"10,000.00"}}]
["SUB TOTAL : ELECTRICAL WORK (carry to summary page)",{"$nulls":7},{"$f":"SUM(I236:I241)","v":{"v":10000,"d":"10,000.00"}}]

{"sheet":"Summary","index":13,"n_rows":11,"n_cols":3,"rows_kept":11}
["SUMMARY OF SCHEDULE OF QUANTITIES: MHLWAZINI HIGH SCHOOL ",null,"AMOUNT"]
[1,"ADMINISTRATION BLOCK",{"$f":"'1 Admin block'!I316","v":{"v":120000,"d":"R 120,000.00"}}]
[2,"CLASSROOM A",{"$f":"'2 Classroom A'!I196","v":{"v":5000,"d":"R 5,000.00"}}]
[3,"CLASSROOM B",{"$f":"'3 Classroom B'!I194","v":{"v":5000,"d":"R 5,000.00"}}]
[4,"ABLUTION BLOCK - BOYS",{"$f":"'4 Ablution block - Boys'!I231","v":{"v":28156.25,"d":"R 28,156.25"}}]
[5,"ABLUTION BLOCK - GIRLS",{"$f":"'5 Ablution block - Girls'!I229","v":{"v":30077.5,"d":"R 30,077.50"}}]
[6,"SEPTIC TANK",{"$f":"'6 Septic Tank'!I81","v":{"v":2000,"d":"R 2,000.00"}}]
[7,"ELECTRICAL",{"$f":"'7 Electrical'!I242","v":{"v":10000,"d":"R 10,000.00"}}]
["SUB-TOTAL",null,{"$f":"SUM(C2:C8)","v":{"v":200233.75,"d":"R 200,233.75"}}]
["VAT (15%)",null,{"$f":"C9*15%","v":{"v":30035.0625,"d":"R 30,035.06"}}]
["TOTAL ",null,{"$f":"C9+C10","v":{"v":230268.8125,"d":"R 230,268.81"}}]