{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Index","Hist Opex Summary Curr","Hist Opex Cat Yr1 Curr","Hist Opex Cat Yr2 Curr","Hist Opex Cat Yr3 Curr","Hist Opex Cat Yr4 Curr","Hist Opex Cat Yr5 Curr"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":28,"comments":1,"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":"Index","index":0,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Revenue Reset Information Pro Formas"]
[]
[null,"INDEX","Click on orange box for link to pages"]
[]
[]
[null,"Historic Opex"]
[null,"Table 1.1","Historic Opex by Category current reporting format- Summary"]
[null,1.2,"Historic Opex by Category current reporting format Year 1"]
[null,1.3,"Historic Opex by Category current reporting format Year 2"]
[null,1.4,"Historic Opex by Category current reporting format Year 3"]
[null,1.5,"Historic Opex by Category current reporting format Year 4"]
[null,1.6,"Historic Opex by Category current reporting format Year 5"]
[]
[null,"This file presents operational expenditure in accordance with the current regulatory period reporting format."]

{"sheet":"Hist Opex Summary Curr","index":1,"n_rows":70,"n_cols":13,"rows_kept":70,"cut":false,"hidden":false,"merged":[[4,3,4,5]]}
[]
[null,"Current Regulatory Period (2008-2013) Reporting Format"]
[null,"1.1 HISTORIC OPEX by expenditure category"]
[null,"for the period 1 July 2008 to 30 June 2013"]
[null,"($m, nominal)",null,"As returned to AER"]
[null,null,null,"Actual","Actual","Actual"]
[null,null,null,"2008/09","2009/10","2010/11","2011/12","2012/13","Total",null,"Revenue Cap",null,"Key cost drivers and explanation for material differences over time"]
[null,"Direct Operations & Maintenance"]
[null,"Maintenance"]
[null,"Communications",null,null,null,null,null,null,null,null,null,null,"Continuing trend reflects asset management program applied to a growing asset base, at a lower level than the allowance due to fewer than expected equipment failures requiring corrective maintenance to date"]
[null,"Labour",null,0.72699999999999998,0.92400000000000004,0.8613866215326782,{"$f":"'Hist Opex Cat Yr4 Curr'!N11","v":0.57933140622768986},{"$f":"'Hist Opex Cat Yr5 Curr'!N11","v":0.61444899347067217},{"$f":"SUM(D11:H11)","v":3.7061670212310402}]
[null,"Non Labour",null,0.34300000000000003,0.50900000000000001,0.56761337846732185,{"$f":"'Hist Opex Cat Yr4 Curr'!N12","v":1.486},{"$f":"'Hist Opex Cat Yr5 Curr'!N12","v":0.62155395652932799},{"$f":"SUM(D12:H12)","v":3.5271673349966504}]
[null,"Sub-Totals",null,{"$f":"SUM(D11:D12)","v":1.07},{"$f":"SUM(E11:E12)","v":1.4330000000000001},1.429,2.0653314062276897,1.23600295,7.2333343562276902,null,{"$f":"SUM('Hist Opex Cat Yr1 Curr:Hist Opex Cat Yr4 Curr'!P13)","v":8.4032476911327585}]
[null,"Lines",null,null,null,null,null,null,null,null,null,null,"Continuing growth in refurbishment spend due to increased remedial work, plus increase in routine inspection effort, driven by asset condition and fire start risk mitigation"]
[null,"Labour",null,2.097,2.573,4.3628874372537236,{"$f":"'Hist Opex Cat Yr4 Curr'!N15","v":2.83},{"$f":"'Hist Opex Cat Yr5 Curr'!N15","v":1.8586920083835454},{"$f":"SUM(D15:H15)","v":13.72157944563727}]
[null,"Non Labour",null,2.4329999999999998,2.9870000000000001,5.1371125627462764,{"$f":"'Hist Opex Cat Yr4 Curr'!N16","v":10.93},{"$f":"'Hist Opex Cat Yr5 Curr'!N16","v":6.883743811616454},{"$f":"SUM(D16:H16)","v":28.370856374362731}]
[null,"Sub-Totals",null,{"$f":"SUM(D15:D16)","v":4.5299999999999994},{"$f":"SUM(E15:E16)","v":5.5600000000000005},9.5,13.76,8.742435819999999,42.092435819999999,null,{"$f":"SUM('Hist Opex Cat Yr1 Curr:Hist Opex Cat Yr4 Curr'!P17)","v":24.29808100959605}]
[null,"Secondary Systems",null,null,null,null,null,null,null,null,null,null,"Reflects rescheduling of secondary systems refurbishment activity as available resources were reprioritised to lines and substation maintenance activity"]
[null,"Labour",null,1.458,1.9390000000000001,1.3124359227433147,{"$f":"'Hist Opex Cat Yr4 Curr'!N19","v":1.2037757660664223},{"$f":"'Hist Opex Cat Yr5 Curr'!N19","v":0.97520482665922459},{"$f":"SUM(D19:H19)","v":6.8884165154689612}]
[null,"Non Labour",null,0.59199999999999997,0.81100000000000005,0.33856407725668525,{"$f":"'Hist Opex Cat Yr4 Curr'!N20","v":0.81700000000000006},{"$f":"'Hist Opex Cat Yr5 Curr'!N20","v":0.85492255334077538},{"$f":"SUM(D20:H20)","v":3.4134866305974612}]
[null,"Sub-Totals",null,{"$f":"SUM(D19:D20)","v":2.0499999999999998},{"$f":"SUM(E19:E20)","v":2.75},1.6509999999999998,2.0207757660664223,1.83012738,10.301903146066422,null,{"$f":"SUM('Hist Opex Cat Yr1 Curr:Hist Opex Cat Yr4 Curr'!P21)","v":10.198296618245577}]
[null,"Substations"]
[null,"Labour ",null,6.6929999999999996,8.0069999999999997,8.2652474364890658,{"$f":"'Hist Opex Cat Yr4 Curr'!N23","v":5.7101465831228468},{"$f":"'Hist Opex Cat Yr5 Curr'!N23","v":6.8658786872218425},{"$f":"SUM(D23:H23)","v":35.541272706833752}]
[null,"Non Labour",null,3.4169999999999998,3.5430000000000001,3.509752563510935,{"$f":"'Hist Opex Cat Yr4 Curr'!N24","v":6.21},{"$f":"'Hist Opex Cat Yr5 Curr'!N24","v":7.4338019427781576},{"$f":"SUM(D24:H24)","v":24.113554506289091}]
[null,"Sub-Totals",null,{"$f":"SUM(D23:D24)","v":10.11},{"$f":"SUM(E23:E24)","v":11.55},11.775,11.920146583122847,14.299680630000001,59.654827213122843,null,{"$f":"SUM('Hist Opex Cat Yr1 Curr:Hist Opex Cat Yr4 Curr'!P25)","v":43.230479036062214}]
[null,"Easements"]
[null,"Labour",null,1.071,1.21,1.1866658446148426,{"$f":"'Hist Opex Cat Yr4 Curr'!N27","v":0.81},{"$f":"'Hist Opex Cat Yr5 Curr'!N27","v":0.7854324990056174},{"$f":"SUM(D27:H27)","v":5.0630983436204602}]
[null,"Non Labour",null,0.44900000000000001,0.43,0.40833415538515722,{"$f":"'Hist Opex Cat Yr4 Curr'!N28","v":0.73},{"$f":"'Hist Opex Cat Yr5 Curr'!N28","v":0.69033822099438247},{"$f":"SUM(D28:H28)","v":2.7076723763795396}]
[null,"Sub-Totals",null,{"$f":"SUM(D27:D28)","v":1.52},{"$f":"SUM(E27:E28)","v":1.64},1.5949999999999998,1.54,1.4757707199999999,7.7707707199999998,null,{"$f":"SUM('Hist Opex Cat Yr1 Curr:Hist Opex Cat Yr4 Curr'!P29)","v":4.5991950820928302}]
[null,"Summary",null,null,null,null,null,{"$f":"'Hist Opex Cat Yr5 Curr'!N30","v":0}]
[null,"Sub-Total Labour",null,{"$f":"+D11+D15+D19+D23+D27","v":12.045999999999999},14.652999999999999,15.988623262633624,11.133253755416961,{"$f":"+H11+H15+H19+H23+H27","v":11.099657014740902},64.920534032791494]
[null,"Sub-Total Non Labour",null,7.234,8.2800000000000011,9.9613767373663755,20.173000000000002,{"$f":"+H12+H16+H20+H24+H28","v":16.484360485259096},62.132737222625472]
[null,"Total Maintenance",null,{"$f":"SUM(D31:D32)","v":19.28},{"$f":"SUM(E31:E32)","v":22.933},{"$f":"SUM(F31:F32)","v":25.95},{"$f":"SUM(G31:G32)","v":31.306253755416961},{"$f":"SUM(H31:H32)","v":27.584017499999998},127.05327125541697,null,{"$f":"SUM(K13:K29)","v":90.729299437129427}]
[null,"Field Support"]
[null,"Field Support",null,6.71,6.03,7.0609999999999999,{"$f":"'Hist Opex Cat Yr4 Curr'!N35","v":7.282},{"$f":"'Hist Opex Cat Yr5 Curr'!N35","v":7.06},{"$f":"SUM(D35:H35)","v":34.143000000000001},null,{"$f":"SUM('Hist Opex Cat Yr1 Curr:Hist Opex Cat Yr4 Curr'!P35)","v":28.297202383143436}]
[null,"Direct Charges",null,2.57,2.0870000000000002,2.1549999999999998,{"$f":"'Hist Opex Cat Yr4 Curr'!N36","v":1.9139999999999999},{"$f":"'Hist Opex Cat Yr5 Curr'!N36","v":2.8572122599999998},{"$f":"SUM(D36:H36)","v":11.58321226},null,{"$f":"SUM('Hist Opex Cat Yr1 Curr:Hist Opex Cat Yr4 Curr'!P36)","v":8.1730873781632418}]
[null,"Total Field Support",null,{"$f":"SUM(D35:D36)","v":9.2799999999999994},{"$f":"SUM(E35:E36)","v":8.1170000000000009},9.2159999999999993,9.1959999999999997,9.9172122599999994,45.726212259999997,null,{"$f":"SUM(K35:K36)","v":36.470289761306674}]
[null,"Operations",null,null,null,null,null,{"$f":"'Hist Opex Cat Yr5 Curr'!N38","v":0}]
[null,"Network Switching",null,1.85,1.64,1.5349999999999999,{"$f":"'Hist Opex Cat Yr4 Curr'!N39","v":1.732},{"$f":"'Hist Opex Cat Yr5 Curr'!N39","v":1.68},{"$f":"SUM(D39:H39)","v":8.4370000000000012},null,{"$f":"SUM('Hist Opex Cat Yr1 Curr:Hist Opex Cat Yr4 Curr'!P39)","v":6.0352580118286294}]
[null,"Asset Monitoring",null,0.45,0.46,0.61199999999999999,{"$f":"'Hist Opex Cat Yr4 Curr'!N40","v":0.82699999999999996},{"$f":"'Hist Opex Cat Yr5 Curr'!N40","v":1.47},{"$f":"SUM(D40:H40)","v":3.819},null,{"$f":"SUM('Hist Opex Cat Yr1 Curr:Hist Opex Cat Yr4 Curr'!P40)","v":2.858525148429619}]
[null,"Total Operations",null,{"$f":"SUM(D39:D40)","v":2.3000000000000003},{"$f":"SUM(E39:E40)","v":2.1},2.1469999999999998,2.5590000000000002,{"$f":"SUM(H39:H40)","v":3.15},12.256,null,{"$f":"SUM(K39:K40)","v":8.8937831602582484}]
[null,"Total Direct Operations & Maintenance",null,{"$f":"+D33+D37+D41","v":30.860000000000003},{"$f":"+E33+E37+E41","v":33.15},37.312999999999995,43.061253755416956,{"$f":"+H33+H37+H41","v":40.65122976},185.03548351541698,null,{"$f":"+K33+K34+K38+K41+K37","v":136.09337235869435}]
[null,"Other Controllable"]
[null,"Asset Manager Support"]
[null,"Grid Planning",null,0.92,1.45,1.8380000000000001,{"$f":"'Hist Opex Cat Yr4 Curr'!N45","v":1.258},{"$f":"'Hist Opex Cat Yr5 Curr'!N45","v":1.79},{"$f":"SUM(D45:H45)","v":7.2560000000000002},null,{"$f":"SUM('Hist Opex Cat Yr1 Curr:Hist Opex Cat Yr4 Curr'!P45)","v":4.4927969327274777}]
[null,"Project Support",null,2.79,2.6500000000000004,3.383,{"$f":"'Hist Opex Cat Yr4 Curr'!N46","v":3.2250000000000001},{"$f":"'Hist Opex Cat Yr5 Curr'!N46","v":2.77},{"$f":"SUM(D46:H46)","v":14.818},null,{"$f":"SUM('Hist Opex Cat Yr1 Curr:Hist Opex Cat Yr4 Curr'!P46)","v":12.676484312368455}]
[null,"IT Support",null,1.7,1.24,1.32,{"$f":"'Hist Opex Cat Yr4 Curr'!N47","v":1.921},{"$f":"'Hist Opex Cat Yr5 Curr'!N47","v":1.78},{"$f":"SUM(D47:H47)","v":7.9610000000000003},null,{"$f":"SUM('Hist Opex Cat Yr1 Curr:Hist Opex Cat Yr4 Curr'!P47)","v":7.4415428438072588}]
[null,"Customer & Regulatory Support",null,0.93,0.65,0.57899999999999996,{"$f":"'Hist Opex Cat Yr4 Curr'!N48","v":0.75900000000000001},{"$f":"'Hist Opex Cat Yr5 Curr'!N48","v":2.11},{"$f":"SUM(D48:H48)","v":5.0279999999999996},null,{"$f":"SUM('Hist Opex Cat Yr1 Curr:Hist Opex Cat Yr4 Curr'!P48)","v":2.6521886873972149}]
[null,"Sub-Totals",null,{"$f":"SUM(D45:D48)","v":6.34},{"$f":"SUM(E45:E48)","v":5.9900000000000011},7.12,7.1630000000000011,{"$f":"'Hist Opex Cat Yr5 Curr'!N49","v":8.4491225199999995},35.062999999999995,null,{"$f":"SUM(K45:K48)","v":27.263012776300403}]
[null,"Insurance",null,{"$f":"'Hist Opex Cat Yr1 Curr'!$K50","v":1.8298555724862999},{"$f":"'Hist Opex Cat Yr2 Curr'!$K50","v":1.8501920000000001},{"$f":"'Hist Opex Cat Yr3 Curr'!$K50","v":2.228491},{"$f":"'Hist Opex Cat Yr4 Curr'!$K50","v":2.4809999999999999},{"$f":"'Hist Opex Cat Yr5 Curr'!N50","v":2.81},{"$f":"SUM(D50:H50)","v":11.199538572486301},null,{"$f":"SUM('Hist Opex Cat Yr1 Curr:Hist Opex Cat Yr4 Curr'!P50)","v":11.761621942325}]
[null,"Corporate Support",null,{"$f":"'Hist Opex Cat Yr1 Curr'!$K51","v":9.34},{"$f":"'Hist Opex Cat Yr2 Curr'!$K51","v":9.93},{"$f":"'Hist Opex Cat Yr3 Curr'!$K51","v":9.2170000000000005},{"$f":"'Hist Opex Cat Yr4 Curr'!$K51","v":11.476000000000001},{"$f":"'Hist Opex Cat Yr5 Curr'!N51","v":13.38},{"$f":"SUM(D51:H51)","v":53.343000000000004},null,{"$f":"SUM('Hist Opex Cat Yr1 Curr:Hist Opex Cat Yr4 Curr'!P51)","v":44.856231309683267}]
[null,"Total Other Controllable",null,{"$f":"D49+D50+D51","v":17.509855572486302},{"$f":"E49+E50+E51","v":17.770192000000002},18.565491000000002,21.120000000000005,{"$f":"'Hist Opex Cat Yr5 Curr'!N52","v":24.639122520000001},99.605538572486296,null,{"$f":"SUM(K49:K51)","v":83.880866028308674}]
[]
[null,"Total Maintenance Labour",null,{"$f":"+D31","v":12.045999999999999},14.652999999999999,15.988623262633624,11.133253755416961,{"$f":"'Hist Opex Cat Yr5 Curr'!N54","v":11.099657014740901},64.920534032791494]
[null,"Total Maintenance Non labour",null,7.234,8.2800000000000011,9.9613767373663755,20.173000000000002,{"$f":"'Hist Opex Cat Yr5 Curr'!N55","v":16.484360485259099},62.132737222625472]
[null,"Total Other",null,{"$f":"D52+D41+D37","v":29.0898555724863},{"$f":"E52+E41+E37","v":27.987192000000004},29.928491000000001,32.875000000000007,{"$f":"'Hist Opex Cat Yr5 Curr'!N56","v":37.706334779999999},157.58775083248628]
[null,"TOTAL CONTROLLABLE OPEX ",null,{"$f":"SUM(D54:D56)","v":48.369855572486301},{"$f":"SUM(E54:E56)","v":50.920192},55.878490999999997,64.181253755416975,{"$f":"'Hist Opex Cat Yr5 Curr'!N57","v":65.290352279999993},284.64102208790325,null,{"$f":"K52+K42","v":219.97423838700303}]
[]
[null,"Other Opex"]
[null,"Self Insurance",null,{"$f":"'Hist Opex Cat Yr1 Curr'!$N60","v":1.722934},{"$f":"'Hist Opex Cat Yr2 Curr'!K60","v":1.790808},{"$f":"'Hist Opex Cat Yr3 Curr'!$N60","v":1.8735090000000001},{"$f":"'Hist Opex Cat Yr4 Curr'!$N60","v":1.923},{"$f":"'Hist Opex Cat Yr5 Curr'!N60","v":2.0326559999999998},{"$f":"SUM(D60:H60)","v":9.3429070000000003},null,{"$f":"SUM('Hist Opex Cat Yr1 Curr:Hist Opex Cat Yr4 Curr'!P60)","v":7.3102510000000001}]
[null,"Network Support",null,4.76,4.84,6.6180000000000003,{"$f":"'Hist Opex Cat Yr4 Curr'!N61","v":6.48},{"$f":"'Hist Opex Cat Yr5 Curr'!N61","v":6.74},{"$f":"SUM(D61:H61)","v":29.438000000000002},null,{"$f":"SUM('Hist Opex Cat Yr1 Curr:Hist Opex Cat Yr4 Curr'!P61)","v":21.46332057746665},null,"Refer Network Support Pass Through Application"]
[null,"TOTAL OTHER OPEX",null,{"$f":"SUM(D59:D61)","v":6.4829340000000002},6.630808,8.4915090000000006,8.4030000000000005,{"$f":"'Hist Opex Cat Yr5 Curr'!N62","v":8.7726559999999996},38.780906999999999,null,28.773571577466651]
[]
[]
[null,"Grand Total",null,{"$f":"D62+D57","v":54.852789572486301},{"$f":"E62+E57","v":57.551000000000002},64.37,72.584253755416981,{"$f":"H62+H57","v":74.063008279999991},{"$f":"+I57+I62","v":323.42192908790327},null,{"$f":"+K57+K62","v":248.74780996446967}]
[]
[null,"Revenue Cap Allowance",null,{"$f":"'Hist Opex Cat Yr1 Curr'!N67","v":56.545268405691829},{"$f":"'Hist Opex Cat Yr2 Curr'!N67","v":59.979713659342252},{"$f":"'Hist Opex Cat Yr3 Curr'!N67","v":64.088014665043318},{"$f":"'Hist Opex Cat Yr4 Curr'!N67","v":68.133943000000002},{"$f":"'Hist Opex Cat Yr5 Curr'!N67","v":72.81},{"$f":"SUM(D67:H67)","v":321.55693973007737}]
[null,"Corrected values in red"]
[]
[null,null,null,54.826343575878624,57.55479396413098,64.279895206244817,72.583785116987471,74.072656742377688,323.31747460561962,null,321.55299673007738]

{"sheet":"Hist Opex Cat Yr1 Curr","index":2,"n_rows":67,"n_cols":18,"rows_kept":67,"cut":false,"hidden":false,"merged":[[4,2,4,15],[5,2,5,4],[5,5,6,5],[5,6,6,6],[5,8,6,8],[5,9,5,10],[5,11,6,11]]}
[]
[null,"Current Regulatory Period (2008-2013) Reporting Format"]
[null,"Historical expenditure category"]
[null,"2008/09"]
[null,"($m, nominal)","Year 1"]
[null,null,"Field Maintenance  ",null,null,"Field Maintenance","Operational Refurbishment",null,"Network Monitoring & Control","Support / Corporate",null,"Corporate Support"]
[null,null,"Routine","Condition-Based","Corrective",null,null,"Maintenance Support",null,"Network","Non-Network",null,null,"TOTAL",null,"Revenue Cap Allowance ",null,"Key cost drivers and explanation for material differences over time"]
[null,"Direct Operations & Maintenance"]
[null,"Field Maintenance"]
[null,"Communications"]
[null,"Labour",0.44993624480566108,0,0.21578789843419025,null,6.1165274972156562E-2,null,null,null,null,null,null,{"$f":"SUM(C11:K11)","v":0.72688941821200781}]
[null,"Non Labour",0.2800637551943389,0,4.2121015658097517E-3,null,5.8834725027843433E-2,null,null,null,null,null,null,{"$f":"SUM(C12:K12)","v":0.34311058178799209}]
[null,"Communications",{"$f":"SUM(C11:C12)","v":0.73},0,0.22,{"$f":"SUM(C13:E13)","v":0.95},0.12,0,0,0,0,{"$f":"SUM(J13:K13)","v":0},null,{"$f":"SUM(F13:K13)","v":1.0699999999999998},null,1.6847902155713343,null,"The corrective maintenance spend in communication equipment is reactive in nature, the fall in activity vs. AER allowance represents a reduced level of equipment failures.  While it is too early in the regulatory period to determine if this trend will continue and result in permanent saving. The reduction in the communication refurbishment spend represents a reduced level of activity due to efficiency targets."]
[null,"Lines"]
[null,"Labour",0.4782031606705418,0,0.62291069713337199,null,0.99608307712423805,null,null,null,null,null,null,{"$f":"SUM(C15:K15)","v":2.0971969349281521},null,null,null,"                                                                        "]
[null,"Non Labour",0.58179683932945825,0,0.58708930286662797,null,1.2639169228757616,null,null,null,null,null,null,{"$f":"SUM(C16:K16)","v":2.4328030650718477}]
[null,"Lines",{"$f":"SUM(C15:C16)","v":1.06},0,1.21,{"$f":"SUM(C17:E17)","v":2.27},2.2599999999999998,0,0,0,0,{"$f":"SUM(J17:K17)","v":0},null,{"$f":"SUM(F17:K17)","v":4.5299999999999994},null,6.254689699981534,null,"Removal of the Port River Crossing line & towers was identified in the AER allowance but has been postponed to later in the Regulatory Period."]
[null,"Secondary Systems",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"                                                                        "]
[null,"Labour",0.35748359176340194,0,0.63749263615642249,null,0.46305745889664757,null,null,null,null,null,null,{"$f":"SUM(C19:K19)","v":1.4580336868164721},null,null,null,"                                                                        "]
[null,"Non Labour",0.22251640823659805,0,7.2507363843577644E-2,null,0.29694254110335244,null,null,null,null,null,null,{"$f":"SUM(C20:K20)","v":0.59196631318352821}]
[null,"Secondary Systems",{"$f":"SUM(C19:C20)","v":0.57999999999999996},0,0.71000000000000019,{"$f":"SUM(C21:E21)","v":1.29},0.76,0,0,0,0,{"$f":"SUM(J21:K21)","v":0},null,{"$f":"SUM(F21:K21)","v":2.0499999999999998},null,2.0697884033113469]
[null,"Substations"]
[null,"Labour ",2.4284230199100061,0.18693044151084068,3.1531419887327097,null,0.92520625998176032,null,null,null,null,null,null,{"$f":"SUM(C23:K23)","v":6.6937017101353167}]
[null,"Non Labour",1.5115769800899941,3.3069558489159309E-2,0.36685801126729178,null,1.5047937400182365,null,null,null,null,null,null,{"$f":"SUM(C24:K24)","v":3.4162982898646819}]
[null,"Substations",{"$f":"SUM(C23:C24)","v":3.9400000000000004},0.21999999999999997,3.5200000000000014,{"$f":"SUM(C25:E25)","v":7.6800000000000015},2.4299999999999971,0,0,0,0,{"$f":"SUM(J25:K25)","v":0},null,{"$f":"SUM(F25:K25)","v":10.11},null,9.8327762046943672]
[null,"Easements"]
[null,"Labour",1.0714734855628318,0,0,null,0,null,null,null,null,null,null,{"$f":"SUM(C27:K27)","v":1.0714734855628318}]
[null,"Non Labour",0.34852651443716814,0,0,null,0.1,null,null,null,null,null,null,{"$f":"SUM(C28:K28)","v":0.44852651443716818}]
[null,"Easements",{"$f":"SUM(C27:C28)","v":1.42},0,0,{"$f":"SUM(C29:E29)","v":1.42},0.1,0,0,0,0,{"$f":"SUM(J29:K29)","v":0},null,{"$f":"SUM(F29:K29)","v":1.52},null,1.0792939464720253,null,"The overspend in routine easement spend represent extra vegetation cutting requirements placed on Electranet from the Office of the Technical Regulator (OTR). "]
[null,"Summary",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"                                                                        "]
[null,"Sub-Total Labour",{"$f":"+C11+C15+C19+C23+C27","v":4.7855195027124431},0.18693044151084068,4.6293332204566946,null,2.4455120709748028,0,0,0,{"$f":"+K11+K15+K19+K23+K27","v":0},null,null,{"$f":"SUM(F31:K31)","v":2.4455120709748028},null,null,null,"                                                                        "]
[null,"Sub-Total Non Labour",2.9444804972875573,3.3069558489159309E-2,1.0306667795433073,null,3.224487929025194,0,0,0,0,null,null,{"$f":"SUM(F32:K32)","v":3.224487929025194}]
[null,"Total Maintenance",{"$f":"+C31+C32","v":7.73},0.21999999999999997,5.6600000000000019,{"$f":"SUM(C33:E33)","v":13.610000000000003},5.6699999999999964,0,0,0,0,{"$f":"SUM(J33:K33)","v":0},null,{"$f":"SUM(F33:K33)","v":19.28},null,20.921338470030609]
[null,"Field Support"]
[null,"Field Support",null,null,null,null,null,6.71,null,null,null,null,null,{"$f":"SUM(C35:K35)","v":6.71},null,6.4087646077874192]
[null,"Direct Charges",null,null,null,null,null,2.57,null,null,null,null,null,{"$f":"SUM(C36:K36)","v":2.57},null,1.7815157093237022,null,"Communication expenses increased significantly as extra data services required on new substations."]
[null,"Field Support",{"$f":"SUM(C35:C36)","v":0},0,0,{"$f":"SUM(C37:E37)","v":0},0,9.2799999999999994,0,0,0,{"$f":"SUM(J37:K37)","v":0},null,{"$f":"SUM(F37:K37)","v":9.2799999999999994},null,{"$f":"SUM(P35:P36)","v":8.1902803171111209}]
[null,"Operations"]
[null,"Network Switching",null,null,null,null,null,null,1.85,null,null,null,null,{"$f":"SUM(C39:K39)","v":1.85},null,1.3616258748797687]
[null,"Asset Monitoring",null,null,null,null,null,null,0.45,null,null,null,null,{"$f":"SUM(C40:K40)","v":0.45},null,0.64472089638470542]
[null,"Operations",{"$f":"SUM(C39:C40)","v":0},0,0,{"$f":"SUM(C41:E41)","v":0},0,0,2.3000000000000003,0,0,{"$f":"SUM(J41:K41)","v":0},null,{"$f":"SUM(F41:K41)","v":2.3000000000000003},null,{"$f":"SUM(P39:P40)","v":2.0063467712644742}]
[null,"Total Direct Operations & Maintenance",{"$f":"+C41+C37+C33","v":7.73},0.21999999999999997,5.6600000000000019,{"$f":"SUM(C42:E42)","v":13.610000000000003},5.6699999999999964,9.2799999999999994,{"$f":"+I41+I37+I33","v":2.3000000000000003},0,0,{"$f":"SUM(J42:K42)","v":0},null,{"$f":"SUM(F42:K42)","v":30.860000000000003},null,{"$f":"P41+P37+P33","v":31.117965558406205}]
[null,"Other Controllable"]
[null,"Asset Manager Support"]
[null,"Grid Planning",null,null,null,null,null,null,null,0.92,null,null,null,{"$f":"SUM(C45:K45)","v":0.92},null,1.0390271437850505]
[null,"Project Support",null,null,null,null,null,null,null,2.79,null,null,null,{"$f":"SUM(C46:K46)","v":2.79},null,2.9112620451831104]
[null,"IT Support",null,null,null,null,null,null,null,null,1.7,null,null,{"$f":"SUM(C47:K47)","v":1.7},null,1.752788653460865]
[null,"Customer & Regulatory Support",null,null,null,null,null,null,null,0.93,null,null,null,{"$f":"SUM(C48:K48)","v":0.93},null,0.61437687018421971,null,"The overspend represents additional regulation compliance service and an increase in legal costs for the Merits Review"]
[null,"Asset Manager Support",{"$f":"SUM(C45:C48)","v":0},0,0,{"$f":"SUM(C49:E49)","v":0},0,0,0,4.6399999999999997,1.7,{"$f":"SUM(J49:K49)","v":6.34},null,{"$f":"SUM(F49:K49)","v":6.34},null,{"$f":"SUM(P45:P48)","v":6.3174547126132454}]
[null,"Insurance",null,null,null,0,0,0,0,null,1.8298555724862999,{"$f":"SUM(J50:K50)","v":1.8298555724862999},null,{"$f":"SUM(F50:K50)","v":1.8298555724862999},null,{"$f":"4.201872942325-K60","v":2.4789389423250001},null,"ElectraNet achieved lower insurance premiums for the year due to the current economic climate"]
[null,"Corporate Support",null,null,null,0,0,0,0,null,9.34,{"$f":"SUM(J51:K51)","v":9.34},null,{"$f":"SUM(F51:K51)","v":9.34},null,10.073017161761408]
[null,"Total Other Controllable",{"$f":"+C51+C50+C49","v":0},{"$f":"+D51+D50+D49","v":0},0,{"$f":"SUM(C52:E52)","v":0},0,0,0,4.6399999999999997,12.8698555724863,{"$f":"SUM(J52:K52)","v":17.509855572486298},null,{"$f":"SUM(F52:K52)","v":17.509855572486298},null,{"$f":"SUM(P49:P51)","v":18.869410816699656}]
[]
[null,"Total Maintenance Labour",{"$f":"+C31","v":4.7855195027124431},0.18693044151084068,4.6293332204566946,null,2.4455120709748028,0,0,0,0,null,null,{"$f":"SUM(F54:K54)","v":2.4455120709748028}]
[null,"Total Maintenance Non labour",2.9444804972875573,3.3069558489159309E-2,1.0306667795433073,null,3.224487929025194,0,0,0,0,null,null,{"$f":"SUM(F55:K55)","v":3.224487929025194}]
[null,"Total Other",{"$f":"C37+C41+C49+C50+C51","v":0},{"$f":"D37+D41+D49+D50+D51","v":0},0,0,0,9.2799999999999994,2.3000000000000003,4.6399999999999997,12.8698555724863,null,null,{"$f":"SUM(F56:K56)","v":29.0898555724863}]
[null,"TOTAL CONTROLLABLE OPEX ",{"$f":"+C52+C42","v":7.73},{"$f":"+D52+D42","v":0.21999999999999997},{"$f":"+E52+E42","v":5.6600000000000019},{"$f":"SUM(C57:E57)","v":13.610000000000003},{"$f":"+G52+G42","v":5.6699999999999964},{"$f":"+H52+H42","v":9.2799999999999994},{"$f":"+I52+I42","v":2.3000000000000003},{"$f":"+J52+J42","v":4.6399999999999997},{"$f":"+K52+K42","v":12.8698555724863},{"$f":"SUM(J57:K57)","v":17.509855572486298},null,{"$f":"SUM(F57:K57)","v":48.369855572486301},null,{"$f":"P52+P42","v":49.98737637510586}]
[]
[null,"Other Opex"]
[null,"Self Insurance",null,null,null,0,0,0,0,null,1.722934,{"$f":"SUM(J60:K60)","v":1.722934},null,{"$f":"SUM(F60:K60)","v":1.722934},null,{"$f":"K60","v":1.722934}]
[null,"Network Support",null,null,null,0,0,0,0,4.76,null,{"$f":"SUM(J61:K61)","v":4.76},null,{"$f":"SUM(F61:K61)","v":4.76},null,4.8349580305859705]
[null,"TOTAL OTHER OPEX",{"$f":"SUM(C61:C61)","v":0},{"$f":"SUM(D61:D61)","v":0},{"$f":"SUM(E60:E61)","v":0},0,0,0,0,4.76,1.722934,{"$f":"SUM(L60:L61)","v":6.4829340000000002},null,{"$f":"SUM(N60:N61)","v":6.4829340000000002},null,6.55789203058597]
[]
[]
[null,"Grand Total",{"$f":"+C62+C57","v":7.73},0.21999999999999997,5.6600000000000019,{"$f":"SUM(C65:E65)","v":13.610000000000003},5.6699999999999964,9.2799999999999994,2.3000000000000003,9.3999999999999986,14.5927895724863,{"$f":"SUM(J65:K65)","v":23.992789572486299},null,{"$f":"+N62+N57","v":54.852789572486301},null,{"$f":"P57+P62","v":56.545268405691829}]
[]
[null,"Revenue Cap Allowance",8.327479579686603,0.12380738701013837,4.8602802793694293,13.311567246066172,7.6097712239644366,8.1902803171111209,2.0063467712644742,9.3996240897383512,16.027678757547275,25.427302847285624,null,{"$f":"SUM(F67:K67)","v":56.545268405691829},null,{"$f":"N67","v":56.545268405691829}]

{"sheet":"Hist Opex Cat Yr2 Curr","index":3,"n_rows":68,"n_cols":18,"rows_kept":68,"cut":false,"hidden":false,"merged":[[5,17,6,17],[4,2,4,15],[5,2,5,4],[5,5,6,5],[5,6,6,6],[5,8,6,8],[5,9,5,10],[5,11,6,11]]}
[]
[null,"Current Regulatory Period (2008-2013) Reporting Format"]
[null,"Historical expenditure category"]
[null,"2009/10"]
[null,"($m, nominal)","Year 2"]
[null,null,"Field Maintenance  ",null,null,"Field Maintenance","Operational Refurbishment",null,"Network Monitoring & Control","Support / Corporate",null,"Corporate Support",null,null,null,null,null,"Key cost drivers and explanation for material differences over time"]
[null,null,"Routine","Condition-Based","Corrective",null,null,"Maintenance Support",null,"Network","Non-Network",null,null,"TOTAL",null,"Revenue Cap Allowance "]
[null,"Direct Operations & Maintenance"]
[null,"Field Maintenance"]
[null,"Communications"]
[null,"Labour",0.52969616312356127,0,0.18643742361076396,null,0.20743425367466717,null,null,null,null,null,null,{"$f":"SUM(C11:K11)","v":0.92356784040899242}]
[null,"Non Labour",0.3133038368764387,0,3.5625763892360484E-3,null,0.19256574632533285,null,null,null,null,null,null,{"$f":"SUM(C12:K12)","v":0.50943215959100763}]
[null,"Communications",{"$f":"SUM(C11:C12)","v":0.84299999999999997},{"$f":"SUM(D11:D12)","v":0},{"$f":"SUM(E11:E12)","v":0.19},{"$f":"SUM(C13:E13)","v":1.0329999999999999},{"$f":"SUM(G11:G12)","v":0.4},{"$f":"SUM(H11:H12)","v":0},{"$f":"SUM(I11:I12)","v":0},{"$f":"SUM(J11:J12)","v":0},{"$f":"SUM(K11:K12)","v":0},{"$f":"SUM(J13:K13)","v":0},null,{"$f":"SUM(F13:K13)","v":1.4329999999999998},null,2.0338586836717165,null,"As corrective maintenance spend in communication equipment is reactive in nature, the variance to the allowance reflects a reduced level of equipment failures.  It is too early in the regulatory period to determine if this trend will continue and result in permanent saving. "]
[null,"Lines"]
[null,"Labour",0.76478368205742819,0,0.88419557296299944,null,0.92372661925561805,null,null,null,null,null,null,{"$f":"SUM(C15:K15)","v":2.5727058742760458}]
[null,"Non Labour",0.88521631794257172,0,0.81580442703700051,null,1.286273380744382,null,null,null,null,null,null,{"$f":"SUM(C16:K16)","v":2.9872941257239543}]
[null,"Lines",{"$f":"SUM(C15:C16)","v":1.65},{"$f":"SUM(D15:D16)","v":0},{"$f":"SUM(E15:E16)","v":1.7},{"$f":"SUM(C17:E17)","v":3.3499999999999996},{"$f":"SUM(G15:G16)","v":2.21},{"$f":"SUM(H15:H16)","v":0},{"$f":"SUM(I15:I16)","v":0},{"$f":"SUM(J15:J16)","v":0},{"$f":"SUM(K15:K16)","v":0},{"$f":"SUM(J17:K17)","v":0},null,{"$f":"SUM(F17:K17)","v":5.56},null,6.1201119012784986]
[null,"Secondary Systems"]
[null,"Labour",0.33930715075530621,0,0.7468435533795722,null,0.85244055091504645,null,null,null,null,null,null,{"$f":"SUM(C19:K19)","v":1.9385912550499249}]
[null,"Non Labour",0.2006928492446938,0,8.3156446620427787E-2,null,0.52755944908495345,null,null,null,null,null,null,{"$f":"SUM(C20:K20)","v":0.81140874495007509}]
[null,"Secondary Systems",{"$f":"SUM(C19:C20)","v":0.54},{"$f":"SUM(D19:D20)","v":0},{"$f":"SUM(E19:E20)","v":0.83},{"$f":"SUM(C21:E21)","v":1.37},{"$f":"SUM(G19:G20)","v":1.38},{"$f":"SUM(H19:H20)","v":0},{"$f":"SUM(I19:I20)","v":0},{"$f":"SUM(J19:J20)","v":0},{"$f":"SUM(K19:K20)","v":0},{"$f":"SUM(J21:K21)","v":0},null,{"$f":"SUM(F21:K21)","v":2.75},null,2.4395032482273056]
[null,"Substations"]
[null,"Labour ",2.3814335210418709,0,3.5753310551626734,null,2.0500457117081217,null,null,null,null,null,null,{"$f":"SUM(C23:K23)","v":8.0068102879126659}]
[null,"Non Labour",1.4085664789581291,0,0.63466894483732639,null,1.4999542882918784,null,null,null,null,null,null,{"$f":"SUM(C24:K24)","v":3.5431897120873339}]
[null,"Substations",{"$f":"SUM(C23:C24)","v":3.79},{"$f":"SUM(D23:D24)","v":0},{"$f":"SUM(E23:E24)","v":4.21},{"$f":"SUM(C25:E25)","v":8},{"$f":"SUM(G23:G24)-0.01","v":3.54},{"$f":"SUM(H23:H24)","v":0},{"$f":"SUM(I23:I24)","v":0},{"$f":"SUM(J23:J24)","v":0},{"$f":"SUM(K23:K24)","v":0},{"$f":"SUM(J25:K25)","v":0},null,{"$f":"SUM(F25:K25)","v":11.54},null,10.37252038935336]
[null,"Easements"]
[null,"Labour",1.2102305947230516,0,0,null,0,null,null,null,null,null,null,{"$f":"SUM(C27:K27)","v":1.2102305947230516}]
[null,"Non Labour",0.37976940527694847,0,0.05,null,0,null,null,null,null,null,null,{"$f":"SUM(C28:K28)","v":0.42976940527694846}]
[null,"Easements",{"$f":"SUM(C27:C28)","v":1.59},{"$f":"SUM(D27:D28)","v":0},{"$f":"SUM(E27:E28)","v":0.05},{"$f":"SUM(C29:E29)","v":1.6400000000000001},{"$f":"SUM(G27:G28)","v":0},{"$f":"SUM(H27:H28)","v":0},{"$f":"SUM(I27:I28)","v":0},{"$f":"SUM(J27:J28)","v":0},{"$f":"SUM(K27:K28)","v":0},{"$f":"SUM(J29:K29)","v":0},null,{"$f":"SUM(F29:K29)","v":1.6400000000000001},null,1.128086506942328,null,"The continuing overspend in routine easement spend reflects extra vegetation cutting requirements placed on ElectraNet by the Technical Regulator."]
[null,"Summary"]
[null,"Sub-Total Labour",{"$f":"+C11+C15+C19+C23+C27","v":5.2254511117012177},0,5.3928076051160083,{"$f":"SUM(C31:E31)","v":10.618258716817227},{"$f":"+G11+G15+G19+G23+G27","v":4.0336471355534531},0,0,0,0,null,null,{"$f":"SUM(F31:K31)","v":14.65190585237068}]
[null,"Sub-Total Non Labour",3.1875488882987817,0,1.5871923948839908,{"$f":"SUM(C32:E32)","v":4.774741283182772},3.5063528644465469,0,0,0,0,null,null,{"$f":"SUM(F32:K32)","v":8.2810941476293181}]
[null,"Total Maintenance",{"$f":"+C31+C32","v":8.4130000000000003},{"$f":"+D31+D32","v":0},{"$f":"+E31+E32","v":6.9799999999999986},{"$f":"SUM(C33:E33)","v":15.392999999999999},{"$f":"+G31+G32","v":7.54},{"$f":"+H31+H32","v":0},{"$f":"+I31+I32","v":0},{"$f":"+J31+J32","v":0},{"$f":"+K31+K32","v":0},{"$f":"SUM(J33:K33)","v":0},null,{"$f":"SUM(F33:K33)","v":22.933},null,22.094080729473209]
[null,"Field Support"]
[null,"Field Support",null,null,null,null,null,6.04,null,null,null,null,null,{"$f":"SUM(C35:K35)","v":6.04},null,6.8449429631714507]
[null,"Direct Charges",null,null,null,null,null,2.0870000000000002,null,null,null,null,null,{"$f":"SUM(C36:K36)","v":2.0870000000000002},null,1.9636542875126297,null,"Additional Land Tax obligation, and rate of growth of property values"]
[null,"Field Support",{"$f":"SUM(C35:C36)","v":0},{"$f":"SUM(D35:D36)","v":0},{"$f":"SUM(E35:E36)","v":0},{"$f":"SUM(C37:E37)","v":0},{"$f":"SUM(G35:G36)","v":0},{"$f":"SUM(H35:H36)","v":8.1270000000000007},{"$f":"SUM(I35:I36)","v":0},{"$f":"SUM(J35:J36)","v":0},{"$f":"SUM(K35:K36)","v":0},{"$f":"SUM(J37:K37)","v":0},null,{"$f":"SUM(F37:K37)","v":8.1270000000000007},null,{"$f":"SUM(P35:P36)","v":8.8085972506840804}]
[null,"Operations"]
[null,"Network Switching",null,null,null,null,null,null,1.64,null,null,null,null,{"$f":"SUM(C39:K39)","v":1.64},null,1.4580097602691549,null,"General growth due to asset growth and wages growth"]
[null,"Asset Monitoring",null,null,null,null,null,null,0.46,null,null,null,null,{"$f":"SUM(C40:K40)","v":0.46},null,0.6910630596743057]
[null,"Operations",{"$f":"SUM(C39:C40)","v":0},{"$f":"SUM(D39:D40)","v":0},{"$f":"SUM(E39:E40)","v":0},{"$f":"SUM(C41:E41)","v":0},{"$f":"SUM(G39:G40)","v":0},{"$f":"SUM(H39:H40)","v":0},{"$f":"SUM(I39:I40)","v":2.1},{"$f":"SUM(J39:J40)","v":0},{"$f":"SUM(K39:K40)","v":0},{"$f":"SUM(J41:K41)","v":0},null,{"$f":"SUM(F41:K41)","v":2.1},null,{"$f":"SUM(P39:P40)","v":2.1490728199434606}]
[null,"Total Direct Operations & Maintenance",{"$f":"+C41+C37+C33","v":8.4130000000000003},{"$f":"+D41+D37+D33","v":0},{"$f":"+E41+E37+E33","v":6.9799999999999986},{"$f":"SUM(C42:E42)","v":15.392999999999999},{"$f":"+G41+G37+G33","v":7.54},{"$f":"+H41+H37+H33","v":8.1270000000000007},{"$f":"+I41+I37+I33","v":2.1},{"$f":"+J41+J37+J33","v":0},{"$f":"+K41+K37+K33","v":0},{"$f":"SUM(J42:K42)","v":0},null,{"$f":"SUM(F42:K42)","v":33.160000000000004},null,{"$f":"P41+P37+P33","v":33.051750800100749}]
[null,"Other Controllable"]
[null,"Asset Manager Support"]
[null,"Grid Planning",null,null,null,null,null,null,null,1.4500000000000002,null,null,null,{"$f":"SUM(C45:K45)","v":1.4500000000000002},null,1.0951774172711009,null,"General growth due to asset growth and wages growth"]
[null,"Project Support",null,null,null,null,null,null,null,2.66,null,null,null,{"$f":"SUM(C46:K46)","v":2.66},null,3.0823706697074917]
[null,"IT Support",null,null,null,null,null,null,null,null,1.24,null,null,{"$f":"SUM(C47:K47)","v":1.24},null,1.8234856662605272,null,"Internal charging decrease resulting from lower proportion of costs allocated to this area.  The shift in cost allocation is a result of higher capital allocation of IT costs compared to the previous year."]
[null,"Customer & Regulatory Support",null,null,null,null,null,null,null,0.65,null,null,null,{"$f":"SUM(C48:K48)","v":0.65},null,0.64605985960059376]
[null,"Asset Manager Support",{"$f":"SUM(C45:C48)","v":0},{"$f":"SUM(D45:D48)","v":0},{"$f":"SUM(E45:E48)","v":0},{"$f":"SUM(C49:E49)","v":0},{"$f":"SUM(G45:G48)","v":0},{"$f":"SUM(H45:H48)","v":0},{"$f":"SUM(I45:I48)","v":0},{"$f":"SUM(J45:J48)","v":4.7600000000000007},{"$f":"SUM(K45:K48)","v":1.24},{"$f":"SUM(J49:K49)-0.01","v":5.9900000000000011},null,{"$f":"SUM(F49:K49)-0.01","v":5.9900000000000011},null,{"$f":"SUM(P45:P48)","v":6.647093612839714}]
[null,"Insurance",null,null,null,0,0,0,0,null,1.8501920000000001,{"$f":"SUM(J50:K50)+0.01","v":1.8601920000000001},null,{"$f":"SUM(F50:K50)+0.01","v":1.8601920000000001},null,{"$f":"4.55-K60","v":2.7591919999999996}]
[null,"Corporate Support",null,null,null,0,0,0,0,null,9.93,{"$f":"SUM(J51:K51)","v":9.93},null,{"$f":"SUM(F51:K51)","v":9.93},null,10.596601517797799]
[null,"Total Other Controllable",{"$f":"+C51+C50+C49","v":0},{"$f":"+D51+D50+D49","v":0},{"$f":"+E51+E50+E49","v":0},{"$f":"SUM(C52:E52)","v":0},{"$f":"+G51+G50+G49","v":0},{"$f":"+H51+H50+H49","v":0},{"$f":"+I51+I50+I49","v":0},{"$f":"+J51+J50+J49","v":4.7600000000000007},{"$f":"+K51+K50+K49","v":13.020192},{"$f":"SUM(J52:K52)-0.01","v":17.770191999999998},null,{"$f":"SUM(F52:K52)-0.01","v":17.770191999999998},null,{"$f":"SUM(P49:P51)","v":20.002887130637511}]
[]
[null,"Total Maintenance Labour",{"$f":"+C31","v":5.2254511117012177},0,5.3928076051160083,null,{"$f":"+G31","v":4.0336471355534531},0,0,0,0,null,null,{"$f":"SUM(F54:K54)","v":4.0336471355534531}]
[null,"Total Maintenance Non labour",3.1875488882987817,0,1.5871923948839908,null,3.5063528644465469,0,0,0,0,null,null,{"$f":"SUM(F55:K55)","v":3.5063528644465469}]
[null,"Total Other",{"$f":"C37+C41+C49+C50+C51","v":0},0,0,0,0,8.1270000000000007,2.1,4.7600000000000007,13.020192,null,null,{"$f":"SUM(F56:K56)","v":28.007192000000003}]
[null,"TOTAL CONTROLLABLE OPEX ",{"$f":"+C52+C42","v":8.4130000000000003},{"$f":"+D52+D42","v":0},{"$f":"+E52+E42","v":6.9799999999999986},{"$f":"SUM(C57:E57)","v":15.392999999999999},{"$f":"+G52+G42","v":7.54},{"$f":"+H52+H42","v":8.1270000000000007},{"$f":"+I52+I42","v":2.1},{"$f":"+J52+J42","v":4.7600000000000007},{"$f":"+K52+K42","v":13.020192},{"$f":"SUM(J57:K57)-0.01","v":17.770191999999998},null,{"$f":"SUM(F57:K57)","v":50.940192000000003},null,{"$f":"P52+P42","v":53.054637930738259}]
[]
[null,"Other Opex"]
[null,"Self Insurance",null,null,null,0,0,0,0,0,1.790808,{"$f":"SUM(J60:K60)","v":1.790808},null,{"$f":"SUM(F60:K60)","v":1.790808},null,{"$f":"K60","v":1.790808}]
[null,"Network Support",null,null,null,0,0,0,0,4.84,null,{"$f":"SUM(J61:K61)","v":4.84},null,{"$f":"SUM(F61:K61)","v":4.84},null,5.1351902187043379]
[null,"TOTAL OTHER OPEX",{"$f":"SUM(C61:C61)","v":0},{"$f":"SUM(D61:D61)","v":0},{"$f":"SUM(E60:E61)","v":0},0,0,0,0,4.84,1.790808,{"$f":"SUM(L60:L61)","v":6.630808},null,{"$f":"SUM(N60:N61)","v":6.630808},null,6.9259982187043381]
[]
[]
[null,"Grand Total",{"$f":"+C62+C57","v":8.4130000000000003},0,6.9799999999999986,15.392999999999999,7.54,8.1270000000000007,2.1,9.6000000000000014,14.811,{"$f":"SUM(J65:K65)-0.01","v":24.401},null,{"$f":"+N62+N57","v":57.571000000000005},null,{"$f":"P57+P62","v":59.980636149442596}]
[]
[null,"Revenue Cap Allowance",9.2512090410042944,0.13568370137677493,5.3142520123130756,14.701144754694145,7.3929359747790642,8.8085972506840804,2.1490728199434606,9.9587981652835253,16.969164693957982,26.927962859241507,null,{"$f":"SUM(F67:K67)","v":59.979713659342252},null,{"$f":"N67","v":59.979713659342252}]
[null,"Corrected values in red"]

{"sheet":"Hist Opex Cat Yr3 Curr","index":4,"n_rows":68,"n_cols":18,"rows_kept":68,"cut":false,"hidden":false,"merged":[[5,17,6,17],[4,2,4,15],[5,2,5,4],[5,5,6,5],[5,6,6,6],[5,8,6,8],[5,9,5,10],[5,11,6,11]]}
[]
[null,"Current Regulatory Period (2008-2013) Reporting Format"]
[null,"Historical expenditure category"]
[null,"2010/11"]
[null,"($m, nominal)","Year 3"]
[null,null,"Field Maintenance  ",null,null,"Field Maintenance","Operational Refurbishment",null,"Network Monitoring & Control","Support / Corporate",null,"Corporate Support",null,null,null,null,null,"Key cost drivers and explanation for material differences over time"]
[null,null,"Routine","Condition-Based","Corrective",null,null,"Maintenance Support",null,"Network","Non-Network",null,null,"TOTAL",null,"Revenue Cap Allowance "]
[null,"Direct Operations & Maintenance"]
[null,"Field Maintenance"]
[null,"Communications"]
[null,"Labour",0.61963329442672943,0,0,0.61963329442672943,0.24175332710594877,null,null,null,null,null,null,{"$f":"SUM(F11:K11)","v":0.8613866215326782}]
[null,"Non Labour",0.35036670557327054,0,0,0.35036670557327054,0.21724667289405125,null,null,null,null,null,null,0.56761337846732185]
[null,"Communications",{"$f":"SUM(C11:C12)","v":0.97},0,0,0.97,{"$f":"SUM(G11:G12)","v":0.45900000000000002},0,{"$f":"SUM(I11:I12)","v":0},{"$f":"SUM(J11:J12)","v":0},{"$f":"SUM(K11:K12)","v":0},{"$f":"SUM(J13:K13)","v":0},null,{"$f":"SUM(F13:K13)","v":1.429},null,2.2445987918897075,null,"This reflects a continuation of a higher level of equipment reliability than expected in an increasing asset base, resulting in a reduced level of maintenance effort to date and allowing reallocation of resources to lines and substations"]
[null,"Lines"]
[null,"Labour",1.1855303521721492,0,1.0405942633089378,2.226124615481087,2.1367628217726367,null,null,null,null,null,null,{"$f":"SUM(F15:K15)","v":4.3628874372537236}]
[null,"Non Labour",1.3114696478278505,0,0.9454057366910622,2.2568753845189127,2.8802371782273641,null,null,null,null,null,null,5.1371125627462764]
[null,"Lines",{"$f":"SUM(C15:C16)","v":2.4969999999999999},0,1.986,4.4829999999999997,{"$f":"SUM(G15:G16)","v":5.0170000000000012},0,{"$f":"SUM(I15:I16)","v":0},{"$f":"SUM(J15:J16)","v":0},{"$f":"SUM(K15:K16)","v":0},{"$f":"SUM(J17:K17)","v":0},null,{"$f":"SUM(F17:K17)","v":9.5},null,6.0532794083360191,null,"This spend level reflects growth in refurbishment effort due to increased remedial work identified by asset testing, plus increased routine inspection effort, driven by asset condition and fire start risk mitigation"]
[null,"Secondary Systems"]
[null,"Labour",0.40627502603649474,0,0.8867748265008758,1.2930498525373706,1.9386070205944145E-2,null,null,null,null,null,null,{"$f":"SUM(F19:K19)","v":1.3124359227433147}]
[null,"Non Labour",0.22972497396350525,0,9.7225173499124157E-2,0.3269501474626294,1.1613929794055853E-2,null,null,null,null,null,null,0.33856407725668525]
[null,"Secondary Systems",{"$f":"SUM(C19:C20)","v":0.63600000000000001},0,0.98399999999999999,1.62,{"$f":"SUM(G19:G20)","v":3.1E-2},0,{"$f":"SUM(I19:I20)","v":0},{"$f":"SUM(J19:J20)","v":0},{"$f":"SUM(K19:K20)","v":0},{"$f":"SUM(J21:K21)","v":0},null,{"$f":"SUM(F21:K21)","v":1.651},null,2.6290049667069244,null,"Reflects rescheduling of secondary systems refurbishment activity as available resources were reprioritised to lines and substation maintenance activity"]
[null,"Substations"]
[null,"Labour ",3.4680300571574372,0,3.4201699298722539,6.8881999870296911,1.3770474494593739,null,null,null,null,null,null,{"$f":"SUM(F23:K23)","v":8.2652474364890658}]
[null,"Non Labour",1.9609699428425629,0,0.59783007012774592,2.558800012970309,0.95095255054062588,null,null,null,null,null,null,3.509752563510935]
[null,"Substations",{"$f":"SUM(C23:C24)","v":5.4290000000000003},0,4.0179999999999998,9.4469999999999992,{"$f":"SUM(G23:G24)","v":2.3279999999999998},0,{"$f":"SUM(I23:I24)","v":0},{"$f":"SUM(J23:J24)","v":0},{"$f":"SUM(K23:K24)","v":0},{"$f":"SUM(J25:K25)","v":0},null,{"$f":"SUM(F25:K25)","v":11.774999999999999},null,11.135182442014486,null,"Significant improvements in asset inspection and condition assessment processes have revealed the need for additional corrective effort to mitigate risk"]
[null,"Easements"]
[null,"Labour",1.1866658446148426,0,0,1.1866658446148426,0,null,null,null,null,null,null,{"$f":"SUM(F27:K27)","v":1.1866658446148426}]
[null,"Non Labour",0.36033415538515723,0,4.8000000000000001E-2,0.40833415538515722,0,null,null,null,null,null,null,0.40833415538515722]
[null,"Easements",{"$f":"SUM(C27:C28)","v":1.5469999999999997},0,4.8000000000000001E-2,1.5949999999999998,{"$f":"SUM(G27:G28)","v":0},0,{"$f":"SUM(I27:I28)","v":0},{"$f":"SUM(J27:J28)","v":0},{"$f":"SUM(K27:K28)","v":0},{"$f":"SUM(J29:K29)","v":0},null,{"$f":"SUM(F29:K29)","v":1.5949999999999998},null,1.1818146286784772,null,"The ongoing overspend in routine easement spend reflects extra vegetation cutting requirements placed on ElectraNet by the Technical Regulator"]
[null,"Summary"]
[null,"Sub-Total Labour",{"$f":"+C11+C15+C19+C23+C27","v":6.8661345744076536},0,5.3475390196820669,12.21367359408972,3.7749496685439032,0,0,0,0,null,null,{"$f":"SUM(F31:K31)","v":15.988623262633624}]
[null,"Sub-Total Non Labour",4.2128654255923461,0,1.6884609803179322,5.9013264059102788,4.0600503314560976,0,0,0,0,null,null,{"$f":"SUM(F32:K32)","v":9.9613767373663755}]
[null,"Total Maintenance",{"$f":"+C31+C32","v":11.079000000000001},{"$f":"+D31+D32","v":0},{"$f":"+E31+E32","v":7.0359999999999996},18.114999999999998,{"$f":"+G31+G32","v":7.8350000000000009},{"$f":"+H31+H32","v":0},{"$f":"+I31+I32","v":0},{"$f":"+J31+J32","v":0},{"$f":"+K31+K32","v":0},{"$f":"SUM(J33:K33)","v":0},null,{"$f":"SUM(F33:K33)","v":25.95},null,23.243880237625618]
[null,"Field Support"]
[null,"Field Support",null,null,null,null,null,7.0609999999999999,null,null,null,null,null,{"$f":"SUM(F35:K35)","v":7.0609999999999999},null,7.3334948121845631]
[null,"Direct Charges",null,null,null,null,null,2.1549999999999998,null,null,null,null,null,2.1549999999999998,null,2.1079173813269092]
[null,"Field Support",{"$f":"SUM(C35:C36)","v":0},{"$f":"SUM(D35:D36)","v":0},{"$f":"SUM(E35:E36)","v":0},{"$f":"SUM(C37:E37)","v":0},{"$f":"SUM(G35:G36)","v":0},{"$f":"SUM(H35:H36)","v":9.2159999999999993},{"$f":"SUM(I35:I36)","v":0},{"$f":"SUM(J35:J36)","v":0},{"$f":"SUM(K35:K36)","v":0},{"$f":"SUM(J37:K37)","v":0},null,{"$f":"SUM(F37:K37)","v":9.2159999999999993},null,{"$f":"SUM(P35:P36)","v":9.4414121935114714}]
[null,"Operations"]
[null,"Network Switching",null,null,null,null,null,null,1.5349999999999999,null,null,null,null,{"$f":"SUM(F39:K39)","v":1.5349999999999999},null,1.5656223766797051]
[null,"Asset Monitoring",null,null,null,null,null,null,0.61199999999999999,null,null,null,null,0.61199999999999999,null,0.74274119237060776]
[null,"Operations",{"$f":"SUM(C39:C40)","v":0},{"$f":"SUM(D39:D40)","v":0},{"$f":"SUM(E39:E40)","v":0},{"$f":"SUM(C41:E41)","v":0},{"$f":"SUM(G39:G40)","v":0},{"$f":"SUM(H39:H40)","v":0},{"$f":"SUM(I39:I40)","v":2.1469999999999998},{"$f":"SUM(J39:J40)","v":0},{"$f":"SUM(K39:K40)","v":0},{"$f":"SUM(J41:K41)","v":0},null,{"$f":"SUM(F41:K41)","v":2.1469999999999998},null,{"$f":"SUM(P39:P40)","v":2.3083635690503126}]
[null,"Total Direct Operations & Maintenance",{"$f":"+C41+C37+C33","v":11.079000000000001},{"$f":"+D41+D37+D33","v":0},{"$f":"+E41+E37+E33","v":7.0359999999999996},{"$f":"SUM(C42:E42)","v":18.115000000000002},{"$f":"+G41+G37+G33","v":7.8350000000000009},{"$f":"+H41+H37+H33","v":9.2159999999999993},{"$f":"+I41+I37+I33","v":2.1469999999999998},{"$f":"+J41+J37+J33","v":0},{"$f":"+K41+K37+K33","v":0},{"$f":"SUM(J42:K42)","v":0},null,{"$f":"SUM(F42:K42)","v":37.313000000000002},null,{"$f":"P41+P37+P33","v":34.9936560001874}]
[null,"Other Controllable"]
[null,"Asset Manager Support"]
[null,"Grid Planning",null,null,null,null,null,null,null,1.8380000000000001,0,null,null,{"$f":"SUM(F45:K45)","v":1.8380000000000001},null,1.1585923716713267]
[null,"Project Support",null,null,null,null,null,null,null,3.383,0,null,null,3.383,null,3.2728515974778531]
[null,"IT Support",null,null,null,null,null,null,null,0,1.32,null,null,1.32,null,1.9052685240858667]
[null,"Customer & Regulatory Support",null,null,null,null,null,null,null,0.57899999999999996,0,null,null,0.57899999999999996,null,0.6817519576124017]
[null,"Asset Manager Support",{"$f":"SUM(C45:C48)","v":0},{"$f":"SUM(D45:D48)","v":0},{"$f":"SUM(E45:E48)","v":0},{"$f":"SUM(C49:E49)","v":0},{"$f":"SUM(G45:G48)","v":0},{"$f":"SUM(H45:H48)","v":0},{"$f":"SUM(I45:I48)","v":0},{"$f":"SUM(J45:J48)","v":5.8},{"$f":"SUM(K45:K48)","v":1.32},{"$f":"SUM(J49:K49)","v":7.12},null,{"$f":"SUM(F49:K49)","v":7.12},null,{"$f":"SUM(P45:P48)","v":7.018464450847449}]
[null,"Insurance",null,null,null,0,0,0,0,null,2.228491,{"$f":"SUM(J50:K50)","v":2.228491},null,{"$f":"SUM(F50:K50)","v":2.228491},null,{"$f":"4.96-K60","v":3.0864909999999997},null,"ElectraNet was able to increase its level of cover and achieve insurance premiums lower than the allowance in the current economic climate"]
[null,"Corporate Support",null,null,null,0,0,0,0,null,9.2170000000000005,{"$f":"SUM(J51:K51)","v":9.2170000000000005},null,{"$f":"SUM(F51:K51)","v":9.2170000000000005},null,11.596612630124058,null,"Operational efficiencies and cost savings achieved"]
[null,"Total Other Controllable",{"$f":"+C51+C50+C49","v":0},{"$f":"+D51+D50+D49","v":0},{"$f":"+E51+E50+E49","v":0},{"$f":"SUM(C52:E52)","v":0},{"$f":"+G51+G50+G49","v":0},{"$f":"+H51+H50+H49","v":0},{"$f":"+I51+I50+I49","v":0},{"$f":"+J51+J50+J49","v":5.8},{"$f":"+K51+K50+K49","v":12.765491000000001},{"$f":"SUM(J52:K52)","v":18.565491000000002},null,{"$f":"SUM(F52:K52)","v":18.565491000000002},null,{"$f":"SUM(P49:P51)","v":21.701568080971505}]
[]
[null,"Total Maintenance Labour",{"$f":"+C31","v":6.8661345744076536},0,5.3475390196820669,null,{"$f":"+G31","v":3.7749496685439032},0,0,0,0,null,null,{"$f":"SUM(F54:K54)","v":3.7749496685439032}]
[null,"Total Maintenance Non labour",4.2128654255923461,0,1.6884609803179322,null,4.0600503314560976,0,0,0,0,null,null,{"$f":"SUM(F55:K55)","v":4.0600503314560976}]
[null,"Total Other",{"$f":"C37+C41+C49+C50+C51","v":0},0,0,0,0,9.2159999999999993,2.1469999999999998,5.8,12.765491000000001,null,null,{"$f":"SUM(F56:K56)","v":29.928491000000001}]
[null,"TOTAL CONTROLLABLE OPEX ",{"$f":"+C52+C42","v":11.079000000000001},{"$f":"+D52+D42","v":0},{"$f":"+E52+E42","v":7.0359999999999996},{"$f":"SUM(C57:E57)","v":18.115000000000002},{"$f":"+G52+G42","v":7.8350000000000009},{"$f":"+H52+H42","v":9.2159999999999993},{"$f":"+I52+I42","v":2.1469999999999998},{"$f":"+J52+J42","v":5.8},{"$f":"+K52+K42","v":12.765491000000001},{"$f":"SUM(J57:K57)","v":18.565491000000002},null,{"$f":"SUM(F57:K57)","v":55.878490999999997},null,{"$f":"P52+P42","v":56.695224081158905}]
[]
[null,"Other Opex"]
[null,"Self Insurance",null,null,null,0,0,0,0,0,1.8735090000000001,{"$f":"SUM(J60:K60)","v":1.8735090000000001},null,{"$f":"SUM(F60:K60)","v":1.8735090000000001},null,{"$f":"K60","v":1.8735090000000001}]
[null,"Network Support",null,null,null,0,0,0,0,6.6180000000000003,null,{"$f":"SUM(J61:K61)","v":6.6180000000000003},null,{"$f":"SUM(F61:K61)","v":6.6180000000000003},null,5.5231723281763427,null,"Refer Network Support Pass Through Application"]
[null,"TOTAL OTHER OPEX",{"$f":"SUM(C61:C61)","v":0},{"$f":"SUM(D61:D61)","v":0},{"$f":"SUM(E60:E61)","v":0},0,0,0,0,6.6180000000000003,1.8735090000000001,{"$f":"SUM(L60:L61)","v":8.4915090000000006},null,{"$f":"SUM(N60:N61)","v":8.4915090000000006},null,7.3966813281763431]
[]
[]
[null,"Grand Total",{"$f":"+C62+C57","v":11.079000000000001},{"$f":"+D62+D57","v":0},{"$f":"+E62+E57","v":7.0359999999999996},{"$f":"SUM(C65:E65)","v":18.115000000000002},{"$f":"+G62+G57","v":7.8350000000000009},{"$f":"+H62+H57","v":9.2159999999999993},{"$f":"+I62+I57","v":2.1469999999999998},{"$f":"+J62+J57","v":12.417999999999999},{"$f":"+K62+K57","v":14.639000000000001},{"$f":"SUM(J65:K65)","v":27.057000000000002},null,{"$f":"+N62+N57","v":64.37},null,{"$f":"P57+P62","v":64.091905409335254}]
[]
[null,"Revenue Cap Allowance",9.563956616081315,0.14987739125851376,5.8471296499800411,15.560963657319871,7.6829165803057471,9.4414121935114714,2.3083635690503126,10.636368254937924,18.457990409918004,29.094358664855928,null,{"$f":"SUM(F67:K67)","v":64.088014665043318},null,{"$f":"N67","v":64.088014665043318}]
[null,"Corrected values in red"]

{"sheet":"Hist Opex Cat Yr4 Curr","index":5,"n_rows":67,"n_cols":18,"rows_kept":67,"cut":false,"hidden":false,"merged":[[5,17,6,17],[4,2,4,15],[5,2,5,4],[5,5,6,5],[5,6,6,6],[5,8,6,8],[5,9,5,10],[5,11,6,11]]}
[]
[null,"Current Regulatory Period (2008-2013) Reporting Format"]
[null,"Historical expenditure category"]
[null,"2011/12"]
[null,"($m, nominal)","Year 4"]
[null,null,"Field Maintenance  ",null,null,"Field Maintenance","Operational Refurbishment",null,"Network Monitoring & Control","Support / Corporate",null,"Corporate Support",null,null,null,null,null,"Key cost drivers and explanation for material differences over time"]
[null,null,"Routine","Condition-Based","Corrective",null,null,"Maintenance Support",null,"Network","Non-Network",null,null,"TOTAL",null,"Revenue Cap Allowance "]
[null,"Direct Operations & Maintenance"]
[null,"Field Maintenance"]
[null,"Communications"]
[null,"Labour",0.43,null,0,{"$f":"SUM(C11:E11)","v":0.43},0.14933140622768987,null,null,null,null,null,null,{"$f":"SUM(F11:K11)","v":0.57933140622768986}]
[null,"Non Labour",{"$f":"0.726+0.236","v":0.96199999999999997},null,0,{"$f":"SUM(C12:E12)","v":0.96199999999999997},0.52400000000000002,null,null,null,null,null,null,1.486]
[null,"Communications",{"$f":"SUM(C11:C12)","v":1.3919999999999999},0,{"$f":"SUM(E11:E12)","v":0},1.3919999999999999,0.67333140622768983,0,{"$f":"SUM(I11:I12)","v":0},{"$f":"SUM(J11:J12)","v":0},{"$f":"SUM(K11:K12)","v":0},{"$f":"SUM(J13:K13)","v":0},null,{"$f":"SUM(F13:K13)","v":2.0653314062276897},null,2.44]
[null,"Lines"]
[null,"Labour",0.71,null,1.26,{"$f":"SUM(C15:E15)","v":1.97},0.86,null,null,null,null,null,null,{"$f":"SUM(F15:K15)","v":2.83}]
[null,"Non Labour",2.61,null,4.46,7.07,3.86,null,null,null,null,null,null,10.93]
[null,"Lines",{"$f":"SUM(C15:C16)","v":3.32},0,{"$f":"SUM(E15:E16)","v":5.72},9.0400000000000009,4.72,0,{"$f":"SUM(I15:I16)","v":0},{"$f":"SUM(J15:J16)","v":0},{"$f":"SUM(K15:K16)","v":0},{"$f":"SUM(J17:K17)","v":0},null,{"$f":"SUM(F17:K17)","v":13.760000000000002},null,5.87]
[null,"Secondary Systems"]
[null,"Labour",0.44,null,0.53377576606642241,{"$f":"SUM(C19:E19)","v":0.97377576606642235},0.23,null,null,null,null,null,null,{"$f":"SUM(F19:K19)","v":1.2037757660664223}]
[null,"Non Labour",0.26700000000000002,null,0.43,0.69700000000000006,0.12,null,null,null,null,null,null,0.81700000000000006]
[null,"Secondary Systems",{"$f":"SUM(C19:C20)","v":0.70700000000000007},0,{"$f":"SUM(E19:E20)","v":0.96377576606642235},1.6707757660664224,0.35,0,{"$f":"SUM(I19:I20)","v":0},{"$f":"SUM(J19:J20)","v":0},{"$f":"SUM(K19:K20)","v":0},{"$f":"SUM(J21:K21)","v":0},null,{"$f":"SUM(F21:K21)","v":2.0207757660664223},null,3.06]
[null,"Substations"]
[null,"Labour ",2.76,null,2.0962719842500621,{"$f":"SUM(C23:E23)","v":4.8562719842500623},0.85387459887278427,null,null,null,null,null,null,{"$f":"SUM(F23:K23)","v":5.7101465831228468}]
[null,"Non Labour",3.63,null,2.11,5.74,0.47,null,null,null,null,null,null,6.21]
[null,"Substations",{"$f":"SUM(C23:C24)","v":6.39},0,{"$f":"SUM(E23:E24)","v":4.206271984250062},10.596271984250063,1.3238745988727842,0,{"$f":"SUM(I23:I24)","v":0},{"$f":"SUM(J23:J24)","v":0},{"$f":"SUM(K23:K24)","v":0},{"$f":"SUM(J25:K25)","v":0},null,{"$f":"SUM(F25:K25)","v":11.920146583122847},null,11.89]
[null,"Easements"]
[null,"Labour",0.81,null,0,{"$f":"SUM(C27:E27)","v":0.81},0,null,null,null,null,null,null,{"$f":"SUM(F27:K27)","v":0.81}]
[null,"Non Labour",0.73,null,0,0.73,0,null,null,null,null,null,null,0.73]
[null,"Easements",{"$f":"SUM(C27:C28)","v":1.54},0,{"$f":"SUM(E27:E28)","v":0},1.54,{"$f":"SUM(G27:G28)","v":0},0,{"$f":"SUM(I27:I28)","v":0},{"$f":"SUM(J27:J28)","v":0},{"$f":"SUM(K27:K28)","v":0},{"$f":"SUM(J29:K29)","v":0},null,{"$f":"SUM(F29:K29)","v":1.54},null,1.21]
[null,"Summary"]
[null,"Sub-Total Labour",{"$f":"+C11+C15+C19+C23+C27","v":5.15},0,3.8900477503164845,9.040047750316484,2.0932060051004742,0,0,0,0,null,null,{"$f":"SUM(F31:K31)","v":11.133253755416959}]
[null,"Sub-Total Non Labour",8.1989999999999998,0,7,15.199,4.9740000000000002,0,0,0,0,null,null,{"$f":"SUM(F32:K32)","v":20.173000000000002}]
[null,"Total Maintenance",{"$f":"+C31+C32","v":13.349},{"$f":"+D31+D32","v":0},{"$f":"+E31+E32","v":10.890047750316484},24.239047750316484,{"$f":"+G31+G32","v":7.0672060051004744},{"$f":"+H31+H32","v":0},{"$f":"+I31+I32","v":0},{"$f":"+J31+J32","v":0},{"$f":"+K31+K32","v":0},{"$f":"SUM(J33:K33)","v":0},null,{"$f":"SUM(F33:K33)","v":31.306253755416957},null,{"$f":"SUM(P13:P29)","v":24.470000000000002}]
[null,"Field Support"]
[null,"Field Support",null,null,null,null,null,7.282,null,null,null,null,null,{"$f":"SUM(F35:K35)","v":7.282},null,7.71]
[null,"Direct Charges",null,null,null,null,null,1.9139999999999999,null,null,null,null,null,1.9139999999999999,null,2.3199999999999998]
[null,"Field Support",{"$f":"SUM(C35:C36)","v":0},{"$f":"SUM(D35:D36)","v":0},{"$f":"SUM(E35:E36)","v":0},{"$f":"SUM(C37:E37)","v":0},{"$f":"SUM(G35:G36)","v":0},{"$f":"SUM(H35:H36)","v":9.1959999999999997},{"$f":"SUM(I35:I36)","v":0},{"$f":"SUM(J35:J36)","v":0},{"$f":"SUM(K35:K36)","v":0},{"$f":"SUM(J37:K37)","v":0},null,{"$f":"SUM(F37:K37)","v":9.1959999999999997},null,{"$f":"SUM(P35:P36)","v":10.029999999999999}]
[null,"Operations"]
[null,"Network Switching",null,null,null,null,null,null,1.732,null,null,null,null,{"$f":"SUM(F39:K39)","v":1.732},null,1.65]
[null,"Asset Monitoring",null,null,null,null,null,null,0.82699999999999996,null,null,null,null,0.82699999999999996,null,0.78]
[null,"Operations",{"$f":"SUM(C39:C40)","v":0},{"$f":"SUM(D39:D40)","v":0},{"$f":"SUM(E39:E40)","v":0},{"$f":"SUM(C41:E41)","v":0},{"$f":"SUM(G39:G40)","v":0},{"$f":"SUM(H39:H40)","v":0},{"$f":"SUM(I39:I40)","v":2.5590000000000002},{"$f":"SUM(J39:J40)","v":0},{"$f":"SUM(K39:K40)","v":0},{"$f":"SUM(J41:K41)","v":0},null,{"$f":"SUM(F41:K41)","v":2.5590000000000002},null,{"$f":"SUM(P39:P40)","v":2.4299999999999997}]
[null,"Total Direct Operations & Maintenance",{"$f":"+C41+C37+C33","v":13.349},{"$f":"+D41+D37+D33","v":0},{"$f":"+E41+E37+E33","v":10.890047750316484},{"$f":"SUM(C42:E42)","v":24.239047750316484},{"$f":"+G41+G37+G33","v":7.0672060051004744},{"$f":"+H41+H37+H33","v":9.1959999999999997},{"$f":"+I41+I37+I33","v":2.5590000000000002},{"$f":"+J41+J37+J33","v":0},{"$f":"+K41+K37+K33","v":0},{"$f":"SUM(J42:K42)","v":0},null,{"$f":"SUM(F42:K42)","v":43.061253755416956},null,{"$f":"P41+P37+P33","v":36.93}]
[null,"Other Controllable"]
[null,"Asset Manager Support"]
[null,"Grid Planning",null,null,null,null,null,null,null,1.258,0,null,null,{"$f":"SUM(F45:K45)","v":1.258},null,1.2]
[null,"Project Support",null,null,null,null,null,null,null,3.2250000000000001,0,null,null,3.2250000000000001,null,3.41]
[null,"IT Support",null,null,null,null,null,null,null,0,1.921,null,null,1.921,null,1.96]
[null,"Customer & Regulatory Support",null,null,null,null,null,null,null,0.75900000000000001,0,null,null,0.75900000000000001,null,0.71]
[null,"Asset Manager Support",{"$f":"SUM(C45:C48)","v":0},{"$f":"SUM(D45:D48)","v":0},{"$f":"SUM(E45:E48)","v":0},{"$f":"SUM(C49:E49)","v":0},{"$f":"SUM(G45:G48)","v":0},{"$f":"SUM(H45:H48)","v":0},{"$f":"SUM(I45:I48)","v":0},{"$f":"SUM(J45:J48)","v":5.2420000000000009},{"$f":"SUM(K45:K48)","v":1.921},{"$f":"SUM(J49:K49)","v":7.1630000000000011},null,{"$f":"SUM(F49:K49)","v":7.1630000000000011},null,{"$f":"SUM(P45:P48)","v":7.28}]
[null,"Insurance",null,null,null,0,0,0,0,null,{"$f":"4.404-1.923","v":2.4809999999999999},4.4039999999999999,null,{"$f":"SUM(F50:K50)","v":2.4809999999999999},null,{"$f":"5.36-K60","v":3.4370000000000003}]
[null,"Corporate Support",null,null,null,0,0,0,0,null,11.476000000000001,11.476000000000001,null,{"$f":"SUM(F51:K51)","v":11.476000000000001},null,12.59]
[null,"Total Other Controllable",{"$f":"+C51+C50+C49","v":0},{"$f":"+D51+D50+D49","v":0},{"$f":"+E51+E50+E49","v":0},{"$f":"SUM(C52:E52)","v":0},{"$f":"+G51+G50+G49","v":0},{"$f":"+H51+H50+H49","v":0},{"$f":"+I51+I50+I49","v":0},{"$f":"+J51+J50+J49","v":5.2420000000000009},{"$f":"+K51+K50+K49","v":15.878},{"$f":"SUM(J52:K52)","v":21.12},null,{"$f":"SUM(F52:K52)","v":21.12},null,{"$f":"SUM(P49:P51)","v":23.307000000000002}]
[]
[null,"Total Maintenance Labour",{"$f":"+C31","v":5.15},0,3.8900477503164845,null,{"$f":"+G31","v":2.0932060051004742},0,0,0,0,null,null,{"$f":"SUM(F54:K54)","v":2.0932060051004742}]
[null,"Total Maintenance Non labour",8.1989999999999998,0,7,null,4.9740000000000002,0,0,0,0,null,null,{"$f":"SUM(F55:K55)","v":4.9740000000000002}]
[null,"Total Other",{"$f":"C37+C41+C49+C50+C51","v":0},0,0,0,0,9.1959999999999997,2.5590000000000002,5.2420000000000009,15.878,null,null,{"$f":"SUM(F56:K56)","v":32.875}]
[null,"TOTAL CONTROLLABLE OPEX ",{"$f":"+C52+C42","v":13.349},{"$f":"+D52+D42","v":0},{"$f":"+E52+E42","v":10.890047750316484},{"$f":"SUM(C57:E57)","v":24.239047750316484},{"$f":"+G52+G42","v":7.0672060051004744},{"$f":"+H52+H42","v":9.1959999999999997},{"$f":"+I52+I42","v":2.5590000000000002},{"$f":"+J52+J42","v":5.2420000000000009},{"$f":"+K52+K42","v":15.878},{"$f":"SUM(J57:K57)","v":21.12},null,{"$f":"SUM(F57:K57)","v":64.181253755416961},null,{"$f":"P52+P42","v":60.237000000000002}]
[]
[null,"Other Opex"]
[null,"Self Insurance",null,null,null,0,0,0,0,null,1.923,{"$f":"SUM(J60:K60)","v":1.923},null,{"$f":"SUM(F60:K60)","v":1.923},null,{"$f":"K60","v":1.923}]
[null,"Network Support",null,null,null,0,0,0,0,6.48,null,{"$f":"SUM(J61:K61)","v":6.48},null,{"$f":"SUM(F61:K61)","v":6.48},null,5.97]
[null,"TOTAL OTHER OPEX",{"$f":"SUM(C61:C61)","v":0},{"$f":"SUM(D61:D61)","v":0},{"$f":"SUM(E60:E61)","v":0},0,0,0,0,6.48,1.923,{"$f":"SUM(L60:L61)","v":8.4030000000000005},null,{"$f":"SUM(N60:N61)","v":8.4030000000000005},null,7.8929999999999998]
[]
[]
[null,"Grand Total",{"$f":"+C62+C57","v":13.349},{"$f":"+D62+D57","v":0},{"$f":"+E62+E57","v":10.890047750316484},{"$f":"SUM(C65:E65)","v":24.239047750316484},{"$f":"+G62+G57","v":7.0672060051004744},{"$f":"+H62+H57","v":9.1959999999999997},{"$f":"+I62+I57","v":2.5590000000000002},{"$f":"+J62+J57","v":11.722000000000001},{"$f":"+K62+K57","v":17.801000000000002},{"$f":"SUM(J65:K65)","v":29.523000000000003},null,{"$f":"+N62+N57","v":72.584253755416967},null,{"$f":"P57+P62","v":68.13}]
[]
[null,"Revenue Cap Allowance",9.563956616081315,0.14987739125851376,5.8471296499800411,15.560963657319871,8.9124293426801309,10.031729,2.432277,11.28302,19.913523999999999,31.196543999999999,null,{"$f":"SUM(F67:K67)","v":68.133943000000002}]

{"sheet":"Hist Opex Cat Yr5 Curr","index":6,"n_rows":67,"n_cols":18,"rows_kept":67,"cut":false,"hidden":false,"merged":[[5,17,6,17],[4,2,4,15],[5,2,5,4],[5,5,6,5],[5,6,6,6],[5,8,6,8],[5,9,5,10],[5,11,6,11]]}
[]
[null,"Current Regulatory Period (2008-2013) Reporting Format"]
[null,"Historical expenditure category"]
[null,"2012/13"]
[null,"($m, nominal)","Year 5"]
[null,null,"Field Maintenance  ",null,null,"Field Maintenance","Operational Refurbishment",null,"Network Monitoring & Control","Support / Corporate",null,"Corporate Support",null,null,null,null,null,"Key cost drivers and explanation for material differences over time"]
[null,null,"Routine","Condition-Based","Corrective",null,null,"Maintenance Support",null,"Network","Non-Network",null,null,"TOTAL",null,"Revenue Cap Allowance "]
[null,"Direct Operations & Maintenance"]
[null,"Field Maintenance"]
[null,"Communications"]
[null,"Labour",0.37741248089552532,null,7.1875441703001253E-2,0.44928792259852657,0.16516107087214563,null,null,null,null,null,null,{"$f":"SUM(F11:K11)","v":0.61444899347067217}]
[null,"Non Labour",0.18228511910447487,null,4.4299082969987413E-3,0.18671502740147361,0.43483892912785438,null,null,null,null,null,null,0.62155395652932799]
[null,"Communications",{"$f":"SUM(C11:C12)","v":0.55969760000000024},0,7.6305349999999994E-2,0.63600295000000018,0.6,0,{"$f":"SUM(I11:I12)","v":0},{"$f":"SUM(J11:J12)","v":0},{"$f":"SUM(K11:K12)","v":0},{"$f":"SUM(J13:K13)","v":0},null,{"$f":"SUM(F13:K13)","v":1.23600295},null,2.72]
[null,"Lines"]
[null,"Labour",0.72912176861098543,null,0.69530176191438009,1.4244235305253654,0.43426847785818007,null,null,null,null,null,null,{"$f":"SUM(F15:K15)","v":1.8586920083835454}]
[null,"Non Labour",2.7003330513890145,null,2.5750792380856198,5.2754122894746338,1.6083315221418202,null,null,null,null,null,null,6.883743811616454]
[null,"Lines",{"$f":"SUM(C15:C16)","v":3.4294548200000001},0,3.270381,6.6998358199999988,2.0426000000000002,0,{"$f":"SUM(I15:I16)","v":0},{"$f":"SUM(J15:J16)","v":0},{"$f":"SUM(K15:K16)","v":0},{"$f":"SUM(J17:K17)","v":0},null,{"$f":"SUM(F17:K17)","v":8.742435819999999},null,5.8]
[null,"Secondary Systems"]
[null,"Labour",0.42768599195642254,null,0.4745960260234996,0.90228201797992214,7.2922808679302425E-2,null,null,null,null,null,null,{"$f":"SUM(F19:K19)","v":0.97520482665922459}]
[null,"Non Labour",0.37493497804357745,null,0.41605910397650037,0.79099408202007782,6.3928471320697566E-2,null,null,null,null,null,null,0.85492255334077538]
[null,"Secondary Systems",{"$f":"SUM(C19:C20)","v":0.80262096999999999},0,0.89065512999999996,1.6932760999999998,0.13685127999999999,0,{"$f":"SUM(I19:I20)","v":0},{"$f":"SUM(J19:J20)","v":0},{"$f":"SUM(K19:K20)","v":0},{"$f":"SUM(J21:K21)","v":0},null,{"$f":"SUM(F21:K21)","v":1.8301273799999997},null,3.81]
[null,"Substations"]
[null,"Labour ",3.053899711684732,null,2.2827263869916017,5.3366260986763336,1.5292525885455084,null,null,null,null,null,null,{"$f":"SUM(F23:K23)","v":6.8658786872218425}]
[null,"Non Labour",3.3065084083152678,null,2.4715461230083982,5.778054531323666,1.6557474114544917,null,null,null,null,null,null,7.4338019427781576]
[null,"Substations",{"$f":"SUM(C23:C24)","v":6.3604081199999998},0,4.7542725099999998,11.114680629999999,3.1850000000000001,0,{"$f":"SUM(I23:I24)","v":0},{"$f":"SUM(J23:J24)","v":0},{"$f":"SUM(K23:K24)","v":0},{"$f":"SUM(J25:K25)","v":0},null,{"$f":"SUM(F25:K25)","v":14.299680629999999},null,11.8]
[null,"Easements"]
[null,"Labour",0.7854324990056174,null,0,0.7854324990056174,0,null,null,null,null,null,null,{"$f":"SUM(F27:K27)","v":0.7854324990056174}]
[null,"Non Labour",0.69033822099438247,null,0,0.69033822099438247,0,null,null,null,null,null,null,0.69033822099438247]
[null,"Easements",{"$f":"SUM(C27:C28)","v":1.4757707199999999},0,0,1.4757707199999999,0,0,{"$f":"SUM(I27:I28)","v":0},{"$f":"SUM(J27:J28)","v":0},{"$f":"SUM(K27:K28)","v":0},{"$f":"SUM(J29:K29)","v":0},null,{"$f":"SUM(F29:K29)","v":1.4757707199999999},null,1.26]
[null,"Summary"]
[null,"Sub-Total Labour",{"$f":"+C11+C15+C19+C23+C27","v":5.373552452153282},0,3.5244996166324825,8.8980520687857645,2.2016049459551366,0,0,0,0,null,null,{"$f":"SUM(F31:K31)","v":11.099657014740901}]
[null,"Sub-Total Non Labour",7.2543997778467171,0,5.4671143733675169,12.721514151214235,3.7628463340448635,0,0,0,0,null,null,{"$f":"SUM(F32:K32)","v":16.484360485259099}]
[null,"Total Maintenance",{"$f":"+C31+C32","v":12.627952229999998},{"$f":"+D31+D32","v":0},{"$f":"+E31+E32","v":8.9916139899999994},21.619566219999999,{"$f":"+G31+G32","v":5.9644512800000005},{"$f":"+H31+H32","v":0},{"$f":"+I31+I32","v":0},{"$f":"+J31+J32","v":0},{"$f":"+K31+K32","v":0},{"$f":"SUM(J33:K33)","v":0},null,{"$f":"SUM(F33:K33)","v":27.584017500000002},null,{"$f":"SUM(P13:P29)","v":25.390000000000004}]
[null,"Field Support"]
[null,"Field Support",null,null,null,null,null,{"$f":"8.8055161*0+7.06","v":7.06},null,null,null,null,null,{"$f":"SUM(F35:K35)","v":7.06},null,8.2899999999999991]
[null,"Direct Charges",null,null,null,null,null,2.8572122599999998,null,null,null,null,null,2.8572122599999998,null,2.54]
[null,"Field Support",{"$f":"SUM(C35:C36)","v":0},{"$f":"SUM(D35:D36)","v":0},{"$f":"SUM(E35:E36)","v":0},{"$f":"SUM(C37:E37)","v":0},{"$f":"SUM(G35:G36)","v":0},{"$f":"H36+H35","v":9.9172122599999994},0,0,0,{"$f":"SUM(J37:K37)","v":0},null,{"$f":"SUM(F37:K37)","v":9.9172122599999994},null,{"$f":"SUM(P35:P36)","v":10.829999999999998}]
[null,"Operations"]
[null,"Network Switching",null,null,null,null,null,null,1.68,null,null,null,null,{"$f":"SUM(F39:K39)","v":1.68},null,1.78]
[null,"Asset Monitoring",null,null,null,null,null,null,1.47,null,null,null,null,1.47,null,0.84]
[null,"Operations",{"$f":"SUM(C39:C40)","v":0},{"$f":"SUM(D39:D40)","v":0},{"$f":"SUM(E39:E40)","v":0},{"$f":"SUM(C41:E41)","v":0},{"$f":"SUM(G39:G40)","v":0},0,{"$f":"I40+I39","v":3.15},0,0,{"$f":"SUM(J41:K41)","v":0},null,{"$f":"SUM(F41:K41)","v":3.15},null,{"$f":"SUM(P39:P40)","v":2.62}]
[null,"Total Direct Operations & Maintenance",{"$f":"+C41+C37+C33","v":12.627952229999998},{"$f":"+D41+D37+D33","v":0},{"$f":"+E41+E37+E33","v":8.9916139899999994},{"$f":"SUM(C42:E42)","v":21.619566219999996},{"$f":"+G41+G37+G33","v":5.9644512800000005},{"$f":"+H41+H37+H33","v":9.9172122599999994},3.15,0,0,0,null,{"$f":"SUM(F42:K42)","v":40.651229759999993},null,{"$f":"P41+P37+P33","v":38.840000000000003}]
[null,"Other Controllable"]
[null,"Asset Manager Support"]
[null,"Grid Planning",null,null,null,null,null,null,null,{"$f":"1.25+0.54","v":1.79},null,null,null,{"$f":"SUM(F45:K45)","v":1.79},null,1.27]
[null,"Project Support",null,null,null,null,null,null,null,2.77,null,null,null,2.77,null,3.6]
[null,"IT Support",null,null,null,null,null,null,null,null,1.78,null,null,1.78,null,2.0499999999999998]
[null,"Customer & Regulatory Support",null,null,null,null,null,null,null,2.11,null,null,null,2.11,null,0.74]
[null,"Asset Manager Support",{"$f":"SUM(C45:C48)","v":0},{"$f":"SUM(D45:D48)","v":0},{"$f":"SUM(E45:E48)","v":0},{"$f":"SUM(C49:E49)","v":0},{"$f":"SUM(G45:G48)","v":0},0,0,{"$f":"SUM(J45:J48)","v":6.67},1.77912252,{"$f":"SUM(J49:K49)","v":8.4491225199999995},null,{"$f":"SUM(F49:K49)","v":8.4491225199999995},null,{"$f":"SUM(P45:P48)","v":7.66}]
[null,"Insurance",null,null,null,0,0,0,0,null,2.81,{"$f":"SUM(J50:K50)","v":2.81},null,{"$f":"SUM(F50:K50)","v":2.81},null,{"$f":"5.91-K60","v":3.8773440000000003}]
[null,"Corporate Support",null,null,null,0,0,0,0,null,13.38,{"$f":"SUM(J51:K51)","v":13.38},null,{"$f":"SUM(F51:K51)","v":13.38},null,13.17]
[null,"Total Other Controllable",{"$f":"+C51+C50+C49","v":0},{"$f":"+D51+D50+D49","v":0},{"$f":"+E51+E50+E49","v":0},{"$f":"SUM(C52:E52)","v":0},{"$f":"+G51+G50+G49","v":0},{"$f":"+H51+H50+H49","v":0},{"$f":"+I51+I50+I49","v":0},{"$f":"+J51+J50+J49","v":6.67},{"$f":"+K51+K50+K49","v":17.969122520000003},{"$f":"SUM(J52:K52)","v":24.639122520000001},null,{"$f":"SUM(F52:K52)","v":24.639122520000001},null,{"$f":"SUM(P49:P51)","v":24.707343999999999}]
[]
[null,"Total Maintenance Labour",{"$f":"+C31","v":5.373552452153282},0,3.5244996166324825,8.8980520687857645,2.2016049459551366,0,0,0,0,null,null,{"$f":"SUM(F54:K54)","v":11.099657014740901}]
[null,"Total Maintenance Non labour",7.2543997778467171,0,5.4671143733675169,12.721514151214235,3.7628463340448635,0,0,0,0,null,null,{"$f":"SUM(F55:K55)","v":16.484360485259099}]
[null,"Total Other",{"$f":"C37+C41+C49+C50+C51","v":0},0,0,0,0,9.9172122599999994,3.15,6.67,17.969122519999999,null,null,{"$f":"SUM(F56:K56)","v":37.706334779999999}]
[null,"TOTAL CONTROLLABLE OPEX ",{"$f":"+C52+C42","v":12.627952229999998},{"$f":"+D52+D42","v":0},{"$f":"+E52+E42","v":8.9916139899999994},{"$f":"SUM(C57:E57)","v":21.619566219999996},{"$f":"+G52+G42","v":5.9644512800000005},{"$f":"+H52+H42","v":9.9172122599999994},{"$f":"+I52+I42","v":3.15},{"$f":"+J52+J42","v":6.67},{"$f":"+K52+K42","v":17.969122520000003},{"$f":"SUM(J57:K57)","v":24.639122520000001},null,{"$f":"SUM(F57:K57)","v":65.290352279999993},null,{"$f":"P52+P42","v":63.547344000000002}]
[]
[null,"Other Opex"]
[null,"Self Insurance",null,null,null,null,null,null,null,null,2.0326559999999998,{"$f":"SUM(J60:K60)","v":2.0326559999999998},null,{"$f":"SUM(F60:K60)","v":2.0326559999999998},null,{"$f":"K60","v":2.0326559999999998}]
[null,"Network Support",null,null,null,null,null,null,null,6.74,null,{"$f":"SUM(J61:K61)","v":6.74},null,{"$f":"SUM(F61:K61)","v":6.74},null,7.23]
[null,"TOTAL OTHER OPEX",{"$f":"SUM(C61:C61)","v":0},{"$f":"SUM(D61:D61)","v":0},{"$f":"SUM(E60:E61)","v":0},0,0,0,0,6.74,2.0326559999999998,{"$f":"SUM(L60:L61)","v":8.7726559999999996},null,{"$f":"SUM(N60:N61)","v":8.7726559999999996},null,9.2626559999999998]
[]
[]
[null,"Grand Total",{"$f":"+C62+C57","v":12.627952229999998},{"$f":"+D62+D57","v":0},{"$f":"+E62+E57","v":8.9916139899999994},{"$f":"SUM(C65:E65)","v":21.619566219999996},{"$f":"+G62+G57","v":5.9644512800000005},{"$f":"+H62+H57","v":9.9172122599999994},{"$f":"+I62+I57","v":3.15},{"$f":"+J62+J57","v":13.41},{"$f":"+K62+K57","v":20.001778520000002},{"$f":"SUM(J65:K65)","v":33.411778519999999},null,{"$f":"+N62+N57","v":74.063008279999991},null,{"$f":"P57+P62","v":72.81}]
[]
[null,"Revenue Cap Allowance",11.27,0.19,7.32,18.78,6.61,10.829999999999998,2.62,12.84,21.130000000000003,33.97,null,{"$f":"SUM(F67:K67)","v":72.81}]