{"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,"(2018 version 1.0)"]
[null,null,null,null,null,"Appendix A"]
[]
[]
[]
[null,null,"Licensee Name:","National Grid Electricity System Operator"]
[]
[null,null,"Submission Date:","2018-10-19"]
[]
[]
[]
[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":94,"n_cols":13,"rows_kept":94,"cut":false,"hidden":false,"merged":[]}
["NIC Funding Request"]
[null," ","2018/19","2019/20","2020/21","2021/22","2022/23","2023/24","2024/25","2025/26","Total"]
["Total Project Cost","From Project Cost Summary sheet"]
[null,"Labour",349.79596000000004,2043.6411795000001,1771.4677758614998,975.85086126781084,0,0,0,0,5140.7557766293103]
[null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,"Contractors",131.63749999999999,1143.1713400000001,802.60684249999986,166.91156000000001,0,0,0,0,2244.3272425]
[null,"IT",0,0,0,0,0,0,0,0,0]
[null,"IPR Costs",0,0,0,0,0,0,0,0,0]
[null,"Travel & Expenses",72.505709999999993,66.151316369999989,198.17328348917999,15.869363430950639,0,0,0,0,352.69967329013059]
["Payments to users & Contingency",null,35.409693157894722,172.75362294052616,314.85246686743045,61.528310387303151,0,0,0,0,584.54409335315438]
[null,"Decommissioning",0,0,0,0,0,0,0,0,0]
[null,"Other",118.845,29.355,3209.9489686304992,10.406112660000002,0,0,0,0,3368.5550812904989]
[null,"Total",708.19386315789473,3455.0724588105263,6297.0493373486097,1230.5662077460647,0,0,0,0,11690.881867063097]
[]
["External funding","Any funding that will be received from Project Partners and/or External Funders - from Project Cost Summary sheet"]
[null,"Labour",5.6111811957748117,17.653535826727943,14.233864643881409,2.5901646850588347,0,0,0,0,40.088746351443]
[null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,"Contractors",4.6447444950774681,44.803098173272048,12.12750412127493,14.100991314941167,0,0,0,0,75.676338104565616]
[null,"IT",0,0,0,0,0,0,0,0,0]
[null,"IPR Costs",0,0,0,0,0,0,0,0,0]
[null,"Travel & Expenses",0,0,0,0,0,0,0,0,0]
["Payments to users & Contingency",null,0.54282894736842047,3.2871912631578915,1.4114967894736827,0.87848189473684102,0,0,0,0,6.1199988947368356]
[null,"Decommissioning",0,0,0,0,0,0,0,0,0]
[null,"Other",5.782430914772229E-2,0,0.45707023484366566,0,0,0,0,0,0.5148945439913879]
[null,"Total",10.856578947368423,65.743825263157888,28.229935789473689,17.569637894736843,0,0,0,0,122.39997789473684]
[]
["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,0,0]
[null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,"Contractors",0,0,0,0,0,0,0,0,0]
[null,"IT",0,0,0,0,0,0,0,0,0]
[null,"IPR Costs",0,0,0,0,0,0,0,0,0]
[null,"Travel & Expenses",0,0,0,0,0,0,0,0,0]
["Payments to users & Contingency",null,0,0,0,0,0,0,0,0,0]
[null,"Decommissioning",0,0,0,0,0,0,0,0,0]
[null,"Other",0,0,0,0,0,0,0,0,0]
[null,"Total",0,0,0,0,0,0,0,0,0]
[]
["Initial Net Funding Required"]
[null,"Labour",344.18477880422523,2025.9876436732723,1757.2339112176185,973.26069658275196,0,0,0,0,5100.6670302778675]
[null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,"Contractors",126.99275550492251,1098.3682418267281,790.47933837872495,152.81056868505885,0,0,0,0,2168.6509043954343]
[null,"IT",0,0,0,0,0,0,0,0,0]
[null,"IPR Costs",0,0,0,0,0,0,0,0,0]
[null,"Travel & Expenses",72.505709999999993,66.151316369999989,198.17328348917999,15.869363430950639,0,0,0,0,352.69967329013059]
["Payments to users & Contingency",null,34.866864210526302,169.46643167736826,313.44097007795676,60.649828492566307,0,0,0,0,578.42409445841758]
[null,"Decommissioning",0,0,0,0,0,0,0,0,0,"Check Total = to Initial Net Funding request "]
[null,"Other",118.78717569085228,29.355,3209.4918983956554,10.406112660000002,0,0,0,0,3368.0401867465075,"in Project Cost Summary"]
[null,"Total",697.33728421052626,3389.3286335473686,6268.8194015591362,1212.9965698513279,0,0,0,0,11568.481889168361,"OK"]
[]
["Direct Benefits","from Direct Benefits sheet"]
[null,"Total",0,0,0,0,0,0,0,0,0]
[]
[]
[]
["Licensee Compulsory Contribution / Direct Benefits",null,"from Project Cost Summary sheet"]
[null,"Labour",34.979596000000001,204.36411795000001,177.14677758615005,97.585086126781079,0,0,0,0,514.0755776629311]
[null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,"Contractors",13.16375,114.317134,80.260684250000011,16.691155999999999,0,0,0,0,224.43272425000001]
[null,"IT",0,0,0,0,0,0,0,0,0]
[null,"IPR Costs",0,0,0,0,0,0,0,0,0]
[null,"Travel & Expenses",7.2505710000000008,6.6151316369999993,19.817328348918,1.586936343095064,0,0,0,0,35.269967329013063]
["Payments to users & Contingency",null,3.5409693157894715,17.27536229405262,31.485246686743032,6.1528310387303167,0,0,0,0,58.454409335315439]
[null,"Decommissioning",0,0,0,0,0,0,0,0,0,"of Total Initial Net Funding Required"]
[null,"Other",11.884499999999999,2.9355000000000002,320.99489686305003,1.0406112660000002,0,0,0,0,336.85550812905001,"OK"]
[null,"Total",70.819386315789473,345.5072458810526,629.70493373486113,123.05662077460646,0,0,0,0,1169.0881867063097,"Check that Total is = or > than "]
[null,null,null,null,null,null,null,null,null,null,null,"Total Direct Benefits"]
[null,null,null,null,null,null,null,null,null,null,null,"OK"]
["Outstanding Funding required"]
[null,"Labour",309.20518280422522,1821.6235257232722,1580.0871336314685,875.67561045597085,0,0,0,0,4586.5914526149372]
[null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,"Contractors",113.82900550492252,984.05110782672807,710.21865412872489,136.11941268505885,0,0,0,0,1944.2181801454344]
[null,"IT",0,0,0,0,0,0,0,0,0]
[null,"IPR Costs",0,0,0,0,0,0,0,0,0]
[null,"Travel & Expenses",65.255138999999986,59.536184732999992,178.35595514026198,14.282427087855574,0,0,0,0,317.42970596111752]
["Payments to users & Contingency",null,31.32589489473683,152.19106938331564,281.95572339121372,54.496997453835988,0,0,0,0,519.96968512310218]
[null,"Decommissioning",0,0,0,0,0,0,0,0,0,"Check that Total is =to "]
[null,"Other",106.90267569085228,26.419499999999999,2888.4970015326053,9.3655013940000007,0,0,0,0,3031.1846786174578,"Total Outstanding Funding required"]
[null,"Total",626.51789789473673,3043.8213876663158,5639.1144678242754,1089.9399490767214,0,0,0,0,10399.39370246205,"OK"]
[]
["balance",10271.609193386654,0,6601.269907825601,1046.5198355073869,-5.1811648526695464,2.5528500604040438E-2,-2.496811562870925E-4,-1.2328705904832577E-4,-1.2515190012500288E-4,-2.496811562870925E-4,10271.609193386654]
["interest",null,0,84.364395506061271,38.238948716664943,5.2066933532735868,-2.5778181760327531E-2,1.2639409723876673E-4,-1.8648410766770915E-6,-1.2421947958666435E-6,1.2639409723876673E-4,127.78450907539806]
[null,null,null,null,null,null,null,null,null,null,null,10399.393702462052,0]
[]
[null,"Bank of England interest rate",null,5.0000000000000001E-3,null,null,"NIC FUNDING REQUEST   £",null,null,null,null,10271.609193386654]
[null,"interest rate used in calculation",null,0.01]
[null,"RPI adjustment","2018/19","2019/20","2020/21","2021/22","2022/23","2023/24","2024/25","2025/26"]
[null,"Annual inflation ",3.3000000000000002E-2,0.03,3.0499999999999999E-2,3.2000000000000001E-2,3.2000000000000001E-2,3.2000000000000001E-2,3.2000000000000001E-2,3.2000000000000001E-2]
["n.b the NIC Funding Request calculation should use the Bank of England Base rate plus 0.5% on 30 June of the year in which the Full Submission is made."]
[]
[]
[null,null,null,"Bank of England Base Rate: https://www.bankofengland.co.uk/boeapps/iadb/Repo.asp "]
[null,null,null,"RPI Forecast 2018/19-202223: https://www.gov.uk/government/statistics/forecasts-for-the-uk-economy-may-2018 "]
[null,null,null,"RPI for 2023/24 and thereafter is an extension from 2022/23 as no further consistent forecast is available. "]