{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Operating Expenditure","Capital Expenditure","Consumption & Revenue","WACC & NPV Calculations"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":"Operating Expenditure","index":0,"n_rows":52,"n_cols":17,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Operating Expenditure Years 1 -10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 11 Uplift",0.15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Years 11 - 15 rate of increase",4.4999999999999998E-2]
[null,"All numbers in blue are input by Utility Regulator",null,0,null,null,null,null,null,null,null,null,null,null,null,"Years 16 - 20 rate of increase",2.75E-2]
[null,"All numbers in black are calculated",null,0,null,null,null,null,null,null,null,null,null,null,null,"Years 21 - 30 rate of increase",0.01]
[null,"Applicants only permitted to input data into blank cells",null,null,null,null,null,null,null,null,null,null,null,null,null,"Years 31 - 40 rate of increase",0]
[]
[]
[null,null,null,null,"Controlable Operating Expenditure £m",null,null,null,null,null,null,null,null,null,null,null,"Total"]
["Operating Expenditure Item",null,null,null,"Price Control Period 1",null,null,null,null,"Price Control Period2",null,null,null,null,null,"Year","Opex"]
["Level 1","Level 2","Level 3",null,1,2,3,4,5,6,7,8,9,10,null,1,{"$f":"$E$46","v":9.9280000000000007E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"$F$46","v":0.26735000000000003}]
["Mobilisation Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"$G$46","v":0.30648000000000003}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"$H$46","v":0.34544000000000002}]
["Marketing, Advertising & PR ","Market Development & Advertising",null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"$I$46","v":0.38431999999999999}]
["for Non-Domestic","Incentives",null,null,null,null,null,null,null,null,null,null,null,null,null,6,{"$f":"$J$46","v":0.44424999999999998}]
["Connections","Total Marketing, Advertising & PR",null,null,{"$f":"SUM(E17:E18)","v":0},0,0,0,0,0,0,0,0,0,null,7,{"$f":"$K$46","v":0.47930999999999996}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,{"$f":"$L$46","v":0.51436999999999999}]
["Emergencies and","Emergencies","Emergency Call Centre",null,null,null,null,null,null,null,null,null,null,null,null,9,{"$f":"$M$46","v":0.54942999999999997}]
["Network Maintenance",null,"First Calls",null,null,null,null,null,null,null,null,null,null,null,null,10,{"$f":"$N$46","v":0.58083000000000007}]
[null,"Network Maintenance","Repairs",null,null,null,null,null,null,null,null,null,null,null,null,11,{"$f":"((SUM(Q13:Q22)-E15)/10)*(1+Q4)","v":0.45667190000000002}]
[null,null,"Maintenance",null,null,null,null,null,null,null,null,null,null,null,null,12,{"$f":"Q23*(1+$Q$5)","v":0.47722213549999998}]
[null,"Total Emergencies and Network Maintenance",null,null,{"$f":"SUM(E21:E24)","v":0},{"$f":"SUM(F21:F24)","v":0},0,0,0,0,0,0,0,0,null,13,{"$f":"Q24*(1+$Q$5)","v":0.49869713159749995}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,0.52113850251938743]
["Manpower",null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,0.54458973513275988]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,{"$f":"Q27*(1+$Q$6)","v":0.55956595284891086}]
["Office","Buildings",null,null,null,null,null,null,null,null,null,null,null,null,null,17,{"$f":"Q28*(1+$Q$6)","v":0.57495401655225598}]
[null,"Telephone, Postage and Stationary",null,null,null,null,null,null,null,null,null,null,null,null,null,18,0.59076525200744301]
[null,"Total Office",null,null,{"$f":"SUM(E29:E30)","v":0},{"$f":"SUM(F29:F30)","v":0},{"$f":"SUM(G29:G30)","v":0},{"$f":"SUM(H29:H30)","v":0},{"$f":"SUM(I29:I30)","v":0},{"$f":"SUM(J29:J30)","v":0},{"$f":"SUM(K29:K30)","v":0},{"$f":"SUM(L29:L30)","v":0},{"$f":"SUM(M29:M30)","v":0},{"$f":"SUM(N29:N30)","v":0},null,19,0.60701129643764773]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,0.62370410708968305]
["Insurance","Business Insurance ",null,null,null,null,null,null,null,null,null,null,null,null,null,21,{"$f":"Q32*(1+$Q$7)","v":0.62994114816057989}]
[null,"Car Insurance",null,null,null,null,null,null,null,null,null,null,null,null,null,22,{"$f":"Q33*(1+$Q$7)","v":0.63624055964218573}]
[null,"Building Insurance",null,null,null,null,null,null,null,null,null,null,null,null,null,23,0.6426029652386076]
[null,"Total Insurance",null,null,{"$f":"SUM(E33:E35)","v":0},{"$f":"SUM(F33:F35)","v":0},0,0,0,0,0,0,0,0,null,24,0.64902899489099364]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,0.65551928483990363]
["Professional and Legal Fees",null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,0.66207447768830263]
["Information Technology",null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,0.66869522246518565]
["Miscellaneous ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,0.67538217468983752]
["Rates",null,null,null,{"$f":"SUM('Capital Expenditure'!$C$115)*0.01","v":7.4280000000000013E-2},{"$f":"SUM('Capital Expenditure'!$C$115:E115)*0.01","v":0.24235000000000001},{"$f":"SUM('Capital Expenditure'!$C$115:F115)*0.01","v":0.28148000000000001},{"$f":"SUM('Capital Expenditure'!$C$115:G115)*0.01","v":0.32044},{"$f":"SUM('Capital Expenditure'!$C$115:H115)*0.01","v":0.35931999999999997},{"$f":"SUM('Capital Expenditure'!$C$115:I115)*0.01","v":0.39424999999999999},{"$f":"SUM('Capital Expenditure'!$C$115:J115)*0.01","v":0.42930999999999997},{"$f":"SUM('Capital Expenditure'!$C$115:K115)*0.01","v":0.46437},{"$f":"SUM('Capital Expenditure'!$C$115:L115)*0.01","v":0.49942999999999999},{"$f":"SUM('Capital Expenditure'!$C$115:M115)*0.01","v":0.53083000000000002},null,29,0.68213599643673595]
["Licence Fees",null,null,null,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,0.05,0.05,0.05,0.05,0.05,null,30,0.68895735640110334]
["Total Other",null,null,null,{"$f":"SUM(E38:E42)","v":9.9280000000000007E-2},0.26735000000000003,0.30648000000000003,0.34544000000000002,0.38431999999999999,0.44424999999999998,0.47930999999999996,0.51436999999999999,0.54942999999999997,0.58083000000000007,null,31,{"$f":"Q42*(1+$Q$8)","v":0.68895735640110334}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32,{"$f":"Q43*(1+$Q$8)","v":0.68895735640110334}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33,{"$f":"Q44*(1+$Q$8)","v":0.68895735640110334}]
["Total  Operating Expenditure",null,null,null,{"$f":"E15+E19+E25+E27+E31+E36+E43","v":9.9280000000000007E-2},0.26735000000000003,0.30648000000000003,0.34544000000000002,0.38431999999999999,0.44424999999999998,0.47930999999999996,0.51436999999999999,0.54942999999999997,0.58083000000000007,null,34,0.68895735640110334]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35,0.68895735640110334]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,0.68895735640110334]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,0.68895735640110334]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,0.68895735640110334]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39,0.68895735640110334]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,0.68895735640110334]

