{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Guide","Revenue","Opex","Capex","Cashflow","RAB Summary","2011 to 2015 Distribution RAB","System Data","Inflation","PR2 Allow Outturn Revised Capex","PR2 Adjustments","Error check"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":5,"defined_names":126,"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":"Guide","index":0,"n_rows":17,"n_cols":18,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Cells Colour Code",null,null,null,null,null,null,null,null,null,null,null,null,null,"Asset Base range"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2006]
[null,"Data input cells have a green background with blue text for positive numbers and red for negative numbers",null,10.5,-20.6,null,null,null,null,null,null,null,null,null,null,2007]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2008,null,"Yes/No toggle"]
[null,"Cells containing formula or referring to other cells have a white background and black text when positive and red text when negative",null,{"$f":"D4","v":10.5},{"$f":"E4+D4","v":-10.100000000000001},null,null,null,null,null,null,null,null,null,null,2009,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2010,null,1]
[null,"Cells that are used to determine scenarios have an orange background and black text",null,2016,null,null,null,null,null,null,null,null,null,null,null,2011]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2012]
[null,"Cells that are used to profile revenue have a yellow background and blue text",null,2.9,null,null,null,null,null,null,null,null,null,null,null,2014]
[]
[null,"Cells that contain asset categories have an olive green background and black text",null,"Scada Tel (15 years)",null,null,null,null,null,null,null,null,null,null,null,2015]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2016]
[]
[null,"Macros"]
[]
[null,"This model uses macros to calculate depreciation, opening asset value and to profile revenue.  These macros were developed using MS Excel 2007 SP1 and MS Visual Basic 6.5.  To ensure that the macros work correctly please ensure that your system is compatible."]

