{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Inputs","DAV","GD17 Pi's Calc - 30 yrs","GD17 Pi's Calc - 40 yrs","FE Financeability","Building Block Method"],"not_rendered":{"charts":0,"images":15,"macros":1,"external_links":9,"defined_names":114,"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":"Inputs","index":0,"n_rows":144,"n_cols":44,"rows_kept":144,"cut":false,"hidden":false,"merged":[[136,0,136,1],[136,7,136,11],[136,12,136,14],[0,0,2,0],[66,21,66,27],[66,15,66,20]]}
["Inputs",{"$f":"K2/E2","v":1.2549120992761116},null,"2006 to 2012",null,null,null,null,null,null,null,null,257.5,"Dec"]
[null,{"$f":"M2/K2","v":1.0548001648125258},null,"2012 to 2014",193.4,null,null,null,null,null,242.7,null,256,null,263.8]
[null,"£2014","Source",2005,2006,{"$f":"E3+1","v":2007},{"$f":"F3+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,{"$f":"AH3+1","v":2036},{"$f":"AI3+1","v":2037},{"$f":"AJ3+1","v":2038},{"$f":"AK3+1","v":2039},{"$f":"AL3+1","v":2040},{"$f":"AM3+1","v":2041},{"$f":"AN3+1","v":2042},{"$f":"AO3+1","v":2043},{"$f":"AP3+1","v":2044},{"$f":"AQ3+1","v":2045}]
[null,null,null,null,"Actual","Actual","Actual","PCR02 Det","PCR02 Det","PCR02 Det","PCR02 Det","PCR02 Det","GD14 Det","GD14 Det","GD14 Det","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward"]
[]
["Capex - Subtotals in £2006",null,null,2005,2006,2007,2008,2009,2010,2011,2012,{"$f":"K6+1","v":2013},{"$f":"L6+1","v":2014},2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,{"$f":"AH6+1","v":2036},{"$f":"AI6+1","v":2037},{"$f":"AJ6+1","v":2038},{"$f":"AK6+1","v":2039},{"$f":"AL6+1","v":2040},{"$f":"AM6+1","v":2041},{"$f":"AN6+1","v":2042},{"$f":"AO6+1","v":2043},{"$f":"AP6+1","v":2044},{"$f":"AQ6+1","v":2045}]
[null,null,"Figures from updated capex performance model"]
["MP","4 bar main","Letter 16 Feb 2011","Mains",6923003.5736016659,9049244.9559499994,6831773.4384899987,8188137.6620777044,8078146.8929423047,5521651.1165696075,4199399.2184697855,3685225.3602657947,736542.26614045189,622468.085131309,563037.47659657535,{"$f":"P53/$M$1*$E$2","v":0},{"$f":"Q53/$M$1*$E$2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AI53/$M$1*$E$2","v":0},0,0,0,0,0,0,0,0,0]
[null,"Governors","PI's model V1.1","Meters/Tele",0,26142.857142857145,82857.142857142855,77420.412963277224,100474.46264514832,102242.49368188051,52597.539583342295,53307.163212749292,0,0,0,{"$f":"P54/$M$1*$E$2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AI54/$M$1*$E$2","v":0},0,0,0,0,0,0,0,0,0]
["LP","Infill &TMA from 2017","PI's model V1.1","Mains",0,0,223967.2145,652307.71911510383,542746.43033011002,573809.65979659045,607285.61253340822,357597.43583069346,5393975.0220325543,4237495.8560576476,3800068.0023640287,7166098.9682265297,6896639.1713438733,6941695.805103736,7215722.9701909088,7183281.9588850709,7788485.7070131246,5658989.2151363846,5008523.493655785,5215532.2255831072,3258340.8998130434,1566936.3748711778,1552908.932265861,1545987.9012736934,1539950.5473044426,1534939.9322457467,1531159.5358258395,1527806.8841935082,1525671.2425494401,1523882.5943313984,{"$f":"AI55/$M$1*$E$2","v":1522586.4924710684},1522047.039084475,1521811.3048619668,1521916.4858811803,1522763.0729472062,1523589.2863392448,1524718.9517753324,1525595.5871806054,1526759.6660223869,1528259.2533698031]
["Domestic","Services","PI's model V1.1","Services",155848.57344775368,290470.02493707597,588038.57324413338,1075079.9285243603,1207475.3821402513,1223250.2156746923,1239295.8958059708,1251911.2190519627,2021496.1681087764,2021496.1681087764,1910572.0642768852,{"$f":"P56/$M$1*$E$2","v":2489084.7763727787},2539826.3827970191,2593570.8499842519,2671942.1990060979,2894010.5062257587,2975495.2992028478,2892185.3946654932,2910353.8967056894,2729972.0787065313,2730434.4330296875,2563984.2504772251,2334441.0363285812,2211085.5954193487,2098137.2910257471,1990873.7551702166,1892462.9469331002,1800668.3779288584,1715331.3989242383,1636131.4285598665,{"$f":"AI56/$M$1*$E$2","v":1561925.8472947988},1493781.0247439651,1429189.6384837632,1369963.3092878039,1315267.0925615877,1263885.9817979787,1215861.8441143173,1170753.9719203124,1128440.3517743906,1089666.9396760217]
[null,"Meters","PI's model V1.1","Meters/Tele",64686.979303382133,114504.69793804453,193959.25240832509,254860.27446987515,249037.08193032144,253419.34264173303,257704.73237662474,261181.57499993203,720369.18005768443,720369.18005768443,684350.7210548002,524125.91095313168,534150.12882806046,544661.98553156911,560519.03324620042,654614.38067937479,729910.04827854247,821346.94554115261,956366.20122463105,904192.60507065686,978038.40295089548,960092.692876352,948448.09642664425,923955.47724876076,927002.97802723513,915092.786668555,899038.22757770296,889106.53006816527,881011.35938444978,879972.47282183182,{"$f":"AI57/$M$1*$E$2","v":946679.4099592953},1024524.2294998905,1055081.7707052787,1173929.4114361699,1118764.2941189343,1169085.1125719955,1149991.5227596073,1136968.9792861261,1107785.4675032787,1105702.249427716]
["IC","Services","PI's model V1.1","Services",126231.33064109038,159935.80890609877,476274.6650065133,318783.89176086854,258585.8443867765,282115.17405732744,163323.28549151111,123739.36732817689,139713.37124021427,91762.602389781634,44688.388957560775,335846.55817835394,336400.91303752235,336130.84130340174,335177.36131641979,334597.69298106461,333042.49770811689,245460.43675896956,262330.78573371703,269821.43491639622,279130.87049994967,254856.88235809602,231334.23717875019,212905.58212136407,188004.70579492117,171220.19489842464,155603.77495422744,142271.41122006669,131282.60336947124,117291.8554318883,{"$f":"AI58/$M$1*$E$2","v":107545.99096263561},95539.382316274889,89739.348264296859,79673.8985260552,71822.286630266273,65791.348934359965,57253.562056661394,55649.835097996583,51676.977374936083,45302.887426807509]
[null,"Meters","PI's model V1.1","Meters/Tele",147239.78394750127,257228.4965924492,454194.6356763544,87474.434687182555,61732.499862058918,67651.010594575317,39311.432863005859,29881.354494274132,99093.793160280184,59757.173465183361,25514.934487021015,176285.2656186239,178218.0879569556,168892.88385720341,168413.79665390763,182162.81595396172,189574.87097557259,188546.97859954208,216832.75066064138,188688.37877577377,196830.01500684005,184301.19077906088,181703.55041484308,153280.47802053424,150344.38918865507,130402.72002064598,118597.37795653859,114929.88250735184,103940.23656753628,96173.667753739443,{"$f":"AI59/$M$1*$E$2","v":103405.58830969397},102509.3794776858,118619.58527849089,136105.37377665081,98176.046968980358,97772.689838762308,89588.351210615248,95422.063003000076,75826.861653467451,83573.747216635384]
["Large loads","Services","PI's model V1.1","Services",10776.11913175164,74502.023543078423,203422.60109625667,253476.55331323601,227163.82311733722,113437.22476295715,84543.988629387663,17080.919613584025,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AI60/$M$1*$E$2","v":0},0,0,0,0,0,0,0,0,0]
[null,"Meters","PI's model V1.1","Meters/Tele",139516.47551741544,254560.39100677639,606396.96677496401,184407.09931451353,139939.78312399564,76816.191635921568,64296.385227626684,13032.768941170691,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AI61/$M$1*$E$2","v":0},0,0,0,0,0,0,0,0,0]
["Telemetry","PRS from 2017","PI's model V1.1","Meters/Tele",15000,33000,115500,17349.993662346264,11891.418733192708,5232.2242426047924,0,0,19921.714050267823,19921.714050267823,7968.6856201071287,14264.312761165051,27712.214648543693,31576.819821359222,35245.426299029124,33020.793040776698,100485.99088932038,16719.053365811396,16824.081264696153,16824.73499462134,17300.310337784482,17244.83798861007,17396.199147332474,17493.589986598327,17597.558900355416,17696.785683425063,17799.073962091094,17895.15858198583,17995.764190454196,18096.81917402098,{"$f":"AI62/$M$1*$E$2","v":18192.085215038191},18292.40569394354,18383.704444148992,18478.102456921046,18573.399728144977,18661.531601768282,18752.594839788308,18827.043820858133,18904.779672706271,18985.489445992887]
["Other capex","IT & office","PI's model V1.1","Other",313181,54621,600000,44487.163236785294,44042.291604417442,479620.55557210592,43165.85000148954,42734.191501474641,97217.964565306975,17531.108364235683,16734.239802224969,423455.42371743661,85474.84119316467,85474.84119316467,85474.84119316467,85474.84119316467,85474.84119316467,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AI63/$M$1*$E$2","v":0},0,0,0,0,0,0,0,0,0]
["Capex not started (Foyle river crossing)",null,"PI's model V1.1","Mains",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AI64/$M$1*$E$2","v":0},0,0,0,0,0,0,0,0,0]
[]
["Capex - Subtotals in £2012 Av"]
[]
["MP","4 bar main",null,"Mains",{"$f":"E8/$E$2*$K$2","v":8687760.9478444885},{"$f":"F8/$E$2*$K$2","v":11356006.984534977},8573275.1474742647,{"$f":"H8/$E$2*$K$2","v":10275393.022679724},10137364.275683027,{"$f":"J8/$E$2*$K$2","v":6929186.794164652},5269876.8889483809,4624633.8931567129,{"$f":"M8/$E$2*$K$2","v":924295.80140789901},781142.73144451226,706562.54172693298,{"$f":"P53/$M$1*$K$2","v":0},{"$f":"Q53/$M$1*$K$2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AI53/$M$1*$K$2","v":0},0,0,0,0,0,0,0,0,0]
[null,"Governors",null,"Meters/Tele",{"$f":"E9/$E$2*$K$2","v":0},32806.987738218348,103978.43108287783,97155.812958569702,126086.61884166233,128305.34238155324,66005.288815290449,66895.804093765531,0,0,0,{"$f":"P54/$M$1*$K$2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AI54/$M$1*$K$2","v":0},0,0,0,0,0,0,0,0,0]
["LP","Infill &TMA from 2017",null,"Mains",0,0,281059.16731721815,818588.84916874708,681099.06226017419,720080.68476025073,762090.0628844786,448753.34889405011,6768964.5183417834,5317684.820399126,4768751.3142386228,8992824.2998375315,8654675.9404610023,8711218.0553189069,9055098.0603171326,9014387.4427166823,9773864.9487698302,7101534.0357476752,6285256.731697306,6545034.4940487081,4088931.4187416006,1966367.41562169,1948764.2081743765,1940078.9226428405,1932502.574099215,1926214.6926372424,1921470.6274298409,1917263.3443317704,1914583.3017929115,1912338.7055027424,{"$f":"AI55/$M$1*$K$2","v":1910712.2115963199},1910035.2450144885,1909739.4192864492,1909871.4122200746,1910933.8045723212,1911970.6297545743,1913388.2605784549,1914488.3609551855,1915949.1775782483,1917831.0278844426]
["Domestic","Services",null,"Services",195576.26047450781,364514.34877057048,737936.72040512494,1349130.8099941169,1515275.4666258479,1535071.4960922843,1555207.4142301399,1571038.5360078146,2536800,2536800,2397600,3123582.6019941745,3187258.85783266,3254703.439975067,3353052.5940991724,3631728.7996948892,3733985.0523088472,3629438.4451153832,3652238.3181513483,3425874.9922547834,3426455.2062890651,3217574.8582772622,2929518.3015354015,2774718.0662268661,2632977.8724506143,2498371.5634943722,2374874.6495380732,2259680.5342468144,2152590.126778245,2053201.1257056857,{"$f":"AI56/$M$1*$K$2","v":1960079.6439423354},1874563.8816202704,1793507.3694933264,1719183.532389607,1650544.58823525,1586065.8106637509,1525799.7392272223,1469193.3246383648,1416093.4507530744,1367436.2267806125]
[null,"Meters",null,"Meters/Tele",81176.472993437652,143693.33086640851,243401.81261375645,319827.242057077,312519.64728277666,318018.99927170941,323396.78670013865,327759.91857540584,903999.99999999988,903999.99999999988,858800,657731.94719919877,670311.45949622674,683502.91565931658,703402.11669520603,821483.50667468598,915972.95096795366,1030718.2196630699,1200155.5172555221,1134682.2401791541,1227352.2254197639,1204831.9367171179,1190218.9917411921,1159482.9075919038,1163307.2531913647,1148361.0099506632,1128213.9494990099,1115750.5421279406,1105591.8144912408,1104288.1031740359,{"$f":"AI57/$M$1*$K$2","v":1187999.4456934901},1285687.8516009483,1324034.8797837184,1473178.2221073341,1403950.8489279491,1467099.0528501719,1443138.275975991,1426796.1286077704,1390173.3865721081,1387559.1310036539]
["IC","Services",null,"Services",158409.22412922769,200705.38170377543,597682.83969535038,400045.76282504026,324502.50482249563,354029.74531392643,204956.36705682389,155282.02921690035,175328,115154,56080,421457.90935825492,422153.57597831782,421814.65969149745,420618.12611941609,419890.69331181166,417939.05994705256,308031.27198242972,329202.07702985068,338602.18332062749,350284.7066718603,319822.98525496328,290304.1332124233,267177.79100752354,235929.38002289229,214866.29421844703,195269.05988309722,178538.11532114883,164748.1273928163,147190.96852802113,{"$f":"AI58/$M$1*$K$2","v":134960.76528765078},119893.52682605953,112614.99391801885,99983.739256843823,90130.656489998044,82562.359805424843,71848.187751560079,69835.651387196325,64850.064161825168,56851.141564044374]
[null,"Meters",null,"Meters/Tele",184772.98637051994,322799.15265246853,569974.34373656253,109772.72646628338,77468.860995458628,84896.071723388988,49332.392739666604,37498.473297623219,124354,74990.000000000015,32019,221222.51274891428,223648.03488703785,211945.72343403962,211344.51110601539,228598.32177883407,237899.79930595381,236609.88472651943,272106.04232335911,236787.32951851236,247004.36733278219,231281.79421963842,228021.9838970135,192353.52645079448,188668.99305111988,163643.95113242388,148829.28454008227,144226.90012685774,130435.86047022261,120689.49929592844,{"$f":"AI59/$M$1*$K$2","v":129764.9239025994},128640.26059583423,148857.15277709274,170800.28032881671,123202.30920047326,122696.13145743335,112425.50588839875,119746.30140035221,95156.046139072118,104877.706563999]
["Large loads","Services",null,"Services",13523.082281675919,93493.490764762842,255277.48338191048,318090.79363558622,285070.63014776492,142353.74586333867,106095.27425208058,21435.052689849239,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AI60/$M$1*$K$2","v":0},0,0,0,0,0,0,0,0,0]
[null,"Meters",null,"Meters/Tele",175080.91317516405,319450.91467086156,760974.89057023649,231414.70012219457,175612.12701237714,96397.568304230415,80686.311761866571,16354.979431345017,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AI61/$M$1*$K$2","v":0},0,0,0,0,0,0,0,0,0]
["Telemetry","PRS from 2017",null,"Meters/Tele",18823.681489141673,41412.09927611168,144942.3474663909,21772.716969242181,14922.68524584214,6565.9815081705428,0,0,25000.000000000004,25000.000000000004,{"$f":"O17/$E$2*$K$2","v":10000},17900.458671844659,34776.39346019418,39626.133250485429,44229.911906796115,41438.192714563105,126101.08577475727,20980.942357199718,21112.743138271744,21113.563511864522,21710.368764117342,21640.755841963099,21830.700791404299,21952.917733957671,22083.389581780037,22207.910472426382,22336.273270938509,22456.851022998762,22583.10221832075,22709.917339890857,{"$f":"AI62/$M$1*$K$2","v":22829.467847413485},22955.361230196984,23069.933136478594,23188.394344853863,23307.984043540775,23418.581798082534,23532.858157273124,23626.285084396426,23723.836745428187,23825.120416455396]
["Other capex","IT & office",null,"Other",393014.62616339186,68544.553774560496,752947.2595656669,55827.479408313287,55269.204614230155,601881.63824896642,54169.347442406979,53627.653967982915,122000,22000,20999.999999999996,531399.33472710371,107263.41239700653,107263.41239700653,107263.41239700653,107263.41239700653,107263.41239700653,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AI63/$M$1*$K$2","v":0},0,0,0,0,0,0,0,0,0]
["Capex not started (Foyle river crossing)",null,null,"Mains",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AI64/$M$1*$K$2","v":0},0,0,0,0,0,0,0,0,0]
[]
["Capex - Subtotals in £2014 Av - GD17 Submission"]
[]
["MP","4 bar main",null,"Mains",{"$f":"E8/$E$2*$M$2","v":9163851.6796381921},{"$f":"F8/$E$2*$M$2","v":11978318.038899688},9043092.038538985,10838486.253836051,10692893.508755067,7308907.3725016518,5558667.0110044731,4878064.592699294,{"$f":"M8/$E$2*$M$2","v":974947.36366057745},{"$f":"N8/$E$2*$M$2","v":823949.48186977813},{"$f":"O8/$E$2*$M$2","v":745282.28546392603},{"$f":"P53/$M$1*$M$2","v":0},{"$f":"Q53/$M$1*$M$2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AI53/$M$1*$M$2","v":0},0,0,0,0,0,0,0,0,0]
[null,"Governors",null,"Meters/Tele",{"$f":"E9/$E$2*$M$2","v":0},34604.816073275229,109676.46624316738,102479.96752119425,132996.18633483956,135336.49629038991,69622.389520866738,70561.705183370315,0,0,0,{"$f":"P54/$M$1*$M$2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AI54/$M$1*$M$2","v":0},0,0,0,0,0,0,0,0,0]
["LP","Infill &TMA from 2017",null,"Mains",0,0,296461.25600827299,863447.65301689028,718423.40312568855,759541.22496342892,803852.7239325362,473345.10637361696,7139904.8895570524,5609094.8249780647,5030079.6722088484,{"$f":"P55/$M$1*$M$2","v":9485632.553598715},9128953.6083972678,9188594.2404682338,9551318.9264160935,9508377.3602615204,10309474.358817786,7490699.2713284092,6629689.8364833556,6903703.4630262433,4313005.5343957553,2074124.674079739,2055556.8079630837,2046395.5673529757,2038404.0336604824,2031771.575258072,2026767.5344954235,2022329.691590166,2019502.7822784728,2017135.1817416649,{"$f":"AI55/$M$1*$M$2","v":2015419.555701104},2014705.4912390155,2014393.454212324,2014532.6803804662,2015653.2920087115,2016746.9353818337,2018242.2526085062,2019402.6386671921,2020943.5082819597,2022928.4842950858]
["Domestic","Services",null,"Services",206293.87178192832,384489.79515972827,778375.7743045406,1423063.4007354509,1598312.8119333212,1619193.6670771521,1640433.0368476138,1657131.706707872,2675817.0580964154,2675817.0580964154,2528988.875154512,3294755.4433889934,3361921.1685420726,3433061.7249015952,3536800.4288808741,3830748.1364725656,3938608.0485828798,3828332.2700846237,3852381.579920664,3613613.5064574559,3614225.5163164428,3393898.4908074955,3090056.3872808521,2926773.0735643911,2777265.4938086416,2635282.7369367913,2505018.1717418493,2383511.3999471962,2270552.4204995087,2165716.8857876207,{"$f":"AI56/$M$1*$M$2","v":2067492.3314760523},1977290.2912846694,1891791.8689340402,1813395.0733075377,1740994.7037009641,1672982.4784916367,1609413.816407783,1549705.36097001,1493695.6052442812,1442371.9573788084]
[null,"Meters",null,"Meters/Tele",85624.95709237759,151567.7490803485,256740.27206065782,337353.82763334044,329645.77546102525,335446.49284531362,341118.98391114752,345721.21613227815,953539.34899052326,953539.34899052326,905862.38154099719,693775.76630817843,707044.63795234472,720958.98808728904,741948.66861958278,866500.93823123036,966168.41964481317,1087201.7479758793,1265924.2374017867,1196863.0139508178,1294611.3296557872,1270856.9254206107,1255443.1886516076,1223022.7620252469,1227056.6823938582,1211291.3825602382,1190040.2598753462,1176893.8557262167,1166178.4281407401,1164803.2732284847,{"$f":"AI57/$M$1*$M$2","v":1253102.0111146825},1356143.7577661425,1396592.209413399,1553908.6314770398,1480887.5868378861,1547496.3227426619,1522222.4913467397,1504984.7916093499,1466355.1172742469,1463597.6000697792]
["IC","Services",null,"Services",167090.07571933369,211704.06969990322,630435.95781627402,421968.33656040509,342285.29556884582,373430.63370566611,216188.00975091438,163791.51001040993,184936.00329625054,121464.4581788216,59153.193242686444,444553.87225262984,445287.66151812678,444930.17256293097,443668.06875389587,442900.77250854467,440842.18931374315,324911.43645447883,347242.40510771231,357157.63877247897,369480.36632878549,337349.33755776926,306212.84755822155,281819.17798898241,248858.34893226382,226641.0025542746,205969.8365474779,188322.03346606551,173776.35192649762,155257.05786227199,{"$f":"AI58/$M$1*$M$2","v":142356.63746863866},126463.71185608258,118786.31414508788,105462.86464669147,95069.831320311088,87086.790730073175,75785.480281826865,73662.65659300478,68403.858365996057,59966.593491534244]
[null,"Meters",null,"Meters/Tele",194898.57647652703,340488.5994191675,601209.0317122374,115788.28996855601,81714.167345848415,89548.390445766709,52035.815992396587,39553.39581455107,131168.61969509683,79099.46435929132,33773.646477132264,233345.54290779587,235903.98405884503,223560.38400953502,222926.22514684772,241125.54748818098,250936.74751678688,249576.14540580544,287017.49828916334,249763.31420164468,260540.24737203232,243956.07466101128,240517.62619544895,202894.53140256857,199008.08496533454,172611.66662505362,156985.15386180909,152130.55802420925,137583.76712145444,127303.30374848653,{"$f":"AI59/$M$1*$M$2","v":136876.06311934671},135689.76807801222,157014.54928280076,180160.16384086147,129953.81604994297,129419.89968316004,118586.4421402146,126308.4184527819,100370.61315040158,110625.02216886586]
["Large loads","Services",null,"Services",14264.149419485108,98616.949467570201,269266.73154416599,335522.22155216348,300692.54766307306,150154.75459833004,111909.31276692472,22609.697110018151,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AI60/$M$1*$M$2","v":0},0,0,0,0,0,0,0,0,0]
[null,"Meters",null,"Meters/Tele",184675.37607269056,336956.87744433689,802676.43999167928,244096.26382893207,185235.70051573362,101680.17093482896,85107.934944531706,17251.234999688193,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AI61/$M$1*$M$2","v":0},0,0,0,0,0,0,0,0,0]
["Telemetry","PRS from 2017",null,"Meters/Tele",19855.222337125128,43681.48914167528,152885.2119958635,22965.865447573131,15740.450856759737,6925.798376974285,0,0,26370.004120313148,26370.004120313148,{"$f":"O17/$E$2*$M$2","v":10548.001648125259},18881.406757281555,36682.145553398062,41797.651883495142,46653.718368932037,43709.01250485437,133011.44605825242,22130.701456296367,22269.724941893561,22270.590272094429,22900.100550531683,22826.672828770308,23027.02679274619,23155.941243894373,23293.562970480798,23424.907626457167,23560.304727483555,23687.490160229434,23820.659941862843,23954.424552995712,{"$f":"AI62/$M$1*$M$2","v":24080.526448034005},24213.318808942844,24334.16927457157,24459.122176689696,24585.265410574531,24701.923940293073,24822.462662801481,24921.00940092907,25023.906909063109,25130.740941955424]
["Other capex","IT & office",null,"Other",414551.89245087898,72300.806618407441,794208.89348500513,58886.83448095675,58297.966136147181,634864.85122264281,57137.836610037855,56566.458243937479,128685.62010712815,23205.603625875567,22150.803461063038,560520.10585141554,113141.46507471641,113141.46507471641,113141.46507471641,113141.46507471641,113141.46507471641,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AI63/$M$1*$M$2","v":0},0,0,0,0,0,0,0,0,0]
["Capex not started (Foyle river crossing)",null,null,"Mains",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AI64/$M$1*$M$2","v":0},0,0,0,0,0,0,0,0,0]
[]
["Capex - Subtotals in DEC £2014  - GD17 Submission"]
[]
["MP","4 bar main - Non LP Infill!!",null,"Mains",{"$f":"E38/$M$2*$M$1","v":9217546.1230735723},{"$f":"F38/$M$2*$M$1","v":12048503.496158866},9096078.905952299,10901993.009229621,10755547.181657929,7351733.0016374039,5591237.3255220773,4906647.0024221418,980659.94586952613,828777.31086510886,749649.17385531624,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Governors",null,"Meters/Tele",{"$f":"E39/$M$2*$M$1","v":0},34807.578667454574,110319.10178756094,103080.43608088874,133775.46086414525,136129.48357334142,70030.333209465563,70975.152674679121,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["LP","Infill &TMA from 2017",null,"Mains",0,0,298198.33368019649,868506.91660878609,722632.9152533781,763991.661828449,808562.79848682845,476118.61285627488,7181740.2697693007,5641960.6149681704,5059552.7952881968,9541212.4318424575,9182443.5709464699,9242433.659845978,9607283.6857505627,9564090.5088568032,10369881.435138984,7534590.0873713493,6668535.6753690001,6944154.8505049124,4338277.051198855,2086277.748341925,2067601.0861347425,2058386.1663804345,2050347.8072952118,2043676.4868318497,2038643.1255178577,2034179.279626827,2031335.8063933856,2028954.3331971825,2027228.6546602901,2026510.4062267442,2026196.5408580992,2026336.5828045704,2027463.7605165751,2028563.8119563367,2030067.8908073842,2031235.0760031326,2032784.9741507992,2034781.5808827523]
["Domestic","Services",null,"Services",207502.62493690057,386742.66505324229,782936.56985710631,1431401.6628491352,1607677.926065743,1628681.1299701822,1650044.9491728928,1666841.4628018634,2691495.673671199,2691495.673671199,2543807.1693448704,3314060.6510651009,3381619.9253889988,3453177.3209459404,3557523.8688938478,3853193.9263347094,3961685.8301175451,3850763.9044796508,3874954.1282405118,3634787.0230968553,3635402.6189511092,3413784.6147770709,3108162.1864250759,2943922.1345423074,2793538.5338114267,2650723.8467235304,2519696.0125918994,2397477.2870562617,2283856.4385883729,2178406.6331652827,2079606.5443557948,1988875.9765851656,1902876.5869160756,1824020.4350651992,1751195.844542962,1682785.1102015486,1618843.9754882974,1558785.6658194438,1502447.7279312594,1450823.355566575]
[null,"Meters",null,"Meters/Tele",86126.665825340737,152455.84136011617,258244.60959226324,339330.51021712954,331577.29367661721,337411.99963932915,343117.72795750189,347746.92638305319,959126.49361351458,959126.49361351458,911170.16893283895,697840.85868889035,711187.47762784676,725183.35715811304,746296.02409977559,871578.09216617898,971829.56272866949,1093572.0707179254,1273341.7622303129,1203875.8831731859,1302196.9429154892,1278303.352717997,1262799.3010851131,1230188.9110214885,1234246.4676422598,1218388.7930049272,1197013.1520230533,1183789.7181621124,1173011.5048681274,1171628.2924075578,1260444.4057110576,1364089.9125968034,1404775.3668904307,1563013.5648646005,1489564.6625420144,1556563.6840087322,1531141.7637569746,1513803.061872686,1474947.0417895257,1472173.367257688]
["IC","Services",null,"Services",168069.11913175165,212944.52323330109,634129.9185066038,424440.80728243873,344290.87347256951,375618.70382503525,217454.73637054864,164751.22588937718,186019.61269056451,122176.16398846313,59499.79398434281,447158.68009786011,447896.76890983456,447537.18529279187,446267.68634425075,445495.89422246191,443425.24901675334,326815.21440245426,349277.02857514034,359250.35931216145,371645.29035024322,339325.99383252184,308007.06346188299,283470.46223501163,250316.50332053882,227968.97717861604,207176.69105849828,189425.48288090574,174794.57273856693,156166.76718568374,143190.75839130647,127204.71016773931,119482.32770453175,106080.81111923067,95626.881113203533,87597.064894507203,76229.535830353198,74094.273721479418,68804.66222360931,60317.960250273703]
[null,"Meters",null,"Meters/Tele",196040.56032306919,342483.64980638918,604731.74088242627,116466.73698009051,82192.9612951405,90073.088046034871,52340.713351727034,39785.153993151958,131937.18582612279,79562.93778327154,33971.538936959209,234712.80194827123,237286.23396543984,224870.30813459089,224232.43349731754,242538.39249299455,252407.08002176805,251038.50563279257,288699.24144320143,251226.77112079493,262066.85038397781,245385.50478597815,241926.90916143791,204083.36654750549,200174.14796317829,173623.06310918479,157904.98874771813,153021.94801263235,138389.92200693171,128049.22154388782,137678.07130168664,136484.82531284433,157934.55640750466,181215.78980086651,130715.2641908606,130178.21940786605,119281.28457462991,127048.50684215367,100958.72221182971,111273.21565813656]
["Large loads","Services",null,"Services",14347.728419989902,99194.783155856741,270844.46629930759,337488.17206907069,302454.41805953637,151034.56761355462,112565.03139641842,22742.175804022165,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Meters",null,"Meters/Tele",185757.45835436648,338931.2341481123,807379.62225725548,245526.51537480473,186321.06594844299,102275.95318640022,85606.614250847328,17352.316454764492,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Telemetry","PRS from 2017",null,"Meters/Tele",19971.561530506719,43937.435367114784,153781.02378490177,23100.431065430006,15832.680060998564,6966.379226839369,0,0,26524.515863205608,26524.515863205608,10609.806345282243,18992.04,36897.08,42042.559999999998,46927.08,43965.120000000003,133790.81,22260.373535141855,22400.21161147497,22401.082011969982,23034.280827194954,22960.422864876386,23161.950777859936,23291.620587120316,23430.048691010958,23562.162944580938,23698.353387996154,23826.284047887028,23960.234121209694,24094.782509360921,24221.623282690452,24355.193723838995,24476.752297664763,24602.437345693736,24729.319700089618,24846.661775880726,24967.906779966335,25067.030940387638,25170.531363608399,25277.991377162194]
["Other capex","IT & office",null,"Other",416980.90744570835,72724.444157187172,798862.46122026886,59231.874526743602,58639.555781476171,638584.76246027544,57472.628621424796,56897.902335210551,129439.63741244336,23341.573959620931,22280.593325092705,563804.40334663866,113804.40334663857,113804.40334663857,113804.40334663857,113804.40334663857,113804.40334663857,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Capex not started (Foyle river crossing)",null,null,"Mains",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Capex - Subtotals in Av £2014 - UR Draft Det"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Linked to Capex DD 04.00 Final Issued to AC Post RPE 04-03-16 All - Converted to Av £2014",null,null,null,null,null,"Post GD17 Linked to Capex DD 04.00 Final Issued to AC Post RPE 04-03-16 All - Converted to Av £2014"]
["MP","4 bar main - Non LP Infill!!",null,"Mains",{"$f":"E38","v":9163851.6796381921},{"$f":"F38","v":11978318.038899688},9043092.038538985,10838486.253836051,10692893.508755067,7308907.3725016518,5558667.0110044731,4878064.592699294,974947.36366057745,823949.48186977813,745282.28546392603,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Governors",null,"Meters/Tele",{"$f":"E39","v":0},34604.816073275229,109676.46624316738,102479.96752119425,132996.18633483956,135336.49629038991,69622.389520866738,70561.705183370315,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["LP","Infill &TMA from 2017",null,"Mains",0,0,296461.25600827299,863447.65301689028,718423.40312568855,759541.22496342892,803852.7239325362,473345.10637361696,7139904.8895570515,5609094.8249780647,5030079.6722088484,8555091.644436311,8281762.3229990024,8161225.047773717,8125322.5929647023,8223366.0130449189,8250559.77759209,8453132.4855783507,7589340.6137340749,7879579.3768352084,5273178.960268897,2049709.2412921893,2044389.6513965565,2036741.719915896,2030756.3092185059,2023772.1763426452,2025056.4298815154,2017952.3897440073,2019538.2637438904,2020815.0240027274,2022216.8998972939,2016419.265806979,2017145.3566747506,2018598.5189045211,2020003.4711567846,2019965.8070137941,2021067.6757632357,2020852.1249681364,2028099.1836716477,2028363.5652776069]
["Domestic","Services",null,"Services",206293.87178192832,384489.79515972827,778375.7743045406,1423063.4007354509,1598312.8119333212,1619193.6670771521,1640433.0368476138,1657131.706707872,2675817.0580964154,2675817.0580964154,2528988.875154512,2715542.1730459379,2937434.9065124448,3161948.8897992135,3354215.8146297769,3544045.6130942423,3661855.9301229944,3632004.7674730783,3632004.7674730783,3558792.5363007416,3412368.0739560686,3265943.6116113956,3082913.0336805545,2936488.571335881,2790064.108991208,2643639.6466465355,2570427.4154741988,2424002.9531295253,2350790.721957189,2277578.4907848523,2204366.259612516,2057941.797267843,1984729.5660955063,1911517.3349231696,1838305.1037508335,1765092.8725784968,1691880.6414061601,1618668.4102338236,1618668.4102338236,1545456.1790614873]
[null,"Meters",null,"Meters/Tele",85624.95709237759,151567.7490803485,256740.27206065782,337353.82763334044,329645.77546102525,335446.49284531362,341118.98391114752,345721.21613227815,953539.34899052337,953539.34899052337,905862.38154099719,914610.59814739041,985805.17941834405,1058574.6869490414,1124467.1965966329,1191617.4288233523,1240210.6970556299,1266936.204132532,1286564.7546286986,1286769.714145784,1352576.8358863872,1431570.8467666362,1514421.1532830545,1540317.1835032448,1591026.7634380483,1758991.3747081144,1899908.3552778082,1878468.7104044317,1875535.0721653942,1869378.9273550182,1824739.0922623342,1874672.7703340726,1933773.0063815692,1992509.7507532111,2041352.9537973849,2089832.6651657035,2118888.7855549403,2052280.9177521907,2061913.4471623464,2033062.2862901944]
["IC","Services",null,"Services",167090.07571933369,211704.06969990322,630435.95781627402,421968.33656040509,342285.29556884582,373430.63370566611,216188.00975091438,163791.51001040993,184936.00329625054,121464.4581788216,59153.193242686444,289929.80349587015,286919.25332701189,284617.05994610139,282898.5189716419,281190.35468746745,279492.50443827745,242836.62683015471,261531.55881281287,268143.18109936261,271107.01177954022,243976.56170714609,224711.66228599229,198721.14709058954,182876.05230040979,161715.0113167215,147009.85140353313,127744.95198237934,117713.52506485546,104148.30002865843,97536.677742108615,87163.270361487346,77701.810882459162,72458.110448298961,65846.488161749134,51867.036903106338,46395.349493547867,44115.479739565177,40011.714182396317,36363.922576024008]
[null,"Meters",null,"Meters/Tele",194898.57647652703,340488.5994191675,601209.0317122374,115788.28996855601,81714.167345848415,89548.390445766709,52035.815992396587,39553.39581455107,131168.61969509683,79099.464359291305,33773.646477132264,234721.92879138369,240823.18272676945,220256.79274150814,218926.86429905641,217604.96607279018,216291.04957561049,186239.94948464163,202156.80313154674,212007.03941183811,281568.78253662837,322145.51782061637,474483.66068772704,755022.08846426138,568139.94449227839,545568.43667568907,504182.71085137868,362473.39328795183,418503.66163410124,273817.89046280837,154009.41128320337,304933.02661491017,304985.51823635079,283941.98289541167,279254.59966563288,265081.86187666509,260585.07963991852,218942.9122790455,233253.75943960491,239832.01798343088]
["Large loads","Services",null,"Services",14264.149419485108,98616.949467570201,269266.73154416599,335522.22155216348,300692.54766307306,150154.75459833004,111909.31276692472,22609.697110018151,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Meters",null,"Meters/Tele",184675.37607269056,336956.87744433689,802676.43999167928,244096.26382893207,185235.70051573362,101680.17093482896,85107.934944531706,17251.234999688193,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Telemetry","PRS from 2017",null,"Meters/Tele",19855.222337125128,43681.48914167528,152885.2119958635,22965.865447573131,15740.450856759737,6925.798376974285,0,0,26370.004120313144,26370.004120313144,10548.001648125259,6911.4367684450008,12624.620622117282,23223.63620185461,22043.470230512074,7736.7635961618698,29486.118130375162,45877.639242704143,40079.928281699387,46017.528058502197,58520.507230143339,136697.27228508101,86440.253193116048,86569.16764426422,86706.78937085066,86838.134026827014,86973.531127853421,87100.716560599292,87233.886342232698,87367.650953365563,87493.752848403863,87626.545209312695,87747.395674941421,87872.348577059543,87998.491810944382,88115.15034066292,43703.869420083043,70798.648643633205,65103.835190762489,71148.269000457614]
["Other capex","IT & office",null,"Other",414551.89245087898,72300.806618407441,794208.89348500513,58886.83448095675,58297.966136147181,634864.85122264281,57137.836610037855,56566.458243937479,128685.62010712815,23205.603625875567,22150.803461063042,160607.71401945711,110424.82648356976,109538.79565200016,108877.39148790488,108219.98093598762,107566.53988249302,107566.53988249302,107566.53988249302,107566.53988249302,107566.53988249302,107566.53988249302,107566.53988249302,107566.53988249302,107566.53988249302,107566.53988249302,107566.53988249302,107566.53988249302,107566.53988249302,107566.53988249302,107566.53988249302,107566.53988249302,107566.53988249302,107566.53988249302,107566.53988249302,107566.53988249302,107566.53988249302,107566.53988249302,107566.53988249302,107566.53988249302]
["Capex not started (Foyle river crossing)",null,null,"Mains",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Capex - Subtotals in Av £2014 - UR Final Det"]
[]
["MP","4 bar main - Non LP Infill!!",null,"Mains",{"$f":"E38","v":9163851.6796381921},{"$f":"F38","v":11978318.038899688},9043092.038538985,10838486.253836051,10692893.508755067,7308907.3725016518,5558667.0110044731,4878064.592699294,974947.36366057745,823949.48186977813,745282.28546392603,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Governors",null,"Meters/Tele",{"$f":"E39","v":0},34604.816073275229,109676.46624316738,102479.96752119425,132996.18633483956,135336.49629038991,69622.389520866738,70561.705183370315,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["LP","Infill & TMA from 2017",null,"Mains",0,0,296461.25600827299,863447.65301689028,718423.40312568855,759541.22496342892,803852.7239325362,473345.10637361696,7139904.8895570524,5609094.8249780647,5030079.6722088484,9325580.6838898789,9046212.3897054493,8911661.742908366,8898234.853946887,8977411.2596932538,9012296.8725269102,7320907.0622120257,6482253.9923139447,6762443.3002239261,4228461.1003260547,2058906.6057640414,2049585.2438961628,2038803.6858026143,2029665.8311927118,2019542.8197864466,2019106.9517996518,2008873.0216322506,2008743.5875681159,2008303.7542764484,2008005.5965221364,1999065.9552651774,1998103.3613521929,1997858.973022565,1997563.8022885374,1995846.5125606998,1995260.370237682,1993404.3352644269,2000429.0220842301,1999035.009832965]
["Domestic","Services",null,"Services",206293.87178192832,384489.79515972827,778375.7743045406,1423063.4007354509,1598312.8119333212,1619193.6670771521,1640433.0368476138,1657131.706707872,2675817.0580964154,2675817.0580964154,2528988.875154512,3102401.9712001393,3368800.103802552,3619014.1970894164,3821979.4468362741,4011175.3594084424,4218677.4253562773,4288661.5510213263,4288661.5510213263,4201174.1723805489,4026199.4150989964,3851224.6578174429,3632506.2112155012,3457531.4539339477,3282556.6966523943,3107581.9393708408,3020094.5607300643,2845119.8034485108,2757632.4248077343,2670145.0461669574,2582657.6675261809,2407682.9102446274,2320195.5316038509,2232708.1529630739,2145220.7743222974,2057733.3956815205,1970246.017040744,1882758.6383999672,1882758.6383999672,1795271.2597591905]
[null,"Meters",null,"Meters/Tele",85624.95709237759,151567.7490803485,256740.27206065782,337353.82763334044,329645.77546102525,335446.49284531362,341118.98391114752,345721.21613227815,953539.34899052326,953539.34899052326,905862.38154099719,896176.25355911208,968053.51421942655,1036831.0704941978,1096825.4283080369,1155711.1805676536,1218761.7616517411,1267540.0998938915,1287534.3753935369,1288098.2872288511,1354250.8159171846,1433576.6883746642,1516741.9247551891,1542939.3394689867,1593936.7585268989,1762175.6635495736,1903360.1651866268,1882174.4960101107,1879488.060782684,1873572.3462986688,1829166.1688470962,1854160.6281091878,1911568.1938117242,1965937.0812507048,2008690.2457396772,2048595.3329581253,2092895.1806412756,2058106.553840996,2067918.5594102666,2039240.1020119793]
["IC","Services",null,"Services",167090.07571933369,211704.06969990322,630435.95781627402,421968.33656040509,342285.29556884582,{"$f":"J43","v":373430.63370566611},216188.00975091438,163791.51001040993,184936.00329625054,121464.4581788216,59153.193242686444,292008.17217862507,289510.2900421496,287078.15799859399,285201.90764468751,283337.91985863046,281486.11449622997,242836.62683015471,261531.55881281287,268143.18109936261,271107.01177954022,243976.56170714609,224711.66228599229,198721.14709058954,182876.05230040979,161715.0113167215,147009.85140353313,127744.95198237934,117713.52506485546,104148.30002865843,97536.677742108615,87163.270361487346,77701.810882459162,72458.110448298961,65846.488161749134,51867.036903106338,46395.349493547867,44115.479739565177,40011.714182396317,36363.922576024008]
[null,"Meters",null,"Meters/Tele",194898.57647652703,340488.5994191675,601209.0317122374,115788.28996855601,81714.167345848415,89548.390445766709,52035.815992396587,39553.39581455107,131168.61969509683,79099.46435929132,33773.646477132264,236404.53851302547,242997.94688451043,222161.36432188717,220709.38921747913,219266.90375457675,217833.84591194039,186239.94948464163,202156.80313154674,212007.03941183811,281568.78253662837,322145.51782061643,474483.66068772704,755022.08846426127,568139.94449227827,545568.43667568907,504182.71085137868,362473.39328795177,418503.66163410124,273817.89046280837,154009.41128320337,304933.02661491017,304985.51823635079,283941.98289541167,279254.59966563282,265081.86187666503,260585.07963991852,218942.9122790455,233253.75943960488,239832.01798343085]
["Large loads","Services",null,"Services",14264.149419485108,98616.949467570201,269266.73154416599,335522.22155216348,300692.54766307306,150154.75459833004,111909.31276692472,22609.697110018151,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Meters",null,"Meters/Tele",184675.37607269056,336956.87744433689,802676.43999167928,244096.26382893207,185235.70051573362,101680.17093482896,85107.934944531706,17251.234999688193,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Telemetry","PRS from 2017",null,"Meters/Tele",19855.222337125128,43681.48914167528,152885.2119958635,22965.865447573131,15740.450856759737,6925.798376974285,0,0,26370.004120313148,26370.004120313148,10548.001648125259,6960.9815670796179,12738.627804163405,23424.452153783157,22222.950419479308,7795.8524082767326,18327.505328439645,19140.846601941746,19140.846601941746,19140.846601941746,19140.846601941746,18881.406757281555,30754.875650485439,24818.141203883497,30754.875650485439,42628.344543689323,120878.53732038835,29138.639320374037,29277.662805971231,29278.528136172099,29908.038414609353,29834.610692847978,30034.96465682386,30163.879107972043,30301.500834558468,30432.845490534834,30568.242591561226,30695.428024307104,30828.597805940513,30962.362417073382]
["Other capex","IT & office",null,"Other",414551.89245087898,72300.806618407441,794208.89348500513,58886.83448095675,58297.966136147181,634864.85122264281,57137.836610037855,56566.458243937479,128685.62010712815,23205.603625875567,22150.803461063038,578567.43176510651,126785.73621678636,124557.90765920668,123743.83730304753,113636.78954164691,112894.09609509307,167612.86812603404,117904.13026195636,117904.13026195636,117904.13026195636,117904.13026195636,117904.13026195636,167612.86812603404,117904.13026195636,117904.13026195636,117904.13026195636,117904.13026195636,117904.13026195636,167612.86812603404,117904.13026195636,117904.13026195636,117904.13026195636,117904.13026195636,117904.13026195636,167612.86812603404,117904.13026195636,117904.13026195636,117904.13026195636,117904.13026195636]
["Capex not started (Foyle river crossing)",null,null,"Mains",0,0,0,0,0,0,0,0,0,0,0,{"$f":"2446182/$M$1*$M$2","v":2431932.3961165049},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Capex"]
["Total Capex - £2006",null,null,null,{"$f":"SUM(E8:E19)","v":7895483.83559056},{"$f":"SUM(F8:F19)","v":10314210.256016379},10376384.490053689,11153785.133125253,10921235.910815915,8699245.2092299964,6750923.9409821527,5835691.3552398132,9228329.4793555364,7790801.8876248859,7052934.5131592024,{"$f":"SUM(P8:P19)","v":11129161.215828022},10598421.739805136,10702004.026794687,11072495.627905728,11367162.988959171,12202469.255260689,9823248.0240673535,9371231.2092451602,9325031.4580470864,7460074.9316382008,5547416.2293505222,5266232.0517620128,5064708.6240702989,4921037.4702413557,4760226.174687014,4614660.9372095,4492678.2444999367,4375232.6049855901,4271548.8380727451,{"$f":"SUM(AI8:AI19)","v":4260335.4142125305},4256693.4608162353,4232825.3520379458,4300066.5813647807,4145366.1929551195,4138785.9510841095,4056166.8267563218,4003217.4803088978,3909394.1040011658,3871490.5665629767]
["Total Capex - £2012",null,null,null,{"$f":"SUM(E23:E34)","v":9908138.194921555},{"$f":"SUM(F23:F34)","v":12943427.244752714},13021450.443309359,13997019.916284895,13705191.083531655,10916788.06763247,8471816.1348312739,7323279.6893314496,11580742.319749683,9776771.5518436395,8850812.8559655547,{"$f":"SUM(P23:P34)","v":13966119.064537022},13300087.674512444,13430074.339726321,13895008.732640745,14264790.369288474,15313026.3094714,12327312.799592277,11760071.429595657,11702094.802833648,9361738.2932191901,6961519.745932634,6608658.3193518119,6355764.1316538854,6175469.4623969868,5973665.4219055753,5790993.844161042,5637916.287177531,5490532.3331437567,5360418.3195463056,{"$f":"SUM(AI23:AI34)","v":5346346.4582698084},5341776.1268877974,5311823.7483950844,5396205.58064753,5202070.1914695315,5193812.5663294373,5090132.8275789013,5023686.0520732654,4905945.9619497554,4858380.354213207]
["Total Capex - Av £2014 - FE GD17 Submission",null,null,null,{"$f":"SUM(E38:E49)","v":10451105.800988538},{"$f":"SUM(F38:F49)","v":13652729.191004101},13735028.073700851,14764058.914581511,14456237.813696349,11515029.852962147,8936073.0552814417,7724596.623275036,12215368.907523356,10312540.24421908,9335838.8591972925,{"$f":"SUM(P38:P49)","v":14731464.691065012},14028934.671096772,14166044.626987794,14656457.501260942,15046503.232541613,16152182.675008979,13002851.572705494,12404525.282144578,12343371.526680736,9874763.0946193356,7343012.1753553953,6970813.8844419606,6704061.0535780583,6513886.2067310605,6301023.2715608869,6108341.2612493904,5946875.0289140828,5791414.4099085368,5654170.1269215243,{"$f":"SUM(AI38:AI49)","v":5639327.1253278581},5634506.3390328661,5602912.5652622236,5691918.5358292861,5487144.4953283891,5478434.3509696592,5369072.9454478705,5298984.8756932681,5174792.6092259493,5124620.3983460292]
["Total Capex - DEC £2014",null,null,null,{"$f":"SUM(E53:E64)","v":10512342.749041205},{"$f":"SUM(F53:F64)","v":13732725.651107643},13815506.753820188,14850567.072284138,14540942.332135979,11582500.731006846,8988432.8583397325,7769857.9316145377,12286943.334715877,10372965.284712555,9390541.0400128998,14817781.866989218,14111135.46018523,14249048.794724055,14742335.181932392,15134666.337419787,16246824.370370358,13079040.156139312,12477208.047469644,12415695.96921988,9932623.0346268695,7386037.6373203695,7011658.4970461121,6743342.6613138691,6552053.5087236259,6337943.3297926895,6144132.3233270217,5981719.9997866256,5825348.4787165951,5687300.030008954,{"$f":"SUM(AI53:AI64)","v":5672370.0577028263},5667521.0246131355,5635742.1310743075,5725269.6210001614,5519295.732605705,5510534.5522448719,5400532.3572376054,5330033.6151992837,5205113.6596706314,5154647.4709925875]
["Total Capex - Av £2014 - UR Draft Det",null,null,null,{"$f":"SUM(E68:E79)","v":10451105.800988538},{"$f":"SUM(F68:F79)","v":13652729.191004101},13735028.073700851,14764058.914581511,14456237.813696349,11515029.852962147,8936073.0552814417,7724596.623275036,12215368.907523356,10312540.244219081,{"$f":"SUM(O68:O79)","v":9335838.8591972925},{"$f":"SUM(P68:P79)","v":12877415.298704794},{"$f":"SUM(Q68:Q79)","v":12855794.292089259},13019384.909063434,13236751.849180231,13573781.120254919,13785462.61679747,{"$f":"SUM(V68:V79)","v":13934594.212623956},{"$f":"SUM(W68:W79)","v":13119244.965944404},13358875.915733928,10756886.711540157,7557609.591365559,7534925.9544094941,7661426.4178366298,7357136.5076937946,7328091.3195990259,7341124.8338987809,7005309.6549913874,6976881.6707901573,6740672.8234699238,6497928.6335283527,6536323.2154770987,6513649.1938280715,6474464.5863841651,6440327.6482258216,6387521.9337609224,6290087.941160379,6133225.0334988879,6154616.8897630759,6061792.7800716944]
["Total Capex - Av £2014 - UR Final Det",null,null,null,{"$f":"SUM(E83:E94)","v":10451105.800988538},{"$f":"SUM(F83:F94)","v":13652729.191004101},13735028.073700851,14764058.914581511,14456237.813696349,11515029.852962147,8936073.0552814417,7724596.623275036,12215368.907523356,10312540.24421908,{"$f":"SUM(O83:O94)","v":9335838.8591972925},{"$f":"SUM(P83:P94)","v":16870032.428789474},{"$f":"SUM(Q83:Q94)","v":14055098.60867504},14224728.892625451,14468917.813675892,14768335.265232481,{"$f":"SUM(U83:U94)","v":15080277.621366629},13492939.004170017,12659183.257537063,12868910.957208425,10298632.102522301,8046615.5685031498,8046687.708753014,8185448.7240903163,7805834.2890771348,7757116.3455049172,7832536.9075536001,7373428.4359435346,7329263.05292542,7126878.7334957467,6819187.690597292,6800744.5315501941,6760493.5108053591,6700972.3099499829,6644781.5412744088,6617169.8535966855,6513854.3699066853,6345927.4778102646,6373104.4215843631,6258608.8048426202]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Opex"]
["Total Opex - Av £2014 - UR Final Det",null,null,null,5042039.5355880875,6462480.0228248565,6426407.6637687851,6203884.654678951,5779951.4524189532,5779756.2961345157,5562712.4767710976,5196757.8273461675,5665371.4080630774,5871023.9565660441,6138280.638636535,6400428.3486982603,6354391.1259654341,6494151.8707070993,6689509.9097442664,6941077.3949377397,7254769.5690012202,7441890.5396429896,7540878.0146904299,7627520.4273558753,7719348.2712727701,7881132.868371876,8083674.7675785627,8198020.7518430725,8298339.4623038825,8363873.533360865,8303503.9426606819,8213556.665251446,8200560.3915330935,8319471.2847529575,8512435.5824412648,8732058.0342062954,8807962.412517909,8813779.6483350843,9061647.1737421807,9318411.7696721591,9308878.1996023413,9162286.523511149,9109951.3236088529,9032978.58285149]
[]
["Volumes (Therms)"]
["GD17 FD"]
["Domestic","P1",null,null,64221,558617,1506329,1765161.1017030813,2676992.6535403649,3655315.6994553381,4578235.3113516886,5535454.7706306791,8222120.8526521884,9798128.2439809628,11337112.59500844,11203323.378270078,12702360.989018295,14326699.280580208,16062487.011711972,17896063.057793055,19829726.038751334,21643454.427329723,23401323.326366756,25082557.014303595,26700948.441771291,28185555.038309969,29584490.583048541,30853598.72600615,32043121.86708371,33109612.665686525,34118163.822969578,35025604.106243148,35878257.766668394,36650593.783935919,37387530.340127297,38030467.901377402,38623921.519376032,39143311.808696337,39631768.684496991,40048845.569480203,40436790.324254863,40755982.777216941,41063159.887550257,41319037.542245932]
["Small IC","P2",null,null,0,2596,20579,1125000,1430000,1887000,2255000,2610000,8795675.3019238226,9434708.3817379549,9821200.8075830545,8335677.3474708954,8849510.5040420257,9352278.0105153415,9844149.79657715,10325293.499885023,10795874.494915435,11215022.066147061,11602463.199554017,11773164.588792324,12166809.494504767,12306058.882053426,12610323.990060942,12673302.881860003,12905908.449900407,12908449.555074668,13083541.050804961,13038281.716745947,13167148.536668703,13084173.425693898,13175823.550813511,13063178.452253668,13124797.838751927,12988900.384376364,13026220.144930789,12872188.055825885,12889777.887123175,12721691.263245024,12723193.890889924,12544304.757362621]
["Medium IC","P3",null,null,0,196639,522544,1872761.2253318976,2624879.6059852978,3089440.658133693,3662526.0563349789,3750125.7196735349,3807199.7661422309,3902269.7661422314,3999351.9223922314,6380452.711904861,6374076.0908642253,6367763.2360339956,6361513.5097520696,6355326.2807329623,6349200.9240040472,6293990.481186619,6238780.0383691927,6183569.5955517665,6128359.1527343392,6073148.709916913,6017938.2670994867,5962727.8242820604,5907517.3814646332,5852306.9386472069,5797096.4958297806,5741886.0530123543,5686675.6101949271,5631465.1673775008,5576254.7245600745,5521044.2817426482,5465833.838925221,5410623.3961077947,5355412.9532903684,5300202.5104729421,5244992.0676555149,5189781.6248380886,5134571.1820206624,5079360.7392032361]
["Large Firm CHP","P4",null,null,1163837,4264513,7745837,599915.6273257588,599668.1952572451,599265.96313585842,598716.84216108394,598028.40908418782,3337000,3337000,3337000,1160961.1091276254,927141.3657889805,927141.3657889805,927141.3657889805,927141.3657889805,927141.3657889805,919079.26695603284,911017.16812308517,902955.06929013762,894892.97045718983,886830.87162424228,878768.7727912945,870706.67395834695,862644.57512539916,854582.47629245161,846520.37745950394,838458.27862655628,830396.17979360861,822334.08096066094,814271.98212771327,806209.8832947656,798147.78446181794,790085.68562887027,782023.58679592272,773961.48796297493,765899.38913002727,757837.29029707971,749775.19146413205,741713.09263118438]
["Large Firm","P5",null,null,0,0,30698,10445530.931120336,13739397.800335582,15604885.680057753,16217243.531336559,16348103.276331419,11018999.999999998,11018999.999999998,11018999.999999998,13374606.008694762,13360835.65099987,13360835.65099987,13360835.65099987,13360835.65099987,13360835.65099987,13244654.47142596,13128473.291852048,13012292.112278137,12896110.932704223,12779929.753130313,12663748.573556401,12547567.393982489,12431386.214408576,12315205.034834664,12199023.855260752,12082842.67568684,11966661.496112928,11850480.316539017,11734299.136965103,11618117.957391193,11501936.777817279,11385755.598243369,11269574.418669457,11153393.239095544,11037212.059521632,10921030.87994772,10804849.70037381,10688668.520799898]
["Int","P6",null,null,4770961,9073301,14530386,11426119.582749041,13355461.799958056,13659721.423725909,13647204.711606814,13631512.50709703,23389390.873258937,23418346.129278943,23441549.504552245,21500025.712540649,18152168.570725184,18152168.570725184,18152168.570725184,18152168.570725184,18152168.570725184,17994323.626631938,17836478.682538673,17678633.738445412,17520788.794352148,17362943.850258887,17205098.906165622,17047253.962072361,16889409.017979097,16731564.073885836,16573719.129792571,16415874.18569931,16258029.241606047,16100184.297512785,15942339.353419522,15784494.409326259,15626649.465232996,15468804.521139733,15310959.577046473,15153114.632953208,14995269.688859945,14837424.744766682,14679579.800673421,14521734.856580159]
["Total Volume (Therms) - UR Final Det",null,null,null,5999019,14095666,24356373,27234488.468230113,{"$f":"SUM(I109:I114)","v":34426400.055076547},38495629.424508549,40958926.452791125,42473224.682816848,58570386.793977171,60909452.521140091,62955214.829535969,{"$f":"SUM(P109:P114)","v":61955046.268008873},{"$f":"SUM(Q109:Q114)","v":60366093.17143859},{"$f":"SUM(R109:R114)","v":62486886.114643574},{"$f":"SUM(S109:S114)","v":64708295.905555233},{"$f":"SUM(T109:T114)","v":67016828.425925076},{"$f":"SUM(U109:U114)","v":69414947.045184851},{"$f":"SUM(V109:V114)","v":71310524.339677334},{"$f":"SUM(W109:W114)","v":73118535.706803769},{"$f":"SUM(X109:X114)","v":74633172.118661374},{"$f":"SUM(Y109:Y114)","v":76307909.786523953},{"$f":"SUM(Z109:Z114)","v":77594467.105293751},{"$f":"SUM(AA109:AA114)","v":78960369.092722297},{"$f":"SUM(AB109:AB114)","v":79955157.462161407},{"$f":"SUM(AC109:AC114)","v":81039987.50596182},{"$f":"SUM(AD109:AD114)","v":81771720.744421363},{"$f":"SUM(AE109:AE114)","v":82618064.732117146},{"$f":"SUM(AF109:AF114)","v":83142947.016014159},{"$f":"SUM(AG109:AG114)","v":83787168.831044599},{"$f":"SUM(AH109:AH114)","v":84139231.072019786},{"$f":"SUM(AI109:AI114)","v":84630519.088013217},{"$f":"SUM(AJ109:AJ114)","v":84823512.885385931},{"$f":"SUM(AK109:AK114)","v":85141287.224565268},{"$f":"SUM(AL109:AL114)","v":85187481.394192457},{"$f":"SUM(AM109:AM114)","v":85375959.365229994},{"$f":"SUM(AN109:AN114)","v":85301705.49579075},{"$f":"SUM(AO109:AO114)","v":85369941.416545153},{"$f":"SUM(AP109:AP114)","v":85183748.580311537},{"$f":"SUM(AQ109:AQ114)","v":85155129.652972206},84894819.508823022]
[]
["TRV Opening Value (£2014)"]
["DAV (Incl Uncertainty Mechanism Capex Adjustments)",null,null,null,null,null,null,null,null,null,null,{"$f":"DAV!L35","v":87789156.407069787},null,null,{"$f":"DAV!O35","v":105662652.97555538}]
["PAB determination",null,null,null,null,null,null,null,null,null,null,31724674.250258528,null,null,{"$f":"(37603.2511769514*1000)/K2*M2","v":39663915.53893514}]
["Opex adjustment MDR",null,null,null,null,null,null,null,-52055.317639015622,-238998.33200229373,-404873.37811521307,-418911.61578483548,"n/a","n/a","n/a"]
["Opex Adjustment OAV & PCR02 Retro Opex Adj",null,null,null,null,null,null,{"$f":"D131+H143","v":2922657.9180946201},{"$f":"I143","v":631836.17924617918},{"$f":"J143","v":1560191.3248136702},{"$f":"K143","v":2070553.9375680764},{"$f":"L143","v":1808970.0033849594},"n/a","n/a","n/a"]
["GD14 Uncertainty Mechanism Adj",null,null,null,null,null,null,"n/a","n/a","n/a","n/a","n/a",{"$f":"M143","v":-603995.03534388205},{"$f":"N143","v":-265007.63093670085},-296639.33589103405]
["Adjusted PAB",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H119:L122)","v":39604044.969824679},null,null,{"$f":"SUM(M119:O122)","v":38498273.536763526}]
["Actual Depreciation",null,null,null,null,null,null,{"$f":"1630500.22677686/K2*M2","v":1719851.9079310927},{"$f":"1947695.89523954/K2*M2","v":2054429.9513033468},{"$f":"2203584.72118004/K2*M2","v":2324341.52707907},{"$f":"2612872.60094617/K2*M2","v":2756058.4501121528},{"$f":"2777246.76356909/K2*M2","v":2929440.34393773},{"$f":"DAV!M29","v":3150891.4533627699},{"$f":"DAV!N29","v":3449656.6293379012},{"$f":"DAV!O29","v":3814245.9059210173}]
["Determined Depreciation (per V7 PH Model)",null,null,null,null,null,null,{"$f":"-1690376.52079378/K2*M2","v":-1783009.4327285031},{"$f":"-2072120.48949698/K2*M2","v":-2185673.0338328262},{"$f":"-2345564.29024628/K2*M2","v":-2474101.5999301514},{"$f":"-2521468.70325611/K2*M2","v":-2659645.6037641708},{"$f":"-2731587.08372248/K2*M2","v":-2881278.5061102388},{"$f":"-3120839.57568117/K2*M2","v":-3291862.0987819512},{"$f":"-3399887.94022108/K2*M2","v":-3586202.3596893139},{"$f":"-3692450.11767324/K2*M2","v":-3894796.9926837641}]
["DAB Adjustment",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H124:L125)","v":-199585.99600249715},null,null,{"$f":"SUM(M124:O125)","v":-358067.46253333939}]
["Capitalised Under-recoveries","Exclude",null,4.2999999999999997E-2,null,null,null,null,null,null,null,"n/a",null,null,0]
["Opening TRV Value","Include - In Full",null,null,null,null,null,null,null,null,null,{"$f":"SUM(L118,L123,L126,L127)","v":127193615.38089198},null,null,{"$f":"SUM(O118,O123,O126,O127)","v":143802859.04978558}]
[null,"Include - Discounted"]
[null,"Exclude"]
["Opening Asset Value (£2014)","Opex","PI's model V7",3212984.4870914645]
[null,"Mains","PI's model V7",1845762.7935014917]
[null,"Other Capex","PI's model V7",449375.3050672182]
[null,"Total OAV",null,{"$f":"SUM(D131:D133)","v":5508122.5856601736}]
[]
[]
["UM ADJUSTMENTS UPDATE BY FORMULA YEAR (£2014)",null,null,null,null,null,null,"PCR02",null,null,null,null,"GD14"]
[null,null,null,null,null,null,null,2009,2010,2011,2012,2013,2014,2015,2016]
["Uncertainty Mechanism Adjustment Categories",null,null,null,null,null,null,"Actual","Actual","Actual","Actual","Forecast","Forecast","Forecast","Forecast"]
["Capex 40 Yr Life",null,null,null,null,null,null,{"$f":"-2664919.34097565/K2*M2","v":-2810957.3600732032},{"$f":"-3369293.41742625/K2*M2","v":-3553931.2520029666},{"$f":"1435272.85221556/K2*M2","v":1513926.0410679167},{"$f":"4821142.32086481/K2*M2","v":5085341.7146328446},{"$f":"2158215.58502883/K2*M2","v":2276486.1547893719},-5573402.9039872596,-207530.19739508501,1977833.0503587432,"Linked to UM Model"]
["Capex 15 Yr Life",null,null,null,null,null,null,{"$f":"152976.527336461/K2*M2","v":161359.66624694693},{"$f":"295260.527926963/K2*M2","v":311440.85351999395},{"$f":"665935.025800321/K2*M2","v":702428.37496861222},{"$f":"893259.912382716/K2*M2","v":942210.70280171116},{"$f":"747802.663865809/K2*M2","v":788782.37309290119},-9914.0230446598543,144197.550039658,98232.259945405822,"Linked to UM Model"]
["Capex 5 Yr Life",null,null,null,null,null,null,{"$f":"0/K2*M2","v":0},{"$f":"0/K2*M2","v":0},{"$f":"-752295.29351409/K2*M2","v":-793521.19958634966},{"$f":"0/K2*M2","v":0},{"$f":"0/K2*M2","v":0},-4873.1897492644639,0,0,"Linked to UM Model"]
["Opex",null,null,null,null,null,null,{"$f":"-275243.19646693/K2*M2","v":-290326.56899684417},{"$f":"599010.31524628/K2*M2","v":631836.17924617918},{"$f":"1479134.50989171/K2*M2","v":1560191.3248136702},{"$f":"1962982.19003036/K2*M2","v":2070553.9375680764},{"$f":"1714988.35867785/K2*M2","v":1808970.0033849594},-603995.03534388205,-265007.63093670085,-296639.33589103405,"Linked to UM Model"]
["Total Retrospective Adjustments",null,null,null,null,null,null,{"$f":"SUM(H140:H143)","v":-2939924.2628231007},-2610654.2192367935,2983024.5412638495,8098106.3550026324,{"$f":"SUM(L140:L143)","v":4874238.5312672332},{"$f":"SUM(M140:M143)","v":-6192185.1521250652},{"$f":"SUM(N140:N143)","v":-328340.27829212788},1779425.9744131151,"Linked to UM Model"]

{"sheet":"DAV","index":1,"n_rows":35,"n_cols":44,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,0,2,1]]}
["Condition 2.3.17 Calculation of DAV"]
[]
[]
[]
[]
[null,null,null,"£2014",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,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045]
[]
["Annual Capex "]
["Mains",null,null,null,{"$f":"SUM(Inputs!E83,Inputs!E85,Inputs!E94)","v":9163851.6796381921},{"$f":"SUM(Inputs!F83,Inputs!F85,Inputs!F94)","v":11978318.038899688},{"$f":"SUM(Inputs!G83,Inputs!G85,Inputs!G94)","v":9339553.2945472579},{"$f":"SUM(Inputs!H83,Inputs!H85,Inputs!H94)","v":11701933.90685294},{"$f":"SUM(Inputs!I83,Inputs!I85,Inputs!I94)","v":11411316.911880756},{"$f":"SUM(Inputs!J83,Inputs!J85,Inputs!J94)","v":8068448.5974650811},{"$f":"SUM(Inputs!K83,Inputs!K85,Inputs!K94)","v":6362519.7349370094},{"$f":"SUM(Inputs!L83,Inputs!L85,Inputs!L94)","v":5351409.6990729105},{"$f":"SUM(Inputs!M83,Inputs!M85,Inputs!M94)","v":8114852.2532176301},{"$f":"SUM(Inputs!N83,Inputs!N85,Inputs!N94)","v":6433044.3068478424},{"$f":"SUM(Inputs!O83,Inputs!O85,Inputs!O94)","v":5775361.9576727748},{"$f":"SUM(Inputs!P83,Inputs!P85,Inputs!P94)","v":11757513.080006383},{"$f":"SUM(Inputs!Q83,Inputs!Q85,Inputs!Q94)","v":9046212.3897054493},{"$f":"SUM(Inputs!R83,Inputs!R85,Inputs!R94)","v":8911661.742908366},{"$f":"SUM(Inputs!S83,Inputs!S85,Inputs!S94)","v":8898234.853946887},{"$f":"SUM(Inputs!T83,Inputs!T85,Inputs!T94)","v":8977411.2596932538},{"$f":"SUM(Inputs!U83,Inputs!U85,Inputs!U94)","v":9012296.8725269102},{"$f":"SUM(Inputs!V83,Inputs!V85,Inputs!V94)","v":7320907.0622120257},{"$f":"SUM(Inputs!W83,Inputs!W85,Inputs!W94)","v":6482253.9923139447},{"$f":"SUM(Inputs!X83,Inputs!X85,Inputs!X94)","v":6762443.3002239261},{"$f":"SUM(Inputs!Y83,Inputs!Y85,Inputs!Y94)","v":4228461.1003260547},{"$f":"SUM(Inputs!Z83,Inputs!Z85,Inputs!Z94)","v":2058906.6057640414},{"$f":"SUM(Inputs!AA83,Inputs!AA85,Inputs!AA94)","v":2049585.2438961628},{"$f":"SUM(Inputs!AB83,Inputs!AB85,Inputs!AB94)","v":2038803.6858026143},{"$f":"SUM(Inputs!AC83,Inputs!AC85,Inputs!AC94)","v":2029665.8311927118},{"$f":"SUM(Inputs!AD83,Inputs!AD85,Inputs!AD94)","v":2019542.8197864466},{"$f":"SUM(Inputs!AE83,Inputs!AE85,Inputs!AE94)","v":2019106.9517996518},{"$f":"SUM(Inputs!AF83,Inputs!AF85,Inputs!AF94)","v":2008873.0216322506},{"$f":"SUM(Inputs!AG83,Inputs!AG85,Inputs!AG94)","v":2008743.5875681159},{"$f":"SUM(Inputs!AH83,Inputs!AH85,Inputs!AH94)","v":2008303.7542764484},{"$f":"SUM(Inputs!AI83,Inputs!AI85,Inputs!AI94)","v":2008005.5965221364},{"$f":"SUM(Inputs!AJ83,Inputs!AJ85,Inputs!AJ94)","v":1999065.9552651774},{"$f":"SUM(Inputs!AK83,Inputs!AK85,Inputs!AK94)","v":1998103.3613521929},{"$f":"SUM(Inputs!AL83,Inputs!AL85,Inputs!AL94)","v":1997858.973022565},{"$f":"SUM(Inputs!AM83,Inputs!AM85,Inputs!AM94)","v":1997563.8022885374},{"$f":"SUM(Inputs!AN83,Inputs!AN85,Inputs!AN94)","v":1995846.5125606998},{"$f":"SUM(Inputs!AO83,Inputs!AO85,Inputs!AO94)","v":1995260.370237682},{"$f":"SUM(Inputs!AP83,Inputs!AP85,Inputs!AP94)","v":1993404.3352644269},{"$f":"SUM(Inputs!AQ83,Inputs!AQ85,Inputs!AQ94)","v":2000429.0220842301},{"$f":"SUM(Inputs!AR83,Inputs!AR85,Inputs!AR94)","v":1999035.009832965}]
["Services",null,null,null,{"$f":"SUM(Inputs!E86,Inputs!E88,Inputs!E90)","v":387648.09692074714},{"$f":"SUM(Inputs!F86,Inputs!F88,Inputs!F90)","v":694810.81432720169},{"$f":"SUM(Inputs!G86,Inputs!G88,Inputs!G90)","v":1678078.4636649806},{"$f":"SUM(Inputs!H86,Inputs!H88,Inputs!H90)+Inputs!H140","v":-630403.40122518362},{"$f":"SUM(Inputs!I86,Inputs!I88,Inputs!I90)+Inputs!I140","v":-1312640.5968377264},{"$f":"SUM(Inputs!J86,Inputs!J88,Inputs!J90)+Inputs!J140","v":3656705.096449065},{"$f":"SUM(Inputs!K86,Inputs!K88,Inputs!K90)+Inputs!K140","v":7053872.0739982976},{"$f":"SUM(Inputs!L86,Inputs!L88,Inputs!L90)+Inputs!L140","v":4120019.0686176717},{"$f":"SUM(Inputs!M86,Inputs!M88,Inputs!M90)+Inputs!M140","v":-2712649.8425945938},{"$f":"SUM(Inputs!N86,Inputs!N88,Inputs!N90)+Inputs!N140","v":2589751.318880152},{"$f":"SUM(Inputs!O86,Inputs!O88,Inputs!O90)+Inputs!O140","v":4565975.1187559413},{"$f":"SUM(Inputs!P86,Inputs!P88,Inputs!P90)","v":3394410.1433787644},{"$f":"SUM(Inputs!Q86,Inputs!Q88,Inputs!Q90)","v":3658310.3938447013},{"$f":"SUM(Inputs!R86,Inputs!R88,Inputs!R90)","v":3906092.3550880104},{"$f":"SUM(Inputs!S86,Inputs!S88,Inputs!S90)","v":4107181.3544809618},{"$f":"SUM(Inputs!T86,Inputs!T88,Inputs!T90)","v":4294513.2792670727},{"$f":"SUM(Inputs!U86,Inputs!U88,Inputs!U90)","v":4500163.5398525074},{"$f":"SUM(Inputs!V86,Inputs!V88,Inputs!V90)","v":4531498.1778514814},{"$f":"SUM(Inputs!W86,Inputs!W88,Inputs!W90)","v":4550193.1098341392},{"$f":"SUM(Inputs!X86,Inputs!X88,Inputs!X90)","v":4469317.3534799116},{"$f":"SUM(Inputs!Y86,Inputs!Y88,Inputs!Y90)","v":4297306.4268785361},{"$f":"SUM(Inputs!Z86,Inputs!Z88,Inputs!Z90)","v":4095201.2195245889},{"$f":"SUM(Inputs!AA86,Inputs!AA88,Inputs!AA90)","v":3857217.8735014936},{"$f":"SUM(Inputs!AB86,Inputs!AB88,Inputs!AB90)","v":3656252.6010245373},{"$f":"SUM(Inputs!AC86,Inputs!AC88,Inputs!AC90)","v":3465432.7489528041},{"$f":"SUM(Inputs!AD86,Inputs!AD88,Inputs!AD90)","v":3269296.9506875621},{"$f":"SUM(Inputs!AE86,Inputs!AE88,Inputs!AE90)","v":3167104.4121335973},{"$f":"SUM(Inputs!AF86,Inputs!AF88,Inputs!AF90)","v":2972864.7554308902},{"$f":"SUM(Inputs!AG86,Inputs!AG88,Inputs!AG90)","v":2875345.9498725897},{"$f":"SUM(Inputs!AH86,Inputs!AH88,Inputs!AH90)","v":2774293.3461956158},{"$f":"SUM(Inputs!AI86,Inputs!AI88,Inputs!AI90)","v":2680194.3452682896},{"$f":"SUM(Inputs!AJ86,Inputs!AJ88,Inputs!AJ90)","v":2494846.1806061147},{"$f":"SUM(Inputs!AK86,Inputs!AK88,Inputs!AK90)","v":2397897.3424863098},{"$f":"SUM(Inputs!AL86,Inputs!AL88,Inputs!AL90)","v":2305166.2634113729},{"$f":"SUM(Inputs!AM86,Inputs!AM88,Inputs!AM90)","v":2211067.2624840466},{"$f":"SUM(Inputs!AN86,Inputs!AN88,Inputs!AN90)","v":2109600.4325846266},{"$f":"SUM(Inputs!AO86,Inputs!AO88,Inputs!AO90)","v":2016641.3665342918},{"$f":"SUM(Inputs!AP86,Inputs!AP88,Inputs!AP90)","v":1926874.1181395324},{"$f":"SUM(Inputs!AQ86,Inputs!AQ88,Inputs!AQ90)","v":1922770.3525823636},{"$f":"SUM(Inputs!AR86,Inputs!AR88,Inputs!AR90)","v":1831635.1823352145}]
["Meters, PRS, Telemetry",null,null,null,{"$f":"SUM(Inputs!E84,Inputs!E87,Inputs!E89,Inputs!E91,Inputs!E92)","v":485054.13197872031},{"$f":"SUM(Inputs!F84,Inputs!F87,Inputs!F89,Inputs!F91,Inputs!F92)","v":907299.53115880338},{"$f":"SUM(Inputs!G84,Inputs!G87,Inputs!G89,Inputs!G91,Inputs!G92)","v":1923187.4220036054},{"$f":"SUM(Inputs!H84,Inputs!H87,Inputs!H89,Inputs!H91,Inputs!H92)+Inputs!H141","v":984043.88064654276},{"$f":"SUM(Inputs!I84,Inputs!I87,Inputs!I89,Inputs!I91,Inputs!I92)+Inputs!I141","v":1056773.1340342006},{"$f":"SUM(Inputs!J84,Inputs!J87,Inputs!J89,Inputs!J91,Inputs!J92)+Inputs!J141","v":1371365.7238618857},{"$f":"SUM(Inputs!K84,Inputs!K87,Inputs!K89,Inputs!K91,Inputs!K92)+Inputs!K141","v":1490095.8271706537},{"$f":"SUM(Inputs!L84,Inputs!L87,Inputs!L89,Inputs!L91,Inputs!L92)+Inputs!L141","v":1261869.9252227889},{"$f":"SUM(Inputs!M84,Inputs!M87,Inputs!M89,Inputs!M91,Inputs!M92)+Inputs!M141","v":1101163.9497612733},{"$f":"SUM(Inputs!N84,Inputs!N87,Inputs!N89,Inputs!N91,Inputs!N92)+Inputs!N141","v":1203206.3675097858},{"$f":"SUM(Inputs!O84,Inputs!O87,Inputs!O89,Inputs!O91,Inputs!O92)+Inputs!O141","v":1048416.2896116604},{"$f":"SUM(Inputs!P84,Inputs!P87,Inputs!P89,Inputs!P91,Inputs!P92)","v":1139541.7736392173},{"$f":"SUM(Inputs!Q84,Inputs!Q87,Inputs!Q89,Inputs!Q91,Inputs!Q92)","v":1223790.0889081003},{"$f":"SUM(Inputs!R84,Inputs!R87,Inputs!R89,Inputs!R91,Inputs!R92)","v":1282416.8869698681},{"$f":"SUM(Inputs!S84,Inputs!S87,Inputs!S89,Inputs!S91,Inputs!S92)","v":1339757.7679449953},{"$f":"SUM(Inputs!T84,Inputs!T87,Inputs!T89,Inputs!T91,Inputs!T92)","v":1382773.9367305071},{"$f":"SUM(Inputs!U84,Inputs!U87,Inputs!U89,Inputs!U91,Inputs!U92)","v":1454923.1128921211},{"$f":"SUM(Inputs!V84,Inputs!V87,Inputs!V89,Inputs!V91,Inputs!V92)","v":1472920.895980475},{"$f":"SUM(Inputs!W84,Inputs!W87,Inputs!W89,Inputs!W91,Inputs!W92)","v":1508832.0251270256},{"$f":"SUM(Inputs!X84,Inputs!X87,Inputs!X89,Inputs!X91,Inputs!X92)","v":1519246.1732426311},{"$f":"SUM(Inputs!Y84,Inputs!Y87,Inputs!Y89,Inputs!Y91,Inputs!Y92)","v":1654960.4450557549},{"$f":"SUM(Inputs!Z84,Inputs!Z87,Inputs!Z89,Inputs!Z91,Inputs!Z92)","v":1774603.6129525623},{"$f":"SUM(Inputs!AA84,Inputs!AA87,Inputs!AA89,Inputs!AA91,Inputs!AA92)","v":2021980.4610934015},{"$f":"SUM(Inputs!AB84,Inputs!AB87,Inputs!AB89,Inputs!AB91,Inputs!AB92)","v":2322779.5691371313},{"$f":"SUM(Inputs!AC84,Inputs!AC87,Inputs!AC89,Inputs!AC91,Inputs!AC92)","v":2192831.5786696626},{"$f":"SUM(Inputs!AD84,Inputs!AD87,Inputs!AD89,Inputs!AD91,Inputs!AD92)","v":2350372.4447689522},{"$f":"SUM(Inputs!AE84,Inputs!AE87,Inputs!AE89,Inputs!AE91,Inputs!AE92)","v":2528421.4133583941},{"$f":"SUM(Inputs!AF84,Inputs!AF87,Inputs!AF89,Inputs!AF91,Inputs!AF92)","v":2273786.5286184363},{"$f":"SUM(Inputs!AG84,Inputs!AG87,Inputs!AG89,Inputs!AG91,Inputs!AG92)","v":2327269.3852227563},{"$f":"SUM(Inputs!AH84,Inputs!AH87,Inputs!AH89,Inputs!AH91,Inputs!AH92)","v":2176668.7648976492},{"$f":"SUM(Inputs!AI84,Inputs!AI87,Inputs!AI89,Inputs!AI91,Inputs!AI92)","v":2013083.6185449089},{"$f":"SUM(Inputs!AJ84,Inputs!AJ87,Inputs!AJ89,Inputs!AJ91,Inputs!AJ92)","v":2188928.2654169458},{"$f":"SUM(Inputs!AK84,Inputs!AK87,Inputs!AK89,Inputs!AK91,Inputs!AK92)","v":2246588.6767048989},{"$f":"SUM(Inputs!AL84,Inputs!AL87,Inputs!AL89,Inputs!AL91,Inputs!AL92)","v":2280042.9432540885},{"$f":"SUM(Inputs!AM84,Inputs!AM87,Inputs!AM89,Inputs!AM91,Inputs!AM92)","v":2318246.3462398686},{"$f":"SUM(Inputs!AN84,Inputs!AN87,Inputs!AN89,Inputs!AN91,Inputs!AN92)","v":2344110.040325325},{"$f":"SUM(Inputs!AO84,Inputs!AO87,Inputs!AO89,Inputs!AO91,Inputs!AO92)","v":2384048.5028727553},{"$f":"SUM(Inputs!AP84,Inputs!AP87,Inputs!AP89,Inputs!AP91,Inputs!AP92)","v":2307744.8941443483},{"$f":"SUM(Inputs!AQ84,Inputs!AQ87,Inputs!AQ89,Inputs!AQ91,Inputs!AQ92)","v":2332000.9166558119},{"$f":"SUM(Inputs!AR84,Inputs!AR87,Inputs!AR89,Inputs!AR91,Inputs!AR92)","v":2310034.4824124835}]
["Other Capex",null,null,null,{"$f":"Inputs!E93","v":414551.89245087898},{"$f":"Inputs!F93","v":72300.806618407441},{"$f":"Inputs!G93","v":794208.89348500513},{"$f":"Inputs!H93+Inputs!H142","v":58886.83448095675},{"$f":"Inputs!I93+Inputs!I142","v":58297.966136147181},{"$f":"Inputs!J93+Inputs!J142","v":-158656.34836370684},{"$f":"Inputs!K93+Inputs!K142","v":57137.836610037855},{"$f":"Inputs!L93+Inputs!L142","v":56566.458243937479},{"$f":"Inputs!M93+Inputs!M142","v":123812.43035786369},{"$f":"Inputs!N93+Inputs!N142","v":23205.603625875567},{"$f":"Inputs!O93+Inputs!O142","v":22150.803461063038},{"$f":"Inputs!P93","v":578567.43176510651},{"$f":"Inputs!Q93","v":126785.73621678636},{"$f":"Inputs!R93","v":124557.90765920668},{"$f":"Inputs!S93","v":123743.83730304753},{"$f":"Inputs!T93","v":113636.78954164691},{"$f":"Inputs!U93","v":112894.09609509307},{"$f":"Inputs!V93","v":167612.86812603404},{"$f":"Inputs!W93","v":117904.13026195636},{"$f":"Inputs!X93","v":117904.13026195636},{"$f":"Inputs!Y93","v":117904.13026195636},{"$f":"Inputs!Z93","v":117904.13026195636},{"$f":"Inputs!AA93","v":117904.13026195636},{"$f":"Inputs!AB93","v":167612.86812603404},{"$f":"Inputs!AC93","v":117904.13026195636},{"$f":"Inputs!AD93","v":117904.13026195636},{"$f":"Inputs!AE93","v":117904.13026195636},{"$f":"Inputs!AF93","v":117904.13026195636},{"$f":"Inputs!AG93","v":117904.13026195636},{"$f":"Inputs!AH93","v":167612.86812603404},{"$f":"Inputs!AI93","v":117904.13026195636},{"$f":"Inputs!AJ93","v":117904.13026195636},{"$f":"Inputs!AK93","v":117904.13026195636},{"$f":"Inputs!AL93","v":117904.13026195636},{"$f":"Inputs!AM93","v":117904.13026195636},{"$f":"Inputs!AN93","v":167612.86812603404},{"$f":"Inputs!AO93","v":117904.13026195636},{"$f":"Inputs!AP93","v":117904.13026195636},{"$f":"Inputs!AQ93","v":117904.13026195636},{"$f":"Inputs!AR93","v":117904.13026195636}]
["Capitalised Under-recoveries",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Inputs!B127=Inputs!B128,Inputs!O127,IF(Inputs!B127=Inputs!B129,Inputs!O127,0))","v":0}]
["Total capex",null,null,null,{"$f":"SUM(E9:E13)","v":10451105.800988538},{"$f":"SUM(F9:F13)","v":13652729.191004099},13735028.073700849,{"$f":"SUM(H9:H13)","v":12114461.220755257},11213747.415213376,12937863.069412325,14963625.472715998,10789865.15115731,6627178.7907421738,10249207.596863655,11411904.169501439,{"$f":"SUM(P9:P13)","v":16870032.42878947},{"$f":"SUM(Q9:Q13)","v":14055098.608675038},{"$f":"SUM(R9:R13)","v":14224728.892625451},14468917.813675892,14768335.265232481,15080277.621366631,13492939.004170017,12659183.257537065,12868910.957208425,10298632.102522302,8046615.5685031489,8046687.7087530149,8185448.7240903163,7805834.2890771348,7757116.3455049181,7832536.9075536001,7373428.4359435337,7329263.0529254191,7126878.7334957477,6819187.690597292,6800744.5315501941,6760493.5108053582,6700972.3099499838,6644781.5412744088,6617169.8535966855,6513854.3699066853,6345927.4778102646,6373104.4215843631,6258608.8048426202]
["Check",null,null,null,{"$f":"ROUND(DAV!E14,0)=ROUND(SUM(Inputs!E83:E94),0)","v":true},{"$f":"ROUND(DAV!F14,0)=ROUND(SUM(Inputs!F83:F94),0)","v":true},{"$f":"ROUND(DAV!G14,0)=ROUND(SUM(Inputs!G83:G94),0)","v":true},{"$f":"ROUND(DAV!H14,0)=ROUND(SUM(Inputs!H83:H94)+SUM(Inputs!H140:H142),0)","v":true},{"$f":"ROUND(DAV!I14,0)=ROUND(SUM(Inputs!I83:I94)+SUM(Inputs!I140:I142),0)","v":true},{"$f":"ROUND(DAV!J14,0)=ROUND(SUM(Inputs!J83:J94)+SUM(Inputs!J140:J142),0)","v":true},{"$f":"ROUND(DAV!K14,0)=ROUND(SUM(Inputs!K83:K94)+SUM(Inputs!K140:K142),0)","v":true},{"$f":"ROUND(DAV!L14,0)=ROUND(SUM(Inputs!L83:L94)+SUM(Inputs!L140:L142),0)","v":true},{"$f":"ROUND(DAV!M14,0)=ROUND(SUM(Inputs!M83:M94)+SUM(Inputs!M140:M142),0)","v":true},{"$f":"ROUND(DAV!N14,0)=ROUND(SUM(Inputs!N83:N94)+SUM(Inputs!N140:N142),0)","v":true},{"$f":"ROUND(DAV!O14,0)=ROUND(SUM(Inputs!O83:O94)+SUM(Inputs!O140:O142),0)","v":true},{"$f":"ROUND(DAV!P14,0)=ROUND(SUM(Inputs!P83:P94)+Inputs!O127,0)","v":true},{"$f":"ROUND(DAV!Q14,0)=ROUND(SUM(Inputs!Q83:Q94),0)","v":true},{"$f":"ROUND(DAV!R14,0)=ROUND(SUM(Inputs!R83:R94),0)","v":true},{"$f":"ROUND(DAV!S14,0)=ROUND(SUM(Inputs!S83:S94),0)","v":true},{"$f":"ROUND(DAV!T14,0)=ROUND(SUM(Inputs!T83:T94),0)","v":true},{"$f":"ROUND(DAV!U14,0)=ROUND(SUM(Inputs!U83:U94),0)","v":true},{"$f":"ROUND(DAV!V14,0)=ROUND(SUM(Inputs!V83:V94),0)","v":true},{"$f":"ROUND(DAV!W14,0)=ROUND(SUM(Inputs!W83:W94),0)","v":true},{"$f":"ROUND(DAV!X14,0)=ROUND(SUM(Inputs!X83:X94),0)","v":true},{"$f":"ROUND(DAV!Y14,0)=ROUND(SUM(Inputs!Y83:Y94),0)","v":true},{"$f":"ROUND(DAV!Z14,0)=ROUND(SUM(Inputs!Z83:Z94),0)","v":true},{"$f":"ROUND(DAV!AA14,0)=ROUND(SUM(Inputs!AA83:AA94),0)","v":true},{"$f":"ROUND(DAV!AB14,0)=ROUND(SUM(Inputs!AB83:AB94),0)","v":true},{"$f":"ROUND(DAV!AC14,0)=ROUND(SUM(Inputs!AC83:AC94),0)","v":true},{"$f":"ROUND(DAV!AD14,0)=ROUND(SUM(Inputs!AD83:AD94),0)","v":true},{"$f":"ROUND(DAV!AE14,0)=ROUND(SUM(Inputs!AE83:AE94),0)","v":true},{"$f":"ROUND(DAV!AF14,0)=ROUND(SUM(Inputs!AF83:AF94),0)","v":true},{"$f":"ROUND(DAV!AG14,0)=ROUND(SUM(Inputs!AG83:AG94),0)","v":true},{"$f":"ROUND(DAV!AH14,0)=ROUND(SUM(Inputs!AH83:AH94),0)","v":true},{"$f":"ROUND(DAV!AI14,0)=ROUND(SUM(Inputs!AI83:AI94),0)","v":true},{"$f":"ROUND(DAV!AJ14,0)=ROUND(SUM(Inputs!AJ83:AJ94),0)","v":true},{"$f":"ROUND(DAV!AK14,0)=ROUND(SUM(Inputs!AK83:AK94),0)","v":true},{"$f":"ROUND(DAV!AL14,0)=ROUND(SUM(Inputs!AL83:AL94),0)","v":true},{"$f":"ROUND(DAV!AM14,0)=ROUND(SUM(Inputs!AM83:AM94),0)","v":true},{"$f":"ROUND(DAV!AN14,0)=ROUND(SUM(Inputs!AN83:AN94),0)","v":true},{"$f":"ROUND(DAV!AO14,0)=ROUND(SUM(Inputs!AO83:AO94),0)","v":true},{"$f":"ROUND(DAV!AP14,0)=ROUND(SUM(Inputs!AP83:AP94),0)","v":true},{"$f":"ROUND(DAV!AQ14,0)=ROUND(SUM(Inputs!AQ83:AQ94),0)","v":true},{"$f":"ROUND(DAV!AR14,0)=ROUND(SUM(Inputs!AR83:AR94),0)","v":true}]
[]
[]
["Opening DAV (Capex Only)",null,"Mains",{"$f":"Inputs!D132","v":1845762.7935014917}]
[null,null,"Other Capex",{"$f":"Inputs!D133","v":449375.3050672182}]
[null,null,null,{"$f":"SUM(D17:D19)","v":2295138.09856871}]
[]
["Depreciation",null,"Useful Life"]
["Opening DAV",null,40,null,{"$f":"(($D$18+$D$19)/$C$23)","v":57378.452464217749},{"$f":"(($D$18+$D$19)/$C$23)","v":57378.452464217749},{"$f":"(($D$18+$D$19)/$C$23)","v":57378.452464217749},57378.452464217749,57378.452464217749,57378.452464217749,57378.452464217749,57378.452464217749,57378.452464217749,57378.452464217749,57378.452464217749,57378.452464217749,57378.452464217749,57378.452464217749,57378.452464217749,57378.452464217749,57378.452464217749,57378.452464217749,57378.452464217749,57378.452464217749,57378.452464217749,57378.452464217749,57378.452464217749,57378.452464217749,57378.452464217749,57378.452464217749,57378.452464217749,57378.452464217749,57378.452464217749,57378.452464217749,57378.452464217749,57378.452464217749,57378.452464217749,57378.452464217749,57378.452464217749,57378.452464217749,57378.452464217749,57378.452464217749,57378.452464217749,57378.452464217749]
["Mains",null,40,null,{"$f":"(SUM($D$9:E9)/$C$24)","v":229096.29199095481},{"$f":"(SUM($D$9:F9)/$C$24)","v":528554.242963447},{"$f":"(SUM($D$9:G9)/$C$24)","v":762043.07532712852},{"$f":"(SUM($D$9:H9)/$C$24)","v":1054591.4229984521},{"$f":"(SUM($D$9:I9)/$C$24)","v":1339874.3457954708},{"$f":"(SUM($D$9:J9)/$C$24)","v":1541585.5607320978},{"$f":"(SUM($D$9:K9)/$C$24)","v":1700648.5541055233},{"$f":"(SUM($D$9:L9)/$C$24)","v":1834433.7965823461},{"$f":"(SUM($D$9:M9)/$C$24)","v":2037305.1029127866},{"$f":"(SUM($D$9:N9)/$C$24)","v":2198131.2105839825},{"$f":"(SUM($D$9:O9)/$C$24)","v":2342515.259525802},{"$f":"(SUM($D$9:P9)/$C$24)","v":2636453.0865259618},{"$f":"(SUM($D$9:Q9)/$C$24)","v":2862608.3962685978},{"$f":"(SUM($D$9:R9)/$C$24)","v":3085399.9398413068},{"$f":"(SUM($D$9:S9)/$C$24)","v":3307855.8111899793},{"$f":"(SUM($D$9:T9)/$C$24)","v":3532291.0926823108},{"$f":"(SUM($D$9:U9)/$C$24)","v":3757598.5144954836},{"$f":"(SUM($D$9:V9)/$C$24)","v":3940621.1910507842},{"$f":"(SUM($D$9:W9)/$C$24)","v":4102677.5408586329},{"$f":"(SUM($D$9:X9)/$C$24)","v":4271738.6233642306},{"$f":"(SUM($D$9:Y9)/$C$24)","v":4377450.1508723823},{"$f":"(SUM($D$9:Z9)/$C$24)","v":4428922.8160164831},{"$f":"(SUM($D$9:AA9)/$C$24)","v":4480162.4471138874},{"$f":"(SUM($D$9:AB9)/$C$24)","v":4531132.5392589523},{"$f":"(SUM($D$9:AC9)/$C$24)","v":4581874.1850387696},{"$f":"(SUM($D$9:AD9)/$C$24)","v":4632362.7555334317},{"$f":"(SUM($D$9:AE9)/$C$24)","v":4682840.429328423},{"$f":"(SUM($D$9:AF9)/$C$24)","v":4733062.2548692292},{"$f":"(SUM($D$9:AG9)/$C$24)","v":4783280.8445584318},{"$f":"(SUM($D$9:AH9)/$C$24)","v":4833488.4384153429},{"$f":"(SUM($D$9:AI9)/$C$24)","v":4883688.5783283962},{"$f":"(SUM($D$9:AJ9)/$C$24)","v":4933665.2272100253},{"$f":"(SUM($D$9:AK9)/$C$24)","v":4983617.8112438302},{"$f":"(SUM($D$9:AL9)/$C$24)","v":5033564.285569394},{"$f":"(SUM($D$9:AM9)/$C$24)","v":5083503.3806266077},{"$f":"(SUM($D$9:AN9)/$C$24)","v":5133399.5434406251},{"$f":"(SUM($D$9:AO9)/$C$24)","v":5183281.052696567},{"$f":"(SUM($D$9:AP9)/$C$24)","v":5233116.1610781774},{"$f":"(SUM($D$9:AQ9)/$C$24)","v":5283126.8866302837},{"$f":"(SUM($D$9:AR9)/$C$24)","v":5333102.7618761081}]
["Services",null,40,null,{"$f":"SUM($D$10:E10)/$C$25","v":9691.202423018678},{"$f":"SUM($D$10:F10)/$C$25","v":27061.472781198721},{"$f":"SUM($D$10:G10)/$C$25","v":69013.434372823249},{"$f":"SUM($D$10:H10)/$C$25","v":53253.349342193651},{"$f":"SUM($D$10:I10)/$C$25","v":20437.334421250493},{"$f":"SUM($D$10:J10)/$C$25","v":111854.9618324771},{"$f":"SUM($D$10:K10)/$C$25","v":288201.76368243451},{"$f":"SUM($D$10:L10)/$C$25","v":391202.2403978763},{"$f":"SUM($D$10:M10)/$C$25","v":323385.99433301145},{"$f":"SUM($D$10:N10)/$C$25","v":388129.77730501525},{"$f":"SUM($D$10:O10)/$C$25","v":502279.15527391376},{"$f":"SUM($D$10:P10)/$C$25","v":587139.40885838284},{"$f":"SUM($D$10:Q10)/$C$25","v":678597.16870450042},{"$f":"SUM($D$10:R10)/$C$25","v":776249.47758170066},{"$f":"SUM($D$10:S10)/$C$25","v":878929.01144372462},{"$f":"SUM($D$10:T10)/$C$25","v":986291.84342540149},{"$f":"SUM($D$10:U10)/$C$25","v":1098795.9319217142},{"$f":"SUM($D$10:V10)/$C$25","v":1212083.3863680013},{"$f":"SUM($D$10:W10)/$C$25","v":1325838.2141138548},{"$f":"SUM($D$10:X10)/$C$25","v":1437571.1479508528},{"$f":"SUM($D$10:Y10)/$C$25","v":1545003.8086228161},{"$f":"SUM($D$10:Z10)/$C$25","v":1647383.8391109309},{"$f":"SUM($D$10:AA10)/$C$25","v":1743814.2859484679},{"$f":"SUM($D$10:AB10)/$C$25","v":1835220.6009740815},{"$f":"SUM($D$10:AC10)/$C$25","v":1921856.4196979017},{"$f":"SUM($D$10:AD10)/$C$25","v":2003588.8434650905},{"$f":"SUM($D$10:AE10)/$C$25","v":2082766.4537684307},{"$f":"SUM($D$10:AF10)/$C$25","v":2157088.072654203},{"$f":"SUM($D$10:AG10)/$C$25","v":2228971.7214010176},{"$f":"SUM($D$10:AH10)/$C$25","v":2298329.0550559079},{"$f":"SUM($D$10:AI10)/$C$25","v":2365333.9136876157},{"$f":"SUM($D$10:AJ10)/$C$25","v":2427705.0682027685},{"$f":"SUM($D$10:AK10)/$C$25","v":2487652.5017649261},{"$f":"SUM($D$10:AL10)/$C$25","v":2545281.6583502102},{"$f":"SUM($D$10:AM10)/$C$25","v":2600558.3399123112},{"$f":"SUM($D$10:AN10)/$C$25","v":2653298.3507269272},{"$f":"SUM($D$10:AO10)/$C$25","v":2703714.3848902844},{"$f":"SUM($D$10:AP10)/$C$25","v":2751886.2378437729},{"$f":"SUM($D$10:AQ10)/$C$25","v":2799955.4966583317},{"$f":"SUM($D$10:AR10)/$C$25","v":2845746.3762167124}]
["Meters, PRS, Telemetry",null,15,null,{"$f":"SUM($E$11:E11)/$C$26","v":32336.942131914686},{"$f":"SUM($E$11:F11)/$C$26","v":92823.577542501574},{"$f":"SUM($E$11:G11)/$C$26","v":221036.07234274191},{"$f":"SUM($E$11:H11)/$C$26","v":286638.99771917809},{"$f":"SUM($E$11:I11)/$C$26","v":357090.5399881248},{"$f":"SUM($E$11:J11)/$C$26","v":448514.92157891713},{"$f":"SUM($E$11:K11)/$C$26","v":547854.64339029405},{"$f":"SUM($E$11:L11)/$C$26","v":631979.3050718134},{"$f":"SUM($E$11:M11)/$C$26","v":705390.2350558982},{"$f":"SUM($E$11:N11)/$C$26","v":785603.99288988404},{"$f":"SUM($E$11:O11)/$C$26","v":855498.41219732794},{"$f":"SUM($E$11:P11)/$C$26","v":931467.86377327575},{"$f":"SUM($E$11:Q11)/$C$26","v":1013053.8697004825},{"$f":"SUM($E$11:R11)/$C$26","v":1098548.328831807},{"$f":"SUM(E11:S11)/$C$26","v":1187865.5133614733},1247713.5003449258,1284221.739127147,1254203.9707256048,1289189.8470243039,1320021.3829715329,1338927.6977177907,1357894.8834365846,1408568.919161292,1490009.9604530158,1555984.9745303406,1642782.0515408267,1735374.0275221053,1805373.7901694612,1875030.6233863204,1930824.6898498305,{"$f":"SUM(U11:AI11)/$C$26","v":1972845.335304124},{"$f":"SUM(V11:AJ11)/$C$26","v":2021779.0121391125},{"$f":"SUM(W11:AK11)/$C$26","v":2073356.8641874075},{"$f":"SUM(X11:AL11)/$C$26","v":2124770.925395878},{"$f":"SUM(Y11:AM11)/$C$26","v":2178037.6035956941},{"$f":"SUM(Z11:AN11)/$C$26","v":2223980.9099469986},{"$f":"SUM(AA11:AO11)/$C$26","v":2264610.5692750118},{"$f":"SUM(AB11:AP11)/$C$26","v":2283661.5314784078},{"$f":"SUM(AC11:AQ11)/$C$26","v":2284276.2879796531},{"$f":"SUM(AD11:AR11)/$C$26","v":2292089.8148958413}]
["Other Capex",null,5,null,{"$f":"SUM($E$12:E12)/$C$27","v":82910.37849017579},{"$f":"SUM($E$12:F12)/$C$27","v":97370.539813857278},{"$f":"SUM($E$12:G12)/$C$27","v":256212.31851085828},{"$f":"SUM($E$12:H12)/$C$27","v":267989.6854070496},{"$f":"SUM(E12:I12)/$C$27","v":279649.27863427909},165007.63047136195,161975.036469688,14446.549421474483,27431.66859685587,20413.196094801551,56574.626459755527,160860.54549076926,174904.40108533902,175053.49654560763,195161.14328104202,213458.34049715879,120323.67336315611,128489.09974500565,127158.34426555558,125990.40285733735,126843.87100139924,127845.87783477191,117904.13026195636,127845.87783477191,127845.87783477191,127845.87783477191,127845.87783477191,127845.87783477191,117904.13026195636,127845.87783477191,{"$f":"SUM(AE12:AI12)/$C$27","v":127845.87783477191},{"$f":"SUM(AF12:AJ12)/$C$27","v":127845.87783477191},{"$f":"SUM(AG12:AK12)/$C$27","v":127845.87783477191},{"$f":"SUM(AH12:AL12)/$C$27","v":127845.87783477191},{"$f":"SUM(AI12:AM12)/$C$27","v":117904.13026195636},{"$f":"SUM(AJ12:AN12)/$C$27","v":127845.87783477191},{"$f":"SUM(AK12:AO12)/$C$27","v":127845.87783477191},{"$f":"SUM(AL12:AP12)/$C$27","v":127845.87783477191},{"$f":"SUM(AM12:AQ12)/$C$27","v":127845.87783477191},{"$f":"SUM(AN12:AR12)/$C$27","v":127845.87783477191}]
["Capitalised Under-recoveries",null,{"$f":"IF(D28=D29,19,29)","v":19},"30 yr Rec Period",null,null,null,null,null,null,null,null,null,null,null,{"$f":"P13/C28","v":0},{"$f":"P28","v":0},{"$f":"Q28","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(D28=D29,0,AH28)","v":0},{"$f":"IF(E28=E29,0,AI28)","v":0},{"$f":"IF(F28=F29,0,AJ28)","v":0},0,0,0,0,0,0,0]
["Total depreciation",null,null,"30 yr Rec Period",{"$f":"SUM(E23:E28)","v":411413.26750028168},{"$f":"SUM(F23:F28)","v":803188.28556522238},1365683.3530177698,1719851.9079310913,2054429.9513033428,2324341.5270790714,2756058.450112158,2929440.3439377281,3150891.4533627699,3449656.6293379012,3814245.9059210173,{"$f":"SUM(P23:P28)","v":4373299.3571126079},4786542.2882231381,5192629.6952646393,5627189.9317404367,6037133.2294140141,6318318.3113717185,6592776.1003536135,6902242.3987265648,7212700.00960817,7445603.9806786049,7619425.8688629875,7807828.2349498207,8041587.4309850391,8244939.909566001,8463957.9808383379,8686205.240917949,8880748.4479918834,9062565.7720719427,9247866.5136200711,{"$f":"SUM(AI23:AI28)","v":9407092.1576191261},{"$f":"SUM(AJ23:AJ28)","v":9568373.6378508955},{"$f":"SUM(AK23:AK28)","v":9729851.5074951537},{"$f":"SUM(AL23:AL28)","v":9888841.1996144727},{"$f":"SUM(AM23:AM28)","v":10037381.906860786},{"$f":"SUM(AN23:AN28)","v":10195903.13441354},{"$f":"SUM(AO23:AO28)","v":10336830.337160854},{"$f":"SUM(AP23:AP28)","v":10453888.260699349},{"$f":"SUM(AQ23:AQ28)","v":10552583.001567258},{"$f":"SUM(AR23:AR28)","v":10656163.283287652}]
[null,null,null,"40 yr Rec Period"]
["DAV"]
["Opening balance",null,null,null,{"$f":"D35","v":2295138.09856871},{"$f":"E35","v":12334830.632056966},25184371.53749584,37553716.25817892,47948325.571003087,57107643.034913123,67721164.577246368,79928731.599850208,87789156.407069787,91265443.744449198,98064994.711974949,{"$f":"O35","v":105662652.97555538},118159386.04723224,127427942.36768414,136460041.56504494,145301769.44698039,154032971.48279884,162794930.79279375,169695093.69661015,175452034.55542067,181108245.50302091,183961273.62486461,184388463.32450476,184627322.79830796,184771184.09141323,184332078.47092435,183625236.83559093,182771568.50222659,181264248.49017826,179530945.77103174,{"$f":"AH35","v":177409957.9909074},{"$f":"AI35","v":174822053.52388558},{"$f":"AJ35","v":172054424.4175849},{"$f":"AK35","v":169085066.4208951},{"$f":"AL35","v":165897197.53123063},{"$f":"AM35","v":162504597.16564423},{"$f":"AN35","v":158925863.88482738},{"$f":"AO35","v":155102887.91757321},{"$f":"AP35","v":150994927.13468412},{"$f":"AQ35","v":146815448.55470124}]
["Capex",null,null,null,{"$f":"E14","v":10451105.800988538},{"$f":"F14","v":13652729.191004099},{"$f":"G14","v":13735028.073700849},12114461.220755257,11213747.415213376,12937863.069412325,14963625.472715998,{"$f":"L14","v":10789865.15115731},6627178.7907421738,10249207.596863655,11411904.169501439,{"$f":"P14","v":16870032.42878947},14055098.608675038,14224728.892625451,14468917.813675892,14768335.265232481,15080277.621366631,13492939.004170017,12659183.257537065,12868910.957208425,10298632.102522302,8046615.5685031489,8046687.7087530149,8185448.7240903163,7805834.2890771348,7757116.3455049181,7832536.9075536001,7373428.4359435337,7329263.0529254191,7126878.7334957477,{"$f":"AI14","v":6819187.690597292},6800744.5315501941,6760493.5108053582,6700972.3099499838,6644781.5412744088,6617169.8535966855,6513854.3699066853,6345927.4778102646,6373104.4215843631,{"$f":"AR14","v":6258608.8048426202}]
["Depreciation",null,null,null,{"$f":"-E29","v":-411413.26750028168},{"$f":"-F29","v":-803188.28556522238},{"$f":"-G29","v":-1365683.3530177698},-1719851.9079310913,-2054429.9513033428,-2324341.5270790714,-2756058.450112158,{"$f":"-L29","v":-2929440.3439377281},{"$f":"-M29","v":-3150891.4533627699},-3449656.6293379012,-3814245.9059210173,{"$f":"-P29","v":-4373299.3571126079},-4786542.2882231381,-5192629.6952646393,-5627189.9317404367,-6037133.2294140141,-6318318.3113717185,-6592776.1003536135,-6902242.3987265648,-7212700.00960817,-7445603.9806786049,-7619425.8688629875,-7807828.2349498207,-8041587.4309850391,-8244939.909566001,-8463957.9808383379,-8686205.240917949,-8880748.4479918834,-9062565.7720719427,-9247866.5136200711,{"$f":"-AI29","v":-9407092.1576191261},-9568373.6378508955,-9729851.5074951537,-9888841.1996144727,-10037381.906860786,-10195903.13441354,-10336830.337160854,-10453888.260699349,-10552583.001567258,{"$f":"-AR29","v":-10656163.283287652}]
["Closing balance",null,null,{"$f":"D20","v":2295138.09856871},{"$f":"SUM(E32:E34)","v":12334830.632056966},{"$f":"SUM(F32:F34)","v":25184371.53749584},37553716.25817892,47948325.571003087,57107643.034913123,67721164.577246368,79928731.599850208,87789156.407069787,91265443.744449198,98064994.711974949,105662652.97555538,{"$f":"SUM(P32:P34)","v":118159386.04723224},127427942.36768414,136460041.56504494,145301769.44698039,154032971.48279884,162794930.79279375,169695093.69661015,175452034.55542067,181108245.50302091,183961273.62486461,184388463.32450476,184627322.79830796,184771184.09141323,184332078.47092435,183625236.83559093,182771568.50222659,181264248.49017826,179530945.77103174,177409957.9909074,{"$f":"SUM(AI32:AI34)","v":174822053.52388558},172054424.4175849,169085066.4208951,165897197.53123063,162504597.16564423,158925863.88482738,155102887.91757321,150994927.13468412,146815448.55470124,{"$f":"SUM(AR32:AR34)","v":142417894.07625622}]

{"sheet":"GD17 Pi's Calc - 30 yrs","index":2,"n_rows":83,"n_cols":32,"rows_kept":83,"cut":false,"hidden":true,"merged":[[52,0,52,21],[54,0,54,21],[60,0,60,21],[1,0,1,2],[1,3,1,4],[30,0,30,21],[38,0,38,21],[42,0,42,21],[46,0,46,21]]}
[{"$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,"GD17",{"$f":"4.3%","v":4.2999999999999997E-2},null,null,null,{"$f":"IF(DAV!D28=DAV!D30,\"ADJUST DAV RECOVERY PERIOD FOR U/Rs IN DAV TAB CELL D28\",\"\")","v":""}]
[null,"£2014",null,"Post GD17",{"$f":"E3","v":4.2999999999999997E-2}]
[null,"£'000"]
["Real Return pa",null,null,{"$f":"E3","v":4.2999999999999997E-2},{"$f":"D6","v":4.2999999999999997E-2},{"$f":"E6","v":4.2999999999999997E-2},{"$f":"F6","v":4.2999999999999997E-2},{"$f":"G6","v":4.2999999999999997E-2},{"$f":"H6","v":4.2999999999999997E-2},{"$f":"E4","v":4.2999999999999997E-2},{"$f":"J6","v":4.2999999999999997E-2},{"$f":"K6","v":4.2999999999999997E-2},4.2999999999999997E-2,4.2999999999999997E-2,4.2999999999999997E-2,4.2999999999999997E-2,4.2999999999999997E-2,4.2999999999999997E-2,4.2999999999999997E-2,4.2999999999999997E-2,4.2999999999999997E-2,4.2999999999999997E-2]
["Discount Factor (Mid Yr)",0.5,1,{"$f":"D8*(1+D6*$B$7)","v":0.97938638542665402},{"$f":"E8*(1+E6*$B$7)","v":0.93900899849151875},0.90029625933990298,0.86317953915618695,0.82759303850065868,0.79347367066218488,0.76076094981992792,0.72939688381584666,0.69932587134788748,0.67049460340161793,0.64285196874555894,0.61634896332268363,0.59093860337745319,0.56657584216438472,0.54321749009049347,0.52082213815004164,0.49935008451585972,0.4787632641571043,0.45902518135868109]
["Discount Factor (Yr End)",null,1,{"$f":"C8/(1+D6)","v":0.95877277085330781},0.91924522612972948,0.88134729255007627,0.84501178576229752,0.81017429123901974,0.7767730500853498,0.74474884955450604,{"$f":"J8/(1+K6)","v":0.71404491807718706},0.68460682461858779,0.65638238218464795,0.62932155530646983,0.60337637133889732,0.57850083541600894,0.55465084891276029,0.53178413126822655,0.50986014503185673,0.48884002399986265,0.46868650431434583,0.44936385840301618]
[]
[]
[]
[null,null,2016,2017,{"$f":"D12+1","v":2018},2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035]
[]
["Capex",null,null,{"$f":"Inputs!P102/1000","v":16870.032428789473},{"$f":"Inputs!Q102/1000","v":14055.09860867504},{"$f":"Inputs!R102/1000","v":14224.728892625451},{"$f":"Inputs!S102/1000","v":14468.917813675891},{"$f":"Inputs!T102/1000","v":14768.335265232481},{"$f":"Inputs!U102/1000","v":15080.277621366629},{"$f":"Inputs!V102/1000","v":13492.939004170017},{"$f":"Inputs!W102/1000","v":12659.183257537063},{"$f":"Inputs!X102/1000","v":12868.910957208425},{"$f":"Inputs!Y102/1000","v":10298.632102522301},{"$f":"Inputs!Z102/1000","v":8046.6155685031499},{"$f":"Inputs!AA102/1000","v":8046.6877087530138},{"$f":"Inputs!AB102/1000","v":8185.4487240903163},{"$f":"Inputs!AC102/1000","v":7805.8342890771346},{"$f":"Inputs!AD102/1000","v":7757.1163455049173},{"$f":"Inputs!AE102/1000","v":7832.5369075536},{"$f":"Inputs!AF102/1000","v":7373.4284359435342},{"$f":"Inputs!AG102/1000","v":7329.2630529254202},{"$f":"Inputs!AH102/1000","v":7126.8787334957469}]
["Opex","GD14",null,{"$f":"Inputs!P105/1000","v":6400.4283486982604},{"$f":"Inputs!Q105/1000","v":6354.3911259654342},{"$f":"Inputs!R105/1000","v":6494.1518707070991},{"$f":"Inputs!S105/1000","v":6689.5099097442662},{"$f":"Inputs!T105/1000","v":6941.0773949377399},{"$f":"Inputs!U105/1000","v":7254.7695690012206},{"$f":"Inputs!V105/1000","v":7441.89053964299},{"$f":"Inputs!W105/1000","v":7540.8780146904301},{"$f":"Inputs!X105/1000","v":7627.5204273558757},{"$f":"Inputs!Y105/1000","v":7719.34827127277},{"$f":"Inputs!Z105/1000","v":7881.1328683718757},{"$f":"Inputs!AA105/1000","v":8083.6747675785628},{"$f":"Inputs!AB105/1000","v":8198.0207518430725},{"$f":"Inputs!AC105/1000","v":8298.3394623038821},{"$f":"Inputs!AD105/1000","v":8363.8735333608656},{"$f":"Inputs!AE105/1000","v":8303.5039426606818},{"$f":"Inputs!AF105/1000","v":8213.5566652514462},{"$f":"Inputs!AG105/1000","v":8200.5603915330939},{"$f":"Inputs!AH105/1000","v":8319.4712847529572}]
["Volumes (therms '000)",0.44844183597538856,2012,{"$f":"SUM(D17:D22)","v":61955.046268008868},{"$f":"SUM(E17:E22)","v":60366.093171438581},62486.886114643581,64708.29590555522,67016.828425925065,69414.947045184847,71310.524339677329,73118.53570680377,74633.172118661372,76307.90978652396,77594.467105293748,78960.369092722278,79955.157462161413,81039.987505961821,81771.720744421342,82618.064732117156,83142.94701601415,83787.168831044604,84139.231072019771]
["V Dom/Very Small IC Tariff (<2,500 tpa) (P1)",{"$f":"B16/Inputs!K2*Inputs!M2","v":0.4730165224956715},2014,{"$f":"Inputs!P109/1000","v":11203.323378270079},{"$f":"Inputs!Q109/1000","v":12702.360989018294},{"$f":"Inputs!R109/1000","v":14326.699280580207},{"$f":"Inputs!S109/1000","v":16062.487011711972},{"$f":"Inputs!T109/1000","v":17896.063057793053},{"$f":"Inputs!U109/1000","v":19829.726038751334},{"$f":"Inputs!V109/1000","v":21643.454427329722},{"$f":"Inputs!W109/1000","v":23401.323326366757},{"$f":"Inputs!X109/1000","v":25082.557014303595},{"$f":"Inputs!Y109/1000","v":26700.948441771292},{"$f":"Inputs!Z109/1000","v":28185.555038309969},{"$f":"Inputs!AA109/1000","v":29584.49058304854},{"$f":"Inputs!AB109/1000","v":30853.598726006152},{"$f":"Inputs!AC109/1000","v":32043.121867083708},{"$f":"Inputs!AD109/1000","v":33109.612665686524},{"$f":"Inputs!AE109/1000","v":34118.163822969582},{"$f":"Inputs!AF109/1000","v":35025.604106243147},{"$f":"Inputs!AG109/1000","v":35878.257766668394},{"$f":"Inputs!AH109/1000","v":36650.593783935918}]
["V Small/Med Tariff IC (2,500 - 25k tpa) (P2)",null,null,{"$f":"Inputs!P110/1000","v":8335.6773474708953},{"$f":"Inputs!Q110/1000","v":8849.5105040420258},{"$f":"Inputs!R110/1000","v":9352.2780105153415},{"$f":"Inputs!S110/1000","v":9844.1497965771505},{"$f":"Inputs!T110/1000","v":10325.293499885023},{"$f":"Inputs!U110/1000","v":10795.874494915435},{"$f":"Inputs!V110/1000","v":11215.022066147061},{"$f":"Inputs!W110/1000","v":11602.463199554017},{"$f":"Inputs!X110/1000","v":11773.164588792324},{"$f":"Inputs!Y110/1000","v":12166.809494504767},{"$f":"Inputs!Z110/1000","v":12306.058882053425},{"$f":"Inputs!AA110/1000","v":12610.323990060942},{"$f":"Inputs!AB110/1000","v":12673.302881860003},{"$f":"Inputs!AC110/1000","v":12905.908449900408},{"$f":"Inputs!AD110/1000","v":12908.449555074667},{"$f":"Inputs!AE110/1000","v":13083.541050804961},{"$f":"Inputs!AF110/1000","v":13038.281716745947},{"$f":"Inputs!AG110/1000","v":13167.148536668703},{"$f":"Inputs!AH110/1000","v":13084.173425693898}]
["V Large Tariff IC (25k - 75k tpa) (P3)",null,null,{"$f":"Inputs!P111/1000","v":6380.4527119048607},{"$f":"Inputs!Q111/1000","v":6374.0760908642251},{"$f":"Inputs!R111/1000","v":6367.7632360339958},{"$f":"Inputs!S111/1000","v":6361.5135097520697},{"$f":"Inputs!T111/1000","v":6355.326280732962},{"$f":"Inputs!U111/1000","v":6349.200924004047},{"$f":"Inputs!V111/1000","v":6293.990481186619},{"$f":"Inputs!W111/1000","v":6238.7800383691929},{"$f":"Inputs!X111/1000","v":6183.5695955517667},{"$f":"Inputs!Y111/1000","v":6128.3591527343397},{"$f":"Inputs!Z111/1000","v":6073.1487099169126},{"$f":"Inputs!AA111/1000","v":6017.9382670994864},{"$f":"Inputs!AB111/1000","v":5962.7278242820603},{"$f":"Inputs!AC111/1000","v":5907.5173814646332},{"$f":"Inputs!AD111/1000","v":5852.3069386472071},{"$f":"Inputs!AE111/1000","v":5797.0964958297809},{"$f":"Inputs!AF111/1000","v":5741.8860530123548},{"$f":"Inputs!AG111/1000","v":5686.6756101949268},{"$f":"Inputs!AH111/1000","v":5631.4651673775006}]
["V CHP Contract (>75k tpa) (P4)",null,null,{"$f":"Inputs!P112/1000","v":1160.9611091276254},{"$f":"Inputs!Q112/1000","v":927.14136578898047},{"$f":"Inputs!R112/1000","v":927.14136578898047},{"$f":"Inputs!S112/1000","v":927.14136578898047},{"$f":"Inputs!T112/1000","v":927.14136578898047},{"$f":"Inputs!U112/1000","v":927.14136578898047},{"$f":"Inputs!V112/1000","v":919.07926695603282},{"$f":"Inputs!W112/1000","v":911.01716812308518},{"$f":"Inputs!X112/1000","v":902.95506929013766},{"$f":"Inputs!Y112/1000","v":894.89297045718979},{"$f":"Inputs!Z112/1000","v":886.83087162424226},{"$f":"Inputs!AA112/1000","v":878.76877279129451},{"$f":"Inputs!AB112/1000","v":870.70667395834698},{"$f":"Inputs!AC112/1000","v":862.64457512539911},{"$f":"Inputs!AD112/1000","v":854.58247629245159},{"$f":"Inputs!AE112/1000","v":846.52037745950395},{"$f":"Inputs!AF112/1000","v":838.45827862655631},{"$f":"Inputs!AG112/1000","v":830.39617979360855},{"$f":"Inputs!AH112/1000","v":822.33408096066091}]
["V Firm Contract (>75k tpa) (P5)",null,null,{"$f":"Inputs!P113/1000","v":13374.606008694762},{"$f":"Inputs!Q113/1000","v":13360.83565099987},{"$f":"Inputs!R113/1000","v":13360.83565099987},{"$f":"Inputs!S113/1000","v":13360.83565099987},{"$f":"Inputs!T113/1000","v":13360.83565099987},{"$f":"Inputs!U113/1000","v":13360.83565099987},{"$f":"Inputs!V113/1000","v":13244.65447142596},{"$f":"Inputs!W113/1000","v":13128.473291852048},{"$f":"Inputs!X113/1000","v":13012.292112278137},{"$f":"Inputs!Y113/1000","v":12896.110932704223},{"$f":"Inputs!Z113/1000","v":12779.929753130313},{"$f":"Inputs!AA113/1000","v":12663.748573556401},{"$f":"Inputs!AB113/1000","v":12547.567393982488},{"$f":"Inputs!AC113/1000","v":12431.386214408576},{"$f":"Inputs!AD113/1000","v":12315.205034834664},{"$f":"Inputs!AE113/1000","v":12199.023855260752},{"$f":"Inputs!AF113/1000","v":12082.842675686839},{"$f":"Inputs!AG113/1000","v":11966.661496112927},{"$f":"Inputs!AH113/1000","v":11850.480316539017}]
["V Int Contract (>75k tpa) (P6)",null,null,{"$f":"Inputs!P114/1000","v":21500.02571254065},{"$f":"Inputs!Q114/1000","v":18152.168570725185},{"$f":"Inputs!R114/1000","v":18152.168570725185},{"$f":"Inputs!S114/1000","v":18152.168570725185},{"$f":"Inputs!T114/1000","v":18152.168570725185},{"$f":"Inputs!U114/1000","v":18152.168570725185},{"$f":"Inputs!V114/1000","v":17994.323626631936},{"$f":"Inputs!W114/1000","v":17836.478682538673},{"$f":"Inputs!X114/1000","v":17678.633738445413},{"$f":"Inputs!Y114/1000","v":17520.788794352149},{"$f":"Inputs!Z114/1000","v":17362.943850258886},{"$f":"Inputs!AA114/1000","v":17205.098906165622},{"$f":"Inputs!AB114/1000","v":17047.253962072362},{"$f":"Inputs!AC114/1000","v":16889.409017979098},{"$f":"Inputs!AD114/1000","v":16731.564073885835},{"$f":"Inputs!AE114/1000","v":16573.719129792571},{"$f":"Inputs!AF114/1000","v":16415.874185699311},{"$f":"Inputs!AG114/1000","v":16258.029241606047},{"$f":"Inputs!AH114/1000","v":16100.184297512784}]
["£/therm",{"$f":"B16*Inputs!B2","v":0.4730165224956715},2014,{"$f":"D24/Inputs!M2*Inputs!M1","v":0.44258252356428246}]
["P Dom/Very Small IC Tariff (<2,500 tpa) (P1)",null,null,0.4400043729415779,{"$f":"D24","v":0.4400043729415779},{"$f":"E24","v":0.4400043729415779},0.4400043729415779,0.4400043729415779,0.4400043729415779,0.4400043729415779,0.4400043729415779,0.4400043729415779,0.4400043729415779,0.4400043729415779,0.4400043729415779,0.4400043729415779,0.4400043729415779,0.4400043729415779,0.4400043729415779,0.4400043729415779,0.4400043729415779,{"$f":"U24","v":0.4400043729415779}]
["P Small/Med Tariff IC (2,500 - 25k tpa) (P2)","Per GD14 Split - Needs Confirmed",0.70249326086221142,{"$f":"$D$24*C25","v":0.30910010674136162},{"$f":"D25","v":0.30910010674136162},0.30910010674136162,0.30910010674136162,0.30910010674136162,0.30910010674136162,0.30910010674136162,0.30910010674136162,0.30910010674136162,0.30910010674136162,0.30910010674136162,0.30910010674136162,0.30910010674136162,0.30910010674136162,0.30910010674136162,0.30910010674136162,0.30910010674136162,0.30910010674136162,0.30910010674136162]
["P Large Tariff IC (25k - 75k tpa) (P3)","Per GD14 Split - Needs Confirmed",0.62966323886435094,{"$f":"$D$24*C26","v":0.27705457858087174},0.27705457858087174,0.27705457858087174,0.27705457858087174,0.27705457858087174,0.27705457858087174,0.27705457858087174,0.27705457858087174,0.27705457858087174,0.27705457858087174,0.27705457858087174,0.27705457858087174,0.27705457858087174,0.27705457858087174,0.27705457858087174,0.27705457858087174,0.27705457858087174,0.27705457858087174,0.27705457858087174]
["P CHP Contract (>75k tpa) (P4)","Per GD14 Split - Needs Confirmed",0.59008170977553098,{"$f":"$D$24*C27","v":0.25963853269407666},0.25963853269407666,{"$f":"E27","v":0.25963853269407666},{"$f":"F27","v":0.25963853269407666},{"$f":"G27","v":0.25963853269407666},{"$f":"H27","v":0.25963853269407666},{"$f":"I27","v":0.25963853269407666},{"$f":"J27","v":0.25963853269407666},{"$f":"K27","v":0.25963853269407666},{"$f":"L27","v":0.25963853269407666},{"$f":"M27","v":0.25963853269407666},{"$f":"N27","v":0.25963853269407666},{"$f":"O27","v":0.25963853269407666},{"$f":"P27","v":0.25963853269407666},{"$f":"Q27","v":0.25963853269407666},{"$f":"R27","v":0.25963853269407666},{"$f":"S27","v":0.25963853269407666},0.25963853269407666,0.25963853269407666]
["P Firm Contract (>75k tpa) (P5)","Per GD14 Split - Needs Confirmed",0.59008170977553098,{"$f":"$D$24*C28","v":0.25963853269407666},0.25963853269407666,0.25963853269407666,0.25963853269407666,0.25963853269407666,0.25963853269407666,0.25963853269407666,0.25963853269407666,0.25963853269407666,0.25963853269407666,0.25963853269407666,0.25963853269407666,0.25963853269407666,0.25963853269407666,0.25963853269407666,0.25963853269407666,0.25963853269407666,0.25963853269407666,0.25963853269407666]
["P Int Contract (>75k tpa) (P6)","Per GD14 Split - Needs Confirmed",0.59008170977553098,{"$f":"$D$24*C29","v":0.25963853269407666},0.25963853269407666,0.25963853269407666,0.25963853269407666,0.25963853269407666,0.25963853269407666,0.25963853269407666,0.25963853269407666,0.25963853269407666,0.25963853269407666,0.25963853269407666,0.25963853269407666,0.25963853269407666,0.25963853269407666,0.25963853269407666,0.25963853269407666,0.25963853269407666,0.25963853269407666,0.25963853269407666]
[]
["Conditions 4.6 and 4.6.6 Establishing Best Available Revenue Per Unit and Calculating Cashflow"]
[]
["Allowed Revenue",null,null,{"$f":"SUMPRODUCT(D24:D29,D17:D22)","v":18630.03212027088},{"$f":"SUMPRODUCT(E24:E29,E17:E22)","v":18513.157789179917},19381.530225185968,20295.590523675768,21249.379371994299,22243.959117078361,23083.02882024095,23887.719640419076,24591.696354534179,25336.934063976783,25944.672180958412,26565.721037321331,27055.063673987734,27561.820185538723,27943.328978358266,28352.679419769582,28649.430169456355,28975.896978293393,29201.543309463937]
["Capex",null,null,{"$f":"-D14","v":-16870.032428789473},{"$f":"-E14","v":-14055.09860867504},-14224.728892625451,-14468.917813675891,-14768.335265232481,-15080.277621366629,-13492.939004170017,-12659.183257537063,-12868.910957208425,-10298.632102522301,-8046.6155685031499,-8046.6877087530138,-8185.4487240903163,-7805.8342890771346,-7757.1163455049173,-7832.5369075536,-7373.4284359435342,-7329.2630529254202,-7126.8787334957469]
["Opex",null,null,{"$f":"-D15","v":-6400.4283486982604},{"$f":"-E15","v":-6354.3911259654342},-6494.1518707070991,-6689.5099097442662,-6941.0773949377399,-7254.7695690012206,-7441.89053964299,-7540.8780146904301,-7627.5204273558757,-7719.34827127277,-7881.1328683718757,-8083.6747675785628,-8198.0207518430725,-8298.3394623038821,-8363.8735333608656,-8303.5039426606818,-8213.5566652514462,-8200.5603915330939,-8319.4712847529572]
[]
["Cashflows",null,null,{"$f":"SUM(D33:D36)","v":-4640.428657216853},{"$f":"SUM(E33:E36)","v":-1896.3319454605571},{"$f":"SUM(F33:F36)","v":-1337.350538146582},-862.83719974438918,-460.03328817592228,-91.08807328948933,2148.199276427943,3687.6583681915836,4095.2649699698777,7318.9536901817128,10016.923744083389,10435.358560989753,10671.594198054347,11457.646434157707,11822.339099492483,12216.6385695553,13062.445068261375,13446.073533834879,13755.193291215235]
[]
[]
[]
["Discounted Cashflow",null,{"$f":"SUM(D41:V41)","v":61096.140113289177},{"$f":"D37*D7","v":-4544.772649421875},{"$f":"E37*E7","v":-1780.6727609143911},-1204.011686919574,-744.78341644217664,-380.72034677296068,-72.275987866557216,1634.2661219378037,2689.7665223363711,2863.9247435246648,4907.3189518131958,6439.3991496581421,6431.8224309665256,6306.2569712091681,6491.6256776546625,6422.1013726250112,6362.6958208020578,6522.7330488200923,6437.4860551552365,6313.9800951237867]
[]
[]
[]
["Closing DAV",null,null,{"$f":"DAV!P35/1000","v":118159.38604723224},{"$f":"DAV!Q35/1000","v":127427.94236768414},{"$f":"DAV!R35/1000","v":136460.04156504493},{"$f":"DAV!S35/1000","v":145301.76944698038},{"$f":"DAV!T35/1000","v":154032.97148279884},{"$f":"DAV!U35/1000","v":162794.93079279375},{"$f":"DAV!V35/1000","v":169695.09369661016},{"$f":"DAV!W35/1000","v":175452.03455542066},{"$f":"DAV!X35/1000","v":181108.24550302091},{"$f":"DAV!Y35/1000","v":183961.27362486461},{"$f":"DAV!Z35/1000","v":184388.46332450476},{"$f":"DAV!AA35/1000","v":184627.32279830796},{"$f":"DAV!AB35/1000","v":184771.18409141322},{"$f":"DAV!AC35/1000","v":184332.07847092435},{"$f":"DAV!AD35/1000","v":183625.23683559094},{"$f":"DAV!AE35/1000","v":182771.56850222658},{"$f":"DAV!AF35/1000","v":181264.24849017826},{"$f":"DAV!AG35/1000","v":179530.94577103175},{"$f":"DAV!AH35/1000","v":177409.95799090739}]
[]
[]
[]
["TRV",null,{"$f":"-C65","v":-143802.85904978559}]
["Discounted DAV2035",null,{"$f":"V45*V8","v":79721.623241911162}]
["Backsolve to 0 by running Macro Ctrl + q",null,{"$f":"SUM(C41:C50)","v":-2985.0956945852522}]
[]
[]
[]
["Condition 4.6.8 Calculating TRV"]
[]
[null,"Total Regulatory Value (TRV)",null,null,null,null,null,null,{"$f":"I67+I69","v":196363.78461040006},null,null,null,null,{"$f":"N67+N69","v":212920.43674493121},null,null,null,null,{"$f":"S67+S69","v":200017.43444611382},null,null,{"$f":"V67+V69","v":184052.89475309799}]
[]
[]
[]
["Condition 4.6.9 Calculating Profile Adjustment"]
[null,null,null,null,null,null,null,null,"x",null,null,null,null,"x",null,null,null,null,"x",null,null,null,null,"x",null,null,null,null,"x",null,null,"x"]
[null,"Adjusted Cashflows",null,{"$f":"D37*(1+$I$6*$B$7)*(1+$I$6)^($I$12-D12)","v":-5850.8371897332272},{"$f":"E37*(1+$I$6*$B$7)*(1+$I$6)^($I$12-E12)","v":-2292.3977096253989},-1550.0173271810606,-958.8172714801857,-490.13073603818793,-93.046466865213361,{"$f":"J37*(1+$N$6*$B$7)*(1+$N$6)^($N$12-J12)","v":2596.8697689719866},{"$f":"K37*(1+$N$6*$B$7)*(1+$N$6)^($N$12-K12)","v":4274.0734043767125},{"$f":"L37*(1+$N$6*$B$7)*(1+$N$6)^($N$12-L12)","v":4550.8130452165715},{"$f":"M37*(1+$N$6*$B$7)*(1+$N$6)^($N$12-M12)","v":7797.792575885006},{"$f":"N37*(1+$N$6*$B$7)*(1+$N$6)^($N$12-N12)","v":10232.287604581183},{"$f":"O37*(1+$S$6*$B$7)*(1+$S$6)^($S$12-O12)","v":12614.875851032946},{"$f":"P37*(1+$S$6*$B$7)*(1+$S$6)^($S$12-P12)","v":12368.601532514655},{"$f":"Q37*(1+$S$6*$B$7)*(1+$S$6)^($S$12-Q12)","v":12732.169283890695},{"$f":"R37*(1+$S$6*$B$7)*(1+$S$6)^($S$12-R12)","v":12595.809723907229},{"$f":"S37*(1+$S$6*$B$7)*(1+$S$6)^($S$12-S12)","v":12479.29629880074},{"$f":"T37*(1+$V$6*$B$7)*(1+$V$6)^($V$12-T12)","v":14515.482112871923},{"$f":"U37*(1+$V$6*$B$7)*(1+$V$6)^($V$12-U12)","v":14325.776171749258},{"$f":"V37*(1+$V$6*$B$7)*(1+$V$6)^($V$12-V12)","v":14050.929946976365}]
[]
[null,"Closing TRV (Incl Return)",{"$f":"Inputs!O128/1000","v":143802.85904978559},null,null,null,null,null,{"$f":"-$C$65*(1+I6)^(I12-C12)","v":-185128.53790947678},null,null,null,null,{"$f":"-I57*(1+N6)^(N12-I12)","v":-242372.27314396267},null,null,null,null,{"$f":"-N57*(1+S6)^(S12-N12)","v":-262808.18713626009},null,null,{"$f":"-S57*(1+V6)^(V12-S12)","v":-226945.08298469553}]
[]
[null,"DAV",null,null,null,null,null,null,{"$f":"I45","v":162794.93079279375},null,null,null,null,{"$f":"N45","v":184388.46332450476},null,null,null,null,{"$f":"S45","v":182771.56850222658},null,null,{"$f":"V45","v":177409.95799090739}]
[]
[null,"Calculated PA",null,null,null,null,null,null,{"$f":"-SUM(D63:I68)","v":33568.853817606316},null,null,null,null,{"$f":"-SUM(J63:N68)","v":28531.973420426453},null,null,null,null,{"$f":"-SUM(O63:S68)","v":17245.865943887242},null,null,{"$f":"-SUM(T63:V68)","v":6642.9367621905985}]
[null,"Check",null,null,null,null,null,null,{"$f":"SUM(D63:I69)","v":0},null,null,null,null,{"$f":"SUM(J63:N69)","v":0},null,null,null,null,{"$f":"SUM(O63:S69)","v":0},null,null,{"$f":"SUM(T63:V69)","v":0}]
[]
[]
[null,null,null,null,null,null,null,"Average Totex",{"$f":"SUM(D14:I15)/6","v":21600.286474903169}]
[null,null,null,null,null,null,null,"Average TRV",{"$f":"(+C65+I57)/2","v":170083.32183009281}]
[]
[null,null,null,null,null,null,null,"Ratio",{"$f":"+I74/I73","v":7.8741234301548895}]
[]
[null,null,null,{"$f":"(SUM(D72:D77))+4162954.34941467","v":4162954.3494146699},{"$f":"(SUM(E72:E77))+4533329.78337157","v":4533329.7833715696},{"$f":"(SUM(F72:F77))+4932708.67857861","v":4932708.6785786096},{"$f":"(SUM(G72:G77))+5347599.74421037","v":5347599.7442103699},{"$f":"(SUM(H72:H77))+5741466.60358512","v":5741466.6035851203},{"$f":"(SUM(I72:I77))+6102467.09446314","v":6294158.5768915657}]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(D78:I78)/6/1000","v":5168.7029560086512}]
[]
[null,null,null,null,null,null,null,null,{"$f":"(+C65+I57)/2","v":170083.32183009281}]
[null,null,null,null,null,null,null,null,{"$f":"+I80/I82","v":3.0389240405193883E-2}]

{"sheet":"GD17 Pi's Calc - 40 yrs","index":3,"n_rows":81,"n_cols":32,"rows_kept":81,"cut":false,"hidden":false,"merged":[[1,0,1,2],[1,3,1,4],[52,0,52,31],[54,0,54,31],[60,0,60,31],[30,0,30,31],[38,0,38,31],[42,0,42,31],[46,0,46,31],[10,9,10,31]]}
[{"$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,"GD17",4.3200000000000002E-2]
[null,"£2014",null,"Post GD17",{"$f":"E3","v":4.3200000000000002E-2}]
[null,"£'000"]
["Real Return pa",null,null,{"$f":"E3","v":4.3200000000000002E-2},{"$f":"D6","v":4.3200000000000002E-2},{"$f":"E6","v":4.3200000000000002E-2},{"$f":"F6","v":4.3200000000000002E-2},{"$f":"G6","v":4.3200000000000002E-2},{"$f":"H6","v":4.3200000000000002E-2},{"$f":"E4","v":4.3200000000000002E-2},{"$f":"J6","v":4.3200000000000002E-2},{"$f":"K6","v":4.3200000000000002E-2},4.3200000000000002E-2,4.3200000000000002E-2,4.3200000000000002E-2,4.3200000000000002E-2,4.3200000000000002E-2,4.3200000000000002E-2,4.3200000000000002E-2,4.3200000000000002E-2,4.3200000000000002E-2,4.3200000000000002E-2,{"$f":"V6","v":4.3200000000000002E-2},{"$f":"W6","v":4.3200000000000002E-2},{"$f":"X6","v":4.3200000000000002E-2},{"$f":"Y6","v":4.3200000000000002E-2},{"$f":"Z6","v":4.3200000000000002E-2},{"$f":"AA6","v":4.3200000000000002E-2},{"$f":"AB6","v":4.3200000000000002E-2},{"$f":"AC6","v":4.3200000000000002E-2},{"$f":"AD6","v":4.3200000000000002E-2},{"$f":"AE6","v":4.3200000000000002E-2}]
["Discount Factor (Mid Yr)",0.5,1,{"$f":"D8*(1+D6*$B$7)","v":0.97929447852760754},0.93874087282170982,0.89986663422326496,0.86260221838886597,0.82688096087889773,0.79263895789771643,0.75981495197250426,0.728350222366281,0.69818848002902711,0.66927576689899071,0.64156035937403266,0.6149926757803228,0.58952518767285544,0.56511233480910228,0.54171044364369481,0.51927764919832708,0.49777382016710808,0.47716048712337816,0.45740077369955734,0.43845933061690701,0.42030227244718849,0.40289711699308711,0.38621272717895627,0.37021925534792594,0.35488808986572656,0.3401918039357042,0.32610410653345878,0.31259979537333094,0.29965471182259484]
["Discount Factor (Yr End)",null,1,{"$f":"C8/(1+D6)","v":0.95858895705521485},0.91889278858820456,0.88084047985832503,0.84436395691940669,0.80939796483838844,0.77587995095704421,0.7437499529879642,0.71295049174459768,0.68342646831345644,0.65512506548452498,0.62799565326354012,0.60198969829710525,0.57706067704860553,0.55316399256959892,0.53025689471779047,0.50829840367886359,0.48724923665535241,0.4670717375914038,0.44772980980771077,0.42918885142610314,0.41141569346827372,0.39437854051790044,0.37804691384001199,0.36239159685583977,0.3473845828756133,0.33299902499579498,0.31920918807112253,0.30599040267553929,0.2933190209696504]
[]
[]
[null,null,null,null,null,null,null,null,null,"IMPORTANT NOTE:  Values from 2023 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,2016,2017,{"$f":"D12+1","v":2018},2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,{"$f":"V12+1","v":2036},{"$f":"W12+1","v":2037},{"$f":"X12+1","v":2038},{"$f":"Y12+1","v":2039},{"$f":"Z12+1","v":2040},{"$f":"AA12+1","v":2041},{"$f":"AB12+1","v":2042},{"$f":"AC12+1","v":2043},{"$f":"AD12+1","v":2044},2045]
[]
["Capex",null,null,{"$f":"Inputs!P102/1000","v":16870.032428789473},{"$f":"Inputs!Q102/1000","v":14055.09860867504},{"$f":"Inputs!R102/1000","v":14224.728892625451},{"$f":"Inputs!S102/1000","v":14468.917813675891},{"$f":"Inputs!T102/1000","v":14768.335265232481},{"$f":"Inputs!U102/1000","v":15080.277621366629},{"$f":"Inputs!V102/1000","v":13492.939004170017},{"$f":"Inputs!W102/1000","v":12659.183257537063},{"$f":"Inputs!X102/1000","v":12868.910957208425},{"$f":"Inputs!Y102/1000","v":10298.632102522301},{"$f":"Inputs!Z102/1000","v":8046.6155685031499},{"$f":"Inputs!AA102/1000","v":8046.6877087530138},{"$f":"Inputs!AB102/1000","v":8185.4487240903163},{"$f":"Inputs!AC102/1000","v":7805.8342890771346},{"$f":"Inputs!AD102/1000","v":7757.1163455049173},{"$f":"Inputs!AE102/1000","v":7832.5369075536},{"$f":"Inputs!AF102/1000","v":7373.4284359435342},{"$f":"Inputs!AG102/1000","v":7329.2630529254202},{"$f":"Inputs!AH102/1000","v":7126.8787334957469},{"$f":"Inputs!AI102/1000","v":6819.1876905972922},{"$f":"Inputs!AJ102/1000","v":6800.7445315501946},{"$f":"Inputs!AK102/1000","v":6760.4935108053587},{"$f":"Inputs!AL102/1000","v":6700.9723099499834},{"$f":"Inputs!AM102/1000","v":6644.7815412744085},{"$f":"Inputs!AN102/1000","v":6617.1698535966852},{"$f":"Inputs!AO102/1000","v":6513.854369906685},{"$f":"Inputs!AP102/1000","v":6345.9274778102645},{"$f":"Inputs!AQ102/1000","v":6373.1044215843631},{"$f":"Inputs!AR102/1000","v":6258.60880484262}]
["Opex",null,null,{"$f":"Inputs!P105/1000","v":6400.4283486982604},{"$f":"Inputs!Q105/1000","v":6354.3911259654342},{"$f":"Inputs!R105/1000","v":6494.1518707070991},{"$f":"Inputs!S105/1000","v":6689.5099097442662},{"$f":"Inputs!T105/1000","v":6941.0773949377399},{"$f":"Inputs!U105/1000","v":7254.7695690012206},{"$f":"Inputs!V105/1000","v":7441.89053964299},{"$f":"Inputs!W105/1000","v":7540.8780146904301},{"$f":"Inputs!X105/1000","v":7627.5204273558757},{"$f":"Inputs!Y105/1000","v":7719.34827127277},{"$f":"Inputs!Z105/1000","v":7881.1328683718757},{"$f":"Inputs!AA105/1000","v":8083.6747675785628},{"$f":"Inputs!AB105/1000","v":8198.0207518430725},{"$f":"Inputs!AC105/1000","v":8298.3394623038821},{"$f":"Inputs!AD105/1000","v":8363.8735333608656},{"$f":"Inputs!AE105/1000","v":8303.5039426606818},{"$f":"Inputs!AF105/1000","v":8213.5566652514462},{"$f":"Inputs!AG105/1000","v":8200.5603915330939},{"$f":"Inputs!AH105/1000","v":8319.4712847529572},{"$f":"Inputs!AI105/1000","v":8512.4355824412651},{"$f":"Inputs!AJ105/1000","v":8732.0580342062949},{"$f":"Inputs!AK105/1000","v":8807.9624125179089},{"$f":"Inputs!AL105/1000","v":8813.7796483350849},{"$f":"Inputs!AM105/1000","v":9061.6471737421798},{"$f":"Inputs!AN105/1000","v":9318.4117696721587},{"$f":"Inputs!AO105/1000","v":9308.8781996023408},{"$f":"Inputs!AP105/1000","v":9162.2865235111494},{"$f":"Inputs!AQ105/1000","v":9109.9513236088533},{"$f":"Inputs!AR105/1000","v":9032.9785828514905}]
["Volumes (therms '000)",null,null,{"$f":"SUM(D17:D22)","v":61955.046268008868},{"$f":"SUM(E17:E22)","v":60366.093171438581},62486.886114643581,64708.29590555522,67016.828425925065,69414.947045184847,71310.524339677329,73118.53570680377,74633.172118661372,76307.90978652396,77594.467105293748,78960.369092722278,79955.157462161413,81039.987505961821,81771.720744421342,82618.064732117156,83142.94701601415,83787.168831044604,84139.231072019771,84630.519088013214,84823.512885385935,85141.287224565283,85187.481394192466,85375.959365229995,85301.705495790753,85369.941416545145,85183.748580311556,85155.129652972217,84894.819508823042]
["V Dom/Very Small IC Tariff (<2,500 tpa) (P1)",null,null,{"$f":"Inputs!P109/1000","v":11203.323378270079},{"$f":"Inputs!Q109/1000","v":12702.360989018294},{"$f":"Inputs!R109/1000","v":14326.699280580207},{"$f":"Inputs!S109/1000","v":16062.487011711972},{"$f":"Inputs!T109/1000","v":17896.063057793053},{"$f":"Inputs!U109/1000","v":19829.726038751334},{"$f":"Inputs!V109/1000","v":21643.454427329722},{"$f":"Inputs!W109/1000","v":23401.323326366757},{"$f":"Inputs!X109/1000","v":25082.557014303595},{"$f":"Inputs!Y109/1000","v":26700.948441771292},{"$f":"Inputs!Z109/1000","v":28185.555038309969},{"$f":"Inputs!AA109/1000","v":29584.49058304854},{"$f":"Inputs!AB109/1000","v":30853.598726006152},{"$f":"Inputs!AC109/1000","v":32043.121867083708},{"$f":"Inputs!AD109/1000","v":33109.612665686524},{"$f":"Inputs!AE109/1000","v":34118.163822969582},{"$f":"Inputs!AF109/1000","v":35025.604106243147},{"$f":"Inputs!AG109/1000","v":35878.257766668394},{"$f":"Inputs!AH109/1000","v":36650.593783935918},{"$f":"Inputs!AI109/1000","v":37387.530340127298},{"$f":"Inputs!AJ109/1000","v":38030.4679013774},{"$f":"Inputs!AK109/1000","v":38623.921519376032},{"$f":"Inputs!AL109/1000","v":39143.311808696337},{"$f":"Inputs!AM109/1000","v":39631.768684496994},{"$f":"Inputs!AN109/1000","v":40048.845569480203},{"$f":"Inputs!AO109/1000","v":40436.790324254864},{"$f":"Inputs!AP109/1000","v":40755.982777216945},{"$f":"Inputs!AQ109/1000","v":41063.15988755026},{"$f":"Inputs!AR109/1000","v":41319.037542245933}]
["V Small/Med Tariff IC (2,500 - 25k tpa) (P2)",null,null,{"$f":"Inputs!P110/1000","v":8335.6773474708953},{"$f":"Inputs!Q110/1000","v":8849.5105040420258},{"$f":"Inputs!R110/1000","v":9352.2780105153415},{"$f":"Inputs!S110/1000","v":9844.1497965771505},{"$f":"Inputs!T110/1000","v":10325.293499885023},{"$f":"Inputs!U110/1000","v":10795.874494915435},{"$f":"Inputs!V110/1000","v":11215.022066147061},{"$f":"Inputs!W110/1000","v":11602.463199554017},{"$f":"Inputs!X110/1000","v":11773.164588792324},{"$f":"Inputs!Y110/1000","v":12166.809494504767},{"$f":"Inputs!Z110/1000","v":12306.058882053425},{"$f":"Inputs!AA110/1000","v":12610.323990060942},{"$f":"Inputs!AB110/1000","v":12673.302881860003},{"$f":"Inputs!AC110/1000","v":12905.908449900408},{"$f":"Inputs!AD110/1000","v":12908.449555074667},{"$f":"Inputs!AE110/1000","v":13083.541050804961},{"$f":"Inputs!AF110/1000","v":13038.281716745947},{"$f":"Inputs!AG110/1000","v":13167.148536668703},{"$f":"Inputs!AH110/1000","v":13084.173425693898},{"$f":"Inputs!AI110/1000","v":13175.823550813511},{"$f":"Inputs!AJ110/1000","v":13063.178452253667},{"$f":"Inputs!AK110/1000","v":13124.797838751927},{"$f":"Inputs!AL110/1000","v":12988.900384376364},{"$f":"Inputs!AM110/1000","v":13026.220144930789},{"$f":"Inputs!AN110/1000","v":12872.188055825885},{"$f":"Inputs!AO110/1000","v":12889.777887123175},{"$f":"Inputs!AP110/1000","v":12721.691263245024},{"$f":"Inputs!AQ110/1000","v":12723.193890889925},{"$f":"Inputs!AR110/1000","v":12544.304757362621}]
["V Large Tariff IC (25k - 75k tpa) (P3)",null,null,{"$f":"Inputs!P111/1000","v":6380.4527119048607},{"$f":"Inputs!Q111/1000","v":6374.0760908642251},{"$f":"Inputs!R111/1000","v":6367.7632360339958},{"$f":"Inputs!S111/1000","v":6361.5135097520697},{"$f":"Inputs!T111/1000","v":6355.326280732962},{"$f":"Inputs!U111/1000","v":6349.200924004047},{"$f":"Inputs!V111/1000","v":6293.990481186619},{"$f":"Inputs!W111/1000","v":6238.7800383691929},{"$f":"Inputs!X111/1000","v":6183.5695955517667},{"$f":"Inputs!Y111/1000","v":6128.3591527343397},{"$f":"Inputs!Z111/1000","v":6073.1487099169126},{"$f":"Inputs!AA111/1000","v":6017.9382670994864},{"$f":"Inputs!AB111/1000","v":5962.7278242820603},{"$f":"Inputs!AC111/1000","v":5907.5173814646332},{"$f":"Inputs!AD111/1000","v":5852.3069386472071},{"$f":"Inputs!AE111/1000","v":5797.0964958297809},{"$f":"Inputs!AF111/1000","v":5741.8860530123548},{"$f":"Inputs!AG111/1000","v":5686.6756101949268},{"$f":"Inputs!AH111/1000","v":5631.4651673775006},{"$f":"Inputs!AI111/1000","v":5576.2547245600745},{"$f":"Inputs!AJ111/1000","v":5521.0442817426483},{"$f":"Inputs!AK111/1000","v":5465.8338389252212},{"$f":"Inputs!AL111/1000","v":5410.6233961077951},{"$f":"Inputs!AM111/1000","v":5355.412953290368},{"$f":"Inputs!AN111/1000","v":5300.2025104729419},{"$f":"Inputs!AO111/1000","v":5244.9920676555148},{"$f":"Inputs!AP111/1000","v":5189.7816248380886},{"$f":"Inputs!AQ111/1000","v":5134.5711820206625},{"$f":"Inputs!AR111/1000","v":5079.3607392032363}]
["V CHP Contract (>75k tpa) (P4)",null,null,{"$f":"Inputs!P112/1000","v":1160.9611091276254},{"$f":"Inputs!Q112/1000","v":927.14136578898047},{"$f":"Inputs!R112/1000","v":927.14136578898047},{"$f":"Inputs!S112/1000","v":927.14136578898047},{"$f":"Inputs!T112/1000","v":927.14136578898047},{"$f":"Inputs!U112/1000","v":927.14136578898047},{"$f":"Inputs!V112/1000","v":919.07926695603282},{"$f":"Inputs!W112/1000","v":911.01716812308518},{"$f":"Inputs!X112/1000","v":902.95506929013766},{"$f":"Inputs!Y112/1000","v":894.89297045718979},{"$f":"Inputs!Z112/1000","v":886.83087162424226},{"$f":"Inputs!AA112/1000","v":878.76877279129451},{"$f":"Inputs!AB112/1000","v":870.70667395834698},{"$f":"Inputs!AC112/1000","v":862.64457512539911},{"$f":"Inputs!AD112/1000","v":854.58247629245159},{"$f":"Inputs!AE112/1000","v":846.52037745950395},{"$f":"Inputs!AF112/1000","v":838.45827862655631},{"$f":"Inputs!AG112/1000","v":830.39617979360855},{"$f":"Inputs!AH112/1000","v":822.33408096066091},{"$f":"Inputs!AI112/1000","v":814.27198212771327},{"$f":"Inputs!AJ112/1000","v":806.20988329476563},{"$f":"Inputs!AK112/1000","v":798.14778446181799},{"$f":"Inputs!AL112/1000","v":790.08568562887024},{"$f":"Inputs!AM112/1000","v":782.02358679592271},{"$f":"Inputs!AN112/1000","v":773.96148796297496},{"$f":"Inputs!AO112/1000","v":765.89938913002732},{"$f":"Inputs!AP112/1000","v":757.83729029707968},{"$f":"Inputs!AQ112/1000","v":749.77519146413204},{"$f":"Inputs!AR112/1000","v":741.7130926311844}]
["V Firm Contract (>75k tpa) (P5)",null,null,{"$f":"Inputs!P113/1000","v":13374.606008694762},{"$f":"Inputs!Q113/1000","v":13360.83565099987},{"$f":"Inputs!R113/1000","v":13360.83565099987},{"$f":"Inputs!S113/1000","v":13360.83565099987},{"$f":"Inputs!T113/1000","v":13360.83565099987},{"$f":"Inputs!U113/1000","v":13360.83565099987},{"$f":"Inputs!V113/1000","v":13244.65447142596},{"$f":"Inputs!W113/1000","v":13128.473291852048},{"$f":"Inputs!X113/1000","v":13012.292112278137},{"$f":"Inputs!Y113/1000","v":12896.110932704223},{"$f":"Inputs!Z113/1000","v":12779.929753130313},{"$f":"Inputs!AA113/1000","v":12663.748573556401},{"$f":"Inputs!AB113/1000","v":12547.567393982488},{"$f":"Inputs!AC113/1000","v":12431.386214408576},{"$f":"Inputs!AD113/1000","v":12315.205034834664},{"$f":"Inputs!AE113/1000","v":12199.023855260752},{"$f":"Inputs!AF113/1000","v":12082.842675686839},{"$f":"Inputs!AG113/1000","v":11966.661496112927},{"$f":"Inputs!AH113/1000","v":11850.480316539017},{"$f":"Inputs!AI113/1000","v":11734.299136965103},{"$f":"Inputs!AJ113/1000","v":11618.117957391192},{"$f":"Inputs!AK113/1000","v":11501.936777817278},{"$f":"Inputs!AL113/1000","v":11385.75559824337},{"$f":"Inputs!AM113/1000","v":11269.574418669457},{"$f":"Inputs!AN113/1000","v":11153.393239095545},{"$f":"Inputs!AO113/1000","v":11037.212059521633},{"$f":"Inputs!AP113/1000","v":10921.030879947721},{"$f":"Inputs!AQ113/1000","v":10804.84970037381},{"$f":"Inputs!AR113/1000","v":10688.668520799898}]
["V Int Contract (>75k tpa) (P6)",null,null,{"$f":"Inputs!P114/1000","v":21500.02571254065},{"$f":"Inputs!Q114/1000","v":18152.168570725185},{"$f":"Inputs!R114/1000","v":18152.168570725185},{"$f":"Inputs!S114/1000","v":18152.168570725185},{"$f":"Inputs!T114/1000","v":18152.168570725185},{"$f":"Inputs!U114/1000","v":18152.168570725185},{"$f":"Inputs!V114/1000","v":17994.323626631936},{"$f":"Inputs!W114/1000","v":17836.478682538673},{"$f":"Inputs!X114/1000","v":17678.633738445413},{"$f":"Inputs!Y114/1000","v":17520.788794352149},{"$f":"Inputs!Z114/1000","v":17362.943850258886},{"$f":"Inputs!AA114/1000","v":17205.098906165622},{"$f":"Inputs!AB114/1000","v":17047.253962072362},{"$f":"Inputs!AC114/1000","v":16889.409017979098},{"$f":"Inputs!AD114/1000","v":16731.564073885835},{"$f":"Inputs!AE114/1000","v":16573.719129792571},{"$f":"Inputs!AF114/1000","v":16415.874185699311},{"$f":"Inputs!AG114/1000","v":16258.029241606047},{"$f":"Inputs!AH114/1000","v":16100.184297512784},{"$f":"Inputs!AI114/1000","v":15942.339353419522},{"$f":"Inputs!AJ114/1000","v":15784.494409326258},{"$f":"Inputs!AK114/1000","v":15626.649465232997},{"$f":"Inputs!AL114/1000","v":15468.804521139733},{"$f":"Inputs!AM114/1000","v":15310.959577046473},{"$f":"Inputs!AN114/1000","v":15153.114632953208},{"$f":"Inputs!AO114/1000","v":14995.269688859946},{"$f":"Inputs!AP114/1000","v":14837.424744766682},{"$f":"Inputs!AQ114/1000","v":14679.579800673422},{"$f":"Inputs!AR114/1000","v":14521.734856580159}]
["£/therm",null,null,{"$f":"D24/Inputs!M2*Inputs!M1","v":0.43833769167842668}]
["P Dom/Very Small IC Tariff (<2,500 tpa) (P1)",null,null,0.43578426823175626,{"$f":"D24","v":0.43578426823175626},0.43578426823175626,0.43578426823175626,0.43578426823175626,0.43578426823175626,0.43578426823175626,0.43578426823175626,0.43578426823175626,0.43578426823175626,0.43578426823175626,0.43578426823175626,0.43578426823175626,0.43578426823175626,0.43578426823175626,0.43578426823175626,0.43578426823175626,0.43578426823175626,0.43578426823175626,{"$f":"V24","v":0.43578426823175626},{"$f":"W24","v":0.43578426823175626},{"$f":"X24","v":0.43578426823175626},{"$f":"Y24","v":0.43578426823175626},{"$f":"Z24","v":0.43578426823175626},{"$f":"AA24","v":0.43578426823175626},{"$f":"AB24","v":0.43578426823175626},{"$f":"AC24","v":0.43578426823175626},{"$f":"AD24","v":0.43578426823175626},{"$f":"AE24","v":0.43578426823175626}]
["P Small/Med Tariff IC (2,500 - 25k tpa) (P2)",null,0.70249326086221142,{"$f":"$D$24*C25","v":0.30613551162257907},{"$f":"D25","v":0.30613551162257907},0.30613551162257907,0.30613551162257907,0.30613551162257907,0.30613551162257907,0.30613551162257907,0.30613551162257907,0.30613551162257907,0.30613551162257907,0.30613551162257907,0.30613551162257907,0.30613551162257907,0.30613551162257907,0.30613551162257907,0.30613551162257907,0.30613551162257907,0.30613551162257907,0.30613551162257907,0.30613551162257907,0.30613551162257907,0.30613551162257907,0.30613551162257907,0.30613551162257907,0.30613551162257907,0.30613551162257907,0.30613551162257907,0.30613551162257907,{"$f":"AE25","v":0.30613551162257907}]
["P Large Tariff IC (25k - 75k tpa) (P3)",null,0.62966323886435094,{"$f":"$D$24*C26","v":0.27439733378093872},{"$f":"D26","v":0.27439733378093872},0.27439733378093872,0.27439733378093872,0.27439733378093872,0.27439733378093872,0.27439733378093872,0.27439733378093872,0.27439733378093872,0.27439733378093872,0.27439733378093872,0.27439733378093872,0.27439733378093872,0.27439733378093872,0.27439733378093872,0.27439733378093872,0.27439733378093872,0.27439733378093872,0.27439733378093872,0.27439733378093872,0.27439733378093872,0.27439733378093872,0.27439733378093872,0.27439733378093872,0.27439733378093872,0.27439733378093872,0.27439733378093872,0.27439733378093872,0.27439733378093872]
["P CHP Contract (>75k tpa) (P4)",null,0.5,{"$f":"$D$24*C27","v":0.21789213411587813},0.21789213411587813,{"$f":"E27","v":0.21789213411587813},{"$f":"F27","v":0.21789213411587813},{"$f":"G27","v":0.21789213411587813},{"$f":"H27","v":0.21789213411587813},{"$f":"I27","v":0.21789213411587813},{"$f":"J27","v":0.21789213411587813},{"$f":"K27","v":0.21789213411587813},{"$f":"L27","v":0.21789213411587813},{"$f":"M27","v":0.21789213411587813},{"$f":"N27","v":0.21789213411587813},{"$f":"O27","v":0.21789213411587813},{"$f":"P27","v":0.21789213411587813},{"$f":"Q27","v":0.21789213411587813},{"$f":"R27","v":0.21789213411587813},{"$f":"S27","v":0.21789213411587813},{"$f":"T27","v":0.21789213411587813},{"$f":"U27","v":0.21789213411587813},0.21789213411587813,0.21789213411587813,0.21789213411587813,0.21789213411587813,0.21789213411587813,0.21789213411587813,0.21789213411587813,0.21789213411587813,0.21789213411587813,0.21789213411587813]
["P Firm Contract (>75k tpa) (P5)",null,0.59008170977553098,0.25714832609147337,0.25714832609147337,0.25714832609147337,0.25714832609147337,0.25714832609147337,0.25714832609147337,0.25714832609147337,0.25714832609147337,0.25714832609147337,0.25714832609147337,0.25714832609147337,0.25714832609147337,0.25714832609147337,0.25714832609147337,0.25714832609147337,0.25714832609147337,0.25714832609147337,0.25714832609147337,0.25714832609147337,0.25714832609147337,0.25714832609147337,0.25714832609147337,0.25714832609147337,0.25714832609147337,0.25714832609147337,0.25714832609147337,0.25714832609147337,0.25714832609147337,0.25714832609147337]
["P Int Contract (>75k tpa) (P6)",null,0.53600000000000003,0.23358036777222135,0.23358036777222135,0.23358036777222135,0.23358036777222135,0.23358036777222135,0.23358036777222135,0.23358036777222135,0.23358036777222135,0.23358036777222135,0.23358036777222135,0.23358036777222135,0.23358036777222135,0.23358036777222135,0.23358036777222135,0.23358036777222135,0.23358036777222135,0.23358036777222135,0.23358036777222135,0.23358036777222135,0.23358036777222135,0.23358036777222135,0.23358036777222135,0.23358036777222135,0.23358036777222135,0.23358036777222135,0.23358036777222135,0.23358036777222135,0.23358036777222135,0.23358036777222135]
[]
["Conditions 4.6 and 4.6.6 Establishing Best Available Revenue Per Unit and Calculating Cashflow"]
[]
["Allowed Revenue",null,null,{"$f":"SUMPRODUCT(D24:D29,D17:D22)","v":17899.063896123589},{"$f":"SUMPRODUCT(E24:E29,E17:E22)","v":17871.391543099326},18731.435374135912,19636.72887300295,20581.369883121475,21566.410562403842,22401.469274986808,23202.478834231009,23903.740241615113,24645.86690798539,25251.81274760118,25870.941662608071,26359.627559086966,26865.560313075304,27247.446605683763,27656.907516191619,27954.848684444973,28282.220903587557,28509.739619482116,28775.290793129789,28937.336660729296,29131.166751620643,29232.254289886121,29372.889473891457,29423.83878443663,29514.632335344824,29518.622558116967,29569.293975874789,29542.38557379791]
["Capex",null,null,{"$f":"-D14","v":-16870.032428789473},-14055.09860867504,-14224.728892625451,-14468.917813675891,-14768.335265232481,-15080.277621366629,-13492.939004170017,-12659.183257537063,-12868.910957208425,-10298.632102522301,-8046.6155685031499,-8046.6877087530138,-8185.4487240903163,-7805.8342890771346,-7757.1163455049173,-7832.5369075536,-7373.4284359435342,-7329.2630529254202,-7126.8787334957469,{"$f":"-W14","v":-6819.1876905972922},-6800.7445315501946,-6760.4935108053587,-6700.9723099499834,-6644.7815412744085,-6617.1698535966852,-6513.854369906685,-6345.9274778102645,-6373.1044215843631,{"$f":"-AF14","v":-6258.60880484262}]
["Opex",null,null,{"$f":"-D15","v":-6400.4283486982604},-6354.3911259654342,-6494.1518707070991,-6689.5099097442662,-6941.0773949377399,-7254.7695690012206,-7441.89053964299,-7540.8780146904301,-7627.5204273558757,-7719.34827127277,-7881.1328683718757,-8083.6747675785628,-8198.0207518430725,-8298.3394623038821,-8363.8735333608656,-8303.5039426606818,-8213.5566652514462,-8200.5603915330939,-8319.4712847529572,{"$f":"-W15","v":-8512.4355824412651},-8732.0580342062949,-8807.9624125179089,-8813.7796483350849,-9061.6471737421798,-9318.4117696721587,-9308.8781996023408,-9162.2865235111494,-9109.9513236088533,{"$f":"-AF15","v":-9032.9785828514905}]
[]
["Cashflows",null,null,{"$f":"SUM(D33:D36)","v":-5371.3968813641441},-2538.0981915411485,-1987.4453891966386,-1521.6988504172068,-1128.0427770487458,-768.63662796400786,1466.639731173801,3002.4175620035167,3407.3088570508116,6627.8865341903193,9324.0643107261567,9740.5791862764927,9976.1580831535794,10761.386561694288,11126.45672681798,11520.866665977337,12367.863583249993,12752.397459129043,13063.38960123341,{"$f":"SUM(W33:W36)","v":13443.66752009123},13404.534094972807,13562.710828297377,13717.502331601054,13666.460758874868,13488.257161167785,13691.899765835797,14010.408556795552,14086.238230681571,{"$f":"SUM(AF33:AF36)","v":14250.798186103799}]
[]
[]
[]
["Discounted Cashflow",null,{"$f":"SUM(D41:AF41)","v":102028.98179077878},{"$f":"D37*D7","v":-5260.1793079003164},-2382.616511634541,-1788.4357930789261,-1312.6208040896697,-932.75709539856712,-609.25133579140595,1114.3747969027881,2186.8114989216888,2378.9437918937479,4435.8838430897194,5981.9500500160657,5990.3848574182994,5881.1964662251876,6081.3922856623567,6027.3178096669399,5982.52855903608,6156.3987031400075,6084.9401835889439,5975.204510742913,{"$f":"W37*W7","v":5894.5014618954556},5633.9561412128878,5464.3770913319377,5297.8739855713347,5059.5869253923047,4786.8218195445424,4657.8720806465253,4568.8517645825395,4403.3551884910503,{"$f":"AF37*AF7","v":4270.3188236988908}]
[]
[]
[]
["Closing DAV",null,null,{"$f":"DAV!P35/1000","v":118159.38604723224},{"$f":"DAV!Q35/1000","v":127427.94236768414},{"$f":"DAV!R35/1000","v":136460.04156504493},{"$f":"DAV!S35/1000","v":145301.76944698038},{"$f":"DAV!T35/1000","v":154032.97148279884},{"$f":"DAV!U35/1000","v":162794.93079279375},{"$f":"DAV!V35/1000","v":169695.09369661016},{"$f":"DAV!W35/1000","v":175452.03455542066},{"$f":"DAV!X35/1000","v":181108.24550302091},{"$f":"DAV!Y35/1000","v":183961.27362486461},{"$f":"DAV!Z35/1000","v":184388.46332450476},{"$f":"DAV!AA35/1000","v":184627.32279830796},{"$f":"DAV!AB35/1000","v":184771.18409141322},{"$f":"DAV!AC35/1000","v":184332.07847092435},{"$f":"DAV!AD35/1000","v":183625.23683559094},{"$f":"DAV!AE35/1000","v":182771.56850222658},{"$f":"DAV!AF35/1000","v":181264.24849017826},{"$f":"DAV!AG35/1000","v":179530.94577103175},{"$f":"DAV!AH35/1000","v":177409.95799090739},{"$f":"DAV!AI35/1000","v":174822.05352388558},{"$f":"DAV!AJ35/1000","v":172054.4244175849},{"$f":"DAV!AK35/1000","v":169085.06642089511},{"$f":"DAV!AL35/1000","v":165897.19753123063},{"$f":"DAV!AM35/1000","v":162504.59716564423},{"$f":"DAV!AN35/1000","v":158925.86388482738},{"$f":"DAV!AO35/1000","v":155102.88791757321},{"$f":"DAV!AP35/1000","v":150994.92713468411},{"$f":"DAV!AQ35/1000","v":146815.44855470123},{"$f":"DAV!AR35/1000","v":142417.89407625623}]
[]
[]
[]
["TRV",null,{"$f":"-C65","v":-143802.85904978559}]
["Discounted DAV2045",null,{"$f":"AF45*AF8","v":41773.877259006847}]
["Backsolve to 0 by running Macro Ctrl + q",null,{"$f":"SUM(C41:C50)","v":0}]
[]
[]
[]
["Condition 4.6.8 Calculating TRV"]
[]
[null,"Total Regulatory Value (TRV)",null,null,null,null,null,null,{"$f":"I67+I69","v":201176.38006388021},null,null,null,null,{"$f":"N67+N69","v":222916.75935869501},null,null,null,null,{"$f":"S67+S69","v":216463.27264163599},null,null,null,null,{"$f":"X67+X69","v":195138.24147414783},null,null,null,null,{"$f":"AC67+AC69","v":165214.90727029624},null,null,{"$f":"AF67+AF69","v":142417.89407625623}]
[]
[]
[]
["Condition 4.6.9 Calculating Profile Adjustment"]
[null,null,null,null,null,null,null,null,"x",null,null,null,null,"x",null,null,null,null,"x",null,null,null,null,"x",null,null,null,null,"x",null,null,"x"]
[null,"Adjusted Cashflows",null,{"$f":"D37*(1+$I$6*$B$7)*(1+$I$6)^($I$12-D12)","v":-6779.6304072710109},-3070.8571715193762,-2305.0418958150667,-1691.7833776611424,-1202.1925482776244,-785.23917912803051,{"$f":"J37*(1+$N$6*$B$7)*(1+$N$6)^($N$12-J12)","v":1774.4944429338871},{"$f":"K37*(1+$N$6*$B$7)*(1+$N$6)^($N$12-K12)","v":3482.2080177742682},{"$f":"L37*(1+$N$6*$B$7)*(1+$N$6)^($N$12-L12)","v":3788.1532770664217},{"$f":"M37*(1+$N$6*$B$7)*(1+$N$6)^($N$12-M12)","v":7063.5581950886353},{"$f":"N37*(1+$N$6*$B$7)*(1+$N$6)^($N$12-N12)","v":9525.4640998378418},{"$f":"O37*(1+$S$6*$B$7)*(1+$S$6)^($S$12-O12)","v":11785.173461223276},{"$f":"P37*(1+$S$6*$B$7)*(1+$S$6)^($S$12-P12)","v":11570.361865509325},{"$f":"Q37*(1+$S$6*$B$7)*(1+$S$6)^($S$12-Q12)","v":11964.216770400291},{"$f":"R37*(1+$S$6*$B$7)*(1+$S$6)^($S$12-R12)","v":11857.833442016712},{"$f":"S37*(1+$S$6*$B$7)*(1+$S$6)^($S$12-S12)","v":11769.717385962449},{"$f":"T37*(1+$X$6*$B$7)*(1+$X$6)^($X$12-T12)","v":14963.937450321779},{"$f":"U37*(1+$X$6*$B$7)*(1+$X$6)^($X$12-U12)","v":14790.248112055024},{"$f":"V37*(1+$X$6*$B$7)*(1+$X$6)^($X$12-V12)","v":14523.521114061952},{"$f":"W37*(1+$X$6*$B$7)*(1+$X$6)^($X$12-W12)","v":14327.361730429489},{"$f":"X37*(1+$X$6*$B$7)*(1+$X$6)^($X$12-X12)","v":13694.072031424221},{"$f":"Y37*(1+$AC$6*$B$7)*(1+$AC$6)^($AC$12-Y12)","v":16409.588861111351},{"$f":"Z37*(1+$AC$6*$B$7)*(1+$AC$6)^($AC$12-Z12)","v":15909.578070501064},{"$f":"AA37*(1+$AC$6*$B$7)*(1+$AC$6)^($AC$12-AA12)","v":15193.999218034332},{"$f":"AB37*(1+$AC$6*$B$7)*(1+$AC$6)^($AC$12-AB12)","v":14374.882387733687},{"$f":"AC37*(1+$AC$6*$B$7)*(1+$AC$6)^($AC$12-AC12)","v":13987.644800777851},{"$f":"AD37*(1+$AF$6*$B$7)*(1+$AF$6)^($AF$12-AD12)","v":15576.391021212623},{"$f":"AE37*(1+$AF$6*$B$7)*(1+$AF$6)^($AF$12-AE12)","v":15012.170618647549},{"$f":"AF37*(1+$AF$6*$B$7)*(1+$AF$6)^($AF$12-AF12)","v":14558.615426923641}]
[]
[null,"Closing TRV (Incl Return)",{"$f":"Inputs!O128/1000","v":143802.85904978559},null,null,null,null,null,{"$f":"-$C$65*(1+I6)^(I12-C12)","v":-185341.63548420795},null,null,null,null,{"$f":"-I57*(1+N6)^(N12-I12)","v":-248550.63739139607},null,null,null,null,{"$f":"-N57*(1+S6)^(S12-N12)","v":-275410.57556674804},null,null,null,null,{"$f":"-S57*(1+X6)^(X12-S12)","v":-267437.38191244029},null,null,null,null,{"$f":"-X57*(1+AC6)^(AC12-X12)","v":-241090.60060845455},null,null,{"$f":"-AC57*(1+AF6)^(AF12-AC12)","v":-187565.07114304006}]
[]
[null,"DAV",null,null,null,null,null,null,{"$f":"I45","v":162794.93079279375},null,null,null,null,{"$f":"N45","v":184388.46332450476},null,null,null,null,{"$f":"S45","v":182771.56850222658},null,null,null,null,{"$f":"X45","v":172054.4244175849},null,null,null,null,{"$f":"AC45","v":155102.88791757321},null,null,{"$f":"AF45","v":142417.89407625623}]
[]
[null,"Calculated PA",null,null,null,null,null,null,{"$f":"-SUM(D63:I68)","v":38381.449271086458},null,null,null,null,{"$f":"-SUM(J63:N68)","v":38528.296034190251},null,null,null,null,{"$f":"-SUM(O63:S68)","v":33691.704139409412},null,null,null,null,{"$f":"-SUM(T63:X68)","v":23083.817056562926},null,null,null,null,{"$f":"-SUM(Y63:AC68)","v":10112.019352723029},null,null,{"$f":"-SUM(AD63:AF68)","v":0}]
[null,"Check",null,null,null,null,null,null,{"$f":"SUM(D63:I69)","v":0},null,null,null,null,{"$f":"SUM(J63:N69)","v":0},null,null,null,null,{"$f":"SUM(O63:S69)","v":0},null,null,null,null,{"$f":"SUM(T63:X69)","v":0},null,null,null,null,{"$f":"SUM(Y63:AC69)","v":0},null,null,{"$f":"SUM(AD63:AF69)","v":-2.9103830456733704E-11}]
[]
[]
[null,"Annual Basis"]
[null,"Cashflow",null,{"$f":"+'Building Block Method'!C9","v":-5487.4190540016098},{"$f":"+'Building Block Method'!D9","v":-8317.3966696129155},{"$f":"+'Building Block Method'!E9","v":-10707.082415343479},{"$f":"+'Building Block Method'!F9","v":-12724.195921272536},{"$f":"+'Building Block Method'!G9","v":-14426.289686104508},{"$f":"+'Building Block Method'!H9","v":-15834.744579672253}]
[null,"Opening TRV incl. return",null,{"$f":"-$C65/D$8","v":-150015.14256073631},{"$f":"-$C65/E$8","v":-156495.79671936011},-163256.41513763642,-170309.09227158231,-177666.44505771465,-185341.63548420792]
[null,"DAV ",null,{"$f":"+D45","v":118159.38604723224},{"$f":"+E45","v":127427.94236768414},136460.04156504493,145301.76944698038,154032.97148279884,162794.93079279375]
[null,"Q"]
[null,"CC"]
[null,"PA ",{"$f":"+C81-DAV!O35/1000","v":38140.206074230213},{"$f":"-SUM(D74:D78)","v":37343.175567505663},{"$f":"-SUM(E74:E78)","v":37385.251021288874},37503.455987934954,37731.518745874462,38059.763261020329,38381.449271086429]
[]
[null,"TRV",{"$f":"+C65","v":143802.85904978559},{"$f":"SUM(D76:D79)","v":155502.5616147379},164813.19338897301,173963.49755297988,183033.28819285484,192092.73474381916,201176.38006388018]

{"sheet":"FE Financeability","index":4,"n_rows":67,"n_cols":29,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
["Firmus: Financeability Model"]
["Av. £k's 2014 RPI and nominal"]
[]
[null,"Include"]
[null,"Exclude",null,null,null,null,null,null,null,null,null,null,2014,2015,2016,2017,2018,2019,2020,2021,2022,null,null,null,null,"Generic assumptions"]
[null,"Financeability analysis (nominal)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rolling incentive period",null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,256,258.5,{"$f":"+'FE Financeability'!AB7","v":3.0700000000000002E-2},{"$f":"+'FE Financeability'!AB7","v":3.0700000000000002E-2},{"$f":"+P7","v":3.0700000000000002E-2},3.0700000000000002E-2,3.0700000000000002E-2,3.0700000000000002E-2,3.0700000000000002E-2,null,null,null,null,"Forward inflation rate",null,3.0700000000000002E-2]
[null,"RPI factor",null,null,null,null,null,null,null,null,null,null,1,{"$f":"+N7/M7","v":1.009765625},{"$f":"N8*(1+O7)","v":1.0407654296875},{"$f":"O8*(1+P7)","v":1.0727169283789062},1.1056493380801387,1.1395927727591988,1.1745782708829062,1.2106378237990114,1.2478044049896411,null,null,null,null,"Prospective tax rate",null,0.2]
[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,"Year dividends can start",null,2017]
[null,"Revenues",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+'GD17 Pi''s Calc - 40 yrs'!D33*P8","v":19200.628843507475},{"$f":"+'GD17 Pi''s Calc - 40 yrs'!E33*Q8","v":19759.492230198757},{"$f":"+'GD17 Pi''s Calc - 40 yrs'!F33*R8","v":21346.208375771283},{"$f":"+'GD17 Pi''s Calc - 40 yrs'!G33*S8","v":23064.875045448247},{"$f":"+'GD17 Pi''s Calc - 40 yrs'!H33*T8","v":24916.584846104695},{"$f":"+'GD17 Pi''s Calc - 40 yrs'!I33*U8","v":26910.662099582638},null,null,null,null,"CAs as % of core depreciation",null,1]
[null,"Underrecoveries","Exclude",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C11=B4,5000,0)","v":0},{"$f":"IF(C11=B4,5000,0)","v":0},{"$f":"IF(C11=B4,5000,0)","v":0},null,null,null,null,null,null,null,"Threshold PMICR",null,1.4]
[null,"Opex",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+'GD17 Pi''s Calc - 40 yrs'!D35*P8","v":-6865.8478385248727},{"$f":"+'GD17 Pi''s Calc - 40 yrs'!E35*Q8","v":-7025.7283423259896},{"$f":"+'GD17 Pi''s Calc - 40 yrs'!F35*R8","v":-7400.6885370584405},{"$f":"+'GD17 Pi''s Calc - 40 yrs'!G35*S8","v":-7857.3529828414867},{"$f":"+'GD17 Pi''s Calc - 40 yrs'!H35*T8","v":-8403.1308322279365},{"$f":"+'GD17 Pi''s Calc - 40 yrs'!I35*U8","v":-9052.5334253845231}]
[null,"Movements in working capital",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Outturn and financial assumptions",null,"FE"]
[null,"Core asset depreciation",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"-DAV!P29*P8/1000","v":-4691.3122532432817},{"$f":"-DAV!Q29*Q8/1000","v":-5292.2373126665043},{"$f":"-DAV!R29*R8/1000","v":-5917.4832723383843},{"$f":"-DAV!S29*S8/1000","v":-6609.5750199533813},{"$f":"-DAV!T29*T8/1000","v":-7308.7818348424798},{"$f":"-DAV!U29*U8/1000","v":-7884.0254210563417},null,null,null,null,"Initial debt as % of TRV",null,0.55000000000000004]
[null,"Profile adjustment",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(+'GD17 Pi''s Calc - 40 yrs'!D79-'GD17 Pi''s Calc - 40 yrs'!C79)*P8","v":-854.98811699784233},{"$f":"(+'GD17 Pi''s Calc - 40 yrs'!E79-'GD17 Pi''s Calc - 40 yrs'!D79)*Q8","v":46.520697624828522},{"$f":"(+'GD17 Pi''s Calc - 40 yrs'!F79-'GD17 Pi''s Calc - 40 yrs'!E79)*R8","v":134.70552569411575},{"$f":"(+'GD17 Pi''s Calc - 40 yrs'!G79-'GD17 Pi''s Calc - 40 yrs'!F79)*S8","v":267.8775598733738},{"$f":"(+'GD17 Pi''s Calc - 40 yrs'!H79-'GD17 Pi''s Calc - 40 yrs'!G79)*T8","v":397.38522549015397},{"$f":"(+'GD17 Pi''s Calc - 40 yrs'!I79-'GD17 Pi''s Calc - 40 yrs'!H79)*U8","v":401.4012203840212},null,null,null,null,"Nominal interest rate",null,5.6000000000000001E-2]
[null,"Tax (prior year)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"-P47","v":0},0,-382.65575196560746,-407.32941610485955,-393.51416006165834,-406.1485636404239,null,null,null,null,"Year tax payments start",null,2018,"note: to reflect approximate time when tax losses are fully utilised"]
[null,"Post-maintenance FFO",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P10:P16)","v":6788.4806347414778},7488.0472728310906,7780.0863401029665,8458.4951864218929,9208.5432444627731,9969.355909885373]
[]
[null,"PMICR",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P17/P49","v":1.3818687927202615},1.3796369898968566,1.3222000612362268,1.3321944541592505,1.3511052967938049,1.3685300461504519]
[]
[null,"Maximum interest consistent with dividends",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P17/'FE Financeability'!$AB$11","v":4848.9147391010556},{"$f":"Q17/'FE Financeability'!$AB$11","v":5348.6051948793511},{"$f":"R17/'FE Financeability'!$AB$11","v":5557.2045286449766},{"$f":"S17/'FE Financeability'!$AB$11","v":6041.7822760156378},{"$f":"T17/'FE Financeability'!$AB$11","v":6577.5308889019816},{"$f":"U17/'FE Financeability'!$AB$11","v":7120.9685070609812}]
[null,"Implied maximum debt level (pre interest)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"2*P21/IntFE-P41","v":88332.657707871331},95504.220729813664,94720.401416986962,103495.01784937644,114084.91836095526,124918.6763298071]
[]
[null,"Tax"]
[null,"Revenues",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P10+P11","v":19200.628843507475},{"$f":"Q10+Q11","v":19759.492230198757},21346.208375771283,23064.875045448247,24916.584846104695,26910.662099582638]
[null,"Under Recoveries","Exclude",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C26=B4,5000,0)","v":0},{"$f":"IF(C26=B4,5000,0)","v":0},{"$f":"IF(C26=B4,5000,0)","v":0}]
[null,"Opex",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+P12","v":-6865.8478385248727},-7025.7283423259896,-7400.6885370584405,-7857.3529828414867,-8403.1308322279365,-9052.5334253845231]
[null,"Interest",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"-P49","v":-4912.5363207443843},-5427.5489332820125,-5884.1975342436181,-6349.2946994439026,-6815.5629811494318,-7284.7183282005726]
[null,"Capital allowances",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P14*'FE Financeability'!$AB$10","v":-4691.3122532432817},{"$f":"Q14*'FE Financeability'!$AB$10","v":-5292.2373126665043},{"$f":"R14*'FE Financeability'!$AB$10","v":-5917.4832723383843},{"$f":"S14*'FE Financeability'!$AB$10","v":-6609.5750199533813},{"$f":"T14*'FE Financeability'!$AB$10","v":-7308.7818348424798},{"$f":"U14*'FE Financeability'!$AB$10","v":-7884.0254210563417}]
[null,"Losses",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P5<TaxYearFE,-SUM(P25:P29),0)","v":-2730.9324309949361},0,0,0,0,0]
[null,"Taxable profits",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P25:P30)","v":0},2013.9776419242498,2143.8390321308398,2248.6523432094764,2389.1091978848463,2689.3849249412033]
[null,"Tax payable",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P31*P67","v":0},382.65575196560746,407.32941610485955,393.51416006165834,406.1485636404239,457.19543724000459]
[]
[null,"Dividends"]
[null,"Maximum dividend payout (% of initial equity)",null,null,null,null,null,null,null,null,null,null,null,null,null,5.28E-2]
[null,"Allowed dividend in year",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(+P54-P41)*P35","v":3665.2119273473013},{"$f":"+P36*(1+Q7)","v":3777.7339335168631},{"$f":"+Q36*(1+R7)","v":3893.7103652758306},{"$f":"+R36*(1+S7)","v":4013.2472734897983},{"$f":"+S36*(1+T7)","v":4136.4539647859347},{"$f":"+T36*(1+U7)","v":4263.4431015048631}]
[null,"Dividend available",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P36+(O37-O38)*(1+'FE Financeability'!$AB$7)*(1+$P$35)","v":3665.2119273473013},{"$f":"Q36+(P37-P38)*(1+'FE Financeability'!$AB$7)*(1+$P$35)","v":7754.9322187234166},{"$f":"R36+(Q37-Q38)*(1+'FE Financeability'!$AB$7)*(1+$P$35)","v":12308.749859191914},{"$f":"S36+(R37-R38)*(1+'FE Financeability'!$AB$7)*(1+$P$35)","v":17369.729737095993},{"$f":"T36+(S37-S38)*(1+'FE Financeability'!$AB$7)*(1+$P$35)","v":22984.711772044084},{"$f":"U36+(T37-T38)*(1+'FE Financeability'!$AB$7)*(1+$P$35)","v":29204.635604908639}]
[null,"Dividend Paid",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P5<'FE Financeability'!$AB$9,0,MIN(MAX(0,P22-SUM(P41:P47)),P37))","v":0},{"$f":"IF(Q5<'FE Financeability'!$AB$9,0,MIN(MAX(0,Q22-SUM(Q41:Q47)),Q37))","v":0},{"$f":"IF(R5<'FE Financeability'!$AB$9,0,MIN(MAX(0,R22-SUM(R41:R47)),R37))","v":0},{"$f":"IF(S5<'FE Financeability'!$AB$9,0,MIN(MAX(0,S22-SUM(S41:S47)),S37))","v":0},{"$f":"IF(T5<'FE Financeability'!$AB$9,0,MIN(MAX(0,T22-SUM(T41:T47)),T37))","v":0},{"$f":"IF(U5<'FE Financeability'!$AB$9,0,MIN(MAX(0,U22-SUM(U41:U47)),U37))","v":0}]
[]
[null,"Debt"]
[null,"Debt at the start of the year",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+'GD17 Pi''s Calc - 40 yrs'!C81*DebtFE*'FE Financeability'!P8","v":84842.868688594943},{"$f":"+P50","v":95517.393373020299},{"$f":"+Q50","v":103751.18889176218},{"$f":"+R50","v":112282.92057975348},{"$f":"+S50","v":120826.89909982978},{"$f":"+T50","v":129401.62749379936}]
[null,"Revenues",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"-P10","v":-19200.628843507475},{"$f":"-Q10","v":-19759.492230198757},-21346.208375771283,-23064.875045448247,-24916.584846104695,-26910.662099582638]
[null,"Under Recoveries","Exclude",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C43=B4,-5000,0)","v":0},{"$f":"IF(C43=B4,-5000,0)","v":0},{"$f":"IF(C43=B4,-5000,0)","v":0}]
[null,"Opex",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"-P27","v":6865.8478385248727},7025.7283423259896,7400.6885370584405,7857.3529828414867,8403.1308322279365,9052.5334253845231]
[null,"Movements in working capital",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+P13","v":0},0,0,0,0,0]
[null,"Investment",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+DAV!P14*'FE Financeability'!P8/1000","v":18096.769368663579},{"$f":"+DAV!Q14*'FE Financeability'!Q8/1000","v":15540.010473332633},{"$f":"+DAV!R14*'FE Financeability'!R8/1000","v":16210.398240494926},{"$f":"+DAV!S14*'FE Financeability'!S8/1000","v":16994.876467134309},{"$f":"+DAV!T14*'FE Financeability'!T8/1000","v":17879.105266635248},{"$f":"+DAV!U14*'FE Financeability'!U8/1000","v":18817.236844407991}]
[null,"Tax (prior year)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O32","v":0},0,382.65575196560746,407.32941610485955,393.51416006165834,406.1485636404239]
[null,"Dividends",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P38","v":0},0,0,0,0,0]
[null,"Interest",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(P41+SUM(P42:P48)/2)*IntFE","v":4912.5363207443843},5427.5489332820125,5884.1975342436181,6349.2946994439026,6815.5629811494318,7284.7183282005726]
[null,"Debt at the end of the year",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P41:P49)","v":95517.393373020299},103751.18889176218,112282.92057975348,120826.89909982978,129401.62749379936,138051.60255585023]
[]
[null,"Average debt",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(P50,P41)","v":90180.131030807621},99634.291132391241,108017.05473575783,116554.90983979162,125114.26329681458,133726.6150248248]
[]
[null,"TRV at start of year (mid-year RPI)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+'GD17 Pi''s Calc - 40 yrs'!C81*'FE Financeability'!P8","v":154259.7612519908},{"$f":"+'GD17 Pi''s Calc - 40 yrs'!D81*'FE Financeability'!Q8","v":171931.30431910095},{"$f":"+'GD17 Pi''s Calc - 40 yrs'!E81*'FE Financeability'!R8","v":187819.9240414378},{"$f":"+'GD17 Pi''s Calc - 40 yrs'!F81*'FE Financeability'!S8","v":204333.7441525218},{"$f":"+'GD17 Pi''s Calc - 40 yrs'!G81*'FE Financeability'!T8","v":221587.02170057507},{"$f":"+'GD17 Pi''s Calc - 40 yrs'!H81*'FE Financeability'!U8","v":239694.16057984423}]
[null,"TRV at end of year (mid-year RPI)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+'GD17 Pi''s Calc - 40 yrs'!D81*'FE Financeability'!P8","v":166810.23025041324},{"$f":"+'GD17 Pi''s Calc - 40 yrs'!E81*'FE Financeability'!Q8","v":182225.59817739189},{"$f":"+'GD17 Pi''s Calc - 40 yrs'!F81*'FE Financeability'!R8","v":198247.54453528844},{"$f":"+'GD17 Pi''s Calc - 40 yrs'!G81*'FE Financeability'!S8","v":214986.92315957611},{"$f":"+'GD17 Pi''s Calc - 40 yrs'!H81*'FE Financeability'!T8","v":232554.73035785797},{"$f":"+'GD17 Pi''s Calc - 40 yrs'!I81*'FE Financeability'!U8","v":251028.77322357989}]
[null,"Average TRV",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(P54:P55)","v":160534.99575120202},{"$f":"AVERAGE(Q54:Q55)","v":177078.45124824642},193033.73428836314,209660.33365604896,227070.87602921651,245361.46690171206]
[null,"PM-FFO as % TRV",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P17/P56","v":4.2286609240407003E-2},4.228660924040719E-2,4.0304283439290961E-2,4.0343802945092065E-2,4.0553607778735741E-2,4.0631302199863925E-2]
[null,"Gearing ratio",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P52/P56","v":0.56174749068775798},0.56265621497171248,0.55957605096317897,0.55592256201882118,0.55099211966186501,0.54501881128055685]
[]
[null,"Other relevant metrics"]
[null,"FFO/Net Debt",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(P10+P26+P12+P16-P49)/P52","v":8.2304656240770005E-2},{"$f":"(Q10+Q26+Q12+Q16-Q49)/Q52","v":7.3330325047251663E-2},7.1087538641818576E-2,7.2505722484569907E-2,7.4367035600029441E-2,7.6030203714269481E-2]
[null,"FFO Interest Cover",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM((P10+P26+P12+P16-P49)+P49)/P49","v":2.5108783324198494},{"$f":"SUM((Q10+Q26+Q12+Q16-Q49)+Q49)/Q49","v":2.3461352526531201},2.3049641022105267,2.3309979056096046,2.3651662963719695,2.3956973110405184]
[null,"RCF/Capex",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM((P10+P26+P12+P16-P49)-P38)/P46","v":0.41014197247220263},{"$f":"SUM((Q10+Q26+Q12+Q16-Q49)-Q38)/Q46","v":0.47015508561777047},0.47368771812907517,0.4972615107500688,0.52040506132199205,0.54031640598596042]
[null,"FE PMICR ",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(P10+P26+P12-P46+P50-P41+P16+P13)/P49","v":0.99999999999999778},{"$f":"(Q10+Q26+Q12-Q46+Q50-Q41+Q16+Q13)/Q49","v":1.0000000000000004},0.99999999999999756,0.99999999999999833,1.0000000000000002,1.000000000000002]
[]
[null,"Financial Year Corporation Tax Rate",null,null,null,null,null,null,null,null,null,null,null,null,null,0.19,0.19,0.19,0.17,0.17,0.17]
[null,"Calendar Year Corporation Tax Rate",null,null,null,null,null,null,null,null,null,null,null,null,null,0.1925,0.19,0.19,0.17499999999999999,0.17,0.17]

{"sheet":"Building Block Method","index":5,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
["Building Block Method"]
[]
["Year:",null,2017,{"$f":"C4+1","v":2018},{"$f":"D4+1","v":2019},2020,2021,2022]
["Opening:",null,0,{"$f":"+C9","v":-5487.4190540016098},{"$f":"+D9","v":-8317.3966696129155},{"$f":"+E9","v":-10707.082415343479},{"$f":"+F9","v":-12724.195921272536},{"$f":"+G9","v":-14426.289686104508}]
["Cshflow:",null,{"$f":"'GD17 Pi''s Calc - 40 yrs'!D37","v":-5371.3968813641441},{"$f":"'GD17 Pi''s Calc - 40 yrs'!E37","v":-2538.0981915411485},{"$f":"'GD17 Pi''s Calc - 40 yrs'!F37","v":-1987.4453891966386},{"$f":"'GD17 Pi''s Calc - 40 yrs'!G37","v":-1521.6988504172068},{"$f":"'GD17 Pi''s Calc - 40 yrs'!H37","v":-1128.0427770487458},{"$f":"'GD17 Pi''s Calc - 40 yrs'!I37","v":-768.63662796400786}]
["Return on in year cashflow:",null,{"$f":"+C6*'GD17 Pi''s Calc - 40 yrs'!D6*'GD17 Pi''s Calc - 40 yrs'!$B7","v":-116.02217263746552},{"$f":"+D6*'GD17 Pi''s Calc - 40 yrs'!E6*'GD17 Pi''s Calc - 40 yrs'!$B7","v":-54.822920937288814},{"$f":"+E6*'GD17 Pi''s Calc - 40 yrs'!F6*'GD17 Pi''s Calc - 40 yrs'!$B7","v":-42.928820406647397},{"$f":"+F6*'GD17 Pi''s Calc - 40 yrs'!G6*'GD17 Pi''s Calc - 40 yrs'!$B7","v":-32.868695169011666},{"$f":"+G6*'GD17 Pi''s Calc - 40 yrs'!H6*'GD17 Pi''s Calc - 40 yrs'!$B7","v":-24.365723984252913},{"$f":"+H6*'GD17 Pi''s Calc - 40 yrs'!I6*'GD17 Pi''s Calc - 40 yrs'!$B7","v":-16.602551164022572}]
["Return on in year opening:",null,{"$f":"+C5*'GD17 Pi''s Calc - 40 yrs'!D6","v":0},{"$f":"+D5*'GD17 Pi''s Calc - 40 yrs'!E6","v":-237.05650313286955},{"$f":"+E5*'GD17 Pi''s Calc - 40 yrs'!F6","v":-359.31153612727798},{"$f":"+F5*'GD17 Pi''s Calc - 40 yrs'!G6","v":-462.54596034283833},{"$f":"+G5*'GD17 Pi''s Calc - 40 yrs'!H6","v":-549.68526379897355},{"$f":"+H5*'GD17 Pi''s Calc - 40 yrs'!I6","v":-623.21571443971482}]
["Closing:",null,{"$f":"SUM(C5:C8)","v":-5487.4190540016098},-8317.3966696129155,-10707.082415343479,-12724.195921272536,-14426.289686104508,-15834.744579672253]