{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Front Sheet","NIC Funding Request","Direct Benefits","Project Cost Summary","2018-2019","2019-2020","2020-2021","2021-2022","2022-2023","2023-2024","2024-2025","2025-2026","Whole project","Project Direction"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":46,"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:","London Power Networks plc"]
[]
[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",{"$f":"'[2]Project Cost Summary'!C22","v":125.89999999999998},{"$f":"'[2]Project Cost Summary'!C39","v":501.06000000000017},{"$f":"'[2]Project Cost Summary'!C56","v":493.05000000000007},{"$f":"'[2]Project Cost Summary'!C73","v":418.40999999999997},{"$f":"'Project Cost Summary'!C90","v":0},{"$f":"'Project Cost Summary'!D90","v":0},{"$f":"'Project Cost Summary'!E90","v":0},{"$f":"'Project Cost Summary'!F90","v":0},1538.42]
[null,"Equipment",{"$f":"'[2]Project Cost Summary'!D22","v":0},{"$f":"'[2]Project Cost Summary'!D39","v":3639.5},{"$f":"'[2]Project Cost Summary'!D56","v":9018.52},{"$f":"'[2]Project Cost Summary'!D73","v":0},{"$f":"'Project Cost Summary'!D90","v":0},{"$f":"'Project Cost Summary'!E90","v":0},{"$f":"'Project Cost Summary'!F90","v":0},{"$f":"'Project Cost Summary'!G90","v":0},12658.02]
[null,"Contractors",{"$f":"'[2]Project Cost Summary'!E22","v":1059.3999999999999},{"$f":"'[2]Project Cost Summary'!E39","v":4236.1500000000005},{"$f":"'[2]Project Cost Summary'!E56","v":4158.4100000000008},{"$f":"'[2]Project Cost Summary'!E73","v":2911.4100000000003},{"$f":"'Project Cost Summary'!E90","v":0},{"$f":"'Project Cost Summary'!F90","v":0},{"$f":"'Project Cost Summary'!G90","v":0},{"$f":"'Project Cost Summary'!H90","v":0},12365.37]
[null,"IT",{"$f":"'[2]Project Cost Summary'!F22","v":224},{"$f":"'[2]Project Cost Summary'!F39","v":3098.89},{"$f":"'[2]Project Cost Summary'!F56","v":2456.23},{"$f":"'[2]Project Cost Summary'!F73","v":1196.1299999999997},{"$f":"'Project Cost Summary'!F90","v":0},{"$f":"'Project Cost Summary'!G90","v":0},{"$f":"'Project Cost Summary'!H90","v":0},{"$f":"'Project Cost Summary'!I90","v":0},6975.25]
[null,"IPR Costs",{"$f":"'[2]Project Cost Summary'!G22","v":0},{"$f":"'[2]Project Cost Summary'!G39","v":0},{"$f":"'[2]Project Cost Summary'!G56","v":0},{"$f":"'[2]Project Cost Summary'!G73","v":0},{"$f":"'Project Cost Summary'!G90","v":0},{"$f":"'Project Cost Summary'!H90","v":0},{"$f":"'Project Cost Summary'!I90","v":0},{"$f":"'Project Cost Summary'!J90","v":0},0]
[null,"Travel & Expenses",{"$f":"'[2]Project Cost Summary'!H22","v":1.19},{"$f":"'[2]Project Cost Summary'!H39","v":6.5399999999999991},{"$f":"'[2]Project Cost Summary'!H56","v":5.9399999999999995},{"$f":"'[2]Project Cost Summary'!H73","v":5.45},{"$f":"'Project Cost Summary'!H90","v":0},{"$f":"'Project Cost Summary'!I90","v":0},{"$f":"'Project Cost Summary'!J90","v":0},{"$f":"'Project Cost Summary'!K90","v":0},19.119999999999997]
["Payments to users & Contingency",null,{"$f":"'[2]Project Cost Summary'!I22+'[2]Project Cost Summary'!J22","v":0},{"$f":"'[2]Project Cost Summary'!I39+'[2]Project Cost Summary'!J39","v":0},{"$f":"'[2]Project Cost Summary'!I56+'[2]Project Cost Summary'!J56","v":0},{"$f":"'[2]Project Cost Summary'!I73+'[2]Project Cost Summary'!J73","v":0},{"$f":"'Project Cost Summary'!I90+'Project Cost Summary'!J90","v":0},{"$f":"'Project Cost Summary'!J90+'Project Cost Summary'!K90","v":0},{"$f":"'Project Cost Summary'!K90+'Project Cost Summary'!L90","v":0},{"$f":"'Project Cost Summary'!L90+'Project Cost Summary'!M90","v":0},0]
[null,"Decommissioning",{"$f":"'[2]Project Cost Summary'!K22","v":0},{"$f":"'[2]Project Cost Summary'!K39","v":0},{"$f":"'[2]Project Cost Summary'!K56","v":0},{"$f":"'[2]Project Cost Summary'!K73","v":0},{"$f":"'Project Cost Summary'!K90","v":0},{"$f":"'Project Cost Summary'!L90","v":0},{"$f":"'Project Cost Summary'!M90","v":0},{"$f":"'Project Cost Summary'!N90","v":0},0]
[null,"Other",{"$f":"'[2]Project Cost Summary'!L22","v":8},{"$f":"'[2]Project Cost Summary'!L39","v":12},{"$f":"'[2]Project Cost Summary'!L56","v":646.41},{"$f":"'[2]Project Cost Summary'!L73","v":468.27},{"$f":"'Project Cost Summary'!L90","v":0},{"$f":"'Project Cost Summary'!M90","v":0},{"$f":"'Project Cost Summary'!N90","v":0},{"$f":"'Project Cost Summary'!O90","v":0},1134.6799999999998]
[null,"Total",{"$f":"SUM(C4:C12)","v":1418.4899999999998},11494.140000000001,16778.560000000001,4999.67,{"$f":"SUM(G4:G12)","v":0},{"$f":"SUM(H4:H12)","v":0},0,0,34690.86]
[]
["External funding","Any funding that will be received from Project Partners and/or External Funders - from Project Cost Summary sheet"]
[null,"Labour",{"$f":"'[2]Project Cost Summary'!C30","v":3.8250000000000002},{"$f":"'[2]Project Cost Summary'!C47","v":14.770000000000001},{"$f":"'[2]Project Cost Summary'!C64","v":14.576000000000001},{"$f":"'[2]Project Cost Summary'!C81","v":12.783000000000001},{"$f":"'Project Cost Summary'!C98","v":0},{"$f":"'Project Cost Summary'!D98","v":0},{"$f":"'Project Cost Summary'!E98","v":0},{"$f":"'Project Cost Summary'!F98","v":0},45.954000000000008]
[null,"Equipment",{"$f":"'[2]Project Cost Summary'!D30","v":0},{"$f":"'[2]Project Cost Summary'!D47","v":2889.5},{"$f":"'[2]Project Cost Summary'!D64","v":8568.52},{"$f":"'[2]Project Cost Summary'!D81","v":0},{"$f":"'Project Cost Summary'!D98","v":0},{"$f":"'Project Cost Summary'!E98","v":0},{"$f":"'Project Cost Summary'!F98","v":0},{"$f":"'Project Cost Summary'!G98","v":0},11458.02]
[null,"Contractors",{"$f":"'[2]Project Cost Summary'!E30","v":249.48320000000001},{"$f":"'[2]Project Cost Summary'!E47","v":1006.772},{"$f":"'[2]Project Cost Summary'!E64","v":1046.9680000000001},{"$f":"'[2]Project Cost Summary'!E81","v":706.74639999999999},{"$f":"'Project Cost Summary'!E98","v":0},{"$f":"'Project Cost Summary'!F98","v":0},{"$f":"'Project Cost Summary'!G98","v":0},{"$f":"'Project Cost Summary'!H98","v":0},3009.9696000000004]
[null,"IT",{"$f":"'[2]Project Cost Summary'!F30","v":22.4},{"$f":"'[2]Project Cost Summary'!F47","v":420.71100000000001},{"$f":"'[2]Project Cost Summary'!F64","v":908.66110000000003},{"$f":"'[2]Project Cost Summary'!F81","v":374.60039999999998},{"$f":"'Project Cost Summary'!F98","v":0},{"$f":"'Project Cost Summary'!G98","v":0},{"$f":"'Project Cost Summary'!H98","v":0},{"$f":"'Project Cost Summary'!I98","v":0},1726.3725000000002]
[null,"IPR Costs",{"$f":"'[2]Project Cost Summary'!G30","v":0},{"$f":"'[2]Project Cost Summary'!G47","v":0},{"$f":"'[2]Project Cost Summary'!G64","v":0},{"$f":"'[2]Project Cost Summary'!G81","v":0},{"$f":"'Project Cost Summary'!G98","v":0},{"$f":"'Project Cost Summary'!H98","v":0},{"$f":"'Project Cost Summary'!I98","v":0},{"$f":"'Project Cost Summary'!J98","v":0},0]
[null,"Travel & Expenses",{"$f":"'[2]Project Cost Summary'!H30","v":0},{"$f":"'[2]Project Cost Summary'!H47","v":0.27},{"$f":"'[2]Project Cost Summary'!H64","v":0.24},{"$f":"'[2]Project Cost Summary'!H81","v":0.22000000000000003},{"$f":"'Project Cost Summary'!H98","v":0},{"$f":"'Project Cost Summary'!I98","v":0},{"$f":"'Project Cost Summary'!J98","v":0},{"$f":"'Project Cost Summary'!K98","v":0},0.73]
["Payments to users & Contingency",null,{"$f":"'[2]Project Cost Summary'!I30+'[2]Project Cost Summary'!J30","v":0},{"$f":"'[2]Project Cost Summary'!I47+'[2]Project Cost Summary'!J47","v":0},{"$f":"'[2]Project Cost Summary'!I64+'[2]Project Cost Summary'!J64","v":0},{"$f":"'[2]Project Cost Summary'!I81+'[2]Project Cost Summary'!J81","v":0},{"$f":"'Project Cost Summary'!I98+'Project Cost Summary'!K98","v":0},{"$f":"'Project Cost Summary'!J98+'Project Cost Summary'!L98","v":0},{"$f":"'Project Cost Summary'!K98+'Project Cost Summary'!M98","v":0},{"$f":"'Project Cost Summary'!L98+'Project Cost Summary'!N98","v":0},0]
[null,"Decommissioning",{"$f":"'[2]Project Cost Summary'!K30","v":0},{"$f":"'[2]Project Cost Summary'!K47","v":0},{"$f":"'[2]Project Cost Summary'!K64","v":0},{"$f":"'[2]Project Cost Summary'!K81","v":0},{"$f":"'Project Cost Summary'!K98","v":0},{"$f":"'Project Cost Summary'!L98","v":0},{"$f":"'Project Cost Summary'!M98","v":0},{"$f":"'Project Cost Summary'!N98","v":0},0]
[null,"Other",{"$f":"'[2]Project Cost Summary'!L30","v":0},{"$f":"'[2]Project Cost Summary'!L47","v":0},{"$f":"'[2]Project Cost Summary'!L64","v":0},{"$f":"'[2]Project Cost Summary'!L81","v":0},{"$f":"'Project Cost Summary'!L98","v":0},{"$f":"'Project Cost Summary'!M98","v":0},{"$f":"'Project Cost Summary'!N98","v":0},{"$f":"'Project Cost Summary'!O98","v":0},0]
[null,"Total",{"$f":"SUM(C16:C24)","v":275.70819999999998},4332.0230000000001,10538.965099999999,1094.3498,{"$f":"SUM(G16:G24)","v":0},{"$f":"SUM(H16:H24)","v":0},0,0,16241.0461]
[]
["Licensee extra contribution","Any funding from the Licensee which is in excess of the Licensee Compulsory Contribution - from Project Cost Summary sheet"]
[null,"Labour",{"$f":"'[2]Project Cost Summary'!C31","v":0},{"$f":"'[2]Project Cost Summary'!C48","v":0},{"$f":"'[2]Project Cost Summary'!C65","v":0},{"$f":"'[2]Project Cost Summary'!C82","v":0},{"$f":"'Project Cost Summary'!C99","v":0},{"$f":"'Project Cost Summary'!D99","v":0},{"$f":"'Project Cost Summary'!E99","v":0},{"$f":"'Project Cost Summary'!F99","v":0},0]
[null,"Equipment",{"$f":"'[2]Project Cost Summary'!D31","v":0},{"$f":"'[2]Project Cost Summary'!D48","v":0},{"$f":"'[2]Project Cost Summary'!D65","v":0},{"$f":"'[2]Project Cost Summary'!D82","v":0},{"$f":"'Project Cost Summary'!D99","v":0},{"$f":"'Project Cost Summary'!E99","v":0},{"$f":"'Project Cost Summary'!F99","v":0},{"$f":"'Project Cost Summary'!G99","v":0},0]
[null,"Contractors",{"$f":"'[2]Project Cost Summary'!E31","v":0},{"$f":"'[2]Project Cost Summary'!E48","v":0},{"$f":"'[2]Project Cost Summary'!E65","v":0},{"$f":"'[2]Project Cost Summary'!E82","v":0},{"$f":"'Project Cost Summary'!E99","v":0},{"$f":"'Project Cost Summary'!F99","v":0},{"$f":"'Project Cost Summary'!G99","v":0},{"$f":"'Project Cost Summary'!H99","v":0},0]
[null,"IT",{"$f":"'[2]Project Cost Summary'!F31","v":0},{"$f":"'[2]Project Cost Summary'!F48","v":0},{"$f":"'[2]Project Cost Summary'!F65","v":0},{"$f":"'[2]Project Cost Summary'!F82","v":0},{"$f":"'Project Cost Summary'!E99","v":0},{"$f":"'Project Cost Summary'!F99","v":0},{"$f":"'Project Cost Summary'!G99","v":0},{"$f":"'Project Cost Summary'!H99","v":0},0]
[null,"IPR Costs",{"$f":"'[2]Project Cost Summary'!G31","v":0},{"$f":"'[2]Project Cost Summary'!G48","v":0},{"$f":"'[2]Project Cost Summary'!G65","v":0},{"$f":"'[2]Project Cost Summary'!G82","v":0},{"$f":"'Project Cost Summary'!F99","v":0},{"$f":"'Project Cost Summary'!G99","v":0},{"$f":"'Project Cost Summary'!H99","v":0},{"$f":"'Project Cost Summary'!I99","v":0},0]
[null,"Travel & Expenses",{"$f":"'[2]Project Cost Summary'!H31","v":0},{"$f":"'[2]Project Cost Summary'!H48","v":0},{"$f":"'[2]Project Cost Summary'!H65","v":0},{"$f":"'[2]Project Cost Summary'!H82","v":0},{"$f":"'Project Cost Summary'!G99","v":0},{"$f":"'Project Cost Summary'!H99","v":0},{"$f":"'Project Cost Summary'!I99","v":0},{"$f":"'Project Cost Summary'!J99","v":0},0]
["Payments to users & Contingency",null,{"$f":"'[2]Project Cost Summary'!I31+'[2]Project Cost Summary'!J31","v":0},{"$f":"'[2]Project Cost Summary'!I48+'[2]Project Cost Summary'!J48","v":0},{"$f":"'[2]Project Cost Summary'!I65+'[2]Project Cost Summary'!J65","v":0},{"$f":"'[2]Project Cost Summary'!I82","v":0},{"$f":"'Project Cost Summary'!I99+'Project Cost Summary'!J99","v":0},{"$f":"'Project Cost Summary'!J99+'Project Cost Summary'!K99","v":0},{"$f":"'Project Cost Summary'!K99+'Project Cost Summary'!L99","v":0},{"$f":"'Project Cost Summary'!L99+'Project Cost Summary'!M99","v":0},0]
[null,"Decommissioning",{"$f":"'[2]Project Cost Summary'!K31","v":0},{"$f":"'[2]Project Cost Summary'!K48","v":0},{"$f":"'[2]Project Cost Summary'!K65","v":0},{"$f":"'[2]Project Cost Summary'!K82","v":0},{"$f":"'Project Cost Summary'!K99","v":0},{"$f":"'Project Cost Summary'!L99","v":0},{"$f":"'Project Cost Summary'!M99","v":0},{"$f":"'Project Cost Summary'!N99","v":0},0]
[null,"Other",{"$f":"'[2]Project Cost Summary'!L31","v":0},{"$f":"'[2]Project Cost Summary'!L48","v":0},{"$f":"'[2]Project Cost Summary'!L65","v":0},{"$f":"'[2]Project Cost Summary'!L82","v":0},{"$f":"'Project Cost Summary'!L99","v":0},{"$f":"'Project Cost Summary'!M99","v":0},{"$f":"'Project Cost Summary'!N99","v":0},{"$f":"'Project Cost Summary'!O99","v":0},0]
[null,"Total",{"$f":"SUM(C28:C36)","v":0},0,0,0,{"$f":"SUM(G28:G36)","v":0},{"$f":"SUM(H28:H36)","v":0},0,0,0]
[]
["Initial Net Funding Required"]
[null,"Labour",{"$f":"C4-C16-C28","v":122.07499999999997},486.29000000000019,478.47400000000005,405.62699999999995,{"$f":"G4-G16-G28","v":0},{"$f":"H4-H16-H28","v":0},0,0,1492.4660000000001]
[null,"Equipment",0,750,450,0,{"$f":"G5-G17-G29","v":0},{"$f":"H5-H17-H29","v":0},0,0,1200]
[null,"Contractors",809.91679999999985,3229.3780000000006,3111.4420000000009,2204.6636000000003,{"$f":"G6-G18-G30","v":0},{"$f":"H6-H18-H30","v":0},0,0,9355.4004000000004]
[null,"IT",201.6,2678.1790000000001,1547.5689,821.52959999999962,{"$f":"G7-G19-G31","v":0},{"$f":"H7-H19-H31","v":0},0,0,5248.8774999999996]
[null,"IPR Costs",0,0,0,0,{"$f":"G8-G20-G32","v":0},{"$f":"H8-H20-H32","v":0},0,0,0]
[null,"Travel & Expenses",1.19,6.27,5.6999999999999993,5.23,{"$f":"G9-G21-G33","v":0},{"$f":"H9-H21-H33","v":0},0,0,18.389999999999997]
["Payments to users & Contingency",null,0,0,0,0,{"$f":"G10-G22-G34","v":0},{"$f":"H10-H22-H34","v":0},0,0,0]
[null,"Decommissioning",0,0,0,0,{"$f":"G11-G23-G35","v":0},{"$f":"H11-H23-H35","v":0},0,0,0,"Check Total = to Initial Net Funding request "]
[null,"Other",8,12,646.41,468.27,{"$f":"G12-G24-G36","v":0},{"$f":"H12-H24-H36","v":0},0,0,1134.6799999999998,"in Project Cost Summary"]
[null,"Total",1142.7817999999997,7162.1170000000011,6239.5949000000019,3905.3202000000001,{"$f":"G13-G25-G37","v":0},{"$f":"H13-H25-H37","v":0},0,0,18449.813900000001,{"$f":"IF(K49='Project Cost Summary'!M15,\"OK\",\"ERROR\")","v":"ERROR"}]
[]
["Direct Benefits","from Direct Benefits sheet"]
[null,"Total",{"$f":"'[2]Direct Benefits'!D11","v":0},{"$f":"'[2]Direct Benefits'!E11","v":0},{"$f":"'[2]Direct Benefits'!F11","v":0},{"$f":"'[2]Direct Benefits'!G11","v":0},{"$f":"'Direct Benefits'!K11","v":0},{"$f":"'Direct Benefits'!L11","v":0},{"$f":"'Direct Benefits'!M11","v":0},{"$f":"'Direct Benefits'!N11","v":0},{"$f":"SUM(C52:J52)","v":0}]
[]
[]
[]
["Licensee Compulsory Contribution / Direct Benefits",null,"from Project Cost Summary sheet"]
[null,"Labour",{"$f":"'[2]Project Cost Summary'!C33","v":14.8259975},{"$f":"'[2]Project Cost Summary'!C50","v":142.05955400000002},{"$f":"'[2]Project Cost Summary'!C67","v":179.236369},{"$f":"'[2]Project Cost Summary'!C84","v":149.96833800000002},{"$f":"'Project Cost Summary'!C101","v":0},{"$f":"'Project Cost Summary'!D101","v":0},{"$f":"'Project Cost Summary'!E101","v":0},{"$f":"'Project Cost Summary'!F101","v":0},486.0902585]
[null,"Equipment",{"$f":"'[2]Project Cost Summary'!D33","v":0},{"$f":"'[2]Project Cost Summary'!D50","v":0},{"$f":"'[2]Project Cost Summary'!D67","v":0},{"$f":"'[2]Project Cost Summary'!D84","v":0},{"$f":"'Project Cost Summary'!D101","v":0},{"$f":"'Project Cost Summary'!E101","v":0},{"$f":"'Project Cost Summary'!F101","v":0},{"$f":"'Project Cost Summary'!G101","v":0},0]
[null,"Contractors",{"$f":"'[2]Project Cost Summary'!E33","v":0},{"$f":"'[2]Project Cost Summary'!E50","v":0},{"$f":"'[2]Project Cost Summary'!E67","v":0},{"$f":"'[2]Project Cost Summary'!E84","v":0},{"$f":"'Project Cost Summary'!E101","v":0},{"$f":"'Project Cost Summary'!F101","v":0},{"$f":"'Project Cost Summary'!G101","v":0},{"$f":"'Project Cost Summary'!H101","v":0},0]
[null,"IT",{"$f":"'[2]Project Cost Summary'!F33","v":33.599999999999994},{"$f":"'[2]Project Cost Summary'!F50","v":713.04593999999997},{"$f":"'[2]Project Cost Summary'!F67","v":11.61225},{"$f":"'[2]Project Cost Summary'!F84","v":14.19275},{"$f":"'Project Cost Summary'!F101","v":0},{"$f":"'Project Cost Summary'!G101","v":0},{"$f":"'Project Cost Summary'!H101","v":0},{"$f":"'Project Cost Summary'!I101","v":0},772.45094000000006]
[null,"IPR Costs",{"$f":"'[2]Project Cost Summary'!G33","v":0},{"$f":"'[2]Project Cost Summary'!G50","v":0},{"$f":"'[2]Project Cost Summary'!G67","v":0},{"$f":"'[2]Project Cost Summary'!G84","v":0},{"$f":"'Project Cost Summary'!G101","v":0},{"$f":"'Project Cost Summary'!H101","v":0},{"$f":"'Project Cost Summary'!I101","v":0},{"$f":"'Project Cost Summary'!J101","v":0},0]
[null,"Travel & Expenses",{"$f":"'[2]Project Cost Summary'!H33","v":0.20128849999999998},{"$f":"'[2]Project Cost Summary'!H50","v":1.543776},{"$f":"'[2]Project Cost Summary'!H67","v":1.826994},{"$f":"'[2]Project Cost Summary'!H84","v":1.677325},{"$f":"'Project Cost Summary'!H101","v":0},{"$f":"'Project Cost Summary'!I101","v":0},{"$f":"'Project Cost Summary'!J101","v":0},{"$f":"'Project Cost Summary'!K101","v":0},5.2493834999999995]
["Payments to users & Contingency",null,{"$f":"'[2]Project Cost Summary'!I33+'[2]Project Cost Summary'!J33","v":0},{"$f":"'[2]Project Cost Summary'!I50+'[2]Project Cost Summary'!J50","v":0},{"$f":"'[2]Project Cost Summary'!I67+'[2]Project Cost Summary'!J67","v":0},{"$f":"'[2]Project Cost Summary'!I84+'[2]Project Cost Summary'!J84","v":0},{"$f":"'Project Cost Summary'!I101+'Project Cost Summary'!J101","v":0},{"$f":"'Project Cost Summary'!J101+'Project Cost Summary'!K101","v":0},{"$f":"'Project Cost Summary'!K101+'Project Cost Summary'!L101","v":0},{"$f":"'Project Cost Summary'!L101+'Project Cost Summary'!M101","v":0},0]
[null,"Decommissioning",{"$f":"'[2]Project Cost Summary'!K33","v":0},{"$f":"'[2]Project Cost Summary'!K50","v":0},{"$f":"'[2]Project Cost Summary'!K67","v":0},{"$f":"'[2]Project Cost Summary'!K84","v":0},{"$f":"'Project Cost Summary'!K101","v":0},{"$f":"'Project Cost Summary'!L101","v":0},{"$f":"'Project Cost Summary'!M101","v":0},{"$f":"'Project Cost Summary'!N101","v":0},0,"of Total Initial Net Funding Required"]
[null,"Other",{"$f":"'[2]Project Cost Summary'!L33","v":1.3532},{"$f":"'[2]Project Cost Summary'!L50","v":4.8243},{"$f":"'[2]Project Cost Summary'!L67","v":333.61220099999997},{"$f":"'[2]Project Cost Summary'!L84","v":241.67414700000003},{"$f":"'Project Cost Summary'!L101","v":0},{"$f":"'Project Cost Summary'!M101","v":0},{"$f":"'Project Cost Summary'!N101","v":0},{"$f":"'Project Cost Summary'!O101","v":0},581.46384799999998,{"$f":"IF(K66>=K49*0.1,\"OK\",\"ERROR\")","v":"OK"}]
[null,"Total",{"$f":"SUM(C57:C65)","v":49.980485999999992},861.47357,526.28781400000003,407.51256000000001,{"$f":"SUM(G57:G65)","v":0},{"$f":"SUM(H57:H65)","v":0},0,0,1845.25443,"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,{"$f":"IF(K66>=K52,\"OK\",\"ERROR\")","v":"OK"}]
["Outstanding Funding required"]
[null,"Labour",{"$f":"C40-C57","v":107.24900249999997},344.23044600000014,299.23763100000008,255.65866199999994,{"$f":"G40-G57","v":0},0,0,0,1006.3757415000001]
[null,"Equipment",0,750,450,0,0,0,0,0,1200]
[null,"Contractors",809.91679999999985,3229.3780000000006,3111.4420000000009,2204.6636000000003,0,0,0,0,9355.4004000000023]
[null,"IT",168,1965.1330600000001,1535.9566500000001,807.33684999999957,0,0,0,0,4476.4265599999999]
[null,"IPR Costs",0,0,0,0,0,0,0,0,0]
[null,"Travel & Expenses",0.98871149999999997,4.7262239999999993,3.8730059999999993,3.5526750000000007,0,0,0,0,13.1406165]
["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,"Check that Total is =to "]
[null,"Other",6.6467999999999998,7.1757,312.797799,226.59585299999995,0,0,0,0,553.21615199999997,"Total Outstanding Funding required"]
[null,"Total",1092.8013139999998,6300.643430000001,5713.3070860000016,3497.80764,0,0,0,0,16604.55947,{"$f":"IF(K79='Project Cost Summary'!M17, \"OK\",\"ERROR\")","v":"ERROR"}]
[]
["balance",16398.497669989454,0,{"$f":"B81-C79-D79","v":9005.0529259894538},{"$f":"D81-E79+D82","v":3418.7635929693465},{"$f":"E81-F79+E82","v":-16.924964435859472},{"$f":"F81-G79+F82","v":8.4228706807962794E-2},{"$f":"G81-H79+G82","v":2.5028162705248436E-5},4.4629683755858867E-4,4.4865346255990783E-4,{"$f":"G81-G79+G82","v":2.5028162705248436E-5},{"$f":"B81","v":16398.497669989454}]
["interest",null,0,{"$f":"((B81+D81)/2)*$D86","v":127.01775297989454},{"$f":"((D81+E81)/2)*$D86","v":62.119082594794001},{"$f":"((E81+F81)/2)*$D86","v":17.009193142667435},{"$f":"((F81+G81)/2)*$D86","v":-8.4203678645257546E-2},{"$f":"((G81+H81)/2)*$D86","v":4.2126867485334024E-4},2.3566250013191857E-6,4.4747515005924823E-6,{"$f":"((G81+K81)/2)*$D86","v":4.2126867485334024E-4},{"$f":"SUM(D82:K82)","v":206.06267440743693}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"L81+L82","v":16604.56034439689},{"$f":"K79-L83","v":-8.7439689013990574E-4}]
[]
[null,"Bank of England interest rate",null,5.0000000000000001E-3,null,null,"NIC FUNDING REQUEST   £",null,null,null,null,{"$f":"L81","v":16398.497669989454}]
[null,"interest rate used in calculation",null,{"$f":"D85+0.5%","v":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. "]

{"sheet":"Direct Benefits","index":2,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[6,1,7,1],[2,0,4,6],[6,2,6,11]]}
["Direct Benefits"]
[]
["Direct Benefit: Any benefits of the Project accruing to the Licensee during the Project Implementation, comprising any expenditure included within the Network Lincesee Business plan for RIIO-T1 or ED1 that will be saved as a result of undertaking the project"]
[]
[]
[]
[null,"Description of Direct Benefit"]
[null,null,"2017/18","2018/19","2019/20","2020/21","2021/22","2022/23","2023/24","2024/25","2025/26","Total"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C9:K9)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C10:K10)","v":0}]
[null,"Total Direct Benefits",{"$f":"SUM(C9:C10)","v":0},0,0,0,0,0,0,0,0,0]
[]
[]
[null,"n.b. These are Direct Benefits associated with the Project itself, not the wider deployment of the Solution and therefore should not extend beyond the Project period."]

{"sheet":"Project Cost Summary","index":3,"n_rows":153,"n_cols":15,"rows_kept":153,"cut":false,"hidden":false,"merged":[[87,2,87,12],[53,2,53,12],[70,2,70,12],[52,2,52,12],[1,2,1,12],[19,2,19,12],[18,2,18,12],[69,2,69,12],[36,2,36,12],[35,2,35,12],[2,2,2,12],[86,2,86,12],[137,2,137,12],[138,2,138,12],[104,2,104,12],[103,2,103,12],[120,2,120,12],[121,2,121,12]]}
["Project Cost Summary"]
[null,null,"Total"]
[null,null,"Cost type"]
[null,null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other","Total"]
[null,"Total Project Cost",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C5:L5)","v":0}]
[null,"Hitachi Vantara",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C6:L6)","v":0}]
[null,"Hitachi Europe",null,null,null,null,null,null,null,null,null,null,0]
[null,"Hitachi Capital",null,null,null,null,null,null,null,null,null,null,0]
[null,"Royal Mail",null,null,null,null,null,null,null,null,null,null,0]
[null,"Centrica",null,null,null,null,null,null,null,null,null,null,0]
[null,"Uber",null,null,null,null,null,null,null,null,null,null,0]
[null,"SSEN",null,null,null,null,null,null,null,null,null,null,0]
[null,"External Funding",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C13:L13)","v":0}]
[null,"Licensee extra contribution",null,null,null,null,null,null,null,null,null,null,0]
[null,"Initial Net Funding Required",null,null,null,null,null,null,null,null,null,null,0,null,"Check Total Initial Net Funding Required matches that on the Second Tier Funding Request tab"]
[null,"Licensee Compulsory Contribution / Direct Benefits",null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ABS(M15-'NIC Funding Request'!K49)<0.01,\"OK\",\"ERROR\")","v":"ERROR"}]
[null,"Outstanding Funding Required",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C17:L17)","v":0}]
[]
[null,null,"2018/19"]
[null,null,"Cost type"]
[null,null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other","Total"]
[null,"Total Project Cost",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C22:L22)","v":0}]
[null,"Hitachi Vantara",null,null,null,null,null,null,null,null,null,null,0]
[null,"Hitachi Europe",null,null,null,null,null,null,null,null,null,null,0]
[null,"Hitachi Capital",null,null,null,null,null,null,null,null,null,null,0]
[null,"Royal Mail",null,null,null,null,null,null,null,null,null,null,0]
[null,"Centrica",null,null,null,null,null,null,null,null,null,null,0]
[null,"Uber",null,null,null,null,null,null,null,null,null,null,0]
[null,"SSEN",null,null,null,null,null,null,null,null,null,null,0]
[null,"External Funding",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C30:L30)","v":0}]
[null,"Licensee extra contribution",null,null,null,null,null,null,null,null,null,null,0]
[null,"Initial Net Funding Required",null,null,null,null,null,null,null,null,null,null,0]
[null,"Licensee Compulsory Contribution / Direct Benefits",null,null,null,null,null,null,null,null,null,null,0]
[null,"Outstanding Funding Required",null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,"2019/20"]
[null,null,"Cost type"]
[null,null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other","Total"]
[null,"Total Project Cost"]
[null,"Hitachi Vantara"]
[null,"Hitachi Europe"]
[null,"Hitachi Capital"]
[null,"Royal Mail"]
[null,"Centrica"]
[null,"Uber"]
[null,"SSEN"]
[null,"External Funding"]
[null,"Licensee extra contribution"]
[null,"Initial Net Funding Required"]
[null,"Licensee Compulsory Contribution / Direct Benefits"]
[null,"Outstanding Funding Required"]
[]
[null,null,"2020/21"]
[null,null,"Cost type"]
[null,null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other","Total"]
[null,"Total Project Cost"]
[null,"Hitachi Vantara"]
[null,"Hitachi Europe"]
[null,"Hitachi Capital"]
[null,"Royal Mail"]
[null,"Centrica"]
[null,"Uber"]
[null,"SSEN"]
[null,"External Funding"]
[null,"Licensee extra contribution"]
[null,"Initial Net Funding Required"]
[null,"Licensee Compulsory Contribution / Direct Benefits"]
[null,"Outstanding Funding Required"]
[]
[null,null,"2021/22"]
[null,null,"Cost type"]
[null,null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other","Total"]
[null,"Total Project Cost"]
[null,"Hitachi Vantara"]
[null,"Hitachi Europe"]
[null,"Hitachi Capital"]
[null,"Royal Mail"]
[null,"Centrica"]
[null,"Uber"]
[null,"SSEN"]
[null,"External Funding"]
[null,"Licensee extra contribution"]
[null,"Initial Net Funding Required"]
[null,"Licensee Compulsory Contribution"]
[null,"Outstanding Funding Required"]
[]
[null,null,"2022/23"]
[null,null,"Cost type"]
[null,null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other","Total"]
[null,"Total Project Cost",{"$f":"'2022-2023'!G96","v":0},{"$f":"'2022-2023'!H96","v":0},{"$f":"'2022-2023'!I96","v":0},{"$f":"'2022-2023'!J96","v":0},{"$f":"'2022-2023'!K96","v":0},{"$f":"'2022-2023'!L96","v":0},{"$f":"'2022-2023'!M96","v":0},{"$f":"'2022-2023'!N96","v":0},{"$f":"'2022-2023'!O96","v":0},{"$f":"'2022-2023'!P96","v":0},{"$f":"SUM(C90:L90)","v":0}]
[null,"Hitachi Vantara",{"$f":"'2022-2023'!AO96","v":0},{"$f":"'2022-2023'!AP96","v":0},{"$f":"'2022-2023'!AQ96","v":0},{"$f":"'2022-2023'!AR96","v":0},{"$f":"'2022-2023'!AS96","v":0},{"$f":"'2022-2023'!AT96","v":0},{"$f":"'2022-2023'!AU96","v":0},{"$f":"'2022-2023'!AV96","v":0},{"$f":"'2022-2023'!AW96","v":0},{"$f":"'2022-2023'!AX96","v":0},0]
[null,"Hitachi Europe",{"$f":"'2022-2023'!AZ96","v":0},{"$f":"'2022-2023'!BA96","v":0},{"$f":"'2022-2023'!BB96","v":0},{"$f":"'2022-2023'!BC96","v":0},{"$f":"'2022-2023'!BD96","v":0},{"$f":"'2022-2023'!BE96","v":0},{"$f":"'2022-2023'!BF96","v":0},{"$f":"'2022-2023'!BG96","v":0},{"$f":"'2022-2023'!BH96","v":0},{"$f":"'2022-2023'!BI96","v":0},0]
[null,"Hitachi Capital",{"$f":"'2022-2023'!BK96","v":0},{"$f":"'2021-2022'!BL109","v":0},{"$f":"'2021-2022'!BM109","v":0},{"$f":"'2021-2022'!BN109","v":0},{"$f":"'2021-2022'!BO109","v":0},{"$f":"'2021-2022'!BP109","v":0},{"$f":"'2021-2022'!BQ109","v":0},{"$f":"'2021-2022'!BR109","v":0},{"$f":"'2021-2022'!BS109","v":0},{"$f":"'2021-2022'!BT109","v":0},0]
[null,"Royal Mail",{"$f":"'2022-2023'!BV96","v":0},{"$f":"'2022-2023'!BW96","v":0},{"$f":"'2022-2023'!BX96","v":0},{"$f":"'2022-2023'!BY96","v":0},{"$f":"'2022-2023'!BZ96","v":0},{"$f":"'2022-2023'!CA96","v":0},{"$f":"'2022-2023'!CB96","v":0},{"$f":"'2022-2023'!CC96","v":0},{"$f":"'2022-2023'!CD96","v":0},{"$f":"'2022-2023'!CE96","v":0},0]
[null,"Centrica",{"$f":"'2022-2023'!CG96","v":0},{"$f":"'2022-2023'!CH96","v":0},{"$f":"'2022-2023'!CI96","v":0},{"$f":"'2022-2023'!CJ96","v":0},{"$f":"'2022-2023'!CK96","v":0},{"$f":"'2022-2023'!CL96","v":0},{"$f":"'2022-2023'!CM96","v":0},{"$f":"'2022-2023'!CN96","v":0},{"$f":"'2022-2023'!CO96","v":0},{"$f":"'2022-2023'!CP96","v":0},0]
[null,"Uber",{"$f":"'2022-2023'!CR96","v":0},{"$f":"'2022-2023'!CS96","v":0},{"$f":"'2022-2023'!CT96","v":0},{"$f":"'2022-2023'!CU96","v":0},{"$f":"'2022-2023'!CV96","v":0},{"$f":"'2022-2023'!CW96","v":0},{"$f":"'2022-2023'!CX96","v":0},{"$f":"'2022-2023'!CY96","v":0},{"$f":"'2022-2023'!CZ96","v":0},{"$f":"'2022-2023'!DA96","v":0},0]
[null,"SSEN",{"$f":"'2022-2023'!DC96","v":0},{"$f":"'2022-2023'!DD96","v":0},{"$f":"'2022-2023'!DE96","v":0},{"$f":"'2022-2023'!DF96","v":0},{"$f":"'2022-2023'!DG96","v":0},{"$f":"'2022-2023'!DH96","v":0},{"$f":"'2022-2023'!DI96","v":0},{"$f":"'2022-2023'!DJ96","v":0},{"$f":"'2022-2023'!DK96","v":0},{"$f":"'2022-2023'!DL96","v":0},0]
[null,"External Funding",{"$f":"SUM(C91:C97)","v":0},{"$f":"SUM(D91:D97)","v":0},0,0,0,0,0,0,0,0,0]
[null,"Licensee extra contribution",{"$f":"'2022-2023'!DN96","v":0},{"$f":"'2022-2023'!DO96","v":0},{"$f":"'2022-2023'!DP96","v":0},{"$f":"'2022-2023'!DQ96","v":0},{"$f":"'2022-2023'!DR96","v":0},{"$f":"'2022-2023'!DS96","v":0},{"$f":"'2022-2023'!DT96","v":0},{"$f":"'2022-2023'!DU96","v":0},{"$f":"'2022-2023'!DV96","v":0},{"$f":"'2022-2023'!DW96","v":0},0]
[null,"Initial Net Funding Required",{"$f":"C90-C98-C99","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Licensee Compulsory Contribution",{"$f":"'2022-2023'!AD96","v":0},{"$f":"'2022-2023'!AE96","v":0},{"$f":"'2022-2023'!AF96","v":0},{"$f":"'2022-2023'!AG96","v":0},{"$f":"'2022-2023'!AH96","v":0},{"$f":"'2022-2023'!AI96","v":0},{"$f":"'2022-2023'!AJ96","v":0},{"$f":"'2022-2023'!AK96","v":0},{"$f":"'2022-2023'!AL96","v":0},{"$f":"'2022-2023'!AM96","v":0},0]
[null,"Outstanding Funding Required",{"$f":"'2022-2023'!DY96","v":0},{"$f":"'2022-2023'!DZ96","v":0},{"$f":"'2022-2023'!EA96","v":0},{"$f":"'2022-2023'!EB96","v":0},{"$f":"'2022-2023'!EC96","v":0},{"$f":"'2022-2023'!ED96","v":0},{"$f":"'2022-2023'!EE96","v":0},{"$f":"'2022-2023'!EF96","v":0},{"$f":"'2022-2023'!EG96","v":0},{"$f":"'2022-2023'!EH96","v":0},0]
[]
[null,null,"2023/24"]
[null,null,"Cost type"]
[null,null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other","Total"]
[null,"Total Project Cost",{"$f":"'2023-2024'!G9","v":0},{"$f":"'2023-2024'!H9","v":0},{"$f":"'2023-2024'!I9","v":0},{"$f":"'2023-2024'!J9","v":0},{"$f":"'2023-2024'!K9","v":0},{"$f":"'2023-2024'!L9","v":0},{"$f":"'2023-2024'!M9","v":0},{"$f":"'2023-2024'!N9","v":0},{"$f":"'2023-2024'!O9","v":0},{"$f":"'2023-2024'!P9","v":0},{"$f":"SUM(C107:L107)","v":0}]
[null,"Hitachi Vantara",{"$f":"'2023-2024'!AO9","v":0},{"$f":"'2023-2024'!AP9","v":0},{"$f":"'2023-2024'!AQ9","v":0},{"$f":"'2023-2024'!AR9","v":0},{"$f":"'2023-2024'!AS9","v":0},{"$f":"'2023-2024'!AT9","v":0},{"$f":"'2023-2024'!AU9","v":0},{"$f":"'2023-2024'!AV9","v":0},{"$f":"'2023-2024'!AW9","v":0},{"$f":"'2023-2024'!AX9","v":0},0]
[null,"Hitachi Europe",{"$f":"'2023-2024'!AZ9","v":0},{"$f":"'2023-2024'!BA9","v":0},{"$f":"'2023-2024'!BB9","v":0},{"$f":"'2023-2024'!BC9","v":0},{"$f":"'2023-2024'!BD9","v":0},{"$f":"'2023-2024'!BE9","v":0},{"$f":"'2023-2024'!BF9","v":0},{"$f":"'2023-2024'!BG9","v":0},{"$f":"'2023-2024'!BH9","v":0},{"$f":"'2023-2024'!BI9","v":0},0]
[null,"Hitachi Capital",{"$f":"'2023-2024'!BK9","v":0},{"$f":"'2023-2024'!BL35","v":0},{"$f":"'2023-2024'!BM35","v":0},{"$f":"'2023-2024'!BN35","v":0},{"$f":"'2023-2024'!BO35","v":0},{"$f":"'2023-2024'!BP35","v":0},{"$f":"'2023-2024'!BQ35","v":0},{"$f":"'2023-2024'!BR35","v":0},{"$f":"'2023-2024'!BS35","v":0},{"$f":"'2023-2024'!BT35","v":0},0]
[null,"Royal Mail",{"$f":"'2022-2023'!BV96","v":0},{"$f":"'2022-2023'!BW96","v":0},{"$f":"'2022-2023'!BX96","v":0},{"$f":"'2022-2023'!BY96","v":0},{"$f":"'2022-2023'!BZ96","v":0},{"$f":"'2022-2023'!CA96","v":0},{"$f":"'2022-2023'!CB96","v":0},{"$f":"'2022-2023'!CC96","v":0},{"$f":"'2022-2023'!CD96","v":0},{"$f":"'2022-2023'!CE96","v":0},0]
[null,"Centrica",{"$f":"'2023-2024'!CG9","v":0},{"$f":"'2023-2024'!CH9","v":0},{"$f":"'2023-2024'!CI9","v":0},{"$f":"'2023-2024'!CJ9","v":0},{"$f":"'2023-2024'!CK9","v":0},{"$f":"'2023-2024'!CL9","v":0},{"$f":"'2023-2024'!CM9","v":0},{"$f":"'2023-2024'!CN9","v":0},{"$f":"'2023-2024'!CO9","v":0},{"$f":"'2023-2024'!CP9","v":0},0]
[null,"Uber",{"$f":"'2023-2024'!CR9","v":0},{"$f":"'2023-2024'!CS9","v":0},{"$f":"'2023-2024'!CT9","v":0},{"$f":"'2023-2024'!CU9","v":0},{"$f":"'2023-2024'!CV9","v":0},{"$f":"'2023-2024'!CW9","v":0},{"$f":"'2023-2024'!CX9","v":0},{"$f":"'2023-2024'!CY9","v":0},{"$f":"'2023-2024'!CZ9","v":0},{"$f":"'2023-2024'!DA9","v":0},0]
[null,"SSEN",{"$f":"'2023-2024'!DC9","v":0},{"$f":"'2023-2024'!DD9","v":0},{"$f":"'2023-2024'!DE9","v":0},{"$f":"'2023-2024'!DF9","v":0},{"$f":"'2023-2024'!DG9","v":0},{"$f":"'2023-2024'!DH9","v":0},{"$f":"'2023-2024'!DI9","v":0},{"$f":"'2023-2024'!DJ9","v":0},{"$f":"'2023-2024'!DK9","v":0},{"$f":"'2023-2024'!DL9","v":0},0]
[null,"External Funding",{"$f":"SUM(C108:C114)","v":0},{"$f":"SUM(D108:D114)","v":0},0,0,0,0,0,0,0,0,0]
[null,"Licensee extra contribution",{"$f":"'2023-2024'!DN9","v":0},{"$f":"'2023-2024'!DO9","v":0},{"$f":"'2023-2024'!DP9","v":0},{"$f":"'2023-2024'!DQ9","v":0},{"$f":"'2023-2024'!DR9","v":0},{"$f":"'2023-2024'!DS9","v":0},{"$f":"'2023-2024'!DT9","v":0},{"$f":"'2023-2024'!DU9","v":0},{"$f":"'2023-2024'!DV9","v":0},{"$f":"'2023-2024'!DW9","v":0},0]
[null,"Initial Net Funding Required",{"$f":"C107-C115-C116","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Licensee Compulsory Contribution",{"$f":"'2023-2024'!AD9","v":0},{"$f":"'2023-2024'!AE9","v":0},{"$f":"'2023-2024'!AF9","v":0},{"$f":"'2023-2024'!AG9","v":0},{"$f":"'2023-2024'!AH9","v":0},{"$f":"'2023-2024'!AI9","v":0},{"$f":"'2023-2024'!AJ9","v":0},{"$f":"'2023-2024'!AK9","v":0},{"$f":"'2023-2024'!AL9","v":0},{"$f":"'2023-2024'!AM9","v":0},0]
[null,"Outstanding Funding Required",{"$f":"'2023-2024'!DY9","v":0},{"$f":"'2023-2024'!DZ9","v":0},{"$f":"'2023-2024'!EA9","v":0},{"$f":"'2023-2024'!EB9","v":0},{"$f":"'2023-2024'!EC9","v":0},{"$f":"'2023-2024'!ED9","v":0},{"$f":"'2023-2024'!EE9","v":0},{"$f":"'2023-2024'!EF9","v":0},{"$f":"'2023-2024'!EG9","v":0},{"$f":"'2023-2024'!EH9","v":0},0]
[]
[null,null,"2024/25"]
[null,null,"Cost type"]
[null,null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other","Total"]
[null,"Total Project Cost",{"$f":"'2024-2025'!G9","v":0},{"$f":"'2024-2025'!H9","v":0},{"$f":"'2024-2025'!I9","v":0},{"$f":"'2024-2025'!J9","v":0},{"$f":"'2024-2025'!K9","v":0},{"$f":"'2024-2025'!L9","v":0},{"$f":"'2024-2025'!M9","v":0},{"$f":"'2024-2025'!N9","v":0},{"$f":"'2024-2025'!O9","v":0},{"$f":"'2024-2025'!P9","v":0},{"$f":"SUM(C124:L124)","v":0}]
[null,"Hitachi Vantara",{"$f":"'2024-2025'!AO9","v":0},{"$f":"'2024-2025'!AP9","v":0},{"$f":"'2024-2025'!AQ9","v":0},{"$f":"'2024-2025'!AR9","v":0},{"$f":"'2024-2025'!AS9","v":0},{"$f":"'2024-2025'!AT9","v":0},{"$f":"'2024-2025'!AU9","v":0},{"$f":"'2024-2025'!AV9","v":0},{"$f":"'2024-2025'!AW9","v":0},{"$f":"'2024-2025'!AX9","v":0},0]
[null,"Hitachi Europe",{"$f":"'2024-2025'!AZ9","v":0},{"$f":"'2024-2025'!BA9","v":0},{"$f":"'2024-2025'!BB9","v":0},{"$f":"'2024-2025'!BC9","v":0},{"$f":"'2024-2025'!BD9","v":0},{"$f":"'2024-2025'!BE9","v":0},{"$f":"'2024-2025'!BF9","v":0},{"$f":"'2024-2025'!BG9","v":0},{"$f":"'2024-2025'!BH9","v":0},{"$f":"'2024-2025'!BI9","v":0},0]
[null,"Hitachi Capital",{"$f":"'2024-2025'!BK9","v":0},{"$f":"'2024-2025'!BL9","v":0},{"$f":"'2024-2025'!BM9","v":0},{"$f":"'2024-2025'!BN9","v":0},{"$f":"'2024-2025'!BO9","v":0},{"$f":"'2024-2025'!BP9","v":0},{"$f":"'2024-2025'!BQ9","v":0},{"$f":"'2024-2025'!BR9","v":0},{"$f":"'2024-2025'!BS9","v":0},{"$f":"'2024-2025'!BT9","v":0},0]
[null,"Royal Mail",{"$f":"'2024-2025'!BV9","v":0},{"$f":"'2024-2025'!BW9","v":0},{"$f":"'2024-2025'!BX9","v":0},{"$f":"'2024-2025'!BY9","v":0},{"$f":"'2024-2025'!BZ9","v":0},{"$f":"'2024-2025'!CA9","v":0},{"$f":"'2024-2025'!CB9","v":0},{"$f":"'2024-2025'!CC9","v":0},{"$f":"'2024-2025'!CD9","v":0},{"$f":"'2024-2025'!CE9","v":0},0]
[null,"Centrica",{"$f":"'2024-2025'!CG9","v":0},{"$f":"'2024-2025'!CH9","v":0},{"$f":"'2024-2025'!CI9","v":0},{"$f":"'2024-2025'!CJ9","v":0},{"$f":"'2024-2025'!CK9","v":0},{"$f":"'2024-2025'!CL9","v":0},{"$f":"'2024-2025'!CM9","v":0},{"$f":"'2024-2025'!CN9","v":0},{"$f":"'2024-2025'!CO9","v":0},{"$f":"'2024-2025'!CP9","v":0},0]
[null,"Uber",{"$f":"'2024-2025'!CR9","v":0},{"$f":"'2024-2025'!CS9","v":0},{"$f":"'2024-2025'!CT9","v":0},{"$f":"'2024-2025'!CU9","v":0},{"$f":"'2024-2025'!CV9","v":0},{"$f":"'2024-2025'!CW9","v":0},{"$f":"'2024-2025'!CX9","v":0},{"$f":"'2024-2025'!CY9","v":0},{"$f":"'2024-2025'!CZ9","v":0},{"$f":"'2024-2025'!DA9","v":0},0]
[null,"SSEN",{"$f":"'2024-2025'!DC9","v":0},{"$f":"'2024-2025'!DD9","v":0},{"$f":"'2024-2025'!DE9","v":0},{"$f":"'2024-2025'!DF9","v":0},{"$f":"'2024-2025'!DG9","v":0},{"$f":"'2024-2025'!DH9","v":0},{"$f":"'2024-2025'!DI9","v":0},{"$f":"'2024-2025'!DJ9","v":0},{"$f":"'2024-2025'!DK9","v":0},{"$f":"'2024-2025'!DL9","v":0},0]
[null,"External Funding",{"$f":"SUM(C125:C131)","v":0},{"$f":"SUM(D125:D131)","v":0},0,0,0,0,0,0,0,0,0]
[null,"Licensee extra contribution",{"$f":"'2024-2025'!DN9","v":0},{"$f":"'2024-2025'!DO9","v":0},{"$f":"'2024-2025'!DP9","v":0},{"$f":"'2024-2025'!DQ9","v":0},{"$f":"'2024-2025'!DR9","v":0},{"$f":"'2024-2025'!DS9","v":0},{"$f":"'2024-2025'!DT9","v":0},{"$f":"'2024-2025'!DU9","v":0},{"$f":"'2024-2025'!DV9","v":0},{"$f":"'2024-2025'!DW9","v":0},0]
[null,"Initial Net Funding Required",{"$f":"C124-C132-C133","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Licensee Compulsory Contribution",{"$f":"'2024-2025'!AD9","v":0},{"$f":"'2024-2025'!AE9","v":0},{"$f":"'2024-2025'!AF9","v":0},{"$f":"'2024-2025'!AG9","v":0},{"$f":"'2024-2025'!AH9","v":0},{"$f":"'2024-2025'!AI9","v":0},{"$f":"'2024-2025'!AJ9","v":0},{"$f":"'2024-2025'!AK9","v":0},{"$f":"'2024-2025'!AL9","v":0},{"$f":"'2024-2025'!AM9","v":0},0]
[null,"Outstanding Funding Required",{"$f":"'2024-2025'!DY9","v":0},{"$f":"'2024-2025'!DZ9","v":0},{"$f":"'2024-2025'!EA9","v":0},{"$f":"'2024-2025'!EB9","v":0},{"$f":"'2024-2025'!EC9","v":0},{"$f":"'2024-2025'!ED9","v":0},{"$f":"'2024-2025'!EE9","v":0},{"$f":"'2024-2025'!EF9","v":0},{"$f":"'2024-2025'!EG9","v":0},{"$f":"'2024-2025'!EH9","v":0},0]
[]
[null,null,"2025/26"]
[null,null,"Cost type"]
[null,null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other","Total"]
[null,"Total Project Cost",{"$f":"'2025-2026'!G22","v":0},{"$f":"'2025-2026'!H9","v":0},{"$f":"'2025-2026'!I9","v":0},{"$f":"'2025-2026'!J9","v":0},{"$f":"'2025-2026'!K9","v":0},{"$f":"'2025-2026'!L9","v":0},{"$f":"'2025-2026'!M9","v":0},{"$f":"'2025-2026'!N9","v":0},{"$f":"'2025-2026'!O9","v":0},{"$f":"'2025-2026'!P9","v":0},{"$f":"SUM(C141:L141)","v":0}]
[null,"Hitachi Vantara",{"$f":"'2025-2026'!AO22","v":0},{"$f":"'2025-2026'!AP9","v":0},{"$f":"'2025-2026'!AQ9","v":0},{"$f":"'2025-2026'!AR9","v":0},{"$f":"'2025-2026'!AS9","v":0},{"$f":"'2025-2026'!AT9","v":0},{"$f":"'2025-2026'!AU9","v":0},{"$f":"'2025-2026'!AV9","v":0},{"$f":"'2025-2026'!AW9","v":0},{"$f":"'2025-2026'!AX9","v":0},0]
[null,"Hitachi Europe",{"$f":"'2025-2026'!AZ22","v":0},{"$f":"'2025-2026'!BA9","v":0},{"$f":"'2025-2026'!BB9","v":0},{"$f":"'2025-2026'!BC9","v":0},{"$f":"'2025-2026'!BD9","v":0},{"$f":"'2025-2026'!BE9","v":0},{"$f":"'2025-2026'!BF9","v":0},{"$f":"'2025-2026'!BG9","v":0},{"$f":"'2025-2026'!BH9","v":0},{"$f":"'2025-2026'!BI9","v":0},0]
[null,"Hitachi Capital",{"$f":"'2025-2026'!BK22","v":0},{"$f":"'2025-2026'!BL61","v":0},{"$f":"'2025-2026'!BM61","v":0},{"$f":"'2025-2026'!BN61","v":0},{"$f":"'2025-2026'!BO61","v":0},{"$f":"'2025-2026'!BP61","v":0},{"$f":"'2025-2026'!BQ61","v":0},{"$f":"'2025-2026'!BR61","v":0},{"$f":"'2025-2026'!BS61","v":0},{"$f":"'2025-2026'!BT61","v":0},0]
[null,"Royal Mail",{"$f":"'2025-2026'!BV9","v":0},{"$f":"'2025-2026'!BW9","v":0},{"$f":"'2025-2026'!BX9","v":0},{"$f":"'2025-2026'!BY9","v":0},{"$f":"'2025-2026'!BZ9","v":0},{"$f":"'2025-2026'!CA9","v":0},{"$f":"'2025-2026'!CB9","v":0},{"$f":"'2025-2026'!CC9","v":0},{"$f":"'2025-2026'!CD9","v":0},{"$f":"'2025-2026'!CE9","v":0},0]
[null,"Centrica",{"$f":"'2025-2026'!CG9","v":0},{"$f":"'2025-2026'!CH9","v":0},{"$f":"'2025-2026'!CI9","v":0},{"$f":"'2025-2026'!CJ9","v":0},{"$f":"'2025-2026'!CK9","v":0},{"$f":"'2025-2026'!CL9","v":0},{"$f":"'2025-2026'!CM9","v":0},{"$f":"'2025-2026'!CN9","v":0},{"$f":"'2025-2026'!CO9","v":0},{"$f":"'2025-2026'!CP9","v":0},0]
[null,"Uber",{"$f":"'2025-2026'!CR9","v":0},{"$f":"'2025-2026'!CS9","v":0},{"$f":"'2025-2026'!CT9","v":0},{"$f":"'2025-2026'!CU9","v":0},{"$f":"'2025-2026'!CV9","v":0},{"$f":"'2025-2026'!CW9","v":0},{"$f":"'2025-2026'!CX9","v":0},{"$f":"'2025-2026'!CY9","v":0},{"$f":"'2025-2026'!CZ9","v":0},{"$f":"'2025-2026'!DA9","v":0},0]
[null,"SSEN",{"$f":"'2025-2026'!DC9","v":0},{"$f":"'2025-2026'!DD9","v":0},{"$f":"'2025-2026'!DE9","v":0},{"$f":"'2025-2026'!DF9","v":0},{"$f":"'2025-2026'!DG9","v":0},{"$f":"'2025-2026'!DH9","v":0},{"$f":"'2025-2026'!DI9","v":0},{"$f":"'2025-2026'!DJ9","v":0},{"$f":"'2025-2026'!DK9","v":0},{"$f":"'2025-2026'!DL9","v":0},0]
[null,"External Funding",{"$f":"SUM(C142:C148)","v":0},{"$f":"SUM(D142:D148)","v":0},0,0,0,0,0,0,0,0,0]
[null,"Licensee extra contribution",{"$f":"'2025-2026'!DN9","v":0},{"$f":"'2025-2026'!DO9","v":0},{"$f":"'2025-2026'!DP9","v":0},{"$f":"'2025-2026'!DQ9","v":0},{"$f":"'2025-2026'!DR9","v":0},{"$f":"'2025-2026'!DS9","v":0},{"$f":"'2025-2026'!DT9","v":0},{"$f":"'2025-2026'!DU9","v":0},{"$f":"'2025-2026'!DV9","v":0},{"$f":"'2025-2026'!DW9","v":0},0]
[null,"Initial Net Funding Required",{"$f":"C141-C149-C150","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Licensee Compulsory Contribution",{"$f":"'2025-2026'!AD9","v":0},{"$f":"'2025-2026'!AE9","v":0},{"$f":"'2025-2026'!AF9","v":0},{"$f":"'2025-2026'!AG9","v":0},{"$f":"'2025-2026'!AH9","v":0},{"$f":"'2025-2026'!AI9","v":0},{"$f":"'2025-2026'!AJ9","v":0},{"$f":"'2025-2026'!AK9","v":0},{"$f":"'2025-2026'!AL9","v":0},{"$f":"'2025-2026'!AM9","v":0},0]
[null,"Outstanding Funding Required",{"$f":"'2025-2026'!DY9","v":0},{"$f":"'2025-2026'!DZ9","v":0},{"$f":"'2025-2026'!EA9","v":0},{"$f":"'2025-2026'!EB9","v":0},{"$f":"'2025-2026'!EC9","v":0},{"$f":"'2025-2026'!ED9","v":0},{"$f":"'2025-2026'!EE9","v":0},{"$f":"'2025-2026'!EF9","v":0},{"$f":"'2025-2026'!EG9","v":0},{"$f":"'2025-2026'!EH9","v":0},0]

{"sheet":"2018-2019","index":4,"n_rows":96,"n_cols":138,"rows_kept":96,"cut":false,"hidden":false,"merged":[[3,128,3,137],[3,117,3,126],[3,6,3,15],[3,17,3,27],[3,29,3,38],[3,40,3,49],[3,51,3,60],[3,62,3,71],[3,73,3,82],[3,84,3,93],[3,95,3,104],[3,106,3,115]]}
[null,"Project Costs in 2018-2019"]
[]
[]
[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,null,null,null,null,"Licensee Compulsory Contribution/Direct Benefits",null,null,null,null,null,null,null,null,null,null,"Hitachi Vantara",null,null,null,null,null,null,null,null,null,null,"Hitachi Europe",null,null,null,null,null,null,null,null,null,null,"Hitachi Capital",null,null,null,null,null,null,null,null,null,null,"Royal Mail",null,null,null,null,null,null,null,null,null,null,"Centrica",null,null,null,null,null,null,null,null,null,null,"Uber",null,null,null,null,null,null,null,null,null,null,"SSEN",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","Contingency","Decommissioning","Other",null,"Licensee Compulsory Contribution\n/Direct Benefits","Hitachi Vantara","Hitachi Europe","Hitachi Capital","Royal Mail","Centrica","Uber","SSEN","Licensee Extra Contribution","Oustanding Funding Required","Total",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other"]
[null,"Description","Task","Project Workstream"]
[null,"UKPN Standards Engineer","Home trial","WS1"]
[null,"UKPN Income Management","Home trial","WS1"]
[null,"T&S for FATs etc","Home trial","WS1"]
[null,"UKPN Asset Engineer","Depot trial","WS2"]
[null,"UKPN Connections Designer","Depot trial","WS2"]
[null,"UKPN Customer Relationship Manager","Depot trial","WS2"]
[null,"UKPN Standards Engineer","Depot trial","WS2"]
[null,"UKPN IS resource","Depot trial","WS2"]
[null,"Procurement / support","Depot trial","WS2"]
[null,"Vendor (profiled connections tool)","Depot trial","WS2"]
[null,"Site visits (T&S)","Depot trial","WS2"]
[null,"UKPN Asset Engineer","Mixed trial","WS3"]
[null,"UKPN Connections Designer","Mixed trial","WS3"]
[null,"UKPN Customer Relationship Manager","Mixed trial","WS3"]
[null,"Flexibility payments (WS1)","DSR trialing Home","WS1"]
[null,"Flexibility payments (WS2)","DSR trialing Depot","WS2"]
[null,"ANM/DERMS modification (contractor)","DNO system integration","WS4"]
[null,"Systems integration (contractor)","DNO system integration","WS4"]
[null,"GSA/Netmap mofication (contractor)","DNO system integration","WS4"]
[null,"Cloud service","DNO system integration","WS4"]
[null,"Piclo platform","DNO system integration","WS4"]
[null,"Procurement / support","Procurement","WS4"]
[null,"UKPN DSO Engineer (x 3 - 4 people)","DNO system integration","WS4"]
[null,"UKPN IS architect","DNO system integration","WS4"]
[null,"UKPN IS Project Manager","DNO system integration","WS4"]
[null,"UKPN Control Systems and Automation Engineer","DNO system integration","WS4"]
[null,"UKPN Asset Information engineer","DNO system integration","WS4"]
[null,"UKPN Review","Project review","WS6"]
[null,"Academic partner","External data analysis","WS6"]
[null,"UKPN Data analyst","Data analysis","WS6"]
[null,"Learning events","Dissemination","WS7"]
[null,"LCNI Contribution","Dissemination","WS7"]
[null,"UKPN Project Manager","Project management","WS7"]
[null,"UKPN Project Support (x3 people)","Project management","WS7"]
[null,"UKPN T&S","Project management","WS7"]
[null,"UKPN Comms Lead","Project communications","WS7"]
[null,"UKPN Legal","Legal/contract advice","WS7"]
[null,"UKPN Contingency","n/a","WS7"]
[null,"SSEN Standards Engineer","Home trial","WS1"]
[null,"SSEN Asset Engineer","Depot trial","WS2"]
[null,"SSEN Connections Designer","Depot trial","WS2"]
[null,"SSEN Standards Engineer","Depot trial","WS2"]
[null,"Site visits (T&S)","Project management","WS2"]
[null,"SSEN Review","Project review","WS6"]
[null,"SSEN Project Management","Project Management","WS7"]
[null,"SSEN T&S","Project Management","WS7"]
[null,"Telematics","Vehicle monitoring-trial 1","WS1"]
[null,"Telematics","Vehicle monitoring-trial 2","WS2"]
[null,"Data Science WS1","Home charging DS","WS1"]
[null,"Data Science WS2","Depot charging DS","WS2"]
[null,"Data Science WS3","Mixed charging DS","WS3"]
[null,"Data Science WS4","Flexibility DS","WS4"]
[null,"GSS (Analytics)","Forecasting, flex analysis, data analysis","WS4"]
[null,"Analytics SW and SW Support","Operation of IoT Platform","WS4"]
[null,"HW and SW platform","Operation of IoT Platform","WS4"]
[null,"GSS (IaaS)","Operation of IoT Platform","WS4"]
[null,"WS Lead","Responsible for project reporting","WS6"]
[null,"WS Lead","Leading PMO","WS7"]
[null,"PMO","Overall management of the project","WS7"]
[null,"Governance","Overall project governance","WS7"]
[null,"WS Lead","Leading home trial activity","WS1"]
[null,"Trial designer","Designing trial 1","WS1"]
[null,"WS Lead","Leading depot trial activity","WS2"]
[null,"Trial designer","Designing trial 2","WS2"]
[null,"Data Scientist (Blend)","Creating depot planning tool","WS2"]
[null,"SW Engineer","Creating depot planning tool","WS2"]
[null,"Smart equipment SME","Creating depot planning tool","WS2"]
[null,"Planning tool designer","Creating depot planning tool","WS2"]
[null,"Site works (sub-contractor)","Implementing smart depot controller","WS2"]
[null,"IoT Engineer","Implementing smart depot controller","WS2"]
[null,"WS Lead","Leading implementation of trial 3","WS3"]
[null,"Trial designer","Designing trial 3","WS3"]
[null,"WS Lead","Leading forecasting & flexibility activity","WS4"]
[null,"IoT Engineer","Implementing smart depot controller","WS2"]
[null,"Operating model SME","Creating commercial models","WS5"]
[null,"Commercial SME","Creating commercial models","WS5"]
[null,"CBA SME","Creating commercial models","WS5"]
[null,"Behavioural SME","Creating commercial models","WS5"]
[null,"Energy Technology Lead","Overseeing overall project technical direction","WS7"]
[null,"HC Project Management","Supporting home trial","WS1"]
[null,"Centrica Project Management","Planning/implementing home method trial","WS1"]
[null,"REStore ","Develop at home charge ","WS1"]
[null,"EV delta","Purchase of EV vans & infra","WS1"]
[null,"RM Project Manager/support","Planning/implementing depot method trial","WS2"]
[null,"EV delta","Purchase of EV vans & infra for Depot (cost delta vs diesel)","WS2"]
[null,"Site cost","Preparing sites for trial operation","WS2"]
[null,"Uber Project Management","Set up & manage data exchange/trial 3","WS3"]
[null,"Platform vehicle data","Data for trial 3","WS3"]
[]
[null,"Total"]

{"sheet":"2019-2020","index":5,"n_rows":96,"n_cols":138,"rows_kept":96,"cut":false,"hidden":false,"merged":[[3,128,3,137],[3,117,3,126],[3,6,3,15],[3,17,3,27],[3,29,3,38],[3,40,3,49],[3,51,3,60],[3,62,3,71],[3,73,3,82],[3,84,3,93],[3,106,3,115],[3,95,3,104]]}
[null,"Project Costs in 2019-2020"]
[]
[]
[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,null,null,null,null,"Licensee Compulsory Contribution/Direct Benefits",null,null,null,null,null,null,null,null,null,null,"Hitachi Vantara",null,null,null,null,null,null,null,null,null,null,"Hitachi Europe",null,null,null,null,null,null,null,null,null,null,"Hitachi Capital",null,null,null,null,null,null,null,null,null,null,"Royal Mail",null,null,null,null,null,null,null,null,null,null,"Centrica",null,null,null,null,null,null,null,null,null,null,"Uber",null,null,null,null,null,null,null,null,null,null,"SSEN",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","Contingency","Decommissioning","Other",null,"Licensee Compulsory Contribution\n/Direct Benefits","Hitachi Vantara","Hitachi Europe","Hitachi Capital","Royal Mail","Centrica","Uber","SSEN","Licensee Extra Contribution","Oustanding Funding Required","Total",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other"]
[null,"Description","Task","Project Workstream"]
[null,"UKPN Standards Engineer","Home trial","WS1"]
[null,"UKPN Income Management","Home trial","WS1"]
[null,"T&S for FATs etc","Home trial","WS1"]
[null,"UKPN Asset Engineer","Depot trial","WS2"]
[null,"UKPN Connections Designer","Depot trial","WS2"]
[null,"UKPN Customer Relationship Manager","Depot trial","WS2"]
[null,"UKPN Standards Engineer","Depot trial","WS2"]
[null,"UKPN IS resource","Depot trial","WS2"]
[null,"Procurement / support","Depot trial","WS2"]
[null,"Vendor (profiled connections tool)","Depot trial","WS2"]
[null,"Site visits (T&S)","Depot trial","WS2"]
[null,"UKPN Asset Engineer","Mixed trial","WS3"]
[null,"UKPN Connections Designer","Mixed trial","WS3"]
[null,"UKPN Customer Relationship Manager","Mixed trial","WS3"]
[null,"Flexibility payments (WS1)","DSR trialing Home","WS1"]
[null,"Flexibility payments (WS2)","DSR trialing Depot","WS2"]
[null,"ANM/DERMS modification (contractor)","DNO system integration","WS4"]
[null,"Systems integration (contractor)","DNO system integration","WS4"]
[null,"GSA/Netmap mofication (contractor)","DNO system integration","WS4"]
[null,"Cloud service","DNO system integration","WS4"]
[null,"Piclo platform","DNO system integration","WS4"]
[null,"Procurement / support","Procurement","WS4"]
[null,"UKPN DSO Engineer (x 3 - 4 people)","DNO system integration","WS4"]
[null,"UKPN IS architect","DNO system integration","WS4"]
[null,"UKPN IS Project Manager","DNO system integration","WS4"]
[null,"UKPN Control Systems and Automation Engineer","DNO system integration","WS4"]
[null,"UKPN Asset Information engineer","DNO system integration","WS4"]
[null,"UKPN Review","Project review","WS6"]
[null,"Academic partner","External data analysis","WS6"]
[null,"UKPN Data analyst","Data analysis","WS6"]
[null,"Learning events","Dissemination","WS7"]
[null,"LCNI Contribution","Dissemination","WS7"]
[null,"UKPN Project Manager","Project management","WS7"]
[null,"UKPN Project Support (x3 people)","Project management","WS7"]
[null,"UKPN T&S","Project management","WS7"]
[null,"UKPN Comms Lead","Project communications","WS7"]
[null,"UKPN Legal","Legal/contract advice","WS7"]
[null,"UKPN Contingency","n/a","WS7"]
[null,"SSEN Standards Engineer","Home trial","WS1"]
[null,"SSEN Asset Engineer","Depot trial","WS2"]
[null,"SSEN Connections Designer","Depot trial","WS2"]
[null,"SSEN Standards Engineer","Depot trial","WS2"]
[null,"Site visits (T&S)","Project management","WS2"]
[null,"SSEN Review","Project review","WS6"]
[null,"SSEN Project Management","Project Management","WS7"]
[null,"SSEN T&S","Project Management","WS7"]
[null,"Telematics","Vehicle monitoring-trial 1","WS1"]
[null,"Telematics","Vehicle monitoring-trial 2","WS2"]
[null,"Data Science WS1","Home charging DS","WS1"]
[null,"Data Science WS2","Depot charging DS","WS2"]
[null,"Data Science WS3","Mixed charging DS","WS3"]
[null,"Data Science WS4","Flexibility DS","WS4"]
[null,"GSS (Analytics)","Forecasting, flex analysis, data analysis","WS4"]
[null,"Analytics SW and SW Support","Operation of IoT Platform","WS4"]
[null,"HW and SW platform","Operation of IoT Platform","WS4"]
[null,"GSS (IaaS)","Operation of IoT Platform","WS4"]
[null,"WS Lead","Responsible for project reporting","WS6"]
[null,"WS Lead","Leading PMO","WS7"]
[null,"PMO","Overall management of the project","WS7"]
[null,"Governance","Overall project governance","WS7"]
[null,"WS Lead","Leading home trial activity","WS1"]
[null,"Trial designer","Designing trial 1","WS1"]
[null,"WS Lead","Leading depot trial activity","WS2"]
[null,"Trial designer","Designing trial 2","WS2"]
[null,"Data Scientist (Blend)","Creating depot planning tool","WS2"]
[null,"SW Engineer","Creating depot planning tool","WS2"]
[null,"Smart equipment SME","Creating depot planning tool","WS2"]
[null,"Planning tool designer","Creating depot planning tool","WS2"]
[null,"Site works (sub-contractor)","Implementing smart depot controller","WS2"]
[null,"IoT Engineer","Implementing smart depot controller","WS2"]
[null,"WS Lead","Leading implementation of trial 3","WS3"]
[null,"Trial designer","Designing trial 3","WS3"]
[null,"WS Lead","Leading forecasting & flexibility activity","WS4"]
[null,"WS Lead","Leading business model activity","WS5"]
[null,"Operating model SME","Creating commercial models","WS5"]
[null,"Commercial SME","Creating commercial models","WS5"]
[null,"CBA SME","Creating commercial models","WS5"]
[null,"Behavioural SME","Creating commercial models","WS5"]
[null,"Energy Technology Lead","Overseeing overall project technical direction","WS7"]
[null,"HC Project Management","Supporting home trial","WS1"]
[null,"Centrica Project Management","Planning/implementing home method trial","WS1"]
[null,"REStore ","Develop at home charge ","WS1"]
[null,"EV delta","Purchase of EV vans & infra","WS1"]
[null,"RM Project Manager/support","Planning/implementing depot method trial","WS2"]
[null,"EV delta","Purchase of EV vans & infra for Depot (cost delta vs diesel)","WS2"]
[null,"Site cost","Preparing sites for trial operation","WS2"]
[null,"Uber Project Management","Set up & manage data exchange/trial 3","WS3"]
[null,"Platform vehicle data","Data for trial 3","WS3"]
[]
[null,"Total"]

{"sheet":"2020-2021","index":6,"n_rows":96,"n_cols":138,"rows_kept":96,"cut":false,"hidden":false,"merged":[[3,128,3,137],[3,117,3,126],[3,6,3,15],[3,17,3,27],[3,29,3,38],[3,40,3,49],[3,51,3,60],[3,62,3,71],[3,73,3,82],[3,84,3,93],[3,95,3,104],[3,106,3,115]]}
[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,null,null,null,null,"Licensee Compulsory Contribution/Direct Benefits",null,null,null,null,null,null,null,null,null,null,"Hitachi Vantara",null,null,null,null,null,null,null,null,null,null,"Hitachi Europe",null,null,null,null,null,null,null,null,null,null,"Hitachi Capital",null,null,null,null,null,null,null,null,null,null,"Royal Mail",null,null,null,null,null,null,null,null,null,null,"Centrica",null,null,null,null,null,null,null,null,null,null,"Uber",null,null,null,null,null,null,null,null,null,null,"SSEN",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","Contingency","Decommissioning","Other",null,"Licensee Compulsory Contribution\n/Direct Benefits","Hitachi Vantara","Hitachi Europe","Hitachi Capital","Royal Mail","Centrica","Uber","SSEN","Licensee Extra Contribution","Oustanding Funding Required","Total",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other"]
[null,"Description","Task","Project Workstream"]
[null,"UKPN Standards Engineer","Home trial","WS1"]
[null,"UKPN Income Management","Home trial","WS1"]
[null,"T&S for FATs etc","Home trial","WS1"]
[null,"UKPN Asset Engineer","Depot trial","WS2"]
[null,"UKPN Connections Designer","Depot trial","WS2"]
[null,"UKPN Customer Relationship Manager","Depot trial","WS2"]
[null,"UKPN Standards Engineer","Depot trial","WS2"]
[null,"UKPN IS resource","Depot trial","WS2"]
[null,"Procurement / support","Depot trial","WS2"]
[null,"Vendor (profiled connections tool)","Depot trial","WS2"]
[null,"Site visits (T&S)","Depot trial","WS2"]
[null,"UKPN Asset Engineer","Mixed trial","WS3"]
[null,"UKPN Connections Designer","Mixed trial","WS3"]
[null,"UKPN Customer Relationship Manager","Mixed trial","WS3"]
[null,"Flexibility payments (WS1)","DSR trialing Home","WS1"]
[null,"Flexibility payments (WS2)","DSR trialing Depot","WS2"]
[null,"ANM/DERMS modification (contractor)","DNO system integration","WS4"]
[null,"Systems integration (contractor)","DNO system integration","WS4"]
[null,"GSA/Netmap mofication (contractor)","DNO system integration","WS4"]
[null,"Cloud service","DNO system integration","WS4"]
[null,"Piclo platform","DNO system integration","WS4"]
[null,"Procurement / support","Procurement","WS4"]
[null,"UKPN DSO Engineer (x 3 - 4 people)","DNO system integration","WS4"]
[null,"UKPN IS architect","DNO system integration","WS4"]
[null,"UKPN IS Project Manager","DNO system integration","WS4"]
[null,"UKPN Control Systems and Automation Engineer","DNO system integration","WS4"]
[null,"UKPN Asset Information engineer","DNO system integration","WS4"]
[null,"UKPN Review","Project review","WS6"]
[null,"Academic partner","External data analysis","WS6"]
[null,"UKPN Data analyst","Data analysis","WS6"]
[null,"Learning events","Dissemination","WS7"]
[null,"LCNI Contribution","Dissemination","WS7"]
[null,"UKPN Project Manager","Project management","WS7"]
[null,"UKPN Project Support (x3 people)","Project management","WS7"]
[null,"UKPN T&S","Project management","WS7"]
[null,"UKPN Comms Lead","Project communications","WS7"]
[null,"UKPN Legal","Legal/contract advice","WS7"]
[null,"UKPN Contingency","n/a","WS7"]
[null,"SSEN Standards Engineer","Home trial","WS1"]
[null,"SSEN Asset Engineer","Depot trial","WS2"]
[null,"SSEN Connections Designer","Depot trial","WS2"]
[null,"SSEN Standards Engineer","Depot trial","WS2"]
[null,"Site visits (T&S)","Project management","WS2"]
[null,"SSEN Review","Project review","WS6"]
[null,"SSEN Project Management","Project Management","WS7"]
[null,"SSEN T&S","Project Management","WS7"]
[null,"Telematics","Vehicle monitoring-trial 1","WS1"]
[null,"Telematics","Vehicle monitoring-trial 2","WS2"]
[null,"Data Science WS1","Home charging DS","WS1"]
[null,"Data Science WS2","Depot charging DS","WS2"]
[null,"Data Science WS3","Mixed charging DS","WS3"]
[null,"Data Science WS4","Flexibility DS","WS4"]
[null,"GSS (Analytics)","Forecasting, flex analysis, data analysis","WS4"]
[null,"Analytics SW and SW Support","Operation of IoT Platform","WS4"]
[null,"HW and SW platform","Operation of IoT Platform","WS4"]
[null,"GSS (IaaS)","Operation of IoT Platform","WS4"]
[null,"WS Lead","Responsible for project reporting","WS6"]
[null,"WS Lead","Leading PMO","WS7"]
[null,"PMO","Overall management of the project","WS7"]
[null,"Governance","Overall project governance","WS7"]
[null,"WS Lead","Leading home trial activity","WS1"]
[null,"Trial designer","Designing trial 1","WS1"]
[null,"WS Lead","Leading depot trial activity","WS2"]
[null,"Trial designer","Designing trial 2","WS2"]
[null,"Data Scientist (Blend)","Creating depot planning tool","WS2"]
[null,"SW Engineer","Creating depot planning tool","WS2"]
[null,"Smart equipment SME","Creating depot planning tool","WS2"]
[null,"Planning tool designer","Creating depot planning tool","WS2"]
[null,"Site works (sub-contractor)","Implementing smart depot controller","WS2"]
[null,"IoT Engineer","Implementing smart depot controller","WS2"]
[null,"WS Lead","Leading implementation of trial 3","WS3"]
[null,"Trial designer","Designing trial 3","WS3"]
[null,"WS Lead","Leading forecasting & flexibility activity","WS4"]
[null,"WS Lead","Leading business model activity","WS5"]
[null,"Operating model SME","Creating commercial models","WS5"]
[null,"Commercial SME","Creating commercial models","WS5"]
[null,"CBA SME","Creating commercial models","WS5"]
[null,"Behavioural SME","Creating commercial models","WS5"]
[null,"Energy Technology Lead","Overseeing overall project technical direction","WS7"]
[null,"HC Project Management","Supporting home trial","WS1"]
[null,"Centrica Project Management","Planning/implementing home method trial","WS1"]
[null,"REStore ","Develop at home charge ","WS1"]
[null,"EV delta","Purchase of EV vans & infra","WS1"]
[null,"RM Project Manager/support","Planning/implementing depot method trial","WS2"]
[null,"EV delta","Purchase of EV vans & infra for Depot (cost delta vs diesel)","WS2"]
[null,"Site cost","Preparing sites for trial operation","WS2"]
[null,"Uber Project Management","Set up & manage data exchange/trial 3","WS3"]
[null,"Platform vehicle data","Data for trial 3","WS3"]
[]
[null,"Total"]

{"sheet":"2021-2022","index":7,"n_rows":96,"n_cols":138,"rows_kept":96,"cut":false,"hidden":false,"merged":[[3,128,3,137],[3,117,3,126],[3,6,3,15],[3,17,3,27],[3,29,3,38],[3,40,3,49],[3,51,3,60],[3,62,3,71],[3,73,3,82],[3,84,3,93],[3,95,3,104],[3,106,3,115]]}
[null,"Project Costs in 2021-2022"]
[]
[]
[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,null,null,null,null,"Licensee Compulsory Contribution/Direct Benefits",null,null,null,null,null,null,null,null,null,null,"Hitachi Vantara",null,null,null,null,null,null,null,null,null,null,"Hitachi Europe",null,null,null,null,null,null,null,null,null,null,"Hitachi Capital",null,null,null,null,null,null,null,null,null,null,"Royal Mail",null,null,null,null,null,null,null,null,null,null,"Centrica",null,null,null,null,null,null,null,null,null,null,"Uber",null,null,null,null,null,null,null,null,null,null,"SSEN",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","Contingency","Decommissioning","Other",null,"Licensee Compulsory Contribution\n/Direct Benefits","Hitachi Vantara","Hitachi Europe","Hitachi Capital","Royal Mail","Centrica","Uber","SSEN","Licensee Extra Contribution","Oustanding Funding Required","Total",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other"]
[null,"Description","Task","Project Workstream"]
[null,"UKPN Standards Engineer","Home trial","WS1"]
[null,"UKPN Income Management","Home trial","WS1"]
[null,"T&S for FATs etc","Home trial","WS1"]
[null,"UKPN Asset Engineer","Depot trial","WS2"]
[null,"UKPN Connections Designer","Depot trial","WS2"]
[null,"UKPN Customer Relationship Manager","Depot trial","WS2"]
[null,"UKPN Standards Engineer","Depot trial","WS2"]
[null,"UKPN IS resource","Depot trial","WS2"]
[null,"Procurement / support","Depot trial","WS2"]
[null,"Vendor (profiled connections tool)","Depot trial","WS2"]
[null,"Site visits (T&S)","Depot trial","WS2"]
[null,"UKPN Asset Engineer","Mixed trial","WS3"]
[null,"UKPN Connections Designer","Mixed trial","WS3"]
[null,"UKPN Customer Relationship Manager","Mixed trial","WS3"]
[null,"Flexibility payments (WS1)","DSR trialing Home","WS1"]
[null,"Flexibility payments (WS2)","DSR trialing Depot","WS2"]
[null,"ANM/DERMS modification (contractor)","DNO system integration","WS4"]
[null,"Systems integration (contractor)","DNO system integration","WS4"]
[null,"GSA/Netmap mofication (contractor)","DNO system integration","WS4"]
[null,"Cloud service","DNO system integration","WS4"]
[null,"Piclo platform","DNO system integration","WS4"]
[null,"Procurement / support","Procurement","WS4"]
[null,"UKPN DSO Engineer (x 3 - 4 people)","DNO system integration","WS4"]
[null,"UKPN IS architect","DNO system integration","WS4"]
[null,"UKPN IS Project Manager","DNO system integration","WS4"]
[null,"UKPN Control Systems and Automation Engineer","DNO system integration","WS4"]
[null,"UKPN Asset Information engineer","DNO system integration","WS4"]
[null,"UKPN Review","Project review","WS6"]
[null,"Academic partner","External data analysis","WS6"]
[null,"UKPN Data analyst","Data analysis","WS6"]
[null,"Learning events","Dissemination","WS7"]
[null,"LCNI Contribution","Dissemination","WS7"]
[null,"UKPN Project Manager","Project management","WS7"]
[null,"UKPN Project Support (x3 people)","Project management","WS7"]
[null,"UKPN T&S","Project management","WS7"]
[null,"UKPN Comms Lead","Project communications","WS7"]
[null,"UKPN Legal","Legal/contract advice","WS7"]
[null,"UKPN Contingency","n/a","WS7"]
[null,"SSEN Standards Engineer","Home trial","WS1"]
[null,"SSEN Asset Engineer","Depot trial","WS2"]
[null,"SSEN Connections Designer","Depot trial","WS2"]
[null,"SSEN Standards Engineer","Depot trial","WS2"]
[null,"Site visits (T&S)","Project management","WS2"]
[null,"SSEN Review","Project review","WS6"]
[null,"SSEN Project Management","Project Management","WS7"]
[null,"SSEN T&S","Project Management","WS7"]
[null,"Telematics","Vehicle monitoring-trial 1","WS1"]
[null,"Telematics","Vehicle monitoring-trial 2","WS2"]
[null,"Data Science WS1","Home charging DS","WS1"]
[null,"Data Science WS2","Depot charging DS","WS2"]
[null,"Data Science WS3","Mixed charging DS","WS3"]
[null,"Data Science WS4","Flexibility DS","WS4"]
[null,"GSS (Analytics)","Forecasting, flex analysis, data analysis","WS4"]
[null,"Analytics SW and SW Support","Operation of IoT Platform","WS4"]
[null,"HW and SW platform","Operation of IoT Platform","WS4"]
[null,"GSS (IaaS)","Operation of IoT Platform","WS4"]
[null,"WS Lead","Responsible for project reporting","WS6"]
[null,"WS Lead","Leading PMO","WS7"]
[null,"PMO","Overall management of the project","WS7"]
[null,"Governance","Overall project governance","WS7"]
[null,"WS Lead","Leading home trial activity","WS1"]
[null,"Trial designer","Designing trial 1","WS1"]
[null,"WS Lead","Leading depot trial activity","WS2"]
[null,"Trial designer","Designing trial 2","WS2"]
[null,"Data Scientist (Blend)","Creating depot planning tool","WS2"]
[null,"SW Engineer","Creating depot planning tool","WS2"]
[null,"Smart equipment SME","Creating depot planning tool","WS2"]
[null,"Planning tool designer","Creating depot planning tool","WS2"]
[null,"Site works (sub-contractor)","Implementing smart depot controller","WS2"]
[null,"IoT Engineer","Implementing smart depot controller","WS2"]
[null,"WS Lead","Leading implementation of trial 3","WS3"]
[null,"Trial designer","Designing trial 3","WS3"]
[null,"WS Lead","Leading forecasting & flexibility activity","WS4"]
[null,"WS Lead","Leading business model activity","WS5"]
[null,"Operating model SME","Creating commercial models","WS5"]
[null,"Commercial SME","Creating commercial models","WS5"]
[null,"CBA SME","Creating commercial models","WS5"]
[null,"Behavioural SME","Creating commercial models","WS5"]
[null,"Energy Technology Lead","Overseeing overall project technical direction","WS7"]
[null,"HC Project Management","Supporting home trial","WS1"]
[null,"Centrica Project Management","Planning/implementing home method trial","WS1"]
[null,"REStore ","Develop at home charge ","WS1"]
[null,"EV delta","Purchase of EV vans & infra","WS1"]
[null,"RM Project Manager/support","Planning/implementing depot method trial","WS2"]
[null,"EV delta","Purchase of EV vans & infra for Depot (cost delta vs diesel)","WS2"]
[null,"Site cost","Preparing sites for trial operation","WS2"]
[null,"Uber Project Management","Set up & manage data exchange/trial 3","WS3"]
[null,"Platform vehicle data","Data for trial 3","WS3"]
[]
[null,"Total"]

{"sheet":"2022-2023","index":8,"n_rows":342,"n_cols":138,"rows_kept":342,"cut":false,"hidden":false,"merged":[[3,73,3,82],[3,128,3,137],[3,6,3,15],[3,17,3,27],[3,29,3,38],[3,40,3,49],[3,51,3,60],[3,62,3,71],[3,84,3,93],[3,95,3,104],[3,106,3,115],[3,117,3,126]]}
[null,"Project Costs in 2022-2023"]
[null,"No Project Costs are planned for this period"]
[]
[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,null,null,null,null,"Licensee Compulsory Contribution/Direct Benefits",null,null,null,null,null,null,null,null,null,null,"Hitachi Vantara",null,null,null,null,null,null,null,null,null,null,"Hitachi Europe",null,null,null,null,null,null,null,null,null,null,"Hitachi Capital",null,null,null,null,null,null,null,null,null,null,"Royal Mail",null,null,null,null,null,null,null,null,null,null,"Centrica",null,null,null,null,null,null,null,null,null,null,"Uber",null,null,null,null,null,null,null,null,null,null,"SSEN",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","Contingency","Decommissioning","Other",null,"Licensee Compulsory Contribution\n/Direct Benefits","Hitachi Vantara","Hitachi Europe","Hitachi Capital","Royal Mail","Centrica","Uber","SSEN","Licensee Extra Contribution","Oustanding Funding Required","Total",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other"]
[null,"Description","Task","Project Workstream"]
[null,"UKPN Standards Engineer","Home trial","WS1"]
[null,"UKPN Income Management","Home trial","WS1"]
[null,"T&S for FATs etc","Home trial","WS1"]
[null,"UKPN Asset Engineer","Depot trial","WS2"]
[null,"UKPN Connections Designer","Depot trial","WS2"]
[null,"UKPN Customer Relationship Manager","Depot trial","WS2"]
[null,"UKPN Standards Engineer","Depot trial","WS2"]
[null,"UKPN IS resource","Depot trial","WS2"]
[null,"Procurement / support","Depot trial","WS2"]
[null,"Vendor (profiled connections tool)","Depot trial","WS2"]
[null,"Site visits (T&S)","Depot trial","WS2"]
[null,"UKPN Asset Engineer","Mixed trial","WS3"]
[null,"UKPN Connections Designer","Mixed trial","WS3"]
[null,"UKPN Customer Relationship Manager","Mixed trial","WS3"]
[null,"Flexibility payments (WS1)","DSR trialing Home","WS1"]
[null,"Flexibility payments (WS2)","DSR trialing Depot","WS2"]
[null,"ANM/DERMS modification (contractor)","DNO system integration","WS4"]
[null,"Systems integration (contractor)","DNO system integration","WS4"]
[null,"GSA/Netmap mofication (contractor)","DNO system integration","WS4"]
[null,"Cloud service","DNO system integration","WS4"]
[null,"Piclo platform","DNO system integration","WS4"]
[null,"Procurement / support","Procurement","WS4"]
[null,"UKPN DSO Engineer (x 3 - 4 people)","DNO system integration","WS4"]
[null,"UKPN IS architect","DNO system integration","WS4"]
[null,"UKPN IS Project Manager","DNO system integration","WS4"]
[null,"UKPN Control Systems and Automation Engineer","DNO system integration","WS4"]
[null,"UKPN Asset Information engineer","DNO system integration","WS4"]
[null,"UKPN Review","Project review","WS6"]
[null,"Academic partner","External data analysis","WS6"]
[null,"UKPN Data analyst","Data analysis","WS6"]
[null,"Learning events","Dissemination","WS7"]
[null,"LCNI Contribution","Dissemination","WS7"]
[null,"UKPN Project Manager","Project management","WS7"]
[null,"UKPN Project Support (x3 people)","Project management","WS7"]
[null,"UKPN T&S","Project management","WS7"]
[null,"UKPN Comms Lead","Project communications","WS7"]
[null,"UKPN Legal","Legal/contract advice","WS7"]
[null,"UKPN Contingency","n/a","WS7"]
[null,"SSEN Standards Engineer","Home trial","WS1"]
[null,"SSEN Asset Engineer","Depot trial","WS2"]
[null,"SSEN Connections Designer","Depot trial","WS2"]
[null,"SSEN Standards Engineer","Depot trial","WS2"]
[null,"Site visits (T&S)","Project management","WS2"]
[null,"SSEN Review","Project review","WS6"]
[null,"SSEN Project Management","Project Management","WS7"]
[null,"SSEN T&S","Project Management","WS7"]
[null,"Telematics","Vehicle monitoring-trial 1","WS1"]
[null,"Telematics","Vehicle monitoring-trial 2","WS2"]
[null,"Data Science WS1","Home charging DS","WS1"]
[null,"Data Science WS2","Depot charging DS","WS2"]
[null,"Data Science WS3","Mixed charging DS","WS3"]
[null,"Data Science WS4","Flexibility DS","WS4"]
[null,"GSS (Analytics)","Forecasting, flex analysis, data analysis","WS4"]
[null,"Analytics SW and SW Support","Operation of IoT Platform","WS4"]
[null,"HW and SW platform","Operation of IoT Platform","WS4"]
[null,"GSS (IaaS)","Operation of IoT Platform","WS4"]
[null,"WS Lead","Responsible for project reporting","WS6"]
[null,"WS Lead","Leading PMO","WS7"]
[null,"PMO","Overall management of the project","WS7"]
[null,"Governance","Overall project governance","WS7"]
[null,"WS Lead","Leading home trial activity","WS1"]
[null,"Trial designer","Designing trial 1","WS1"]
[null,"WS Lead","Leading depot trial activity","WS2"]
[null,"Trial designer","Designing trial 2","WS2"]
[null,"Data Scientist (Blend)","Creating depot planning tool","WS2"]
[null,"SW Engineer","Creating depot planning tool","WS2"]
[null,"Smart equipment SME","Creating depot planning tool","WS2"]
[null,"Planning tool designer","Creating depot planning tool","WS2"]
[null,"Site works (sub-contractor)","Implementing smart depot controller","WS2"]
[null,"IoT Engineer","Implementing smart depot controller","WS2"]
[null,"WS Lead","Leading implementation of trial 3","WS3"]
[null,"Trial designer","Designing trial 3","WS3"]
[null,"WS Lead","Leading forecasting & flexibility activity","WS4"]
[null,"WS Lead","Leading business model activity","WS5"]
[null,"Operating model SME","Creating commercial models","WS5"]
[null,"Commercial SME","Creating commercial models","WS5"]
[null,"CBA SME","Creating commercial models","WS5"]
[null,"Behavioural SME","Creating commercial models","WS5"]
[null,"Energy Technology Lead","Overseeing overall project technical direction","WS7"]
[null,"HC Project Management","Supporting home trial","WS1"]
[null,"Centrica Project Management","Planning/implementing home method trial","WS1"]
[null,"REStore ","Develop at home charge ","WS1"]
[null,"EV delta","Purchase of EV vans & infra","WS1"]
[null,"RM Project Manager/support","Planning/implementing depot method trial","WS2"]
[null,"EV delta","Purchase of EV vans & infra for Depot (cost delta vs diesel)","WS2"]
[null,"Site cost","Preparing sites for trial operation","WS2"]
[null,"Uber Project Management","Set up & manage data exchange/trial 3","WS3"]
[null,"Platform vehicle data","Data for trial 3","WS3"]
[]
[null,"Total"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Totals"]

{"sheet":"2023-2024","index":9,"n_rows":255,"n_cols":138,"rows_kept":255,"cut":false,"hidden":false,"merged":[[3,117,3,126],[3,128,3,137],[3,6,3,15],[3,17,3,27],[3,29,3,38],[3,40,3,49],[3,51,3,60],[3,62,3,71],[3,73,3,82],[3,84,3,93],[3,95,3,104],[3,106,3,115]]}
[null,"Project Costs in 2023-2024"]
[null,"No Project Costs are planned for this period"]
[]
[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,null,null,null,null,"Licensee Compulsory Contribution/Direct Benefits",null,null,null,null,null,null,null,null,null,null,"Hitachi Vantara",null,null,null,null,null,null,null,null,null,null,"Hitachi Europe",null,null,null,null,null,null,null,null,null,null,"Hitachi Capital",null,null,null,null,null,null,null,null,null,null,"Royal Mail",null,null,null,null,null,null,null,null,null,null,"Centrica",null,null,null,null,null,null,null,null,null,null,"Uber",null,null,null,null,null,null,null,null,null,null,"SSEN",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","Contingency","Decommissioning","Other",null,"Licensee Compulsory Contribution\n/Direct Benefits","Hitachi Vantara","Hitachi Europe","Hitachi Capital","Royal Mail","Centrica","Uber","SSEN","Licensee Extra Contribution","Oustanding Funding Required","Total",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","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,null,null,null,null,{"$f":"SUM(R7:AA7)","v":0},null,{"$f":"$R7*G7","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$S7*G7","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$T7*G7","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$U7*G7","v":0},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,{"$f":"$X7*G7","v":0},{"$f":"$X7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$Y7*G7","v":0},{"$f":"$Y7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$Z7*G7","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$AA7*G7","v":0},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,null,null,null,null,{"$f":"SUM(R8:AA8)","v":0},null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,{"$f":"$V8*G8","v":0},{"$f":"$V8*H8","v":0},{"$f":"$V8*I8","v":0},{"$f":"$V8*J8","v":0},{"$f":"$V8*K8","v":0},{"$f":"$V8*L8","v":0},{"$f":"$V8*M8","v":0},{"$f":"$V8*N8","v":0},{"$f":"$V8*O8","v":0},{"$f":"$V8*P8","v":0},null,{"$f":"$W8*G8","v":0},{"$f":"$W8*H8","v":0},{"$f":"$W8*I8","v":0},{"$f":"$W8*J8","v":0},{"$f":"$W8*K8","v":0},{"$f":"$W8*L8","v":0},{"$f":"$W8*M8","v":0},{"$f":"$W8*N8","v":0},{"$f":"$W8*O8","v":0},{"$f":"$W8*P8","v":0},null,{"$f":"$X8*G8","v":0},{"$f":"$X8*H8","v":0},{"$f":"$X8*I8","v":0},{"$f":"$X8*J8","v":0},{"$f":"$X8*K8","v":0},{"$f":"$X8*L8","v":0},{"$f":"$X8*M8","v":0},{"$f":"$X8*N8","v":0},{"$f":"$X8*O8","v":0},{"$f":"$X8*P8","v":0},null,{"$f":"$Y8*G8","v":0},{"$f":"$Y8*H8","v":0},{"$f":"$Y8*I8","v":0},{"$f":"$Y8*J8","v":0},{"$f":"$Y8*K8","v":0},{"$f":"$Y8*L8","v":0},{"$f":"$Y8*M8","v":0},{"$f":"$Y8*N8","v":0},{"$f":"$Y8*O8","v":0},{"$f":"$Y8*P8","v":0},null,0,0,0,0,0,0,0,0,0,0,null,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,null,null,null,null,{"$f":"SUM(AD7:AD8)","v":0},{"$f":"SUM(AE7:AE8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(AO7:AO8)","v":0},{"$f":"SUM(AP7:AP8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(AZ7:AZ8)","v":0},{"$f":"SUM(BA7:BA8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(BK7:BK8)","v":0},{"$f":"SUM(BL7:BL8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(BV7:BV8)","v":0},{"$f":"SUM(BW7:BW8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(CG7:CG8)","v":0},{"$f":"SUM(CH7:CH8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(CR7:CR8)","v":0},{"$f":"SUM(CS7:CS8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(DC7:DC8)","v":0},{"$f":"SUM(DD7:DD8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(DN7:DN8)","v":0},{"$f":"SUM(DO7:DO8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(DY7:DY8)","v":0},{"$f":"SUM(DZ7:DZ8)","v":0},0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Totals"]

{"sheet":"2024-2025","index":10,"n_rows":255,"n_cols":138,"rows_kept":255,"cut":false,"hidden":false,"merged":[[3,117,3,126],[3,128,3,137],[3,6,3,15],[3,17,3,27],[3,29,3,38],[3,40,3,49],[3,51,3,60],[3,62,3,71],[3,73,3,82],[3,84,3,93],[3,95,3,104],[3,106,3,115]]}
[null,"Project Costs in 2024-2025"]
[null,"No Project Costs are planned for this period"]
[]
[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,null,null,null,null,"Licensee Compulsory Contribution/Direct Benefits",null,null,null,null,null,null,null,null,null,null,"Hitachi Vantara",null,null,null,null,null,null,null,null,null,null,"Hitachi Europe",null,null,null,null,null,null,null,null,null,null,"Hitachi Capital",null,null,null,null,null,null,null,null,null,null,"Royal Mail",null,null,null,null,null,null,null,null,null,null,"Centrica",null,null,null,null,null,null,null,null,null,null,"Uber",null,null,null,null,null,null,null,null,null,null,"SSEN",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","Contingency","Decommissioning","Other",null,"Licensee Compulsory Contribution\n/Direct Benefits","Hitachi Vantara","Hitachi Europe","Hitachi Capital","Royal Mail","Centrica","Uber","SSEN","Licensee Extra Contribution","Oustanding Funding Required","Total",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","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,null,null,null,null,{"$f":"SUM(R7:AA7)","v":0},null,{"$f":"$R7*G7","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$S7*G7","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$T7*G7","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$U7*G7","v":0},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,{"$f":"$X7*G7","v":0},{"$f":"$X7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$Y7*G7","v":0},{"$f":"$Y7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$Z7*G7","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$AA7*G7","v":0},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,null,null,null,null,{"$f":"SUM(R8:AA8)","v":0},null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,{"$f":"$V8*G8","v":0},{"$f":"$V8*H8","v":0},{"$f":"$V8*I8","v":0},{"$f":"$V8*J8","v":0},{"$f":"$V8*K8","v":0},{"$f":"$V8*L8","v":0},{"$f":"$V8*M8","v":0},{"$f":"$V8*N8","v":0},{"$f":"$V8*O8","v":0},{"$f":"$V8*P8","v":0},null,{"$f":"$W8*G8","v":0},{"$f":"$W8*H8","v":0},{"$f":"$W8*I8","v":0},{"$f":"$W8*J8","v":0},{"$f":"$W8*K8","v":0},{"$f":"$W8*L8","v":0},{"$f":"$W8*M8","v":0},{"$f":"$W8*N8","v":0},{"$f":"$W8*O8","v":0},{"$f":"$W8*P8","v":0},null,{"$f":"$X8*G8","v":0},{"$f":"$X8*H8","v":0},{"$f":"$X8*I8","v":0},{"$f":"$X8*J8","v":0},{"$f":"$X8*K8","v":0},{"$f":"$X8*L8","v":0},{"$f":"$X8*M8","v":0},{"$f":"$X8*N8","v":0},{"$f":"$X8*O8","v":0},{"$f":"$X8*P8","v":0},null,{"$f":"$Y8*G8","v":0},{"$f":"$Y8*H8","v":0},{"$f":"$Y8*I8","v":0},{"$f":"$Y8*J8","v":0},{"$f":"$Y8*K8","v":0},{"$f":"$Y8*L8","v":0},{"$f":"$Y8*M8","v":0},{"$f":"$Y8*N8","v":0},{"$f":"$Y8*O8","v":0},{"$f":"$Y8*P8","v":0},null,0,0,0,0,0,0,0,0,0,0,null,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,null,null,null,null,{"$f":"SUM(AD7:AD8)","v":0},{"$f":"SUM(AE7:AE8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(AO7:AO8)","v":0},{"$f":"SUM(AP7:AP8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(AZ7:AZ8)","v":0},{"$f":"SUM(BA7:BA8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(BK7:BK8)","v":0},{"$f":"SUM(BL7:BL8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(BV7:BV8)","v":0},{"$f":"SUM(BW7:BW8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(CG7:CG8)","v":0},{"$f":"SUM(CH7:CH8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(CR7:CR8)","v":0},{"$f":"SUM(CS7:CS8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(DC7:DC8)","v":0},{"$f":"SUM(DD7:DD8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(DN7:DN8)","v":0},{"$f":"SUM(DO7:DO8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(DY7:DY8)","v":0},{"$f":"SUM(DZ7:DZ8)","v":0},0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Totals"]

{"sheet":"2025-2026","index":11,"n_rows":255,"n_cols":138,"rows_kept":255,"cut":false,"hidden":false,"merged":[[3,117,3,126],[3,128,3,137],[3,6,3,15],[3,17,3,27],[3,29,3,38],[3,40,3,49],[3,51,3,60],[3,62,3,71],[3,73,3,82],[3,84,3,93],[3,95,3,104],[3,106,3,115]]}
[null,"Project Costs in 2025-2026"]
[null,"No Project Costs are planned for this period"]
[]
[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,null,null,null,null,"Licensee Compulsory Contribution/Direct Benefits",null,null,null,null,null,null,null,null,null,null,"Hitachi Vantara",null,null,null,null,null,null,null,null,null,null,"Hitachi Europe",null,null,null,null,null,null,null,null,null,null,"Hitachi Capital",null,null,null,null,null,null,null,null,null,null,"Royal Mail",null,null,null,null,null,null,null,null,null,null,"Centrica",null,null,null,null,null,null,null,null,null,null,"Uber",null,null,null,null,null,null,null,null,null,null,"SSEN",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","Contingency","Decommissioning","Other",null,"Licensee Compulsory Contribution\n/Direct Benefits","Hitachi Vantara","Hitachi Europe","Hitachi Capital","Royal Mail","Centrica","Uber","SSEN","Licensee Extra Contribution","Oustanding Funding Required","Total",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","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,null,null,null,null,{"$f":"SUM(R7:AA7)","v":0},null,{"$f":"$R7*G7","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$S7*G7","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$T7*G7","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$U7*G7","v":0},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,{"$f":"$X7*G7","v":0},{"$f":"$X7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$Y7*G7","v":0},{"$f":"$Y7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$Z7*G7","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$AA7*G7","v":0},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,null,null,null,null,{"$f":"SUM(R8:AA8)","v":0},null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,{"$f":"$V8*G8","v":0},{"$f":"$V8*H8","v":0},{"$f":"$V8*I8","v":0},{"$f":"$V8*J8","v":0},{"$f":"$V8*K8","v":0},{"$f":"$V8*L8","v":0},{"$f":"$V8*M8","v":0},{"$f":"$V8*N8","v":0},{"$f":"$V8*O8","v":0},{"$f":"$V8*P8","v":0},null,{"$f":"$W8*G8","v":0},{"$f":"$W8*H8","v":0},{"$f":"$W8*I8","v":0},{"$f":"$W8*J8","v":0},{"$f":"$W8*K8","v":0},{"$f":"$W8*L8","v":0},{"$f":"$W8*M8","v":0},{"$f":"$W8*N8","v":0},{"$f":"$W8*O8","v":0},{"$f":"$W8*P8","v":0},null,{"$f":"$X8*G8","v":0},{"$f":"$X8*H8","v":0},{"$f":"$X8*I8","v":0},{"$f":"$X8*J8","v":0},{"$f":"$X8*K8","v":0},{"$f":"$X8*L8","v":0},{"$f":"$X8*M8","v":0},{"$f":"$X8*N8","v":0},{"$f":"$X8*O8","v":0},{"$f":"$X8*P8","v":0},null,{"$f":"$Y8*G8","v":0},{"$f":"$Y8*H8","v":0},{"$f":"$Y8*I8","v":0},{"$f":"$Y8*J8","v":0},{"$f":"$Y8*K8","v":0},{"$f":"$Y8*L8","v":0},{"$f":"$Y8*M8","v":0},{"$f":"$Y8*N8","v":0},{"$f":"$Y8*O8","v":0},{"$f":"$Y8*P8","v":0},null,0,0,0,0,0,0,0,0,0,0,null,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,null,null,null,null,{"$f":"SUM(AD7:AD8)","v":0},{"$f":"SUM(AE7:AE8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(AO7:AO8)","v":0},{"$f":"SUM(AP7:AP8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(AZ7:AZ8)","v":0},{"$f":"SUM(BA7:BA8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(BK7:BK8)","v":0},{"$f":"SUM(BL7:BL8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(BV7:BV8)","v":0},{"$f":"SUM(BW7:BW8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(CG7:CG8)","v":0},{"$f":"SUM(CH7:CH8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(CR7:CR8)","v":0},{"$f":"SUM(CS7:CS8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(DC7:DC8)","v":0},{"$f":"SUM(DD7:DD8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(DN7:DN8)","v":0},{"$f":"SUM(DO7:DO8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(DY7:DY8)","v":0},{"$f":"SUM(DZ7:DZ8)","v":0},0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Totals"]

{"sheet":"Whole project","index":12,"n_rows":342,"n_cols":138,"rows_kept":342,"cut":false,"hidden":false,"merged":[[3,128,3,137],[3,117,3,126],[3,6,3,15],[3,17,3,27],[3,29,3,38],[3,40,3,49],[3,51,3,60],[3,62,3,71],[3,73,3,82],[3,84,3,93],[3,95,3,104],[3,106,3,115]]}
[null,"Whole Project"]
[]
[]
[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,null,null,null,null,"Licensee Compulsory Contribution/Direct Benefits",null,null,null,null,null,null,null,null,null,null,"Hitachi Vantara",null,null,null,null,null,null,null,null,null,null,"Hitachi Europe",null,null,null,null,null,null,null,null,null,null,"Hitachi Capital",null,null,null,null,null,null,null,null,null,null,"Royal Mail",null,null,null,null,null,null,null,null,null,null,"Centrica",null,null,null,null,null,null,null,null,null,null,"Uber",null,null,null,null,null,null,null,null,null,null,"SSEN",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","Contingency","Decommissioning","Other",null,"Licensee Compulsory Contribution\n/Direct Benefits","Hitachi Vantara","Hitachi Europe","Hitachi Capital","Royal Mail","Centrica","Uber","SSEN","Licensee Extra Contribution","Oustanding Funding Required","Total",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other"]
[null,"Description","Task","Project Workstream"]
[null,"UKPN Standards Engineer","Home trial","WS1"]
[null,"UKPN Income Management","Home trial","WS1"]
[null,"T&S for FATs etc","Home trial","WS1"]
[null,"UKPN Asset Engineer","Depot trial","WS2"]
[null,"UKPN Connections Designer","Depot trial","WS2"]
[null,"UKPN Customer Relationship Manager","Depot trial","WS2"]
[null,"UKPN Standards Engineer","Depot trial","WS2"]
[null,"UKPN IS resource","Depot trial","WS2"]
[null,"Procurement / support","Depot trial","WS2"]
[null,"Vendor (profiled connections tool)","Depot trial","WS2"]
[null,"Site visits (T&S)","Depot trial","WS2"]
[null,"UKPN Asset Engineer","Mixed trial","WS3"]
[null,"UKPN Connections Designer","Mixed trial","WS3"]
[null,"UKPN Customer Relationship Manager","Mixed trial","WS3"]
[null,"Flexibility payments (WS1)","DSR trialing Home","WS1"]
[null,"Flexibility payments (WS2)","DSR trialing Depot","WS2"]
[null,"ANM/DERMS modification (contractor)","DNO system integration","WS4"]
[null,"Systems integration (contractor)","DNO system integration","WS4"]
[null,"GSA/Netmap mofication (contractor)","DNO system integration","WS4"]
[null,"Cloud service","DNO system integration","WS4"]
[null,"Piclo platform","DNO system integration","WS4"]
[null,"Procurement / support","Procurement","WS4"]
[null,"UKPN DSO Engineer (x 3 - 4 people)","DNO system integration","WS4"]
[null,"UKPN IS architect","DNO system integration","WS4"]
[null,"UKPN IS Project Manager","DNO system integration","WS4"]
[null,"UKPN Control Systems and Automation Engineer","DNO system integration","WS4"]
[null,"UKPN Asset Information engineer","DNO system integration","WS4"]
[null,"UKPN Review","Project review","WS6"]
[null,"Academic partner","External data analysis","WS6"]
[null,"UKPN Data analyst","Data analysis","WS6"]
[null,"Learning events","Dissemination","WS7"]
[null,"LCNI Contribution","Dissemination","WS7"]
[null,"UKPN Project Manager","Project management","WS7"]
[null,"UKPN Project Support (x3 people)","Project management","WS7"]
[null,"UKPN T&S","Project management","WS7"]
[null,"UKPN Comms Lead","Project communications","WS7"]
[null,"UKPN Legal","Legal/contract advice","WS7"]
[null,"UKPN Contingency","n/a","WS7"]
[null,"SSEN Standards Engineer","Home trial","WS1"]
[null,"SSEN Asset Engineer","Depot trial","WS2"]
[null,"SSEN Connections Designer","Depot trial","WS2"]
[null,"SSEN Standards Engineer","Depot trial","WS2"]
[null,"Site visits (T&S)","Project management","WS2"]
[null,"SSEN Review","Project review","WS6"]
[null,"SSEN Project Management","Project Management","WS7"]
[null,"SSEN T&S","Project Management","WS7"]
[null,"Telematics","Vehicle monitoring-trial 1","WS1"]
[null,"Telematics","Vehicle monitoring-trial 2","WS2"]
[null,"Data Science WS1","Home charging DS","WS1"]
[null,"Data Science WS2","Depot charging DS","WS2"]
[null,"Data Science WS3","Mixed charging DS","WS3"]
[null,"Data Science WS4","Flexibility DS","WS4"]
[null,"GSS (Analytics)","Forecasting, flex analysis, data analysis","WS4"]
[null,"Analytics SW and SW Support","Operation of IoT Platform","WS4"]
[null,"HW and SW platform","Operation of IoT Platform","WS4"]
[null,"GSS (IaaS)","Operation of IoT Platform","WS4"]
[null,"WS Lead","Responsible for project reporting","WS6"]
[null,"WS Lead","Leading PMO","WS7"]
[null,"PMO","Overall management of the project","WS7"]
[null,"Governance","Overall project governance","WS7"]
[null,"WS Lead","Leading home trial activity","WS1"]
[null,"Trial designer","Designing trial 1","WS1"]
[null,"WS Lead","Leading depot trial activity","WS2"]
[null,"Trial designer","Designing trial 2","WS2"]
[null,"Data Scientist (Blend)","Creating depot planning tool","WS2"]
[null,"SW Engineer","Creating depot planning tool","WS2"]
[null,"Smart equipment SME","Creating depot planning tool","WS2"]
[null,"Planning tool designer","Creating depot planning tool","WS2"]
[null,"Site works (sub-contractor)","Implementing smart depot controller","WS2"]
[null,"IoT Engineer","Implementing smart depot controller","WS2"]
[null,"WS Lead","Leading implementation of trial 3","WS3"]
[null,"Trial designer","Designing trial 3","WS3"]
[null,"WS Lead","Leading forecasting & flexibility activity","WS4"]
[null,"WS Lead","Leading business model activity","WS5"]
[null,"Operating model SME","Creating commercial models","WS5"]
[null,"Commercial SME","Creating commercial models","WS5"]
[null,"CBA SME","Creating commercial models","WS5"]
[null,"Behavioural SME","Creating commercial models","WS5"]
[null,"Energy Technology Lead","Overseeing overall project technical direction","WS7"]
[null,"HC Project Management","Supporting home trial","WS3"]
[null,"Centrica Project Management","Planning/implementing home method trial","WS1"]
[null,"REStore ","Develop at home charge ","WS1"]
[null,"EV delta","Purchase of EV vans & infra","WS1"]
[null,"RM Project Manager/support","Planning/implementing depot method trial","WS2"]
[null,"EV delta","Purchase of EV vans & infra for Depot (cost delta vs diesel)","WS2"]
[null,"Site cost","Preparing sites for trial operation","WS2"]
[null,"Uber Project Management","Set up & manage data exchange/trial 3","WS3"]
[null,"Platform vehicle data","Data for trial 3","WS3"]
[]
[null,"Total"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Totals"]

{"sheet":"Project Direction","index":13,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,"Cost Category","Cost"]
[null,null,"Labour"]
[null,null,null,{"$f":"'Whole project'!DY96+'Whole project'!AD96+'Whole project'!DN96","v":0}]
[null,null,"Equipment"]
[null,null,null,{"$f":"'Whole project'!DZ96+'Whole project'!AE96+'Whole project'!DO96","v":0}]
[null,null,"Contractors"]
[null,null,null,{"$f":"'Whole project'!EA96+'Whole project'!AF96+'Whole project'!DP96","v":0}]
[null,null,"IT"]
[null,null,null,{"$f":"'Whole project'!EB96+'Whole project'!AG96+'Whole project'!DQ96","v":0}]
[null,null,"IPR Costs"]
[null,null,null,{"$f":"'Whole project'!EC96+'Whole project'!AH96+'Whole project'!DR96","v":0}]
[null,null,"Travel & Expenses"]
[null,null,null,{"$f":"'Whole project'!ED96+'Whole project'!AI96+'Whole project'!DS96","v":0}]
[null,null,"Payments to users"]
[null,null,null,{"$f":"'Whole project'!EE96+'Whole project'!AJ96+'Whole project'!DT96","v":0}]
[null,null,"Contingency"]
[null,null,null,{"$f":"'Whole project'!EF96+'Whole project'!AK96+'Whole project'!DU96","v":0}]
[null,null,"Decommissioning"]
[null,null,null,{"$f":"'Whole project'!EG96+'Whole project'!AL96+'Whole project'!DV96","v":0}]
[null,null,"Other"]
[null,null,null,{"$f":"'Whole project'!EH96+'Whole project'!AM96+'Whole project'!DW96","v":0},"Check that = to Total Outstanding Funding Required + Licensee Compulsory Contribution + Licensee Extra Contribution"]
[null,null,"Total",{"$f":"SUM(D6:D24)","v":0},{"$f":"IF(D25=('NIC Funding Request'!K79+'NIC Funding Request'!K37+'NIC Funding Request'!K66),\"OK\", \"ERROR\")","v":"ERROR"}]