{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["YEAR ONE","YEAR TWO","YEAR THREE","FINAL"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":14,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"YEAR ONE","index":0,"n_rows":230,"n_cols":7,"rows_kept":230,"cut":false,"hidden":false,"merged":[[101,1,102,1],[101,2,101,6],[141,2,141,6],[134,2,134,6],[135,2,135,6],[134,1,135,1],[10,1,10,6],[11,1,11,6],[47,1,48,1],[47,2,47,6],[48,2,48,6],[53,1,54,1],[53,2,53,6],[54,2,54,6],[38,2,38,6],[39,2,39,6],[44,1,45,1],[9,1,9,6],[13,3,13,5],[118,1,119,1],[118,2,118,6],[119,2,119,6],[124,1,125,1],[125,2,125,6],[124,2,124,6],[12,3,12,5],[14,3,14,6],[82,1,83,1],[106,1,107,1],[106,2,106,6],[107,2,107,6],[112,1,113,1],[112,2,112,6],[113,2,113,6],[93,1,94,1],[19,2,19,6],[38,1,39,1],[20,2,21,6],[68,1,69,1],[68,2,68,6],[69,2,69,6],[1,6,1,7],[2,2,2,6],[4,2,4,6],[6,2,6,6],[8,2,8,6],[82,2,83,6],[80,1,80,3],[59,1,60,1],[59,2,59,6],[60,2,60,6],[76,1,77,1],[76,2,76,6],[77,2,77,6],[81,1,81,6],[44,2,44,6],[45,2,45,6],[26,1,27,1],[31,1,32,1],[27,2,27,6],[26,2,26,6],[31,2,31,6],[32,2,32,6],[19,1,21,1],[17,2,17,6],[229,2,229,3],[173,1,174,1],[175,2,175,3],[175,4,175,6],[214,2,214,6],[193,1,194,1],[193,2,194,6],[176,2,176,6],[191,1,191,3],[173,2,174,6],[176,1,178,1],[177,2,178,6],[184,2,184,6],[185,2,187,6],[216,2,216,6],[196,2,196,6],[198,2,200,6],[208,2,208,3],[210,2,211,6],[184,1,187,1],[214,1,216,1],[196,1,200,1],[210,1,211,1],[228,2,228,3],[155,1,156,1],[155,2,155,6],[156,2,156,6],[171,1,171,3],[149,1,150,1],[149,2,149,6],[150,2,150,6],[85,1,86,1],[85,2,85,6],[86,2,86,6],[146,1,147,1],[146,2,146,6],[147,2,147,6],[140,1,141,1],[140,2,140,6],[164,2,164,6],[164,1,166,1],[165,2,166,6],[160,2,160,6],[161,2,162,6],[160,1,162,1],[102,2,102,6],[93,2,93,6],[94,2,94,6]]}
[]
[]
[null,null,"CLUSTER : Trading Services"]
[]
[null,null,"UNIT : Electricity"]
[]
[null,null,"DEPARTMENT: MV/LV Operations"]
[]
[null,null,"CONTRACT TITLE"]
[null,"                                House Services- Installation, erection and termination of low voltage underground"]
[null,"                                        and overhead electric cables, streetlight circuitry, customer service cable connections"]
[null,"                                          and associated equipment during a 36-month period"]
[null,null,"Contract No :","Please Select"]
[]
[null,null,"Company Name :"]
[null,"Item","Description","Unit","Price Excl.vat","Vat","Price Incl.vat"]
[]
[null,1,"Underground Mains"]
[]
[null,"1.1.0","Trenching & backfilling in normal soil conditions"]
[null,null,"Inclusive of transportation to site, physically carrying, vegetation clearance and removal thereof, excavation to specified depth, positioning, setting vertical alignment, backfilling, compaction, and all other actions required for the planting of poles, but excluding stays and Trenching in normal soil conditions, bedding, laying of marker tape, backfilling and compaction. Rates are to be given per linear metre of trench. All excess rubble to be removed and site returned to an acceptable condition. Items expressed in width x depth."]
[]
[null,"1.1.1","300 x 500 mm","m",null,0.15,{"$f":"((E23)*(1+F23))","v":0}]
[null,"1.1.2","400 x 800 mm","m",null,0.15,{"$f":"((E24)*(1+F24))","v":0}]
[null,"1.1.3","1000 x 500 mm – Proving Trench","m",null,0.15,0]
[null,"1.1.4","1000 x 800 mm – Proving Trench","m",null,0.15,0]
[null,"1.2.0","Trenching & backfilling in hard soil conditions"]
[null,null,"Trenching using jackhammer, bedding, laying of marker tape, backfilling and compaction Rates are to be given per linear metre of trench. (Trench depth 650mm or 950mm additional 150mm deep to allow for bedding soil). All excess rubble to be removed and site returned to an acceptable condition. Items expressed in width x depth"]
[null,"1.2.1","300 x 500 mm","m",null,0.15,{"$f":"((E29)*(1+F29))","v":0}]
[null,"1.2.2","400 x 800 mm","m",null,0.15,{"$f":"((E30)*(1+F30))","v":0}]
[null,"1.2.3","Supply bedding sand/m3","m3",null,0.15,{"$f":"((E31)*(1+F31))","v":0}]
[null,"1.3.0","LV cable joints"]
[null,null,"LV cable joints. Rates to be quoted are per a joint, inclusive of all phases."]
[null,"1.3.1","2.5 - 25 mm²","each",null,0.15,{"$f":"((E34)*(1+F34))","v":0}]
[null,"1.3.2","35 - 95 mm²","each",null,0.15,0]
[null,"1.3.3","150 - 240 mm²","each",null,0.15,0]
[null,"1.3.4","35 - 95 mm² Transition Joint Paper-PVC","each",null,0.15,0]
[null,"1.3.5","150 - 240 mm² Transition Joint Paper-PVC","each",null,0.15,0]
[null,"1.4.0","Installation of LV ground mounted kiosks"]
[null,null,"Install ground mount kiosks, including base/slab and housing"]
[null,"1.4.1","6 and 12 Way consumer distribution units including fuse holders installation","each",null,0.15,{"$f":"((E41)*(1+F41))","v":0}]
[null,"1.4.2","LV/Street lighting Switch Pillar","each",null,0.15,0]
[null,"1.4.3","Uprate 6 to 12 way consumer distribution unit\nincluding fuse holders installation","each",null,0.15,0]
[null,"1.4.4","Install earth spike and connect to consumer distribution unit","each",null,0.15,0]
[null,"1.5.0","Installation of cable ducts and erection of cable duct markers"]
[null,null,"Laying of cable ducts including trenching, bedding, backfilling and compaction 800mm below the road surface, per linear metre of duct laid."]
[null,"1.5.1","Laying of PVC 110mm -160mm diameter duct","m",null,0.15,{"$f":"((E47)*(1+F47))","v":0}]
[null,"1.6.0","Laying of LV cables"]
[null,null,"Laying of LV cables inclusive of cable trays. Excluding trenching, backfilling and pulling through ducts."]
[null,"1.6.1","LV cable up to 25 mm²","m",null,0.15,{"$f":"((E50)*(1+F50))","v":0}]
[null,"1.6.2","LV cable 35 - 95 mm²","m",null,0.15,0]
[null,"1.6.3","LV cable 150 - 240 mm²","m",null,0.15,0]
[null,"1.6.4","185 - 240 mm² Single core LV cable","m",null,0.15,0]
[null,"1.7.0","Pulling of cables through ducts"]
[null,null,"Pulling of cables through ducts excluding the laying of duct"]
[null,"1.7.1","LV cable up to 25 mm²","m",null,0.15,{"$f":"((E56)*(1+F56))","v":0}]
[null,"1.7.2","LV cable 35 - 95 mm²","m",null,0.15,0]
[null,"1.7.3","LV cable 150 - 240 mm²","m",null,0.15,0]
[null,"1.7.4","Single core LV cable 185 - 240 mm²","m",null,0.15,0]
[null,"1.8.0","Termination of LV cables in mini substations"]
[null,null,"LV Cable terminations in mini substations, inclusive of all phases."]
[null,"1.8.1","4 - 25 mm² Stranded / Concentric Cu PVC","each",null,0.15,{"$f":"((E62)*(1+F62))","v":0}]
[null,"1.8.2","16 - 50 mm² 4 Core PVC","each",null,0.15,0]
[null,"1.8.3","95 - 150 mm² 4 Core PVC","each",null,0.15,{"$f":"((E64)*(1+F64))","v":0}]
[null,"1.8.4","240 mm² 4 Core PVC","each",null,0.15,{"$f":"((E65)*(1+F65))","v":0}]
[null,"1.8.5","95 - 150 mm² CNE PVC","each",null,0.15,0]
[null,"1.8.6","150 - 240 mm² CNE PVC","each",null,0.15,0]
[null,"1.8.7","185 - 240 mm² Single core LV cable","each",null,0.15,0]
[null,"1.9.0","Termination of LV cables in ground mounted CDU’s/meter boxes/kioskss"]
[null,null,"Include the installation of circuit breakers or fuses, inclusive of all phases."]
[null,"1.9.1","4 - 25 mm² Stranded / Concentric Cu PVC","each",null,0.15,{"$f":"((E71)*(1+F71))","v":0}]
[null,"1.9.2","16 - 50 mm² 4 Core PVC","each",null,0.15,0]
[null,"1.9.3","95 - 150 mm² 4 Core PVC","each",null,0.15,0]
[null,"1.9.4","240 mm² 4 Core PVC","each",null,0.15,0]
[null,"1.9.5","95 - 150 mm² CNE PVC","each",null,0.15,0]
[null,"1.9.6","150 - 240 mm² CNE PVC","each",null,0.15,0]
[null,"1.10.0","LV Circuits in substations"]
[null,null,"Termination shall be priced per substation site and not per LV circuit."]
[null,"1.10.1","Install LV frame / board in substation","each",null,0.15,{"$f":"((E79)*(1+F79))","v":0}]
[null,"1.10.2","Install Stripple Board (200A - 800A)","each",null,0.15,0]
[null,"TOTAL",null,null,{"$f":"SUM(E79:E80,E71:E76,E62:E68,E56:E59,E50:E53,E47:E47,E41:E44,E34:E38,E29:E31,E23:E26)","v":0},0.15,{"$f":"((E81)*(1+F81))","v":0}]
[]
[null,2,"Overhead Mains"]
[]
[]
[null,"2.1.0","Planting of Poles (normal soil conditions)"]
[null,null,"Excavation to specified depth, physically carrying, positioning, setting vertical alignment, backfilling, compaction and all other actions required for the planting of poles, but excluding stays and dressings"]
[null,"2.1.1","Wooden/Fibre Glass /Steel 5 - 7m","each",null,0.15,{"$f":"((E88)*(1+F88))","v":0}]
[null,"2.1.2","Wooden/Fibre Glass/Steel 9m","each",null,0.15,0]
[null,"2.1.3","Wooden/Fibre Glass/Steel 10m - 13m","each",null,0.15,0]
[null,"2.1.4","Concrete 9 m circular","each",null,0.15,0]
[null,"2.1.5","Concrete prestressed 9m 4kN - 7kN","each",null,0.15,0]
[null,"2.1.6","Concrete prestressed 9m 17.5kN, 10 - 11 m 8kN","each",null,0.15,0]
[null,"2.2.0","Planting of Poles (hard ground)"]
[null,null,"Excavation using Jack Hammer. Excavation to specified depth, physically carrying, positioning, setting vertical aligning, backfilling, compaction and all other actions required for the planting of the following poles in accordance with the specification, but excluding stays and dressings."]
[null,"2.2.1","Wooden/Fibre Glass/Steel 5 - 7m","m",null,0.15,{"$f":"((E96)*(1+F96))","v":0}]
[null,"2.2.2","Wooden/Fibre Glass/Steel 9m","m",null,0.15,0]
[null,"2.2.3","Wooden & Steel 10m - 13m","m",null,0.15,0]
[null,"2.2.4","Concrete 9 m circular","m",null,0.15,0]
[null,"2.2.5","Concrete prestressed 9m 4kN - 7kN","m",null,0.15,0]
[null,"2.2.6","800 x 950 mm trench","m",null,0.15,0]
[null,"2.3.0","Splices for overhead mains"]
[null,null,"Full tension splices, jointing inclusive of all phases"]
[null,"2.3.1","Pine /Oak Al conductor (3 conductors)","set",null,0.15,{"$f":"((E104)*(1+F104))","v":0}]
[null,"2.3.2","25 mm² LV ABC (2 Cores)","set",null,0.15,0]
[null,"2.3.3","50 - 95 mm² LV ABC (4 Cores)","set",null,0.15,0]
[null,"2.4.0","Reclamation of overhead conductors"]
[null,null,"Rates must allow for the reclaiming of the associated hardware, excluding poles and stays. Prices to include transportation and be priced per kilogram. (R/kg)"]
[null,"2.4.1","Bare Copper","/kg",null,0.15,{"$f":"((E109)*(1+F109))","v":0}]
[null,"2.4.2","Bare Aluminium","/kg",null,0.15,0]
[null,"2.4.3","ABC","/kg",null,0.15,0]
[null,"2.4.4","Airdac","/kg",null,0.15,0]
[null,"2.5.0","Reclamation of poles and stays and hardware"]
[null,null,"\tReclamation & return to stores of poles and associated hardware. Prices to include transportation."]
[null,"2.5.1","Wooden Poles","each",null,0.15,{"$f":"((E115)*(1+F115))","v":0}]
[null,"2.5.2","Concrete Poles/Steel Poles","each",null,0.15,0]
[null,"2.5.3","Fibre Glass poles","each",null,0.15,0]
[null,"2.5.4","Removal of Stays","each",null,0.15,0]
[null,"2.6.0","Dressing Of Poles On 10, 16 and 25 mm² Airdac Routes"]
[null,null,"Dressing of Intermediate service poles, price per dressing. Rates must allow for affixing of pole numbers."]
[null,"2.6.1","LDW1","each",null,0.15,{"$f":"((E121)*(1+F121))","v":0}]
[null,"2.6.2","LDC1","each",null,0.15,0]
[null,"2.6.3","LDW2","each",null,0.15,0]
[null,"2.6.4","LDC2","each",null,0.15,0]
[null,"2.7.0","Dressing of poles LV ABC."]
[null,null,"Including the use of such specialized tools as may be required. Allow for affixing of pole numbers, all temporary stays that may be necessary but exclude planting of pole, price per dressing."]
[null,"2.7.1","LAX 1/25","each",null,0.15,{"$f":"((E127)*(1+F127))","v":0}]
[null,"2.7.2","LAX 2/25","each",null,0.15,0]
[null,"2.7.3","LAX 3/25","each",null,0.15,0]
[null,"2.7.4","T-Off from 25 mm² ABC LV Route","each",null,0.15,0]
[null,"2.7.5","LAX 1/50 - 1/95","each",null,0.15,0]
[null,"2.7.6","LAX 2/50 - 2/95","each",null,0.15,0]
[null,"2.7.7","LAX 3/50 - 3/95","each",null,0.15,0]
[null,"2.7.8","T-Off from 50-95 mm² ABC LV Route","each",null,0.15,0]
[null,"2.8.0","Strutting and Staying of Poles"]
[null,null,"Strutting /Staying of poles, including excavation necessary."]
[null,"2.8.1","Erection of Stays","each",null,0.15,{"$f":"((E137)*(1+F137))","v":0}]
[null,"2.8.2","Erection of Stays in hard ground ","each",null,0.15,0]
[null,"2.8.3","Erection of Struts","each",null,0.15,0]
[null,"2.8.4","Installation of anti-climbing device","/pole",null,0.15,0]
[null,"2.9.0","Stringing of ABC and Airdac"]
[null,null,"Stringing of ABC cable and Airdac on dressed poles, rates must allow for tensioning as specified. Prices per metre inclusive of all phases."]
[null,"2.9.1","Airdac 10 - 25 mm²","m",null,0.15,{"$f":"((E143)*(1+F143))","v":0}]
[null,"2.9.2","ABC LV 2 core x 25 mm²","m",null,0.15,0]
[null,"2.9.3","ABC LV 4 core x 50 mm²","m",null,0.15,0]
[null,"2.9.4","ABC LV 4 core x 95 mm²","m",null,0.15,0]
[null,"2.10.0","Earthing of LV ABC"]
[null,null,"Construction of combined neutral earth points on ABC in accordance with the Specification. Allow for power drivers and such other specialized tools as may be required."]
[null,"2.10.1","Earthing of LV ABC Circuits ","each",null,0.15,{"$f":"((E149)*(1+F149))","v":0}]
[null,"2.11.0","Aerial CDU's"]
[null,null,"Install and assembly of aerial consumer distribution units and streetlight feeds including phasing and labelling."]
[null,"2.11.1","Spit distribution box for 1 split type meter","each",null,0.15,{"$f":"((E152)*(1+F152))","v":0}]
[null,"2.11.2","Spit distribution box for 4 split type meters","each",null,0.15,0]
[null,"2.11.3","Spit distribution box for 6 split type meters","each",null,0.15,0]
[null,"2.11.4","Remove and replace of existing aerial Cdu's and split distribution box's ","each",null,0.15,0]
[null,"2.12.0","Streetlights"]
[null,null,"Affixing of streetlight on outreach to pole and terminating on fuse or in CDU. Rates must allow for streetlight assembly and fitting to coincide with pole dressing."]
[null,"2.12.1","80W HPMV/LED","each",null,0.15,{"$f":"((E158)*(1+F158))","v":0}]
[null,"2.12.2","Photocell box with internal wiring","each",null,0.15,0]
[null,"2.12.3","Install streetlight cable box","each",null,0.15,0]
[null,"2.13.0","Terminations of LV cables in aerial CDU's"]
[null,null,"Includes, raising and securing of cable up pole and the installation of circuit breakers or fuses as required. Inclusive of all phases."]
[]
[null,"2.13.1","4 - 25 mm² Concentric Cu PVC","each",null,0.15,0]
[null,"2.14.0","Termination of cables onto overhead conductors"]
[null,null,"Includes, raising and securing of cable up pole and the installation of circuit breakers or fuses as required. Inclusive of all phases"]
[]
[null,"2.14.1","4 - 25 mm² Cu Concentric / Stranded PVC","each",null,0.15,{"$f":"((E168)*(1+F168))","v":0}]
[null,"2.14.2","16 - 50 mm² 4 core PVC","each",null,0.15,0]
[null,"2.14.3","95 - 240 mm² 4 core PVC","each",null,0.15,0]
[null,"2.14.4","95 - 240 mm² CNE PVC","each",null,0.15,0]
[null,"Total",null,null,{"$f":"SUM(E158:E171,E152:E155,E149:E149,E143:E146,E137:E140,E127:E134,E121:E124,E115:E118,E109:E112,E104:E106,E96:E101,E88:E93)","v":0},0.15,0]
[]
[null,3,"Labour and Transport "]
[]
[]
[null,"3.1.0","Labour rates"]
[null,null,"Rates to apply for hourly work, authorised by the Senior Manager or his/her representative for work not specified in the document. Such claims are to be agreed upon prior to commencement of project. This is not to be used for calculation of overtime work"]
[]
[null,"3.1.1","Competent Electrician","hr",null,0.15,{"$f":"((E180)*(1+F180))","v":0}]
[null,"3.1.2","Specially Trained Person","hr",null,0.15,0]
[null,"3.1.3","Cable Layer","hr",null,0.15,0]
[null,"3.1.4","Electrician Assistant","hr",null,0.15,0]
[null,"3.1.5","Labourer","hr",null,0.15,0]
[null,"3.2.0","Transport"]
[null,null,"Rates to apply for hourly work, authorised by the Senior Manager or his/her representative for work not specified in the document. Such claims are to be agreed upon prior to commencement of project. This is not to be used for calculation of overtime work"]
[]
[]
[null,"3.2.1","Vehicle up to 1 Tonne","hr",null,0.15,0]
[null,"3.2.2","Vehicle up to 3 Tonne","hr",null,0.15,0]
[null,"3.2.3","Vehicle up to 8 Tonne with Crane","hr",null,0.15,0]
[null,"Total",null,null,{"$f":"SUM(E180:E191)","v":0},0.15,0]
[]
[null,4,"House Services"]
[]
[]
[null,"4.1.0","Labour and Transport Rates"]
[]
[null,null,"Rates to apply for hourly work, authorised by the Senior Manager or his/her representative for work not specified in the document. Such claims are to be agreed upon prior to commencement of project. This is not to be used for calculation of overtime work"]
[]
[]
[null,"4.1.1","Installation of Spilt Pre-payment Meter (Comms wire) in pre-wired formal dwelling (refer 11.4.2.1)","each",null,0.15,{"$f":"((E202)*(1+F202))","v":0}]
[null,"4.1.2","Installation of Spilt Pre-payment Meter (PLC) in pre-wired formal dwelling","each",null,0.15,{"$f":"((E203)*(1+F203))","v":0}]
[null,"4.1.3","Installation of Spilt Pre-payment Meter and SPDU in formal dwelling (refer 11.4.2.2)","each",null,0.15,0]
[null,"4.1.4","Installation of Spilt Pre-payment Meter and SPDU in informal dwelling (refer 11.4.2.3)","each",null,0.15,0]
[null,"4.1.5","Install single phase credit meter and circuit breaker","each",null,0.15,0]
[null,"4.1.6","Install 3phase credit meter and 3phase circuit breaker","each",null,0.15,0]
[null,"4.1.7","Install 3phase Pre-payment meter and 3phase circuit breaker","each",null,0.15,0]
[null,null,"Total",null,{"$f":"SUM(E202:E208)","v":0},0.15,0]
[]
[null,5,"Sundry"]
[]
[]
[]
[null,"5.1.0","Sundry Items"]
[]
[null,null,"To perform the following tasks"]
[null,"5.1.1","Locate consumer/supply GPS co-ordinate","each",null,0.15,{"$f":"((E218)*(1+F218))","v":0}]
[null,"5.1.2","Tracing of existing cables","each",null,0.15,0]
[null,"5.1.3","Install meter/split meter/PLC meter","each",null,0.15,0]
[null,"5.1.4","Remove meter/split meter/PLC meter","each",null,0.15,0]
[null,"5.1.5","Testing of an existing installation","each",null,0.15,0]
[null,"5.1.6","Perform an earth loop impedance test on an existing connection","each",null,0.15,0]
[null,"5.1.7","Install new Customer Interface Unit suitable for split meter","each",null,0.15,0]
[null,"5.1.8","Warning of LV circuits of a transformer","/circuit",null,0.15,0]
[null,"5.1.9","Saw Cutting per meter *","m",null,0.15,0]
[null,"5.1.10","Directional drilling per meter – 110mm - 160mm pipe *","m",null,0.15,0]
[null,"5.1.11","Re-instatement of paving/tiles/bricks per m2","m2",null,0.15,0]
[null,null,"Total",null,{"$f":"SUM(E218:E228)","v":0},0.15,0]
[null,null,"Grand Total Year One",null,{"$f":"SUM(E81,E172,E192,E209,E229)","v":0},0.15,{"$f":"((E230)*(1+F230))","v":0}]

{"sheet":"YEAR TWO","index":1,"n_rows":230,"n_cols":7,"rows_kept":230,"cut":false,"hidden":false,"merged":[[8,2,8,6],[13,3,13,5],[2,2,2,6],[4,2,4,6],[6,2,6,6],[31,1,32,1],[31,2,31,6],[32,2,32,6],[1,6,1,7],[27,2,27,6],[9,1,9,6],[10,1,10,6],[11,1,11,6],[12,3,12,5],[14,3,14,6],[17,2,17,6],[19,2,19,6],[19,1,21,1],[20,2,21,6],[26,1,27,1],[26,2,26,6],[106,1,107,1],[106,2,106,6],[107,2,107,6],[102,2,102,6],[101,1,102,1],[101,2,101,6],[86,2,86,6],[93,2,93,6],[76,2,76,6],[82,1,83,1],[76,1,77,1],[77,2,77,6],[80,1,80,3],[81,1,81,6],[82,2,83,6],[85,1,86,1],[85,2,85,6],[93,1,94,1],[94,2,94,6],[147,2,147,6],[118,1,119,1],[118,2,118,6],[119,2,119,6],[140,1,141,1],[140,2,140,6],[141,2,141,6],[146,1,147,1],[146,2,146,6],[208,2,208,3],[210,1,211,1],[210,2,211,6],[214,1,216,1],[214,2,214,6],[216,2,216,6],[228,2,228,3],[229,2,229,3],[164,1,166,1],[164,2,164,6],[165,2,166,6],[171,1,171,3],[173,1,174,1],[173,2,174,6],[175,2,175,3],[175,4,175,6],[176,1,178,1],[176,2,176,6],[177,2,178,6],[184,1,187,1],[184,2,184,6],[185,2,187,6],[191,1,191,3],[193,1,194,1],[38,1,39,1],[38,2,38,6],[39,2,39,6],[44,1,45,1],[44,2,44,6],[45,2,45,6],[47,1,48,1],[48,2,48,6],[68,1,69,1],[68,2,68,6],[59,1,60,1],[59,2,59,6],[60,2,60,6],[69,2,69,6],[47,2,47,6],[53,1,54,1],[53,2,53,6],[54,2,54,6],[112,1,113,1],[112,2,112,6],[113,2,113,6],[124,1,125,1],[124,2,124,6],[125,2,125,6],[134,1,135,1],[134,2,134,6],[135,2,135,6],[193,2,194,6],[196,1,200,1],[196,2,196,6],[198,2,200,6],[149,1,150,1],[149,2,149,6],[150,2,150,6],[155,1,156,1],[155,2,155,6],[156,2,156,6],[160,1,162,1],[160,2,160,6],[161,2,162,6]]}
[]
[]
[null,null,"CLUSTER : Trading Services"]
[]
[null,null,"UNIT : Electricity"]
[]
[null,null,"DEPARTMENT: MV/LV Operations"]
[]
[null,null,"CONTRACT TITLE"]
[null,"                                House Services- Installation, erection and termination of low voltage underground"]
[null,"                                        and overhead electric cables, streetlight circuitry, customer service cable connections"]
[null,"                                          and associated equipment during a 36-month period"]
[null,null,"Contract No :","Please Select"]
[]
[null,null,"Company Name :"]
[null,"Item","Description","Unit","Price Excl.vat","Vat","Price Incl.vat"]
[]
[null,1,"Underground Mains"]
[]
[null,"1.1.0","Trenching & backfilling in normal soil conditions"]
[null,null,"Inclusive of transportation to site, physically carrying, vegetation clearance and removal thereof, excavation to specified depth, positioning, setting vertical alignment, backfilling, compaction, and all other actions required for the planting of poles, but excluding stays and Trenching in normal soil conditions, bedding, laying of marker tape, backfilling and compaction. Rates are to be given per linear metre of trench. All excess rubble to be removed and site returned to an acceptable condition. Items expressed in width x depth."]
[]
[null,"1.1.1","300 x 500 mm","m",null,0.15,{"$f":"((E23)*(1+F23))","v":0}]
[null,"1.1.2","400 x 800 mm","m",null,0.15,{"$f":"((E24)*(1+F24))","v":0}]
[null,"1.1.3","1000 x 500 mm – Proving Trench","m",null,0.15,0]
[null,"1.1.4","1000 x 800 mm – Proving Trench","m",null,0.15,0]
[null,"1.2.0","Trenching & backfilling in hard soil conditions"]
[null,null,"Trenching using jackhammer, bedding, laying of marker tape, backfilling and compaction Rates are to be given per linear metre of trench. (Trench depth 650mm or 950mm additional 150mm deep to allow for bedding soil). All excess rubble to be removed and site returned to an acceptable condition. Items expressed in width x depth"]
[null,"1.2.1","300 x 500 mm","m",null,0.15,{"$f":"((E29)*(1+F29))","v":0}]
[null,"1.2.2","400 x 800 mm","m",null,0.15,{"$f":"((E31)*(1+F30))","v":0}]
[null,"1.2.3","Supply bedding sand/m3","m3",null,0.15,{"$f":"((#REF!)*(1+F31))","v":{"$error":"#REF!"}}]
[null,"1.3.0","LV cable joints"]
[null,null,"LV cable joints. Rates to be quoted are per a joint, inclusive of all phases."]
[null,"1.3.1","2.5 - 25 mm²","each",null,0.15,{"$f":"((E34)*(1+F34))","v":0}]
[null,"1.3.2","35 - 95 mm²","each",null,0.15,0]
[null,"1.3.3","150 - 240 mm²","each",null,0.15,0]
[null,"1.3.4","35 - 95 mm² Transition Joint Paper-PVC","each",null,0.15,0]
[null,"1.3.5","150 - 240 mm² Transition Joint Paper-PVC","each",null,0.15,0]
[null,"1.4.0","Installation of LV ground mounted kiosks"]
[null,null,"Install ground mount kiosks, including base/slab and housing"]
[null,"1.4.1","6 and 12 Way consumer distribution units including fuse holders installation","each",null,0.15,{"$f":"((E41)*(1+F41))","v":0}]
[null,"1.4.2","LV/Street lighting Switch Pillar","each",null,0.15,0]
[null,"1.4.3","Uprate 6 to 12 way consumer distribution unit\nincluding fuse holders installation","each",null,0.15,0]
[null,"1.4.4","Install earth spike and connect to consumer distribution unit","each",null,0.15,0]
[null,"1.5.0","Installation of cable ducts and erection of cable duct markers"]
[null,null,"Laying of cable ducts including trenching, bedding, backfilling and compaction 800mm below the road surface, per linear metre of duct laid."]
[null,"1.5.1","Laying of PVC 110mm -160mm diameter duct","m",null,0.15,{"$f":"((E47)*(1+F47))","v":0}]
[null,"1.6.0","Laying of LV cables"]
[null,null,"Laying of LV cables inclusive of cable trays. Excluding trenching, backfilling and pulling through ducts."]
[null,"1.6.1","LV cable up to 25 mm²","m",null,0.15,{"$f":"((E50)*(1+F50))","v":0}]
[null,"1.6.2","LV cable 35 - 95 mm²","m",null,0.15,0]
[null,"1.6.3","LV cable 150 - 240 mm²","m",null,0.15,0]
[null,"1.6.4","185 - 240 mm² Single core LV cable","m",null,0.15,0]
[null,"1.7.0","Pulling of cables through ducts"]
[null,null,"Pulling of cables through ducts excluding the laying of duct"]
[null,"1.7.1","LV cable up to 25 mm²","m",null,0.15,{"$f":"((E56)*(1+F56))","v":0}]
[null,"1.7.2","LV cable 35 - 95 mm²","m",null,0.15,0]
[null,"1.7.3","LV cable 150 - 240 mm²","m",null,0.15,0]
[null,"1.7.4","Single core LV cable 185 - 240 mm²","m",null,0.15,0]
[null,"1.8.0","Termination of LV cables in mini substations"]
[null,null,"LV Cable terminations in mini substations, inclusive of all phases."]
[null,"1.8.1","4 - 25 mm² Stranded / Concentric Cu PVC","each",null,0.15,{"$f":"((E62)*(1+F62))","v":0}]
[null,"1.8.2","16 - 50 mm² 4 Core PVC","each",null,0.15,0]
[null,"1.8.3","95 - 150 mm² 4 Core PVC","each",null,0.15,{"$f":"((E64)*(1+F64))","v":0}]
[null,"1.8.4","240 mm² 4 Core PVC","each",null,0.15,{"$f":"((E65)*(1+F65))","v":0}]
[null,"1.8.5","95 - 150 mm² CNE PVC","each",null,0.15,0]
[null,"1.8.6","150 - 240 mm² CNE PVC","each",null,0.15,0]
[null,"1.8.7","185 - 240 mm² Single core LV cable","each",null,0.15,0]
[null,"1.9.0","Termination of LV cables in ground mounted CDU’s/meter boxes/kioskss"]
[null,null,"Include the installation of circuit breakers or fuses, inclusive of all phases."]
[null,"1.9.1","4 - 25 mm² Stranded / Concentric Cu PVC","each",null,0.15,{"$f":"((E71)*(1+F71))","v":0}]
[null,"1.9.2","16 - 50 mm² 4 Core PVC","each",null,0.15,0]
[null,"1.9.3","95 - 150 mm² 4 Core PVC","each",null,0.15,0]
[null,"1.9.4","240 mm² 4 Core PVC","each",null,0.15,0]
[null,"1.9.5","95 - 150 mm² CNE PVC","each",null,0.15,0]
[null,"1.9.6","150 - 240 mm² CNE PVC","each",null,0.15,0]
[null,"1.10.0","LV Circuits in substations"]
[null,null,"Termination shall be priced per substation site and not per LV circuit."]
[null,"1.10.1","Install LV frame / board in substation","each",null,0.15,{"$f":"((E79)*(1+F79))","v":0}]
[null,"1.10.2","Install Stripple Board (200A - 800A)","each",null,0.15,0]
[null,"TOTAL",null,null,{"$f":"SUM(E79:E80,E71:E76,E62:E68,E56:E59,E50:E53,E47:E47,E41:E44,E34:E38,E29:E31,E23:E26)","v":0},0.15,0]
[]
[null,2,"Overhead Mains"]
[]
[]
[null,"2.1.0","Planting of Poles (normal soil conditions)"]
[null,null,"Excavation to specified depth, physically carrying, positioning, setting vertical alignment, backfilling, compaction and all other actions required for the planting of poles, but excluding stays and dressings"]
[null,"2.1.1","Wooden/Fibre Glass /Steel 5 - 7m","each",null,0.15,{"$f":"((E88)*(1+F88))","v":0}]
[null,"2.1.2","Wooden/Fibre Glass/Steel 9m","each",null,0.15,0]
[null,"2.1.3","Wooden/Fibre Glass/Steel 10m - 13m","each",null,0.15,0]
[null,"2.1.4","Concrete 9 m circular","each",null,0.15,0]
[null,"2.1.5","Concrete prestressed 9m 4kN - 7kN","each",null,0.15,0]
[null,"2.1.6","Concrete prestressed 9m 17.5kN, 10 - 11 m 8kN","each",null,0.15,0]
[null,"2.2.0","Planting of Poles (hard ground)"]
[null,null,"Excavation using Jack Hammer. Excavation to specified depth, physically carrying, positioning, setting vertical aligning, backfilling, compaction and all other actions required for the planting of the following poles in accordance with the specification, but excluding stays and dressings."]
[null,"2.2.1","Wooden/Fibre Glass/Steel 5 - 7m","m",null,0.15,{"$f":"((E96)*(1+F96))","v":0}]
[null,"2.2.2","Wooden/Fibre Glass/Steel 9m","m",null,0.15,0]
[null,"2.2.3","Wooden & Steel 10m - 13m","m",null,0.15,0]
[null,"2.2.4","Concrete 9 m circular","m",null,0.15,0]
[null,"2.2.5","Concrete prestressed 9m 4kN - 7kN","m",null,0.15,0]
[null,"2.2.6","800 x 950 mm trench","m",null,0.15,0]
[null,"2.3.0","Splices for overhead mains"]
[null,null,"Full tension splices, jointing inclusive of all phases"]
[null,"2.3.1","Pine /Oak Al conductor (3 conductors)","set",null,0.15,{"$f":"((E104)*(1+F104))","v":0}]
[null,"2.3.2","25 mm² LV ABC (2 Cores)","set",null,0.15,0]
[null,"2.3.3","50 - 95 mm² LV ABC (4 Cores)","set",null,0.15,0]
[null,"2.4.0","Reclamation of overhead conductors"]
[null,null,"Rates must allow for the reclaiming of the associated hardware, excluding poles and stays. Prices to include transportation and be priced per kilogram. (R/kg)"]
[null,"2.4.1","Bare Copper","/kg",null,0.15,{"$f":"((E109)*(1+F109))","v":0}]
[null,"2.4.2","Bare Aluminium","/kg",null,0.15,0]
[null,"2.4.3","ABC","/kg",null,0.15,0]
[null,"2.4.4","Airdac","/kg",null,0.15,0]
[null,"2.5.0","Reclamation of poles and stays and hardware"]
[null,null,"\tReclamation & return to stores of poles and associated hardware. Prices to include transportation."]
[null,"2.5.1","Wooden Poles","each",null,0.15,{"$f":"((E115)*(1+F115))","v":0}]
[null,"2.5.2","Concrete Poles/Steel Poles","each",null,0.15,0]
[null,"2.5.3","Fibre Glass poles","each",null,0.15,0]
[null,"2.5.4","Removal of Stays","each",null,0.15,0]
[null,"2.6.0","Dressing Of Poles On 10, 16 and 25 mm² Airdac Routes"]
[null,null,"Dressing of Intermediate service poles, price per dressing. Rates must allow for affixing of pole numbers."]
[null,"2.6.1","LDW1","each",null,0.15,{"$f":"((E121)*(1+F121))","v":0}]
[null,"2.6.2","LDC1","each",null,0.15,0]
[null,"2.6.3","LDW2","each",null,0.15,0]
[null,"2.6.4","LDC2","each",null,0.15,0]
[null,"2.7.0","Dressing of poles LV ABC."]
[null,null,"Including the use of such specialized tools as may be required. Allow for affixing of pole numbers, all temporary stays that may be necessary but exclude planting of pole, price per dressing."]
[null,"2.7.1","LAX 1/25","each",null,0.15,{"$f":"((E127)*(1+F127))","v":0}]
[null,"2.7.2","LAX 2/25","each",null,0.15,0]
[null,"2.7.3","LAX 3/25","each",null,0.15,0]
[null,"2.7.4","T-Off from 25 mm² ABC LV Route","each",null,0.15,0]
[null,"2.7.5","LAX 1/50 - 1/95","each",null,0.15,0]
[null,"2.7.6","LAX 2/50 - 2/95","each",null,0.15,0]
[null,"2.7.7","LAX 3/50 - 3/95","each",null,0.15,0]
[null,"2.7.8","T-Off from 50-95 mm² ABC LV Route","each",null,0.15,0]
[null,"2.8.0","Strutting and Staying of Poles"]
[null,null,"Strutting /Staying of poles, including excavation necessary."]
[null,"2.8.1","Erection of Stays","each",null,0.15,{"$f":"((E137)*(1+F137))","v":0}]
[null,"2.8.2","Erection of Stays in hard ground ","each",null,0.15,0]
[null,"2.8.3","Erection of Struts","each",null,0.15,0]
[null,"2.8.4","Installation of anti-climbing device","/pole",null,0.15,0]
[null,"2.9.0","Stringing of ABC and Airdac"]
[null,null,"Stringing of ABC cable and Airdac on dressed poles, rates must allow for tensioning as specified. Prices per metre inclusive of all phases."]
[null,"2.9.1","Airdac 10 - 25 mm²","m",null,0.15,{"$f":"((E143)*(1+F143))","v":0}]
[null,"2.9.2","ABC LV 2 core x 25 mm²","m",null,0.15,0]
[null,"2.9.3","ABC LV 4 core x 50 mm²","m",null,0.15,0]
[null,"2.9.4","ABC LV 4 core x 95 mm²","m",null,0.15,0]
[null,"2.10.0","Earthing of LV ABC"]
[null,null,"Construction of combined neutral earth points on ABC in accordance with the Specification. Allow for power drivers and such other specialized tools as may be required."]
[null,"2.10.1","Earthing of LV ABC Circuits ","each",null,0.15,{"$f":"((E149)*(1+F149))","v":0}]
[null,"2.11.0","Aerial CDU's"]
[null,null,"Install and assembly of aerial consumer distribution units and streetlight feeds including phasing and labelling."]
[null,"2.11.1","Spit distribution box for 1 split type meter","each",null,0.15,{"$f":"((E152)*(1+F152))","v":0}]
[null,"2.11.2","Spit distribution box for 4 split type meters","each",null,0.15,0]
[null,"2.11.3","Spit distribution box for 6 split type meters","each",null,0.15,0]
[null,"2.11.4","Remove and replace of existing aerial Cdu's and split distribution box's ","each",null,0.15,0]
[null,"2.12.0","Streetlights"]
[null,null,"Affixing of streetlight on outreach to pole and terminating on fuse or in CDU. Rates must allow for streetlight assembly and fitting to coincide with pole dressing."]
[null,"2.12.1","80W HPMV/LED","each",null,0.15,{"$f":"((E158)*(1+F158))","v":0}]
[null,"2.12.2","Photocell box with internal wiring","each",null,0.15,0]
[null,"2.12.3","Install streetlight cable box","each",null,0.15,0]
[null,"2.13.0","Terminations of LV cables in aerial CDU's"]
[null,null,"Includes, raising and securing of cable up pole and the installation of circuit breakers or fuses as required. Inclusive of all phases."]
[]
[null,"2.13.1","4 - 25 mm² Concentric Cu PVC","each",null,0.15,0]
[null,"2.14.0","Termination of cables onto overhead conductors"]
[null,null,"Includes, raising and securing of cable up pole and the installation of circuit breakers or fuses as required. Inclusive of all phases"]
[]
[null,"2.14.1","4 - 25 mm² Cu Concentric / Stranded PVC","each",null,0.15,{"$f":"((E168)*(1+F168))","v":0}]
[null,"2.14.2","16 - 50 mm² 4 core PVC","each",null,0.15,0]
[null,"2.14.3","95 - 240 mm² 4 core PVC","each",null,0.15,0]
[null,"2.14.4","95 - 240 mm² CNE PVC","each",null,0.15,0]
[null,"Total",null,null,{"$f":"SUM(E158:E171,E152:E155,E149:E149,E143:E146,E137:E140,E127:E134,E121:E124,E115:E118,E109:E112,E104:E106,E96:E101,E88:E93)","v":0},0.15,0]
[]
[null,3,"Labour and Transport "]
[]
[]
[null,"3.1.0","Labour rates"]
[null,null,"Rates to apply for hourly work, authorised by the Senior Manager or his/her representative for work not specified in the document. Such claims are to be agreed upon prior to commencement of project. This is not to be used for calculation of overtime work"]
[]
[null,"3.1.1","Competent Electrician","hr",null,0.15,{"$f":"((E180)*(1+F180))","v":0}]
[null,"3.1.2","Specially Trained Person","hr",null,0.15,0]
[null,"3.1.3","Cable Layer","hr",null,0.15,0]
[null,"3.1.4","Electrician Assistant","hr",null,0.15,0]
[null,"3.1.5","Labourer","hr",null,0.15,0]
[null,"3.2.0","Transport"]
[null,null,"Rates to apply for hourly work, authorised by the Senior Manager or his/her representative for work not specified in the document. Such claims are to be agreed upon prior to commencement of project. This is not to be used for calculation of overtime work"]
[]
[]
[null,"3.2.1","Vehicle up to 1 Tonne","hr",null,0.15,0]
[null,"3.2.2","Vehicle up to 3 Tonne","hr",null,0.15,0]
[null,"3.2.3","Vehicle up to 8 Tonne with Crane","hr",null,0.15,0]
[null,"Total",null,null,{"$f":"SUM(E180:E191)","v":0},0.15,0]
[]
[null,4,"House Services"]
[]
[]
[null,"4.1.0","Labour and Transport Rates"]
[]
[null,null,"Rates to apply for hourly work, authorised by the Senior Manager or his/her representative for work not specified in the document. Such claims are to be agreed upon prior to commencement of project. This is not to be used for calculation of overtime work"]
[]
[]
[null,"4.1.1","Installation of Spilt Pre-payment Meter (Comms wire) in pre-wired formal dwelling (refer 11.4.2.1)","each",null,0.15,{"$f":"((E202)*(1+F202))","v":0}]
[null,"4.1.2","Installation of Spilt Pre-payment Meter (PLC) in pre-wired formal dwelling","each",null,0.15,{"$f":"((E203)*(1+F203))","v":0}]
[null,"4.1.3","Installation of Spilt Pre-payment Meter and SPDU in formal dwelling (refer 11.4.2.2)","each",null,0.15,0]
[null,"4.1.4","Installation of Spilt Pre-payment Meter and SPDU in informal dwelling (refer 11.4.2.3)","each",null,0.15,0]
[null,"4.1.5","Install single phase credit meter and circuit breaker","each",null,0.15,0]
[null,"4.1.6","Install 3phase credit meter and 3phase circuit breaker","each",null,0.15,0]
[null,"4.1.7","Install 3phase Pre-payment meter and 3phase circuit breaker","each",null,0.15,0]
[null,null,"Total",null,{"$f":"SUM(E202:E208)","v":0},0.15,0]
[]
[null,5,"Sundry"]
[]
[]
[]
[null,"5.1.0","Sundry Items"]
[]
[null,null,"To perform the following tasks"]
[null,"5.1.1","Locate consumer/supply GPS co-ordinate","each",null,0.15,{"$f":"((E218)*(1+F218))","v":0}]
[null,"5.1.2","Tracing of existing cables","each",null,0.15,0]
[null,"5.1.3","Install meter/split meter/PLC meter","each",null,0.15,0]
[null,"5.1.4","Remove meter/split meter/PLC meter","each",null,0.15,0]
[null,"5.1.5","Testing of an existing installation","each",null,0.15,0]
[null,"5.1.6","Perform an earth loop impedance test on an existing connection","each",null,0.15,0]
[null,"5.1.7","Install new Customer Interface Unit suitable for split meter","each",null,0.15,0]
[null,"5.1.8","Warning of LV circuits of a transformer","/circuit",null,0.15,0]
[null,"5.1.9","Saw Cutting per meter *","m",null,0.15,0]
[null,"5.1.10","Directional drilling per meter – 110mm - 160mm pipe *","m",null,0.15,0]
[null,"5.1.11","Re-instatement of paving/tiles/bricks per m2","m2",null,0.15,0]
[null,null,"Total",null,{"$f":"SUM(E218:E228)","v":0},0.15,0]
[null,null,"Grand Total Year One",null,{"$f":"SUM(E81,E172,E192,E209,E229)","v":0},0.15,{"$f":"((E230)*(1+F230))","v":0}]

{"sheet":"YEAR THREE","index":2,"n_rows":230,"n_cols":7,"rows_kept":230,"cut":false,"hidden":false,"merged":[[31,1,32,1],[31,2,31,6],[32,2,32,6],[1,6,1,7],[27,2,27,6],[17,2,17,6],[19,2,19,6],[19,1,21,1],[20,2,21,6],[26,1,27,1],[26,2,26,6],[2,2,2,6],[4,2,4,6],[6,2,6,6],[8,2,8,6],[10,1,10,6],[11,1,11,6],[9,1,9,6],[12,3,12,5],[14,3,14,6],[13,3,13,5],[106,1,107,1],[106,2,106,6],[107,2,107,6],[102,2,102,6],[101,1,102,1],[101,2,101,6],[86,2,86,6],[93,2,93,6],[76,2,76,6],[82,1,83,1],[76,1,77,1],[77,2,77,6],[80,1,80,3],[81,1,81,6],[82,2,83,6],[85,1,86,1],[85,2,85,6],[93,1,94,1],[94,2,94,6],[147,2,147,6],[118,1,119,1],[118,2,118,6],[119,2,119,6],[140,1,141,1],[140,2,140,6],[141,2,141,6],[146,1,147,1],[146,2,146,6],[208,2,208,3],[210,1,211,1],[210,2,211,6],[214,1,216,1],[214,2,214,6],[216,2,216,6],[228,2,228,3],[229,2,229,3],[164,1,166,1],[164,2,164,6],[165,2,166,6],[171,1,171,3],[173,1,174,1],[173,2,174,6],[175,2,175,3],[175,4,175,6],[176,1,178,1],[176,2,176,6],[177,2,178,6],[184,1,187,1],[184,2,184,6],[185,2,187,6],[191,1,191,3],[193,1,194,1],[38,1,39,1],[38,2,38,6],[39,2,39,6],[44,1,45,1],[44,2,44,6],[45,2,45,6],[47,1,48,1],[48,2,48,6],[68,1,69,1],[68,2,68,6],[59,1,60,1],[59,2,59,6],[60,2,60,6],[69,2,69,6],[47,2,47,6],[53,1,54,1],[53,2,53,6],[54,2,54,6],[112,1,113,1],[112,2,112,6],[113,2,113,6],[124,1,125,1],[124,2,124,6],[125,2,125,6],[134,1,135,1],[134,2,134,6],[135,2,135,6],[193,2,194,6],[196,1,200,1],[196,2,196,6],[198,2,200,6],[149,1,150,1],[149,2,149,6],[150,2,150,6],[155,1,156,1],[155,2,155,6],[156,2,156,6],[160,1,162,1],[160,2,160,6],[161,2,162,6]]}
[]
[]
[null,null,"CLUSTER : Trading Services"]
[]
[null,null,"UNIT : Electricity"]
[]
[null,null,"DEPARTMENT: MV/LV Operations"]
[]
[null,null,"CONTRACT TITLE"]
[null,"                                House Services- Installation, erection and termination of low voltage underground"]
[null,"                                        and overhead electric cables, streetlight circuitry, customer service cable connections"]
[null,"                                          and associated equipment during a 36-month period"]
[null,null,"Contract No :","Please Select"]
[]
[null,null,"Company Name :"]
[null,"Item","Description","Unit","Price Excl.vat","Vat","Price Incl.vat"]
[]
[null,1,"Underground Mains"]
[]
[null,"1.1.0","Trenching & backfilling in normal soil conditions"]
[null,null,"Inclusive of transportation to site, physically carrying, vegetation clearance and removal thereof, excavation to specified depth, positioning, setting vertical alignment, backfilling, compaction, and all other actions required for the planting of poles, but excluding stays and Trenching in normal soil conditions, bedding, laying of marker tape, backfilling and compaction. Rates are to be given per linear metre of trench. All excess rubble to be removed and site returned to an acceptable condition. Items expressed in width x depth."]
[]
[null,"1.1.1","300 x 500 mm","m",null,0.15,{"$f":"((E23)*(1+F23))","v":0}]
[null,"1.1.2","400 x 800 mm","m",null,0.15,{"$f":"((E24)*(1+F24))","v":0}]
[null,"1.1.3","1000 x 500 mm – Proving Trench","m",null,0.15,0]
[null,"1.1.4","1000 x 800 mm – Proving Trench","m",null,0.15,0]
[null,"1.2.0","Trenching & backfilling in hard soil conditions"]
[null,null,"Trenching using jackhammer, bedding, laying of marker tape, backfilling and compaction Rates are to be given per linear metre of trench. (Trench depth 650mm or 950mm additional 150mm deep to allow for bedding soil). All excess rubble to be removed and site returned to an acceptable condition. Items expressed in width x depth"]
[null,"1.2.1","300 x 500 mm","m",null,0.15,{"$f":"((E29)*(1+F29))","v":0}]
[null,"1.2.2","400 x 800 mm","m",null,0.15,{"$f":"((E30)*(1+F30))","v":0}]
[null,"1.2.3","Supply bedding sand/m3","m3",null,0.15,{"$f":"((E31)*(1+F31))","v":0}]
[null,"1.3.0","LV cable joints"]
[null,null,"LV cable joints. Rates to be quoted are per a joint, inclusive of all phases."]
[null,"1.3.1","2.5 - 25 mm²","each",null,0.15,{"$f":"((E34)*(1+F34))","v":0}]
[null,"1.3.2","35 - 95 mm²","each",null,0.15,0]
[null,"1.3.3","150 - 240 mm²","each",null,0.15,0]
[null,"1.3.4","35 - 95 mm² Transition Joint Paper-PVC","each",null,0.15,0]
[null,"1.3.5","150 - 240 mm² Transition Joint Paper-PVC","each",null,0.15,0]
[null,"1.4.0","Installation of LV ground mounted kiosks"]
[null,null,"Install ground mount kiosks, including base/slab and housing"]
[null,"1.4.1","6 and 12 Way consumer distribution units including fuse holders installation","each",null,0.15,{"$f":"((E41)*(1+F41))","v":0}]
[null,"1.4.2","LV/Street lighting Switch Pillar","each",null,0.15,0]
[null,"1.4.3","Uprate 6 to 12 way consumer distribution unit\nincluding fuse holders installation","each",null,0.15,0]
[null,"1.4.4","Install earth spike and connect to consumer distribution unit","each",null,0.15,0]
[null,"1.5.0","Installation of cable ducts and erection of cable duct markers"]
[null,null,"Laying of cable ducts including trenching, bedding, backfilling and compaction 800mm below the road surface, per linear metre of duct laid."]
[null,"1.5.1","Laying of PVC 110mm -160mm diameter duct","m",null,0.15,{"$f":"((E47)*(1+F47))","v":0}]
[null,"1.6.0","Laying of LV cables"]
[null,null,"Laying of LV cables inclusive of cable trays. Excluding trenching, backfilling and pulling through ducts."]
[null,"1.6.1","LV cable up to 25 mm²","m",null,0.15,{"$f":"((E50)*(1+F50))","v":0}]
[null,"1.6.2","LV cable 35 - 95 mm²","m",null,0.15,0]
[null,"1.6.3","LV cable 150 - 240 mm²","m",null,0.15,0]
[null,"1.6.4","185 - 240 mm² Single core LV cable","m",null,0.15,0]
[null,"1.7.0","Pulling of cables through ducts"]
[null,null,"Pulling of cables through ducts excluding the laying of duct"]
[null,"1.7.1","LV cable up to 25 mm²","m",null,0.15,{"$f":"((E56)*(1+F56))","v":0}]
[null,"1.7.2","LV cable 35 - 95 mm²","m",null,0.15,0]
[null,"1.7.3","LV cable 150 - 240 mm²","m",null,0.15,0]
[null,"1.7.4","Single core LV cable 185 - 240 mm²","m",null,0.15,0]
[null,"1.8.0","Termination of LV cables in mini substations"]
[null,null,"LV Cable terminations in mini substations, inclusive of all phases."]
[null,"1.8.1","4 - 25 mm² Stranded / Concentric Cu PVC","each",null,0.15,{"$f":"((E62)*(1+F62))","v":0}]
[null,"1.8.2","16 - 50 mm² 4 Core PVC","each",null,0.15,0]
[null,"1.8.3","95 - 150 mm² 4 Core PVC","each",null,0.15,{"$f":"((E64)*(1+F64))","v":0}]
[null,"1.8.4","240 mm² 4 Core PVC","each",null,0.15,{"$f":"((E65)*(1+F65))","v":0}]
[null,"1.8.5","95 - 150 mm² CNE PVC","each",null,0.15,0]
[null,"1.8.6","150 - 240 mm² CNE PVC","each",null,0.15,0]
[null,"1.8.7","185 - 240 mm² Single core LV cable","each",null,0.15,0]
[null,"1.9.0","Termination of LV cables in ground mounted CDU’s/meter boxes/kioskss"]
[null,null,"Include the installation of circuit breakers or fuses, inclusive of all phases."]
[null,"1.9.1","4 - 25 mm² Stranded / Concentric Cu PVC","each",null,0.15,{"$f":"((E71)*(1+F71))","v":0}]
[null,"1.9.2","16 - 50 mm² 4 Core PVC","each",null,0.15,0]
[null,"1.9.3","95 - 150 mm² 4 Core PVC","each",null,0.15,0]
[null,"1.9.4","240 mm² 4 Core PVC","each",null,0.15,0]
[null,"1.9.5","95 - 150 mm² CNE PVC","each",null,0.15,0]
[null,"1.9.6","150 - 240 mm² CNE PVC","each",null,0.15,0]
[null,"1.10.0","LV Circuits in substations"]
[null,null,"Termination shall be priced per substation site and not per LV circuit."]
[null,"1.10.1","Install LV frame / board in substation","each",null,0.15,{"$f":"((E79)*(1+F79))","v":0}]
[null,"1.10.2","Install Stripple Board (200A - 800A)","each",null,0.15,0]
[null,"TOTAL",null,null,{"$f":"SUM(E79:E80,E71:E76,E62:E68,E56:E59,E50:E53,E47:E47,E41:E44,E34:E38,E29:E31,E23:E26)","v":0},0.15,0]
[]
[null,2,"Overhead Mains"]
[]
[]
[null,"2.1.0","Planting of Poles (normal soil conditions)"]
[null,null,"Excavation to specified depth, physically carrying, positioning, setting vertical alignment, backfilling, compaction and all other actions required for the planting of poles, but excluding stays and dressings"]
[null,"2.1.1","Wooden/Fibre Glass /Steel 5 - 7m","each",null,0.15,{"$f":"((E88)*(1+F88))","v":0}]
[null,"2.1.2","Wooden/Fibre Glass/Steel 9m","each",null,0.15,0]
[null,"2.1.3","Wooden/Fibre Glass/Steel 10m - 13m","each",null,0.15,0]
[null,"2.1.4","Concrete 9 m circular","each",null,0.15,0]
[null,"2.1.5","Concrete prestressed 9m 4kN - 7kN","each",null,0.15,0]
[null,"2.1.6","Concrete prestressed 9m 17.5kN, 10 - 11 m 8kN","each",null,0.15,0]
[null,"2.2.0","Planting of Poles (hard ground)"]
[null,null,"Excavation using Jack Hammer. Excavation to specified depth, physically carrying, positioning, setting vertical aligning, backfilling, compaction and all other actions required for the planting of the following poles in accordance with the specification, but excluding stays and dressings."]
[null,"2.2.1","Wooden/Fibre Glass/Steel 5 - 7m","m",null,0.15,{"$f":"((E96)*(1+F96))","v":0}]
[null,"2.2.2","Wooden/Fibre Glass/Steel 9m","m",null,0.15,0]
[null,"2.2.3","Wooden & Steel 10m - 13m","m",null,0.15,0]
[null,"2.2.4","Concrete 9 m circular","m",null,0.15,0]
[null,"2.2.5","Concrete prestressed 9m 4kN - 7kN","m",null,0.15,0]
[null,"2.2.6","800 x 950 mm trench","m",null,0.15,0]
[null,"2.3.0","Splices for overhead mains"]
[null,null,"Full tension splices, jointing inclusive of all phases"]
[null,"2.3.1","Pine /Oak Al conductor (3 conductors)","set",null,0.15,{"$f":"((E104)*(1+F104))","v":0}]
[null,"2.3.2","25 mm² LV ABC (2 Cores)","set",null,0.15,0]
[null,"2.3.3","50 - 95 mm² LV ABC (4 Cores)","set",null,0.15,0]
[null,"2.4.0","Reclamation of overhead conductors"]
[null,null,"Rates must allow for the reclaiming of the associated hardware, excluding poles and stays. Prices to include transportation and be priced per kilogram. (R/kg)"]
[null,"2.4.1","Bare Copper","/kg",null,0.15,{"$f":"((E109)*(1+F109))","v":0}]
[null,"2.4.2","Bare Aluminium","/kg",null,0.15,0]
[null,"2.4.3","ABC","/kg",null,0.15,0]
[null,"2.4.4","Airdac","/kg",null,0.15,0]
[null,"2.5.0","Reclamation of poles and stays and hardware"]
[null,null,"\tReclamation & return to stores of poles and associated hardware. Prices to include transportation."]
[null,"2.5.1","Wooden Poles","each",null,0.15,{"$f":"((E115)*(1+F115))","v":0}]
[null,"2.5.2","Concrete Poles/Steel Poles","each",null,0.15,0]
[null,"2.5.3","Fibre Glass poles","each",null,0.15,0]
[null,"2.5.4","Removal of Stays","each",null,0.15,0]
[null,"2.6.0","Dressing Of Poles On 10, 16 and 25 mm² Airdac Routes"]
[null,null,"Dressing of Intermediate service poles, price per dressing. Rates must allow for affixing of pole numbers."]
[null,"2.6.1","LDW1","each",null,0.15,{"$f":"((E121)*(1+F121))","v":0}]
[null,"2.6.2","LDC1","each",null,0.15,0]
[null,"2.6.3","LDW2","each",null,0.15,0]
[null,"2.6.4","LDC2","each",null,0.15,0]
[null,"2.7.0","Dressing of poles LV ABC."]
[null,null,"Including the use of such specialized tools as may be required. Allow for affixing of pole numbers, all temporary stays that may be necessary but exclude planting of pole, price per dressing."]
[null,"2.7.1","LAX 1/25","each",null,0.15,{"$f":"((E127)*(1+F127))","v":0}]
[null,"2.7.2","LAX 2/25","each",null,0.15,0]
[null,"2.7.3","LAX 3/25","each",null,0.15,0]
[null,"2.7.4","T-Off from 25 mm² ABC LV Route","each",null,0.15,0]
[null,"2.7.5","LAX 1/50 - 1/95","each",null,0.15,0]
[null,"2.7.6","LAX 2/50 - 2/95","each",null,0.15,0]
[null,"2.7.7","LAX 3/50 - 3/95","each",null,0.15,0]
[null,"2.7.8","T-Off from 50-95 mm² ABC LV Route","each",null,0.15,0]
[null,"2.8.0","Strutting and Staying of Poles"]
[null,null,"Strutting /Staying of poles, including excavation necessary."]
[null,"2.8.1","Erection of Stays","each",null,0.15,{"$f":"((E137)*(1+F137))","v":0}]
[null,"2.8.2","Erection of Stays in hard ground ","each",null,0.15,0]
[null,"2.8.3","Erection of Struts","each",null,0.15,0]
[null,"2.8.4","Installation of anti-climbing device","/pole",null,0.15,0]
[null,"2.9.0","Stringing of ABC and Airdac"]
[null,null,"Stringing of ABC cable and Airdac on dressed poles, rates must allow for tensioning as specified. Prices per metre inclusive of all phases."]
[null,"2.9.1","Airdac 10 - 25 mm²","m",null,0.15,{"$f":"((E143)*(1+F143))","v":0}]
[null,"2.9.2","ABC LV 2 core x 25 mm²","m",null,0.15,0]
[null,"2.9.3","ABC LV 4 core x 50 mm²","m",null,0.15,0]
[null,"2.9.4","ABC LV 4 core x 95 mm²","m",null,0.15,0]
[null,"2.10.0","Earthing of LV ABC"]
[null,null,"Construction of combined neutral earth points on ABC in accordance with the Specification. Allow for power drivers and such other specialized tools as may be required."]
[null,"2.10.1","Earthing of LV ABC Circuits ","each",null,0.15,{"$f":"((E149)*(1+F149))","v":0}]
[null,"2.11.0","Aerial CDU's"]
[null,null,"Install and assembly of aerial consumer distribution units and streetlight feeds including phasing and labelling."]
[null,"2.11.1","Spit distribution box for 1 split type meter","each",null,0.15,{"$f":"((E152)*(1+F152))","v":0}]
[null,"2.11.2","Spit distribution box for 4 split type meters","each",null,0.15,0]
[null,"2.11.3","Spit distribution box for 6 split type meters","each",null,0.15,0]
[null,"2.11.4","Remove and replace of existing aerial Cdu's and split distribution box's ","each",null,0.15,0]
[null,"2.12.0","Streetlights"]
[null,null,"Affixing of streetlight on outreach to pole and terminating on fuse or in CDU. Rates must allow for streetlight assembly and fitting to coincide with pole dressing."]
[null,"2.12.1","80W HPMV/LED","each",null,0.15,{"$f":"((E158)*(1+F158))","v":0}]
[null,"2.12.2","Photocell box with internal wiring","each",null,0.15,0]
[null,"2.12.3","Install streetlight cable box","each",null,0.15,0]
[null,"2.13.0","Terminations of LV cables in aerial CDU's"]
[null,null,"Includes, raising and securing of cable up pole and the installation of circuit breakers or fuses as required. Inclusive of all phases."]
[]
[null,"2.13.1","4 - 25 mm² Concentric Cu PVC","each",null,0.15,0]
[null,"2.14.0","Termination of cables onto overhead conductors"]
[null,null,"Includes, raising and securing of cable up pole and the installation of circuit breakers or fuses as required. Inclusive of all phases"]
[]
[null,"2.14.1","4 - 25 mm² Cu Concentric / Stranded PVC","each",null,0.15,{"$f":"((E168)*(1+F168))","v":0}]
[null,"2.14.2","16 - 50 mm² 4 core PVC","each",null,0.15,0]
[null,"2.14.3","95 - 240 mm² 4 core PVC","each",null,0.15,0]
[null,"2.14.4","95 - 240 mm² CNE PVC","each",null,0.15,0]
[null,"Total",null,null,{"$f":"SUM(E158:E171,E152:E155,E149:E149,E143:E146,E137:E140,E127:E134,E121:E124,E115:E118,E109:E112,E104:E106,E96:E101,E88:E93)","v":0},0.15,0]
[]
[null,3,"Labour and Transport "]
[]
[]
[null,"3.1.0","Labour rates"]
[null,null,"Rates to apply for hourly work, authorised by the Senior Manager or his/her representative for work not specified in the document. Such claims are to be agreed upon prior to commencement of project. This is not to be used for calculation of overtime work"]
[]
[null,"3.1.1","Competent Electrician","hr",null,0.15,{"$f":"((E180)*(1+F180))","v":0}]
[null,"3.1.2","Specially Trained Person","hr",null,0.15,0]
[null,"3.1.3","Cable Layer","hr",null,0.15,0]
[null,"3.1.4","Electrician Assistant","hr",null,0.15,0]
[null,"3.1.5","Labourer","hr",null,0.15,0]
[null,"3.2.0","Transport"]
[null,null,"Rates to apply for hourly work, authorised by the Senior Manager or his/her representative for work not specified in the document. Such claims are to be agreed upon prior to commencement of project. This is not to be used for calculation of overtime work"]
[]
[]
[null,"3.2.1","Vehicle up to 1 Tonne","hr",null,0.15,0]
[null,"3.2.2","Vehicle up to 3 Tonne","hr",null,0.15,0]
[null,"3.2.3","Vehicle up to 8 Tonne with Crane","hr",null,0.15,0]
[null,"Total",null,null,{"$f":"SUM(E180:E191)","v":0},0.15,0]
[]
[null,4,"House Services"]
[]
[]
[null,"4.1.0","Labour and Transport Rates"]
[]
[null,null,"Rates to apply for hourly work, authorised by the Senior Manager or his/her representative for work not specified in the document. Such claims are to be agreed upon prior to commencement of project. This is not to be used for calculation of overtime work"]
[]
[]
[null,"4.1.1","Installation of Spilt Pre-payment Meter (Comms wire) in pre-wired formal dwelling (refer 11.4.2.1)","each",null,0.15,{"$f":"((E202)*(1+F202))","v":0}]
[null,"4.1.2","Installation of Spilt Pre-payment Meter (PLC) in pre-wired formal dwelling","each",null,0.15,{"$f":"((E203)*(1+F203))","v":0}]
[null,"4.1.3","Installation of Spilt Pre-payment Meter and SPDU in formal dwelling (refer 11.4.2.2)","each",null,0.15,0]
[null,"4.1.4","Installation of Spilt Pre-payment Meter and SPDU in informal dwelling (refer 11.4.2.3)","each",null,0.15,0]
[null,"4.1.5","Install single phase credit meter and circuit breaker","each",null,0.15,0]
[null,"4.1.6","Install 3phase credit meter and 3phase circuit breaker","each",null,0.15,0]
[null,"4.1.7","Install 3phase Pre-payment meter and 3phase circuit breaker","each",null,0.15,0]
[null,null,"Total",null,{"$f":"SUM(E202:E208)","v":0},0.15,0]
[]
[null,5,"Sundry"]
[]
[]
[]
[null,"5.1.0","Sundry Items"]
[]
[null,null,"To perform the following tasks"]
[null,"5.1.1","Locate consumer/supply GPS co-ordinate","each",null,0.15,{"$f":"((E218)*(1+F218))","v":0}]
[null,"5.1.2","Tracing of existing cables","each",null,0.15,0]
[null,"5.1.3","Install meter/split meter/PLC meter","each",null,0.15,0]
[null,"5.1.4","Remove meter/split meter/PLC meter","each",null,0.15,0]
[null,"5.1.5","Testing of an existing installation","each",null,0.15,0]
[null,"5.1.6","Perform an earth loop impedance test on an existing connection","each",null,0.15,0]
[null,"5.1.7","Install new Customer Interface Unit suitable for split meter","each",null,0.15,0]
[null,"5.1.8","Warning of LV circuits of a transformer","/circuit",null,0.15,0]
[null,"5.1.9","Saw Cutting per meter *","m",null,0.15,0]
[null,"5.1.10","Directional drilling per meter – 110mm - 160mm pipe *","m",null,0.15,0]
[null,"5.1.11","Re-instatement of paving/tiles/bricks per m2","m2",null,0.15,0]
[null,null,"Total",null,{"$f":"SUM(E218:E228)","v":0},0.15,0]
[null,null,"Grand Total Year One",null,{"$f":"SUM(E81,E172,E192,E209,E229)","v":0},0.15,{"$f":"((E230)*(1+F230))","v":0}]

{"sheet":"FINAL","index":3,"n_rows":43,"n_cols":7,"rows_kept":43,"cut":false,"hidden":false,"merged":[[38,4,39,4],[38,5,39,5],[38,6,39,6],[41,5,42,5],[41,6,42,6],[41,4,42,4],[14,3,14,6],[2,2,2,6],[4,2,4,6],[6,2,6,6],[1,6,1,7],[8,2,8,6],[9,1,9,6],[10,1,10,6],[11,1,11,6],[12,3,12,5],[13,3,13,5],[35,6,36,6],[15,2,15,6],[25,1,25,3],[31,2,31,6],[21,1,21,3],[17,1,17,3],[18,1,18,6],[23,2,23,6],[19,2,19,6],[27,2,27,6],[33,1,33,3],[29,1,29,3],[36,2,36,3],[35,4,36,4],[35,5,36,5],[32,2,32,3]]}
[]
[]
[null,null,"CLUSTER : Trading Services"]
[]
[null,null,"UNIT : Electricity"]
[]
[null,null,"DEPARTMENT: MV/LV Operations"]
[]
[null,null,"CONTRACT TITLE"]
[null,"                                House Services- Installation, erection and termination of low voltage underground"]
[null,"                                      and overhead electric cables, streetlight circuitry, customer service cable connections"]
[null,"                                            and associated equipment during a 36-month period"]
[null,null,"Contract No :","Please Select"]
[]
[null,null,"Company Name :"]
[null,1," Underground Mains"]
[]
[null,"Total",null,null,{"$f":"'YEAR ONE'!E81","v":0},{"$f":"'YEAR TWO'!E81","v":0},{"$f":"'YEAR THREE'!E81","v":0}]
[]
[null,2,"Overhead Mains"]
[]
[null,"Total",null,null,{"$f":"'YEAR ONE'!E172","v":0},{"$f":"'YEAR TWO'!E172","v":0},{"$f":"'YEAR THREE'!E172","v":0}]
[]
[null,3,"Labour and Transport "]
[]
[null,"Total",null,null,{"$f":"'YEAR ONE'!E192","v":0},{"$f":"'YEAR TWO'!E192","v":0},{"$f":"'YEAR THREE'!E192","v":0}]
[]
[null,4,"House Services"]
[]
[null,"Total",null,null,{"$f":"'YEAR ONE'!E209","v":0},{"$f":"'YEAR TWO'!E209","v":0},{"$f":"'YEAR THREE'!E209","v":0}]
[]
[null,5,"Sundry"]
[]
[null,"Total",null,null,{"$f":"'YEAR ONE'!E229","v":0},{"$f":"'YEAR TWO'!E229","v":0},{"$f":"'YEAR THREE'!E229","v":0}]
[]
[null,null,null,null,{"$f":"SUM(E18,E22,E26,E30,E34)","v":0},{"$f":"SUM(F18,F22,F26,F30,F34)","v":0},0]
[null,null,"Grand Total"]
[]
[null,null,null,null,{"$f":"(E36*0.15)","v":0},{"$f":"(F36*0.15)","v":0},0]
[null,null,null,"VAT"]
[]
[null,null,null,null,{"$f":"SUM(E36,E39)","v":0},{"$f":"SUM(F36,F39)","v":0},0]
[null,null,null,"Grand Total Incl. VAT"]