{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Opening Values","Retrospective mechanism","DAV","Pi's Calc"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":4,"defined_names":42,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Opening Values","index":0,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,3,1]]}
[]
[null,"Opening Values"]
[]
[null,null,"£2012","Source",2005,2006,{"$f":"F4+1","v":2007},{"$f":"G4+1","v":2008},2009,2010,2011,2012,2013]
[]
[null,"TRV Opening Value (£2012)"]
[null,"DAV (Incl Retrospective Capex Adjustments)",null,null,null,null,null,null,null,null,null,null,{"$f":"DAV!L33","v":83228235.390608743}]
[null,"PAB determination",null,null,null,null,null,null,null,null,null,null,{"$f":"23967000*RPI_12","v":30076478.283350565}]
[null,"Opex adjustment MDR",null,null,null,null,null,null,null,{"$f":"-30511.8195439202*RPI_12*(1+7.5%*0.5)*(1+7.5%)^3","v":-49350.881214801135},{"$f":"-150593.539357789*RPI_12*(1+7.5%*0.5)*(1+7.5%)^2","v":-226581.62178498704},{"$f":"-274245.276434163*RPI_12*(1+7.5%*0.5)*(1+7.5%)^1","v":-383838.94089282112},{"$f":"-305035.792518024*RPI_12*(1+7.5%*0.5)*(1+7.5%)^0","v":-397147.84824601392}]
[null,"Opex Adjustment OAV & PCR02 Retro Opex Adj",null,null,null,null,null,null,{"$f":"E18+'Retrospective mechanism'!H8","v":2770816.705943611},{"$f":"'Retrospective mechanism'!I8","v":599010.3152462804},{"$f":"'Retrospective mechanism'!J8","v":1479134.5098917086},{"$f":"'Retrospective mechanism'!K8","v":1962982.190030358},{"$f":"'Retrospective mechanism'!L8","v":1714988.3586778473}]
[null,"Adjusted PAB",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(I8:M10)","v":37546491.071001746}]
[null,"Actual Depreciation",null,null,null,null,null,null,{"$f":"DAV!H27","v":1630500.2267768586},{"$f":"DAV!I27","v":1947695.8952395367},{"$f":"DAV!J27","v":2203584.7211800418},{"$f":"DAV!K27","v":2612872.6009461745},{"$f":"DAV!L27","v":2777246.7635690887}]
[null,"Determined Depreciation",null,null,null,null,null,null,{"$f":"-1347007.90738161*RPI_12","v":-1690376.5207937784},{"$f":"-1651207.67477839*RPI_12","v":-2072120.4894969764},{"$f":"-1869106.44307223*RPI_12","v":-2345564.290246278},{"$f":"-2009279.13971871*RPI_12","v":-2521468.703256106},{"$f":"-2176715.87141297*RPI_12","v":-2731587.083722481}]
[null,"DAB Adjustment",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(I12:M13)","v":-189216.8798039197}]
[null,"Opening TRV Value",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M7,M11,M14)","v":120585509.58180657}]
[]
[]
[null,"Opening Asset Value","Opex","PI's model V7",{"$f":"2427309.37423238*RPI_12","v":3046059.9024105407}]
[null,null,"Mains","PI's model V7",{"$f":"1394416.11040308*RPI_12","v":1749869.6483703593}]
[null,null,"Other Capex","PI's model V7",{"$f":"339489*RPI_12","v":426028.85367114784}]
[null,null,"Total OAV",null,{"$f":"SUM(E18:E20)","v":5221958.4044520473}]

{"sheet":"Retrospective mechanism","index":1,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[{"$f":"242.7/193.4","v":1.2549120992761116},"Y","N"]
["RETROSPECTIVE ADJUSTMENTS UPDATE BY FORMULA YEAR (£2012)"]
[null,null,null,null,null,null,null,2009,{"$f":"H3+1","v":2010},{"$f":"I3+1","v":2011},2012,2013,"TOTAL"]
["Retrospective Adjustment Categories",null,null,null,null,null,null,"Actual","Actual","Actual","Actual","Forecast","Actual/Forecast"]
["Capex 40 Yr Life",null,null,null,null,null,null,-2664919.3409756515,-3369293.4174262471,1435272.8522155578,4821142.3208648134,2158215.5850288309,{"$f":"SUM(H5:L5)","v":2380417.9997073039},{"$f":"SUM(H5:K5)","v":222202.41467847303}]
["Capex 15 Yr Life",null,null,null,null,null,null,152976.5273364615,295260.52792696259,665935.02580032102,893259.91238271643,747802.66386580933,{"$f":"SUM(H6:L6)","v":2755234.6573122707},{"$f":"SUM(H6:K6)","v":2007431.9934464614}]
["Capex 5 Yr Life",null,null,null,null,null,null,0,0,-752295.29351408989,0,0,-752295.29351408989,-752295.29351408989]
["Opex",null,null,null,null,null,null,-275243.1964669298,599010.3152462804,1479134.5098917086,1962982.190030358,1714988.3586778473,{"$f":"SUM(H8:L8)","v":5480872.1773792645},3765883.8187014172]
["Total Retrospective Adjustments",null,null,null,null,null,null,{"$f":"SUM(H5:H8)","v":-2787186.0101061198},{"$f":"SUM(I5:I8)","v":-2475022.574253004},2828047.0943934973,7677384.4232778875,4621006.6075724876,9864229.5408847481,5243222.9333122615]
[]
["N.B. for GD14 this will only account for ACTUAL adjustments up to t = 2012, 2013 has been Provisionally adjusted for in this Price Control"]
["As per Final Document Paragraph 10.8:"]
["http://www.uregni.gov.uk/uploads/publications/2013-12-20_GD14_Price_Control_for_NI_GDNs_2014-2016_Final_Determination.pdf"]

{"sheet":"DAV","index":2,"n_rows":33,"n_cols":34,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,0,2,1],[4,14,4,33]]}
["Condition 2.3.17 Calculation of DAV"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IMPORTANT NOTE:  Total Capex and Breakdown from 2017 Onwards are forecasts and will be determined as part of the Next Price Control."]
[null,null,null,"£2012",2006,{"$f":"E6+1","v":2007},{"$f":"F6+1","v":2008},2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035]
[]
["Annual Capex "]
["Mains",null,null,null,8687760.9478444904,11356006.984534977,8854334.3147914819,11093981.871848471,10818463.3379432,7649267.4789249031,6031966.9518328598,5073387.2420507632,7693260.3197496813,6098827.5518436385,5475313.8559655566,5095363.2577601904,4580368.7541013965,3307875.9201738578,3307394.6407638304,3296922.8166870177,1668764.9829048654,1639499.9461973594,1086516.5900859016,1096993.337123716,1092652.9033087122,1092808.7432596222,990449.76704240998,965855.69080355717,966556.7362090128,967751.50428975211,968233.68516130908,968052.88564961415,969936.25331374619,969936.25331374619]
["Services",null,null,null,367508.56688541145,658713.22123910883,1590897.0434823858,-597651.9745209082,-1244444.815830139,3466727.839485107,6687401.376403858,3905971.2029433949,2712128,2651954,2453680,2338559.365341791,2350703.1289895382,1992203.7539129043,1991913.8982259082,1985607.1298526111,1518042.4054702732,1491420.5820411243,1436865.0497901873,1450720.0353389471,1444980.0239055157,1445186.1146185952,1449875.2737403242,1447894.7758131698,1448945.6988338986,1450736.7515541776,1451459.5791686664,1451188.5462690881,1454011.8647293891,1454011.8647293891]
["Meters, telemtry",null,null,null,459854.05402826332,860162.48520406859,1823271.8254698243,932919.72590982821,1001870.4673050795,1300118.9889893737,1412680.6923996788,1196311.8392639491,1053354,1003990,900819,857720.15812899964,862541.34937588277,710490.53817467345,710378.19613273197,841613.64020800439,813242.19841010042,977843.49593714124,1026407.5842566267,1079019.7132700598,1403401.8785345897,1442883.2834359929,1546735.7856760218,1485051.0639825419,1454870.5446795945,1378186.7030298566,1331663.1002247133,1331391.9561679102,1203713.4618926023,1203713.4618926023]
["Other Capex",null,null,null,393014.62616339192,68544.553774560496,752947.2595656669,55827.479408313287,55269.204614230155,-150413.65526512347,54169.347442406979,53627.653967982907,122000,22000,20999.999999999996,20999.999999999996,20999.999999999996,20999.999999999996,20999.999999999996,20999.999999999996,20999.999999999996,20999.999999999996,20999.999999999996,20999.999999999996,20999.999999999996,20999.999999999996,20999.999999999996,20999.999999999996,20999.999999999996,20999.999999999996,20999.999999999996,20999.999999999996,20999.999999999996,20999.999999999996]
["Total capex",null,null,null,{"$f":"SUM(E9:E12)","v":9908138.1949215569},12943427.244752714,13021450.443309357,11485077.102645703,10631158.194032369,12265700.65213426,14186218.368078804,10229297.938226091,11580742.319749681,9776771.5518436395,8850812.8559655566,8312642.7812309805,7814613.2324668178,6031570.2122614365,6030686.7351224702,6145143.5867476333,4021049.5867852392,4129764.0241756248,3570789.2241327157,3647733.0857327227,3962034.8057488175,4001878.1413142104,4008060.8264587559,3919801.5305992691,3891372.9797225054,3817674.9588737865,3772356.3645546888,3771633.3880866123,3648661.5799357379,3648661.5799357379]
[]
[]
[]
["Opening DAV (Capex Only)",null,{"$f":"'Opening Values'!C19","v":"Mains"},{"$f":"'Opening Values'!E19","v":1749869.6483703593}]
[null,null,{"$f":"'Opening Values'!C20","v":"Other Capex"},{"$f":"'Opening Values'!E20","v":426028.85367114784}]
[null,null,null,{"$f":"SUM(D16:D18)","v":2175898.502041507}]
[]
["Depreciation",null,"Useful Life"]
["Opening DAV",null,40,null,{"$f":"(($D$17+$D$18)/$C$22)","v":54397.462551037679},54397.462551037679,54397.462551037679,54397.462551037679,54397.462551037679,54397.462551037679,54397.462551037679,54397.462551037679,54397.462551037679,54397.462551037679,54397.462551037679,54397.462551037679,54397.462551037679,54397.462551037679,54397.462551037679,54397.462551037679,54397.462551037679,54397.462551037679,54397.462551037679,54397.462551037679,54397.462551037679,54397.462551037679,54397.462551037679,54397.462551037679,54397.462551037679,54397.462551037679,54397.462551037679,54397.462551037679,54397.462551037679,54397.462551037679]
[{"$f":"A9","v":"Mains"},null,40,null,{"$f":"(SUM($D$9:E9)/$C$23)","v":217194.02369611227},{"$f":"(SUM($D$9:F9)/$C$23)","v":501094.19830948673},{"$f":"(SUM($D$9:G9)/$C$23)","v":722452.55617927376},{"$f":"(SUM($D$9:H9)/$C$23)","v":999802.1029754855},{"$f":"(SUM($D$9:I9)/$C$23)","v":1270263.6864240654},{"$f":"(SUM($D$9:J9)/$C$23)","v":1461495.3733971878},{"$f":"(SUM($D$9:K9)/$C$23)","v":1612294.5471930094},{"$f":"(SUM($D$9:L9)/$C$23)","v":1739129.2282442786},{"$f":"(SUM($D$9:M9)/$C$23)","v":1931460.7362380207},{"$f":"(SUM($D$9:N9)/$C$23)","v":2083931.4250341118},{"$f":"(SUM($D$9:O9)/$C$23)","v":2220814.2714332505},{"$f":"(SUM($D$9:P9)/$C$23)","v":2348198.3528772555},{"$f":"(SUM($D$9:Q9)/$C$23)","v":2462707.5717297904},{"$f":"(SUM($D$9:R9)/$C$23)","v":2545404.4697341369},{"$f":"(SUM($D$9:S9)/$C$23)","v":2628089.3357532327},{"$f":"(SUM($D$9:T9)/$C$23)","v":2710512.4061704082},{"$f":"(SUM($D$9:U9)/$C$23)","v":2752231.5307430299},{"$f":"(SUM($D$9:V9)/$C$23)","v":2793219.0293979635},{"$f":"(SUM($D$9:W9)/$C$23)","v":2820381.9441501116},{"$f":"(SUM($D$9:X9)/$C$23)","v":2847806.7775782044},{"$f":"(SUM($D$9:Y9)/$C$23)","v":2875123.1001609224},{"$f":"(SUM($D$9:Z9)/$C$23)","v":2902443.3187424131},{"$f":"(SUM($D$9:AA9)/$C$23)","v":2927204.5629184735},{"$f":"(SUM($D$9:AB9)/$C$23)","v":2951350.9551885622},{"$f":"(SUM($D$9:AC9)/$C$23)","v":2975514.8735937877},{"$f":"(SUM($D$9:AD9)/$C$23)","v":2999708.6612010314},{"$f":"(SUM($D$9:AE9)/$C$23)","v":3023914.503330064},{"$f":"(SUM($D$9:AF9)/$C$23)","v":3048115.8254713048},{"$f":"(SUM($D$9:AG9)/$C$23)","v":3072364.2318041483},{"$f":"(SUM($D$9:AH9)/$C$23)","v":3096612.6381369922}]
[{"$f":"A10","v":"Services"},null,40,null,{"$f":"SUM($D$10:E10)/$C$24","v":9187.7141721352855},{"$f":"SUM($D$10:F10)/$C$24","v":25655.54470311301},{"$f":"SUM($D$10:G10)/$C$24","v":65427.970790172651},{"$f":"SUM($D$10:H10)/$C$24","v":50486.671427149944},{"$f":"SUM($D$10:I10)/$C$24","v":19375.55103139647},{"$f":"SUM($D$10:J10)/$C$24","v":106043.74701852414},{"$f":"SUM($D$10:K10)/$C$24","v":273228.78142862057},{"$f":"SUM($D$10:L10)/$C$24","v":370878.0615022055},{"$f":"SUM($D$10:M10)/$C$24","v":438681.26150220551},{"$f":"SUM($D$10:N10)/$C$24","v":504980.11150220549},{"$f":"SUM($D$10:O10)/$C$24","v":566322.11150220549},{"$f":"SUM($D$10:P10)/$C$24","v":624786.09563575021},{"$f":"SUM($D$10:Q10)/$C$24","v":683553.67386048869},{"$f":"SUM($D$10:R10)/$C$24","v":733358.76770831121},{"$f":"SUM($D$10:S10)/$C$24","v":783156.61516395886},{"$f":"SUM($D$10:T10)/$C$24","v":832796.7934102742},{"$f":"SUM($D$10:U10)/$C$24","v":870747.85354703106},{"$f":"SUM($D$10:V10)/$C$24","v":908033.36809805909},{"$f":"SUM($D$10:W10)/$C$24","v":943954.99434281385},{"$f":"SUM($D$10:X10)/$C$24","v":980222.99522628752},{"$f":"SUM($D$10:Y10)/$C$24","v":1016347.4958239254},{"$f":"SUM($D$10:Z10)/$C$24","v":1052477.1486893902},{"$f":"SUM($D$10:AA10)/$C$24","v":1088724.0305328981},{"$f":"SUM($D$10:AB10)/$C$24","v":1124921.3999282275},{"$f":"SUM($D$10:AC10)/$C$24","v":1161145.0423990749},{"$f":"SUM($D$10:AD10)/$C$24","v":1197413.4611879294},{"$f":"SUM($D$10:AE10)/$C$24","v":1233699.9506671461},{"$f":"SUM($D$10:AF10)/$C$24","v":1269979.6643238734},{"$f":"SUM($D$10:AG10)/$C$24","v":1306329.960942108},{"$f":"SUM($D$10:AH10)/$C$24","v":1342680.2575603428}]
["Meters, telemtry",null,15,null,{"$f":"SUM($E$11:E11)/$C$25","v":30656.936935217553},{"$f":"SUM($E$11:F11)/$C$25","v":88001.10261548878},{"$f":"SUM($E$11:G11)/$C$25","v":209552.5576468104},{"$f":"SUM($E$11:H11)/$C$25","v":271747.20604079892},{"$f":"SUM($E$11:I11)/$C$25","v":338538.5705278042},{"$f":"SUM($E$11:J11)/$C$25","v":425213.16979376244},{"$f":"SUM($E$11:K11)/$C$25","v":519391.88262040768},{"$f":"SUM($E$11:L11)/$C$25","v":599146.00523800426},{"$f":"SUM($E$11:M11)/$C$25","v":669369.60523800424},{"$f":"SUM($E$11:N11)/$C$25","v":736302.27190467098},{"$f":"SUM($E$11:O11)/$C$25","v":796356.87190467096},{"$f":"SUM($E$11:P11)/$C$25","v":853538.21577993757},{"$f":"SUM($E$11:Q11)/$C$25","v":911040.9724049964},{"$f":"SUM($E$11:R11)/$C$25","v":958407.00828330801},{"$f":"SUM(E11:S11)/$C$25","v":1005765.5546921568},1031216.1937708064,1028088.1746512086,971726.28601569636,977958.80990548281,983102.0929698149,989987.61893949588,992001.1250085833,1015362.7214360548,1044142.5257015579,1074201.2286801974,1106025.7422155212,1137621.9383552356,1168878.6454747037,1201760.1737225659,1234649.1914398903]
["Other Capex",null,5,null,{"$f":"SUM($E$12:E12)/$C$26","v":78602.92523267839},{"$f":"SUM($E$12:F12)/$C$26","v":92311.835987590486},{"$f":"SUM($E$12:G12)/$C$26","v":242901.2879007239},{"$f":"SUM($E$12:H12)/$C$26","v":254066.78378238654},{"$f":"SUM(E12:I12)/$C$26","v":265120.62470523256},156434.96841952947,153559.92715309878,13696.006033561973,26930.510151899314,20276.669229053288,54559.400282077979,47925.530793596583,41400,21200,20999.999999999996,20999.999999999996,20999.999999999996,20999.999999999996,20999.999999999996,20999.999999999996,20999.999999999996,20999.999999999996,20999.999999999996,20999.999999999996,20999.999999999996,20999.999999999996,20999.999999999996,20999.999999999996,20999.999999999996,20999.999999999996]
["Total depreciation",null,null,null,{"$f":"SUM(E22:E26)","v":390039.06258718111},{"$f":"SUM(F22:F26)","v":761460.14416671672},{"$f":"SUM(G22:G26)","v":1294731.8350680184},{"$f":"SUM(H22:H26)","v":1630500.2267768586},1947695.8952395367,2203584.7211800418,2612872.6009461745,2777246.7635690887,{"$f":"SUM(M22:M26)","v":3120839.5756811677},3399887.9402210796,3692450.1176732429,3928845.657637578,4153099.6805463131,4312767.7082767943,4492408.9681603862,4649922.8559025265,4726465.0214923071,4748376.1460627569,4817693.2109494461,4886529.3283253452,4956855.6774753816,5022319.0549914241,5106688.7774384636,5195812.3433693852,5286258.6072240975,5378545.3271555193,5470633.8549034838,5562371.5978209199,5655851.8290198604,5749339.5496882629]
[]
["DAV"]
["Opening balance",null,null,null,{"$f":"D33","v":2175898.502041507},{"$f":"E33","v":11693997.634375883},23875964.734961882,35602683.343203224,45457260.219072066,54140722.517864898,64202838.448819116,75776184.215951741,83228235.390608743,91688138.134677261,98065021.746299818,103223384.48459212,107607181.60818553,111268695.16010603,112987497.66409068,114525775.43105276,116020996.16189787,115315580.72719081,114696968.60530367,113450064.61848694,112211268.37589432,111216447.50416777,110196006.59049055,109097378.63951084,107821367.82674073,106426482.19923913,104865611.83095741,103167334.34060861,101376596.13087431,99369405.881790191]
["Capex",null,null,null,{"$f":"E13","v":9908138.1949215569},{"$f":"F13","v":12943427.244752714},{"$f":"G13","v":13021450.443309357},11485077.102645703,10631158.194032369,12265700.65213426,14186218.368078804,{"$f":"L13","v":10229297.938226091},11580742.319749681,9776771.5518436395,8850812.8559655566,8312642.7812309805,7814613.2324668178,6031570.2122614365,6030686.7351224702,6145143.5867476333,4021049.5867852392,4129764.0241756248,3570789.2241327157,3647733.0857327227,3962034.8057488175,4001878.1413142104,4008060.8264587559,3919801.5305992691,3891372.9797225054,3817674.9588737865,3772356.3645546888,3771633.3880866123,3648661.5799357379,3648661.5799357379]
["Depreciation",null,null,null,{"$f":"-E27","v":-390039.06258718111},{"$f":"-F27","v":-761460.14416671672},{"$f":"-G27","v":-1294731.8350680184},-1630500.2267768586,-1947695.8952395367,-2203584.7211800418,-2612872.6009461745,{"$f":"-L27","v":-2777246.7635690887},{"$f":"-M27","v":-3120839.5756811677},-3399887.9402210796,-3692450.1176732429,-3928845.657637578,-4153099.6805463131,-4312767.7082767943,-4492408.9681603862,-4649922.8559025265,-4726465.0214923071,-4748376.1460627569,-4817693.2109494461,-4886529.3283253452,-4956855.6774753816,-5022319.0549914241,-5106688.7774384636,-5195812.3433693852,-5286258.6072240975,-5378545.3271555193,-5470633.8549034838,-5562371.5978209199,-5655851.8290198604,-5749339.5496882629]
["Closing balance",null,null,{"$f":"D19","v":2175898.502041507},{"$f":"SUM(E30:E32)","v":11693997.634375883},23875964.734961882,35602683.343203224,45457260.219072066,54140722.517864898,64202838.448819116,75776184.215951741,83228235.390608743,{"$f":"SUM(M30:M32)","v":91688138.134677261},98065021.746299818,103223384.48459212,107607181.60818553,111268695.16010603,112987497.66409068,114525775.43105276,116020996.16189787,115315580.72719081,114696968.60530367,113450064.61848694,112211268.37589432,111216447.50416777,110196006.59049055,109097378.63951084,107821367.82674073,106426482.19923913,104865611.83095741,103167334.34060861,101376596.13087431,99369405.881790191,97268727.912037671]

{"sheet":"Pi's Calc","index":3,"n_rows":61,"n_cols":25,"rows_kept":61,"cut":false,"hidden":false,"merged":[[1,3,1,4],[1,0,1,2],[21,0,21,24],[45,0,45,24],[51,0,51,24],[29,0,29,24],[33,0,33,24],[37,0,37,24],[43,0,43,24],[10,6,10,24],[9,0,9,24]]}
[{"$f":"242.7/193.4","v":1.2549120992761116}]
["Firmus Energy P Tariff Model - Calculation of Pi tariffs, Allowed Revenues, PA and TRV",null,null,"Return"]
[null,null,null,"To 2016",7.4999999999999997E-2]
[null,"£2012",null,"Post 2016",4.8300000000000003E-2]
[null,"£'000"]
["Real Return pa",null,null,{"$f":"E3","v":7.4999999999999997E-2},{"$f":"D6","v":7.4999999999999997E-2},{"$f":"E6","v":7.4999999999999997E-2},{"$f":"E4","v":4.8300000000000003E-2},{"$f":"G6","v":4.8300000000000003E-2},{"$f":"H6","v":4.8300000000000003E-2},4.8300000000000003E-2,4.8300000000000003E-2,4.8300000000000003E-2,4.8300000000000003E-2,4.8300000000000003E-2,4.8300000000000003E-2,4.8300000000000003E-2,4.8300000000000003E-2,4.8300000000000003E-2,4.8300000000000003E-2,4.8300000000000003E-2,4.8300000000000003E-2,4.8300000000000003E-2,4.8300000000000003E-2,4.8300000000000003E-2,4.8300000000000003E-2]
["Discount Factor (Mid Yr)",0.5,1,{"$f":"D8*(1+D6*$B$7)","v":0.96511627906976749},{"$f":"E8*(1+E6*$B$7)","v":0.89778258518117915},0.83514659086621323,0.78641645260255644,0.75018263150105546,0.71561826910336301,0.68264644577254885,0.65119378591295318,0.62119029467991338,0.59256920221302423,0.56526681504628851,0.53922237436448384,0.51437792079031175,0.49067816540142306,0.4680703666902824,0.44650421319305772,0.42593171152633563,0.40630707958250084,0.38758664464609449,0.36972874620442092,0.35269364323611652,0.33644342577135983]
["Discount Factor (Yr End)",null,1,{"$f":"C8/(1+D6)","v":0.93023255813953487},{"$f":"D8/(1+E6)","v":0.86533261222282321},0.80496056950960304,0.76787233569550994,0.73249292730660109,0.69874361090012505,0.66654928064497287,0.63583829118093371,0.60654229817889316,0.57859610624715552,0.55193752384542161,0.52650722488354629,0.50224861669707743,0.4791077141057688,0.45703301927479612,0.43597540711131938,0.41588801594135205,0.39672614322364974,0.3784471460685393,0.36101034634030266,0.34437694013193043,0.32850991141078928]
[]
[]
[null,null,null,null,null,null,"IMPORTANT NOTE:  Values from 2017 Onwards are forecasts and will be determined as part of the Next Price Control.  This Model is re-run at each Price Control Period, to calculate allowed Revenues."]
[null,null,2013,2014,{"$f":"D12+1","v":2015},2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,{"$f":"X12+1","v":2035}]
[]
["Capex",null,null,11580.742319749681,9776.771551843638,8850.8128559655543,8312.6427812309812,7814.613232466817,6031.5702122614357,6030.6867351224691,6145.1435867476312,4021.0495867852392,4129.7640241756244,3570.7892241327158,3647.7330857327233,3962.0348057488172,4001.8781413142106,4008.0608264587554,3919.8015305992685,3891.3729797225055,3817.6749588737857,3772.3563645546888,3771.6333880866123,3648.6615799357369,3648.6615799357369]
["Opex",null,null,5371.0376591285503,5566.0059150725738,5819.3777773323709,5676.6507463548232,5889.9106318628083,6195.5786537571084,6331.9630260989197,6608.5236774970826,6716.8460390271366,6852.9910100459374,7120.4583722833249,7229.2955289455294,7302.5617430316879,7396.6190931454139,7494.7517537788945,7521.8762148606966,7628.7758050535876,7739.7839595795576,7738.7924557365386,7833.7742138303711,7943.7509467793589,8046.4539805546829]
["Volumes (therms '000)",null,null,58570.386793977174,60909.452521140091,62955.214829535966,63206.791482785804,63460.883902568152,63717.517246548305,63976.71692396827,64238.508598162429,64502.918189098535,64649.626141251647,64797.801172926309,64947.457954917714,65098.611304729027,65251.27618803845,65405.467720180983,65561.201167644933,65718.49194958352,65877.355639341491,66037.807965997054,66199.864815919165,66363.542234340493,66528.856426946033]
["£/therm"]
["P Dom (P1)",null,null,0.44844183597538861,{"$f":"D18","v":0.44844183597538861},{"$f":"E18","v":0.44844183597538861},0.44844183597538861,0.44844183597538861,0.44844183597538861,0.44844183597538861,0.44844183597538861,0.44844183597538861,0.44844183597538861,0.44844183597538861,0.44844183597538861,0.44844183597538861,0.44844183597538861,0.44844183597538861,0.44844183597538861,0.44844183597538861,0.44844183597538861,0.44844183597538861,0.44844183597538861,0.44844183597538861,0.44844183597538861]
["P SME (P2 + P3)",null,0.68134311258632596,{"$f":"$D$18*C19","v":0.30554275633739791},{"$f":"D19","v":0.30554275633739791},0.30554275633739791,0.30554275633739791,0.30554275633739791,0.30554275633739791,0.30554275633739791,0.30554275633739791,0.30554275633739791,0.30554275633739791,0.30554275633739791,0.30554275633739791,0.30554275633739791,0.30554275633739791,0.30554275633739791,0.30554275633739791,0.30554275633739791,0.30554275633739791,0.30554275633739791,0.30554275633739791,0.30554275633739791,0.30554275633739791]
["P Contract (P4, P5 + P6)",null,0.59008170977553098,{"$f":"$D$18*C20","v":0.26461732530723553},0.26461732530723553,0.26461732530723553,0.26461732530723553,0.26461732530723553,0.26461732530723553,0.26461732530723553,0.26461732530723553,0.26461732530723553,0.26461732530723553,0.26461732530723553,0.26461732530723553,0.26461732530723553,0.26461732530723553,0.26461732530723553,0.26461732530723553,0.26461732530723553,0.26461732530723553,0.26461732530723553,0.26461732530723553,0.26461732530723553,0.26461732530723553]
[]
["Conditions 4.6 and 4.6.6 Establishing Best Available Revenue Per Unit and Calculating Cashflow"]
[]
["Allowed Revenue",null,null,{"$f":"SUMPRODUCT(D18:D20,[4]Volumes!C5:C7)/1000","v":17525.944532405567},{"$f":"SUMPRODUCT(E18:E20,[4]Volumes!D5:D7)/1000","v":18464.65412132761},{"$f":"SUMPRODUCT(F18:F20,[4]Volumes!E5:E7)/1000","v":19308.69181505073},{"$f":"SUMPRODUCT(G18:G20,[4]Volumes!F5:F7)/1000","v":19401.759868670611},{"$f":"SUMPRODUCT(H18:H20,[4]Volumes!G5:G7)/1000","v":19495.758602826692},{"$f":"SUMPRODUCT(I18:I20,[4]Volumes!H5:H7)/1000","v":19590.697324324337},{"$f":"SUMPRODUCT(J18:J20,[4]Volumes!I5:I7)/1000","v":19686.585433036955},{"$f":"SUMPRODUCT(K18:K20,[4]Volumes!J5:J7)/1000","v":19783.432422836697},{"$f":"SUMPRODUCT(L18:L20,[4]Volumes!K5:K7)/1000","v":19881.247882534444},{"$f":"SUMPRODUCT(M18:M20,[4]Volumes!L5:L7)/1000","v":19926.073434611924},{"$f":"SUMPRODUCT(N18:N20,[4]Volumes!M5:M7)/1000","v":19971.34724221018},{"$f":"SUMPRODUCT(O18:O20,[4]Volumes!N5:N7)/1000","v":20017.073787884419},{"$f":"SUMPRODUCT(P18:P20,[4]Volumes!O5:O7)/1000","v":20063.257599015396},{"$f":"SUMPRODUCT(Q18:Q20,[4]Volumes!P5:P7)/1000","v":20109.903248257688},{"$f":"SUMPRODUCT(R18:R20,[4]Volumes!Q5:Q7)/1000","v":20157.015353992403},{"$f":"SUMPRODUCT(S18:S20,[4]Volumes!R5:R7)/1000","v":20204.598580784463},{"$f":"SUMPRODUCT(T18:T20,[4]Volumes!S5:S7)/1000","v":20252.657639844445},{"$f":"SUMPRODUCT(U18:U20,[4]Volumes!T5:T7)/1000","v":20301.19728949502},{"$f":"SUMPRODUCT(V18:V20,[4]Volumes!U5:U7)/1000","v":20350.222335642109},{"$f":"SUMPRODUCT(W18:W20,[4]Volumes!V5:V7)/1000","v":20399.737632250668},{"$f":"SUMPRODUCT(X18:X20,[4]Volumes!W5:W7)/1000","v":20449.74808182531},{"$f":"SUMPRODUCT(Y18:Y20,[4]Volumes!X5:X7)/1000","v":20500.258635895698}]
["Capex",null,null,{"$f":"-D14","v":-11580.742319749681},{"$f":"-E14","v":-9776.771551843638},-8850.8128559655543,-8312.6427812309812,-7814.613232466817,-6031.5702122614357,-6030.6867351224691,-6145.1435867476312,-4021.0495867852392,-4129.7640241756244,-3570.7892241327158,-3647.7330857327233,-3962.0348057488172,-4001.8781413142106,-4008.0608264587554,-3919.8015305992685,-3891.3729797225055,-3817.6749588737857,-3772.3563645546888,-3771.6333880866123,-3648.6615799357369,-3648.6615799357369]
["Opex",null,null,{"$f":"-D15","v":-5371.0376591285503},{"$f":"-E15","v":-5566.0059150725738},-5819.3777773323709,-5676.6507463548232,-5889.9106318628083,-6195.5786537571084,-6331.9630260989197,-6608.5236774970826,-6716.8460390271366,-6852.9910100459374,-7120.4583722833249,-7229.2955289455294,-7302.5617430316879,-7396.6190931454139,-7494.7517537788945,-7521.8762148606966,-7628.7758050535876,-7739.7839595795576,-7738.7924557365386,-7833.7742138303711,-7943.7509467793589,-8046.4539805546829]
[]
["Cashflows",null,null,{"$f":"SUM(D24:D27)","v":574.16455352733556},{"$f":"SUM(E24:E27)","v":3121.8766544113987},4638.5011817528048,5412.466341084807,5791.2347384970662,7363.5484583057942,7323.9356718155668,7029.7651585919821,9143.352256722068,8943.3184003903625,9280.0996457941383,9140.0451732061665,8798.6610502348922,8711.4060137980632,8654.2027737547542,8762.9208353244976,8732.5088550683504,8743.738371041678,8839.0735153508813,8794.3300303336855,8857.3355551102122,8805.1430754052762]
[]
[]
[]
["Discounted Cashflow",null,{"$f":"SUM(D32:Y32)","v":88631.768392382946},{"$f":"D28*D7","v":554.13555747405644},2802.7664934142363,3873.8284486697562,4256.4525797866518,4344.4837157660559,5269.4898021915296,4999.6586554316818,4577.7393877024842,5679.7616827154325,5299.5350496563769,5245.7323700902425,4928.5168600948691,4525.8369767585245,4274.4967209173574,4050.7758657234467,3912.6810728496171,3719.452442558144,3552.6428021713973,3425.9068455950073,3251.5166158231605,3123.9259462966111,2962.4325006963181]
[]
[]
[]
["Closing DAV",null,null,{"$f":"DAV!M33/1000","v":91688.138134677254},{"$f":"DAV!N33/1000","v":98065.021746299812},{"$f":"DAV!O33/1000","v":103223.38448459213},{"$f":"DAV!P33/1000","v":107607.18160818554},{"$f":"DAV!Q33/1000","v":111268.69516010603},{"$f":"DAV!R33/1000","v":112987.49766409068},{"$f":"DAV!S33/1000","v":114525.77543105275},{"$f":"DAV!T33/1000","v":116020.99616189787},{"$f":"DAV!U33/1000","v":115315.58072719081},{"$f":"DAV!V33/1000","v":114696.96860530367},{"$f":"DAV!W33/1000","v":113450.06461848694},{"$f":"DAV!X33/1000","v":112211.26837589432},{"$f":"DAV!Y33/1000","v":111216.44750416777},{"$f":"DAV!Z33/1000","v":110196.00659049055},{"$f":"DAV!AA33/1000","v":109097.37863951085},{"$f":"DAV!AB33/1000","v":107821.36782674072},{"$f":"DAV!AC33/1000","v":106426.48219923914},{"$f":"DAV!AD33/1000","v":104865.61183095741},{"$f":"DAV!AE33/1000","v":103167.33434060861},{"$f":"DAV!AF33/1000","v":101376.5961308743},{"$f":"DAV!AG33/1000","v":99369.405881790197},{"$f":"DAV!AH33/1000","v":97268.727912037677}]
[]
[]
[]
["TRV",null,{"$f":"-C56","v":-120585.50958180657}]
["Discounted DAV2035",null,{"$f":"Y36*Y8","v":31953.741189423665}]
["Backsolve to 0 by running Macro Ctrl + q",null,{"$f":"SUM(C32:C41)","v":3.637978807091713E-11}]
[]
[]
[]
["Condition 4.6.8 Calculating TRV"]
[]
[null,"Total Regulatory Value (TRV)",null,null,null,{"$f":"F58+F60","v":140820.28782019269},null,null,null,null,{"$f":"K58+K60","v":141399.08871230003},null,null,null,null,{"$f":"P58+P60","v":127880.03762844086},null,null,null,null,{"$f":"U58+U60","v":112716.35071607991},null,null,null,{"$f":"Y58+Y60","v":97268.727912037313}]
[]
[]
[]
["Condition 4.6.9 Calculating Profile Adjustment"]
[]
[null,"Adjusted Cashflows",null,{"$f":"D28*(1+$F$6*$B$7)*(1+$F$6)^($F$12-D12)","v":688.40087137640319},{"$f":"E28*(1+$F$6*$B$7)*(1+$F$6)^($F$12-E12)","v":3481.8680561232131},{"$f":"F28*(1+$F$6*$B$7)*(1+$F$6)^($F$12-F12)","v":4812.4449760685357},{"$f":"G28*(1+$K$6*$B$7)*(1+$K$6)^($K$12-G12)","v":6694.2375739611416},{"$f":"H28*(1+$K$6*$B$7)*(1+$K$6)^($K$12-H12)","v":6832.6865116869667},{"$f":"I28*(1+$K$6*$B$7)*(1+$K$6)^($K$12-I12)","v":8287.4684888898046},{"$f":"J28*(1+$K$6*$B$7)*(1+$K$6)^($K$12-J12)","v":7863.0977793833144},{"$f":"K28*(1+$K$6*$B$7)*(1+$K$6)^($K$12-K12)","v":7199.533987171978},{"$f":"L28*(1+$P$6*$B$7)*(1+$P$6)^($P$12-L12)","v":11308.66565659668},{"$f":"M28*(1+$P$6*$B$7)*(1+$P$6)^($P$12-M12)","v":10551.617014910964},{"$f":"N28*(1+$P$6*$B$7)*(1+$P$6)^($P$12-N12)","v":10444.493415606787},{"$f":"O28*(1+$P$6*$B$7)*(1+$P$6)^($P$12-O12)","v":9812.9028059970133},{"$f":"P28*(1+$P$6*$B$7)*(1+$P$6)^($P$12-P12)","v":9011.1487145980645},{"$f":"Q28*(1+$U$6*$B$7)*(1+$U$6)^($U$12-Q12)","v":10774.426626348288},{"$f":"R28*(1+$U$6*$B$7)*(1+$U$6)^($U$12-R12)","v":10210.509024709947},{"$f":"S28*(1+$U$6*$B$7)*(1+$U$6)^($U$12-S12)","v":9862.4230837338291},{"$f":"T28*(1+$U$6*$B$7)*(1+$U$6)^($U$12-T12)","v":9375.3651129095015},{"$f":"U28*(1+$U$6*$B$7)*(1+$U$6)^($U$12-U12)","v":8954.8996527023337},{"$f":"V28*(1+$Y$6*$B$7)*(1+$Y$6)^($Y$12-V12)","v":10428.625519645402},{"$f":"W28*(1+$Y$6*$B$7)*(1+$Y$6)^($Y$12-W12)","v":9897.7732570061216},{"$f":"X28*(1+$Y$6*$B$7)*(1+$Y$6)^($Y$12-X12)","v":9509.3811108495265},{"$f":"Y28*(1+$Y$6*$B$7)*(1+$Y$6)^($Y$12-Y12)","v":9017.7872806763135}]
[]
[null,"Closing TRV (Incl Return)",{"$f":"'Opening Values'!M15/1000","v":120585.50958180657},null,null,{"$f":"-$C$56*(1+F6)^(F12-C12)","v":-149803.00172376086},null,null,null,null,{"$f":"-F48*(1+K6)^(K12-F12)","v":-178276.11305339323},null,null,null,null,{"$f":"-K48*(1+P6)^(P12-K12)","v":-179008.86523615036},null,null,null,null,{"$f":"-P48*(1+U6)^(U12-P12)","v":-161893.9742164838},null,null,null,{"$f":"-U48*(1+Y6)^(Y12-U12)","v":-136122.29508021468}]
[]
[null,"DAV",null,null,null,{"$f":"F36","v":103223.38448459213},null,null,null,null,{"$f":"K36","v":116020.99616189787},null,null,null,null,{"$f":"P36","v":111216.44750416777},null,null,null,null,{"$f":"U36","v":104865.61183095741},null,null,null,{"$f":"Y36","v":97268.727912037677}]
[]
[null,"Calculated PA",null,null,null,{"$f":"-SUM(D54:F59)","v":37596.903335600568},null,null,null,null,{"$f":"-SUM(G54:K59)","v":25378.092550402158},null,null,null,null,{"$f":"-SUM(L54:P59)","v":16663.590124273091},null,null,null,null,{"$f":"-SUM(Q54:U59)","v":7850.7388851224969},null,null,null,{"$f":"-SUM(V54:Y59)","v":-3.637978807091713E-10}]
[null,"Check",null,null,null,{"$f":"SUM(D54:F60)","v":0},null,null,null,null,{"$f":"SUM(G54:K60)","v":0},null,null,null,null,{"$f":"SUM(L54:P60)","v":0},null,null,null,null,{"$f":"SUM(Q54:U60)","v":0},null,null,null,{"$f":"SUM(V54:Y60)","v":0}]