{"text_format":"3","workbook":"xlsx","n_sheets":32,"sheets":["Notes","P&Gs 1","P & Gs 2","Alterations","Alterations 2","BoQ Works 1","BoQ Works 2","BoQ Works 3","BoQ Works 4","BoQ Works 5","BoQ Works 6","BoQ Works 7","BoQ Works 8","BoQ Works 9","BoQ Works 10","BoQ Works 11","BoQ Works 12","BoQ Works 13","BoQ Works 14","BoQ Works 15","BoQ Works 16","BoQ Works 17","BoQ Works 18","BoQ Works 19","BoQ Works 20","BoQ Works 21","External Lighting BoQ 1","External Lighting BoQ 2","External Lighting BoQ 3","External Lighting BoQ 4","External Lighting BoQ 5","SUMMARY"],"not_rendered":{"defined_names":37},"read":"whole","date_system":"1900"}

{"sheet":"Notes","index":0,"n_rows":8,"n_cols":1,"rows_kept":8,"merged":[[1,0,1,5],[7,0,7,5],[9,0,9,5],[10,0,10,5],[11,0,11,5],[12,0,12,5],[13,0,13,5],[14,0,14,5],[15,0,15,5],[16,0,16,5],[17,0,17,5],[18,1,18,7],[19,1,19,7],[20,1,20,7],[21,1,21,7],[22,1,22,7],[23,1,23,7],[30,1,30,7]]}
[]
["FRAMEWORK CONTRACTS FOR ELECTRICAL WORKS - BUILDINGS & EXTERNAL LIGHTING IN VARIOUS TNPA PREMISES - 3 YEARS"]
[]
["PROJECT NO.: "]
[]
[]
["PRICING DATA"]
["1.1.        Pricing Notes for Framework Contracts"]

{"sheet":"P&Gs 1","index":1,"n_rows":94,"n_cols":6,"rows_kept":94}
[{"$f":"+Notes!A2","v":"FRAMEWORK CONTRACTS FOR ELECTRICAL WORKS - BUILDINGS & EXTERNAL LIGHTING IN VARIOUS TNPA PREMISES - 3 YEARS"}]
[]
[{"$nulls":5},"EB.PG1"]
["Item","Description","Unit","Quantity","Rate","Amount"]
[]
[null,"CHARGE/LUMP SUM ITEMS"]
[]
["EB.PG1","Contractual requirements, Compliance & Management"]
[]
["EB.PG01","Compliace with OHS ACT including Transnet policies","Item",1,"Work package stage"]
[]
["EB.PG02","Provision of a health and safety plan","Item",1,"Work package stage"]
[]
["EB.PG03","Provision of a health and safety file","Item",1,"Work package stage"]
[]
["EB.PG04","Health and safety training","item",1,"Work package stage"]
[]
["EB.PG05","Provision of a Safety officer","Months",1,null,{"$f":"D18*E18","v":0}]
[]
["EB.PG06","Provision of a Safety Manager","Months",1,null,0]
[]
["EB.PG07","Provision of personal protective clothing and equipment","item",1,"Work package stage"]
[]
["EB.PG08","Compliace with Environment Management Plan including Transnet policies","Item",1,"Work package stage"]
[]
["EB.PG09","Insurance (liability, works risk, indemnity, etc)","Item",1,"Work package stage"]
[]
["EB.PG10","Management of the works","Item",1,"Work package stage"]
[]
["EB.PG11","Site supervision","Item",1,"Work package stage"]
[]
["EB.PG12","Other fixed charge obligations",null,1,"Work package stage"]
[]
["EB.PG13","Contractor to Specify: ","Item",1,"Work package stage"]
[]
["EB.PG14","Other time related items","Item",1,"Work package stage"]
[]
["EB.PG15","Contractor to Specify: "]
[]
["EB.PG15.01","SCHEDULED TIME RELATED ITEMS"]
[]
["EB.PG15.01(a)","Facilities for Engineer"]
[]
["(i)","Furnished offices","Months",1,null,{"$f":"D44*E44","v":0}]
[]
["(ii)","Nameboards","Months",1,null,{"$f":"D46*E46","v":0}]
[]
["(iii)","Telephone","Months",1,null,{"$f":"D48*E48","v":0}]
[]
["(iv)","Survey assistance and materials","Months",1,null,{"$f":"D50*E50","v":0}]
[]
["EB.PG15.01(b)","Facilities for Contractor"]
[]
["(i)","Storage sheds and facilities","Months",1,null,{"$f":"D54*E54","v":0}]
[]
["(ii)","Tools and equipment","Months",1,null,{"$f":"D56*E56","v":0}]
[]
["(iii)","Workshops","Months",1,null,{"$f":"D58*E58","v":0}]
[]
["(iv)","Living accomodation","Months",1,null,{"$f":"D60*E60","v":0}]
[]
["(v)","Access and access control","Months",1,null,{"$f":"D62*E62","v":0}]
[]
["(vi)","Plant (related to temporary offices of a contractor)","Months",1,null,{"$f":"D64*E64","v":0}]
[]
["(vii)","Removal of site establishment","Months",1,null,{"$f":"D66*E66","v":0}]
[]
["(viii)","Laboratories","Months",1,null,{"$f":"D68*E68","v":0}]
[]
["(ix)","Ablution and latrine facilities","Months",1,null,{"$f":"D70*E70","v":0}]
[]
["(x)","Tools and equipment","Months",1,null,0]
[]
["(xi)","Water, electricity and communications","Months",1,null,{"$f":"D74*E74","v":0}]
[]
["(xii)","Dealing with water","Months",1,null,{"$f":"D76*E76","v":0}]
[]
["(xiii)","Access and access control","Months",1,null,{"$f":"D78*E78","v":0}]
[]
["(xiv)","Plant","Months",1,"refer to (vi)"]
[]
["(xv)","Supervision for the duration of construction","Months",1,null,{"$f":"D82*E82","v":0}]
[]
["(xvi)","Company and head office overheads duration of construction","Months",1,null,{"$f":"D84*E84","v":0}]
[]
["(xvii)","Other Fixed Charged Obligations","Months",1,null,{"$f":"D86*E86","v":0}]
[]
["EB.PG15.01(c)","Temporary works"]
[]
["(i)","Maintain access roads to site","Months",1,"Work package stage"]
[]
["(ii)","Dealing with traffic","Months",1,"Work package stage"]
[]
[null,"Total Carried to Summary",{"$nulls":3},{"$f":"SUM(F5:F93)","v":0}]

{"sheet":"P & Gs 2","index":2,"n_rows":46,"n_cols":6,"rows_kept":46}
[{"$f":"+Notes!A2","v":"FRAMEWORK CONTRACTS FOR ELECTRICAL WORKS - BUILDINGS & EXTERNAL LIGHTING IN VARIOUS TNPA PREMISES - 3 YEARS"}]
[{"$nulls":5},"EB.PG1"]
["Item","Description","Unit","Quantity","Rate","Amount"]
[null,null,"Balance brought forward",null,null,{"$f":"+'P&Gs 1'!F94","v":0}]
["EB.PG15.02","Existing services"]
[]
["(i)","Supply or hire of specialist equipment for the detection of existing services.","Months",1,null,{"$f":"D7*E7","v":0}]
[]
["(ii)","b) The use of equipment referred to in item (i) above.","Months",1,null,0]
[]
["2)     TNPA also reserves the option to balance the rates, cost parameters and prices offered for any activity by compiling an averaged (equalized) set of common rates and prices that would apply across the board to all the Service providers for that region and Type of works or services during the execution of this framework.","DEFINED COST ITEMS"]
[]
[null,"For work executed by the Contractor (Rates to including overheads and profit):"]
[]
["EB.PG15.03(a)","People Employed by the Contractor"]
[]
["(i)","Labourer","Hour",1,null,{"$f":"D17*E17","v":0}]
[]
["(ii)","Electrician (Tradesman), construction","Hour",1,null,{"$f":"D19*E19","v":0}]
[]
["(iii)","Carpenter & Joiner (Tradesman)","Hour",1,null,{"$f":"D21*E21","v":0}]
[]
["(iii)","Semi-skilled artisan"]
[]
["(iv)","Erector, constructional steel","Hour",1,null,{"$f":"D25*E25","v":0}]
[]
["(v)","Plasterer, construction","Hour",1,null,{"$f":"D27*E27","v":0}]
[]
[]
["(vi)","Plant"]
[]
["(a)","Cherry picker","Hour",1,null,{"$f":"D32*E32","v":0}]
[]
["(b)","TLB","Hour",1,null,{"$f":"D34*E34","v":0}]
[]
["(c )","Auger trucks","Hour",1,null,{"$f":"D36*E36","v":0}]
[]
["(d )","Truck mounted auger drills","Hour",1,null,{"$f":"D38*E38","v":0}]
[]
["(e )","Skid steer auger ","Hour",1,null,{"$f":"D40*E40","v":0}]
[]
["(f )","Mobile Elevating Platform machinery (any suitable for heights up to 14m)","Hour",1,null,{"$f":"D42*E42","v":0}]
[]
["(g)","Hydraulic Aerial Lifting platform","Hour",1,null,{"$f":"D44*E44","v":0}]
[]
["EB.PG1","Total Carried to Summary",{"$nulls":3},{"$f":"SUM(F4:F45)","v":0}]

{"sheet":"Alterations","index":3,"n_rows":30,"n_cols":6,"rows_kept":30}
[{"$f":"+Notes!A2","v":"FRAMEWORK CONTRACTS FOR ELECTRICAL WORKS - BUILDINGS & EXTERNAL LIGHTING IN VARIOUS TNPA PREMISES - 3 YEARS"}]
[]
[{"$nulls":5},"EB.AL01"]
["Item","Description","Unit","Quantity","Rate","Amount"]
["EB.AL01","REMEDIAL WORKS"]
[]
["EB.AL01.1","Breaking up and removing old cables and conduits from reinforced concrete, including cutting off and removing reinforcement:"]
[]
["(a )","walls","m3",{"v":2,"d":"2.00"},null,{"$f":"E9*D9","v":0}]
[]
["2)     TNPA also reserves the option to balance the rates, cost parameters and prices offered for any activity by compiling an averaged (equalized) set of common rates and prices that would apply across the board to all the Service providers for that region and Type of works or services during the execution of this framework.","floors","m3",{"v":2,"d":"2.00"},null,{"$f":"E11*D11","v":0}]
[]
["EB.AL01.2","Taking out/off and carefully removing cables, cable trays, screws, bolts, cable ladders and all sundry in roof structures and ceilings surfaces, in heights not exceeding 3m high:"]
[]
["(a )","inside ceilings","m",45,null,{"$f":"E15*D15","v":0}]
[]
["(b )","in roof structures","m",45,null,{"$f":"E17*D17","v":0}]
[]
["(c )","high walls and beams","m",45,null,{"$f":"E19*D19","v":0}]
[]
["EB.AL01.3","Taking out/off and carefully removing cables, cable trays, screws, bolts, cable ladders and all sundry in roof structures and ceilings surfaces, in heights exceeding 3m high:"]
[]
["(a )","inside ceilings","m",45,null,{"$f":"E23*D23","v":0}]
[]
["(b )","in roof structures","m",45,null,{"$f":"E25*D25","v":0}]
[]
["(c )","high walls and beams","m",45,null,{"$f":"E27*D27","v":0}]
[]
[]
[null,"Total Carried to Summary",{"$nulls":3},{"$f":"SUM(F5:F29)","v":0}]

