{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Opening Values","DAV","Pi's Calc"],"not_rendered":{"charts":0,"images":17,"macros":1,"external_links":4,"defined_names":60,"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":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[[23,2,23,6],[1,1,3,1],[1,3,4,3],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[8,1,8,3],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2]]}
[]
[null,"Calculating Opening Values",null,"RPI","2006-09-01",200.1]
[null,null,null,null,"2010-09-01",225.3]
[null,null,null,null,"2011-09-01",237.9]
[null,null,null,null,"2012-09-01",244.2]
[]
[]
[]
[null,"Opening DAV/TRV (2014)"]
[null,"£2012",null,2013]
[null,null,null,"£'000s"]
[null,"DAV",null,{"$f":"DAV!F32","v":390529.06654725899}]
[null,"Q",null,-4114.9223812817199]
[null,"CC",null,-4432.6622818324704]
[null,"PA",null,{"$f":"111809.438314822*rpi_12/rpi_10","v":121188.92515081904}]
[null,"TRV Retrospective Adjustments",null,418.49983119357103]
[]
[null,"TRV",null,{"$f":"SUM(D12:D16)","v":503588.90686615743}]
[]
[null,"N.B. for GD14 this TRV of £503.6m is as per Final Document Paragraph 10.40:"]
[]
[null,"http://www.uregni.gov.uk/uploads/publications/2013-12-20_GD14_Price_Control_for_NI_GDNs_2014-2016_Final_Determination.pdf"]
[]
[null,"5-year Allowed Capex Overspend","£'000s"]
[null,"£2006",2012,2013,2014,2015,2016]
[null,"Inclusions of overspend in DAVt",{"$f":"0/1000","v":0},{"$f":"0/1000","v":0},{"$f":"299551.037728997/1000","v":299.55103772899702},{"$f":"480869.248089519/1000","v":480.86924808951898},{"$f":"270457.265233916/1000","v":270.45726523391602}]
[null,"remaining average life",0,0,24,25,22]
[]
[null,"For detail on the Rolling Capex Incentive please see Appendix 5 of:"]
[]
[null,"http://www.uregni.gov.uk/uploads/publications/PNGL12_Final_Decisions_FINAL.pdf"]

{"sheet":"DAV","index":1,"n_rows":32,"n_cols":39,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,2,1],[4,9,4,38]]}
["Condition 2.3.17 Calculation of DAV"]
[null,null,"£2012"]
[null,null,"£'000"]
[]
[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,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,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046]
[]
["Opening DAV (Incl Rolling Capex Incentive)",null,null,null,{"$f":"D32+'Opening Values'!C26*rpi_12/rpi_06","v":388965.43101734912},{"$f":"E32+'Opening Values'!D26*rpi_12/rpi_06","v":390258.65534140245},{"$f":"F32+'Opening Values'!E26*rpi_12/rpi_06","v":390894.63557980984},{"$f":"G32+'Opening Values'!F26*rpi_12/rpi_06","v":391371.84878211521},{"$f":"H32+'Opening Values'!G26*rpi_12/rpi_06","v":391428.90164266102},{"$f":"I32","v":390605.6985039296},391024.44748495205,390836.25599915342,389125.17696504161,389406.83200457611,386636.79304380197,384717.03330544324,384096.95463418536,378871.98415472475,372894.39361518022,365674.31687195768,357856.44672808796,348889.78097213985,339742.84334874898,330168.95221252402,320743.19797550305,311329.81335328601,301363.50786829751,291085.02485844941,280592.86134591058,269873.88130251266,254667.98825752659,239641.93914948811,224753.0920121815,209955.82586020694,195134.1350375016,180323.55363019244,165469.63640781093,150582.67307555754,135654.39527079408]
[]
["Capex"]
["Mains",null,null,null,2661.6432911661996,2662.8019073722076,2703.0962826975324,2784.9985089325924,2695.9875711195518,2757.688307247684,2798.4847400804906,1605.9548495824579,4098.5548495824578,1950.3118918300468,1416.1983714536957,3366.5618918300465,1327.1618918300464,1327.1618918300469,1327.1618918300464,1327.1618918300464,1327.1618918300464,1327.1618918300464,1327.1618918300464,1327.1618918300464,1327.1618918300464,1327.1618918300464,1327.1618918300469,1327.1618918300464,1327.1618918300464,1327.1618918300469,1327.1618918300469,1327.1618918300464,1327.1618918300469,1327.1618918300464,1327.1618918300464,1327.1618918300469,1327.1618918300469,1327.1618918300469,1327.1618918300469]
["Services",null,null,null,4887.380262156249,4406.4877018085444,6339.8860000000032,6434.3860000000004,6509.9859999999999,6304.3424207030348,6304.5871083037218,6439.1593917074306,6439.4125205809387,6196.5597096118954,6196.7908455094093,6197.0189101298465,5343.2361206602836,5343.3857878301051,5343.5339164731258,5343.6805717234765,5343.8258162118163,5343.969710151152,5344.1123114198026,5344.2536756417267,5344.3938562643025,5344.5329046335519,5344.6708700670069,5344.8077999241523,5344.9437396746753,2153.0678947565389,2153.2019834712401,2153.3352077986096,2153.4676062878812,2153.5992159076904,2153.7300721020283,2153.8602088443467,2153.8602088443472,2153.8602088443472,2153.8602088443472]
["Meters",null,null,null,2458.15,2332.9138707317111,2640.6079999999997,2769.8809999999999,2692.34,4678.7685009681409,4609.3217786040259,4818.1341830974252,4957.5539137731284,4924.5342037384153,7009.7557555577605,7115.7370860503379,6101.1699404494175,5950.0808875073062,5263.34992152004,5042.7335085524592,4224.9512039214524,4364.4881196152392,4240.4626800424685,4729.2913860478056,4965.6897922394701,4618.2718736866645,4489.0683776923306,4446.2158111241406,4388.5922742227167,3269.2730346435578,3268.1272451263321,3326.0808852066752,3324.9412744823876,3273.6366371096738,3272.5031774050417,3271.3727828342694,3271.3727828342694,3271.3727828342694,3271.3727828342694]
["Other",null,null,null,3175.6591708130218,3185.4496550930462,988.72461972014912,1006.4316960489302,1020.5973571119553,1006.2030727950721,1010.3071848384213,904.51142412898889,904.53673701633977,852.37216014419425,852.39527373394537,852.41808019598932,767.03980124903308,767.05476796601522,767.06958083031736,767.08424635535243,767.0987708041863,767.11316019811989,767.12742032498488,767.14155674717733,767.15557480943494,767.16947964635995,767.18327618970534,767.19696917541989,767.21056315047224,448.02297865865853,448.03638753012871,448.04970996286562,448.06294981179286,448.07611077377368,448.08919639320749,448.10221006743939,448.10221006743939,448.10221006743944,448.10221006743944]
["Total Capex",null,null,null,{"$f":"SUM(E11:E14)","v":13182.832724135471},12587.653135005508,{"$f":"SUM(G11:G14)","v":12672.314902417686},12995.697204981523,12918.910928231508,14747.00230171393,14722.700811826659,13767.759848516302,16400.058020952863,13923.777965324552,15475.14024625481,17531.73596820622,13538.607754188781,13387.683335133475,12701.115310653529,12480.660218461335,11663.037682767503,11802.732881794558,11678.864303617302,12167.848510266756,12404.401115143253,12057.136149796623,11928.084415779091,11885.38247205376,11827.908468877911,7197.5257998888028,7196.5275079577486,7254.6276947981969,7253.6337224121089,7202.4738556211842,7201.4843377303232,7200.4970935761021,7200.4970935761021,7200.4970935761021,7200.4970935761021]
[]
["Annual depreciation of additional capex"]
["Mains (40 years straight line)",null,null,null,{"$f":"E11/40","v":66.541082279154992},66.570047684305194,{"$f":"G11/40","v":67.577407067438315},69.624962723314809,67.399689277988799,68.942207681192102,69.96211850201226,40.148871239561444,102.46387123956144,48.757797295751168,35.40495928634239,84.164047295751161,33.179047295751161,33.179047295751175,33.179047295751161,33.179047295751161,33.179047295751161,33.179047295751161,33.179047295751161,33.179047295751161,33.179047295751161,33.179047295751161,33.179047295751175,33.179047295751161,33.179047295751161,33.179047295751175,33.179047295751175,33.179047295751161,33.179047295751175,33.179047295751161,33.179047295751161,33.179047295751175,33.179047295751175,33.179047295751175,33.179047295751175]
["Services (35 years straight line)",null,null,null,{"$f":"E12/35","v":139.63943606160711},125.89964862310127,181.13960000000009,183.83960000000002,185.99959999999999,{"$f":"J12/35","v":180.12406916294384},180.13106023724919,183.97598262021231,183.9832148737411,177.04456313176843,177.05116701455455,177.05768314656703,152.66388916172238,152.66816536657444,152.67239761351789,152.67658776352789,152.68073760605191,152.68484886146149,152.68892318342293,152.69296216119218,152.69696732183721,152.70094013238719,152.70488200191448,152.70879428354721,152.7126782764193,61.516225564472542,61.520056670606856,61.523863079960279,61.527645893939464,61.531406168791158,61.53514491720081,61.538863109838481,61.538863109838495,61.538863109838495,61.538863109838495]
["Meters (15 years straight line)",null,null,null,{"$f":"E13/15","v":163.87666666666667},155.52759138211408,176.04053333333331,184.65873333333332,179.48933333333335,311.91790006454272,307.28811857360171,321.20894553982833,330.50359425154187,328.30228024922769,467.31705037051739,474.38247240335585,406.74466269662781,396.67205916715375,350.88999476800268,336.18223390349726,281.66341359476348,290.96587464101594,282.69751200283122,315.28609240318707,331.04598614929802,307.88479157911098,299.27122517948868,296.41438740827601,292.57281828151446,217.95153564290385,217.87514967508881,221.73872568044501,221.66275163215917,218.24244247397826,218.16687849366946,218.09151885561795,218.09151885561795,218.09151885561795,218.09151885561795]
["Other (40 years straight line)",null,null,null,{"$f":"E14/40","v":79.391479270325547},79.636241377326158,24.718115493003729,25.160792401223254,25.514933927798882,25.155076819876804,25.257679620960534,22.612785603224722,22.613418425408494,21.309304003604858,21.309881843348634,21.310452004899734,19.175995031225828,19.176369199150379,19.176739520757934,19.177106158883809,19.177469270104659,19.177829004952997,19.178185508124621,19.178538918679433,19.178889370235872,19.179236991158998,19.179581904742633,19.179924229385499,19.180264078761805,11.200574466466463,11.200909688253217,11.201242749071641,11.201573745294821,11.201902769344342,11.202229909830187,11.202555251685984,11.202555251685984,11.202555251685986,11.202555251685986]
[]
["Depreciation",null,null,null,{"$f":"B24","v":34},{"$f":"E23-1","v":33},{"$f":"F23-1","v":32},31,30,29,28,27,26,25,24,23,22,21,20,19,18,17,16,15,14,13,12,11,10,9,8,7,6,5,4,3,2,1,0]
["Distribution asset (average life remaining)",34,null,null,{"$f":"IF(E23>0,$D$32/$E$23,0)","v":11440.159735804385},11440.159735804385,11440.159735804385,11440.159735804385,11440.159735804385,11440.159735804385,11440.159735804385,11440.159735804385,11440.159735804385,11440.159735804385,11440.159735804385,11440.159735804385,11440.159735804385,11440.159735804385,11440.159735804385,11440.159735804385,11440.159735804385,11440.159735804385,11440.159735804385,11440.159735804385,11440.159735804385,11440.159735804385,11440.159735804385,11440.159735804385,11440.159735804385,11440.159735804385,11440.159735804385,11440.159735804385,11440.159735804385,11440.159735804385,11440.159735804385,11440.159735804385,11440.159735804385,11440.159735804385,{"$f":"IF(AM23>0,($D$32-$E$24-$F$24)/$G$23,0)","v":0}]
["Total Allowed Capex Overspend (average life remaining)",null,null,null,null,null,{"$f":"('Opening Values'!$E$26*rpi_12/rpi_06)/'Opening Values'!$E$27","v":15.232043022951247},{"$f":"('Opening Values'!$E$26*rpi_12/rpi_06)/'Opening Values'!$E$27+('Opening Values'!$F$26*rpi_12/rpi_06)/'Opening Values'!$F$27","v":38.70596014108429},{"$f":"('Opening Values'!$E$26*rpi_12/rpi_06)/'Opening Values'!$E$27+('Opening Values'!$F$26*rpi_12/rpi_06)/'Opening Values'!$F$27+('Opening Values'!$G$26*rpi/rpi_06)/'Opening Values'!$G$27","v":53.708836923175582},{"$f":"('Opening Values'!$E$26*rpi_12/rpi_06)/'Opening Values'!$E$27+('Opening Values'!$F$26*rpi_12/rpi_06)/'Opening Values'!$F$27+('Opening Values'!$G$26*rpi/rpi_06)/'Opening Values'!$G$27","v":53.708836923175582},{"$f":"('Opening Values'!$E$26*rpi_12/rpi_06)/'Opening Values'!$E$27+('Opening Values'!$F$26*rpi_12/rpi_06)/'Opening Values'!$F$27+('Opening Values'!$G$26*rpi/rpi_06)/'Opening Values'!$G$27","v":53.708836923175582},{"$f":"('Opening Values'!$E$26*rpi_12/rpi_06)/'Opening Values'!$E$27+('Opening Values'!$F$26*rpi_12/rpi_06)/'Opening Values'!$F$27+('Opening Values'!$G$26*rpi/rpi_06)/'Opening Values'!$G$27","v":53.708836923175582},{"$f":"('Opening Values'!$E$26*rpi_12/rpi_06)/'Opening Values'!$E$27+('Opening Values'!$F$26*rpi_12/rpi_06)/'Opening Values'!$F$27+('Opening Values'!$G$26*rpi/rpi_06)/'Opening Values'!$G$27","v":53.708836923175582},{"$f":"('Opening Values'!$E$26*rpi_12/rpi_06)/'Opening Values'!$E$27+('Opening Values'!$F$26*rpi_12/rpi_06)/'Opening Values'!$F$27+('Opening Values'!$G$26*rpi/rpi_06)/'Opening Values'!$G$27","v":53.708836923175582},{"$f":"('Opening Values'!$E$26*rpi_12/rpi_06)/'Opening Values'!$E$27+('Opening Values'!$F$26*rpi_12/rpi_06)/'Opening Values'!$F$27+('Opening Values'!$G$26*rpi/rpi_06)/'Opening Values'!$G$27","v":53.708836923175582},{"$f":"('Opening Values'!$E$26*rpi_12/rpi_06)/'Opening Values'!$E$27+('Opening Values'!$F$26*rpi_12/rpi_06)/'Opening Values'!$F$27+('Opening Values'!$G$26*rpi/rpi_06)/'Opening Values'!$G$27","v":53.708836923175582},{"$f":"('Opening Values'!$E$26*rpi_12/rpi_06)/'Opening Values'!$E$27+('Opening Values'!$F$26*rpi_12/rpi_06)/'Opening Values'!$F$27+('Opening Values'!$G$26*rpi/rpi_06)/'Opening Values'!$G$27","v":53.708836923175582},{"$f":"('Opening Values'!$E$26*rpi_12/rpi_06)/'Opening Values'!$E$27+('Opening Values'!$F$26*rpi_12/rpi_06)/'Opening Values'!$F$27+('Opening Values'!$G$26*rpi/rpi_06)/'Opening Values'!$G$27","v":53.708836923175582},{"$f":"('Opening Values'!$E$26*rpi_12/rpi_06)/'Opening Values'!$E$27+('Opening Values'!$F$26*rpi_12/rpi_06)/'Opening Values'!$F$27+('Opening Values'!$G$26*rpi/rpi_06)/'Opening Values'!$G$27","v":53.708836923175582},{"$f":"('Opening Values'!$E$26*rpi_12/rpi_06)/'Opening Values'!$E$27+('Opening Values'!$F$26*rpi_12/rpi_06)/'Opening Values'!$F$27+('Opening Values'!$G$26*rpi/rpi_06)/'Opening Values'!$G$27","v":53.708836923175582},{"$f":"('Opening Values'!$E$26*rpi_12/rpi_06)/'Opening Values'!$E$27+('Opening Values'!$F$26*rpi_12/rpi_06)/'Opening Values'!$F$27+('Opening Values'!$G$26*rpi/rpi_06)/'Opening Values'!$G$27","v":53.708836923175582},{"$f":"('Opening Values'!$E$26*rpi_12/rpi_06)/'Opening Values'!$E$27+('Opening Values'!$F$26*rpi_12/rpi_06)/'Opening Values'!$F$27+('Opening Values'!$G$26*rpi/rpi_06)/'Opening Values'!$G$27","v":53.708836923175582},{"$f":"('Opening Values'!$E$26*rpi_12/rpi_06)/'Opening Values'!$E$27+('Opening Values'!$F$26*rpi_12/rpi_06)/'Opening Values'!$F$27+('Opening Values'!$G$26*rpi/rpi_06)/'Opening Values'!$G$27","v":53.708836923175582},{"$f":"('Opening Values'!$E$26*rpi_12/rpi_06)/'Opening Values'!$E$27+('Opening Values'!$F$26*rpi_12/rpi_06)/'Opening Values'!$F$27+('Opening Values'!$G$26*rpi/rpi_06)/'Opening Values'!$G$27","v":53.708836923175582},{"$f":"('Opening Values'!$E$26*rpi_12/rpi_06)/'Opening Values'!$E$27+('Opening Values'!$F$26*rpi_12/rpi_06)/'Opening Values'!$F$27+('Opening Values'!$G$26*rpi/rpi_06)/'Opening Values'!$G$27","v":53.708836923175582},{"$f":"('Opening Values'!$E$26*rpi_12/rpi_06)/'Opening Values'!$E$27+('Opening Values'!$F$26*rpi_12/rpi_06)/'Opening Values'!$F$27+('Opening Values'!$G$26*rpi/rpi_06)/'Opening Values'!$G$27","v":53.708836923175582},{"$f":"('Opening Values'!$E$26*rpi_12/rpi_06)/'Opening Values'!$E$27+('Opening Values'!$F$26*rpi_12/rpi_06)/'Opening Values'!$F$27+('Opening Values'!$G$26*rpi/rpi_06)/'Opening Values'!$G$27","v":53.708836923175582},{"$f":"('Opening Values'!$E$26*rpi_12/rpi_06)/'Opening Values'!$E$27+('Opening Values'!$F$26*rpi_12/rpi_06)/'Opening Values'!$F$27+('Opening Values'!$G$26*rpi/rpi_06)/'Opening Values'!$G$27","v":53.708836923175582},{"$f":"('Opening Values'!$E$26*rpi_12/rpi_06)/'Opening Values'!$E$27+('Opening Values'!$F$26*rpi_12/rpi_06)/'Opening Values'!$F$27+('Opening Values'!$G$26*rpi/rpi_06)/'Opening Values'!$G$27","v":53.708836923175582},{"$f":"('Opening Values'!$E$26*rpi_12/rpi_06)/'Opening Values'!$E$27+('Opening Values'!$F$26*rpi_12/rpi_06)/'Opening Values'!$F$27+('Opening Values'!$G$26*rpi/rpi_06)/'Opening Values'!$G$27","v":53.708836923175582},{"$f":"('Opening Values'!$F$26*rpi_12/rpi_06)/'Opening Values'!$F$27","v":23.473917118133041},{"$f":"('Opening Values'!$F$26*rpi_12/rpi_06)/'Opening Values'!$F$27","v":23.473917118133041}]
["Mains (40 years straight line)",null,null,null,{"$f":"SUM($C$18:E$18)","v":66.541082279154992},{"$f":"SUM($C$18:F$18)","v":133.1111299634602},{"$f":"SUM($C$18:G$18)","v":200.68853703089852},{"$f":"SUM($C$18:H$18)","v":270.31349975421335},{"$f":"SUM($C$18:I$18)","v":337.71318903220214},{"$f":"SUM($C$18:J$18)","v":406.65539671339423},{"$f":"SUM($C$18:K$18)","v":476.61751521540646},{"$f":"SUM($C$18:L$18)","v":516.76638645496791},{"$f":"SUM($C$18:M$18)","v":619.23025769452931},{"$f":"SUM($C$18:N$18)","v":667.98805499028049},{"$f":"SUM($C$18:O$18)","v":703.39301427662292},{"$f":"SUM($C$18:P$18)","v":787.5570615723741},{"$f":"SUM($C$18:Q$18)","v":820.73610886812526},{"$f":"SUM($C$18:R$18)","v":853.91515616387642},{"$f":"SUM($C$18:S$18)","v":887.09420345962758},{"$f":"SUM($C$18:T$18)","v":920.27325075537874},{"$f":"SUM($C$18:U$18)","v":953.4522980511299},{"$f":"SUM($C$18:V$18)","v":986.63134534688106},{"$f":"SUM($C$18:W$18)","v":1019.8103926426322},{"$f":"SUM($C$18:X$18)","v":1052.9894399383834},{"$f":"SUM($C$18:Y$18)","v":1086.1684872341345},{"$f":"SUM($C$18:Z$18)","v":1119.3475345298857},{"$f":"SUM($C$18:AA$18)","v":1152.5265818256369},{"$f":"SUM($C$18:AB$18)","v":1185.705629121388},{"$f":"SUM($C$18:AC$18)","v":1218.8846764171392},{"$f":"SUM($C$18:AD$18)","v":1252.0637237128904},{"$f":"SUM($C$18:AE$18)","v":1285.2427710086415},{"$f":"SUM($C$18:AF$18)","v":1318.4218183043927},{"$f":"SUM($C$18:AG$18)","v":1351.6008656001438},{"$f":"SUM($C$18:AH$18)","v":1384.779912895895},{"$f":"SUM($C$18:AI$18)","v":1417.9589601916462},{"$f":"SUM($C$18:AJ$18)","v":1451.1380074873973},{"$f":"SUM($C$18:AK$18)","v":1484.3170547831485},{"$f":"SUM($C$18:AL$18)","v":1517.4961020788996},{"$f":"SUM($C$18:AM$18)","v":1550.6751493746508}]
["Services (35 years straight line)",null,null,null,{"$f":"SUM($C$19:E19)","v":139.63943606160711},{"$f":"SUM($C$19:F19)","v":265.53908468470837},{"$f":"SUM($C$19:G19)","v":446.67868468470846},{"$f":"SUM($C$19:H19)","v":630.51828468470853},{"$f":"SUM($C$19:I19)","v":816.51788468470852},{"$f":"SUM($C$19:J19)","v":996.6419538476523},{"$f":"SUM($C$19:K19)","v":1176.7730140849014},{"$f":"SUM($C$19:L19)","v":1360.7489967051138},{"$f":"SUM($C$19:M19)","v":1544.732211578855},{"$f":"SUM($C$19:N19)","v":1721.7767747106234},{"$f":"SUM($C$19:O19)","v":1898.8279417251779},{"$f":"SUM($C$19:P19)","v":2075.8856248717448},{"$f":"SUM($C$19:Q19)","v":2228.5495140334669},{"$f":"SUM($C$19:R19)","v":2381.2176794000416},{"$f":"SUM($C$19:S19)","v":2533.8900770135597},{"$f":"SUM($C$19:T19)","v":2686.5666647770877},{"$f":"SUM($C$19:U19)","v":2839.2474023831396},{"$f":"SUM($C$19:V19)","v":2991.932251244601},{"$f":"SUM($C$19:W19)","v":3144.621174428024},{"$f":"SUM($C$19:X19)","v":3297.3141365892161},{"$f":"SUM($C$19:Y19)","v":3450.0111039110534},{"$f":"SUM($C$19:Z19)","v":3602.7120440434405},{"$f":"SUM($C$19:AA19)","v":3755.416926045355},{"$f":"SUM($C$19:AB19)","v":3908.1257203289024},{"$f":"SUM($C$19:AC19)","v":4060.8383986053218},{"$f":"SUM($C$19:AD19)","v":4122.3546241697941},{"$f":"SUM($C$19:AE19)","v":4183.8746808404012},{"$f":"SUM($C$19:AF19)","v":4245.3985439203616},{"$f":"SUM($C$19:AG19)","v":4306.9261898143013},{"$f":"SUM($C$19:AH19)","v":4368.4575959830927},{"$f":"SUM(E19:AI19)","v":4429.9927409002939},{"$f":"SUM(E19:AJ19)","v":4491.5316040101325},{"$f":"SUM(E19:AK19)","v":4553.070467119971},{"$f":"SUM(E19:AL19)","v":4614.6093302298095},{"$f":"SUM(E19:AM19)","v":4676.1481933396481}]
["Meters (15 years straight line)",null,null,null,{"$f":"SUM($C$20:E20)","v":163.87666666666667},{"$f":"SUM($C$20:F20)","v":319.40425804878078},{"$f":"SUM($C$20:G20)","v":495.44479138211409},{"$f":"SUM($C$20:H20)","v":680.10352471544741},{"$f":"SUM($C$20:I20)","v":859.59285804878073},{"$f":"SUM($C$20:J20)","v":1171.5107581133234},{"$f":"SUM($C$20:K20)","v":1478.798876686925},{"$f":"SUM($C$20:L20)","v":1800.0078222267534},{"$f":"SUM($C$20:M20)","v":2130.5114164782954},{"$f":"SUM($C$20:N20)","v":2458.8136967275232},{"$f":"SUM(E20:O20)","v":2926.1307470980405},{"$f":"SUM(E20:P20)","v":3400.5132195013962},{"$f":"SUM(E20:Q20)","v":3807.2578821980242},{"$f":"SUM(E20:R20)","v":4203.9299413651779},{"$f":"SUM(E20:S20)","v":4554.8199361331808},4727.1255033700108,4853.26132558266,4968.1866668903431,5066.2254455598404,5202.0222046296949,5221.1502907144504,5221.7469637199592,5199.8092433596194,5165.7200365163526,5129.9905745486394,4880.6250598210272,4624.1177370927608,4439.1118000765782,4264.1024925415832,4131.4549402475577,4013.4395848377308,3949.8676900985847,3876.9933343131866,{"$f":"SUM(X20:AL20)","v":3812.3873411659733},3715.1927676184041]
["Other",null,null,null,{"$f":"SUM($C$21:E21)","v":79.391479270325547},{"$f":"SUM($C$21:F21)","v":159.02772064765171},{"$f":"SUM($C$21:G21)","v":183.74583614065543},{"$f":"SUM($C$21:H21)","v":208.90662854187869},{"$f":"SUM($C$21:I21)","v":234.42156246967758},{"$f":"SUM($C$21:J21)","v":259.57663928955441},{"$f":"SUM($C$21:K21)","v":284.83431891051492},{"$f":"SUM($C$21:L21)","v":307.44710451373965},{"$f":"SUM($C$21:M21)","v":330.06052293914814},{"$f":"SUM($C$21:N21)","v":351.36982694275298},{"$f":"SUM($C$21:O21)","v":372.67970878610163},{"$f":"SUM($C$21:P21)","v":393.99016079100136},{"$f":"SUM($C$21:Q21)","v":413.16615582222721},{"$f":"SUM($C$21:R21)","v":432.34252502137758},{"$f":"SUM($C$21:S21)","v":451.51926454213549},{"$f":"SUM($C$21:T21)","v":470.6963707010193},{"$f":"SUM($C$21:U21)","v":489.87383997112397},{"$f":"SUM($C$21:V21)","v":509.05166897607694},{"$f":"SUM($C$21:W21)","v":528.22985448420161},{"$f":"SUM($C$21:X21)","v":547.40839340288107},{"$f":"SUM($C$21:Y21)","v":566.58728277311695},{"$f":"SUM($C$21:Z21)","v":585.76651976427593},{"$f":"SUM($C$21:AA21)","v":604.94610166901862},{"$f":"SUM($C$21:AB21)","v":624.12602589840412},{"$f":"SUM($C$21:AC21)","v":643.30628997716587},{"$f":"SUM($C$21:AD21)","v":654.50686444363237},{"$f":"SUM($C$21:AE21)","v":665.70777413188557},{"$f":"SUM($C$21:AF21)","v":676.90901688095721},{"$f":"SUM($C$21:AG21)","v":688.11059062625202},{"$f":"SUM($C$21:AH21)","v":699.31249339559633},{"$f":"SUM($C$21:AI21)","v":710.51472330542651},{"$f":"SUM($C$21:AJ21)","v":721.71727855711254},{"$f":"SUM($C$21:AK21)","v":732.91983380879856},{"$f":"SUM($C$21:AL21)","v":744.12238906048458},{"$f":"SUM($C$21:AM21)","v":755.3249443121706}]
["Total Depreciation",null,null,null,{"$f":"SUM(E24:E29)","v":11889.608400082139},{"$f":"SUM(F24:F29)","v":12317.241929148984},{"$f":"SUM(G24:G29)","v":12781.949628065713},{"$f":"SUM(H24:H29)","v":13268.707633641718},{"$f":"SUM(I24:I29)","v":13742.114066962928},{"$f":"SUM(J24:J29)","v":14328.253320691487},14910.892297625309,15478.838882628135,16118.402981418389,16693.816926098738,17394.899984613501,18151.814639464075,18763.578233649401,19365.273874678034,19921.192053876061,20298.530362331057,20629.703438715616,20949.670505185462,21252.755439842258,21593.602747287736,21817.785737360315,22023.441634785118,22206.567425627189,22377.545984592609,22546.888512275826,{"$f":"SUM(AD24:AD29)","v":22403.418844874905},22222.576615996208,22143.474832104806,22050.899874386669,22024.164678326524,22012.065745039483,{"$f":"SUM(AJ24:AJ29)","v":22054.414315957612},22087.460425829489,22128.774898339554,10697.341054644874]
[]
["Closing DAV",null,null,388965.43101734912,{"$f":"E$8+E$15-E$30","v":390258.65534140245},390529.06654725899,390785.00085416186,391098.83835345501,390605.6985039296,391024.44748495205,390836.25599915342,389125.17696504161,389406.83200457611,386636.79304380197,384717.03330544324,384096.95463418536,378871.98415472475,372894.39361518022,365674.31687195768,357856.44672808796,348889.78097213985,339742.84334874898,330168.95221252402,320743.19797550305,311329.81335328601,301363.50786829751,291085.02485844941,280592.86134591058,269873.88130251266,254667.98825752659,239641.93914948811,224753.0920121815,209955.82586020694,195134.1350375016,180323.55363019244,165469.63640781093,150582.67307555754,135654.39527079408,132157.5513097253]

