{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Inputs","Opening Values","DAV","PDP Workings - FD","Pi's Calc","PNGL Financeability","Building Block"],"not_rendered":{"charts":0,"images":17,"macros":1,"external_links":11,"defined_names":172,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Inputs","index":0,"n_rows":118,"n_cols":40,"rows_kept":118,"cut":false,"hidden":false,"merged":[[93,9,93,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)","GD17 Determination","GD17 Determination","GD17 Determination","GD17 Determination","GD17 Determination","GD17 Determination","GD17 Determination","GD17 Determination","GD17 Determination","GD17 Determination","GD17 Determination","GD17 Determination","GD17 Determination","GD17 Determination","GD17 Determination","GD17 Determination","GD17 Determination","GD17 Determination","GD17 Determination","GD17 Determination","GD17 Determination","GD17 Determination","GD17 Determination","GD17 Determination","GD17 Determination","GD17 Determination","GD17 Determination","GD17 Determination","GD17 Determination","GD17 Determination"]
[]
[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,99399.801904527674,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,99399.801904527674,{"$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,99399.801904527674,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 (enter as -ve)",null,"Mains",null,null,null,null,-1749175.8239281755,-3701513.8235338153,-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,0,0,0,1092524.7082946079,0,0,0,0,3055593.5126058259,1214369.4126974759,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AL71","v":0},"NOTE: 2046 = 2045 totals"]
["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,99841.295291135641,218757.89122065401,111511.3184829543,92305.412276045841,61431.627738487914,117658.63836096457,117658.63836096457,117658.63836096457,117658.63836096457,117658.63836096457,117658.63836096457,117658.63836096457,117658.63836096457,117658.63836096457,117658.63836096457,117658.63836096457,117658.63836096457,117658.63836096457,117658.63836096457,117658.63836096457,110819.88493307502,233453.49947338959,124380.53087288458,105209.56604823661,73595.71007324534,127096.49705302056,127096.49705302056,127096.49705302056,{"$f":"AL73","v":127096.49705302056}]
["LP","feeder mains",null,"Mains",86593.474201474179,77946.753473600489,0,0,0]
["LP","infill mains",null,"Mains",{"$f":"E14","v":1594618.8959868955},1790746.4358872746,2677085.586535506,2686660.1169516519,2917941.1726655257,1774277.2972175817,2689954.3910682495,5386118.5587406782,5263139.1363675324,4833492.8854805464,3725061.0171924261,958620.88909214677,958620.88909214677,958620.88909214677,958620.88909214677,958620.88909214677,958620.88909214677,958620.88909214677,958620.88909214677,958620.88909214677,958620.88909214677,958620.88909214677,958620.88909214677,958620.88909214677,958620.88909214677,958620.88909214677,958620.88909214677,958620.88909214677,958620.88909214677,958620.88909214677,958620.88909214677,958620.88909214677,958620.88909214677,958620.88909214677,958620.88909214677]
["domestic","services",null,"Services",5214018.0966420891,5927058.9853116218,6861021.573286267,5975399.5718921199,{"$f":"I15","v":5426732.1849776888},5062136.1462163003,4966358.4605120225,4883003.0694512222,4822276.6336756293,4750156.6480772365,4668718.6917908853,3454822.3007289413,3306081.4394091656,3175530.5464082425,3090012.3048218926,2912028.4600819489,2765653.1267423313,2552205.9357584049,2363859.397000453,2173804.4980959748,1984244.4186215426,1798845.3612214581,1613446.3038213735,1593582.119099936,1573717.9343784982,1553853.7496570607,1527368.170028477,1507503.9853070395,1481018.405678456,1461154.2209570184,1434668.6413284349,1408183.0616998516,1381697.4820712679,1361833.2973498304,1361833.2973498304]
["domestic","meters",null,"Meters",2137406.9909909908,2345905.626042081,2392522.9257593779,2158166.8973430181,2022785.9687571384,2236074.5226077791,2629006.971366433,2827064.7746718298,3347399.9661565255,3563867.1865066169,4236752.7488996768,4415732.5849713795,3948929.0338994064,3997987.410118931,3408080.4506693846,3586592.4813581803,2913906.469180638,2909546.0791931576,2853799.1430066372,3123846.0676636696,3240012.6376551865,3488831.9726481065,3075392.6710197404,3118169.2841425068,3151356.284803337,2934429.613917781,3499421.7661210774,3802656.9681737246,4551344.8453456871,4885713.7561984099,5286150.9454700146,5004610.4738840004,4530911.6572294785,4574798.5842620889,4574798.5842620889]
["Industrial/ commercial","services",null,"Services",416258.18181818287,341696.83842794865,279987.3574165235,285854.75349634915,283853.77022187604,524434.99993394909,539816.70647974894,600743.69410864986,676330.03106769058,723792.31988148438,751544.44609066716,456203.82937720581,406121.15976088046,380354.77732972865,346919.7325012135,317866.57035226159,299010.13838422822,285595.01974781847,284219.89063550171,288392.4822216598,289863.966667926,289863.96666794684,289863.96666793642,289863.96666793642,289863.96666793851,287613.61590051942,283552.80647591135,271731.86094943335,253708.06150709331,235496.49478606964,219882.22627870881,213425.75871023748,213425.75871023748,213425.75871023748,213425.75871023748]
["Industrial/ commercial","meters",null,"Meters",221313.42178541474,104958.58834171797,267127.36290442763,269564.66869961465,267677.71601871809,1034759.7254933818,1248693.0117931615,1301224.5383593009,1470221.550468182,1603314.957829807,1602439.6589005485,1461331.6623862598,1332625.4209807208,1243802.8279476876,1046323.0183221683,854289.1643750706,906488.17925047537,873516.78550328512,847452.09351390193,836220.77198786906,794833.95198859717,759676.26737543347,1090955.3288395263,1288073.1135647791,1144823.3261333026,1099409.6518389506,1323796.5313257771,1382988.6538966501,1557803.5521684343,1697631.331934029,1700601.8460787628,1561960.2521497514,1433254.0107442117,1344431.4177111788,1344431.4177111788]
["Other capex",null,null,"Other",201032.43243243246,28287.936482731246,100704.73384570026,100100.50544262605,99399.801904527674,237154.13293087311,235125.48055508622,233150.22704879052,231626.43227783547,230112.59653858878,228608.65474202772,238753.8900618045,238753.8900618045,238753.8900618045,238753.8900618045,238753.8900618045,238753.8900618045,238753.8900618045,238753.8900618045,238753.8900618045,238753.8900618045,238753.8900618045,238753.8900618045,238753.8900618045,238753.8900618045,238753.8900618045,238753.8900618045,238753.8900618045,238753.8900618045,238753.8900618045,238753.8900618045,238753.8900618045,238753.8900618045,238753.8900618045,238753.8900618045]
["Engineering Other (Mgt Fee)",null,null,"Other",2882092.3561015544,2742733.3640333428,0,0,0]
["TMA",null,null,"Other",0,0,0,0,976176.20053760987,736084.84433678328,819612.95580600202,1086986.5322300552,1185427.050940546,1030744.1853439265,914532.41550739796,486964.70191982941,467082.34882621933,757009.97254359466,560992.23391127295,418851.59195263585,402328.41542187065,379642.1844598371,360670.01767281012,342081.78694097814,323272.92743816157,304733.02169815521,286193.1159581457,284206.69748600188,282220.27901385835,280008.8254649727,276954.18655965355,273785.673534862,269334.73562776961,265527.1604835235,261317.17566992907,258022.97095022359,255374.41298736524,253387.99451522148,253387.99451522148]
["PDP REMOVAL OVER BULK MAINS","INFILL REMOVED AS PART OF PDP (enter as -ve)",null,"Mains",null,null,null,null,-584259.58708035096,-1137205.6299672034,-2301778.8766776514,-921698.72275290021]
[null,null,null,null,{"$f":"SUM(E71:E83)=SUM(E10:E21)","v":true},{"$f":"SUM(F71:F83)=SUM(F10:F21)","v":true},{"$f":"SUM(G71:G83)=SUM(G10:G21)","v":true},{"$f":"SUM(H71:H83)=SUM(H10:H21)","v":true},true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,{"$f":"ROUND(SUM(AM71:AM83),0)=ROUND(SUM(AL71:AL83),0)","v":true}]
["Capex"]
["Total Capex - UR Final Det - Sep £2014",null,null,null,{"$f":"SUM(E71:E83)","v":13093510.367567547},13757976.408111474,12735283.150148306,11630969.913594604,11410307.228002733,10467716.038769446,10926630.396194186,15615350.563078281,18200456.827731505,16827786.19193425,16189089.260862118,11590088.496898532,10775872.820391312,13925312.464468926,10981730.570438324,9404661.6856350135,8602419.746494459,8315539.4221774191,8025033.9593442194,8079379.024425067,7947261.3198863296,7956984.0071260156,7670884.8038216382,7888928.5984760756,7757015.2085118508,7470348.8742942,8219288.1245979229,8669495.4204890504,9434964.9103542771,9848107.3095612396,10173591.324053047,9770673.7936010361,9139134.5979495328,9072348.3287555296,9072348.3287555296]
[]
["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":"E89","v":18549942.268388364},{"$f":"F89","v":15795746.919990418},{"$f":"G89","v":14550551.970897809},{"$f":"H89","v":15898581.833370512},{"$f":"I89","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":"E89","v":18549942.268388364},{"$f":"F89","v":15795746.919990418},{"$f":"G89","v":14550551.970897809},{"$f":"H89","v":15898581.833370512},{"$f":"I89","v":16411036.009646954},14736830.280561412,14421528.100443158,14331291.412166817,14280968.553134473,14179296.5015049,14286369.017291397,14432599.76578846,14550302.627140457,14665328.427149208,14774125.588004295,14873445.655224593,14967418.337590815,15010181.888621863,15043271.453182774,15066778.788644534,15080897.445392126,15085815.796002124,15087137.726346185,15170925.195728902,15253570.548072373,15334861.461720439,15414915.855432393,15493624.499429822,15571105.024392074,15647248.412878675,15721957.091974394,15795235.780403448,15867303.622526553,15933477.732545011,16014827.805745712]
[]
["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.190561548,84247122.930693775,87728447.736934483,91397376.953424722,95063665.466860771,98701544.792494148,102208342.28825723,105284437.7274152,107824786.6444934,110600663.78120573,113633095.79813305,116657060.13247615,119681024.46681923,122704988.80116233,125728953.13550539,128752917.46984848,131776881.80419159,134800846.13853467,137824810.47287777,140450559.25240716,142241423.22686106,143634071.6465013,145026720.06614155,146419368.48578176,147812016.90542194,149204665.32506216,150597313.74470237,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(J95:J97)","v":150846744.84278205},{"$f":"SUM(K95:K97)","v":154662994.68484253},{"$f":"SUM(L95:L97)","v":158546738.71695584},162640201.2172859,166711157.0321368,170770395.7769334,174627672.99650061,177936739.24545917,180712615.81288564,183618655.87404862,186767743.49226949,189908363.42790616,193048983.36354282,196189603.29917946,199330223.2348161,202470843.17045274,205611463.10608944,208752083.04172608,211892702.97736275,214635107.35818574,216515739.17671636,217998155.44043335,219480571.70415035,220962987.96786729,222445404.23158422,223927820.49530119,225410236.75901815,227571711.12390983,229054127.38762683,230536543.65134382]
["GD17 Draft Det"]
["Domestic","P1",null,null,null,null,null,null,null,79098372.766256317,82716629.665472016,86266265.166919172,89817557.957761034,93301337.845176578,96681055.099017233,99723283.878809333,102186070.97639591,104016134.89678958,106693952.2291321,108893159.91684312,111010002.70812476,113035645.4994064,114947288.29068804,116744931.08196966,118428573.87325129,119998216.66453293,121453859.45581457,122843002.24709621,124213145.03837785,125525834.13421135,126819523.23004486,128094212.32587837,129349901.42171186,130586590.51754537,131804279.61337888,133002968.70921238,134463500.35140696,135624189.44724047,136721204.77189401]
["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) - UR Draft Det",null,null,null,null,null,null,null,null,{"$f":"SUM(J100:J102)","v":149120345.41847682},153132501.41962078,157084556.14694053,161060382.22162223,164948829.4104526,168749906.08345649,172142614.5870527,174838372.49443987,176903964.06518182,179711944.32197499,182027807.61097959,184261306.00355476,186403604.39613,188431902.7887052,190346201.18128037,192146499.57385555,193832797.96643078,195405096.35900599,196910894.75158119,198397693.14415643,199800150.08406666,201183607.02397689,202548063.96388716,203893520.90379739,205219977.84370765,206527434.78361791,207815891.72352818,209366191.20979953,210616648.14970976,211803431.31844008]
["GD17 Final Det"]
["Domestic/Very Small IC","P1",null,null,null,null,null,null,null,78884982.769431904,82121076.882275432,85375121.50775291,88664904.915517494,91966156.821927711,95217090.983929083,97358392.70488286,98897339.066560403,99750607.269552767,101408493.9308508,102550349.06418379,103556378.28693038,104435556.51408429,105186578.79657508,105819506.67178944,106335950.99857184,106738730.90147519,107030314.43589514,107251160.04519632,107440303.08293103,107597017.29341578,107719335.31384905,107804241.00387035,107849492.83043067,107855541.69381535,107824022.17341536,107757830.57047793,107889391.26296434,107759376.34260473,107152301.31878234]
["Small/Medium IC","P2",null,null,null,null,null,null,null,21631048.867182981,21884863.655830089,22162076.321401738,22466168.161214661,22788697.270781603,23123457.495438535,23191804.020806167,23151549.911907788,23099750.55533741,23047196.489951771,22969667.12464644,22883942.819060266,22791726.762216751,22697047.327968039,22601812.385246146,22505126.755033303,22406496.864798903,22305922.71454294,22203404.304265425,22098941.633966345,21991782.585684992,21881267.147158571,21765199.052984543,21642094.872551244,21512021.976921912,21375771.822067924,21236072.575210564,21094877.197618593,20952185.689292006,20807998.050230809]
["Large IC ","P3",null,null,null,null,null,null,null,29597833.398214757,29722833.398214757,29847833.398214754,29972833.398214754,30097833.398214754,30222833.398214754,30094934.786562961,29964952.841577832,29832887.563259378,29577905.618274257,29322923.673289131,29067941.728304006,28812959.783318885,28557977.838333763,28302995.893348642,28048013.948363516,27793032.003378395,27538050.058393274,27283068.113408152,27028086.168423027,26773104.223437902,26518122.27845278,26263140.333467659,26008158.388482533,25753176.443497412,25498194.49851229,25243212.553527165,24988230.60854204,24733248.663556919,24478266.718571797]
["Contract","P4",null,null,null,null,null,null,null,18767558.877937257,18767558.877937257,18767558.877937257,18767558.877937257,18767558.877937257,18767558.877937257,18611162.553954449,18454766.229971636,18298369.905988824,18141973.582006015,17985577.258023206,17829180.934040394,17672784.610057585,17516388.286074772,17359991.962091964,17203595.638109151,17047199.314126343,16890802.990143534,16734406.666160721,16578010.342177911,16421614.0181951,16265217.69421229,16108821.370229481,15952425.046246668,15796028.722263858,15639632.398281049,15483236.074298237,15326839.750315426,15170443.426332617,15014047.102349807]
["Total Volume (Therms) - UR Final Det",null,null,null,null,null,null,null,null,{"$f":"SUM(J105:J108)","v":148881423.9127669},152496332.81425753,156152590.10530666,159871465.35288417,163620246.36886132,167330940.75551963,169256294.06620643,170468608.05001768,170981615.29413837,172175569.62108284,172828517.12014255,173337443.76833504,173713027.66967753,173957992.24895167,174084306.91247618,174092687.34007782,173985459.08377883,173765090.19897491,173472039.12903064,173145341.22749829,172783518.12073377,172383942.4336727,171941401.76055205,171452171.13771114,170916768.83649856,170337620.89227661,169720351.77351391,169299338.81944039,168615254.12178627,167452613.18993479]
[]
["Q & CC Calcs"]
[null,null,null,null,"Opex",null,{"$f":"G91","v":14550551.970897809},{"$f":"H91","v":15898581.833370512},16411036.009646954,14736830.280561412,14421528.100443158,14331291.412166817,14280968.553134473,14179296.5015049,14286369.017291397,14432599.76578846,14550302.627140457,14665328.427149208,14774125.588004295,14873445.655224593,14967418.337590815,15010181.888621863,15043271.453182774,15066778.788644534,15080897.445392126,15085815.796002124,15087137.726346185,15170925.195728902,15253570.548072373,15334861.461720439,15414915.855432393,15493624.499429822,15571105.024392074,15647248.412878675,15721957.091974394,15795235.780403448,15867303.622526553,15933477.732545011,16014827.805745712]
[null,null,null,null,"Capex",null,12903134.23767028,12598408.350679506,13087626.101593731,{"$f":"J86","v":10467716.038769446},{"$f":"K86","v":10926630.396194186},15615350.563078281,18200456.827731505,16827786.19193425,16189089.260862118,11590088.496898532,10775872.820391312,13925312.464468926,10981730.570438324,9404661.6856350135,8602419.746494459,8315539.4221774191,8025033.9593442194,8079379.024425067,7947261.3198863296,7956984.0071260156,7670884.8038216382,7888928.5984760756,7757015.2085118508,7470348.8742942,8219288.1245979229,8669495.4204890504,9434964.9103542771,9848107.3095612396,10173591.324053047,9770673.7936010361,9139134.5979495328,9072348.3287555296,9072348.3287555296]
[null,null,null,null,"GD14/GD17 Allowed Revenue",null,47057.766288488849,48820.298209229746,50636.490339679811,{"$f":"'Pi''s Calc'!D28","v":51932.248149078878},{"$f":"'Pi''s Calc'!E28","v":53342.851746027525},{"$f":"'Pi''s Calc'!F28","v":54768.866529423976},{"$f":"'Pi''s Calc'!G28","v":56218.557962643237},{"$f":"'Pi''s Calc'!H28","v":57679.33590837018},{"$f":"'Pi''s Calc'!I28","v":59124.583696231093},{"$f":"'Pi''s Calc'!J28","v":59925.661661398801},{"$f":"'Pi''s Calc'!K28","v":60449.453891448022},{"$f":"'Pi''s Calc'!L28","v":60697.551358438628},{"$f":"'Pi''s Calc'!M28","v":61222.092496708035},{"$f":"'Pi''s Calc'!N28","v":61533.883964476539},{"$f":"'Pi''s Calc'!O28","v":61789.100658880823},{"$f":"'Pi''s Calc'!P28","v":61991.893906238976},{"$f":"'Pi''s Calc'!Q28","v":62143.180504470554},{"$f":"'Pi''s Calc'!R28","v":62247.61385029785},{"$f":"'Pi''s Calc'!S28","v":62305.512054386905},{"$f":"'Pi''s Calc'!T28","v":62317.813375682876},{"$f":"'Pi''s Calc'!U28","v":62285.492872507413},{"$f":"'Pi''s Calc'!V28","v":62224.534522348928},{"$f":"'Pi''s Calc'!W28","v":62150.360080483755},{"$f":"'Pi''s Calc'!X28","v":62062.415197670343},{"$f":"'Pi''s Calc'!Y28","v":61959.687948130988},{"$f":"'Pi''s Calc'!Z28","v":61840.205827140737},{"$f":"'Pi''s Calc'!AA28","v":61702.555813871491},{"$f":"'Pi''s Calc'!AB28","v":61546.940000918308},{"$f":"'Pi''s Calc'!AC28","v":61374.28557751677},{"$f":"'Pi''s Calc'!AD28","v":61186.70682869431},{"$f":"'Pi''s Calc'!AE28","v":61076.722403065498},{"$f":"'Pi''s Calc'!AF28","v":60862.864939679188},{"$f":"'Pi''s Calc'!AG28","v":60460.002659834099}]
[]
["Working Capital (£2014)",null,null,null,null,null,-3912000,{"$f":"G116-(H112-G112)*12%+(H114-G114)*1000*15%","v":-3809383.7953855898},{"$f":"H116-(I112-H112)*12%+(I114-H114)*1000*15%","v":-3598449.4769712528},{"$f":"I116-(J112-I112)*12%+(J114-I114)*1000*15%","v":-3203181.1180711277},{"$f":"J116-(K112-J112)*12%+(K114-J114)*1000*15%","v":-2953754.3169146404},{"$f":"K116-(L112-K112)*12%+(L114-K114)*1000*15%","v":-2729023.6968120118},-2505531.2387452414,-2274213.9006906515,-2070275.4344058943,-1967661.4294503857,-1903216.9383052422,-1879805.4142577015,-1814179.9028199008,-1779329.590721061,-1752323.8084443649,-1727036.4474643676,-1708314.2054769401,-1695470.0838582569,-1688479.5920546097,-1687224.5959334138,-1692231.3030510205,-1711429.5519007193,-1732473.1604617117,-1755419.8025214912,-1780435.4171978289,-1807802.7726260582,-1837747.9376119152,-1870227.5161732847,-1905090.7211750019,-1942020.9761098572,-1967166.7810089516,-2007186.2937191131,-2077377.6444799604]
[]
["Capital Creditors (£2014)",null,null,null,null,null,-6395000,{"$f":"G118-(H113-G113)*1/6","v":-6344212.3521682043},{"$f":"H118-(I113-H113)*1/6","v":-6425748.6439872421},{"$f":"I118-(J113-I113)*1/6","v":-5989096.9668498617},{"$f":"J118-(K113-J113)*1/6","v":-6065582.693087318},{"$f":"K118-(L113-K113)*1/6","v":-6847036.0542346667},-7277887.0983435372,-7049108.6590439947,-6942659.1705319723,-6176159.043204708,-6040456.4304535044,-6565363.0377997737,-6074766.0554613397,-5811921.2413274543,-5678214.2514706952,-5630400.8640845222,-5581983.2869456559,-5591040.7977924636,-5569021.1803693408,-5570641.6282426221,-5522958.4276918927,-5559299.0601342991,-5537313.4951402619,-5489535.7727706535,-5614358.9811546076,-5689393.5304697957,-5816971.7787806671,-5885828.8453151612,-5940076.1810637955,-5872923.2593217939,-5767666.7267132103,-5756535.6818475435,-5756535.6818475435]

{"sheet":"Opening Values","index":1,"n_rows":34,"n_cols":12,"rows_kept":34,"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],[26,1,27,1],[26,2,26,6],[25,2,25,11],[26,7,26,8],[26,9,26,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":407140.67554007727}]
[null,"PA",null,192305.89999026165]
[null,"Q & CC",null,-9870.1647926817459]
[null,"TRV UM Adjustments PNGL12",null,8159.0569182474856]
[null,"TRV UM Adjustments GD14",null,-1910.2314019334865]
[]
[null,"TRV",null,{"$f":"SUM(D14:D19)","v":595825.23625397123}]
[null,null,null,{"$f":"D20/rpi_14*F7","v":595593.93763741304}]
[null,"N.B. for GD14 this TRV of £503.6m is as per Final Document Paragraph 10.40:"]
[]
[null,"http://www.uregni.gov.uk/uploads/publications/2013-12-20_GD14_Price_Control_for_NI_GDNs_2014-2016_Final_Determination.pdf"]
[]
[null,"5-year Allowed Capex Overspend","£'000s"]
[null,"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.1394350235439]
[null,"remaining average life",0,0,24,25,22,0,0,15,24,27]
[]
[null,"For detail on the Rolling Capex Incentive please see Appendix 5 of:"]
[]
[null,"http://www.uregni.gov.uk/uploads/publications/PNGL12_Final_Decisions_FINAL.pdf"]

{"sheet":"DAV","index":2,"n_rows":37,"n_cols":39,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,2,1],[4,15,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,null,null,null,null,null,null,"IMPORTANT NOTE:  Total Capex and Breakdown from 2023 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'!C29","v":410309.1524572855},{"$f":"E37+'Opening Values'!D29","v":410889.02067015518},{"$f":"F37+'Opening Values'!E29","v":412050.52667957771},{"$f":"G37+'Opening Values'!F29","v":411951.98825954832},{"$f":"H37+'Opening Values'!G29","v":410039.20805163617},{"$f":"I37+'Opening Values'!H29+SUM('PDP Workings - FD'!B9:C9)/1000-IF(DAV!J6='PDP Workings - FD'!H15,SUM('PDP Workings - FD'!B9:I9)/1000,0)","v":426144.32157091511},{"$f":"J37+'Opening Values'!I29+'PDP Workings - FD'!D9/1000-IF(DAV!K6='PDP Workings - FD'!H15,SUM('PDP Workings - FD'!B9:I9)/1000,0)","v":430670.63562625262},{"$f":"K37+'Opening Values'!J29+'PDP Workings - FD'!E9/1000-IF(DAV!L6='PDP Workings - FD'!H15,SUM('PDP Workings - FD'!B9:I9)/1000,0)","v":427408.44253809383},{"$f":"L37+'Opening Values'!K29+'PDP Workings - FD'!F9/1000-IF(DAV!M6='PDP Workings - FD'!H15,SUM('PDP Workings - FD'!B9:I9)/1000,0)","v":399220.73449984129},{"$f":"M37+'Opening Values'!L29+'PDP Workings - FD'!G9/1000-IF(DAV!N6='PDP Workings - FD'!H15,SUM('PDP Workings - FD'!B9:I9)/1000,0)","v":402222.23080870678},{"$f":"N37+'Opening Values'!H29+'PDP Workings - FD'!H9/1000-IF(DAV!O6='PDP Workings - FD'!H15,SUM('PDP Workings - FD'!B9:I9)/1000,0)","v":401760.12974876619},{"$f":"O37+'Opening Values'!H29+'PDP Workings - FD'!I9/1000-IF(DAV!P6='PDP Workings - FD'!H15,SUM('PDP Workings - FD'!B9:I9)/1000,0)","v":400018.72915457987},{"$f":"P37","v":393148.94107238448},384980.32383886771,379399.14886692545,370418.48918069724,359601.79515999195,347777.97539100959,335485.03805928922,322714.56823255139,309790.12263653491,296590.7836588723,283289.7037710658,269625.92157589609,256126.51014220767,242472.70011142717,228572.63672960337,215444.73009853536,202692.2972878369,190595.09552679796,178693.45651540573,166873.87465938987,154394.16313831086,141095.94112085659,{"$f":"AL37","v":127510.2084722601}]
[]
["Capex"]
["Mains",null,null,null,{"$f":"SUM(Inputs!E71:E75,Inputs!E83)/1000","v":2021.3888877968827},{"$f":"SUM(Inputs!F71:F75,Inputs!F83)/1000","v":2267.3350694720307},{"$f":"SUM(Inputs!G71:G75,Inputs!G83)/1000","v":2833.9191969360095},{"$f":"SUM(Inputs!H71:H75,Inputs!H83)/1000","v":2841.883516720874},{"$f":"SUM(Inputs!I71:I75,Inputs!I83)/1000","v":2333.6815855851746},{"$f":"SUM(Inputs!J71:J75,Inputs!J83)/1000","v":637.07166725037825},{"$f":"SUM(Inputs!K71:K75,Inputs!K83)/1000","v":488.0168096817336},{"$f":"SUM(Inputs!L71:L75,Inputs!L83)/1000","v":4683.1777272084328},{"$f":"SUM(Inputs!M71:M75,Inputs!M83)/1000","v":6467.1751631450952},{"$f":"SUM(Inputs!N71:N75,Inputs!N83)/1000","v":4925.7982977565916},{"$f":"SUM(Inputs!O71:O75,Inputs!O83)/1000","v":3786.4926449309141},{"$f":"SUM(Inputs!P71:P75,Inputs!P83)/1000","v":1076.2795274531113},{"$f":"SUM(Inputs!Q71:Q75,Inputs!Q83)/1000","v":1076.2795274531113},{"$f":"SUM(Inputs!R71:R75,Inputs!R83)/1000","v":4131.8730400589375},{"$f":"SUM(Inputs!S71:S75,Inputs!S83)/1000","v":2290.6489401505874},{"$f":"SUM(Inputs!T71:T75,Inputs!T83)/1000","v":1076.2795274531113},{"$f":"SUM(Inputs!U71:U75,Inputs!U83)/1000","v":1076.2795274531113},{"$f":"SUM(Inputs!V71:V75,Inputs!V83)/1000","v":1076.2795274531113},{"$f":"SUM(Inputs!W71:W75,Inputs!W83)/1000","v":1076.2795274531113},{"$f":"SUM(Inputs!X71:X75,Inputs!X83)/1000","v":1076.2795274531113},{"$f":"SUM(Inputs!Y71:Y75,Inputs!Y83)/1000","v":1076.2795274531113},{"$f":"SUM(Inputs!Z71:Z75,Inputs!Z83)/1000","v":1076.2795274531113},{"$f":"SUM(Inputs!AA71:AA75,Inputs!AA83)/1000","v":1076.2795274531113},{"$f":"SUM(Inputs!AB71:AB75,Inputs!AB83)/1000","v":1076.2795274531113},{"$f":"SUM(Inputs!AC71:AC75,Inputs!AC83)/1000","v":1076.2795274531113},{"$f":"SUM(Inputs!AD71:AD75,Inputs!AD83)/1000","v":1076.2795274531113},{"$f":"SUM(Inputs!AE71:AE75,Inputs!AE83)/1000","v":1069.4407740252218},{"$f":"SUM(Inputs!AF71:AF75,Inputs!AF83)/1000","v":1192.0743885655363},{"$f":"SUM(Inputs!AG71:AG75,Inputs!AG83)/1000","v":1083.0014199650313},{"$f":"SUM(Inputs!AH71:AH75,Inputs!AH83)/1000","v":1063.8304551403835},{"$f":"SUM(Inputs!AI71:AI75,Inputs!AI83)/1000","v":1032.2165991653922},{"$f":"SUM(Inputs!AJ71:AJ75,Inputs!AJ83)/1000","v":1085.7173861451672},{"$f":"SUM(Inputs!AK71:AK75,Inputs!AK83)/1000","v":1085.7173861451672},{"$f":"SUM(Inputs!AL71:AL75,Inputs!AL83)/1000","v":1085.7173861451672},{"$f":"SUM(Inputs!AM71:AM75,Inputs!AM83)/1000","v":1085.7173861451672}]
["Services",null,null,null,{"$f":"SUM(Inputs!E76,Inputs!E78)/1000","v":5630.2762784602719},{"$f":"SUM(Inputs!F76,Inputs!F78)/1000","v":6268.7558237395706},{"$f":"SUM(Inputs!G76,Inputs!G78)/1000","v":7141.0089307027902},{"$f":"SUM(Inputs!H76,Inputs!H78)/1000","v":6261.2543253884687},{"$f":"SUM(Inputs!I76,Inputs!I78)/1000","v":5710.5859551995645},{"$f":"SUM(Inputs!J76,Inputs!J78)/1000","v":5586.5711461502488},{"$f":"SUM(Inputs!K76,Inputs!K78)/1000","v":5506.1751669917712},{"$f":"SUM(Inputs!L76,Inputs!L78)/1000","v":5483.7467635598723},{"$f":"SUM(Inputs!M76,Inputs!M78)/1000","v":5498.6066647433199},{"$f":"SUM(Inputs!N76,Inputs!N78)/1000","v":5473.9489679587205},{"$f":"SUM(Inputs!O76,Inputs!O78)/1000","v":5420.2631378815531},{"$f":"SUM(Inputs!P76,Inputs!P78)/1000","v":3911.0261301061473},{"$f":"SUM(Inputs!Q76,Inputs!Q78)/1000","v":3712.2025991700461},{"$f":"SUM(Inputs!R76,Inputs!R78)/1000","v":3555.8853237379708},{"$f":"SUM(Inputs!S76,Inputs!S78)/1000","v":3436.9320373231062},{"$f":"SUM(Inputs!T76,Inputs!T78)/1000","v":3229.8950304342102},{"$f":"SUM(Inputs!U76,Inputs!U78)/1000","v":3064.6632651265595},{"$f":"SUM(Inputs!V76,Inputs!V78)/1000","v":2837.8009555062231},{"$f":"SUM(Inputs!W76,Inputs!W78)/1000","v":2648.0792876359546},{"$f":"SUM(Inputs!X76,Inputs!X78)/1000","v":2462.1969803176344},{"$f":"SUM(Inputs!Y76,Inputs!Y78)/1000","v":2274.108385289469},{"$f":"SUM(Inputs!Z76,Inputs!Z78)/1000","v":2088.7093278894049},{"$f":"SUM(Inputs!AA76,Inputs!AA78)/1000","v":1903.3102704893099},{"$f":"SUM(Inputs!AB76,Inputs!AB78)/1000","v":1883.4460857678723},{"$f":"SUM(Inputs!AC76,Inputs!AC78)/1000","v":1863.5819010464368},{"$f":"SUM(Inputs!AD76,Inputs!AD78)/1000","v":1841.4673655575803},{"$f":"SUM(Inputs!AE76,Inputs!AE78)/1000","v":1810.9209765043884},{"$f":"SUM(Inputs!AF76,Inputs!AF78)/1000","v":1779.2358462564728},{"$f":"SUM(Inputs!AG76,Inputs!AG78)/1000","v":1734.7264671855492},{"$f":"SUM(Inputs!AH76,Inputs!AH78)/1000","v":1696.6507157430881},{"$f":"SUM(Inputs!AI76,Inputs!AI78)/1000","v":1654.5508676071438},{"$f":"SUM(Inputs!AJ76,Inputs!AJ78)/1000","v":1621.608820410089},{"$f":"SUM(Inputs!AK76,Inputs!AK78)/1000","v":1595.1232407815053},{"$f":"SUM(Inputs!AL76,Inputs!AL78)/1000","v":1575.2590560600679},{"$f":"SUM(Inputs!AM76,Inputs!AM78)/1000","v":1575.2590560600679}]
["Meters",null,null,null,{"$f":"SUM(Inputs!E77,Inputs!E79)/1000","v":2358.7204127764053},{"$f":"SUM(Inputs!F77,Inputs!F79)/1000","v":2450.8642143837992},{"$f":"SUM(Inputs!G77,Inputs!G79)/1000","v":2659.6502886638054},{"$f":"SUM(Inputs!H77,Inputs!H79)/1000","v":2427.7315660426329},{"$f":"SUM(Inputs!I77,Inputs!I79)/1000","v":2290.4636847758561},{"$f":"SUM(Inputs!J77,Inputs!J79)/1000","v":3270.8342481011609},{"$f":"SUM(Inputs!K77,Inputs!K79)/1000","v":3877.699983159594},{"$f":"SUM(Inputs!L77,Inputs!L79)/1000","v":4128.2893130311304},{"$f":"SUM(Inputs!M77,Inputs!M79)/1000","v":4817.6215166247075},{"$f":"SUM(Inputs!N77,Inputs!N79)/1000","v":5167.1821443364242},{"$f":"SUM(Inputs!O77,Inputs!O79)/1000","v":5839.1924078002257},{"$f":"SUM(Inputs!P77,Inputs!P79)/1000","v":5877.064247357639},{"$f":"SUM(Inputs!Q77,Inputs!Q79)/1000","v":5281.5544548801281},{"$f":"SUM(Inputs!R77,Inputs!R79)/1000","v":5241.7902380666183},{"$f":"SUM(Inputs!S77,Inputs!S79)/1000","v":4454.4034689915525},{"$f":"SUM(Inputs!T77,Inputs!T79)/1000","v":4440.8816457332514},{"$f":"SUM(Inputs!U77,Inputs!U79)/1000","v":3820.3946484311136},{"$f":"SUM(Inputs!V77,Inputs!V79)/1000","v":3783.0628646964428},{"$f":"SUM(Inputs!W77,Inputs!W79)/1000","v":3701.2512365205389},{"$f":"SUM(Inputs!X77,Inputs!X79)/1000","v":3960.0668396515384},{"$f":"SUM(Inputs!Y77,Inputs!Y79)/1000","v":4034.8465896437838},{"$f":"SUM(Inputs!Z77,Inputs!Z79)/1000","v":4248.5082400235406},{"$f":"SUM(Inputs!AA77,Inputs!AA79)/1000","v":4166.3479998592666},{"$f":"SUM(Inputs!AB77,Inputs!AB79)/1000","v":4406.2423977072849},{"$f":"SUM(Inputs!AC77,Inputs!AC79)/1000","v":4296.1796109366396},{"$f":"SUM(Inputs!AD77,Inputs!AD79)/1000","v":4033.8392657567319},{"$f":"SUM(Inputs!AE77,Inputs!AE79)/1000","v":4823.2182974468542},{"$f":"SUM(Inputs!AF77,Inputs!AF79)/1000","v":5185.6456220703749},{"$f":"SUM(Inputs!AG77,Inputs!AG79)/1000","v":6109.1483975141218},{"$f":"SUM(Inputs!AH77,Inputs!AH79)/1000","v":6583.3450881324388},{"$f":"SUM(Inputs!AI77,Inputs!AI79)/1000","v":6986.7527915487772},{"$f":"SUM(Inputs!AJ77,Inputs!AJ79)/1000","v":6566.5707260337522},{"$f":"SUM(Inputs!AK77,Inputs!AK79)/1000","v":5964.1656679736898},{"$f":"SUM(Inputs!AL77,Inputs!AL79)/1000","v":5919.2300019732675},{"$f":"SUM(Inputs!AM77,Inputs!AM79)/1000","v":5919.2300019732675}]
["Other 40 yrs - TMA",null,null,null,{"$f":"SUM(Inputs!E80:E82)/1000","v":3083.1247885339872},{"$f":"SUM(Inputs!F80:F82)/1000","v":2771.021300516074},{"$f":"SUM(Inputs!G80:G82)/1000","v":100.70473384570026},{"$f":"SUM(Inputs!H80:H82)/1000","v":100.10050544262604},{"$f":"SUM(Inputs!I80:I82)/1000","v":1075.5760024421377},{"$f":"SUM(Inputs!J82)/1000","v":736.08484433678325},{"$f":"SUM(Inputs!K82)/1000","v":819.61295580600199},{"$f":"SUM(Inputs!L82)/1000","v":1086.9865322300552},{"$f":"SUM(Inputs!M82)/1000","v":1185.427050940546},{"$f":"SUM(Inputs!N82)/1000","v":1030.7441853439266},{"$f":"SUM(Inputs!O82)/1000","v":914.53241550739801},{"$f":"SUM(Inputs!P82)/1000","v":486.96470191982939},{"$f":"SUM(Inputs!Q82)/1000","v":467.08234882621935},{"$f":"SUM(Inputs!R82)/1000","v":757.0099725435947},{"$f":"SUM(Inputs!S82)/1000","v":560.99223391127293},{"$f":"SUM(Inputs!T82)/1000","v":418.85159195263583},{"$f":"SUM(Inputs!U82)/1000","v":402.32841542187066},{"$f":"SUM(Inputs!V82)/1000","v":379.6421844598371},{"$f":"SUM(Inputs!W82)/1000","v":360.6700176728101},{"$f":"SUM(Inputs!X82)/1000","v":342.08178694097813},{"$f":"SUM(Inputs!Y82)/1000","v":323.27292743816156},{"$f":"SUM(Inputs!Z82)/1000","v":304.7330216981552},{"$f":"SUM(Inputs!AA82)/1000","v":286.19311595814571},{"$f":"SUM(Inputs!AB82)/1000","v":284.20669748600187},{"$f":"SUM(Inputs!AC82)/1000","v":282.22027901385837},{"$f":"SUM(Inputs!AD82)/1000","v":280.00882546497269},{"$f":"SUM(Inputs!AE82)/1000","v":276.95418655965352},{"$f":"SUM(Inputs!AF82)/1000","v":273.78567353486198},{"$f":"SUM(Inputs!AG82)/1000","v":269.33473562776959},{"$f":"SUM(Inputs!AH82)/1000","v":265.52716048352352},{"$f":"SUM(Inputs!AI82)/1000","v":261.31717566992904},{"$f":"SUM(Inputs!AJ82)/1000","v":258.02297095022357},{"$f":"SUM(Inputs!AK82)/1000","v":255.37441298736525},{"$f":"SUM(Inputs!AL82)/1000","v":253.38799451522146},{"$f":"SUM(Inputs!AM82)/1000","v":253.38799451522146}]
["Other 5 yrs",null,null,null,null,null,null,null,null,{"$f":"SUM(Inputs!J80)/1000","v":237.15413293087312},{"$f":"SUM(Inputs!K80)/1000","v":235.12548055508623},{"$f":"SUM(Inputs!L80)/1000","v":233.15022704879053},{"$f":"SUM(Inputs!M80)/1000","v":231.62643227783548},{"$f":"SUM(Inputs!N80)/1000","v":230.11259653858878},{"$f":"SUM(Inputs!O80)/1000","v":228.60865474202771},{"$f":"SUM(Inputs!P80)/1000","v":238.7538900618045},{"$f":"SUM(Inputs!Q80)/1000","v":238.7538900618045},{"$f":"SUM(Inputs!R80)/1000","v":238.7538900618045},{"$f":"SUM(Inputs!S80)/1000","v":238.7538900618045},{"$f":"SUM(Inputs!T80)/1000","v":238.7538900618045},{"$f":"SUM(Inputs!U80)/1000","v":238.7538900618045},{"$f":"SUM(Inputs!V80)/1000","v":238.7538900618045},{"$f":"SUM(Inputs!W80)/1000","v":238.7538900618045},{"$f":"SUM(Inputs!X80)/1000","v":238.7538900618045},{"$f":"SUM(Inputs!Y80)/1000","v":238.7538900618045},{"$f":"SUM(Inputs!Z80)/1000","v":238.7538900618045},{"$f":"SUM(Inputs!AA80)/1000","v":238.7538900618045},{"$f":"SUM(Inputs!AB80)/1000","v":238.7538900618045},{"$f":"SUM(Inputs!AC80)/1000","v":238.7538900618045},{"$f":"SUM(Inputs!AD80)/1000","v":238.7538900618045},{"$f":"SUM(Inputs!AE80)/1000","v":238.7538900618045},{"$f":"SUM(Inputs!AF80)/1000","v":238.7538900618045},{"$f":"SUM(Inputs!AG80)/1000","v":238.7538900618045},{"$f":"SUM(Inputs!AH80)/1000","v":238.7538900618045},{"$f":"SUM(Inputs!AI80)/1000","v":238.7538900618045},{"$f":"SUM(Inputs!AJ80)/1000","v":238.7538900618045},{"$f":"SUM(Inputs!AK80)/1000","v":238.7538900618045},{"$f":"SUM(Inputs!AL80)/1000","v":238.7538900618045},{"$f":"SUM(Inputs!AM80)/1000","v":238.7538900618045}]
["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,11410.307228002734,{"$f":"SUM(J11:J15)","v":10467.716038769444},{"$f":"SUM(K11:K15)","v":10926.630396194187},15615.350563078284,18200.456827731505,16827.78619193425,16189.089260862118,11590.08849689853,10775.872820391309,13925.312464468925,10981.730570438322,9404.6616856350138,8602.4197464944591,8315.5394221774186,8025.0339593442195,8079.3790244250677,7947.2613198863301,7956.9840071260169,7670.8848038216374,7888.9285984760754,7757.0152085118507,7470.3488742942009,8219.2881245979224,8669.4954204890491,9434.9649103542761,9848.1073095612373,10173.591324053046,9770.6737936010359,9139.1345979495309,9072.3483287555282,9072.3483287555282]
[null,null,null,null,{"$f":"ROUND(DAV!E16*1000,0)=ROUND(Inputs!E86,0)","v":true},{"$f":"ROUND(DAV!F16*1000,0)=ROUND(Inputs!F86,0)","v":true},{"$f":"ROUND(DAV!G16*1000,0)=ROUND(Inputs!G86,0)","v":true},{"$f":"ROUND(DAV!H16*1000,0)=ROUND(Inputs!H86,0)","v":true},{"$f":"ROUND(DAV!I16*1000,0)=ROUND(Inputs!I86,0)","v":true},{"$f":"ROUND(DAV!J16*1000,0)=ROUND(Inputs!J86,0)","v":true},{"$f":"ROUND(DAV!K16*1000,0)=ROUND(Inputs!K86,0)","v":true},{"$f":"ROUND(DAV!L16*1000,0)=ROUND(Inputs!L86,0)","v":true},{"$f":"ROUND(DAV!M16*1000,0)=ROUND(Inputs!M86,0)","v":true},{"$f":"ROUND(DAV!N16*1000,0)=ROUND(Inputs!N86,0)","v":true},{"$f":"ROUND(DAV!O16*1000,0)=ROUND(Inputs!O86,0)","v":true},{"$f":"ROUND(DAV!P16*1000,0)=ROUND(Inputs!P86,0)","v":true},{"$f":"ROUND(DAV!Q16*1000,0)=ROUND(Inputs!Q86,0)","v":true},{"$f":"ROUND(DAV!R16*1000,0)=ROUND(Inputs!R86,0)","v":true},{"$f":"ROUND(DAV!S16*1000,0)=ROUND(Inputs!S86,0)","v":true},{"$f":"ROUND(DAV!T16*1000,0)=ROUND(Inputs!T86,0)","v":true},{"$f":"ROUND(DAV!U16*1000,0)=ROUND(Inputs!U86,0)","v":true},{"$f":"ROUND(DAV!V16*1000,0)=ROUND(Inputs!V86,0)","v":true},{"$f":"ROUND(DAV!W16*1000,0)=ROUND(Inputs!W86,0)","v":true},{"$f":"ROUND(DAV!X16*1000,0)=ROUND(Inputs!X86,0)","v":true},{"$f":"ROUND(DAV!Y16*1000,0)=ROUND(Inputs!Y86,0)","v":true},{"$f":"ROUND(DAV!Z16*1000,0)=ROUND(Inputs!Z86,0)","v":true},{"$f":"ROUND(DAV!AA16*1000,0)=ROUND(Inputs!AA86,0)","v":true},{"$f":"ROUND(DAV!AB16*1000,0)=ROUND(Inputs!AB86,0)","v":true},{"$f":"ROUND(DAV!AC16*1000,0)=ROUND(Inputs!AC86,0)","v":true},{"$f":"ROUND(DAV!AD16*1000,0)=ROUND(Inputs!AD86,0)","v":true},{"$f":"ROUND(DAV!AE16*1000,0)=ROUND(Inputs!AE86,0)","v":true},{"$f":"ROUND(DAV!AF16*1000,0)=ROUND(Inputs!AF86,0)","v":true},{"$f":"ROUND(DAV!AG16*1000,0)=ROUND(Inputs!AG86,0)","v":true},{"$f":"ROUND(DAV!AH16*1000,0)=ROUND(Inputs!AH86,0)","v":true},{"$f":"ROUND(DAV!AI16*1000,0)=ROUND(Inputs!AI86,0)","v":true},{"$f":"ROUND(DAV!AJ16*1000,0)=ROUND(Inputs!AJ86,0)","v":true},{"$f":"ROUND(DAV!AK16*1000,0)=ROUND(Inputs!AK86,0)","v":true},{"$f":"ROUND(DAV!AL16*1000,0)=ROUND(Inputs!AL86,0)","v":true},{"$f":"ROUND(DAV!AM16*1000,0)=ROUND(Inputs!AM86,0)","v":true}]
["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},40,null,{"$f":"E11/$B$21","v":50.534722194922068},{"$f":"F11/$B$21","v":56.683376736800767},{"$f":"G11/$B$21","v":70.847979923400231},{"$f":"H11/$B$21","v":71.047087918021845},{"$f":"I11/$B$21","v":58.342039639629363},{"$f":"J11/$B$21","v":15.926791681259456},12.200420242043339,117.07944318021082,161.67937907862739,123.14495744391479,94.662316123272859,26.906988186327784,26.906988186327784,{"$f":"R11/$B$21","v":103.29682600147343},57.266223503764685,26.906988186327784,26.906988186327784,26.906988186327784,26.906988186327784,26.906988186327784,26.906988186327784,26.906988186327784,26.906988186327784,26.906988186327784,26.906988186327784,26.906988186327784,26.736019350630546,29.801859714138409,27.075035499125782,26.595761378509586,25.805414979134802,27.14293465362918,27.14293465362918,27.14293465362918,27.14293465362918]
["Services (35 or 40 years straight line)",{"$f":"IF(B18=C18,35,40)","v":40},35,null,{"$f":"E12/$C$22","v":160.86503652743633},{"$f":"F12/$C$22","v":179.10730924970201},{"$f":"G12/$C$22","v":204.02882659150828},{"$f":"H12/$C$22","v":178.89298072538483},{"$f":"I12/$C$22","v":163.15959871998757},{"$f":"J12/$B$22","v":139.66427865375621},{"$f":"K12/$B$22","v":137.65437917479429},{"$f":"L12/$B$22","v":137.09366908899682},137.465166618583,136.848724198968,135.50657844703883,97.775653252653683,92.805064979251156,88.89713309344927,85.923300933077655,80.747375760855249,76.616581628163985,70.94502388765558,66.20198219089886,61.554924507940861,56.852709632236724,52.21773319723512,47.582756762232748,47.086152144196809,46.589547526160921,46.036684138939506,45.273024412609708,44.480896156411816,43.368161679638732,42.416267893577199,41.363771690178595,40.540220510252226,39.878081019537632,39.3814764015017,39.3814764015017]
["Meters (15 years straight line)",{"$f":"IF(B18=C18,15,15)","v":15},15,null,{"$f":"E13/$B$23","v":157.24802751842702},{"$f":"F13/$B$23","v":163.39094762558662},177.31001924425371,161.84877106950887,152.69757898505708,218.05561654007741,258.51333221063959,275.21928753540868,321.17476777498052,344.47880962242829,389.27949385334836,391.80428315717592,352.1036303253419,349.45268253777454,296.96023126610351,296.05877638221676,254.69297656207425,252.20419097976284,246.75008243470259,264.00445597676924,268.98977264291892,283.23388266823605,277.75653332395109,293.74949318048567,286.41197406244265,268.92261771711549,321.54788649645695,345.70970813802501,407.27655983427479,438.8896725421626,465.78351943658515,437.77138173558347,397.6110445315793,394.61533346488449,394.61533346488449]
["Other (40 years straight line)",{"$f":"IF(B18=C18,40,40)","v":40},40,null,{"$f":"E14/$B$24","v":77.078119713349679},{"$f":"F14/$B$24","v":69.275532512901847},2.5176183461425063,2.5025126360656511,{"$f":"I14/$B$24","v":26.889400061053443},{"$f":"J14/$B$24","v":18.402121108419582},{"$f":"K14/$B$24","v":20.490323895150048},{"$f":"L14/$B$24","v":27.17466330575138},29.635676273513649,25.768604633598166,22.863310387684951,12.174117547995735,11.677058720655484,18.925249313589866,14.024805847781824,10.471289798815896,10.058210385546767,9.4910546114959278,9.0167504418202533,8.5520446735244526,8.0818231859540397,7.6183255424538796,7.1548278989536431,7.1051674371500466,7.055506975346459,7.0002206366243174,6.9238546639913379,6.8446418383715493,6.7333683906942401,6.6381790120880879,6.5329293917482261,6.4505742737555893,6.3843603246841312,6.3346998628805364,6.3346998628805364]
["Other (5 years straight line)",{"$f":"IF(B18=C18,40,5)","v":5},40,null,{"$f":"E15/$C$25","v":0},{"$f":"F15/$C$25","v":0},{"$f":"G15/$C$25","v":0},{"$f":"H15/$C$25","v":0},{"$f":"I15/$C$25","v":0},{"$f":"J15/$B$25","v":47.430826586174625},{"$f":"K15/$B$25","v":47.025096111017248},{"$f":"L15/$B$25","v":46.630045409758104},{"$f":"M15/$B$25","v":46.325286455567095},{"$f":"N15/$B$25","v":46.022519307717758},{"$f":"O15/$B$25","v":45.721730948405543},47.750778012360897,47.750778012360897,47.750778012360897,47.750778012360897,47.750778012360897,47.750778012360897,47.750778012360897,47.750778012360897,47.750778012360897,47.750778012360897,47.750778012360897,47.750778012360897,47.750778012360897,47.750778012360897,47.750778012360897,47.750778012360897,47.750778012360897,47.750778012360897,{"$f":"AH15/$B$25","v":47.750778012360897},47.750778012360897,47.750778012360897,47.750778012360897,47.750778012360897,47.750778012360897]
[]
["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$29/'Opening Values'!$E$30","v":16.067871755578388},{"$f":"'Opening Values'!$E$29/'Opening Values'!$E$30+'Opening Values'!$F$29/'Opening Values'!$F$30","v":40.829874415820285},{"$f":"'Opening Values'!$E$29/'Opening Values'!$E$30+'Opening Values'!$F$29/'Opening Values'!$F$30+'Opening Values'!$G$29/'Opening Values'!$G$30","v":56.656004878828959},{"$f":"'Opening Values'!$E$29/'Opening Values'!$E$30+'Opening Values'!$F$29/'Opening Values'!$F$30+'Opening Values'!$G$29/'Opening Values'!$G$30","v":56.656004878828959},{"$f":"'Opening Values'!$E$29/'Opening Values'!$E$30+'Opening Values'!$F$29/'Opening Values'!$F$30+'Opening Values'!$G$29/'Opening Values'!$G$30","v":56.656004878828959},{"$f":"'Opening Values'!$E$29/'Opening Values'!$E$30+'Opening Values'!$F$29/'Opening Values'!$F$30+'Opening Values'!$G$29/'Opening Values'!$G$30+'Opening Values'!$J$29/'Opening Values'!$J$30","v":64.234719456104585},{"$f":"'Opening Values'!$E$29/'Opening Values'!$E$30+'Opening Values'!$F$29/'Opening Values'!$F$30+'Opening Values'!$G$29/'Opening Values'!$G$30+'Opening Values'!$J$29/'Opening Values'!$J$30+'Opening Values'!$K$29/'Opening Values'!$K$30","v":96.07564828200654},{"$f":"'Opening Values'!$E$29/'Opening Values'!$E$30+'Opening Values'!$F$29/'Opening Values'!$F$30+'Opening Values'!$G$29/'Opening Values'!$G$30+'Opening Values'!$J$29/'Opening Values'!$J$30+'Opening Values'!$K$29/'Opening Values'!$K$30+'Opening Values'!$L$29/'Opening Values'!$L$30","v":146.59933106065631},{"$f":"'Opening Values'!$E$29/'Opening Values'!$E$30+'Opening Values'!$F$29/'Opening Values'!$F$30+'Opening Values'!$G$29/'Opening Values'!$G$30+'Opening Values'!$J$29/'Opening Values'!$J$30+'Opening Values'!$K$29/'Opening Values'!$K$30+'Opening Values'!$L$29/'Opening Values'!$L$30","v":146.59933106065631},{"$f":"'Opening Values'!$E$29/'Opening Values'!$E$30+'Opening Values'!$F$29/'Opening Values'!$F$30+'Opening Values'!$G$29/'Opening Values'!$G$30+'Opening Values'!$J$29/'Opening Values'!$J$30+'Opening Values'!$K$29/'Opening Values'!$K$30+'Opening Values'!$L$29/'Opening Values'!$L$30","v":146.59933106065631},{"$f":"'Opening Values'!$E$29/'Opening Values'!$E$30+'Opening Values'!$F$29/'Opening Values'!$F$30+'Opening Values'!$G$29/'Opening Values'!$G$30+'Opening Values'!$J$29/'Opening Values'!$J$30+'Opening Values'!$K$29/'Opening Values'!$K$30+'Opening Values'!$L$29/'Opening Values'!$L$30","v":146.59933106065631},{"$f":"'Opening Values'!$E$29/'Opening Values'!$E$30+'Opening Values'!$F$29/'Opening Values'!$F$30+'Opening Values'!$G$29/'Opening Values'!$G$30+'Opening Values'!$J$29/'Opening Values'!$J$30+'Opening Values'!$K$29/'Opening Values'!$K$30+'Opening Values'!$L$29/'Opening Values'!$L$30","v":146.59933106065631},{"$f":"'Opening Values'!$E$29/'Opening Values'!$E$30+'Opening Values'!$F$29/'Opening Values'!$F$30+'Opening Values'!$G$29/'Opening Values'!$G$30+'Opening Values'!$J$29/'Opening Values'!$J$30+'Opening Values'!$K$29/'Opening Values'!$K$30+'Opening Values'!$L$29/'Opening Values'!$L$30","v":146.59933106065631},{"$f":"'Opening Values'!$E$29/'Opening Values'!$E$30+'Opening Values'!$F$29/'Opening Values'!$F$30+'Opening Values'!$G$29/'Opening Values'!$G$30+'Opening Values'!$J$29/'Opening Values'!$J$30+'Opening Values'!$K$29/'Opening Values'!$K$30+'Opening Values'!$L$29/'Opening Values'!$L$30","v":146.59933106065631},{"$f":"'Opening Values'!$E$29/'Opening Values'!$E$30+'Opening Values'!$F$29/'Opening Values'!$F$30+'Opening Values'!$G$29/'Opening Values'!$G$30+'Opening Values'!$J$29/'Opening Values'!$J$30+'Opening Values'!$K$29/'Opening Values'!$K$30+'Opening Values'!$L$29/'Opening Values'!$L$30","v":146.59933106065631},{"$f":"'Opening Values'!$E$29/'Opening Values'!$E$30+'Opening Values'!$F$29/'Opening Values'!$F$30+'Opening Values'!$G$29/'Opening Values'!$G$30+'Opening Values'!$J$29/'Opening Values'!$J$30+'Opening Values'!$K$29/'Opening Values'!$K$30+'Opening Values'!$L$29/'Opening Values'!$L$30","v":146.59933106065631},{"$f":"'Opening Values'!$E$29/'Opening Values'!$E$30+'Opening Values'!$F$29/'Opening Values'!$F$30+'Opening Values'!$G$29/'Opening Values'!$G$30+'Opening Values'!$J$29/'Opening Values'!$J$30+'Opening Values'!$K$29/'Opening Values'!$K$30+'Opening Values'!$L$29/'Opening Values'!$L$30","v":146.59933106065631},{"$f":"'Opening Values'!$E$29/'Opening Values'!$E$30+'Opening Values'!$F$29/'Opening Values'!$F$30+'Opening Values'!$G$29/'Opening Values'!$G$30+'Opening Values'!$J$29/'Opening Values'!$J$30+'Opening Values'!$K$29/'Opening Values'!$K$30+'Opening Values'!$L$29/'Opening Values'!$L$30","v":146.59933106065631},{"$f":"'Opening Values'!$E$29/'Opening Values'!$E$30+'Opening Values'!$F$29/'Opening Values'!$F$30+'Opening Values'!$G$29/'Opening Values'!$G$30+'Opening Values'!$J$29/'Opening Values'!$J$30+'Opening Values'!$K$29/'Opening Values'!$K$30+'Opening Values'!$L$29/'Opening Values'!$L$30","v":146.59933106065631},{"$f":"'Opening Values'!$E$29/'Opening Values'!$E$30+'Opening Values'!$F$29/'Opening Values'!$F$30+'Opening Values'!$G$29/'Opening Values'!$G$30+'Opening Values'!$J$29/'Opening Values'!$J$30+'Opening Values'!$K$29/'Opening Values'!$K$30+'Opening Values'!$L$29/'Opening Values'!$L$30","v":146.59933106065631},{"$f":"'Opening Values'!$E$29/'Opening Values'!$E$30+'Opening Values'!$F$29/'Opening Values'!$F$30+'Opening Values'!$G$29/'Opening Values'!$G$30+'Opening Values'!$K$29/'Opening Values'!$K$30+'Opening Values'!$L$29/'Opening Values'!$L$30","v":139.02061648338068},{"$f":"'Opening Values'!$E$29/'Opening Values'!$E$30+'Opening Values'!$F$29/'Opening Values'!$F$30+'Opening Values'!$G$29/'Opening Values'!$G$30+'Opening Values'!$K$29/'Opening Values'!$K$30+'Opening Values'!$L$29/'Opening Values'!$L$30","v":139.02061648338068},{"$f":"'Opening Values'!$E$29/'Opening Values'!$E$30+'Opening Values'!$F$29/'Opening Values'!$F$30+'Opening Values'!$G$29/'Opening Values'!$G$30+'Opening Values'!$K$29/'Opening Values'!$K$30+'Opening Values'!$L$29/'Opening Values'!$L$30","v":139.02061648338068},{"$f":"'Opening Values'!$E$29/'Opening Values'!$E$30+'Opening Values'!$F$29/'Opening Values'!$F$30+'Opening Values'!$G$29/'Opening Values'!$G$30+'Opening Values'!$K$29/'Opening Values'!$K$30+'Opening Values'!$L$29/'Opening Values'!$L$30","v":139.02061648338068},{"$f":"'Opening Values'!$F$29/'Opening Values'!$F$30+'Opening Values'!$K$29/'Opening Values'!$K$30+'Opening Values'!$L$29/'Opening Values'!$L$30","v":107.12661426479362},{"$f":"'Opening Values'!$F$29/'Opening Values'!$F$30+'Opening Values'!$K$29/'Opening Values'!$K$30+'Opening Values'!$L$29/'Opening Values'!$L$30","v":107.12661426479362},{"$f":"'Opening Values'!$K$29/'Opening Values'!$K$30+'Opening Values'!$L$29/'Opening Values'!$L$30","v":82.364611604551726},{"$f":"'Opening Values'!$K$29/'Opening Values'!$K$30+'Opening Values'!$L$29/'Opening Values'!$L$30","v":82.364611604551726},{"$f":"'Opening Values'!$K$29/'Opening Values'!$K$30+'Opening Values'!$L$29/'Opening Values'!$L$30","v":82.364611604551726},{"$f":"'Opening Values'!$K$29/'Opening Values'!$K$30+'Opening Values'!$L$29/'Opening Values'!$L$30","v":82.364611604551726},{"$f":"'Opening Values'!$L$29/'Opening Values'!$L$30","v":50.523682778649771},{"$f":"'Opening Values'!$L$29/'Opening Values'!$L$30","v":50.523682778649771},{"$f":"'Opening Values'!$L$29/'Opening Values'!$L$30","v":50.523682778649771}]
["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":307.45520641277426},{"$f":"IF($B$18=$C$18,SUM($E$21:J$21),SUM($E$21:J$21))","v":323.38199809403369},{"$f":"IF($B$18=$C$18,SUM($E$21:K$21),SUM($E$21:K$21))","v":335.58241833607701},{"$f":"IF($B$18=$C$18,SUM($E$21:L$21),SUM($E$21:L$21))","v":452.66186151628784},{"$f":"IF($B$18=$C$18,SUM($E$21:M$21),SUM($E$21:M$21))","v":614.34124059491523},{"$f":"IF($B$18=$C$18,SUM($E$21:N$21),SUM($E$21:N$21))","v":737.48619803883003},{"$f":"IF($B$18=$C$18,SUM($E$21:O$21),SUM($E$21:O$21))","v":832.14851416210286},{"$f":"IF($B$18=$C$18,SUM($E$21:P$21),SUM($E$21:P$21))","v":859.05550234843065},{"$f":"IF($B$18=$C$18,SUM($E$21:Q$21),SUM($E$21:Q$21))","v":885.96249053475844},{"$f":"IF($B$18=$C$18,SUM($E$21:R$21),SUM($E$21:R$21))","v":989.25931653623184},{"$f":"IF($B$18=$C$18,SUM($E$21:S$21),SUM($E$21:S$21))","v":1046.5255400399965},{"$f":"IF($B$18=$C$18,SUM($E$21:T$21),SUM($E$21:T$21))","v":1073.4325282263242},{"$f":"IF($B$18=$C$18,SUM($E$21:U$21),SUM($E$21:U$21))","v":1100.3395164126518},{"$f":"IF($B$18=$C$18,SUM($E$21:V$21),SUM($E$21:V$21))","v":1127.2465045989795},{"$f":"IF($B$18=$C$18,SUM($E$21:W$21),SUM($E$21:W$21))","v":1154.1534927853072},{"$f":"IF($B$18=$C$18,SUM($E$21:X$21),SUM($E$21:X$21))","v":1181.0604809716349},{"$f":"IF($B$18=$C$18,SUM($E$21:Y$21),SUM($E$21:Y$21))","v":1207.9674691579626},{"$f":"IF($B$18=$C$18,SUM($E$21:Z$21),SUM($E$21:Z$21))","v":1234.8744573442902},{"$f":"IF($B$18=$C$18,SUM($E$21:AA$21),SUM($E$21:AA$21))","v":1261.7814455306179},{"$f":"IF($B$18=$C$18,SUM($E$21:AB$21),SUM($E$21:AB$21))","v":1288.6884337169456},{"$f":"IF($B$18=$C$18,SUM($E$21:AC$21),SUM($E$21:AC$21))","v":1315.5954219032733},{"$f":"IF($B$18=$C$18,SUM($E$21:AD$21),SUM($E$21:AD$21))","v":1342.502410089601},{"$f":"IF($B$18=$C$18,SUM($E$21:AE$21),SUM($E$21:AE$21))","v":1369.2384294402316},{"$f":"IF($B$18=$C$18,SUM($E$21:AF$21),SUM($E$21:AF$21))","v":1399.0402891543699},{"$f":"IF($B$18=$C$18,SUM($E$21:AG$21),SUM($E$21:AG$21))","v":1426.1153246534957},{"$f":"IF($B$18=$C$18,SUM($E$21:AH$21),SUM($E$21:AH$21))","v":1452.7110860320054},{"$f":"IF($B$18=$C$18,SUM($E$21:AI$21),SUM($E$21:AI$21))","v":1478.5165010111402},{"$f":"IF($B$18=$C$18,SUM($E$21:AJ$21),SUM($E$21:AJ$21))","v":1505.6594356647695},{"$f":"IF($B$18=$C$18,SUM($E$21:AK$21),SUM($E$21:AK$21))","v":1532.8023703183987},{"$f":"IF($B$18=$C$18,SUM($E$21:AL$21),SUM($E$21:AL$21))","v":1559.945304972028},{"$f":"IF($B$18=$C$18,SUM($E$21:AM$21),SUM($E$21:AM$21))","v":1587.0882396256573}]
["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":160.86503652743633},{"$f":"IF($B$18=$C$18,SUM($E$22:F22),SUM($E$22:F22))","v":339.97234577713834},{"$f":"IF($B$18=$C$18,SUM($E$22:G22),SUM($E$22:G22))","v":544.00117236864662},{"$f":"IF($B$18=$C$18,SUM($E$22:H22),SUM($E$22:H22))","v":722.89415309403148},{"$f":"IF($B$18=$C$18,SUM($E$22:I22),SUM($E$22:I22))","v":886.05375181401905},{"$f":"IF($B$18=$C$18,SUM($E$22:J22),SUM($E$22:J22))","v":1025.7180304677752},{"$f":"IF($B$18=$C$18,SUM($E$22:K22),SUM($E$22:K22))","v":1163.3724096425694},{"$f":"IF($B$18=$C$18,SUM($E$22:L22),SUM($E$22:L22))","v":1300.4660787315663},{"$f":"IF($B$18=$C$18,SUM($E$22:M22),SUM($E$22:M22))","v":1437.9312453501493},{"$f":"IF($B$18=$C$18,SUM($E$22:N22),SUM($E$22:N22))","v":1574.7799695491174},{"$f":"IF($B$18=$C$18,SUM($E$22:O22),SUM($E$22:O22))","v":1710.2865479961563},{"$f":"IF($B$18=$C$18,SUM($E$22:P22),SUM($E$22:P22))","v":1808.06220124881},{"$f":"IF($B$18=$C$18,SUM($E$22:Q22),SUM($E$22:Q22))","v":1900.8672662280612},{"$f":"IF($B$18=$C$18,SUM($E$22:R22),SUM($E$22:R22))","v":1989.7643993215106},{"$f":"IF($B$18=$C$18,SUM($E$22:S22),SUM($E$22:S22))","v":2075.6877002545884},{"$f":"IF($B$18=$C$18,SUM($E$22:T22),SUM($E$22:T22))","v":2156.4350760154439},{"$f":"IF($B$18=$C$18,SUM($E$22:U22),SUM($E$22:U22))","v":2233.051657643608},{"$f":"IF($B$18=$C$18,SUM($E$22:V22),SUM($E$22:V22))","v":2303.9966815312637},{"$f":"IF($B$18=$C$18,SUM($E$22:W22),SUM($E$22:W22))","v":2370.1986637221626},{"$f":"IF($B$18=$C$18,SUM($E$22:X22),SUM($E$22:X22))","v":2431.7535882301036},{"$f":"IF($B$18=$C$18,SUM($E$22:Y22),SUM($E$22:Y22))","v":2488.6062978623404},{"$f":"IF($B$18=$C$18,SUM($E$22:Z22),SUM($E$22:Z22))","v":2540.8240310595756},{"$f":"IF($B$18=$C$18,SUM($E$22:AA22),SUM($E$22:AA22))","v":2588.4067878218084},{"$f":"IF($B$18=$C$18,SUM($E$22:AB22),SUM($E$22:AB22))","v":2635.492939966005},{"$f":"IF($B$18=$C$18,SUM($E$22:AC22),SUM($E$22:AC22))","v":2682.0824874921659},{"$f":"IF($B$18=$C$18,SUM($E$22:AD22),SUM($E$22:AD22))","v":2728.1191716311055},{"$f":"IF($B$18=$C$18,SUM($E$22:AE22),SUM($E$22:AE22))","v":2773.3921960437151},{"$f":"IF($B$18=$C$18,SUM($E$22:AF22),SUM($E$22:AF22))","v":2817.8730922001268},{"$f":"IF($B$18=$C$18,SUM($E$22:AG22),SUM($E$22:AG22))","v":2861.2412538797657},{"$f":"IF($B$18=$C$18,SUM($E$22:AH22),SUM($E$22:AH22))","v":2903.657521773343},{"$f":"IF($B$18=$C$18,SUM($E$22:AI22),SUM($E$22:AI22))","v":2945.0212934635215},{"$f":"IF($B$18=$C$18,SUM($E$22:AJ22),SUM($E$22:AJ22))","v":2985.5615139737738},{"$f":"IF($B$18=$C$18,SUM($E$22:AK22),SUM($E$22:AK22))","v":3025.4395949933114},{"$f":"IF($B$18=$C$18,SUM($E$22:AL22),SUM($E$22:AL22))","v":3064.8210713948133},{"$f":"IF($B$18=$C$18,SUM($E$22:AM22),SUM($E$22:AM22))","v":3104.2025477963152}]
["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":1030.5509609829107},{"$f":"IF($B$18=$C$18,SUM($E$23:K23),SUM($E$23:K23))","v":1289.0642931935504},{"$f":"IF($B$18=$C$18,SUM($E$23:L23),SUM($E$23:L23))","v":1564.2835807289591},{"$f":"IF($B$18=$C$18,SUM($E$23:M23),SUM($E$23:M23))","v":1885.4583485039398},{"$f":"IF($B$18=$C$18,SUM($E$23:N23),SUM($E$23:N23))","v":2229.9371581263681},{"$f":"IF($B$18=$C$18,SUM($E$23:O23),SUM($E$23:O23))","v":2619.2166519797165},{"$f":"IF($B$18=$C$18,SUM($E$23:P23),SUM($E$23:P23))","v":3011.0209351368926},{"$f":"IF($B$18=$C$18,SUM($E$23:Q23),SUM($E$23:Q23))","v":3363.1245654622344},{"$f":"IF($B$18=$C$18,SUM($E$23:R23),SUM($E$23:R23))","v":3712.5772480000087},{"$f":"IF($B$18=$C$18,SUM(E23:S23),SUM(E23:S23))","v":4009.5374792661123},{"$f":"IF($B$18=$C$18,SUM(F23:T23),SUM(F23:T23))","v":4148.3482281299021},{"$f":"IF($B$18=$C$18,SUM(G23:U23),SUM(G23:U23))","v":4239.6502570663897},{"$f":"IF($B$18=$C$18,SUM(H23:V23),SUM(H23:V23))","v":4314.5444288018989},4399.4457401670925,4510.7526171588052,4561.6867732616465,4586.4073237192424,4588.9445695077848,4561.5192949132907,4503.4524593533051,4383.0955832170721,4312.8391865563526,4306.4452643690356,4364.2691416655362,4506.1985829415953,4675.9233259959638,4859.0017311694728,5004.4085847212891,5152.2738357514709,{"$f":"IF($B$18=$C$18,SUM(Y23:AM23),SUM(Y23:AM23))","v":5282.8847132395858}]
["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":178.26318326951315},{"$f":"IF($B$18=$C$18,SUM($E$24:J24),SUM($E$24:J24))","v":196.66530437793273},{"$f":"IF($B$18=$C$18,SUM($E$24:K24),SUM($E$24:K24))","v":217.15562827308278},{"$f":"IF($B$18=$C$18,SUM($E$24:L24),SUM($E$24:L24))","v":244.33029157883416},{"$f":"IF($B$18=$C$18,SUM($E$24:M24),SUM($E$24:M24))","v":273.96596785234783},{"$f":"IF($B$18=$C$18,SUM($E$24:N24),SUM($E$24:N24))","v":299.73457248594599},{"$f":"IF($B$18=$C$18,SUM($E$24:O24),SUM($E$24:O24))","v":322.59788287363097},{"$f":"IF($B$18=$C$18,SUM($E$24:P24),SUM($E$24:P24))","v":334.77200042162667},{"$f":"IF($B$18=$C$18,SUM($E$24:Q24),SUM($E$24:Q24))","v":346.44905914228218},{"$f":"IF($B$18=$C$18,SUM($E$24:R24),SUM($E$24:R24))","v":365.37430845587204},{"$f":"IF($B$18=$C$18,SUM($E$24:S24),SUM($E$24:S24))","v":379.39911430365385},{"$f":"IF($B$18=$C$18,SUM($E$24:T24),SUM($E$24:T24))","v":389.87040410246976},{"$f":"IF($B$18=$C$18,SUM($E$24:U24),SUM($E$24:U24))","v":399.92861448801654},{"$f":"IF($B$18=$C$18,SUM($E$24:V24),SUM($E$24:V24))","v":409.41966909951248},{"$f":"IF($B$18=$C$18,SUM($E$24:W24),SUM($E$24:W24))","v":418.43641954133273},{"$f":"IF($B$18=$C$18,SUM($E$24:X24),SUM($E$24:X24))","v":426.98846421485717},{"$f":"IF($B$18=$C$18,SUM($E$24:Y24),SUM($E$24:Y24))","v":435.0702874008112},{"$f":"IF($B$18=$C$18,SUM($E$24:Z24),SUM($E$24:Z24))","v":442.68861294326507},{"$f":"IF($B$18=$C$18,SUM($E$24:AA24),SUM($E$24:AA24))","v":449.84344084221874},{"$f":"IF($B$18=$C$18,SUM($E$24:AB24),SUM($E$24:AB24))","v":456.94860827936878},{"$f":"IF($B$18=$C$18,SUM($E$24:AC24),SUM($E$24:AC24))","v":464.00411525471526},{"$f":"IF($B$18=$C$18,SUM($E$24:AD24),SUM($E$24:AD24))","v":471.00433589133957},{"$f":"IF($B$18=$C$18,SUM($E$24:AE24),SUM($E$24:AE24))","v":477.9281905553309},{"$f":"IF($B$18=$C$18,SUM($E$24:AF24),SUM($E$24:AF24))","v":484.77283239370246},{"$f":"IF($B$18=$C$18,SUM($E$24:AG24),SUM($E$24:AG24))","v":491.5062007843967},{"$f":"IF($B$18=$C$18,SUM($E$24:AH24),SUM($E$24:AH24))","v":498.14437979648477},{"$f":"IF($B$18=$C$18,SUM($E$24:AI24),SUM($E$24:AI24))","v":504.67730918823298},{"$f":"IF($B$18=$C$18,SUM($E$24:AJ24),SUM($E$24:AJ24))","v":511.12788346198857},{"$f":"IF($B$18=$C$18,SUM($E$24:AK24),SUM($E$24:AK24))","v":517.51224378667268},{"$f":"IF($B$18=$C$18,SUM($E$24:AL24),SUM($E$24:AL24))","v":523.84694364955317},{"$f":"IF($B$18=$C$18,SUM($E$24:AM24),SUM($E$24:AM24))","v":530.18164351243365}]
["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.430826586174625},{"$f":"IF($B$18=$C$18,SUM($E$25:K25),SUM(G25:K25))","v":94.45592269719188},{"$f":"IF($B$18=$C$18,SUM($E$25:L25),SUM(H25:L25))","v":141.08596810694999},{"$f":"IF($B$18=$C$18,SUM($E$25:M25),SUM(I25:M25))","v":187.41125456251709},{"$f":"IF($B$18=$C$18,SUM($E$25:N25),SUM(J25:N25))","v":233.43377387023486},{"$f":"IF($B$18=$C$18,SUM($E$25:O25),SUM(K25:O25))","v":231.72467823246575},{"$f":"IF($B$18=$C$18,SUM($E$25:P25),SUM(L25:P25))","v":232.4503601338094},{"$f":"IF($B$18=$C$18,SUM($E$25:Q25),SUM(M25:Q25))","v":233.5710927364122},{"$f":"IF($B$18=$C$18,SUM($E$25:R25),SUM(N25:R25))","v":234.99658429320601},{"$f":"IF($B$18=$C$18,SUM($E$25:S25),SUM(O25:S25))","v":236.72484299784918},{"$f":"IF($B$18=$C$18,SUM($E$25:T25),SUM(P25:T25))","v":238.7538900618045},{"$f":"IF($B$18=$C$18,SUM($E$25:U25),SUM(Q25:U25))","v":238.7538900618045},{"$f":"IF($B$18=$C$18,SUM($E$25:V25),SUM(R25:V25))","v":238.7538900618045},{"$f":"IF($B$18=$C$18,SUM($E$25:W25),SUM(S25:W25))","v":238.7538900618045},{"$f":"IF($B$18=$C$18,SUM($E$25:X25),SUM(T25:X25))","v":238.7538900618045},{"$f":"IF($B$18=$C$18,SUM($E$25:Y25),SUM(U25:Y25))","v":238.7538900618045},{"$f":"IF($B$18=$C$18,SUM($E$25:Z25),SUM(V25:Z25))","v":238.7538900618045},{"$f":"IF($B$18=$C$18,SUM($E$25:AA25),SUM(W25:AA25))","v":238.7538900618045},{"$f":"IF($B$18=$C$18,SUM($E$25:AB25),SUM(X25:AB25))","v":238.7538900618045},{"$f":"IF($B$18=$C$18,SUM($E$25:AC25),SUM(Y25:AC25))","v":238.7538900618045},{"$f":"IF($B$18=$C$18,SUM($E$25:AD25),SUM(Z25:AD25))","v":238.7538900618045},{"$f":"IF($B$18=$C$18,SUM($E$25:AE25),SUM(AA25:AE25))","v":238.7538900618045},{"$f":"IF($B$18=$C$18,SUM($E$25:AF25),SUM(AB25:AF25))","v":238.7538900618045},{"$f":"IF($B$18=$C$18,SUM($E$25:AG25),SUM(AC25:AG25))","v":238.7538900618045},{"$f":"IF($B$18=$C$18,SUM($E$25:AH25),SUM(AD25:AH25))","v":238.7538900618045},{"$f":"IF($B$18=$C$18,SUM($E$25:AI25),SUM(AE25:AI25))","v":238.7538900618045},{"$f":"IF($B$18=$C$18,SUM($E$25:AJ25),SUM(AF25:AJ25))","v":238.7538900618045},{"$f":"IF($B$18=$C$18,SUM($E$25:AK25),SUM(AG25:AK25))","v":238.7538900618045},{"$f":"IF($B$18=$C$18,SUM($E$25:AL25),SUM(AH25:AL25))","v":238.7538900618045},{"$f":"IF($B$18=$C$18,SUM($E$25:AM25),SUM(AI25:AM25))","v":238.7538900618045}]
["Total Depreciation",null,null,null,{"$f":"SUM(E28:E34)","v":12513.642154697825},{"$f":"SUM(F28:F34)","v":12982.099320822816},13452.8716366837,13891.924991692922,14308.839739561661,14748.319374131348,15224.202925764992,15834.978748862393,16563.099953889567,17289.887251874843,17930.489855048418,18459.876579093918,18944.490053908095,19506.487436411178,19962.390256666549,20221.355706340288,20426.23951547682,20608.476753897805,20795.503786082048,21003.824620441555,21146.600297548914,21258.063894932526,21334.666998991306,21388.340032164488,21410.825239292339,21370.412256117994,21347.194755665922,21421.928231187521,21532.166671393243,21749.746320953476,21993.173180068901,22250.38531468005,22437.35661540382,22658.080977352016,{"$f":"SUM(AM28:AM34)","v":10793.634717014444}]
[]
["Closing DAV",null,null,{"$f":"388965.431017349/rpi*rpi_14","v":410309.1524572855},{"$f":"E$8+E$16-E$35","v":410889.02067015518},{"$f":"F$8+F$16-F$35","v":411664.89775744383},411332.9381930423,409691.03318144998,407140.67554007727,421863.71823555324,{"$f":"K$8+K$16-K$35","v":426373.06309668178},427188.81435230974,400858.09137368324,401760.12974876619,400018.72915457987,393148.94107238448,384980.32383886771,379399.14886692545,370418.48918069724,359601.79515999195,347777.97539100959,335485.03805928922,322714.56823255139,309790.12263653491,296590.7836588723,283289.7037710658,269625.92157589609,256126.51014220767,242472.70011142717,228572.63672960337,215444.73009853536,202692.2972878369,190595.09552679796,178693.45651540573,166873.87465938987,154394.16313831086,141095.94112085659,127510.2084722601,{"$f":"AM$8+AM$16-AM$35","v":125788.92208400118}]

{"sheet":"PDP Workings - FD","index":3,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
["Bulk & Infill Removal Calcs - East Down"]
[]
[null,"2014-09-01",257.60000000000002]
[null,"2015-09-01",259.60000000000002]
["Total PDP Additions"]
["PDP DAV",2016,{"$f":"B7+1","v":2017},{"$f":"C7+1","v":2018},2019,2020,2021,2022,2023]
["Op Bal",0,{"$f":"B12","v":11720148.994062999},{"$f":"C12","v":18228038.239193495},26339691.544354424,26543083.713500071,25824777.15989282,25106470.606285568,24388164.052678317]
["Total PDP Additions",{"$f":"B21","v":12020665.634936409},{"$f":"C21","v":6982980.3959014444},8806917.3906993624,921698.72275290021,0,0,0,0]
["Additions Depn",{"$f":"-B9/40","v":-300516.64087341022},{"$f":"-C9/40","v":-174574.5098975361},{"$f":"-D9/40","v":-220172.93476748405},-23042.468068822505,0,0,0,0]
["Annual Depn (40 yrs)",{"$f":"B10","v":-300516.64087341022},{"$f":"C10+B11","v":-475091.15077094629},{"$f":"D10+C11","v":-695264.08553843037},{"$f":"E10+D11","v":-718306.55360725289},-718306.55360725289,-718306.55360725289,-718306.55360725289,-718306.55360725289]
["Cl Bal",{"$f":"SUM(B8:B9,B11)","v":11720148.994062999},{"$f":"SUM(C8:C9,C11)","v":18228038.239193495},{"$f":"SUM(D8:D9,D11)","v":26339691.544354424},{"$f":"SUM(E8:E9,E11)","v":26543083.713500071},{"$f":"SUM(F8:F9,F11)","v":25824777.15989282},{"$f":"SUM(G8:G9,G11)","v":25106470.606285568},24388164.052678317,23669857.499071065]
[]
[]
["Payment Received 31st Dec",null,2019,"Removal of infill from opening TRV in year",null,null,null,{"$f":"C15+1","v":2020}]
[]
[]
["£Sep 2014",2016,{"$f":"B18+1","v":2017},{"$f":"C18+1","v":2018},{"$f":"D18+1","v":2019},{"$f":"E18+1","v":2020},{"$f":"F18+1","v":2021},{"$f":"G18+1","v":2022},{"$f":"H18+1","v":2023}]
["Bulk Mains",11436406.047856059,5845774.765934241,6505138.5140217114,0,0,0,0,0]
["'Other' Mains",584259.58708035096,1137205.6299672034,2301778.8766776514,921698.72275290021,0,0,0,0]
[null,{"$f":"SUM(B19:B20)","v":12020665.634936409},{"$f":"SUM(C19:C20)","v":6982980.3959014444},8806917.3906993624,921698.72275290021,0,0,0,0]
[null,{"$f":"B21","v":12020665.634936409},{"$f":"B22+C21","v":19003646.030837853},{"$f":"C22+D21","v":27810563.421537213},{"$f":"D22+E21","v":28732262.144290112},{"$f":"E22+F21","v":28732262.144290112}]

{"sheet":"Pi's Calc","index":4,"n_rows":93,"n_cols":33,"rows_kept":93,"cut":false,"hidden":false,"merged":[[25,0,25,32],[1,3,1,4],[0,0,1,2],[54,0,54,32],[60,0,60,32],[36,0,36,32],[40,0,40,32],[44,0,44,32],[52,0,52,32],[9,9,9,32]]}
["PNGL 'P' Tariff Model - Calculation of Pi tariffs, Allowed Revenues, PA and TRV"]
[null,null,null,"Return"]
[null,null,null,"GD17",4.2599999999999999E-2]
["p","Sep £2014",null,"Post GD17",{"$f":"E3","v":4.2599999999999999E-2}]
[null,"£'000"]
["Real Return pa",null,null,{"$f":"E3","v":4.2599999999999999E-2},{"$f":"D6","v":4.2599999999999999E-2},{"$f":"E6","v":4.2599999999999999E-2},{"$f":"E4","v":4.2599999999999999E-2},{"$f":"G6","v":4.2599999999999999E-2},{"$f":"H6","v":4.2599999999999999E-2},4.2599999999999999E-2,4.2599999999999999E-2,4.2599999999999999E-2,4.2599999999999999E-2,4.2599999999999999E-2,4.2599999999999999E-2,4.2599999999999999E-2,4.2599999999999999E-2,4.2599999999999999E-2,4.2599999999999999E-2,4.2599999999999999E-2,4.2599999999999999E-2,4.2599999999999999E-2,4.2599999999999999E-2,4.2599999999999999E-2,4.2599999999999999E-2,{"$f":"Y6","v":4.2599999999999999E-2},4.2599999999999999E-2,4.2599999999999999E-2,4.2599999999999999E-2,4.2599999999999999E-2,4.2599999999999999E-2,4.2599999999999999E-2,4.2599999999999999E-2]
["Discount Factor (Yr End)",null,1,{"$f":"C7/(1+D6)","v":0.95914061001342799},0.91995070977693072,0.88236208495773139,0.8463093084190787,0.81172962633711754,0.77856284897095485,0.746751245895794,0.71623944551677921,0.68697433868864299,0.65890498627339633,0.63198253047515474,0.6061601097977698,0.58139277747723939,0.55763742324692056,0.53485269829936755,0.51299894331418339,0.4920381194266098,0.47193374201669847,0.45265081720381595,0.4341557809359447,0.41641644056775823,0.39940191882578002,0.3830826000630923,0.36743007871004441,0.35241710983123387,0.33801756170269892,0.32420637032677818,0.31095949580546539,0.29825388049632207,0.28606740887811438]
[]
[]
[null,null,null,null,null,null,null,null,null,"IMPORTANT NOTE:  Values from 2023 Onwards are forecasts and will be determined as part of the Next Price Control.  This Model is re-run at each Price Control Period, to calculate allowed Revenues."]
[null,null,2016,2017,{"$f":"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":"Inputs!J86/1000","v":10467.716038769446},{"$f":"Inputs!K86/1000","v":10926.630396194187},{"$f":"Inputs!L86/1000","v":15615.35056307828},{"$f":"Inputs!M86/1000","v":18200.456827731505},{"$f":"Inputs!N86/1000","v":16827.78619193425},{"$f":"Inputs!O86/1000","v":16189.089260862118},{"$f":"Inputs!P86/1000","v":11590.088496898532},{"$f":"Inputs!Q86/1000","v":10775.872820391312},{"$f":"Inputs!R86/1000","v":13925.312464468927},{"$f":"Inputs!S86/1000","v":10981.730570438323},{"$f":"Inputs!T86/1000","v":9404.6616856350138},{"$f":"Inputs!U86/1000","v":8602.4197464944591},{"$f":"Inputs!V86/1000","v":8315.5394221774186},{"$f":"Inputs!W86/1000","v":8025.0339593442195},{"$f":"Inputs!X86/1000","v":8079.3790244250667},{"$f":"Inputs!Y86/1000","v":7947.2613198863291},{"$f":"Inputs!Z86/1000","v":7956.984007126016},{"$f":"Inputs!AA86/1000","v":7670.8848038216383},{"$f":"Inputs!AB86/1000","v":7888.9285984760754},{"$f":"Inputs!AC86/1000","v":7757.0152085118507},{"$f":"Inputs!AD86/1000","v":7470.3488742942},{"$f":"Inputs!AE86/1000","v":8219.2881245979224},{"$f":"Inputs!AF86/1000","v":8669.495420489051},{"$f":"Inputs!AG86/1000","v":9434.9649103542779},{"$f":"Inputs!AH86/1000","v":9848.1073095612392},{"$f":"Inputs!AI86/1000","v":10173.591324053048},{"$f":"Inputs!AJ86/1000","v":9770.6737936010359},{"$f":"Inputs!AK86/1000","v":9139.1345979495327},{"$f":"Inputs!AL86/1000","v":9072.34832875553},{"$f":"Inputs!AM86/1000","v":9072.34832875553}]
["Opex",null,null,{"$f":"Inputs!J91/1000","v":14736.830280561411},{"$f":"Inputs!K91/1000","v":14421.528100443158},{"$f":"Inputs!L91/1000","v":14331.291412166816},{"$f":"Inputs!M91/1000","v":14280.968553134473},{"$f":"Inputs!N91/1000","v":14179.296501504899},{"$f":"Inputs!O91/1000","v":14286.369017291398},{"$f":"Inputs!P91/1000","v":14432.59976578846},{"$f":"Inputs!Q91/1000","v":14550.302627140456},{"$f":"Inputs!R91/1000","v":14665.328427149208},{"$f":"Inputs!S91/1000","v":14774.125588004295},{"$f":"Inputs!T91/1000","v":14873.445655224594},{"$f":"Inputs!U91/1000","v":14967.418337590816},{"$f":"Inputs!V91/1000","v":15010.181888621863},{"$f":"Inputs!W91/1000","v":15043.271453182773},{"$f":"Inputs!X91/1000","v":15066.778788644533},{"$f":"Inputs!Y91/1000","v":15080.897445392126},{"$f":"Inputs!Z91/1000","v":15085.815796002124},{"$f":"Inputs!AA91/1000","v":15087.137726346185},{"$f":"Inputs!AB91/1000","v":15170.925195728902},{"$f":"Inputs!AC91/1000","v":15253.570548072374},{"$f":"Inputs!AD91/1000","v":15334.861461720438},{"$f":"Inputs!AE91/1000","v":15414.915855432393},{"$f":"Inputs!AF91/1000","v":15493.624499429821},{"$f":"Inputs!AG91/1000","v":15571.105024392074},{"$f":"Inputs!AH91/1000","v":15647.248412878675},{"$f":"Inputs!AI91/1000","v":15721.957091974395},{"$f":"Inputs!AJ91/1000","v":15795.235780403449},{"$f":"Inputs!AK91/1000","v":15867.303622526553},{"$f":"Inputs!AL91/1000","v":15933.47773254501},{"$f":"Inputs!AM91/1000","v":16014.827805745712}]
["Volumes (therms '000)",null,null,{"$f":"SUM(D16:D19)","v":148881.42391276691},{"$f":"SUM(E16:E19)","v":152496.33281425753},156152.59010530665,159871.46535288417,163620.24636886132,167330.94075551964,169256.29406620644,170468.60805001765,170981.61529413838,172175.56962108286,172828.51712014255,173337.44376833504,173713.02766967751,173957.99224895163,174084.3069124762,174092.68734007783,173985.45908377884,173765.09019897488,173472.03912903066,173145.34122749831,172783.51812073379,172383.94243367272,171941.40176055202,171452.17113771112,170916.76883649855,170337.62089227661,169720.35177351392,169299.3388194404,168615.25412178625,167452.61318993475]
["V Dom/Very Small IC Tariff (<2,500 tpa) (P1)",null,null,{"$f":"Inputs!J105/1000","v":78884.98276943191},{"$f":"Inputs!K105/1000","v":82121.076882275433},{"$f":"Inputs!L105/1000","v":85375.121507752905},{"$f":"Inputs!M105/1000","v":88664.904915517487},{"$f":"Inputs!N105/1000","v":91966.156821927711},{"$f":"Inputs!O105/1000","v":95217.090983929083},{"$f":"Inputs!P105/1000","v":97358.392704882863},{"$f":"Inputs!Q105/1000","v":98897.339066560409},{"$f":"Inputs!R105/1000","v":99750.607269552769},{"$f":"Inputs!S105/1000","v":101408.4939308508},{"$f":"Inputs!T105/1000","v":102550.34906418379},{"$f":"Inputs!U105/1000","v":103556.37828693038},{"$f":"Inputs!V105/1000","v":104435.5565140843},{"$f":"Inputs!W105/1000","v":105186.57879657508},{"$f":"Inputs!X105/1000","v":105819.50667178944},{"$f":"Inputs!Y105/1000","v":106335.95099857185},{"$f":"Inputs!Z105/1000","v":106738.7309014752},{"$f":"Inputs!AA105/1000","v":107030.31443589514},{"$f":"Inputs!AB105/1000","v":107251.16004519633},{"$f":"Inputs!AC105/1000","v":107440.30308293103},{"$f":"Inputs!AD105/1000","v":107597.01729341579},{"$f":"Inputs!AE105/1000","v":107719.33531384905},{"$f":"Inputs!AF105/1000","v":107804.24100387035},{"$f":"Inputs!AG105/1000","v":107849.49283043067},{"$f":"Inputs!AH105/1000","v":107855.54169381535},{"$f":"Inputs!AI105/1000","v":107824.02217341536},{"$f":"Inputs!AJ105/1000","v":107757.83057047793},{"$f":"Inputs!AK105/1000","v":107889.39126296433},{"$f":"Inputs!AL105/1000","v":107759.37634260472},{"$f":"Inputs!AM105/1000","v":107152.30131878234}]
["V Small/Med Tariff IC (2,500 - 25k tpa) (P2)",null,null,{"$f":"Inputs!J106/1000","v":21631.048867182981},{"$f":"Inputs!K106/1000","v":21884.86365583009},{"$f":"Inputs!L106/1000","v":22162.076321401739},{"$f":"Inputs!M106/1000","v":22466.16816121466},{"$f":"Inputs!N106/1000","v":22788.697270781602},{"$f":"Inputs!O106/1000","v":23123.457495438535},{"$f":"Inputs!P106/1000","v":23191.804020806168},{"$f":"Inputs!Q106/1000","v":23151.549911907787},{"$f":"Inputs!R106/1000","v":23099.75055533741},{"$f":"Inputs!S106/1000","v":23047.19648995177},{"$f":"Inputs!T106/1000","v":22969.667124646439},{"$f":"Inputs!U106/1000","v":22883.942819060267},{"$f":"Inputs!V106/1000","v":22791.726762216749},{"$f":"Inputs!W106/1000","v":22697.047327968037},{"$f":"Inputs!X106/1000","v":22601.812385246147},{"$f":"Inputs!Y106/1000","v":22505.126755033303},{"$f":"Inputs!Z106/1000","v":22406.496864798904},{"$f":"Inputs!AA106/1000","v":22305.92271454294},{"$f":"Inputs!AB106/1000","v":22203.404304265423},{"$f":"Inputs!AC106/1000","v":22098.941633966344},{"$f":"Inputs!AD106/1000","v":21991.782585684992},{"$f":"Inputs!AE106/1000","v":21881.267147158571},{"$f":"Inputs!AF106/1000","v":21765.199052984543},{"$f":"Inputs!AG106/1000","v":21642.094872551243},{"$f":"Inputs!AH106/1000","v":21512.021976921911},{"$f":"Inputs!AI106/1000","v":21375.771822067923},{"$f":"Inputs!AJ106/1000","v":21236.072575210565},{"$f":"Inputs!AK106/1000","v":21094.877197618593},{"$f":"Inputs!AL106/1000","v":20952.185689292008},{"$f":"Inputs!AM106/1000","v":20807.99805023081}]
["V Large Tariff (25k tpa - 75k tpa) (P3)",null,null,{"$f":"Inputs!J107/1000","v":29597.833398214756},{"$f":"Inputs!K107/1000","v":29722.833398214756},{"$f":"Inputs!L107/1000","v":29847.833398214752},{"$f":"Inputs!M107/1000","v":29972.833398214752},{"$f":"Inputs!N107/1000","v":30097.833398214752},{"$f":"Inputs!O107/1000","v":30222.833398214752},{"$f":"Inputs!P107/1000","v":30094.934786562961},{"$f":"Inputs!Q107/1000","v":29964.952841577833},{"$f":"Inputs!R107/1000","v":29832.887563259377},{"$f":"Inputs!S107/1000","v":29577.905618274257},{"$f":"Inputs!T107/1000","v":29322.923673289133},{"$f":"Inputs!U107/1000","v":29067.941728304006},{"$f":"Inputs!V107/1000","v":28812.959783318885},{"$f":"Inputs!W107/1000","v":28557.977838333762},{"$f":"Inputs!X107/1000","v":28302.995893348641},{"$f":"Inputs!Y107/1000","v":28048.013948363518},{"$f":"Inputs!Z107/1000","v":27793.032003378394},{"$f":"Inputs!AA107/1000","v":27538.050058393274},{"$f":"Inputs!AB107/1000","v":27283.068113408153},{"$f":"Inputs!AC107/1000","v":27028.086168423026},{"$f":"Inputs!AD107/1000","v":26773.104223437902},{"$f":"Inputs!AE107/1000","v":26518.122278452782},{"$f":"Inputs!AF107/1000","v":26263.140333467658},{"$f":"Inputs!AG107/1000","v":26008.158388482534},{"$f":"Inputs!AH107/1000","v":25753.17644349741},{"$f":"Inputs!AI107/1000","v":25498.19449851229},{"$f":"Inputs!AJ107/1000","v":25243.212553527166},{"$f":"Inputs!AK107/1000","v":24988.230608542039},{"$f":"Inputs!AL107/1000","v":24733.248663556918},{"$f":"Inputs!AM107/1000","v":24478.266718571798}]
["V Contract IC (>75k tpa) (P4)",null,null,{"$f":"Inputs!J108/1000","v":18767.558877937256},{"$f":"Inputs!K108/1000","v":18767.558877937256},{"$f":"Inputs!L108/1000","v":18767.558877937256},{"$f":"Inputs!M108/1000","v":18767.558877937256},{"$f":"Inputs!N108/1000","v":18767.558877937256},{"$f":"Inputs!O108/1000","v":18767.558877937256},{"$f":"Inputs!P108/1000","v":18611.162553954448},{"$f":"Inputs!Q108/1000","v":18454.766229971636},{"$f":"Inputs!R108/1000","v":18298.369905988824},{"$f":"Inputs!S108/1000","v":18141.973582006016},{"$f":"Inputs!T108/1000","v":17985.577258023208},{"$f":"Inputs!U108/1000","v":17829.180934040392},{"$f":"Inputs!V108/1000","v":17672.784610057584},{"$f":"Inputs!W108/1000","v":17516.388286074773},{"$f":"Inputs!X108/1000","v":17359.991962091965},{"$f":"Inputs!Y108/1000","v":17203.595638109153},{"$f":"Inputs!Z108/1000","v":17047.199314126341},{"$f":"Inputs!AA108/1000","v":16890.802990143533},{"$f":"Inputs!AB108/1000","v":16734.406666160721},{"$f":"Inputs!AC108/1000","v":16578.010342177909},{"$f":"Inputs!AD108/1000","v":16421.614018195101},{"$f":"Inputs!AE108/1000","v":16265.21769421229},{"$f":"Inputs!AF108/1000","v":16108.821370229482},{"$f":"Inputs!AG108/1000","v":15952.425046246668},{"$f":"Inputs!AH108/1000","v":15796.028722263858},{"$f":"Inputs!AI108/1000","v":15639.632398281048},{"$f":"Inputs!AJ108/1000","v":15483.236074298236},{"$f":"Inputs!AK108/1000","v":15326.839750315426},{"$f":"Inputs!AL108/1000","v":15170.443426332617},{"$f":"Inputs!AM108/1000","v":15014.047102349807}]
["£/therm",null,null,0.36809798200903682]
["P Dom/Very Small IC Tariff (<2,500 tpa) (P1)",null,1,0.39507148963518945,{"$f":"D21","v":0.39507148963518945},{"$f":"E21","v":0.39507148963518945},0.39507148963518945,0.39507148963518945,0.39507148963518945,0.39507148963518945,0.39507148963518945,0.39507148963518945,0.39507148963518945,0.39507148963518945,0.39507148963518945,0.39507148963518945,0.39507148963518945,0.39507148963518945,0.39507148963518945,0.39507148963518945,0.39507148963518945,0.39507148963518945,0.39507148963518945,0.39507148963518945,0.39507148963518945,0.39507148963518945,0.39507148963518945,0.39507148963518945,0.39507148963518945,0.39507148963518945,0.39507148963518945,0.39507148963518945,0.39507148963518945]
["P Small/Med Tariff IC (2,500 - 25k tpa) (P2)",null,0.9,{"$f":"$D$21*C22","v":0.35556434067167053},{"$f":"D22","v":0.35556434067167053},0.35556434067167053,0.35556434067167053,0.35556434067167053,0.35556434067167053,0.35556434067167053,0.35556434067167053,0.35556434067167053,0.35556434067167053,0.35556434067167053,0.35556434067167053,0.35556434067167053,0.35556434067167053,0.35556434067167053,0.35556434067167053,0.35556434067167053,0.35556434067167053,0.35556434067167053,0.35556434067167053,0.35556434067167053,0.35556434067167053,0.35556434067167053,0.35556434067167053,0.35556434067167053,0.35556434067167053,0.35556434067167053,0.35556434067167053,0.35556434067167053,0.35556434067167053]
["P Large Tariff (25k tpa - 75k tpa) (P3)",null,0.84779769349637712,{"$f":"$D$21*C23","v":0.33494069767889151},{"$f":"D23","v":0.33494069767889151},0.33494069767889151,0.33494069767889151,0.33494069767889151,0.33494069767889151,0.33494069767889151,0.33494069767889151,0.33494069767889151,0.33494069767889151,0.33494069767889151,0.33494069767889151,0.33494069767889151,0.33494069767889151,0.33494069767889151,0.33494069767889151,0.33494069767889151,0.33494069767889151,0.33494069767889151,0.33494069767889151,0.33494069767889151,0.33494069767889151,0.33494069767889151,0.33494069767889151,0.33494069767889151,0.33494069767889151,0.33494069767889151,0.33494069767889151,0.33494069767889151,0.33494069767889151]
["P Contract IC (>75k tpa) (P4)",null,0.42649945316995669,{"$f":"$D$21*C24","v":0.16849777429244853},{"$f":"D24","v":0.16849777429244853},0.16849777429244853,0.16849777429244853,0.16849777429244853,0.16849777429244853,0.16849777429244853,0.16849777429244853,0.16849777429244853,0.16849777429244853,0.16849777429244853,0.16849777429244853,0.16849777429244853,0.16849777429244853,0.16849777429244853,0.16849777429244853,0.16849777429244853,0.16849777429244853,0.16849777429244853,0.16849777429244853,0.16849777429244853,0.16849777429244853,0.16849777429244853,0.16849777429244853,0.16849777429244853,0.16849777429244853,0.16849777429244853,0.16849777429244853,0.16849777429244853,0.16849777429244853]
[]
["Conditions 2.3.15 and 2.3.16 Establishing Best Available Revenue Per Therm and Calculating Cashflow"]
[]
["Allowed Revenue",null,null,{"$f":"SUMPRODUCT(D16:D19,D21:D24)","v":51932.248149078878},{"$f":"SUMPRODUCT(E16:E19,E21:E24)","v":53342.851746027525},54768.866529423976,56218.557962643237,57679.33590837018,59124.583696231093,59925.661661398801,60449.453891448022,60697.551358438628,61222.092496708035,61533.883964476539,61789.100658880823,61991.893906238976,62143.180504470554,62247.61385029785,62305.512054386905,62317.813375682876,62285.492872507413,62224.534522348928,62150.360080483755,62062.415197670343,61959.687948130988,61840.205827140737,61702.555813871491,61546.940000918308,61374.28557751677,61186.70682869431,61076.722403065498,60862.864939679188,60460.002659834099]
["Capex",null,null,{"$f":"-D13","v":-10467.716038769446},-10926.630396194187,-15615.35056307828,-18200.456827731505,-16827.78619193425,-16189.089260862118,-11590.088496898532,-10775.872820391312,-13925.312464468927,-10981.730570438323,-9404.6616856350138,-8602.4197464944591,-8315.5394221774186,-8025.0339593442195,-8079.3790244250667,-7947.2613198863291,-7956.984007126016,-7670.8848038216383,-7888.9285984760754,-7757.0152085118507,-7470.3488742942,-8219.2881245979224,{"$f":"-Z13","v":-8669.495420489051},-9434.9649103542779,-9848.1073095612392,-10173.591324053048,-9770.6737936010359,-9139.1345979495327,-9072.34832875553,-9072.34832875553]
["Opex",null,null,{"$f":"-D14","v":-14736.830280561411},-14421.528100443158,-14331.291412166816,-14280.968553134473,-14179.296501504899,-14286.369017291398,-14432.59976578846,-14550.302627140456,-14665.328427149208,-14774.125588004295,-14873.445655224594,-14967.418337590816,-15010.181888621863,-15043.271453182773,-15066.778788644533,-15080.897445392126,-15085.815796002124,-15087.137726346185,-15170.925195728902,-15253.570548072374,-15334.861461720438,-15414.915855432393,{"$f":"-Z14","v":-15493.624499429821},-15571.105024392074,-15647.248412878675,-15721.957091974395,-15795.235780403449,-15867.303622526553,-15933.47773254501,-16014.827805745712]
["Capex Creditor",null,null,{"$f":"-(Inputs!J118-Inputs!I118)/1000","v":-436.65167713738049},{"$f":"-(Inputs!K118-Inputs!J118)/1000","v":76.485726237456319},{"$f":"-(Inputs!L118-Inputs!K118)/1000","v":781.4533611473488},{"$f":"-(Inputs!M118-Inputs!L118)/1000","v":430.85104410887044},{"$f":"-(Inputs!N118-Inputs!M118)/1000","v":-228.77843929954247},{"$f":"-(Inputs!O118-Inputs!N118)/1000","v":-106.44948851202243},{"$f":"-(Inputs!P118-Inputs!O118)/1000","v":-766.50012732726429},{"$f":"-(Inputs!Q118-Inputs!P118)/1000","v":-135.70261275120359},{"$f":"-(Inputs!R118-Inputs!Q118)/1000","v":524.90660734626931},{"$f":"-(Inputs!S118-Inputs!R118)/1000","v":-490.59698233843409},{"$f":"-(Inputs!T118-Inputs!S118)/1000","v":-262.84481413388534},{"$f":"-(Inputs!U118-Inputs!T118)/1000","v":-133.70698985675909},{"$f":"-(Inputs!V118-Inputs!U118)/1000","v":-47.813387386173012},{"$f":"-(Inputs!W118-Inputs!V118)/1000","v":-48.417577138866299},{"$f":"-(Inputs!X118-Inputs!W118)/1000","v":9.057510846807622},{"$f":"-(Inputs!Y118-Inputs!X118)/1000","v":-22.019617423122749},{"$f":"-(Inputs!Z118-Inputs!Y118)/1000","v":1.620447873281315},{"$f":"-(Inputs!AA118-Inputs!Z118)/1000","v":-47.68320055072941},{"$f":"-(Inputs!AB118-Inputs!AA118)/1000","v":36.340632442406381},{"$f":"-(Inputs!AC118-Inputs!AB118)/1000","v":-21.985564994037151},{"$f":"-(Inputs!AD118-Inputs!AC118)/1000","v":-47.777722369608469},{"$f":"-(Inputs!AE118-Inputs!AD118)/1000","v":124.82320838395412},{"$f":"-(Inputs!AF118-Inputs!AE118)/1000","v":75.034549315188073},{"$f":"-(Inputs!AG118-Inputs!AF118)/1000","v":127.57824831087142},{"$f":"-(Inputs!AH118-Inputs!AG118)/1000","v":68.857066534494052},{"$f":"-(Inputs!AI118-Inputs!AH118)/1000","v":54.247335748634299},{"$f":"-(Inputs!AJ118-Inputs!AI118)/1000","v":-67.152921742001553},{"$f":"-(Inputs!AK118-Inputs!AJ118)/1000","v":-105.25653260858357},{"$f":"-(Inputs!AL118-Inputs!AK118)/1000","v":-11.131044865666889},{"$f":"-(Inputs!AM118-Inputs!AL118)/1000","v":0}]
["Working Capital Adjustment",null,null,{"$f":"-(Inputs!J116-Inputs!I116)/1000","v":-395.26835890012512},{"$f":"-(Inputs!K116-Inputs!J116)/1000","v":-249.42680115648733},{"$f":"-(Inputs!L116-Inputs!K116)/1000","v":-224.73062010262859},{"$f":"-(Inputs!M116-Inputs!L116)/1000","v":-223.49245806677035},{"$f":"-(Inputs!N116-Inputs!M116)/1000","v":-231.31733805458992},{"$f":"-(Inputs!O116-Inputs!N116)/1000","v":-203.93846628475725},{"$f":"-(Inputs!P116-Inputs!O116)/1000","v":-102.61400495550852},{"$f":"-(Inputs!Q116-Inputs!P116)/1000","v":-64.444491145143516},{"$f":"-(Inputs!R116-Inputs!Q116)/1000","v":-23.411524047540734},{"$f":"-(Inputs!S116-Inputs!R116)/1000","v":-65.625511437800711},{"$f":"-(Inputs!T116-Inputs!S116)/1000","v":-34.850312098839787},{"$f":"-(Inputs!U116-Inputs!T116)/1000","v":-27.00578227669606},{"$f":"-(Inputs!V116-Inputs!U116)/1000","v":-25.28736097999732},{"$f":"-(Inputs!W116-Inputs!V116)/1000","v":-18.722241987427463},{"$f":"-(Inputs!X116-Inputs!W116)/1000","v":-12.844121618683218},{"$f":"-(Inputs!Y116-Inputs!X116)/1000","v":-6.9904918036472514},{"$f":"-(Inputs!Z116-Inputs!Y116)/1000","v":-1.2549961211958434},{"$f":"-(Inputs!AA116-Inputs!Z116)/1000","v":5.0067071176066529},{"$f":"-(Inputs!AB116-Inputs!AA116)/1000","v":19.198248849698807},{"$f":"-(Inputs!AC116-Inputs!AB116)/1000","v":21.043608560992404},{"$f":"-(Inputs!AD116-Inputs!AC116)/1000","v":22.946642059779492},{"$f":"-(Inputs!AE116-Inputs!AD116)/1000","v":25.015614676337687},{"$f":"-(Inputs!AF116-Inputs!AE116)/1000","v":27.36735542822932},{"$f":"-(Inputs!AG116-Inputs!AF116)/1000","v":29.945164985856973},{"$f":"-(Inputs!AH116-Inputs!AG116)/1000","v":32.479578561369564},{"$f":"-(Inputs!AI116-Inputs!AH116)/1000","v":34.863205001717198},{"$f":"-(Inputs!AJ116-Inputs!AI116)/1000","v":36.93025493485527},{"$f":"-(Inputs!AK116-Inputs!AJ116)/1000","v":25.145804899094394},{"$f":"-(Inputs!AL116-Inputs!AK116)/1000","v":40.019512710161507},{"$f":"-(Inputs!AM116-Inputs!AL116)/1000","v":70.191350760847328}]
["Allowed Capex Overspend",null,null,{"$f":"-'Opening Values'!H29","v":0},{"$f":"-'Opening Values'!I29","v":0},{"$f":"-'Opening Values'!J29","v":-113.68071865913447},{"$f":"-'Opening Values'!K29","v":-764.1822918216468},{"$f":"-'Opening Values'!L29","v":-1364.1394350235439}]
[]
["Cashflows",null,null,{"$f":"SUM(D28:D34)","v":25895.781793710517},{"$f":"SUM(E28:E34)","v":27821.752174471145},25265.266576564463,23180.308875997711,24848.018002553355,28338.737463280799,33033.859266429034,34923.1313400199,32608.40555011922,34910.013844489178,36958.081497384199,38058.549802662092,38593.071847073523,39007.735272817263,39097.669426456385,39248.343179881675,39275.379024306814,39484.793848906469,39220.219609436055,39138.832367466486,39232.373781345879,38475.322791160965,37779.487811965279,36854.00929242187,36152.92092357426,35567.847702239684,35590.574587882686,35990.173454879929,35885.927346223143,35443.017876093705]
[]
[]
[]
["Discounted Cashflow",null,{"$f":"SUM(D39:AG39)","v":562082.15253446833},{"$f":"D35*D7","v":24837.695946394128},25594.640660142595,22293.113293510305,19617.711173786254,20169.872368430606,22063.48817565183,24668.075563952199,25013.324226685509,22401.137838484228,23002.382193007219,23356.861866223862,23069.574727125542,22437.73323254873,{"$f":"Q35*Q7","v":21752.172984231831},20911.493989956882,20134.358578111736,19324.983634887241,18634.206513872348,17753.064457124357,16992.350331418442,16337.005445051893,15367.117750230957,14472.664420059566,13541.271535095275,12740.907903843183,12022.557155324001,11538.691004981914,11191.486191480708,10703.117086220132,10139.092286634816]
[]
[]
[]
["Closing DAV",null,null,{"$f":"DAV!J37","v":421863.71823555324},{"$f":"DAV!K37","v":426373.06309668178},{"$f":"DAV!L37","v":427188.81435230974},{"$f":"DAV!M37","v":400858.09137368324},{"$f":"DAV!N37","v":401760.12974876619},{"$f":"DAV!O37","v":400018.72915457987},{"$f":"DAV!P37","v":393148.94107238448},{"$f":"DAV!Q37","v":384980.32383886771},{"$f":"DAV!R37","v":379399.14886692545},{"$f":"DAV!S37","v":370418.48918069724},{"$f":"DAV!T37","v":359601.79515999195},{"$f":"DAV!U37","v":347777.97539100959},{"$f":"DAV!V37","v":335485.03805928922},{"$f":"DAV!W37","v":322714.56823255139},{"$f":"DAV!X37","v":309790.12263653491},{"$f":"DAV!Y37","v":296590.7836588723},{"$f":"DAV!Z37","v":283289.7037710658},{"$f":"DAV!AA37","v":269625.92157589609},{"$f":"DAV!AB37","v":256126.51014220767},{"$f":"DAV!AC37","v":242472.70011142717},{"$f":"DAV!AD37","v":228572.63672960337},{"$f":"DAV!AE37","v":215444.73009853536},{"$f":"DAV!AF37","v":202692.2972878369},{"$f":"DAV!AG37","v":190595.09552679796},{"$f":"DAV!AH37","v":178693.45651540573},{"$f":"DAV!AI37","v":166873.87465938987},{"$f":"DAV!AJ37","v":154394.16313831086},{"$f":"DAV!AK37","v":141095.94112085659},{"$f":"DAV!AL37","v":127510.2084722601},{"$f":"DAV!AM37","v":125788.92208400118}]
[]
[]
[]
["TRV",null,{"$f":"-'Opening Values'!D20","v":-595825.23625397123}]
["Discounted DAV2046",null,{"$f":"AG43*AG7","v":35984.11100614124}]
["Discounted Capital Creditors (CC2046)",null,{"$f":"Inputs!AM118/1000*'Pi''s Calc'!AG7","v":-1646.7572466205363}]
["Discounted Working Capital Adjustment (Q2046)",null,{"$f":"Inputs!AM116/1000*'Pi''s Calc'!AG7","v":-594.27004001770297}]
["Backsolve to 0 by running Macro Ctrl + q",null,{"$f":"SUM(C39:C50)","v":9.9134922493249178E-11}]
[]
[]
[]
["Condition 2.3.18 Calculating TRV"]
[]
[null,"Total Regulatory Value (TRV)",null,null,null,null,null,null,{"$f":"I67+I69+I71+I73","v":592436.07018457027},null,null,null,null,{"$f":"N67+N69+N71+N73","v":542431.02683544718},null,null,null,null,{"$f":"S67+S69+S71+S73","v":457119.06913638324},null,null,null,null,{"$f":"X67+X69+X71+X73","v":349313.75152971328},null,null,null,null,{"$f":"AC67+AC69+AC71+AC73","v":228732.11054289193},null,null,null,{"$f":"AG67+AG69+AG71+AG73","v":117955.00875767355}]
[]
[]
[]
["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":"D35*(1+$I$6)^($I$11-D11)","v":31901.979370352317},32874.212652159869,28633.672057401207,25197.33788956852,25906.543569462126,28338.737463280799,{"$f":"J35*(1+$N$6)^($N$11-J11)","v":39032.844065176228},{"$f":"K35*(1+$N$6)^($N$11-K11)","v":39579.138695304267},{"$f":"L35*(1+$N$6)^($N$11-L11)","v":35445.818133045512},{"$f":"M35*(1+$N$6)^($N$11-M11)","v":36397.180434264417},{"$f":"N35*(1+$N$6)^($N$11-N11)","v":36958.081497384199},{"$f":"O35*(1+$S$6)^($S$11-O11)","v":44970.023871953112},{"$f":"P35*(1+$S$6)^($S$11-P11)","v":43738.361501471678},{"$f":"Q35*(1+$S$6)^($S$11-Q11)","v":42401.983995724993},{"$f":"R35*(1+$S$6)^($S$11-R11)","v":40763.230144023422},{"$f":"S35*(1+$S$6)^($S$11-S11)","v":39248.343179881675},{"$f":"T35*(1+$X$6)^($X$11-T11)","v":46407.83060471584},{"$f":"U35*(1+$X$6)^($X$11-U11)","v":44748.969297335512},{"$f":"V35*(1+$X$6)^($X$11-V11)","v":42632.957605898424},{"$f":"W35*(1+$X$6)^($X$11-W11)","v":40806.146626320558},{"$f":"X35*(1+$X$6)^($X$11-X11)","v":39232.373781345879},{"$f":"Y35*(1+$AC$6)^($AC$11-Y11)","v":45462.483288803211},{"$f":"Z35*(1+$AC$6)^($AC$11-Z11)","v":42816.309150200017},{"$f":"AA35*(1+$AC$6)^($AC$11-AA11)","v":40060.852066039726},{"$f":"AB35*(1+$AC$6)^($AC$11-AB11)","v":37693.035354918524},{"$f":"AC35*(1+$AC$6)^($AC$11-AC11)","v":35567.847702239684},{"$f":"AD35*(1+$AG$6)^($AG$11-AD11)","v":40335.566537389939},{"$f":"AE35*(1+$AG$6)^($AG$11-AE11)","v":39121.849760414676},{"$f":"AF35*(1+AG6)^(AG11-AF11)","v":37414.667851172249},{"$f":"AG35*(1+AG6)^(AG11-AG11)","v":35443.017876093705}]
[]
[null,"Closing TRV (Incl Return)",{"$f":"'Opening Values'!D20","v":595825.23625397123},null,null,null,null,null,{"$f":"-$C$65*(1+I6)^(I11-C11)","v":-765288.55318679509},null,null,null,null,{"$f":"-I57*(1+N6)^(N11-I11)","v":-729844.08966062183},null,null,null,null,{"$f":"-N57*(1+S6)^(S11-N11)","v":-668241.01182943815},null,null,null,null,{"$f":"-S57*(1+X6)^(X11-S11)","v":-563142.02944532945},null,null,null,null,{"$f":"-X57*(1+AC6)^(AC11-X11)","v":-430332.63810509315},null,null,null,{"$f":"-AC57*(1+AG6)^(AG11-AC11)","v":-270270.11078274413}]
[]
[null,"DAV",null,null,null,null,null,null,{"$f":"I43","v":400018.72915457987},null,null,null,null,{"$f":"N43","v":359601.79515999195},null,null,null,null,{"$f":"S43","v":296590.7836588723},null,null,null,null,{"$f":"X43","v":228572.63672960337},null,null,null,null,{"$f":"AC43","v":166873.87465938987},null,null,null,{"$f":"AG43","v":125788.92208400118}]
[]
[null,"CC",null,null,null,null,null,null,{"$f":"Inputs!O118/1000","v":-6942.6591705319724},null,null,null,null,{"$f":"Inputs!T118/1000","v":-5811.9212413274545},null,null,null,null,{"$f":"Inputs!Y118/1000","v":-5569.021180369341},null,null,null,null,{"$f":"Inputs!AD118/1000","v":-5489.5357727706532},null,null,null,null,{"$f":"Inputs!AI118/1000","v":-5940.076181063795},null,null,null,{"$f":"Inputs!AM118/1000","v":-5756.5356818475439}]
[]
[null,"Q",null,null,null,null,null,null,{"$f":"Inputs!O116/1000","v":-2070.2754344058944},null,null,null,null,{"$f":"Inputs!T116/1000","v":-1779.3295907210611},null,null,null,null,{"$f":"Inputs!Y116/1000","v":-1688.4795920546096},null,null,null,null,{"$f":"Inputs!AD116/1000","v":-1755.4198025214912},null,null,null,null,{"$f":"Inputs!AI116/1000","v":-1905.090721175002},null,null,null,{"$f":"Inputs!AM116/1000","v":-2077.3776444799605}]
[]
[null,"Calculated PA",null,null,null,null,null,null,{"$f":"-SUM(D63:I71)","v":201430.27563492826},null,null,null,null,{"$f":"-SUM(J63:N72)","v":190420.48250750374},null,null,null,null,{"$f":"-SUM(O63:S72)","v":167785.7862499349},null,null,null,null,{"$f":"-SUM(T63:X72)","v":127986.07037540205},null,null,null,null,{"$f":"-SUM(Y63:AC72)","v":69703.40278574088},null,null,null,{"$f":"-SUM(AD63:AG72)","v":-1.2641976354643703E-10}]
[null,"Check",null,null,null,null,null,null,{"$f":"SUM(D63:I73)","v":0},null,null,null,null,{"$f":"SUM(J63:N73)","v":0},null,null,null,null,{"$f":"SUM(O63:S73)","v":0},null,null,null,null,{"$f":"SUM(T63:X73)","v":0},null,null,null,null,{"$f":"SUM(Y63:AC73)","v":0},null,null,null,{"$f":"SUM(AD63:AG73)","v":0}]
[]
[]
[]
[]
[null,"ANNUAL BASIS"]
[null,"Cashflow",null,{"$f":"'Building Block'!C11","v":25895.781793710517},{"$f":"'Building Block'!D11","v":54820.694272593733},{"$f":"'Building Block'!E11","v":82421.3224251707},{"$f":"'Building Block'!F11","v":109112.77963648069},{"$f":"'Building Block'!G11","v":138609.00205154813},{"$f":"'Building Block'!H11","v":172852.48300222488}]
[null,"Opening TRV incl. return",null,{"$f":"-$C65/D$7","v":-621207.39131839038},-647670.82618855382,-675261.60338418616,-704027.74768835248,-734019.32973987632,-765288.55318679498]
[null,"DAV ",{"$f":"DAV!I37","v":407140.67554007727},{"$f":"+D43","v":421863.71823555324},426373.06309668178,427188.81435230974,400858.09137368324,401760.12974876619,400018.72915457987]
[null,"Q",{"$f":"Inputs!I116/1000","v":-3598.4494769712528},{"$f":"+Inputs!J116/1000","v":-3203.1811180711275},{"$f":"+Inputs!K116/1000","v":-2953.7543169146402},{"$f":"+Inputs!L116/1000","v":-2729.0236968120116},{"$f":"+Inputs!M116/1000","v":-2505.5312387452414},{"$f":"+Inputs!N116/1000","v":-2274.2139006906514},{"$f":"+Inputs!O116/1000","v":-2070.2754344058944}]
[null,"CC",{"$f":"Inputs!I118/1000","v":-6425.7486439872418},{"$f":"+Inputs!J118/1000","v":-5989.0969668498619},{"$f":"+Inputs!K118/1000","v":-6065.5826930873181},{"$f":"+Inputs!L118/1000","v":-6847.0360542346671},{"$f":"+Inputs!M118/1000","v":-7277.8870983435372},{"$f":"+Inputs!N118/1000","v":-7049.1086590439945},{"$f":"+Inputs!O118/1000","v":-6942.6591705319724}]
[null,"PA ",{"$f":"+C87-C82-C84-C83","v":198708.75883485246},{"$f":"-SUM(D80:D84)+D90","v":201643.81540488545},{"$f":"-SUM(E80:E84)+E90","v":203306.96925081749},203959.78850204253,{"$f":"-SUM(G80:G84)","v":203840.29501527728},202973.52049929669,201430.27563492802]
[]
[null,"TRV",{"$f":"+C65","v":595825.23625397123},{"$f":"SUM(D82:D85)","v":614315.25555551774},{"$f":"SUM(E82:E85)","v":620660.69533749728},621572.54310330562,594914.96805187175,595410.32768832822,592436.07018457004]
[]
[]
[null,"East Down Adjustment",null,{"$f":"'PDP Workings - FD'!C22/1000","v":19003.646030837852},{"$f":"'PDP Workings - FD'!D22/1000","v":27810.563421537212},{"$f":"'PDP Workings - FD'!E22/1000","v":28732.262144290111},{"$f":"'PDP Workings - FD'!F22/1000","v":28732.262144290111},{"$f":"Inputs!N83/1000","v":0},{"$f":"Inputs!O83/1000","v":0}]
[]
[]
[null,"PA movement",null,{"$f":"D85-C85","v":2935.0565700329898},{"$f":"E85-D85","v":1663.1538459320436},652.8192512250389,-119.49348676524824,-866.7745159805927,-1543.2448643686657]

{"sheet":"PNGL Financeability","index":5,"n_rows":65,"n_cols":31,"rows_kept":65,"cut":false,"hidden":false,"merged":[]}
["PNGL: GD17 Financeability "]
[]
[]
[null,null,null,null,null,null,null,2014,2015,2016,2017,2018,2019,2020,2021,2022,null,null,null,null,null,null,null,null,null,null,null,"Generic assumptions"]
[null,"Financeability analysis (nominal)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rolling incentive period",null,5]
[null,null,null,null,null,null,null,256,258.5,{"$f":"+'PNGL Financeability'!AD6","v":3.0700000000000002E-2},{"$f":"+'PNGL Financeability'!AD6","v":3.0700000000000002E-2},{"$f":"+K6","v":3.0700000000000002E-2},3.0700000000000002E-2,3.0700000000000002E-2,3.0700000000000002E-2,3.0700000000000002E-2,null,null,null,null,null,null,null,null,null,null,null,"Forward inflation rate",null,3.0700000000000002E-2]
[null,"RPI factor",null,null,null,null,null,1,{"$f":"+I6/H6","v":1.009765625},{"$f":"I7*(1+J6)","v":1.0407654296875},1.0727169283789062,1.1056493380801387,1.1395927727591988,1.1745782708829062,1.2106378237990114,1.2478044049896411,null,null,null,null,null,null,null,null,null,null,null,"Prospective tax rate",null,0.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year dividends can start",null,2017]
[null,"Revenues",null,null,null,null,null,null,null,null,{"$f":"+'Pi''s Calc'!D28*'PNGL Financeability'!K7","v":55708.601718291029},{"$f":"+'Pi''s Calc'!E28*'PNGL Financeability'!L7","v":58978.488724302304},{"$f":"+'Pi''s Calc'!F28*'PNGL Financeability'!M7","v":62414.204469144745},{"$f":"+'Pi''s Calc'!G28*'PNGL Financeability'!N7","v":66033.096603291939},{"$f":"+'Pi''s Calc'!H28*'PNGL Financeability'!O7","v":69828.785702281457},{"$f":"+'Pi''s Calc'!I28*'PNGL Financeability'!P7","v":73775.91597933587},"Revenues",52618183.633603677,55813248.547105826,59108458.443660133,62542587.290232971,66075856.50658229,69708040.096986696,null,null,null,null,"Maximum dividend payout 2017 on",null,5.28E-2]
[null,"Opex",null,null,null,null,null,null,null,null,{"$f":"+'Pi''s Calc'!D30*'PNGL Financeability'!K7","v":-15808.447312605091},{"$f":"+'Pi''s Calc'!E30*'PNGL Financeability'!L7","v":-15945.152998359097},{"$f":"+'Pi''s Calc'!F30*'PNGL Financeability'!M7","v":-16331.836117611276},{"$f":"+'Pi''s Calc'!G30*'PNGL Financeability'!N7","v":-16774.115349673848},{"$f":"+'Pi''s Calc'!H30*'PNGL Financeability'!O7","v":-17165.992659582829},{"$f":"+'Pi''s Calc'!I30*'PNGL Financeability'!P7","v":-17826.594191083735},"Opex",-15198105.888377802,-15691245.305462938,-16061569.195354868,-16441907.748255696,-16839177.414488085,-17384933.053161271,null,null,null,null,"CAs as % of core depreciation",null,0.8]
[null,"Movements in working capital",null,null,null,null,null,null,null,null,{"$f":"('Pi''s Calc'!D31+'Pi''s Calc'!D32)*K7","v":-892.41470571502202},{"$f":"('Pi''s Calc'!E31+'Pi''s Calc'!E32)*L7","v":-191.21218501109428},{"$f":"('Pi''s Calc'!F31+'Pi''s Calc'!F32)*M7","v":634.43721212525418},{"$f":"('Pi''s Calc'!G31+'Pi''s Calc'!G32)*N7","v":243.55888944605425},{"$f":"('Pi''s Calc'!H31+'Pi''s Calc'!H32)*O7","v":-557.00935063512134},{"$f":"('Pi''s Calc'!I31+'Pi''s Calc'!I32)*P7","v":-387.30345725114728},"Movements in working capital",-123521.32618173305,128927.00261285156,-134622.14949853485,47349.414479689673,-408370.15974652721,-125248.90400229534,null,null,null,null,"Threshold PMICR",null,1.4]
[null,"Core asset depreciation",null,null,null,null,null,null,null,null,{"$f":"-(DAV!J35)*K7","v":-15820.771857769292},{"$f":"-(DAV!K35)*L7","v":-16832.629887669773},{"$f":"-(DAV!L35)*M7","v":-18045.427338999085},{"$f":"-(DAV!M35)*N7","v":-19454.657304300352},{"$f":"-(DAV!N35)*O7","v":-20931.791476340029},{"$f":"-(DAV!O35)*P7","v":-22373.744224751485},"Core asset depreciation",-12359889.81598038,-13583851.105645219,-14655177.293613246,-14945911.780915707,-16201517.403052662,-17440823.088033963]
[null,"Unspent allowance depreciation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unspent allowance depreciation",-2190550.2762239994,-2258019.2247316986,-2327566.2168534347,-2399255.2563325204,-2473152.3182275617,-2549325.409628971]
[null,"Profile adjustment",null,null,null,null,null,null,null,null,{"$f":"'Pi''s Calc'!D93*'PNGL Financeability'!K7","v":3148.4848684241169},{"$f":"'Pi''s Calc'!E93*'PNGL Financeability'!L7","v":1838.8649488802009},{"$f":"'Pi''s Calc'!F93*'PNGL Financeability'!M7","v":743.94810061412602},{"$f":"'Pi''s Calc'!G93*'PNGL Financeability'!N7","v":-140.3544530664947},{"$f":"'Pi''s Calc'!H93*'PNGL Financeability'!O7","v":-1049.3500137511862},{"$f":"'Pi''s Calc'!I93*'PNGL Financeability'!P7","v":-1925.6677397368624},"Profile adjustment",5215157.8193943491,4835287.1246330058,4145457.8685146864,2566175.9661068004,1951071.9763472378,1340290.5498201724]
[null,"Tax (prior year)",null,null,null,null,null,null,null,null,{"$f":"-K44","v":0},{"$f":"-L44","v":0},0,0,-2408.9466738045967,-2725.3017138565165,"Tax (prior year)",0,0,0,0,-2708265.7873959164,-3055600.8339277329,null,null,null,null,"Outturn and financial assumptions",null,"PNGL"]
[null,"Post-maintenance FFO",null,null,null,null,null,null,null,null,{"$f":"SUM(K9:K15)","v":26335.452710625745},27848.358602142544,29415.326325273763,29907.528385697296,27715.695528167696,28537.304652656127,"Post-maintenance FFO",{"$f":"SUM(R9:R15)","v":27961274.146234114},29244347.038511835,30074981.456854727,31369037.88531553,29396445.400018774,30492399.358052634,null,null,null,null,"Initial debt as % of TRV",null,0.55000000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nominal interest rate",null,5.5E-2]
[null,"PMICR",null,null,null,null,null,null,null,null,{"$f":"K16/K46","v":1.4},1.4629965038751607,1.5101743167198247,1.5006402265941239,1.3937168854344812,1.4112507606483045,null,null,null,null,null,null,null,null,null,null,null,"Year tax payments start",null,2020,"note: to reflect approximate time when tax losses are fully utilised"]
[]
[null,"Maximum interest consistent with dividends",null,null,null,null,null,null,null,null,{"$f":"K16/'PNGL Financeability'!$AD$11","v":18811.03765044696},{"$f":"L16/'PNGL Financeability'!$AD$11","v":19891.684715816104},{"$f":"M16/'PNGL Financeability'!$AD$11","v":21010.947375195548},{"$f":"N16/'PNGL Financeability'!$AD$11","v":21362.520275498071},{"$f":"O16/'PNGL Financeability'!$AD$11","v":19796.92537726264},{"$f":"P16/'PNGL Financeability'!$AD$11","v":20383.789037611521}]
[null,"Implied maximum debt level (pre interest)",null,null,null,null,null,null,null,null,{"$f":"2*K20/IntPNGL-K39","v":332504.233236778},372018.71877881524,404127.28025384393,408953.44422981195,343102.15745844779,374994.98215364851]
[]
[null,"Tax"]
[null,"Revenues",null,null,null,null,null,null,null,null,{"$f":"K9","v":55708.601718291029},58978.488724302304,62414.204469144745,66033.096603291939,69828.785702281457,73775.91597933587,"Revenues",52618183.633603677,55813248.547105826,59108458.443660133,62542587.290232971,66075856.50658229,69708040.096986696]
[null,"Opex",null,null,null,null,null,null,null,null,{"$f":"+K10","v":-15808.447312605091},-15945.152998359097,-16331.836117611276,-16774.115349673848,-17165.992659582829,-17826.594191083735,"Opex",-15198105.888377802,-15691245.305462938,-16061569.195354868,-16441907.748255696,-16839177.414488085,-17384933.053161271]
[null,"Interest",null,null,null,null,null,null,null,null,{"$f":"-K46","v":-18811.03765044696},{"$f":"-L46","v":-19035.150479429223},-19478.099977998132,-19929.845845580112,-19886.173309529451,-20221.285577586917,"Interest",-19138481.632586747,-19652879.832854465,-20151782.695017923,-20602621.180265125,-20997461.000013411,-21375446.927634995]
[null,"Capital allowances",null,null,null,null,null,null,null,null,{"$f":"K12*'PNGL Financeability'!$AD$10","v":-12656.617486215435},{"$f":"L12*'PNGL Financeability'!$AD$10","v":-13466.103910135818},{"$f":"M12*'PNGL Financeability'!$AD$10","v":-14436.341871199269},{"$f":"N12*'PNGL Financeability'!$AD$10","v":-15563.725843440283},{"$f":"O12*'PNGL Financeability'!$AD$10","v":-16745.433181072025},{"$f":"P12*'PNGL Financeability'!$AD$10","v":-17898.995379801188},"Capital allowances",-9887911.8527843039,-10867080.884516176,-11724141.834890597,{"$f":"U12*0.8","v":-11956729.424732566},-12961213.922442131,-13952658.47042717]
[null,"Losses",null,null,null,null,null,null,null,null,{"$f":"IF(K4<TaxYearPNGL,-SUM(K24:K27),0)","v":-8432.4992690235467},-10532.081336378167,-12167.926502336069,0,0,0,"Losses",{"$f":"IF(K4<TaxYearPNGL,-SUM(R24:R27),0)","v":-8393684.2598548252},-9602042.5242722519,-11170964.718396742,0,0,0]
[null,"Taxable profits",null,null,null,null,null,null,null,null,{"$f":"SUM(K24:K28)","v":0},{"$f":"SUM(L24:L28)","v":0},0,13765.409564597696,16031.186552097155,17829.040830864029,"Taxable profits",0,0,0,13541328.936979581,15278004.169638664,16995001.645763259]
[null,"Tax payable",null,null,null,null,null,null,null,null,{"$f":"K29*K65","v":0},0,0,2408.9466738045967,2725.3017138565165,3030.936941246885,"Tax payable",0,0,0,2708265.7873959164,3055600.8339277329,3399000.3291526521]
[]
[null,"Dividends"]
[null,"Maximum dividend payout (% of initial equity)",null,null,null,null,null,null,null,null,{"$f":"+'PNGL Financeability'!AD9","v":5.28E-2}]
[null,"Allowed dividend in year",null,null,null,null,null,null,null,null,{"$f":"(+K51-K39)*K33","v":15186.247178691508},{"$f":"+K34*(1+L6)","v":15652.464967077338},{"$f":"+L34*(1+M6)","v":16132.995641566611},{"$f":"+M34*(1+N6)","v":16628.278607762706},{"$f":"+N34*(1+O6)","v":17138.766761021019},{"$f":"+O34*(1+P6)","v":17664.926900584363}]
[null,"Dividend available",null,null,null,null,null,null,null,null,{"$f":"K34+(J35-J36)*(1+'PNGL Financeability'!$AD$6)*(1+$K$33)","v":15186.247178691508},{"$f":"L34+(K35-K36)*(1+'PNGL Financeability'!$AD$6)*(1+$K$33)","v":20700.274632568617},{"$f":"M34+(L35-L36)*(1+'PNGL Financeability'!$AD$6)*(1+$K$33)","v":16132.995641566611},{"$f":"N34+(M35-M36)*(1+'PNGL Financeability'!$AD$6)*(1+$K$33)","v":16628.278607762706},{"$f":"O34+(N35-N36)*(1+'PNGL Financeability'!$AD$6)*(1+$K$33)","v":17138.766761021019},{"$f":"P34+(O35-O36)*(1+'PNGL Financeability'!$AD$6)*(1+$K$33)","v":36262.561941519583}]
[null,"Dividend Paid",null,null,null,null,null,null,null,null,{"$f":"IF(K4<'PNGL Financeability'!$AD$8,0,MIN(MAX(0,K21-SUM(K39:K44)),K35))","v":10534.406645179668},{"$f":"IF(L4<'PNGL Financeability'!$AD$8,0,MIN(MAX(0,L21-SUM(L39:L44)),L35))","v":20700.274632568617},{"$f":"IF(M4<'PNGL Financeability'!$AD$8,0,MIN(MAX(0,M21-SUM(M39:M44)),M35))","v":16132.995641566611},{"$f":"IF(N4<'PNGL Financeability'!$AD$8,0,MIN(MAX(0,N21-SUM(N39:N44)),N35))","v":16628.278607762706},{"$f":"IF(O4<'PNGL Financeability'!$AD$8,0,MIN(MAX(0,O21-SUM(O39:O44)),O35))","v":0},{"$f":"IF(P4<'PNGL Financeability'!$AD$8,0,MIN(MAX(0,P21-SUM(P39:P44)),P35))","v":36262.561941519583}]
[]
[null,"Debt"]
[null,"Debt at the start of the year",null,null,null,null,null,null,null,null,{"$f":"+'Pi''s Calc'!C87*DebtPNGL*'PNGL Financeability'!K7","v":351533.49950674787},{"$f":"+K47","v":351315.27088722493},{"$f":"+L47","v":359907.16975326691},367865.47487920878,376786.03807837545,366233.71012313408]
[null,"Revenues",null,null,null,null,null,null,null,null,{"$f":"-K9","v":-55708.601718291029},-58978.488724302304,-62414.204469144745,-66033.096603291939,-69828.785702281457,-73775.91597933587]
[null,"Opex",null,null,null,null,null,null,null,null,{"$f":"-K25","v":15808.447312605091},15945.152998359097,16331.836117611276,16774.115349673848,17165.992659582829,17826.594191083735]
[null,"Movements in working capital",null,null,null,null,null,null,null,null,{"$f":"+K11","v":-892.41470571502202},-191.21218501109428,634.43721212525418,243.55888944605425,-557.00935063512134,-387.30345725114728]
[null,"Investment",null,null,null,null,null,null,null,null,{"$f":"DAV!J16*'PNGL Financeability'!K7","v":11228.896196251369},{"$f":"DAV!K16*'PNGL Financeability'!L7","v":12081.021664998425},{"$f":"DAV!L16*'PNGL Financeability'!M7","v":17795.140645785297},{"$f":"DAV!M16*'PNGL Financeability'!N7","v":21377.861109995854},{"$f":"DAV!N16*'PNGL Financeability'!O7","v":20372.354454758333},{"$f":"DAV!O16*'PNGL Financeability'!P7","v":20200.816892474242}]
[null,"Tax (prior year)",null,null,null,null,null,null,null,null,{"$f":"J30","v":0},0,0,0,2408.9466738045967,2725.3017138565165]
[null,"Dividends",null,null,null,null,null,null,null,null,{"$f":"K36","v":10534.406645179668},20700.274632568617,16132.995641566611,16628.278607762706,0,36262.561941519583]
[null,"Interest",null,null,null,null,null,null,null,null,{"$f":"(K39+SUM(K40:K45)/2)*IntPNGL","v":18811.03765044696},19035.150479429223,19478.099977998132,19929.845845580112,19886.173309529451,20221.285577586917]
[null,"Debt at the end of the year",null,null,null,null,null,null,null,null,{"$f":"SUM(K39:K46)","v":351315.27088722493},{"$f":"SUM(L39:L46)","v":359907.16975326691},367865.47487920878,376786.03807837545,366233.71012313408,389307.05100306805]
[]
[null,"Average debt",null,null,null,null,null,null,null,null,{"$f":"AVERAGE(K47,K39)","v":351424.38519698638},355611.22032024595,363886.32231623784,372325.75647879211,371509.87410075474,377770.38056310103]
[]
[null,"TRV at start of year (mid-year RPI)",null,null,null,null,null,null,null,null,{"$f":"+'Pi''s Calc'!C87*'PNGL Financeability'!K7","v":639151.81728499616},{"$f":"+'Pi''s Calc'!D87*'PNGL Financeability'!L7","v":679217.25567748945},{"$f":"+'Pi''s Calc'!E87*'PNGL Financeability'!M7","v":707300.44274231081},{"$f":"+'Pi''s Calc'!F87*'PNGL Financeability'!N7","v":730085.60290657147},{"$f":"+'Pi''s Calc'!G87*'PNGL Financeability'!O7","v":720226.56226777646},{"$f":"+'Pi''s Calc'!H87*'PNGL Financeability'!P7","v":742955.62966582156}]
[null,"TRV at end of year (mid-year RPI)",null,null,null,null,null,null,null,null,{"$f":"+'Pi''s Calc'!D87*'PNGL Financeability'!K7","v":658986.37399581773},{"$f":"+'Pi''s Calc'!E87*'PNGL Financeability'!L7","v":686233.08697226248},{"$f":"+'Pi''s Calc'!F87*'PNGL Financeability'!M7","v":708339.57786608266},{"$f":"+'Pi''s Calc'!G87*'PNGL Financeability'!N7","v":698774.19449672697},{"$f":"+'Pi''s Calc'!H87*'PNGL Financeability'!O7","v":720826.26338005392},{"$f":"+'Pi''s Calc'!I87*'PNGL Financeability'!P7","v":739244.3380510587}]
[null,"Average TRV",null,null,null,null,null,null,null,null,{"$f":"AVERAGE(K51:K52)","v":649069.09564040694},{"$f":"AVERAGE(L51:L52)","v":682725.1713248759},707820.01030419674,714429.89870164916,720526.41282391525,741099.98385844007]
[null,"PM-FFO as % TRV",null,null,null,null,null,null,null,null,{"$f":"K16/K53","v":4.0574189847448754E-2},4.0789998335788405E-2,4.1557635976739435E-2,4.1862089534675094E-2,3.8465898036330493E-2,3.8506686377296061E-2]
[null,"Gearing ratio",null,null,null,null,null,null,null,null,{"$f":"K49/K53","v":0.54142831257472201},0.5208702348415799,0.51409442657583526,0.52115086050489878,0.51560895962816788,0.50974279961023472]
[]
[null,"Other Relevant metrics"]
[null,"FFO/Net Debt",null,null,null,null,null,null,null,null,{"$f":"SUM(K9+K10+K15-K46)/K49","v":6.0010396670162065E-2},6.7484330851266178E-2,7.3111482190898955E-2,7.8772781355266205E-2,8.1741227290041726E-2,8.7361890171524639E-2]
[null,"FFO/Interest Cover",null,null,null,null,null,null,null,null,{"$f":"SUM((K9+K10+K15-K46)+K46)/K46","v":2.1211033196107549},{"$f":"SUM((L9+L10+L15-L46)+L46)/L46","v":2.2607299990850183},2.3658554172936124,2.4716187789552007,2.527074746191234,2.6320789482043918,{"$f":"SUM((Q9+Q10-Q46)+Q46)/Q46","v":{"$error":"#VALUE!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"RCF/Capex",null,null,null,null,null,null,null,null,{"$f":"SUM((K9+K10+K15-K46)-K36)/K43","v":0.93995971871063122},{"$f":"SUM((L9+L10+L15-L46)-L36)/L43","v":0.27298275803115191},0.58843439006191856,0.59411260719327108,1.490631489197934,-0.16137107039098625]
[]
[]
[]
[null,"Financial Year Corporation Tax Rate",null,null,null,null,null,null,null,null,0.19,0.19,0.19,0.17,0.17,0.17]
[null,"Calander Year Corporation Tax Rate",null,null,null,null,null,null,null,null,0.1925,0.19,0.19,0.17499999999999999,0.17,0.17]

{"sheet":"Building Block","index":6,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["Building Block Method"]
[]
["Year:",null,2017,{"$f":"C6+1","v":2018},{"$f":"D6+1","v":2019},2020,2021,2022]
["Opening:",null,0,{"$f":"+C11","v":25895.781793710517},{"$f":"+D11","v":54820.694272593733},{"$f":"+E11","v":82421.3224251707},{"$f":"+F11","v":109112.77963648069},{"$f":"+G11","v":138609.00205154813}]
["Cshflow:",null,{"$f":"'Pi''s Calc'!D35","v":25895.781793710517},{"$f":"'Pi''s Calc'!E35","v":27821.752174471145},{"$f":"'Pi''s Calc'!F35","v":25265.266576564463},{"$f":"'Pi''s Calc'!G35","v":23180.308875997711},{"$f":"'Pi''s Calc'!H35","v":24848.018002553355},{"$f":"'Pi''s Calc'!I35","v":28338.737463280799}]
["Return on in year cashflow:",null,0,0,0,0,0,0]
["Return on in year opening:",null,{"$f":"C7*'Pi''s Calc'!D6","v":0},{"$f":"D7*'Pi''s Calc'!E6","v":1103.1603044120679},{"$f":"E7*'Pi''s Calc'!F6","v":2335.3615760124931},{"$f":"F7*'Pi''s Calc'!G6","v":3511.1483353122717},{"$f":"G7*'Pi''s Calc'!H6","v":4648.2044125140774},{"$f":"H7*'Pi''s Calc'!I6","v":5904.7434873959501}]
["Closing:",null,{"$f":"SUM(C7:C10)","v":25895.781793710517},54820.694272593733,82421.3224251707,109112.77963648069,138609.00205154813,172852.48300222488]