{"sheet":"Alterations 2","index":4,"n_rows":46,"n_cols":6,"rows_kept":46}
[{"$f":"+Notes!A2","v":"FRAMEWORK CONTRACTS FOR ELECTRICAL WORKS - BUILDINGS & EXTERNAL LIGHTING IN VARIOUS TNPA PREMISES - 3 YEARS"}]
[{"$nulls":5},"EB.AL01"]
["Item","Description","Unit","Quantity","Rate","Amount"]
[null,null,"Balance brought forward",null,null,{"$f":"+Alterations!F30","v":0}]
["EB.AL01.4","Replace old lights with new lights in various parts of the building structure (heights not exceeding 3m high):"]
[]
["(i)","Halogen lamps","No",2,null,{"$f":"E7*D7","v":0}]
[]
["(ii)","Compact fluorescent lamps","No",2,null,{"$f":"E9*D9","v":0}]
[]
["2)     TNPA also reserves the option to balance the rates, cost parameters and prices offered for any activity by compiling an averaged (equalized) set of common rates and prices that would apply across the board to all the Service providers for that region and Type of works or services during the execution of this framework.","Globe LED bulbs - globe shaped","No",2,null,{"$f":"E11*D11","v":0}]
[null,"(Standard, Bulge neck reflector, Candelabra base, globe medium, R reflector,  Parabolic Reflector, MR types, PR types, BR types, including their bases)"]
[]
["(v)","Light emitting diode (LED) tubes","No",2,null,{"$f":"E14*D14","v":0}]
[]
["(vi)","Linear flourescent","No",2,null,{"$f":"E16*D16","v":0}]
[]
["(vii)","Emergency Exit Lighting","No",2,null,{"$f":"E18*D18","v":0}]
[]
["(viii)","LED Wall packs","No",2,null,{"$f":"E20*D20","v":0}]
[null,"(various types)"]
[]
["(ix)","Light cover (various types, above lightings)","No",2,null,{"$f":"E23*D23","v":0}]
[]
["EB.AL01.5","Replace old lights with new lights in various parts of the building structure (heights exceeding 3m high):"]
[]
["(i)","Halogen lamps","No",2,null,{"$f":"E27*D27","v":0}]
[]
["(ii)","Compact fluorescent lamps","No",2,null,{"$f":"E29*D29","v":0}]
[]
["(iii)","Globe LED bulbs - globe shaped","No",2,null,{"$f":"E31*D31","v":0}]
[null,"(Standard, Bulge neck reflector, Candelabra base, globe medium, R reflector,  Parabolic Reflector, MR types, PR types, BR types, including their bases):"]
[]
["(iv)","Light emitting diode (LED) tubes","No",2,null,{"$f":"E34*D34","v":0}]
[]
["(v)","Linear flourescent","No",2,null,{"$f":"E36*D36","v":0}]
[]
["(vi)","Emergency Exit Lighting","No",2,null,{"$f":"E38*D38","v":0}]
[]
["(vii)","LED Wall packs","No",2,null,{"$f":"E40*D40","v":0}]
[null,"(various types)"]
[]
["(viii)","Light cover (various types, above lightings)","No",2,null,{"$f":"E43*D43","v":0}]
[]
[]
["EB.AL01","Total Carried to Summary",{"$nulls":3},{"$f":"SUM(F4:F45)","v":0}]

{"sheet":"BoQ Works 1","index":5,"n_rows":30,"n_cols":6,"rows_kept":30,"merged":[[1,1,1,2]]}
[{"$f":"+Notes!A2","v":"FRAMEWORK CONTRACTS FOR ELECTRICAL WORKS - BUILDINGS & EXTERNAL LIGHTING IN VARIOUS TNPA PREMISES - 3 YEARS"}]
[]
[{"$nulls":5},"EB.W01"]
["Item","Description","Unit","Quantity","Rate","Amount"]
[]
["EB.W01","PRELIMINARIES"]
[]
["EB.W01.1","GENERAL REQUIREMENTS"]
[]
["EB.W01.1(a )","Site Establishment"]
[]
["(i)","Labour rate","SUM",1,"Work package stage"]
[]
["(ii)","Material rate","SUM",1,"Work package stage"]
[]
[]
["EB.W01.1(b )","Labelling of cables, socket outlets and distribution board"]
[null,"(screwed)"]
[]
["(i)","Labour rate","SUM",1,null,{"$f":"D20*E20","v":0}]
[]
["(ii)","Material rate","SUM",1,null,{"$f":"D22*E22","v":0}]
[]
["EB.W01.1(c )","Final phase balancing on DB's"]
[]
["(i)","Labour rate","SUM",1,null,{"$f":"D26*E26","v":0}]
[]
["(ii)","Material rate","SUM",1,null,{"$f":"D28*E28","v":0}]
[]
[null,"Total Carried to Summary",{"$nulls":3},{"$f":"SUM(F5:F29)","v":0}]

{"sheet":"BoQ Works 2","index":6,"n_rows":60,"n_cols":6,"rows_kept":60}
[]
[{"$f":"+Notes!A2","v":"FRAMEWORK CONTRACTS FOR ELECTRICAL WORKS - BUILDINGS & EXTERNAL LIGHTING IN VARIOUS TNPA PREMISES - 3 YEARS"}]
[]
[{"$nulls":5},"EB.W01"]
["Item","Description","Unit","Quantity","Rate","Amount"]
[null,null,"Balance brought forward",null,null,{"$f":"+'BoQ Works 1'!F30","v":0}]
["EB.W01.1(d )","As-built drawings for new electrical installation, including generator installation"]
[]
["(i)","Labour rate","SUM",1,null,{"$f":"D9*E9","v":0}]
[]
["2)     TNPA also reserves the option to balance the rates, cost parameters and prices offered for any activity by compiling an averaged (equalized) set of common rates and prices that would apply across the board to all the Service providers for that region and Type of works or services during the execution of this framework.","Material rate","SUM",1,null,0]
[]
["EB.W01.1(e )","Certificate of compliance for the complete installation"]
[]
["(i)","Labour rate","SUM",1,null,{"$f":"D15*E15","v":0}]
[]
["(ii)","Material rate","SUM",1,null,{"$f":"D17*E17","v":0}]
[]
["EB.W01.1(f )","Operation and Maintenance manuals"]
[]
[null,"Prepare maintenance manuals, drawings and block plans and converting to electronic format on usb /memory stick"]
[]
["(i)","Labour rate","SUM",1,null,{"$f":"D23*E23","v":0}]
[]
["(ii)","Material rate","SUM",1,null,{"$f":"D25*E25","v":0}]
[]
["EB.W01.1(g )","Statutory & regulatory requirements"]
[]
["(i)","Labour rate","SUM",1,null,{"$f":"D29*E29","v":0}]
[]
["(ii)","Material rate","SUM",1,null,{"$f":"D31*E31","v":0}]
[]
["EB.W01.1(h )","Attendance of progress meetings"]
[]
["(i)","Labour rate","SUM",1,null,{"$f":"D35*E35","v":0}]
[]
["(ii)","Material rate","SUM",1,null,{"$f":"D37*E37","v":0}]
[]
["EB.W01.1(i )","Fixed Price Items"]
[]
[null,"Establishment of stores"]
[]
["(i)","Labour rate","SUM",1,null,{"$f":"D43*E43","v":0}]
[]
["(ii)","Material rate","SUM",1,null,{"$f":"D45*E45","v":0}]
[]
["EB.W01.1(j )","Establishment of communication"]
[]
["(i)","Labour rate","SUM",1,null,{"$f":"D49*E49","v":0}]
[]
["(ii)","Material rate","SUM",1,null,{"$f":"D51*E51","v":0}]
[]
["EB.W01.1(k )","Removal of site on completion"]
[]
["(i)","Labour rate","SUM",1,null,{"$f":"D55*E55","v":0}]
[]
["(ii)","Material rate","SUM",1,null,{"$f":"D57*E57","v":0}]
[]
[]
[null,"Total Carried to Summary",{"$nulls":3},{"$f":"SUM(F6:F59)","v":0}]

{"sheet":"BoQ Works 3","index":7,"n_rows":47,"n_cols":6,"rows_kept":47}
[]
[{"$f":"+Notes!A2","v":"FRAMEWORK CONTRACTS FOR ELECTRICAL WORKS - BUILDINGS & EXTERNAL LIGHTING IN VARIOUS TNPA PREMISES - 3 YEARS"}]
[{"$nulls":5},"EB.W01"]
["Item","Description","Unit","Quantity","Rate","Amount"]
[null,null,"Balance brought forward",null,null,{"$f":"+'BoQ Works 2'!F60","v":0}]
["EB.W01.1(l )","Variable Items"]
[]
["EB.W01.1(l )(a)","Variable w.r.t. Contract Value"]
[]
["(i)","Labour rate","SUM",1,"Work package stage"]
[]
["(ii)","Material rate","SUM",1,"Work package stage"]
[]
["EB.W01.1(l )(b)","Variable w.r.t. Contract Period"]
[]
["(i)","Labour rate","SUM",1,"Work package stage"]
[]
["(ii)","Material rate","SUM",1,"Work package stage"]
[]
["EB.W01.1(l )(c )","Other requirements (specify)"]
[]
["1.","Living Out Allowances"]
[]
["(i)","Labour rate","SUM",1,"Work package stage"]
[]
["(ii)","Material rate","SUM",1,"Work package stage"]
[]
["2.","Transport"]
[]
["(i)","Labour rate","SUM",1,"Work package stage"]
[]
["(ii)","Material rate","SUM",1,"Work package stage"]
[]
["EB.W01.1(l )(d )","DISTRIBUTION BOARDS"]
[]
[null,"NOTE:  All materials must be of South African manufacture. The Electrical Subcontractor must submit proof of unavailability where this requirement cannot be fulfilled.  "]
[]
[null,"Indoor distribution boards with cascaded protection as specified and shown on the drawings."]
[]
[null,"NOTE:All equipment to be SABS approved and bear the SABS performance mark"]
[]
[null,"Main DB. Including Digital Controller and Surge Arrestors."]
[]
["(i)","Labour rate","No",1,null,{"$f":"D44*E44","v":0}]
[]
["(ii)","Material rate","No",1,null,{"$f":"D46*E46","v":0}]
[null,"Total Carried to Summary",{"$nulls":3},{"$f":"SUM(F5:F46)","v":0}]

