{"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,9337051.6389023922,9058446.7985165175,8925843.7885425873,8915125.1064422615,8998069.8852982726,9026202.663719859,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,3217111.5213252585,3491144.1919132471,3760834.6534316181,3990881.9717900185,4217761.6154586468,4357735.3372857664,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,921167.00594398438,994707.53568836651,1067728.235583693,1133622.7235087822,1200718.2960644646,1249057.0756896459,1268690.7187431997,1288459.0181009609,1288801.1385377592,1354740.2453143131,1433861.0653467497,1516831.7111606519,1542842.9047945638,1593662.4722593261,1761731.8951755881,1902751.0994495961,1881408.5023967712,1878569.3240364045,1872505.0511628173,1827954.5000650408,1877972.286247924,1937154.042464684,1995969.7190637079,2044889.2663933823,2093442.7341053204,2122570.0228962954,2056030.7355534022,2065731.8454234144,2036946.6770692377]
["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/M1*M2","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":17021203.686311975},{"$f":"SUM(Q83:Q94)","v":14216331.127065742},14411628.55969137,14691507.886325758,15040587.262384515,{"$f":"SUM(U83:U94)","v":15263536.638526972},13494089.623019325,12660107.900244487,12869613.808517333,10299121.531919429,8046899.9454752347,8046777.4951584768,8185352.2894158931,7805560.0028095618,7756672.5771309314,7831927.8418165697,7372662.4423301956,7328344.3161791405,7125811.4383598957,6817976.0218152367,6824556.1896889303,6786079.3594583189,6731004.9477629857,6680980.5619281139,6662017.2547438806,6543529.2121617058,6343851.6595226703,6370917.7075975109,6256315.3798998781]
[]
["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,6334386.0275065359,6293113.2704177871,6445597.5121211382,6656073.1894411305,6929350.9224953353,7205284.4186704941,7397470.4122668877,7498577.7459669979,7584873.3903372055,7674486.9345203014,7835200.125664534,8039074.9761723923,8151088.1550714802,8248818.3843041863,8311137.9240282578,8247445.512845533,8152646.5343082082,8137499.9675737498,8256464.7075646939,8449928.0031555127,8668512.9785760194,8742688.0128671732,8746768.2499520555,8995917.2417841777,9253073.8344431277,9240833.289249409,9090735.131322708,9038035.8390327003,8958412.8104273845]
[]
["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,11228403.378270078,12779500.989018295,14462359.280580208,16267497.011711972,18185433.057793058,20197186.038751334,22038984.862112332,23793384.195931971,25471148.318651419,27086070.180901729,28567207.212223012,29962673.191744193,31228311.769484412,32414365.345344577,33477386.578730002,34482468.170795672,35386438.888851844,36235622.984059706,37004489.436109841,37737956.427083813,38377424.423116535,38967408.475897767,39483329.200000688,39968316.510583945,40381923.830349766,40766399.019907035,41082121.907651722,41385829.452767648,41638237.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":61980126.268008873},{"$f":"SUM(Q109:Q114)","v":60443233.17143859},{"$f":"SUM(R109:R114)","v":62622546.114643574},{"$f":"SUM(S109:S114)","v":64913305.905555233},{"$f":"SUM(T109:T114)","v":67306198.425925076},{"$f":"SUM(U109:U114)","v":69782407.045184851},{"$f":"SUM(V109:V114)","v":71706054.774459943},{"$f":"SUM(W109:W114)","v":73510596.576368988},{"$f":"SUM(X109:X114)","v":75021763.423009202},{"$f":"SUM(Y109:Y114)","v":76693031.52565439},{"$f":"SUM(Z109:Z114)","v":77976119.279206783},{"$f":"SUM(AA109:AA114)","v":79338551.701417938},{"$f":"SUM(AB109:AB114)","v":80329870.505639672},{"$f":"SUM(AC109:AC114)","v":81411230.98422268},{"$f":"SUM(AD109:AD114)","v":82139494.657464832},{"$f":"SUM(AE109:AE114)","v":82982369.07994324},{"$f":"SUM(AF109:AF114)","v":83503781.798622862},{"$f":"SUM(AG109:AG114)","v":84144534.048435912},{"$f":"SUM(AH109:AH114)","v":84493126.724193707},{"$f":"SUM(AI109:AI114)","v":84980945.174969748},{"$f":"SUM(AJ109:AJ114)","v":85170469.407125071},{"$f":"SUM(AK109:AK114)","v":85484774.181087017},{"$f":"SUM(AL109:AL114)","v":85527498.785496801},{"$f":"SUM(AM109:AM114)","v":85712507.191316947},{"$f":"SUM(AN109:AN114)","v":85634783.756660312},{"$f":"SUM(AO109:AO114)","v":85699550.112197325},{"$f":"SUM(AP109:AP114)","v":85509887.710746318},{"$f":"SUM(AQ109:AQ114)","v":85477799.218189597},85214019.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":11768984.035018897},{"$f":"SUM(Inputs!Q83,Inputs!Q85,Inputs!Q94)","v":9058446.7985165175},{"$f":"SUM(Inputs!R83,Inputs!R85,Inputs!R94)","v":8925843.7885425873},{"$f":"SUM(Inputs!S83,Inputs!S85,Inputs!S94)","v":8915125.1064422615},{"$f":"SUM(Inputs!T83,Inputs!T85,Inputs!T94)","v":8998069.8852982726},{"$f":"SUM(Inputs!U83,Inputs!U85,Inputs!U94)","v":9026202.663719859},{"$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":3509119.6935038837},{"$f":"SUM(Inputs!Q86,Inputs!Q88,Inputs!Q90)","v":3780654.4819553969},{"$f":"SUM(Inputs!R86,Inputs!R88,Inputs!R90)","v":4047912.8114302121},{"$f":"SUM(Inputs!S86,Inputs!S88,Inputs!S90)","v":4276083.8794347057},{"$f":"SUM(Inputs!T86,Inputs!T88,Inputs!T90)","v":4501099.5353172775},{"$f":"SUM(Inputs!U86,Inputs!U88,Inputs!U90)","v":4639221.4517819965},{"$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":1164532.5260240894},{"$f":"SUM(Inputs!Q84,Inputs!Q87,Inputs!Q89,Inputs!Q91,Inputs!Q92)","v":1250444.1103770402},{"$f":"SUM(Inputs!R84,Inputs!R87,Inputs!R89,Inputs!R91,Inputs!R92)","v":1313314.0520593633},{"$f":"SUM(Inputs!S84,Inputs!S87,Inputs!S89,Inputs!S91,Inputs!S92)","v":1376555.0631457407},{"$f":"SUM(Inputs!T84,Inputs!T87,Inputs!T89,Inputs!T91,Inputs!T92)","v":1427781.0522273181},{"$f":"SUM(Inputs!U84,Inputs!U87,Inputs!U89,Inputs!U91,Inputs!U92)","v":1485218.4269300259},{"$f":"SUM(Inputs!V84,Inputs!V87,Inputs!V89,Inputs!V91,Inputs!V92)","v":1474071.5148297832},{"$f":"SUM(Inputs!W84,Inputs!W87,Inputs!W89,Inputs!W91,Inputs!W92)","v":1509756.6678344496},{"$f":"SUM(Inputs!X84,Inputs!X87,Inputs!X89,Inputs!X91,Inputs!X92)","v":1519949.0245515392},{"$f":"SUM(Inputs!Y84,Inputs!Y87,Inputs!Y89,Inputs!Y91,Inputs!Y92)","v":1655449.8744528834},{"$f":"SUM(Inputs!Z84,Inputs!Z87,Inputs!Z89,Inputs!Z91,Inputs!Z92)","v":1774887.9899246478},{"$f":"SUM(Inputs!AA84,Inputs!AA87,Inputs!AA89,Inputs!AA91,Inputs!AA92)","v":2022070.2474988643},{"$f":"SUM(Inputs!AB84,Inputs!AB87,Inputs!AB89,Inputs!AB91,Inputs!AB92)","v":2322683.1344627086},{"$f":"SUM(Inputs!AC84,Inputs!AC87,Inputs!AC89,Inputs!AC91,Inputs!AC92)","v":2192557.29240209},{"$f":"SUM(Inputs!AD84,Inputs!AD87,Inputs!AD89,Inputs!AD91,Inputs!AD92)","v":2349928.6763949664},{"$f":"SUM(Inputs!AE84,Inputs!AE87,Inputs!AE89,Inputs!AE91,Inputs!AE92)","v":2527812.3476213631},{"$f":"SUM(Inputs!AF84,Inputs!AF87,Inputs!AF89,Inputs!AF91,Inputs!AF92)","v":2273020.5350050968},{"$f":"SUM(Inputs!AG84,Inputs!AG87,Inputs!AG89,Inputs!AG91,Inputs!AG92)","v":2326350.6484764768},{"$f":"SUM(Inputs!AH84,Inputs!AH87,Inputs!AH89,Inputs!AH91,Inputs!AH92)","v":2175601.4697617982},{"$f":"SUM(Inputs!AI84,Inputs!AI87,Inputs!AI89,Inputs!AI91,Inputs!AI92)","v":2011871.9497628536},{"$f":"SUM(Inputs!AJ84,Inputs!AJ87,Inputs!AJ89,Inputs!AJ91,Inputs!AJ92)","v":2212739.9235556819},{"$f":"SUM(Inputs!AK84,Inputs!AK87,Inputs!AK89,Inputs!AK91,Inputs!AK92)","v":2272174.5253578587},{"$f":"SUM(Inputs!AL84,Inputs!AL87,Inputs!AL89,Inputs!AL91,Inputs!AL92)","v":2310075.5810670918},{"$f":"SUM(Inputs!AM84,Inputs!AM87,Inputs!AM89,Inputs!AM91,Inputs!AM92)","v":2354445.3668935737},{"$f":"SUM(Inputs!AN84,Inputs!AN87,Inputs!AN89,Inputs!AN91,Inputs!AN92)","v":2388957.4414725201},{"$f":"SUM(Inputs!AO84,Inputs!AO87,Inputs!AO89,Inputs!AO91,Inputs!AO92)","v":2413723.3451277753},{"$f":"SUM(Inputs!AP84,Inputs!AP87,Inputs!AP89,Inputs!AP91,Inputs!AP92)","v":2305669.0758567546},{"$f":"SUM(Inputs!AQ84,Inputs!AQ87,Inputs!AQ89,Inputs!AQ91,Inputs!AQ92)","v":2329814.2026689597},{"$f":"SUM(Inputs!AR84,Inputs!AR87,Inputs!AR89,Inputs!AR91,Inputs!AR92)","v":2307741.0574697419}]
["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":17021203.686311979},{"$f":"SUM(Q9:Q13)","v":14216331.127065741},{"$f":"SUM(R9:R13)","v":14411628.55969137},14691507.886325754,15040587.262384515,15263536.638526972,13494089.623019325,12660107.900244489,12869613.808517333,10299121.531919431,8046899.9454752347,8046777.4951584777,8185352.2894158941,7805560.0028095627,7756672.5771309324,7831927.8418165697,7372662.4423301937,7328344.3161791395,7125811.4383598967,6817976.0218152367,6824556.1896889312,6786079.3594583189,6731004.9477629866,6680980.5619281139,6662017.2547438806,6543529.2121617058,6343851.6595226703,6370917.70759751,6256315.3798998781]
["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,{"$f":"[8]Inputs!B50","v":"Mains"},{"$f":"Inputs!D132","v":1845762.7935014917}]
[null,null,{"$f":"[8]Inputs!B51","v":"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":2636739.8604012742},{"$f":"(SUM($D$9:Q9)/$C$24)","v":2863201.030364187},{"$f":"(SUM($D$9:R9)/$C$24)","v":3086347.1250777515},{"$f":"(SUM($D$9:S9)/$C$24)","v":3309225.2527388083},{"$f":"(SUM($D$9:T9)/$C$24)","v":3534176.9998712651},{"$f":"(SUM($D$9:U9)/$C$24)","v":3759832.0664642616},{"$f":"(SUM($D$9:V9)/$C$24)","v":3942854.7430195622},{"$f":"(SUM($D$9:W9)/$C$24)","v":4104911.0928274109},{"$f":"(SUM($D$9:X9)/$C$24)","v":4273972.1753330091},{"$f":"(SUM($D$9:Y9)/$C$24)","v":4379683.7028411608},{"$f":"(SUM($D$9:Z9)/$C$24)","v":4431156.3679852616},{"$f":"(SUM($D$9:AA9)/$C$24)","v":4482395.999082665},{"$f":"(SUM($D$9:AB9)/$C$24)","v":4533366.0912277307},{"$f":"(SUM($D$9:AC9)/$C$24)","v":4584107.7370075481},{"$f":"(SUM($D$9:AD9)/$C$24)","v":4634596.3075022092},{"$f":"(SUM($D$9:AE9)/$C$24)","v":4685073.9812972005},{"$f":"(SUM($D$9:AF9)/$C$24)","v":4735295.8068380076},{"$f":"(SUM($D$9:AG9)/$C$24)","v":4785514.3965272103},{"$f":"(SUM($D$9:AH9)/$C$24)","v":4835721.9903841214},{"$f":"(SUM($D$9:AI9)/$C$24)","v":4885922.1302971747},{"$f":"(SUM($D$9:AJ9)/$C$24)","v":4935898.7791788038},{"$f":"(SUM($D$9:AK9)/$C$24)","v":4985851.3632126087},{"$f":"(SUM($D$9:AL9)/$C$24)","v":5035797.8375381725},{"$f":"(SUM($D$9:AM9)/$C$24)","v":5085736.9325953852},{"$f":"(SUM($D$9:AN9)/$C$24)","v":5135633.0954094026},{"$f":"(SUM($D$9:AO9)/$C$24)","v":5185514.6046653446},{"$f":"(SUM($D$9:AP9)/$C$24)","v":5235349.7130469549},{"$f":"(SUM($D$9:AQ9)/$C$24)","v":5285360.4385990612},{"$f":"(SUM($D$9:AR9)/$C$24)","v":5335336.3138448857}]
["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":590007.14761151082},{"$f":"SUM($D$10:Q10)/$C$25","v":684523.50966039579},{"$f":"SUM($D$10:R10)/$C$25","v":785721.32994615112},{"$f":"SUM($D$10:S10)/$C$25","v":892623.42693201883},{"$f":"SUM($D$10:T10)/$C$25","v":1005150.9153149507},{"$f":"SUM($D$10:U10)/$C$25","v":1121131.4516095007},{"$f":"SUM($D$10:V10)/$C$25","v":1234418.9060557878},{"$f":"SUM($D$10:W10)/$C$25","v":1348173.7338016413},{"$f":"SUM($D$10:X10)/$C$25","v":1459906.6676386392},{"$f":"SUM($D$10:Y10)/$C$25","v":1567339.3283106026},{"$f":"SUM($D$10:Z10)/$C$25","v":1669719.3587987174},{"$f":"SUM($D$10:AA10)/$C$25","v":1766149.8056362546},{"$f":"SUM($D$10:AB10)/$C$25","v":1857556.1206618682},{"$f":"SUM($D$10:AC10)/$C$25","v":1944191.9393856884},{"$f":"SUM($D$10:AD10)/$C$25","v":2025924.3631528772},{"$f":"SUM($D$10:AE10)/$C$25","v":2105101.9734562174},{"$f":"SUM($D$10:AF10)/$C$25","v":2179423.5923419897},{"$f":"SUM($D$10:AG10)/$C$25","v":2251307.2410888043},{"$f":"SUM($D$10:AH10)/$C$25","v":2320664.5747436946},{"$f":"SUM($D$10:AI10)/$C$25","v":2387669.4333754024},{"$f":"SUM($D$10:AJ10)/$C$25","v":2450040.5878905552},{"$f":"SUM($D$10:AK10)/$C$25","v":2509988.0214527128},{"$f":"SUM($D$10:AL10)/$C$25","v":2567617.1780379969},{"$f":"SUM($D$10:AM10)/$C$25","v":2622893.8596000979},{"$f":"SUM($D$10:AN10)/$C$25","v":2675633.8704147139},{"$f":"SUM($D$10:AO10)/$C$25","v":2726049.9045780711},{"$f":"SUM($D$10:AP10)/$C$25","v":2774221.7575315596},{"$f":"SUM($D$10:AQ10)/$C$25","v":2822291.0163461184},{"$f":"SUM($D$10:AR10)/$C$25","v":2868081.8959044991}]
["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":933133.91393226734},{"$f":"SUM($E$11:Q11)/$C$26","v":1016496.85462407},{"$f":"SUM($E$11:R11)/$C$26","v":1104051.1247613609},{"$f":"SUM(E11:S11)/$C$26","v":1195821.4623044103},1258669.9236543169,1297197.8500390649,1267256.7895608102,1302304.3087066705,1333182.7014078267,1352121.6447805599,1371107.7889641593,1421787.8104492307,1503222.4227626596,1569179.1510888136,1655946.6435410338,1746831.9649808521,1815003.7266227226,1882539.4997171969,1935809.2601582671,{"$f":"SUM(U11:AI11)/$C$26","v":1974748.6533273035},{"$f":"SUM(V11:AJ11)/$C$26","v":2023250.0864356805},{"$f":"SUM(W11:AK11)/$C$26","v":2076456.9538042187},{"$f":"SUM(X11:AL11)/$C$26","v":2129811.5480197282},{"$f":"SUM(Y11:AM11)/$C$26","v":2185444.637509197},{"$f":"SUM(Z11:AN11)/$C$26","v":2234345.1419771728},{"$f":"SUM(AA11:AO11)/$C$26","v":2276934.1656573811},{"$f":"SUM(AB11:AP11)/$C$26","v":2295840.7542145741},{"$f":"SUM(AC11:AQ11)/$C$26","v":2296316.1587616573},{"$f":"SUM(AD11:AR11)/$C$26","v":2303995.0764328344}]
["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":4378119.9199000401},4796504.2481982093,5208551.5287950886,5650209.737720497,6068834.6318019088,6355863.4939402007,6630397.9908453841,6939925.9320654962,7250430.3997010291,7483366.99939794,7657207.8460471267,7845616.1978943236,8079368.964951247,8282703.1577810394,8501691.644495111,8722232.2500332594,8914947.45610171,9094643.7200593837,9277420.1555850729,{"$f":"SUM(AI23:AI28)","v":9433564.547298871},{"$f":"SUM(AJ23:AJ28)","v":9594413.7838040292},{"$f":"SUM(AK23:AK28)","v":9757520.6687685307},{"$f":"SUM(AL23:AL28)","v":9918450.8938948866},{"$f":"SUM(AM23:AM28)","v":10069358.012430852},{"$f":"SUM(AN23:AN28)","v":10230836.438100278},{"$f":"SUM(AO23:AO28)","v":10373723.005199786},{"$f":"SUM(AP23:AP28)","v":10490636.555092078},{"$f":"SUM(AQ23:AQ28)","v":10589191.944005826},{"$f":"SUM(AR23:AR28)","v":10692637.616481209}]
[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},118305736.74196731,127725563.62083483,136928640.6517311,145969938.80033636,154941691.43091896,163849364.57550573,170713056.20767969,176433238.17585868,182052421.58467498,184868176.11719647,185257868.21662456,185459029.51388869,185565012.83835334,185087869.68338186,184342850.6160177,183452546.20780101,181910261.19402948,180143961.79014921,{"$f":"AH35","v":177992353.07292402},{"$f":"AI35","v":175376764.54744038},{"$f":"AJ35","v":172606906.95332527},{"$f":"AK35","v":169635465.64401507},{"$f":"AL35","v":166448019.69788319},{"$f":"AM35","v":163059642.24738047},{"$f":"AN35","v":159490823.06402406},{"$f":"AO35","v":155660629.27098599},{"$f":"AP35","v":151513844.37541661},{"$f":"AQ35","v":147295570.13900831}]
["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":17021203.686311979},14216331.127065741,14411628.55969137,14691507.886325754,15040587.262384515,15263536.638526972,13494089.623019325,12660107.900244489,12869613.808517333,10299121.531919431,8046899.9454752347,8046777.4951584777,8185352.2894158941,7805560.0028095627,7756672.5771309324,7831927.8418165697,7372662.4423301937,7328344.3161791395,7125811.4383598967,{"$f":"AI14","v":6817976.0218152367},6824556.1896889312,6786079.3594583189,6731004.9477629866,6680980.5619281139,6662017.2547438806,6543529.2121617058,6343851.6595226703,6370917.70759751,{"$f":"AR14","v":6256315.3798998781}]
["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":-4378119.9199000401},-4796504.2481982093,-5208551.5287950886,-5650209.737720497,-6068834.6318019088,-6355863.4939402007,-6630397.9908453841,-6939925.9320654962,-7250430.3997010291,-7483366.99939794,-7657207.8460471267,-7845616.1978943236,-8079368.964951247,-8282703.1577810394,-8501691.644495111,-8722232.2500332594,-8914947.45610171,-9094643.7200593837,-9277420.1555850729,{"$f":"-AI29","v":-9433564.547298871},-9594413.7838040292,-9757520.6687685307,-9918450.8938948866,-10069358.012430852,-10230836.438100278,-10373723.005199786,-10490636.555092078,-10589191.944005826,{"$f":"-AR29","v":-10692637.616481209}]
["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":118305736.74196731},127725563.62083483,136928640.6517311,145969938.80033636,154941691.43091896,163849364.57550573,170713056.20767969,176433238.17585868,182052421.58467498,184868176.11719647,185257868.21662456,185459029.51388869,185565012.83835334,185087869.68338186,184342850.6160177,183452546.20780101,181910261.19402948,180143961.79014921,177992353.07292402,{"$f":"SUM(AI32:AI34)","v":175376764.54744038},172606906.95332527,169635465.64401507,166448019.69788319,163059642.24738047,159490823.06402406,155660629.27098599,151513844.37541661,147295570.13900831,{"$f":"SUM(AR32:AR34)","v":142859247.90242699}]