{"sheet":"Pi's Calc","index":2,"n_rows":69,"n_cols":36,"rows_kept":69,"cut":false,"hidden":false,"merged":[[20,0,20,35],[1,3,1,4],[0,0,1,2],[49,0,49,35],[55,0,55,35],[31,0,31,35],[35,0,35,35],[39,0,39,35],[47,0,47,35],[9,6,9,35]]}
["PNGL 'P' Tariff Model - Calculation of Pi tariffs, Allowed Revenues, PA and TRV"]
[null,null,null,"Return"]
[null,null,null,"To 2016",7.4999999999999997E-2]
["p","£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,{"$f":"Y6","v":4.8300000000000003E-2},{"$f":"Z6","v":4.8300000000000003E-2},{"$f":"AA6","v":4.8300000000000003E-2},{"$f":"AB6","v":4.8300000000000003E-2},{"$f":"AC6","v":4.8300000000000003E-2},{"$f":"AD6","v":4.8300000000000003E-2},{"$f":"AE6","v":4.8300000000000003E-2},{"$f":"AF6","v":4.8300000000000003E-2},{"$f":"AG6","v":4.8300000000000003E-2},{"$f":"AH6","v":4.8300000000000003E-2},4.8300000000000003E-2]
["Discount Factor (Yr End)",null,1,{"$f":"C7/(1+D6)","v":0.93023255813953487},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,0.31337394964303089,0.29893537121342256,0.2851620444657279,0.27202331819682141,0.25948995344540821,0.2475340584235507,0.23612902644619926,0.22524947672059453,0.21487119786377423,0.20497109402248806,0.19552713347561582]
[]
[]
[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":"D11+1","v":2015},2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,{"$f":"X11+1","v":2035},{"$f":"Y11+1","v":2036},2037,2038,2039,2040,2041,2042,2043,2044,2045,{"$f":"AI11+1","v":2046}]
[]
["Capex",null,null,12672.314902417684,12995.697204981523,12918.910928231508,14747.002301713934,14722.700811826659,13767.759848516302,16400.058020952867,13923.777965324554,15475.140246254812,17531.73596820622,13538.607754188781,13387.683335133474,12701.115310653528,12480.660218461337,11663.037682767499,11802.732881794558,11678.864303617303,12167.848510266756,12404.401115143257,12057.136149796626,11928.084415779091,11885.382472053761,11827.908468877913,7197.5257998888019,7196.5275079577459,7254.6276947981969,7253.6337224121098,7202.4738556211842,7201.484337730325,7200.4970935761012,7200.4970935761021,7200.4970935761021,7200.4970935761021]
["Opex",null,null,13749.930745035412,14041.780037449151,14197.210603765589,13406.574500403272,13448.132530232431,13745.04492988737,14020.940074315293,14110.398440742747,14412.781687997513,14568.571458323224,14537.828918494837,14595.989242289843,14587.677779570404,15057.845980675331,15169.276556429762,15322.524640892536,15569.54615986086,15765.561400102624,16118.132297026414,16169.732319942515,16143.772859851524,16243.151968017137,16350.448926786394,15887.136619230283,16087.743494726217,16208.035865528151,16456.824735871105,16594.214058460231,16848.067548260984,16852.25975494766,16852.051586055957,16851.8413394331,16851.628994341281]
["Volumes (therms '000)",null,null,{"$f":"[4]Inputs!E11","v":135320.3406981361},{"$f":"[4]Inputs!F11","v":139809.22819078714},{"$f":"[4]Inputs!G11","v":144470.65933285159},{"$f":"[4]Inputs!H11","v":148932.604548042},{"$f":"[4]Inputs!I11","v":153199.02998297976},{"$f":"[4]Inputs!J11","v":157292.37105677347},{"$f":"[4]Inputs!K11","v":161225.42973529431},{"$f":"[4]Inputs!L11","v":164461.4190697826},{"$f":"[4]Inputs!M11","v":167884.92095938866},{"$f":"[4]Inputs!N11","v":168082.80840972651},{"$f":"[4]Inputs!O11","v":171003.39577569324},{"$f":"[4]Inputs!P11","v":173744.58893574594},{"$f":"[4]Inputs!Q11","v":176485.78209579861},{"$f":"[4]Inputs!R11","v":179226.97525585128},{"$f":"[4]Inputs!S11","v":181968.16841590396},{"$f":"[4]Inputs!T11","v":184709.36157595663},{"$f":"[4]Inputs!U11","v":187450.55473600933},{"$f":"[4]Inputs!V11","v":190191.74789606201},{"$f":"[4]Inputs!W11","v":192932.94105611462},{"$f":"[4]Inputs!X11","v":195674.13421616732},{"$f":"[4]Inputs!Y11","v":198415.32737622},{"$f":"[4]Inputs!Z11","v":201156.52053627267},{"$f":"[4]Inputs!AA11","v":203897.71369632537},{"$f":"[4]Inputs!AB11","v":206253.28385419157},{"$f":"[4]Inputs!AC11","v":207837.60800768487},{"$f":"[4]Inputs!AD11","v":209036.30915899176},{"$f":"[4]Inputs!AE11","v":210235.01031029862},{"$f":"[4]Inputs!AF11","v":211433.7114616055},{"$f":"[4]Inputs!AG11","v":212632.41261291236},{"$f":"[4]Inputs!AH11","v":213831.11376421919},{"$f":"[4]Inputs!AI11","v":213831.11376421919},{"$f":"[4]Inputs!AJ11","v":213831.11376421919},{"$f":"[4]Inputs!AK11","v":213831.11376421919}]
["£/therm"]
["P Dom (P1)",null,null,0.37651982641571391,{"$f":"D17","v":0.37651982641571391},{"$f":"E17","v":0.37651982641571391},0.37651982641571391,0.37651982641571391,0.37651982641571391,0.37651982641571391,0.37651982641571391,0.37651982641571391,0.37651982641571391,0.37651982641571391,0.37651982641571391,0.37651982641571391,0.37651982641571391,0.37651982641571391,0.37651982641571391,0.37651982641571391,0.37651982641571391,0.37651982641571391,0.37651982641571391,0.37651982641571391,0.37651982641571391,0.37651982641571391,0.37651982641571391,0.37651982641571391,0.37651982641571391,0.37651982641571391,0.37651982641571391,0.37651982641571391,0.37651982641571391,0.37651982641571391,0.37651982641571391,0.37651982641571391]
["P SME (P2)",null,0.9,{"$f":"$D$17*C18","v":0.33886784377414253},{"$f":"D18","v":0.33886784377414253},0.33886784377414253,0.33886784377414253,0.33886784377414253,0.33886784377414253,0.33886784377414253,0.33886784377414253,0.33886784377414253,0.33886784377414253,0.33886784377414253,0.33886784377414253,0.33886784377414253,0.33886784377414253,0.33886784377414253,0.33886784377414253,0.33886784377414253,0.33886784377414253,0.33886784377414253,0.33886784377414253,0.33886784377414253,0.33886784377414253,0.33886784377414253,0.33886784377414253,0.33886784377414253,0.33886784377414253,0.33886784377414253,0.33886784377414253,0.33886784377414253,0.33886784377414253,0.33886784377414253,0.33886784377414253,0.33886784377414253]
["P Contract (P3 + P4)",null,0.69697530711249867,{"$f":"$D$17*C19","v":0.26242502165003689},0.26242502165003689,0.26242502165003689,0.26242502165003689,0.26242502165003689,0.26242502165003689,0.26242502165003689,0.26242502165003689,0.26242502165003689,0.26242502165003689,0.26242502165003689,0.26242502165003689,0.26242502165003689,0.26242502165003689,0.26242502165003689,0.26242502165003689,0.26242502165003689,0.26242502165003689,0.26242502165003689,0.26242502165003689,0.26242502165003689,0.26242502165003689,0.26242502165003689,0.26242502165003689,0.26242502165003689,0.26242502165003689,0.26242502165003689,0.26242502165003689,0.26242502165003689,0.26242502165003689,0.26242502165003689,0.26242502165003689,0.26242502165003689]
[]
["Conditions 2.3.15 and 2.3.16 Establishing Best Available Revenue Per Therm and Calculating Cashflow"]
[]
["Allowed Revenue",null,null,{"$f":"SUMPRODUCT(D17:D19,[4]Inputs!E8:E10)","v":44598.998923443527},{"$f":"SUMPRODUCT(E17:E19,[4]Inputs!F8:F10)","v":46265.928691296423},{"$f":"SUMPRODUCT(F17:F19,[4]Inputs!G8:G10)","v":47989.633178719399},{"$f":"SUMPRODUCT(G17:G19,[4]Inputs!H8:H10)","v":49656.164243138192},{"$f":"SUMPRODUCT(H17:H19,[4]Inputs!I8:I10)","v":51248.508411603922},{"$f":"SUMPRODUCT(I17:I19,[4]Inputs!J8:J10)","v":52775.656152980962},{"$f":"SUMPRODUCT(J17:J19,[4]Inputs!K8:K10)","v":54242.780570267001},{"$f":"SUMPRODUCT(K17:K19,[4]Inputs!L8:L10)","v":55494.278888004992},{"$f":"SUMPRODUCT(L17:L19,[4]Inputs!M8:M10)","v":56774.346324767437},{"$f":"SUMPRODUCT(M17:M19,[4]Inputs!N8:N10)","v":56876.066267057962},{"$f":"SUMPRODUCT(N17:N19,[4]Inputs!O8:O10)","v":57972.45225972504},{"$f":"SUMPRODUCT(O17:O19,[4]Inputs!P8:P10)","v":59001.29277712138},{"$f":"SUMPRODUCT(P17:P19,[4]Inputs!Q8:Q10)","v":60030.133294517706},{"$f":"SUMPRODUCT(Q17:Q19,[4]Inputs!R8:R10)","v":61058.973811914038},{"$f":"SUMPRODUCT(R17:R19,[4]Inputs!S8:S10)","v":62087.814329310364},{"$f":"SUMPRODUCT(S17:S19,[4]Inputs!T8:T10)","v":63116.65484670669},{"$f":"SUMPRODUCT(T17:T19,[4]Inputs!U8:U10)","v":64145.49536410303},{"$f":"SUMPRODUCT(U17:U19,[4]Inputs!V8:V10)","v":65174.335881499355},{"$f":"SUMPRODUCT(V17:V19,[4]Inputs!W8:W10)","v":66203.176398895681},{"$f":"SUMPRODUCT(W17:W19,[4]Inputs!X8:X10)","v":67232.016916292006},{"$f":"SUMPRODUCT(X17:X19,[4]Inputs!Y8:Y10)","v":68260.857433688347},{"$f":"SUMPRODUCT(Y17:Y19,[4]Inputs!Z8:Z10)","v":69289.697951084672},{"$f":"SUMPRODUCT(Z17:Z19,[4]Inputs!AA8:AA10)","v":70318.538468480998},{"$f":"SUMPRODUCT(AA17:AA19,[4]Inputs!AB8:AB10)","v":71202.184280032176},{"$f":"SUMPRODUCT(AB17:AB19,[4]Inputs!AC8:AC10)","v":71795.440679893058},{"$f":"SUMPRODUCT(AC17:AC19,[4]Inputs!AD8:AD10)","v":72243.502373908792},{"$f":"SUMPRODUCT(AD17:AD19,[4]Inputs!AE8:AE10)","v":72691.564067924526},{"$f":"SUMPRODUCT(AE17:AE19,[4]Inputs!AF8:AF10)","v":73139.62576194026},{"$f":"SUMPRODUCT(AF17:AF19,[4]Inputs!AG8:AG10)","v":73587.68745595598},{"$f":"SUMPRODUCT(AG17:AG19,[4]Inputs!AH8:AH10)","v":74035.7491499717},{"$f":"SUMPRODUCT(AH17:AH19,[4]Inputs!AI8:AI10)","v":74035.7491499717},{"$f":"SUMPRODUCT(AI17:AI19,[4]Inputs!AJ8:AJ10)","v":74035.7491499717},{"$f":"SUMPRODUCT(AJ17:AJ19,[4]Inputs!AK8:AK10)","v":74035.7491499717}]
["Capex",null,null,{"$f":"-D13","v":-12672.314902417684},{"$f":"-E13","v":-12995.697204981523},-12918.910928231508,-14747.002301713934,-14722.700811826659,-13767.759848516302,-16400.058020952867,-13923.777965324554,-15475.140246254812,-17531.73596820622,-13538.607754188781,-13387.683335133474,-12701.115310653528,-12480.660218461337,-11663.037682767499,-11802.732881794558,-11678.864303617303,-12167.848510266756,-12404.401115143257,-12057.136149796626,-11928.084415779091,-11885.382472053761,{"$f":"-Z13","v":-11827.908468877913},-7197.5257998888019,-7196.5275079577459,-7254.6276947981969,-7253.6337224121098,-7202.4738556211842,-7201.484337730325,-7200.4970935761012,-7200.4970935761021,-7200.4970935761021,-7200.4970935761021]
["Opex",null,null,{"$f":"-D14","v":-13749.930745035412},-14041.780037449151,-14197.210603765589,-13406.574500403272,-13448.132530232431,-13745.04492988737,-14020.940074315293,-14110.398440742747,-14412.781687997513,-14568.571458323224,-14537.828918494837,-14595.989242289843,-14587.677779570404,-15057.845980675331,-15169.276556429762,-15322.524640892536,-15569.54615986086,-15765.561400102624,-16118.132297026414,-16169.732319942515,-16143.772859851524,-16243.151968017137,{"$f":"-Z14","v":-16350.448926786394},-15887.136619230283,-16087.743494726217,-16208.035865528151,-16456.824735871105,-16594.214058460231,-16848.067548260984,-16852.25975494766,-16852.051586055957,-16851.8413394331,-16851.628994341281]
["Capex Creditor",null,null,14.110294568696059,53.897050427306446,-12.797712791669182,304.68189558040444,-4.0502483145454899,-159.15682721839286,438.71636207276026,-412.71334260471815,258.56038015504276,342.76595365856775,-665.52136900290657,-25.154069842550904,-114.42800407999103,-36.742515365364959,-136.27042261563986,23.282533171176912,-20.644763029542752,81.497367774908426,39.425434146082964,-57.877494224438443,-21.508622336255385,-7.1169906208887692,-9.5790005293078728,-771.73044483151841,-0.16638198850909247,9.6833644734085542,-0.16566206434788183,-8.5266444651540372,-0.16491964847641066,-0.16454069237038493,0,0,0]
["Working Capital Adjustment",null,null,313.57549742235102,-215.60519770825189,-239.6057766786171,-346.29897372210445,-233.88289635203407,-193.45732861736417,-187.01957163223997,-172.02273407895072,-155.72412584379688,3.4367810955075546,-168.14700367946691,-147.34683875405042,-155.32345313578284,-97.905893476859205,-140.95440851891715,-135.93630747391609,-124.68349533325201,-130.8042487804382,-112.01756997859175,-148.13407485951902,-157.44121282036789,-142.40058462957538,-141.45044255714026,-188.14434863940977,-64.915634919620345,-52.774169606127892,-37.354589661205772,-50.722535391665062,-36.746835326267579,-66.70618929995905,-2.4980267004226335E-2,-2.5229594742821063E-2,-2.5481411018350629E-2]
["Allowed Capex Overspend",null,null,{"$f":"-'Opening Values'!E26/rpi_06*rpi","v":-365.56903255082995},{"$f":"-'Opening Values'!F26/rpi_06*rpi","v":-586.84792795332601},{"$f":"-'Opening Values'!G26/rpi_06*rpi","v":-330.06328920600845}]
[]
["Cashflows",null,null,{"$f":"SUM(D23:D29)","v":18138.870035430653},{"$f":"SUM(E23:E29)","v":18479.895373631476},20291.044868046003,21460.970362879289,22839.741924878246,24910.237218741528,24073.479265439353,26875.366405254023,26989.260644826354,25121.961575282588,29062.347214359052,30845.119291101466,32471.588747078004,33385.819203935142,34978.275258978538,35878.743549716855,36751.756642262073,37191.619090124441,37608.050850893502,38799.136877468904,40010.050322901108,41011.645935763307,41989.151629730237,47157.647067442158,48446.087660300967,48737.748008449722,48943.585357915756,49283.688668002025,49501.223814989935,49916.121571455617,49983.17549007263,49983.385487367748,49983.597580643291]
[]
[]
[]
["Discounted Cashflow",null,{"$f":"SUM(D34:AJ34)","v":478515.59912383079},{"$f":"D30*D7","v":16873.367474819213},15991.256137268991,16333.491032927219,16479.285438836236,16729.949421481371,17405.869102602144,16046.160287000272,17088.387049978191,16370.128177662133,14535.469148749164,16040.599958629222,16240.178159159772,16308.810530176313,15995.403522345843,15986.226750635862,15642.249825730431,15284.61515230978,14754.887601868135,14232.659513721146,14006.889841839858,13778.538704725239,13472.73217316826,13158.306288368673,14097.08873165739,13814.985403577297,13257.803934699017,12700.368685976922,12199.391470073297,11688.675787328988,11243.580263891958,10739.944790587148,10245.149206293519,9773.1495557419094]
[]
[]
[]
["Closing DAV",null,null,{"$f":"DAV!G32","v":390785.00085416186},{"$f":"DAV!H32","v":391098.83835345501},{"$f":"DAV!I32","v":390605.6985039296},{"$f":"DAV!J32","v":391024.44748495205},{"$f":"DAV!K32","v":390836.25599915342},{"$f":"DAV!L32","v":389125.17696504161},{"$f":"DAV!M32","v":389406.83200457611},{"$f":"DAV!N32","v":386636.79304380197},{"$f":"DAV!O32","v":384717.03330544324},{"$f":"DAV!P32","v":384096.95463418536},{"$f":"DAV!Q32","v":378871.98415472475},{"$f":"DAV!R32","v":372894.39361518022},{"$f":"DAV!S32","v":365674.31687195768},{"$f":"DAV!T32","v":357856.44672808796},{"$f":"DAV!U32","v":348889.78097213985},{"$f":"DAV!V32","v":339742.84334874898},{"$f":"DAV!W32","v":330168.95221252402},{"$f":"DAV!X32","v":320743.19797550305},{"$f":"DAV!Y32","v":311329.81335328601},{"$f":"DAV!Z32","v":301363.50786829751},{"$f":"DAV!AA32","v":291085.02485844941},{"$f":"DAV!AB32","v":280592.86134591058},{"$f":"DAV!AC32","v":269873.88130251266},{"$f":"DAV!AD32","v":254667.98825752659},{"$f":"DAV!AE32","v":239641.93914948811},{"$f":"DAV!AF32","v":224753.0920121815},{"$f":"DAV!AG32","v":209955.82586020694},{"$f":"DAV!AH32","v":195134.1350375016},{"$f":"DAV!AI32","v":180323.55363019244},{"$f":"DAV!AJ32","v":165469.63640781093},{"$f":"DAV!AK32","v":150582.67307555754},{"$f":"DAV!AL32","v":135654.39527079408},{"$f":"DAV!AM32","v":132157.5513097253}]
[]
[]
[]
["TRV",null,{"$f":"-'Opening Values'!D18","v":-503588.90686615743}]
["Discounted DAV2046",null,{"$f":"AJ38*$AJ$7","v":25840.387174747204}]
["Discounted Capital Creditors (CC2046)",null,{"$f":"AJ64*AJ7","v":-691.14988657109575}]
["Discounted Working Capital Adjustment (Q2046)",null,{"$f":"AJ66*AJ7","v":-75.929545849686903}]
["Backsolve to 0 by running Macro Ctrl + q",null,{"$f":"SUM(C34:C45)","v":-2.1547919004660798E-10}]
[]
[]
[]
["Condition 2.3.18 Calculating TRV"]
[]
[null,"Total Regulatory Value (TRV)",null,null,null,{"$f":"F62+F64+F66+F68","v":564488.26120509894},null,null,null,null,{"$f":"K62+K64+K66+K68","v":582917.301556119},null,null,null,null,{"$f":"P62+P64+P66+P68","v":579684.93146187533},null,null,null,null,{"$f":"U62+U64+U66+U68","v":538110.67342146032},null,null,null,null,{"$f":"Z62+Z64+Z66+Z68","v":462174.49069118756},null,null,null,null,{"$f":"AE62+AE64+AE66+AE68","v":318193.81885380181},null,null,null,null,{"$f":"AJ62+AJ64+AJ66+AJ68","v":128234.41584107833}]
[]
[]
[]
["Condition 2.3.19 Calculating Profile Adjustment"]
[]
[null,"Adjusted Cashflows",null,{"$f":"D30*(1+$F$6)^($F$11-D11)","v":20961.731684694547},{"$f":"E30*(1+$F$6)^($F$11-E11)","v":19865.887526653834},{"$f":"F30*(1+$F$6)^($F$11-F11)","v":20291.044868046003},{"$f":"G30*(1+$K$6)^($K$11-G11)","v":25917.415901815981},{"$f":"H30*(1+$K$6)^($K$11-H11)","v":26311.641896258032},{"$f":"I30*(1+$K$6)^($K$11-I11)","v":27374.678977377189},{"$f":"J30*(1+$K$6)^($K$11-J11)","v":25236.228313960073},{"$f":"K30*(1+$K$6)^($K$11-K11)","v":26875.366405254023},{"$f":"L30*(1+$P$6)^($P$11-L11)","v":32593.674991713291},{"$f":"M30*(1+$P$6)^($P$11-M11)","v":28940.784833492093},{"$f":"N30*(1+$P$6)^($P$11-N11)","v":31937.569214459039},{"$f":"O30*(1+$P$6)^($P$11-O11)","v":32334.938552861666},{"$f":"P30*(1+$P$6)^($P$11-P11)","v":32471.588747078004},{"$f":"Q30*(1+$U$6)^($U$11-Q11)","v":40318.501302619261},{"$f":"R30*(1+$U$6)^($U$11-R11)","v":40295.370052343162},{"$f":"S30*(1+$U$6)^($U$11-S11)","v":39428.331338659198},{"$f":"T30*(1+$U$6)^($U$11-T11)","v":38526.866488083331},{"$f":"U30*(1+$U$6)^($U$11-U11)","v":37191.619090124441},{"$f":"V30*(1+$Z$6)^($Z$11-V11)","v":45417.494115046211},{"$f":"W30*(1+$Z$6)^($Z$11-W11)","v":44697.045998224559},{"$f":"X30*(1+$Z$6)^($Z$11-X11)","v":43968.360230391147},{"$f":"Y30*(1+$Z$6)^($Z$11-Y11)","v":42992.508434460673},{"$f":"Z30*(1+$Z$6)^($Z$11-Z11)","v":41989.151629730237},{"$f":"AA30*(1+$AE$6)^($AE$11-AA11)","v":56950.097378261111},{"$f":"AB30*(1+$AE$6)^($AE$11-AB11)","v":55810.442779307341},{"$f":"AC30*(1+$AE$6)^($AE$11-AC11)","v":53559.514271017397},{"$f":"AD30*(1+$AE$6)^($AE$11-AD11)","v":51307.560530703086},{"$f":"AE30*(1+$AE$6)^($AE$11-AE11)","v":49283.688668002025},{"$f":"AF30*(1+$AJ$6)^($AJ$11-AF11)","v":59780.326032277662},{"$f":"AG30*(1+$AJ$6)^($AJ$11-AG11)","v":57503.938527765225},{"$f":"AH30*(1+$AJ$6)^($AJ$11-AH11)","v":54928.155492682679},{"$f":"AI30*(1+$AJ$6)^($AJ$11-AI11)","v":52397.583006407614},{"$f":"AJ30*(1+$AJ$6)^($AJ$11-AJ11)","v":49983.597580643291}]
[]
[null,"Closing TRV (Incl Return)",{"$f":"'Opening Values'!D18","v":503588.90686615743},null,null,{"$f":"-$C$60*(1+F6)^(F11-C11)","v":-625606.92528449337},null,null,null,null,{"$f":"-F52*(1+K6)^(K11-F11)","v":-714632.63305078424},null,null,null,null,{"$f":"-K52*(1+P6)^(P11-K11)","v":-737963.48780147941},null,null,null,null,{"$f":"-P52*(1+U6)^(U11-P11)","v":-733871.36169328971},null,null,null,null,{"$f":"-U52*(1+Z6)^(Z11-U11)","v":-681239.05109904043},null,null,null,null,{"$f":"-Z52*(1+AE6)^(AE11-Z11)","v":-585105.12248109281},null,null,null,null,{"$f":"-AE52*(1+AJ6)^(AJ11-AE11)","v":-402828.01648085483}]
[]
[null,"DAV",null,null,null,{"$f":"F38","v":390605.6985039296},null,null,null,null,{"$f":"K38","v":386636.79304380197},null,null,null,null,{"$f":"P38","v":365674.31687195768},null,null,null,null,{"$f":"U38","v":320743.19797550305},null,null,null,null,{"$f":"Z38","v":269873.88130251266},null,null,null,null,195134.1350375016,null,null,null,null,132157.5513097253]
[]
[null,"CC",null,null,null,-4487.8719140368039,null,null,null,null,-4655.349753552312,null,null,null,null,-4451.5726444404736,null,null,null,null,-4362.694844376012,null,null,null,null,-4306.0381708112045,null,null,null,null,-3535.1324019350832,null,null,null,null,-3534.8029415942365]
[]
[null,"Q",null,null,null,-3973.2869043172022,null,null,null,null,-2840.6053999145088,null,null,null,null,-2217.5007595969191,null,null,null,null,-1587.2164060135365,null,null,null,null,-885.77252116834222,null,null,null,null,-491.8612429503134,null,null,null,null,-388.33252705132134]
[]
[null,"Calculated PA",null,null,null,{"$f":"-SUM(D58:F67)","v":182343.72151952336},null,null,null,null,{"$f":"-SUM(G58:K67)","v":203776.46366578387},null,null,null,null,{"$f":"-SUM(L58:P67)","v":220679.68799395504},null,null,null,null,{"$f":"-SUM(Q58:U67)","v":223317.3866963468},null,null,null,null,{"$f":"-SUM(V58:Z67)","v":197492.42008065444},null,null,null,null,{"$f":"-SUM(AA58:AE67)","v":127086.67746118561},null,null,null,null,{"$f":"-SUM(AF58:AJ67)","v":-1.4134684533928521E-9}]
[null,"Check",null,null,null,{"$f":"SUM(D58:F68)","v":0},null,null,null,null,{"$f":"SUM(G58:K68)","v":0},null,null,null,null,{"$f":"SUM(L58:P68)","v":0},null,null,null,null,{"$f":"SUM(Q58:U68)","v":0},null,null,null,null,{"$f":"SUM(V58:Z68)","v":0},null,null,null,null,{"$f":"SUM(AA58:AE68)","v":0},null,null,null,null,{"$f":"SUM(AF58:AJ68)","v":0}]