{"sheet":"BoQ Works 4","index":8,"n_rows":52,"n_cols":6,"rows_kept":52}
[{"$nulls":5},"EB.W01"]
["Item","Description","Unit","Quantity","Rate","Amount"]
[null,null,"Balance brought forward",null,null,{"$f":"+'BoQ Works 3'!F47","v":0}]
["EB.W01.1(l )(d )","Digital Controller similar in quality as Lovato DMG800 Series LCD Digital Power Meter or similar approved product.  Surge arrestors similar in quality as Denguard or similar approved."]
[]
["1.","SDB-B1"]
[]
["(i)","Labour rate","No",1,null,{"$f":"D8*E8","v":0}]
[]
["(ii)","Material rate","No",1,null,{"$f":"D10*E10","v":0}]
[]
["2.","SDB-B2"]
[]
["(i)","Labour rate","No",1,null,{"$f":"D14*E14","v":0}]
[]
["(ii)","Material rate","No",1,null,{"$f":"D16*E16","v":0}]
[]
["3. ","SDB-A"]
[]
["(i)","Labour rate","No",1,null,{"$f":"D20*E20","v":0}]
[]
["(ii)","Material rate","No",1,null,{"$f":"D22*E22","v":0}]
[]
["4.","SDB-A1"]
[]
["(i)","Labour rate","No",1,null,{"$f":"D26*E26","v":0}]
[]
["(ii)","Material rate","No",1,null,{"$f":"D28*E28","v":0}]
[]
["5.","SDB-C"]
[]
["(i)","Labour rate","No",1,null,{"$f":"D32*E32","v":0}]
[]
["(ii)","Material rate","No",1,null,{"$f":"D34*E34","v":0}]
[]
["6.","SDB-Server"]
[]
["(i)","Labour rate","No",1,null,{"$f":"D38*E38","v":0}]
[]
["(ii)","Material rate","No",1,null,{"$f":"D40*E40","v":0}]
[]
["7.","DBs for other services"]
[]
["(a )","Tele Data DB"]
[]
[null,"Flush mounted 400x400x150 DB with soft backing and lockable door"]
[]
["(i)","Labour rate","No",2,null,{"$f":"D48*E48","v":0}]
[]
["(ii)","Material rate","No",2,null,{"$f":"D50*E50","v":0}]
[]
["EB.W01","Total Carried to Summary",{"$nulls":3},{"$f":"SUM(F1:F51)","v":0}]

{"sheet":"BoQ Works 5","index":9,"n_rows":41,"n_cols":6,"rows_kept":41}
[]
[{"$f":"+Notes!A2","v":"FRAMEWORK CONTRACTS FOR ELECTRICAL WORKS - BUILDINGS & EXTERNAL LIGHTING IN VARIOUS TNPA PREMISES - 3 YEARS"}]
[{"$nulls":5},"EB.W02"]
["Item","Description","Unit","Quantity","Rate","Amount"]
[]
["EB.W02","CABLES, WIRING & ACCESSORIES"]
[]
["EB.W02.1","Allow for the following LV  (1000V) cables (incl. Install/laying and backfilling)"]
[]
["EB.W02.1(a)","All LV cables - PVC/PVC/SWA/PVC"]
[]
["1.","95mm2 x 4c with 70mm²  BCE"]
[]
["A.","Supply and install/lay"]
[]
["(i)","Labour rate","m",35,null,{"$f":"D16*E16","v":0}]
[]
["(ii)","Material rate","m",35,null,{"$f":"D18*E18","v":0}]
[]
["B.","Terminate"]
[]
["(i)","Labour rate","No",2,null,{"$f":"D22*E22","v":0}]
[]
["(ii)","Material rate","No",2,null,{"$f":"D24*E24","v":0}]
[]
["2.","25mm² x 4c with 16 mm² BCE"]
[]
["A.","Supply and install/lay"]
[]
["(i)","Labour rate","m",35,null,{"$f":"D30*E30","v":0}]
[]
["(ii)","Material rate","m",35,null,{"$f":"D32*E32","v":0}]
[]
["B.","Terminate"]
[]
["(i)","Labour rate","No",2,null,{"$f":"D36*E36","v":0}]
[]
["(ii)","Material rate","No",2,null,{"$f":"D38*E38","v":0}]
[]
[]
[null,"Total Carried to Summary",{"$nulls":3},{"$f":"SUM(F6:F40)","v":0}]

{"sheet":"BoQ Works 6","index":10,"n_rows":72,"n_cols":6,"rows_kept":72}
[]
[{"$f":"+Notes!A2","v":"FRAMEWORK CONTRACTS FOR ELECTRICAL WORKS - BUILDINGS & EXTERNAL LIGHTING IN VARIOUS TNPA PREMISES - 3 YEARS"}]
[{"$nulls":5},"EB.W02"]
["Item","Description","Unit","Quantity","Rate","Amount"]
[null,null,"Balance brought forward",null,null,{"$f":"+'BoQ Works 5'!F41","v":0}]
[4,"10mm² x 4c with 10mm² BCE"]
[]
["A.","Supply and install/lay"]
[]
["(i)","Labour rate","m",120,null,{"$f":"D10*E10","v":0}]
[]
["(ii)","Material rate","m",120,null,{"$f":"D12*E12","v":0}]
[]
["B.","Terminate"]
[]
["(i)","Labour rate","No",4,null,{"$f":"D16*E16","v":0}]
[]
["(ii)","Material rate","No",4,null,{"$f":"D18*E18","v":0}]
[]
["5.","4mm² x 4c with 4mm² BCE"]
[]
["A.","Supply and install/lay"]
[]
["(i)","Labour rate","m",30,null,{"$f":"D24*E24","v":0}]
[]
["(ii)","Material rate","m",30,null,{"$f":"D26*E26","v":0}]
[]
["B.","Terminate"]
[]
["(i)","Labour rate","No",6,null,{"$f":"D30*E30","v":0}]
[]
["(ii)","Material rate","No",6,null,{"$f":"D32*E32","v":0}]
[]
["6.","6mm² x 3 core"]
[]
["A.","Supply and install/lay"]
[]
["(i)","Labour rate","m",25,null,{"$f":"D38*E38","v":0}]
[]
["(ii)","Material rate","m",25,null,{"$f":"D40*E40","v":0}]
[]
["B.","Terminate"]
[]
["(i)","Labour rate","No",2,null,{"$f":"D44*E44","v":0}]
[]
["(ii)","Material rate","No",2,null,{"$f":"D46*E46","v":0}]
[]
["7.","Wiring - PVC insulated copper wire of the following sizes:"]
[]
["A.","2,5 mm2 supply and install and terminate"]
[]
["(i)","Labour rate","m",2200,null,{"$f":"D52*E52","v":0}]
[]
["(ii)","Material rate","m",2200,null,{"$f":"D54*E54","v":0}]
[]
["8.","BCE  - Bare Copper Earth Wire"]
[]
["A.","2,5 mm2 supply and install and terminate"]
[]
["(i)","Labour rate","m",1600,null,{"$f":"D60*E60","v":0}]
[]
["(ii)","Material rate","m",1600,null,{"$f":"D62*E62","v":0}]
[]
["9.","Draw wire"]
[]
["A.","16 swg galvanised"]
[]
["(i)","Labour rate","m",150,null,{"$f":"D68*E68","v":0}]
[]
["(ii)","Material rate","m",150,null,{"$f":"D70*E70","v":0}]
[]
["EB.W02","Total Carried to Summary",{"$nulls":3},{"$f":"SUM(F5:F71)","v":0}]

{"sheet":"BoQ Works 7","index":11,"n_rows":53,"n_cols":6,"rows_kept":53}
[{"$f":"+Notes!A2","v":"FRAMEWORK CONTRACTS FOR ELECTRICAL WORKS - BUILDINGS & EXTERNAL LIGHTING IN VARIOUS TNPA PREMISES - 3 YEARS"}]
[{"$nulls":5},"EB.W03"]
["Item","Description","Unit","Quantity","Rate","Amount"]
["EB.W03","CONDUIT, WIREWAYS & ACCESSORIES"]
[]
["EB.W03.01","SABS Approved PVC, Galvanized or Bosal conduit, complete with all couplings, saddles etc.  (On surface, chased, build- and cast-in)"]
[]
["A.","20 mm dia PVC"]
[]
["(i)","Labour rate","m",1200,null,{"$f":"D10*E10","v":0}]
[]
["(ii)","Material rate","m",1200,null,{"$f":"D12*E12","v":0}]
[]
["B.","Flexible Sprague 20mm PVC"]
[]
["(i)","Labour rate","m",150,null,{"$f":"D16*E16","v":0}]
[]
["(ii)","Material rate","m",150,null,{"$f":"D18*E18","v":0}]
[]
["C.","25 mm dia PVC"]
[]
["(i)","Labour rate","m",125,null,{"$f":"D22*E22","v":0}]
[]
["(ii)","Material rate","m",125,null,{"$f":"D24*E24","v":0}]
[]
["D.","Outlet boxes"]
[]
[null,"100 x 50 x 50 galvanised build/cast-in"]
[]
["(i)","Labour rate","No",6,null,{"$f":"D30*E30","v":0}]
[]
["(ii)","Material rate","No",6,null,{"$f":"D32*E32","v":0}]
[]
["E","100 x 100 x 50 galvanised build/cast-in"]
[]
["(i)","Labour rate","No",36,null,{"$f":"D36*E36","v":0}]
[]
["(ii)","Material rate","No",36,null,{"$f":"D38*E38","v":0}]
[]
["F.","Round PVC Box complete with cover plate"]
[]
["(i)","Labour rate","No",75,null,{"$f":"D42*E42","v":0}]
[]
["(ii)","Material rate","No",75,null,{"$f":"D44*E44","v":0}]
[]
["G.","Draw wire"]
[]
[null,"16 swg galvanised"]
[]
["(i)","Labour rate","m",155,null,{"$f":"D50*E50","v":0}]
[]
["(ii)","Material rate","m",155,null,{"$f":"D52*E52","v":0}]
[null,"Total Carried to Summary",{"$nulls":3},{"$f":"SUM(F4:F52)","v":0}]

