{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Inputs","DAV","GD17 Pi's Calc - 40 yrs"],"not_rendered":{"charts":0,"images":12,"macros":1,"external_links":8,"defined_names":60,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Inputs","index":0,"n_rows":171,"n_cols":44,"rows_kept":171,"cut":false,"hidden":false,"merged":[[66,21,66,27],[131,42,133,42],[131,43,133,43],[66,15,66,20],[131,35,133,35],[131,36,133,36],[131,37,133,37],[131,38,133,38],[131,39,133,39],[131,30,133,30],[131,31,133,31],[131,32,133,32],[131,33,133,33],[131,34,133,34],[131,25,133,25],[131,26,133,26],[131,27,133,27],[131,28,133,28],[131,29,133,29],[131,20,133,20],[131,21,133,21],[131,22,133,22],[131,23,133,23],[131,24,133,24],[131,15,133,15],[131,16,133,16],[131,17,133,17],[131,18,133,18],[131,19,133,19],[129,39,130,39],[129,40,130,40],[129,41,130,41],[131,40,133,40],[131,41,133,41],[129,42,130,42],[129,43,130,43],[129,34,130,34],[129,35,130,35],[129,36,130,36],[129,37,130,37],[129,38,130,38],[129,29,130,29],[129,30,130,30],[129,31,130,31],[129,32,130,32],[129,33,130,33],[123,42,125,42],[123,43,125,43],[129,15,130,15],[129,16,130,16],[129,17,130,17],[129,18,130,18],[129,19,130,19],[129,20,130,20],[129,21,130,21],[129,22,130,22],[129,23,130,23],[129,24,130,24],[129,25,130,25],[129,26,130,26],[129,27,130,27],[129,28,130,28],[123,37,125,37],[123,38,125,38],[123,39,125,39],[123,40,125,40],[123,41,125,41],[123,32,125,32],[123,33,125,33],[123,34,125,34],[123,35,125,35],[123,36,125,36],[123,27,125,27],[123,28,125,28],[123,29,125,29],[123,30,125,30],[123,31,125,31],[121,40,122,40],[121,41,122,41],[121,42,122,42],[121,43,122,43],[123,15,125,15],[123,16,125,16],[123,17,125,17],[123,18,125,18],[123,19,125,19],[123,20,125,20],[123,21,125,21],[123,22,125,22],[123,23,125,23],[123,24,125,24],[123,25,125,25],[123,26,125,26],[121,35,122,35],[121,36,122,36],[121,37,122,37],[121,38,122,38],[121,39,122,39],[121,30,122,30],[121,31,122,31],[121,32,122,32],[121,33,122,33],[121,34,122,34],[121,25,122,25],[121,26,122,26],[121,27,122,27],[121,28,122,28],[121,29,122,29],[121,20,122,20],[121,21,122,21],[121,22,122,22],[121,23,122,23],[121,24,122,24],[121,15,122,15],[121,16,122,16],[121,17,122,17],[121,18,122,18],[121,19,122,19],[113,31,114,31],[113,32,114,32],[113,33,114,33],[115,16,117,16],[115,17,117,17],[115,18,117,18],[115,19,117,19],[115,20,117,20],[113,23,114,23],[113,24,114,24],[113,25,114,25],[113,26,114,26],[113,27,114,27],[113,28,114,28],[113,29,114,29],[113,30,114,30],[115,21,117,21],[115,22,117,22],[115,23,117,23],[0,0,2,0],[156,0,156,1],[156,7,156,11],[156,12,156,14],[113,15,114,15],[115,15,117,15],[111,4,111,43],[113,34,114,34],[113,35,114,35],[113,36,114,36],[113,37,114,37],[113,38,114,38],[113,39,114,39],[113,40,114,40],[113,41,114,41],[113,42,114,42],[113,43,114,43],[113,16,114,16],[113,17,114,17],[113,18,114,18],[113,19,114,19],[113,20,114,20],[113,21,114,21],[113,22,114,22],[115,40,117,40],[115,41,117,41],[115,42,117,42],[115,43,117,43],[115,34,117,34],[115,35,117,35],[115,36,117,36],[115,37,117,37],[115,38,117,38],[115,39,117,39],[115,24,117,24],[115,25,117,25],[115,26,117,26],[115,27,117,27],[115,33,117,33],[115,28,117,28],[115,29,117,29],[115,30,117,30],[115,31,117,31],[115,32,117,32]]}
["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"]
[]
["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]
[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]
["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]
["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]
[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]
["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]
[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]
["Large loads","Services",null,"Services",14264.149419485108,98616.949467570201,269266.73154416599,335522.22155216348,300692.54766307306,150154.75459833004,111909.31276692472,22609.697110018151,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]
["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]
["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]
["Capex not started (Foyle river crossing)",null,null,"Mains",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":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Opex"]
["Total Opex - £2012",null,null,null,4780089.8253407376,6126733.9903890332,6092535.7031120472,5881573.4597288333,5479664.9121174999,5479479.8948119022,5273712.1801263485,4926770.0183473239,5371037.6591285504,5566005.9150725733,5819377.7773323711,{"$f":"P107/$M$1*$K$2","v":6815651.118035295},{"$f":"Q107/$M$1*$K$2","v":7040839.4259325527},7183711.9563182788,7515983.6551076993,8030797.8387831496,8539159.1787710935,9246311.7917562798,9529263.9704645351,9642055.3762118854,9841470.2608399112,10230032.605722621,10332216.981546458,10432409.45146147,10532577.849271653,10627083.050849726,10721957.974904815,10811574.27553566,10901953.257751299,10987388.900338417,{"$f":"AI107/$M$1*$K$2","v":11073933.522924699},11155802.406572323,11238990.530736333,11317808.264403056,11398126.809112124,11474285.222677452,11552161.146013672,11626012.320268091,11701722.068248639,11773575.304322639]
["Total Opex - Av £2014 - FE GD17 Submission",null,null,null,{"$f":"E105/$K$2*$M$2","v":5042039.5355880875},{"$f":"F105/$K$2*$M$2","v":6462480.0228248565},6426407.6637687851,6203884.654678951,5779951.4524189532,5779756.2961345157,5562712.4767710976,{"$f":"L105/$K$2*$M$2","v":5196757.8273461675},{"$f":"M105/$K$2*$M$2","v":5665371.4080630774},{"$f":"N105/$K$2*$M$2","v":5871023.9565660441},{"$f":"O105/$K$2*$M$2","v":6138280.638636535},{"$f":"P107/$M$1*$M$2","v":7189149.9226083048},{"$f":"Q107/$M$1*$M$2","v":7426678.5868921857},7577380.555490233,7927860.7981358515,8470886.883924542,9007106.5091281421,{"$f":"V107/$M$1*$M$2","v":9753011.2018525247},10051469.206588056,10170441.599959796,10380784.45313151,10790640.078553734,10898424.175013982,11004107.20879331,11109764.851312498,11209448.953512691,11309523.039042573,11404050.327717878,11499382.093054524,11589499.622936279,11680786.905103927,11767142.217068458,11854889.0641471,11938026.02260891,12022746.036805537,12103077.943986107,12185221.480756078,12263119.711531239,12342978.366179034,12418769.171432205]
["Total Opex - DEC £2014",null,null,null,{"$f":"E106/$M$2*$M$1","v":5071582.7359919241},{"$f":"F106/$M$2*$M$1","v":6500346.1167085962},6464062.3961736802,6240235.5413274607,5813818.3554604705,5813622.0556821786,{"$f":"K106/$M$2*$M$1","v":5595306.4951896779},5227207.580240774,5698566.9436571971,5905424.4875615481,6174247.1267535463,7231273.8479360882,7470194.2817372568,7621779.2696825583,7974313.1074999291,8520520.986760037,9059882.5238300655,9810157.751863379,10110364.533970408,10230034.03120956,10441609.362036576,10853866.485264011,10962282.129164454,11068584.399469834,11174861.129738158,11275129.31847468,11375789.775599463,11470870.935106849,11566761.285006015,11657406.847289421,11749229.015876021,11836090.315996593,11924351.304757336,12007975.393835133,12093191.814364944,12173994.416314151,12256619.262869883,12334973.928590992,12415300.505043365,12491535.397046065]
["Total Opex - Av £2014 - UR Draft Det",null,null,null,{"$f":"E106","v":5042039.5355880875},{"$f":"F106","v":6462480.0228248565},6426407.6637687851,6203884.654678951,5779951.4524189532,5779756.2961345157,5562712.4767710976,5196757.8273461675,5665371.4080630774,5871023.9565660441,{"$f":"O106","v":6138280.638636535},5425838.8111566827,5581342.3587159719,5688586.7157006832,5861151.288067746,6083403.1381035578,6311921.9869764987,6340884.4782954752,6376567.0068941889,6406742.847627244,6454189.3201468633,6562682.5659656627,6720812.9916738635,6821744.3698380413,6909955.2580570979,6969047.2906954521,6905135.75223302,6831499.2511364445,6812954.74479286,6868689.2599203885,6959764.5214790562,7010655.0314151896,7091675.9111255845,7167438.0464539239,7239109.6162691992,7306751.9108345415,7368206.277936399,7429114.9390185503,7523117.0445959382,7578514.3503050171]
["Total Opex - Av £2014 - UR Final Det",null,null,null,{"$f":"E108","v":5042039.5355880875},{"$f":"F108","v":6462480.0228248565},6426407.6637687851,6203884.654678951,5779951.4524189532,5779756.2961345157,5562712.4767710976,5196757.8273461675,5665371.4080630774,5871023.9565660441,{"$f":"O108","v":6138280.638636535}]
[]
["Volumes (Therms)"]
["Submission",null,null,null,"FORECASTS ARE ILLUSTRATIVE ONLY"]
["Domestic","P1",null,null,64221,558617,1506329,1765161.1017030813,2676992.6535403649,3655315.6994553381,4578235.3113516886,5535454.7706306791,8222120.8526521884,9798128.2439809628,11337112.59500844,9388556.1062499974,10807304.009615382,12362944.11801035,14052003.416144164,15904066.95432537,17923879.434761871,20158865.389391746,22407719.650374446,24587959.171195939,26664677.899170473,28648721.440121811,30490998.902631219,32200909.439254832,33807771.846271574,35319388.645303704,36742963.406578347,38085146.809685931,39352079.16132769,40549429.642590173,41682432.53732048,42755920.673823915,43774356.294242688,44741859.549485318,45662234.802355252,46538994.907477789,47375383.623654902,48174396.302306376,48938798.984604694,49671146.029710799]
["Small IC","P2",null,null,0,2596,20579,1125000,1430000,1887000,2255000,2610000,8795675.3019238226,9434708.3817379549,9821200.8075830545,15793478.437645832,16357532.583924549,16909345.527129546,17449105.318041194,17976997.838411052,18493206.45767083,19069554.667423621,19620168.494631395,19932774.355754331,20508243.78591169,20797987.74983852,21286935.84058746,21498810.599046711,21917676.404874839,22066477.106905349,22428576.261947609,22526286.978270844,22842405.146176558,22898732.974076897,23177606.542402007,23200414.230679803,23449119.673344616,23444776.048528153,23669045.309408128,23642709.120985318,23847185.07461958,23803034.90967562,23991478.284440856,23932898.798514765]
["Medium IC","P3",null,null,0,196639,522544,1872761.2253318976,2624879.6059852978,3089440.658133693,3662526.0563349789,3750125.7196735349,3807199.7661422309,3902269.7661422314,3999351.9223922314]
["Large Firm CHP","P4",null,null,1163837,4264513,7745837,599915.6273257588,599668.1952572451,599265.96313585842,598716.84216108394,598028.40908418782,3337000,3337000,3337000,36035592.830363035,35700024.587514035,35700024.587514035,35700024.587514035,35700024.587514035,35700024.587514035,35700024.587514035,35700024.587514035,35700024.587514035,35700024.587514035,35700024.587514035,35700024.587514035,35700024.587514035,35700024.587514035,35700024.587514035,35700024.587514035,35700024.587514035,35700024.587514035,35700024.587514035,35700024.587514035,35700024.587514035,35700024.587514035,35700024.587514035,35700024.587514035,35700024.587514035,35700024.587514035,35700024.587514035,35700024.587514035,35700024.587514035]
["Large Firm","P5",null,null,0,0,30698,10445530.931120336,13739397.800335582,15604885.680057753,16217243.531336559,16348103.276331419,11018999.999999998,11018999.999999998,11018999.999999998]
["Int","P6",null,null,4770961,9073301,14530386,11426119.582749041,13355461.799958056,13659721.423725909,13647204.711606814,13631512.50709703,23389390.873258937,23418346.129278943,23441549.504552245]
["Total Volume (Therms) - FE GD17 Submission",null,null,null,{"$f":"SUM(E113:E118)","v":5999019},{"$f":"SUM(F113:F118)","v":14095666},24356373,27234488.468230113,34426400.055076547,38495629.424508549,40958926.452791125,42473224.682816848,58570386.793977171,60909452.521140091,62955214.829535969,61217627.374258861,62864861.181053966,64972314.232653931,67201133.321699396,69581089.380250454,72117110.479946733,74928444.644329399,77727912.732519865,80220758.114464313,82872946.27259621,85146733.777474374,87477959.330732703,89399744.62581557,91425472.838660449,93085890.33972308,94871564.256039992,96311458.375470817,97894508.89501828,99148187.204181105,100560063.66723652,101656359.49201775,102923500.55510134,103886660.1855275,105031304.69927743,105881728.61597714,106922593.28578851,107677455.79949602,108630301.85655957,109304069.4157396]
["GD17 DD"]
["Domestic","P1",null,null,{"$f":"E113","v":64221},{"$f":"F113","v":558617},1506329,1765161.1017030813,2676992.6535403649,3655315.6994553381,4578235.3113516886,5535454.7706306791,8222120.8526521884,9798128.2439809628,11337112.59500844,10151055.000000002,11645555,13273054.999999998,15024054.999999994,16889054.999999993,18849054.999999985,20825354.999999985,22751354.999999985,24658354.999999985,26508354.999999985,28282354.999999985,29978729.999999985,31597479.999999985,33140229.999999985,34606979.999999985,36016729.999999985,37369479.999999985,38665229.999999985,39922979.999999985,41142729.999999993,42305479.999999993,43411229.999999993,44478979.999999993,45508729.999999993,46500479.999999993,47454229.999999993,48369979.999999993,49266729.999999993,50144479.999999993]
["Small IC","P2",null,null,{"$f":"E114","v":0},2596,20579,1125000,1430000,1887000,2255000,2610000,8795675.3019238226,9434708.3817379549,9821200.8075830545,15793478.437645832,16357532.583924549,16909345.527129546,17449105.318041194,17976997.838411052,18493206.45767083,19069554.667423621,19620168.494631395,19932774.355754331,20508243.78591169,20797987.74983852,21286935.84058746,21498810.599046711,21917676.404874839,22066477.106905349,22428576.261947609,22526286.978270844,22842405.146176558,22898732.974076897,23177606.542402007,23200414.230679803,23449119.673344616,23444776.048528153,23669045.309408128,23642709.120985318,23847185.07461958,23803034.90967562,23991478.284440856,23932898.798514765]
["Medium IC","P3",null,null,0,196639,522544,1872761.2253318976,2624879.6059852978,3089440.658133693,3662526.0563349789,3750125.7196735349,3807199.7661422309,3902269.7661422314,3999351.9223922314]
["Large Firm CHP","P4",null,null,1163837,4264513,7745837,599915.6273257588,599668.1952572451,599265.96313585842,598716.84216108394,598028.40908418782,3337000,3337000,3337000,36035592.830363035,35700024.587514035,35700024.587514035,35700024.587514035,35700024.587514035,35700024.587514035,35700024.587514035,35700024.587514035,35700024.587514035,35700024.587514035,35700024.587514035,35700024.587514035,35700024.587514035,35700024.587514035,35700024.587514035,35700024.587514035,35700024.587514035,35700024.587514035,35700024.587514035,35700024.587514035,35700024.587514035,35700024.587514035,35700024.587514035,35700024.587514035,35700024.587514035,35700024.587514035,35700024.587514035,35700024.587514035,35700024.587514035]
["Large Firm","P5",null,null,0,0,30698,10445530.931120336,13739397.800335582,15604885.680057753,16217243.531336559,16348103.276331419,11018999.999999998,11018999.999999998,11018999.999999998]
["Int","P6",null,null,4770961,9073301,14530386,11426119.582749041,13355461.799958056,13659721.423725909,13647204.711606814,13631512.50709703,23389390.873258937,23418346.129278943,23441549.504552245]
["Total Volume (Therms) - UR Draft Det",null,null,null,{"$f":"SUM(E121:E126)","v":5999019},{"$f":"SUM(F121:F126)","v":14095666},24356373,27234488.468230113,34426400.055076547,38495629.424508549,40958926.452791125,42473224.682816848,58570386.793977171,60909452.521140091,62955214.829535969,61980126.268008873,63703112.171438582,65882425.114643581,68173184.905555218,70566077.425925076,73042286.045184851,75594934.254937649,78071548.082145423,80291153.943268359,82716623.373425722,84780367.337352544,86965690.42810148,88796315.18656072,90757930.992388859,92373481.694419369,94145330.84946163,95595791.565784872,97207659.73369059,98521737.56159091,100020361.12991604,101205918.81819382,102560374.26085865,103623780.63604218,104877799.89692217,105843213.70849934,107001439.6621336,107873039.49718964,108958232.87195489,109777403.3860288]
["GD17 FD"]
["Domestic","P1",null,null,{"$f":"E121","v":64221},{"$f":"F121","v":558617},1506329,1765161.1017030813,2676992.6535403649,3655315.6994553381,4578235.3113516886,5535454.7706306791,8222120.8526521884,9798128.2439809628,11337112.59500844]
["Small IC","P2",null,null,{"$f":"E122","v":0},2596,20579,1125000,1430000,1887000,2255000,2610000,8795675.3019238226,9434708.3817379549,9821200.8075830545]
["Medium IC","P3",null,null,0,196639,522544,1872761.2253318976,2624879.6059852978,3089440.658133693,3662526.0563349789,3750125.7196735349,3807199.7661422309,3902269.7661422314,3999351.9223922314]
["Large Firm CHP","P4",null,null,1163837,4264513,7745837,599915.6273257588,599668.1952572451,599265.96313585842,598716.84216108394,598028.40908418782,3337000,3337000,3337000]
["Large Firm","P5",null,null,0,0,30698,10445530.931120336,13739397.800335582,15604885.680057753,16217243.531336559,16348103.276331419,11018999.999999998,11018999.999999998,11018999.999999998]
["Int","P6",null,null,{"$f":"E126","v":4770961},{"$f":"F126","v":9073301},14530386,11426119.582749041,13355461.799958056,13659721.423725909,13647204.711606814,13631512.50709703,23389390.873258937,23418346.129278943,23441549.504552245]
["Total Volume (Therms) - UR Final Det",null,null,null,{"$f":"SUM(E129:E134)","v":5999019},{"$f":"SUM(F129:F134)","v":14095666},24356373,27234488.468230113,34426400.055076547,38495629.424508549,40958926.452791125,42473224.682816848,58570386.793977171,60909452.521140091,62955214.829535969,{"$f":"SUM(P129:P134)","v":0},{"$f":"SUM(Q129:Q134)","v":0},{"$f":"SUM(R129:R134)","v":0},{"$f":"SUM(S129:S134)","v":0},{"$f":"SUM(T129:T134)","v":0},{"$f":"SUM(U129:U134)","v":0},{"$f":"SUM(V129:V134)","v":0},{"$f":"SUM(W129:W134)","v":0},{"$f":"SUM(X129:X134)","v":0},{"$f":"SUM(Y129:Y134)","v":0},{"$f":"SUM(Z129:Z134)","v":0},{"$f":"SUM(AA129:AA134)","v":0},{"$f":"SUM(AB129:AB134)","v":0},{"$f":"SUM(AC129:AC134)","v":0},{"$f":"SUM(AD129:AD134)","v":0},{"$f":"SUM(AE129:AE134)","v":0},{"$f":"SUM(AF129:AF134)","v":0},{"$f":"SUM(AG129:AG134)","v":0},{"$f":"SUM(AH129:AH134)","v":0},{"$f":"SUM(AI129:AI134)","v":0},{"$f":"SUM(AJ129:AJ134)","v":0},{"$f":"SUM(AK129:AK134)","v":0},{"$f":"SUM(AL129:AL134)","v":0},{"$f":"SUM(AM129:AM134)","v":0},{"$f":"SUM(AN129:AN134)","v":0},{"$f":"SUM(AO129:AO134)","v":0},{"$f":"SUM(AP129:AP134)","v":0},{"$f":"SUM(AQ129:AQ134)","v":0},0]
[]
["TRV Opening Value (£2014)"]
["DAV (Incl Retrospective Capex Adjustments)",null,null,null,null,null,null,null,null,null,null,{"$f":"DAV!L35","v":87789156.407069787},null,null,{"$f":"DAV!O35","v":105240391.68242395}]
["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":"D151+H163","v":2922657.9180946201},{"$f":"I163","v":631836.17924617918},{"$f":"J163","v":1560191.3248136702},{"$f":"K163","v":2070553.9375680764},{"$f":"L163","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":"M163","v":-603995.03534388205},{"$f":"N163","v":-265007.63093670085},-296639.33589103405]
["Adjusted PAB",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H139:L142)","v":39604044.969824679},null,null,{"$f":"SUM(M139:O142)","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":3151866.0913126227},{"$f":"DAV!N29","v":3450631.267287754},{"$f":"DAV!O29","v":3804343.3497931482}]
["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(H144:L145)","v":-199585.99600249715},null,null,{"$f":"SUM(M144:O145)","v":-366020.74276150344}]
["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(L138,L143,L146,L147)","v":127193615.38089198},null,null,{"$f":"SUM(O138,O143,O146,O147)","v":143372644.47642598}]
[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(D151:D153)","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,1542745.287249893]
["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]
["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},0,0,0]
["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]
["Total Retrospective Adjustments",null,null,null,null,null,null,{"$f":"SUM(H160:H163)","v":-2939924.2628231007},-2610654.2192367935,2983024.5412638495,8098106.3550026324,{"$f":"SUM(L160:L163)","v":4874238.5312672332},{"$f":"SUM(M160:M163)","v":-6187311.9623758011},{"$f":"SUM(N160:N163)","v":-328340.27829212788},1344338.2113042648]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M164:O164)","v":-5171314.0293636639}]
[]
["INPUTS BASIS",null,null,null,null,null,null,null,null,null,null,{"$f":"L166-L165","v":0}]
["SELECT BASIS OF MODELLING INPUTS","UR Draft Det"]
[null,"FE GD17 Submission"]
[null,"UR Draft Det"]
[null,"UR Final Det"]

{"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":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!E38,Inputs!E40,Inputs!E49),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!E68,Inputs!E70,Inputs!E79),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!E83,Inputs!E85,Inputs!E94),0)))","v":9163851.6796381921},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!F38,Inputs!F40,Inputs!F49),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!F68,Inputs!F70,Inputs!F79),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!F83,Inputs!F85,Inputs!F94),0)))","v":11978318.038899688},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!G38,Inputs!G40,Inputs!G49),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!G68,Inputs!G70,Inputs!G79),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!G83,Inputs!G85,Inputs!G94),0)))","v":9339553.2945472579},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!H38,Inputs!H40,Inputs!H49),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!H68,Inputs!H70,Inputs!H79),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!H83,Inputs!H85,Inputs!H94),0)))","v":11701933.90685294},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!I38,Inputs!I40,Inputs!I49),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!I68,Inputs!I70,Inputs!I79),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!I83,Inputs!I85,Inputs!I94),0)))","v":11411316.911880756},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!J38,Inputs!J40,Inputs!J49),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!J68,Inputs!J70,Inputs!J79),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!J83,Inputs!J85,Inputs!J94),0)))","v":8068448.5974650811},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!K38,Inputs!K40,Inputs!K49),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!K68,Inputs!K70,Inputs!K79),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!K83,Inputs!K85,Inputs!K94),0)))","v":6362519.7349370094},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!L38,Inputs!L40,Inputs!L49),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!L68,Inputs!L70,Inputs!L79),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!L83,Inputs!L85,Inputs!L94),0)))","v":5351409.6990729105},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!M38,Inputs!M40,Inputs!M49),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!M68,Inputs!M70,Inputs!M79),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!M83,Inputs!M85,Inputs!M94),0)))","v":8114852.2532176292},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!N38,Inputs!N40,Inputs!N49),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!N68,Inputs!N70,Inputs!N79),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!N83,Inputs!N85,Inputs!N94),0)))","v":6433044.3068478424},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!O38,Inputs!O40,Inputs!O49),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!O68,Inputs!O70,Inputs!O79),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!O83,Inputs!O85,Inputs!O94),0)))","v":5775361.9576727748},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!P38,Inputs!P40,Inputs!P49),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!P68,Inputs!P70,Inputs!P79),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!P83,Inputs!P85,Inputs!P94),0)))","v":8555091.644436311},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!Q38,Inputs!Q40,Inputs!Q49),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!Q68,Inputs!Q70,Inputs!Q79),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!Q83,Inputs!Q85,Inputs!Q94),0)))","v":8281762.3229990024},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!R38,Inputs!R40,Inputs!R49),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!R68,Inputs!R70,Inputs!R79),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!R83,Inputs!R85,Inputs!R94),0)))","v":8161225.047773717},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!S38,Inputs!S40,Inputs!S49),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!S68,Inputs!S70,Inputs!S79),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!S83,Inputs!S85,Inputs!S94),0)))","v":8125322.5929647023},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!T38,Inputs!T40,Inputs!T49),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!T68,Inputs!T70,Inputs!T79),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!T83,Inputs!T85,Inputs!T94),0)))","v":8223366.0130449189},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!U38,Inputs!U40,Inputs!U49),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!U68,Inputs!U70,Inputs!U79),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!U83,Inputs!U85,Inputs!U94),0)))","v":8250559.77759209},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!V38,Inputs!V40,Inputs!V49),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!V68,Inputs!V70,Inputs!V79),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!V83,Inputs!V85,Inputs!V94),0)))","v":8453132.4855783507},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!W38,Inputs!W40,Inputs!W49),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!W68,Inputs!W70,Inputs!W79),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!W83,Inputs!W85,Inputs!W94),0)))","v":7589340.6137340749},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!X38,Inputs!X40,Inputs!X49),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!X68,Inputs!X70,Inputs!X79),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!X83,Inputs!X85,Inputs!X94),0)))","v":7879579.3768352084},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!Y38,Inputs!Y40,Inputs!Y49),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!Y68,Inputs!Y70,Inputs!Y79),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!Y83,Inputs!Y85,Inputs!Y94),0)))","v":5273178.960268897},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!Z38,Inputs!Z40,Inputs!Z49),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!Z68,Inputs!Z70,Inputs!Z79),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!Z83,Inputs!Z85,Inputs!Z94),0)))","v":2049709.2412921893},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AA38,Inputs!AA40,Inputs!AA49),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AA68,Inputs!AA70,Inputs!AA79),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AA83,Inputs!AA85,Inputs!AA94),0)))","v":2044389.6513965565},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AB38,Inputs!AB40,Inputs!AB49),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AB68,Inputs!AB70,Inputs!AB79),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AB83,Inputs!AB85,Inputs!AB94),0)))","v":2036741.719915896},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AC38,Inputs!AC40,Inputs!AC49),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AC68,Inputs!AC70,Inputs!AC79),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AC83,Inputs!AC85,Inputs!AC94),0)))","v":2030756.3092185059},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AD38,Inputs!AD40,Inputs!AD49),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AD68,Inputs!AD70,Inputs!AD79),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AD83,Inputs!AD85,Inputs!AD94),0)))","v":2023772.1763426452},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AE38,Inputs!AE40,Inputs!AE49),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AE68,Inputs!AE70,Inputs!AE79),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AE83,Inputs!AE85,Inputs!AE94),0)))","v":2025056.4298815154},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AF38,Inputs!AF40,Inputs!AF49),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AF68,Inputs!AF70,Inputs!AF79),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AF83,Inputs!AF85,Inputs!AF94),0)))","v":2017952.3897440073},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AG38,Inputs!AG40,Inputs!AG49),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AG68,Inputs!AG70,Inputs!AG79),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AG83,Inputs!AG85,Inputs!AG94),0)))","v":2019538.2637438904},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AH38,Inputs!AH40,Inputs!AH49),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AH68,Inputs!AH70,Inputs!AH79),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AH83,Inputs!AH85,Inputs!AH94),0)))","v":2020815.0240027274},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AI38,Inputs!AI40,Inputs!AI49),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AI68,Inputs!AI70,Inputs!AI79),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AI83,Inputs!AI85,Inputs!AI94),0)))","v":2022216.8998972939},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AJ38,Inputs!AJ40,Inputs!AJ49),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AJ68,Inputs!AJ70,Inputs!AJ79),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AJ83,Inputs!AJ85,Inputs!AJ94),0)))","v":2016419.265806979},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AK38,Inputs!AK40,Inputs!AK49),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AK68,Inputs!AK70,Inputs!AK79),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AK83,Inputs!AK85,Inputs!AK94),0)))","v":2017145.3566747506},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AL38,Inputs!AL40,Inputs!AL49),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AL68,Inputs!AL70,Inputs!AL79),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AL83,Inputs!AL85,Inputs!AL94),0)))","v":2018598.5189045211},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AM38,Inputs!AM40,Inputs!AM49),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AM68,Inputs!AM70,Inputs!AM79),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AM83,Inputs!AM85,Inputs!AM94),0)))","v":2020003.4711567846},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AN38,Inputs!AN40,Inputs!AN49),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AN68,Inputs!AN70,Inputs!AN79),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AN83,Inputs!AN85,Inputs!AN94),0)))","v":2019965.8070137941},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AO38,Inputs!AO40,Inputs!AO49),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AO68,Inputs!AO70,Inputs!AO79),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AO83,Inputs!AO85,Inputs!AO94),0)))","v":2021067.6757632357},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AP38,Inputs!AP40,Inputs!AP49),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AP68,Inputs!AP70,Inputs!AP79),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AP83,Inputs!AP85,Inputs!AP94),0)))","v":2020852.1249681364},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AQ38,Inputs!AQ40,Inputs!AQ49),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AQ68,Inputs!AQ70,Inputs!AQ79),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AQ83,Inputs!AQ85,Inputs!AQ94),0)))","v":2028099.1836716477},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AR38,Inputs!AR40,Inputs!AR49),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AR68,Inputs!AR70,Inputs!AR79),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AR83,Inputs!AR85,Inputs!AR94),0)))","v":2028363.5652776069}]
["Services",null,null,null,{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!E41,Inputs!E43,Inputs!E45),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!E71,Inputs!E73,Inputs!E75),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!E86,Inputs!E88,Inputs!E90),0)))","v":387648.09692074714},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!F41,Inputs!F43,Inputs!F45),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!F71,Inputs!F73,Inputs!F75),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!F86,Inputs!F88,Inputs!F90),0)))","v":694810.81432720169},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!G41,Inputs!G43,Inputs!G45),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!G71,Inputs!G73,Inputs!G75),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!G86,Inputs!G88,Inputs!G90),0)))","v":1678078.4636649806},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!H41,Inputs!H43,Inputs!H45),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!H71,Inputs!H73,Inputs!H75),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!H86,Inputs!H88,Inputs!H90),0)))+Inputs!H160","v":-630403.40122518362},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!I41,Inputs!I43,Inputs!I45),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!I71,Inputs!I73,Inputs!I75),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!I86,Inputs!I88,Inputs!I90),0)))+Inputs!I160","v":-1312640.5968377264},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!J41,Inputs!J43,Inputs!J45),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!J71,Inputs!J73,Inputs!J75),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!J86,Inputs!J88,Inputs!J90),0)))+Inputs!J160","v":3656705.096449065},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!K41,Inputs!K43,Inputs!K45),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!K71,Inputs!K73,Inputs!K75),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!K86,Inputs!K88,Inputs!K90),0)))+Inputs!K160","v":7053872.0739982976},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!L41,Inputs!L43,Inputs!L45),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!L71,Inputs!L73,Inputs!L75),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!L86,Inputs!L88,Inputs!L90),0)))+Inputs!L160","v":4120019.0686176717},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!M41,Inputs!M43,Inputs!M45),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!M71,Inputs!M73,Inputs!M75),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!M86,Inputs!M88,Inputs!M90),0)))+Inputs!M160","v":-2712649.8425945938},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!N41,Inputs!N43,Inputs!N45),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!N71,Inputs!N73,Inputs!N75),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!N86,Inputs!N88,Inputs!N90),0)))+Inputs!N160","v":2589751.318880152},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!O41,Inputs!O43,Inputs!O45),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!O71,Inputs!O73,Inputs!O75),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!O86,Inputs!O88,Inputs!O90),0)))+Inputs!O160","v":4130887.3556470913},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!P41,Inputs!P43,Inputs!P45),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!P71,Inputs!P73,Inputs!P75),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!P86,Inputs!P88,Inputs!P90),0)))","v":3005471.9765418079},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!Q41,Inputs!Q43,Inputs!Q45),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!Q71,Inputs!Q73,Inputs!Q75),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!Q86,Inputs!Q88,Inputs!Q90),0)))","v":3224354.1598394569},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!R41,Inputs!R43,Inputs!R45),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!R71,Inputs!R73,Inputs!R75),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!R86,Inputs!R88,Inputs!R90),0)))","v":3446565.9497453151},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!S41,Inputs!S43,Inputs!S45),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!S71,Inputs!S73,Inputs!S75),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!S86,Inputs!S88,Inputs!S90),0)))","v":3637114.3336014189},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!T41,Inputs!T43,Inputs!T45),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!T71,Inputs!T73,Inputs!T75),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!T86,Inputs!T88,Inputs!T90),0)))","v":3825235.9677817095},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!U41,Inputs!U43,Inputs!U45),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!U71,Inputs!U73,Inputs!U75),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!U86,Inputs!U88,Inputs!U90),0)))","v":3941348.4345612717},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!V41,Inputs!V43,Inputs!V45),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!V71,Inputs!V73,Inputs!V75),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!V86,Inputs!V88,Inputs!V90),0)))","v":3874841.3943032329},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!W41,Inputs!W43,Inputs!W45),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!W71,Inputs!W73,Inputs!W75),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!W86,Inputs!W88,Inputs!W90),0)))","v":3893536.3262858912},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!X41,Inputs!X43,Inputs!X45),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!X71,Inputs!X73,Inputs!X75),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!X86,Inputs!X88,Inputs!X90),0)))","v":3826935.7174001043},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!Y41,Inputs!Y43,Inputs!Y45),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!Y71,Inputs!Y73,Inputs!Y75),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!Y86,Inputs!Y88,Inputs!Y90),0)))","v":3683475.0857356088},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!Z41,Inputs!Z43,Inputs!Z45),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!Z71,Inputs!Z73,Inputs!Z75),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!Z86,Inputs!Z88,Inputs!Z90),0)))","v":3509920.1733185416},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AA41,Inputs!AA43,Inputs!AA45),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AA71,Inputs!AA73,Inputs!AA75),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AA86,Inputs!AA88,Inputs!AA90),0)))","v":3307624.6959665469},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AB41,Inputs!AB43,Inputs!AB45),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AB71,Inputs!AB73,Inputs!AB75),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AB86,Inputs!AB88,Inputs!AB90),0)))","v":3135209.7184264706},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AC41,Inputs!AC43,Inputs!AC45),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AC71,Inputs!AC73,Inputs!AC75),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AC86,Inputs!AC88,Inputs!AC90),0)))","v":2972940.1612916179},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AD41,Inputs!AD43,Inputs!AD45),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AD71,Inputs!AD73,Inputs!AD75),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AD86,Inputs!AD88,Inputs!AD90),0)))","v":2805354.6579632568},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AE41,Inputs!AE43,Inputs!AE45),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AE71,Inputs!AE73,Inputs!AE75),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AE86,Inputs!AE88,Inputs!AE90),0)))","v":2717437.2668777318},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AF41,Inputs!AF43,Inputs!AF45),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AF71,Inputs!AF73,Inputs!AF75),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AF86,Inputs!AF88,Inputs!AF90),0)))","v":2551747.9051119047},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AG41,Inputs!AG43,Inputs!AG45),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AG71,Inputs!AG73,Inputs!AG75),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AG86,Inputs!AG88,Inputs!AG90),0)))","v":2468504.2470220444},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AH41,Inputs!AH43,Inputs!AH45),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AH71,Inputs!AH73,Inputs!AH75),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AH86,Inputs!AH88,Inputs!AH90),0)))","v":2381726.7908135108},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AI41,Inputs!AI43,Inputs!AI45),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AI71,Inputs!AI73,Inputs!AI75),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AI86,Inputs!AI88,Inputs!AI90),0)))","v":2301902.9373546247},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AJ41,Inputs!AJ43,Inputs!AJ45),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AJ71,Inputs!AJ73,Inputs!AJ75),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AJ86,Inputs!AJ88,Inputs!AJ90),0)))","v":2145105.0676293303},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AK41,Inputs!AK43,Inputs!AK45),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AK71,Inputs!AK73,Inputs!AK75),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AK86,Inputs!AK88,Inputs!AK90),0)))","v":2062431.3769779655},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AL41,Inputs!AL43,Inputs!AL45),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AL71,Inputs!AL73,Inputs!AL75),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AL86,Inputs!AL88,Inputs!AL90),0)))","v":1983975.4453714686},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AM41,Inputs!AM43,Inputs!AM45),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AM71,Inputs!AM73,Inputs!AM75),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AM86,Inputs!AM88,Inputs!AM90),0)))","v":1904151.5919125827},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AN41,Inputs!AN43,Inputs!AN45),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AN71,Inputs!AN73,Inputs!AN75),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AN86,Inputs!AN88,Inputs!AN90),0)))","v":1816959.9094816032},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AO41,Inputs!AO43,Inputs!AO45),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AO71,Inputs!AO73,Inputs!AO75),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AO86,Inputs!AO88,Inputs!AO90),0)))","v":1738275.9908997079},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AP41,Inputs!AP43,Inputs!AP45),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AP71,Inputs!AP73,Inputs!AP75),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AP86,Inputs!AP88,Inputs!AP90),0)))","v":1662783.8899733888},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AQ41,Inputs!AQ43,Inputs!AQ45),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AQ71,Inputs!AQ73,Inputs!AQ75),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AQ86,Inputs!AQ88,Inputs!AQ90),0)))","v":1658680.12441622},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AR41,Inputs!AR43,Inputs!AR45),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AR71,Inputs!AR73,Inputs!AR75),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AR86,Inputs!AR88,Inputs!AR90),0)))","v":1581820.1016375113}]
["Meters, PRS, Telemetry",null,null,null,{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!E39,Inputs!E42,Inputs!E44,Inputs!E46,Inputs!E47),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!E69,Inputs!E72,Inputs!E74,Inputs!E76,Inputs!E77),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!E84,Inputs!E87,Inputs!E89,Inputs!E91,Inputs!E92),0)))","v":485054.13197872031},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!F39,Inputs!F42,Inputs!F44,Inputs!F46,Inputs!F47),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!F69,Inputs!F72,Inputs!F74,Inputs!F76,Inputs!F77),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!F84,Inputs!F87,Inputs!F89,Inputs!F91,Inputs!F92),0)))","v":907299.53115880338},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!G39,Inputs!G42,Inputs!G44,Inputs!G46,Inputs!G47),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!G69,Inputs!G72,Inputs!G74,Inputs!G76,Inputs!G77),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!G84,Inputs!G87,Inputs!G89,Inputs!G91,Inputs!G92),0)))","v":1923187.4220036054},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!H39,Inputs!H42,Inputs!H44,Inputs!H46,Inputs!H47),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!H69,Inputs!H72,Inputs!H74,Inputs!H76,Inputs!H77),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!H84,Inputs!H87,Inputs!H89,Inputs!H91,Inputs!H92),0)))+Inputs!H161","v":984043.88064654276},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!I39,Inputs!I42,Inputs!I44,Inputs!I46,Inputs!I47),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!I69,Inputs!I72,Inputs!I74,Inputs!I76,Inputs!I77),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!I84,Inputs!I87,Inputs!I89,Inputs!I91,Inputs!I92),0)))+Inputs!I161","v":1056773.1340342006},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!J39,Inputs!J42,Inputs!J44,Inputs!J46,Inputs!J47),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!J69,Inputs!J72,Inputs!J74,Inputs!J76,Inputs!J77),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!J84,Inputs!J87,Inputs!J89,Inputs!J91,Inputs!J92),0)))+Inputs!J161","v":1371365.7238618857},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!K39,Inputs!K42,Inputs!K44,Inputs!K46,Inputs!K47),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!K69,Inputs!K72,Inputs!K74,Inputs!K76,Inputs!K77),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!K84,Inputs!K87,Inputs!K89,Inputs!K91,Inputs!K92),0)))+Inputs!K161","v":1490095.8271706537},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!L39,Inputs!L42,Inputs!L44,Inputs!L46,Inputs!L47),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!L69,Inputs!L72,Inputs!L74,Inputs!L76,Inputs!L77),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!L84,Inputs!L87,Inputs!L89,Inputs!L91,Inputs!L92),0)))+Inputs!L161","v":1261869.9252227889},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!M39,Inputs!M42,Inputs!M44,Inputs!M46,Inputs!M47),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!M69,Inputs!M72,Inputs!M74,Inputs!M76,Inputs!M77),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!M84,Inputs!M87,Inputs!M89,Inputs!M91,Inputs!M92),0)))+Inputs!M161","v":1101163.9497612736},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!N39,Inputs!N42,Inputs!N44,Inputs!N46,Inputs!N47),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!N69,Inputs!N72,Inputs!N74,Inputs!N76,Inputs!N77),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!N84,Inputs!N87,Inputs!N89,Inputs!N91,Inputs!N92),0)))+Inputs!N161","v":1203206.3675097858},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!O39,Inputs!O42,Inputs!O44,Inputs!O46,Inputs!O47),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!O69,Inputs!O72,Inputs!O74,Inputs!O76,Inputs!O77),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!O84,Inputs!O87,Inputs!O89,Inputs!O91,Inputs!O92),0)))+Inputs!O161","v":1048416.2896116604},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!P39,Inputs!P42,Inputs!P44,Inputs!P46,Inputs!P47),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!P69,Inputs!P72,Inputs!P74,Inputs!P76,Inputs!P77),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!P84,Inputs!P87,Inputs!P89,Inputs!P91,Inputs!P92),0)))","v":1156243.9637072191},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!Q39,Inputs!Q42,Inputs!Q44,Inputs!Q46,Inputs!Q47),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!Q69,Inputs!Q72,Inputs!Q74,Inputs!Q76,Inputs!Q77),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!Q84,Inputs!Q87,Inputs!Q89,Inputs!Q91,Inputs!Q92),0)))","v":1239252.9827672308},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!R39,Inputs!R42,Inputs!R44,Inputs!R46,Inputs!R47),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!R69,Inputs!R72,Inputs!R74,Inputs!R76,Inputs!R77),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!R84,Inputs!R87,Inputs!R89,Inputs!R91,Inputs!R92),0)))","v":1302055.1158924042},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!S39,Inputs!S42,Inputs!S44,Inputs!S46,Inputs!S47),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!S69,Inputs!S72,Inputs!S74,Inputs!S76,Inputs!S77),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!S84,Inputs!S87,Inputs!S89,Inputs!S91,Inputs!S92),0)))","v":1365437.5311262014},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!T39,Inputs!T42,Inputs!T44,Inputs!T46,Inputs!T47),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!T69,Inputs!T72,Inputs!T74,Inputs!T76,Inputs!T77),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!T84,Inputs!T87,Inputs!T89,Inputs!T91,Inputs!T92),0)))","v":1416959.1584923044},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!U39,Inputs!U42,Inputs!U44,Inputs!U46,Inputs!U47),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!U69,Inputs!U72,Inputs!U74,Inputs!U76,Inputs!U77),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!U84,Inputs!U87,Inputs!U89,Inputs!U91,Inputs!U92),0)))","v":1485987.8647616156},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!V39,Inputs!V42,Inputs!V44,Inputs!V46,Inputs!V47),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!V69,Inputs!V72,Inputs!V74,Inputs!V76,Inputs!V77),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!V84,Inputs!V87,Inputs!V89,Inputs!V91,Inputs!V92),0)))","v":1499053.7928598779},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!W39,Inputs!W42,Inputs!W44,Inputs!W46,Inputs!W47),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!W69,Inputs!W72,Inputs!W74,Inputs!W76,Inputs!W77),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!W84,Inputs!W87,Inputs!W89,Inputs!W91,Inputs!W92),0)))","v":1528801.4860419447},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!X39,Inputs!X42,Inputs!X44,Inputs!X46,Inputs!X47),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!X69,Inputs!X72,Inputs!X74,Inputs!X76,Inputs!X77),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!X84,Inputs!X87,Inputs!X89,Inputs!X91,Inputs!X92),0)))","v":1544794.2816161243},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!Y39,Inputs!Y42,Inputs!Y44,Inputs!Y46,Inputs!Y47),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!Y69,Inputs!Y72,Inputs!Y74,Inputs!Y76,Inputs!Y77),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!Y84,Inputs!Y87,Inputs!Y89,Inputs!Y91,Inputs!Y92),0)))","v":1692666.1256531589},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!Z39,Inputs!Z42,Inputs!Z44,Inputs!Z46,Inputs!Z47),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!Z69,Inputs!Z72,Inputs!Z74,Inputs!Z76,Inputs!Z77),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!Z84,Inputs!Z87,Inputs!Z89,Inputs!Z91,Inputs!Z92),0)))","v":1890413.6368723335},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AA39,Inputs!AA42,Inputs!AA44,Inputs!AA46,Inputs!AA47),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AA69,Inputs!AA72,Inputs!AA74,Inputs!AA76,Inputs!AA77),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AA84,Inputs!AA87,Inputs!AA89,Inputs!AA91,Inputs!AA92),0)))","v":2075345.0671638974},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AB39,Inputs!AB42,Inputs!AB44,Inputs!AB46,Inputs!AB47),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AB69,Inputs!AB72,Inputs!AB74,Inputs!AB76,Inputs!AB77),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AB84,Inputs!AB87,Inputs!AB89,Inputs!AB91,Inputs!AB92),0)))","v":2381908.4396117702},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AC39,Inputs!AC42,Inputs!AC44,Inputs!AC46,Inputs!AC47),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AC69,Inputs!AC72,Inputs!AC74,Inputs!AC76,Inputs!AC77),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AC84,Inputs!AC87,Inputs!AC89,Inputs!AC91,Inputs!AC92),0)))","v":2245873.4973011771},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AD39,Inputs!AD42,Inputs!AD44,Inputs!AD46,Inputs!AD47),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AD69,Inputs!AD72,Inputs!AD74,Inputs!AD76,Inputs!AD77),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AD84,Inputs!AD87,Inputs!AD89,Inputs!AD91,Inputs!AD92),0)))","v":2391397.9454106302},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AE39,Inputs!AE42,Inputs!AE44,Inputs!AE46,Inputs!AE47),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AE69,Inputs!AE72,Inputs!AE74,Inputs!AE76,Inputs!AE77),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AE84,Inputs!AE87,Inputs!AE89,Inputs!AE91,Inputs!AE92),0)))","v":2491064.59725704},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AF39,Inputs!AF42,Inputs!AF44,Inputs!AF46,Inputs!AF47),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AF69,Inputs!AF72,Inputs!AF74,Inputs!AF76,Inputs!AF77),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AF84,Inputs!AF87,Inputs!AF89,Inputs!AF91,Inputs!AF92),0)))","v":2328042.8202529829},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AG39,Inputs!AG42,Inputs!AG44,Inputs!AG46,Inputs!AG47),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AG69,Inputs!AG72,Inputs!AG74,Inputs!AG76,Inputs!AG77),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AG84,Inputs!AG87,Inputs!AG89,Inputs!AG91,Inputs!AG92),0)))","v":2381272.6201417278},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AH39,Inputs!AH42,Inputs!AH44,Inputs!AH46,Inputs!AH47),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AH69,Inputs!AH72,Inputs!AH74,Inputs!AH76,Inputs!AH77),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AH84,Inputs!AH87,Inputs!AH89,Inputs!AH91,Inputs!AH92),0)))","v":2230564.4687711922},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AI39,Inputs!AI42,Inputs!AI44,Inputs!AI46,Inputs!AI47),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AI69,Inputs!AI72,Inputs!AI74,Inputs!AI76,Inputs!AI77),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AI84,Inputs!AI87,Inputs!AI89,Inputs!AI91,Inputs!AI92),0)))","v":2066242.2563939414},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AJ39,Inputs!AJ42,Inputs!AJ44,Inputs!AJ46,Inputs!AJ47),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AJ69,Inputs!AJ72,Inputs!AJ74,Inputs!AJ76,Inputs!AJ77),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AJ84,Inputs!AJ87,Inputs!AJ89,Inputs!AJ91,Inputs!AJ92),0)))","v":2267232.3421582957},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AK39,Inputs!AK42,Inputs!AK44,Inputs!AK46,Inputs!AK47),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AK69,Inputs!AK72,Inputs!AK74,Inputs!AK76,Inputs!AK77),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AK84,Inputs!AK87,Inputs!AK89,Inputs!AK91,Inputs!AK92),0)))","v":2326505.9202928618},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AL39,Inputs!AL42,Inputs!AL44,Inputs!AL46,Inputs!AL47),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AL69,Inputs!AL72,Inputs!AL74,Inputs!AL76,Inputs!AL77),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AL84,Inputs!AL87,Inputs!AL89,Inputs!AL91,Inputs!AL92),0)))","v":2364324.0822256822},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AM39,Inputs!AM42,Inputs!AM44,Inputs!AM46,Inputs!AM47),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AM69,Inputs!AM72,Inputs!AM74,Inputs!AM76,Inputs!AM77),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AM84,Inputs!AM87,Inputs!AM89,Inputs!AM91,Inputs!AM92),0)))","v":2408606.045273962},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AN39,Inputs!AN42,Inputs!AN44,Inputs!AN46,Inputs!AN47),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AN69,Inputs!AN72,Inputs!AN74,Inputs!AN76,Inputs!AN77),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AN84,Inputs!AN87,Inputs!AN89,Inputs!AN91,Inputs!AN92),0)))","v":2443029.6773830312},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AO39,Inputs!AO42,Inputs!AO44,Inputs!AO46,Inputs!AO47),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AO69,Inputs!AO72,Inputs!AO74,Inputs!AO76,Inputs!AO77),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AO84,Inputs!AO87,Inputs!AO89,Inputs!AO91,Inputs!AO92),0)))","v":2423177.7346149422},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AP39,Inputs!AP42,Inputs!AP44,Inputs!AP46,Inputs!AP47),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AP69,Inputs!AP72,Inputs!AP74,Inputs!AP76,Inputs!AP77),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AP84,Inputs!AP87,Inputs!AP89,Inputs!AP91,Inputs!AP92),0)))","v":2342022.4786748695},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AQ39,Inputs!AQ42,Inputs!AQ44,Inputs!AQ46,Inputs!AQ47),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AQ69,Inputs!AQ72,Inputs!AQ74,Inputs!AQ76,Inputs!AQ77),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AQ84,Inputs!AQ87,Inputs!AQ89,Inputs!AQ91,Inputs!AQ92),0)))","v":2360271.0417927136},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,SUM(Inputs!AR39,Inputs!AR42,Inputs!AR44,Inputs!AR46,Inputs!AR47),IF(Inputs!$B$168=Inputs!$B$170,SUM(Inputs!AR69,Inputs!AR72,Inputs!AR74,Inputs!AR76,Inputs!AR77),IF(Inputs!$B$168=Inputs!$B$171,SUM(Inputs!AR84,Inputs!AR87,Inputs!AR89,Inputs!AR91,Inputs!AR92),0)))","v":2344042.573274083}]
["Other Capex",null,null,null,{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!E48,IF(Inputs!$B$168=Inputs!$B$170,Inputs!E78,IF(Inputs!$B$168=Inputs!$B$171,Inputs!E93,0)))","v":414551.89245087898},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!F48,IF(Inputs!$B$168=Inputs!$B$170,Inputs!F78,IF(Inputs!$B$168=Inputs!$B$171,Inputs!F93,0)))","v":72300.806618407441},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!G48,IF(Inputs!$B$168=Inputs!$B$170,Inputs!G78,IF(Inputs!$B$168=Inputs!$B$171,Inputs!G93,0)))","v":794208.89348500513},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!H48,IF(Inputs!$B$168=Inputs!$B$170,Inputs!H78,IF(Inputs!$B$168=Inputs!$B$171,Inputs!H93,0)))+Inputs!H162","v":58886.83448095675},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!I48,IF(Inputs!$B$168=Inputs!$B$170,Inputs!I78,IF(Inputs!$B$168=Inputs!$B$171,Inputs!I93,0)))+Inputs!I162","v":58297.966136147181},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!J48,IF(Inputs!$B$168=Inputs!$B$170,Inputs!J78,IF(Inputs!$B$168=Inputs!$B$171,Inputs!J93,0)))+Inputs!J162","v":-158656.34836370684},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!K48,IF(Inputs!$B$168=Inputs!$B$170,Inputs!K78,IF(Inputs!$B$168=Inputs!$B$171,Inputs!K93,0)))+Inputs!K162","v":57137.836610037855},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!L48,IF(Inputs!$B$168=Inputs!$B$170,Inputs!L78,IF(Inputs!$B$168=Inputs!$B$171,Inputs!L93,0)))+Inputs!L162","v":56566.458243937479},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!M48,IF(Inputs!$B$168=Inputs!$B$170,Inputs!M78,IF(Inputs!$B$168=Inputs!$B$171,Inputs!M93,0)))+Inputs!M162","v":128685.62010712815},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!N48,IF(Inputs!$B$168=Inputs!$B$170,Inputs!N78,IF(Inputs!$B$168=Inputs!$B$171,Inputs!N93,0)))+Inputs!N162","v":23205.603625875567},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!O48,IF(Inputs!$B$168=Inputs!$B$170,Inputs!O78,IF(Inputs!$B$168=Inputs!$B$171,Inputs!O93,0)))+Inputs!O162","v":22150.803461063042},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!P48,IF(Inputs!$B$168=Inputs!$B$170,Inputs!P78,IF(Inputs!$B$168=Inputs!$B$171,Inputs!P93,0)))","v":160607.71401945711},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!Q48,IF(Inputs!$B$168=Inputs!$B$170,Inputs!Q78,IF(Inputs!$B$168=Inputs!$B$171,Inputs!Q93,0)))","v":110424.82648356976},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!R48,IF(Inputs!$B$168=Inputs!$B$170,Inputs!R78,IF(Inputs!$B$168=Inputs!$B$171,Inputs!R93,0)))","v":109538.79565200016},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!S48,IF(Inputs!$B$168=Inputs!$B$170,Inputs!S78,IF(Inputs!$B$168=Inputs!$B$171,Inputs!S93,0)))","v":108877.39148790488},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!T48,IF(Inputs!$B$168=Inputs!$B$170,Inputs!T78,IF(Inputs!$B$168=Inputs!$B$171,Inputs!T93,0)))","v":108219.98093598762},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!U48,IF(Inputs!$B$168=Inputs!$B$170,Inputs!U78,IF(Inputs!$B$168=Inputs!$B$171,Inputs!U93,0)))","v":107566.53988249302},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!V48,IF(Inputs!$B$168=Inputs!$B$170,Inputs!V78,IF(Inputs!$B$168=Inputs!$B$171,Inputs!V93,0)))","v":107566.53988249302},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!W48,IF(Inputs!$B$168=Inputs!$B$170,Inputs!W78,IF(Inputs!$B$168=Inputs!$B$171,Inputs!W93,0)))","v":107566.53988249302},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!X48,IF(Inputs!$B$168=Inputs!$B$170,Inputs!X78,IF(Inputs!$B$168=Inputs!$B$171,Inputs!X93,0)))","v":107566.53988249302},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!Y48,IF(Inputs!$B$168=Inputs!$B$170,Inputs!Y78,IF(Inputs!$B$168=Inputs!$B$171,Inputs!Y93,0)))","v":107566.53988249302},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!Z48,IF(Inputs!$B$168=Inputs!$B$170,Inputs!Z78,IF(Inputs!$B$168=Inputs!$B$171,Inputs!Z93,0)))","v":107566.53988249302},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AA48,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AA78,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AA93,0)))","v":107566.53988249302},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AB48,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AB78,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AB93,0)))","v":107566.53988249302},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AC48,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AC78,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AC93,0)))","v":107566.53988249302},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AD48,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AD78,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AD93,0)))","v":107566.53988249302},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AE48,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AE78,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AE93,0)))","v":107566.53988249302},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AF48,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AF78,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AF93,0)))","v":107566.53988249302},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AG48,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AG78,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AG93,0)))","v":107566.53988249302},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AH48,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AH78,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AH93,0)))","v":107566.53988249302},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AI48,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AI78,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AI93,0)))","v":107566.53988249302},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AJ48,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AJ78,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AJ93,0)))","v":107566.53988249302},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AK48,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AK78,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AK93,0)))","v":107566.53988249302},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AL48,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AL78,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AL93,0)))","v":107566.53988249302},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AM48,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AM78,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AM93,0)))","v":107566.53988249302},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AN48,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AN78,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AN93,0)))","v":107566.53988249302},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AO48,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AO78,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AO93,0)))","v":107566.53988249302},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AP48,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AP78,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AP93,0)))","v":107566.53988249302},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AQ48,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AQ78,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AQ93,0)))","v":107566.53988249302},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AR48,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AR78,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AR93,0)))","v":107566.53988249302}]
["Capitalised Under-recoveries",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Inputs!B147=Inputs!B148,Inputs!O147,IF(Inputs!B147=Inputs!B149,Inputs!O147,0))","v":0}]
["Total capex",null,null,null,{"$f":"SUM(E9:E13)","v":10451105.800988538},{"$f":"SUM(F9:F13)","v":13652729.191004099},13735028.073700849,12114461.220755257,11213747.415213376,12937863.069412325,14963625.472715998,10789865.15115731,6632051.980491437,10249207.596863655,10976816.406392589,{"$f":"SUM(P9:P13)","v":12877415.298704796},12855794.292089261,13019384.909063436,13236751.849180227,13573781.120254919,13785462.61679747,13934594.212623954,13119244.965944402,13358875.91573393,10756886.711540157,7557609.5913655572,7534925.9544094941,7661426.4178366298,7357136.5076937936,7328091.3195990259,7341124.8338987799,7005309.6549913883,6976881.6707901554,6740672.8234699238,{"$f":"SUM(AI9:AI13)","v":6497928.6335283527},{"$f":"SUM(AJ9:AJ13)","v":6536323.2154770987},{"$f":"SUM(AK9:AK13)","v":6513649.1938280715},{"$f":"SUM(AL9:AL13)","v":6474464.5863841651},{"$f":"SUM(AM9:AM13)","v":6440327.6482258225},{"$f":"SUM(AN9:AN13)","v":6387521.9337609215},{"$f":"SUM(AO9:AO13)","v":6290087.941160379},{"$f":"SUM(AP9:AP13)","v":6133225.0334988879},{"$f":"SUM(AQ9:AQ13)","v":6154616.8897630749},{"$f":"SUM(AR9:AR13)","v":6061792.7800716944}]
[]
[]
[]
["Opening DAV (Capex Only)",null,"Mains",{"$f":"Inputs!D152","v":1845762.7935014917}]
[null,null,"Other Capex",{"$f":"Inputs!D153","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":2556392.5506367097},{"$f":"(SUM($D$9:Q9)/$C$24)","v":2763436.6087116851},{"$f":"(SUM($D$9:R9)/$C$24)","v":2967467.234906028},{"$f":"(SUM($D$9:S9)/$C$24)","v":3170600.2997301454},{"$f":"(SUM($D$9:T9)/$C$24)","v":3376184.4500562684},{"$f":"(SUM($D$9:U9)/$C$24)","v":3582448.4444960705},{"$f":"(SUM($D$9:V9)/$C$24)","v":3793776.7566355295},{"$f":"(SUM($D$9:W9)/$C$24)","v":3983510.2719788812},{"$f":"(SUM($D$9:X9)/$C$24)","v":4180499.756399761},{"$f":"(SUM($D$9:Y9)/$C$24)","v":4312329.2304064836},{"$f":"(SUM($D$9:Z9)/$C$24)","v":4363571.9614387881},{"$f":"(SUM($D$9:AA9)/$C$24)","v":4414681.7027237015},{"$f":"(SUM($D$9:AB9)/$C$24)","v":4465600.2457215991},{"$f":"(SUM($D$9:AC9)/$C$24)","v":4516369.1534520611},{"$f":"(SUM($D$9:AD9)/$C$24)","v":4566963.4578606272},{"$f":"(SUM($D$9:AE9)/$C$24)","v":4617589.8686076645},{"$f":"(SUM($D$9:AF9)/$C$24)","v":4668038.6783512654},{"$f":"(SUM($D$9:AG9)/$C$24)","v":4718527.1349448618},{"$f":"(SUM($D$9:AH9)/$C$24)","v":4769047.5105449306},{"$f":"(SUM($D$9:AI9)/$C$24)","v":4819602.9330423633},{"$f":"(SUM($D$9:AJ9)/$C$24)","v":4870013.4146875376},{"$f":"(SUM($D$9:AK9)/$C$24)","v":4920442.0486044064},{"$f":"(SUM($D$9:AL9)/$C$24)","v":4970907.0115770195},{"$f":"(SUM($D$9:AM9)/$C$24)","v":5021407.0983559387},{"$f":"(SUM($D$9:AN9)/$C$24)","v":5071906.243531283},{"$f":"(SUM($D$9:AO9)/$C$24)","v":5122432.9354253644},{"$f":"(SUM($D$9:AP9)/$C$24)","v":5172954.2385495678},{"$f":"(SUM($D$9:AQ9)/$C$24)","v":5223656.7181413593},{"$f":"(SUM($D$9:AR9)/$C$24)","v":5274365.8072732994}]
["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":491401.96119619254},{"$f":"SUM($D$10:P10)/$C$25","v":566538.76060973783},{"$f":"SUM($D$10:Q10)/$C$25","v":647147.61460572423},{"$f":"SUM($D$10:R10)/$C$25","v":733311.76334935718},{"$f":"SUM($D$10:S10)/$C$25","v":824239.6216893926},{"$f":"SUM($D$10:T10)/$C$25","v":919870.52088393527},{"$f":"SUM($D$10:U10)/$C$25","v":1018404.2317479672},{"$f":"SUM($D$10:V10)/$C$25","v":1115275.2666055481},{"$f":"SUM($D$10:W10)/$C$25","v":1212613.6747626953},{"$f":"SUM($D$10:X10)/$C$25","v":1308287.0676976978},{"$f":"SUM($D$10:Y10)/$C$25","v":1400373.9448410883},{"$f":"SUM($D$10:Z10)/$C$25","v":1488121.9491740516},{"$f":"SUM($D$10:AA10)/$C$25","v":1570812.5665732154},{"$f":"SUM($D$10:AB10)/$C$25","v":1649192.8095338773},{"$f":"SUM($D$10:AC10)/$C$25","v":1723516.3135661676},{"$f":"SUM($D$10:AD10)/$C$25","v":1793650.1800152492},{"$f":"SUM($D$10:AE10)/$C$25","v":1861586.1116871922},{"$f":"SUM($D$10:AF10)/$C$25","v":1925379.80931499},{"$f":"SUM($D$10:AG10)/$C$25","v":1987092.4154905411},{"$f":"SUM($D$10:AH10)/$C$25","v":2046635.5852608788},{"$f":"SUM($D$10:AI10)/$C$25","v":2104183.1586947446},{"$f":"SUM($D$10:AJ10)/$C$25","v":2157810.7853854778},{"$f":"SUM($D$10:AK10)/$C$25","v":2209371.5698099271},{"$f":"SUM($D$10:AL10)/$C$25","v":2258970.9559442136},{"$f":"SUM($D$10:AM10)/$C$25","v":2306574.7457420281},{"$f":"SUM($D$10:AN10)/$C$25","v":2351998.7434790684},{"$f":"SUM($D$10:AO10)/$C$25","v":2395455.6432515611},{"$f":"SUM($D$10:AP10)/$C$25","v":2437025.2405008958},{"$f":"SUM($D$10:AQ10)/$C$25","v":2478492.2436113013},{"$f":"SUM($D$10:AR10)/$C$25","v":2518037.7461522389}]
["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":932581.34311114263},{"$f":"SUM($E$11:Q11)/$C$26","v":1015198.208628958},{"$f":"SUM($E$11:R11)/$C$26","v":1102001.8830217849},{"$f":"SUM(E11:S11)/$C$26","v":1193031.0517635318},1255158.053531104,1293737.2757712917,1265461.7004950428,1301778.8741880697,1334313.6173601982,1355733.6441462829,1382421.4981263948,1436653.1742558021,1522036.1402458351,1591547.2822319276,1681079.3926185258,1770067.4348551808,1842653.4240208978,1914601.2576375192,1972276.386813852,{"$f":"SUM(U11:AI11)/$C$26","v":2015561.9266739611},{"$f":"SUM(V11:AJ11)/$C$26","v":2067644.8918337401},{"$f":"SUM(W11:AK11)/$C$26","v":2122808.3669959386},{"$f":"SUM(X11:AL11)/$C$26","v":2178509.8734081881},{"$f":"SUM(Y11:AM11)/$C$26","v":2236097.3243187102},{"$f":"SUM(Z11:AN11)/$C$26","v":2286121.5611007018},{"$f":"SUM(AA11:AO11)/$C$26","v":2321639.1676168758},{"$f":"SUM(AB11:AP11)/$C$26","v":2339417.6617176076},{"$f":"SUM(AC11:AQ11)/$C$26","v":2337975.1685296702},{"$f":"SUM(AD11:AR11)/$C$26","v":2344519.7735945303}]
["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,28406.306546708765,21387.834044654443,57549.264409608419,78243.239891492267,89014.913539418732,85185.548648393131,102319.90622079899,119533.74171578391,108925.50688839107,108353.84956817573,107959.3984142743,107697.22809319194,107566.53988249302,107566.53988249302,107566.53988249302,107566.53988249302,107566.53988249302,107566.53988249302,107566.53988249302,107566.53988249302,107566.53988249302,107566.53988249302,{"$f":"SUM(AE12:AI12)/$C$27","v":107566.53988249302},{"$f":"SUM(AF12:AJ12)/$C$27","v":107566.53988249302},{"$f":"SUM(AG12:AK12)/$C$27","v":107566.53988249302},{"$f":"SUM(AH12:AL12)/$C$27","v":107566.53988249302},{"$f":"SUM(AI12:AM12)/$C$27","v":107566.53988249302},{"$f":"SUM(AJ12:AN12)/$C$27","v":107566.53988249302},{"$f":"SUM(AK12:AO12)/$C$27","v":107566.53988249302},{"$f":"SUM(AL12:AP12)/$C$27","v":107566.53988249302},{"$f":"SUM(AM12:AQ12)/$C$27","v":107566.53988249302},{"$f":"SUM(AN12:AR12)/$C$27","v":107566.53988249302}]
["Capitalised Under-recoveries",null,{"$f":"IF(D28=D29,19,29)","v":29},"40 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,3151866.0913126227,3450631.267287754,3804343.3497931482,{"$f":"SUM(P23:P28)","v":4191134.3467133003},4572175.7979500042,4945344.8823897801,{"$f":"SUM(S23:S28)","v":5347569.3318680869},5728125.2186513096,6060893.9113679389,6340246.0257685147,6663240.6718081385,6988176.1220150655,7233381.811740566,7399060.4010859458,7587092.43589943,7801774.1878480222,7996377.7415968673,8206638.0228411127,8414188.4074967485,8601016.9040338621,8785165.8004196323,8952904.4749663696,{"$f":"SUM(AI23:AI28)","v":9104293.0107577797},{"$f":"SUM(AJ23:AJ28)","v":9260414.0842534639},{"$f":"SUM(AK23:AK28)","v":9417566.9777569808},{"$f":"SUM(AL23:AL28)","v":9573332.8332761303},{"$f":"SUM(AM23:AM28)","v":9729024.1607633866},{"$f":"SUM(AN23:AN28)","v":9874971.5404577628},{"$f":"SUM(AO23:AO28)","v":10004472.738640511},{"$f":"SUM(AP23:AP28)","v":10114342.133114781},{"$f":"SUM(AQ23:AQ28)","v":10205069.122629041},{"$f":"SUM(AR23:AR28)","v":10301868.319366779}]
[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,91269342.296248615,98067918.625824511,{"$f":"O35","v":105240391.68242395},113926672.63441545,122210291.1285547,130284331.15522835,138173513.67254049,146019169.57414412,153743738.27957365,161338086.46642908,167794090.76056534,174164790.55428421,177688295.4540838,177846844.6443634,177794678.16287345,177654330.39286205,177015089.15895897,176136542.45571688,175063478.88211891,173467771.63307643,171659487.50344697,{"$f":"AH35","v":169447255.85195053},{"$f":"AI35","v":166840891.4747211},{"$f":"AJ35","v":164116800.60594475},{"$f":"AK35","v":161212882.82201585},{"$f":"AL35","v":158114014.57512391},{"$f":"AM35","v":154825318.06258634},{"$f":"AN35","v":151337868.45588949},{"$f":"AO35","v":147623483.65840936},{"$f":"AP35","v":143642366.55879346},{"$f":"AQ35","v":139591914.3259275}]
["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},6632051.980491437,10249207.596863655,10976816.406392589,{"$f":"P14","v":12877415.298704796},12855794.292089261,13019384.909063436,13236751.849180227,13573781.120254919,13785462.61679747,13934594.212623954,13119244.965944402,13358875.91573393,10756886.711540157,7557609.5913655572,7534925.9544094941,7661426.4178366298,7357136.5076937936,7328091.3195990259,7341124.8338987799,7005309.6549913883,6976881.6707901554,6740672.8234699238,{"$f":"AI14","v":6497928.6335283527},6536323.2154770987,6513649.1938280715,6474464.5863841651,6440327.6482258225,6387521.9337609215,6290087.941160379,6133225.0334988879,6154616.8897630749,{"$f":"AR14","v":6061792.7800716944}]
["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":-3151866.0913126227},-3450631.267287754,-3804343.3497931482,{"$f":"-P29","v":-4191134.3467133003},-4572175.7979500042,-4945344.8823897801,-5347569.3318680869,-5728125.2186513096,-6060893.9113679389,-6340246.0257685147,-6663240.6718081385,-6988176.1220150655,-7233381.811740566,-7399060.4010859458,-7587092.43589943,-7801774.1878480222,-7996377.7415968673,-8206638.0228411127,-8414188.4074967485,-8601016.9040338621,-8785165.8004196323,-8952904.4749663696,{"$f":"-AI29","v":-9104293.0107577797},-9260414.0842534639,-9417566.9777569808,-9573332.8332761303,-9729024.1607633866,-9874971.5404577628,-10004472.738640511,-10114342.133114781,-10205069.122629041,{"$f":"-AR29","v":-10301868.319366779}]
["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,91269342.296248615,98067918.625824511,105240391.68242395,{"$f":"SUM(P32:P34)","v":113926672.63441545},122210291.1285547,130284331.15522835,138173513.67254049,146019169.57414412,153743738.27957365,161338086.46642908,167794090.76056534,174164790.55428421,177688295.4540838,177846844.6443634,177794678.16287345,177654330.39286205,177015089.15895897,176136542.45571688,175063478.88211891,173467771.63307643,171659487.50344697,169447255.85195053,{"$f":"SUM(AI32:AI34)","v":166840891.4747211},164116800.60594475,161212882.82201585,158114014.57512391,154825318.06258634,151337868.45588949,147623483.65840936,143642366.55879346,139591914.3259275,{"$f":"SUM(AR32:AR34)","v":135351838.78663242}]

{"sheet":"GD17 Pi's Calc - 40 yrs","index":2,"n_rows":64,"n_cols":32,"rows_kept":64,"cut":false,"hidden":false,"merged":[[1,0,1,2],[1,3,1,4],[46,0,46,31],[48,0,48,31],[54,0,54,31],[24,0,24,31],[32,0,32,31],[36,0,36,31],[40,0,40,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",{"$f":"IF(Inputs!B168=Inputs!B169,5.5%,IF(Inputs!B168=Inputs!B170,4.3%,IF(Inputs!B168=Inputs!B171,4.3%,0)))","v":4.2999999999999997E-2}]
[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,{"$f":"V6","v":4.2999999999999997E-2},{"$f":"W6","v":4.2999999999999997E-2},{"$f":"X6","v":4.2999999999999997E-2},{"$f":"Y6","v":4.2999999999999997E-2},{"$f":"Z6","v":4.2999999999999997E-2},{"$f":"AA6","v":4.2999999999999997E-2},{"$f":"AB6","v":4.2999999999999997E-2},{"$f":"AC6","v":4.2999999999999997E-2},{"$f":"AD6","v":4.2999999999999997E-2},{"$f":"AE6","v":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,{"$f":"O8*(1+O6*$B$7)","v":0.61634896332268363},0.59093860337745319,0.56657584216438472,0.54321749009049347,0.52082213815004164,0.49935008451585972,0.4787632641571043,{"$f":"V8*(1+V6*$B$7)","v":0.45902518135868109},{"$f":"W8*(1+W6*$B$7)","v":0.4401008450227048},0.42195670663730089,{"$f":"Y8*(1+Y6*$B$7)","v":0.40456060080278133},0.3878816882097616,0.37189040096813197,0.35655839018996349,0.3418584757334262,0.32776459801862534,0.31425177182993808,{"$f":"AF8*(1+AF6*$B$7)","v":0.30129604202295118}]
["Discount Factor (Yr End)",null,1,{"$f":"C8/(1+D6)","v":0.95877277085330781},{"$f":"D8/(1+E6)","v":0.91924522612972948},{"$f":"E8/(1+F6)","v":0.88134729255007627},0.84501178576229752,0.81017429123901974,0.7767730500853498,0.74474884955450604,0.71404491807718706,0.68460682461858779,0.65638238218464795,0.62932155530646983,0.60337637133889732,0.57850083541600894,0.55465084891276029,0.53178413126822655,0.50986014503185673,0.48884002399986265,0.46868650431434583,0.44936385840301618,0.43083783164239331,0.41307558163220837,0.39604561997335419,0.37971775644616895,0.36406304549009488,0.3490537348898321,0.33466321657702025,0.32086597946023038,0.30763756419964566,0.29495451984625665]
[]
[]
[]
[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":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!P99/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!P101/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!P102/1000,0)))","v":12877.415298704793},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!Q99/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!Q101/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!Q102/1000,0)))","v":12855.79429208926},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!R99/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!R101/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!R102/1000,0)))","v":13019.384909063434},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!S99/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!S101/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!S102/1000,0)))","v":13236.751849180231},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!T99/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!T101/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!T102/1000,0)))","v":13573.781120254918},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!U99/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!U101/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!U102/1000,0)))","v":13785.462616797469},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!V99/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!V101/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!V102/1000,0)))","v":13934.594212623955},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!W99/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!W101/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!W102/1000,0)))","v":13119.244965944405},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!X99/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!X101/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!X102/1000,0)))","v":13358.875915733928},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!Y99/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!Y101/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!Y102/1000,0)))","v":10756.886711540157},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!Z99/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!Z101/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!Z102/1000,0)))","v":7557.609591365559},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AA99/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AA101/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AA102/1000,0)))","v":7534.9259544094939},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AB99/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AB101/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AB102/1000,0)))","v":7661.4264178366302},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AC99/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AC101/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AC102/1000,0)))","v":7357.1365076937946},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AD99/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AD101/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AD102/1000,0)))","v":7328.0913195990261},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AE99/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AE101/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AE102/1000,0)))","v":7341.1248338987807},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AF99/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AF101/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AF102/1000,0)))","v":7005.3096549913871},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AG99/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AG101/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AG102/1000,0)))","v":6976.8816707901569},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AH99/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AH101/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AH102/1000,0)))","v":6740.672823469924},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AI99/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AI101/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AI102/1000,0)))","v":6497.9286335283523},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AJ99/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AJ101/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AJ102/1000,0)))","v":6536.3232154770985},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AK99/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AK101/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AK102/1000,0)))","v":6513.6491938280715},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AL99/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AL101/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AL102/1000,0)))","v":6474.4645863841652},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AM99/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AM101/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AM102/1000,0)))","v":6440.3276482258216},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AN99/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AN101/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AN102/1000,0)))","v":6387.5219337609224},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AO99/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AO101/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AO102/1000,0)))","v":6290.0879411603792},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AP99/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AP101/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AP102/1000,0)))","v":6133.2250334988876},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AQ99/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AQ101/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AQ102/1000,0)))","v":6154.616889763076},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AR99/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AR101/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AR102/1000,0)))","v":6061.7927800716943}]
["Opex",null,null,{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!P106/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!P108/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!P109/1000,0)))","v":5425.8388111566828},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!Q106/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!Q108/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!Q109/1000,0)))","v":5581.3423587159723},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!R106/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!R108/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!R109/1000,0)))","v":5688.5867157006833},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!S106/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!S108/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!S109/1000,0)))","v":5861.1512880677456},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!T106/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!T108/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!T109/1000,0)))","v":6083.4031381035575},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!U106/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!U108/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!U109/1000,0)))","v":6311.9219869764984},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!V106/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!V108/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!V109/1000,0)))","v":6340.8844782954757},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!W106/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!W108/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!W109/1000,0)))","v":6376.567006894189},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!X106/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!X108/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!X109/1000,0)))","v":6406.7428476272444},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!Y106/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!Y108/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!Y109/1000,0)))","v":6454.1893201468638},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!Z106/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!Z108/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!Z109/1000,0)))","v":6562.6825659656624},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AA106/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AA108/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AA109/1000,0)))","v":6720.8129916738635},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AB106/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AB108/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AB109/1000,0)))","v":6821.7443698380412},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AC106/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AC108/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AC109/1000,0)))","v":6909.955258057098},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AD106/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AD108/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AD109/1000,0)))","v":6969.0472906954519},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AE106/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AE108/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AE109/1000,0)))","v":6905.13575223302},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AF106/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AF108/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AF109/1000,0)))","v":6831.4992511364444},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AG106/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AG108/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AG109/1000,0)))","v":6812.9547447928599},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AH106/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AH108/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AH109/1000,0)))","v":6868.6892599203884},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AI106/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AI108/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AI109/1000,0)))","v":6959.7645214790564},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AJ106/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AJ108/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AJ109/1000,0)))","v":7010.65503141519},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AK106/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AK108/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AK109/1000,0)))","v":7091.6759111255842},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AL106/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AL108/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AL109/1000,0)))","v":7167.4380464539236},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AM106/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AM108/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AM109/1000,0)))","v":7239.1096162691993},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AN106/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AN108/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AN109/1000,0)))","v":7306.7519108345414},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AO106/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AO108/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AO109/1000,0)))","v":7368.2062779363987},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AP106/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AP108/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AP109/1000,0)))","v":7429.1149390185501},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AQ106/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AQ108/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AQ109/1000,0)))","v":7523.1170445959378},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AR106/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AR108/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AR109/1000,0)))","v":7578.5143503050167}]
["Volumes (therms '000)",null,null,{"$f":"SUM(D17:D19)","v":61980.126268008869},63703.112171438588,65882.425114643585,68173.18490555523,70566.07742592509,73042.286045184854,75594.934254937645,78071.548082145426,{"$f":"SUM(L17:L19)","v":80291.153943268349},82716.623373425711,84780.367337352538,86965.690428101487,88796.315186560736,90757.930992388865,92373.481694419374,94145.330849461636,95595.791565784864,97207.659733690583,98521.737561590926,{"$f":"SUM(W17:W19)","v":100020.36112991604},{"$f":"SUM(X17:X19)","v":101205.91881819384},{"$f":"SUM(Y17:Y19)","v":102560.37426085865},{"$f":"SUM(Z17:Z19)","v":103623.7806360422},{"$f":"SUM(AA17:AA19)","v":104877.79989692217},{"$f":"SUM(AB17:AB19)","v":105843.21370849934},{"$f":"SUM(AC17:AC19)","v":107001.43966213362},{"$f":"SUM(AD17:AD19)","v":107873.03949718966},{"$f":"SUM(AE17:AE19)","v":108958.2328719549},{"$f":"SUM(AF17:AF19)","v":109777.4033860288}]
["P Dom (P1)",null,null,{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!P113/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!P121/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!P129/1000,0)))","v":10151.055000000002},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!Q113/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!Q121/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!Q129/1000,0)))","v":11645.555},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!R113/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!R121/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!R129/1000,0)))","v":13273.054999999998},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!S113/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!S121/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!S129/1000,0)))","v":15024.054999999995},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!T113/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!T121/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!T129/1000,0)))","v":16889.054999999993},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!U113/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!U121/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!U129/1000,0)))","v":18849.054999999986},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!V113/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!V121/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!V129/1000,0)))","v":20825.354999999985},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!W113/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!W121/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!W129/1000,0)))","v":22751.354999999985},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!X113/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!X121/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!X129/1000,0)))","v":24658.354999999985},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!Y113/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!Y121/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!Y129/1000,0)))","v":26508.354999999985},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!Z113/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!Z121/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!Z129/1000,0)))","v":28282.354999999985},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AA113/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AA121/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AA129/1000,0)))","v":29978.729999999985},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AB113/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AB121/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AB129/1000,0)))","v":31597.479999999985},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AC113/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AC121/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AC129/1000,0)))","v":33140.229999999989},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AD113/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AD121/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AD129/1000,0)))","v":34606.979999999989},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AE113/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AE121/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AE129/1000,0)))","v":36016.729999999989},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AF113/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AF121/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AF129/1000,0)))","v":37369.479999999989},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AG113/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AG121/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AG129/1000,0)))","v":38665.229999999989},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AH113/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AH121/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AH129/1000,0)))","v":39922.979999999989},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AI113/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AI121/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AI129/1000,0)))","v":41142.729999999996},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AJ113/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AJ121/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AJ129/1000,0)))","v":42305.479999999996},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AK113/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AK121/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AK129/1000,0)))","v":43411.229999999996},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AL113/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AL121/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AL129/1000,0)))","v":44478.979999999996},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AM113/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AM121/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AM129/1000,0)))","v":45508.729999999996},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AN113/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AN121/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AN129/1000,0)))","v":46500.479999999996},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AO113/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AO121/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AO129/1000,0)))","v":47454.229999999996},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AP113/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AP121/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AP129/1000,0)))","v":48369.979999999996},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AQ113/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AQ121/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AQ129/1000,0)))","v":49266.729999999996},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AR113/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AR121/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AR129/1000,0)))","v":50144.479999999996}]
["P SME (P2 + P3)",null,null,{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!P114/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!P122/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!P130/1000,0)))","v":15793.478437645832},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!Q114/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!Q122/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!Q130/1000,0)))","v":16357.532583924549},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!R114/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!R122/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!R130/1000,0)))","v":16909.345527129546},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!S114/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!S122/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!S130/1000,0)))","v":17449.105318041195},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!T114/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!T122/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!T130/1000,0)))","v":17976.997838411051},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!U114/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!U122/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!U130/1000,0)))","v":18493.206457670829},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!V114/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!V122/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!V130/1000,0)))","v":19069.554667423621},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!W114/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!W122/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!W130/1000,0)))","v":19620.168494631394},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!X114/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!X122/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!X130/1000,0)))","v":19932.774355754329},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!Y114/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!Y122/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!Y130/1000,0)))","v":20508.243785911691},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!Z114/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!Z122/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!Z130/1000,0)))","v":20797.987749838521},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AA114/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AA122/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AA130/1000,0)))","v":21286.935840587459},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AB114/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AB122/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AB130/1000,0)))","v":21498.810599046712},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AC114/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AC122/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AC130/1000,0)))","v":21917.676404874837},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AD114/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AD122/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AD130/1000,0)))","v":22066.47710690535},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AE114/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AE122/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AE130/1000,0)))","v":22428.576261947608},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AF114/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AF122/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AF130/1000,0)))","v":22526.286978270844},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AG114/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AG122/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AG130/1000,0)))","v":22842.405146176559},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AH114/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AH122/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AH130/1000,0)))","v":22898.732974076898},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AI114/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AI122/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AI130/1000,0)))","v":23177.606542402005},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AJ114/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AJ122/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AJ130/1000,0)))","v":23200.414230679802},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AK114/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AK122/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AK130/1000,0)))","v":23449.119673344616},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AL114/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AL122/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AL130/1000,0)))","v":23444.776048528154},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AM114/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AM122/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AM130/1000,0)))","v":23669.045309408128},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AN114/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AN122/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AN130/1000,0)))","v":23642.709120985317},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AO114/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AO122/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AO130/1000,0)))","v":23847.185074619581},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AP114/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AP122/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AP130/1000,0)))","v":23803.034909675622},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AQ114/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AQ122/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AQ130/1000,0)))","v":23991.478284440855},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AR114/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AR122/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AR130/1000,0)))","v":23932.898798514765}]
["P Contract (P4, P5 + P6)",null,null,{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!P116/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!P124/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!P132/1000,0)))","v":36035.592830363035},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!Q116/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!Q124/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!Q132/1000,0)))","v":35700.024587514039},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!R116/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!R124/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!R132/1000,0)))","v":35700.024587514039},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!S116/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!S124/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!S132/1000,0)))","v":35700.024587514039},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!T116/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!T124/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!T132/1000,0)))","v":35700.024587514039},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!U116/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!U124/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!U132/1000,0)))","v":35700.024587514039},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!V116/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!V124/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!V132/1000,0)))","v":35700.024587514039},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!W116/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!W124/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!W132/1000,0)))","v":35700.024587514039},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!X116/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!X124/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!X132/1000,0)))","v":35700.024587514039},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!Y116/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!Y124/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!Y132/1000,0)))","v":35700.024587514039},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!Z116/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!Z124/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!Z132/1000,0)))","v":35700.024587514039},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AA116/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AA124/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AA132/1000,0)))","v":35700.024587514039},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AB116/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AB124/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AB132/1000,0)))","v":35700.024587514039},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AC116/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AC124/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AC132/1000,0)))","v":35700.024587514039},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AD116/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AD124/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AD132/1000,0)))","v":35700.024587514039},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AE116/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AE124/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AE132/1000,0)))","v":35700.024587514039},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AF116/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AF124/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AF132/1000,0)))","v":35700.024587514039},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AG116/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AG124/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AG132/1000,0)))","v":35700.024587514039},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AH116/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AH124/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AH132/1000,0)))","v":35700.024587514039},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AI116/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AI124/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AI132/1000,0)))","v":35700.024587514039},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AJ116/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AJ124/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AJ132/1000,0)))","v":35700.024587514039},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AK116/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AK124/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AK132/1000,0)))","v":35700.024587514039},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AL116/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AL124/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AL132/1000,0)))","v":35700.024587514039},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AM116/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AM124/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AM132/1000,0)))","v":35700.024587514039},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AN116/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AN124/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AN132/1000,0)))","v":35700.024587514039},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AO116/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AO124/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AO132/1000,0)))","v":35700.024587514039},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AP116/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AP124/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AP132/1000,0)))","v":35700.024587514039},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AQ116/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AQ124/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AQ132/1000,0)))","v":35700.024587514039},{"$f":"IF(Inputs!$B$168=Inputs!$B$169,Inputs!AR116/1000,IF(Inputs!$B$168=Inputs!$B$170,Inputs!AR124/1000,IF(Inputs!$B$168=Inputs!$B$171,Inputs!AR132/1000,0)))","v":35700.024587514039}]
["£/therm",null,null,{"$f":"D21/Inputs!M2*Inputs!M1","v":0.35856688128342823}]
["P Dom (P1)",null,null,0.35647814216915585,{"$f":"D21","v":0.35647814216915585},{"$f":"E21","v":0.35647814216915585},0.35647814216915585,0.35647814216915585,0.35647814216915585,0.35647814216915585,0.35647814216915585,0.35647814216915585,0.35647814216915585,0.35647814216915585,0.35647814216915585,0.35647814216915585,0.35647814216915585,0.35647814216915585,0.35647814216915585,0.35647814216915585,0.35647814216915585,0.35647814216915585,{"$f":"V21","v":0.35647814216915585},{"$f":"W21","v":0.35647814216915585},{"$f":"X21","v":0.35647814216915585},{"$f":"Y21","v":0.35647814216915585},{"$f":"Z21","v":0.35647814216915585},{"$f":"AA21","v":0.35647814216915585},{"$f":"AB21","v":0.35647814216915585},{"$f":"AC21","v":0.35647814216915585},{"$f":"AD21","v":0.35647814216915585},{"$f":"AE21","v":0.35647814216915585}]
["P SME (P2 + P3)",null,0.68134311258632596,{"$f":"$D$21*C22","v":0.24288392695452346},{"$f":"D22","v":0.24288392695452346},0.24288392695452346,0.24288392695452346,0.24288392695452346,0.24288392695452346,0.24288392695452346,0.24288392695452346,0.24288392695452346,0.24288392695452346,0.24288392695452346,0.24288392695452346,0.24288392695452346,0.24288392695452346,0.24288392695452346,0.24288392695452346,0.24288392695452346,0.24288392695452346,0.24288392695452346,0.24288392695452346,0.24288392695452346,0.24288392695452346,0.24288392695452346,0.24288392695452346,0.24288392695452346,0.24288392695452346,0.24288392695452346,0.24288392695452346,{"$f":"AE22","v":0.24288392695452346}]
["P Contract (P4, P5 + P6)",null,0.59008170977553098,{"$f":"$D$21*C23","v":0.21035123162878031},0.21035123162878031,0.21035123162878031,0.21035123162878031,0.21035123162878031,0.21035123162878031,0.21035123162878031,0.21035123162878031,0.21035123162878031,0.21035123162878031,0.21035123162878031,0.21035123162878031,0.21035123162878031,0.21035123162878031,0.21035123162878031,0.21035123162878031,0.21035123162878031,0.21035123162878031,0.21035123162878031,0.21035123162878031,0.21035123162878031,0.21035123162878031,0.21035123162878031,0.21035123162878031,0.21035123162878031,0.21035123162878031,0.21035123162878031,0.21035123162878031,0.21035123162878031]
[]
["Conditions 4.6 and 4.6.6 Establishing Best Available Revenue Per Unit and Calculating Cashflow"]
[]
["Allowed Revenue",null,null,{"$f":"SUMPRODUCT(D21:D23,D17:D19)","v":15034.742625004041},{"$f":"SUMPRODUCT(E21:E23,E17:E19)","v":15633.911701360208},16348.106372330472,17103.398576897438,17896.446920400263,18720.522855625393,19565.016324472264,20385.328474877741,21141.059231132858,21940.316069184701,22643.082445162701,23366.560685942921,{"$f":"SUMPRODUCT(P21:P23,P17:P19)","v":23995.070651936367},24646.76307755434,25205.768691423709,25796.261817070255,26302.219986375709,26840.906561094002,27302.948068444512,{"$f":"SUMPRODUCT(W21:W23,W17:W19)","v":27805.496189753962},28225.530770454814,28680.113030727753,29059.687570376227,29481.242336052634,29828.382896683746,30218.037847364041,30533.75934061817,30899.200981479902,{"$f":"SUMPRODUCT(AF21:AF23,AF17:AF19)","v":31197.87165518817}]
["Capex",null,null,{"$f":"-D14","v":-12877.415298704793},{"$f":"-E14","v":-12855.79429208926},-13019.384909063434,-13236.751849180231,-13573.781120254918,-13785.462616797469,-13934.594212623955,-13119.244965944405,-13358.875915733928,-10756.886711540157,-7557.609591365559,-7534.9259544094939,-7661.4264178366302,-7357.1365076937946,-7328.0913195990261,-7341.1248338987807,-7005.3096549913871,-6976.8816707901569,-6740.672823469924,{"$f":"-W14","v":-6497.9286335283523},-6536.3232154770985,-6513.6491938280715,-6474.4645863841652,-6440.3276482258216,-6387.5219337609224,-6290.0879411603792,-6133.2250334988876,-6154.616889763076,{"$f":"-AF14","v":-6061.7927800716943}]
["Opex",null,null,-5425.8388111566828,-5581.3423587159723,-5688.5867157006833,-5861.1512880677456,-6083.4031381035575,-6311.9219869764984,-6340.8844782954757,-6376.567006894189,-6406.7428476272444,-6454.1893201468638,-6562.6825659656624,-6720.8129916738635,-6821.7443698380412,-6909.955258057098,-6969.0472906954519,-6905.13575223302,-6831.4992511364444,-6812.9547447928599,-6868.6892599203884,{"$f":"-W15","v":-6959.7645214790564},-7010.65503141519,-7091.6759111255842,-7167.4380464539236,-7239.1096162691993,-7306.7519108345414,-7368.2062779363987,-7429.1149390185501,-7523.1170445959378,{"$f":"-AF15","v":-7578.5143503050167}]
[]
["Cashflows",null,null,{"$f":"SUM(D27:D30)","v":-3268.5114848574349},{"$f":"SUM(E27:E30)","v":-2803.2249494450243},{"$f":"SUM(F27:F30)","v":-2359.8652524336449},-1994.5045603505387,-1760.7373379582123,-1376.8617481485744,-710.46236644716646,889.51650203914687,1375.4404677716857,4729.2400374976796,8522.7902878314799,9110.8217398595643,9511.8998642616953,10379.671311803448,10908.630081129231,11550.001230938457,12465.411080247879,13051.070145510985,13693.5859850542,{"$f":"SUM(W27:W30)","v":14347.80303474655},14678.552523562525,15074.787925774097,15417.784937538137,15801.805071557612,16134.109052088283,16559.743628267264,16971.419368100735,17221.467047120888,{"$f":"SUM(AF27:AF30)","v":17557.56452481146}]
[]
[]
[]
["Discounted Cashflow",null,{"$f":"SUM(D35:AF35)","v":103450.00785680686},{"$f":"D31*D7","v":-3201.1356488800288},{"$f":"E31*E7","v":-2632.2534523248105},-2124.5778593122263,-1721.6155272482913,-1457.173963522398,-1092.503545297802,-540.49202470966009,648.81056469012594,961.8811036115801,3170.9299233330594,5478.8925157379954,5615.445534380211,{"$f":"P31*P7","v":5620.9488212529932},5880.8710148745422,5925.7586529966775,6015.4963367329801,6224.6040764467125,6248.372943608173,6285.7007902401974,{"$f":"W31*W7","v":6314.4802398112852},6193.7136810450847,6098.6652602256827,5980.276450027327,5876.5396240818218,5752.7519507619163,5661.0887152957639,5562.6304469910501,5411.876533068631,{"$f":"AF31*AF7","v":5290.0246988882709}]
[]
[]
[]
["Closing DAV",null,null,{"$f":"DAV!P35/1000","v":113926.67263441544},{"$f":"DAV!Q35/1000","v":122210.2911285547},{"$f":"DAV!R35/1000","v":130284.33115522834},{"$f":"DAV!S35/1000","v":138173.51367254049},{"$f":"DAV!T35/1000","v":146019.16957414412},{"$f":"DAV!U35/1000","v":153743.73827957365},{"$f":"DAV!V35/1000","v":161338.08646642909},{"$f":"DAV!W35/1000","v":167794.09076056533},{"$f":"DAV!X35/1000","v":174164.79055428421},{"$f":"DAV!Y35/1000","v":177688.2954540838},{"$f":"DAV!Z35/1000","v":177846.84464436342},{"$f":"DAV!AA35/1000","v":177794.67816287346},{"$f":"DAV!AB35/1000","v":177654.33039286206},{"$f":"DAV!AC35/1000","v":177015.08915895896},{"$f":"DAV!AD35/1000","v":176136.54245571687},{"$f":"DAV!AE35/1000","v":175063.47888211891},{"$f":"DAV!AF35/1000","v":173467.77163307642},{"$f":"DAV!AG35/1000","v":171659.48750344696},{"$f":"DAV!AH35/1000","v":169447.25585195053},{"$f":"DAV!AI35/1000","v":166840.89147472111},{"$f":"DAV!AJ35/1000","v":164116.80060594477},{"$f":"DAV!AK35/1000","v":161212.88282201585},{"$f":"DAV!AL35/1000","v":158114.0145751239},{"$f":"DAV!AM35/1000","v":154825.31806258633},{"$f":"DAV!AN35/1000","v":151337.86845588949},{"$f":"DAV!AO35/1000","v":147623.48365840936},{"$f":"DAV!AP35/1000","v":143642.36655879347},{"$f":"DAV!AQ35/1000","v":139591.9143259275},{"$f":"DAV!AR35/1000","v":135351.8387866324}]
[]
[]
[]
["TRV",null,{"$f":"-C59","v":-143372.64447642598}]
["Discounted DAV2045",null,{"$f":"AF39*AF8","v":39922.636619619101}]
["Backsolve to 0 by running Macro Ctrl + q",null,{"$f":"SUM(C35:C44)","v":0}]
[]
[]
[]
["Condition 4.6.8 Calculating TRV"]
[]
[null,"Total Regulatory Value (TRV)",null,null,null,null,null,null,{"$f":"I61+I63","v":200318.36127156368},null,null,null,null,{"$f":"N61+N63","v":231808.17685373293},null,null,null,null,{"$f":"S61+S63","v":229128.24853727632},null,null,null,null,{"$f":"X61+X63","v":207120.66775018623},null,null,null,null,{"$f":"AC61+AC63","v":167891.6759160354},null,null,{"$f":"AF61+AF63","v":135351.8387866324}]
[]
[]
[]
["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":"D31*(1+$I$6*$B$7)*(1+$I$6)^($I$12-D12)","v":-4121.0694018391814},{"$f":"E31*(1+$I$6*$B$7)*(1+$I$6)^($I$12-E12)","v":-3388.7033697108641},{"$f":"F31*(1+$I$6*$B$7)*(1+$I$6)^($I$12-F12)","v":-2735.1333302291873},{"$f":"G31*(1+$I$6*$B$7)*(1+$I$6)^($I$12-G12)","v":-2216.3687669894375},{"$f":"H31*(1+$I$6*$B$7)*(1+$I$6)^($I$12-H12)","v":-1875.9326979254593},{"$f":"I31*(1+$I$6*$B$7)*(1+$I$6)^($I$12-I12)","v":-1406.4642757337688},{"$f":"J31*(1+$N$6*$B$7)*(1+$N$6)^($N$12-J12)","v":-858.8487398090931},{"$f":"K31*(1+$N$6*$B$7)*(1+$N$6)^($N$12-K12)","v":1030.9682851625273},{"$f":"L31*(1+$N$6*$B$7)*(1+$N$6)^($N$12-L12)","v":1528.4413754795971},{"$f":"M31*(1+$N$6*$B$7)*(1+$N$6)^($N$12-M12)","v":5038.6482023309463},{"$f":"N31*(1+$N$6*$B$7)*(1+$N$6)^($N$12-N12)","v":8706.0302790198566},{"$f":"O31*(1+$S$6*$B$7)*(1+$S$6)^($S$12-O12)","v":11013.697754370171},{"$f":"P31*(1+$S$6*$B$7)*(1+$S$6)^($S$12-P12)","v":11024.491472856322},{"$f":"Q31*(1+$S$6*$B$7)*(1+$S$6)^($S$12-Q12)","v":11534.282630596861},{"$f":"R31*(1+$S$6*$B$7)*(1+$S$6)^($S$12-R12)","v":11622.32174987207},{"$f":"S31*(1+$S$6*$B$7)*(1+$S$6)^($S$12-S12)","v":11798.326257403634},{"$f":"T31*(1+$X$6*$B$7)*(1+$X$6)^($X$12-T12)","v":15068.922863586104},{"$f":"U31*(1+$X$6*$B$7)*(1+$X$6)^($X$12-U12)","v":15126.464069647089},{"$f":"V31*(1+$X$6*$B$7)*(1+$X$6)^($X$12-V12)","v":15216.829727390712},{"$f":"W31*(1+$X$6*$B$7)*(1+$X$6)^($X$12-W12)","v":15286.500874393325},{"$f":"X31*(1+$X$6*$B$7)*(1+$X$6)^($X$12-X12)","v":14994.141402819119},{"$f":"Y31*(1+$AC$6*$B$7)*(1+$AC$6)^($AC$12-Y12)","v":18223.29123171539},{"$f":"Z31*(1+$AC$6*$B$7)*(1+$AC$6)^($AC$12-Z12)","v":17869.536159947264},{"$f":"AA31*(1+$AC$6*$B$7)*(1+$AC$6)^($AC$12-AA12)","v":17559.562368962586},{"$f":"AB31*(1+$AC$6*$B$7)*(1+$AC$6)^($AC$12-AB12)","v":17189.675069766632},{"$f":"AC31*(1+$AC$6*$B$7)*(1+$AC$6)^($AC$12-AC12)","v":16915.778116275011},{"$f":"AD31*(1+$AF$6*$B$7)*(1+$AF$6)^($AF$12-AD12)","v":18859.28193231465},{"$f":"AE31*(1+$AF$6*$B$7)*(1+$AF$6)^($AF$12-AE12)","v":18348.172917945249},{"$f":"AF31*(1+$AF$6*$B$7)*(1+$AF$6)^($AF$12-AF12)","v":17935.052162094908}]
[]
[null,"Closing TRV (Incl Return)",{"$f":"Inputs!O148/1000","v":143372.64447642598},null,null,null,null,null,{"$f":"-$C$59*(1+I6)^(I12-C12)","v":-184574.68942913579},null,null,null,null,{"$f":"-I51*(1+N6)^(N12-I12)","v":-247253.41625591676},null,null,null,null,{"$f":"-N51*(1+S6)^(S12-N12)","v":-286121.36840237537},null,null,null,null,{"$f":"-S51*(1+X6)^(X12-S12)","v":-282813.5266880226},null,null,null,null,{"$f":"-X51*(1+AC6)^(AC12-X12)","v":-255649.51886270227},null,null,{"$f":"-AC51*(1+AF6)^(AF12-AC12)","v":-190494.34579898723}]
[]
[null,"DAV",null,null,null,null,null,null,{"$f":"I39","v":153743.73827957365},null,null,null,null,{"$f":"N39","v":177846.84464436342},null,null,null,null,{"$f":"S39","v":175063.47888211891},null,null,null,null,{"$f":"X39","v":164116.80060594477},null,null,null,null,{"$f":"AC39","v":147623.48365840936},null,null,{"$f":"AF39","v":135351.8387866324}]
[]
[null,"Calculated PA",null,null,null,null,null,null,{"$f":"-SUM(D57:I62)","v":46574.622991990036},null,null,null,null,{"$f":"-SUM(J57:N62)","v":53961.332209369517},null,null,null,null,{"$f":"-SUM(O57:S62)","v":54064.769655157404},null,null,null,null,{"$f":"-SUM(T57:X62)","v":43003.867144241463},null,null,null,null,{"$f":"-SUM(Y57:AC62)","v":20268.19225762604},null,null,{"$f":"-SUM(AD57:AF62)","v":0}]
[null,"Check",null,null,null,null,null,null,{"$f":"SUM(D57:I63)","v":0},null,null,null,null,{"$f":"SUM(J57:N63)","v":0},null,null,null,null,{"$f":"SUM(O57:S63)","v":0},null,null,null,null,{"$f":"SUM(T57:X63)","v":0},null,null,null,null,{"$f":"SUM(Y57:AC63)","v":0},null,null,{"$f":"SUM(AD57:AF63)","v":0}]