{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Front Sheet","NIC Funding Request"],"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 K"]
[]
[]
[]
[null,null,"Licensee Name:","Electricity North West Limited"]
[]
[null,null,"Submission Date:","2015-10-27"]
[]
[]
[]
[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",null,null,null,null,null,null,1203362.07]
[null,"Equipment",null,null,null,null,null,null,1416766.52]
[null,"Contractors",null,null,null,null,null,null,1883086.28]
[null,"IT",null,null,null,null,null,null,223636.12]
[null,"IPR Costs",null,null,null,null,null,null,0]
[null,"Travel & Expenses",null,null,null,null,null,null,0]
["Payments to users & Contigency",null,null,null,null,null,null,null,568066.80000000005]
[null,"Decommissioning",null,null,null,null,null,null,29357.759999999998]
[null,"Other",null,null,null,null,null,null,230089.5]
[null,"Total",416946.35,2507691.63,1093328.6499999999,815561.12,720837.3,0,5554365.0499999998]
[]
["External funding","Any funding that will be received from Project Partners and/or External Funders - from Project Cost Summary sheet"]
[null,"Labour",null,null,null,null,null,null,0]
[null,"Equipment"]
[null,"Contractors"]
[null,"IT"]
[null,"IPR Costs",null,null,null,null,null,null,0]
[null,"Travel & Expenses",null,null,null,null,null,null,0]
["Payments to users & Contigency",null,null,null,null,null,null,null,0]
[null,"Decommissioning",null,null,null,null,null,null,0]
[null,"Other",null,null,null,null,null,null,0]
[null,"Total",31893.15,94630.98,39204.479999999996,20184.46,30657.590000000004,0,216570.65999999997]
[]
["Licensee extra contribution","Any funding from the Licensee which is in excess of the Licensee Compulsory Contribution - from Project Cost Summary sheet"]
[null,"Labour",null,null,null,null,null,null,0]
[null,"Equipment",null,null,null,null,null,null,0]
[null,"Contractors",null,null,null,null,null,null,0]
[null,"IT",null,null,null,null,null,null,0]
[null,"IPR Costs",null,null,null,null,null,null,0]
[null,"Travel & Expenses",null,null,null,null,null,null,0]
["Payments to users & Contigency",null,null,null,null,null,null,null,0]
[null,"Decommissioning",null,null,null,null,null,null,0]
[null,"Other",null,null,null,null,null,null,0]
[null,"Total",0,0,0,0,0,0,0]
[]
["Initial Net Funding Required",null,"calculated from the tables above"]
[null,"Labour",null,null,null,null,null,null,1203362.07]
[null,"Equipment",null,null,null,null,null,null,1333237.01]
[null,"Contractors",null,null,null,null,null,null,1764545.12]
[null,"IT",null,null,null,null,null,null,209136.13]
[null,"IPR Costs",null,null,null,null,null,null,0]
[null,"Travel & Expenses",null,null,null,null,null,null,0]
["Payments to users & Contigency",null,null,null,null,null,null,null,568066.80000000005]
[null,"Decommissioning",null,null,null,null,null,null,29357.759999999998,"Check Total = to Initial Net Funding request "]
[null,"Other",null,null,null,null,null,null,230089.5,"in Project Cost Summary"]
[null,"Total",385053.19999999995,2413060.65,1054124.17,795376.66,690179.71000000008,0,5337794.3899999997,"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",null,null,null,null,null,null,533779.83000000007]
[null,"Equipment",null,null,null,null,null,null,0]
[null,"Contractors",null,null,null,null,null,null,0]
[null,"IT",null,null,null,null,null,null,0]
[null,"IPR Costs",null,null,null,null,null,null,0]
[null,"Travel & Expenses",null,null,null,null,null,null,0]
["Payments to users & Contigency",null,null,null,null,null,null,null,0]
[null,"Decommissioning",null,null,null,null,null,null,0,"of Total Initial Net Funding Required"]
[null,"Other",null,null,null,null,null,null,0,"OK"]
[null,"Total",0,73382.45,116645.54000000001,178453.02,165298.82,0,533779.83000000007,"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",null,null,null,null,null,null,669582.24]
[null,"Equipment",null,null,null,null,null,null,1333237.01]
[null,"Contractors",null,null,null,null,null,null,1764545.12]
[null,"IT",null,null,null,null,null,null,209136.13]
[null,"IPR Costs",null,null,null,null,null,null,0]
[null,"Travel & Expenses",null,null,null,null,null,null,0]
["Payments to users & Contigency",null,null,null,null,null,null,null,568066.80000000005]
[null,"Decommissioning",null,null,null,null,null,null,29357.759999999998,"Check that Total is =to "]
[null,"Other",null,null,null,null,null,null,230089.5,"Total Outstanding Funding required"]
[null,"Total",385053.19999999995,2339678.1999999997,937478.62999999989,616923.64,524880.89000000013,0,4804014.5599999996,"OK"]
[]
["balance",4743833.5097028734,0,2019102.1097028735,1115438.1577999024,514187.21913741622,-2545.5439778973159,12.6643979002788,4743833.5097028734]
["interest",null,0,33814.678097028736,15672.701337513879,8148.1268846865933,2558.2083757975947,-12.664397899985186,60181.050297126814]
[null,null,null,null,null,null,null,null,4804014.5600000005,0]
[]
[null,"Bank of England interest rate",null,5.0000000000000001E-3,null,null,"NIC FUNDING REQUEST   £",null,4743833.5097028734]
[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."]