{"sheet":"BoQ Works 8","index":12,"n_rows":38,"n_cols":6,"rows_kept":38}
[]
[{"$f":"+Notes!A2","v":"FRAMEWORK CONTRACTS FOR ELECTRICAL WORKS - BUILDINGS & EXTERNAL LIGHTING IN VARIOUS TNPA PREMISES - 3 YEARS"}]
[{"$nulls":5},"EB.W03"]
["Item","Description","Unit","Quantity","Rate","Amount"]
[null,null,"Balance brought forward",null,null,{"$f":"+'BoQ Works 7'!F53","v":0}]
[]
["EB.W03.02","Trunking"]
[]
["A.","P1000 (41mm x 41mm x 2.5) wiring duct suspended 2m from rafters complete with all installation fittings"]
[]
["2)     TNPA also reserves the option to balance the rates, cost parameters and prices offered for any activity by compiling an averaged (equalized) set of common rates and prices that would apply across the board to all the Service providers for that region and Type of works or services during the execution of this framework.","Labour rate","m",200,null,{"$f":"D11*E11","v":0}]
[]
["(ii)","Material rate","m",200,null,{"$f":"D13*E13","v":0}]
[]
["B.","2 Tier power skirting complete with covers and all accessories"]
[]
["(i)","Labour rate","m",75,null,{"$f":"D17*E17","v":0}]
[]
["(ii)","Material rate","m",75,null,{"$f":"D19*E19","v":0}]
[]
["C.","P1000 trunking complete with all accessories and installation fittings for office block"]
[]
["(i)","Labour rate","m",40,null,{"$f":"D23*E23","v":0}]
[]
["(ii)","Material rate","m",40,null,{"$f":"D25*E25","v":0}]
[]
["D.","P8000 trunking complete with all accessories and installation fittings for office block"]
[]
["(i)","Labour rate","m",40,null,{"$f":"D29*E29","v":0}]
[]
["(ii)","Material rate","m",40,null,{"$f":"D31*E31","v":0}]
[]
[]
[]
[]
[]
[]
[null,"Total Carried to Summary",{"$nulls":3},{"$f":"SUM(F5:F37)","v":0}]

{"sheet":"BoQ Works 9","index":13,"n_rows":23,"n_cols":6,"rows_kept":23}
[{"$f":"+Notes!A2","v":"FRAMEWORK CONTRACTS FOR ELECTRICAL WORKS - BUILDINGS & EXTERNAL LIGHTING IN VARIOUS TNPA PREMISES - 3 YEARS"}]
[]
[{"$nulls":5},"EB.W03"]
["Item","Description","Unit","Quantity","Rate","Amount"]
[null,null,"Balance brought forward",null,null,{"$f":"+'BoQ Works 8'!F38","v":0}]
["EB.W03.04","LIGHTING"]
[]
["(a )","Equal or similar approved BEKA Roughguard LED 55w surface mounted luminaire","No",5,null,{"$f":"D8*E8","v":0}]
[]
["(b )","Equal or similar approved to NORDLAND N50-LED 1200 64W LED Zone 2 surface mounted luminaire, including hook clamps and accessories","No",5,null,{"$f":"D10*E10","v":0}]
[]
["(i)","Labour rate","No",6,null,{"$f":"D12*E12","v":0}]
[]
["(ii)","Material rate","No",6,null,{"$f":"D14*E14","v":0}]
[]
["(c )","Equal or similar approved to BEKA Series 30, 20W LED BULKHEAD","No",5,null,{"$f":"D16*E16","v":0}]
[]
["(i)","Labour rate","No",6,null,{"$f":"D18*E18","v":0}]
[]
["(ii)","Material rate","No",6,null,{"$f":"D20*E20","v":0}]
[]
[]
[null,"Total Carried to Summary",{"$nulls":3},{"$f":"SUM(F5:F22)","v":0}]

{"sheet":"BoQ Works 10","index":14,"n_rows":37,"n_cols":6,"rows_kept":37}
[]
[{"$f":"+Notes!A2","v":"FRAMEWORK CONTRACTS FOR ELECTRICAL WORKS - BUILDINGS & EXTERNAL LIGHTING IN VARIOUS TNPA PREMISES - 3 YEARS"}]
[{"$nulls":5},"EB.W03"]
["Item","Description","Unit","Quantity","Rate","Amount"]
[null,null,"Balance brought forward",null,null,{"$f":"+'BoQ Works 9'!F23","v":0}]
[]
["EB.W03.05","SWITCHES AND SOCKET OUTLETS"]
[]
["(a )","Light switches"]
[]
["2)     TNPA also reserves the option to balance the rates, cost parameters and prices offered for any activity by compiling an averaged (equalized) set of common rates and prices that would apply across the board to all the Service providers for that region and Type of works or services during the execution of this framework.","16 A 1 Lever 1 way switch complete with cover plate Similar in quality or as approved by engineer."]
[]
["(i)","Labour rate","No",6,null,{"$f":"D13*E13","v":0}]
[]
["(ii)","Material rate","No",6,null,{"$f":"D15*E15","v":0}]
[]
["2.","16 A 1way key switch complete with cover plate Similar in quality or as approved by engineer."]
[]
["(i)","Labour rate","No",2,null,{"$f":"D19*E19","v":0}]
[]
["(ii)","Material rate","No",2,null,{"$f":"D21*E21","v":0}]
[]
["3.","Equal or similar approved to Legrand Industrial Rotary 16A single lever, one way weatherproof light switch","No",2,null,{"$f":"D23*E23","v":0}]
[]
["(i)","Labour rate","No",2,null,{"$f":"D25*E25","v":0}]
[]
["(ii)","Material rate","No",2,null,{"$f":"D27*E27","v":0}]
[]
["4.","Equal or similar approved to National Photocell, installed in a weather-proof IP65 york box with a clear window.","No",2,null,{"$f":"D29*E29","v":0}]
[]
["(i)","Labour rate","No",2,null,{"$f":"D31*E31","v":0}]
[]
["(ii)","Material rate","No",2,null,{"$f":"D33*E33","v":0}]
[]
[]
[]
[null,"Total Carried to Summary",{"$nulls":3},{"$f":"SUM(F5:F36)","v":0}]

{"sheet":"BoQ Works 11","index":15,"n_rows":66,"n_cols":6,"rows_kept":66}
[]
[{"$f":"+Notes!A2","v":"FRAMEWORK CONTRACTS FOR ELECTRICAL WORKS - BUILDINGS & EXTERNAL LIGHTING IN VARIOUS TNPA PREMISES - 3 YEARS"}]
[{"$nulls":5},"EB.W03"]
["Item","Description","Unit","Quantity","Rate","Amount"]
[null,null,"Balance brought forward"]
["EB.W03.06","Occupancy Sensors"]
[]
["(a )","Ceiling mounted passive infrared(PIR) Similar in quality as Schneider SAE-UE-MS-CU-WE or as approved by Engineer."]
[]
["(i)","Labour rate","No",20,null,{"$f":"D10*E10","v":0}]
[]
["(ii)","Material rate","No",20,null,{"$f":"D12*E12","v":0}]
[]
["(b )","Ceiling mounted ultra sonic Similar in quality as Schneider SAE-UE-MS-CSAWE or as approved by engineer."]
[]
["(i)","Labour rate","No",7,null,{"$f":"D16*E16","v":0}]
[]
["(ii)","Material rate","No",7,null,{"$f":"D18*E18","v":0}]
[]
["EB.W03.07","Socket outlets"]
[]
["(a )","Single 16A Floor Mounted Switched Socket Outlet.  Similar in quality as Schneider or as approved by engineer.",null," "]
[]
["(i)","Labour rate","No",10,null,{"$f":"D24*E24","v":0}]
[]
["(ii)","Material rate","No",10,null,{"$f":"D26*E26","v":0}]
[]
["(b )","Equal or similar approved to Legrand Arteor 16A single dedicated socket outlet (4x2) installed on power skirting","each",16,null,{"$f":"D28*E28","v":0}]
[]
["(i)","Equal or similar approved to Legrand Arteor 16A double socket outlet (4x4)","each",8,null,{"$f":"D30*E30","v":0}]
[]
["(ii)","Equal or similar approved to Legrand Arteor 16A single dedicated socket outlet (4x2) installed on power skirting","each",16,null,{"$f":"D32*E32","v":0}]
[]
["(c )","Equal or similar approved to Legrand 16A single socket outlet (4x2), installed on power skirting","each",16,null,{"$f":"D34*E34","v":0}]
[]
["(i)","Equal or similar approved to Legrand 16A single socket outlet (4x2)","each",1,null,{"$f":"D36*E36","v":0}]
[]
["(ii)","Equal or similar approved to Legrand 2-tier power skirting (70mm DATA, 70mm ELECTRICAL), including bends, covers, fixings, etc ","m",100,null,{"$f":"D38*E38","v":0}]
[]
["(d )","Equal or similar approved to Power Logic pop up plug complete with 1xLegrand 16A single socket outlet (4x2), 1xLegrand 16A single dedicated socket outlet (4x2) and 2 x RJ45 outlets","each",1,null,{"$f":"D40*E40","v":0}]
[]
["(i)","Equal or similar approved to O-Line UDS underfloor box with 16A dedicated double socket outlet and 16A non Dedicated double socket outlet","each",1,null,{"$f":"D42*E42","v":0}]
[]
["(ii)","Equal or similar approved to UMMAC 5D Blaster Range Siren 400VAC","each",1,null,{"$f":"D44*E44","v":0}]
[]
["EB.W03.08","Provision for other services"]
[]
["(a )","RJ11 Telephone Data outlet complete on power skirting"]
[]
["(i)","Labour rate","No",10,null,{"$f":"D50*E50","v":0}]
[]
["(ii)","Material rate","No",10,null,{"$f":"D52*E52","v":0}]
[]
["(b )","RJ45 Data Internet outlet complete on power skirting"]
[]
["(i)","Labour rate","No",4,null,{"$f":"D56*E56","v":0}]
[]
["(ii)","Material rate","No",4,null,{"$f":"D58*E58","v":0}]
[]
["(c )","USB outlet complete on power skirting"]
[]
["(i)","Labour rate","No",14,null,{"$f":"D62*E62","v":0}]
[]
["(ii)","Material rate","No",14,null,{"$f":"D64*E64","v":0}]
[]
[null,"Total Carried to Summary",{"$nulls":3},{"$f":"SUM(F5:F65)","v":0}]