{"sheet":"Capital Expenditure","index":1,"n_rows":129,"n_cols":44,"rows_kept":129,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Capital Expendituree Years 1 - 40"]
[]
[]
[null,"All numbers in blue are input by Utility Regulator",null,0]
[null,"All numbers in black are calculated",null,0]
[null,"Applicants only permitted to input data into blank cells"]
[]
[]
[null,null,"Period 1",null,null,null,null,"Period 2",null,null,null,null,"Period 3",null,null,null,null,"Period 4",null,null,null,null,"Period 5",null,null,null,null,"Period 6",null,null,null,null,"Period 7",null,null,null,null,"Period 8"]
["Connection Numbers",null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,null,"Total"]
[null,"Dungannon + Coalisland",null,256,256,160,160,160,160,160,160,160,160,160,160,160,160,160,160,160,160,160,160,160,160,160,160,160,160,160,160,160,160,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C13:AP13)","v":4992}]
["Existing","Cookstown + Magherafelt",null,282,282,176,176,176,176,176,176,176,176,176,176,176,176,176,176,176,176,176,176,176,176,176,176,176,176,176,176,176,176,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C14:AP14)","v":5492}]
["Owner","Omagh",null,295,295,184,184,184,184,184,184,184,184,184,184,184,184,184,184,184,184,184,184,184,184,184,184,184,184,184,184,184,184,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C15:AP15)","v":5742}]
["Occupied","Enniskillen + Derylin",null,220,220,138,138,138,138,138,138,138,138,138,138,138,138,138,138,138,138,138,138,138,138,138,138,138,138,138,138,138,138,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C16:AP16)","v":4304}]
[null,"Strabane",null,164,164,103,103,103,103,103,103,103,103,103,103,103,103,103,103,103,103,103,103,103,103,103,103,103,103,103,103,103,103,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C17:AP17)","v":3212}]
[null,"Total",{"$f":"SUM(C13:C17)","v":0},{"$f":"SUM(D13:D17)","v":1217},{"$f":"SUM(E13:E17)","v":1217},761,761,761,761,761,761,761,761,761,761,761,761,761,761,761,761,761,761,761,761,761,761,761,761,761,761,761,761,0,0,0,0,0,0,0,0,0,null,23742]
[null,"Dungannon + Coalisland",null,215,54,54,54,54,21,21,21,21,21,54,54,54,54,54,54,54,54,54,54,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C19:AP19)","v":1076}]
["Existing","Cookstown + Magherafelt",null,221,55,55,55,55,22,22,22,22,22,55,55,55,55,55,55,55,55,55,55,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C20:AP20)","v":1101}]
["Housing","Omagh",null,244,61,61,61,61,24,24,24,24,24,61,61,61,61,61,61,61,61,61,61,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C21:AP21)","v":1218}]
["Executive","Enniskillen + Derylin",null,174,43,43,43,43,17,17,17,17,17,43,43,43,43,43,43,43,43,43,43,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C22:AP22)","v":861}]
[null,"Strabane",null,209,52,52,52,52,21,21,21,21,21,52,52,52,52,52,52,52,52,52,52,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C23:AP23)","v":1042}]
[null,"Total",{"$f":"SUM(C19:C23)","v":0},1063,265,265,265,265,105,105,105,105,105,265,265,265,265,265,265,265,265,265,265,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AR19:AR23)","v":5298}]
[null,"Dungannon + Coalisland",null,53,71,71,71,71,89,71,71,71,71,71,71,71,71,71,71,71,71,71,71,71,71,71,71,71,71,71,71,71,71,71,71,71,71,71,71,71,71,71,null,{"$f":"SUM(C25:AP25)","v":2769}]
["New","Cookstown + Magherafelt",null,58,58,58,70,76,58,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,null,{"$f":"SUM(C26:AP26)","v":2688}]
["Houses","Omagh",null,46,46,69,46,46,46,69,69,69,69,69,69,69,69,69,69,69,69,69,69,69,69,69,69,69,69,69,69,69,69,69,69,69,69,69,69,69,69,69,null,{"$f":"SUM(C27:AP27)","v":2576}]
[null,"Enniskillen + Derylin",null,42,28,28,42,28,28,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,null,{"$f":"SUM(C28:AP28)","v":1582}]
[null,"Strabane",null,37,18,37,18,18,37,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,null,{"$f":"SUM(C29:AP29)","v":759}]
[null,"Total",{"$f":"SUM(C25:C29)","v":0},236,221,263,247,239,258,270,270,270,270,270,270,270,270,270,270,270,270,270,270,270,270,270,270,270,270,270,270,270,270,270,270,270,270,270,270,270,270,270,null,{"$f":"SUM(AR25:AR29)","v":10374}]
[null,"Dungannon + Coalisland",null,18,7,11,11,11,11,11,11,11,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,null,null,null,null,{"$f":"SUM(C31:AP31)","v":102}]
["Small I & C","Cookstown + Magherafelt",null,28,11,17,17,17,17,17,17,17,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,null,null,null,null,{"$f":"SUM(C32:AP32)","v":158}]
[null,"Omagh",null,14,6,8,8,8,8,8,8,8,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,null,null,null,null,{"$f":"SUM(C33:AP33)","v":76}]
[null,"Enniskillen + Derylin",null,11,4,7,7,7,7,7,7,7,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,null,null,null,null,{"$f":"SUM(C34:AP34)","v":64}]
[null,"Strabane",null,8,3,5,5,5,5,5,5,5,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,null,null,null,null,{"$f":"SUM(C35:AP35)","v":46}]
[null,"Total",{"$f":"SUM(C31:C35)","v":0},79,31,48,48,48,48,48,48,48,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AR31:AR35)","v":446}]
[null,"Dungannon + Coalisland",null,9,4,5,5,5,5,5,5,5,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,null,null,null,null,{"$f":"SUM(C37:AP37)","v":48}]
["Medium  I & C","Cookstown + Magherafelt",null,21,8,12,12,12,12,12,12,12,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,null,null,null,null,{"$f":"SUM(C38:AP38)","v":113}]
[null,"Omagh",null,12,5,7,7,7,7,7,7,7,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,null,null,null,null,{"$f":"SUM(C39:AP39)","v":66}]
[null,"Enniskillen + Derylin",null,8,3,5,5,5,5,5,5,5,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,null,null,null,null,{"$f":"SUM(C40:AP40)","v":46}]
[null,"Strabane",null,6,3,4,4,4,4,4,4,4,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,null,null,null,null,{"$f":"SUM(C41:AP41)","v":37}]
[null,"Total",{"$f":"SUM(C37:C41)","v":0},56,23,33,33,33,33,33,33,33,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AR37:AR41)","v":310}]
[null,"Dungannon + Coalisland",null,4,4,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,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C43:AP43)","v":8}]
["Large  I & C","Cookstown + Magherafelt",null,4,4,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,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C44:AP44)","v":8}]
[null,"Omagh",null,5,5,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,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C45:AP45)","v":10}]
[null,"Enniskillen + Derylin",null,3,3,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,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C46:AP46)","v":6}]
[null,"Strabane",null,2,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,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C47:AP47)","v":4}]
[null,"Total",{"$f":"SUM(C43:C47)","v":0},{"$f":"SUM(D43:D47)","v":18},18,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AR43:AR47)","v":36}]
[null,"Dungannon + Coalisland",4,3,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,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C49:AP49)","v":7}]
["Contract  I & C","Cookstown + Magherafelt",4,3,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,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C50:AP50)","v":7}]
[null,"Omagh",3,3,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,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C51:AP51)","v":6}]
[null,"Enniskillen + Derylin",3,3,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,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C52:AP52)","v":6}]
[null,"Strabane",1,0,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,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C53:AP53)","v":1}]
[null,"Total",{"$f":"SUM(C49:C53)","v":15},{"$f":"SUM(D49:D53)","v":12},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AR49:AR53)","v":27}]
[]
[]
[null,null,"Period 1",null,null,null,null,"Period 2",null,null,null,null,"Period 3",null,null,null,null,"Period 4",null,null,null,null,"Period 5",null,null,null,null,"Period 6",null,null,null,null,"Period 7",null,null,null,null,"Period 8"]
["Connection Costs",null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,null,"Total"]
[null,"Dungannon + Coalisland",{"$f":"(C13+C19)*$A$69","v":0},{"$f":"(D13+D19)*$A$63","v":1220832},{"$f":"(E13+E19)*$A$63","v":803520},554688,554688,554688,469152,469152,469152,469152,469152,554688,554688,554688,554688,554688,554688,554688,554688,554688,554688,414720,414720,414720,414720,414720,414720,414720,414720,414720,414720,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(C59:AP59)","v":15728256}]
["Existing","Cookstown + Magherafelt",{"$f":"(C14+C20)*$A$69","v":0},{"$f":"(D14+D20)*$A$63","v":1303776},873504,598752,598752,598752,513216,513216,513216,513216,513216,598752,598752,598752,598752,598752,598752,598752,598752,598752,598752,456192,456192,456192,456192,456192,456192,456192,456192,456192,456192,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(C60:AP60)","v":17089056}]
["Houses","Omagh",{"$f":"(C15+C21)*$A$69","v":0},{"$f":"(D15+D21)*$A$63","v":1397088},922752,635040,635040,635040,539136,539136,539136,539136,539136,635040,635040,635040,635040,635040,635040,635040,635040,635040,635040,476928,476928,476928,476928,476928,476928,476928,476928,476928,476928,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(C61:AP61)","v":18040320}]
[null,"Enniskillen + Derylin",{"$f":"(C16+C22)*$A$69","v":0},{"$f":"(D16+D22)*$A$63","v":1021248},681696,469152,469152,469152,401760,401760,401760,401760,401760,469152,469152,469152,469152,469152,469152,469152,469152,469152,469152,357696,357696,357696,357696,357696,357696,357696,357696,357696,357696,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(C62:AP62)","v":13387680}]
[{"$f":"ROUND(2476*1.0467,0)","v":2592},"Strabane",{"$f":"(C17+C23)*$A$69","v":0},{"$f":"(D17+D23)*$A$63","v":966816},559872,401760,401760,401760,321408,321408,321408,321408,321408,401760,401760,401760,401760,401760,401760,401760,401760,401760,401760,266976,266976,266976,266976,266976,266976,266976,266976,266976,266976,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(C63:AP63)","v":11026368}]
[null,"Total",{"$f":"SUM(C59:C63)","v":0},5909760,3841344,2659392,2659392,2659392,2244672,2244672,2244672,2244672,2244672,2659392,{"$f":"SUM(O59:O63)","v":2659392},2659392,2659392,2659392,2659392,2659392,2659392,2659392,2659392,1972512,1972512,1972512,1972512,1972512,1972512,1972512,1972512,1972512,1972512,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AR59:AR63)","v":75271680}]
[null,"Dungannon + Coalisland",{"$f":"C25*$A$69","v":0},{"$f":"D25*$A$69","v":51304},68728,68728,68728,68728,86152,68728,68728,68728,68728,68728,{"$f":"O25*$A$69","v":68728},68728,68728,68728,68728,68728,68728,68728,68728,68728,68728,68728,68728,68728,68728,68728,68728,68728,68728,68728,68728,68728,68728,68728,68728,68728,68728,68728,null,{"$f":"SUM(C65:AP65)","v":2680392}]
["New","Cookstown + Magherafelt",{"$f":"C26*$A$69","v":0},56144,56144,56144,67760,73568,56144,67760,67760,67760,67760,67760,{"$f":"O26*$A$69","v":67760},67760,67760,67760,67760,67760,67760,67760,67760,67760,67760,67760,67760,67760,67760,67760,67760,67760,67760,67760,67760,67760,67760,67760,67760,67760,67760,67760,null,{"$f":"SUM(C66:AP66)","v":2601984}]
["Houses","Omagh",{"$f":"C27*$A$69","v":0},44528,44528,66792,44528,44528,44528,66792,66792,66792,66792,66792,{"$f":"O27*$A$69","v":66792},66792,66792,66792,66792,66792,66792,66792,66792,66792,66792,66792,66792,66792,66792,66792,66792,66792,66792,66792,66792,66792,66792,66792,66792,66792,66792,66792,null,{"$f":"SUM(C67:AP67)","v":2493568}]
[null,"Enniskillen + Derylin",{"$f":"C28*$A$69","v":0},40656,27104,27104,40656,27104,27104,40656,40656,40656,40656,40656,{"$f":"O28*$A$69","v":40656},40656,40656,40656,40656,40656,40656,40656,40656,40656,40656,40656,40656,40656,40656,40656,40656,40656,40656,40656,40656,40656,40656,40656,40656,40656,40656,40656,null,{"$f":"SUM(C68:AP68)","v":1531376}]
[{"$f":"ROUND(925*1.0467,0)","v":968},"Strabane",{"$f":"C29*$A$69","v":0},35816,17424,35816,17424,17424,35816,17424,17424,17424,17424,17424,{"$f":"O29*$A$69","v":17424},17424,17424,17424,17424,17424,17424,17424,17424,17424,17424,17424,17424,17424,17424,17424,17424,17424,17424,17424,17424,17424,17424,17424,17424,17424,17424,17424,null,{"$f":"SUM(C69:AP69)","v":734712}]
[null,"Total",{"$f":"SUM(C65:C69)","v":0},228448,213928,254584,239096,231352,249744,261360,261360,261360,261360,261360,{"$f":"SUM(O65:O69)","v":261360},261360,261360,261360,261360,261360,261360,261360,261360,261360,261360,261360,261360,261360,261360,261360,261360,261360,261360,261360,261360,261360,261360,261360,261360,261360,261360,261360,null,{"$f":"SUM(AR65:AR69)","v":10042032}]
[null,"Dungannon + Coalisland",{"$f":"C31*$A$75","v":0},{"$f":"D31*$A$75","v":69786},27139,42647,42647,42647,42647,42647,42647,42647,0,0,{"$f":"O31*$A$75","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,null,{"$f":"SUM(C71:AP71)","v":395454}]
["Small I & C","Cookstown + Magherafelt",{"$f":"C32*$A$75","v":0},108556,42647,65909,65909,65909,65909,65909,65909,65909,0,0,{"$f":"O32*$A$75","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,null,{"$f":"SUM(C72:AP72)","v":612566}]
[null,"Omagh",{"$f":"C33*$A$75","v":0},54278,23262,31016,31016,31016,31016,31016,31016,31016,0,0,{"$f":"O33*$A$75","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,null,{"$f":"SUM(C73:AP73)","v":294652}]
[null,"Enniskillen + Derylin",{"$f":"C34*$A$75","v":0},42647,15508,27139,27139,27139,27139,27139,27139,27139,0,0,{"$f":"O34*$A$75","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,null,{"$f":"SUM(C74:AP74)","v":248128}]
[{"$f":"ROUND(3704*1.0467,0)","v":3877},"Strabane",{"$f":"C35*$A$75","v":0},31016,11631,19385,19385,19385,19385,19385,19385,19385,0,0,{"$f":"O35*$A$75","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,null,{"$f":"SUM(C75:AP75)","v":178342}]
[null,"Total",{"$f":"SUM(C71:C75)","v":0},306283,120187,186096,186096,186096,186096,186096,186096,186096,0,0,{"$f":"SUM(O71:O75)","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,null,{"$f":"SUM(AR71:AR75)","v":1729142}]
[null,"Dungannon + Coalisland",{"$f":"C37*$A$81","v":0},{"$f":"D37*$A$81","v":48735},21660,27075,27075,27075,27075,27075,27075,27075,0,0,{"$f":"O37*$A$81","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,null,{"$f":"SUM(C77:AP77)","v":259920}]
["Medium  I & C","Cookstown + Magherafelt",{"$f":"C38*$A$81","v":0},113715,43320,64980,64980,64980,64980,64980,64980,64980,0,0,{"$f":"O38*$A$81","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,null,{"$f":"SUM(C78:AP78)","v":611895}]
[null,"Omagh",{"$f":"C39*$A$81","v":0},64980,27075,37905,37905,37905,37905,37905,37905,37905,0,0,{"$f":"O39*$A$81","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,null,{"$f":"SUM(C79:AP79)","v":357390}]
[null,"Enniskillen + Derylin",{"$f":"C40*$A$81","v":0},43320,16245,27075,27075,27075,27075,27075,27075,27075,0,0,{"$f":"O40*$A$81","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,null,{"$f":"SUM(C80:AP80)","v":249090}]
[{"$f":"ROUND(5173*1.0467,0)","v":5415},"Strabane",{"$f":"C41*$A$81","v":0},32490,16245,21660,21660,21660,21660,21660,21660,21660,0,0,{"$f":"O41*$A$81","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,null,{"$f":"SUM(C81:AP81)","v":200355}]
[null,"Total",{"$f":"SUM(C77:C81)","v":0},303240,124545,178695,178695,178695,178695,178695,178695,178695,0,0,{"$f":"SUM(O77:O81)","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,null,{"$f":"SUM(AR77:AR81)","v":1678650}]
[null,"Dungannon + Coalisland",{"$f":"C43*$A$87","v":0},{"$f":"D43*$A$87","v":43320},43320,0,0,0,0,0,0,0,0,0,{"$f":"O43*$A$87","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,null,{"$f":"SUM(C83:AP83)","v":86640}]
["Large  I & C","Cookstown + Magherafelt",{"$f":"C44*$A$87","v":0},43320,43320,0,0,0,0,0,0,0,0,0,{"$f":"O44*$A$87","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,null,{"$f":"SUM(C84:AP84)","v":86640}]
[null,"Omagh",{"$f":"C45*$A$87","v":0},54150,54150,0,0,0,0,0,0,0,0,0,{"$f":"O45*$A$87","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,null,{"$f":"SUM(C85:AP85)","v":108300}]
[null,"Enniskillen + Derylin",{"$f":"C46*$A$87","v":0},32490,32490,0,0,0,0,0,0,0,0,0,{"$f":"O46*$A$87","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,null,{"$f":"SUM(C86:AP86)","v":64980}]
[{"$f":"ROUND(10347*1.0467,0)","v":10830},"Strabane",{"$f":"C47*$A$87","v":0},21660,21660,0,0,0,0,0,0,0,0,0,{"$f":"O47*$A$87","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,null,{"$f":"SUM(C87:AP87)","v":43320}]
[null,"Total",{"$f":"SUM(C83:C87)","v":0},194940,194940,0,0,0,0,0,0,0,0,0,{"$f":"SUM(O83:O87)","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,null,{"$f":"SUM(AR83:AR87)","v":389880}]
[null,"Dungannon + Coalisland",{"$f":"C49*$A$93","v":100900},{"$f":"D49*$A$93","v":75675},0,0,0,0,0,0,0,0,0,0,{"$f":"O49*$A$93","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,null,{"$f":"SUM(C89:AP89)","v":176575}]
["Contract  I & C","Cookstown + Magherafelt",{"$f":"C50*$A$93","v":100900},75675,0,0,0,0,0,0,0,0,0,0,{"$f":"O50*$A$93","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,null,{"$f":"SUM(C90:AP90)","v":176575}]
[null,"Omagh",{"$f":"C51*$A$93","v":75675},75675,0,0,0,0,0,0,0,0,0,0,{"$f":"O51*$A$93","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,null,{"$f":"SUM(C91:AP91)","v":151350}]
[null,"Enniskillen + Derylin",{"$f":"C52*$A$93","v":75675},75675,0,0,0,0,0,0,0,0,0,0,{"$f":"O52*$A$93","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,null,{"$f":"SUM(C92:AP92)","v":151350}]
[{"$f":"ROUND(24100*1.0467,0)","v":25225},"Strabane",{"$f":"C53*$A$93","v":25225},0,0,0,0,0,0,0,0,0,0,0,{"$f":"O53*$A$93","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,null,{"$f":"SUM(C93:AP93)","v":25225}]
[null,"Total",{"$f":"SUM(C89:C93)","v":378375},302700,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(O89:O93)","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,null,{"$f":"SUM(AR89:AR93)","v":681075}]
[]
[null,null,"Period 1",null,null,null,null,"Period 2",null,null,null,null,"Period 3",null,null,null,null,"Period 4",null,null,null,null,"Period 5",null,null,null,null,"Period 6",null,null,null,null,"Period 7",null,null,null,null,"Period 8"]
["Total Capex £m",null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,null,"Total"]
[null,"Dungannon + Coalisland",{"$f":"ROUND((C59+C65+C71+C77+C83+C89)/1000000,3)","v":0.10100000000000001},{"$f":"ROUND((D59+D65+D71+D77+D83+D89)/1000000,3)","v":1.51},0.96399999999999997,0.69299999999999995,0.69299999999999995,0.69299999999999995,0.625,0.60799999999999998,0.60799999999999998,0.60799999999999998,0.53800000000000003,0.623,0.623,0.623,0.623,0.623,0.623,0.623,0.623,0.623,0.623,0.48299999999999998,0.48299999999999998,0.48299999999999998,0.48299999999999998,0.48299999999999998,0.48299999999999998,0.48299999999999998,0.48299999999999998,0.48299999999999998,0.48299999999999998,6.9000000000000006E-2,6.9000000000000006E-2,6.9000000000000006E-2,6.9000000000000006E-2,6.9000000000000006E-2,6.9000000000000006E-2,6.9000000000000006E-2,6.9000000000000006E-2,6.9000000000000006E-2,null,{"$f":"SUM(C98:AP98)","v":19.321999999999989}]
["Connection ","Cookstown + Magherafelt",{"$f":"ROUND((C60+C66+C72+C78+C84+C90)/1000000,3)","v":0.10100000000000001},{"$f":"ROUND((D60+D66+D72+D78+D84+D90)/1000000,3)","v":1.7010000000000001},1.0589999999999999,0.78600000000000003,0.79700000000000004,0.80300000000000005,0.7,0.71199999999999997,0.71199999999999997,0.71199999999999997,0.58099999999999996,0.66700000000000004,0.66700000000000004,0.66700000000000004,0.66700000000000004,0.66700000000000004,0.66700000000000004,0.66700000000000004,0.66700000000000004,0.66700000000000004,0.66700000000000004,0.52400000000000002,0.52400000000000002,0.52400000000000002,0.52400000000000002,0.52400000000000002,0.52400000000000002,0.52400000000000002,0.52400000000000002,0.52400000000000002,0.52400000000000002,6.8000000000000005E-2,6.8000000000000005E-2,6.8000000000000005E-2,6.8000000000000005E-2,6.8000000000000005E-2,6.8000000000000005E-2,6.8000000000000005E-2,6.8000000000000005E-2,6.8000000000000005E-2,null,{"$f":"SUM(C99:AP99)","v":21.186000000000018}]
["Costs","Omagh",{"$f":"ROUND((C61+C67+C73+C79+C85+C91)/1000000,3)","v":7.5999999999999998E-2},{"$f":"ROUND((D61+D67+D73+D79+D85+D91)/1000000,3)","v":1.6910000000000001},1.0720000000000001,0.77100000000000002,0.748,0.748,0.65300000000000002,0.67500000000000004,0.67500000000000004,0.67500000000000004,0.60599999999999998,0.70199999999999996,0.70199999999999996,0.70199999999999996,0.70199999999999996,0.70199999999999996,0.70199999999999996,0.70199999999999996,0.70199999999999996,0.70199999999999996,0.70199999999999996,0.54400000000000004,0.54400000000000004,0.54400000000000004,0.54400000000000004,0.54400000000000004,0.54400000000000004,0.54400000000000004,0.54400000000000004,0.54400000000000004,0.54400000000000004,6.7000000000000004E-2,6.7000000000000004E-2,6.7000000000000004E-2,6.7000000000000004E-2,6.7000000000000004E-2,6.7000000000000004E-2,6.7000000000000004E-2,6.7000000000000004E-2,6.7000000000000004E-2,null,{"$f":"SUM(C100:AP100)","v":21.453000000000007}]
[null,"Enniskillen + Derylin",{"$f":"ROUND((C62+C68+C74+C80+C86+C92)/1000000,3)","v":7.5999999999999998E-2},{"$f":"ROUND((D62+D68+D74+D80+D86+D92)/1000000,3)","v":1.256},0.77300000000000002,0.55000000000000004,0.56399999999999995,0.55000000000000004,0.48299999999999998,0.497,0.497,0.497,0.442,0.51,0.51,0.51,0.51,0.51,0.51,0.51,0.51,0.51,0.51,0.39800000000000002,0.39800000000000002,0.39800000000000002,0.39800000000000002,0.39800000000000002,0.39800000000000002,0.39800000000000002,0.39800000000000002,0.39800000000000002,0.39800000000000002,4.1000000000000002E-2,4.1000000000000002E-2,4.1000000000000002E-2,4.1000000000000002E-2,4.1000000000000002E-2,4.1000000000000002E-2,4.1000000000000002E-2,4.1000000000000002E-2,4.1000000000000002E-2,null,{"$f":"SUM(C101:AP101)","v":15.633999999999999}]
[null,"Strabane",{"$f":"ROUND((C63+C69+C75+C81+C87+C93)/1000000,3)","v":2.5000000000000001E-2},{"$f":"ROUND((D63+D69+D75+D81+D87+D93)/1000000,3)","v":1.0880000000000001},0.627,0.47899999999999998,0.46,0.46,0.39800000000000002,0.38,0.38,0.38,0.33900000000000002,0.41899999999999998,0.41899999999999998,0.41899999999999998,0.41899999999999998,0.41899999999999998,0.41899999999999998,0.41899999999999998,0.41899999999999998,0.41899999999999998,0.41899999999999998,0.28399999999999997,0.28399999999999997,0.28399999999999997,0.28399999999999997,0.28399999999999997,0.28399999999999997,0.28399999999999997,0.28399999999999997,0.28399999999999997,0.28399999999999997,1.7000000000000001E-2,1.7000000000000001E-2,1.7000000000000001E-2,1.7000000000000001E-2,1.7000000000000001E-2,1.7000000000000001E-2,1.7000000000000001E-2,1.7000000000000001E-2,1.7000000000000001E-2,null,{"$f":"SUM(C102:AP102)","v":12.199}]
[null,"Total",{"$f":"SUM(C98:C102)","v":0.37900000000000006},7.2460000000000004,4.4950000000000001,3.2789999999999999,3.262,3.2539999999999996,2.859,2.8719999999999999,2.8719999999999999,2.8719999999999999,{"$f":"SUM(M98:M102)","v":2.5060000000000002},2.9209999999999998,2.9209999999999998,2.9209999999999998,2.9209999999999998,2.9209999999999998,2.9209999999999998,2.9209999999999998,2.9209999999999998,2.9209999999999998,2.9209999999999998,2.2330000000000001,2.2330000000000001,2.2330000000000001,2.2330000000000001,2.2330000000000001,2.2330000000000001,2.2330000000000001,2.2330000000000001,2.2330000000000001,2.2330000000000001,0.26200000000000001,0.26200000000000001,0.26200000000000001,0.26200000000000001,0.26200000000000001,0.26200000000000001,0.26200000000000001,0.26200000000000001,0.26200000000000001,null,{"$f":"SUM(AR98:AR102)","v":89.794000000000011}]
[null,"Dungannon + Coalisland",1.909,0.47899999999999998,0.31900000000000001,9.9000000000000005E-2,9.9000000000000005E-2,9.9000000000000005E-2,9.9000000000000005E-2,9.9000000000000005E-2,9.9000000000000005E-2,9.9000000000000005E-2,9.9000000000000005E-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,null,null,null,{"$f":"SUM(C104:AP104)","v":3.4990000000000014}]
["Network","Cookstown + Magherafelt",2.08,1.278,0.85199999999999998,0.26600000000000001,0.26600000000000001,0.26600000000000001,0.26600000000000001,0.26600000000000001,0.26600000000000001,0.26600000000000001,0.26600000000000001,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,null,null,null,{"$f":"SUM(C105:AP105)","v":6.3380000000000001}]
["Costs","Omagh",2.1539999999999999,0.27900000000000003,0.186,5.8999999999999997E-2,5.8999999999999997E-2,5.8999999999999997E-2,5.8999999999999997E-2,5.8999999999999997E-2,5.8999999999999997E-2,5.8999999999999997E-2,5.8999999999999997E-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,null,null,null,{"$f":"SUM(C106:AP106)","v":3.0910000000000011}]
[null,"Enniskillen + Derylin",0.82499999999999996,0.48699999999999999,0.32400000000000001,0.10199999999999999,0.10199999999999999,0.10199999999999999,0.10199999999999999,0.10199999999999999,0.10199999999999999,0.10199999999999999,0.10199999999999999,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,null,null,null,{"$f":"SUM(C107:AP107)","v":2.4519999999999995}]
[null,"Strabane",8.1000000000000003E-2,0.51700000000000002,0.34499999999999997,0.108,0.108,0.108,0.108,0.108,0.108,0.108,0.108,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,null,null,null,{"$f":"SUM(C108:AP108)","v":1.8070000000000006}]
[null,"Total",{"$f":"SUM(C104:C108)","v":7.0490000000000004},3.04,2.0259999999999998,0.63400000000000001,0.63400000000000001,0.63400000000000001,0.63400000000000001,0.63400000000000001,0.63400000000000001,0.63400000000000001,0.63400000000000001,{"$f":"SUM(N104:N108)","v":0},0,0,0,0,{"$f":"SUM(S104:S108)","v":0},0,0,0,0,{"$f":"SUM(X104:X108)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AR104:AR108)","v":17.187000000000005}]
[null,"Dungannon + Coalisland",{"$f":"C98+C104","v":2.0100000000000002},{"$f":"D98+D104","v":1.9889999999999999},1.2829999999999999,0.79199999999999993,0.79199999999999993,0.79199999999999993,0.72399999999999998,0.70699999999999996,0.70699999999999996,0.70699999999999996,0.63700000000000001,0.623,{"$f":"O98+O104","v":0.623},0.623,0.623,0.623,0.623,0.623,0.623,0.623,0.623,0.48299999999999998,0.48299999999999998,0.48299999999999998,0.48299999999999998,0.48299999999999998,0.48299999999999998,0.48299999999999998,0.48299999999999998,0.48299999999999998,0.48299999999999998,6.9000000000000006E-2,6.9000000000000006E-2,6.9000000000000006E-2,6.9000000000000006E-2,6.9000000000000006E-2,6.9000000000000006E-2,6.9000000000000006E-2,6.9000000000000006E-2,6.9000000000000006E-2,null,{"$f":"SUM(C110:AP110)","v":22.820999999999998}]
["Capex £m","Cookstown + Magherafelt",{"$f":"C99+C105","v":2.181},2.9790000000000001,1.911,1.052,1.0630000000000002,1.069,0.96599999999999997,0.97799999999999998,0.97799999999999998,0.97799999999999998,0.84699999999999998,0.66700000000000004,{"$f":"O99+O105","v":0.66700000000000004},0.66700000000000004,0.66700000000000004,0.66700000000000004,0.66700000000000004,0.66700000000000004,0.66700000000000004,0.66700000000000004,0.66700000000000004,0.52400000000000002,0.52400000000000002,0.52400000000000002,0.52400000000000002,0.52400000000000002,0.52400000000000002,0.52400000000000002,0.52400000000000002,0.52400000000000002,0.52400000000000002,6.8000000000000005E-2,6.8000000000000005E-2,6.8000000000000005E-2,6.8000000000000005E-2,6.8000000000000005E-2,6.8000000000000005E-2,6.8000000000000005E-2,6.8000000000000005E-2,6.8000000000000005E-2,null,{"$f":"SUM(C111:AP111)","v":27.524000000000033}]
[null,"Omagh",2.23,1.9700000000000002,1.258,0.83000000000000007,0.80699999999999994,0.80699999999999994,0.71199999999999997,0.73399999999999999,0.73399999999999999,0.73399999999999999,0.66500000000000004,0.70199999999999996,{"$f":"O100+O106","v":0.70199999999999996},0.70199999999999996,0.70199999999999996,0.70199999999999996,0.70199999999999996,0.70199999999999996,0.70199999999999996,0.70199999999999996,0.70199999999999996,0.54400000000000004,0.54400000000000004,0.54400000000000004,0.54400000000000004,0.54400000000000004,0.54400000000000004,0.54400000000000004,0.54400000000000004,0.54400000000000004,0.54400000000000004,6.7000000000000004E-2,6.7000000000000004E-2,6.7000000000000004E-2,6.7000000000000004E-2,6.7000000000000004E-2,6.7000000000000004E-2,6.7000000000000004E-2,6.7000000000000004E-2,6.7000000000000004E-2,null,{"$f":"SUM(C112:AP112)","v":24.544000000000004}]
[null,"Enniskillen + Derylin",0.90099999999999991,1.7429999999999999,1.097,0.65200000000000002,0.66599999999999993,0.65200000000000002,0.58499999999999996,0.59899999999999998,0.59899999999999998,0.59899999999999998,0.54400000000000004,0.51,{"$f":"O101+O107","v":0.51},0.51,0.51,0.51,0.51,0.51,0.51,0.51,0.51,0.39800000000000002,0.39800000000000002,0.39800000000000002,0.39800000000000002,0.39800000000000002,0.39800000000000002,0.39800000000000002,0.39800000000000002,0.39800000000000002,0.39800000000000002,4.1000000000000002E-2,4.1000000000000002E-2,4.1000000000000002E-2,4.1000000000000002E-2,4.1000000000000002E-2,4.1000000000000002E-2,4.1000000000000002E-2,4.1000000000000002E-2,4.1000000000000002E-2,null,{"$f":"SUM(C113:AP113)","v":18.085999999999999}]
[null,"Strabane",0.10600000000000001,1.605,0.97199999999999998,0.58699999999999997,0.56800000000000006,0.56800000000000006,0.50600000000000001,0.48799999999999999,0.48799999999999999,0.48799999999999999,0.44700000000000001,0.41899999999999998,{"$f":"O102+O108","v":0.41899999999999998},0.41899999999999998,0.41899999999999998,0.41899999999999998,0.41899999999999998,0.41899999999999998,0.41899999999999998,0.41899999999999998,0.41899999999999998,0.28399999999999997,0.28399999999999997,0.28399999999999997,0.28399999999999997,0.28399999999999997,0.28399999999999997,0.28399999999999997,0.28399999999999997,0.28399999999999997,0.28399999999999997,1.7000000000000001E-2,1.7000000000000001E-2,1.7000000000000001E-2,1.7000000000000001E-2,1.7000000000000001E-2,1.7000000000000001E-2,1.7000000000000001E-2,1.7000000000000001E-2,1.7000000000000001E-2,null,{"$f":"SUM(C114:AP114)","v":14.006000000000004}]
[null,"Total",{"$f":"SUM(C110:C114)","v":7.4280000000000008},{"$f":"SUM(D110:D114)","v":10.286000000000001},6.520999999999999,3.9130000000000003,3.8959999999999999,3.8879999999999999,3.4930000000000003,3.5059999999999998,3.5059999999999998,3.5059999999999998,3.14,2.9209999999999998,2.9209999999999998,2.9209999999999998,2.9209999999999998,2.9209999999999998,2.9209999999999998,2.9209999999999998,2.9209999999999998,2.9209999999999998,2.9209999999999998,2.2330000000000001,2.2330000000000001,2.2330000000000001,2.2330000000000001,2.2330000000000001,2.2330000000000001,2.2330000000000001,2.2330000000000001,2.2330000000000001,2.2330000000000001,0.26200000000000001,0.26200000000000001,0.26200000000000001,0.26200000000000001,0.26200000000000001,0.26200000000000001,0.26200000000000001,0.26200000000000001,0.26200000000000001,null,{"$f":"SUM(AR110:AR114)","v":106.98100000000004}]
[null,"Meter Replacement Costs",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1.1100000000000001,0.84799999999999998,0.65900000000000003,0.57599999999999996,0.56499999999999995,0.52300000000000002,0.52300000000000002,0.53400000000000003,0.53400000000000003,0.314,0.35599999999999998,0.35599999999999998,0.35599999999999998,0.35599999999999998,0.35599999999999998,0.35599999999999998,0.35599999999999998,0.35599999999999998,0.35599999999999998,null,{"$f":"SUM(C116:AP116)","v":9.3899999999999988}]
["Lifecycle","Annual Visit Costs",0,0,5.0000000000000001E-3,5.0000000000000001E-3,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,null,{"$f":"SUM(C117:AP117)","v":0.37000000000000016}]
["Expenditure","Domestic Regulators & Batt Costs",0,0,0,0,0,0,0,0,0,0,0,0.39800000000000002,0.30399999999999999,0.22,0.22,0.22,0.188,0.19900000000000001,0.19900000000000001,0.19900000000000001,0.19900000000000001,0.628,0.52300000000000002,0.44,0.45,0.45,0.41899999999999998,0.41899999999999998,0.41899999999999998,0.41899999999999998,0.41899999999999998,0.80600000000000005,0.70099999999999996,0.61799999999999999,0.628,0.628,0.59699999999999998,0.59699999999999998,0.59699999999999998,0.59699999999999998,null,{"$f":"SUM(C118:AP118)","v":12.700999999999997}]
[null,"IPRS Replacement Costs",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2.1000000000000001E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(C119:AP119)","v":2.1000000000000001E-2}]
[null,"Total",{"$f":"SUM(C116:C119)","v":0},0,5.0000000000000001E-3,5.0000000000000001E-3,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.40800000000000003,{"$f":"SUM(O116:O119)","v":0.314},0.23,0.23,0.23,0.19800000000000001,{"$f":"SUM(T116:T119)","v":0.20900000000000002},0.20900000000000002,0.20900000000000002,0.23,1.7480000000000002,1.381,1.109,1.036,1.0249999999999999,0.95199999999999996,0.95199999999999996,0.96300000000000008,0.96300000000000008,0.74299999999999999,1.1720000000000002,1.0669999999999999,0.98399999999999999,0.99399999999999999,0.99399999999999999,0.96299999999999997,0.96299999999999997,0.96299999999999997,0.96299999999999997,null,{"$f":"SUM(C120:AP120)","v":22.482000000000006}]
["Grand Total",null,{"$f":"C115+C120","v":7.4280000000000008},{"$f":"D115+D120","v":10.286000000000001},6.5259999999999989,3.9180000000000001,3.9059999999999997,3.8979999999999997,3.5030000000000001,3.5159999999999996,3.5159999999999996,3.5159999999999996,3.15,3.3289999999999997,3.2349999999999999,3.1509999999999998,3.1509999999999998,3.1509999999999998,3.1189999999999998,3.13,3.13,3.13,3.1509999999999998,3.9810000000000003,3.6139999999999999,3.3420000000000001,3.2690000000000001,3.258,3.1850000000000001,3.1850000000000001,3.1960000000000002,3.1960000000000002,2.976,1.4340000000000002,1.329,1.246,1.256,1.256,1.2250000000000001,1.2250000000000001,1.2250000000000001,1.2250000000000001,null,{"$f":"AR115+AR120","v":129.46300000000005}]
[]
[]
["Existing ","Dungannon + Coalisland",{"$f":"ROUND((C13*$A$128)/1000000,3)","v":0},0.109,0.109,6.8000000000000005E-2,6.8000000000000005E-2,6.8000000000000005E-2,6.8000000000000005E-2,6.8000000000000005E-2,6.8000000000000005E-2,6.8000000000000005E-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,null,null,null,null,{"$f":"SUM(C124:AP124)","v":0.69400000000000017}]
[" Domestic ","Cookstown + Magherafelt",{"$f":"ROUND((C14*$A$128)/1000000,3)","v":0},0.12,0.12,7.4999999999999997E-2,7.4999999999999997E-2,7.4999999999999997E-2,7.4999999999999997E-2,7.4999999999999997E-2,7.4999999999999997E-2,7.4999999999999997E-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,null,null,null,null,{"$f":"SUM(C125:AP125)","v":0.7649999999999999}]
["Connection ","Omagh",{"$f":"ROUND((C15*$A$128)/1000000,3)","v":0},0.125,0.125,7.8E-2,7.8E-2,7.8E-2,7.8E-2,7.8E-2,7.8E-2,7.8E-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,null,null,null,null,{"$f":"SUM(C126:AP126)","v":0.79599999999999993}]
[" Incentive","Enniskillen + Derylin",{"$f":"ROUND((C16*$A$128)/1000000,3)","v":0},9.4E-2,9.4E-2,5.8999999999999997E-2,5.8999999999999997E-2,5.8999999999999997E-2,5.8999999999999997E-2,5.8999999999999997E-2,5.8999999999999997E-2,5.8999999999999997E-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,null,null,null,null,{"$f":"SUM(C127:AP127)","v":0.60099999999999998}]
[425,"Strabane",{"$f":"ROUND((C17*$A$128)/1000000,3)","v":0},7.0000000000000007E-2,7.0000000000000007E-2,4.3999999999999997E-2,4.3999999999999997E-2,4.3999999999999997E-2,4.3999999999999997E-2,4.3999999999999997E-2,4.3999999999999997E-2,4.3999999999999997E-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,null,null,null,null,{"$f":"SUM(C128:AP128)","v":0.4479999999999999}]
[null,"Total",{"$f":"SUM(C124:C128)","v":0},0.51800000000000002,0.51800000000000002,0.32400000000000001,0.32400000000000001,0.32400000000000001,0.32400000000000001,0.32400000000000001,0.32400000000000001,0.32400000000000001,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,null,null,null,null,{"$f":"SUM(AR124:AR128)","v":3.3039999999999998}]

{"sheet":"Consumption & Revenue","index":2,"n_rows":58,"n_cols":15,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Consumption and Revenue Years 1 - 40"]
[]
[]
[null,"All numbers in blue are input by Utility Regulator",null,null,null,null,0]
[null,"All numbers in black are calculated",null,null,null,null,0]
[null,"Applicants only permitted to input data into blank cells"]
[]
[]
[]
[null,null,"Consumption Therms pa",null,null,null,null,null,null,null,null,null,"pence / Kwh"]
[null,null,480,480,400,null,29.307099999999998,"Kwh per therm",null,null,null,null,{"$f":"'WACC & NPV Calculations'!M9","v":0},{"$f":"'WACC & NPV Calculations'!M8","v":0}]
[]
[]
[null,null,"Domestic Connections",null,null,null,"Consumption Gwh's",null,null,null,null,null,"Revenue £m"]
[null,null,"Existing",null,null,null,null,"Industrial & Commercial",null,null,null,null,"Domestic -","Large -"]
["Year","PC period","Private","NIHE","New","Total","Domestic","Small","Medium","Large","Contract","Total","Medium IC","Contract IC","Total"]
[1,{"$f":"ROUNDUP(A19/5,0)","v":1},{"$f":"SUM('Capital Expenditure'!$C$18)","v":0},{"$f":"SUM('Capital Expenditure'!$C$24)","v":0},{"$f":"SUM('Capital Expenditure'!$C$30)","v":0},{"$f":"SUM(C19:E19)","v":0},null,null,null,null,155.542,{"$f":"SUM(H19:K19)","v":155.542},{"$f":"SUM(G19:I19)*$M$13/100","v":0},{"$f":"SUM(J19:K19)*$N$13/100","v":0},{"$f":"SUM(M19:N19)","v":0}]
[2,{"$f":"ROUNDUP(A20/5,0)","v":1},{"$f":"SUM('Capital Expenditure'!$C$18:$D$18)","v":1217},{"$f":"SUM('Capital Expenditure'!$C$24:$D$24)","v":1063},{"$f":"SUM('Capital Expenditure'!$C$30:$D$30)","v":236},{"$f":"SUM(C20:E20)","v":2516},{"$f":"ROUND((C19*$C$13+D19*$D$13+E19*$E$13+((C20-C19)*$C$13/2)+((D20-D19)*$D$13/2)+((E20-E19)*$E$13/2))*$G$13/1000000,3)","v":17.420000000000002},3.3395440449999998,9.9610000000000003,11.787000000000001,466.62699999999995,{"$f":"SUM(H20:K20)","v":491.71454404499997},{"$f":"SUM(G20:I20)*$M$13/100","v":0},{"$f":"SUM(J20:K20)*$N$13/100","v":0},{"$f":"SUM(M20:N20)","v":0}]
[3,1,{"$f":"SUM('Capital Expenditure'!$C$18:$E$18)","v":2434},{"$f":"SUM('Capital Expenditure'!$C$24:$E$24)","v":1328},{"$f":"SUM('Capital Expenditure'!$C$30:$E$30)","v":457},4219,{"$f":"ROUND((C20*$C$13+D20*$D$13+E20*$E$13+((C21-C20)*$C$13/2)+((D21-D20)*$D$13/2)+((E21-E20)*$E$13/2))*$G$13/1000000,3)","v":46.56},4.6753616630000003,13.946,35.362000000000002,622.16899999999998,676.15236166299997,{"$f":"SUM(G21:I21)*$M$13/100","v":0},0,0]
[4,1,{"$f":"SUM('Capital Expenditure'!$C$18:$F$18)","v":3195},{"$f":"SUM('Capital Expenditure'!$C$24:$F$24)","v":1593},{"$f":"SUM('Capital Expenditure'!$C$30:$F$30)","v":720},5508,67.037000000000006,6.6790880899999996,19.922000000000001,47.149000000000001,622.16899999999998,695.91908808999995,0,0,0]
[5,1,{"$f":"SUM('Capital Expenditure'!$C$18:$G$18)","v":3956},{"$f":"SUM('Capital Expenditure'!$C$24:$G$24)","v":1858},{"$f":"SUM('Capital Expenditure'!$C$30:$G$30)","v":967},6781,84.46,8.6828145170000006,25.899000000000001,47.149000000000001,622.16899999999998,703.89981451699998,0,{"$f":"SUM(J23:K23)*$N$13/100","v":0},0]
[6,2,{"$f":"SUM('Capital Expenditure'!$C$18:$H$18)","v":4717},{"$f":"SUM('Capital Expenditure'!$C$24:$H$24)","v":2123},{"$f":"SUM('Capital Expenditure'!$C$30:$H$30)","v":1206},8046,101.741,10.686540944000001,31.876000000000001,47.149000000000001,622.16899999999998,711.88054094400002,0,0,0]
[7,2,{"$f":"SUM('Capital Expenditure'!$C$18:$I$18)","v":5478},{"$f":"SUM('Capital Expenditure'!$C$24:$I$24)","v":2228},{"$f":"SUM('Capital Expenditure'!$C$30:$I$30)","v":1464},9170,117.962,12.690267370999999,37.851999999999997,47.149000000000001,622.16899999999998,719.86026737099996,0,0,0]
[8,2,{"$f":"SUM('Capital Expenditure'!$C$18:$J$18)","v":6239},{"$f":"SUM('Capital Expenditure'!$C$24:$J$24)","v":2333},{"$f":"SUM('Capital Expenditure'!$C$30:$J$30)","v":1734},10306,133.239,14.693993797999999,43.829000000000001,47.149000000000001,622.16899999999998,727.840993798,0,0,0]
[9,2,{"$f":"SUM('Capital Expenditure'!$C$18:$K$18)","v":7000},{"$f":"SUM('Capital Expenditure'!$C$24:$K$24)","v":2438},{"$f":"SUM('Capital Expenditure'!$C$30:$K$30)","v":2004},11442,148.58699999999999,16.697720225000001,49.805999999999997,47.149000000000001,622.16899999999998,735.82172022500004,0,0,0]
[10,2,{"$f":"SUM('Capital Expenditure'!$C$18:$L$18)","v":7761},{"$f":"SUM('Capital Expenditure'!$C$24:$L$24)","v":2543},{"$f":"SUM('Capital Expenditure'!$C$30:$L$30)","v":2274},12578,163.935,18.701446652000001,55.781999999999996,47.149000000000001,622.16899999999998,743.80144665199998,0,{"$f":"SUM(J28:K28)*$N$13/100","v":0},0]
[11,3,{"$f":"SUM('Capital Expenditure'!$C$18:$M$18)","v":8522},{"$f":"SUM('Capital Expenditure'!$C$24:$M$24)","v":2648},{"$f":"SUM('Capital Expenditure'!$C$30:$M$30)","v":2544},13714,179.28200000000001,18.701446652000001,55.781999999999996,47.149000000000001,622.16899999999998,743.80144665199998,0,0,0]
[12,3,{"$f":"SUM('Capital Expenditure'!$C$18:$N$18)","v":9283},{"$f":"SUM('Capital Expenditure'!$C$24:$N$24)","v":2913},{"$f":"SUM('Capital Expenditure'!$C$30:$N$30)","v":2814},15010,195.755,18.701446652000001,55.781999999999996,47.149000000000001,622.16899999999998,743.80144665199998,0,0,0]
[13,3,{"$f":"SUM('Capital Expenditure'!$C$18:$O$18)","v":10044},{"$f":"SUM('Capital Expenditure'!$C$24:$O$24)","v":3178},{"$f":"SUM('Capital Expenditure'!$C$30:$O$30)","v":3084},16306,213.35300000000001,18.701446652000001,55.781999999999996,47.149000000000001,622.16899999999998,743.80144665199998,0,0,0]
[14,3,{"$f":"SUM('Capital Expenditure'!$C$18:$P$18)","v":10805},{"$f":"SUM('Capital Expenditure'!$C$24:$P$24)","v":3443},{"$f":"SUM('Capital Expenditure'!$C$30:$P$30)","v":3354},17602,230.952,18.701446652000001,55.781999999999996,47.149000000000001,622.16899999999998,743.80144665199998,0,0,0]
[15,3,{"$f":"SUM('Capital Expenditure'!$C$18:$Q$18)","v":11566},{"$f":"SUM('Capital Expenditure'!$C$24:$Q$24)","v":3708},{"$f":"SUM('Capital Expenditure'!$C$30:$Q$30)","v":3624},18898,248.55,18.701446652000001,55.781999999999996,47.149000000000001,622.16899999999998,743.80144665199998,0,0,0]
[16,4,{"$f":"SUM('Capital Expenditure'!$C$18:$R$18)","v":12327},{"$f":"SUM('Capital Expenditure'!$C$24:$R$24)","v":3973},{"$f":"SUM('Capital Expenditure'!$C$30:$R$30)","v":3894},20194,266.14800000000002,18.701446652000001,55.781999999999996,47.149000000000001,622.16899999999998,743.80144665199998,0,0,0]
[17,4,{"$f":"SUM('Capital Expenditure'!$C$18:$R$18)","v":12327},{"$f":"SUM('Capital Expenditure'!$C$24:$R$24)","v":3973},{"$f":"SUM('Capital Expenditure'!$C$30:$R$30)","v":3894},20194,274.947,18.701446652000001,55.781999999999996,47.149000000000001,622.16899999999998,743.80144665199998,0,0,0]
[18,4,{"$f":"SUM('Capital Expenditure'!$C$18:$T$18)","v":13849},{"$f":"SUM('Capital Expenditure'!$C$24:$T$24)","v":4503},{"$f":"SUM('Capital Expenditure'!$C$30:$T$30)","v":4434},22786,292.54599999999999,18.701446652000001,55.781999999999996,47.149000000000001,622.16899999999998,743.80144665199998,0,0,0]
[19,4,{"$f":"SUM('Capital Expenditure'!$C$18:$U$18)","v":14610},{"$f":"SUM('Capital Expenditure'!$C$24:$U$24)","v":4768},{"$f":"SUM('Capital Expenditure'!$C$30:$U$30)","v":4704},24082,318.94299999999998,18.701446652000001,55.781999999999996,47.149000000000001,622.16899999999998,743.80144665199998,0,0,0]
[20,4,{"$f":"SUM('Capital Expenditure'!$C$18:$V$18)","v":15371},{"$f":"SUM('Capital Expenditure'!$C$24:$V$24)","v":5033},{"$f":"SUM('Capital Expenditure'!$C$30:$V$30)","v":4974},25378,336.54199999999997,18.701446652000001,55.781999999999996,47.149000000000001,622.16899999999998,743.80144665199998,0,0,0]
[21,5,{"$f":"SUM('Capital Expenditure'!$C$18:$W$18)","v":16132},{"$f":"SUM('Capital Expenditure'!$C$24:$W$24)","v":5298},{"$f":"SUM('Capital Expenditure'!$C$30:$W$30)","v":5244},26674,354.14,18.701446652000001,55.781999999999996,47.149000000000001,622.16899999999998,743.80144665199998,0,0,0]
[22,5,{"$f":"SUM('Capital Expenditure'!$C$18:$X$18)","v":16893},{"$f":"SUM('Capital Expenditure'!$C$24:$X$24)","v":5298},{"$f":"SUM('Capital Expenditure'!$C$30:$X$30)","v":5514},27705,369.87400000000002,18.701446652000001,55.781999999999996,47.149000000000001,622.16899999999998,743.80144665199998,0,0,0]
[23,5,{"$f":"SUM('Capital Expenditure'!$C$18:$Y$18)","v":17654},{"$f":"SUM('Capital Expenditure'!$C$24:$Y$24)","v":5298},{"$f":"SUM('Capital Expenditure'!$C$30:$Y$30)","v":5784},28736,383.745,18.701446652000001,55.781999999999996,47.149000000000001,622.16899999999998,743.80144665199998,0,0,0]
[24,5,{"$f":"SUM('Capital Expenditure'!$C$18:$Z$18)","v":18415},{"$f":"SUM('Capital Expenditure'!$C$24:$Z$24)","v":5298},{"$f":"SUM('Capital Expenditure'!$C$30:$Z$30)","v":6054},29767,397.61500000000001,18.701446652000001,55.781999999999996,47.149000000000001,622.16899999999998,743.80144665199998,0,0,0]
[25,5,{"$f":"SUM('Capital Expenditure'!$C$18:$AA$18)","v":19176},{"$f":"SUM('Capital Expenditure'!$C$24:$AA$24)","v":5298},{"$f":"SUM('Capital Expenditure'!$C$30:$AA$30)","v":6324},30798,411.48599999999999,18.701446652000001,55.781999999999996,47.149000000000001,622.16899999999998,743.80144665199998,0,0,0]
[26,6,{"$f":"SUM('Capital Expenditure'!$C$18:$AB$18)","v":19937},{"$f":"SUM('Capital Expenditure'!$C$24:$AB$24)","v":5298},{"$f":"SUM('Capital Expenditure'!$C$30:$AB$30)","v":6594},31829,425.35599999999999,18.701446652000001,55.781999999999996,47.149000000000001,622.16899999999998,743.80144665199998,0,0,{"$f":"SUM(M44:N44)","v":0}]
[27,6,{"$f":"SUM('Capital Expenditure'!$C$18:$AC$18)","v":20698},{"$f":"SUM('Capital Expenditure'!$C$24:$AC$24)","v":5298},{"$f":"SUM('Capital Expenditure'!$C$30:$AC$30)","v":6864},32860,439.22699999999998,18.701446652000001,55.781999999999996,47.149000000000001,622.16899999999998,743.80144665199998,0,0,0]
[28,6,{"$f":"SUM('Capital Expenditure'!$C$18:$AD$18)","v":21459},{"$f":"SUM('Capital Expenditure'!$C$24:$AD$24)","v":5298},{"$f":"SUM('Capital Expenditure'!$C$30:$AD$30)","v":7134},33891,453.09699999999998,18.701446652000001,55.781999999999996,47.149000000000001,622.16899999999998,743.80144665199998,0,0,0]
[29,6,{"$f":"SUM('Capital Expenditure'!$C$18:$AE$18)","v":22220},{"$f":"SUM('Capital Expenditure'!$C$24:$AE$24)","v":5298},{"$f":"SUM('Capital Expenditure'!$C$30:$AE$30)","v":7404},34922,466.96800000000002,18.701446652000001,55.781999999999996,47.149000000000001,622.16899999999998,743.80144665199998,0,0,0]
[30,6,{"$f":"SUM('Capital Expenditure'!$C$18:$AF$18)","v":22981},{"$f":"SUM('Capital Expenditure'!$C$24:$AF$24)","v":5298},{"$f":"SUM('Capital Expenditure'!$C$30:$AF$30)","v":7674},35953,480.83800000000002,18.701446652000001,55.781999999999996,47.149000000000001,622.16899999999998,743.80144665199998,0,0,0]
[31,7,{"$f":"SUM('Capital Expenditure'!$C$18:$AG$18)","v":23742},{"$f":"SUM('Capital Expenditure'!$C$24:$AG$24)","v":5298},{"$f":"SUM('Capital Expenditure'!$C$30:$AG$30)","v":7944},36984,494.709,18.701446652000001,55.781999999999996,47.149000000000001,622.16899999999998,743.80144665199998,0,0,{"$f":"SUM(M49:N49)","v":0}]
[32,7,{"$f":"SUM('Capital Expenditure'!$C$18:$AH$18)","v":23742},{"$f":"SUM('Capital Expenditure'!$C$24:$AH$24)","v":5298},{"$f":"SUM('Capital Expenditure'!$C$30:$AH$30)","v":8214},37254,503.226,18.701446652000001,55.781999999999996,47.149000000000001,622.16899999999998,743.80144665199998,0,0,0]
[33,7,{"$f":"SUM('Capital Expenditure'!$C$18:$AI$18)","v":23742},{"$f":"SUM('Capital Expenditure'!$C$24:$AI$24)","v":5298},{"$f":"SUM('Capital Expenditure'!$C$30:$AI$30)","v":8484},37524,506.392,18.701446652000001,55.781999999999996,47.149000000000001,622.16899999999998,743.80144665199998,0,0,0]
[34,7,{"$f":"SUM('Capital Expenditure'!$C$18:$AJ$18)","v":23742},{"$f":"SUM('Capital Expenditure'!$C$24:$AJ$24)","v":5298},{"$f":"SUM('Capital Expenditure'!$C$30:$AJ$30)","v":8754},37794,509.55700000000002,18.701446652000001,55.781999999999996,47.149000000000001,622.16899999999998,743.80144665199998,0,0,0]
[35,7,{"$f":"SUM('Capital Expenditure'!$C$18:$AK$18)","v":23742},{"$f":"SUM('Capital Expenditure'!$C$24:$AK$24)","v":5298},{"$f":"SUM('Capital Expenditure'!$C$30:$AK$30)","v":9024},38064,512.72199999999998,18.701446652000001,55.781999999999996,47.149000000000001,622.16899999999998,743.80144665199998,0,0,0]
[36,8,{"$f":"SUM('Capital Expenditure'!$C$18:$AL$18)","v":23742},{"$f":"SUM('Capital Expenditure'!$C$24:$AL$24)","v":5298},{"$f":"SUM('Capital Expenditure'!$C$30:$AL$30)","v":9294},38334,515.88699999999994,18.701446652000001,55.781999999999996,47.149000000000001,622.16899999999998,743.80144665199998,0,0,0]
[37,8,{"$f":"SUM('Capital Expenditure'!$C$18:$AM$18)","v":23742},{"$f":"SUM('Capital Expenditure'!$C$24:$AM$24)","v":5298},{"$f":"SUM('Capital Expenditure'!$C$30:$AM$30)","v":9564},38604,519.05200000000002,18.701446652000001,55.781999999999996,47.149000000000001,622.16899999999998,743.80144665199998,0,0,0]
[38,8,{"$f":"SUM('Capital Expenditure'!$C$18:$AN$18)","v":23742},{"$f":"SUM('Capital Expenditure'!$C$24:$AN$24)","v":5298},{"$f":"SUM('Capital Expenditure'!$C$30:$AN$30)","v":9834},38874,522.21699999999998,18.701446652000001,55.781999999999996,47.149000000000001,622.16899999999998,743.80144665199998,0,0,0]
[39,8,{"$f":"SUM('Capital Expenditure'!$C$18:$AO$18)","v":23742},{"$f":"SUM('Capital Expenditure'!$C$24:$AO$24)","v":5298},{"$f":"SUM('Capital Expenditure'!$C$30:$AO$30)","v":10104},39144,525.38300000000004,18.701446652000001,55.781999999999996,47.149000000000001,622.16899999999998,743.80144665199998,0,0,{"$f":"SUM(M57:N57)","v":0}]
[40,8,{"$f":"SUM('Capital Expenditure'!$C$18:$AP$18)","v":23742},{"$f":"SUM('Capital Expenditure'!$C$24:$AP$24)","v":5298},{"$f":"SUM('Capital Expenditure'!$C$30:$AP$30)","v":10374},39414,528.548,18.701446652000001,55.781999999999996,47.149000000000001,622.16899999999998,743.80144665199998,0,0,{"$f":"SUM(M58:N58)","v":0}]

{"sheet":"WACC & NPV Calculations","index":3,"n_rows":63,"n_cols":18,"rows_kept":63,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Weighted Average Cost of Capital and Nett Present Value  Years 1-40"]
[]
[null,null,null,null,null,null,null,null,null,"Depreciation Period (years)",null,35]
[null,"All numbers in blue are input by Utility Regulator",null,null,null,null,0]
[null,"All numbers in black are calculated",null,null,null,null,0,null,"Distribution Tariff",null,null,"pence / Kwh"]
[null,"Applicants only permitted to input data into blank cells",null,null,null,null,null,null,"Large + Contract I/C",null,null,0.85,{"$f":"M9*L8","v":0}]
[null,null,null,null,null,null,null,null,"Domestic + Small + Medium I/C",null,null,1,null,null,null,{"$f":"SUM(O59:Q59)","v":{"$error":"#DIV/0!"}},"Allowed / Collected Revenue Check"]
[]
[null,null,null,null,null,null,null,null,null,"Social Discount Rate",null,3.5000000000000003E-2]
[]
[]
[null,null,"Pre Tax","Asset Value",null,null,null,"Annual Cost",null,null,null,null,null,null,"Profile Adjustment"]
[null,null,"Real",null,null,null,null,null,"Return on","Domestic","Operating",null,null,"Opening","Annual",null,null,"Closing"]
["Year","PC period","WACC","Opening","Capex","Depreciation","Closing","Depreciation","Capital","Incentive","Costs","Total",null,"Balance","Cost","Return","Revenue","Balance"]
[1,{"$f":"ROUNDUP(A17/5,0)","v":1},null,0,{"$f":"'Capital Expenditure'!C$121","v":7.4280000000000008},{"$f":"-ROUND((E17/$L$5),3)","v":-0.21199999999999999},{"$f":"SUM(D17:F17)","v":7.2160000000000011},{"$f":"-SUM(F17:F17)","v":0.21199999999999999},{"$f":"((D17+G17)/2)*C17","v":0},{"$f":"'Capital Expenditure'!C$129","v":0},{"$f":"'Operating Expenditure'!Q13","v":9.9280000000000007E-2},{"$f":"SUM(H17:K17)","v":0.31128},null,0,{"$f":"L17","v":0.31128},{"$f":"N17*C17","v":0},{"$f":"-'Consumption & Revenue'!O19","v":0},{"$f":"SUM(N17:Q17)","v":0.31128}]
[2,{"$f":"ROUNDUP(A18/5,0)","v":1},null,{"$f":"G17","v":7.2160000000000011},{"$f":"'Capital Expenditure'!D$121","v":10.286000000000001},{"$f":"-ROUND((SUM($E$17:E18)/$L$5),3)","v":-0.50600000000000001},16.996000000000002,0.50600000000000001,{"$f":"((D18+G18)/2)*C18","v":0},{"$f":"'Capital Expenditure'!D$129","v":0.51800000000000002},{"$f":"'Operating Expenditure'!Q14","v":0.26735000000000003},1.29135,null,{"$f":"R17","v":0.31128},{"$f":"L18","v":1.29135},0,{"$f":"-'Consumption & Revenue'!O20","v":0},{"$f":"SUM(N18:Q18)","v":1.60263}]
[3,1,null,{"$f":"G18","v":16.996000000000002},{"$f":"'Capital Expenditure'!E$121","v":6.5259999999999989},{"$f":"-ROUND((SUM($E$17:E19)/$L$5),3)","v":-0.69299999999999995},22.829000000000001,0.69299999999999995,0,{"$f":"'Capital Expenditure'!E$129","v":0.51800000000000002},{"$f":"'Operating Expenditure'!Q15","v":0.30648000000000003},1.5174799999999999,null,{"$f":"R18","v":1.60263},1.5174799999999999,0,{"$f":"-'Consumption & Revenue'!O21","v":0},3.1201099999999999]
[4,1,null,22.829000000000001,{"$f":"'Capital Expenditure'!F$121","v":3.9180000000000001},{"$f":"-ROUND((SUM($E$17:E20)/$L$5),3)","v":-0.80500000000000005},25.942,0.80500000000000005,0,{"$f":"'Capital Expenditure'!F$129","v":0.32400000000000001},{"$f":"'Operating Expenditure'!Q16","v":0.34544000000000002},1.47444,null,3.1201099999999999,1.47444,0,{"$f":"-'Consumption & Revenue'!O22","v":0},4.5945499999999999]
[5,1,null,25.942,{"$f":"'Capital Expenditure'!G$121","v":3.9059999999999997},{"$f":"-ROUND((SUM($E$17:E21)/$L$5),3)","v":-0.91600000000000004},28.931999999999999,0.91600000000000004,0,{"$f":"'Capital Expenditure'!G$129","v":0.32400000000000001},{"$f":"'Operating Expenditure'!Q17","v":0.38431999999999999},1.62432,null,4.5945499999999999,1.62432,0,{"$f":"-'Consumption & Revenue'!O23","v":0},6.2188699999999999]
[6,2,null,28.931999999999999,{"$f":"'Capital Expenditure'!H$121","v":3.8979999999999997},{"$f":"-ROUND((SUM($E$17:E22)/$L$5),3)","v":-1.0269999999999999},31.802999999999997,1.0269999999999999,0,{"$f":"'Capital Expenditure'!H$129","v":0.32400000000000001},{"$f":"'Operating Expenditure'!Q18","v":0.44424999999999998},1.79525,null,6.2188699999999999,1.79525,0,{"$f":"-'Consumption & Revenue'!O24","v":0},8.0141200000000001]
[7,2,null,31.802999999999997,{"$f":"'Capital Expenditure'!I$121","v":3.5030000000000001},{"$f":"-ROUND((SUM($E$17:E23)/$L$5),3)","v":-1.1279999999999999},34.177999999999997,1.1279999999999999,0,{"$f":"'Capital Expenditure'!L$129","v":0.32400000000000001},{"$f":"'Operating Expenditure'!Q19","v":0.47930999999999996},1.9313099999999999,null,8.0141200000000001,1.9313099999999999,0,{"$f":"-'Consumption & Revenue'!O25","v":0},9.94543]
[8,2,null,34.177999999999997,{"$f":"'Capital Expenditure'!J$121","v":3.5159999999999996},{"$f":"-ROUND((SUM($E$17:E24)/$L$5),3)","v":-1.228},36.465999999999994,1.228,0,{"$f":"'Capital Expenditure'!J$129","v":0.32400000000000001},{"$f":"'Operating Expenditure'!Q20","v":0.51436999999999999},2.06637,null,9.94543,2.06637,0,{"$f":"-'Consumption & Revenue'!O26","v":0},12.011800000000001]
[9,2,null,36.465999999999994,{"$f":"'Capital Expenditure'!K$121","v":3.5159999999999996},{"$f":"-ROUND((SUM($E$17:E25)/$L$5),3)","v":-1.3280000000000001},38.653999999999989,1.3280000000000001,0,{"$f":"'Capital Expenditure'!K$129","v":0.32400000000000001},{"$f":"'Operating Expenditure'!Q21","v":0.54942999999999997},2.2014300000000002,null,12.011800000000001,2.2014300000000002,0,{"$f":"-'Consumption & Revenue'!O27","v":0},14.213230000000001]
[10,2,null,38.653999999999989,{"$f":"'Capital Expenditure'!L$121","v":3.5159999999999996},{"$f":"-ROUND((SUM($E$17:E26)/$L$5),3)","v":-1.429},40.740999999999985,1.429,0,{"$f":"'Capital Expenditure'!L$129","v":0.32400000000000001},{"$f":"'Operating Expenditure'!Q22","v":0.58083000000000007},2.3338300000000003,null,14.213230000000001,2.3338300000000003,0,{"$f":"-'Consumption & Revenue'!O28","v":0},16.547060000000002]
[11,3,{"$f":"AVERAGE($C$17:$C$26)","v":{"$error":"#DIV/0!"}},40.740999999999985,{"$f":"'Capital Expenditure'!M$121","v":3.15},{"$f":"-ROUND((SUM($E$17:E27)/$L$5),3)","v":-1.5189999999999999},42.371999999999986,1.5189999999999999,{"$error":"#DIV/0!"},null,{"$f":"'Operating Expenditure'!Q23","v":0.45667190000000002},{"$error":"#DIV/0!"},null,16.547060000000002,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"-'Consumption & Revenue'!O29","v":0},{"$error":"#DIV/0!"}]
[12,3,{"$f":"AVERAGE($C$17:$C$26)","v":{"$error":"#DIV/0!"}},42.371999999999986,{"$f":"'Capital Expenditure'!N$121","v":3.3289999999999997},{"$f":"-ROUND((SUM($E$17:E28)/$L$5),3)","v":-1.6140000000000001},44.086999999999989,1.6140000000000001,{"$error":"#DIV/0!"},null,{"$f":"'Operating Expenditure'!Q24","v":0.47722213549999998},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"-'Consumption & Revenue'!O30","v":0},{"$error":"#DIV/0!"}]
[13,3,{"$error":"#DIV/0!"},44.086999999999989,{"$f":"'Capital Expenditure'!O$121","v":3.2349999999999999},{"$f":"-ROUND((SUM($E$17:E29)/$L$5),3)","v":-1.706},45.615999999999985,1.706,{"$error":"#DIV/0!"},null,{"$f":"'Operating Expenditure'!Q25","v":0.49869713159749995},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"-'Consumption & Revenue'!O31","v":0},{"$error":"#DIV/0!"}]
[14,3,{"$error":"#DIV/0!"},45.615999999999985,{"$f":"'Capital Expenditure'!P$121","v":3.1509999999999998},{"$f":"-ROUND((SUM($E$17:E30)/$L$5),3)","v":-1.7969999999999999},46.969999999999985,1.7969999999999999,{"$error":"#DIV/0!"},null,{"$f":"'Operating Expenditure'!Q26","v":0.52113850251938743},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"-'Consumption & Revenue'!O32","v":0},{"$error":"#DIV/0!"}]
[15,3,{"$error":"#DIV/0!"},46.969999999999985,{"$f":"'Capital Expenditure'!Q$121","v":3.1509999999999998},{"$f":"-ROUND((SUM($E$17:E31)/$L$5),3)","v":-1.887},48.23399999999998,1.887,{"$error":"#DIV/0!"},null,{"$f":"'Operating Expenditure'!Q27","v":0.54458973513275988},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"-'Consumption & Revenue'!O33","v":0},{"$error":"#DIV/0!"}]
[16,4,{"$error":"#DIV/0!"},48.23399999999998,{"$f":"'Capital Expenditure'!R$121","v":3.1509999999999998},{"$f":"-ROUND((SUM($E$17:E32)/$L$5),3)","v":-1.9770000000000001},49.40799999999998,1.9770000000000001,{"$error":"#DIV/0!"},null,{"$f":"'Operating Expenditure'!Q28","v":0.55956595284891086},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"-'Consumption & Revenue'!O34","v":0},{"$error":"#DIV/0!"}]
[17,4,{"$error":"#DIV/0!"},49.40799999999998,{"$f":"'Capital Expenditure'!S$121","v":3.1189999999999998},{"$f":"-ROUND((SUM($E$17:E33)/$L$5),3)","v":-2.0659999999999998},50.460999999999977,2.0659999999999998,{"$error":"#DIV/0!"},null,{"$f":"'Operating Expenditure'!Q29","v":0.57495401655225598},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"-'Consumption & Revenue'!O35","v":0},{"$error":"#DIV/0!"}]
[18,4,{"$error":"#DIV/0!"},50.460999999999977,{"$f":"'Capital Expenditure'!T$121","v":3.13},{"$f":"-ROUND((SUM($E$17:E34)/$L$5),3)","v":-2.1549999999999998},51.435999999999979,2.1549999999999998,{"$error":"#DIV/0!"},null,{"$f":"'Operating Expenditure'!Q30","v":0.59076525200744301},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"-'Consumption & Revenue'!O36","v":0},{"$error":"#DIV/0!"}]
[19,4,{"$error":"#DIV/0!"},51.435999999999979,{"$f":"'Capital Expenditure'!U$121","v":3.13},{"$f":"-ROUND((SUM($E$17:E35)/$L$5),3)","v":-2.2450000000000001},52.320999999999984,2.2450000000000001,{"$error":"#DIV/0!"},null,{"$f":"'Operating Expenditure'!Q31","v":0.60701129643764773},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"-'Consumption & Revenue'!O37","v":0},{"$error":"#DIV/0!"}]
[20,4,{"$error":"#DIV/0!"},52.320999999999984,{"$f":"'Capital Expenditure'!V$121","v":3.13},{"$f":"-ROUND((SUM($E$17:E36)/$L$5),3)","v":-2.3340000000000001},53.116999999999983,2.3340000000000001,{"$error":"#DIV/0!"},null,{"$f":"'Operating Expenditure'!Q32","v":0.62370410708968305},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"-'Consumption & Revenue'!O38","v":0},{"$error":"#DIV/0!"}]
[21,5,{"$error":"#DIV/0!"},53.116999999999983,{"$f":"'Capital Expenditure'!W$121","v":3.1509999999999998},{"$f":"-ROUND((SUM($E$17:E37)/$L$5),3)","v":-2.4239999999999999},53.843999999999987,2.4239999999999999,{"$error":"#DIV/0!"},null,{"$f":"'Operating Expenditure'!Q33","v":0.62994114816057989},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"-'Consumption & Revenue'!O39","v":0},{"$error":"#DIV/0!"}]
[22,5,{"$error":"#DIV/0!"},53.843999999999987,{"$f":"'Capital Expenditure'!X$121","v":3.9810000000000003},{"$f":"-ROUND((SUM($E$17:E38)/$L$5),3)","v":-2.5379999999999998},55.286999999999992,2.5379999999999998,{"$error":"#DIV/0!"},null,{"$f":"'Operating Expenditure'!Q34","v":0.63624055964218573},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"-'Consumption & Revenue'!O40","v":0},{"$error":"#DIV/0!"}]
[23,5,{"$error":"#DIV/0!"},55.286999999999992,{"$f":"'Capital Expenditure'!Y$121","v":3.6139999999999999},{"$f":"-ROUND((SUM($E$17:E39)/$L$5),3)","v":-2.641},56.259999999999991,2.641,{"$error":"#DIV/0!"},null,{"$f":"'Operating Expenditure'!Q35","v":0.6426029652386076},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"-'Consumption & Revenue'!O41","v":0},{"$error":"#DIV/0!"}]
[24,5,{"$error":"#DIV/0!"},56.259999999999991,{"$f":"'Capital Expenditure'!Z$121","v":3.3420000000000001},{"$f":"-ROUND((SUM($E$17:E40)/$L$5),3)","v":-2.7360000000000002},56.865999999999993,2.7360000000000002,{"$error":"#DIV/0!"},null,{"$f":"'Operating Expenditure'!Q36","v":0.64902899489099364},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"-'Consumption & Revenue'!O42","v":0},{"$error":"#DIV/0!"}]
[25,5,{"$error":"#DIV/0!"},56.865999999999993,{"$f":"'Capital Expenditure'!AA$121","v":3.2690000000000001},{"$f":"-ROUND((SUM($E$17:E41)/$L$5),3)","v":-2.83},57.304999999999993,2.83,{"$error":"#DIV/0!"},null,{"$f":"'Operating Expenditure'!Q37","v":0.65551928483990363},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"-'Consumption & Revenue'!O43","v":0},{"$error":"#DIV/0!"}]
[26,6,{"$error":"#DIV/0!"},57.304999999999993,{"$f":"'Capital Expenditure'!AB$121","v":3.258},{"$f":"-ROUND((SUM($E$17:E42)/$L$5),3)","v":-2.923},57.639999999999993,2.923,{"$error":"#DIV/0!"},null,{"$f":"'Operating Expenditure'!Q38","v":0.66207447768830263},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"-'Consumption & Revenue'!O44","v":0},{"$error":"#DIV/0!"}]
[27,6,{"$error":"#DIV/0!"},57.639999999999993,{"$f":"'Capital Expenditure'!AC$121","v":3.1850000000000001},{"$f":"-ROUND((SUM($E$17:E43)/$L$5),3)","v":-3.0139999999999998},57.810999999999993,3.0139999999999998,{"$error":"#DIV/0!"},null,{"$f":"'Operating Expenditure'!Q39","v":0.66869522246518565},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"-'Consumption & Revenue'!O45","v":0},{"$error":"#DIV/0!"}]
[28,6,{"$error":"#DIV/0!"},57.810999999999993,{"$f":"'Capital Expenditure'!AD$121","v":3.1850000000000001},{"$f":"-ROUND((SUM($E$17:E44)/$L$5),3)","v":-3.105},57.890999999999998,3.105,{"$error":"#DIV/0!"},null,{"$f":"'Operating Expenditure'!Q40","v":0.67538217468983752},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"-'Consumption & Revenue'!O46","v":0},{"$error":"#DIV/0!"}]
[29,6,{"$error":"#DIV/0!"},57.890999999999998,{"$f":"'Capital Expenditure'!AE$121","v":3.1960000000000002},{"$f":"-ROUND((SUM($E$17:E45)/$L$5),3)","v":-3.1960000000000002},57.890999999999998,3.1960000000000002,{"$error":"#DIV/0!"},null,{"$f":"'Operating Expenditure'!Q41","v":0.68213599643673595},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"-'Consumption & Revenue'!O47","v":0},{"$error":"#DIV/0!"}]
[30,6,{"$error":"#DIV/0!"},57.890999999999998,{"$f":"'Capital Expenditure'!AF$121","v":3.1960000000000002},{"$f":"-ROUND((SUM($E$17:E46)/$L$5),3)","v":-3.2879999999999998},57.798999999999999,3.2879999999999998,{"$error":"#DIV/0!"},null,{"$f":"'Operating Expenditure'!Q42","v":0.68895735640110334},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"-'Consumption & Revenue'!O48","v":0},{"$error":"#DIV/0!"}]
[31,7,{"$error":"#DIV/0!"},57.798999999999999,{"$f":"'Capital Expenditure'!AG$121","v":2.976},{"$f":"-ROUND((SUM($E$17:E47)/$L$5),3)","v":-3.3730000000000002},57.402000000000001,3.3730000000000002,{"$error":"#DIV/0!"},null,{"$f":"'Operating Expenditure'!Q43","v":0.68895735640110334},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"-'Consumption & Revenue'!O49","v":0},{"$error":"#DIV/0!"}]
[32,7,{"$error":"#DIV/0!"},57.402000000000001,{"$f":"'Capital Expenditure'!AH$121","v":1.4340000000000002},{"$f":"-ROUND((SUM($E$17:E48)/$L$5),3)","v":-3.4140000000000001},55.421999999999997,3.4140000000000001,{"$error":"#DIV/0!"},null,{"$f":"'Operating Expenditure'!Q44","v":0.68895735640110334},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"-'Consumption & Revenue'!O50","v":0},{"$error":"#DIV/0!"}]
[33,7,{"$error":"#DIV/0!"},55.421999999999997,{"$f":"'Capital Expenditure'!AI$121","v":1.329},{"$f":"-ROUND((SUM($E$17:E49)/$L$5),3)","v":-3.452},53.298999999999999,3.452,{"$error":"#DIV/0!"},null,{"$f":"'Operating Expenditure'!Q45","v":0.68895735640110334},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"-'Consumption & Revenue'!O51","v":0},{"$error":"#DIV/0!"}]
[34,7,{"$error":"#DIV/0!"},53.298999999999999,{"$f":"'Capital Expenditure'!AJ$121","v":1.246},{"$f":"-ROUND((SUM($E$17:E50)/$L$5),3)","v":-3.4870000000000001},51.058,3.4870000000000001,{"$error":"#DIV/0!"},null,{"$f":"'Operating Expenditure'!Q46","v":0.68895735640110334},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"-'Consumption & Revenue'!O52","v":0},{"$error":"#DIV/0!"}]
[35,7,{"$error":"#DIV/0!"},51.058,{"$f":"'Capital Expenditure'!AK$121","v":1.256},{"$f":"-ROUND((SUM($E$17:E51)/$L$5),3)","v":-3.5230000000000001},48.790999999999997,3.5230000000000001,{"$error":"#DIV/0!"},null,{"$f":"'Operating Expenditure'!Q47","v":0.68895735640110334},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"-'Consumption & Revenue'!O53","v":0},{"$error":"#DIV/0!"}]
[36,8,{"$error":"#DIV/0!"},48.790999999999997,{"$f":"'Capital Expenditure'!AL$121","v":1.256},{"$f":"-ROUND((SUM(E18:E52)/$L$5),3)","v":-3.347},46.699999999999996,3.347,{"$error":"#DIV/0!"},null,{"$f":"'Operating Expenditure'!Q48","v":0.68895735640110334},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"-'Consumption & Revenue'!O54","v":0},{"$error":"#DIV/0!"}]
[37,8,{"$error":"#DIV/0!"},46.699999999999996,{"$f":"'Capital Expenditure'!AM$121","v":1.2250000000000001},{"$f":"-ROUND((SUM(E19:E53)/$L$5),3)","v":-3.0880000000000001},44.836999999999996,3.0880000000000001,{"$error":"#DIV/0!"},null,{"$f":"'Operating Expenditure'!Q49","v":0.68895735640110334},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"-'Consumption & Revenue'!O55","v":0},{"$error":"#DIV/0!"}]
[38,8,{"$error":"#DIV/0!"},44.836999999999996,{"$f":"'Capital Expenditure'!AN$121","v":1.2250000000000001},-2.9359999999999999,43.125999999999998,2.9359999999999999,{"$error":"#DIV/0!"},null,{"$f":"'Operating Expenditure'!Q50","v":0.68895735640110334},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"-'Consumption & Revenue'!O56","v":0},{"$error":"#DIV/0!"}]
[39,8,{"$error":"#DIV/0!"},43.125999999999998,{"$f":"'Capital Expenditure'!AO$121","v":1.2250000000000001},-2.859,41.491999999999997,2.859,{"$error":"#DIV/0!"},null,{"$f":"'Operating Expenditure'!Q51","v":0.68895735640110334},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"-'Consumption & Revenue'!O57","v":0},{"$error":"#DIV/0!"}]
[40,8,{"$error":"#DIV/0!"},41.491999999999997,{"$f":"'Capital Expenditure'!AP$121","v":1.2250000000000001},-2.7829999999999999,39.933999999999997,2.7829999999999999,{"$error":"#DIV/0!"},null,{"$f":"'Operating Expenditure'!Q52","v":0.68895735640110334},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"-'Consumption & Revenue'!O58","v":0},{"$error":"#DIV/0!"}]
[]
[]
[null,null,null,null,{"$f":"SUM(E17:E56)","v":129.46299999999994},{"$f":"SUM(F17:F56)","v":-89.528999999999968},{"$f":"SUM(D59:F59)","v":39.933999999999969},89.528999999999968,{"$error":"#DIV/0!"},3.3039999999999994,22.90553177415007,{"$error":"#DIV/0!"},null,null,{"$f":"SUM(O17:O56)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(P17:P56)","v":{"$error":"#DIV/0!"}},0]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Net Present Value  as  per Published",null,null,{"$f":"-NPV(L11,Q17:Q56)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Criteria 3.15 Applicant Determined Cost"]