{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Front Sheet","NIC Funding Request","Direct Benefits","Project Cost Summary","2020-2021","2021-2022","2022-2023","2023-2024","2024-2025","2025-2026","2026-2027","Whole project","Project Direction"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":4,"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,"Network Innovation Competition Full Submission "]
[null,null,null,null,null," Spreadsheet "]
[]
[null,null,null,null,null,"(2020 version 1.0)"]
[null,null,null,null,null,"Appendix A"]
[]
[]
[]
[null,null,"Licensee Name:","South Eastern Power Networks Plc"]
[]
[null,null,"Submission Date:","2020-10-15"]
[]
[]
[]
[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":12,"rows_kept":94,"cut":false,"hidden":false,"merged":[]}
["NIC Funding Request"]
[null," ","2020/21","2021/22","2022/23","2023/24","2024/25","2025/26","2026/27","Total"]
["Total Project Cost","From Project Cost Summary sheet"]
[null,"Labour",0,576.79999999999995,573,449.9,328.4,185.79999999999998,0,{"$f":"SUM(C4:I4)","v":2113.9}]
[null,"Equipment",0,644.57583,1283.4672100000003,266.75,10.5,10.5,0,2215.7930400000005]
[null,"Contractors",0,466.54758928571431,3221.4428342857136,613.71980357142854,222.12017857142857,278.25521428571432,0,4802.0856199999989]
[null,"IT",0,1551.6610000000001,3368.748,1392.9740000000002,325.74350000000004,325.74350000000004,0,6964.8700000000008]
[null,"IPR Costs",0,0,0,0,0,0,0,0]
[null,"Travel & Expenses",0,20.727777777777778,61.227777777777774,34.227777777777774,20.727777777777778,10.363888888888889,0,147.27499999999998]
["Payments to users & Contingency",null,0,279.9228,305.01929999999999,305.01929999999999,305.01929999999999,305.01929999999999,0,1499.9999999999998]
[null,"Decommissioning",0,0,0,0,0,0,0,0]
[null,"Other",0,16,16,16,16,16,0,80]
[null,"Total",{"$f":"SUM(C4:C12)","v":0},3556.2349970634918,8828.9051220634919,3078.5908813492065,1228.5107563492063,{"$f":"SUM(H4:H12)","v":1131.6819031746033},0,17823.923659999997]
[]
["External funding","Any funding that will be received from Project Partners and/or External Funders - from Project Cost Summary sheet"]
[null,"Labour",0,50.182332704178556,49.85172787707058,39.141871504178106,28.571217163752145,16.164836020174018,0,{"$f":"SUM(C16:I16)","v":183.91198526935341}]
[null,"Equipment",0,56.078916009244168,111.66327764757945,23.20758885027675,0.91351333806150281,0.91351333806150281,0,192.77680918322338]
[null,"Contractors",0,40.590232919327612,280.26961875453821,53.394402513808153,19.324737693105028,24.208557108110636,0,417.78754898888963]
[null,"IT",0,134.99647806189043,293.08535529219159,121.19050748313181,28.340098289222592,28.340098289222592,0,605.95253741565909]
[null,"IPR Costs",0,0,0,0,0,0,0,0]
[null,"Travel & Expenses",0,1.8033429969880779,5.326894443796732,2.9778601459242959,1.8033429969880779,0.90167149849403894,0,12.813112082191223]
["Payments to users & Contingency",null,0,24.353639183573566,26.537066563445993,26.537066563445993,26.537066563445993,26.537066563445993,0,130.50190543735755]
[null,"Decommissioning",0,0,0,0,0,0,0,0]
[null,"Other",0,1.3920203246651472,1.3920203246651472,1.3920203246651472,1.3920203246651472,1.3920203246651472,0,6.9601016233257358]
[null,"Total",{"$f":"SUM(C16:C24)","v":0},309.39696219986757,768.12596090328782,267.84131738543027,106.8819963692405,{"$f":"SUM(H16:H24)","v":98.457763142173931},0,1550.7040000000002]
[]
["Licensee extra contribution","Any funding from the Licensee which is in excess of the Licensee Compulsory Contribution - from Project Cost Summary sheet"]
[null,"Labour",0,0,0,0,0,0,0,{"$f":"SUM(C28:I28)","v":0}]
[null,"Equipment",0,0,0,0,0,0,0,0]
[null,"Contractors",0,0,0,0,0,0,0,0]
[null,"IT",0,0,0,0,0,0,0,0]
[null,"IPR Costs",0,0,0,0,0,0,0,0]
[null,"Travel & Expenses",0,0,0,0,0,0,0,0]
["Payments to users & Contingency",null,0,0,0,0,0,0,0,0]
[null,"Decommissioning",0,0,0,0,0,0,0,0]
[null,"Other",0,0,0,0,0,0,0,0]
[null,"Total",{"$f":"SUM(C28:C36)","v":0},0,0,0,0,{"$f":"SUM(H28:H36)","v":0},0,0]
[]
["Initial Net Funding Required"]
[null,"Labour",0,526.61766729582143,523.14827212292937,410.75812849582189,299.82878283624785,169.63516397982596,0,{"$f":"J4-J16-J28","v":1929.9880147306467}]
[null,"Equipment",0,588.49691399075584,1171.8039323524208,243.54241114972325,9.5864866619384976,9.5864866619384976,0,2023.0162308167771]
[null,"Contractors",0,425.9573563663867,2941.1732155311756,560.32540105762041,202.79544087832355,254.04665717760369,0,4384.2980710111096]
[null,"IT",0,1416.6645219381096,3075.6626447078083,1271.7834925168684,297.40340171077747,297.40340171077747,0,6358.9174625843416]
[null,"IPR Costs",0,0,0,0,0,0,0,0]
[null,"Travel & Expenses",0,18.924434780789699,55.900883333981042,31.249917631853478,18.924434780789699,9.4622173903948497,0,134.46188791780875]
["Payments to users & Contingency",null,0,255.56916081642643,278.482233436554,278.482233436554,278.482233436554,278.482233436554,0,1369.4980945626421]
[null,"Decommissioning",0,0,0,0,0,0,0,0,"Check Total = to Initial Net Funding request "]
[null,"Other",0,14.607979675334853,14.607979675334853,14.607979675334853,14.607979675334853,14.607979675334853,0,73.039898376674259,"in Project Cost Summary"]
[null,"Total",{"$f":"C13-C25-C37","v":0},3246.8380348636242,8060.7791611602042,2810.7495639637764,1121.6287599799657,{"$f":"H13-H25-H37","v":1033.2241400324294},0,{"$f":"J13-J25-J37","v":16273.219659999997},{"$f":"IF(J49='Project Cost Summary'!M13,\"OK\",\"ERROR\")","v":"ERROR"}]
[]
["Direct Benefits","from Direct Benefits sheet"]
[null,"Total",0,0,0,0,0,0,0,{"$f":"SUM(C52:I52)","v":0}]
[]
[]
[]
["Licensee Compulsory Contribution / Direct Benefits",null,"from Project Cost Summary sheet"]
[null,"Labour",0,52.661766729582141,52.31482721229294,41.075812849582185,29.982878283624778,16.963516397982598,0,{"$f":"SUM(C57:I57)","v":192.99880147306465}]
[null,"Equipment",0,58.849691399075574,117.18039323524206,24.354241114972321,0.9586486661938497,0.9586486661938497,0,202.30162308167766]
[null,"Contractors",0,42.595735636638665,294.11732155311756,56.032540105762045,20.279544087832353,25.404665717760366,0,438.42980710111101]
[null,"IT",0,141.66645219381095,307.56626447078082,127.17834925168683,29.740340171077744,29.740340171077744,0,635.89174625843407]
[null,"IPR Costs",0,0,0,0,0,0,0,0]
[null,"Travel & Expenses",0,1.8924434780789698,5.5900883333981044,3.1249917631853483,1.8924434780789698,0.94622173903948492,0,13.446188791780878]
["Payments to users & Contingency",null,0,25.55691608164264,27.848223343655398,27.848223343655398,27.848223343655398,27.848223343655398,0,136.94980945626423]
[null,"Decommissioning",0,0,0,0,0,0,0,0,"of Total Initial Net Funding Required"]
[null,"Other",0,1.4607979675334852,1.4607979675334852,1.4607979675334852,1.4607979675334852,1.4607979675334852,0,7.3039898376674266,{"$f":"IF(J66>=J49*0.1,\"OK\",\"ERROR\")","v":"OK"}]
[null,"Total",{"$f":"SUM(C57:C65)","v":0},324.68380348636242,806.07791611602033,281.07495639637762,112.16287599799658,{"$f":"SUM(H57:H65)","v":103.32241400324291},{"$f":"SUM(I57:I65)","v":0},{"$f":"SUM(C66:I66)","v":1627.3219659999997},"Check that Total is = or > than "]
[null,null,null,null,null,null,null,null,null,null,"Total Direct Benefits"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J66>=J52,\"OK\",\"ERROR\")","v":"OK"}]
["Outstanding Funding required"]
[null,"Labour",0,473.95590056623928,470.83344491063644,369.68231564623972,269.8459045526231,152.67164758184336,0,{"$f":"SUM(C70:I70)","v":1736.9892132575819}]
[null,"Equipment",0,529.64722259168025,1054.6235391171788,219.18817003475093,8.6278379957446472,8.6278379957446472,0,1820.7146077350992]
[null,"Contractors",0,383.36162072974804,2647.0558939780581,504.29286095185836,182.51589679049118,228.64199145984333,0,3945.8682639099993]
[null,"IT",0,1274.9980697442986,2768.0963802370275,1144.6051432651816,267.66306153969975,267.66306153969975,0,5723.0257163259066]
[null,"IPR Costs",0,0,0,0,0,0,0,0]
[null,"Travel & Expenses",0,17.031991302710729,50.310795000582935,28.124925868668129,17.031991302710729,8.5159956513553645,0,121.01569912602788]
["Payments to users & Contingency",null,0,230.01224473478379,250.63401009289859,250.63401009289859,250.63401009289859,250.63401009289859,0,1232.5482851063782]
[null,"Decommissioning",0,0,0,0,0,0,0,0,"Check that Total is =to "]
[null,"Other",0,13.147181707801368,13.147181707801368,13.147181707801368,13.147181707801368,13.147181707801368,0,65.735908539006843,"Total Outstanding Funding required"]
[null,"Total",{"$f":"C49-C66","v":0},2922.1542313772616,7254.7012450441835,2529.6746075673987,{"$f":"G49-G66","v":1009.4658839819691},929.90172602918653,0,14645.897693999999,{"$f":"IF(J79='Project Cost Summary'!M15, \"OK\",\"ERROR\")","v":"ERROR"}]
[]
["balance",14384.070890355333,0,11461.916658978073,4336.4453516805561,1885.7625541664506,907.4077097137166,-8.5281649960690995,-4.033767272480862,{"$f":"G81-G79+G82","v":-88.092322948851674},{"$f":"B81","v":14384.070890355333}]
["interest",null,0,129.22993774666702,78.991810053293136,31.111039529235033,13.965851319400835,4.4943977235882375,-6.2809661342749804E-2,{"$f":"((G81+J81)/2)*$D86","v":4.0965769338243243},{"$f":"SUM(D82:J82)","v":261.82680364466586}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K81+K82","v":14645.897693999999},{"$f":"J79-K83","v":0}]
[]
[null,"Bank of England interest rate",null,5.0000000000000001E-3,null,null,"NIC FUNDING REQUEST   £",null,{"$f":"K81","v":14384.070890355333}]
[null,"interest rate used in calculation",null,{"$f":"D85+0.5%","v":0.01}]
[null,"RPI adjustment","2020/21","2021/22","2022/23","2023/24","2024/25","2025/26","2026/27"]
[null,"Annual inflation ",1.7000000000000001E-2,2.1299999999999999E-2,2.58E-2,2.8000000000000001E-2,2.8000000000000001E-2,2.8000000000000001E-2,2.1000000000000001E-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 2020/21 - 2026/27 : https://www.gov.uk/government/statistics/forecasts-for-the-uk-economy-may-2020"]
[null,null,null,"RPI for 2025/26 and thereafter is an extension from 2024/25 as no further consistent forecast is available. "]

{"sheet":"Direct Benefits","index":2,"n_rows":14,"n_cols":10,"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,"2020/21","2021/22","2022/23","2023/24","2024/25","2025/26","2026/27","Total"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(C9:I9)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(C10:I10)","v":0}]
[null,"Total Direct Benefits",{"$f":"SUM(C9:C10)","v":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":118,"n_cols":15,"rows_kept":118,"cut":false,"hidden":false,"merged":[[92,2,92,12],[91,2,91,12],[106,2,106,12],[107,2,107,12],[77,2,77,12],[1,2,1,12],[17,2,17,12],[16,2,16,12],[61,2,61,12],[32,2,32,12],[31,2,31,12],[2,2,2,12],[4,14,12,14],[76,2,76,12],[47,2,47,12],[62,2,62,12],[46,2,46,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,null,null,"Check Total Initial Net Funding Required matches that on the Second Tier Funding Request tab"]
[null,"ABB"]
[null,"Siemens"]
[null,"GE"]
[null,"Vodafone"]
[null,"PNDC"]
[null,"External Funding"]
[null,"Licensee extra contribution"]
[null,"Initial Net Funding Required"]
[null,"Licensee Compulsory Contribution / Direct Benefits",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ABS(M13-'NIC Funding Request'!J49)<0.01,\"OK\",\"ERROR\")","v":"ERROR"}]
[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,"ABB"]
[null,"Siemens"]
[null,"GE"]
[null,"Vodafone"]
[null,"PNDC"]
[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,"ABB"]
[null,"Siemens"]
[null,"GE"]
[null,"Vodafone"]
[null,"PNDC"]
[null,"External Funding"]
[null,"Licensee extra contribution"]
[null,"Initial Net Funding Required"]
[null,"Licensee Compulsory Contribution / Direct Benefits"]
[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"]
[null,"ABB"]
[null,"Siemens"]
[null,"GE"]
[null,"Vodafone"]
[null,"PNDC"]
[null,"External Funding"]
[null,"Licensee extra contribution"]
[null,"Initial Net Funding Required"]
[null,"Licensee Compulsory Contribution / Direct Benefits"]
[null,"Outstanding Funding Required"]
[]
[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"]
[null,"ABB"]
[null,"Siemens"]
[null,"GE"]
[null,"Vodafone"]
[null,"PNDC"]
[null,"External Funding"]
[null,"Licensee extra contribution"]
[null,"Initial Net Funding Required"]
[null,"Licensee Compulsory Contribution"]
[null,"Outstanding Funding Required"]
[]
[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"]
[null,"ABB"]
[null,"Siemens"]
[null,"GE"]
[null,"Vodafone"]
[null,"PNDC"]
[null,"External Funding"]
[null,"Licensee extra contribution"]
[null,"Initial Net Funding Required"]
[null,"Licensee Compulsory Contribution"]
[null,"Outstanding Funding Required"]
[]
[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"]
[null,"ABB"]
[null,"Siemens"]
[null,"GE"]
[null,"Vodafone"]
[null,"PNDC"]
[null,"External Funding"]
[null,"Licensee extra contribution"]
[null,"Initial Net Funding Required"]
[null,"Licensee Compulsory Contribution"]
[null,"Outstanding Funding Required"]
[]
[null,null,"2026/27"]
[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,"ABB"]
[null,"Siemens"]
[null,"GE"]
[null,"Vodafone"]
[null,"PNDC"]
[null,"Initial Net Funding Required"]
[null,"Licensee Compulsory Contribution"]
[null,"Outstanding Funding Required"]

{"sheet":"2020-2021","index":4,"n_rows":269,"n_cols":114,"rows_kept":269,"cut":false,"hidden":false,"merged":[[3,104,3,113],[3,93,3,102],[3,6,3,15],[3,17,3,25],[3,27,3,36],[3,38,3,47],[3,49,3,58],[3,60,3,69],[3,71,3,80],[3,82,3,91]]}
[null,"Project Costs in 2020-2021"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ABB",null,null,null,null,null,null,null,null,null,null,"GE",null,null,null,null,null,null,null,null,null,null,"PNDC",null,null,null,null,null,null,null,null,null,null,"Siemens",null,null,null,null,null,null,null,null,null,null,"Vodafone"]
[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,"Licensee Compulsory Contribution/Direct Benefits",null,null,null,null,null,null,null,null,null,null,"Project Partner 1",null,null,null,null,null,null,null,null,null,null,"Project Partner 2",null,null,null,null,null,null,null,null,null,null,"Project Partner 3",null,null,null,null,null,null,null,null,null,null,"Project Partner 4",null,null,null,null,null,null,null,null,null,null,"Project Partner 5",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","Project Partner 1","Project Partner 2","Project Partner 3","Project Partner 4","Project Partner 5","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,"Description","Task","Project Workstream",null,null,null,null,null,null,null,null,null,null,null,null,null,"UKPN","ABB","GE","PNDC","Siemens","Vodafone","UKPN","NIC"]
["Example","Stage 1 - Agreement from customers to proceed","Complete spreadsheet","Workstream 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R7:Y7)","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},0,0,0,0,0,0,0,0,0,null,{"$f":"$Y7*G7","v":0},0,0,0,0,0,0,0,0,0]
[null,"Solution design and approval","Details of the system design and architecture for protection and control on a substation with local intelligence","Workstreams 1 and 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R8:Y8)","v":0},null,{"$f":"$R8*G8","v":0},{"$f":"$R8*H8","v":0},{"$f":"$R8*I8","v":0},{"$f":"$R8*J8","v":0},{"$f":"$R8*K8","v":0},{"$f":"$R8*L8","v":0},{"$f":"$R8*M8","v":0},{"$f":"$R8*N8","v":0},{"$f":"$R8*O8","v":0},{"$f":"$R8*P8","v":0},null,{"$f":"$S8*G8","v":0},{"$f":"$S8*H8","v":0},{"$f":"$S8*I8","v":0},{"$f":"$S8*J8","v":0},{"$f":"$S8*K8","v":0},{"$f":"$S8*L8","v":0},{"$f":"$S8*M8","v":0},{"$f":"$S8*N8","v":0},{"$f":"$S8*O8","v":0},{"$f":"$S8*P8","v":0},null,{"$f":"$T8*G8","v":0},{"$f":"$T8*H8","v":0},{"$f":"$T8*I8","v":0},{"$f":"$T8*J8","v":0},{"$f":"$T8*K8","v":0},{"$f":"$T8*L8","v":0},{"$f":"$T8*M8","v":0},{"$f":"$T8*N8","v":0},{"$f":"$T8*O8","v":0},{"$f":"$T8*P8","v":0},null,{"$f":"$U8*G8","v":0},{"$f":"$U8*H8","v":0},{"$f":"$U8*I8","v":0},{"$f":"$U8*J8","v":0},{"$f":"$U8*K8","v":0},{"$f":"$U8*L8","v":0},{"$f":"$U8*M8","v":0},{"$f":"$U8*N8","v":0},{"$f":"$U8*O8","v":0},{"$f":"$U8*P8","v":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,"Trial design and site selection","Description of the trial design and site selection criteria process","Workstreams 2 and 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Equipment specification and purchase","Description of the trial design and site selection criteria process","Workstream 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Solution development and approval","Initial learning from off-network PNDC trial, and learning from functionality development, virtualisation","Workstreams 1 and 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Initial validation and off-network installation and testing","Initial learning from off-network PNDC trial, and learning from functionality development, virtualisation","Workstream 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Trial site preparation: design, installation and commissioning","Review of site installation and learning from mid trial passive network demonstration","Workstream 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Site acceptance testing and solution reiterations","Review of site installation and learning from mid trial passive network demonstration","Workstream 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Transition from PNDC to live network","Review of site installation and learning from mid trial passive network demonstration","Workstream 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Plan, launch, publicise and select OIC participants","Learning from the innovation competition process","Workstream 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Incubate, test and deploy as network trial","Learning from the innovation competition process","Workstream 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Launch academic research and review deliverables","Learning from academic insights and the governance required to prepare for the future world of distributed & autonomous network operation","Workstream 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Data gathering and engineering support for network trials","Presentation of findings from project trials and innovation competition trial ","Workstream 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Communications, training, dissemination and events","Presentation of findings from project trials and innovation competition trial ","Workstream 6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Project management and contingency","Presentation of findings from project trials and innovation competition trial ","PM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,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,{"$f":"SUM(R22:Y22)","v":0},null,{"$f":"$R22*G22","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$S22*G22","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$T22*G22","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$U22*G22","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$U22*R22","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$U22*AC22","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$X22*G22","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$Y22*G22","v":0},0,0,0,0,0,0,0,0,0]
[null,"Total",null,null,null,null,{"$f":"SUM(G7:G22)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(G23:P23)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AB7:AB22)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AM7:AM22)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AX7:AX22)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(BI7:BI22)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(BT7:BT22)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(CE7:CE22)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(CP7:CP22)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(DA7:DA22)","v":0},0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Totals"]

{"sheet":"2021-2022","index":5,"n_rows":268,"n_cols":114,"rows_kept":268,"cut":false,"hidden":false,"merged":[[3,104,3,113],[3,93,3,102],[3,6,3,15],[3,17,3,25],[3,27,3,36],[3,38,3,47],[3,49,3,58],[3,60,3,69],[3,71,3,80],[3,82,3,91]]}
[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,"Licensee Compulsory Contribution/Direct Benefits",null,null,null,null,null,null,null,null,null,null,"ABB",null,null,null,null,null,null,null,null,null,null,"Siemens",null,null,null,null,null,null,null,null,null,null,"GE",null,null,null,null,null,null,null,null,null,null,"Vodafone",null,null,null,null,null,null,null,null,null,null,"PNDC",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","ABB","Siemens","GE","Vodafone","PNDC","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,"Description","Task","Project Workstream"]
[null,"Solution design and approval","Details of the system design and architecture for protection and control on a substation with local intelligence","Workstreams 1 and 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R7:Y7)","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},0,0,0,0,0,0,0,0,0,null,{"$f":"$Y7*G7","v":0},0,0,0,0,0,0,0,0,0]
[null,"Trial design and site selection","Description of the trial design and site selection criteria process","Workstreams 2 and 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R8:Y8)","v":0},null,{"$f":"$R8*G8","v":0},{"$f":"$R8*H8","v":0},{"$f":"$R8*I8","v":0},{"$f":"$R8*J8","v":0},{"$f":"$R8*K8","v":0},{"$f":"$R8*L8","v":0},{"$f":"$R8*M8","v":0},{"$f":"$R8*N8","v":0},{"$f":"$R8*O8","v":0},{"$f":"$R8*P8","v":0},null,{"$f":"$S8*G8","v":0},{"$f":"$S8*H8","v":0},{"$f":"$S8*I8","v":0},{"$f":"$S8*J8","v":0},{"$f":"$S8*K8","v":0},{"$f":"$S8*L8","v":0},{"$f":"$S8*M8","v":0},{"$f":"$S8*N8","v":0},{"$f":"$S8*O8","v":0},{"$f":"$S8*P8","v":0},null,{"$f":"$T8*G8","v":0},{"$f":"$T8*H8","v":0},{"$f":"$T8*I8","v":0},{"$f":"$T8*J8","v":0},{"$f":"$T8*K8","v":0},{"$f":"$T8*L8","v":0},{"$f":"$T8*M8","v":0},{"$f":"$T8*N8","v":0},{"$f":"$T8*O8","v":0},{"$f":"$T8*P8","v":0},null,{"$f":"$U8*G8","v":0},{"$f":"$U8*H8","v":0},{"$f":"$U8*I8","v":0},{"$f":"$U8*J8","v":0},{"$f":"$U8*K8","v":0},{"$f":"$U8*L8","v":0},{"$f":"$U8*M8","v":0},{"$f":"$U8*N8","v":0},{"$f":"$U8*O8","v":0},{"$f":"$U8*P8","v":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,"Equipment specification and purchase","Description of the trial design and site selection criteria process","Workstream 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Solution development and approval","Initial learning from off-network PNDC trial, and learning from functionality development, virtualisation","Workstreams 1 and 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Initial validation and off-network installation and testing","Initial learning from off-network PNDC trial, and learning from functionality development, virtualisation","Workstream 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Trial site preparation: design, installation and commissioning","Review of site installation and learning from mid trial passive network demonstration","Workstream 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Site acceptance testing and solution reiterations","Review of site installation and learning from mid trial passive network demonstration","Workstream 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Transition from PNDC to live network","Review of site installation and learning from mid trial passive network demonstration","Workstream 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Plan, launch, publicise and select OIC participants","Learning from the innovation competition process","Workstream 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Incubate, test and deploy as network trial","Learning from the innovation competition process","Workstream 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Launch academic research and review deliverables","Learning from academic insights and the governance required to prepare for the future world of distributed & autonomous network operation","Workstream 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Data gathering and engineering support for network trials","Presentation of findings from project trials and innovation competition trial ","Workstream 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Communications, training, dissemination and events","Presentation of findings from project trials and innovation competition trial ","Workstream 6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Project management and contingency","Presentation of findings from project trials and innovation competition trial ","PM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,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,{"$f":"SUM(R21:Y21)","v":0},null,{"$f":"$R21*G21","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$S21*G21","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$T21*G21","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$U21*G21","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$V21*G21","v":0},{"$f":"$V21*H21","v":0},{"$f":"$V21*I21","v":0},{"$f":"$V21*J21","v":0},{"$f":"$V21*K21","v":0},{"$f":"$V21*L21","v":0},{"$f":"$V21*M21","v":0},{"$f":"$V21*N21","v":0},{"$f":"$V21*O21","v":0},{"$f":"$V21*P21","v":0},null,{"$f":"$W21*G21","v":0},{"$f":"$W21*H21","v":0},{"$f":"$W21*I21","v":0},{"$f":"$W21*J21","v":0},{"$f":"$W21*K21","v":0},{"$f":"$W21*L21","v":0},{"$f":"$W21*M21","v":0},{"$f":"$W21*N21","v":0},{"$f":"$W21*O21","v":0},{"$f":"$W21*P21","v":0},null,{"$f":"$X21*G21","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$Y21*G21","v":0},0,0,0,0,0,0,0,0,0]
[null,"Total",null,null,null,null,{"$f":"SUM(G7:G21)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(G22:P22)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AB7:AB21)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AM7:AM21)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AX7:AX21)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(BI7:BI21)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(BT7:BT21)","v":0},{"$f":"SUM(BU7:BU21)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(CE7:CE21)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(CP7:CP21)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(DA7:DA21)","v":0},0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Totals"]

{"sheet":"2022-2023","index":6,"n_rows":268,"n_cols":114,"rows_kept":268,"cut":false,"hidden":false,"merged":[[3,104,3,113],[3,93,3,102],[3,6,3,15],[3,17,3,25],[3,27,3,36],[3,38,3,47],[3,49,3,58],[3,60,3,69],[3,71,3,80],[3,82,3,91]]}
[null,"Project Costs in 2022-2023"]
[]
[]
[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,"Licensee Compulsory Contribution/Direct Benefits",null,null,null,null,null,null,null,null,null,null,"ABB",null,null,null,null,null,null,null,null,null,null,"Siemens",null,null,null,null,null,null,null,null,null,null,"GE",null,null,null,null,null,null,null,null,null,null,"Vodafone",null,null,null,null,null,null,null,null,null,null,"PNDC",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","ABB","Siemens","GE","Vodafone","PNDC","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,"Description","Task","Project Workstream"]
[null,"Solution design and approval","Details of the system design and architecture for protection and control on a substation with local intelligence","Workstreams 1 and 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R7:Y7)","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},0,0,0,0,0,0,0,0,0,null,{"$f":"$Y7*G7","v":0},0,0,0,0,0,0,0,0,0]
[null,"Trial design and site selection","Description of the trial design and site selection criteria process","Workstreams 2 and 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R8:Y8)","v":0},null,{"$f":"$R8*G8","v":0},{"$f":"$R8*H8","v":0},{"$f":"$R8*I8","v":0},{"$f":"$R8*J8","v":0},{"$f":"$R8*K8","v":0},{"$f":"$R8*L8","v":0},{"$f":"$R8*M8","v":0},{"$f":"$R8*N8","v":0},{"$f":"$R8*O8","v":0},{"$f":"$R8*P8","v":0},null,{"$f":"$S8*G8","v":0},{"$f":"$S8*H8","v":0},{"$f":"$S8*I8","v":0},{"$f":"$S8*J8","v":0},{"$f":"$S8*K8","v":0},{"$f":"$S8*L8","v":0},{"$f":"$S8*M8","v":0},{"$f":"$S8*N8","v":0},{"$f":"$S8*O8","v":0},{"$f":"$S8*P8","v":0},null,{"$f":"$T8*G8","v":0},{"$f":"$T8*H8","v":0},{"$f":"$T8*I8","v":0},{"$f":"$T8*J8","v":0},{"$f":"$T8*K8","v":0},{"$f":"$T8*L8","v":0},{"$f":"$T8*M8","v":0},{"$f":"$T8*N8","v":0},{"$f":"$T8*O8","v":0},{"$f":"$T8*P8","v":0},null,{"$f":"$U8*G8","v":0},{"$f":"$U8*H8","v":0},{"$f":"$U8*I8","v":0},{"$f":"$U8*J8","v":0},{"$f":"$U8*K8","v":0},{"$f":"$U8*L8","v":0},{"$f":"$U8*M8","v":0},{"$f":"$U8*N8","v":0},{"$f":"$U8*O8","v":0},{"$f":"$U8*P8","v":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,"Equipment specification and purchase","Description of the trial design and site selection criteria process","Workstream 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Solution development and approval","Initial learning from off-network PNDC trial, and learning from functionality development, virtualisation","Workstreams 1 and 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Initial validation and off-network installation and testing","Initial learning from off-network PNDC trial, and learning from functionality development, virtualisation","Workstream 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Trial site preparation: design, installation and commissioning","Review of site installation and learning from mid trial passive network demonstration","Workstream 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Site acceptance testing and solution reiterations","Review of site installation and learning from mid trial passive network demonstration","Workstream 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Transition from PNDC to live network","Review of site installation and learning from mid trial passive network demonstration","Workstream 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Plan, launch, publicise and select OIC participants","Learning from the innovation competition process","Workstream 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Incubate, test and deploy as network trial","Learning from the innovation competition process","Workstream 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Launch academic research and review deliverables","Learning from academic insights and the governance required to prepare for the future world of distributed & autonomous network operation","Workstream 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Data gathering and engineering support for network trials","Presentation of findings from project trials and innovation competition trial ","Workstream 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Communications, training, dissemination and events","Presentation of findings from project trials and innovation competition trial ","Workstream 6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Project management and contingency","Presentation of findings from project trials and innovation competition trial ","PM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,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,{"$f":"SUM(R21:Y21)","v":0},null,{"$f":"$R21*G21","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$S21*G21","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$T21*G21","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$U21*G21","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$V21*G21","v":0},{"$f":"$V21*H21","v":0},{"$f":"$V21*I21","v":0},{"$f":"$V21*J21","v":0},{"$f":"$V21*K21","v":0},{"$f":"$V21*L21","v":0},{"$f":"$V21*M21","v":0},{"$f":"$V21*N21","v":0},{"$f":"$V21*O21","v":0},{"$f":"$V21*P21","v":0},null,{"$f":"$W21*G21","v":0},{"$f":"$W21*H21","v":0},{"$f":"$W21*I21","v":0},{"$f":"$W21*J21","v":0},{"$f":"$W21*K21","v":0},{"$f":"$W21*L21","v":0},{"$f":"$W21*M21","v":0},{"$f":"$W21*N21","v":0},{"$f":"$W21*O21","v":0},{"$f":"$W21*P21","v":0},null,{"$f":"$X21*G21","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$Y21*G21","v":0},0,0,0,0,0,0,0,0,0]
[null,"Total",null,null,null,null,{"$f":"SUM(G7:G21)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(G22:P22)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AB7:AB21)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AM7:AM21)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AX7:AX21)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(BI7:BI21)","v":0},{"$f":"SUM(BJ7:BJ21)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(BT7:BT21)","v":0},{"$f":"SUM(BU7:BU21)","v":0},{"$f":"SUM(BV7:BV21)","v":0},{"$f":"SUM(BW7:BW21)","v":0},{"$f":"SUM(BX7:BX21)","v":0},{"$f":"SUM(BY7:BY21)","v":0},{"$f":"SUM(BZ7:BZ21)","v":0},{"$f":"SUM(CA7:CA21)","v":0},{"$f":"SUM(CB7:CB21)","v":0},{"$f":"SUM(CC7:CC21)","v":0},null,{"$f":"SUM(CE7:CE21)","v":0},{"$f":"SUM(CF7:CF21)","v":0},{"$f":"SUM(CG7:CG21)","v":0},{"$f":"SUM(CH7:CH21)","v":0},{"$f":"SUM(CI7:CI21)","v":0},{"$f":"SUM(CJ7:CJ21)","v":0},{"$f":"SUM(CK7:CK21)","v":0},{"$f":"SUM(CL7:CL21)","v":0},{"$f":"SUM(CM7:CM21)","v":0},{"$f":"SUM(CN7:CN21)","v":0},null,{"$f":"SUM(CP7:CP21)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(DA7:DA21)","v":0},0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Totals"]

{"sheet":"2023-2024","index":7,"n_rows":268,"n_cols":114,"rows_kept":268,"cut":false,"hidden":false,"merged":[[3,93,3,102],[3,104,3,113],[3,6,3,15],[3,17,3,25],[3,27,3,36],[3,38,3,47],[3,49,3,58],[3,60,3,69],[3,71,3,80],[3,82,3,91]]}
[null,"Project Costs in 2023-2024"]
[]
[]
[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,"Licensee Compulsory Contribution/Direct Benefits",null,null,null,null,null,null,null,null,null,null,"ABB",null,null,null,null,null,null,null,null,null,null,"Siemens",null,null,null,null,null,null,null,null,null,null,"GE",null,null,null,null,null,null,null,null,null,null,"Vodafone",null,null,null,null,null,null,null,null,null,null,"PNDC",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","ABB","Siemens","GE","Vodafone","PNDC","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,"Description","Task","Project Workstream"]
[null,"Solution design and approval","Details of the system design and architecture for protection and control on a substation with local intelligence","Workstreams 1 and 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R7:Y7)","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},0,0,0,0,0,0,0,0,0,null,{"$f":"$Y7*G7","v":0},0,0,0,0,0,0,0,0,0]
[null,"Trial design and site selection","Description of the trial design and site selection criteria process","Workstreams 2 and 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R8:Y8)","v":0},null,{"$f":"$R8*G8","v":0},{"$f":"$R8*H8","v":0},{"$f":"$R8*I8","v":0},{"$f":"$R8*J8","v":0},{"$f":"$R8*K8","v":0},{"$f":"$R8*L8","v":0},{"$f":"$R8*M8","v":0},{"$f":"$R8*N8","v":0},{"$f":"$R8*O8","v":0},{"$f":"$R8*P8","v":0},null,{"$f":"$S8*G8","v":0},{"$f":"$S8*H8","v":0},{"$f":"$S8*I8","v":0},{"$f":"$S8*J8","v":0},{"$f":"$S8*K8","v":0},{"$f":"$S8*L8","v":0},{"$f":"$S8*M8","v":0},{"$f":"$S8*N8","v":0},{"$f":"$S8*O8","v":0},{"$f":"$S8*P8","v":0},null,{"$f":"$T8*G8","v":0},{"$f":"$T8*H8","v":0},{"$f":"$T8*I8","v":0},{"$f":"$T8*J8","v":0},{"$f":"$T8*K8","v":0},{"$f":"$T8*L8","v":0},{"$f":"$T8*M8","v":0},{"$f":"$T8*N8","v":0},{"$f":"$T8*O8","v":0},{"$f":"$T8*P8","v":0},null,{"$f":"$U8*G8","v":0},{"$f":"$U8*H8","v":0},{"$f":"$U8*I8","v":0},{"$f":"$U8*J8","v":0},{"$f":"$U8*K8","v":0},{"$f":"$U8*L8","v":0},{"$f":"$U8*M8","v":0},{"$f":"$U8*N8","v":0},{"$f":"$U8*O8","v":0},{"$f":"$U8*P8","v":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,"Equipment specification and purchase","Description of the trial design and site selection criteria process","Workstream 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Solution development and approval","Initial learning from off-network PNDC trial, and learning from functionality development, virtualisation","Workstreams 1 and 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Initial validation and off-network installation and testing","Initial learning from off-network PNDC trial, and learning from functionality development, virtualisation","Workstream 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Trial site preparation: design, installation and commissioning","Review of site installation and learning from mid trial passive network demonstration","Workstream 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,0,{"$f":"$R12*I12","v":0},{"$f":"$R12*J12","v":0},0,0,0,0,0,0,null,0,0,{"$f":"$S12*I12","v":0},{"$f":"$S12*J12","v":0},0,0,0,0,0,0,null,0,0,{"$f":"$T12*I12","v":0},{"$f":"$T12*J12","v":0},0,0,0,0,0,0,null,0,0,{"$f":"$U12*I12","v":0},{"$f":"$U12*J12","v":0},0,0,0,0,0,0,null,0,0,{"$f":"$V12*I12","v":0},{"$f":"$V12*J12","v":0},0,0,0,0,0,0,null,0,0,{"$f":"$W12*I12","v":0},{"$f":"$W12*J12","v":0},0,0,0,0,0,0,null,0,0,{"$f":"$X12*I12","v":0},{"$f":"$X12*J12","v":0},0,0,0,0,0,0,null,0,0,{"$f":"$Y12*I12","v":0},{"$f":"$Y12*J12","v":0},0,0,0,0,0,0]
[null,"Site acceptance testing and solution reiterations","Review of site installation and learning from mid trial passive network demonstration","Workstream 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,0,{"$f":"$R13*I13","v":0},{"$f":"$R13*J13","v":0},0,0,0,0,0,0,null,0,0,{"$f":"$S13*I13","v":0},{"$f":"$S13*J13","v":0},0,0,0,0,0,0,null,0,0,{"$f":"$T13*I13","v":0},{"$f":"$T13*J13","v":0},0,0,0,0,0,0,null,0,0,{"$f":"$U13*I13","v":0},{"$f":"$U13*J13","v":0},0,0,0,0,0,0,null,0,0,{"$f":"$V13*I13","v":0},{"$f":"$V13*J13","v":0},0,0,0,0,0,0,null,0,0,{"$f":"$W13*I13","v":0},{"$f":"$W13*J13","v":0},0,0,0,0,0,0,null,0,0,{"$f":"$X13*I13","v":0},{"$f":"$X13*J13","v":0},0,0,0,0,0,0,null,0,0,{"$f":"$Y13*I13","v":0},{"$f":"$Y13*J13","v":0},0,0,0,0,0,0]
[null,"Transition from PNDC to live network","Review of site installation and learning from mid trial passive network demonstration","Workstream 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Plan, launch, publicise and select OIC participants","Learning from the innovation competition process","Workstream 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Incubate, test and deploy as network trial","Learning from the innovation competition process","Workstream 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Launch academic research and review deliverables","Learning from academic insights and the governance required to prepare for the future world of distributed & autonomous network operation","Workstream 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Data gathering and engineering support for network trials","Presentation of findings from project trials and innovation competition trial ","Workstream 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Communications, training, dissemination and events","Presentation of findings from project trials and innovation competition trial ","Workstream 6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Project management and contingency","Presentation of findings from project trials and innovation competition trial ","PM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,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,{"$f":"SUM(R21:Y21)","v":0},null,{"$f":"$R21*G21","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$S21*G21","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$T21*G21","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$U21*G21","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$V21*G21","v":0},{"$f":"$V21*H21","v":0},{"$f":"$V21*I21","v":0},{"$f":"$V21*J21","v":0},{"$f":"$V21*K21","v":0},{"$f":"$V21*L21","v":0},{"$f":"$V21*M21","v":0},{"$f":"$V21*N21","v":0},{"$f":"$V21*O21","v":0},{"$f":"$V21*P21","v":0},null,{"$f":"$W21*G21","v":0},{"$f":"$W21*H21","v":0},{"$f":"$W21*I21","v":0},{"$f":"$W21*J21","v":0},{"$f":"$W21*K21","v":0},{"$f":"$W21*L21","v":0},{"$f":"$W21*M21","v":0},{"$f":"$W21*N21","v":0},{"$f":"$W21*O21","v":0},{"$f":"$W21*P21","v":0},null,{"$f":"$X21*G21","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$Y21*G21","v":0},0,0,0,0,0,0,0,0,0]
[null,"Total",null,null,null,null,{"$f":"SUM(G7:G21)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(G22:P22)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AB7:AB21)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AM7:AM21)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AX7:AX21)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(BI7:BI21)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(BT7:BT21)","v":0},{"$f":"SUM(BU7:BU21)","v":0},{"$f":"SUM(BV7:BV21)","v":0},{"$f":"SUM(BW7:BW21)","v":0},{"$f":"SUM(BX7:BX21)","v":0},{"$f":"SUM(BY7:BY21)","v":0},{"$f":"SUM(BZ7:BZ21)","v":0},{"$f":"SUM(CA7:CA21)","v":0},{"$f":"SUM(CB7:CB21)","v":0},{"$f":"SUM(CC7:CC21)","v":0},null,{"$f":"SUM(CE7:CE21)","v":0},{"$f":"SUM(CF7:CF21)","v":0},{"$f":"SUM(CG7:CG21)","v":0},{"$f":"SUM(CH7:CH21)","v":0},{"$f":"SUM(CI7:CI21)","v":0},{"$f":"SUM(CJ7:CJ21)","v":0},{"$f":"SUM(CK7:CK21)","v":0},{"$f":"SUM(CL7:CL21)","v":0},{"$f":"SUM(CM7:CM21)","v":0},{"$f":"SUM(CN7:CN21)","v":0},null,{"$f":"SUM(CP7:CP21)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(DA7:DA21)","v":0},0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Totals"]

{"sheet":"2024-2025","index":8,"n_rows":268,"n_cols":114,"rows_kept":268,"cut":false,"hidden":false,"merged":[[3,93,3,102],[3,104,3,113],[3,6,3,15],[3,17,3,25],[3,27,3,36],[3,38,3,47],[3,49,3,58],[3,60,3,69],[3,71,3,80],[3,82,3,91]]}
[null,"Project Costs in 2024-2025"]
[]
[]
[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,"Licensee Compulsory Contribution/Direct Benefits",null,null,null,null,null,null,null,null,null,null,"ABB",null,null,null,null,null,null,null,null,null,null,"Siemens",null,null,null,null,null,null,null,null,null,null,"GE",null,null,null,null,null,null,null,null,null,null,"Vodafone",null,null,null,null,null,null,null,null,null,null,"PNDC",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","ABB","Siemens","GE","Vodafone","PNDC","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,"Description","Task","Project Workstream"]
[null,"Solution design and approval","Details of the system design and architecture for protection and control on a substation with local intelligence","Workstreams 1 and 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R7:Y7)","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},0,0,0,0,0,0,0,0,0,null,{"$f":"$Y7*G7","v":0},0,0,0,0,0,0,0,0,0]
[null,"Trial design and site selection","Description of the trial design and site selection criteria process","Workstreams 2 and 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R8:Y8)","v":0},null,{"$f":"$R8*G8","v":0},{"$f":"$R8*H8","v":0},{"$f":"$R8*I8","v":0},{"$f":"$R8*J8","v":0},{"$f":"$R8*K8","v":0},{"$f":"$R8*L8","v":0},{"$f":"$R8*M8","v":0},{"$f":"$R8*N8","v":0},{"$f":"$R8*O8","v":0},{"$f":"$R8*P8","v":0},null,{"$f":"$S8*G8","v":0},{"$f":"$S8*H8","v":0},{"$f":"$S8*I8","v":0},{"$f":"$S8*J8","v":0},{"$f":"$S8*K8","v":0},{"$f":"$S8*L8","v":0},{"$f":"$S8*M8","v":0},{"$f":"$S8*N8","v":0},{"$f":"$S8*O8","v":0},{"$f":"$S8*P8","v":0},null,{"$f":"$T8*G8","v":0},{"$f":"$T8*H8","v":0},{"$f":"$T8*I8","v":0},{"$f":"$T8*J8","v":0},{"$f":"$T8*K8","v":0},{"$f":"$T8*L8","v":0},{"$f":"$T8*M8","v":0},{"$f":"$T8*N8","v":0},{"$f":"$T8*O8","v":0},{"$f":"$T8*P8","v":0},null,{"$f":"$U8*G8","v":0},{"$f":"$U8*H8","v":0},{"$f":"$U8*I8","v":0},{"$f":"$U8*J8","v":0},{"$f":"$U8*K8","v":0},{"$f":"$U8*L8","v":0},{"$f":"$U8*M8","v":0},{"$f":"$U8*N8","v":0},{"$f":"$U8*O8","v":0},{"$f":"$U8*P8","v":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,"Equipment specification and purchase","Description of the trial design and site selection criteria process","Workstream 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Solution development and approval","Initial learning from off-network PNDC trial, and learning from functionality development, virtualisation","Workstreams 1 and 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Initial validation and off-network installation and testing","Initial learning from off-network PNDC trial, and learning from functionality development, virtualisation","Workstream 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Trial site preparation: design, installation and commissioning","Review of site installation and learning from mid trial passive network demonstration","Workstream 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Site acceptance testing and solution reiterations","Review of site installation and learning from mid trial passive network demonstration","Workstream 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Transition from PNDC to live network","Review of site installation and learning from mid trial passive network demonstration","Workstream 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Plan, launch, publicise and select OIC participants","Learning from the innovation competition process","Workstream 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Incubate, test and deploy as network trial","Learning from the innovation competition process","Workstream 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Launch academic research and review deliverables","Learning from academic insights and the governance required to prepare for the future world of distributed & autonomous network operation","Workstream 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Data gathering and engineering support for network trials","Presentation of findings from project trials and innovation competition trial ","Workstream 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Communications, training, dissemination and events","Presentation of findings from project trials and innovation competition trial ","Workstream 6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Project management and contingency","Presentation of findings from project trials and innovation competition trial ","PM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,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,{"$f":"SUM(R21:Y21)","v":0},null,{"$f":"$R21*G21","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$S21*G21","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$T21*G21","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$U21*G21","v":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":"$X21*G21","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$Y21*G21","v":0},0,0,0,0,0,0,0,0,0]
[null,"Total",null,null,null,null,{"$f":"SUM(G7:G21)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(G22:P22)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AB7:AB21)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AM7:AM21)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AX7:AX21)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(BI7:BI21)","v":0},0,0,{"$f":"SUM(BL7:BL21)","v":0},0,0,0,0,0,0,null,{"$f":"SUM(BT7:BT21)","v":0},{"$f":"SUM(BU7:BU21)","v":0},{"$f":"SUM(BV7:BV21)","v":0},{"$f":"SUM(BW7:BW21)","v":0},{"$f":"SUM(BX7:BX21)","v":0},{"$f":"SUM(BY7:BY21)","v":0},{"$f":"SUM(BZ7:BZ21)","v":0},{"$f":"SUM(CA7:CA21)","v":0},{"$f":"SUM(CB7:CB21)","v":0},{"$f":"SUM(CC7:CC21)","v":0},null,{"$f":"SUM(CE7:CE21)","v":0},{"$f":"SUM(CF7:CF21)","v":0},{"$f":"SUM(CG7:CG21)","v":0},{"$f":"SUM(CH7:CH21)","v":0},{"$f":"SUM(CI7:CI21)","v":0},{"$f":"SUM(CJ7:CJ21)","v":0},{"$f":"SUM(CK7:CK21)","v":0},{"$f":"SUM(CL7:CL21)","v":0},{"$f":"SUM(CM7:CM21)","v":0},{"$f":"SUM(CN7:CN21)","v":0},null,{"$f":"SUM(CP7:CP21)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(DA7:DA21)","v":0},0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Totals"]

{"sheet":"2025-2026","index":9,"n_rows":268,"n_cols":114,"rows_kept":268,"cut":false,"hidden":false,"merged":[[3,93,3,102],[3,104,3,113],[3,6,3,15],[3,17,3,25],[3,27,3,36],[3,38,3,47],[3,49,3,58],[3,60,3,69],[3,71,3,80],[3,82,3,91]]}
[null,"Project Costs in 2025-2026"]
[]
[]
[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,"Licensee Compulsory Contribution/Direct Benefits",null,null,null,null,null,null,null,null,null,null,"ABB",null,null,null,null,null,null,null,null,null,null,"Siemens",null,null,null,null,null,null,null,null,null,null,"GE",null,null,null,null,null,null,null,null,null,null,"Vodafone",null,null,null,null,null,null,null,null,null,null,"PNDC",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","ABB","Siemens","GE","Vodafone","PNDC","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,"Description","Task","Project Workstream"]
[null,"Solution design and approval","Details of the system design and architecture for protection and control on a substation with local intelligence","Workstreams 1 and 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R7:Y7)","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},0,0,0,0,0,0,0,0,0,null,{"$f":"$Y7*G7","v":0},0,0,0,0,0,0,0,0,0]
[null,"Trial design and site selection","Description of the trial design and site selection criteria process","Workstreams 2 and 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R8:Y8)","v":0},null,{"$f":"$R8*G8","v":0},{"$f":"$R8*H8","v":0},{"$f":"$R8*I8","v":0},{"$f":"$R8*J8","v":0},{"$f":"$R8*K8","v":0},{"$f":"$R8*L8","v":0},{"$f":"$R8*M8","v":0},{"$f":"$R8*N8","v":0},{"$f":"$R8*O8","v":0},{"$f":"$R8*P8","v":0},null,{"$f":"$S8*G8","v":0},{"$f":"$S8*H8","v":0},{"$f":"$S8*I8","v":0},{"$f":"$S8*J8","v":0},{"$f":"$S8*K8","v":0},{"$f":"$S8*L8","v":0},{"$f":"$S8*M8","v":0},{"$f":"$S8*N8","v":0},{"$f":"$S8*O8","v":0},{"$f":"$S8*P8","v":0},null,{"$f":"$T8*G8","v":0},{"$f":"$T8*H8","v":0},{"$f":"$T8*I8","v":0},{"$f":"$T8*J8","v":0},{"$f":"$T8*K8","v":0},{"$f":"$T8*L8","v":0},{"$f":"$T8*M8","v":0},{"$f":"$T8*N8","v":0},{"$f":"$T8*O8","v":0},{"$f":"$T8*P8","v":0},null,{"$f":"$U8*G8","v":0},{"$f":"$U8*H8","v":0},{"$f":"$U8*I8","v":0},{"$f":"$U8*J8","v":0},{"$f":"$U8*K8","v":0},{"$f":"$U8*L8","v":0},{"$f":"$U8*M8","v":0},{"$f":"$U8*N8","v":0},{"$f":"$U8*O8","v":0},{"$f":"$U8*P8","v":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,"Equipment specification and purchase","Description of the trial design and site selection criteria process","Workstream 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Solution development and approval","Initial learning from off-network PNDC trial, and learning from functionality development, virtualisation","Workstreams 1 and 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Initial validation and off-network installation and testing","Initial learning from off-network PNDC trial, and learning from functionality development, virtualisation","Workstream 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Trial site preparation: design, installation and commissioning","Review of site installation and learning from mid trial passive network demonstration","Workstream 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Site acceptance testing and solution reiterations","Review of site installation and learning from mid trial passive network demonstration","Workstream 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Transition from PNDC to live network","Review of site installation and learning from mid trial passive network demonstration","Workstream 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Plan, launch, publicise and select OIC participants","Learning from the innovation competition process","Workstream 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Incubate, test and deploy as network trial","Learning from the innovation competition process","Workstream 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Launch academic research and review deliverables","Learning from academic insights and the governance required to prepare for the future world of distributed & autonomous network operation","Workstream 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Data gathering and engineering support for network trials","Presentation of findings from project trials and innovation competition trial ","Workstream 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Communications, training, dissemination and events","Presentation of findings from project trials and innovation competition trial ","Workstream 6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,{"$f":"$U19*P19","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,"Project management and contingency","Presentation of findings from project trials and innovation competition trial ","PM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,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,{"$f":"SUM(R21:Y21)","v":0},null,{"$f":"$R21*G21","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$S21*G21","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$T21*G21","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$U21*G21","v":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":"$X21*G21","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$Y21*G21","v":0},0,0,0,0,0,0,0,0,0]
[null,"Total",null,null,null,null,{"$f":"SUM(G7:G21)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(G22:P22)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AB7:AB21)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AM7:AM21)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AX7:AX21)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(BI7:BI21)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(BT7:BT21)","v":0},{"$f":"SUM(BU7:BU21)","v":0},{"$f":"SUM(BV7:BV21)","v":0},{"$f":"SUM(BW7:BW21)","v":0},{"$f":"SUM(BX7:BX21)","v":0},{"$f":"SUM(BY7:BY21)","v":0},{"$f":"SUM(BZ7:BZ21)","v":0},{"$f":"SUM(CA7:CA21)","v":0},{"$f":"SUM(CB7:CB21)","v":0},{"$f":"SUM(CC7:CC21)","v":0},null,{"$f":"SUM(CE7:CE21)","v":0},{"$f":"SUM(CF7:CF21)","v":0},{"$f":"SUM(CG7:CG21)","v":0},{"$f":"SUM(CH7:CH21)","v":0},{"$f":"SUM(CI7:CI21)","v":0},{"$f":"SUM(CJ7:CJ21)","v":0},{"$f":"SUM(CK7:CK21)","v":0},{"$f":"SUM(CL7:CL21)","v":0},{"$f":"SUM(CM7:CM21)","v":0},{"$f":"SUM(CN7:CN21)","v":0},null,{"$f":"SUM(CP7:CP21)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(DA7:DA21)","v":0},0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Totals"]

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

{"sheet":"Whole project","index":11,"n_rows":268,"n_cols":114,"rows_kept":268,"cut":false,"hidden":false,"merged":[[3,104,3,113],[3,93,3,102],[3,6,3,15],[3,17,3,25],[3,27,3,36],[3,38,3,47],[3,49,3,58],[3,60,3,69],[3,71,3,80],[3,82,3,91]]}
[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,"Licensee Compulsory Contribution/Direct Benefits",null,null,null,null,null,null,null,null,null,null,"ABB",null,null,null,null,null,null,null,null,null,null,"Siemens",null,null,null,null,null,null,null,null,null,null,"GE",null,null,null,null,null,null,null,null,null,null,"Vodafone",null,null,null,null,null,null,null,null,null,null,"PNDC",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","ABB","Siemens","GE","Vodafone","PNDC","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,"Description","Task","Project Workstream","Cost breakdown","Comments"]
[null,"Solution design and approval","Details of the system design and architecture for protection and control on a substation with local intelligence","Workstreams 1 and 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R7:Y7)","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,{"$f":"$W7*P7","v":0},null,{"$f":"$X7*G7","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$Y7*G7","v":0},0,0,0,0,0,0,0,0,0]
[null,"Trial design and site selection","Description of the trial design and site selection criteria process","Workstreams 2 and 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R8:Y8)","v":0},null,{"$f":"$R8*G8","v":0},{"$f":"$R8*H8","v":0},{"$f":"$R8*I8","v":0},{"$f":"$R8*J8","v":0},{"$f":"$R8*K8","v":0},{"$f":"$R8*L8","v":0},{"$f":"$R8*M8","v":0},{"$f":"$R8*N8","v":0},{"$f":"$R8*O8","v":0},{"$f":"$R8*P8","v":0},null,{"$f":"$S8*G8","v":0},{"$f":"$S8*H8","v":0},{"$f":"$S8*I8","v":0},{"$f":"$S8*J8","v":0},{"$f":"$S8*K8","v":0},{"$f":"$S8*L8","v":0},{"$f":"$S8*M8","v":0},{"$f":"$S8*N8","v":0},{"$f":"$S8*O8","v":0},{"$f":"$S8*P8","v":0},null,{"$f":"$T8*G8","v":0},{"$f":"$T8*H8","v":0},{"$f":"$T8*I8","v":0},{"$f":"$T8*J8","v":0},{"$f":"$T8*K8","v":0},{"$f":"$T8*L8","v":0},{"$f":"$T8*M8","v":0},{"$f":"$T8*N8","v":0},{"$f":"$T8*O8","v":0},{"$f":"$T8*P8","v":0},null,{"$f":"$U8*G8","v":0},{"$f":"$U8*H8","v":0},{"$f":"$U8*I8","v":0},{"$f":"$U8*J8","v":0},{"$f":"$U8*K8","v":0},{"$f":"$U8*L8","v":0},{"$f":"$U8*M8","v":0},{"$f":"$U8*N8","v":0},{"$f":"$U8*O8","v":0},{"$f":"$U8*P8","v":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,"Equipment specification and purchase","Description of the trial design and site selection criteria process","Workstream 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Solution development and approval","Initial learning from off-network PNDC trial, and learning from functionality development, virtualisation","Workstreams 1 and 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Initial validation and off-network installation and testing","Initial learning from off-network PNDC trial, and learning from functionality development, virtualisation","Workstream 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Trial site preparation: design, installation and commissioning","Review of site installation and learning from mid trial passive network demonstration","Workstream 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Site acceptance testing and solution reiterations","Review of site installation and learning from mid trial passive network demonstration","Workstream 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Transition from PNDC to live network","Review of site installation and learning from mid trial passive network demonstration","Workstream 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Plan, launch, publicise and select OIC participants","Learning from the innovation competition process","Workstream 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Incubate, test and deploy as network trial","Learning from the innovation competition process","Workstream 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Launch academic research and review deliverables","Learning from academic insights and the governance required to prepare for the future world of distributed & autonomous network operation","Workstream 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Data gathering and engineering support for network trials","Presentation of findings from project trials and innovation competition trial ","Workstream 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Communications, training, dissemination and events","Presentation of findings from project trials and innovation competition trial ","Workstream 6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"Project management and contingency","Presentation of findings from project trials and innovation competition trial ","PM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,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,{"$f":"SUM(R21:Y21)","v":0},null,{"$f":"$R21*G21","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$S21*G21","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$T21*G21","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$U21*G21","v":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":"$X21*G21","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$Y21*G21","v":0},0,0,0,0,0,0,0,0,0]
[null,"Total",null,null,null,null,{"$f":"SUM(G7:G21)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(G22:P22)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AB7:AB21)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AM7:AM21)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AX7:AX21)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(BI7:BI21)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(BT7:BT21)","v":0},{"$f":"SUM(BU7:BU21)","v":0},{"$f":"SUM(BV7:BV21)","v":0},{"$f":"SUM(BW7:BW21)","v":0},{"$f":"SUM(BX7:BX21)","v":0},{"$f":"SUM(BY7:BY21)","v":0},{"$f":"SUM(BZ7:BZ21)","v":0},{"$f":"SUM(CA7:CA21)","v":0},{"$f":"SUM(CB7:CB21)","v":0},{"$f":"SUM(CC7:CC21)","v":0},null,{"$f":"SUM(CE7:CE21)","v":0},{"$f":"SUM(CF7:CF21)","v":0},{"$f":"SUM(CG7:CG21)","v":0},{"$f":"SUM(CH7:CH21)","v":0},{"$f":"SUM(CI7:CI21)","v":0},{"$f":"SUM(CJ7:CJ21)","v":0},{"$f":"SUM(CK7:CK21)","v":0},{"$f":"SUM(CL7:CL21)","v":0},{"$f":"SUM(CM7:CM21)","v":0},{"$f":"SUM(CN7:CN21)","v":0},null,{"$f":"SUM(CP7:CP21)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(DA7:DA21)","v":0},0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Totals"]

{"sheet":"Project Direction","index":12,"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,1929.9880147306467]
[null,null,"Equipment"]
[null,null,null,2023.0162308167769]
[null,null,"Contractors"]
[null,null,null,4384.2980710111087]
[null,null,"IT"]
[null,null,null,6358.9174625843416]
[null,null,"IPR Costs"]
[null,null,null,0]
[null,null,"Travel & Expenses"]
[null,null,null,134.46188791780884]
[null,null,"Payments to users"]
[null,null,null,0]
[null,null,"Contingency"]
[null,null,null,1369.4980945626421]
[null,null,"Decommissioning"]
[null,null,null,0]
[null,null,"Other"]
[null,null,null,73.039898376674273,"Check that = to Total Outstanding Funding Required + Licensee Compulsory Contribution + Licensee Extra Contribution"]
[null,null,"Total",{"$f":"SUM(D6:D24)","v":16273.219659999997},{"$f":"IF(D25=('NIC Funding Request'!J79+'NIC Funding Request'!J37+'NIC Funding Request'!J66),\"OK\", \"ERROR\")","v":"OK"}]