{"sheet":"BoQ Works 12","index":16,"n_rows":33,"n_cols":6,"rows_kept":33}
[]
[{"$f":"+Notes!A2","v":"FRAMEWORK CONTRACTS FOR ELECTRICAL WORKS - BUILDINGS & EXTERNAL LIGHTING IN VARIOUS TNPA PREMISES - 3 YEARS"}]
[{"$nulls":5},"EB.W03"]
["Item","Description","Unit","Quantity","Rate","Amount"]
[null,"Balance brought forward",{"$nulls":3},{"$f":"+'BoQ Works 11'!F66","v":0}]
[]
["EB.W03.09","Isolators"]
[]
["(a )","20 A single pole Isolator switch complete in weather proof box  Similar in quality or as approved by engineer.",null," "]
[]
["2)     TNPA also reserves the option to balance the rates, cost parameters and prices offered for any activity by compiling an averaged (equalized) set of common rates and prices that would apply across the board to all the Service providers for that region and Type of works or services during the execution of this framework.","Labour rate","No",15,null,{"$f":"D11*E11","v":0}]
[]
["(ii)","Material rate","No",15,null,{"$f":"D13*E13","v":0}]
[]
["(b )","30 A single pole Isolator switch complete in weather proof box for geysers  Similar in quality or as approved by engineer.",null," "]
[]
["(i)","Labour rate","No",9,null,{"$f":"D17*E17","v":0}]
[]
["(ii)","Material rate","No",9,null,{"$f":"D19*E19","v":0}]
[]
["(c )","30 A triple pole Isolator switch complete in weather proof box for cold storage containers.  Similar in quality or as approved by engineer.",null," "]
[]
["(i)","Labour rate","No",2,null,{"$f":"D23*E23","v":0}]
[]
["(ii)","Material rate","No",2,null,{"$f":"D25*E25","v":0}]
[]
["(d )","40 A triple pole Isolator switch complete in weather proof box for geysers  Similar in quality or as approved by engineer.",null," "]
[]
["(i)","Labour rate","No",1,null,{"$f":"D29*E29","v":0}]
[]
["(ii)","Material rate","No",1,null,{"$f":"D31*E31","v":0}]
[]
[null,"Total Carried to Summary",{"$nulls":3},{"$f":"SUM(F5:F32)","v":0}]

{"sheet":"BoQ Works 13","index":17,"n_rows":19,"n_cols":6,"rows_kept":19}
[]
[{"$f":"+Notes!A2","v":"FRAMEWORK CONTRACTS FOR ELECTRICAL WORKS - BUILDINGS & EXTERNAL LIGHTING IN VARIOUS TNPA PREMISES - 3 YEARS"}]
[{"$nulls":5},"EB.W03"]
["Item","Description","Unit","Quantity","Rate","Amount"]
[null,null,"Balance brought forward",null,null,{"$f":"+'BoQ Works 12'!F33","v":0}]
["(e )","60 A triple pole solator switch complete in weather proof box for geysers  Similar in quality or as approved by engineer.",null," "]
[]
["(i)","Labour rate","No",2,null,{"$f":"D8*E8","v":0}]
[]
["(ii)","Material rate","No",2,null,{"$f":"D10*E10","v":0}]
[]
["(f )","40A, 4 Pole, 230V Contactor for warehouse lighting  Similar in quality or as approved by engineer.",null," "]
[]
["(i)","Labour rate","No",2,null,{"$f":"D14*E14","v":0}]
[]
["(ii)","Material rate","No",2,null,{"$f":"D16*E16","v":0}]
[]
[]
[null,"Total Carried to Summary",{"$nulls":3},{"$f":"SUM(F5:F18)","v":0}]

{"sheet":"BoQ Works 14","index":18,"n_rows":66,"n_cols":6,"rows_kept":66}
[]
[{"$f":"+Notes!A2","v":"FRAMEWORK CONTRACTS FOR ELECTRICAL WORKS - BUILDINGS & EXTERNAL LIGHTING IN VARIOUS TNPA PREMISES - 3 YEARS"}]
[{"$nulls":5},"EB.W03"]
["Item","Description","Unit","Quantity","Rate","Amount"]
[null,null,"Balance brought forward",null,null,{"$f":"+'BoQ Works 13'!F19","v":0}]
["EB.W03.10","LUMINAIRES"]
[]
["1.","Luminaires"]
[]
[null,"Supply and Install"]
[]
["(a )","Lascon FTL 150  Similar in quality or as approved by engineer.",null," "]
[]
["(i)","Labour rate","No",40,null,{"$f":"D14*E14","v":0}]
[]
["(ii )","Material rate ","No",40,null,{"$f":"D16*E16","v":0}]
[]
["(b )","15W LED bulkhead complete with LED lamps  Similar in quality as BEKA BULKHEAD SERIES 30 or as approved by engineer.",null," "]
[]
["(i)","Labour rate","No",19,null,{"$f":"D20*E20","v":0}]
[]
["(ii)","Material rate ","No",19,null,{"$f":"D22*E22","v":0}]
[]
["(c )","29W LED bollard luinaire, burried version, complete with LED lamps  Similar in quality or as approved by engineer.",null," "]
[]
["(i)","Labour rate","No",3,null,{"$f":"D26*E26","v":0}]
[]
["(ii)","Material rate ","No",3,null,{"$f":"D28*E28","v":0}]
[]
["(d )","LEDflood-maxi 128LED/279W OPTIC 5121. 3 @ 20 90 160 degrees"]
[]
["(i)","Labour rate","No",2,null,{"$f":"D32*E32","v":0}]
[]
["(ii)","Material rate ","No",2,null,{"$f":"D34*E34","v":0}]
[]
["(e )","8m pole with baseplate, glandplate, MCB, access door & 3 way floodlight bracket  Similar in quality or as approved by engineer.",null," "]
[]
["(i)","Labour rate","No",2,null,{"$f":"D38*E38","v":0}]
[]
["(ii)","Material rate ","No",2,null,{"$f":"D40*E40","v":0}]
[]
["(f )","LEDflood-maxi 128LED/279W OPTIC 5121  Similar in quality or as approved by engineer.",null," "]
[]
["(i)","Labour rate","No",5,null,{"$f":"D44*E44","v":0}]
[]
["(ii)","Material rate ","No",5,null,{"$f":"D46*E46","v":0}]
[]
["(g )","LEDflood-maxi 80LED/180W OPTIC 5121  Similar in quality or as approved by engineer.",null," "]
[]
["(i)","Labour rate","No",2,null,{"$f":"D50*E50","v":0}]
[]
["(ii)","Material rate ","No",2,null,{"$f":"D52*E52","v":0}]
[]
["(h )","ZELA 2282 LED 24/55w Cree XP-G2"]
[]
["(i)","Labour rate","No",6,null,{"$f":"D56*E56","v":0}]
[]
["(ii)","Material rate ","No",6,null,{"$f":"D58*E58","v":0}]
[]
["(i )","Re-aiming and addition of luminaires to existing mast light"]
[]
["(i)","Labour rate ","SUM",1,null,{"$f":"D62*E62","v":0}]
[]
["(ii)","Material rate ","SUM",1,null,{"$f":"D64*E64","v":0}]
[]
[null,"Total Carried to Summary",{"$nulls":3},{"$f":"SUM(F5:F65)","v":0}]

{"sheet":"BoQ Works 15","index":19,"n_rows":51,"n_cols":6,"rows_kept":51}
[]
[{"$f":"+Notes!A2","v":"FRAMEWORK CONTRACTS FOR ELECTRICAL WORKS - BUILDINGS & EXTERNAL LIGHTING IN VARIOUS TNPA PREMISES - 3 YEARS"}]
[{"$nulls":5},"EB.W03"]
["Item","Description","Unit","Quantity","Rate","Amount"]
[null,null,"Balance brought forward",null,null,{"$f":"+'BoQ Works 14'!F66","v":0}]
[]
["(i )","4m pole with baseplate, glandplate, MCB & access door  Similar in quality or as Future Light  or approved by engineer.",null," "]
[]
["(i)","Labour rate","No",6,null,{"$f":"D9*E9","v":0}]
[]
["2)     TNPA also reserves the option to balance the rates, cost parameters and prices offered for any activity by compiling an averaged (equalized) set of common rates and prices that would apply across the board to all the Service providers for that region and Type of works or services during the execution of this framework.","Material rate ","No",6,null,{"$f":"D11*E11","v":0}]
[]
["(j )","ZELA 6303 LED 24/55w Cree XP  Similar in quality or as BEKA or approved by engineer.",null," "]
[]
["(i)","Labour rate","No",2,null,{"$f":"D15*E15","v":0}]
[]
["(ii)","Material rate ","No",2,null,{"$f":"D17*E17","v":0}]
[]
["(k )","VLN LED 41W 700mA clear diffuser with opaque C  Similar in quality or as BEKA or approved by engineer.",null," "]
[]
["(i)","Labour rate","No",2,null,{"$f":"D21*E21","v":0}]
[]
["(ii)","Material rate ","No",2,null,{"$f":"D23*E23","v":0}]
[]
["(l )","135W LEDBay complete with LED lamps  Similar in quality or as BEKA LEDBay or similar approved",null," "]
[]
["(i)","Labour rate","No",35,null,{"$f":"D27*E27","v":0}]
[]
["(ii)","Material rate ","No",35,null,{"$f":"D29*E29","v":0}]
[]
["(m )","Same as item (l) above complete with 1 hour battery backup  Similar in quality or as BEKA LEDBay or as approved by engineer.",null," "]
[]
["(i)","Labour rate","No",16,null,{"$f":"D33*E33","v":0}]
[]
["(ii)","Material rate ","No",16,null,{"$f":"D35*E35","v":0}]
[]
["(n )","8W LED Flushmounted Downlighter  Similar in quality  or as approved by engineer.",null," "]
[]
["(i)","Labour rate","No",16,null,{"$f":"D39*E39","v":0}]
[]
["(ii)","Material rate ","No",16,null,{"$f":"D41*E41","v":0}]
[]
["EB.W03.11","Photocell"]
[]
["(a )","16A Photovoltaic (Day/Night) switch for exterior lighting",null," "]
[]
["(i)","Labour rate","No",4,null,{"$f":"D47*E47","v":0}]
[]
["(ii)","Material rate ","No",4,null,{"$f":"D49*E49","v":0}]
[]
[null,"Total Carried to Summary",{"$nulls":3},{"$f":"SUM(F5:F50)","v":0}]