{"sheet":"Revenue","index":1,"n_rows":38,"n_cols":10,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["PR3 Distribution Revenue"]
[null,null,2010,2011,2012,2013,2014,2015,null,"Total"]
["Opex",null,null,{"$f":"Opex!E61*1000000","v":220897417.38703573},{"$f":"Opex!F61*1000000","v":217206909.66061276},{"$f":"Opex!G61*1000000","v":213599113.65832239},{"$f":"Opex!H61*1000000","v":210072116.64818105},{"$f":"Opex!I61*1000000","v":210162557.6680561},null,{"$f":"SUM(Opex_2011_to_2015)","v":1071938115.0222081}]
["Capex",null,null,{"$f":"'RAB Summary'!C6","v":354368201.59283286},{"$f":"'RAB Summary'!D6","v":358601971.25010806},{"$f":"'RAB Summary'!E6","v":475541069.50310147},{"$f":"'RAB Summary'!F6","v":513725086.76179206},{"$f":"'RAB Summary'!G6","v":610700097.5107646},null,{"$f":"SUM(Capex_2011_to_2015)","v":2312936426.6185989}]
["PR2 Adjustments /Clawbacks",null,null,{"$f":"'PR2 Adjustments'!C7","v":68448220.045041814},{"$f":"'PR2 Adjustments'!D7","v":52500000},{"$f":"'PR2 Adjustments'!E7","v":0},{"$f":"'PR2 Adjustments'!F7","v":0},{"$f":"'PR2 Adjustments'!G7","v":0},null,{"$f":"SUM(D5:H5)","v":120948220.04504181}]
["Incentives",null,null,{"$f":"IF(incent=1,incentamount,0)","v":8000000},{"$f":"IF(incent=1,incentamount,0)","v":8000000},{"$f":"IF(incent=1,incentamount,0)","v":8000000},{"$f":"IF(incent=1,incentamount,0)","v":8000000},{"$f":"IF(incent=1,incentamount,0)","v":8000000},null,{"$f":"SUM(D6:H6)","v":40000000}]
[]
["NPV of Costs",{"$f":"(NPV(RoR,D3:H3)+NPV(RoR,D4:H4)+NPV(RoR,D6:H6))*((1+RoR)^0.5)+D5+NPV(RoR,E5:H5)","v":3129746059.4663272}]
["OAV",null,null,{"$f":"OAV_2011","v":4974523268.1112766},{"$f":"D12","v":5156970169.9159622},{"$f":"E12","v":5337996176.3034029},5620869415.1461983,5921821412.229558]
["Capex",null,null,{"$f":"'RAB Summary'!C6","v":354368201.59283286},{"$f":"'RAB Summary'!D6","v":358601971.25010806},{"$f":"'RAB Summary'!E6","v":475541069.50310147},{"$f":"'RAB Summary'!F6","v":513725086.76179206},{"$f":"'RAB Summary'!G6","v":610700097.5107646}]
["Depreciation",null,null,{"$f":"Dep_2011","v":-171921299.78814697},{"$f":"Dep_2012","v":-177575964.86266708},{"$f":"Dep_2013","v":-192667830.66030598},{"$f":"Dep_2014","v":-212773089.67843246},{"$f":"Dep_2015","v":-239055773.97755527}]
["CAV",null,null,{"$f":"SUM(D9:D11)","v":5156970169.9159622},{"$f":"SUM(E9:E11)","v":5337996176.3034029},5620869415.1461983,5921821412.229558,6293465735.7627668]
["NPV of Return",{"$f":"D9-(H12/((1+RoR)^5))","v":43428186.368476868}]
["NPV of Costs + Return",{"$f":"INT(B8+B13)","v":3173174245}]
[]
["Opex",null,null,{"$f":"D3","v":220897417.38703573},{"$f":"E3","v":217206909.66061276},213599113.65832239,210072116.64818105,210162557.6680561,null,{"$f":"SUM(D16:H16)","v":1071938115.0222081}]
[{"$f":"A5","v":"PR2 Adjustments /Clawbacks"},null,null,{"$f":"'PR2 Adjustments'!C7","v":68448220.045041814},{"$f":"'PR2 Adjustments'!D7","v":52500000},{"$f":"'PR2 Adjustments'!E7","v":0},{"$f":"'PR2 Adjustments'!F7","v":0},{"$f":"'PR2 Adjustments'!G7","v":0},null,{"$f":"SUM(D17:H17)","v":120948220.04504181}]
["Depreciation",null,null,{"$f":"-D11","v":171921299.78814697},{"$f":"-E11","v":177575964.86266708},192667830.66030598,212773089.67843246,239055773.97755527,null,{"$f":"SUM(Total_Depreciation)","v":993993958.96710777}]
["Return on Capital + Incentives",null,null,{"$f":"D20-D16-D18-D17","v":221323873.39257371},{"$f":"E20-E16-E18-E17","v":250791300.16899425},308215778.56888622,311602198.89404941,306355539.84604871,null,{"$f":"SUM(Total_Return)","v":1398288690.8705525}]
["Annual Revenue",null,null,{"$f":"D24*D27*10000","v":682590810.61279821},{"$f":"E24*E27*10000","v":698074174.69227409},714482722.88751459,734447405.22066295,755573871.49166012,null,{"$f":"SUM(Total_Revenue)","v":3585168984.9049101}]
[]
["NPV of Revenue",{"$f":"INT(NPV(RoR,D20:H20)*((1+RoR)^0.5))","v":3173174245}]
[]
["Annual Consumption (GWhr)",null,23080.674179438887,{"$f":"IF(Growth1=1,C24*(1+Growth),'System Data'!B3)","v":23549.038166108097},{"$f":"IF(Growth1=1,D24*(1+Growth),'System Data'!C3)","v":24083.206405671688},{"$f":"IF(Growth1=1,E24*(1+Growth),'System Data'!D3)","v":24649.293029886925},{"$f":"IF(Growth1=1,F24*(1+Growth),'System Data'!E3)","v":25338.064485534647},{"$f":"IF(Growth1=1,G24*(1+Growth),'System Data'!F3)","v":26066.916900181233}]
["Annual Consumption Growth (%)",null,null,{"$f":"D24/C24-1","v":2.0292474259111737E-2},{"$f":"E24/D24-1","v":2.2683229599260946E-2},{"$f":"F24/E24-1","v":2.350545083905109E-2},2.79428482923465E-2,2.8765117993234446E-2]
[]
["AUP (c/kWh)",null,3.1,2.8985931646040077,{"$f":"D27*(1+$D32)","v":2.8985931646040077},{"$f":"E27*(1+$D32)","v":2.8985931646040077},{"$f":"F27*(1+$D32)","v":2.8985931646040077},{"$f":"G27*(1+$D32)","v":2.8985931646040077}]
["AUP increase(decrease) (%)",null,null,{"$f":"AUP_2011/AUP_2010-1","v":-6.4969946901933029E-2},{"$f":"E27/AUP_2011-1","v":0},{"$f":"F27/E27-1","v":0},{"$f":"G27/F27-1","v":0},0]
[]
[]
[]
[null,"Profile-Factor",null,0,null,0,"Linear (1) or ESBN forecast (0)"]
[null,"Po",null,-6.4969946901933029E-2,null,1.6E-2,"Consumption (Growth %)"]
[]
[null,"RoR",null,0.05,null,1,"Include Smart Metering (1 Yes, 0 No)"]
[]
[null,null,null,null,null,1,"Include Incentives Up front ( 1 Yes, 0 No)"]
[null,null,null,null,null,8000000,"Annual Incentive Amount"]

{"sheet":"Opex","index":2,"n_rows":63,"n_cols":11,"rows_kept":63,"cut":false,"hidden":false,"merged":[]}
[null,"OPEX"]
[null,"Real Values"]
[null,null,null,null,2011,2012,2013,2014,2015,null,"Total"]
[]
[null,"Capital Driven Opex","[€m]",null,{"$f":"SUM(E6:E6)","v":0},{"$f":"SUM(F6:F6)","v":0},{"$f":"SUM(G6:G6)","v":0},{"$f":"SUM(H6:H6)","v":0},{"$f":"SUM(I6:I6)","v":0},null,{"$f":"SUM(E5:I5)","v":0}]
[null,"Non Repayable Line Diversions ","[€m]",null,0,0,0,0,0,null,{"$f":"SUM(E6:I6)","v":0}]
[null,"Network Operations & Maintenance","[€m]",null,{"$f":"SUM(E8:E10)","v":93.104597322125628},{"$f":"SUM(F8:F10)","v":91.06945721761943},{"$f":"SUM(G8:G10)","v":89.080218664073328},{"$f":"SUM(H8:H10)","v":87.13582057357263},{"$f":"SUM(I8:I10)","v":85.235226852705892},null,445.62532063009689]
[null,"System control","[€m]",null,14.735171767200336,14.366792473020327,14.007622661194819,13.657432094664948,13.315996292298324,null,70.08301528837876]
[null,"Planned maintenance","[€m]",null,41.044067341363274,40.31044048637613,39.590177351111123,38.88303029343448,38.188756329571191,null,198.0164718018562]
[null,"Fault maintenance","[€m]",null,37.325358213562019,36.392224258222967,35.482418651767389,34.595358185473202,33.730474230836371,null,177.52583353986194]
[null,"Asset Management","[€m]",null,{"$f":"E12","v":12.395429029507891},12.208215240634031,12.025681796482015,11.847711688433805,11.674190833086797,null,60.151228588144534]
[null,"Asset Management","[€m]",null,12.395429029507891,12.208215240634031,12.025681796482015,11.847711688433805,11.674190833086797,null,60.151228588144534]
[null,"Metering","[€m]",null,{"$f":"SUM(E14:E17)","v":20.808708639590108},20.452125905071156,20.102003214193122,19.758215883735801,19.420641795291456,null,100.54169543788164]
[null,"Meter reading","[€m]",null,12.518458787893602,12.330681906075197,12.145721677484069,11.963535852321808,11.784082814536982,null,60.742481038311659]
[null,"QH Data","[€m]",null,1.5329642715200338,1.5099698074472332,1.4873202603355247,1.4650104564304918,1.4430352995840343,null,7.4383000953173175]
[null,"Data Aggregation ","[€m]",null,4.4452104925097915,4.3340802301970465,4.2257282244421202,4.1200850188310669,4.01708289336029,null,21.142186859340313]
[null,"Customer meter operation","[€m]",null,2.3120750876666829,2.2773939613516827,2.2432330519314077,2.2095845561524365,2.1764407878101499,null,11.218727444912361]
[null,"Customer Service","[€m]",null,{"$f":"SUM(E19:E21)","v":17.299316671631157},16.866833754840378,16.445162910969369,16.034033838195136,15.633182992240258,null,82.278530167876283]
[null,"Call centre","[€m]",null,6.9021830910036046,6.7296285137285148,6.5613878008853019,6.3973531058631696,6.2374192782165903,null,32.82797178969718]
[null,"Area Operations","[€m]",null,9.5549999999999997,9.3161249999999995,9.0832218749999996,8.8561413281250001,8.6347377949218753,null,45.445225998046872]
[null,"Customer relations / Other Cust Service","[€m]",null,0.84213358062755272,0.82108024111186384,0.80055323508406717,0.78053940420696544,0.76102591910179129,null,4.0053323801322405]
[null,"Provision of information","[€m]",null,{"$f":"SUM(E23:E25)","v":14.798304880354726},14.586355615013405,14.377585588652202,14.17194711268642,13.969393213860123,null,71.903586410566874]
[null,"DUoS Billing","[€m]",null,0.66835385759999999,0.66835385759999999,0.66835385759999999,0.66835385759999999,0.66835385759999999,null,3.3417692880000001]
[null,"MRSO","[€m]",null,1.9424510227547258,1.913314257413405,1.8846145435522039,1.8563453253989208,1.828500145517937,null,9.4252252946371922]
[null,"Market Opening","[€m]",null,12.1875,12.004687499999999,11.824617187499999,11.647247929687499,11.472539210742186,null,59.136591827929678]
[null,"Commercial","[€m]",null,{"$f":"SUM(E27:E29)","v":39.281693960042887},39.646082338548432,41.01377741204454,41.491285927209994,43.182795625806499,null,204.61563526365234]
[null,"External repayable / COS adjustments","[€m]",null,25.157192178016665,25.015759842307393,25.825561148033533,25.799974224838373,26.782666615954199,null,128.58115400915017]
[null,"Supply repayable","[€m]",null,10.711600919853861,11.332094852202058,11.959166121342047,12.533841453313999,13.254691428617573,null,59.791394775329536]
[null,"Other inter ESB","[€m]",null,3.4129008621723655,3.2982276440389806,3.2290501426689611,3.1574702490576212,3.1454375812347211,null,16.24308647917265]
[null,"Other","[€m]",null,{"$f":"SUM(E31:E34)","v":61.851060843826275},{"$f":"SUM(F31:F34)","v":61.3839219274344},{"$f":"SUM(G31:G34)","v":60.928461483952319},{"$f":"SUM(H31:H34)","v":60.48438755155729},{"$f":"SUM(I31:I34)","v":63.589921980871594},null,308.23775378764185]
[null,"Network Rates","[€m]",null,35.385065133994495,35.385065133994495,35.385065133994495,35.385065133994495,38.923571647393949,null,180.46383218337192]
[null,"Insurance","[€m]",null,2.5,2.5,2.5,2.5,2.5,null,12.5]
[null,"CER Levy","[€m]",null,1.9,1.9,1.9,1.9,1.9,null,9.5]
[null,"Other","[€m]",null,{"$f":"SUM(E35:E42)","v":22.065995709831778},{"$f":"SUM(F35:F42)","v":21.598856793439904},{"$f":"SUM(G35:G42)","v":21.143396349957822},{"$f":"SUM(H35:H42)","v":20.699322417562794},{"$f":"SUM(I35:I42)","v":20.266350333477643},null,105.77392160426994]
[null,"Company wide costs","[€m]",null,1.9295579354999999,1.8813189871124998,1.8342860124346871,1.78842886212382,1.7437181405707245,null,9.1773099377417324]
[null,"Corporate Charges & Corporate Affairs","[€m]",null,11.596092504749999,11.306190192131249,11.023535437327967,10.747947051394767,10.479248375109899,null,55.15301356071388]
[null,"Legal","[€m]",null,2.2574390541567779,2.2574390541567779,2.2574390541567779,2.2574390541567779,2.2574390541567779,null,11.28719527078389]
[null,"Pension","[€m]",null,1.654107,1.612754325,1.572435466875,1.533124580203125,1.4947964656980468,null,7.8672178377761721]
[null,"Environmental","[€m]",null,1.1000000000000001,1.1000000000000001,1.1000000000000001,1.1000000000000001,1.1000000000000001,null,5.5]
[null,"Revenue","[€m]",null,0.61508218200000009,0.59970512745000004,0.58471249926375002,0.57009468678215625,0.55584231961260233,null,2.9254368151085086]
[null,"Misc","[€m]",null,2.3E-2,2.3E-2,2.3E-2,2.3E-2,2.3E-2,null,0.11499999999999999]
[null,"Health & Safety","[€m]",null,2.8907170334249992,2.8184491075893741,2.7479878798996396,2.6792881829021487,2.6123059783295948,null,13.748748182145755]
[null,"Sustainability & RD&D","[€m]",null,{"$f":"SUM(E44:E45)","v":3.6399999999999997},{"$f":"SUM(F44:F45)","v":3.6399999999999997},3.6399999999999997,3.6399999999999997,3.6399999999999997,null,18.2]
[null,"Sustainability","[€m]",null,2.96,2.96,2.96,2.96,2.96,null,14.8]
[null,"R&D","[€m]",null,0.67999999999999994,0.67999999999999994,0.67999999999999994,0.67999999999999994,0.67999999999999994,null,3.3999999999999995]
[null,"TOTAL OPEX","[€m]",null,{"$f":"E30+E26+E22+E18+E13+E11+E7+E5+E43","v":263.17911134707862},{"$f":"F30+F26+F22+F18+F13+F11+F7+F5+F43","v":259.85299199916119},257.61289107036691,254.56340257539105,256.34535329386262,null,{"$f":"SUM(E46:I46)","v":1291.5537502858606}]
[]
[null,"LESS..."]
[null,"Comercial Expenditures","[€m]",null,{"$f":"-E26","v":-39.281693960042887},{"$f":"-F26","v":-39.646082338548432},{"$f":"-G26","v":-41.01377741204454},{"$f":"-H26","v":-41.491285927209994},{"$f":"-I26","v":-43.182795625806499},null,-204.61563526365234]
[null,"Other Misc. Incomes","[€m]",null,{"$f":"SUM(E51:E56)","v":-3},{"$f":"SUM(F51:F56)","v":-3},{"$f":"SUM(G51:G56)","v":-3},{"$f":"SUM(H51:H56)","v":-3},{"$f":"SUM(I51:I56)","v":-3},null,{"$f":"SUM(E50:I50)","v":-15}]
[null,"Sale of scrap","[€m]",null,0,0,0,0,0,null,0]
[null,"DOE","[€m]",null,0,0,0,0,0,null,0]
[null,"Tower Co and Fibre Co","[€m]",null,0,0,0,0,0,null,0]
[null,"Supply Chain","[€m]",null,0,0,0,0,0,null,0]
[null,"Misc","[€m]",null,0,0,0,0,0,null,0]
[null,"€15m Various Revenue","[€m]",null,-3,-3,-3,-3,-3,null,-15]
[null,"Non Retained Porperty Disposal","[€m]",null,{"$f":"E58*(1-E59)","v":0},{"$f":"F58*(1-F59)","v":0},{"$f":"G58*(1-G59)","v":0},{"$f":"H58*(1-H59)","v":0},{"$f":"I58*(1-I59)","v":0},null,0]
[null,"(Loss)/Profit on sale of Assets    (Nominal values)","[€m]",null,0,0,0,0,0,null,0]
[null,"% Retained by the Company","[%]",null,0.6,0.6,0.6,0.6,0.6,null,3]
[]
[null,"TOTAL ALLOWED OPEX","[€m]",null,{"$f":"E46+E49+E50+E57","v":220.89741738703572},{"$f":"F46+F49+F50+F57","v":217.20690966061275},{"$f":"G46+G49+G50+G57","v":213.59911365832238},{"$f":"H46+H49+H50+H57","v":210.07211664818107},{"$f":"I46+I49+I50+I57","v":210.16255766805611},null,{"$f":"SUM(E61:I61)","v":1071.938115022208}]
[]
[null,null,null,null,{"$f":"E46+E50","v":260.17911134707862},{"$f":"F46+F50","v":256.85299199916119},254.61289107036691,251.56340257539105,253.34535329386262]

{"sheet":"Capex","index":3,"n_rows":70,"n_cols":11,"rows_kept":70,"cut":false,"hidden":false,"merged":[]}
["Capex"]
[null,null,"Asset Categorisation",null,2011,2012,2013,2014,2015,null,"Totals"]
["LOAD RELATED CAPEX"]
["(G1) New housing Schemes","[€m]",null,null,12.067345529574345,13.331453316680244,14.570234021482577,15.781755776945602,16.96759007389722,null,{"$f":"SUM(E4:I4)","v":72.718378718579999}]
["(G2) Non-scheme Houses","[€m]",null,null,31.269320100000002,31.694564295900005,32.114239398054011,32.52235154173534,32.916118981597947,null,160.51659431728731]
["(G3) Commercial/Industrial Supplies","[€m]",null,null,39.961624342500002,40.758532578225001,41.484884297298748,42.187621531972461,42.877117014316099,null,207.26977976431232]
["Whole Current Metering","[€m]",null,null,2.1652721499999998,2.2993834500000001,2.4331802499999999,2.5668351,2.7004619000000001,null,12.165132850000001]
["New Business","[€m]",null,null,{"$f":"SUM(E4:E7)","v":85.463562122074336},{"$f":"SUM(F4:F7)","v":88.083933640805242},{"$f":"SUM(G4:G7)","v":90.602537966835342},{"$f":"SUM(H4:H7)","v":93.058563950653408},{"$f":"SUM(I4:I7)","v":95.461287969811252},null,{"$f":"SUM(E8:I8)","v":452.66988565017959}]
["Transmission Connection Costs",null,null,null,5.2524450000000007,5.1999205500000008,5.1479213445000003,5.0964421310550003,5.0454777097444499,null,{"$f":"SUM(E9:I9)","v":25.742206735299451}]
["110kV",null,null,null,47.747617447897547,46.46700925895918,45.897853189756077,45.494894077173804,44.940957892065512,null,230.54833186585211]
["38kV",null,null,null,43.440794243334011,42.302966765451977,41.847608509767149,41.525321485014572,41.13315154291724,null,210.24984254648496]
["MVLV  System Improvements",null,null,null,14.477608752744969,14.058557270909397,13.739715201068133,13.499904684891593,13.324790467734648,null,69.10057637734873]
["IFTs associated with 20kV Conversion","[€m]",null,null,3.338452782316554,3.2717150414346352,3.2392424379831541,3.21270549155081,3.1885589320535419,null,16.250674685338694]
["20kV Conversion","[€m]",null,null,16.561807208725167,16.260933515685938,16.126971921818853,16.017836150073855,15.971304019548285,null,80.938852815852101]
["Reinforcements","[€m]",null,null,{"$f":"SUM(E9:E14)","v":130.81872543501825},{"$f":"SUM(F9:F14)","v":127.56110240244114},125.99931260489336,124.84710401975963,123.60424056406367,null,{"$f":"SUM(E15:I15)","v":632.83048502617612}]
["Generation Connections","[€m]",null,null,7.2259392256368118,40.179478719702466,31.800605812250591,16.492602866615748,66.800816337303388,null,162.499442961509]
["Dismantling","[€m]",null,null,11.84089021114081,11.612008446353961,11.465619404408885,11.348632404643814,11.228209891580539,null,57.495360358128011]
["Non-Repayable Line Diversions","[€m]",null,null,9.7547474434403316,10.129691154258362,10.395115119477799,10.60832166977721,10.867159869927098,null,51.755035256880802]
["Total Load Related CAPEX","[€m]",null,null,{"$f":"E8+E15+E16+E17+E18","v":245.10386443731053},{"$f":"F8+F15+F16+F17+F18","v":277.56621436356113},270.26319090786598,256.3552249114498,307.96171463268593,null,{"$f":"SUM(E19:I19)","v":1357.2502092528734}]
[]
["NON-LOAD RELATED CAPEX"]
["Renew Prog - 110kV & 38kV Lines","[€m]",null,null,3.3180994007214166,3.2849184067142025,3.2520692226470604,3.2195485304205897,3.1873530451163838]
["Renew Prog - 110 & 38kV Cables","[€m]",null,null,4.1834973752114228,4.1416624014593086,4.1002457774447159,4.0592433196702684,4.0186508864735657]
["Renew Prog - HV Substation","[€m]",null,null,23.973118372426924,23.733387188702654,23.496053316815626,23.26109278364747,23.028481855810995]
["Renew Prog - MV Overhead Lines","[€m]",null,null,14.074420840540132,13.933676632134731,13.794339865813383,13.65639646715525,13.519832502483698]
["Renew Prog - MV Cables","[€m]",null,null,0.51168000000000002,0.50656319999999999,0.501497568,0.49648259232000003,0.4915177663968]
["Renew Prog - MV Substations","[€m]",null,null,4.9143926684015291,4.8652487417175134,4.8165962543003387,4.7684302917573351,4.720745988839762]
["Renew Prog - Urban LV Renewal","[€m]",null,null,12.847405743363073,12.718931685929443,12.591742369070149,12.465824945379447,12.341166695925653]
["Renew Prog - Rural LV Network","[€m]",null,null,19.104178629788144,18.913136843490264,18.72400547505536,18.536765420304807,18.351397766101758]
["Renew Prog - LV cables and associated items","[€m]",null,null,3.4198173718323135,3.3856191981139903,3.3517630061328503,3.3182453760715216,3.2850629223108063]
["Renew Prog - Cutouts","[€m]",null,null,1.1671527962858725,1.1554812683230138,1.1439264556397837,1.1324871910833858,1.1211623191725519]
["Response capex","[€m]",null,null,4.5426070452874585,4.4971809748345839,4.4522091650862379,4.4076870734353752,4.3636102027010217]
["Continuity Imporvement","[€m]",null,null,20.790117053223661,20.199933688513383,19.62330984428624,19.240533752407732,18.86781689253122]
["System Control",null,null,null,3.02,3.02,3.02,3.02,3.02]
["Total Non-Load Related CAPEX","[€m]",null,null,{"$f":"SUM(E22:E34)","v":115.86648729708195},{"$f":"SUM(F22:F34)","v":114.35574022993308},112.86775832029174,111.58273774365315,110.31679884386421,null,{"$f":"SUM(E35:I35)","v":564.98952243482404}]
[]
["TOTAL NETWORK CAPEX","[€m]","HV/MV/LV Networks",null,{"$f":"E19+E35","v":360.97035173439247},{"$f":"F19+F35","v":391.92195459349421},{"$f":"G19+G35","v":383.1309492281577},{"$f":"H19+H35","v":367.93796265510298},{"$f":"I19+I35","v":418.27851347655013},null,{"$f":"SUM(E37:I37)","v":1922.2397316876975}]
[]
["NON NETWORK CAPEX"]
["New Accommodation","[€m]","Premises",null,0,0,0,49.96217449144747,49.952929921024435]
["Accommodation Refurbishment","[€m]","Premises",null,3.5452500000000002,3.5452500000000002,3.6652499999999999,3.7665000000000002,3.7665000000000002]
["Fixture & Fittings","[€m]","F&F",null,0.35624999999999996,0.28500000000000003,0.28500000000000003,0.28500000000000003,0.21375]
["Office Equipment","[€m]","Office Equip,Telecoms & Smart Metering (10 Year)",null,0.11874999999999999,9.5000000000000001E-2,9.5000000000000001E-2,9.5000000000000001E-2,7.1249999999999994E-2]
["Vehicles","[€m]","Vehicles",null,7.04,7.04,7.04,7.04,7.04]
["Tools","[€m]","Tools",null,3.5809199999999999,3.3986399999999999,3.1281600000000003,2.8224,2.7488999999999999]
["Distribution Assets Management","[€m]","IT (7 year)",null,0,2.5,8.5,3,2.5]
["Distribution Control / Operation","[€m]","Scada Tel (15 years)",null,6,5.5,0,0,0]
["IT Infrastructure","[€m]","IT (5 year)",null,0.9,2,1.7,0.7,0.7]
["Enterprise Applicactions","[€m]","IT (5 year)",null,4.5,3.31,2.6999999999999997,12.2,12.9]
["Environment","[€m]","IT (5 year)",null,1.3719999999999999,1.3719999999999999,1.3719999999999999,1.3719999999999999,1.3719999999999999]
["Telecomms & System Control","[€m]","Office Equip,Telecoms & Smart Metering (10 Year)",null,6.3488000000000007,6.3488000000000007,6.3568000000000007,6.3488000000000007,6.3488000000000007,null,{"$f":"SUM(E41:I51)","v":179.28977000000012}]
["TOTAL NON-NETWORK CAPEX","[€m]",null,null,{"$f":"SUM(E40:E51)","v":33.761969999999998},{"$f":"SUM(F40:F51)","v":35.394689999999997},{"$f":"SUM(G40:G51)","v":34.842210000000001},{"$f":"SUM(H40:H51)","v":87.59187449144747},{"$f":"SUM(I40:I51)","v":87.614129921024428},null,{"$f":"SUM(E52:I52)","v":279.2048744124719}]
[]
["OTHER"]
["Smart Metering","[€m]",null,null,9.5936001451143298,15.506772196719,134.66978507061199,121.217134457184,219.338914435399]
[{"$f":"A55","v":"Smart Metering"},"[€m]","Office Equip,Telecoms & Smart Metering (10 Year)",null,{"$f":"IF(SMin=1,E55,0)","v":9.5936001451143298},{"$f":"IF(SMin=1,F55,0)","v":15.506772196719},{"$f":"IF(SMin=1,G55,0)","v":134.66978507061199},{"$f":"IF(SMin=1,H55,0)","v":121.217134457184},{"$f":"IF(SMin=1,I55,0)","v":219.338914435399}]
["Electric Vehicles Infrastructure","[€m]","Vehicles",null,0,0,0,0,0]
["Total Other","[€m]",null,null,{"$f":"E56+E57","v":9.5936001451143298},{"$f":"F56+F57","v":15.506772196719},134.66978507061199,121.217134457184,219.338914435399,null,{"$f":"SUM(E58:I58)","v":500.32620630502834}]
[]
["TOTAL GROSS CAPEX","[€m]",null,null,{"$f":"E37+E52+E58","v":404.32592187950684},{"$f":"F37+F52+F58","v":442.82341679021317},{"$f":"G37+G52+G58","v":552.64294429876975},{"$f":"H37+H52+H58","v":576.74697160373444},{"$f":"I37+I52+I58","v":725.23155783297352},null,{"$f":"SUM(E60:I60)","v":2701.7708124051978}]
[]
["CONTRIBUTIONS"]
["Customer Contributions as % of New Demand Connections","[%]",null,null,0.5,0.5,0.5,0.5,0.5]
["Customer Contributions as % of Generation Connections","[%]",null,null,1,1,1,1,1]
["Customer Contributions","[€m]","Customer Contributions",null,{"$f":"-SUM(E4:E7)*E63-(E16*E64)","v":-49.957720286673982},{"$f":"-SUM(F4:F7)*F63-(F16*F64)","v":-84.221445540105094},-77.101874795668266,-63.021884841942452,-114.53146032220901]
["Capital Grants","[€m]","Grants",null,0,0,0,0,0]
["IDC","[€m]","Other",null,0,0,0,0,0]
["Total Contributions","[€m]",null,null,{"$f":"E66+E65+E67","v":-49.957720286673982},{"$f":"F66+F65+F67","v":-84.221445540105094},-77.101874795668266,-63.021884841942452,-114.53146032220901,null,{"$f":"SUM(E68:I68)","v":-388.83438578659877}]
[]
["TOTAL NET CAPEX","[€m]",null,null,{"$f":"E60+E68","v":354.36820159283286},{"$f":"F60+F68","v":358.60197125010808},{"$f":"G60+G68","v":475.54106950310148},{"$f":"H60+H68","v":513.725086761792},{"$f":"I60+I68","v":610.70009751076452},null,{"$f":"SUM(E70:I70)","v":2312.9364266185989}]

{"sheet":"Cashflow","index":4,"n_rows":115,"n_cols":13,"rows_kept":115,"cut":false,"hidden":false,"merged":[]}
[]
[null,"CASH FLOW"]
[]
[null,"2009 Prices"]
[null,null,null,2010,2011,2012,2013,2014,2015,null,"TOTAL"]
[null,"Operating Activities:"]
[null,"Operating profit","[€m]",null,{"$f":"(Revenue!D19+Revenue!D17)/1000000","v":289.77209343761552},{"$f":"(Revenue!E19+Revenue!E17)/1000000","v":303.29130016899427},{"$f":"(Revenue!F19+Revenue!F17)/1000000","v":308.21577856888621},{"$f":"(Revenue!G19+Revenue!G17)/1000000","v":311.60219889404942},{"$f":"(Revenue!H19+Revenue!H17)/1000000","v":306.35553984604871},null,{"$f":"SUM(E7:I7)","v":1519.2369109155941}]
[null,"Depreciation","[€m]",null,{"$f":"-Dep_2011/1000000","v":171.92129978814697},{"$f":"-Dep_2012/1000000","v":177.57596486266709},{"$f":"-Dep_2013/1000000","v":192.66783066030598},{"$f":"-Dep_2014/1000000","v":212.77308967843246},{"$f":"-Dep_2015/1000000","v":239.05577397755528},null,{"$f":"SUM(E8:I8)","v":993.9939589671078}]
[null,"Other fixed asset and revaluation adjustment","[€m]",null,0,0,0,0,0,null,{"$f":"SUM(E9:I9)","v":0},null,"Source: ESBN submission Table 3.1.3"]
[null,"(Profit)/Loss on sale of assets","[€m]",null,0,0,0,0,0,null,0,null,"Source: ESBN submission Table 3.1.3"]
[null,"(Increase)/Decrease in stocks","[€m]",null,0,0,0,0,0,null,0,null,"Source: ESBN submission Table 3.1.3"]
[null,"(Increase)/Decrease in Debtors","[€m]",null,3.5843348586904469,-4.384379423707025,-4.8274607819926754,-5.1343555640935952,-5.4612601703417898,null,-16.223121081444638,null,"Source: ESBN submission Table 3.1.3"]
[null,"Increase/(Decrease) in Creditors","[€m]",null,-8.669871275086189,5.2867693734297649,9.5931969979341805,2.4410210612643422,11.612703028501709,null,20.263819186043808,null,"Source: ESBN submission Table 3.1.3"]
[null,"(Increase)/Decrease in provisions","[€m]",null,-4,-4,-4,-4,-4,null,-20,null,"Source: ESBN submission Table 3.1.3"]
[null,"Net cash inflow / (outflow) from Operating Activities","[€m]",null,{"$f":"SUM(E7:E14)","v":452.60785680936681},{"$f":"SUM(F7:F14)","v":477.76965498138412},{"$f":"SUM(G7:G14)","v":501.64934544513369},{"$f":"SUM(H7:H14)","v":517.68195406965265},{"$f":"SUM(I7:I14)","v":547.56275668176397},null,{"$f":"SUM(K7:K14)","v":2497.2715679873008}]
[]
[null,"Taxation",0.125]
[null,"Taxation Payments","[€m]",null,{"$f":"-$C$17*(E7+E21)","v":-22.101682904445489},{"$f":"-$C$17*(F7+F21)","v":-23.579171151473062},{"$f":"-$C$17*(G7+G21)","v":-23.717347331106936},{"$f":"-$C$17*(H7+H21)","v":-23.362091791252624},{"$f":"-$C$17*(I7+I21)","v":-21.733708345899487},null,{"$f":"-$C$17*(K7+K21)","v":-114.49400152417759}]
[]
[null,"Returns on Investments (ROI) & Servicing of Finance:"]
[null,"Debt Interest Payment","[€m]",null,{"$f":"-E70","v":-112.95863020205162},{"$f":"-F70","v":-114.65793095720976},-118.47699992003071,-124.70546456402843,-132.48587307885282,null,{"$f":"SUM(E21:I21)","v":-603.28489872217335}]
[]
[null,"Dividend"]
[null,"% of Profit after tax and interest",0.1]
[null,"Total Dividend ","[€m]",null,{"$f":"-$C$24*(E7+E18+E21)","v":-15.47117803311184},{"$f":"-$C$24*(F7+F18+F21)","v":-16.505419806031142},{"$f":"-$C$24*(G7+G18+G21)","v":-16.602143131774859},{"$f":"-$C$24*(H7+H18+H21)","v":-16.353464253876837},{"$f":"-$C$24*(I7+I18+I21)","v":-15.213595842129644},null,{"$f":"SUM(E25:I25)","v":-80.145801066924321}]
[]
[null,"Capital Expenditure and Financial Investments:"]
[null,"Purchase of fixed assets","[€m]",null,{"$f":"-Capex!E60","v":-404.32592187950684},{"$f":"-Capex!F60","v":-442.82341679021317},{"$f":"-Capex!G60","v":-552.64294429876975},{"$f":"-Capex!H60","v":-576.74697160373444},{"$f":"-Capex!I60","v":-725.23155783297352},null,{"$f":"SUM(E28:I28)","v":-2701.7708124051978}]
[null,"Receipts from Sale of Fixed Assets","[€m]",null,0,0,0,0,0,null,{"$f":"SUM(E29:I29)","v":0},null,"Source: ESBN submission Table 3.1.3"]
[null,"Receipt of Consumers' Contributions","[€m]",null,{"$f":"-Capex!E68","v":49.957720286673982},{"$f":"-Capex!F68","v":84.221445540105094},{"$f":"-Capex!G68","v":77.101874795668266},{"$f":"-Capex!H68","v":63.021884841942452},{"$f":"-Capex!I68","v":114.53146032220901},null,{"$f":"SUM(E30:I30)","v":388.83438578659877}]
[null,"Net cash inflow / (outflow) from Capital Expenditure","[€m]",null,{"$f":"SUM(E28:E30)","v":-354.36820159283286},-358.60197125010808,-475.54106950310148,-513.725086761792,-610.70009751076452,null,-2312.9364266185989]
[]
[null,"Financing:"]
[null,"New Loans in year","[€m]",null,54.408720751712544,94.044387309934862,151.78022307022545,208.95165867578334,232.57051809588285,null,{"$f":"SUM(E34:I34)","v":741.75550790353907}]
[null,"Repayment of Debt","[€m]",null,0,0,0,0,0,null,{"$f":"SUM(E35:I35)","v":0}]
[null,"New Equity","[€m]",null,0,0,0,0,0,null,{"$f":"SUM(E36:I36)","v":0}]
[null,"Total","[€m]",null,{"$f":"SUM(E34:E36)","v":54.408720751712544},{"$f":"SUM(F34:F36)","v":94.044387309934862},151.78022307022545,208.95165867578334,232.57051809588285,null,{"$f":"SUM(K34:K36)","v":741.75550790353907}]
[]
[null,"Increase / (Decrease) in Cash and Cash Equivalents","[€m]",null,{"$f":"E15+E18+E21+E25+E31+E37","v":2.1168848286375024},{"$f":"F15+F18+F21+F25+F31+F37","v":58.469549126496887},19.092008629345145,48.487505374486091,3.979039320256561E-13,null,{"$f":"+K37+K31+K25+K21+K18+K15","v":128.16594795896572}]
[]
[null,"Cash Balance","[€m]",{"$f":"$C43*-E31","v":177.18410079641643},{"$f":"$C43*-F31","v":179.30098562505404},237.77053475155074,256.862543380896,305.35004875538226,{"$f":"H41","v":305.35004875538226}]
[]
[null,"Cash balance at start of period as a %age of capex programme",0.5,null,null,null,null,null,"Cash Inflow/(Outflow) from Business excl. Loan Finance",null,{"$f":"K15+K18+K21","v":1779.4926677409499}]
[null,null,null,null,null,null,null,null,"Net Capital Expenditure",null,{"$f":"K31","v":-2312.9364266185989}]
[null,null,null,null,null,null,null,null,"Cash Inflow/(Outflow) before Dividends and Loan Finance",null,{"$f":"K43+K44","v":-533.44375887764909}]
[]
[]
[null,"Long Term Debt"]
[]
[null,null,null,2010,2011,2012,2013,2014,2015]
[null,"Index Linked Debt"]
[null,"Opening Balance","[€m]",null,{"$f":"(OAV_2011)*$D76/1000000","v":2735.9877974612023},{"$f":"E55","v":2790.396518212915},{"$f":"F55","v":2884.4409055228498},3036.2211285930753,3245.1727872688584]
[null,"Borrow","[€m]",null,{"$f":"E34","v":54.408720751712544},{"$f":"F34","v":94.044387309934862},{"$f":"G34","v":151.78022307022545},{"$f":"H34","v":208.95165867578334},{"$f":"I34","v":232.57051809588285}]
[null,"Finance Repayments","[€m]",null,{"$f":"E35","v":0},{"$f":"F35","v":0},0,0,0]
[null,"Closing Balance","[€m]",null,{"$f":"SUM(E52:E54)","v":2790.396518212915},2884.4409055228498,3036.2211285930753,3245.1727872688584,3477.7433053647414]
[]
[null,"Average Borrowings in Year","[€m]",null,{"$f":"(E52+E55)/2","v":2763.1921578370584},2837.4187118678824,2960.3310170579625,3140.6969579309671,3361.4580463167999]
[null,"Interest","[€m]",null,{"$f":"E57*$D$74","v":88.422149050785876},{"$f":"F57*$D$74","v":90.797398779772237},{"$f":"G57*$D$74","v":94.730592545854805},{"$f":"H57*$D$74","v":100.50230265379095},{"$f":"I57*$D$74","v":107.5666574821376}]
[]
[null,"Nominal Debt"]
[null,"Opening Balance","[€m]",null,2364.8000000000002,{"$f":"E64","v":2420.2968951667472},{"$f":"F64","v":2516.2221702228808},2671.0379977545108,2884.16868960381]
[null,"Borrow","[€m]",null,{"$f":"E53*(1+$D72)","v":55.496895166746796},{"$f":"F53*(1+$D72)","v":95.925275056133557},{"$f":"G53*(1+$D72)","v":154.81582753162996},{"$f":"H53*(1+$D72)","v":213.13069184929901},{"$f":"I53*(1+$D72)","v":237.22192845780052}]
[null,"Finance Repayments","[€m]",null,{"$f":"E36*(1+$D72)","v":0},{"$f":"F36*(1+$D72)","v":0},{"$f":"G36*(1+$D72)","v":0},{"$f":"H36*(1+$D72)","v":0},{"$f":"I36*(1+$D72)","v":0}]
[null,"Closing Balance","[€m]",null,{"$f":"E61+E62","v":2420.2968951667472},{"$f":"F61+F62","v":2516.2221702228808},2671.0379977545108,2884.16868960381,3121.3906180616104]
[null,"Year",null,null,1,2,3,4,5]
[]
[null,"Average Borrowings in Year","[€m]",null,{"$f":"(E61+E64)/2","v":2392.5484475833737},{"$f":"(F61+F64)/2","v":2468.259532694814},2593.6300839886958,2777.6033436791604,3002.7796538327102]
[null,"Interest","[€m]",null,{"$f":"E67*((1+$D72)*(1+$D74)-1)/(1+$D72)^E65","v":123.47426498116552},{"$f":"F67*((1+$D72)*(1+$D74)-1)/(1+$D72)^F65","v":124.88387331896871},{"$f":"G67*((1+$D72)*(1+$D74)-1)/(1+$D72)^G65","v":128.65403165182039},{"$f":"H67*((1+$D72)*(1+$D74)-1)/(1+$D72)^H65","v":135.0782482398445},{"$f":"I67*((1+$D72)*(1+$D74)-1)/(1+$D72)^I65","v":143.16553690601648}]
[]
[null,"Indexed and Nominal Debt Interest","[€m]",null,{"$f":"(E58*$I72)+(E68*(1-$I72))","v":112.95863020205162},{"$f":"(F58*$I72)+(F68*(1-$I72))","v":114.65793095720976},{"$f":"(G58*$I72)+(G68*(1-$I72))","v":118.47699992003071},{"$f":"(H58*$I72)+(H68*(1-$I72))","v":124.70546456402843},{"$f":"(I58*$I72)+(I68*(1-$I72))","v":132.48587307885282}]
[]
[null,"Inflation","[%]",0.02,null,null,null,"%age of Index linked debt",0.3]
[]
[null,"Interest Rate","[%]",3.2000000000000001E-2,null,null,null,"Nominal Interest Rate",{"$f":"(1+D72)*(1+D74)-1","v":5.264000000000002E-2}]
[]
[null,"Gearing","[%]",0.55000000000000004]
[]
[]
[null,"Ratios"]
[]
[null,"EBIT","[€m]",null,{"$f":"E7","v":289.77209343761552},{"$f":"F7","v":303.29130016899427},308.21577856888621,311.60219889404942,306.35553984604871]
[null,"Interest","[€m]",null,{"$f":"Cashflow!E70","v":112.95863020205162},{"$f":"Cashflow!F70","v":114.65793095720976},{"$f":"Cashflow!G70","v":118.47699992003071},{"$f":"Cashflow!H70","v":124.70546456402843},{"$f":"Cashflow!I70","v":132.48587307885282}]
[null,"EBIT Interest Cover","times",null,{"$f":"E81/E82","v":2.5652939746108263},{"$f":"F81/F82","v":2.6451837883083931},2.601481965081196,2.4987052490715933,2.312363822093789,null,{"$f":"AVERAGE(E83:I83)","v":2.5246057598331597}]
[]
[null,"EBITDA","[€m]",null,{"$f":"E7+E8","v":461.69339322576252},{"$f":"F7+F8","v":480.86726503166136},500.88360922919219,524.37528857248185,545.41131382360402]
[null,"Interest","[€m]",null,{"$f":"E70","v":112.95863020205162},{"$f":"F70","v":114.65793095720976},118.47699992003071,124.70546456402843,132.48587307885282]
[null,"EBITDA Interest Cover","times",null,{"$f":"E85/E86","v":4.087278611646771},{"$f":"F85/F86","v":4.1939293777341984},4.2276864671394216,4.2049102692147704,4.1167507232939968,null,4.166111089805832]
[]
[null,"Net Debt","[€m]",null,{"$f":"(E55*$I72)+(E64*(1-$I72))-E41","v":2352.0257964555435},{"$f":"(F55*$I72)+(F64*(1-$I72))-F41","v":2388.9172560613206},2523.7303936251838,2687.119870147942,2922.9463754971671]
[null,"RAV","[€m]",null,{"$f":"CAV_2011/1000000","v":5156.9701699159623},{"$f":"(OAV_2012+CAV_2012)/2/1000000","v":5247.483173109682},{"$f":"(OAV_2013+CAV_2013)/2/1000000","v":5479.4327957247997},{"$f":"(OAV_2014+CAV_2014)/2/1000000","v":5771.3454136878772},{"$f":"(OAV_2015+CAV_2015)/2/1000000","v":6107.6435739961626}]
[null,"Net Debt/RAV","%",null,{"$f":"E89/E90","v":0.45608675616866562},{"$f":"F89/F90","v":0.45525010319292508},0.4605824156825622,0.46559678507110497,0.47857186492379356,null,{"$f":"AVERAGE(E91:I91)","v":0.46321758500781024}]
[]
[null,"EBITDA","[€m]",null,{"$f":"E85","v":461.69339322576252},{"$f":"F85","v":480.86726503166136},500.88360922919219,524.37528857248185,545.41131382360402]
[null,"Net Debt","[€m]",null,{"$f":"E89","v":2352.0257964555435},{"$f":"F89","v":2388.9172560613206},2523.7303936251838,2687.119870147942,2922.9463754971671]
[null,"EBITDA/Net Debt","%",null,{"$f":"E93/E94","v":0.19629605845374884},{"$f":"F93/F94","v":0.20129088347935567},0.19846953957300631,0.19514398832665841,0.18659641463002702,null,0.19555937689255926]
[]
[null,"Operating Cashflows","[€m]",null,{"$f":"E15","v":452.60785680936681},{"$f":"F15","v":477.76965498138412},501.64934544513369,517.68195406965265,547.56275668176397]
[null,"Capex","[€m]",null,{"$f":"-E28","v":404.32592187950684},{"$f":"-F28","v":442.82341679021317},552.64294429876975,576.74697160373444,725.23155783297352]
[null,"Operating Cashflows/Capex","%",null,{"$f":"E97/E98","v":1.1194134046746784},{"$f":"F97/F98","v":1.0789168703960537},0.90772776640016617,0.89758937551099338,0.75501782950249374,null,0.95173304929687708]
[]
[null,"FFO","[€m]",null,{"$f":"E7+E8+E18+E21","v":326.6330801192654},{"$f":"F7+F8+F18+F21","v":342.63016292297851},{"$f":"G7+G8+G18+G21","v":358.68926197805456},{"$f":"H7+H8+H18+H21","v":376.30773221720079},{"$f":"I7+I8+I18+I21","v":391.19173239885174}]
[null,"Interest","[€m]",null,{"$f":"E70","v":112.95863020205162},{"$f":"F70","v":114.65793095720976},118.47699992003071,124.70546456402843,132.48587307885282]
[null,"FFO Interest Cover","times",null,{"$f":"(E101+E102)/E102","v":3.891616864820417},{"$f":"(F101+F102)/F102","v":3.9882814041956487},4.0275012215042727,4.0175721130808215,3.9527052455322735,null,{"$f":"AVERAGE(E103:I103)","v":3.975535369826686}]
[]
[null,"FFO","[€m]",null,{"$f":"E7+E8+E18+E21","v":326.6330801192654},{"$f":"F7+F8+F18+F21","v":342.63016292297851},358.68926197805456,376.30773221720079,391.19173239885174]
[null,"Net Debt","[€m]",null,{"$f":"E89","v":2352.0257964555435},{"$f":"F89","v":2388.9172560613206},2523.7303936251838,2687.119870147942,2922.9463754971671]
[null,"FFO/Net Debt","%",null,{"$f":"E105/E106","v":0.13887308575080043},{"$f":"F105/F106","v":0.1434248767108339},0.14212661656890357,0.14004128970862875,0.13383472775216873,null,{"$f":"AVERAGE(E107:I107)","v":0.13966011929826708}]
[]
[null,"Retained Cash Flow","[€m]",null,{"$f":"E7+E8+E18+E21+E25","v":311.16190208615353},{"$f":"F7+F8+F18+F21+F25","v":326.12474311694734},{"$f":"G7+G8+G18+G21+G25","v":342.08711884627968},{"$f":"H7+H8+H18+H21+H25","v":359.95426796332396},{"$f":"I7+I8+I18+I21+I25","v":375.97813655672212}]
[null,"Net Debt","[€m]",null,{"$f":"E89","v":2352.0257964555435},{"$f":"F89","v":2388.9172560613206},{"$f":"G89","v":2523.7303936251838},{"$f":"H89","v":2687.119870147942},{"$f":"I89","v":2922.9463754971671}]
[null,"Retained Cash Flow / Net Debt","%",null,{"$f":"E109/E110","v":0.13229527607863331},{"$f":"F109/F110","v":0.13651571325439668},0.13554820265681888,0.13395541894582705,0.12862984408763625,null,{"$f":"AVERAGE(E111:I111)","v":0.13338889100466242}]
[]
[null,"Retained Cash Flow","[€m]",null,{"$f":"E7+E8+E18+E21+E25","v":311.16190208615353},{"$f":"F7+F8+F18+F21+F25","v":326.12474311694734},{"$f":"G7+G8+G18+G21+G25","v":342.08711884627968},{"$f":"H7+H8+H18+H21+H25","v":359.95426796332396},{"$f":"I7+I8+I18+I21+I25","v":375.97813655672212}]
[null,"Capex","[€m]",null,{"$f":"-E28","v":404.32592187950684},{"$f":"-F28","v":442.82341679021317},{"$f":"-G28","v":552.64294429876975},{"$f":"-H28","v":576.74697160373444},{"$f":"-I28","v":725.23155783297352}]
[null,"Retained Cash Flow / Capex","times",null,{"$f":"E113/E114","v":0.76958187751039842},{"$f":"F113/F114","v":0.73646679636060974},0.61900205616547344,0.62411124060593726,0.51842495337649497,null,0.65351738480378274]

{"sheet":"RAB Summary","index":5,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
["Distribution RAB 2011 to 2015"]
[null,"(€ 2009 prices)"]
[null,null,2011,2012,2013,2014,2015]
[null,"OAV",4974523268.1112766,{"$f":"C8","v":5156970169.9159622},{"$f":"D8","v":5337996176.3034029},5620869415.1461983,5921821412.229558]
[null,"Capex",{"$f":"'2011 to 2015 Distribution RAB'!Q76","v":354368201.59283286},{"$f":"'2011 to 2015 Distribution RAB'!Q77","v":358601971.25010806},{"$f":"'2011 to 2015 Distribution RAB'!Q78","v":475541069.50310147},{"$f":"'2011 to 2015 Distribution RAB'!Q79","v":513725086.76179206},{"$f":"'2011 to 2015 Distribution RAB'!Q80","v":610700097.5107646}]
[null,"Depreciation",-171921299.78814697,-177575964.86266708,-192667830.66030598,-212773089.67843246,-239055773.97755527]
[null,"CAV",{"$f":"SUM(C5:C7)","v":5156970169.9159622},{"$f":"SUM(D5:D7)","v":5337996176.3034029},5620869415.1461983,5921821412.229558,6293465735.7627668]

{"sheet":"2011 to 2015 Distribution RAB","index":6,"n_rows":82,"n_cols":86,"rows_kept":82,"cut":false,"hidden":false,"merged":[]}
[null,"Historic Cost",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Indexed Gross Asset Value",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Indexed Net Book Value (CAV 2000 using ESB asset lifes)",null,null,null,null,null,null,null,null,null,null,null,"Opening Asset Base",2001,null,null,null,null,"Indexed Net Book Value (CAV 2005 applying FRS 15 and CER PR1 asset lifes)",null,null,null,null,null,null,null,null,null,null,"Opening Asset Base",2006,null,null,null,null,"Indexed Net Book Value",null,null,null,null,null,null,null,null,null,"Opening Asset Base",2016]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Asset Life",30,25,5,7,10,5,15,7,50,5,15,25,25,40,null,null,"Asset Life",40,40,5,7,10,5,15,7,50,5,15,40,40,40,null,null,"Asset Life",45,45,5,7,10,5,15,7,50,5,15,45,45,45]
["Capitalised Year",null,"110kV Networks","HV/MV/LV Networks","IT (5 year)","IT (7 year)","Office Equip,Telecoms & Smart Metering (10 Year)","F&F","Scada Tel (15 years)","Vehicles","Premises","Tools","Telecoms (15 Years)","Grants","Customer Contributions","Other","Total",null,"Indexation",null,{"$f":"C4","v":"110kV Networks"},{"$f":"D4","v":"HV/MV/LV Networks"},{"$f":"E4","v":"IT (5 year)"},{"$f":"F4","v":"IT (7 year)"},{"$f":"G4","v":"Office Equip,Telecoms & Smart Metering (10 Year)"},"F&F","Scada Tel (15 years)","Vehicles","Premises","Tools","Telecoms (15 Years)","Grants","Customer Contributions","Other","Total",null,null,{"$f":"C4","v":"110kV Networks"},{"$f":"D4","v":"HV/MV/LV Networks"},"IT (5 year)","IT (7 year)","Office Equip,Telecoms & Smart Metering (10 Year)","F&F","Scada Tel (15 years)","Vehicles","Premises","Tools","Telecoms (15 Years)","Grants","Customer Contributions","Other","Total",null,null,{"$f":"C4","v":"110kV Networks"},{"$f":"D4","v":"HV/MV/LV Networks"},"IT (5 year)","IT (7 year)","Office Equip,Telecoms & Smart Metering (10 Year)","F&F","Scada Tel (15 years)","Vehicles","Premises","Tools","Telecoms (15 Years)","Grants","Customer Contributions","Other","Total",null,null,{"$f":"C4","v":"110kV Networks"},{"$f":"D4","v":"HV/MV/LV Networks"},"IT (5 year)","IT (7 year)","Office Equip,Telecoms & Smart Metering (10 Year)","F&F","Scada Tel (15 years)","Vehicles","Premises","Tools","Telecoms (15 Years)","Grants","Customer Contributions","Other","Total"]
[null,null,null,"€","€","€","€","€","€","€","€","€","€","€","€",null,"€",null,null,null,null,"€","€",null,"€","€","€","€","€","€","€","€","€",null,"€",null,null,"€","€","€",null,"€","€","€","€","€","€","€","€","€","€","€",null,null,"€","€","€",null,"€","€","€","€","€","€","€","€","€","€","€",null,null,"€","€","€",null,"€","€","€","€","€","€","€","€","€","€","€"]
[]
[1950,null,0,1040673.3,0,0,0,0,0,0,0,0,0,0,-1133288.780175,0,{"$f":"SUM(C7:P7)","v":-92615.480174999917},null,{"$f":"Inflation!O7","v":29.199162479061979},null,{"$f":"+C7*$S7","v":0},{"$f":"+D7*$S7","v":30386788.774321612},0,0,0,0,0,0,0,0,0,0,-33091083.22802778,0,{"$f":"SUM(U7:AG7)","v":-2704294.4537061676},null,null,{"$f":"IF(AND(($AX$1-$A7)<AL$3,$A7<$AX$1),((AL$3-($AX$1-$A7))/AL$3*U7),0)","v":0},{"$f":"IF(AND(($AX$1-$A7)<AM$3,$A7<$AX$1),((AM$3-($AX$1-$A7))/AM$3*V7),0)","v":0},{"$f":"IF(AND(($AX$1-$A7)<AN$3,$A7<$AX$1),((AN$3-($AX$1-$A7))/AN$3*W7),0)","v":0},0,{"$f":"IF(AND(($AX$1-$A7)<AP$3,$A7<$AX$1),((AP$3-($AX$1-$A7))/AP$3*Y7),0)","v":0},{"$f":"IF(AND(($AX$1-$A7)<AQ$3,$A7<$AX$1),((AQ$3-($AX$1-$A7))/AQ$3*Z7),0)","v":0},{"$f":"IF(AND(($AX$1-$A7)<AR$3,$A7<$AX$1),((AR$3-($AX$1-$A7))/AR$3*AA7),0)","v":0},{"$f":"IF(AND(($AX$1-$A7)<AS$3,$A7<$AX$1),((AS$3-($AX$1-$A7))/AS$3*AB7),0)","v":0},{"$f":"IF(AND(($AX$1-$A7)<AT$3,$A7<$AX$1),((AT$3-($AX$1-$A7))/AT$3*AC7),0)","v":0},{"$f":"IF(AND(($AX$1-$A7)<AU$3,$A7<$AX$1),((AU$3-($AX$1-$A7))/AU$3*AD7),0)","v":0},{"$f":"IF(AND(($AX$1-$A7)<AV$3,$A7<$AX$1),((AV$3-($AX$1-$A7))/AV$3*AE7),0)","v":0},{"$f":"IF(AND(($AX$1-$A7)<AW$3,$A7<$AX$1),((AW$3-($AX$1-$A7))/AW$3*AF7),0)","v":0},{"$f":"IF(AND(($AX$1-$A7)<AX$3,$A7<$AX$1),((AX$3-($AX$1-$A7))/AX$3*AG7),0)","v":0},{"$f":"IF(AND(($AX$1-$A7)<AY$3,$A7<$AX$1),((AY$3-($AX$1-$A7))/AY$3*AH7),0)","v":0},{"$f":"SUM(AL7:AY7)","v":0},null,null,{"$f":"IF(AND(($BO$1-$A7)<BC$3,$A7<$BO$1),((BC$3-($BO$1-$A7))/(BC$3-(2001-$A7))*AL7),0)","v":0},{"$f":"IF(AND(($BO$1-$A7)<BD$3,$A7<$BO$1),((BD$3-($BO$1-$A7))/(BD$3-(2001-$A7))*AM7),0)","v":0},{"$f":"IF(AND(($BO$1-$A7)<BE$3,$A7<$BO$1),((BE$3-($BO$1-$A7))/(BE$3-(2001-$A7))*AN7),0)","v":0},0,{"$f":"IF(AND(($BO$1-$A7)<BG$3,$A7<$BO$1),((BG$3-($BO$1-$A7))/(BG$3-(2001-$A7))*AP7),0)","v":0},{"$f":"IF(AND(($BO$1-$A7)<BH$3,$A7<$BO$1),((BH$3-($BO$1-$A7))/(BH$3-(2001-$A7))*AQ7),0)","v":0},{"$f":"IF(AND(($BO$1-$A7)<BI$3,$A7<$BO$1),((BI$3-($BO$1-$A7))/(BI$3-(2001-$A7))*AR7),0)","v":0},{"$f":"IF(AND(($BO$1-$A7)<BJ$3,$A7<$BO$1),((BJ$3-($BO$1-$A7))/(BJ$3-(2001-$A7))*AS7),0)","v":0},{"$f":"IF(AND(($BO$1-$A7)<BK$3,$A7<$BO$1),((BK$3-($BO$1-$A7))/(BK$3-(2001-$A7))*AT7),0)","v":0},{"$f":"IF(AND(($BO$1-$A7)<BL$3,$A7<$BO$1),((BL$3-($BO$1-$A7))/(BL$3-(2001-$A7))*AU7),0)","v":0},{"$f":"IF(AND(($BO$1-$A7)<BM$3,$A7<$BO$1),((BM$3-($BO$1-$A7))/(BM$3-(2001-$A7))*AV7),0)","v":0},{"$f":"IF(AND(($BO$1-$A7)<BN$3,$A7<$BO$1),((BN$3-($BO$1-$A7))/(BN$3-(2001-$A7))*AW7),0)","v":0},{"$f":"IF(AND(($BO$1-$A7)<BO$3,$A7<$BO$1),((BO$3-($BO$1-$A7))/(BO$3-(2001-$A7))*AX7),0)","v":0},{"$f":"IF(AND(($BO$1-$A7)<BP$3,$A7<$BO$1),((BP$3-($BO$1-$A7))/(BP$3-(2001-$A7))*AY7),0)","v":0},{"$f":"SUM(BC7:BP7)","v":0},null,null,{"$f":"IF(AND(($CE$1-$A7)<BT$3,$A7<$CE$1),((BT$3-($CE$1-$A7))/(BT$3-(2006-$A7))*BC7),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(BT7:CG7)","v":0}]
[1951,null,98142.91,1262213.4500000002,0,0,0,0,0,0,15366.37,0,0,0,-1133288.780175,0,242433.94982500025,null,{"$f":"Inflation!O8","v":28.765511551155118},null,{"$f":"+C8*$S8","v":2823131.0112689771},{"$f":"+D8*$S8","v":36308215.575998358},{"$f":"+E8*$S8","v":0},{"$f":"+F8*$S8","v":0},{"$f":"+G8*$S8","v":0},{"$f":"+H8*$S8","v":0},{"$f":"+I8*$S8","v":0},{"$f":"+J8*$S8","v":0},{"$f":"+K8*$S8","v":442021.49373432348},{"$f":"+L8*$S8","v":0},{"$f":"+M8*$S8","v":0},{"$f":"+N8*$S8","v":0},{"$f":"+O8*$S8","v":-32599631.496918455},{"$f":"+P8*$S8","v":0},{"$f":"SUM(U8:AG8)","v":6973736.584083207},null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AL8:AY8)","v":0},null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(AND(($CE$1-$A8)<BT$3,$A8<$CE$1),((BT$3-($CE$1-$A8))/(BT$3-(2006-$A8))*BC8),0)","v":0},{"$f":"IF(AND(($CE$1-$A8)<BU$3,$A8<$CE$1),((BU$3-($CE$1-$A8))/(BU$3-(2006-$A8))*BD8),0)","v":0},{"$f":"IF(AND(($CE$1-$A8)<BV$3,$A8<$CE$1),((BV$3-($CE$1-$A8))/(BV$3-(2006-$A8))*BE8),0)","v":0},{"$f":"IF(AND(($CE$1-$A8)<BW$3,$A8<$CE$1),((BW$3-($CE$1-$A8))/(BW$3-(2006-$A8))*BF8),0)","v":0},{"$f":"IF(AND(($CE$1-$A8)<BX$3,$A8<$CE$1),((BX$3-($CE$1-$A8))/(BX$3-(2006-$A8))*BG8),0)","v":0},{"$f":"IF(AND(($CE$1-$A8)<BY$3,$A8<$CE$1),((BY$3-($CE$1-$A8))/(BY$3-(2006-$A8))*BH8),0)","v":0},{"$f":"IF(AND(($CE$1-$A8)<BZ$3,$A8<$CE$1),((BZ$3-($CE$1-$A8))/(BZ$3-(2006-$A8))*BI8),0)","v":0},{"$f":"IF(AND(($CE$1-$A8)<CA$3,$A8<$CE$1),((CA$3-($CE$1-$A8))/(CA$3-(2006-$A8))*BJ8),0)","v":0},{"$f":"IF(AND(($CE$1-$A8)<CB$3,$A8<$CE$1),((CB$3-($CE$1-$A8))/(CB$3-(2006-$A8))*BK8),0)","v":0},{"$f":"IF(AND(($CE$1-$A8)<CC$3,$A8<$CE$1),((CC$3-($CE$1-$A8))/(CC$3-(2006-$A8))*BL8),0)","v":0},{"$f":"IF(AND(($CE$1-$A8)<CD$3,$A8<$CE$1),((CD$3-($CE$1-$A8))/(CD$3-(2006-$A8))*BM8),0)","v":0},{"$f":"IF(AND(($CE$1-$A8)<CE$3,$A8<$CE$1),((CE$3-($CE$1-$A8))/(CE$3-(2006-$A8))*BN8),0)","v":0},{"$f":"IF(AND(($CE$1-$A8)<CF$3,$A8<$CE$1),((CF$3-($CE$1-$A8))/(CF$3-(2006-$A8))*BO8),0)","v":0},{"$f":"IF(AND(($CE$1-$A8)<CG$3,$A8<$CE$1),((CG$3-($CE$1-$A8))/(CG$3-(2006-$A8))*BP8),0)","v":0},{"$f":"SUM(BT8:CG8)","v":0}]
[1952,null,635771.83000000007,2314774.0299999998,0,0,0,0,0,0,41555.99,0,0,0,-1133288.780175,0,1858813.0698250001,null,{"$f":"Inflation!O9","v":26.654281345565753},null,16946041.228405204,{"$f":"+D9*$S9","v":61698638.247029059},{"$f":"+E9*$S9","v":0},0,0,0,0,0,1107645.0490535169,0,0,0,-30206997.99255747,0,49545326.531930313,null,null,0,0,0,0,0,0,0,0,22152.900981070339,0,0,0,0,0,22152.900981070339,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1953,null,88938.790000000008,3258531.48,0,0,0,0,0,0,495.89,0,0,0,-1133288.780175,0,2214677.3798250002,null,{"$f":"Inflation!O10","v":24.517440225035166},null,2180551.4675119556,79890850.782295376,0,0,0,0,0,0,12157.953433192688,0,0,0,-27785339.925643582,0,54298220.277596936,null,null,0,0,0,0,0,0,0,0,486.31813732770752,0,0,0,0,0,486.31813732770752,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1954,null,133577.72,2327058.17,0,0,0,0,0,0,40225.300000000003,0,0,0,-1133288.780175,0,1367572.409825,null,{"$f":"Inflation!O11","v":23.284445334936226},null,3110283.1193054174,54184258.750581726,0,0,0,0,0,0,936623.7989314103,0,0,0,-26388000.650681343,0,31843165.018137213,null,null,0,0,0,0,0,0,0,0,56197.427935884618,0,0,0,0,0,56197.427935884618,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1955,null,61203.929999999993,3488740.09,0,0,0,0,0,0,380807.15,0,0,0,-1133288.780175,0,2797462.389825,null,{"$f":"Inflation!O12","v":23.214675722466382},null,1420829.3878905317,80989969.869318172,0,0,0,0,0,0,8840314.5000466146,0,0,0,-26308931.531672113,0,64942182.225583203,null,null,0,0,0,0,0,0,0,0,707225.16000372916,0,0,0,0,0,707225.16000372916,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1956,null,122537.32999999999,1805001.52,0,0,0,0,0,0,0,0,0,0,-1133288.780175,0,794250.06982500013,null,{"$f":"Inflation!O13","v":22.627076843198342},null,2772661.582070353,40841908.09512981,0,0,0,0,0,0,0,0,0,0,-25643012.314554237,0,17971557.362645924,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1957,null,72223.97,2225517.0399999996,0,0,0,0,0,0,11480.97,0,0,0,-1133288.780175,0,1175933.199825,null,{"$f":"Inflation!O14","v":21.701711795829443},null,1567383.7816906318,48297529.398787417,0,0,0,0,0,0,249156.70207656393,0,0,0,-24594306.488804959,0,25519763.393749654,null,null,0,0,0,0,0,0,0,0,29898.804249187669,0,0,0,0,0,29898.804249187669,null,null,0,0,0,0,0,0,0,0,4983.1340415312779,0,0,0,0,0,4983.1340415312779,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1958,null,37688.370000000003,1139886.5199999998,0,0,0,0,0,0,0,0,0,0,-1133288.780175,0,44286.109824999934,null,{"$f":"Inflation!O15","v":20.84906111709126},null,785767.12953354884,23765563.722028464,0,0,0,0,0,0,0,0,0,0,-23628007.041182376,0,923323.81037963554,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1959,null,43444.93,1208564.75,0,0,0,0,0,0,11962.2,0,0,0,-1133288.780175,0,130683.09982499992,null,{"$f":"Inflation!O16","v":19.960952708118636},null,867202.19313752465,24124103.819449224,0,0,0,0,0,0,238776.90848505677,0,0,0,-22621523.745714631,0,2608559.1753571741,null,null,0,0,0,0,0,0,0,0,38204.305357609082,0,0,0,0,0,38204.305357609082,null,null,0,0,0,0,0,0,0,0,14326.614509103405,0,0,0,0,0,14326.614509103405,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1960,null,19957.740000000002,829406.33,0,0,0,0,0,0,892.63,0,0,0,-1133288.780175,0,-283032.08017500001,null,{"$f":"Inflation!O17","v":19.960952708118636},null,398375.50430092769,16555740.528944239,0,0,0,0,0,0,17817.745215847939,0,0,0,-22621523.745714631,0,-5649589.9672536179,null,null,0,0,0,0,0,0,0,0,3207.1941388526288,0,0,0,0,0,3207.1941388526288,null,null,0,0,0,0,0,0,0,0,1425.4196172678351,0,0,0,0,0,1425.4196172678351,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1961,null,3920.95,1291001.76,0,0,0,0,0,0,42840.959999999999,0,0,0,-1133288.780175,0,204474.88982499996,null,{"$f":"Inflation!O18","v":19.872207022343829},null,77917.93012425903,25655054.240930244,0,0,0,0,0,0,851344.42615595111,0,0,0,-22520949.255737107,0,4063367.3414733484,null,null,0,0,0,0,0,0,0,0,170268.88523119024,0,0,0,0,0,170268.88523119024,null,null,0,0,0,0,0,0,0,0,85134.442615595122,0,0,0,0,0,85134.442615595122,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1962,null,227247.56,2039974.2199999997,0,0,0,0,0,0,0,0,0,0,-1133288.780175,0,1133932.9998249998,null,{"$f":"Inflation!O19","v":19.336550194120914},null,4394183.8504315037,39446063.899742655,0,0,0,0,0,0,0,0,0,0,-21913895.382287949,0,21926352.367886208,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1963,null,354047.76999999996,1980843.2799999998,0,0,0,0,0,0,10268.370000000001,0,0,0,-1133288.780175,0,1211870.639825,null,{"$f":"Inflation!O20","v":18.546547505053731},null,6566363.7853633361,36737803.992586441,0,0,0,0,0,0,190442.81200446858,0,0,0,-21018594.198460031,0,22476016.391494218,null,null,0,0,0,0,0,0,0,0,45706.274881072459,0,0,0,0,0,45706.274881072459,null,null,0,0,0,0,0,0,0,0,26661.993680625601,0,0,0,0,0,26661.993680625601,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1964,null,235862.73,3710274.48,0,0,0,0,0,0,0,0,0,0,-1133288.780175,0,2812848.429825,null,{"$f":"Inflation!O21","v":18.104481487251391},null,4270172.4288175739,67172595.635781288,0,0,0,0,0,0,0,0,0,0,-20517605.740387999,0,50925162.32421086,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1965,null,1033290.7,4548239.42,0,0,0,0,0,0,0,0,0,0,-1125058.340175,0,4456471.7798250001,null,{"$f":"Inflation!O22","v":16.960400856197701},null,17525024.472981121,77139963.753160134,0,0,0,0,0,0,0,0,0,0,-19081440.435976434,0,75583547.790164828,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1966,null,530589.27,5128232.2699999996,0,0,0,0,0,0,0,0,0,0,-1133288.780175,0,4525532.7598249987,null,{"$f":"Inflation!O23","v":16.149620159347787},null,8568815.1711256262,82819003.249409854,0,0,0,0,0,0,0,0,0,0,-18302183.330676842,0,73085635.089858636,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,{"$f":"IF(AND(($CE$1-$A23)<BU$3,$A23<$CE$1),((BU$3-($CE$1-$A23))/(BU$3-(2006-$A23))*BD23),0)","v":0},{"$f":"IF(AND(($CE$1-$A23)<BV$3,$A23<$CE$1),((BV$3-($CE$1-$A23))/(BV$3-(2006-$A23))*BE23),0)","v":0},0,{"$f":"IF(AND(($CE$1-$A23)<BX$3,$A23<$CE$1),((BX$3-($CE$1-$A23))/(BX$3-(2006-$A23))*BG23),0)","v":0},{"$f":"IF(AND(($CE$1-$A23)<BY$3,$A23<$CE$1),((BY$3-($CE$1-$A23))/(BY$3-(2006-$A23))*BH23),0)","v":0},{"$f":"IF(AND(($CE$1-$A23)<BZ$3,$A23<$CE$1),((BZ$3-($CE$1-$A23))/(BZ$3-(2006-$A23))*BI23),0)","v":0},{"$f":"IF(AND(($CE$1-$A23)<CA$3,$A23<$CE$1),((CA$3-($CE$1-$A23))/(CA$3-(2006-$A23))*BJ23),0)","v":0},{"$f":"IF(AND(($CE$1-$A23)<CB$3,$A23<$CE$1),((CB$3-($CE$1-$A23))/(CB$3-(2006-$A23))*BK23),0)","v":0},{"$f":"IF(AND(($CE$1-$A23)<CC$3,$A23<$CE$1),((CC$3-($CE$1-$A23))/(CC$3-(2006-$A23))*BL23),0)","v":0},{"$f":"IF(AND(($CE$1-$A23)<CD$3,$A23<$CE$1),((CD$3-($CE$1-$A23))/(CD$3-(2006-$A23))*BM23),0)","v":0},{"$f":"IF(AND(($CE$1-$A23)<CE$3,$A23<$CE$1),((CE$3-($CE$1-$A23))/(CE$3-(2006-$A23))*BN23),0)","v":0},{"$f":"IF(AND(($CE$1-$A23)<CF$3,$A23<$CE$1),((CF$3-($CE$1-$A23))/(CF$3-(2006-$A23))*BO23),0)","v":0},{"$f":"IF(AND(($CE$1-$A23)<CG$3,$A23<$CE$1),((CG$3-($CE$1-$A23))/(CG$3-(2006-$A23))*BP23),0)","v":0},0]
[1967,null,849018.04,5295909.3100000005,0,0,0,0,0,0,258532.63,0,0,0,-1133288.780175,0,5270171.199825,null,{"$f":"Inflation!O24","v":15.681104664237846},null,13313540.747066075,83045708.18242164,0,0,0,0,0,0,4054077.2301506773,0,0,0,-17771219.976730611,0,82642106.18290779,null,null,0,0,0,0,0,0,0,0,1297304.7136482168,0,0,0,0,0,1297304.7136482168,null,null,0,0,0,0,0,0,0,0,891896.99063314905,0,0,0,0,0,891896.99063314905,null,null,0,0,0,0,0,0,0,0,81081.54460301355,0,0,0,0,0,81081.54460301355]
[1968,null,2095221.65,5974407.2100000009,0,0,0,0,0,0,24460.23,0,0,0,-1133288.780175,0,6960800.3098250013,null,{"$f":"Inflation!O25","v":15.207101107912417},null,31862247.475037079,90853414.502310947,0,0,0,0,0,0,371969.19073279254,0,0,0,-17234037.064583953,0,105853594.10349686,null,null,0,0,0,0,0,0,0,0,126469.52484914947,0,0,0,0,0,126469.52484914947,null,null,0,0,0,0,0,0,0,0,89272.605775870223,0,0,0,0,0,89272.605775870223,null,null,0,0,0,0,0,0,0,0,14878.767629311704,0,0,0,0,0,14878.767629311704]
[1969,null,57142.3,5806671.0599999996,0,0,0,0,0,0,12252.97,0,0,0,-1133288.780175,0,4742777.5498249996,null,{"$f":"Inflation!O26","v":14.513883685108862},null,829356.6956995962,84277348.362527773,0,0,0,0,0,0,177838.18137712832,0,0,0,-16448421.537098855,0,68836121.702505648,null,null,0,0,0,0,0,0,0,0,64021.745295766195,0,0,0,0,0,64021.745295766195,null,null,0,0,0,0,0,0,0,0,46237.92715805336,0,0,0,0,0,46237.92715805336,null,null,0,0,0,0,0,0,0,0,10670.2908826277,0,0,0,0,0,10670.2908826277]
[1970,null,690591.56,8258520.0800000001,0,0,0,0,0,0,64708.4,0,0,0,-2538540.2030000002,0,6475279.8370000012,null,{"$f":"Inflation!O27","v":13.51624408777235},null,9334204.0899154842,111624173.20504923,0,0,0,0,0,0,874614.52892920829,0,0,0,-34311529.010371171,0,87521462.813522756,null,null,0,0,0,0,0,0,0,0,332353.52099309914,0,0,0,0,0,332353.52099309914,null,null,0,0,0,0,0,0,0,0,244892.06810017829,0,0,0,0,0,244892.06810017829,null,null,0,0,0,0,0,0,0,0,69969.162314336645,0,0,0,0,0,69969.162314336645]
[1971,null,511192.28,11050340.550000003,0,0,0,0,0,0,211027.24,0,0,0,-1939524.7949999999,0,9833035.2750000022,null,{"$f":"Inflation!O28","v":12.490613356262539},null,6385105.1201863,138025531.26507956,0,0,0,0,0,0,2635859.6624792204,0,0,0,-24225854.309229363,0,122820641.73851572,null,null,0,0,0,0,0,0,0,0,1054343.8649916882,0,0,0,0,0,1054343.8649916882,null,null,0,0,0,0,0,0,0,0,790757.89874376613,0,0,0,0,0,790757.89874376613,null,null,0,0,0,0,0,0,0,0,263585.96624792204,0,0,0,0,0,263585.96624792204]
[1972,null,2361752.17,10192632.26,0,0,0,0,0,0,110455.71,0,0,0,-2036977.1865000001,0,10627862.953500001,null,{"$f":"Inflation!O29","v":11.461945622513728},null,27070274.946393795,116827396.7143992,0,0,0,0,0,0,1266037.3417161459,0,0,0,-23347721.745964006,0,121815987.25654514,null,null,902342.49821312644,0,0,0,0,0,0,0,531735.68352078123,0,0,0,0,0,1434078.1817339077,null,null,492186.81720715982,0,0,0,0,0,0,0,405131.94934916665,0,0,0,0,0,897318.76655632653,null,null,44744.2561097418,0,0,0,0,0,0,0,151924.4810059375,0,0,0,0,0,196668.73711567931]
[1973,null,144772.70000000001,12954114.609999999,0,0,0,0,0,0,195964.38,61070.59,4243.0225,0,-2271561.2820000001,0,11088604.020500001,null,{"$f":"Inflation!O30","v":10.555192249470183},null,1528103.6809748721,136733170.13022044,0,0,0,0,0,0,2068441.7049482297,644611.81823857129,44785.918206327602,0,-23976766.037962954,0,117042347.21462549,null,null,101873.57873165814,0,0,0,0,0,0,0,910114.35017722112,0,0,0,0,0,1011987.9289088793,null,null,59426.254260133923,0,0,0,0,0,0,0,703270.1796823981,0,0,0,0,0,762696.43394253205,null,null,9904.3757100223193,0,0,0,0,0,0,0,289581.83869275212,0,0,0,0,0,299486.21440277447]
[1974,null,1651595.3199999998,16310329.75,0,0,0,0,0,0,512916.37,10030.93,0,0,-2427739.0559999999,0,16057133.314000001,null,{"$f":"Inflation!O31","v":9.4728290403217041},null,15645280.110155417,154504965.31302303,0,0,0,0,0,0,4858769.084992392,95021.285005434198,0,0,-22997557.031999998,0,152106478.76117623,null,null,1564528.0110155419,0,0,0,0,0,0,0,2235033.7790965005,0,0,0,0,0,3799561.7901120423,null,null,962786.46831725654,0,0,0,0,0,0,0,1749156.8705972612,0,0,0,0,0,2711943.3389145178,null,null,222181.49268859767,0,0,0,0,0,0,0,777403.05359878275,0,0,0,0,0,999584.54628738039]
[1975,null,2626095.87,16509149.66,0,0,0,0,0,0,289256.17,15104.8,0,0,-2420144.1825000001,0,17019462.317500003,null,{"$f":"Inflation!O32","v":8.0984436701509868},null,21267289.47561115,133698418.56360231,0,0,0,0,0,0,2342524.7989886175,122325.37194889662,0,0,-19599401.335619859,0,137831156.87453112,null,null,2835638.5967481532,0,0,0,0,0,0,0,1124411.9035145363,0,0,0,0,0,3960050.5002626898,null,null,1822910.5264809558,0,0,0,0,0,0,0,890159.4236156746,0,0,0,0,0,2713069.9500966305,null,null,520831.57899455877,0,0,0,0,0,0,0,421654.46381795109,0,0,0,0,0,942486.04281250993]
[1976,null,314233.27,17083970.18,0,0,0,0,0,0,1017170.27,0,0,0,-3072448.5255,0,15342925.194499999,null,{"$f":"Inflation!O33","v":6.6996810023444429},null,2105262.669323572,114457150.45956497,0,0,0,0,0,0,6814716.3340685675,0,0,0,-20584425.016973544,0,102792704.44598357,null,null,350877.11155392864,0,0,0,0,0,0,0,3407358.1670342837,0,0,0,0,0,3758235.2785882126,null,null,233918.07436928575,0,0,0,0,0,0,0,2725886.5336274272,0,0,0,0,0,2959804.6079967129,null,null,77972.691456428583,0,0,0,0,0,0,0,1362943.2668137136,0,0,0,0,0,1440915.9582701421]
[1977,null,425564.15,18542857.249999996,0,0,0,0,0,0,1955478.21,39556.15,0,0,-3480351.858,0,17483103.901999995,null,{"$f":"Inflation!O34","v":5.6788832421162363},null,2416729.1198804406,105302721.29797854,0,0,0,0,0,0,11104932.437092453,224634.75735763618,0,0,-19764511.843064308,0,99284505.76924476,null,null,483345.82397608814,4212108.8519191416,0,0,0,0,0,0,5774564.8672880763,0,0,0,-790580.47372257232,0,9679439.0694607347,null,null,332300.2539835606,2895824.8356944099,0,0,0,0,0,0,4664071.6235788306,0,0,0,-543524.07568426849,0,7348672.6375725325,null,null,124612.59524383523,1085934.3133854037,0,0,0,0,0,0,2443085.1361603402,0,0,0,-203821.52838160068,0,3449810.5164079783]
[1978,null,333571.62,20245103.32,0,0,0,0,0,0,1171040.07,31401.89,0,0,-15342879.123,0,6438237.7770000026,null,{"$f":"Inflation!O35","v":4.9973195728517172},null,1666963.9855738552,101171251.07544129,0,0,0,0,0,0,5852061.462404645,156925.27952153661,0,0,-76673270.145265892,0,32173931.65767543,null,null,388958.26330056624,8093700.0860353028,0,0,0,0,0,0,3160113.1896985085,0,0,0,-6133861.6116212718,0,5508909.927413106,null,null,274558.77409451734,5713200.0607308028,0,0,0,0,0,0,2574907.0434580436,0,0,0,-4329784.6670267805,0,4232881.2112565823,null,null,113053.61286244831,2352494.1426538597,0,0,0,0,0,0,1404494.7509771145,0,0,0,-1782852.5099522036,0,2087189.9965412186]
[1979,null,1106339.29,25536226.779999997,0,0,0,0,0,29511.25,1735434.91,58617.45,0,0,-15797445.327,0,12668684.352999996,null,{"$f":"Inflation!O36","v":4.6427496570918745},null,5136456.3592747683,118558308.12626533,0,0,0,0,0,137013.34581785259,8057189.8333077673,272146.14588710008,0,0,-73343583.874856889,0,58817529.935695946,null,null,1369721.6958066048,14226996.975151839,0,0,0,0,0,0,4512026.3066523504,0,0,0,-8801230.0649828259,0,11307514.912627971,null,null,989243.44697143685,10275053.370942995,0,0,0,0,0,0,3706307.3233215734,0,0,0,-6356443.9358209297,0,8614160.2054150756,null,null,439663.75420952745,4566690.3870857749,0,0,0,0,0,0,2094869.3566600196,0,0,0,-2825086.1936981906,0,4276137.3042571321]
[1980,null,1522339.45,32884789.860000003,0,0,0,0,0,5392.58,1030878.15,205984.53,14385.623800000001,0,-13280189.742000001,0,22383580.451800004,null,{"$f":"Inflation!O37","v":4.09993532075028},null,6241493.2812265549,134825511.46246466,0,0,0,0,0,22109.229211971546,4226533.7385747051,844523.25007514562,58980.127128645865,0,-54447918.989491351,0,91771232.099190354,null,null,1872447.9843679664,21572081.833994348,0,0,0,0,0,0,2451389.568373329,0,0,0,-8711667.0383186154,0,17184252.348417029,null,null,1379698.5147974489,15895218.193469519,0,0,0,0,0,0,2028736.1945158585,0,0,0,-6419123.080866348,0,12884529.821916476,null,null,653541.40174616,7529313.8811171399,0,0,0,0,0,0,1183429.4468009176,0,0,0,-3040637.2488314277,0,6325647.48083279]
[1981,null,4386656.5999999996,36803953.119999997,0,0,0,0,0,0,3928916.06,285094.28999999998,0,0,-15939053.487500001,0,29465566.5825,null,{"$f":"Inflation!O38","v":3.467896113713905},null,15212469.375337452,127632285.99415675,0,0,0,0,0,0,13625072.735582149,988677.38033302501,0,0,-55274981.645579316,0,102183523.83983007,null,null,5070823.1251124833,25526457.19883135,0,0,0,0,0,0,8175043.6413492886,0,0,0,-11054996.329115864,0,27717327.636177253,null,null,3803117.3438343625,19144842.899123512,0,0,0,0,0,0,6812536.3677910743,0,0,0,-8291247.2468368979,0,21469249.363912053,null,null,1901558.6719171812,9572421.4495617561,0,0,0,0,0,0,4087521.8206746443,0,0,0,-4145623.623418449,0,11415878.318735134]
[1982,null,6698911.8700000001,42381283.710000001,0,0,0,0,0,55732.61,3108323.89,300007.34000000003,23004.6849,0,-17191488.113000002,0,35375775.991899997,null,{"$f":"Inflation!O39","v":2.8802584184263584},null,19294597.307863761,122069049.18944339,0,0,0,0,0,160524.31913337304,8952776.0513682663,864098.6666246989,66259.437346470731,0,-49515928.362744927,0,101891376.60903502,null,null,{"$f":"IF(AND(($AX$1-$A39)<AL$3,$A39<$AX$1),((AL$3-($AX$1-$A39))/AL$3*U39),0)","v":7074685.6795500452},{"$f":"IF(AND(($AX$1-$A39)<AM$3,$A39<$AX$1),((AM$3-($AX$1-$A39))/AM$3*V39),0)","v":29296571.805466413},{"$f":"IF(AND(($AX$1-$A39)<AN$3,$A39<$AX$1),((AN$3-($AX$1-$A39))/AN$3*W39),0)","v":0},0,{"$f":"IF(AND(($AX$1-$A39)<AP$3,$A39<$AX$1),((AP$3-($AX$1-$A39))/AP$3*Y39),0)","v":0},{"$f":"IF(AND(($AX$1-$A39)<AQ$3,$A39<$AX$1),((AQ$3-($AX$1-$A39))/AQ$3*Z39),0)","v":0},{"$f":"IF(AND(($AX$1-$A39)<AR$3,$A39<$AX$1),((AR$3-($AX$1-$A39))/AR$3*AA39),0)","v":0},{"$f":"IF(AND(($AX$1-$A39)<AS$3,$A39<$AX$1),((AS$3-($AX$1-$A39))/AS$3*AB39),0)","v":0},{"$f":"IF(AND(($AX$1-$A39)<AT$3,$A39<$AX$1),((AT$3-($AX$1-$A39))/AT$3*AC39),0)","v":5550721.1518483255},{"$f":"IF(AND(($AX$1-$A39)<AU$3,$A39<$AX$1),((AU$3-($AX$1-$A39))/AU$3*AD39),0)","v":0},{"$f":"IF(AND(($AX$1-$A39)<AV$3,$A39<$AX$1),((AV$3-($AX$1-$A39))/AV$3*AE39),0)","v":0},{"$f":"IF(AND(($AX$1-$A39)<AW$3,$A39<$AX$1),((AW$3-($AX$1-$A39))/AW$3*AF39),0)","v":0},{"$f":"IF(AND(($AX$1-$A39)<AX$3,$A39<$AX$1),((AX$3-($AX$1-$A39))/AX$3*AG39),0)","v":-11883822.807058781},{"$f":"IF(AND(($AX$1-$A39)<AY$3,$A39<$AX$1),((AY$3-($AX$1-$A39))/AY$3*AH39),0)","v":0},30038155.829806,null,null,{"$f":"IF(AND(($BO$1-$A39)<BC$3,$A39<$BO$1),((BC$3-($BO$1-$A39))/(BC$3-(2001-$A39))*AL39),0)","v":5390236.7082286058},{"$f":"IF(AND(($BO$1-$A39)<BD$3,$A39<$BO$1),((BD$3-($BO$1-$A39))/(BD$3-(2001-$A39))*AM39),0)","v":22321197.566069648},{"$f":"IF(AND(($BO$1-$A39)<BE$3,$A39<$BO$1),((BE$3-($BO$1-$A39))/(BE$3-(2001-$A39))*AN39),0)","v":0},0,{"$f":"IF(AND(($BO$1-$A39)<BG$3,$A39<$BO$1),((BG$3-($BO$1-$A39))/(BG$3-(2001-$A39))*AP39),0)","v":0},{"$f":"IF(AND(($BO$1-$A39)<BH$3,$A39<$BO$1),((BH$3-($BO$1-$A39))/(BH$3-(2001-$A39))*AQ39),0)","v":0},{"$f":"IF(AND(($BO$1-$A39)<BI$3,$A39<$BO$1),((BI$3-($BO$1-$A39))/(BI$3-(2001-$A39))*AR39),0)","v":0},{"$f":"IF(AND(($BO$1-$A39)<BJ$3,$A39<$BO$1),((BJ$3-($BO$1-$A39))/(BJ$3-(2001-$A39))*AS39),0)","v":0},{"$f":"IF(AND(($BO$1-$A39)<BK$3,$A39<$BO$1),((BK$3-($BO$1-$A39))/(BK$3-(2001-$A39))*AT39),0)","v":4655443.5467114989},{"$f":"IF(AND(($BO$1-$A39)<BL$3,$A39<$BO$1),((BL$3-($BO$1-$A39))/(BL$3-(2001-$A39))*AU39),0)","v":0},{"$f":"IF(AND(($BO$1-$A39)<BM$3,$A39<$BO$1),((BM$3-($BO$1-$A39))/(BM$3-(2001-$A39))*AV39),0)","v":0},{"$f":"IF(AND(($BO$1-$A39)<BN$3,$A39<$BO$1),((BN$3-($BO$1-$A39))/(BN$3-(2001-$A39))*AW39),0)","v":0},{"$f":"IF(AND(($BO$1-$A39)<BO$3,$A39<$BO$1),((BO$3-($BO$1-$A39))/(BO$3-(2001-$A39))*AX39),0)","v":-9054341.1863304991},{"$f":"IF(AND(($BO$1-$A39)<BP$3,$A39<$BO$1),((BP$3-($BO$1-$A39))/(BP$3-(2001-$A39))*AY39),0)","v":0},23312536.634679258,null,null,2823457.3233578415,11692055.867941245,0,0,0,0,0,0,2864888.3364378456,0,0,0,-4742750.1452207379,0,12637651.382516194]
[1983,null,3593919.0300000003,34612142.18,0,0,0,0,0,30579.1,0,164763.74,0,0,-16377025.4925,0,22024378.557500005,null,{"$f":"Inflation!O40","v":2.4591109794461614},null,8837845.7459134981,85115098.856989592,0,0,0,0,0,75197.400551582105,0,405172.32204861264,0,0,-40272923.199276425,0,54160391.12622688,null,null,3535138.2983653992,23832227.679957088,0,0,0,0,0,0,0,0,0,0,-11276418.495797399,0,16090947.482525088,null,null,2731697.7760096267,18415812.298148658,0,0,0,0,0,0,0,0,0,0,-8713596.1103888992,0,12433913.963769386,null,null,1490016.9687325235,10044988.526262904,0,0,0,0,0,0,0,0,0,0,-4752870.6056666719,0,6782134.8893287545]
[1984,null,5277851.7299999995,47133201.210000008,0,0,0,0,0,31564.42,8160463.8300000001,13042.75,0,0,-16878944.668499999,0,43737179.271500006,null,{"$f":"Inflation!O41","v":2.2257846216706247},null,11747361.216091702,104908354.4233253,0,0,0,0,0,70255.600627952692,18163434.898513369,29030.35237429454,0,0,-37568895.473176681,0,97349541.017755926,null,null,5090523.1936397376,33570673.415464096,0,0,0,0,0,0,11987867.033018824,0,0,0,-12022046.551416539,0,38627017.090706117,null,null,3983887.7167615341,26272700.933841467,0,0,0,0,0,0,10171523.543167487,0,0,0,-9408558.1706738137,0,31019554.023096669,null,null,2251762.6225173888,14849787.484345175,0,0,0,0,0,0,6538836.5634648139,0,0,0,-5317880.7051634593,0,18322505.965163916]
[1985,null,7545396.959999999,34009357.389999993,0,0,0,0,0,0,237537.51,121059.36,0,0,-17449057.030499998,0,24464294.189499993,null,{"$f":"Inflation!O42","v":2.0498230265401394},null,15466728.432993965,69713163.895855039,0,0,0,0,0,0,486909.85766500863,248150.26370621228,0,0,-35767478.892531008,0,50147473.557689205,null,null,7217806.6020638505,25096739.002507813,0,0,0,0,0,0,331098.7032122059,0,0,0,-12876292.401311163,0,19769351.906472705,null,null,5714096.8933005482,19868251.710318685,0,0,0,0,0,0,282407.71744570503,0,0,0,-10193731.484371336,0,15671024.836693602,null,null,3333223.1877586534,11589813.4976859,0,0,0,0,0,0,185025.74591270328,0,0,0,-5946343.3658832796,0,9161719.0654739756]
[1986,null,2805191.6900000004,33005357.199999992,0,0,0,0,0,0,88493.119999999995,82275.210000000006,14960.804700000001,0,-18162332.352000002,0,17833945.672699992,null,{"$f":"Inflation!O43","v":1.9440057990409281},null,5453308.912781422,{"$f":"+D43*$S43","v":64162605.796217233},{"$f":"+E43*$S43","v":0},0,{"$f":"+G43*$S43","v":0},{"$f":"+H43*$S43","v":0},{"$f":"+I43*$S43","v":0},{"$f":"+J43*$S43","v":0},{"$f":"+K43*$S43","v":172031.13845522472},{"$f":"+L43*$S43","v":159943.48535731016},{"$f":"+M43*$S43","v":29083.891095118772},{"$f":"+N43*$S43","v":0},{"$f":"+O43*$S43","v":-35307679.416396663},{"$f":"+P43*$S43","v":0},34669293.807509646,null,null,2726654.456390711,25665042.318486895,0,0,0,0,0,0,120421.79691865729,0,0,0,-14123071.766558666,0,14389046.805237599,null,null,2181323.5651125689,20532033.854789518,0,0,0,0,0,0,103218.68307313482,0,0,0,-11298457.413246933,0,11518118.689728286,null,null,1308794.1390675413,12319220.31287371,0,0,0,0,0,0,68812.455382089873,0,0,0,-6779074.4479481596,0,6917752.4593751822]
[1987,null,1787226.1900000002,50918902.190000005,0,0,0,0,0,65928.61,994151.58,187026.05,300290.05859999999,0,-14741658.18,0,39511866.498599999,null,{"$f":"Inflation!O44","v":1.8726761955406592},null,3346895.9420598275,95354616.034276158,0,0,0,0,0,123462.93855208387,1861723.9986251353,350239.23178099707,562346.04449772963,0,-27606352.35648324,0,73992931.833308682,null,null,1785011.1690985747,41956031.055081509,0,0,0,0,0,0,1340441.2790100973,0,37489.736299848642,0,-12146795.036852626,0,32972178.202637404,null,null,1441739.7904257718,33887563.544488914,0,0,0,0,0,0,1154268.8791475839,0,0,0,-9810872.9143809676,0,26672699.299681298,null,null,887224.48641585966,20853885.258147024,0,0,0,0,0,0,781924.0794225568,0,0,0,-6037460.255003673,0,16485573.568981767]
[1988,null,1672278.08,52465543.219999999,0,0,0,0,0,0,3304204.15,168203.48,148307.41279999999,0,-12125997.9,0,45632538.442799993,null,{"$f":"Inflation!O45","v":1.8156810665833401},null,3036323.6479183403,95260693.472563922,0,0,0,0,0,0,5999380.9152810983,305403.87396942952,269278.96145491966,0,-22016944.800459344,0,82854136.070728377,null,null,1720583.4004870595,45725132.866830684,0,0,0,0,0,0,4439541.8773080129,0,35903.861527322617,0,-10568133.504220484,0,41353028.501932591,null,null,1401956.8448413077,37257515.669269443,0,0,0,0,0,0,3839603.7857799032,0,0,0,-8611071.744179653,0,33888004.555711001,null,null,882713.56897415675,23458435.791762244,0,0,0,0,0,0,2639727.6027236832,0,0,0,-5421785.9130020039,0,21559091.050458081]
[1989,null,996376.18,57928050.069999985,0,0,0,0,0,135959.75,2171557.56,166250.60999999999,738400.06460000004,0,-15019730.801999999,0,47116863.432599984,null,{"$f":"Inflation!O46","v":1.7776044216022195},null,1771162.7031471292,102973157.93922673,0,0,0,0,0,241682.65275993236,3860170.3204197274,295527.81943006616,1312583.2197443247,0,-26699139.884910248,0,83755144.76981768,null,null,1062697.6218882774,53546042.128397904,0,0,0,0,0,0,2933729.443518993,0,262516.64394886495,0,-13883552.740153329,0,43921433.097600721,null,null,872930.1894082278,43984248.891183995,0,0,0,0,0,0,2547712.4114770205,0,0,0,-11404346.893697377,0,36000544.598371863,null,null,561169.40747671796,28275588.572903998,0,0,0,0,0,0,1775678.347393075,0,0,0,-7331365.8602340287,0,23281070.467539765]
[1990,null,3171753.66,64882462.310000002,0,0,0,0,0,335492.75,6109579.8299999982,293086,1129549.8776999998,0,-18314700.912,0,57607223.515699998,null,{"$f":"Inflation!O47","v":1.7078544905896997},null,5416893.7312753163,110809804.61665045,0,0,0,0,0,572972.79964778747,10434273.34828175,500548.24122897274,1929106.830974991,0,-31278844.19636647,0,98384755.371692806,null,null,3430699.3631410333,62053490.585324258,0,0,0,0,0,0,8138733.2116597658,0,514428.48825999757,0,-17516152.749965224,0,56621198.898419827,null,null,2839199.4729443034,51354612.898199387,0,0,0,0,0,0,7095305.8768315911,0,0,0,-14496126.413764324,0,46792991.834210962,null,null,1860165.1719290263,33646125.691923738,0,0,0,0,0,0,5008451.2071752409,0,0,0,-9497462.1331559364,0,31017279.937872067]
[1991,null,2419623.04,86593877.49000001,0,0,0,0,159325.7107,290442.43,3055160.02,361283.65,616638.32170000009,0,-15545402.334000001,0,77950948.328400031,null,{"$f":"Inflation!O48","v":1.6530492257214116},null,3999755.9928096882,143143942.13705927,0,0,0,0,263373.24271014862,480115.63402814529,5050329.9055160126,597219.65789830545,1019333.5002363358,0,-25697315.291746527,0,128856754.77851135,null,null,2666503.9952064585,85886365.282235563,0,0,0,0,87791.08090338287,0,4040263.9244128102,0,339777.83341211191,0,-15418389.175047915,0,77602312.941122413,null,null,2222086.6626720489,71571971.068529636,0,0,0,0,0,0,3535230.9338612091,0,0,0,-12848657.645873263,0,64480631.019189626,null,null,1481391.1084480325,47714647.379019752,0,0,0,0,0,0,2525164.9527580068,0,0,0,-8565771.763915509,0,43155431.676310286]
[1992,null,1851909.17,50758966.789999999,0,0,0,0,2422136.4241999998,718916.81,1290707.81,324729.15999999997,1927300.4981000009,0,-16642507.982999999,0,42652158.679299995,null,{"$f":"Inflation!O49","v":1.6018727830769515},null,2966522.896153627,81309407.398007855,0,0,0,0,3879954.4148253091,1151613.271235504,2067549.7117438572,520174.80327544064,3087290.2127170432,0,-26659180.58010859,0,68323332.127850056,null,null,2076566.0273075388,52038020.734725028,0,0,0,0,1551981.7659301236,0,1695390.7636299629,0,1234916.0850868174,0,-17061875.571269497,0,41534999.805409975,null,null,1741636.0229030971,43644791.583962932,0,0,0,0,258663.62765502059,0,1488635.7924555773,0,205819.34751446955,0,-14309960.156548612,0,33029586.217942491,null,null,1179817.9509988721,29565826.556878112,0,0,0,0,0,0,1075125.8501068058,0,0,0,-9693843.977016801,0,22126926.380966991]
[1993,null,6956025.4399999995,105102669.73999999,0,0,0,0,940606.76899999997,1577861.65,3309484.68,494036.03,3410538.4493999998,0,-14243920.884,0,107547301.87439999,null,{"$f":"Inflation!O50","v":1.5533960683669288},null,10805462.569956334,163266073.94898376,0,0,0,0,1461134.85684392,2451044.0835369551,5140940.4902325841,767433.62663360615,5297917.0183122018,0,-22126450.699335188,0,167063555.89516419,null,null,7924005.8846346447,111020930.28530896,0,0,0,0,681862.93319382938,0,4318390.0117953708,0,2472361.275212361,0,-15045986.475547928,0,111371563.91459724,null,null,6685879.9651604816,93673909.928229436,0,0,0,0,194817.98091252267,0,3804295.9627721123,0,706388.93577496021,0,-12695051.088743564,0,92370241.684105948,null,null,4596542.4760478307,64400813.07565774,0,0,0,0,0,0,2776107.8647255953,0,0,0,-8727847.6235112008,0,63045615.792919956]
[1994,null,10121188.18,101425375.12000003,0,0,56883.5645,343253.55080000003,520943.11720000004,3090444.71,1036163.2,1740276.37,3399403.1306999996,0,-19359695.285999998,0,102374235.65720005,null,{"$f":"Inflation!O51","v":1.5318148665629749},null,15503786.521405458,155364897.45554253,0,0,87135.089764193879,525800.89211596933,797988.41156061832,4733989.1510689016,1587210.1939454651,2665781.2154942486,5207256.2530469792,0,-29655469.051223941,0,156818376.13272047,null,null,11886236.333077518,111862726.16799062,0,0,26140.526929258162,0,425593.81949899642,0,1365000.7667930999,0,2777203.3349583889,0,-21351937.716881238,0,106990963.23236665,null,null,10085291.434126379,94913828.263749629,0,0,0,0,159597.68231212365,0,1206279.7473985534,0,1041451.2506093958,0,-18116795.638565898,0,89289652.739630193,null,null,7029142.5146941431,66152062.123219445,0,0,0,0,0,0,888837.70860946039,0,0,0,-12626857.566273203,0,61443184.780249842]
[1995,null,6599715.0599999996,114724692.69999999,0,0,162029.17830000003,55208.529699999999,427636.10119999998,3323694.36,1879386.32,1065410.18,903201.68719999993,0,-22106138.579999998,0,107034835.53639998,null,{"$f":"Inflation!O52","v":1.4966986923559062},null,9877784.9002235811,{"$f":"+D52*$S52","v":171708297.54502317},0,0,{"$f":"+G52*$S52","v":242508.85928511203},82630.534208882207,640042.39347021794,4974569.0024027005,2812875.047575579,1594598.0232286707,1351820.7841658881,0,-33086228.705724448,0,160198898.3838594,null,null,7902227.9201788651,130498306.13421762,0,0,97003.543714044819,0,384025.43608213076,710652.71462895721,2475330.0418665097,0,811092.47049953288,0,-25145533.816350579,0,117733104.44483709,null,null,6740135.578976091,111307378.76153855,0,0,0,0,170677.97159205811,0,2194042.5371089517,0,360485.54244423681,0,-21447661.196299024,0,99325059.195360869,null,null,4757742.7616301822,78569914.419909567,0,0,0,0,0,0,1631467.527593836,0,0,0,-15139525.550328724,0,69819599.158804864]
[1996,null,5899441.4300000006,121523642.41999997,0,0,22879.050500000001,247898.29250000001,338531.43559999997,3858744.23,6151835.2699999996,1435165.95,439186.46349999995,0,-28316670.855,0,111600653.68709998,null,{"$f":"Inflation!O53","v":1.4600131495743141},null,8613262.0629434958,177426115.91736686,0,0,33403.714579774787,361934.76680701959,494260.34752027004,5633817.3166440111,8981760.3882150501,2095361.1588213125,641218.0118250394,0,-41342711.800467737,0,162938421.88425508,null,null,7177718.3857862465,141940892.73389348,0,0,16701.857289887394,0,329506.89834684669,1609662.0904697173,8083584.3493935456,0,427478.67455002625,0,-33074169.440374192,0,126511375.54935554,null,null,6152330.0449596392,121663622.34333727,0,0,0,0,164753.44917342335,0,7185408.3105720403,0,213739.33727501312,0,-28349288.091749307,0,107030565.39356804,null,null,4394521.4606854571,86902587.388098046,0,0,0,0,0,0,5389056.2329290304,0,0,0,-20249491.494106647,0,76436673.587605894]
[1997,null,4924663.9400000004,141074173.74000001,0,0,17338.27,224840.13,0,5917408.9600000056,2458777.7400000002,621269.19999999995,529492.21,0,-34155952.200000003,0,121612011.99000002,null,{"$f":"Inflation!O54","v":1.4356814007692373},null,7070248.4236969519,202537567.36740598,0,0,24892.231760515246,322798.79278753744,0,8495513.9846172445,3530021.46994342,891944.6353107834,760182.11774919915,0,-49037065.299103118,0,174596103.72416851,null,null,6127548.633870692,170131556.58862102,0,0,14935.339056309147,64559.758557507492,0,3640934.5648359619,3247619.7523479466,178388.9270621567,557466.88634941273,0,-41191134.851246618,0,142771875.59945437,null,null,5276500.2124997629,146502173.72909033,0,0,2489.2231760515242,0,0,0,2894617.6053536045,0,304072.84709967964,0,-35470143.899684593,0,119509709.71753486,null,null,3810805.7090276065,105807125.47100969,0,0,0,0,0,0,2188613.3113649203,0,0,0,-25617326.149772204,0,86189218.341630012]
[1998,null,14761618.449999999,189654100.91999999,5463651.21,0,51706.27,173627.79,0,12421795.290000005,4260430.76,3010951.51,1200717.6599999999,0,-36918054.093999997,0,194080545.76599997,null,{"$f":"Inflation!O55","v":1.4152256157955414},null,20891020.561040074,268403341.76265675,7732299.1481643049,0,73176.037801240527,245722.49602196895,0,17579642.888576411,6029470.7458752664,4261175.704870265,1699286.3897700815,0,-52247375.839154251,0,274667759.89562219,null,null,18801918.504936066,236194940.75113794,3092919.6592657221,0,51223.226460868369,98288.998408787593,0,10045510.222043663,5667702.5011227503,1704470.2819481061,1359429.1118160654,0,-45977690.738455743,0,231038712.51868424,null,null,16261118.706971733,204276705.5144977,0,0,14635.207560248105,0,0,0,5064755.4265352236,0,793000.31522603822,0,-39764489.287313074,0,186645725.88347787,null,null,11866221.759141535,149066785.10517401,0,0,0,0,0,0,3858861.2773601701,0,0,0,-29017330.020471703,0,135774538.12120402]
[1999,null,15187269.750000002,230993452.72999993,1978822.46,0,252274.56,355029.69,0,10152016.839999998,523000.39,6032700.2799999993,0,-8931841.2025249507,-47552192.210524902,0,208990533.28695005,null,{"$f":"Inflation!O56","v":1.3817240736997713},null,20984616.227347311,319169214.50407106,2734186.630559803,0,348573.8327340174,490553.06955116696,0,14027286.064433478,722642.22941736924,8335527.2062913505,0,-12341340.011992238,-65704008.734480999,0,288767251.01793236,null,null,19585641.812190823,293635677.34374541,1640511.9783358818,0,278859.06618721393,294331.84173070017,0,10019490.046023913,693736.5402406744,5001316.3237748099,0,-11354032.81103286,-60447688.035722524,0,259347844.10547403,null,null,17008583.679007821,254999404.00904208,0,0,104572.14982020523,0,0,0,621472.31729893747,0,0,-9860081.1253706422,-52494044.87312746,0,210379906.15667096,null,null,12532640.605584709,187894297.69087312,0,0,0,0,0,0,476943.87141546368,0,0,-7265322.9344836306,-38679822.538093917,0,154958736.69529575]
[2000,null,43427949.5,200787052.92000002,1564822.89,0,24586.29,349654.84,0,9740059.5900000054,856943.36,3978205.8,0,-1041058.38829017,-47132547.788290203,0,212555669.01341966,null,{"$f":"Inflation!O57","v":1.3594244716524997},null,59037017.303988941,272954833.33043349,2127258.5304679875,0,33423.204293145136,475329.34612773935,0,13240875.36199962,1164949.7744041178,5408070.3177899094,0,-1415240.2494607673,-64073138.874732599,0,288953378.04531157,null,null,57069116.72718931,262036639.99721614,1701806.8243743901,0,30080.883863830622,380263.47690219153,0,11349321.738856817,1141650.7789160355,4326456.2542319279,0,-1358630.6394823366,-61510213.319743291,0,275166492.72232503,null,null,49752563.300626576,228442198.97193202,0,0,13369.281717258054,0,0,1891553.6231428026,1025155.8014756237,0,0,-1184447.2241640883,-53624288.535160817,0,226316105.21956936,null,null,36995495.787645407,169867276.15861613,0,0,0,0,0,0,792165.84659480012,0,0,-880742.80771175795,-39874470.96204266,0,166899724.02310193]
[2000,"WIP",0,{"$f":"92493090.3300004+1830841.25075942","v":94323931.580759823},0,0,0,0,0,6463679.4300000099,13842791.51,6576622.9199999897,0,0,0,0,{"$f":"SUM(C58:P58)","v":121207025.44075982},null,{"$f":"Inflation!O58","v":1.2877605898083717},null,0,{"$f":"+D58*$S58","v":121466641.76548377},{"$f":"+E58*$S58","v":0},0,{"$f":"+G58*$S58","v":0},{"$f":"+H58*$S58","v":0},{"$f":"+I58*$S58","v":0},{"$f":"+J58*$S58","v":8323671.635109053},{"$f":"+K58*$S58","v":17826201.359511919},{"$f":"+L58*$S58","v":8469115.8104064427},{"$f":"+M58*$S58","v":0},{"$f":"+N58*$S58","v":0},{"$f":"+O58*$S58","v":0},{"$f":"+P58*$S58","v":0},156085630.57051119,null,null,0,116607976.09486441,0,0,0,0,0,7134575.6872363305,17469677.332321681,6775292.6483251546,0,0,0,0,147987521.76274756,null,null,0,101658235.5698818,0,0,0,0,0,1189095.9478727216,15687057.19637049,0,0,0,0,0,118534388.71412501,null,null,0,75592021.321194157,0,0,0,0,0,0,12121816.924468106,0,0,0,0,0,87713838.245662257]
[]
[2001,null,0,291831394.02004153,17981395.797674853,7447393.1602309719,1331955.2442722113,266391.04885444231,0,9323686.709905481,665977.62213610567,5993798.5992249511,0,-2131128.3908355385,-45020087.256400734,932368.67099054798,{"$f":"SUM(C60:P60)","v":288623145.2260949},null,{"$f":"Inflation!O59","v":1.2279271917837169},null,{"$f":"+C60*$S60","v":0},{"$f":"+D60*$S60","v":358347704.13335699},22079844.846190412,9144856.5693516787,1635544.0626807711,327108.81253615429,0,11448808.438765399,817772.03134038555,7359948.2820634702,0,-2616870.5002892343,-55281389.31861005,1144880.84387654,{"$f":"SUM(U60:AH60)","v":354408208.20126247},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(($BO$1-$A60)<BC$3,$A60<$BO$1),((BC$3-($BO$1-$A60))/BC$3*U60),0)","v":0},{"$f":"IF(AND(($BO$1-$A60)<BD$3,$A60<$BO$1),((BD$3-($BO$1-$A60))/BD$3*V60),0)","v":313554241.11668736},0,2612816.1626719083,817772.03134038555,0,0,3271088.1253615422,{"$f":"IF(AND(($BO$1-$A60)<BK$3,$A60<$BO$1),((BK$3-($BO$1-$A60))/BK$3*AC60),0)","v":735994.82820634707},{"$f":"IF(AND(($BO$1-$A60)<BL$3,$A60<$BO$1),((BL$3-($BO$1-$A60))/BL$3*AD60),0)","v":0},{"$f":"IF(AND(($BO$1-$A60)<BM$3,$A60<$BO$1),((BM$3-($BO$1-$A60))/BM$3*AE60),0)","v":0},{"$f":"IF(AND(($BO$1-$A60)<BN$3,$A60<$BO$1),((BN$3-($BO$1-$A60))/BN$3*AF60),0)","v":-2289761.6877530799},{"$f":"IF(AND(($BO$1-$A60)<BO$3,$A60<$BO$1),((BO$3-($BO$1-$A60))/BO$3*AG60),0)","v":-48371215.653783791},{"$f":"IF(AND(($BO$1-$A60)<BP$3,$A60<$BO$1),((BP$3-($BO$1-$A60))/BP$3*AH60),0)","v":1001770.7383919725},271332705.66112268,null,null,0,{"$f":"IF(AND(($CE$1-$A60)<BU$3,$A60<$CE$1),((BU$3-($CE$1-$A60))/(BU$3-(2006-$A60))*BD60),0)","v":235165680.83751553},{"$f":"IF(AND(($CE$1-$A60)<BV$3,$A60<$CE$1),((BV$3-($CE$1-$A60))/(BV$3-(2006-$A60))*BE60),0)","v":0},0,{"$f":"IF(AND(($CE$1-$A60)<BX$3,$A60<$CE$1),((BX$3-($CE$1-$A60))/(BX$3-(2006-$A60))*BG60),0)","v":0},{"$f":"IF(AND(($CE$1-$A60)<BY$3,$A60<$CE$1),((BY$3-($CE$1-$A60))/(BY$3-(2006-$A60))*BH60),0)","v":0},{"$f":"IF(AND(($CE$1-$A60)<BZ$3,$A60<$CE$1),((BZ$3-($CE$1-$A60))/(BZ$3-(2006-$A60))*BI60),0)","v":0},{"$f":"IF(AND(($CE$1-$A60)<CA$3,$A60<$CE$1),((CA$3-($CE$1-$A60))/(CA$3-(2006-$A60))*BJ60),0)","v":0},{"$f":"IF(AND(($CE$1-$A60)<CB$3,$A60<$CE$1),((CB$3-($CE$1-$A60))/(CB$3-(2006-$A60))*BK60),0)","v":572440.42193826998},{"$f":"IF(AND(($CE$1-$A60)<CC$3,$A60<$CE$1),((CC$3-($CE$1-$A60))/(CC$3-(2006-$A60))*BL60),0)","v":0},{"$f":"IF(AND(($CE$1-$A60)<CD$3,$A60<$CE$1),((CD$3-($CE$1-$A60))/(CD$3-(2006-$A60))*BM60),0)","v":0},{"$f":"IF(AND(($CE$1-$A60)<CE$3,$A60<$CE$1),((CE$3-($CE$1-$A60))/(CE$3-(2006-$A60))*BN60),0)","v":-1717321.2658148101},{"$f":"IF(AND(($CE$1-$A60)<CF$3,$A60<$CE$1),((CF$3-($CE$1-$A60))/(CF$3-(2006-$A60))*BO60),0)","v":-36278411.740337841},{"$f":"IF(AND(($CE$1-$A60)<CG$3,$A60<$CE$1),((CG$3-($CE$1-$A60))/(CG$3-(2006-$A60))*BP60),0)","v":751328.05379397934},198493716.30709511]
[2002,null,0,333120141.85513812,18808540.004367899,0,3630133.1855087331,278645.03710174665,0,9752576.2985611334,1114580.1484069866,6269513.3347892994,0,0,-45976431.121788189,278645.03710174665,{"$f":"SUM(C61:P61)","v":327276343.77918744},null,{"$f":"Inflation!O60","v":1.1735018108868636},null,{"$f":"+C61*$S61","v":0},390917089.70989347,22071855.755263746,0,4259967.8669549972,326990.45563353697,0,11444665.947173795,1307961.8225341479,7357285.2517545819,0,0,-53953425.179533593,326990.45563353697,{"$f":"SUM(U61:AH61)","v":384059382.08530813},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(($BO$1-$A61)<BC$3,$A61<$BO$1),((BC$3-($BO$1-$A61))/BC$3*U61),0)","v":0},351825380.73890412,4414371.1510527497,0,2555980.720172998,65398.091126707397,0,4904856.8345030546,1203324.8767314162,1471457.0503509166,0,0,-48558082.661580235,294291.41007018328,318176978.21133184,null,null,0,266014312.26600069,0,0,0,0,0,0,941732.51222458668,0,0,0,-36714647.866072863,222513.01737013858,230463909.92952254]
[2003,null,0,417897610.3533985,19466838.904520772,-3816046.966731898,2373495.0670015384,288397.61340030778,0,6344747.4948067702,1153590.4536012311,5335355.8479056936,0,0,-49171793.08475247,1441988.0670015386,401314183.75015193,null,{"$f":"Inflation!O61","v":1.1340255144193552},null,0,473906552.555632,22075892.002817884,-4327494.6244965605,2691603.9643282215,327050.25189359835,0,7195105.5416591624,1308201.0075743934,6050429.6600315692,0,0,-55762067.947858512,1635251.2594679913,455100523.67104971,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,438363561.11395961,8830356.8011271544,-2472854.0711408914,1884122.775029755,130820.10075743934,0,4111488.8809480928,1229708.9471199298,2420171.8640126279,0,0,-51579912.851769127,1512607.4150078921,404430070.97505242,null,null,0,333991284.65825492,0,0,0,0,0,0,968068.74560505117,0,0,0,-39298981.22039552,1152462.7923869654,296812834.97585142]
[2004,null,0,480465541.02018112,11052838.533566795,39550000,3060366.8044755724,294742.36089511454,0,10315982.631329009,1178969.4435804582,5452733.6765596187,0,0,-52169397.878435262,5157991.3156645047,504359767.90781689,null,{"$f":"Inflation!O62","v":1.109683045916646},null,0,533164465.01726383,12265147.529953277,43887964.466003351,3396037.1572126457,327070.60079875402,0,11447471.027956393,1308282.4031950161,6050806.1147769494,0,0,-57891496.341379449,5723735.5139781963,559679483.48975897,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,506506241.76640064,7359088.5179719655,31348546.047145251,2716829.7257701168,196242.36047925241,0,8176765.0199688524,1255951.1070672155,3630483.6688661696,0,0,-54996921.524310477,5437548.7382792858,511630775.42763835,null,null,0,388714092.51840049,0,0,0,0,0,0,994294.62642821227,0,0,0,-42206939.774470836,4173002.5200748011,351674449.89043266]
[2005,null,0,492720624.97039461,11321615.107344877,9332123.798623709,1509548.6809793166,301909.7361958634,0,10566840.766855219,6863468.0424987609,5585330.119623472,0,-2264323.0214689751,-53588978.174765758,6491059.3282110626,488839219.35449213,null,{"$f":"Inflation!O63","v":1.0833390301350454},null,0,533783483.98296076,12265147.529953277,10109853.945101185,1635353.0039937699,327070.60079875408,0,11447471.027956393,7435462.8125234861,6050806.1147769494,0,-2453029.5059906552,-58055031.641778849,7032017.9171732115,529578605.78746825,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,520438896.88338673,9812118.0239626225,8665589.0958010145,1471817.7035943929,261656.48063900328,0,9812118.0239626225,7286753.5562730161,4840644.8918215595,0,-2391703.7683408889,-56603655.850734375,6856217.4692438813,510450452.50960946,null,null,0,402157329.40988976,0,0,0,0,0,0,5799660.9937683186,0,0,-1848134.7300815959,-43739188.611931108,5297986.226233908,367667653.28787929]
[]
[2006,null,0,153777467.09345108,0,0,-3309376.8576001585,0,0,-5828324.1706264773,10998760.244990308,-12481565.58965501,0,0,-80248063.961228281,0,{"$f":"SUM(C66:P66)","v":62908896.759331465},null,{"$f":"Inflation!O64","v":1.0422847644501845},null,{"$f":"+C66*$S66","v":0},{"$f":"+D66*$S66","v":160279911.06724367},{"$f":"+E66*$S66","v":0},0,{"$f":"+G66*$S66","v":-3449313.0785006727},{"$f":"+H66*$S66","v":0},{"$f":"+I66*$S66","v":0},{"$f":"+J66*$S66","v":-6074773.4853207348},{"$f":"+K66*$S66","v":11463840.231193777},{"$f":"+L66*$S66","v":-13009345.6505831},{"$f":"+M66*$S66","v":0},{"$f":"+N66*$S66","v":0},{"$f":"+O66*$S66","v":-83641334.443412155},{"$f":"+P66*$S66","v":0},{"$f":"SUM(U66:AH66)","v":65568984.640620798},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($CE$1=2006,U66,IF(AND(($CE$1-$A66)<BT$3,$A66<$CE$1),((BT$3-($CE$1-$A66))/BT$3*U66),0))","v":0},{"$f":"IF($CE$1=2006,V66,IF(AND(($CE$1-$A66)<BU$3,$A66<$CE$1),((BU$3-($CE$1-$A66))/BU$3*V66),0))","v":124662153.05230063},{"$f":"IF($CE$1=2006,W66,IF(AND(($CE$1-$A66)<BV$3,$A66<$CE$1),((BV$3-($CE$1-$A66))/BV$3*W66),0))","v":0},null,{"$f":"IF($CE$1=2006,Y66,IF(AND(($CE$1-$A66)<BX$3,$A66<$CE$1),((BX$3-($CE$1-$A66))/BX$3*Y66),0))","v":0},0,0,0,9171072.1849550214,0,0,0,-65054371.233765014,0,{"$f":"SUM(BT66:CG66)","v":68778854.003490627}]
[]
[2006,null,{"$f":"'PR2 Allow Outturn Revised Capex'!C79","v":0},{"$f":"'PR2 Allow Outturn Revised Capex'!D79","v":560253130.5585022},{"$f":"'PR2 Allow Outturn Revised Capex'!E79","v":14041734.52373665},{"$f":"'PR2 Allow Outturn Revised Capex'!F79","v":0},{"$f":"'PR2 Allow Outturn Revised Capex'!G79","v":1264095.5815681},{"$f":"'PR2 Allow Outturn Revised Capex'!H79","v":0},{"$f":"'PR2 Allow Outturn Revised Capex'!I79","v":0},{"$f":"'PR2 Allow Outturn Revised Capex'!J79","v":22239946.016157478},{"$f":"'PR2 Allow Outturn Revised Capex'!K79","v":0},{"$f":"'PR2 Allow Outturn Revised Capex'!L79","v":0},{"$f":"'PR2 Allow Outturn Revised Capex'!M79","v":0},{"$f":"'PR2 Allow Outturn Revised Capex'!N79","v":0},{"$f":"'PR2 Allow Outturn Revised Capex'!O79","v":-130995770.95686242},{"$f":"'PR2 Allow Outturn Revised Capex'!P79","v":17354022.878750265},{"$f":"SUM(C68:P68)","v":484157158.60185224},null,{"$f":"Inflation!O64","v":1.0422847644501845},null,{"$f":"+C68*$S68","v":0},{"$f":"+D68*$S68","v":583943302.21664691},14635485.960544877,0,1317547.5654772262,0,0,23180356.894835517,0,0,0,0,-136534896.27574366,18087833.648441333,504629630.01020211,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(($CE$1-$A68)<(BT$3+1),$A68<$CE$1),((BT$3-($CE$1-$A68)+0.5)/BT$3*U68),0)","v":0},{"$f":"IF(AND(($CE$1-$A68)<(BU$3+1),$A68<$CE$1),((BU$3-($CE$1-$A68)+0.5)/BU$3*V68),0)","v":460666382.85979921},{"$f":"IF(AND(($CE$1-$A68)<(BV$3+1),$A68<$CE$1),((BV$3-($CE$1-$A68)+0.5)/BV$3*W68),0)","v":0},0,65877.378273861308,0,0,0,0,0,0,0,-107710862.61753111,14269290.989325941,367290688.60986787]
[2007,null,{"$f":"'PR2 Allow Outturn Revised Capex'!C80","v":0},{"$f":"'PR2 Allow Outturn Revised Capex'!D80","v":561870621.2967279},{"$f":"'PR2 Allow Outturn Revised Capex'!E80","v":18579726.241677091},{"$f":"'PR2 Allow Outturn Revised Capex'!F80","v":6036000},{"$f":"'PR2 Allow Outturn Revised Capex'!G80","v":2746074.7669235002},{"$f":"'PR2 Allow Outturn Revised Capex'!H80","v":0},{"$f":"'PR2 Allow Outturn Revised Capex'!I80","v":0},{"$f":"'PR2 Allow Outturn Revised Capex'!J80","v":16912924.336799413},{"$f":"'PR2 Allow Outturn Revised Capex'!K80","v":0},{"$f":"'PR2 Allow Outturn Revised Capex'!L80","v":0},{"$f":"'PR2 Allow Outturn Revised Capex'!M80","v":0},{"$f":"'PR2 Allow Outturn Revised Capex'!N80","v":0},{"$f":"'PR2 Allow Outturn Revised Capex'!O80","v":-180750041.09316295},{"$f":"'PR2 Allow Outturn Revised Capex'!P80","v":14625785.701099377},{"$f":"SUM(C69:P69)","v":440021091.25006431},null,{"$f":"Inflation!O65","v":0.99391910961852614},null,{"$f":"+C69*$S69","v":0},558453947.64005184,18466744.963083658,5999295.7456574235,2729376.1872865069,0,0,16810078.697877176,0,0,0,0,-179650919.90682852,14536847.901508065,437345371.22863615,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(($CE$1-$A69)<(BT$3+1),$A69<$CE$1),((BT$3-($CE$1-$A69)+0.5)/BT$3*U69),0)","v":0},{"$f":"IF(AND(($CE$1-$A69)<(BU$3+1),$A69<$CE$1),((BU$3-($CE$1-$A69)+0.5)/BU$3*V69),0)","v":452968201.97470874},0,0,409406.42809297604,0,0,0,0,0,0,0,-145716857.25776091,11790998.853445431,319451749.99848616]
[2008,null,{"$f":"'PR2 Allow Outturn Revised Capex'!C81","v":0},{"$f":"'PR2 Allow Outturn Revised Capex'!D81","v":515688016.98339367},{"$f":"'PR2 Allow Outturn Revised Capex'!E81","v":9024899.9778191522},{"$f":"'PR2 Allow Outturn Revised Capex'!F81","v":78000},{"$f":"'PR2 Allow Outturn Revised Capex'!G81","v":6693730.7745737899},{"$f":"'PR2 Allow Outturn Revised Capex'!H81","v":0},{"$f":"'PR2 Allow Outturn Revised Capex'!I81","v":0},{"$f":"'PR2 Allow Outturn Revised Capex'!J81","v":16812114.171473444},{"$f":"'PR2 Allow Outturn Revised Capex'!K81","v":-23810838.9280813},{"$f":"'PR2 Allow Outturn Revised Capex'!L81","v":0},{"$f":"'PR2 Allow Outturn Revised Capex'!M81","v":0},{"$f":"'PR2 Allow Outturn Revised Capex'!N81","v":0},{"$f":"'PR2 Allow Outturn Revised Capex'!O81","v":-138735566.75506133},{"$f":"'PR2 Allow Outturn Revised Capex'!P81","v":15450923.998497669},401201280.22261512,null,{"$f":"Inflation!O66","v":0.95520400670706984},null,0,492587260.03336114,8620620.6189434007,74505.912523151448,6393878.4556913022,0,0,16058998.817808144,-22744208.747159928,0,0,0,-132520769.23721074,14758784.510691393,383229070.36464787,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,410489383.36113429,0,0,1598469.6139228255,0,0,0,-19332577.435085937,0,0,0,-110433974.36434229,12298987.092242828,294620288.26787174]
[2009,null,{"$f":"'PR2 Allow Outturn Revised Capex'!C82","v":0},{"$f":"'PR2 Allow Outturn Revised Capex'!D82","v":394701064.99794102},{"$f":"'PR2 Allow Outturn Revised Capex'!E82","v":6930379.4221634082},{"$f":"'PR2 Allow Outturn Revised Capex'!F82","v":779685},{"$f":"'PR2 Allow Outturn Revised Capex'!G82","v":10190639.838762261},{"$f":"'PR2 Allow Outturn Revised Capex'!H82","v":0},{"$f":"'PR2 Allow Outturn Revised Capex'!I82","v":0},{"$f":"'PR2 Allow Outturn Revised Capex'!J82","v":19283339.630904227},{"$f":"'PR2 Allow Outturn Revised Capex'!K82","v":0},{"$f":"'PR2 Allow Outturn Revised Capex'!L82","v":0},{"$f":"'PR2 Allow Outturn Revised Capex'!M82","v":0},{"$f":"'PR2 Allow Outturn Revised Capex'!N82","v":0},{"$f":"'PR2 Allow Outturn Revised Capex'!O82","v":-98754611.574840009},{"$f":"'PR2 Allow Outturn Revised Capex'!P82","v":12872323.332633095},346002820.64756405,null,{"$f":"Inflation!O67","v":1},null,0,394701064.99794102,6930379.4221634082,779685,10190639.838762261,0,0,19283339.630904227,0,0,0,0,-98754611.574840009,12872323.332633095,346002820.64756405,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,337688688.94268286,0,55691.78571428571,3566723.9435667912,0,0,1377381.4022074447,0,0,0,0,-84490056.569585338,11012987.740141647,269211417.24472767]
[2010,null,{"$f":"'PR2 Allow Outturn Revised Capex'!C83","v":0},{"$f":"'PR2 Allow Outturn Revised Capex'!D83","v":327624888.34922481},{"$f":"'PR2 Allow Outturn Revised Capex'!E83","v":5174843.2630053833},{"$f":"'PR2 Allow Outturn Revised Capex'!F83","v":0},{"$f":"'PR2 Allow Outturn Revised Capex'!G83","v":5738087.9997232901},{"$f":"'PR2 Allow Outturn Revised Capex'!H83","v":0},{"$f":"'PR2 Allow Outturn Revised Capex'!I83","v":0},{"$f":"'PR2 Allow Outturn Revised Capex'!J83","v":10454522.365501376},{"$f":"'PR2 Allow Outturn Revised Capex'!K83","v":0},{"$f":"'PR2 Allow Outturn Revised Capex'!L83","v":0},{"$f":"'PR2 Allow Outturn Revised Capex'!M83","v":0},{"$f":"'PR2 Allow Outturn Revised Capex'!N83","v":0},{"$f":"'PR2 Allow Outturn Revised Capex'!O83","v":-39076517.572207913},{"$f":"'PR2 Allow Outturn Revised Capex'!P83","v":12761355.02804143},322677179.4332884,null,1,null,0,327624888.34922481,5174843.2630053833,0,5738087.9997232901,0,0,10454522.365501376,0,0,0,0,-39076517.572207913,12761355.02804143,322677179.4332884,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,287581846.43987513,0,0,2582139.5998754804,0,0,2240254.7926074374,0,0,0,0,-34300498.757826947,11201633.857947478,{"$f":"SUM(BT72:CG72)","v":269305375.93247861}]
[]
[2011,null,{"$f":"'PR2 Allow Outturn Revised Capex'!C85","v":0},{"$f":"'PR2 Allow Outturn Revised Capex'!D85","v":21952486.429504052},{"$f":"'PR2 Allow Outturn Revised Capex'!E85","v":0},{"$f":"'PR2 Allow Outturn Revised Capex'!F85","v":0},{"$f":"'PR2 Allow Outturn Revised Capex'!G85","v":0},{"$f":"'PR2 Allow Outturn Revised Capex'!H85","v":0},{"$f":"'PR2 Allow Outturn Revised Capex'!I85","v":0},{"$f":"'PR2 Allow Outturn Revised Capex'!J85","v":0},{"$f":"'PR2 Allow Outturn Revised Capex'!K85","v":0},{"$f":"'PR2 Allow Outturn Revised Capex'!L85","v":0},{"$f":"'PR2 Allow Outturn Revised Capex'!M85","v":0},{"$f":"'PR2 Allow Outturn Revised Capex'!N85","v":0},{"$f":"'PR2 Allow Outturn Revised Capex'!O85","v":0},{"$f":"'PR2 Allow Outturn Revised Capex'!P85","v":0},21952486.429504052,null,1,null,0,{"$f":"+D74*$S74","v":21952486.429504052},{"$f":"+E74*$S74","v":0},{"$f":"+F74*$S74","v":0},{"$f":"+G74*$S74","v":0},{"$f":"+H74*$S74","v":0},{"$f":"+I74*$S74","v":0},{"$f":"+J74*$S74","v":0},{"$f":"+K74*$S74","v":0},{"$f":"+L74*$S74","v":0},{"$f":"+M74*$S74","v":0},{"$f":"+N74*$S74","v":0},{"$f":"+O74*$S74","v":0},{"$f":"+P74*$S74","v":0},21952486.429504052,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($CE$1=2011,U74,IF(AND(($CE$1-$A74)<BT$3,$A74<$CE$1),((BT$3-($CE$1-$A74))/BT$3*U74),0))","v":0},{"$f":"IF($CE$1=2011,V74,IF(AND(($CE$1-$A74)<BU$3,$A74<$CE$1),((BU$3-($CE$1-$A74))/BU$3*V74),0))","v":19513321.270670269},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(BT74:CG74)","v":19513321.270670269}]
[]
[2011,null,{"$f":"SUMIF(Capex!$C$37:$C$67,C$4,Capex!$E$37:$E$67)*1000000","v":0},{"$f":"SUMIF(Capex!$C$37:$C$67,D$4,Capex!$E$37:$E$67)*1000000","v":360970351.73439246},{"$f":"SUMIF(Capex!$C$37:$C$67,E$4,Capex!$E$37:$E$67)*1000000","v":6772000},{"$f":"SUMIF(Capex!$C$37:$C$67,F$4,Capex!$E$37:$E$67)*1000000","v":0},{"$f":"SUMIF(Capex!$C$37:$C$67,G$4,Capex!$E$37:$E$67)*1000000","v":16061150.145114332},{"$f":"SUMIF(Capex!$C$37:$C$67,H$4,Capex!$E$37:$E$67)*1000000","v":356249.99999999994},{"$f":"SUMIF(Capex!$C$37:$C$67,I$4,Capex!$E$37:$E$67)*1000000","v":6000000},{"$f":"SUMIF(Capex!$C$37:$C$67,J$4,Capex!$E$37:$E$67)*1000000","v":7040000},{"$f":"SUMIF(Capex!$C$37:$C$67,K$4,Capex!$E$37:$E$67)*1000000","v":3545250.0000000005},{"$f":"SUMIF(Capex!$C$37:$C$67,L$4,Capex!$E$37:$E$67)*1000000","v":3580920},{"$f":"SUMIF(Capex!$C$37:$C$67,M$4,Capex!$E$37:$E$67)*1000000","v":0},{"$f":"SUMIF(Capex!$C$37:$C$67,N$4,Capex!$E$37:$E$67)*1000000","v":0},{"$f":"SUMIF(Capex!$C$37:$C$67,O$4,Capex!$E$37:$E$67)*1000000","v":-49957720.286673985},{"$f":"SUMIF(Capex!$C$37:$C$67,P$4,Capex!$E$37:$E$67)*1000000","v":0},354368201.59283286,null,1,null,0,360970351.73439246,6772000,0,16061150.145114332,356249.99999999994,6000000,7040000,3545250.0000000005,3580920,0,0,-49957720.286673985,0,354368201.59283286,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(AND(($CE$1-$A76)<(BU$3+1),$A76<$CE$1),((BU$3-($CE$1-$A76)+0.5)/BU$3*V76),0)","v":324873316.5609532},{"$f":"IF(AND(($CE$1-$A76)<(BV$3+1),$A76<$CE$1),((BV$3-($CE$1-$A76)+0.5)/BV$3*W76),0)","v":677200},{"$f":"IF(AND(($CE$1-$A76)<(BW$3+1),$A76<$CE$1),((BW$3-($CE$1-$A76)+0.5)/BW$3*X76),0)","v":0},{"$f":"IF(AND(($CE$1-$A76)<(BX$3+1),$A76<$CE$1),((BX$3-($CE$1-$A76)+0.5)/BX$3*Y76),0)","v":8833632.5798128843},{"$f":"IF(AND(($CE$1-$A76)<(BY$3+1),$A76<$CE$1),((BY$3-($CE$1-$A76)+0.5)/BY$3*Z76),0)","v":35624.999999999993},{"$f":"IF(AND(($CE$1-$A76)<(BZ$3+1),$A76<$CE$1),((BZ$3-($CE$1-$A76)+0.5)/BZ$3*AA76),0)","v":4200000},{"$f":"IF(AND(($CE$1-$A76)<(CA$3+1),$A76<$CE$1),((CA$3-($CE$1-$A76)+0.5)/CA$3*AB76),0)","v":2514285.7142857146},{"$f":"IF(AND(($CE$1-$A76)<(CB$3+1),$A76<$CE$1),((CB$3-($CE$1-$A76)+0.5)/CB$3*AC76),0)","v":3226177.5000000005},{"$f":"IF(AND(($CE$1-$A76)<(CC$3+1),$A76<$CE$1),((CC$3-($CE$1-$A76)+0.5)/CC$3*AD76),0)","v":358092},{"$f":"IF(AND(($CE$1-$A76)<(CD$3+1),$A76<$CE$1),((CD$3-($CE$1-$A76)+0.5)/CD$3*AE76),0)","v":0},{"$f":"IF(AND(($CE$1-$A76)<(CE$3+1),$A76<$CE$1),((CE$3-($CE$1-$A76)+0.5)/CE$3*AF76),0)","v":0},{"$f":"IF(AND(($CE$1-$A76)<(CF$3+1),$A76<$CE$1),((CF$3-($CE$1-$A76)+0.5)/CF$3*AG76),0)","v":-44961948.258006588},{"$f":"IF(AND(($CE$1-$A76)<(CG$3+1),$A76<$CE$1),((CG$3-($CE$1-$A76)+0.5)/CG$3*AH76),0)","v":0},299756381.09704524]
[2012,null,{"$f":"SUMIF(Capex!$C$37:$C$67,C$4,Capex!$F$37:$F$67)*1000000","v":0},{"$f":"SUMIF(Capex!$C$37:$C$67,D$4,Capex!$F$37:$F$67)*1000000","v":391921954.59349418},{"$f":"SUMIF(Capex!$C$37:$C$67,E$4,Capex!$F$37:$F$67)*1000000","v":6682000},{"$f":"SUMIF(Capex!$C$37:$C$67,F$4,Capex!$F$37:$F$67)*1000000","v":2500000},{"$f":"SUMIF(Capex!$C$37:$C$67,G$4,Capex!$F$37:$F$67)*1000000","v":21950572.196719002},{"$f":"SUMIF(Capex!$C$37:$C$67,H$4,Capex!$F$37:$F$67)*1000000","v":285000.00000000006},{"$f":"SUMIF(Capex!$C$37:$C$67,I$4,Capex!$F$37:$F$67)*1000000","v":5500000},{"$f":"SUMIF(Capex!$C$37:$C$67,J$4,Capex!$F$37:$F$67)*1000000","v":7040000},{"$f":"SUMIF(Capex!$C$37:$C$67,K$4,Capex!$F$37:$F$67)*1000000","v":3545250.0000000005},{"$f":"SUMIF(Capex!$C$37:$C$67,L$4,Capex!$F$37:$F$67)*1000000","v":3398640},{"$f":"SUMIF(Capex!$C$37:$C$67,M$4,Capex!$F$37:$F$67)*1000000","v":0},{"$f":"SUMIF(Capex!$C$37:$C$67,N$4,Capex!$F$37:$F$67)*1000000","v":0},{"$f":"SUMIF(Capex!$C$37:$C$67,O$4,Capex!$F$37:$F$67)*1000000","v":-84221445.54010509},{"$f":"SUMIF(Capex!$C$37:$C$67,P$4,Capex!$F$37:$F$67)*1000000","v":0},358601971.25010806,null,1,null,0,391921954.59349418,6682000,2500000,21950572.196719002,285000.00000000006,5500000,7040000,3545250.0000000005,3398640,0,0,-84221445.54010509,0,358601971.25010806,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,361439135.90288907,2004600,1250000,14267871.927867351,85500.000000000015,4216666.666666667,3520000,3297082.5000000005,1019592,0,0,-77670888.664763585,0,313429560.33265954]
[2013,null,{"$f":"SUMIF(Capex!$C$37:$C$67,C$4,Capex!$G$37:$G$67)*1000000","v":0},{"$f":"SUMIF(Capex!$C$37:$C$67,D$4,Capex!$G$37:$G$67)*1000000","v":383130949.2281577},{"$f":"SUMIF(Capex!$C$37:$C$67,E$4,Capex!$G$37:$G$67)*1000000","v":5771999.9999999991},{"$f":"SUMIF(Capex!$C$37:$C$67,F$4,Capex!$G$37:$G$67)*1000000","v":8500000},{"$f":"SUMIF(Capex!$C$37:$C$67,G$4,Capex!$G$37:$G$67)*1000000","v":141121585.07061198},{"$f":"SUMIF(Capex!$C$37:$C$67,H$4,Capex!$G$37:$G$67)*1000000","v":285000.00000000006},{"$f":"SUMIF(Capex!$C$37:$C$67,I$4,Capex!$G$37:$G$67)*1000000","v":0},{"$f":"SUMIF(Capex!$C$37:$C$67,J$4,Capex!$G$37:$G$67)*1000000","v":7040000},{"$f":"SUMIF(Capex!$C$37:$C$67,K$4,Capex!$G$37:$G$67)*1000000","v":3665250},{"$f":"SUMIF(Capex!$C$37:$C$67,L$4,Capex!$G$37:$G$67)*1000000","v":3128160.0000000005},{"$f":"SUMIF(Capex!$C$37:$C$67,M$4,Capex!$G$37:$G$67)*1000000","v":0},{"$f":"SUMIF(Capex!$C$37:$C$67,N$4,Capex!$G$37:$G$67)*1000000","v":0},{"$f":"SUMIF(Capex!$C$37:$C$67,O$4,Capex!$G$37:$G$67)*1000000","v":-77101874.795668259},{"$f":"SUMIF(Capex!$C$37:$C$67,P$4,Capex!$G$37:$G$67)*1000000","v":0},475541069.50310147,null,1,null,0,383130949.2281577,5771999.9999999991,8500000,141121585.07061198,285000.00000000006,0,7040000,3665250,3128160.0000000005,0,0,-77101874.795668259,0,475541069.50310147,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,361845896.49326003,2885999.9999999995,5464285.7142857146,105841188.802959,142500.00000000003,0,4525714.2857142864,3481987.5,1564080.0000000002,0,0,-72818437.307020023,0,412933215.48919898]
[2014,null,{"$f":"SUMIF(Capex!$C$37:$C$67,C$4,Capex!$H$37:$H$67)*1000000","v":0},{"$f":"SUMIF(Capex!$C$37:$C$67,D$4,Capex!$H$37:$H$67)*1000000","v":367937962.65510297},{"$f":"SUMIF(Capex!$C$37:$C$67,E$4,Capex!$H$37:$H$67)*1000000","v":14271999.999999998},{"$f":"SUMIF(Capex!$C$37:$C$67,F$4,Capex!$H$37:$H$67)*1000000","v":3000000},{"$f":"SUMIF(Capex!$C$37:$C$67,G$4,Capex!$H$37:$H$67)*1000000","v":127660934.457184},{"$f":"SUMIF(Capex!$C$37:$C$67,H$4,Capex!$H$37:$H$67)*1000000","v":285000.00000000006},{"$f":"SUMIF(Capex!$C$37:$C$67,I$4,Capex!$H$37:$H$67)*1000000","v":0},{"$f":"SUMIF(Capex!$C$37:$C$67,J$4,Capex!$H$37:$H$67)*1000000","v":7040000},{"$f":"SUMIF(Capex!$C$37:$C$67,K$4,Capex!$H$37:$H$67)*1000000","v":53728674.491447471},{"$f":"SUMIF(Capex!$C$37:$C$67,L$4,Capex!$H$37:$H$67)*1000000","v":2822400},{"$f":"SUMIF(Capex!$C$37:$C$67,M$4,Capex!$H$37:$H$67)*1000000","v":0},{"$f":"SUMIF(Capex!$C$37:$C$67,N$4,Capex!$H$37:$H$67)*1000000","v":0},{"$f":"SUMIF(Capex!$C$37:$C$67,O$4,Capex!$H$37:$H$67)*1000000","v":-63021884.841942452},{"$f":"SUMIF(Capex!$C$37:$C$67,P$4,Capex!$H$37:$H$67)*1000000","v":0},513725086.76179206,null,1,null,0,367937962.65510297,14271999.999999998,3000000,127660934.457184,285000.00000000006,0,7040000,53728674.491447471,2822400,0,0,-63021884.841942452,0,513725086.76179206,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,355673363.89993286,9990399.9999999981,2357142.8571428573,108511794.28860641,199500.00000000003,0,5531428.5714285709,52116814.256704047,1975679.9999999998,0,0,-60921155.347211041,0,475434968.5266037]
[2015,null,{"$f":"SUMIF(Capex!$C$37:$C$67,C$4,Capex!$I$37:$I$67)*1000000","v":0},{"$f":"SUMIF(Capex!$C$37:$C$67,D$4,Capex!$I$37:$I$67)*1000000","v":418278513.4765501},{"$f":"SUMIF(Capex!$C$37:$C$67,E$4,Capex!$I$37:$I$67)*1000000","v":14972000},{"$f":"SUMIF(Capex!$C$37:$C$67,F$4,Capex!$I$37:$I$67)*1000000","v":2500000},{"$f":"SUMIF(Capex!$C$37:$C$67,G$4,Capex!$I$37:$I$67)*1000000","v":225758964.435399},{"$f":"SUMIF(Capex!$C$37:$C$67,H$4,Capex!$I$37:$I$67)*1000000","v":213750},{"$f":"SUMIF(Capex!$C$37:$C$67,I$4,Capex!$I$37:$I$67)*1000000","v":0},{"$f":"SUMIF(Capex!$C$37:$C$67,J$4,Capex!$I$37:$I$67)*1000000","v":7040000},{"$f":"SUMIF(Capex!$C$37:$C$67,K$4,Capex!$I$37:$I$67)*1000000","v":53719429.921024434},{"$f":"SUMIF(Capex!$C$37:$C$67,L$4,Capex!$I$37:$I$67)*1000000","v":2748900},{"$f":"SUMIF(Capex!$C$37:$C$67,M$4,Capex!$I$37:$I$67)*1000000","v":0},{"$f":"SUMIF(Capex!$C$37:$C$67,N$4,Capex!$I$37:$I$67)*1000000","v":0},{"$f":"SUMIF(Capex!$C$37:$C$67,O$4,Capex!$I$37:$I$67)*1000000","v":-114531460.32220902},{"$f":"SUMIF(Capex!$C$37:$C$67,P$4,Capex!$I$37:$I$67)*1000000","v":0},610700097.5107646,null,1,null,0,418278513.4765501,14972000,2500000,225758964.435399,213750,0,7040000,53719429.921024434,2748900,0,0,-114531460.32220902,0,610700097.5107646,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,413630974.43792176,13474800,2321428.5714285714,214471016.21362904,192375,0,6537142.8571428573,53182235.621814191,2474010,0,0,-113258888.54085115,0,593025094.16108537]
[2016]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BT7:BT80)","v":108150913.44107199},6790445476.7534895,29033000,11448548.928571429,460148120.77660662,655500,8416666.6666666679,26246207.623386312,182663588.48106936,7391454,0,-11711521.738091793,-1391593410.3129644,72171191.142963111,{"$f":"SUM(CH7:CH80)","v":6293465735.7627678}]