{"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":17021.203686311976},{"$f":"Inputs!Q102/1000","v":14216.331127065743},{"$f":"Inputs!R102/1000","v":14411.628559691369},{"$f":"Inputs!S102/1000","v":14691.507886325759},{"$f":"Inputs!T102/1000","v":15040.587262384515},{"$f":"Inputs!U102/1000","v":15263.536638526972},{"$f":"Inputs!V102/1000","v":13494.089623019325},{"$f":"Inputs!W102/1000","v":12660.107900244488},{"$f":"Inputs!X102/1000","v":12869.613808517333},{"$f":"Inputs!Y102/1000","v":10299.121531919429},{"$f":"Inputs!Z102/1000","v":8046.8999454752347},{"$f":"Inputs!AA102/1000","v":8046.777495158477},{"$f":"Inputs!AB102/1000","v":8185.3522894158932},{"$f":"Inputs!AC102/1000","v":7805.5600028095614},{"$f":"Inputs!AD102/1000","v":7756.6725771309311},{"$f":"Inputs!AE102/1000","v":7831.9278418165695},{"$f":"Inputs!AF102/1000","v":7372.6624423301955},{"$f":"Inputs!AG102/1000","v":7328.3443161791402},{"$f":"Inputs!AH102/1000","v":7125.8114383598959}]
["Opex","GD14",null,{"$f":"Inputs!P105/1000","v":6334.3860275065363},{"$f":"Inputs!Q105/1000","v":6293.1132704177871},{"$f":"Inputs!R105/1000","v":6445.5975121211386},{"$f":"Inputs!S105/1000","v":6656.0731894411301},{"$f":"Inputs!T105/1000","v":6929.350922495335},{"$f":"Inputs!U105/1000","v":7205.2844186704942},{"$f":"Inputs!V105/1000","v":7397.4704122668882},{"$f":"Inputs!W105/1000","v":7498.577745966998},{"$f":"Inputs!X105/1000","v":7584.8733903372058},{"$f":"Inputs!Y105/1000","v":7674.4869345203015},{"$f":"Inputs!Z105/1000","v":7835.2001256645344},{"$f":"Inputs!AA105/1000","v":8039.0749761723919},{"$f":"Inputs!AB105/1000","v":8151.0881550714803},{"$f":"Inputs!AC105/1000","v":8248.8183843041861},{"$f":"Inputs!AD105/1000","v":8311.1379240282586},{"$f":"Inputs!AE105/1000","v":8247.4455128455338},{"$f":"Inputs!AF105/1000","v":8152.6465343082082},{"$f":"Inputs!AG105/1000","v":8137.4999675737499},{"$f":"Inputs!AH105/1000","v":8256.4647075646935}]
["Volumes (therms '000)",0.44844183597538856,2012,{"$f":"SUM(D17:D22)","v":61980.126268008869},{"$f":"SUM(E17:E22)","v":60443.23317143858},62622.546114643585,64913.305905555229,67306.198425925075,69782.407045184853,71706.054774459946,73510.596576368989,75021.763423009194,76693.031525654398,77976.119279206789,79338.55170141795,80329.870505639672,81411.230984222682,82139.49465746482,82982.369079943252,83503.781798622847,84144.534048435919,84493.126724193688]
["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":11228.403378270079},{"$f":"Inputs!Q109/1000","v":12779.500989018296},{"$f":"Inputs!R109/1000","v":14462.359280580207},{"$f":"Inputs!S109/1000","v":16267.497011711972},{"$f":"Inputs!T109/1000","v":18185.43305779306},{"$f":"Inputs!U109/1000","v":20197.186038751333},{"$f":"Inputs!V109/1000","v":22038.984862112331},{"$f":"Inputs!W109/1000","v":23793.384195931972},{"$f":"Inputs!X109/1000","v":25471.14831865142},{"$f":"Inputs!Y109/1000","v":27086.07018090173},{"$f":"Inputs!Z109/1000","v":28567.207212223013},{"$f":"Inputs!AA109/1000","v":29962.673191744194},{"$f":"Inputs!AB109/1000","v":31228.311769484411},{"$f":"Inputs!AC109/1000","v":32414.365345344577},{"$f":"Inputs!AD109/1000","v":33477.386578730002},{"$f":"Inputs!AE109/1000","v":34482.46817079567},{"$f":"Inputs!AF109/1000","v":35386.438888851844},{"$f":"Inputs!AG109/1000","v":36235.622984059708},{"$f":"Inputs!AH109/1000","v":37004.489436109841}]
["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":18641.067429944254},{"$f":"SUMPRODUCT(E24:E29,E17:E22)","v":18547.099726508626},19441.221218419221,20385.79582017252,21376.703437392403,22405.643123959468,23257.063941176784,24060.228137487044,24762.678227734294,25506.389313309042,26112.600806422812,26732.123038917871,27219.939051716417,27725.168939399548,28105.151108351231,28512.97492589469,28808.1990517136,29133.139236682786,29357.258943985478]
["Capex",null,null,{"$f":"-D14","v":-17021.203686311976},{"$f":"-E14","v":-14216.331127065743},-14411.628559691369,-14691.507886325759,-15040.587262384515,-15263.536638526972,-13494.089623019325,-12660.107900244488,-12869.613808517333,-10299.121531919429,-8046.8999454752347,-8046.777495158477,-8185.3522894158932,-7805.5600028095614,-7756.6725771309311,-7831.9278418165695,-7372.6624423301955,-7328.3443161791402,-7125.8114383598959]
["Opex",null,null,{"$f":"-D15","v":-6334.3860275065363},{"$f":"-E15","v":-6293.1132704177871},-6445.5975121211386,-6656.0731894411301,-6929.350922495335,-7205.2844186704942,-7397.4704122668882,-7498.577745966998,-7584.8733903372058,-7674.4869345203015,-7835.2001256645344,-8039.0749761723919,-8151.0881550714803,-8248.8183843041861,-8311.1379240282586,-8247.4455128455338,-8152.6465343082082,-8137.4999675737499,-8256.4647075646935]
[]
["Cashflows",null,null,{"$f":"SUM(D33:D36)","v":-4714.5222838742575},{"$f":"SUM(E33:E36)","v":-1962.3446709749041},{"$f":"SUM(F33:F36)","v":-1416.0048533932868},-961.78525559436912,-593.23474748744684,-63.177933237998332,2365.5039058905713,3901.5424912755579,4308.1910288797544,7532.780846869312,10230.500735283043,10646.270567587002,10883.498607229045,11670.7905522858,12037.34060719204,12433.601571232586,13282.890075075196,13667.294952929897,13974.98279806089]
[]
[]
[]
["Discounted Cashflow",null,{"$f":"SUM(D41:V41)","v":62390.82360736133},{"$f":"D37*D7","v":-4617.3389386170229},{"$f":"E37*E7","v":-1842.6593041873136},-1274.8238727171238,-830.193353691163,-490.95694721730712,-50.130026591204995,1799.5829982480604,2845.772935211507,3012.8294452044861,5050.6889064329425,6576.6975389295931,6561.8178275850478,6431.4794668163886,6612.3879858854716,6538.8939520032363,6475.6949552350725,6632.8122816036739,6543.3987438626345,6414.8690133643486]
[]
[]
[]
["Closing DAV",null,null,{"$f":"DAV!P35/1000","v":118305.73674196731},{"$f":"DAV!Q35/1000","v":127725.56362083483},{"$f":"DAV!R35/1000","v":136928.64065173111},{"$f":"DAV!S35/1000","v":145969.93880033636},{"$f":"DAV!T35/1000","v":154941.69143091896},{"$f":"DAV!U35/1000","v":163849.36457550572},{"$f":"DAV!V35/1000","v":170713.05620767968},{"$f":"DAV!W35/1000","v":176433.23817585869},{"$f":"DAV!X35/1000","v":182052.42158467497},{"$f":"DAV!Y35/1000","v":184868.17611719648},{"$f":"DAV!Z35/1000","v":185257.86821662457},{"$f":"DAV!AA35/1000","v":185459.0295138887},{"$f":"DAV!AB35/1000","v":185565.01283835334},{"$f":"DAV!AC35/1000","v":185087.86968338187},{"$f":"DAV!AD35/1000","v":184342.85061601771},{"$f":"DAV!AE35/1000","v":183452.546207801},{"$f":"DAV!AF35/1000","v":181910.26119402947},{"$f":"DAV!AG35/1000","v":180143.96179014922},{"$f":"DAV!AH35/1000","v":177992.35307292402}]
[]
[]
[]
["TRV",null,{"$f":"-C65","v":-143802.85904978559}]
["Discounted DAV2035",null,{"$f":"V45*V8","v":79983.330543081087}]
["Backsolve to 0 by running Macro Ctrl + q",null,{"$f":"SUM(C41:C50)","v":-1428.7048993431818}]
[]
[]
[]
["Condition 4.6.8 Calculating TRV"]
[]
[null,"Total Regulatory Value (TRV)",null,null,null,null,null,null,{"$f":"I67+I69","v":196851.52758068201},null,null,null,null,{"$f":"N67+N69","v":212329.27514092156},null,null,null,null,{"$f":"S67+S69","v":198099.6484338741},null,null,{"$f":"V67+V69","v":181171.74739364345}]
[]
[]
[]
["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":-5944.2573839420429},{"$f":"E37*(1+$I$6*$B$7)*(1+$I$6)^($I$12-E12)","v":-2372.1977789842826},-1641.1793284757362,-1068.77208677611,-632.04683422443929,-64.536258802615293,{"$f":"J37*(1+$N$6*$B$7)*(1+$N$6)^($N$12-J12)","v":2859.5603997255289},{"$f":"K37*(1+$N$6*$B$7)*(1+$N$6)^($N$12-K12)","v":4521.9695896570065},{"$f":"L37*(1+$N$6*$B$7)*(1+$N$6)^($N$12-L12)","v":4787.4245205811912},{"$f":"M37*(1+$N$6*$B$7)*(1+$N$6)^($N$12-M12)","v":8025.6092673853127},{"$f":"N37*(1+$N$6*$B$7)*(1+$N$6)^($N$12-N12)","v":10450.45650109163},{"$f":"O37*(1+$S$6*$B$7)*(1+$S$6)^($S$12-O12)","v":12869.83870287617},{"$f":"P37*(1+$S$6*$B$7)*(1+$S$6)^($S$12-P12)","v":12614.203187845837},{"$f":"Q37*(1+$S$6*$B$7)*(1+$S$6)^($S$12-Q12)","v":12969.023074891096},{"$f":"R37*(1+$S$6*$B$7)*(1+$S$6)^($S$12-R12)","v":12824.877597747276},{"$f":"S37*(1+$S$6*$B$7)*(1+$S$6)^($S$12-S12)","v":12700.924005014087},{"$f":"T37*(1+$V$6*$B$7)*(1+$V$6)^($V$12-T12)","v":14760.448927014006},{"$f":"U37*(1+$V$6*$B$7)*(1+$V$6)^($V$12-U12)","v":14561.470891577859},{"$f":"V37*(1+$V$6*$B$7)*(1+$V$6)^($V$12-V12)","v":14275.4449282192}]
[]
[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":-242974.29541936223},null,null,null,null,{"$f":"-N57*(1+S6)^(S12-N12)","v":-262078.51500224858},null,null,{"$f":"-S57*(1+V6)^(V12-S12)","v":-224769.11214045453}]
[]
[null,"DAV",null,null,null,null,null,null,{"$f":"I45","v":163849.36457550572},null,null,null,null,{"$f":"N45","v":185257.86821662457},null,null,null,null,{"$f":"S45","v":183452.546207801},null,null,{"$f":"V45","v":177992.35307292402}]
[]
[null,"Calculated PA",null,null,null,null,null,null,{"$f":"-SUM(D63:I68)","v":33002.163005176291},null,null,null,null,{"$f":"-SUM(J63:N68)","v":27071.406924296985},null,null,null,null,{"$f":"-SUM(O63:S68)","v":14647.102226073097},null,null,{"$f":"-SUM(T63:V68)","v":3179.3943207194388}]
[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":21751.433416826458}]
[null,null,null,null,null,null,null,"Average TRV",{"$f":"(+C65+I57)/2","v":170327.1933152338}]
[]
[null,null,null,null,null,null,null,"Ratio",{"$f":"+I74/I73","v":7.8306192539693598}]
[]
[null,null,null,{"$f":"(SUM(D72:D77))+4162954.34941467","v":4162954.3494146699},{"$f":"(SUM(E72:E77))+4533329.78337157","v":4533329.7833715724},{"$f":"(SUM(F72:F77))+4932708.67857861","v":4932708.6785786059},{"$f":"(SUM(G72:G77))+5347599.74421037","v":5347599.7442103727},{"$f":"(SUM(H72:H77))+5741466.60358512","v":5741466.6035851231},{"$f":"(SUM(I72:I77))+6102467.09446314","v":6294553.5518144537}]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(D78:I78)/6/1000","v":5168.7687851624669}]
[]
[null,null,null,null,null,null,null,null,{"$f":"(+C65+I57)/2","v":170327.1933152338}]
[null,null,null,null,null,null,null,null,{"$f":"+I80/I82","v":3.0346116110751296E-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":17021.203686311976},{"$f":"Inputs!Q102/1000","v":14216.331127065743},{"$f":"Inputs!R102/1000","v":14411.628559691369},{"$f":"Inputs!S102/1000","v":14691.507886325759},{"$f":"Inputs!T102/1000","v":15040.587262384515},{"$f":"Inputs!U102/1000","v":15263.536638526972},{"$f":"Inputs!V102/1000","v":13494.089623019325},{"$f":"Inputs!W102/1000","v":12660.107900244488},{"$f":"Inputs!X102/1000","v":12869.613808517333},{"$f":"Inputs!Y102/1000","v":10299.121531919429},{"$f":"Inputs!Z102/1000","v":8046.8999454752347},{"$f":"Inputs!AA102/1000","v":8046.777495158477},{"$f":"Inputs!AB102/1000","v":8185.3522894158932},{"$f":"Inputs!AC102/1000","v":7805.5600028095614},{"$f":"Inputs!AD102/1000","v":7756.6725771309311},{"$f":"Inputs!AE102/1000","v":7831.9278418165695},{"$f":"Inputs!AF102/1000","v":7372.6624423301955},{"$f":"Inputs!AG102/1000","v":7328.3443161791402},{"$f":"Inputs!AH102/1000","v":7125.8114383598959},{"$f":"Inputs!AI102/1000","v":6817.9760218152369},{"$f":"Inputs!AJ102/1000","v":6824.5561896889303},{"$f":"Inputs!AK102/1000","v":6786.0793594583192},{"$f":"Inputs!AL102/1000","v":6731.0049477629855},{"$f":"Inputs!AM102/1000","v":6680.9805619281142},{"$f":"Inputs!AN102/1000","v":6662.0172547438806},{"$f":"Inputs!AO102/1000","v":6543.5292121617058},{"$f":"Inputs!AP102/1000","v":6343.8516595226702},{"$f":"Inputs!AQ102/1000","v":6370.9177075975113},{"$f":"Inputs!AR102/1000","v":6256.3153798998783}]
["Opex",null,null,{"$f":"Inputs!P105/1000","v":6334.3860275065363},{"$f":"Inputs!Q105/1000","v":6293.1132704177871},{"$f":"Inputs!R105/1000","v":6445.5975121211386},{"$f":"Inputs!S105/1000","v":6656.0731894411301},{"$f":"Inputs!T105/1000","v":6929.350922495335},{"$f":"Inputs!U105/1000","v":7205.2844186704942},{"$f":"Inputs!V105/1000","v":7397.4704122668882},{"$f":"Inputs!W105/1000","v":7498.577745966998},{"$f":"Inputs!X105/1000","v":7584.8733903372058},{"$f":"Inputs!Y105/1000","v":7674.4869345203015},{"$f":"Inputs!Z105/1000","v":7835.2001256645344},{"$f":"Inputs!AA105/1000","v":8039.0749761723919},{"$f":"Inputs!AB105/1000","v":8151.0881550714803},{"$f":"Inputs!AC105/1000","v":8248.8183843041861},{"$f":"Inputs!AD105/1000","v":8311.1379240282586},{"$f":"Inputs!AE105/1000","v":8247.4455128455338},{"$f":"Inputs!AF105/1000","v":8152.6465343082082},{"$f":"Inputs!AG105/1000","v":8137.4999675737499},{"$f":"Inputs!AH105/1000","v":8256.4647075646935},{"$f":"Inputs!AI105/1000","v":8449.9280031555136},{"$f":"Inputs!AJ105/1000","v":8668.51297857602},{"$f":"Inputs!AK105/1000","v":8742.6880128671728},{"$f":"Inputs!AL105/1000","v":8746.7682499520561},{"$f":"Inputs!AM105/1000","v":8995.9172417841783},{"$f":"Inputs!AN105/1000","v":9253.0738344431284},{"$f":"Inputs!AO105/1000","v":9240.8332892494091},{"$f":"Inputs!AP105/1000","v":9090.7351313227082},{"$f":"Inputs!AQ105/1000","v":9038.0358390327001},{"$f":"Inputs!AR105/1000","v":8958.4128104273841}]
["Volumes (therms '000)",null,null,{"$f":"SUM(D17:D22)","v":61980.126268008869},{"$f":"SUM(E17:E22)","v":60443.23317143858},62622.546114643585,64913.305905555229,67306.198425925075,69782.407045184853,71706.054774459946,73510.596576368989,75021.763423009194,76693.031525654398,77976.119279206789,79338.55170141795,80329.870505639672,81411.230984222682,82139.49465746482,82982.369079943252,83503.781798622847,84144.534048435919,84493.126724193688,84980.945174969733,85170.469407125071,85484.774181087021,85527.498785496835,85712.507191316952,85634.783756660312,85699.550112197336,85509.887710746334,85477.799218189612,85214.019508823025]
["V Dom/Very Small IC Tariff (<2,500 tpa) (P1)",null,null,{"$f":"Inputs!P109/1000","v":11228.403378270079},{"$f":"Inputs!Q109/1000","v":12779.500989018296},{"$f":"Inputs!R109/1000","v":14462.359280580207},{"$f":"Inputs!S109/1000","v":16267.497011711972},{"$f":"Inputs!T109/1000","v":18185.43305779306},{"$f":"Inputs!U109/1000","v":20197.186038751333},{"$f":"Inputs!V109/1000","v":22038.984862112331},{"$f":"Inputs!W109/1000","v":23793.384195931972},{"$f":"Inputs!X109/1000","v":25471.14831865142},{"$f":"Inputs!Y109/1000","v":27086.07018090173},{"$f":"Inputs!Z109/1000","v":28567.207212223013},{"$f":"Inputs!AA109/1000","v":29962.673191744194},{"$f":"Inputs!AB109/1000","v":31228.311769484411},{"$f":"Inputs!AC109/1000","v":32414.365345344577},{"$f":"Inputs!AD109/1000","v":33477.386578730002},{"$f":"Inputs!AE109/1000","v":34482.46817079567},{"$f":"Inputs!AF109/1000","v":35386.438888851844},{"$f":"Inputs!AG109/1000","v":36235.622984059708},{"$f":"Inputs!AH109/1000","v":37004.489436109841},{"$f":"Inputs!AI109/1000","v":37737.956427083809},{"$f":"Inputs!AJ109/1000","v":38377.424423116536},{"$f":"Inputs!AK109/1000","v":38967.40847589777},{"$f":"Inputs!AL109/1000","v":39483.329200000691},{"$f":"Inputs!AM109/1000","v":39968.316510583943},{"$f":"Inputs!AN109/1000","v":40381.923830349762},{"$f":"Inputs!AO109/1000","v":40766.399019907032},{"$f":"Inputs!AP109/1000","v":41082.121907651723},{"$f":"Inputs!AQ109/1000","v":41385.829452767648},{"$f":"Inputs!AR109/1000","v":41638.23754224593}]
["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.43608066968853604}]
["P Dom/Very Small IC Tariff (<2,500 tpa) (P1)",null,null,0.4335403939427776,{"$f":"D24","v":0.4335403939427776},0.4335403939427776,0.4335403939427776,0.4335403939427776,0.4335403939427776,0.4335403939427776,0.4335403939427776,0.4335403939427776,0.4335403939427776,0.4335403939427776,0.4335403939427776,0.4335403939427776,0.4335403939427776,0.4335403939427776,0.4335403939427776,0.4335403939427776,0.4335403939427776,0.4335403939427776,{"$f":"V24","v":0.4335403939427776},{"$f":"W24","v":0.4335403939427776},{"$f":"X24","v":0.4335403939427776},{"$f":"Y24","v":0.4335403939427776},{"$f":"Z24","v":0.4335403939427776},{"$f":"AA24","v":0.4335403939427776},{"$f":"AB24","v":0.4335403939427776},{"$f":"AC24","v":0.4335403939427776},{"$f":"AD24","v":0.4335403939427776},{"$f":"AE24","v":0.4335403939427776}]
["P Small/Med Tariff IC (2,500 - 25k tpa) (P2)",null,0.70249326086221142,{"$f":"$D$24*C25","v":0.30455920505634959},{"$f":"D25","v":0.30455920505634959},0.30455920505634959,0.30455920505634959,0.30455920505634959,0.30455920505634959,0.30455920505634959,0.30455920505634959,0.30455920505634959,0.30455920505634959,0.30455920505634959,0.30455920505634959,0.30455920505634959,0.30455920505634959,0.30455920505634959,0.30455920505634959,0.30455920505634959,0.30455920505634959,0.30455920505634959,0.30455920505634959,0.30455920505634959,0.30455920505634959,0.30455920505634959,0.30455920505634959,0.30455920505634959,0.30455920505634959,0.30455920505634959,0.30455920505634959,{"$f":"AE25","v":0.30455920505634959}]
["P Large Tariff IC (25k - 75k tpa) (P3)",null,0.62966323886435094,{"$f":"$D$24*C26","v":0.27298444862853599},{"$f":"D26","v":0.27298444862853599},0.27298444862853599,0.27298444862853599,0.27298444862853599,0.27298444862853599,0.27298444862853599,0.27298444862853599,0.27298444862853599,0.27298444862853599,0.27298444862853599,0.27298444862853599,0.27298444862853599,0.27298444862853599,0.27298444862853599,0.27298444862853599,0.27298444862853599,0.27298444862853599,0.27298444862853599,0.27298444862853599,0.27298444862853599,0.27298444862853599,0.27298444862853599,0.27298444862853599,0.27298444862853599,0.27298444862853599,0.27298444862853599,0.27298444862853599,0.27298444862853599]
["P CHP Contract (>75k tpa) (P4)",null,0.5,{"$f":"$D$24*C27","v":0.2167701969713888},0.2167701969713888,{"$f":"E27","v":0.2167701969713888},{"$f":"F27","v":0.2167701969713888},{"$f":"G27","v":0.2167701969713888},{"$f":"H27","v":0.2167701969713888},{"$f":"I27","v":0.2167701969713888},{"$f":"J27","v":0.2167701969713888},{"$f":"K27","v":0.2167701969713888},{"$f":"L27","v":0.2167701969713888},{"$f":"M27","v":0.2167701969713888},{"$f":"N27","v":0.2167701969713888},{"$f":"O27","v":0.2167701969713888},{"$f":"P27","v":0.2167701969713888},{"$f":"Q27","v":0.2167701969713888},{"$f":"R27","v":0.2167701969713888},{"$f":"S27","v":0.2167701969713888},{"$f":"T27","v":0.2167701969713888},{"$f":"U27","v":0.2167701969713888},0.2167701969713888,0.2167701969713888,0.2167701969713888,0.2167701969713888,0.2167701969713888,0.2167701969713888,0.2167701969713888,0.2167701969713888,0.2167701969713888,0.2167701969713888]
["P Firm Contract (>75k tpa) (P5)",null,0.59008170977553098,0.25582425691451144,0.25582425691451144,0.25582425691451144,0.25582425691451144,0.25582425691451144,0.25582425691451144,0.25582425691451144,0.25582425691451144,0.25582425691451144,0.25582425691451144,0.25582425691451144,0.25582425691451144,0.25582425691451144,0.25582425691451144,0.25582425691451144,0.25582425691451144,0.25582425691451144,0.25582425691451144,0.25582425691451144,0.25582425691451144,0.25582425691451144,0.25582425691451144,0.25582425691451144,0.25582425691451144,0.25582425691451144,0.25582425691451144,0.25582425691451144,0.25582425691451144,0.25582425691451144]
["P Int Contract (>75k tpa) (P6)",null,0.53600000000000003,0.23237765115332881,0.23237765115332881,0.23237765115332881,0.23237765115332881,0.23237765115332881,0.23237765115332881,0.23237765115332881,0.23237765115332881,0.23237765115332881,0.23237765115332881,0.23237765115332881,0.23237765115332881,0.23237765115332881,0.23237765115332881,0.23237765115332881,0.23237765115332881,0.23237765115332881,0.23237765115332881,0.23237765115332881,0.23237765115332881,0.23237765115332881,0.23237765115332881,0.23237765115332881,0.23237765115332881,0.23237765115332881,0.23237765115332881,0.23237765115332881,0.23237765115332881,0.23237765115332881]
[]
["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":17817.773942892163},{"$f":"SUMPRODUCT(E24:E29,E17:E22)","v":17812.814189061617},18693.800396639814,19624.498521785128,20600.848997255172,21614.672823767178,22457.601445976208,23252.982371560032,23949.128753345471,24685.929976920695,25287.251575409526,25901.688368996198,26386.353801470679,26888.177286550555,27266.593031484004,27672.441411274693,27967.344269361271,28291.526636431601,28516.36965077501,28779.049291905791,28938.756580818896,29130.084434519755,29229.147271486934,29367.554121451951,29416.736894860042,29505.55874870906,29508.024228959868,29556.930540464007,29528.65649438063]
["Capex",null,null,{"$f":"-D14","v":-17021.203686311976},-14216.331127065743,-14411.628559691369,-14691.507886325759,-15040.587262384515,-15263.536638526972,-13494.089623019325,-12660.107900244488,-12869.613808517333,-10299.121531919429,-8046.8999454752347,-8046.777495158477,-8185.3522894158932,-7805.5600028095614,-7756.6725771309311,-7831.9278418165695,-7372.6624423301955,-7328.3443161791402,-7125.8114383598959,{"$f":"-W14","v":-6817.9760218152369},-6824.5561896889303,-6786.0793594583192,-6731.0049477629855,-6680.9805619281142,-6662.0172547438806,-6543.5292121617058,-6343.8516595226702,-6370.9177075975113,{"$f":"-AF14","v":-6256.3153798998783}]
["Opex",null,null,{"$f":"-D15","v":-6334.3860275065363},-6293.1132704177871,-6445.5975121211386,-6656.0731894411301,-6929.350922495335,-7205.2844186704942,-7397.4704122668882,-7498.577745966998,-7584.8733903372058,-7674.4869345203015,-7835.2001256645344,-8039.0749761723919,-8151.0881550714803,-8248.8183843041861,-8311.1379240282586,-8247.4455128455338,-8152.6465343082082,-8137.4999675737499,-8256.4647075646935,{"$f":"-W15","v":-8449.9280031555136},-8668.51297857602,-8742.6880128671728,-8746.7682499520561,-8995.9172417841783,-9253.0738344431284,-9240.8332892494091,-9090.7351313227082,-9038.0358390327001,{"$f":"-AF15","v":-8958.4128104273841}]
[]
["Cashflows",null,null,{"$f":"SUM(D33:D36)","v":-5537.8157709263487},-2696.6302084219133,-2163.4256751726944,-1723.0825539817606,-1369.0891876246778,-854.1482334302882,1566.0414106899952,3094.2967253485467,3494.6415544909314,6712.3215104809651,9405.1515042697574,9815.835897665329,10049.913356983307,10833.798899436808,11198.782530324814,11593.068056612588,12442.035292722867,12825.682352678712,13134.093504850422,{"$f":"SUM(W33:W36)","v":13511.14526693504},13445.687412553945,13601.317062194263,13751.374073771894,13690.656317739658,13501.645805673032,13721.196247297945,14073.437438114492,14147.976993833794,{"$f":"SUM(AF33:AF36)","v":14313.928304053366}]
[]
[]
[]
["Discounted Cashflow",null,{"$f":"SUM(D41:AF41)","v":101899.52431858513},{"$f":"D37*D7","v":-5423.1524075712796},-2531.4369955313759,-1946.794580709847,-1486.3348335318196,-1132.0737829920031,-677.03116563635911,1189.9016792503714,2253.7317079748691,2439.9184751763,4492.39412659974,6033.9723790465296,6036.6671837257472,5924.6770578715204,6122.3133909130174,6066.497452771514,6020.0211274340036,6193.3194383126447,6119.9088390938887,6007.544530960914,{"$f":"W37*W7","v":5924.0877096081294},5651.2529741109811,5479.9314316669534,5310.9556834894374,5068.5445871779539,4791.5732900189014,4667.8385035241026,4589.4057416108553,4422.6547132190381,{"$f":"AF37*AF7","v":4289.2360610003952}]
[]
[]
[]
["Closing DAV",null,null,{"$f":"DAV!P35/1000","v":118305.73674196731},{"$f":"DAV!Q35/1000","v":127725.56362083483},{"$f":"DAV!R35/1000","v":136928.64065173111},{"$f":"DAV!S35/1000","v":145969.93880033636},{"$f":"DAV!T35/1000","v":154941.69143091896},{"$f":"DAV!U35/1000","v":163849.36457550572},{"$f":"DAV!V35/1000","v":170713.05620767968},{"$f":"DAV!W35/1000","v":176433.23817585869},{"$f":"DAV!X35/1000","v":182052.42158467497},{"$f":"DAV!Y35/1000","v":184868.17611719648},{"$f":"DAV!Z35/1000","v":185257.86821662457},{"$f":"DAV!AA35/1000","v":185459.0295138887},{"$f":"DAV!AB35/1000","v":185565.01283835334},{"$f":"DAV!AC35/1000","v":185087.86968338187},{"$f":"DAV!AD35/1000","v":184342.85061601771},{"$f":"DAV!AE35/1000","v":183452.546207801},{"$f":"DAV!AF35/1000","v":181910.26119402947},{"$f":"DAV!AG35/1000","v":180143.96179014922},{"$f":"DAV!AH35/1000","v":177992.35307292402},{"$f":"DAV!AI35/1000","v":175376.76454744037},{"$f":"DAV!AJ35/1000","v":172606.90695332526},{"$f":"DAV!AK35/1000","v":169635.46564401509},{"$f":"DAV!AL35/1000","v":166448.0196978832},{"$f":"DAV!AM35/1000","v":163059.64224738046},{"$f":"DAV!AN35/1000","v":159490.82306402407},{"$f":"DAV!AO35/1000","v":155660.62927098598},{"$f":"DAV!AP35/1000","v":151513.84437541661},{"$f":"DAV!AQ35/1000","v":147295.57013900831},{"$f":"DAV!AR35/1000","v":142859.24790242699}]
[]
[]
[]
["TRV",null,{"$f":"-C65","v":-143802.85904978559}]
["Discounted DAV2045",null,{"$f":"AF45*AF8","v":41903.334731200463}]
["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":202350.48298657537},null,null,null,null,{"$f":"N67+N69","v":223870.60120097935},null,null,null,null,{"$f":"S67+S69","v":217233.78912036947},null,null,null,null,{"$f":"X67+X69","v":195722.90513297517},null,null,null,null,{"$f":"AC67+AC69","v":165780.15880895715},null,null,{"$f":"AF67+AF69","v":142859.24790242699}]
[]
[]
[]
["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":-6989.6797834276394},-3262.6658188665151,-2509.1440735238552,-1915.6762997915241,-1459.0836914855133,-872.59783527238244,{"$f":"J37*(1+$N$6*$B$7)*(1+$N$6)^($N$12-J12)","v":1894.7610115878078},{"$f":"K37*(1+$N$6*$B$7)*(1+$N$6)^($N$12-K12)","v":3588.7695977874619},{"$f":"L37*(1+$N$6*$B$7)*(1+$N$6)^($N$12-L12)","v":3885.2473938261187},{"$f":"M37*(1+$N$6*$B$7)*(1+$N$6)^($N$12-M12)","v":7153.5433458079915},{"$f":"N37*(1+$N$6*$B$7)*(1+$N$6)^($N$12-N12)","v":9608.3027767619842},{"$f":"O37*(1+$S$6*$B$7)*(1+$S$6)^($S$12-O12)","v":11876.226917170561},{"$f":"P37*(1+$S$6*$B$7)*(1+$S$6)^($S$12-P12)","v":11655.903333536056},{"$f":"Q37*(1+$S$6*$B$7)*(1+$S$6)^($S$12-Q12)","v":12044.722837219486},{"$f":"R37*(1+$S$6*$B$7)*(1+$S$6)^($S$12-R12)","v":11934.913446244558},{"$f":"S37*(1+$S$6*$B$7)*(1+$S$6)^($S$12-S12)","v":11843.478326635421},{"$f":"T37*(1+$X$6*$B$7)*(1+$X$6)^($X$12-T12)","v":15053.678157248614},{"$f":"U37*(1+$X$6*$B$7)*(1+$X$6)^($X$12-U12)","v":14875.244032386008},{"$f":"V37*(1+$X$6*$B$7)*(1+$X$6)^($X$12-V12)","v":14602.127790305558},{"$f":"W37*(1+$X$6*$B$7)*(1+$X$6)^($X$12-W12)","v":14399.275000103913},{"$f":"X37*(1+$X$6*$B$7)*(1+$X$6)^($X$12-X12)","v":13736.114260665112},{"$f":"Y37*(1+$AC$6*$B$7)*(1+$AC$6)^($AC$12-Y12)","v":16456.298728610851},{"$f":"Z37*(1+$AC$6*$B$7)*(1+$AC$6)^($AC$12-Z12)","v":15948.862563656163},{"$f":"AA37*(1+$AC$6*$B$7)*(1+$AC$6)^($AC$12-AA12)","v":15220.89918203802},{"$f":"AB37*(1+$AC$6*$B$7)*(1+$AC$6)^($AC$12-AB12)","v":14389.151109614832},{"$f":"AC37*(1+$AC$6*$B$7)*(1+$AC$6)^($AC$12-AC12)","v":14017.574086239581},{"$f":"AD37*(1+$AF$6*$B$7)*(1+$AF$6)^($AF$12-AD12)","v":15646.464816496575},{"$f":"AE37*(1+$AF$6*$B$7)*(1+$AF$6)^($AF$12-AE12)","v":15077.96766332671},{"$f":"AF37*(1+$AF$6*$B$7)*(1+$AF$6)^($AF$12-AF12)","v":14623.10915542092}]
[]
[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":-250001.22532675072},null,null,null,null,{"$f":"-N57*(1+S6)^(S12-N12)","v":-276589.03398117557},null,null,null,null,{"$f":"-S57*(1+X6)^(X12-S12)","v":-268389.34437368438},null,null,null,null,{"$f":"-X57*(1+AC6)^(AC12-X12)","v":-241812.94447911659},null,null,{"$f":"-AC57*(1+AF6)^(AF12-AC12)","v":-188206.78953767131}]
[]
[null,"DAV",null,null,null,null,null,null,{"$f":"I45","v":163849.36457550572},null,null,null,null,{"$f":"N45","v":185257.86821662457},null,null,null,null,{"$f":"S45","v":183452.546207801},null,null,null,null,{"$f":"X45","v":172606.90695332526},null,null,null,null,{"$f":"AC45","v":155660.62927098598},null,null,{"$f":"AF45","v":142859.24790242699}]
[]
[null,"Calculated PA",null,null,null,null,null,null,{"$f":"-SUM(D63:I68)","v":38501.118411069649},null,null,null,null,{"$f":"-SUM(J63:N68)","v":38612.732984354778},null,null,null,null,{"$f":"-SUM(O63:S68)","v":33781.242912568472},null,null,null,null,{"$f":"-SUM(T63:X68)","v":23115.998179649905},null,null,null,null,{"$f":"-SUM(Y63:AC68)","v":10119.529537971161},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":-1.1641532182693481E-10}]
[]
[]
[null,"Annual Basis"]
[null,"Cashflow",null,{"$f":"+'Building Block Method'!C9","v":-5657.4325915783575},{"$f":"+'Building Block Method'!D9","v":-8656.7111004583694},{"$f":"+'Building Block Method'!E9","v":-11240.836689754597},{"$f":"+'Building Block Method'!F9","v":-13486.741971899761},{"$f":"+'Building Block Method'!G9","v":-15468.030739163201},{"$f":"+'Building Block Method'!H9","v":-17008.847502367436}]
[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":118305.73674196731},{"$f":"+E45","v":127725.56362083483},136928.64065173111,145969.93880033636,154941.69143091896,163849.36457550572]
[null,"Q"]
[null,"CC"]
[null,"PA ",{"$f":"+C81-DAV!O35/1000","v":38140.206074230213},{"$f":"-SUM(D74:D78)","v":37366.838410347365},{"$f":"-SUM(E74:E78)","v":37426.944198983649},37568.611175659898,37825.89544314571,38192.784365958883,38501.118411069619]
[]
[null,"TRV",{"$f":"+C65","v":143802.85904978559},{"$f":"SUM(D76:D79)","v":155672.57515231468},165152.50781981848,174497.25182739101,183795.83424348207,193134.47579687784,202350.48298657534]

{"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":19113.427734568995},{"$f":"+'GD17 Pi''s Calc - 40 yrs'!E33*Q8","v":19694.726217480478},{"$f":"+'GD17 Pi''s Calc - 40 yrs'!F33*R8","v":21303.319827413776},{"$f":"+'GD17 Pi''s Calc - 40 yrs'!G33*S8","v":23050.509540662526},{"$f":"+'GD17 Pi''s Calc - 40 yrs'!H33*T8","v":24940.166998449047},{"$f":"+'GD17 Pi''s Calc - 40 yrs'!I33*U8","v":26970.883961906569},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":-6795.0031225930734},{"$f":"+'GD17 Pi''s Calc - 40 yrs'!E35*Q8","v":-6957.9765219007631},{"$f":"+'GD17 Pi''s Calc - 40 yrs'!F35*R8","v":-7345.3563409279213},{"$f":"+'GD17 Pi''s Calc - 40 yrs'!G35*S8","v":-7818.0789377238334},{"$f":"+'GD17 Pi''s Calc - 40 yrs'!H35*T8","v":-8388.9343211494252},{"$f":"+'GD17 Pi''s Calc - 40 yrs'!I35*U8","v":-8990.7856368202683}]
[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":-4696.4833525496742},{"$f":"-DAV!Q29*Q8/1000","v":-5303.251747118923},{"$f":"-DAV!R29*R8/1000","v":-5935.6276787587594},{"$f":"-DAV!S29*S8/1000","v":-6636.6135838575001},{"$f":"-DAV!T29*T8/1000","v":-7347.1607516407375},{"$f":"-DAV!U29*U8/1000","v":-7930.8744652514333},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":-829.60458490797839},{"$f":"(+'GD17 Pi''s Calc - 40 yrs'!E79-'GD17 Pi''s Calc - 40 yrs'!D79)*Q8","v":66.455925420491297},{"$f":"(+'GD17 Pi''s Calc - 40 yrs'!F79-'GD17 Pi''s Calc - 40 yrs'!E79)*R8","v":161.44266275890021},{"$f":"(+'GD17 Pi''s Calc - 40 yrs'!G79-'GD17 Pi''s Calc - 40 yrs'!F79)*S8","v":302.20051002885918},{"$f":"(+'GD17 Pi''s Calc - 40 yrs'!H79-'GD17 Pi''s Calc - 40 yrs'!G79)*T8","v":444.16960709050426},{"$f":"(+'GD17 Pi''s Calc - 40 yrs'!I79-'GD17 Pi''s Calc - 40 yrs'!H79)*U8","v":384.74057969745115},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,-378.24517750763641,-401.22363531459155,-386.1660358211501,-396.44002967047709,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":6792.3366745182702},7499.9538738812826,7805.533292978359,8496.7938937954623,9262.0754969282389,10037.52440986184]
[]
[null,"PMICR",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P17/P49","v":1.3812482931622314},1.3779754939108229,1.3205918893729989,1.3298777820432861,1.3477850395566275,1.3647077252656536]
[]
[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":4851.669053227336},{"$f":"Q17/'FE Financeability'!$AB$11","v":5357.1099099152025},{"$f":"R17/'FE Financeability'!$AB$11","v":5575.3809235559711},{"$f":"S17/'FE Financeability'!$AB$11","v":6069.1384955681879},{"$f":"T17/'FE Financeability'!$AB$11","v":6615.7682120915997},{"$f":"U17/'FE Financeability'!$AB$11","v":7169.6602927584581}]
[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":88431.026069524189},95624.44162240623,94995.573705415474,103875.47080054958,114583.68775698067,125449.83883915652]
[]
[null,"Tax"]
[null,"Revenues",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P10+P11","v":19113.427734568995},{"$f":"Q10+Q11","v":19694.726217480478},21303.319827413776,23050.509540662526,24940.166998449047,26970.883961906569]
[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":-6795.0031225930734},-6957.9765219007631,-7345.3563409279213,-7818.0789377238334,-8388.9343211494252,-8990.7856368202683]
[null,"Interest",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"-P49","v":-4917.5348908253754},-5442.7338563153362,-5910.632463966087,-6389.1539572460506,-6872.0717511266685,-7355.0726093442008]
[null,"Capital allowances",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P14*'FE Financeability'!$AB$10","v":-4696.4833525496742},{"$f":"Q14*'FE Financeability'!$AB$10","v":-5303.251747118923},{"$f":"R14*'FE Financeability'!$AB$10","v":-5935.6276787587594},{"$f":"S14*'FE Financeability'!$AB$10","v":-6636.6135838575001},{"$f":"T14*'FE Financeability'!$AB$10","v":-7347.1607516407375},{"$f":"U14*'FE Financeability'!$AB$10","v":-7930.8744652514333}]
[null,"Losses",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P5<TaxYearFE,-SUM(P25:P29),0)","v":-2704.4063686008731},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},1990.7640921454549,2111.703343761008,2206.6630618351437,2332.0001745322179,2694.151250490665]
[null,"Tax payable",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P31*P67","v":0},378.24517750763641,401.22363531459155,386.1660358211501,396.44002967047709,458.00571258341307]
[]
[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":95700.912303136705},{"$f":"+Q50","v":104125.17356444063},{"$f":"+R50","v":112879.47546974284},{"$f":"+S50","v":121693.74838914788},{"$f":"+T50","v":130609.4573307884}]
[null,"Revenues",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"-P10","v":-19113.427734568995},{"$f":"-Q10","v":-19694.726217480478},-21303.319827413776,-23050.509540662526,-24940.166998449047,-26970.883961906569]
[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":6795.0031225930734},6957.9765219007631,7345.3563409279213,7818.0789377238334,8388.9343211494252,8990.7856368202683]
[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":18258.933335692302},{"$f":"+DAV!Q14*'FE Financeability'!Q8/1000","v":15718.277100568308},{"$f":"+DAV!R14*'FE Financeability'!R8/1000","v":16423.387750314345},{"$f":"+DAV!S14*'FE Financeability'!S8/1000","v":17256.325929783085},{"$f":"+DAV!T14*'FE Financeability'!T8/1000","v":18208.703831992319},{"$f":"+DAV!U14*'FE Financeability'!U8/1000","v":19045.908253274734}]
[null,"Tax (prior year)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O32","v":0},0,378.24517750763641,401.22363531459155,386.1660358211501,396.44002967047709]
[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":4917.5348908253754},5442.7338563153362,5910.632463966087,6389.1539572460506,6872.0717511266685,7355.0726093442008]
[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":95700.912303136705},104125.17356444063,112879.47546974284,121693.74838914788,130609.4573307884,139426.77989799151]
[]
[null,"Average debt",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(P50,P41)","v":90271.890495865824},99913.042933788674,108502.32451709174,117286.61192944535,126151.60285996814,135018.11861438997]
[]
[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":172119.27967438736},{"$f":"+'GD17 Pi''s Calc - 40 yrs'!E81*'FE Financeability'!R8","v":188206.60431452221},{"$f":"+'GD17 Pi''s Calc - 40 yrs'!F81*'FE Financeability'!S8","v":204960.68032523597},{"$f":"+'GD17 Pi''s Calc - 40 yrs'!G81*'FE Financeability'!T8","v":222510.18879185294},{"$f":"+'GD17 Pi''s Calc - 40 yrs'!H81*'FE Financeability'!U8","v":240994.04965470938}]
[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":166992.60665022544},{"$f":"+'GD17 Pi''s Calc - 40 yrs'!E81*'FE Financeability'!Q8","v":182600.76095325721},{"$f":"+'GD17 Pi''s Calc - 40 yrs'!F81*'FE Financeability'!R8","v":198855.80704883669},{"$f":"+'GD17 Pi''s Calc - 40 yrs'!G81*'FE Financeability'!S8","v":215882.5931811904},{"$f":"+'GD17 Pi''s Calc - 40 yrs'!H81*'FE Financeability'!T8","v":233815.90147929502},{"$f":"+'GD17 Pi''s Calc - 40 yrs'!I81*'FE Financeability'!U8","v":252493.82402243014}]
[null,"Average TRV",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(P54:P55)","v":160626.18395110813},{"$f":"AVERAGE(Q54:Q55)","v":177360.02031382229},193531.20568167945,210421.63675321318,228163.04513557398,246743.93683856976]
[null,"PM-FFO as % TRV",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P17/P56","v":4.2286609240407162E-2},4.2286609240407183E-2,4.0332168993030083E-2,4.0379848882939148E-2,4.0594108881325343E-2,4.0679923237298472E-2]
[null,"Gearing ratio",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P52/P56","v":0.56199984507720757},0.5633346385335416,0.56064511216633761,0.55738855442418922,0.55290111851815937,0.5471993368685063]
[]
[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.1984432590225698E-2},{"$f":"(Q10+Q26+Q12+Q16-Q49)/Q52","v":7.3003640216403431E-2},7.0681304563240621E-2,7.1977976612168079E-2,7.3665293818480401E-2,7.5757133865006168E-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.5049999411205719},{"$f":"SUM((Q10+Q26+Q12+Q16-Q49)+Q49)/Q49","v":2.3401382525439773},2.2975068051966314,2.3213099992376565,2.3522843222392473,2.3906845288076131]
[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.40532979583661627},{"$f":"SUM((Q10+Q26+Q12+Q16-Q49)-Q38)/Q46","v":0.46404677768409214},0.46696126046621189,0.48921497222115629,0.5103600440809084,0.53704898448793736]
[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":1.0000000000000009},{"$f":"(Q10+Q26+Q12-Q46+Q50-Q41+Q16+Q13)/Q49","v":0.99999999999999911},0.99999999999999989,1.0000000000000007,1.0000000000000004,0.99999999999999778]
[]
[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":-5657.4325915783575},{"$f":"+D9","v":-8656.7111004583694},{"$f":"+E9","v":-11240.836689754597},{"$f":"+F9","v":-13486.741971899761},{"$f":"+G9","v":-15468.030739163201}]
["Cshflow:",null,{"$f":"'GD17 Pi''s Calc - 40 yrs'!D37","v":-5537.8157709263487},{"$f":"'GD17 Pi''s Calc - 40 yrs'!E37","v":-2696.6302084219133},{"$f":"'GD17 Pi''s Calc - 40 yrs'!F37","v":-2163.4256751726944},{"$f":"'GD17 Pi''s Calc - 40 yrs'!G37","v":-1723.0825539817606},{"$f":"'GD17 Pi''s Calc - 40 yrs'!H37","v":-1369.0891876246778},{"$f":"'GD17 Pi''s Calc - 40 yrs'!I37","v":-854.1482334302882}]
["Return on in year cashflow:",null,{"$f":"+C6*'GD17 Pi''s Calc - 40 yrs'!D6*'GD17 Pi''s Calc - 40 yrs'!$B7","v":-119.61682065200914},{"$f":"+D6*'GD17 Pi''s Calc - 40 yrs'!E6*'GD17 Pi''s Calc - 40 yrs'!$B7","v":-58.247212501913332},{"$f":"+E6*'GD17 Pi''s Calc - 40 yrs'!F6*'GD17 Pi''s Calc - 40 yrs'!$B7","v":-46.729994583730203},{"$f":"+F6*'GD17 Pi''s Calc - 40 yrs'!G6*'GD17 Pi''s Calc - 40 yrs'!$B7","v":-37.218583166006034},{"$f":"+G6*'GD17 Pi''s Calc - 40 yrs'!H6*'GD17 Pi''s Calc - 40 yrs'!$B7","v":-29.572326452693044},{"$f":"+H6*'GD17 Pi''s Calc - 40 yrs'!I6*'GD17 Pi''s Calc - 40 yrs'!$B7","v":-18.449601842094225}]
["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":-244.40108795618505},{"$f":"+E5*'GD17 Pi''s Calc - 40 yrs'!F6","v":-373.96991953980159},{"$f":"+F5*'GD17 Pi''s Calc - 40 yrs'!G6","v":-485.60414499739858},{"$f":"+G5*'GD17 Pi''s Calc - 40 yrs'!H6","v":-582.62725318606965},{"$f":"+H5*'GD17 Pi''s Calc - 40 yrs'!I6","v":-668.21892793185032}]
["Closing:",null,{"$f":"SUM(C5:C8)","v":-5657.4325915783575},-8656.7111004583694,-11240.836689754597,-13486.741971899761,-15468.030739163201,-17008.847502367436]