{"sheet":"BoQ Works 16","index":20,"n_rows":47,"n_cols":6,"rows_kept":47}
[]
[{"$f":"+Notes!A2","v":"FRAMEWORK CONTRACTS FOR ELECTRICAL WORKS - BUILDINGS & EXTERNAL LIGHTING IN VARIOUS TNPA PREMISES - 3 YEARS"}]
[{"$nulls":5},"EB.W03"]
["Item","Description","Unit","Quantity","Rate","Amount"]
[null,null,"Balance brought forward",null,null,{"$f":"+'BoQ Works 15'!F51","v":0}]
[]
["EB.W03.12","EARTHING AND LIGHTNING PROTECTION"]
[]
["1.","Earthing"]
[]
["2)     TNPA also reserves the option to balance the rates, cost parameters and prices offered for any activity by compiling an averaged (equalized) set of common rates and prices that would apply across the board to all the Service providers for that region and Type of works or services during the execution of this framework.","Earth resistivity test to SABS Standards 10142"]
[]
["(i)","Labour","No",7,null,{"$f":"D13*E13","v":0}]
[]
["(ii)","Material","No",7,null,{"$f":"D15*E15","v":0}]
[]
["(b )","Earthing as required at each DB/Kiosk to achieve max 1 Ohm"]
[]
["(i)","Labour","No",7,null,{"$f":"D19*E19","v":0}]
[]
["(ii)","Material","No",7,null,{"$f":"D21*E21","v":0}]
[]
["(c )","Testing and commissioning of earthing installation"]
[]
["(i)","Labour","No",7,null,{"$f":"D25*E25","v":0}]
[]
["(ii)","Material","No",7,null,{"$f":"D27*E27","v":0}]
[]
["2.","Medium Voltage  cable"]
[]
["(a)","Supply, Delivery, offloading and Installation of a 300mm², 3 core, 22kV XLPE insulated, galvanised steel wire armoured and PVC sheated copper cable from the meter room to the main substation as per SANS 101980-4 ","m",450,null,{"$f":"D31*E31","v":0}]
[]
["(b)","Supply, Delivery, offloading and Installation of a 120mm², 3 core, 11kV XLPE insulated, galvanised steel wire armoured and PVC sheated copper cable from the meter room to the main substation as per SANS 101980-4","m",450,null,{"$f":"D33*E33","v":0}]
[]
["(c)","Supply, Delivery, offloading and Installation of a 50mm², 3 core, 11kV XLPE insulated, galvanised steel wire armoured and PVC sheated copper cable from the meter room to the main substation as per SANS 101980-4","m",400,null,{"$f":"D35*E35","v":0}]
[]
["3.","Medium Voltage Cable termination"]
[]
["(a)","Supply, Delivery and Installation of a temination kit for a 300mm², 3 core, 22kV XLPE insulated, galvanised steel wire armoured and PVC sheated copper cable.","ea",4,null,{"$f":"D39*E39","v":0}]
[]
["(b)","Supply, Delivery and Installation of a temination kit for a 300mm², 3 core, 11kV XLPE insulated, galvanised steel wire armoured and PVC sheated copper cable.","ea",3,null,{"$f":"D41*E41","v":0}]
[]
["(c)","Supply, Delivery and Installation of a temination kit for a 50mm², 3 core, 11kV XLPE insulated, galvanised steel wire armoured and PVC sheated copper cable.","ea",6,null,{"$f":"D43*E43","v":0}]
[]
[]
[]
[null,"Total Carried to Summary",{"$nulls":3},{"$f":"SUM(F5:F46)","v":0}]

{"sheet":"BoQ Works 17","index":21,"n_rows":38,"n_cols":6,"rows_kept":38}
[]
[{"$f":"+Notes!A2","v":"FRAMEWORK CONTRACTS FOR ELECTRICAL WORKS - BUILDINGS & EXTERNAL LIGHTING IN VARIOUS TNPA PREMISES - 3 YEARS"}]
[{"$nulls":5},"EB.W03"]
["Item","Description","Unit","Quantity","Rate","Amount"]
[{"$nulls":3},"Balance brought forward",null,{"$f":"+'BoQ Works 16'!F47","v":0}]
[]
["4.","Medium Voltage Cable Joints"]
[]
["(a )","Supply, Delivery and Installation of a cable joint kit for a 300mm², 3 core, 22kV XLPE insulated, galvanised steel wire armoured and PVC sheated copper cable.","ea",4,null,{"$f":"D9*E9","v":0}]
[]
["2)     TNPA also reserves the option to balance the rates, cost parameters and prices offered for any activity by compiling an averaged (equalized) set of common rates and prices that would apply across the board to all the Service providers for that region and Type of works or services during the execution of this framework.","Supply, Delivery and Installation of a cable joint kit for a 300mm², 3 core, 11kV XLPE insulated, galvanised steel wire armoured and PVC sheated copper cable.","ea",5,null,{"$f":"D11*E11","v":0}]
[]
["EB.W03.13","Cable Support System"]
[]
["(a)","Supply, Delivery and Installation of a similar approved or equal to Oline PS75 Powerspan heavy duty 1000mm width, straight length cable ladder. Cable ladder shall be mild steel Hot-Dip Galvanized","m",30,null,{"$f":"D15*E15","v":0}]
[]
[" (b )","Supply, Delivery and Installation of a similar approved or equal to Oline PS75 Powerspan heavy duty 500mm width, straight length cable ladder. Cable ladder shall be mild steel Hot-Dip Galvanized","m",25,null,{"$f":"D17*E17","v":0}]
[]
["(c )","Supply, Delivery and Installation of a similar approved or equal to Oline PS75 Powerspan heavy duty 1000mm 90° Horizontal bend. Cable ladder shall be mild steel Hot-Dip Galvanized","ea",12,null,{"$f":"D19*E19","v":0}]
[]
["(d )","Supply, Delivery and Installation of a similar approved or equal to Oline PS75 Powerspan heavy duty 1000mm 90° external bend. Cable ladder shall be mild steel Hot-Dip Galvanized.","ea",7,null,{"$f":"D21*E21","v":0}]
[]
["(e )","Supply, Delivery and Installation of a similar approved or equal to Oline PS75 Powerspan heavy duty 1000mm 90° internal bend. Cable ladder shall be mild steel Hot-Dip Galvanized.","ea",9,null,{"$f":"D23*E23","v":0}]
[]
["(f )","Supply, Delivery and Installation of a similar approved or equal to Oline PS75 Powerspan heavy duty 1000mm 90° Tee. Cable ladder shall be mild steel Hot-Dip Galvanized.","ea",13,null,{"$f":"D25*E25","v":0}]
[]
["(g )","Supply, Delivery and Installation of a similar approved or equal to Oline PS75 Powerspan heavy duty 500mm 90° Horizontal bend. Cable ladder shall be mild steel Hot-Dip Galvanized","ea",12,null,{"$f":"D27*E27","v":0}]
[]
["(h )","Supply, Delivery and Installation of a similar approved or equal to Oline PS75 Powerspan heavy duty 500mm 90° external bend. Cable ladder shall be mild steel Hot-Dip Galvanized.","ea",13,null,{"$f":"D29*E29","v":0}]
[]
["(i )","Supply, Delivery and Installation of a similar approved or equal to Oline PS75 Powerspan heavy duty 1000mm 90° internal bend. Cable ladder shall be mild steel Hot-Dip Galvanized.","ea",9,null,{"$f":"D31*E31","v":0}]
[]
["(j )","Allowance for supply and installation of earth bonding copper strilps of the cable ladders for every ladder joints.","sum",1,null,{"$f":"D33*E33","v":0}]
[]
["(k )","Allowance for supply and installation of cable ladder supports including but not limited to Unistruts, cantilever brackets, Fittings, Clamps and Fasteners. These items must be compatible with the associated cable ladder.","sum",1,null,{"$f":"D35*E35","v":0}]
[]
[]
[null,"Total Carried to Summary",{"$nulls":3},{"$f":"SUM(F5:F37)","v":0}]

{"sheet":"BoQ Works 18","index":22,"n_rows":43,"n_cols":6,"rows_kept":43}
[]
[{"$f":"+Notes!A2","v":"FRAMEWORK CONTRACTS FOR ELECTRICAL WORKS - BUILDINGS & EXTERNAL LIGHTING IN VARIOUS TNPA PREMISES - 3 YEARS"}]
[{"$nulls":5},"EB.W03"]
["Item","Description","Unit","Quantity","Rate","Amount"]
[null,null,"Balance brought forward",null,null,{"$f":"+'BoQ Works 17'!F38","v":0}]
[]
["EB.W03.14","Cable Trenches"]
[]
["(a )","Excavate, smoothing out of bottom of the trench, installing sand bedding, back fillig and making good. The trench details will be given during implementation (depth not exceeding 1.5m deep)","m3",15,null,{"$f":"D9*E9","v":0}]
[]
["EB.W03.14","Mini-Substations"]
["(a )","Supply Installation of a 630kVA 11000/400V low maintenance type RMU with internal arc outdoor type B Minisub, complete with switchgear","sum",3,null,{"$f":"D12*E12","v":0}]
[]
["(b )","Offloading and Installation of a 630kVA 11000/400V low maintenance type RMU with internal arc outdoor type B Minisub, complete with switchgear","sum",3,null,{"$f":"D14*E14","v":0}]
[]
["(c )","Design, Supply and Installation of Earth Mat for Proposed Mini Substation.This works shall be carried out in acorcdance with TPD-004 Earthing Spec and SANS 10313.","sum",2,null,{"$f":"D16*E16","v":0}]
[]
["EB.W03.16","EXCAVATION AND SLEEVES"]
[]
["1. ","Excavation of cable trench including backfill and compacting (see details)  (all excavations should be to a minimum depth of 600mm)",null," "]
[]
["(a )","Soft, hand pickable soil  "]
[]
[null,"Per metre:"]
[]
["(i)","Labour rate","sum",1,null,{"$f":"D26*E26","v":0}]
[]
["(ii))","Material rate","sum",1,null,{"$f":"D28*E28","v":0}]
[]
["(b )","Intermediate soil requiring the use of pneumatic tools"]
[]
["(i)","Labour rate","sum",1,null,{"$f":"D32*E32","v":0}]
[]
["(ii))","Material rate","sum",1,null,{"$f":"D34*E34","v":0}]
[]
["(c )","Hard rock requiring blasting"]
[]
["(i)","Labour rate","sum",1,null,{"$f":"D38*E38","v":0}]
[]
["(ii)","Material rate","sum",1,null,{"$f":"D40*E40","v":0}]
[]
[]
[null,"Total Carried to Summary",{"$nulls":3},{"$f":"SUM(F8:F42)","v":0}]