{"sheet":"System Data","index":7,"n_rows":5,"n_cols":6,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[null,2011,2012,2013,2014,2015]
[]
["Total regulated units distributed including 110kV  (GWh)",23549.038166108097,24083.206405671688,24649.293029886925,25338.064485534647,26066.916900181233]
[]
["Growth (%)",null,{"$f":"C3/B3-1","v":2.2683229599260946E-2},2.350545083905109E-2,2.79428482923465E-2,2.8765117993234446E-2]

{"sheet":"Inflation","index":8,"n_rows":67,"n_cols":15,"rows_kept":67,"cut":false,"hidden":false,"merged":[[0,0,3,0],[0,14,2,14]]}
["Source: CSO 1947 base CPI table",null,null,null,null,null,null,null,null,null,null,null,null,"Average","Factor to convert to 2009 money"]
[null,"Mid-","Mid-","Mid-","Mid-","Mid-","Mid-","Mid-","Mid-","Mid-","Mid-","Mid-","Mid-","Annual"]
[null,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Index"]
[]
[1947,null,"-",null,null,"-",null,null,100,100,97,97,97,100,{"$f":"N$67/N5","v":29.053166666666669}]
[1948,99,99,99,100,100,100,99,99,99,99,99,99,{"$f":"SUM(B6:M6)/12","v":99.25},{"$f":"N$67/N6","v":29.272712006717047}]
[1949,99,99,99,99,99,99,100,100,100,100,100,100,99.5,29.199162479061979]
[1950,100,100,100,102,102,102,100,100,100,102,102,102,101,28.765511551155118]
[1951,103,103,103,109,109,109,111,111,111,113,113,113,109,26.654281345565753]
[1952,114,114,114,115,115,115,122,122,122,123,123,123,118.5,24.517440225035166]
[1953,123,123,123,126,126,126,125,125,125,125.1,125.1,125.1,124.77499999999998,23.284445334936226]
[1954,124.2,124.2,124.2,124.4,124.4,124.4,126.4,126.4,126.4,125.6,125.6,125.6,{"$f":"SUM(B12:M12)/12","v":125.14999999999998},23.214675722466382]
[1955,126.5,126.5,126.5,127.5,127.5,127.5,128.4,128.4,128.4,131.19999999999999,131.19999999999999,131.19999999999999,128.4,22.627076843198342]
[1956,131.9,131.9,131.9,134.4,134.4,134.4,134.80000000000001,134.80000000000001,134.80000000000001,134.4,134.4,134.4,133.87500000000003,21.701711795829443]
[1957,134.6,134.6,134.6,138,138,138,142.6,142.6,142.6,142.19999999999999,142.19999999999999,142.19999999999999,{"$f":"SUM(B15:M15)/12","v":139.35},20.84906111709126]
[1958,144.19999999999999,144.19999999999999,144.19999999999999,145.80000000000001,145.80000000000001,145.80000000000001,146.1,146.1,146.1,146.1,146.1,146.1,145.54999999999998,19.960952708118636]
[1959,147.1,147.1,147.1,147,147,147,144.5,144.5,144.5,143.6,143.6,143.6,145.54999999999998,19.960952708118636]
[1960,144.19999999999999,144.19999999999999,144.19999999999999,146.5,146.5,146.5,146.5,146.5,146.5,147.6,147.6,147.6,146.19999999999996,19.872207022343829]
[1961,148.6,148.6,148.6,150.4,150.4,150.4,150.6,150.6,150.6,151.4,151.4,151.4,150.25,19.336550194120914]
[1962,154.1,154.1,154.1,158.1,158.1,158.1,157.4,157.4,157.4,157,157,157,156.65,18.546547505053731]
[1963,159.6,159.6,159.6,159.19999999999999,159.19999999999999,159.19999999999999,159.1,159.1,159.1,164,164,164,160.47499999999999,18.104481487251391]
[1964,164.9,164.9,164.9,171.4,171.4,171.4,173.5,173.5,173.5,175.4,175.4,175.4,171.30000000000004,16.960400856197701]
[1965,177.2,177.2,177.2,180.4,180.4,180.4,181,181,181,181,181,181,179.9,16.149620159347787]
[1966,181.1,181.1,181.1,184.5,184.5,184.5,187.5,187.5,187.5,188,188,188,185.27500000000001,15.681104664237846]
[1967,188.2,188.2,188.2,191.5,191.5,191.5,191.6,191.6,191.6,192.9,192.9,192.9,191.04999999999998,15.207101107912417]
[1968,196.9,196.9,196.9,200,200,200,200.4,200.4,200.4,203.4,203.4,203.4,200.17500000000004,14.513883685108862]
[1969,210.1,210.1,210.1,213.7,213.7,213.7,217.2,217.2,217.2,218.8,218.8,218.8,214.95000000000005,13.51624408777235]
[1970,222.5,222.5,222.5,231.6,231.6,231.6,235.5,235.5,235.5,240.8,240.8,240.8,232.60000000000005,12.490613356262539]
[1971,244.7,244.7,244.7,251.4,251.4,251.4,256.3,256.3,256.3,261.5,261.5,261.5,253.47499999999999,11.461945622513728]
[1972,267.39999999999998,267.39999999999998,267.39999999999998,271.5,271.5,271.5,279,279,279,283.10000000000002,283.10000000000002,283.10000000000002,275.24999999999994,10.555192249470183]
[1973,294.3,294.3,294.3,303.2,303.2,303.2,310.39999999999998,310.39999999999998,310.39999999999998,318.89999999999998,318.89999999999998,318.89999999999998,306.70000000000005,9.4728290403217041]
[1974,333.9,333.9,333.9,352.4,352.4,352.4,365.9,365.9,365.9,382.8,382.8,382.8,358.75000000000006,8.0984436701509868]
[1975,413.5,413.5,413.5,438.7,438.7,438.7,435.2,435.2,435.2,447.2,447.2,447.2,433.64999999999992,6.6996810023444429]
[1976,479.9,479.9,479.9,509.8,509.8,509.8,517.4,517.4,517.4,539.29999999999995,539.29999999999995,539.29999999999995,511.60000000000008,5.6788832421162363]
[1977,559.9,559.9,559.9,580.9,580.9,580.9,587.20000000000005,587.20000000000005,587.20000000000005,597.5,597.5,597.5,581.375,4.9973195728517172]
[1978,606,606,606,616.70000000000005,616.70000000000005,616.70000000000005,635.5,635.5,635.5,644.9,644.9,644.9,625.77499999999986,4.6427496570918745]
[1979,671.7,671.7,671.7,693.2,693.2,693.2,721.8,721.8,721.8,747.8,747.8,747.8,708.625,{"$f":"N$67/N37","v":4.09993532075028}]
[1980,775.9,775.9,775.9,833.2,833.2,833.2,857.8,857.8,857.8,884.2,884.2,884.2,837.77500000000009,3.467896113713905]
[1981,938.7,938.7,938.7,975.4,975.4,975.4,1030.4000000000001,1030.4000000000001,1030.4000000000001,1090.3,1090.3,1090.3,1008.6999999999998,2.8802584184263584]
[1982,1115.8,1115.8,1115.8,1180.2,1180.2,1180.2,1205.3,1205.3,1205.3,1224.5,1224.5,1224.5,1181.4499999999998,2.4591109794461614]
[1983,1255.0999999999999,1255.0999999999999,1255.0999999999999,1289.4000000000001,1289.4000000000001,1289.4000000000001,1326.1,1326.1,1326.1,1350.6,1350.6,1350.6,1305.3000000000002,2.2257846216706247]
[1984,1382.5,1382.5,1382.5,1414.3,1414.3,1414.3,1431.4,1431.4,1431.4,1441.2,1441.2,1441.2,1417.3500000000001,2.0498230265401394]
[1985,1468.2,1468.2,1468.2,1487.8,1487.8,1487.8,1509.8,1509.8,1509.8,1512.2,1512.2,1512.2,1494.5,1.9440057990409281]
[1986,1535.5,1535.5,1535.5,1553.9,1553.9,1553.9,1556.3,1556.3,1556.3,1560,1560,1560,1551.425,1.8726761955406592]
[1987,1588.2,1588.2,1588.2,1598,1598,1598,1606.5,1606.5,1606.5,1607.8,1607.8,1607.8,1600.125,1.8156810665833401]
[1988,1618.8,1618.8,1618.8,1627.4,1627.4,1627.4,1640.8,1640.8,1640.8,1650.6,1650.6,1650.6,1634.3999999999996,1.7776044216022195]
[1989,1672.7,1672.7,1672.7,1689.8,1689.8,1689.8,1714.3,1714.3,1714.3,1727.8,1727.8,1727.8,1701.1499999999996,1.7078544905896997]
[1990,1743.3,1743.3,1743.3,1748.5,1748.5,1748.5,1764,1764,1764,1774.4,1774.4,1774.4,1757.5500000000002,1.6530492257214116]
[1991,1788.2,1788.2,1788.2,1802.1,1802.1,1802.1,1826.2,1826.2,1826.2,1838.3,1838.3,1838.3,1813.7,1.6018727830769515]
[1992,1853.9,1853.9,1853.9,1867.7,1867.7,1867.7,1878.1,1878.1,1878.1,1881.5,1881.5,1881.5,1870.3000000000002,1.5533960683669288]
[1993,1888.4,1888.4,1888.4,1885,1885,1885,1904,1904,1904,1909.2,1909.2,1909.2,1896.6500000000003,1.5318148665629749]
[1994,1921.3,1921.3,1921.3,1936.8,1936.8,1936.8,1952.4,1952.4,1952.4,1954.1,1954.1,1954.1,1941.1499999999996,1.4966986923559062]
[1995,1969.6,1969.6,1969.6,1990.4,1990.4,1990.4,1999,1999,1999,2000.7,2000.7,2000.7,1989.9250000000002,1.4600131495743141]
[1996,2009.4,2009.4,2009.4,2018,2018,2018,2028.4,2028.4,2028.4,2038.8,2038.8,2038.8,2023.6499999999999,1.4356814007692373]
[1997,2028.6,2040.8,2042.9,2044.9,2049,2055.1,2053.1,2049,2059.1999999999998,2063.3000000000002,2071.4,2077.5,2052.9,1.4152256157955414]
[1998,2065.3000000000002,2075.5,2085.6999999999998,2095.9,2104,2114.1999999999998,2108.1,2114.1999999999998,2120.4,2122.4,2114.1999999999998,2112.1999999999998,2102.6750000000002,1.3817240736997713]
[1999,2095.9,2108.1,2114.1999999999998,2124.4,2134.6,2140.6999999999998,2132.6,2144.8000000000002,2153,2155,2159.1,2183.6,2137.1666666666665,1.3594244716524997]
[2000,2179.5,2197.8000000000002,2212.1,2228.4,2244.6999999999998,2259,2265.1,2277.3000000000002,2285.5,2301.8000000000002,2310,2312,2256.1,1.2877605898083717]
[2001,2293.6999999999998,2314,2332.4,2352.8000000000002,2367,2379.3000000000002,2373.1999999999998,2381.3000000000002,2391.5,2399.6999999999998,2397.6,2409.9,2366.0333333333333,1.2279271917837169]
[2002,2405.1,2421.9,2443.6,2465.3000000000002,2477.4,2482.1999999999998,2472.6,2487,2499.1,2511.1,2513.5,2530.4,2475.7666666666664,1.1735018108868636]
[2003,2520.8000000000002,2544.9,2564.1,2571.4,2569,2569,2549.6999999999998,2566.5,2571.4,2569,2569,2578.6,2561.9500000000003,1.1340255144193552]
[2004,2566.5,2588.1999999999998,2597.9,2607.5,2612.3000000000002,2626.8,2619.6,2634,2636.4,2638.8,2643.7,2646.1,2618.15,1.109683045916646]
[2005,2624.4,2646.1,2653.3,2665.3,2675,2682.2,2682.2,2694.3,2716,2718.4,2713.5,2711.1,{"$f":"SUM(B63:M63)/12","v":2681.8166666666666},1.0833390301350454]
[2006,2703.9,2732.8,2744.9,2766.6,2778.6,2785.8,2795.5,2814.8,2824.4,2824.4,2834,2843.7,{"$f":"SUM(B64:M64)/12","v":2787.4500000000003},1.0422847644501845]
[2007,2840.9,2863.6,2883.5,2906.3,2917.6,2923.3,2931.9,2946.1,2954.6,2957.4,2974.5,2977.4,2923.0916666666667,0.99391910961852614]
[2008,2963.1,3000.1,3028.5,3031.4,3054.1,3068.4,3059.8,3074,3082.6,3076.9,3048.4,3011.5,3041.5666666666671,0.95520400670706984]
[2009,2960.3,2948.9,2948.9,2926.2,2911.9,2903.4,2880.7,2892,2880.7,2875,2875,2860.8,{"$f":"SUM(B67:M67)/12","v":2905.3166666666671},1]

{"sheet":"PR2 Allow Outturn Revised Capex","index":9,"n_rows":85,"n_cols":17,"rows_kept":85,"cut":false,"hidden":false,"merged":[]}
[null,"New Business"]
[]
[null,"As per  PR2 determination CER/05/138 (2004 prices)",null,null,null,null,null,null,null,null,null,"Total"]
[null,null,null,null,null,2006,2007,2008,2009,2010]
[null,null,"(i) Commercial/Industrial Supplies","[€m]",null,46.065200853511463,46.065200853511463,46.065200853511463,46.065200853511463,46.065200853511463,null,{"$f":"SUM(F5:J5)","v":230.32600426755732}]
[null,null,"(ii). New housing Schemes","[€m]",null,45.062875246135583,44.612246493674228,41.302460139663957,40.889435538267314,40.48054118288465,null,212.34755860062575]
[null,null,"(iv) Non-scheme Houses","[€m]",null,46.250775054207537,45.788267303665457,42.364035233722937,41.940394881385707,41.520990932571848,null,217.86446340555352]
[null,null,"(v)  Whole Current Metering","[€m]",null,6.2456634524412422,5.4907837555989278,3.6920536759296438,3.7576073772175516,3.7931135694994862,null,22.97922183068685]
[null,null,"New Business","[€m]",null,{"$f":"SUM(F5:F8)","v":143.62451460629583},{"$f":"SUM(G5:G8)","v":141.95649840645007},133.42374990282801,132.65263865038202,131.85984653846748,null,{"$f":"SUM(F9:J9)","v":683.51724810442352}]
[]
[null,"Allowed Unit prices (2004 prices)"]
[null,null,"G1","[€]",null,1138.9355679905773,1126.3087878576441,1078.4605497217115,1066.9239148615054,1058.6308796028827]
[null,null,"G2","[€]",null,2728.2262940557721,2698.763807078928,2583.2385551639204,2550.8868409910219,2530.9833766292973]
[null,null,"G3","[€]",null,4610,4606.5200853511469,4606.5200853511469,4606.5200853511469,4606.5200853511469]
[null,null,"Meters ","[€]",null,96.021146954015634,86.728777893949626,59.002591489498101,59.921235961051785,60.487440652554092]
[]
[null,"Actual & Forecast Units ",null,null,null,null,null,null,"Outturn as per 12/3/09 note revised","Forecast as per DH01"]
[null,null,"G1",null,null,69406,59297,33800,14224,9000]
[null,null,"G2",null,null,21959,19802,17596,12257,9867]
[null,null,"G3",null,null,13762,15301,13654,8370,7473]
[null,null,null,null,null,{"$f":"SUM(F18:F20)","v":105127},{"$f":"SUM(G18:G20)","v":94400},{"$f":"SUM(H18:H20)","v":65050},{"$f":"SUM(I18:I20)","v":34851},{"$f":"SUM(J18:J20)","v":26340}]
[]
[null,null,"Percentage of G3 connections metered","%",null,0.8,0.8,0.8,0.8,0.8]
[]
[null,null,"Allowed Costs (2004 prices)"]
[]
[null,null,"G1","[€]",null,{"$f":"F12*F18","v":79048962.031954005},66786732.193594724,36451966.580593847,15175925.764990052,9527677.9164259452]
[null,null,"G2","[€]",null,59909121.1911707,53440920.907776929,45454665.616664343,31266220.010026954,24973212.977201276]
[null,null,"G3","[€]",null,63442820,70484363.825957894,62897425.245384559,38556573.114389099,34424524.597829118]
[null,null,"Meters ","[€]",null,{"$f":"(F18+F19)*F15+F20*F23*F15","v":9830126.5109585691},{"$f":"(G18+G19)*G15+G20*G23*G15","v":7921789.2270777803},3676994.2995523298,1988006.8454798153,1502834.6579889674]
[]
[null,null,"Total Allowed Costs (2004 prices)","[€]",null,{"$f":"SUM(F27:F30)","v":212231029.73408329},{"$f":"SUM(G27:G30)","v":198633806.15440732},{"$f":"SUM(H27:H30)","v":148481051.74219507},86986725.734885931,70428250.149445295]
[]
[null,null,"Diffence due to volumes","[€]",null,{"$f":"F32-(F9*1000000)","v":68606515.127787471},{"$f":"G32-(G9*1000000)","v":56677307.747957259},15057301.839367062,-45665912.915496081,-61431596.389022186]
[null,null,"Percentage of customer contribution","%",null,0.5,0.5,0.5,0.5,0.5]
[null,null,"Contribution (2004 prices)","[€]",null,{"$f":"-F34*F35","v":-34303257.563893735},{"$f":"-G34*G35","v":-28338653.87397863},-7528650.9196835309,22832956.457748041,30715798.194511093]
[]
[null,null,"Additional New Business (Nominal, 2010 in 2009 prices)","[€]",null,{"$f":"F34*Inflation!N64/Inflation!N62","v":73042885.469874218},{"$f":"G34*Inflation!N65/Inflation!N62","v":63278637.957013912},{"$f":"H34*Inflation!N66/Inflation!N62","v":17492423.03327065},{"$f":"I34*Inflation!N67/Inflation!N62","v":-50674689.338632002},{"$f":"J34*Inflation!N67/Inflation!N62","v":-68169600.996492177}]
[null,null,"Additional Contribution (Nominal, 2010 in 2009 prices)","[€]",null,{"$f":"-F38*F35","v":-36521442.734937109},{"$f":"-G38*G35","v":-31639318.978506956},-8746211.5166353248,25337344.669316001,34084800.498246089]
[]
[]
[null,"Additional Non-Network Capex"]
[null,"Nominal Money, 2010 & 2011 in 2009 prices",null,null,null,2006,2007,2008,2009,2010,2011]
[null,null,"Smart Metering Pilot (10 Years)","[€]",null,0,{"$f":"172000","v":172000},{"$f":"4100000","v":4100000},{"$f":"7730000","v":7730000},{"$f":"3300000","v":3300000},0]
[null,null,"IT Expenditure Associated with SEM (7 years)","[€]",null,0,{"$f":"5780000","v":5780000},{"$f":"56000","v":56000},0,0,0]
[null,null,"Market Enhancements Programme (7 years)","[€]",null,0,{"$f":"256000","v":256000},{"$f":"22000","v":22000},779685,0,0]
[]
[]
[]
[null,"Additional Other Capex",null,null,null,2006,2007,2008,2009,2010,2011]
[null,"Nominal Money, 2010 & 2011 in 2009 prices"]
[null,null,"New Business (Allowed cost driver variations)","[€]",null,0,0,0,0,0,29800000]
[null,null,"Capex underspend","[€]",null,0,0,0,0,0,-7847513.5704959482]
[null,null,"Carrickmines Adjustment","[€]",null,null,null,-23810838.9280813]
[]
[]
[null,"Summary of Capex Adjustments"]
[null,null,null,null,"Asset Categorisation",2006,2007,2008,2009,2010,2011]
[null,null,{"$f":"C38","v":"Additional New Business (Nominal, 2010 in 2009 prices)"},{"$f":"D38","v":"[€]"},"HV/MV/LV Networks",73042885.469874218,63278637.957013912,17492423.03327065,-50674689.338632002,-68169600.996492177,0]
[null,null,{"$f":"C39","v":"Additional Contribution (Nominal, 2010 in 2009 prices)"},{"$f":"D39","v":"[€]"},"Customer Contributions",-36521442.734937109,-31639318.978506956,-8746211.5166353248,25337344.669316001,34084800.498246089,0]
[null,null,{"$f":"C44","v":"Smart Metering Pilot (10 Years)"},{"$f":"D44","v":"[€]"},"Office Equip,Telecoms & Smart Metering (10 Year)",0,172000,4100000,7730000,3300000,0]
[null,null,{"$f":"C45","v":"IT Expenditure Associated with SEM (7 years)"},"[€]","IT (7 year)",0,5780000,56000,0,0,0]
[null,null,"Market Enhancements Programme (7 years)","[€]","IT (7 year)",0,256000,22000,779685,0,0]
[null,null,{"$f":"C52","v":"New Business (Allowed cost driver variations)"},{"$f":"D52","v":"[€]"},"HV/MV/LV Networks",0,0,0,0,0,29800000]
[null,null,{"$f":"C53","v":"Capex underspend"},"[€]","HV/MV/LV Networks",0,0,0,0,0,-7847513.5704959482]
[null,null,"Carrickmines Adjustment","[€]","Premises",0,0,-23810838.9280813,0,0,0]
[]
[]
["Capitalised Year",null,{"$f":"'2011 to 2015 Distribution RAB'!C4","v":"110kV Networks"},{"$f":"'2011 to 2015 Distribution RAB'!D4","v":"HV/MV/LV Networks"},{"$f":"'2011 to 2015 Distribution RAB'!E4","v":"IT (5 year)"},{"$f":"'2011 to 2015 Distribution RAB'!F4","v":"IT (7 year)"},{"$f":"'2011 to 2015 Distribution RAB'!G4","v":"Office Equip,Telecoms & Smart Metering (10 Year)"},{"$f":"'2011 to 2015 Distribution RAB'!H4","v":"F&F"},{"$f":"'2011 to 2015 Distribution RAB'!I4","v":"Scada Tel (15 years)"},{"$f":"'2011 to 2015 Distribution RAB'!J4","v":"Vehicles"},{"$f":"'2011 to 2015 Distribution RAB'!K4","v":"Premises"},{"$f":"'2011 to 2015 Distribution RAB'!L4","v":"Tools"},{"$f":"'2011 to 2015 Distribution RAB'!M4","v":"Telecoms (15 Years)"},{"$f":"'2011 to 2015 Distribution RAB'!N4","v":"Grants"},{"$f":"'2011 to 2015 Distribution RAB'!O4","v":"Customer Contributions"},{"$f":"'2011 to 2015 Distribution RAB'!P4","v":"Other"},{"$f":"'2011 to 2015 Distribution RAB'!Q4","v":"Total"}]
["Allowed as per PR2 determination in Nominal Prices to 2009, 2010 in 2009 prices"]
[2006,null,0,487210245.08862799,14041734.52373665,0,1264095.5815681,0,0,22239946.016157478,0,0,0,0,-94474328.221925303,17354022.878750265,{"$f":"SUM(C71:P71)","v":447635715.86691523}]
[2007,null,0,498591983.33971399,18579726.241677091,0,2574074.7669235002,0,0,16912924.336799413,0,0,0,0,-149110722.114656,14625785.701099377,{"$f":"SUM(C72:P72)","v":402173772.27155745}]
[2008,null,0,498195593.95012301,9024899.9778191522,0,2593730.7745737899,0,0,16812114.171473444,0,0,0,0,-129989355.238426,15450923.998497669,412087907.63406104]
[2009,null,0,445375754.336573,6930379.4221634082,0,2460639.83876226,0,0,19283339.630904227,0,0,0,0,-124091956.244156,12872323.332633095,362830480.31688005]
[2010,null,0,395794489.34571701,5174843.2630053833,0,2438087.9997232901,0,0,10454522.365501376,0,0,0,0,-73161318.070454001,12761355.02804143,353461979.93153453]
[]
[]
["Adjusted capex in Nominal Prices to 2009, 2010 & 2011 in 2009 prices"]
[2006,null,{"$f":"C71+SUMIF($E$59:$E$66,C$69,$F$59:$F$66)","v":0},{"$f":"D71+SUMIF($E$59:$E$66,D$69,$F$59:$F$66)","v":560253130.5585022},14041734.52373665,0,1264095.5815681,0,0,22239946.016157478,0,0,0,0,-130995770.95686242,17354022.878750265,{"$f":"SUM(C79:P79)","v":484157158.60185224}]
[2007,null,{"$f":"C72+SUMIF($E$59:$E$66,C$69,$G$59:$G$66)","v":0},{"$f":"D72+SUMIF($E$59:$E$66,D$69,$G$59:$G$66)","v":561870621.2967279},18579726.241677091,6036000,2746074.7669235002,0,0,16912924.336799413,0,0,0,0,-180750041.09316295,14625785.701099377,{"$f":"SUM(C80:P80)","v":440021091.25006431}]
[2008,null,{"$f":"C73+SUMIF($E$59:$E$66,C$69,$H$59:$H$66)","v":0},{"$f":"D73+SUMIF($E$59:$E$66,D$69,$H$59:$H$66)","v":515688016.98339367},9024899.9778191522,78000,6693730.7745737899,0,0,16812114.171473444,-23810838.9280813,0,0,0,-138735566.75506133,15450923.998497669,401201280.22261512]
[2009,null,{"$f":"C74+SUMIF($E$59:$E$66,C$69,$I$59:$I$66)","v":0},{"$f":"D74+SUMIF($E$59:$E$66,D$69,$I$59:$I$66)","v":394701064.99794102},6930379.4221634082,779685,10190639.838762261,0,0,19283339.630904227,0,0,0,0,-98754611.574840009,12872323.332633095,346002820.64756405]
[2010,null,{"$f":"C75+SUMIF($E$59:$E$66,C$69,$J$59:$J$66)","v":0},{"$f":"D75+SUMIF($E$59:$E$66,D$69,$J$59:$J$66)","v":327624888.34922481},5174843.2630053833,0,5738087.9997232901,0,0,10454522.365501376,0,0,0,0,-39076517.572207913,12761355.02804143,322677179.4332884]
[]
[2011,null,{"$f":"SUMIF($E$59:$E$66,C$69,$K$59:$K$66)","v":0},{"$f":"SUMIF($E$59:$E$66,D$69,$K$59:$K$66)","v":21952486.429504052},0,0,0,0,0,0,0,0,0,0,0,0,21952486.429504052]

{"sheet":"PR2 Adjustments","index":10,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["PR2 Adjustments"]
["2009 Money",null,2011,2012,2013,2014,2015,null,"Total"]
["Revenue associated with PR2 Capex underspend","[€]",-1101512.8245705999]
["Revenue associated with error in calculation of RAB","[€]",-6752764.7943520499]
["PR2 K factors","[€]",{"$f":"C9/((1+C11)*(1+C12))","v":126302497.66396447}]
["Deferral","[€]",-50000000,{"$f":"-C6*(1+RoR)","v":52500000}]
["Total","[€]",{"$f":"SUM(C3:C6)","v":68448220.045041814},{"$f":"SUM(D3:D6)","v":52500000},{"$f":"SUM(E3:E6)","v":0},{"$f":"SUM(F3:F6)","v":0},{"$f":"SUM(G3:G6)","v":0},null,{"$f":"SUM(C7:G7)","v":120948220.04504181}]
[]
["PR2 K factors (2011 money)","[€]",{"$f":"109030000+16000000","v":125030000}]
[]
["2010 HICP estimate",null,-1.4999999999999999E-2]
["2011 HICP estmiate",null,5.0000000000000001E-3]

{"sheet":"Error check","index":11,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Errors"]
[null,null,"No of Errors",{"$f":"COUNTIF(D4:D16,\"No\")","v":0}]
[]
[1,"NPV of Revenue equals NPV of costs",null,{"$f":"IF(INT(NPV_of_Costs_Benefits)=INT(NPV_of_Revenue),\"Yes\",\"No\")","v":"Yes"}]
[2,"Capex input equals capex in RAB",null,{"$f":"IF((Capex!K70*1000000)=SUM('2011 to 2015 Distribution RAB'!Q76:Q80),\"Yes\",\"No\")","v":"Yes"}]
[3,"Total Deferals/Clawback input equals Deferals/Clawback in Revenue calculations",null,{"$f":"IF('PR2 Adjustments'!I7=Revenue!J5,\"Yes\",\"No\")","v":"Yes"}]