{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Opening Values","Inputs","DAV","Pi's Calc","PDP Workings - DD UPDATED"],"not_rendered":{"charts":0,"images":17,"macros":1,"external_links":9,"defined_names":122,"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":"Opening Values","index":0,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[[1,1,3,1],[15,1,15,2],[16,1,16,2],[18,1,18,2],[19,1,19,2],[10,1,10,3],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[1,3,6,3],[17,1,17,2],[22,1,23,1],[22,2,22,6],[21,2,21,11],[22,7,22,8],[22,9,22,11]]}
[]
[null,"Calculating Opening Values",null,"RPI","2006-09-01",200.1]
[null,null,null,null,"2010-09-01",225.3]
[null,null,null,null,"2011-09-01",237.9]
[null,null,null,null,"2012-09-01",244.2]
[null,null,null,null,"2014-09-01",257.60000000000002]
[null,null,null,null,"2014-12-01",257.5]
[]
[]
[]
[null,"Opening DAV/TRV (2017)"]
[null,"Sep £2014",null,2016]
[null,null,null,"£'000s"]
[null,"DAV",null,{"$f":"DAV!I37","v":409537.77196960268}]
[null,"PA",null,192305.89999026165]
[null,"Q & CC",null,-9870.1647926817459]
[null,"TRV UM Adjustments PNGL12",null,6214.5756238458598]
[null,"TRV UM Adjustments GD14",null,-1867.8015198504525]
[]
[null,"TRV",null,{"$f":"SUM(D14:D19)","v":596320.28127117804}]
[]
[null,"5-year Allowed Capex Overspend","£'000s"]
[null,"Sep £2014","GD14 Determined",null,null,null,null,"PNGL12 Actuals",null,"GD14 Actuals"]
[null,null,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021]
[null,"Inclusions of overspend in DAVt",{"$f":"0/1000","v":0},{"$f":"0/1000","v":0},{"$f":"299551.037728997/1000/rpi_06*rpi_14","v":385.6289221338813},{"$f":"480869.248089519/1000/rpi_06*rpi_14","v":619.05006650604741},{"$f":"270457.265233916/1000/rpi_06*rpi_14","v":348.17487018619079},0,0,113.68071865913447,764.1822918216468,1364.1394350235437]
[null,"remaining average life",0,0,24,25,22,0,0,15,24,27]

{"sheet":"Inputs","index":1,"n_rows":131,"n_cols":40,"rows_kept":131,"cut":false,"hidden":false,"merged":[[95,9,95,38],[0,0,2,0],[53,9,53,14],[53,4,53,5],[69,4,69,5],[53,6,53,8],[69,6,69,8],[53,15,53,38]]}
["Inputs"]
[]
[null,"Sep £2014","Source",2011,{"$f":"D3+1","v":2012},{"$f":"E3+1","v":2013},2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046]
[null,null,null,null,"PNGL12 Retro Adj Actuals","PNGL12 Retro Adj Actuals","GD14 Retro Adj Actuals (INCL EAST DOWN)","GD14 Retro Adj Forecast (INCL EAST DOWN)","GD14 Retro Adj Forecast (INCL EAST DOWN)",{"$f":"IF($B$128=$B$129,$B$129,IF($B$128=$B$130,$B$130,IF($B$128=$B$131,$B$131)))","v":"UR Draft Det - Incl East Down"},"UR Draft Det - Incl East Down","UR Draft Det - Incl East Down","UR Draft Det - Incl East Down","UR Draft Det - Incl East Down","UR Draft Det - Incl East Down","UR Draft Det - Incl East Down","UR Draft Det - Incl East Down","UR Draft Det - Incl East Down","UR Draft Det - Incl East Down","UR Draft Det - Incl East Down","UR Draft Det - Incl East Down","UR Draft Det - Incl East Down","UR Draft Det - Incl East Down","UR Draft Det - Incl East Down","UR Draft Det - Incl East Down","UR Draft Det - Incl East Down","UR Draft Det - Incl East Down","UR Draft Det - Incl East Down","UR Draft Det - Incl East Down","UR Draft Det - Incl East Down","UR Draft Det - Incl East Down","UR Draft Det - Incl East Down","UR Draft Det - Incl East Down","UR Draft Det - Incl East Down","UR Draft Det - Incl East Down","UR Draft Det - Incl East Down","UR Draft Det - Incl East Down","UR Draft Det - Incl East Down","UR Draft Det - Incl East Down"]
[]
[null,null,null,null,2012,{"$f":"E6+1","v":2013},{"$f":"F6+1","v":2014},2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046]
[]
["Capex - PNGL  - GD17 Submission - Sep £2014 ","** EAST DOWN EXCLUDED **"]
[null,null,null,"Category"]
["Bulk transmission & IP/MP",">7 & 7 bar mains",null,"Mains",15249.667776238179,5882.0147136918686,0,0,0,0,0,0,1411722.3156205171,0,0,0,0,3054407.3345756498,1213897.9960339053,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Bulk transmission & IP/MP","4 bar mains",null,"Mains",324926.84983227489,392759.86539746384,0,0,0]
["Bulk transmission & IP/MP","presure reduction",null,"Mains",0,0,156833.61040050336,155223.39976922231,0,0,101342.66986437267,223928.67818786259,114898.05157827392,95734.528898356017,195715.95434834552,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","feeder mains",null,"Mains",86593.474201474179,77946.753473600489,0,0,0]
["LP","infill mains",null,"Mains",1594618.8959868955,1790746.4358872746,2677085.586535506,2686660.1169516519,2392344.355486731,2864139.1008622539,2884395.6217282536,2845027.6876884918,2649384.1407697508,2869730.3018623535,2147242.8868874782,2157389.984590916,2145698.5004098429,1764239.7048970039,1912235.6120866712,2142783.2377354377,2140671.2517699748,2138626.5208922606,2136646.2038797466,2138361.3352326592,2136415.6796839833,2134533.4455926288,2132712.1436942443,2130950.8631341392,2045527.2132222326,2044300.7930577267,2043140.7565692184,2042079.0472062593,2041057.4732508159,2043657.5361448114,2042630.0184004325,2041645.371741476,2041645.371741476,2041645.371741476,2041645.371741476]
["domestic","services",null,"Services",5214018.0966420891,5927058.9853116218,6861021.573286267,5975399.5718921199,5426732.1849776888,4769236.9880321296,4770723.7277792189,4842437.1231807433,4837241.8570936639,4838480.946649882,4615369.6288171718,4241043.0179668665,4139915.2883250499,4140455.4507624754,4178613.0042068278,4206655.8329229774,4286839.3883593371,4267477.9530367749,4286529.0171814188,4268583.6940946905,4239550.6005570162,4207731.6122123497,4217073.5592951002,4249056.2429231387,1935340.6594342231,1965008.1200997992,1963889.9548747337,1957637.4400742068,1956638.1499926436,1959256.8316564416,1958275.9416384618,1986561.8134026772,1986561.8134026772,1986561.8134026772,1986561.8134026772]
["domestic","meters",null,"Meters",2137406.9909909908,2345905.626042081,2392522.9257593779,2158166.8973430181,2022785.9687571384,3523593.9213419911,3496448.8198385518,3512434.0274860431,3520726.9623447787,3521246.5944437664,5655946.1239594854,5499566.2195409946,5166372.9106441131,5138616.9283405691,4453578.8691309113,4612242.7242375184,3873750.0400800211,3955727.3880018168,3941206.5647778572,4403003.4279319989,4614619.0444730939,5011786.8441083636,4768690.1692527477,4526651.6953996681,3664995.4545683311,3285619.3155944459,3284325.9822363574,3336378.7334974706,3335627.7311462043,3340819.9811398648,3339801.8031097883,3135993.1149924914,3135993.1149924914,3135993.1149924914,3135993.1149924914]
["Industrial/ commercial","services",null,"Services",416258.18181818287,341696.83842794865,279987.3574165235,285854.75349634915,283853.77022187604,406279.64538954454,406389.79593567684,403663.45164578268,403213.78694817261,403305.31738164288,384692.99662153015,172744.61552920062,174246.7963813091,174265.85898030005,175859.86652827298,177034.90808442247,180404.20645363379,179584.29089333935,180380.88933208602,179620.68037521438,178393.98932040931,177050.17381626158,177438.3561616115,178779.15354904067,191724.97582124471,194651.52551139676,194528.36369967103,193896.73372058323,193785.51423417003,194032.65798853207,193923.3584513017,196712.15028388202,196712.15028388202,196712.15028388202,196712.15028388202]
["Industrial/ commercial","meters",null,"Meters",221313.42178541474,104958.58834171797,267127.36290442763,269564.66869961465,267677.71601871809,1662527.4463332917,1662978.1908100343,1651821.7810279101,1649981.7186228489,1650356.2681715277,2407794.5256001106,1511061.6351313225,1243046.3251486127,1223852.7688567073,1441337.923156393,903422.18859464885,755150.34111174475,834699.82482252095,631322.09286797605,374324.32689811767,435133.1547207589,362314.07266023511,470262.21150486695,338835.99695011869,363371.91463885451,421527.59582429216,421260.88277255266,419893.05652082083,419652.20517072233,420187.40730861353,419950.71370433859,343214.68163786555,343214.68163786555,343214.68163786555,343214.68163786555]
["Other capex",null,null,"Other",201032.43243243246,28287.936482731246,100704.73384570026,100100.50544262605,1930143.3653860807,818661.20609827118,818661.20609827118,828661.20609827118,238661.20609827118,238661.20609827116,238661.20609827116,238661.20609827118,238661.20609827118,238661.20609827118,238661.20609827113,238661.20609827118,238661.20609827118,238661.20609827118,238661.20609827118,238661.20609827118,238661.20609827118,238661.20609827118,238661.20609827118,238661.20609827113,238661.20609827113,238661.20609827113,238661.20609827118,238661.20609827113,238661.20609827113,238661.20609827113,238661.20609827118,238661.20609827113,238661.20609827113,238661.20609827113,238661.20609827113]
["Engineering Other (Mgt Fee)",null,null,"Other",2882092.3561015544,2742733.3640333428,0,0,0]
["TMA",null,null,"Other",null,null,0,0,923616.51881973038,803965.57342839288,806150.91454431508,809112.8262515018,930156.21004321042,811151.65658938792,714730.55123261805,657117.76180869841,645986.05851162015,913336.83492154302,748060.64788556774,652647.39787428384,660791.48465829459,658568.8764822376,660355.61103932513,658656.57097025646,655436.026956141,651931.5231621241,652722.40591509559,655878.62596063188,417259.28484777006,420396.04386689229,420155.90751436236,419361.322100105,419148.11374776298,419694.70257897855,419482.9318490196,422491.93354280363,422491.93354280363,422491.93354280363,422491.93354280363]
[]
["Capex - PNGL  - GD17 East Down Submission - Sep £2014 ","** EAST DOWN ONLY **"]
[null,null,null,"Category"]
["Bulk transmission & IP/MP",">7 & 7 bar mains",null,"Mains"]
["Bulk transmission & IP/MP","4 bar mains",null,"Mains"]
["Bulk transmission & IP/MP","presure reduction",null,"Mains"]
["LP","feeder mains",null,"Mains"]
["LP","infill mains",null,"Mains",null,null,null,null,1830743.5634815528,3866053.5369985811,3866053.5369985811,2408724.2153337477,2408724.2153337477,2408724.2153337477,2408724.2153337477,37373.955236021429,37373.955236021429,37373.955236021429,37373.955236021429,37373.955236021429,37373.955236021429,37373.955236021429,37373.955236021429,37373.955236021429,37373.955236021429,37373.955236021429,37373.955236021429,37373.955236021429,37373.955236021429,37373.955236021429,37373.955236021429,37373.955236021429,37373.955236021429,37373.955236021429,37373.955236021429,37373.955236021429,37373.955236021429,37373.955236021429,37373.955236021429]
["domestic","services",null,"Services",null,null,null,null,0,206597.73033862904,258604.09768717951,295778.56998624495,508087.02986601327,518220.73153504543,526892.74040920695,454561.58408997476,287891.02571730892,355029.18853651726,315018.74006367294,315018.74006367294,315018.74006367294,315018.74006367294,315018.74006367294,315018.74006367294,315018.74006367294,315018.74006367294,315018.74006367294,315018.74006367294,315018.74006367294,271232.36037715274,271232.36037715274,271232.36037715274,271232.36037715274,271232.36037715274,271232.36037715274,271232.36037715274,271232.36037715274,271232.36037715274,271232.36037715274]
["domestic","meters",null,"Meters",null,null,null,null,0,82461.749567069812,98973.286315455785,112291.18772342004,184329.67377450882,184598.37064917499,189933.0086105502,165080.23329154259,106734.12367501394,128842.67559065475,116826.55183009125,116826.55183009125,116826.55183009125,116826.55183009125,116826.55183009125,116826.55183009125,116826.55183009125,116826.55183009125,116826.55183009125,116826.55183009125,116826.55183009125,98586.662011836568,181048.41157890635,197559.94832729237,210877.8497352566,282916.33578634536,283185.03266101156,288519.67062238674,263666.89530337916,205320.78568685052,227429.33760249132]
["Industrial/ commercial","services",null,"Services"]
["Industrial/ commercial","meters",null,"Meters"]
["Other capex",null,null,"Other"]
["Engineering Other (Mgt Fee)",null,null,"Other"]
["TMA",null,null,"Other"]
[]
["Capex - PNGL  - GD17 OVERALL - Sep £2014 ","** OVERALL TOTAL SUB INCL EAST DOWN **"]
[null,null,null,"Category"]
["Bulk transmission & IP/MP",">7 & 7 bar mains",null,"Mains",{"$f":"SUM(E10,E25)","v":15249.667776238179},{"$f":"SUM(F10,F25)","v":5882.0147136918686},{"$f":"SUM(G10,G25)","v":0},{"$f":"SUM(H10,H25)","v":0},{"$f":"SUM(I10,I25)","v":0},{"$f":"SUM(J10,J25)","v":0},0,0,1411722.3156205171,0,0,0,0,3054407.3345756498,1213897.9960339053,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Bulk transmission & IP/MP","4 bar mains",null,"Mains",{"$f":"SUM(E11,E26)","v":324926.84983227489},392759.86539746384,0,0,{"$f":"SUM(I11,I26)","v":0},{"$f":"SUM(J11,J26)","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,0]
["Bulk transmission & IP/MP","presure reduction",null,"Mains",0,0,156833.61040050336,155223.39976922231,0,{"$f":"SUM(J12,J27)","v":0},101342.66986437267,223928.67818786259,114898.05157827392,95734.528898356017,195715.95434834552,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","feeder mains",null,"Mains",86593.474201474179,77946.753473600489,0,0,0,{"$f":"SUM(J13,J28)","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,0]
["LP","infill mains",null,"Mains",1594618.8959868955,1790746.4358872746,2677085.586535506,2686660.1169516519,4223087.9189682836,{"$f":"SUM(J14,J29)","v":6730192.6378608346},6750449.1587268347,5253751.903022239,5058108.3561034985,5278454.5171961011,4555967.1022212263,2194763.9398269374,2183072.4556458644,1801613.6601330254,1949609.5673226926,2180157.1929714591,2178045.2070059963,2176000.476128282,2174020.159115768,2175735.2904686807,2173789.6349200048,2171907.4008286502,2170086.0989302658,2168324.8183701606,2082901.1684582541,2081674.7482937481,2080514.7118052398,2079453.0024422808,2078431.4284868373,2081031.4913808329,2080003.973636454,2079019.3269774974,2079019.3269774974,2079019.3269774974,2079019.3269774974]
["domestic","services",null,"Services",5214018.0966420891,5927058.9853116218,6861021.573286267,5975399.5718921199,5426732.1849776888,{"$f":"SUM(J15,J30)","v":4975834.7183707589},5029327.8254663981,5138215.693166988,5345328.8869596776,5356701.6781849274,5142262.3692263784,4695604.6020568414,4427806.3140423587,4495484.6392989922,4493631.7442705007,4521674.5729866503,4601858.12842301,4582496.6931004478,4601547.7572450917,4583602.4341583634,4554569.3406206891,4522750.3522760225,4532092.299358773,4564074.9829868115,2250359.399497896,2236240.4804769522,2235122.3152518864,2228869.8004513597,2227870.5103697963,2230489.1920335945,2229508.3020156147,2257794.1737798299,2257794.1737798299,2257794.1737798299,2257794.1737798299]
["domestic","meters",null,"Meters",2137406.9909909908,2345905.626042081,2392522.9257593779,2158166.8973430181,2022785.9687571384,{"$f":"SUM(J16,J31)","v":3606055.6709090611},3595422.1061540074,3624725.2152094631,3705056.6361192875,3705844.9650929412,5845879.1325700358,5664646.4528325368,5273107.034319127,5267459.603931224,4570405.4209610028,4729069.2760676099,3990576.5919101122,4072553.9398319079,4058033.1166079482,4519829.9797620904,4731445.5963031854,5128613.3959384551,4885516.7210828392,4643478.2472297596,3781822.0063984222,3384205.9776062826,3465374.3938152636,3533938.6818247628,3546505.580881461,3623736.3169262102,3622986.8357707998,3424512.7856148779,3399660.0102958707,3341313.900679342,3363422.4525949829]
["Industrial/ commercial","services",null,"Services",416258.18181818287,341696.83842794865,279987.3574165235,285854.75349634915,283853.77022187604,{"$f":"SUM(J17,J32)","v":406279.64538954454},406389.79593567684,403663.45164578268,403213.78694817261,403305.31738164288,384692.99662153015,172744.61552920062,174246.7963813091,174265.85898030005,175859.86652827298,177034.90808442247,180404.20645363379,179584.29089333935,180380.88933208602,179620.68037521438,178393.98932040931,177050.17381626158,177438.3561616115,178779.15354904067,191724.97582124471,194651.52551139676,194528.36369967103,193896.73372058323,193785.51423417003,194032.65798853207,193923.3584513017,196712.15028388202,196712.15028388202,196712.15028388202,196712.15028388202]
["Industrial/ commercial","meters",null,"Meters",221313.42178541474,104958.58834171797,267127.36290442763,269564.66869961465,267677.71601871809,{"$f":"SUM(J18,J33)","v":1662527.4463332917},1662978.1908100343,1651821.7810279101,1649981.7186228489,1650356.2681715277,2407794.5256001106,1511061.6351313225,1243046.3251486127,1223852.7688567073,1441337.923156393,903422.18859464885,755150.34111174475,834699.82482252095,631322.09286797605,374324.32689811767,435133.1547207589,362314.07266023511,470262.21150486695,338835.99695011869,363371.91463885451,421527.59582429216,421260.88277255266,419893.05652082083,419652.20517072233,420187.40730861353,419950.71370433859,343214.68163786555,343214.68163786555,343214.68163786555,343214.68163786555]
["Other capex",null,null,"Other",201032.43243243246,28287.936482731246,100704.73384570026,100100.50544262605,1930143.3653860807,{"$f":"SUM(J19,J34)","v":818661.20609827118},818661.20609827118,828661.20609827118,238661.20609827118,238661.20609827116,238661.20609827116,238661.20609827118,238661.20609827118,238661.20609827118,238661.20609827113,238661.20609827118,238661.20609827118,238661.20609827118,238661.20609827118,238661.20609827118,238661.20609827118,238661.20609827118,238661.20609827118,238661.20609827113,238661.20609827113,238661.20609827113,238661.20609827118,238661.20609827113,238661.20609827113,238661.20609827113,238661.20609827118,238661.20609827113,238661.20609827113,238661.20609827113,238661.20609827113]
["Engineering Other (Mgt Fee)",null,null,"Other",2882092.3561015544,2742733.3640333428,0,0,0,{"$f":"SUM(J20,J35)","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,0]
["TMA",null,null,"Other",0,0,0,0,923616.51881973038,{"$f":"SUM(J21,J36)","v":803965.57342839288},806150.91454431508,809112.8262515018,930156.21004321042,811151.65658938792,714730.55123261805,657117.76180869841,645986.05851162015,913336.83492154302,748060.64788556774,652647.39787428384,660791.48465829459,658568.8764822376,660355.61103932513,658656.57097025646,655436.026956141,651931.5231621241,652722.40591509559,655878.62596063188,417259.28484777006,420396.04386689229,420155.90751436236,419361.322100105,419148.11374776298,419694.70257897855,419482.9318490196,422491.93354280363,422491.93354280363,422491.93354280363,422491.93354280363]
[]
["Capex - UR Draft Det - Sep £2014"]
[null,null,null,"Category","Equates to Actuals Above",null,"Equates to Actual/Forecast Above",null,null,"Linked to Capex Spreadsheet Capex DD 04.00 Final Issued to AC Post RPE 04-03-16  - Con to Sep £2014",null,null,null,null,null,"Linked to Capex Spreadsheet Capex DD 04.00 Final Issued to AC Post RPE 04-03-16  - Con to Sep £2014"]
["Bulk transmission & IP/MP",">7 & 7 bar mains",null,"Mains",{"$f":"E10","v":15249.667776238179},{"$f":"F10","v":5882.0147136918686},{"$f":"G10","v":0},{"$f":"H10","v":0},{"$f":"I10","v":0},0,0,0,1083701.1030849144,0,0,0,0,2344699.4933668859,931842.31965586147,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AL55","v":0},"NOTE: 2046 = 2045 totals"]
["Bulk transmission & IP/MP","4 bar mains",null,"Mains",{"$f":"E11","v":324926.84983227489},392759.86539746384,0,0,0]
["Bulk transmission & IP/MP","presure reduction",null,"Mains",0,0,156833.61040050336,155223.39976922231,0,0,98947.743418597456,216882.49734254103,110610.71473162872,91605.78164202132,60996.541584575745,108220.77966890858,108220.77966890858,108220.77966890858,108220.77966890858,108220.77966890858,108220.77966890858,108220.77966890858,108220.77966890858,108220.77966890858,108220.77966890858,108220.77966890858,108220.77966890858,108220.77966890858,108220.77966890858,108220.77966890858,101382.0262766602,224015.64079347576,114942.67220256312,95771.70735782526,195791.96049584469,108220.77966890858,108220.77966890858,108220.77966890858,{"$f":"AL57","v":108220.77966890858}]
["LP","feeder mains",null,"Mains",86593.474201474179,77946.753473600489,0,0,0]
["LP","infill mains - EAST DOWN INFILL INCLUDED 2017 ONWARD",null,"Mains",1594618.8959868955,1790746.4358872746,2677085.586535506,2686660.1169516519,4238399.4277795665,4768549.9514873009,4713181.9575461885,3255429.9067866672,3228023.2032947773,3208532.136447208,3189158.7582477471,957594.39499434712,957594.39499434712,957594.39499434712,957594.39499434712,957594.39499434712,957594.39499434712,957594.39499434712,957594.39499434712,957594.39499434712,957594.39499434712,957594.39499434712,957594.39499434712,957594.39499434712,957594.39499434712,957594.39499434712,957594.39499434712,957594.39499434712,957594.39499434712,957594.39499434712,957594.39499434712,957594.39499434712,957594.39499434712,957594.39499434712,957594.39499434712]
["domestic","services - EAST DOWN DOM SERVICES INCLUDED 2017 ONWARD",null,"Services",5214018.0966420891,5927058.9853116218,6861021.573286267,5975399.5718921199,5426732.1849776888,5649567.9780040747,5541292.8041500067,5348476.4500522809,5256631.5073173381,5150198.3401137851,4906180.012158989,3924276.6129386192,3574345.0267570917,3462366.9191790028,3278929.0982122654,3138956.463739654,3006350.8100287598,2785341.3871772685,2564331.9643257782,2343322.5414742869,2122313.1186227966,1901303.6957713056,1680294.2729198143,1643459.3691112327,1606624.465302651,1569789.5614940692,1532954.6576854871,1496119.7538769054,1459284.8500683238,1422449.9462597419,1385615.04245116,1348780.1386425782,1311945.2348339963,1275110.3310254144,1275110.3310254144]
["domestic","meters - EAST DOWN DOM METERS INCLUDED 2017 ONWARD",null,"Meters",2137406.9909909908,2345905.626042081,2392522.9257593779,2158166.8973430181,2022785.9687571384,2391879.5208047256,2773482.2269774154,2937508.7826917409,3443628.8168863449,3650418.9763956955,4277218.9997089244,3984483.9779343326,3465302.3592451266,3519195.981281206,2903796.6023706673,3092204.4855793221,2423103.2768819425,2416774.1326570651,2352523.7291620946,2614511.9416221818,2722490.9779435787,2962039.4972427362,2539329.3799206046,2577687.829768348,2606456.6671541552,3112042.3025064967,3670867.3573401314,3935563.2631290611,4668662.757914098,4987170.6542305369,5338441.3473750101,4557942.8031580942,4029171.5720069534,4073475.5815810966,4073475.5815810966]
["Industrial/ commercial","services - EAST DOWN IC SERVICES INCLUDED 2017 ONWARD",null,"Services",416258.18181818287,341696.83842794865,279987.3574165235,285854.75349634915,283853.77022187604,593629.13495790982,581713.72913821694,600496.43083509442,657368.48060034041,599379.60429240554,640875.68816299015,375390.55587036285,276514.0295587295,284084.62206054834,307025.81146000122,307025.81145999918,307025.81146000122,307025.81145999918,307025.81145998457,307025.81145998457,307025.81145998667,307025.81146000751,307025.81145999709,307025.81145999709,307025.81145999918,213425.75871023539,213425.75871023748,213425.75871023332,213425.75871023748,213425.75871024167,213425.75871023748,213425.75871023748,213425.75871023748,213425.75871023748,213425.75871023748]
["Industrial/ commercial","meters - EAST DOWN IC METERS INCLUDED 2017 ONWARD",null,"Meters",221313.42178541474,104958.58834171797,267127.36290442763,269564.66869961465,267677.71601871809,772318.61892389262,783804.60465406487,792998.51808739291,833699.43935076299,823904.61195071181,833352.79719857255,1514787.4249826069,1183859.6574169642,1043618.9308911319,838496.42361425143,242481.17305612419,668957.26316783798,666292.83896980085,547473.43145476992,559286.04610993946,510017.91729451012,467988.30790568702,1620037.0305584511,1800856.4499405844,1440274.0050578101,302106.50300032826,332492.97545073967,350233.07928545843,405095.24656069482,410537.90032195079,421369.43982377794,1661375.0911161837,1330447.323550541,1190206.597024709,1190206.597024709]
["Other capex","New 5 Yr Category",null,"Other",201032.43243243246,28287.936482731246,100704.73384570026,100100.50544262605,1930143.3653860807,235466.18796963445,233021.17278525207,231151.44882850256,229755.73756582316,228368.45372135227,226989.54640965274,238753.68388349516,238753.68388349516,238753.68388349516,238753.68388349516,238753.68388349516,238753.68388349516,238753.68388349516,238753.68388349516,238753.68388349516,238753.68388349516,238753.68388349516,238753.68388349516,238753.68388349516,238753.68388349516,238753.68388349516,238753.68388349516,238753.68388349516,238753.68388349516,238753.68388349516,238753.68388349516,238753.68388349516,238753.68388349516,238753.68388349516,238753.68388349516]
["Engineering Other (Mgt Fee)",null,null,"Other",2882092.3561015544,2742733.3640333428,0,0,0]
["TMA","TMA - EAST DOWN TMA INCLUDED 2017 ONWARD",null,"Other",0,0,0,0,1108222.0260490139,1101174.7064449287,1083618.8490834411,920440.2787674045,1022572.4294297369,895811.00808534003,873621.4458569726,525726.15638033301,480845.34513101686,704874.54296007846,547539.16243224754,440357.66701940011,427097.10164831084,404996.15936316154,382895.21707801102,360794.27479286189,338693.33250771306,316592.39022256597,294491.44793741591,290807.95755655773,287124.46717569971,274080.97151986515,270397.48113900714,266713.9907581486,263030.50037729082,259347.00999643307,255663.51961557448,251980.02923471623,248296.53885385813,244613.04847299994,244613.04847299994]
["PDP REMOVAL OVER BULK MAINS","INFILL REMOVED AS PART OF PDP",null,"Mains",null,null,null,null,{"$f":"-'PDP Workings - DD UPDATED'!B33","v":-1749175.8239281755},{"$f":"-'PDP Workings - DD UPDATED'!C33","v":-3701513.8235338153},{"$f":"-'PDP Workings - DD UPDATED'!D33","v":-1986047.0239294725}]
[]
["Capex - UR Final Det - Sep £2014"]
[null,null,null,"Category","Equates to Actuals Above",null,"Equates to Actual/Forecast Above"]
["Bulk transmission & IP/MP",">7 & 7 bar mains",null,"Mains",{"$f":"E10","v":15249.667776238179},5882.0147136918686,0,0,0]
["Bulk transmission & IP/MP","4 bar mains",null,"Mains",324926.84983227489,392759.86539746384,0,0,0]
["Bulk transmission & IP/MP","presure reduction",null,"Mains",0,0,156833.61040050336,155223.39976922231,0]
["LP","feeder mains",null,"Mains",86593.474201474179,77946.753473600489,0,0,0]
["LP","infill mains",null,"Mains",1594618.8959868955,1790746.4358872746,2677085.586535506,2686660.1169516519,2392344.355486731]
["domestic","services",null,"Services",5214018.0966420891,5927058.9853116218,6861021.573286267,5975399.5718921199,5426732.1849776888]
["domestic","meters",null,"Meters",2137406.9909909908,2345905.626042081,2392522.9257593779,2158166.8973430181,2022785.9687571384]
["Industrial/ commercial","services",null,"Services",416258.18181818287,341696.83842794865,279987.3574165235,285854.75349634915,283853.77022187604]
["Industrial/ commercial","meters",null,"Meters",221313.42178541474,104958.58834171797,267127.36290442763,269564.66869961465,267677.71601871809]
["Other capex",null,null,"Other",201032.43243243246,28287.936482731246,100704.73384570026,100100.50544262605,1930143.3653860807]
["Engineering Other (Mgt Fee)",null,null,"Other",2882092.3561015544,2742733.3640333428,0,0,0]
["TMA",null,null,"Other",0,0,0,0,923616.51881973038]
["PDP REMOVAL OVER BULK MAINS","INFILL REMOVED AS PART OF PDP",null,"Mains"]
[]
["Capex"]
["Total Capex - GD17 Submission - Sep £2014",null,null,null,{"$f":"SUM(E40:E51)","v":13093510.367567547},{"$f":"SUM(F40:F51)","v":13757976.408111474},12735283.150148306,11630969.913594604,15077897.443149514,{"$f":"SUM(J40:J51)","v":19003516.898390152},19170721.867599908,17933880.754610017,18857127.168093756,17540210.137613159,19485703.837918513,15134600.213283809,14185926.190147163,17169081.906795714,14831464.372256607,13402666.742677346,12605487.165661063,12742565.307357006,12544320.832306467,12730430.488730995,12967428.948939459,13253228.124780022,13126779.299051724,12788033.031144792,9326099.9557607118,8977357.5776778348,9055617.7809572462,9114073.8031581827,9124054.5589890219,9207832.9743150342,9204517.3215257991,8962406.2579350267,8937553.4826160204,8879207.3729994912,{"$f":"SUM(AM40:AM51)","v":8901315.9249151312}]
["Total Capex - UR Draft Det - Sep £2014",null,null,null,{"$f":"SUM(E55:E67)","v":13093510.367567547},{"$f":"SUM(F55:F67)","v":13757976.408111474},12735283.150148306,11630969.913594604,{"$f":"SUM(I55:I67)","v":13528638.635261904},{"$f":"SUM(J55:J67)","v":11811072.275058649},13823016.063823711,14303384.313391624,15865991.432261668,14648218.912648521,15008393.789328426,11629233.586653007,10285435.27665568,12663409.348285604,10112198.276292047,8525594.4594012517,8137103.1217336031,7884999.1881740466,7458819.0120273903,7489509.4740060056,7305110.0163753349,7259518.5611490533,7745746.8013430331,7924406.2763834698,7552074.2746970672,6776013.9557777457,7317868.3354801042,7682419.5654311255,8320789.8647110509,8585051.0557545722,9006655.147349447,9338072.6794085614,8437855.2865023371,8301400.1753612077,{"$f":"SUM(AM55:AM67)","v":8301400.1753612077}]
["Total Capex - UR Final Det - Sep £2014",null,null,null,{"$f":"SUM(E71:E83)","v":13093510.367567547},{"$f":"SUM(F71:F83)","v":13757976.408111474},12735283.150148306,11630969.913594604,{"$f":"SUM(I71:I83)","v":13247153.879667962},{"$f":"SUM(J71:J83)","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,{"$f":"SUM(AM71:AM83)","v":0}]
[]
["Opex"]
["Total Capex - GD17 Submission - Sep £2014",null,null,null,18549942.268388364,15795746.919990418,14550551.970897809,15898581.833370512,16411036.009646954,16990835.404128112,17413237.140234556,17646480.713075191,17951186.675655503,18316264.795625377,18616976.207101058,18725572.780043356,18790861.53922167,18904547.070102807,19191582.075270932,19448589.564118553,19419434.031872861,19577567.211867735,19854072.542367786,20116509.113741305,20269386.736928385,20442165.070332848,20584895.835044548,20686741.207542952,19652844.319927931,19683299.880392425,19701926.586702783,19785333.594097398,19825956.473152068,20090874.935537573,20268233.166786261,20182925.657912567,20196336.103425719,20209746.548938867,20223156.994452022]
["Total Capex - UR Draft Det - Sep £2014",null,null,null,{"$f":"E91","v":18549942.268388364},{"$f":"F91","v":15795746.919990418},{"$f":"G91","v":14550551.970897809},{"$f":"H91","v":15898581.833370512},{"$f":"I91","v":16411036.009646954},13894889.721356681,13786172.834186561,13665909.760566084,13587442.77387638,13515050.356994217,13551326.504218973,13552403.371397134,13665026.776304686,13775015.197215285,13879281.259199714,13975024.807615366,14065603.09178034,14111244.022864737,14147883.370092984,14175595.994900532,14194548.441280901,14204903.135930842,14211930.149876038,14290690.462938586,14368401.079745565,14444861.374959242,14520186.7857513,14594269.28082064,14667224.039816612,14738943.229261169,14809338.968078775,14878415.28382816,14946378.581136536,15014561.877432546,15098622.309670191]
["Total Capex - UR Final Det - Sep £2014",null,null,null,{"$f":"E91","v":18549942.268388364},{"$f":"F91","v":15795746.919990418},{"$f":"G91","v":14550551.970897809},{"$f":"H91","v":15898581.833370512},{"$f":"I91","v":16411036.009646954}]
[]
["Volumes (Therms)"]
["Submission"]
["Domestic","P1",null,null,null,null,"TO RELINK TO AMcE FILE ONCE REC'd",null,"TO RELINK TO AMcE FILE ONCE REC'd",80824772.190561533,84247122.930693761,87728447.736934483,91397376.953424737,95063665.466860801,98701544.792494178,102208342.28825721,105284437.72741523,107824786.6444934,110600663.78120574,113633095.79813306,116657060.13247614,119681024.46681924,122704988.80116232,125728953.13550541,128752917.46984848,131776881.8041916,134800846.13853469,137824810.47287777,140450559.25240719,142241423.22686106,143634071.64650127,145026720.06614152,146419368.48578173,147812016.90542194,149204665.32506219,150597313.7447024,152669020.26551729,154061668.68515751,155454317.10479775]
["Tariff","P2",null,null,null,null,null,null,null,21656580.376068488,21925479.477996744,22202898.70386935,22502431.987709176,22782099.289124031,23078458.708287232,23303938.432091363,23411909.241891969,23522436.892240245,23652599.816690892,23769255.417984467,23885911.019278031,24002566.620571598,24119222.221865162,24235877.823158719,24352533.42445229,24469189.025745861,24585844.627039429,24702500.228333,24819155.829626575,24908923.67370332,24998691.517780062,25088459.361856803,25178227.205933545,25267995.050010301,25357762.89408705,25447530.738163803,25537298.582240552,25627066.426317301,25716834.27039405]
["Contract","P3 + P4",null,null,null,null,null,null,null,48365392.276152007,48490392.276152007,48615392.276152007,48740392.276152007,48865392.276152007,48990392.276152007,49115392.276152,49240392.276152,49365392.276151992,49365392.276151992,49365392.276151992,49365392.276151992,49365392.276151992,49365392.276151992,49365392.276151992,49365392.276151992,49365392.276151992,49365392.276151992,49365392.276151992,49365392.276151992,49365392.276151992,49365392.276151992,49365392.276151992,49365392.276151992,49365392.276151992,49365392.276151992,49365392.276151992,49365392.276152,49365392.276152,49365392.276152]
["Total Volume (Therms) - FE GD17 Submission",null,null,null,null,null,null,null,null,{"$f":"SUM(J97:J99)","v":150846744.84278202},{"$f":"SUM(K97:K99)","v":154662994.68484253},{"$f":"SUM(L97:L99)","v":158546738.71695584},162640201.21728593,166711157.03213683,170770395.77693343,174627672.99650055,177936739.2454592,180712615.81288564,183618655.87404862,186767743.49226952,189908363.42790616,193048983.36354282,196189603.29917946,199330223.2348161,202470843.17045274,205611463.10608944,208752083.04172611,211892702.97736275,214635107.35818574,216515739.17671636,217998155.44043332,219480571.70415029,220962987.96786726,222445404.23158422,223927820.49530122,225410236.75901818,227571711.12390983,229054127.38762683,230536543.65134382]
["GD17 Draft Det"]
["Domestic","P1",null,null,null,null,null,null,null,72721410.835386544,75996052.942239761,79142388.542365924,82215054.872507483,85206819.759196445,88071802.824888676,90569587.854725912,92657102.141184151,94644285.516809404,96439021.652527496,98272671.023389816,100047420.39425212,101740469.76511444,103329019.13597676,104813068.50683907,106190717.87770137,107461967.24856369,108626816.61942601,109732765.99028832,110827315.36115064,111910464.73201294,112980314.10287526,114036863.47373758,115080112.84459989,116110062.21546221,117126711.58632453,118128160.95718685,119395252.87441026,120368202.24527258,121342457.84495491]
["Tariff","P2",null,null,null,null,null,null,null,27987562.306938265,28483416.201228999,28999975.328422602,29570275.072962716,30092297.375104163,30613830.982415792,31082794.456174791,31278378.077103719,30955526.272220429,31703910.393295497,31932664.311437771,32149353.333150666,32366042.354863562,32582731.376576439,32799420.398289319,33016109.420002203,33232798.441715103,33449487.463427994,33666176.48514089,33882865.506853789,34034213.075901732,34185560.64494966,34336908.213997588,34488255.783045515,34639603.352093458,34790950.921141401,34942298.490189344,35093646.059237279,35244993.628285214,35396341.19733315]
["Contract","P3 + P4",null,null,null,null,null,null,null,48365392.276152007,48490392.276152007,48615392.276152007,48740392.276152007,48865392.276152007,48990392.276152007,49115392.276152,49240392.276152,49365392.276151992,49365392.276151992,49365392.276151992,49365392.276151992,49365392.276151992,49365392.276151992,49365392.276151992,49365392.276151992,49365392.276151992,49365392.276151992,49365392.276151992,49365392.276151992,49365392.276151992,49365392.276151992,49365392.276151992,49365392.276151992,49365392.276151992,49365392.276151992,49365392.276151992,49365392.276152,49365392.276152,49365392.276152]
["Total Volume (Therms) - UR Draft Det",null,null,null,null,null,null,null,null,{"$f":"SUM(J102:J104)","v":149074365.41847682},152969861.41962078,156757756.14694053,160525722.2216222,164164509.4104526,167676026.08345649,170767774.5870527,173175872.49443987,174965204.06518182,177508324.32197499,179570727.61097959,181562166.00355479,183471904.39613,185277142.7887052,186977881.18128037,188572219.57385555,190060157.96643078,191441696.35900599,192764334.75158119,194075573.14415643,195310070.08406666,196531267.02397689,197739163.96388716,198933760.90379739,200115057.84370765,201283054.78361791,202435851.72352818,203854291.20979953,204978588.14970982,206104191.31844008]
["GD17 Final Det"]
["Domestic","P1"]
["Tariff","P2"]
["Contract","P3 + P4"]
["Total Volume (Therms) - UR Final Det",null,null,null,null,null,null,null,null,{"$f":"SUM(J107:J109)","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,0]
[]
["Q & CC Calcs"]
[null,null,null,null,"Opex",null,{"$f":"IF($B$128=$B$129,G91,IF($B$128=$B$130,G92,IF($B$128=$B$131,G93)))","v":14550551.970897809},{"$f":"IF($B$128=$B$129,H91,IF($B$128=$B$130,H92,IF($B$128=$B$131,H93)))","v":15898581.833370512},16411036.009646954,{"$f":"IF($B$128=$B$129,J91,IF($B$128=$B$130,J92,IF($B$128=$B$131,J93)))","v":13894889.721356681},13786172.834186561,13665909.760566084,13587442.77387638,13515050.356994217,13551326.504218973,13552403.371397134,13665026.776304686,13775015.197215285,13879281.259199714,13975024.807615366,14065603.09178034,14111244.022864737,14147883.370092984,14175595.994900532,14194548.441280901,14204903.135930842,14211930.149876038,14290690.462938586,14368401.079745565,14444861.374959242,14520186.7857513,14594269.28082064,14667224.039816612,14738943.229261169,14809338.968078775,14878415.28382816,14946378.581136536,15014561.877432546,15098622.309670191]
[null,null,null,null,"Capex",null,12903134.23767028,12598408.350679506,13087626.101593731,{"$f":"IF($B$128=$B$129,J86,IF($B$128=$B$130,J87,IF($B$128=$B$131,J88)))","v":11811072.275058649},{"$f":"IF($B$128=$B$129,K86,IF($B$128=$B$130,K87,IF($B$128=$B$131,K88)))","v":13823016.063823711},14303384.313391624,15865991.432261668,14648218.912648521,15008393.789328426,11629233.586653007,10285435.27665568,12663409.348285604,10112198.276292047,8525594.4594012517,8137103.1217336031,7884999.1881740466,7458819.0120273903,7489509.4740060056,7305110.0163753349,7259518.5611490533,7745746.8013430331,7924406.2763834698,7552074.2746970672,6776013.9557777457,7317868.3354801042,7682419.5654311255,8320789.8647110509,8585051.0557545722,9006655.147349447,9338072.6794085614,8437855.2865023371,8301400.1753612077,8301400.1753612077]
[null,null,null,null,"GD14/GD17 Allowed Revenue",null,47057.766288488849,48820.298209229746,50636.490339679811,{"$f":"'Pi''s Calc'!D26","v":47930.435973590065},{"$f":"'Pi''s Calc'!E26","v":49321.74324573492},{"$f":"'Pi''s Calc'!F26","v":50672.967762075692},{"$f":"'Pi''s Calc'!G26","v":52014.944663732778},{"$f":"'Pi''s Calc'!H26","v":53311.473815154081},{"$f":"'Pi''s Calc'!I26","v":54561.506106693894},{"$f":"'Pi''s Calc'!J26","v":55660.043210927091},{"$f":"'Pi''s Calc'!K26","v":56518.71173630016},{"$f":"'Pi''s Calc'!L26","v":57170.181797600337},{"$f":"'Pi''s Calc'!M26","v":58072.287362013609},{"$f":"'Pi''s Calc'!N26","v":58817.692295730099},{"$f":"'Pi''s Calc'!O26","v":59537.601985837304},{"$f":"'Pi''s Calc'!P26","v":60227.652028930839},{"$f":"'Pi''s Calc'!Q26","v":60879.509500262706},{"$f":"'Pi''s Calc'!R26","v":61493.174399832889},{"$f":"'Pi''s Calc'!S26","v":62067.952317245727},{"$f":"'Pi''s Calc'!T26","v":62603.843252501247},{"$f":"'Pi''s Calc'!U26","v":63100.847205599421},{"$f":"'Pi''s Calc'!V26","v":63576.324436431925},{"$f":"'Pi''s Calc'!W26","v":64047.635204890437},{"$f":"'Pi''s Calc'!X26","v":64493.286665923006},{"$f":"'Pi''s Calc'!Y26","v":64934.077254185919},{"$f":"'Pi''s Calc'!Z26","v":65370.006969679162},{"$f":"'Pi''s Calc'!AA26","v":65801.075812402734},{"$f":"'Pi''s Calc'!AB26","v":66227.283782356637},{"$f":"'Pi''s Calc'!AC26","v":66648.630879540884},{"$f":"'Pi''s Calc'!AD26","v":67064.422693559798},{"$f":"'Pi''s Calc'!AE26","v":67577.301321117935},{"$f":"'Pi''s Calc'!AF26","v":67982.676979201831},{"$f":"'Pi''s Calc'!AG26","v":68388.530036691911}]
[]
["Working Capital (£2014)",null,null,null,null,null,-3912000,{"$f":"G117-(H113-G113)*12%+(H115-G115)*1000*15%","v":-3809383.7953855898},{"$f":"H117-(I113-H113)*12%+(I115-H115)*1000*15%","v":-3598449.4769712528},{"$f":"I117-(J113-I113)*12%+(J115-I115)*1000*15%","v":-3702420.0772898817},{"$f":"J117-(K113-J113)*12%+(K115-J115)*1000*15%","v":-3480677.9600077393},{"$f":"K117-(L113-K113)*12%+(L115-K115)*1000*15%","v":-3263562.7137221661},-3052850.1400708384,-2849683.6773317838,-2666531.9712677822,-2501880.629694182,-2386595.1594771277,-2302073.260791373,-2179269.3535675136,-2078947.8393199183,-1981830.7799036345,-1883800.1851697317,-1790418.2861373413,-1701694.0661787195,-1617751.6721324383,-1538610.595202103,-1464903.2439108004,-1403032.8968534307,-1341661.5556014911,-1283989.0718722472,-1226909.5329278572,-1170409.9750121918,-1114504.2196831726,-1059179.3269234342,-1004424.7510039099,-950345.13679099886,-881568.93833428342,-828944.58517722017,-778153.87842222571]
[]
["Capital Creditors (£2014)",null,null,null,null,null,-6395000,{"$f":"G119-(H114-G114)*1/6","v":-6344212.3521682043},{"$f":"H119-(I114-H114)*1/6","v":-6425748.6439872421},{"$f":"I119-(J114-I114)*1/6","v":-6212989.6728980616},{"$f":"J119-(K114-J114)*1/6","v":-6548313.6376922382},{"$f":"K119-(L114-K114)*1/6","v":-6628375.0126202237},-6888809.5324318977,-6685847.4458297063,-6745876.5919430237,-6182683.2248304542,-5958716.8398308996,-6355045.8517692201,-5929844.0064369608,-5665410.036955162,-5600661.480677221,-5558644.1584172947,-5487614.1290595187,-5492729.2060559541,-5461995.9631175091,-5454397.3872464625,-5535435.4272787925,-5565212.0064521991,-5503156.6728377985,-5373813.2863512449,-5464122.3496349715,-5524880.8879601415,-5631275.9378401292,-5675319.4696807163,-5745586.8182798624,-5800823.0736230481,-5650786.8414720111,-5628044.3229484893,-5628044.3229484893]
[]
[]
[]
[]
[]
[]
[]
["INPUTS BASIS"]
["SELECT BASIS OF MODELLING INPUTS","UR Draft Det - Incl East Down"]
[null,"PNGL GD17 Submission - Incl East Down"]
[null,"UR Draft Det - Incl East Down"]
[null,"UR Final Det - Incl East Down"]

{"sheet":"DAV","index":2,"n_rows":37,"n_cols":39,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,2,1],[4,9,4,38]]}
["Condition 2.3.17 Calculation of DAV"]
[null,null,"Sep £2014"]
[null,null,"£'000"]
[]
[null,null,null,null,null,null,null,null,null,"IMPORTANT NOTE:  Total Capex and Breakdown from 2017 Onwards are forecasts and will be determined as part of the Next Price Control."]
[null,null,null,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046]
[]
["Opening DAV (Incl Rolling Capex Incentive)",null,null,null,{"$f":"D37+'Opening Values'!C25","v":410309.1524572855},{"$f":"E37+'Opening Values'!D25","v":410909.12879972113},{"$f":"F37+'Opening Values'!E25","v":412113.13135236577},{"$f":"G37+'Opening Values'!F25","v":412082.59307888249},{"$f":"H37+'Opening Values'!G25","v":410260.17464010714},{"$f":"I37+'Opening Values'!H25+'PDP Workings - DD UPDATED'!C12/1000+'PDP Workings - DD UPDATED'!C13/1000-IF(DAV!J6='PDP Workings - DD UPDATED'!$H$45,'PDP Workings - DD UPDATED'!C12/1000)+'PDP Workings - DD UPDATED'!C38/1000+'PDP Workings - DD UPDATED'!C39/1000-IF(DAV!J6='PDP Workings - DD UPDATED'!$H$45,'PDP Workings - DD UPDATED'!C38,0)","v":414944.73222146649},{"$f":"J37+'Opening Values'!I25+'PDP Workings - DD UPDATED'!D13/1000-IF(DAV!K6='PDP Workings - DD UPDATED'!$H$45,'PDP Workings - DD UPDATED'!D12/1000)+'PDP Workings - DD UPDATED'!D39/1000-IF(DAV!K6='PDP Workings - DD UPDATED'!$H$45,'PDP Workings - DD UPDATED'!D38/1000)","v":413886.21799457516},{"$f":"K37+'Opening Values'!J25+'PDP Workings - DD UPDATED'!E13/1000-IF(DAV!L6='PDP Workings - DD UPDATED'!$H$45,'PDP Workings - DD UPDATED'!E12/1000)+'PDP Workings - DD UPDATED'!E39/1000-IF(DAV!L6='PDP Workings - DD UPDATED'!$H$45,'PDP Workings - DD UPDATED'!E38/1000)","v":412383.05568409601},{"$f":"L37+'Opening Values'!K25+'PDP Workings - DD UPDATED'!F13/1000-IF(DAV!M6='PDP Workings - DD UPDATED'!$H$45,'PDP Workings - DD UPDATED'!F12/1000)+'PDP Workings - DD UPDATED'!F39/1000-IF(DAV!M6='PDP Workings - DD UPDATED'!$H$45,'PDP Workings - DD UPDATED'!F38/1000)","v":404564.80736515392},{"$f":"M37+'Opening Values'!L25+'PDP Workings - DD UPDATED'!G13/1000-IF(DAV!N6='PDP Workings - DD UPDATED'!$H$45,'PDP Workings - DD UPDATED'!G12/1000)+'PDP Workings - DD UPDATED'!G39/1000-IF(DAV!N6='PDP Workings - DD UPDATED'!$H$45,'PDP Workings - DD UPDATED'!G38/1000)","v":405333.02494672267},{"$f":"N37+'PDP Workings - DD UPDATED'!H13/1000-IF(DAV!O6='PDP Workings - DD UPDATED'!$H$45,'PDP Workings - DD UPDATED'!H12/1000)+'PDP Workings - DD UPDATED'!H39/1000-IF(DAV!O6='PDP Workings - DD UPDATED'!$H$45,'PDP Workings - DD UPDATED'!H38/1000)","v":402876.2067891442},{"$f":"O37-IF(DAV!P6='PDP Workings - DD UPDATED'!$H$45,'PDP Workings - DD UPDATED'!I12/1000)-IF(DAV!P6='PDP Workings - DD UPDATED'!$H$45,'PDP Workings - DD UPDATED'!I38/1000)","v":400198.78323894687},{"$f":"P37","v":393627.1546778304},385265.32523585868,378778.93659663608,369336.49484849465,358116.22822832165,346344.5666263249,334178.49384858779,321446.75481754425,308584.89334988914,295438.23218830471,282164.69507978996,269272.68365105864,256469.90625464986,243241.63830299856,229272.32711186167,215899.59784935066,202836.69745659549,190327.65953855152,177898.80705588026,165654.68138932632,153461.48940368523,140177.16375802527,{"$f":"AL37","v":126528.8298922031}]
[]
["Capex"]
["Mains",null,null,null,{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!E40:E44)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!E55:E59,Inputs!E67)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!E71:E75,Inputs!E83)/1000,0)))","v":2021.3888877968827},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!F40:F44)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!F55:F59,Inputs!F67)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!F71:F75,Inputs!F83)/1000,0)))","v":2267.3350694720307},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!G40:G44)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!G55:G59,Inputs!G67)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!G71:G75,Inputs!G83)/1000,0)))","v":2833.9191969360095},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!H40:H44)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!H55:H59,Inputs!H67)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!H71:H75,Inputs!H83)/1000,0)))","v":2841.883516720874},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!I40:I44)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!I55:I59,Inputs!I67)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!I71:I75,Inputs!I83)/1000,0)))","v":2489.2236038513911},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!J40:J44)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!J55:J59,Inputs!J67)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!J71:J75,Inputs!J83)/1000,0)))","v":1067.0361279534857},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!K40:K44)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!K55:K59,Inputs!K67)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!K71:K75,Inputs!K83)/1000,0)))","v":2826.0826770353137},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!L40:L44)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!L55:L59,Inputs!L67)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!L71:L75,Inputs!L83)/1000,0)))","v":3472.3124041292081},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!M40:M44)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!M55:M59,Inputs!M67)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!M71:M75,Inputs!M83)/1000,0)))","v":4422.3350211113211},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!N40:N44)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!N55:N59,Inputs!N67)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!N71:N75,Inputs!N83)/1000,0)))","v":3300.1379180892291},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!O40:O44)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!O55:O59,Inputs!O67)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!O71:O75,Inputs!O83)/1000,0)))","v":3250.1552998323227},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!P40:P44)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!P55:P59,Inputs!P67)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!P71:P75,Inputs!P83)/1000,0)))","v":1065.8151746632557},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!Q40:Q44)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!Q55:Q59,Inputs!Q67)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!Q71:Q75,Inputs!Q83)/1000,0)))","v":1065.8151746632557},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!R40:R44)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!R55:R59,Inputs!R67)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!R71:R75,Inputs!R83)/1000,0)))","v":3410.5146680301418},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!S40:S44)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!S55:S59,Inputs!S67)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!S71:S75,Inputs!S83)/1000,0)))","v":1997.6574943191172},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!T40:T44)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!T55:T59,Inputs!T67)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!T71:T75,Inputs!T83)/1000,0)))","v":1065.8151746632557},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!U40:U44)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!U55:U59,Inputs!U67)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!U71:U75,Inputs!U83)/1000,0)))","v":1065.8151746632557},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!V40:V44)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!V55:V59,Inputs!V67)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!V71:V75,Inputs!V83)/1000,0)))","v":1065.8151746632557},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!W40:W44)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!W55:W59,Inputs!W67)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!W71:W75,Inputs!W83)/1000,0)))","v":1065.8151746632557},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!X40:X44)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!X55:X59,Inputs!X67)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!X71:X75,Inputs!X83)/1000,0)))","v":1065.8151746632557},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!Y40:Y44)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!Y55:Y59,Inputs!Y67)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!Y71:Y75,Inputs!Y83)/1000,0)))","v":1065.8151746632557},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!Z40:Z44)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!Z55:Z59,Inputs!Z67)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!Z71:Z75,Inputs!Z83)/1000,0)))","v":1065.8151746632557},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AA40:AA44)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AA55:AA59,Inputs!AA67)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AA71:AA75,Inputs!AA83)/1000,0)))","v":1065.8151746632557},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AB40:AB44)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AB55:AB59,Inputs!AB67)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AB71:AB75,Inputs!AB83)/1000,0)))","v":1065.8151746632557},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AC40:AC44)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AC55:AC59,Inputs!AC67)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AC71:AC75,Inputs!AC83)/1000,0)))","v":1065.8151746632557},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AD40:AD44)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AD55:AD59,Inputs!AD67)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AD71:AD75,Inputs!AD83)/1000,0)))","v":1065.8151746632557},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AE40:AE44)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AE55:AE59,Inputs!AE67)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AE71:AE75,Inputs!AE83)/1000,0)))","v":1058.9764212710072},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AF40:AF44)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AF55:AF59,Inputs!AF67)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AF71:AF75,Inputs!AF83)/1000,0)))","v":1181.6100357878229},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AG40:AG44)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AG55:AG59,Inputs!AG67)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AG71:AG75,Inputs!AG83)/1000,0)))","v":1072.5370671969104},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AH40:AH44)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AH55:AH59,Inputs!AH67)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AH71:AH75,Inputs!AH83)/1000,0)))","v":1053.3661023521724},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AI40:AI44)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AI55:AI59,Inputs!AI67)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AI71:AI75,Inputs!AI83)/1000,0)))","v":1153.3863554901918},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AJ40:AJ44)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AJ55:AJ59,Inputs!AJ67)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AJ71:AJ75,Inputs!AJ83)/1000,0)))","v":1065.8151746632557},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AK40:AK44)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AK55:AK59,Inputs!AK67)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AK71:AK75,Inputs!AK83)/1000,0)))","v":1065.8151746632557},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AL40:AL44)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AL55:AL59,Inputs!AL67)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AL71:AL75,Inputs!AL83)/1000,0)))","v":1065.8151746632557},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AM40:AM44)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AM55:AM59,Inputs!AM67)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AM71:AM75,Inputs!AM83)/1000,0)))","v":1065.8151746632557}]
["Services",null,null,null,{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!E45,Inputs!E47)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!E60,Inputs!E62)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!E76,Inputs!E78)/1000,0)))","v":5630.2762784602719},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!F45,Inputs!F47)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!F60,Inputs!F62)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!F76,Inputs!F78)/1000,0)))","v":6268.7558237395706},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!G45,Inputs!G47)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!G60,Inputs!G62)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!G76,Inputs!G78)/1000,0)))","v":7141.0089307027902},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!H45,Inputs!H47)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!H60,Inputs!H62)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!H76,Inputs!H78)/1000,0)))","v":6261.2543253884687},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!I45,Inputs!I47)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!I60,Inputs!I62)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!I76,Inputs!I78)/1000,0)))","v":5710.5859551995645},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!J45,Inputs!J47)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!J60,Inputs!J62)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!J76,Inputs!J78)/1000,0)))","v":6243.1971129619842},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!K45,Inputs!K47)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!K60,Inputs!K62)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!K76,Inputs!K78)/1000,0)))","v":6123.0065332882241},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!L45,Inputs!L47)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!L60,Inputs!L62)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!L76,Inputs!L78)/1000,0)))","v":5948.9728808873751},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!M45,Inputs!M47)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!M60,Inputs!M62)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!M76,Inputs!M78)/1000,0)))","v":5913.9999879176785},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!N45,Inputs!N47)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!N60,Inputs!N62)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!N76,Inputs!N78)/1000,0)))","v":5749.5779444061909},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!O45,Inputs!O47)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!O60,Inputs!O62)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!O76,Inputs!O78)/1000,0)))","v":5547.0557003219792},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!P45,Inputs!P47)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!P60,Inputs!P62)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!P76,Inputs!P78)/1000,0)))","v":4299.6671688089818},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!Q45,Inputs!Q47)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!Q60,Inputs!Q62)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!Q76,Inputs!Q78)/1000,0)))","v":3850.8590563158209},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!R45,Inputs!R47)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!R60,Inputs!R62)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!R76,Inputs!R78)/1000,0)))","v":3746.4515412395513},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!S45,Inputs!S47)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!S60,Inputs!S62)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!S76,Inputs!S78)/1000,0)))","v":3585.9549096722667},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!T45,Inputs!T47)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!T60,Inputs!T62)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!T76,Inputs!T78)/1000,0)))","v":3445.982275199653},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!U45,Inputs!U47)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!U60,Inputs!U62)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!U76,Inputs!U78)/1000,0)))","v":3313.376621488761},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!V45,Inputs!V47)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!V60,Inputs!V62)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!V76,Inputs!V78)/1000,0)))","v":3092.3671986372674},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!W45,Inputs!W47)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!W60,Inputs!W62)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!W76,Inputs!W78)/1000,0)))","v":2871.3577757857629},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!X45,Inputs!X47)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!X60,Inputs!X62)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!X76,Inputs!X78)/1000,0)))","v":2650.3483529342716},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!Y45,Inputs!Y47)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!Y60,Inputs!Y62)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!Y76,Inputs!Y78)/1000,0)))","v":2429.338930082783},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!Z45,Inputs!Z47)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!Z60,Inputs!Z62)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!Z76,Inputs!Z78)/1000,0)))","v":2208.3295072313131},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AA45,Inputs!AA47)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AA60,Inputs!AA62)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AA76,Inputs!AA78)/1000,0)))","v":1987.3200843798113},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AB45,Inputs!AB47)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AB60,Inputs!AB62)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AB76,Inputs!AB78)/1000,0)))","v":1950.4851805712296},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AC45,Inputs!AC47)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AC60,Inputs!AC62)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AC76,Inputs!AC78)/1000,0)))","v":1913.6502767626503},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AD45,Inputs!AD47)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AD60,Inputs!AD62)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AD76,Inputs!AD78)/1000,0)))","v":1783.2153202043046},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AE45,Inputs!AE47)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AE60,Inputs!AE62)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AE76,Inputs!AE78)/1000,0)))","v":1746.3804163957245},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AF45,Inputs!AF47)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AF60,Inputs!AF62)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AF76,Inputs!AF78)/1000,0)))","v":1709.5455125871388},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AG45,Inputs!AG47)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AG60,Inputs!AG62)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AG76,Inputs!AG78)/1000,0)))","v":1672.7106087785612},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AH45,Inputs!AH47)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AH60,Inputs!AH62)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AH76,Inputs!AH78)/1000,0)))","v":1635.8757049699836},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AI45,Inputs!AI47)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AI60,Inputs!AI62)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AI76,Inputs!AI78)/1000,0)))","v":1599.0408011613974},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AJ45,Inputs!AJ47)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AJ60,Inputs!AJ62)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AJ76,Inputs!AJ78)/1000,0)))","v":1562.2058973528156},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AK45,Inputs!AK47)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AK60,Inputs!AK62)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AK76,Inputs!AK78)/1000,0)))","v":1525.3709935442337},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AL45,Inputs!AL47)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AL60,Inputs!AL62)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AL76,Inputs!AL78)/1000,0)))","v":1488.5360897356518},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AM45,Inputs!AM47)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AM60,Inputs!AM62)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AM76,Inputs!AM78)/1000,0)))","v":1488.5360897356518}]
["Meters",null,null,null,{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!E46,Inputs!E48)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!E61,Inputs!E63)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!E77,Inputs!E79)/1000,0)))","v":2358.7204127764053},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!F46,Inputs!F48)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!F61,Inputs!F63)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!F77,Inputs!F79)/1000,0)))","v":2450.8642143837992},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!G46,Inputs!G48)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!G61,Inputs!G63)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!G77,Inputs!G79)/1000,0)))","v":2659.6502886638054},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!H46,Inputs!H48)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!H61,Inputs!H63)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!H77,Inputs!H79)/1000,0)))","v":2427.7315660426329},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!I46,Inputs!I48)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!I61,Inputs!I63)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!I77,Inputs!I79)/1000,0)))","v":2290.4636847758561},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!J46,Inputs!J48)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!J61,Inputs!J63)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!J77,Inputs!J79)/1000,0)))","v":3164.1981397286181},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!K46,Inputs!K48)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!K61,Inputs!K63)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!K77,Inputs!K79)/1000,0)))","v":3557.2868316314803},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!L46,Inputs!L48)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!L61,Inputs!L63)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!L77,Inputs!L79)/1000,0)))","v":3730.5073007791339},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!M46,Inputs!M48)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!M61,Inputs!M63)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!M77,Inputs!M79)/1000,0)))","v":4277.3282562371087},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!N46,Inputs!N48)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!N61,Inputs!N63)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!N77,Inputs!N79)/1000,0)))","v":4474.3235883464067},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!O46,Inputs!O48)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!O61,Inputs!O63)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!O77,Inputs!O79)/1000,0)))","v":5110.5717969074967},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!P46,Inputs!P48)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!P61,Inputs!P63)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!P77,Inputs!P79)/1000,0)))","v":5499.2714029169401},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!Q46,Inputs!Q48)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!Q61,Inputs!Q63)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!Q77,Inputs!Q79)/1000,0)))","v":4649.1620166620914},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!R46,Inputs!R48)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!R61,Inputs!R63)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!R77,Inputs!R79)/1000,0)))","v":4562.8149121723382},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!S46,Inputs!S48)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!S61,Inputs!S63)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!S77,Inputs!S79)/1000,0)))","v":3742.2930259849186},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!T46,Inputs!T48)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!T61,Inputs!T63)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!T77,Inputs!T79)/1000,0)))","v":3334.6856586354465},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!U46,Inputs!U48)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!U61,Inputs!U63)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!U77,Inputs!U79)/1000,0)))","v":3092.0605400497807},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!V46,Inputs!V48)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!V61,Inputs!V63)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!V77,Inputs!V79)/1000,0)))","v":3083.0669716268658},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!W46,Inputs!W48)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!W61,Inputs!W63)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!W77,Inputs!W79)/1000,0)))","v":2899.9971606168647},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!X46,Inputs!X48)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!X61,Inputs!X63)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!X77,Inputs!X79)/1000,0)))","v":3173.7979877321213},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!Y46,Inputs!Y48)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!Y61,Inputs!Y63)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!Y77,Inputs!Y79)/1000,0)))","v":3232.5088952380888},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!Z46,Inputs!Z48)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!Z61,Inputs!Z63)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!Z77,Inputs!Z79)/1000,0)))","v":3430.0278051484233},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AA46,Inputs!AA48)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AA61,Inputs!AA63)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AA77,Inputs!AA79)/1000,0)))","v":4159.366410479056},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AB46,Inputs!AB48)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AB61,Inputs!AB63)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AB77,Inputs!AB79)/1000,0)))","v":4378.5442797089318},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AC46,Inputs!AC48)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AC61,Inputs!AC63)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AC77,Inputs!AC79)/1000,0)))","v":4046.7306722119656},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AD46,Inputs!AD48)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AD61,Inputs!AD63)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AD77,Inputs!AD79)/1000,0)))","v":3414.1488055068248},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AE46,Inputs!AE48)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AE61,Inputs!AE63)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AE77,Inputs!AE79)/1000,0)))","v":4003.3603327908713},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AF46,Inputs!AF48)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AF61,Inputs!AF63)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AF77,Inputs!AF79)/1000,0)))","v":4285.79634241452},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AG46,Inputs!AG48)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AG61,Inputs!AG63)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AG77,Inputs!AG79)/1000,0)))","v":5073.7580044747929},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AH46,Inputs!AH48)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AH61,Inputs!AH63)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AH77,Inputs!AH79)/1000,0)))","v":5397.7085545524878},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AI46,Inputs!AI48)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AI61,Inputs!AI63)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AI77,Inputs!AI79)/1000,0)))","v":5759.8107871987886},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AJ46,Inputs!AJ48)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AJ61,Inputs!AJ63)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AJ77,Inputs!AJ79)/1000,0)))","v":6219.3178942742779},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AK46,Inputs!AK48)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AK61,Inputs!AK63)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AK77,Inputs!AK79)/1000,0)))","v":5359.6188955574944},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AL46,Inputs!AL48)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AL61,Inputs!AL63)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AL77,Inputs!AL79)/1000,0)))","v":5263.6821786058063},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AM46,Inputs!AM48)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AM61,Inputs!AM63)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AM77,Inputs!AM79)/1000,0)))","v":5263.6821786058063}]
["Other 40 yrs - TMA",null,null,null,{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!E49:E51)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!E64:E66)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!E80:E82)/1000,0)))","v":3083.1247885339872},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!F49:F51)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!F64:F66)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!F80:F82)/1000,0)))","v":2771.021300516074},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!G49:G51)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!G64:G66)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!G80:G82)/1000,0)))","v":100.70473384570026},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!H49:H51)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!H64:H66)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!H80:H82)/1000,0)))","v":100.10050544262604},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!I49:I51)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!I64:I66)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!I80:I82)/1000,0)))","v":3038.3653914350948},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!J51)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!J66)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!J82)/1000,0)))","v":1101.1747064449287},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!K51)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!K66)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!K82)/1000,0)))","v":1083.6188490834411},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!L51)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!L66)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!L82)/1000,0)))","v":920.44027876740449},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!M51)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!M66)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!M82)/1000,0)))","v":1022.5724294297369},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!N51)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!N66)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!N82)/1000,0)))","v":895.81100808534006},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!O51)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!O66)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!O82)/1000,0)))","v":873.62144585697263},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!P51)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!P66)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!P82)/1000,0)))","v":525.72615638033301},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!Q51)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!Q66)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!Q82)/1000,0)))","v":480.84534513101687},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!R51)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!R66)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!R82)/1000,0)))","v":704.87454296007843},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!S51)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!S66)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!S82)/1000,0)))","v":547.53916243224751},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!T51)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!T66)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!T82)/1000,0)))","v":440.35766701940008},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!U51)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!U66)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!U82)/1000,0)))","v":427.09710164831085},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!V51)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!V66)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!V82)/1000,0)))","v":404.99615936316155},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!W51)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!W66)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!W82)/1000,0)))","v":382.895217078011},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!X51)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!X66)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!X82)/1000,0)))","v":360.79427479286187},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!Y51)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!Y66)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!Y82)/1000,0)))","v":338.69333250771308},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!Z51)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!Z66)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!Z82)/1000,0)))","v":316.592390222566},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AA51)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AA66)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AA82)/1000,0)))","v":294.4914479374159},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AB51)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AB66)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AB82)/1000,0)))","v":290.80795755655771},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AC51)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AC66)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AC82)/1000,0)))","v":287.12446717569969},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AD51)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AD66)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AD82)/1000,0)))","v":274.08097151986516},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AE51)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AE66)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AE82)/1000,0)))","v":270.39748113900714},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AF51)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AF66)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AF82)/1000,0)))","v":266.71399075814861},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AG51)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AG66)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AG82)/1000,0)))","v":263.03050037729082},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AH51)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AH66)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AH82)/1000,0)))","v":259.34700999643309},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AI51)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AI66)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AI82)/1000,0)))","v":255.66351961557447},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AJ51)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AJ66)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AJ82)/1000,0)))","v":251.98002923471623},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AK51)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AK66)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AK82)/1000,0)))","v":248.29653885385812},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AL51)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AL66)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AL82)/1000,0)))","v":244.61304847299994},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AM51)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AM66)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AM82)/1000,0)))","v":244.61304847299994}]
["Other 5 yrs",null,null,null,null,null,null,null,null,{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!J49)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!J64)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!J80)/1000,0)))","v":235.46618796963446},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!K49)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!K64)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!K80)/1000,0)))","v":233.02117278525208},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!L49)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!L64)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!L80)/1000,0)))","v":231.15144882850257},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!M49)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!M64)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!M80)/1000,0)))","v":229.75573756582315},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!N49)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!N64)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!N80)/1000,0)))","v":228.36845372135227},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!O49)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!O64)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!O80)/1000,0)))","v":226.98954640965275},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!P49)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!P64)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!P80)/1000,0)))","v":238.75368388349517},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!Q49)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!Q64)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!Q80)/1000,0)))","v":238.75368388349517},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!R49)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!R64)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!R80)/1000,0)))","v":238.75368388349517},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!S49)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!S64)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!S80)/1000,0)))","v":238.75368388349517},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!T49)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!T64)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!T80)/1000,0)))","v":238.75368388349517},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!U49)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!U64)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!U80)/1000,0)))","v":238.75368388349517},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!V49)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!V64)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!V80)/1000,0)))","v":238.75368388349517},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!W49)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!W64)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!W80)/1000,0)))","v":238.75368388349517},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!X49)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!X64)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!X80)/1000,0)))","v":238.75368388349517},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!Y49)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!Y64)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!Y80)/1000,0)))","v":238.75368388349517},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!Z49)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!Z64)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!Z80)/1000,0)))","v":238.75368388349517},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AA49)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AA64)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AA80)/1000,0)))","v":238.75368388349517},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AB49)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AB64)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AB80)/1000,0)))","v":238.75368388349517},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AC49)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AC64)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AC80)/1000,0)))","v":238.75368388349517},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AD49)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AD64)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AD80)/1000,0)))","v":238.75368388349517},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AE49)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AE64)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AE80)/1000,0)))","v":238.75368388349517},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AF49)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AF64)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AF80)/1000,0)))","v":238.75368388349517},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AG49)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AG64)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AG80)/1000,0)))","v":238.75368388349517},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AH49)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AH64)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AH80)/1000,0)))","v":238.75368388349517},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AI49)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AI64)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AI80)/1000,0)))","v":238.75368388349517},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AJ49)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AJ64)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AJ80)/1000,0)))","v":238.75368388349517},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AK49)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AK64)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AK80)/1000,0)))","v":238.75368388349517},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AL49)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AL64)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AL80)/1000,0)))","v":238.75368388349517},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,SUM(Inputs!AM49)/1000,IF(Inputs!$B$128=Inputs!$B$130,SUM(Inputs!AM64)/1000,IF(Inputs!$B$128=Inputs!$B$131,SUM(Inputs!AM80)/1000,0)))","v":238.75368388349517}]
["Total Capex",null,null,null,{"$f":"SUM(E11:E14)","v":13093.510367567547},{"$f":"SUM(F11:F14)","v":13757.976408111474},{"$f":"SUM(G11:G14)","v":12735.283150148303},11630.969913594601,13528.638635261905,{"$f":"SUM(J11:J15)","v":11811.07227505865},{"$f":"SUM(K11:K15)","v":13823.016063823712},14303.384313391625,15865.99143226167,14648.218912648521,15008.393789328424,11629.233586653007,10285.435276655679,12663.409348285604,10112.198276292045,8525.594459401249,8137.1031217336031,7884.9991881740452,7458.8190120273894,7489.5094740060058,7305.1100163753363,7259.5185611490524,7745.7468013430334,7924.40627638347,7552.0742746970664,6776.0139557777447,7317.8683354801051,7682.4195654311252,8320.7898647110505,8585.0510557545713,9006.6551473494474,9338.0726794085604,8437.8552865023375,8301.4001753612083,8301.4001753612083]
[]
["Basis of depreciation","FE","PNGL"]
[null,null,"FE"]
["Annual depreciation of additional capex"]
["Mains (40 years straight line)",{"$f":"IF(B18=C18,40,40)","v":40},null,null,{"$f":"E11/$B$21","v":50.534722194922068},{"$f":"F11/$B$21","v":56.683376736800767},{"$f":"G11/$B$21","v":70.847979923400231},71.047087918021845,{"$f":"I11/$B$21","v":62.230590096284779},{"$f":"J11/$B$21-SUM('PDP Workings - DD UPDATED'!$B$14:C14)/1000+IF(DAV!J6='PDP Workings - DD UPDATED'!$H$45,SUM('PDP Workings - DD UPDATED'!B14:C14)/1000,0)-SUM('PDP Workings - DD UPDATED'!B40:C40)/1000+IF(J6='PDP Workings - DD UPDATED'!$H$45,'PDP Workings - DD UPDATED'!C49/1000,0)","v":162.94314438538692},{"$f":"K11/$B$21-'PDP Workings - DD UPDATED'!D14/1000+IF(DAV!K6='PDP Workings - DD UPDATED'!$H$45,SUM('PDP Workings - DD UPDATED'!B14:D14)/1000,0)+IF(K6='PDP Workings - DD UPDATED'!$H$45,'PDP Workings - DD UPDATED'!C49/1000,0)-'PDP Workings - DD UPDATED'!D40/1000+IF(K6='PDP Workings - DD UPDATED'!$H$45,'PDP Workings - DD UPDATED'!D49/1000,0)","v":120.30324252411967},{"$f":"L11/$B$21-'PDP Workings - DD UPDATED'!E14/1000+IF(DAV!L6='PDP Workings - DD UPDATED'!$H$45,SUM('PDP Workings - DD UPDATED'!B14:E14)/1000,0)-'PDP Workings - DD UPDATED'!E40/1000+IF(L6='PDP Workings - DD UPDATED'!$H$45,'PDP Workings - DD UPDATED'!E49/1000,0)","v":86.807810103230196},{"$f":"M11/$B$21-'PDP Workings - DD UPDATED'!F14/1000+IF(DAV!M6='PDP Workings - DD UPDATED'!$H$45,SUM('PDP Workings - DD UPDATED'!B14:F14)/1000,0)-'PDP Workings - DD UPDATED'!F40/1000+IF(M6='PDP Workings - DD UPDATED'!$H$45,'PDP Workings - DD UPDATED'!F49/1000,0)","v":-75.360041257003559},{"$f":"N11/$B$21-'PDP Workings - DD UPDATED'!G14/1000+IF(DAV!N6='PDP Workings - DD UPDATED'!$H$45,SUM('PDP Workings - DD UPDATED'!B14:G14)/1000,0)-'PDP Workings - DD UPDATED'!G40/1000+IF(N6='PDP Workings - DD UPDATED'!$H$45,'PDP Workings - DD UPDATED'!G49/1000,0)","v":82.503447952230729},{"$f":"O11/$B$21-'PDP Workings - DD UPDATED'!H14/1000+IF(DAV!O6='PDP Workings - DD UPDATED'!$H$45,SUM('PDP Workings - DD UPDATED'!B14:H14)/1000,0)-'PDP Workings - DD UPDATED'!H40/1000+IF(O6='PDP Workings - DD UPDATED'!$H$45,'PDP Workings - DD UPDATED'!H49/1000,0)","v":81.253882495808071},{"$f":"P11/$B$21-'PDP Workings - DD UPDATED'!I14/1000+IF(DAV!P6='PDP Workings - DD UPDATED'!$H$45,SUM('PDP Workings - DD UPDATED'!B14:I14)/1000,0)-'PDP Workings - DD UPDATED'!I40/1000+IF(P6='PDP Workings - DD UPDATED'!$H$45,'PDP Workings - DD UPDATED'!I49/1000,0)","v":26.645379366581391},{"$f":"Q11/$B$21","v":26.645379366581391},85.262866700753548,49.941437357977932,26.645379366581391,26.645379366581391,26.645379366581391,26.645379366581391,26.645379366581391,26.645379366581391,26.645379366581391,26.645379366581391,26.645379366581391,26.645379366581391,26.645379366581391,26.474410531775181,29.540250894695571,26.81342667992276,26.334152558804313,28.834658887254797,26.645379366581391,26.645379366581391,26.645379366581391,26.645379366581391]
["Services (35 or 40 years straight line)",{"$f":"IF(B18=C18,35,40)","v":40},null,null,{"$f":"E12/$B$22","v":140.75690696150679},{"$f":"F12/$B$22","v":156.71889559348926},178.52522326756974,156.53135813471172,142.76464887998912,156.07992782404961,153.07516333220559,148.72432202218437,147.84999969794197,143.73944861015477,138.67639250804947,107.49167922022454,96.27147640789552,93.661288530988784,89.64887274180667,86.149556879991323,82.83441553721903,77.309179965931691,71.783944394644067,66.258708823356784,60.733473252069572,55.20823768078283,49.683002109495284,48.762129514280744,47.841256919066254,44.580383005107613,43.659510409893116,42.738637814678469,41.817765219464029,40.896892624249588,39.976020029034935,39.055147433820387,38.13427483860584,37.213402243391293,37.213402243391293]
["Meters (15 years straight line)",{"$f":"IF(B18=C18,15,15)","v":15},null,null,{"$f":"E13/$B$23","v":157.24802751842702},{"$f":"F13/$B$23","v":163.39094762558662},177.31001924425371,161.84877106950887,152.69757898505708,210.94654264857454,237.15245544209867,248.70048671860891,285.15521708247394,298.2882392230938,340.7047864604998,366.61809352779602,309.94413444413942,304.1876608114892,249.48620173232791,222.31237724236311,206.13736933665206,205.53779810845771,193.33314404112431,211.58653251547474,215.5005930158726,228.66852034322821,277.29109403193706,291.90295198059545,269.78204481413104,227.60992036712165,266.89068885272474,285.71975616096802,338.25053363165284,359.84723697016585,383.98738581325256,414.62119295161853,357.30792637049962,350.91214524038708,350.91214524038708]
["Other (40 years straight line)",{"$f":"IF(B18=C18,40,40)","v":40},null,null,{"$f":"E14/$B$24","v":77.078119713349679},{"$f":"F14/$B$24","v":69.275532512901847},2.5176183461425063,2.5025126360656511,75.959134785877367,27.529367661123217,27.090471227086027,23.011006969185111,25.564310735743422,22.395275202133501,21.840536146424316,13.143153909508325,12.021133628275422,17.62186357400196,13.688479060806188,11.008941675485001,10.677427541207772,10.124903984079038,9.572380426950275,9.0198568698215471,8.4673333126928263,7.9148097555641499,7.3622861984353971,7.2701989389139428,7.178111679392492,6.8520242879966293,6.7599370284751785,6.6678497689537153,6.5757625094322707,6.483675249910827,6.391587990389362,6.2995007308679059,6.2074134713464533,6.115326211824998,6.115326211824998]
["Other (5 years straight line)",{"$f":"IF(B18=C18,40,5)","v":5},null,null,{"$f":"E15/$B$25","v":0},{"$f":"F15/$B$25","v":0},0,0,0,{"$f":"J15/$B$25","v":47.093237593926894},46.604234557050418,46.230289765700512,45.951147513164628,45.673690744270452,45.397909281930552,47.750736776699036,47.750736776699036,47.750736776699036,47.750736776699036,47.750736776699036,47.750736776699036,47.750736776699036,47.750736776699036,47.750736776699036,47.750736776699036,47.750736776699036,47.750736776699036,47.750736776699036,47.750736776699036,47.750736776699036,47.750736776699036,47.750736776699036,47.750736776699036,{"$f":"AH15/$B$25","v":47.750736776699036},47.750736776699036,47.750736776699036,47.750736776699036,47.750736776699036,47.750736776699036]
[]
["Depreciation",null,null,null,{"$f":"B28","v":34},{"$f":"E27-1","v":33},{"$f":"F27-1","v":32},31,30,29,28,27,26,25,24,23,22,21,20,19,18,17,16,15,14,13,12,11,10,9,8,7,6,5,4,3,2,1,0]
["Distribution asset (average life remaining)",34,null,null,{"$f":"IF(E27>0,$D$37/$E$27,0)","v":12067.916248743692},{"$f":"IF(F27>0,$D$37/$E$27,0)","v":12067.916248743692},{"$f":"IF(G27>0,$D$37/$E$27,0)","v":12067.916248743692},12067.916248743692,12067.916248743692,{"$f":"IF(J27>0,$D$37/$E$27,0)","v":12067.916248743692},12067.916248743692,12067.916248743692,{"$f":"IF(M27>0,$D$37/$E$27,0)","v":12067.916248743692},12067.916248743692,12067.916248743692,12067.916248743692,12067.916248743692,12067.916248743692,12067.916248743692,12067.916248743692,12067.916248743692,12067.916248743692,12067.916248743692,12067.916248743692,12067.916248743692,12067.916248743692,12067.916248743692,12067.916248743692,12067.916248743692,12067.916248743692,12067.916248743692,12067.916248743692,12067.916248743692,12067.916248743692,12067.916248743692,12067.916248743692,12067.916248743692,12067.916248743692,{"$f":"IF(AM27>0,($D$37-$E$28-$F$28)/$G$27,0)","v":0}]
["Total Allowed Capex Overspend (average life remaining)",null,null,null,null,null,{"$f":"'Opening Values'!$E$25/'Opening Values'!$E$26","v":16.067871755578388},{"$f":"'Opening Values'!$E$25/'Opening Values'!$E$26+'Opening Values'!$F$25/'Opening Values'!$F$26","v":40.829874415820285},{"$f":"'Opening Values'!$E$25/'Opening Values'!$E$26+'Opening Values'!$F$25/'Opening Values'!$F$26+'Opening Values'!$G$25/'Opening Values'!$G$26","v":56.656004878828959},{"$f":"'Opening Values'!$E$25/'Opening Values'!$E$26+'Opening Values'!$F$25/'Opening Values'!$F$26+'Opening Values'!$G$25/'Opening Values'!$G$26","v":56.656004878828959},{"$f":"'Opening Values'!$E$25/'Opening Values'!$E$26+'Opening Values'!$F$25/'Opening Values'!$F$26+'Opening Values'!$G$25/'Opening Values'!$G$26","v":56.656004878828959},{"$f":"'Opening Values'!$E$25/'Opening Values'!$E$26+'Opening Values'!$F$25/'Opening Values'!$F$26+'Opening Values'!$G$25/'Opening Values'!$G$26+'Opening Values'!$J$25/'Opening Values'!$J$26","v":64.234719456104585},{"$f":"'Opening Values'!$E$25/'Opening Values'!$E$26+'Opening Values'!$F$25/'Opening Values'!$F$26+'Opening Values'!$G$25/'Opening Values'!$G$26+'Opening Values'!$J$25/'Opening Values'!$J$26+'Opening Values'!$K$25/'Opening Values'!$K$26","v":96.07564828200654},{"$f":"'Opening Values'!$E$25/'Opening Values'!$E$26+'Opening Values'!$F$25/'Opening Values'!$F$26+'Opening Values'!$G$25/'Opening Values'!$G$26+'Opening Values'!$J$25/'Opening Values'!$J$26+'Opening Values'!$K$25/'Opening Values'!$K$26+'Opening Values'!$L$25/'Opening Values'!$L$26","v":146.59933106065631},{"$f":"'Opening Values'!$E$25/'Opening Values'!$E$26+'Opening Values'!$F$25/'Opening Values'!$F$26+'Opening Values'!$G$25/'Opening Values'!$G$26+'Opening Values'!$J$25/'Opening Values'!$J$26+'Opening Values'!$K$25/'Opening Values'!$K$26+'Opening Values'!$L$25/'Opening Values'!$L$26","v":146.59933106065631},{"$f":"'Opening Values'!$E$25/'Opening Values'!$E$26+'Opening Values'!$F$25/'Opening Values'!$F$26+'Opening Values'!$G$25/'Opening Values'!$G$26+'Opening Values'!$J$25/'Opening Values'!$J$26+'Opening Values'!$K$25/'Opening Values'!$K$26+'Opening Values'!$L$25/'Opening Values'!$L$26","v":146.59933106065631},{"$f":"'Opening Values'!$E$25/'Opening Values'!$E$26+'Opening Values'!$F$25/'Opening Values'!$F$26+'Opening Values'!$G$25/'Opening Values'!$G$26+'Opening Values'!$J$25/'Opening Values'!$J$26+'Opening Values'!$K$25/'Opening Values'!$K$26+'Opening Values'!$L$25/'Opening Values'!$L$26","v":146.59933106065631},{"$f":"'Opening Values'!$E$25/'Opening Values'!$E$26+'Opening Values'!$F$25/'Opening Values'!$F$26+'Opening Values'!$G$25/'Opening Values'!$G$26+'Opening Values'!$J$25/'Opening Values'!$J$26+'Opening Values'!$K$25/'Opening Values'!$K$26+'Opening Values'!$L$25/'Opening Values'!$L$26","v":146.59933106065631},{"$f":"'Opening Values'!$E$25/'Opening Values'!$E$26+'Opening Values'!$F$25/'Opening Values'!$F$26+'Opening Values'!$G$25/'Opening Values'!$G$26+'Opening Values'!$J$25/'Opening Values'!$J$26+'Opening Values'!$K$25/'Opening Values'!$K$26+'Opening Values'!$L$25/'Opening Values'!$L$26","v":146.59933106065631},{"$f":"'Opening Values'!$E$25/'Opening Values'!$E$26+'Opening Values'!$F$25/'Opening Values'!$F$26+'Opening Values'!$G$25/'Opening Values'!$G$26+'Opening Values'!$J$25/'Opening Values'!$J$26+'Opening Values'!$K$25/'Opening Values'!$K$26+'Opening Values'!$L$25/'Opening Values'!$L$26","v":146.59933106065631},{"$f":"'Opening Values'!$E$25/'Opening Values'!$E$26+'Opening Values'!$F$25/'Opening Values'!$F$26+'Opening Values'!$G$25/'Opening Values'!$G$26+'Opening Values'!$J$25/'Opening Values'!$J$26+'Opening Values'!$K$25/'Opening Values'!$K$26+'Opening Values'!$L$25/'Opening Values'!$L$26","v":146.59933106065631},{"$f":"'Opening Values'!$E$25/'Opening Values'!$E$26+'Opening Values'!$F$25/'Opening Values'!$F$26+'Opening Values'!$G$25/'Opening Values'!$G$26+'Opening Values'!$J$25/'Opening Values'!$J$26+'Opening Values'!$K$25/'Opening Values'!$K$26+'Opening Values'!$L$25/'Opening Values'!$L$26","v":146.59933106065631},{"$f":"'Opening Values'!$E$25/'Opening Values'!$E$26+'Opening Values'!$F$25/'Opening Values'!$F$26+'Opening Values'!$G$25/'Opening Values'!$G$26+'Opening Values'!$J$25/'Opening Values'!$J$26+'Opening Values'!$K$25/'Opening Values'!$K$26+'Opening Values'!$L$25/'Opening Values'!$L$26","v":146.59933106065631},{"$f":"'Opening Values'!$E$25/'Opening Values'!$E$26+'Opening Values'!$F$25/'Opening Values'!$F$26+'Opening Values'!$G$25/'Opening Values'!$G$26+'Opening Values'!$J$25/'Opening Values'!$J$26+'Opening Values'!$K$25/'Opening Values'!$K$26+'Opening Values'!$L$25/'Opening Values'!$L$26","v":146.59933106065631},{"$f":"'Opening Values'!$E$25/'Opening Values'!$E$26+'Opening Values'!$F$25/'Opening Values'!$F$26+'Opening Values'!$G$25/'Opening Values'!$G$26+'Opening Values'!$J$25/'Opening Values'!$J$26+'Opening Values'!$K$25/'Opening Values'!$K$26+'Opening Values'!$L$25/'Opening Values'!$L$26","v":146.59933106065631},{"$f":"'Opening Values'!$E$25/'Opening Values'!$E$26+'Opening Values'!$F$25/'Opening Values'!$F$26+'Opening Values'!$G$25/'Opening Values'!$G$26+'Opening Values'!$J$25/'Opening Values'!$J$26+'Opening Values'!$K$25/'Opening Values'!$K$26+'Opening Values'!$L$25/'Opening Values'!$L$26","v":146.59933106065631},{"$f":"'Opening Values'!$E$25/'Opening Values'!$E$26+'Opening Values'!$F$25/'Opening Values'!$F$26+'Opening Values'!$G$25/'Opening Values'!$G$26+'Opening Values'!$K$25/'Opening Values'!$K$26+'Opening Values'!$L$25/'Opening Values'!$L$26","v":139.02061648338068},{"$f":"'Opening Values'!$E$25/'Opening Values'!$E$26+'Opening Values'!$F$25/'Opening Values'!$F$26+'Opening Values'!$G$25/'Opening Values'!$G$26+'Opening Values'!$K$25/'Opening Values'!$K$26+'Opening Values'!$L$25/'Opening Values'!$L$26","v":139.02061648338068},{"$f":"'Opening Values'!$E$25/'Opening Values'!$E$26+'Opening Values'!$F$25/'Opening Values'!$F$26+'Opening Values'!$G$25/'Opening Values'!$G$26+'Opening Values'!$K$25/'Opening Values'!$K$26+'Opening Values'!$L$25/'Opening Values'!$L$26","v":139.02061648338068},{"$f":"'Opening Values'!$E$25/'Opening Values'!$E$26+'Opening Values'!$F$25/'Opening Values'!$F$26+'Opening Values'!$G$25/'Opening Values'!$G$26+'Opening Values'!$K$25/'Opening Values'!$K$26+'Opening Values'!$L$25/'Opening Values'!$L$26","v":139.02061648338068},{"$f":"'Opening Values'!$F$25/'Opening Values'!$F$26+'Opening Values'!$K$25/'Opening Values'!$K$26+'Opening Values'!$L$25/'Opening Values'!$L$26","v":107.1266142647936},{"$f":"'Opening Values'!$F$25/'Opening Values'!$F$26+'Opening Values'!$K$25/'Opening Values'!$K$26+'Opening Values'!$L$25/'Opening Values'!$L$26","v":107.1266142647936},{"$f":"'Opening Values'!$K$25/'Opening Values'!$K$26+'Opening Values'!$L$25/'Opening Values'!$L$26","v":82.364611604551712},{"$f":"'Opening Values'!$K$25/'Opening Values'!$K$26+'Opening Values'!$L$25/'Opening Values'!$L$26","v":82.364611604551712},{"$f":"'Opening Values'!$K$25/'Opening Values'!$K$26+'Opening Values'!$L$25/'Opening Values'!$L$26","v":82.364611604551712},{"$f":"'Opening Values'!$K$25/'Opening Values'!$K$26+'Opening Values'!$L$25/'Opening Values'!$L$26","v":82.364611604551712},{"$f":"'Opening Values'!$L$25/'Opening Values'!$L$26","v":50.523682778649764},{"$f":"'Opening Values'!$L$25/'Opening Values'!$L$26","v":50.523682778649764},{"$f":"'Opening Values'!$L$25/'Opening Values'!$L$26","v":50.523682778649764}]
["Mains (40 years straight line)",null,null,null,{"$f":"IF($B$18=$C$18,SUM($E$21:E$21),SUM($E$21:E$21))","v":50.534722194922068},{"$f":"IF($B$18=$C$18,SUM($E$21:F$21),SUM($E$21:F$21))","v":107.21809893172284},{"$f":"IF($B$18=$C$18,SUM($E$21:G$21),SUM($E$21:G$21))","v":178.06607885512307},{"$f":"IF($B$18=$C$18,SUM($E$21:H$21),SUM($E$21:H$21))","v":249.11316677314491},{"$f":"IF($B$18=$C$18,SUM($E$21:I$21),SUM($E$21:I$21))","v":311.34375686942968},{"$f":"IF($B$18=$C$18,SUM($E$21:J$21),SUM($E$21:J$21))","v":474.2869012548166},{"$f":"IF($B$18=$C$18,SUM($E$21:K$21),SUM($E$21:K$21))","v":594.59014377893629},{"$f":"IF($B$18=$C$18,SUM($E$21:L$21),SUM($E$21:L$21))","v":681.39795388216646},{"$f":"IF($B$18=$C$18,SUM($E$21:M$21),SUM($E$21:M$21))","v":606.0379126251629},{"$f":"IF($B$18=$C$18,SUM($E$21:N$21),SUM($E$21:N$21))","v":688.54136057739368},{"$f":"IF($B$18=$C$18,SUM($E$21:O$21),SUM($E$21:O$21))","v":769.79524307320173},{"$f":"IF($B$18=$C$18,SUM($E$21:P$21),SUM($E$21:P$21))","v":796.44062243978317},{"$f":"IF($B$18=$C$18,SUM($E$21:Q$21),SUM($E$21:Q$21))","v":823.08600180636461},{"$f":"IF($B$18=$C$18,SUM($E$21:R$21),SUM($E$21:R$21))","v":908.34886850711814},{"$f":"IF($B$18=$C$18,SUM($E$21:S$21),SUM($E$21:S$21))","v":958.29030586509612},{"$f":"IF($B$18=$C$18,SUM($E$21:T$21),SUM($E$21:T$21))","v":984.93568523167755},{"$f":"IF($B$18=$C$18,SUM($E$21:U$21),SUM($E$21:U$21))","v":1011.581064598259},{"$f":"IF($B$18=$C$18,SUM($E$21:V$21),SUM($E$21:V$21))","v":1038.2264439648404},{"$f":"IF($B$18=$C$18,SUM($E$21:W$21),SUM($E$21:W$21))","v":1064.8718233314219},{"$f":"IF($B$18=$C$18,SUM($E$21:X$21),SUM($E$21:X$21))","v":1091.5172026980033},{"$f":"IF($B$18=$C$18,SUM($E$21:Y$21),SUM($E$21:Y$21))","v":1118.1625820645847},{"$f":"IF($B$18=$C$18,SUM($E$21:Z$21),SUM($E$21:Z$21))","v":1144.8079614311662},{"$f":"IF($B$18=$C$18,SUM($E$21:AA$21),SUM($E$21:AA$21))","v":1171.4533407977476},{"$f":"IF($B$18=$C$18,SUM($E$21:AB$21),SUM($E$21:AB$21))","v":1198.0987201643291},{"$f":"IF($B$18=$C$18,SUM($E$21:AC$21),SUM($E$21:AC$21))","v":1224.7440995309105},{"$f":"IF($B$18=$C$18,SUM($E$21:AD$21),SUM($E$21:AD$21))","v":1251.3894788974919},{"$f":"IF($B$18=$C$18,SUM($E$21:AE$21),SUM($E$21:AE$21))","v":1277.8638894292671},{"$f":"IF($B$18=$C$18,SUM($E$21:AF$21),SUM($E$21:AF$21))","v":1307.4041403239628},{"$f":"IF($B$18=$C$18,SUM($E$21:AG$21),SUM($E$21:AG$21))","v":1334.2175670038855},{"$f":"IF($B$18=$C$18,SUM($E$21:AH$21),SUM($E$21:AH$21))","v":1360.5517195626899},{"$f":"IF($B$18=$C$18,SUM($E$21:AI$21),SUM($E$21:AI$21))","v":1389.3863784499447},{"$f":"IF($B$18=$C$18,SUM($E$21:AJ$21),SUM($E$21:AJ$21))","v":1416.0317578165261},{"$f":"IF($B$18=$C$18,SUM($E$21:AK$21),SUM($E$21:AK$21))","v":1442.6771371831076},{"$f":"IF($B$18=$C$18,SUM($E$21:AL$21),SUM($E$21:AL$21))","v":1469.322516549689},{"$f":"IF($B$18=$C$18,SUM($E$21:AM$21),SUM($E$21:AM$21))","v":1495.9678959162704}]
["Services (35 or 40 years straight line)",null,null,null,{"$f":"IF($B$18=$C$18,SUM($E$22:E22),SUM($E$22:E22))","v":140.75690696150679},{"$f":"IF($B$18=$C$18,SUM($E$22:F22),SUM($E$22:F22))","v":297.47580255499605},{"$f":"IF($B$18=$C$18,SUM($E$22:G22),SUM($E$22:G22))","v":476.00102582256579},{"$f":"IF($B$18=$C$18,SUM($E$22:H22),SUM($E$22:H22))","v":632.53238395727749},{"$f":"IF($B$18=$C$18,SUM($E$22:I22),SUM($E$22:I22))","v":775.29703283726667},{"$f":"IF($B$18=$C$18,SUM($E$22:J22),SUM($E$22:J22))","v":931.37696066131628},{"$f":"IF($B$18=$C$18,SUM($E$22:K22),SUM($E$22:K22))","v":1084.4521239935218},{"$f":"IF($B$18=$C$18,SUM($E$22:L22),SUM($E$22:L22))","v":1233.1764460157062},{"$f":"IF($B$18=$C$18,SUM($E$22:M22),SUM($E$22:M22))","v":1381.0264457136482},{"$f":"IF($B$18=$C$18,SUM($E$22:N22),SUM($E$22:N22))","v":1524.765894323803},{"$f":"IF($B$18=$C$18,SUM($E$22:O22),SUM($E$22:O22))","v":1663.4422868318525},{"$f":"IF($B$18=$C$18,SUM($E$22:P22),SUM($E$22:P22))","v":1770.933966052077},{"$f":"IF($B$18=$C$18,SUM($E$22:Q22),SUM($E$22:Q22))","v":1867.2054424599726},{"$f":"IF($B$18=$C$18,SUM($E$22:R22),SUM($E$22:R22))","v":1960.8667309909613},{"$f":"IF($B$18=$C$18,SUM($E$22:S22),SUM($E$22:S22))","v":2050.5156037327679},{"$f":"IF($B$18=$C$18,SUM($E$22:T22),SUM($E$22:T22))","v":2136.6651606127593},{"$f":"IF($B$18=$C$18,SUM($E$22:U22),SUM($E$22:U22))","v":2219.4995761499786},{"$f":"IF($B$18=$C$18,SUM($E$22:V22),SUM($E$22:V22))","v":2296.8087561159105},{"$f":"IF($B$18=$C$18,SUM($E$22:W22),SUM($E$22:W22))","v":2368.5927005105546},{"$f":"IF($B$18=$C$18,SUM($E$22:X22),SUM($E$22:X22))","v":2434.8514093339113},{"$f":"IF($B$18=$C$18,SUM($E$22:Y22),SUM($E$22:Y22))","v":2495.5848825859807},{"$f":"IF($B$18=$C$18,SUM($E$22:Z22),SUM($E$22:Z22))","v":2550.7931202667637},{"$f":"IF($B$18=$C$18,SUM($E$22:AA22),SUM($E$22:AA22))","v":2600.4761223762589},{"$f":"IF($B$18=$C$18,SUM($E$22:AB22),SUM($E$22:AB22))","v":2649.2382518905397},{"$f":"IF($B$18=$C$18,SUM($E$22:AC22),SUM($E$22:AC22))","v":2697.0795088096061},{"$f":"IF($B$18=$C$18,SUM($E$22:AD22),SUM($E$22:AD22))","v":2741.6598918147138},{"$f":"IF($B$18=$C$18,SUM($E$22:AE22),SUM($E$22:AE22))","v":2785.3194022246071},{"$f":"IF($B$18=$C$18,SUM($E$22:AF22),SUM($E$22:AF22))","v":2828.0580400392855},{"$f":"IF($B$18=$C$18,SUM($E$22:AG22),SUM($E$22:AG22))","v":2869.8758052587496},{"$f":"IF($B$18=$C$18,SUM($E$22:AH22),SUM($E$22:AH22))","v":2910.7726978829992},{"$f":"IF($B$18=$C$18,SUM($E$22:AI22),SUM($E$22:AI22))","v":2950.748717912034},{"$f":"IF($B$18=$C$18,SUM($E$22:AJ22),SUM($E$22:AJ22))","v":2989.8038653458543},{"$f":"IF($B$18=$C$18,SUM($E$22:AK22),SUM($E$22:AK22))","v":3027.9381401844603},{"$f":"IF($B$18=$C$18,SUM($E$22:AL22),SUM($E$22:AL22))","v":3065.1515424278514},{"$f":"IF($B$18=$C$18,SUM($E$22:AM22),SUM($E$22:AM22))","v":3102.3649446712425}]
["Meters (15 years straight line)",null,null,null,{"$f":"IF($B$18=$C$18,SUM($E$23:E23),SUM($E$23:E23))","v":157.24802751842702},{"$f":"IF($B$18=$C$18,SUM($E$23:F23),SUM($E$23:F23))","v":320.63897514401367},{"$f":"IF($B$18=$C$18,SUM($E$23:G23),SUM($E$23:G23))","v":497.94899438826735},{"$f":"IF($B$18=$C$18,SUM($E$23:H23),SUM($E$23:H23))","v":659.79776545777622},{"$f":"IF($B$18=$C$18,SUM($E$23:I23),SUM($E$23:I23))","v":812.49534444283336},{"$f":"IF($B$18=$C$18,SUM($E$23:J23),SUM($E$23:J23))","v":1023.4418870914079},{"$f":"IF($B$18=$C$18,SUM($E$23:K23),SUM($E$23:K23))","v":1260.5943425335065},{"$f":"IF($B$18=$C$18,SUM($E$23:L23),SUM($E$23:L23))","v":1509.2948292521155},{"$f":"IF($B$18=$C$18,SUM($E$23:M23),SUM($E$23:M23))","v":1794.4500463345894},{"$f":"IF($B$18=$C$18,SUM($E$23:N23),SUM($E$23:N23))","v":2092.7382855576834},{"$f":"IF($B$18=$C$18,SUM($E$23:O23),SUM($E$23:O23))","v":2433.4430720181831},{"$f":"IF($B$18=$C$18,SUM($E$23:P23),SUM($E$23:P23))","v":2800.0611655459793},{"$f":"IF($B$18=$C$18,SUM($E$23:Q23),SUM($E$23:Q23))","v":3110.0052999901186},{"$f":"IF($B$18=$C$18,SUM($E$23:R23),SUM($E$23:R23))","v":3414.192960801608},{"$f":"IF($B$18=$C$18,SUM(E23:S23),SUM(E23:S23))","v":3663.6791625339361},{"$f":"IF($B$18=$C$18,SUM(F23:T23),SUM(F23:T23))","v":3728.7435122578722},{"$f":"IF($B$18=$C$18,SUM(G23:U23),SUM(G23:U23))","v":3771.4899339689377},{"$f":"IF($B$18=$C$18,SUM(H23:V23),SUM(H23:V23))","v":3799.7177128331409},3831.2020858047572,3890.0910393351742,3894.6450897024729,3886.1611546036015,3914.7517619169298,3921.4994968150513,3892.9933024060883,3779.8984363127097,3680.1710316376389,3655.9466533544683,3690.0095261746319,3800.3705614124692,3962.0455699833583,4170.5293935983245,4322.2995218603664,4479.8785230596295,{"$f":"IF($B$18=$C$18,SUM(Y23:AM23),SUM(Y23:AM23))","v":4619.2041357845419}]
["Other (40 years straight line)",null,null,null,{"$f":"IF($B$18=$C$18,SUM($E$24:E24),SUM($E$24:E24))","v":77.078119713349679},{"$f":"IF($B$18=$C$18,SUM($E$24:F24),SUM($E$24:F24))","v":146.35365222625154},{"$f":"IF($B$18=$C$18,SUM($E$24:G24),SUM($E$24:G24))","v":148.87127057239405},{"$f":"IF($B$18=$C$18,SUM($E$24:H24),SUM($E$24:H24))","v":151.37378320845971},{"$f":"IF($B$18=$C$18,SUM($E$24:I24),SUM($E$24:I24))","v":227.33291799433709},{"$f":"IF($B$18=$C$18,SUM($E$24:J24),SUM($E$24:J24))","v":254.86228565546031},{"$f":"IF($B$18=$C$18,SUM($E$24:K24),SUM($E$24:K24))","v":281.95275688254634},{"$f":"IF($B$18=$C$18,SUM($E$24:L24),SUM($E$24:L24))","v":304.96376385173147},{"$f":"IF($B$18=$C$18,SUM($E$24:M24),SUM($E$24:M24))","v":330.52807458747492},{"$f":"IF($B$18=$C$18,SUM($E$24:N24),SUM($E$24:N24))","v":352.92334978960844},{"$f":"IF($B$18=$C$18,SUM($E$24:O24),SUM($E$24:O24))","v":374.76388593603275},{"$f":"IF($B$18=$C$18,SUM($E$24:P24),SUM($E$24:P24))","v":387.90703984554108},{"$f":"IF($B$18=$C$18,SUM($E$24:Q24),SUM($E$24:Q24))","v":399.92817347381651},{"$f":"IF($B$18=$C$18,SUM($E$24:R24),SUM($E$24:R24))","v":417.55003704781848},{"$f":"IF($B$18=$C$18,SUM($E$24:S24),SUM($E$24:S24))","v":431.23851610862465},{"$f":"IF($B$18=$C$18,SUM($E$24:T24),SUM($E$24:T24))","v":442.24745778410966},{"$f":"IF($B$18=$C$18,SUM($E$24:U24),SUM($E$24:U24))","v":452.9248853253174},{"$f":"IF($B$18=$C$18,SUM($E$24:V24),SUM($E$24:V24))","v":463.04978930939643},{"$f":"IF($B$18=$C$18,SUM($E$24:W24),SUM($E$24:W24))","v":472.62216973634668},{"$f":"IF($B$18=$C$18,SUM($E$24:X24),SUM($E$24:X24))","v":481.6420266061682},{"$f":"IF($B$18=$C$18,SUM($E$24:Y24),SUM($E$24:Y24))","v":490.109359918861},{"$f":"IF($B$18=$C$18,SUM($E$24:Z24),SUM($E$24:Z24))","v":498.02416967442514},{"$f":"IF($B$18=$C$18,SUM($E$24:AA24),SUM($E$24:AA24))","v":505.38645587286055},{"$f":"IF($B$18=$C$18,SUM($E$24:AB24),SUM($E$24:AB24))","v":512.6566548117745},{"$f":"IF($B$18=$C$18,SUM($E$24:AC24),SUM($E$24:AC24))","v":519.83476649116699},{"$f":"IF($B$18=$C$18,SUM($E$24:AD24),SUM($E$24:AD24))","v":526.68679077916363},{"$f":"IF($B$18=$C$18,SUM($E$24:AE24),SUM($E$24:AE24))","v":533.44672780763881},{"$f":"IF($B$18=$C$18,SUM($E$24:AF24),SUM($E$24:AF24))","v":540.11457757659252},{"$f":"IF($B$18=$C$18,SUM($E$24:AG24),SUM($E$24:AG24))","v":546.69034008602478},{"$f":"IF($B$18=$C$18,SUM($E$24:AH24),SUM($E$24:AH24))","v":553.17401533593556},{"$f":"IF($B$18=$C$18,SUM($E$24:AI24),SUM($E$24:AI24))","v":559.56560332632489},{"$f":"IF($B$18=$C$18,SUM($E$24:AJ24),SUM($E$24:AJ24))","v":565.86510405719275},{"$f":"IF($B$18=$C$18,SUM($E$24:AK24),SUM($E$24:AK24))","v":572.07251752853915},{"$f":"IF($B$18=$C$18,SUM($E$24:AL24),SUM($E$24:AL24))","v":578.1878437403642},{"$f":"IF($B$18=$C$18,SUM($E$24:AM24),SUM($E$24:AM24))","v":584.30316995218925}]
["Other (5 years straight line)",null,null,null,{"$f":"IF($B$18=$C$18,SUM($E$25:E25),SUM($E$25:E25))","v":0},{"$f":"IF($B$18=$C$18,SUM($E$25:F25),SUM($E$25:F25))","v":0},{"$f":"IF($B$18=$C$18,SUM($E$25:G25),SUM($E$25:G25))","v":0},{"$f":"IF($B$18=$C$18,SUM($E$25:H25),SUM($E$25:H25))","v":0},{"$f":"IF($B$18=$C$18,SUM($E$25:I25),SUM(E25:I25))","v":0},{"$f":"IF($B$18=$C$18,SUM($E$25:J25),SUM(F25:J25))","v":47.093237593926894},{"$f":"IF($B$18=$C$18,SUM($E$25:K25),SUM(G25:K25))","v":93.697472150977319},{"$f":"IF($B$18=$C$18,SUM($E$25:L25),SUM(H25:L25))","v":139.92776191667784},{"$f":"IF($B$18=$C$18,SUM($E$25:M25),SUM(I25:M25))","v":185.87890942984245},{"$f":"IF($B$18=$C$18,SUM($E$25:N25),SUM(J25:N25))","v":231.55260017411291},{"$f":"IF($B$18=$C$18,SUM($E$25:O25),SUM(K25:O25))","v":229.85727186211653},{"$f":"IF($B$18=$C$18,SUM($E$25:P25),SUM(L25:P25))","v":231.00377408176516},{"$f":"IF($B$18=$C$18,SUM($E$25:Q25),SUM(M25:Q25))","v":232.5242210927637},{"$f":"IF($B$18=$C$18,SUM($E$25:R25),SUM(N25:R25))","v":234.32381035629808},{"$f":"IF($B$18=$C$18,SUM($E$25:S25),SUM(O25:S25))","v":236.40085638872668},{"$f":"IF($B$18=$C$18,SUM($E$25:T25),SUM(P25:T25))","v":238.75368388349517},{"$f":"IF($B$18=$C$18,SUM($E$25:U25),SUM(Q25:U25))","v":238.75368388349517},{"$f":"IF($B$18=$C$18,SUM($E$25:V25),SUM(R25:V25))","v":238.75368388349517},{"$f":"IF($B$18=$C$18,SUM($E$25:W25),SUM(S25:W25))","v":238.75368388349517},{"$f":"IF($B$18=$C$18,SUM($E$25:X25),SUM(T25:X25))","v":238.75368388349517},{"$f":"IF($B$18=$C$18,SUM($E$25:Y25),SUM(U25:Y25))","v":238.75368388349517},{"$f":"IF($B$18=$C$18,SUM($E$25:Z25),SUM(V25:Z25))","v":238.75368388349517},{"$f":"IF($B$18=$C$18,SUM($E$25:AA25),SUM(W25:AA25))","v":238.75368388349517},{"$f":"IF($B$18=$C$18,SUM($E$25:AB25),SUM(X25:AB25))","v":238.75368388349517},{"$f":"IF($B$18=$C$18,SUM($E$25:AC25),SUM(Y25:AC25))","v":238.75368388349517},{"$f":"IF($B$18=$C$18,SUM($E$25:AD25),SUM(Z25:AD25))","v":238.75368388349517},{"$f":"IF($B$18=$C$18,SUM($E$25:AE25),SUM(AA25:AE25))","v":238.75368388349517},{"$f":"IF($B$18=$C$18,SUM($E$25:AF25),SUM(AB25:AF25))","v":238.75368388349517},{"$f":"IF($B$18=$C$18,SUM($E$25:AG25),SUM(AC25:AG25))","v":238.75368388349517},{"$f":"IF($B$18=$C$18,SUM($E$25:AH25),SUM(AD25:AH25))","v":238.75368388349517},{"$f":"IF($B$18=$C$18,SUM($E$25:AI25),SUM(AE25:AI25))","v":238.75368388349517},{"$f":"IF($B$18=$C$18,SUM($E$25:AJ25),SUM(AF25:AJ25))","v":238.75368388349517},{"$f":"IF($B$18=$C$18,SUM($E$25:AK25),SUM(AG25:AK25))","v":238.75368388349517},{"$f":"IF($B$18=$C$18,SUM($E$25:AL25),SUM(AH25:AL25))","v":238.75368388349517},{"$f":"IF($B$18=$C$18,SUM($E$25:AM25),SUM(AI25:AM25))","v":238.75368388349517}]
["Total Depreciation",null,null,null,{"$f":"SUM(E28:E34)","v":12493.534025131896},{"$f":"SUM(F28:F34)","v":12939.602777600674},13384.871490137621,13801.563222556168,14251.041305766388,14855.63352587945,15439.85909296201,16000.911723118194,16461.913285716419,17105.03707022695,17685.817339525736,18200.862147769491,18647.264718627386,19149.797987508151,19554.640024433495,19745.861079574264,19908.764723730332,20051.071965911131,20190.558043070923,20351.370941661102,20451.771177959741,20533.055669663798,20637.758230074363,20727.183672792264,20780.342226348337,20745.325146914649,20690.597597991131,20745.31995818629,20829.82778275503,21013.903538425835,21250.780813903402,21531.264665049639,21722.180932162311,21949.734041183372,{"$f":"SUM(AM28:AM34)","v":10091.11751298639}]
[]
["Closing DAV",null,null,{"$f":"388965.431017349/rpi*rpi_14","v":410309.1524572855},{"$f":"E$8+E$16-E$35","v":410909.12879972113},{"$f":"F$8+F$16-F$35","v":411727.50243023189},411463.54301237647,409911.99976992095,409537.77196960268,411900.17097064567,{"$f":"K$8+K$16-K$35","v":412269.37496543687},410685.52827436943,403968.88551169913,402876.2067891442,400198.78323894687,393627.1546778304,385265.32523585868,378778.93659663608,369336.49484849465,358116.22822832165,346344.5666263249,334178.49384858779,321446.75481754425,308584.89334988914,295438.23218830471,282164.69507978996,269272.68365105864,256469.90625464986,243241.63830299856,229272.32711186167,215899.59784935066,202836.69745659549,190327.65953855152,177898.80705588026,165654.68138932632,153461.48940368523,140177.16375802527,126528.8298922031,{"$f":"AM$8+AM$16-AM$35","v":124739.11255457791}]