{"sheet":"BoQ Works 19","index":23,"n_rows":56,"n_cols":6,"rows_kept":56}
[]
[{"$f":"+Notes!A2","v":"FRAMEWORK CONTRACTS FOR ELECTRICAL WORKS - BUILDINGS & EXTERNAL LIGHTING IN VARIOUS TNPA PREMISES - 3 YEARS"}]
[{"$nulls":5},"EB.W03"]
["Item","Description","Unit","Quantity","Rate","Amount"]
[null,null,"Balance brought forward",null,null,{"$f":"+'BoQ Works 18'!F43","v":0}]
["2. ","Sleeves"]
[]
["(d )","25 mm dia PVC sleeve:"]
[]
["(i)","Labour rate","m",200,null,{"$f":"D10*E10","v":0}]
[]
["(ii)","Material rate","m",200,null,{"$f":"D12*E12","v":0}]
[]
["(e )","25 mm dia PVC slow bend:"]
[]
["(i)","Labour rate","No",24,null,{"$f":"D16*E16","v":0}]
[]
["(ii)","Material rate","No",24,null,{"$f":"D18*E18","v":0}]
[]
["(f )","32 mm dia PVC sleeve:"]
[]
["(i)","Labour rate","No",8,null,{"$f":"D22*E22","v":0}]
[]
["(ii)","Material rate","No",8,null,{"$f":"D24*E24","v":0}]
[]
["(g )","32 mm dia PVC slow bend:"]
[]
["(i)","Labour rate","No",8,null,{"$f":"D28*E28","v":0}]
[]
["(ii)","Material rate","No",8,null,{"$f":"D30*E30","v":0}]
[]
["(h )","50 mm dia PVC sleeve:"]
[]
["(i)","Labour rate","m",450,null,{"$f":"D34*E34","v":0}]
[]
["(ii)","Material rate","m",450,null,{"$f":"D36*E36","v":0}]
[]
["(i )","50 mm dia PVC slow bend:"]
[]
["(i)","Labour rate","No",4,null,{"$f":"D40*E40","v":0}]
[]
["(ii)","Material rate","No",4,null,{"$f":"D42*E42","v":0}]
[]
["(j )","110mm PVC sleeve:"]
[]
["(i)","Labour rate","m",150,null,{"$f":"D46*E46","v":0}]
[]
["(ii)","Material rate","No",150,null,{"$f":"D48*E48","v":0}]
[]
["(j )","110mm PVC slow bend:"]
[]
["(i)","Labour rate","No",10,null,{"$f":"D52*E52","v":0}]
[]
["(ii)","Material rate","No",10,null,{"$f":"D54*E54","v":0}]
[]
[null,"Total Carried to Summary",{"$nulls":3},{"$f":"SUM(F5:F55)","v":0}]

{"sheet":"BoQ Works 20","index":24,"n_rows":32,"n_cols":6,"rows_kept":32}
[]
[{"$f":"+Notes!A2","v":"FRAMEWORK CONTRACTS FOR ELECTRICAL WORKS - BUILDINGS & EXTERNAL LIGHTING IN VARIOUS TNPA PREMISES - 3 YEARS"}]
[{"$nulls":5},"EB.W03"]
["Item","Description","Unit","Quantity","Rate","Amount"]
[null,null,"Balance brought forward",null,null,{"$f":"+'BoQ Works 19'!F56","v":0}]
["EB.W03.17","LOW VOLTAGE CABLE AND TERMINATION"]
[]
["(a )","10mm² 4core PVC insulated PVC bedded SWA PVC sheathed 600/1000V ECC cable.","m",155,null,{"$f":"D8*E8","v":0}]
[]
["(b )","25mm² 4core PVC insulated PVC bedded SWA PVC sheathed 600/1000V ECC cable.","m",75,null,{"$f":"D10*E10","v":0}]
[]
["(c )","35mm² 4core PVC insulated PVC bedded SWA PVC sheathed 600/1000V ECC cable.","m",120,null,{"$f":"D12*E12","v":0}]
[]
["(d )","50mm² 4core PVC insulated PVC bedded SWA PVC sheathed 600/1000V ECC cable.","m",125,null,{"$f":"D14*E14","v":0}]
[]
["(e )","120mm² 4core PVC insulated PVC bedded SWA PVC sheathed 600/1000V ECC cable.","m",200,null,{"$f":"D16*E16","v":0}]
[]
["(f )","240mm² 3core PVC insulated PVC bedded SWA PVC sheathed 600/1000V ECC cable.","m",210,null,{"$f":"D18*E18","v":0}]
[]
["(g )","10mm² 3core PVC insulated PVC bedded SWA PVC sheathed 600/1000V ECC cable termination kit","m",5,null,{"$f":"D20*E20","v":0}]
[]
["(h )","25mm² 4core PVC insulated PVC bedded SWA PVC sheathed 600/1000V ECC cable termination kit","m",5,null,{"$f":"D22*E22","v":0}]
[]
["(i)","35mm² 4core PVC insulated PVC bedded SWA PVC sheathed 600/1000V ECC cable termination kit","m",5,null,{"$f":"D24*E24","v":0}]
[]
["(j)","50mm² 4core PVC insulated PVC bedded SWA PVC sheathed 600/1000V ECC cable termination kit","m",5,null,{"$f":"D26*E26","v":0}]
[]
["(k)","120mm² 4core PVC insulated PVC bedded SWA PVC sheathed 600/1000V ECC cable termination kit","m",5,null,{"$f":"D28*E28","v":0}]
[]
["(l)","240mm² 4core PVC insulated PVC bedded SWA PVC sheathed 600/1000V ECC cable termination kit","m",5,null,{"$f":"D30*E30","v":0}]
[]
[null,"Total Carried to Summary",{"$nulls":3},{"$f":"SUM(F5:F30)","v":0}]

{"sheet":"BoQ Works 21","index":25,"n_rows":27,"n_cols":6,"rows_kept":27}
[]
[{"$f":"+Notes!A2","v":"FRAMEWORK CONTRACTS FOR ELECTRICAL WORKS - BUILDINGS & EXTERNAL LIGHTING IN VARIOUS TNPA PREMISES - 3 YEARS"}]
[{"$nulls":5},"EB.W03"]
["Item","Description","Unit","Quantity","Rate","Amount"]
[null,null,"Balance brought forward",null,null,{"$f":"+'BoQ Works 20'!F32","v":0}]
["EB.W03.18","CABLE SLEEVE"]
[]
["(a )","160mm diameter flexible cable sleeve (underground cable installation sleeve)","m",700,null,{"$f":"D8*E8","v":0}]
[]
["(a )","110mm diameter flexible cable sleeve (underground cable installation sleeve)","m",700,null,{"$f":"D10*E10","v":0}]
[]
["EB.W03.18","MISCELLANEOUS"]
[]
["(a ","Cable marker tape 320 mm wide"]
[]
["(i)","Labour rate","m",220,null,{"$f":"D16*E16","v":0}]
[]
["(ii)","Material rate","m",220,null,{"$f":"D18*E18","v":0}]
[]
["(b)","Cordoning off trenches"]
[]
["(i)","Labour rate","m",220,null,{"$f":"D22*E22","v":0}]
[]
["(ii)","Material rate","m",220,null,{"$f":"D24*E24","v":0}]
[]
[]
["EB.W03","Total Carried to Summary",{"$nulls":3},{"$f":"SUM(F5:F26)","v":0}]

{"sheet":"External Lighting BoQ 1","index":26,"n_rows":42,"n_cols":7,"rows_kept":42}
[]
[{"$f":"+Notes!A2","v":"FRAMEWORK CONTRACTS FOR ELECTRICAL WORKS - BUILDINGS & EXTERNAL LIGHTING IN VARIOUS TNPA PREMISES - 3 YEARS"}]
[{"$nulls":5},"EB.W04","EB.W03"]
["Item","Description","Unit","Quantity","Rate","Amount"]
[]
["EB.W04"," EXTERNAL WORKS"]
[]
["EB.W04.01","ELECTRICAL - AREA LIGHTING & CCTV MAST"]
[]
["EB.W04.01(a )","AREA LIGHTING AND CCTV/PAS POLES"]
[]
["1. ","HIGH MAST LIGHTING (10m)"]
[]
["(i)","Supply, deliver equal or similar approved to 10m beka pole scissor mast (HDG).","No",2,null,{"$f":"D14*E14","v":0}]
[]
["(ii)","Erect equal or similar approved to 10m beka pole scissor mast (HDG).","No",2,null,{"$f":"D16*E16","v":0}]
[]
["(iii)","Supply, deliver 10m scissor mast foundation bases with specifications as according to pole manufacturers details","No",2,null,{"$f":"D18*E18","v":0}]
[]
["(iv)","Erect 10m scissor mast foundation bases with specifications as according to pole manufacturers details","No",2,null,{"$f":"D20*E20","v":0}]
[]
["(v)","Supply, deliver and install similar or equal approved to Nordland 120W BLD150 Zone1 classified LED fitting.","No",2,null,{"$f":"D22*E22","v":0}]
[]
["(vi)","Supply, deliver and install similar or equal approved to Beka LEDLUME MAXI 277W LED fitting.","No",2,null,{"$f":"D24*E24","v":0}]
[]
["(vii)","Design, supply, delivery and installation of a heavy duty stainless steel cable racking system mounted onto the marine structure","m",2,null,{"$f":"D26*E26","v":0}]
[]
["(viii)","Supply, delivery and install 2-core, 4mm², SWA, ECC, copper cable with PVC insulation","m",2,null,{"$f":"D28*E28","v":0}]
[]
["(ix)","Supply, delivery and install 4-core, 4mm², SWA, ECC, copper cable with PVC insulation","m",2,null,{"$f":"D30*E30","v":0}]
[]
["(x)","4mm², 2 core, PVC insulated, PVC bedded SWA PVC sheathed cable terminations inclusive of glands and shrouds","No",2,null,{"$f":"D32*E32","v":0}]
[]
["(xi)","4mm², 4 core, PVC insulated, PVC bedded SWA PVC sheathed cable terminations inclusive of glands and shrouds","No",2,null,{"$f":"D34*E34","v":0}]
[]
["(xii)","Design, supply and installation of Earthing and Lightning protection for Scissor mast to SANS 10313","No",2,null,{"$f":"D36*E36","v":0}]
[]
["EB.W04.01(b )","CCTV MAST (14.75m)"]
[]
["(i)","Design, supply, deliver 14.75m Hot Dip Galvanised CCTV mast pole, including painting to specification, electrical distribution board, etc","sum",null,null,{"$f":"D40*E40","v":0}]
[]
[null,"Section total"]

