{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Front Sheet","NIC Funding Request","2020-2021"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":2,"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":"Front Sheet","index":0,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[[16,3,16,4],[14,3,14,9]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Electricity Network Innovation Competition Full Submission "]
[null,null,null,null,null," Spreadsheet "]
[]
[null,null,null,null,null,"(2015 version 1.0)"]
[null,null,null,null,null,"Appendix A"]
[]
[]
[]
[null,null,"Licensee Name:","Western Power Distribution"]
[]
[null,null,"Submission Date:","2015-07-28"]
[]
[]
[]
[null,"Input cells",null," "]
[null,"Totals cells (of formula within worksheet)"]
[null,"Referencing to other worksheets"]
[null,"Check cells"]
[null,"No Input"]
[null,"Descriptions and pack data"]
[null,"Ofgem Input cells"]

{"sheet":"NIC Funding Request","index":1,"n_rows":90,"n_cols":11,"rows_kept":90,"cut":false,"hidden":false,"merged":[]}
["NIC Funding Request"]
[null," ","2015/16","2016/17","2017/18","2018/19","2019/20","2020/21","Total"]
["Total Project Cost","From Project Cost Summary sheet"]
[null,"Labour",71.673766617349443,340.38772350544281,380.5009285865674,298.02382275460917,275.9467527516378,0,1366.5329942156068]
[null,"Equipment",0,0,0,0,0,0,0]
[null,"Contractors",103.09638228994753,1462.4631214719682,1840.063705370862,1317.5796296153605,1025.8794138259334,0,5749.0822525740714]
[null,"IT",0,3009.20431143114,1261.890038817475,705.26637856658476,0,0,4976.3607288151998]
[null,"IPR Costs",0,0,0,0,0,0,0]
[null,"Travel & Expenses",11.374483492083412,178.27019730151596,230.00796317135774,164.69745370192007,128.23492672824167,0,712.58502439511892]
["Payments to users & Contingency",null,20.682736933264486,554.48059485667432,412.49584843847356,276.17414273760818,158.89567703397921,0,1422.7289999999996]
[null,"Decommissioning",0,0,0,0,0,0,0]
[null,"Other",0,0,0,0,0,0,0]
[null,"Total",206.82736933264488,5544.8059485667409,4124.958484384736,2761.7414273760828,1588.956770339792,0,14227.289999999995]
[]
["External funding","Any funding that will be received from Project Partners and/or External Funders - from Project Cost Summary sheet"]
[null,"Labour",0,0,0,0,0,0,0]
[null,"Equipment",0,0,0,0,0,0,0]
[null,"Contractors",0,0,0,0,0,0,0]
[null,"IT",0,0,0,0,0,0,0]
[null,"IPR Costs",0,0,0,0,0,0,0]
[null,"Travel & Expenses",0,0,0,0,0,0,0]
["Payments to users & Contingency",null,0,0,0,0,0,0,0]
[null,"Decommissioning",0,0,0,0,0,0,0]
[null,"Other",0,0,0,0,0,0,0]
[null,"Total",0,0,0,0,0,0,0]
[]
["Licensee extra contribution","Any funding from the Licensee which is in excess of the Licensee Compulsory Contribution - from Project Cost Summary sheet"]
[null,"Labour",0,0,0,0,0,0,0]
[null,"Equipment",0,0,0,0,0,0,0]
[null,"Contractors",0,0,0,0,0,0,0]
[null,"IT",0,0,0,0,0,0,0]
[null,"IPR Costs",0,0,0,0,0,0,0]
[null,"Travel & Expenses",0,0,0,0,0,0,0]
["Payments to users & Contingency",null,0,0,0,0,0,0,0]
[null,"Decommissioning",0,0,0,0,0,0,0]
[null,"Other",0,0,0,0,0,0,0]
[null,"Total",0,0,0,0,0,0,0]
[]
["Initial Net Funding Required",null,"calculated from the tables above"]
[null,"Labour",71.673766617349443,340.38772350544281,380.5009285865674,298.02382275460917,275.9467527516378,0,1366.5329942156068]
[null,"Equipment",0,0,0,0,0,0,0]
[null,"Contractors",103.09638228994753,1462.4631214719682,1840.063705370862,1317.5796296153605,1025.8794138259334,0,5749.0822525740714]
[null,"IT",0,3009.20431143114,1261.890038817475,705.26637856658476,0,0,4976.3607288151998]
[null,"IPR Costs",0,0,0,0,0,0,0]
[null,"Travel & Expenses",11.374483492083412,178.27019730151596,230.00796317135774,164.69745370192007,128.23492672824167,0,712.58502439511892]
["Payments to users & Contingency",null,20.682736933264486,554.48059485667432,412.49584843847356,276.17414273760818,158.89567703397921,0,1422.7289999999996]
[null,"Decommissioning",0,0,0,0,0,0,0,"Check Total = to Initial Net Funding request "]
[null,"Other",0,0,0,0,0,0,0,"in Project Cost Summary"]
[null,"Total",206.82736933264488,5544.8059485667409,4124.958484384736,2761.7414273760828,1588.956770339792,0,14227.289999999995,"OK"]
[]
["Direct Benefits","from Direct Benefits sheet"]
[null,"Total",0,0,0,0,0,0,0]
[]
[]
[]
["Licensee Compulsory Contribution / Direct Benefits",null,null,"from Project Cost Summary sheet"]
[null,"Labour",7.167376661734945,34.038772350544363,38.050092858656704,29.802382275460936,27.594675275163777,0,136.65329942156072]
[null,"Equipment",0,0,0,0,0,0,0]
[null,"Contractors",10.309638228994753,146.24631214719696,184.00637053708647,131.75796296153612,102.58794138259333,0,574.90822525740759]
[null,"IT",0,300.92043114311394,126.18900388174752,70.526637856658482,0,0,497.63607288151991]
[null,"IPR Costs",0,0,0,0,0,0,0]
[null,"Travel & Expenses",1.1374483492083414,17.827019730151612,23.000796317135809,16.469745370192015,12.823492672824166,0,71.258502439511943]
["Payments to users & Contingency",null,2.0682736933264487,55.448059485667429,41.249584843847423,27.617414273760829,15.889567703397919,0,142.27290000000005]
[null,"Decommissioning",0,0,0,0,0,0,0,"of Total Initial Net Funding Required"]
[null,"Other",0,0,0,0,0,0,0,"OK"]
[null,"Total",20.68273693326449,554.48059485667432,412.4958484384739,276.17414273760835,158.89567703397918,0,1422.7290000000003,"Check that Total is = or > than "]
[null,null,null,null,null,null,null,null,null,"Total Direct Benefits"]
[null,null,null,null,null,null,null,null,null,"OK"]
["Outstanding Funding required",null,"calculated from the tables above"]
[null,"Labour",64.506389955614495,306.34895115489843,342.45083572791071,268.22144047914821,248.35207747647402,0,1229.8796947940459]
[null,"Equipment",0,0,0,0,0,0,0]
[null,"Contractors",92.78674406095277,1316.2168093247712,1656.0573348337755,1185.8216666538244,923.29147244334013,0,5174.1740273166643]
[null,"IT",0,2708.283880288026,1135.7010349357274,634.73974070992631,0,0,4478.72465593368]
[null,"IPR Costs",0,0,0,0,0,0,0]
[null,"Travel & Expenses",10.237035142875071,160.44317757136434,207.00716685422194,148.22770833172805,115.41143405541752,0,641.32652195560695]
["Payments to users & Contingency",null,18.614463239938036,499.03253537100687,371.24626359462616,248.55672846384735,143.0061093305813,0,1280.4560999999997]
[null,"Decommissioning",0,0,0,0,0,0,0,"Check that Total is =to "]
[null,"Other",0,0,0,0,0,0,0,"Total Outstanding Funding required"]
[null,"Total",186.14463239938038,4990.3253537100663,3712.4626359462623,2485.5672846384746,1430.0610933058128,0,12804.560999999996,"OK"]
[]
["balance",12614.937620409331,0,7438.4676342998846,3826.2720246271683,1397.028438283329,-6.9161527079313352,3.440871994565331E-2,12614.937620409331]
["interest",null,0,100.26702627354608,56.323698294635271,26.116502314552488,6.9505614278769885,-3.440871993992841E-2,189.62337959067088]
[null,null,null,null,null,null,null,null,12804.561000000002,0]
[]
[null,"Bank of England interest rate",null,5.0000000000000001E-3,null,null,"NIC FUNDING REQUEST   £",null,12614.937620409331]
[null,"interest rate used in calculation",null,0.01]
[null,"RPI adjustment","2015/16","2016/17","2017/18","2018/19","2019/20","2020/21","2021/22","2022/2023","2023/2024"]
[null,"Index",267.582361413,275.87741461680298,284.42961446992388,293.24693251849152,302.33758742656471,311.71005263678819,321.37306426852859,331.33562926085295,341.60703376793936]
[null,"Annual inflation ",3.0999999999999917E-2,3.0999999999999917E-2,3.0999999999999917E-2,3.0999999999999917E-2,3.0999999999999917E-2,3.0999999999999917E-2,3.0999999999999917E-2,3.0999999999999917E-2,3.0999999999999917E-2]
["n.b the Second Tier Funding Request calculation should use the Bank of England Base rate plus 1.5% on 31 June of the year in which the Full Submission is made."]

{"sheet":"2020-2021","index":2,"n_rows":255,"n_cols":90,"rows_kept":255,"cut":false,"hidden":true,"merged":[[3,69,3,78],[3,80,3,89],[3,6,3,15],[3,17,3,23],[3,25,3,34],[3,36,3,45],[3,47,3,56],[3,58,3,67]]}
[null,"Project Costs in 2020-2021"]
[]
[]
[null,null,null,null,null,null,"Total Cost £K",null,null,null,null,null,null,null,null,null,null,"Funding source %",null,null,null,null,null,null,null,"Licensee Compulsory Contribution/Direct Benefits",null,null,null,null,null,null,null,null,null,null,"Project Partner 1",null,null,null,null,null,null,null,null,null,null,"Project Partner 2",null,null,null,null,null,null,null,null,null,null,"Project Partner 3",null,null,null,null,null,null,null,null,null,null,"Licensee Extra Contribution",null,null,null,null,null,null,null,null,null,null,"Outstanding Funding Required"]
[null,null,null,null,null,null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","Decommissioning","Other",null,"Licensee Compulsory Contribution\n/Direct Benefits","Project Partner 1","Project Partner 2","Project Partner 3","Licensee Extra Contribution","Oustanding Funding Required","Total",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","Decommissioning","Other"]
[null,"Description","Task","Project Workstream"]
[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(R7:W7)","v":0},null,{"$f":"$R7*G7","v":0},{"$f":"$R7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$S7*G7","v":0},{"$f":"$S7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$T7*G7","v":0},{"$f":"$T7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$U7*G7","v":0},{"$f":"$U7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$V7*G7","v":0},{"$f":"$V7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$W7*G7","v":0},{"$f":"$W7*H7","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Cost",null,null,null,null,null,null,{"$f":"SUM(R8:W8)","v":0},null,{"$f":"$R8*G8","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$S8*G8","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$T8*G8","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$U8*G8","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$V8*G8","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$W8*G8","v":0},0,0,0,0,0,0,0,0,0]
[null,"Total",null,null,null,null,{"$f":"SUM(G7:G8)","v":0},{"$f":"SUM(H7:H8)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(G9:P9)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(Z7:Z8)","v":0},{"$f":"SUM(AA7:AA8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(AK7:AK8)","v":0},{"$f":"SUM(AL7:AL8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(AV7:AV8)","v":0},{"$f":"SUM(AW7:AW8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(BG7:BG8)","v":0},{"$f":"SUM(BH7:BH8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(BR7:BR8)","v":0},{"$f":"SUM(BS7:BS8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(CC7:CC8)","v":0},{"$f":"SUM(CD7:CD8)","v":0},0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Totals"]