{"sheet":"Pi's Calc","index":3,"n_rows":72,"n_cols":33,"rows_kept":72,"cut":false,"hidden":false,"merged":[[23,0,23,32],[1,3,1,4],[0,0,1,2],[52,0,52,32],[58,0,58,32],[34,0,34,32],[38,0,38,32],[42,0,42,32],[50,0,50,32],[9,6,9,32]]}
["PNGL 'P' Tariff Model - Calculation of Pi tariffs, Allowed Revenues, PA and TRV"]
[null,null,null,"Return"]
[null,null,null,"GD17",{"$f":"IF(Inputs!B128=Inputs!B129,5.2%,IF(Inputs!B128=Inputs!B130,4.3%,IF(Inputs!B128=Inputs!B131,4.3%,0)))","v":4.2999999999999997E-2}]
["p","Sep £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":"E4","v":4.2999999999999997E-2},{"$f":"G6","v":4.2999999999999997E-2},{"$f":"H6","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,4.2999999999999997E-2,4.2999999999999997E-2,4.2999999999999997E-2,4.2999999999999997E-2,4.2999999999999997E-2,4.2999999999999997E-2,{"$f":"Y6","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]
["Discount Factor (Yr End)",null,1,{"$f":"C7/(1+D6)","v":0.95877277085330781},0.91924522612972948,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,0.28279436226870247]
[]
[]
[null,null,null,null,null,null,"IMPORTANT NOTE:  Values from 2017 Onwards are forecasts and will be determined as part of the Next Price Control.  This Model is re-run at each Price Control Period, to calculate allowed Revenues."]
[null,null,2016,2017,{"$f":"D11+1","v":2018},2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,{"$f":"X11+1","v":2038},{"$f":"Y11+1","v":2039},2040,2041,2042,2043,2044,2045,2046]
[]
["Capex",null,null,{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!J86/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!J87/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!J88/1000)))","v":11811.07227505865},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!K86/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!K87/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!K88/1000)))","v":13823.01606382371},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!L86/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!L87/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!L88/1000)))","v":14303.384313391623},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!M86/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!M87/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!M88/1000)))","v":15865.991432261668},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!N86/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!N87/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!N88/1000)))","v":14648.218912648521},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!O86/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!O87/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!O88/1000)))","v":15008.393789328426},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!P86/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!P87/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!P88/1000)))","v":11629.233586653007},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!Q86/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!Q87/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!Q88/1000)))","v":10285.43527665568},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!R86/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!R87/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!R88/1000)))","v":12663.409348285604},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!S86/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!S87/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!S88/1000)))","v":10112.198276292047},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!T86/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!T87/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!T88/1000)))","v":8525.5944594012526},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!U86/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!U87/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!U88/1000)))","v":8137.1031217336031},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!V86/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!V87/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!V88/1000)))","v":7884.9991881740461},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!W86/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!W87/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!W88/1000)))","v":7458.8190120273903},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!X86/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!X87/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!X88/1000)))","v":7489.5094740060058},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!Y86/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!Y87/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!Y88/1000)))","v":7305.1100163753354},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!Z86/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!Z87/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!Z88/1000)))","v":7259.5185611490533},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AA86/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AA87/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AA88/1000)))","v":7745.7468013430334},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AB86/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AB87/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AB88/1000)))","v":7924.40627638347},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AC86/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AC87/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AC88/1000)))","v":7552.0742746970673},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AD86/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AD87/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AD88/1000)))","v":6776.0139557777457},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AE86/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AE87/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AE88/1000)))","v":7317.8683354801042},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AF86/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AF87/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AF88/1000)))","v":7682.4195654311252},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AG86/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AG87/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AG88/1000)))","v":8320.7898647110505},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AH86/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AH87/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AH88/1000)))","v":8585.0510557545713},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AI86/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AI87/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AI88/1000)))","v":9006.6551473494474},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AJ86/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AJ87/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AJ88/1000)))","v":9338.0726794085622},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AK86/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AK87/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AK88/1000)))","v":8437.8552865023375},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AL86/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AL87/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AL88/1000)))","v":8301.4001753612083},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AM86/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AM87/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AM88/1000)))","v":8301.4001753612083}]
["Opex",null,null,{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!J91/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!J92/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!J93/1000)))","v":13894.88972135668},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!K91/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!K92/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!K93/1000)))","v":13786.172834186562},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!L91/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!L92/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!L93/1000)))","v":13665.909760566085},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!M91/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!M92/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!M93/1000)))","v":13587.442773876381},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!N91/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!N92/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!N93/1000)))","v":13515.050356994218},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!O91/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!O92/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!O93/1000)))","v":13551.326504218972},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!P91/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!P92/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!P93/1000)))","v":13552.403371397133},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!Q91/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!Q92/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!Q93/1000)))","v":13665.026776304687},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!R91/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!R92/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!R93/1000)))","v":13775.015197215285},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!S91/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!S92/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!S93/1000)))","v":13879.281259199714},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!T91/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!T92/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!T93/1000)))","v":13975.024807615366},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!U91/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!U92/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!U93/1000)))","v":14065.60309178034},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!V91/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!V92/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!V93/1000)))","v":14111.244022864737},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!W91/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!W92/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!W93/1000)))","v":14147.883370092984},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!X91/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!X92/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!X93/1000)))","v":14175.595994900532},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!Y91/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!Y92/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!Y93/1000)))","v":14194.548441280902},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!Z91/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!Z92/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!Z93/1000)))","v":14204.903135930841},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AA91/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AA92/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AA93/1000)))","v":14211.930149876038},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AB91/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AB92/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AB93/1000)))","v":14290.690462938586},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AC91/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AC92/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AC93/1000)))","v":14368.401079745565},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AD91/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AD92/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AD93/1000)))","v":14444.861374959242},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AE91/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AE92/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AE93/1000)))","v":14520.186785751301},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AF91/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AF92/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AF93/1000)))","v":14594.269280820639},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AG91/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AG92/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AG93/1000)))","v":14667.224039816612},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AH91/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AH92/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AH93/1000)))","v":14738.943229261169},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AI91/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AI92/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AI93/1000)))","v":14809.338968078775},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AJ91/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AJ92/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AJ93/1000)))","v":14878.415283828161},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AK91/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AK92/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AK93/1000)))","v":14946.378581136536},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AL91/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AL92/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AL93/1000)))","v":15014.561877432545},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AM91/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AM92/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AM93/1000)))","v":15098.622309670191}]
["Volumes (therms '000)",null,null,{"$f":"SUM(D16:D18)","v":149074.36541847681},{"$f":"SUM(E16:E18)","v":152969.86141962078},156757.75614694052,160525.72222162219,164164.50941045262,167676.02608345647,170767.7745870527,173175.87249443989,174965.20406518184,177508.324321975,179570.72761097958,181562.16600355477,183471.90439613,185277.14278870518,186977.88118128036,188572.21957385557,190060.15796643076,191441.69635900599,192764.33475158119,194075.57314415643,195310.07008406665,196531.26702397689,197739.16396388714,198933.7609037974,200115.05784370768,201283.0547836179,202435.85172352818,203854.29120979956,204978.5881497098,206104.19131844005]
["P Dom (P1)",null,null,{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!J97/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!J102/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!J107/1000)))","v":72721.410835386545},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!K97/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!K102/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!K107/1000)))","v":75996.052942239767},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!L97/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!L102/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!L107/1000)))","v":79142.388542365923},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!M97/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!M102/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!M107/1000)))","v":82215.054872507477},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!N97/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!N102/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!N107/1000)))","v":85206.819759196442},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!O97/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!O102/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!O107/1000)))","v":88071.802824888669},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!P97/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!P102/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!P107/1000)))","v":90569.587854725905},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!Q97/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!Q102/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!Q107/1000)))","v":92657.10214118415},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!R97/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!R102/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!R107/1000)))","v":94644.28551680941},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!S97/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!S102/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!S107/1000)))","v":96439.021652527503},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!T97/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!T102/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!T107/1000)))","v":98272.671023389819},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!U97/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!U102/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!U107/1000)))","v":100047.42039425213},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!V97/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!V102/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!V107/1000)))","v":101740.46976511444},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!W97/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!W102/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!W107/1000)))","v":103329.01913597676},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!X97/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!X102/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!X107/1000)))","v":104813.06850683907},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!Y97/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!Y102/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!Y107/1000)))","v":106190.71787770138},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!Z97/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!Z102/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!Z107/1000)))","v":107461.9672485637},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AA97/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AA102/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AA107/1000)))","v":108626.81661942601},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AB97/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AB102/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AB107/1000)))","v":109732.76599028832},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AC97/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AC102/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AC107/1000)))","v":110827.31536115064},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AD97/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AD102/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AD107/1000)))","v":111910.46473201294},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AE97/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AE102/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AE107/1000)))","v":112980.31410287526},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AF97/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AF102/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AF107/1000)))","v":114036.86347373758},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AG97/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AG102/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AG107/1000)))","v":115080.11284459989},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AH97/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AH102/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AH107/1000)))","v":116110.06221546221},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AI97/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AI102/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AI107/1000)))","v":117126.71158632453},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AJ97/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AJ102/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AJ107/1000)))","v":118128.16095718685},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AK97/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AK102/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AK107/1000)))","v":119395.25287441026},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AL97/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AL102/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AL107/1000)))","v":120368.20224527258},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AM97/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AM102/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AM107/1000)))","v":121342.4578449549}]
["P SME (P2)",null,null,{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!J98/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!J103/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!J108/1000)))","v":27987.562306938264},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!K98/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!K103/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!K108/1000)))","v":28483.416201229},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!L98/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!L103/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!L108/1000)))","v":28999.975328422603},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!M98/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!M103/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!M108/1000)))","v":29570.275072962715},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!N98/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!N103/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!N108/1000)))","v":30092.297375104165},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!O98/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!O103/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!O108/1000)))","v":30613.830982415791},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!P98/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!P103/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!P108/1000)))","v":31082.79445617479},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!Q98/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!Q103/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!Q108/1000)))","v":31278.37807710372},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!R98/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!R103/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!R108/1000)))","v":30955.526272220428},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!S98/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!S103/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!S108/1000)))","v":31703.910393295497},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!T98/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!T103/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!T108/1000)))","v":31932.664311437769},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!U98/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!U103/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!U108/1000)))","v":32149.353333150666},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!V98/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!V103/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!V108/1000)))","v":32366.042354863563},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!W98/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!W103/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!W108/1000)))","v":32582.731376576437},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!X98/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!X103/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!X108/1000)))","v":32799.420398289316},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!Y98/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!Y103/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!Y108/1000)))","v":33016.109420002205},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!Z98/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!Z103/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!Z108/1000)))","v":33232.798441715102},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AA98/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AA103/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AA108/1000)))","v":33449.487463427991},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AB98/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AB103/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AB108/1000)))","v":33666.176485140888},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AC98/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AC103/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AC108/1000)))","v":33882.865506853792},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AD98/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AD103/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AD108/1000)))","v":34034.213075901731},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AE98/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AE103/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AE108/1000)))","v":34185.560644949663},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AF98/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AF103/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AF108/1000)))","v":34336.908213997587},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AG98/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AG103/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AG108/1000)))","v":34488.255783045519},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AH98/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AH103/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AH108/1000)))","v":34639.603352093458},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AI98/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AI103/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AI108/1000)))","v":34790.950921141404},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AJ98/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AJ103/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AJ108/1000)))","v":34942.298490189343},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AK98/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AK103/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AK108/1000)))","v":35093.646059237282},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AL98/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AL103/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AL108/1000)))","v":35244.993628285214},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AM98/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AM103/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AM108/1000)))","v":35396.341197333153}]
["P Contract (P3 + P4)",null,null,{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!J99/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!J104/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!J109/1000)))","v":48365.392276152008},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!K99/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!K104/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!K109/1000)))","v":48490.392276152008},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!L99/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!L104/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!L109/1000)))","v":48615.392276152008},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!M99/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!M104/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!M109/1000)))","v":48740.392276152008},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!N99/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!N104/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!N109/1000)))","v":48865.392276152008},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!O99/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!O104/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!O109/1000)))","v":48990.392276152008},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!P99/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!P104/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!P109/1000)))","v":49115.392276152001},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!Q99/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!Q104/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!Q109/1000)))","v":49240.392276152001},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!R99/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!R104/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!R109/1000)))","v":49365.392276151993},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!S99/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!S104/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!S109/1000)))","v":49365.392276151993},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!T99/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!T104/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!T109/1000)))","v":49365.392276151993},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!U99/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!U104/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!U109/1000)))","v":49365.392276151993},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!V99/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!V104/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!V109/1000)))","v":49365.392276151993},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!W99/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!W104/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!W109/1000)))","v":49365.392276151993},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!X99/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!X104/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!X109/1000)))","v":49365.392276151993},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!Y99/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!Y104/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!Y109/1000)))","v":49365.392276151993},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!Z99/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!Z104/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!Z109/1000)))","v":49365.392276151993},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AA99/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AA104/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AA109/1000)))","v":49365.392276151993},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AB99/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AB104/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AB109/1000)))","v":49365.392276151993},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AC99/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AC104/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AC109/1000)))","v":49365.392276151993},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AD99/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AD104/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AD109/1000)))","v":49365.392276151993},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AE99/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AE104/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AE109/1000)))","v":49365.392276151993},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AF99/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AF104/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AF109/1000)))","v":49365.392276151993},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AG99/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AG104/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AG109/1000)))","v":49365.392276151993},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AH99/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AH104/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AH109/1000)))","v":49365.392276151993},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AI99/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AI104/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AI109/1000)))","v":49365.392276151993},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AJ99/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AJ104/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AJ109/1000)))","v":49365.392276151993},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AK99/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AK104/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AK109/1000)))","v":49365.392276152001},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AL99/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AL104/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AL109/1000)))","v":49365.392276152001},{"$f":"IF(Inputs!$B$128=Inputs!$B$129,Inputs!AM99/1000,IF(Inputs!$B$128=Inputs!$B$130,Inputs!AM104/1000,IF(Inputs!$B$128=Inputs!$B$131,Inputs!AM109/1000)))","v":49365.392276152001}]
["£/therm",null,null,0.34885826541834841]
["P Dom (P1)",null,1,0.36547915561408101,{"$f":"D20","v":0.36547915561408101},{"$f":"E20","v":0.36547915561408101},0.36547915561408101,0.36547915561408101,0.36547915561408101,0.36547915561408101,0.36547915561408101,0.36547915561408101,0.36547915561408101,0.36547915561408101,0.36547915561408101,0.36547915561408101,0.36547915561408101,0.36547915561408101,0.36547915561408101,0.36547915561408101,0.36547915561408101,0.36547915561408101,0.36547915561408101,0.36547915561408101,0.36547915561408101,0.36547915561408101,0.36547915561408101,0.36547915561408101,0.36547915561408101,0.36547915561408101,0.36547915561408101,0.36547915561408101,0.36547915561408101]
["P SME (P2)",null,0.9,{"$f":"$D$20*C21","v":0.32893124005267294},{"$f":"D21","v":0.32893124005267294},0.32893124005267294,0.32893124005267294,0.32893124005267294,0.32893124005267294,0.32893124005267294,0.32893124005267294,0.32893124005267294,0.32893124005267294,0.32893124005267294,0.32893124005267294,0.32893124005267294,0.32893124005267294,0.32893124005267294,0.32893124005267294,0.32893124005267294,0.32893124005267294,0.32893124005267294,0.32893124005267294,0.32893124005267294,0.32893124005267294,0.32893124005267294,0.32893124005267294,0.32893124005267294,0.32893124005267294,0.32893124005267294,0.32893124005267294,0.32893124005267294,0.32893124005267294]
["P Contract (P3 + P4)",null,0.68714186683686318,{"$f":"$D$20*C22","v":0.25113602927862005},{"$f":"D22","v":0.25113602927862005},0.25113602927862005,0.25113602927862005,0.25113602927862005,0.25113602927862005,0.25113602927862005,0.25113602927862005,0.25113602927862005,0.25113602927862005,0.25113602927862005,0.25113602927862005,0.25113602927862005,0.25113602927862005,0.25113602927862005,0.25113602927862005,0.25113602927862005,0.25113602927862005,0.25113602927862005,0.25113602927862005,0.25113602927862005,0.25113602927862005,0.25113602927862005,0.25113602927862005,0.25113602927862005,0.25113602927862005,0.25113602927862005,0.25113602927862005,0.25113602927862005,0.25113602927862005]
[]
["Conditions 2.3.15 and 2.3.16 Establishing Best Available Revenue Per Therm and Calculating Cashflow"]
[]
["Allowed Revenue",null,null,{"$f":"SUMPRODUCT(D16:D18,D20:D22)","v":47930.435973590065},{"$f":"SUMPRODUCT(E16:E18,E20:E22)","v":49321.74324573492},50672.967762075692,52014.944663732778,53311.473815154081,54561.506106693894,55660.043210927091,56518.71173630016,57170.181797600337,58072.287362013609,58817.692295730099,59537.601985837304,60227.652028930839,60879.509500262706,61493.174399832889,62067.952317245727,62603.843252501247,63100.847205599421,63576.324436431925,64047.635204890437,64493.286665923006,64934.077254185919,65370.006969679162,65801.075812402734,66227.283782356637,66648.630879540884,67064.422693559798,67577.301321117935,67982.676979201831,68388.530036691911]
["Capex",null,null,{"$f":"-D13","v":-11811.07227505865},-13823.01606382371,-14303.384313391623,-15865.991432261668,-14648.218912648521,-15008.393789328426,-11629.233586653007,-10285.43527665568,-12663.409348285604,-10112.198276292047,-8525.5944594012526,-8137.1031217336031,-7884.9991881740461,-7458.8190120273903,-7489.5094740060058,-7305.1100163753354,-7259.5185611490533,-7745.7468013430334,-7924.40627638347,-7552.0742746970673,-6776.0139557777457,-7317.8683354801042,{"$f":"-Z13","v":-7682.4195654311252},-8320.7898647110505,-8585.0510557545713,-9006.6551473494474,-9338.0726794085622,-8437.8552865023375,-8301.4001753612083,-8301.4001753612083]
["Opex",null,null,{"$f":"-D14","v":-13894.88972135668},-13786.172834186562,-13665.909760566085,-13587.442773876381,-13515.050356994218,-13551.326504218972,-13552.403371397133,-13665.026776304687,-13775.015197215285,-13879.281259199714,-13975.024807615366,-14065.60309178034,-14111.244022864737,-14147.883370092984,-14175.595994900532,-14194.548441280902,-14204.903135930841,-14211.930149876038,-14290.690462938586,-14368.401079745565,-14444.861374959242,-14520.186785751301,{"$f":"-Z14","v":-14594.269280820639},-14667.224039816612,-14738.943229261169,-14809.338968078775,-14878.415283828161,-14946.378581136536,-15014.561877432545,-15098.622309670191]
["Capex Creditor",null,null,{"$f":"-(Inputs!J119-Inputs!I119)/1000","v":-212.75897108918056},{"$f":"-(Inputs!K119-Inputs!J119)/1000","v":335.32396479417662},{"$f":"-(Inputs!L119-Inputs!K119)/1000","v":80.061374927985483},{"$f":"-(Inputs!M119-Inputs!L119)/1000","v":260.43451981167402},{"$f":"-(Inputs!N119-Inputs!M119)/1000","v":-202.96208660219145},{"$f":"-(Inputs!O119-Inputs!N119)/1000","v":60.029146113317459},{"$f":"-(Inputs!P119-Inputs!O119)/1000","v":-563.19336711256949},{"$f":"-(Inputs!Q119-Inputs!P119)/1000","v":-223.96638499955461},{"$f":"-(Inputs!R119-Inputs!Q119)/1000","v":396.32901193832049},{"$f":"-(Inputs!S119-Inputs!R119)/1000","v":-425.20184533225932},{"$f":"-(Inputs!T119-Inputs!S119)/1000","v":-264.43396948179884},{"$f":"-(Inputs!U119-Inputs!T119)/1000","v":-64.748556277940978},{"$f":"-(Inputs!V119-Inputs!U119)/1000","v":-42.017322259926239},{"$f":"-(Inputs!W119-Inputs!V119)/1000","v":-71.030029357776044},{"$f":"-(Inputs!X119-Inputs!W119)/1000","v":5.1150769964354117},{"$f":"-(Inputs!Y119-Inputs!X119)/1000","v":-30.733242938444949},{"$f":"-(Inputs!Z119-Inputs!Y119)/1000","v":-7.5985758710466325},{"$f":"-(Inputs!AA119-Inputs!Z119)/1000","v":81.038040032329974},{"$f":"-(Inputs!AB119-Inputs!AA119)/1000","v":29.776579173406585},{"$f":"-(Inputs!AC119-Inputs!AB119)/1000","v":-62.055333614400588},{"$f":"-(Inputs!AD119-Inputs!AC119)/1000","v":-129.34338648655358},{"$f":"-(Inputs!AE119-Inputs!AD119)/1000","v":90.309063283726573},{"$f":"-(Inputs!AF119-Inputs!AE119)/1000","v":60.758538325170058},{"$f":"-(Inputs!AG119-Inputs!AF119)/1000","v":106.39504987998772},{"$f":"-(Inputs!AH119-Inputs!AG119)/1000","v":44.043531840587036},{"$f":"-(Inputs!AI119-Inputs!AH119)/1000","v":70.267348599146118},{"$f":"-(Inputs!AJ119-Inputs!AI119)/1000","v":55.236255343185739},{"$f":"-(Inputs!AK119-Inputs!AJ119)/1000","v":-150.03623215103707},{"$f":"-(Inputs!AL119-Inputs!AK119)/1000","v":-22.742518523521721},{"$f":"-(Inputs!AM119-Inputs!AL119)/1000","v":0}]
["Working Capital Adjustment",null,null,{"$f":"-(Inputs!J117-Inputs!I117)/1000","v":103.97060031862883},{"$f":"-(Inputs!K117-Inputs!J117)/1000","v":-221.7421172821424},{"$f":"-(Inputs!L117-Inputs!K117)/1000","v":-217.11524628557311},{"$f":"-(Inputs!M117-Inputs!L117)/1000","v":-210.71257365132774},{"$f":"-(Inputs!N117-Inputs!M117)/1000","v":-203.16646273905457},{"$f":"-(Inputs!O117-Inputs!N117)/1000","v":-183.15170606400164},{"$f":"-(Inputs!P117-Inputs!O117)/1000","v":-164.65134157360018},{"$f":"-(Inputs!Q117-Inputs!P117)/1000","v":-115.28547021705424},{"$f":"-(Inputs!R117-Inputs!Q117)/1000","v":-84.521898685754749},{"$f":"-(Inputs!S117-Inputs!R117)/1000","v":-122.80390722385934},{"$f":"-(Inputs!T117-Inputs!S117)/1000","v":-100.32151424759533},{"$f":"-(Inputs!U117-Inputs!T117)/1000","v":-97.117059416283851},{"$f":"-(Inputs!V117-Inputs!U117)/1000","v":-98.030594733902717},{"$f":"-(Inputs!W117-Inputs!V117)/1000","v":-93.38189903239045},{"$f":"-(Inputs!X117-Inputs!W117)/1000","v":-88.724219958621774},{"$f":"-(Inputs!Y117-Inputs!X117)/1000","v":-83.942394046281237},{"$f":"-(Inputs!Z117-Inputs!Y117)/1000","v":-79.141076930335259},{"$f":"-(Inputs!AA117-Inputs!Z117)/1000","v":-73.707351291302587},{"$f":"-(Inputs!AB117-Inputs!AA117)/1000","v":-61.87034705736977},{"$f":"-(Inputs!AC117-Inputs!AB117)/1000","v":-61.371341251939533},{"$f":"-(Inputs!AD117-Inputs!AC117)/1000","v":-57.672483729243979},{"$f":"-(Inputs!AE117-Inputs!AD117)/1000","v":-57.079538944389903},{"$f":"-(Inputs!AF117-Inputs!AE117)/1000","v":-56.499557915665441},{"$f":"-(Inputs!AG117-Inputs!AF117)/1000","v":-55.905755329019158},{"$f":"-(Inputs!AH117-Inputs!AG117)/1000","v":-55.324892759738489},{"$f":"-(Inputs!AI117-Inputs!AH117)/1000","v":-54.754575919524299},{"$f":"-(Inputs!AJ117-Inputs!AI117)/1000","v":-54.079614212910997},{"$f":"-(Inputs!AK117-Inputs!AJ117)/1000","v":-68.776198456715449},{"$f":"-(Inputs!AL117-Inputs!AK117)/1000","v":-52.624353157063247},{"$f":"-(Inputs!AM117-Inputs!AL117)/1000","v":-50.79070675499446}]
["Allowed Capex Overspend",null,null,{"$f":"-'Opening Values'!H25","v":0},{"$f":"-'Opening Values'!I25","v":0},{"$f":"-'Opening Values'!J25","v":-113.68071865913447},{"$f":"-'Opening Values'!K25","v":-764.1822918216468},{"$f":"-'Opening Values'!L25","v":-1364.1394350235437}]
[]
["Cashflows",null,null,{"$f":"SUM(D26:D32)","v":22115.685606404182},{"$f":"SUM(E26:E32)","v":21826.136195236682},{"$f":"SUM(F26:F32)","v":22452.939098101258},21847.050111933433,23377.936561146562,25878.663253195813,29750.561544190783,32228.997828123178,31043.564365352013,33532.80207396573,35952.317544984086,37173.030156629138,38091.360900898231,39108.395189752162,39744.459787964159,40453.61822260476,41052.681902619974,41150.500943121369,41329.133929225914,42003.733175581467,43085.395464970228,43129.251657293855,43097.577103836898,42863.551202426046,42892.008136421748,42848.149536792283,42849.091371453353,43974.255022871301,44591.348054727496,44937.716844905517]
[]
[]
[]
["Discounted Cashflow",null,{"$f":"SUM(D37:AG37)","v":562856.40022126574},{"$f":"D33*D7","v":21203.917168172753},20063.571502328617,19788.837083903294,18461.014828723273,18940.203184057682,20101.848187316573,22156.696483636613,23012.952113892054,21252.636025006388,22010.34050663593,22625.568394281468,22429.328047578292,22035.884103302327,{"$f":"Q33*Q7","v":21691.504591611749},21135.473021067482,20625.687654040627,20068.194006535476,19286.684437815748,18571.819086891966,18096.79732225318,17797.52479154629,17081.151211599758,16364.915286134727,15605.034991275845,14971.615636943077,14339.699548356066,13748.815671882287,13528.132702730161,13152.419654779458,12708.132976966584]
[]
[]
[]
["Closing DAV",null,null,{"$f":"DAV!J37","v":411900.17097064567},{"$f":"DAV!K37","v":412269.37496543687},{"$f":"DAV!L37","v":410685.52827436943},{"$f":"DAV!M37","v":403968.88551169913},{"$f":"DAV!N37","v":402876.2067891442},{"$f":"DAV!O37","v":400198.78323894687},{"$f":"DAV!P37","v":393627.1546778304},{"$f":"DAV!Q37","v":385265.32523585868},{"$f":"DAV!R37","v":378778.93659663608},{"$f":"DAV!S37","v":369336.49484849465},{"$f":"DAV!T37","v":358116.22822832165},{"$f":"DAV!U37","v":346344.5666263249},{"$f":"DAV!V37","v":334178.49384858779},{"$f":"DAV!W37","v":321446.75481754425},{"$f":"DAV!X37","v":308584.89334988914},{"$f":"DAV!Y37","v":295438.23218830471},{"$f":"DAV!Z37","v":282164.69507978996},{"$f":"DAV!AA37","v":269272.68365105864},{"$f":"DAV!AB37","v":256469.90625464986},{"$f":"DAV!AC37","v":243241.63830299856},{"$f":"DAV!AD37","v":229272.32711186167},{"$f":"DAV!AE37","v":215899.59784935066},{"$f":"DAV!AF37","v":202836.69745659549},{"$f":"DAV!AG37","v":190327.65953855152},{"$f":"DAV!AH37","v":177898.80705588026},{"$f":"DAV!AI37","v":165654.68138932632},{"$f":"DAV!AJ37","v":153461.48940368523},{"$f":"DAV!AK37","v":140177.16375802527},{"$f":"DAV!AL37","v":126528.8298922031},{"$f":"DAV!AM37","v":124739.11255457791}]
[]
[]
[]
["TRV",null,{"$f":"-'Opening Values'!D20","v":-596320.28127117804}]
["Discounted DAV2046",null,{"$f":"AG41*AG7","v":35275.517784835756}]
["Discounted Capital Creditors (CC2046)",null,{"$f":"Inputs!AM119/1000*'Pi''s Calc'!AG7","v":-1591.5792051282094}]
["Discounted Working Capital Adjustment (Q2046)",null,{"$f":"Inputs!AM117/1000*'Pi''s Calc'!AG7","v":-220.05752979533077}]
["Backsolve to 0 by running Macro Ctrl + q",null,{"$f":"SUM(C37:C48)","v":-9.049472282640636E-11}]
[]
[]
[]
["Condition 2.3.18 Calculating TRV"]
[]
[null,"Total Regulatory Value (TRV)",null,null,null,null,null,null,{"$f":"I65+I67+I69+I71","v":615058.52869661315},null,null,null,null,{"$f":"N65+N67+N69+N71","v":582695.27350711008},null,null,null,null,{"$f":"S65+S67+S69+S71","v":507560.39846859104},null,null,null,null,{"$f":"X65+X67+X69+X71","v":399354.99958324723},null,null,null,null,{"$f":"AC65+AC67+AC69+AC71","v":258771.73757558753},null,null,null,{"$f":"AG65+AG67+AG69+AG71","v":118332.91435320716}]
[]
[]
[]
["Condition 2.3.19 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,null,"x"]
[null,"Adjusted Cashflows",null,{"$f":"D33*(1+$I$6)^($I$11-D11)","v":27297.441853631412},{"$f":"E33*(1+$I$6)^($I$11-E11)","v":25829.386717425488},25475.699860762354,23766.29161721667,24383.187833275861,25878.663253195813,{"$f":"J33*(1+$N$6)^($N$11-J11)","v":35207.27408239917},{"$f":"K33*(1+$N$6)^($N$11-K11)","v":36567.875229833975},{"$f":"L33*(1+$N$6)^($N$11-L11)","v":33770.71045128382},{"$f":"M33*(1+$N$6)^($N$11-M11)","v":34974.712563146255},{"$f":"N33*(1+$N$6)^($N$11-N11)","v":35952.317544984086},{"$f":"O33*(1+$S$6)^($S$11-O11)","v":43991.138091754307},{"$f":"P33*(1+$S$6)^($S$11-P11)","v":43219.467765862522},{"$f":"Q33*(1+$S$6)^($S$11-Q11)","v":42544.028598776691},{"$f":"R33*(1+$S$6)^($S$11-R11)","v":41453.471558846613},{"$f":"S33*(1+$S$6)^($S$11-S11)","v":40453.61822260476},{"$f":"T33*(1+$X$6)^($X$11-T11)","v":48582.377896168327},{"$f":"U33*(1+$X$6)^($X$11-U11)","v":46690.449146393992},{"$f":"V33*(1+$X$6)^($X$11-V11)","v":44959.857015774476},{"$f":"W33*(1+$X$6)^($X$11-W11)","v":43809.893702131463},{"$f":"X33*(1+$X$6)^($X$11-X11)","v":43085.395464970228},{"$f":"Y33*(1+$AC$6)^($AC$11-Y11)","v":51039.822620209161},{"$f":"Z33*(1+$AC$6)^($AC$11-Z11)","v":48899.653369489621},{"$f":"AA33*(1+$AC$6)^($AC$11-AA11)","v":46629.071312007967},{"$f":"AB33*(1+$AC$6)^($AC$11-AB11)","v":44736.364486287879},{"$f":"AC33*(1+$AC$6)^($AC$11-AC11)","v":42848.149536792283},{"$f":"AD33*(1+$AG$6)^($AG$11-AD11)","v":48617.714870915945},{"$f":"AE33*(1+$AG$6)^($AG$11-AE11)","v":47837.349352375517},{"$f":"AF33*(1+AG6)^(AG11-AF11)","v":46508.776021080776},{"$f":"AG33*(1+AG6)^(AG11-AG11)","v":44937.716844905517}]
[]
[null,"Closing TRV (Incl Return)",{"$f":"'Opening Values'!D20","v":596320.28127117804},null,null,null,null,null,{"$f":"-$C$63*(1+I6)^(I11-C11)","v":-767689.19983212079},null,null,null,null,{"$f":"-I55*(1+N6)^(N11-I11)","v":-759168.16337875742},null,null,null,null,{"$f":"-N55*(1+S6)^(S11-N11)","v":-719222.12270643597},null,null,null,null,{"$f":"-S55*(1+X6)^(X11-S11)","v":-626482.97280868574},null,null,null,null,{"$f":"-X55*(1+AC6)^(AC11-X11)","v":-492924.79890037444},null,null,null,{"$f":"-AC55*(1+AG6)^(AG11-AC11)","v":-306234.47144248494}]
[]
[null,"DAV",null,null,null,null,null,null,{"$f":"I41","v":400198.78323894687},null,null,null,null,{"$f":"N41","v":358116.22822832165},null,null,null,null,{"$f":"S41","v":295438.23218830471},null,null,null,null,{"$f":"X41","v":229272.32711186167},null,null,null,null,{"$f":"AC41","v":165654.68138932632},null,null,null,{"$f":"AG41","v":124739.11255457791}]
[]
[null,"CC",null,null,null,null,null,null,{"$f":"Inputs!O119/1000","v":-6745.8765919430234},null,null,null,null,{"$f":"Inputs!T119/1000","v":-5665.4100369551616},null,null,null,null,{"$f":"Inputs!Y119/1000","v":-5461.9959631175088},null,null,null,null,{"$f":"Inputs!AD119/1000","v":-5373.8132863512446},null,null,null,null,{"$f":"Inputs!AI119/1000","v":-5745.5868182798622},null,null,null,{"$f":"Inputs!AM119/1000","v":-5628.044322948489}]
[]
[null,"Q",null,null,null,null,null,null,{"$f":"Inputs!O117/1000","v":-2666.531971267782},null,null,null,null,{"$f":"Inputs!T117/1000","v":-2078.9478393199183},null,null,null,null,{"$f":"Inputs!Y117/1000","v":-1617.7516721324382},null,null,null,null,{"$f":"Inputs!AD117/1000","v":-1283.9890718722472},null,null,null,null,{"$f":"Inputs!AI117/1000","v":-1004.4247510039098},null,null,null,{"$f":"Inputs!AM117/1000","v":-778.15387842222572}]
[]
[null,"Calculated PA",null,null,null,null,null,null,{"$f":"-SUM(D61:I69)","v":224272.15402087709},null,null,null,null,{"$f":"-SUM(J61:N70)","v":232323.40315506351},null,null,null,null,{"$f":"-SUM(O61:S70)","v":219201.91391553628},null,null,null,null,{"$f":"-SUM(T61:X70)","v":176740.47482960907},null,null,null,null,{"$f":"-SUM(Y61:AC70)","v":99867.067755545009},null,null,null,{"$f":"-SUM(AD61:AG70)","v":-3.092281986027956E-11}]
[null,"Check",null,null,null,null,null,null,{"$f":"SUM(D61:I71)","v":0},null,null,null,null,{"$f":"SUM(J61:N71)","v":0},null,null,null,null,{"$f":"SUM(O61:S71)","v":0},null,null,null,null,{"$f":"SUM(T61:X71)","v":0},null,null,null,null,{"$f":"SUM(Y61:AC71)","v":0},null,null,null,{"$f":"SUM(AD61:AG71)","v":0}]

{"sheet":"PDP Workings - DD UPDATED","index":4,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Infill to be removed",7.4999999999999997E-2,4.2999999999999997E-2,{"$f":"C28","v":4.2999999999999997E-2},{"$f":"D28","v":4.2999999999999997E-2}]
[null,2016,{"$f":"B29+1","v":2017},{"$f":"C29+1","v":2018},2019,2020,2021,2022,2023]
["Total NPV post Bulk Removal"]
[-6626744.8692891514]
["Mains Per Model",1749175.8239281755,3701513.8235338153,3701513.8235338153,2308105.8394225002,2308105.8394225002,2308105.8394225002,2308105.8394225002,48818.257407350182]
["Mains to be removed to break even",{"$f":"B32","v":1749175.8239281755},{"$f":"C32","v":3701513.8235338153},1986047.0239294725]
["NPV at RoR",{"$f":"B33/(1+B28)","v":1627140.3013285354},{"$f":"C33/((1+B28)*(1+C28))","v":3301312.2464570585},{"$f":"D33/((1+B28)*(1+C28)*(1+D28))","v":1698292.3215035577}]
[{"$f":"SUM(B34:E34)","v":6626744.8692891523}]
[{"$f":"SUM(A35,A31)","v":0}]
["Infill to be Removed DAV",2016,{"$f":"B37+1","v":2017},{"$f":"C37+1","v":2018},2019,2020,2021,2022,2023]
["Op Bal",0,{"$f":"B42","v":1705446.4283299712},{"$f":"C42","v":5270693.0106772371},7070821.6178219235,6884903.2010371368,6698984.7842523502,6513066.3674675636,6327147.950682777]
["Infill",{"$f":"B33","v":1749175.8239281755},{"$f":"C33","v":3701513.8235338153},1986047.0239294725,0,0,0,0,0]
["Additions Depn",{"$f":"-B39/40","v":-43729.395598204384},{"$f":"-C39/40","v":-92537.845588345386},{"$f":"-D39/40","v":-49651.175598236812},0,0,0,0,0]
["Total Depn (40 yrs)",{"$f":"SUM($B$40:B40)","v":-43729.395598204384},{"$f":"SUM($B$40:C40)","v":-136267.24118654977},{"$f":"SUM($B$40:D40)","v":-185918.41678478659},{"$f":"SUM($B$40:E40)","v":-185918.41678478659},{"$f":"SUM($B$40:F40)","v":-185918.41678478659},{"$f":"SUM($B$40:G40)","v":-185918.41678478659},{"$f":"SUM($B$40:H40)","v":-185918.41678478659},{"$f":"SUM($B$40:I40)","v":-185918.41678478659}]
["Cl Bal",{"$f":"SUM(B38:B39,B41)","v":1705446.4283299712},{"$f":"SUM(C38:C39,C41)","v":5270693.0106772371},7070821.6178219235,6884903.2010371368,6698984.7842523502,6513066.3674675636,6327147.950682777,6141229.5338979904]
[]
[]
["Payment Received 31st Dec",null,2019,"Removal of infill from opening TRV in year",null,null,null,{"$f":"C45+1","v":2020}]
[]
[null,2016,{"$f":"B47+1","v":2017},{"$f":"C47+1","v":2018},2019,2020,2021,2022,2023]
["Infill Removal from DAV",null,{"$f":"C38","v":1705446.4283299712},5270693.0106772371,7070821.6178219235,6884903.2010371368,6698984.7842523502,6513066.3674675636,6327147.950682777]
["Depreciation Adjustment",null,{"$f":"SUM($B$40:C40)","v":-136267.24118654977},{"$f":"SUM($B$40:D40)","v":-185918.41678478659},{"$f":"SUM($B$40:E40)","v":-185918.41678478659},{"$f":"SUM($B$40:F40)","v":-185918.41678478659},{"$f":"SUM($B$40:G40)","v":-185918.41678478659},{"$f":"SUM($B$40:H40)","v":-185918.41678478659},{"$f":"SUM($B$40:I40)","v":-185918.41678478659}]
[null,null,{"$f":"SUM(C48:C49)","v":1569179.1871434213},{"$f":"SUM(D48:D49)","v":5084774.5938924504},6884903.2010371368,6698984.7842523502,6513066.3674675636,6327147.950682777,6141229.5338979904]