{"sheet":"External Lighting BoQ 2","index":27,"n_rows":35,"n_cols":6,"rows_kept":35}
[]
[{"$f":"+Notes!A2","v":"FRAMEWORK CONTRACTS FOR ELECTRICAL WORKS - BUILDINGS & EXTERNAL LIGHTING IN VARIOUS TNPA PREMISES - 3 YEARS"}]
[{"$nulls":5},"EB.W04"]
["Item","Description","Unit","Quantity","Rate","Amount"]
[]
[null,null,"Balance brought forward",null,null,{"$f":"+'External Lighting BoQ 1'!F42","v":0}]
["EB.W04.01(b )","MEDIUM MAST LIGHTING (10m)"]
[]
["(i)","Supply, deliver and erect equal or similar approved to 10m beka pole scissor mast (HDG).","each",3,null,{"$f":"D9*E9","v":0}]
[]
["(ii)","Supply, deliver and erect 10m scissor mast foundation bases with specifications as according to pole manufacturers details","each",3,null,{"$f":"D11*E11","v":0}]
[]
["(iii)","Supply, deliver and install similar or equal approved to Beka LED flood MAXI 279W  LED fitting.","each",10,null,{"$f":"D13*E13","v":0}]
[]
["(iv)","Design, supply and installation of Earthing and Lightning protection for Scissor mast to SANS 10313","each",3,null,{"$f":"D15*E15","v":0}]
[]
["EB.W04.01(c )","CABLES"]
[]
["(i)","Supply, delivery and install 4-core, 50mm², SWA, ECC, copper cable with PVC insulation","m",450,null,{"$f":"D19*E19","v":0}]
[]
["(ii)","Supply, delivery and install 2-core, 4mm², SWA, ECC, copper cable with PVC insulation","m",200,null,{"$f":"D21*E21","v":0}]
[]
["(iii)","Cable termination of 50mm², 4 core, ECC, Cu, PVC insulated, steel wire armoured and PVC\nsheated  cable","each",19,null,{"$f":"D23*E23","v":0}]
[]
["(iv)","Cable termination of 4mm², 2-core, ECC, Cu, PVC insulated, steel wire armoured and PVC\nsheated  cable","each",6,null,{"$f":"D25*E25","v":0}]
[]
["EB.W04.01(d )","MISCELLANEOUS ITEMS"]
[]
["(i)","Allowance for termination & junction boxes, adaptors, reducers and accessories","sum",1,null,{"$f":"D29*E29","v":0}]
[]
["EB.W04.01(d )","TESTING AND COMMISSIONING"]
[]
["(i)","Testing and commissioning of complete installation in accordance to SANS 10142-1 including the issuing of certificate of compliance","sum",1,null,{"$f":"D33*E33","v":0}]
[]
[null,"Total Carried to Summary",{"$nulls":3},{"$f":"SUM(F6:F34)","v":0}]

{"sheet":"External Lighting BoQ 3","index":28,"n_rows":26,"n_cols":6,"rows_kept":26}
[]
[{"$f":"+Notes!A2","v":"FRAMEWORK CONTRACTS FOR ELECTRICAL WORKS - BUILDINGS & EXTERNAL LIGHTING IN VARIOUS TNPA PREMISES - 3 YEARS"}]
[{"$nulls":5},"EB.W04"]
["Item","Description","Unit","Quantity","Rate","Amount"]
[null,"Total Carried to Summary",{"$nulls":3},{"$f":"+'External Lighting BoQ 2'!F35","v":0}]
["EB.W04.01(e )","Erect 14.75m Hot Dip Galvanised CCTV mast pole, including painting to specification, electrical distribution board, etc","sum",1,null,{"$f":"D6*E6","v":0}]
[]
["EB.W04.01(f )","Design, supply, deliver and erect 14.75m CCTV medium mast pole foundation base with specification","No",4,null,{"$f":"D8*E8","v":0}]
[]
["EB.W04.01(g )","Design, supply and installation of Earthing and Lightning protection for CCTV Mast to SANS 10313","No",4,null,{"$f":"D10*E10","v":0}]
[]
["EB.W04.01(e )","PA SYSTEM MAST (3m)"]
[]
["(i)","Design, supply and deliver 3m Hot Dip Galvanised PA System mast pole as shown in drawing, including painting to specification, electrical distribution board, etc","No",3,null,{"$f":"D14*E14","v":0}]
[]
["(ii)","Erect 3m Hot Dip Galvanised PA System mast pole, including painting to specification, electrical distribution board, etc","No",3,null,{"$f":"D16*E16","v":0}]
[]
["(iii)","Design, supply, deliver 3m PA System mast pole foundation base with specification according to detail","No",3,null,{"$f":"D18*E18","v":0}]
[]
["(iv)","Erect 3m PA System mast pole foundation base with specification according to detail","No",5,null,{"$f":"D20*E20","v":0}]
[]
["(v)","Design, supply and installation of Earthing and Lightning protection for PA System Mast to SANS 10313","No",3,null,{"$f":"D22*E22","v":0}]
[]
[]
[]
[null,"Total Carried to Summary",{"$nulls":3},{"$f":"SUM(F5:F25)","v":0}]

{"sheet":"External Lighting BoQ 4","index":29,"n_rows":16,"n_cols":6,"rows_kept":16}
[]
[{"$f":"+Notes!A2","v":"FRAMEWORK CONTRACTS FOR ELECTRICAL WORKS - BUILDINGS & EXTERNAL LIGHTING IN VARIOUS TNPA PREMISES - 3 YEARS"}]
[{"$nulls":5},"EB.W04"]
["Item","Description","Unit","Quantity","Rate","Amount"]
[null,"Total Carried to Summary",{"$nulls":3},{"$f":"+'External Lighting BoQ 3'!F26","v":0}]
["EB.W04.01(f )","TESTING AND COMMISSIONING"]
[]
["(i)","Testing and Commissioning of complete installation in accordance to SANS 10142-1 including the issue of COC certificates","sum",1]
[]
["(ii)","Testing and Commissioning of hazardous electrical installation and the issue of Master COC certificates","sum",1]
[]
["(iii)","Testing and issue of RMD9 certificates","sum",1]
[]
["(iv)","Exterior Lighting illuminance level test for the entire berth in the horizontal plane at a height of 1m from ground level. The test shall be conducted in the presence of the employers engineer and the test results shall be sent to the Project Manager for approval","sum",1]
[]
[null,"Total Carried to Summary",{"$nulls":3},{"$f":"SUM(F5:F15)","v":0}]

{"sheet":"External Lighting BoQ 5","index":30,"n_rows":34,"n_cols":6,"rows_kept":34}
[]
[{"$f":"+Notes!A2","v":"FRAMEWORK CONTRACTS FOR ELECTRICAL WORKS - BUILDINGS & EXTERNAL LIGHTING IN VARIOUS TNPA PREMISES - 3 YEARS"}]
[{"$nulls":5},"EB.W04"]
["Item","Description","Unit","Quantity","Rate","Amount"]
[null,null,"Total Carried to Summary",null,null,{"$f":"+'External Lighting BoQ 4'!F16","v":0}]
["EB.W04.01(g )","ELECTRICAL - GENERAL"]
[]
[null,"CCTV/PAS POWER SUPPLY"]
[]
["2)     TNPA also reserves the option to balance the rates, cost parameters and prices offered for any activity by compiling an averaged (equalized) set of common rates and prices that would apply across the board to all the Service providers for that region and Type of works or services during the execution of this framework.","Supply and Installation of kiosk (DB-G) according to drawing and specifications, including earthing of kiosk","sum",1]
[]
["(ii)","Supply and Installation of kiosk (DB-H) according to drawing and specifications, including earthing of kiosk","sum",1]
[]
["(iii)","Supply, Delivery, Offloading and Installation of 50mm², 4 core, ECC, Cu, PVC insulated, steel wire armoured and PVC sheated cable","m",10]
[]
["(iv)","Supply, Delivery, Offloading and Installation of 35mm², 4 core, ECC, Cu, PVC insulated, steel wire armoured and PVC sheated cable","m",10]
[]
["(v)","Supply, Delivery, Offloading and Installation of 25mm², 4 core, ECC, Cu, PVC insulated, steel wire armoured and PVC sheated cable","m",10]
[]
["(vi)","Supply, Delivery, Offloading and Installation of 10mm², 4 core, ECC, Cu, PVC insulated, steel wire armoured and PVC sheated cable","m",10]
[]
["(vii)","Supply, Delivery, Offloading and Installation of 6mm², 2 core, ECC, Cu, PVC insulated, steel wire armoured and PVC sheated cable","m",10]
[]
["(viii)","Termination of 50mm², 4 core, ECC, Cu, PVC insulated, steel wire armoured and PVC sheated cable","No",10]
[]
["(ix)","Termination of 35mm², 4 core, ECC, Cu, PVC insulated, steel wire armoured and PVC sheated cable","No",10]
[]
["(x)","Termination of 25mm², 4 core, ECC, Cu, PVC insulated, steel wire armoured and PVC sheated cable","No",10]
[]
["(xi)","Termination of 10mm², 4 core, ECC, Cu, PVC insulated, steel wire armoured and PVC sheated cable","No",10]
[]
["(xii)","Termination of 6mm², 2 core, ECC, Cu, PVC insulated, steel wire armoured and PVC sheated cable","No",10]
[]
[null,"Total Carried to Summary",{"$nulls":3},{"$f":"SUM(F5:F33)","v":0}]

{"sheet":"SUMMARY","index":31,"n_rows":25,"n_cols":3,"rows_kept":25,"merged":[[45,0,45,1]]}
[]
[]
["ITEM NO.","DESCRIPTION","  AMOUNT"]
[]
[null,"SUMMARY"]
[]
[null,"BUILDING"]
["'EB.PG1","PRELIMINARIES & GENERAL"]
[]
["EB.AL01","REMEDIAL WORKS"]
[]
["EB.W01","ELECTRICAL BUILDING WORKS"]
[]
["EB.W01.1","GENERAL Requirements"]
[]
["EB.W02","CABLES, WIRING & ACCESSORIES"]
[]
["EB.W03","CONDUIT, WIREWAYS & ACCESSORIES"]
[]
["EB.W04","EXTERNAL WORKS"]
[]
[null,"Sub total",{"$f":"SUM(C5:C21)","v":0}]
[null,"VAT (15%)"]
[null,"TOTAL"]
[null," (to be carried to form of offer)"]