{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Front Sheet","NIC Funding Request","Project Cost Summary","Direct Benefits","2021-2022","2022-2023","2023-2024","2024-2025","2025-2026","2026-2027","2028-2029","2027-2028","Whole project","Project Direction"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":2,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Front Sheet","index":0,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[[16,3,16,4],[14,3,14,9]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Electricity Network Innovation Competition Full Submission "]
[null,null,null,null,null," Spreadsheet "]
[]
[null,null,null,null,null,"(2021 version 1.0)"]
[null,null,null,null,null,"Appendix A"]
[]
[]
[]
[null,null,"Licensee Name:","Western Power Distribution"]
[]
[null,null,"Submission Date:","2021-08-13"]
[]
[]
[]
[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":89,"n_cols":12,"rows_kept":89,"cut":false,"hidden":false,"merged":[]}
["NIC Funding Request"]
[null," ","2021/22","2022/23","2023/24","2024/25","2025/26","2026/27","2027/28","Total"]
["Total Project Cost","From Project Cost Summary sheet"]
[null,"Labour",{"$f":"'Project Cost Summary'!C18","v":0},{"$f":"'Project Cost Summary'!C35","v":2026.3400000000001},{"$f":"'Project Cost Summary'!C52","v":1747.655},{"$f":"'Project Cost Summary'!C69","v":1194.655},{"$f":"'Project Cost Summary'!C86","v":756.11},{"$f":"'Project Cost Summary'!C103","v":0},{"$f":"'Project Cost Summary'!C116","v":0},{"$f":"SUM(C4:I4)","v":5724.7599999999993}]
[null,"Equipment",{"$f":"'Project Cost Summary'!D18","v":0},{"$f":"'Project Cost Summary'!D35","v":7000},{"$f":"'Project Cost Summary'!D52","v":0},{"$f":"'Project Cost Summary'!D69","v":0},{"$f":"'Project Cost Summary'!D86","v":0},{"$f":"'Project Cost Summary'!D103","v":0},{"$f":"'Project Cost Summary'!D116","v":0},7000]
[null,"Contractors",{"$f":"'Project Cost Summary'!E18","v":0},{"$f":"'Project Cost Summary'!E35","v":100},{"$f":"'Project Cost Summary'!E52","v":136},{"$f":"'Project Cost Summary'!E69","v":136},{"$f":"'Project Cost Summary'!E86","v":146},{"$f":"'Project Cost Summary'!F103","v":0},{"$f":"'Project Cost Summary'!CE116","v":0},518]
[null,"IT",{"$f":"'Project Cost Summary'!F18","v":0},{"$f":"'Project Cost Summary'!F35","v":250},{"$f":"'Project Cost Summary'!F52","v":0},{"$f":"'Project Cost Summary'!F69","v":0},{"$f":"'Project Cost Summary'!F86","v":0},{"$f":"'Project Cost Summary'!G103","v":0},{"$f":"'Project Cost Summary'!F116","v":0},250]
[null,"IPR Costs",{"$f":"'Project Cost Summary'!G18","v":0},{"$f":"'Project Cost Summary'!G35","v":0},{"$f":"'Project Cost Summary'!G52","v":0},{"$f":"'Project Cost Summary'!G69","v":0},{"$f":"'Project Cost Summary'!G86","v":0},{"$f":"'Project Cost Summary'!H103","v":0},{"$f":"'Project Cost Summary'!G116","v":0},0]
[null,"Travel & Expenses",{"$f":"'Project Cost Summary'!H18","v":0},{"$f":"'Project Cost Summary'!H35","v":20},{"$f":"'Project Cost Summary'!H52","v":0},{"$f":"'Project Cost Summary'!H69","v":0},{"$f":"'Project Cost Summary'!H86","v":0},{"$f":"'Project Cost Summary'!I103","v":0},{"$f":"'Project Cost Summary'!H116","v":0},20]
["Payments to users & Contingency",null,{"$f":"'Project Cost Summary'!I18+'Project Cost Summary'!J18","v":0},{"$f":"'Project Cost Summary'!I35+'Project Cost Summary'!J35","v":709.73},{"$f":"'Project Cost Summary'!I52+'Project Cost Summary'!J52","v":702.87},{"$f":"'Project Cost Summary'!I69+'Project Cost Summary'!J69","v":290},{"$f":"'Project Cost Summary'!I86+'Project Cost Summary'!J86","v":20},{"$f":"'Project Cost Summary'!J103+'Project Cost Summary'!I103","v":0},{"$f":"'Project Cost Summary'!J116+'Project Cost Summary'!I116","v":0},1722.6]
[null,"Decommissioning",{"$f":"'Project Cost Summary'!K18","v":0},{"$f":"'Project Cost Summary'!K35","v":0},{"$f":"'Project Cost Summary'!K52","v":0},{"$f":"'Project Cost Summary'!K69","v":0},{"$f":"'Project Cost Summary'!K86","v":0},{"$f":"'Project Cost Summary'!K103","v":0},{"$f":"'Project Cost Summary'!K116","v":0},0]
[null,"Other",{"$f":"'Project Cost Summary'!L18","v":0},{"$f":"'Project Cost Summary'!L35","v":60},{"$f":"'Project Cost Summary'!L52","v":45},{"$f":"'Project Cost Summary'!L69","v":15},{"$f":"'Project Cost Summary'!L86","v":20},{"$f":"'Project Cost Summary'!L103","v":0},{"$f":"'Project Cost Summary'!L116","v":0},140]
[null,"Total",{"$f":"SUM(C4:C12)","v":0},10166.07,2631.5250000000001,1635.655,942.11,{"$f":"SUM(H4:H12)","v":0},0,15375.36]
[]
["External funding","Any funding that will be received from Project Partners and/or External Funders - from Project Cost Summary sheet"]
[null,"Labour",{"$f":"'Project Cost Summary'!C26","v":0},{"$f":"'Project Cost Summary'!C43","v":595.90260595958421},{"$f":"'Project Cost Summary'!C60","v":81.393865439731869},{"$f":"'Project Cost Summary'!C77","v":53.938611507196235},{"$f":"'Project Cost Summary'!C94","v":0},{"$f":"'Project Cost Summary'!D94","v":0},{"$f":"'Project Cost Summary'!E94","v":0},{"$f":"SUM(C16:I16)","v":731.23508290651228}]
[null,"Equipment",{"$f":"'Project Cost Summary'!D26","v":0},{"$f":"'Project Cost Summary'!D43","v":6543.803418803418},{"$f":"'Project Cost Summary'!D60","v":0},{"$f":"'Project Cost Summary'!D77","v":0},{"$f":"'Project Cost Summary'!D94","v":0},{"$f":"'Project Cost Summary'!E94","v":0},{"$f":"'Project Cost Summary'!F94","v":0},6543.803418803418]
[null,"Contractors",{"$f":"'Project Cost Summary'!E26","v":0},{"$f":"'Project Cost Summary'!E43","v":17.233725370488482},{"$f":"'Project Cost Summary'!E60","v":8.9762309775624249},{"$f":"'Project Cost Summary'!E77","v":7.9877271660346283},{"$f":"'Project Cost Summary'!E94","v":0},{"$f":"'Project Cost Summary'!F94","v":0},{"$f":"'Project Cost Summary'!G94","v":0},34.19768351408554]
[null,"IT",{"$f":"'Project Cost Summary'!F26","v":0},{"$f":"'Project Cost Summary'!F43","v":28.028715734260114},{"$f":"'Project Cost Summary'!F60","v":0},{"$f":"'Project Cost Summary'!F77","v":0},{"$f":"'Project Cost Summary'!F94","v":0},{"$f":"'Project Cost Summary'!G94","v":0},{"$f":"'Project Cost Summary'!H94","v":0},28.028715734260114]
[null,"IPR Costs",{"$f":"'Project Cost Summary'!G26","v":0},{"$f":"'Project Cost Summary'!G43","v":0},{"$f":"'Project Cost Summary'!G60","v":0},{"$f":"'Project Cost Summary'!G77","v":0},{"$f":"'Project Cost Summary'!G94","v":0},{"$f":"'Project Cost Summary'!H94","v":0},{"$f":"'Project Cost Summary'!I94","v":0},0]
[null,"Travel & Expenses",{"$f":"'Project Cost Summary'!H26","v":0},{"$f":"'Project Cost Summary'!H43","v":2.2422972587408094},{"$f":"'Project Cost Summary'!H60","v":0},{"$f":"'Project Cost Summary'!H77","v":0},{"$f":"'Project Cost Summary'!H94","v":0},{"$f":"'Project Cost Summary'!I94","v":0},{"$f":"'Project Cost Summary'!J94","v":0},2.2422972587408094]
["Payments to users & Contingency",null,{"$f":"'Project Cost Summary'!I26+'Project Cost Summary'!J26","v":0},{"$f":"'Project Cost Summary'!I43+'Project Cost Summary'!J43","v":218.53035743632955},{"$f":"'Project Cost Summary'!I60+'Project Cost Summary'!J60","v":16.739084737083189},{"$f":"'Project Cost Summary'!I77+'Project Cost Summary'!J77","v":5.8984842224863181},{"$f":"'Project Cost Summary'!I94+'Project Cost Summary'!K94","v":0},{"$f":"'Project Cost Summary'!J94+'Project Cost Summary'!L94","v":0},{"$f":"'Project Cost Summary'!K94+'Project Cost Summary'!M94","v":0},241.16792639589909]
[null,"Decommissioning",{"$f":"'Project Cost Summary'!K26","v":0},{"$f":"'Project Cost Summary'!K43","v":0},{"$f":"'Project Cost Summary'!K60","v":0},{"$f":"'Project Cost Summary'!K77","v":0},{"$f":"'Project Cost Summary'!K94","v":0},{"$f":"'Project Cost Summary'!L94","v":0},{"$f":"'Project Cost Summary'!M94","v":0},0]
[null,"Other",{"$f":"'Project Cost Summary'!L26","v":0},{"$f":"'Project Cost Summary'!L43","v":23.384554354469653},{"$f":"'Project Cost Summary'!L60","v":3.9715945718103089},{"$f":"'Project Cost Summary'!L77","v":1.2187264608033561},{"$f":"'Project Cost Summary'!L94","v":0},{"$f":"'Project Cost Summary'!M94","v":0},{"$f":"'Project Cost Summary'!N94","v":0},28.574875387083321]
[null,"Total",{"$f":"SUM(C16:C24)","v":0},7429.1256749172908,111.0807757261878,69.043549356520543,0,{"$f":"SUM(H16:H24)","v":0},0,7609.25]
[]
["Licensee extra contribution","Any funding from the Licensee which is in excess of the Licensee Compulsory Contribution - from Project Cost Summary sheet"]
[null,"Labour",{"$f":"'Project Cost Summary'!C27","v":0},{"$f":"'Project Cost Summary'!C44","v":0},{"$f":"'Project Cost Summary'!C61","v":0},{"$f":"'Project Cost Summary'!C78","v":0},{"$f":"'Project Cost Summary'!C95","v":0},{"$f":"'Project Cost Summary'!D95","v":0},{"$f":"'Project Cost Summary'!E95","v":0},{"$f":"SUM(C28:I28)","v":0}]
[null,"Equipment",{"$f":"'Project Cost Summary'!D27","v":0},{"$f":"'Project Cost Summary'!D44","v":0},{"$f":"'Project Cost Summary'!D61","v":0},{"$f":"'Project Cost Summary'!D78","v":0},{"$f":"'Project Cost Summary'!D95","v":0},{"$f":"'Project Cost Summary'!E95","v":0},{"$f":"'Project Cost Summary'!F95","v":0},0]
[null,"Contractors",{"$f":"'Project Cost Summary'!E27","v":0},{"$f":"'Project Cost Summary'!E44","v":0},{"$f":"'Project Cost Summary'!E61","v":0},{"$f":"'Project Cost Summary'!E78","v":0},{"$f":"'Project Cost Summary'!E95","v":0},{"$f":"'Project Cost Summary'!F95","v":0},{"$f":"'Project Cost Summary'!G95","v":0},0]
[null,"IT",{"$f":"'Project Cost Summary'!F27","v":0},{"$f":"'Project Cost Summary'!F44","v":0},{"$f":"'Project Cost Summary'!F61","v":0},{"$f":"'Project Cost Summary'!F78","v":0},{"$f":"'Project Cost Summary'!E95","v":0},{"$f":"'Project Cost Summary'!F95","v":0},{"$f":"'Project Cost Summary'!G95","v":0},0]
[null,"IPR Costs",{"$f":"'Project Cost Summary'!G27","v":0},{"$f":"'Project Cost Summary'!G44","v":0},{"$f":"'Project Cost Summary'!G61","v":0},{"$f":"'Project Cost Summary'!G78","v":0},{"$f":"'Project Cost Summary'!F95","v":0},{"$f":"'Project Cost Summary'!G95","v":0},{"$f":"'Project Cost Summary'!H95","v":0},0]
[null,"Travel & Expenses",{"$f":"'Project Cost Summary'!H27","v":0},{"$f":"'Project Cost Summary'!H44","v":0},{"$f":"'Project Cost Summary'!H61","v":0},{"$f":"'Project Cost Summary'!H78","v":0},{"$f":"'Project Cost Summary'!G95","v":0},{"$f":"'Project Cost Summary'!H95","v":0},{"$f":"'Project Cost Summary'!I95","v":0},0]
["Payments to users & Contingency",null,{"$f":"'Project Cost Summary'!I27+'Project Cost Summary'!J27","v":0},{"$f":"'Project Cost Summary'!I44+'Project Cost Summary'!J44","v":0},{"$f":"'Project Cost Summary'!I61+'Project Cost Summary'!J61","v":0},{"$f":"'Project Cost Summary'!I78","v":0},{"$f":"'Project Cost Summary'!I95+'Project Cost Summary'!J95","v":0},{"$f":"'Project Cost Summary'!J95+'Project Cost Summary'!K95","v":0},{"$f":"'Project Cost Summary'!K95+'Project Cost Summary'!L95","v":0},0]
[null,"Decommissioning",{"$f":"'Project Cost Summary'!K27","v":0},{"$f":"'Project Cost Summary'!K44","v":0},{"$f":"'Project Cost Summary'!K61","v":0},{"$f":"'Project Cost Summary'!K78","v":0},{"$f":"'Project Cost Summary'!K95","v":0},{"$f":"'Project Cost Summary'!L95","v":0},{"$f":"'Project Cost Summary'!M95","v":0},0]
[null,"Other",{"$f":"'Project Cost Summary'!L27","v":0},{"$f":"'Project Cost Summary'!L44","v":0},{"$f":"'Project Cost Summary'!L61","v":0},{"$f":"'Project Cost Summary'!L78","v":0},{"$f":"'Project Cost Summary'!L95","v":0},{"$f":"'Project Cost Summary'!M95","v":0},{"$f":"'Project Cost Summary'!N95","v":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",{"$f":"C4-C16-C28","v":0},1430.4373940404159,1666.2611345602681,1140.7163884928038,756.11,{"$f":"H4-H16-H28","v":0},0,{"$f":"J4-J16-J28","v":4993.5249170934867}]
[null,"Equipment",{"$f":"C5-C17-C29","v":0},456.19658119658197,0,0,0,{"$f":"H5-H17-H29","v":0},0,456.19658119658197]
[null,"Contractors",{"$f":"C6-C18-C30","v":0},82.766274629511514,127.02376902243758,128.01227283396537,146,{"$f":"H6-H18-H30","v":0},0,483.80231648591445]
[null,"IT",{"$f":"C7-C19-C31","v":0},221.97128426573988,0,0,0,{"$f":"H7-H19-H31","v":0},0,221.97128426573988]
[null,"IPR Costs",{"$f":"C8-C20-C32","v":0},0,0,0,0,{"$f":"H8-H20-H32","v":0},0,0]
[null,"Travel & Expenses",{"$f":"C9-C21-C33","v":0},17.757702741259191,0,0,0,{"$f":"H9-H21-H33","v":0},0,17.757702741259191]
["Payments to users & Contingency",null,{"$f":"C10-C22-C34","v":0},491.19964256367047,686.1309152629168,284.10151577751367,20,{"$f":"H10-H22-H34","v":0},0,1481.4320736041009]
[null,"Decommissioning",{"$f":"C11-C23-C35","v":0},0,0,0,0,{"$f":"H11-H23-H35","v":0},0,0,"Check Total = to Initial Net Funding request "]
[null,"Other",{"$f":"C12-C24-C36","v":0},36.615445645530343,41.028405428189693,13.781273539196643,20,{"$f":"H12-H24-H36","v":0},0,111.42512461291668,"in Project Cost Summary"]
[null,"Total",{"$f":"C13-C25-C37","v":0},2736.9443250827089,2520.4442242738123,1566.6114506434794,942.11,{"$f":"H13-H25-H37","v":0},0,{"$f":"J13-J25-J37","v":7766.1100000000006},{"$f":"IF(J49='Project Cost Summary'!M11,\"OK\",\"ERROR\")","v":"OK"}]
[]
["Direct Benefits","from Direct Benefits sheet"]
[null,"Total",{"$f":"'Direct Benefits'!C11","v":0},{"$f":"'Direct Benefits'!D11","v":0},{"$f":"'Direct Benefits'!E11","v":0},{"$f":"'Direct Benefits'!F11","v":0},{"$f":"'Direct Benefits'!G11","v":0},{"$f":"'Direct Benefits'!H11","v":0},{"$f":"'Direct Benefits'!I11","v":0},{"$f":"SUM(C52:I52)","v":0}]
[]
[]
[]
["Licensee Compulsory Contribution / Direct Benefits",null,"from Project Cost Summary sheet"]
[null,"Labour",{"$f":"'Project Cost Summary'!C29","v":0},{"$f":"'Project Cost Summary'!C46","v":333.78646442279711},{"$f":"'Project Cost Summary'!C63","v":88.274232096354154},{"$f":"'Project Cost Summary'!C80","v":60.656658066887076},{"$f":"'Project Cost Summary'!C97","v":38.19119313043727},{"$f":"'Project Cost Summary'!D103","v":0},{"$f":"'Project Cost Summary'!D116","v":0},{"$f":"SUM(C57:I57)","v":520.9085477164756}]
[null,"Equipment",{"$f":"'Project Cost Summary'!D29","v":0},{"$f":"'Project Cost Summary'!D46","v":0},{"$f":"'Project Cost Summary'!D63","v":0},{"$f":"'Project Cost Summary'!D80","v":0},{"$f":"'Project Cost Summary'!D97","v":0},{"$f":"'Project Cost Summary'!E103","v":0},{"$f":"'Project Cost Summary'!E116","v":0},0]
[null,"Contractors",{"$f":"'Project Cost Summary'!E29","v":0},{"$f":"'Project Cost Summary'!E46","v":19.538643620286191},{"$f":"'Project Cost Summary'!E63","v":6.8693738553113546},{"$f":"'Project Cost Summary'!E80","v":9.3041127607870742},{"$f":"'Project Cost Summary'!E97","v":7.3744748740842496},{"$f":"'Project Cost Summary'!F103","v":0},{"$f":"'Project Cost Summary'!F116","v":0},43.086605110468874]
[null,"IT",{"$f":"'Project Cost Summary'!F29","v":0},{"$f":"'Project Cost Summary'!F46","v":48.846609050715479},{"$f":"'Project Cost Summary'!F63","v":0},{"$f":"'Project Cost Summary'!F80","v":0},{"$f":"'Project Cost Summary'!F97","v":0},{"$f":"'Project Cost Summary'!G103","v":0},{"$f":"'Project Cost Summary'!G116","v":0},48.846609050715479]
[null,"IPR Costs",{"$f":"'Project Cost Summary'!G29","v":0},{"$f":"'Project Cost Summary'!G46","v":0},{"$f":"'Project Cost Summary'!G63","v":0},{"$f":"'Project Cost Summary'!G80","v":0},{"$f":"'Project Cost Summary'!G97","v":0},{"$f":"'Project Cost Summary'!H103","v":0},{"$f":"'Project Cost Summary'!H116","v":0},0]
[null,"Travel & Expenses",{"$f":"'Project Cost Summary'!H29","v":0},{"$f":"'Project Cost Summary'!H46","v":3.9077287240572383},{"$f":"'Project Cost Summary'!H63","v":0},{"$f":"'Project Cost Summary'!H80","v":0},{"$f":"'Project Cost Summary'!H97","v":0},{"$f":"'Project Cost Summary'!I103","v":0},{"$f":"'Project Cost Summary'!I97","v":0},3.9077287240572383]
["Payments to users & Contingency",null,{"$f":"'Project Cost Summary'!I29+'Project Cost Summary'!J29","v":0},{"$f":"'Project Cost Summary'!I46+'Project Cost Summary'!J46","v":105.45592121177067},{"$f":"'Project Cost Summary'!I63+'Project Cost Summary'!J63","v":35.502035306490377},{"$f":"'Project Cost Summary'!I80+'Project Cost Summary'!J80","v":11.630140950983844},{"$f":"'Project Cost Summary'!I97+'Project Cost Summary'!J97","v":1.0102020375457876},{"$f":"'Project Cost Summary'!J103+'Project Cost Summary'!I103","v":0},{"$f":"'Project Cost Summary'!K116+'Project Cost Summary'!J116","v":0},153.59829950679068]
[null,"Decommissioning",{"$f":"'Project Cost Summary'!K29","v":0},{"$f":"'Project Cost Summary'!K46","v":0},{"$f":"'Project Cost Summary'!K63","v":0},{"$f":"'Project Cost Summary'!K80","v":0},{"$f":"'Project Cost Summary'!K97","v":0},{"$f":"'Project Cost Summary'!K103","v":0},{"$f":"'Project Cost Summary'!K116","v":0},0,"of Total Initial Net Funding Required"]
[null,"Other",{"$f":"'Project Cost Summary'!L29","v":0},{"$f":"'Project Cost Summary'!L46","v":11.723186172171715},{"$f":"'Project Cost Summary'!L63","v":2.2729545844780219},{"$f":"'Project Cost Summary'!L80","v":1.0261889074397508},{"$f":"'Project Cost Summary'!L97","v":1.0102020375457876},{"$f":"'Project Cost Summary'!L103","v":0},{"$f":"'Project Cost Summary'!L116","v":0},16.032531701635275,{"$f":"IF(J66>=J49*0.1,\"OK\",\"ERROR\")","v":"OK"}]
[null,"Total",{"$f":"SUM(C57:C65)","v":0},523.25855320179835,132.91859584263389,82.617100686097743,47.586072079613096,{"$f":"SUM(H57:H65)","v":0},0,786.38032181014307,"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",{"$f":"C40-C57","v":0},1096.6509296176189,1577.986902463914,1080.0597304259168,{"$f":"G40-G57","v":717.91880686956279},0,0,{"$f":"SUM(C70:I70)","v":4472.6163693770122}]
[null,"Equipment",0,456.19658119658197,0,0,0,0,0,456.19658119658197]
[null,"Contractors",0,63.22763100922532,120.15439516712622,118.70816007317829,138.62552512591574,0,0,440.71571137544561]
[null,"IT",0,173.12467521502441,0,0,0,0,0,173.12467521502441]
[null,"IPR Costs",0,0,0,0,0,0,0,0]
[null,"Travel & Expenses",0,13.849974017201953,0,0,0,0,0,13.849974017201953]
["Payments to users & Contingency",null,0,385.74372135189981,650.62887995642643,272.47137482652982,18.989797962454212,0,0,1327.8337740973104]
[null,"Decommissioning",0,0,0,0,0,0,0,0,"Check that Total is =to "]
[null,"Other",0,24.892259473358628,38.755450843711671,12.755084631756892,18.989797962454212,0,0,95.392592911281412,"Total Outstanding Funding required"]
[null,"Total",0,2213.6857718809106,2387.5256284311786,1483.9943499573817,894.52392792038688,0,0,6979.7296781898585,{"$f":"IF(J79='Project Cost Summary'!M13, \"OK\",\"ERROR\")","v":"OK"}]
[]
["balance",6914.0421785778535,0,{"$f":"B81-C79-D79","v":4700.3564066969429},{"$f":"D81-E79+D82","v":2347.6739740215889},{"$f":"E81-F79+E82","v":884.82371520636286},{"$f":"F81-G79+F82","v":-2.7196463401626403E-3},{"$f":"G81-H79+G82","v":2.6517433403399053},{"$f":"H81-I79+H82","v":2.6596904114219044},{"$f":"G81-G79+G82","v":-891.87218458004702},{"$f":"B81","v":6914.0421785778535}]
["interest",null,0,{"$f":"((B81+D81)/2)*$D86","v":34.843195755824389},{"$f":"((D81+E81)/2)*$D86","v":21.144091142155595},{"$f":"((E81+F81)/2)*$D86","v":9.6974930676838564},{"$f":"((F81+G81)/2)*$D86","v":2.654462986680068},{"$f":"((G81+H81)/2)*$D86","v":7.9470710819992286E-3},1.593430125528543E-2,{"$f":"((G81+J81)/2)*$D86","v":-2.6756247126791619},{"$f":"SUM(D82:J82)","v":65.687499612002028}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K81+K82","v":6979.7296781898558},{"$f":"J79-K83","v":0}]
[]
[null,"Bank of England interest rate",null,1E-3,null,null,"NIC FUNDING REQUEST   £",null,{"$f":"K81","v":6914.0421785778535}]
[null,"interest rate used in calculation",null,{"$f":"D85+0.5%","v":6.0000000000000001E-3}]
[null,"RPI adjustment","2021/22","2022/23","2023/24","2024/25","2025/26","2026/27","2027/28"]
[null,"Annual inflation ",2.7799999999999998E-2,2.1299999999999999E-2,3.0800000000000001E-2,3.0800000000000001E-2,3.0800000000000001E-2,3.0800000000000001E-2,3.0800000000000001E-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."]

{"sheet":"Project Cost Summary","index":2,"n_rows":137,"n_cols":15,"rows_kept":137,"cut":false,"hidden":false,"merged":[[125,2,125,12],[126,2,126,12],[100,2,100,12],[99,2,99,12],[112,2,112,12],[113,2,113,12],[83,2,83,12],[49,2,49,12],[66,2,66,12],[48,2,48,12],[1,2,1,12],[15,2,15,12],[14,2,14,12],[65,2,65,12],[32,2,32,12],[31,2,31,12],[2,2,2,12],[82,2,82,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",{"$f":"SUM(C18+C35+C52+C69+C86+C103+C116+C129)","v":5724.7599999999993},{"$f":"SUM(D18+D35+D52+D69+D86+D103+D116+D129)","v":7000},{"$f":"SUM(E18+E35+E52+E69+E86+E103+E116+E129)","v":518},250,0,20,225,1497.6,0,140,{"$f":"SUM(C5:L5)","v":15375.359999999999}]
[null,"Project Partner 1",{"$f":"SUM(C19+C40+C57+C74+C91+C104+C117+C130)","v":6.1529278263645066},0,0,0,0,0,0,0.28207217363549208,0,0,{"$f":"SUM(C6:L6)","v":6.4349999999999987}]
[null,"Project Partner 2",{"$f":"SUM(C20+C41+C58+C75+C92+C105+C118+C131)","v":212.33974358974356},4674.1452991452988,0,0,0,0,40.064102564102562,73.450854700854691,0,0,4999.9999999999991]
[null,"Project Partner 3",{"$f":"SUM(C23+C42+C59+C76+C93+C106+C119+C132)","v":84.935897435897431},1869.6581196581196,0,0,0,0,16.025641025641026,29.380341880341881,0,0,2000]
[null,"External Funding",{"$f":"SUM(C26+C43+C60+C77+C94+C107+C120+C133)","v":731.23508290651228},6543.803418803418,34.19768351408554,28.028715734260114,0,2.2422972587408094,59.38555168487057,181.7823747110285,0,28.574875387083321,{"$f":"SUM(C9:L9)","v":7609.25}]
[null,"Licensee extra contribution",{"$f":"SUM(C27+C44+C61+C78+C95+C108+C121+C134)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Initial Net Funding Required",{"$f":"SUM(C28+C45+C62+C79+C96+C109+C122+C135)","v":4993.5249170934876},456.19658119658197,483.80231648591445,221.97128426573988,0,17.757702741259191,165.61444831512944,1315.8176252889716,0,111.42512461291669,7766.1100000000006,null,"Check Total Initial Net Funding Required matches that on the Second Tier Funding Request tab"]
[null,"Licensee Compulsory Contribution / Direct Benefits",{"$f":"SUM(C29+C46+C63+C80+C97+C110+C123+C136)","v":520.9085477164756},0,43.086605110468874,48.846609050715479,0,3.9077287240572383,7.7452430912793826,145.8530564155113,0,16.032531701635275,786.3803218101433,null,{"$f":"IF(ABS(M11-'NIC Funding Request'!J49)<0.01,\"OK\",\"ERROR\")","v":"OK"}]
[null,"Outstanding Funding Required",{"$f":"SUM(C30+C47+C64+C81+C98+C111+C124+C137)","v":4472.6163693770122},456.19658119658112,440.71571137544561,173.12467521502438,0,13.849974017201951,157.86920522385003,1169.9645688734602,0,95.392592911281412,{"$f":"SUM(C13:L13)","v":6979.7296781898567}]
[]
[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",{"$f":"'2021-2022'!G9","v":0},{"$f":"'2021-2022'!H9","v":0},{"$f":"'2021-2022'!I9","v":0},{"$f":"'2021-2022'!J9","v":0},{"$f":"'2021-2022'!K9","v":0},{"$f":"'2021-2022'!L9","v":0},{"$f":"'2021-2022'!M9","v":0},{"$f":"'2021-2022'!N9","v":0},{"$f":"'2021-2022'!O9","v":0},{"$f":"'2021-2022'!P9","v":0},{"$f":"SUM(C18:L18)","v":0}]
[null,"Guidehouse",{"$f":"'2021-2022'!AK9","v":0},{"$f":"'2021-2022'!AL9","v":0},{"$f":"'2021-2022'!AM9","v":0},{"$f":"'2021-2022'!AN9","v":0},{"$f":"'2021-2022'!AO9","v":0},{"$f":"'2021-2022'!AP9","v":0},{"$f":"'2021-2022'!AQ9","v":0},{"$f":"'2021-2022'!AR9","v":0},{"$f":"'2021-2022'!AS9","v":0},{"$f":"'2021-2022'!AT9","v":0},0]
[null,"Octopus Energy",{"$f":"'2021-2022'!AV9","v":0},{"$f":"'2021-2022'!AW9","v":0},{"$f":"'2021-2022'!AX9","v":0},{"$f":"'2021-2022'!AY9","v":0},{"$f":"'2021-2022'!AZ9","v":0},{"$f":"'2021-2022'!BA9","v":0},{"$f":"'2021-2022'!BB9","v":0},{"$f":"'2021-2022'!BC9","v":0},{"$f":"'2021-2022'!BD9","v":0},{"$f":"'2021-2022'!BE9","v":0},0]
[null,"Passiv"]
[null,"SERO"]
[null,"SP Energy Networks",{"$f":"'2021-2022'!BG9","v":0},{"$f":"'2021-2022'!BH9","v":0},{"$f":"'2021-2022'!BI9","v":0},{"$f":"'2021-2022'!BJ9","v":0},{"$f":"'2021-2022'!BK9","v":0},{"$f":"'2021-2022'!BL9","v":0},{"$f":"'2021-2022'!BM9","v":0},{"$f":"'2021-2022'!BN9","v":0},{"$f":"'2021-2022'!BO9","v":0},{"$f":"'2021-2022'!BP9","v":0},0]
[null,"Welsh Government"]
[null,"WMCA"]
[null,"External Funding",{"$f":"SUM(C19:C23)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(C26:L26)","v":0}]
[null,"Licensee extra contribution",{"$f":"'2021-2022'!BR9","v":0},{"$f":"'2021-2022'!BS9","v":0},{"$f":"'2021-2022'!BT9","v":0},{"$f":"'2021-2022'!BU9","v":0},{"$f":"'2021-2022'!BV9","v":0},{"$f":"'2021-2022'!BW9","v":0},{"$f":"'2021-2022'!BX9","v":0},{"$f":"'2021-2022'!BY9","v":0},{"$f":"'2021-2022'!BZ9","v":0},{"$f":"'2021-2022'!CA9","v":0},0]
[null,"Initial Net Funding Required",{"$f":"C18-C26-C27","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Licensee Compulsory Contribution / Direct Benefits",{"$f":"'2021-2022'!Z9","v":0},{"$f":"'2021-2022'!AA9","v":0},{"$f":"'2021-2022'!AB9","v":0},{"$f":"'2021-2022'!AC9","v":0},{"$f":"'2021-2022'!AD9","v":0},{"$f":"'2021-2022'!AE9","v":0},{"$f":"'2021-2022'!AF9","v":0},{"$f":"'2021-2022'!AG9","v":0},{"$f":"'2021-2022'!AH9","v":0},{"$f":"'2021-2022'!AI9","v":0},0]
[null,"Outstanding Funding Required",{"$f":"'2021-2022'!CC9","v":0},{"$f":"'2021-2022'!CD9","v":0},{"$f":"'2021-2022'!CE9","v":0},{"$f":"'2021-2022'!CF9","v":0},{"$f":"'2021-2022'!CG9","v":0},{"$f":"'2021-2022'!CH9","v":0},{"$f":"'2021-2022'!CI9","v":0},{"$f":"'2021-2022'!CJ9","v":0},{"$f":"'2021-2022'!CK9","v":0},{"$f":"'2021-2022'!CL9","v":0},0]
[]
[null,null,"2022/23"]
[null,null,"Cost type"]
[null,null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other","Total"]
[null,"Total Project Cost",{"$f":"'2022-2023'!G22","v":2026.3400000000001},{"$f":"'2022-2023'!H22","v":7000},{"$f":"'2022-2023'!I22","v":100},{"$f":"'2022-2023'!J22","v":250},{"$f":"'2022-2023'!K22","v":0},{"$f":"'2022-2023'!L22","v":20},{"$f":"'2022-2023'!M22","v":75},{"$f":"'2022-2023'!N22","v":634.73},{"$f":"'2022-2023'!O22","v":0},{"$f":"'2022-2023'!P22","v":60},{"$f":"SUM(C35:L35)","v":10166.07}]
[null,"Guidehouse",{"$f":"'2022-2023'!AO22","v":142.0899487410835},{"$f":"'2022-2023'!AP22","v":0},{"$f":"'2022-2023'!AQ22","v":16.210690998617661},{"$f":"'2022-2023'!AR22","v":0},{"$f":"'2022-2023'!AS22","v":0},{"$f":"'2022-2023'!AT22","v":0},{"$f":"'2022-2023'!AU22","v":0},{"$f":"'2022-2023'!AV22","v":0},{"$f":"'2022-2023'!AW22","v":0},{"$f":"'2022-2023'!AX22","v":19.452829198341192},{"$f":"SUM(C36:L36)","v":177.75346893804235}]
[null,"Octopus Energy",{"$f":"'2022-2023'!AZ22","v":74.630405557407869},{"$f":"'2022-2023'!BA22","v":0},{"$f":"'2022-2023'!BB22","v":0},{"$f":"'2022-2023'!BC22","v":13.062711448741496},{"$f":"'2022-2023'!BD22","v":0},{"$f":"'2022-2023'!BE22","v":1.0450169158993197},{"$f":"'2022-2023'!BF22","v":0.7837626869244898},{"$f":"'2022-2023'!BG22","v":27.417586313992501},{"$f":"'2022-2023'!BH22","v":0},{"$f":"'2022-2023'!BI22","v":1.5675253738489796},118.50700829681466]
[null,"Passiv",{"$f":"'2022-2023'!BK22","v":21.38980725394951},{"$f":"'2022-2023'!BL22","v":0},{"$f":"'2022-2023'!BM22","v":1.0230343718708215},{"$f":"'2022-2023'!BN22","v":5.115171859354108},{"$f":"'2022-2023'!BO22","v":0},{"$f":"'2022-2023'!BP22","v":0.40921374874832861},{"$f":"'2022-2023'!BQ22","v":0},{"$f":"'2022-2023'!BR22","v":10.449886894911694},{"$f":"'2022-2023'!BS22","v":0},{"$f":"'2022-2023'!BT22","v":0},38.387114128834462]
[null,"SERO",{"$f":"'2022-2023'!BV22","v":56.266378685063508},{"$f":"'2022-2023'!BW22","v":0},{"$f":"'2022-2023'!BX22","v":0},{"$f":"'2022-2023'!BY22","v":9.8508324261645122},{"$f":"'2022-2023'!BZ22","v":0},{"$f":"'2022-2023'!CA22","v":0.78806659409316093},{"$f":"'2022-2023'!CB22","v":0},{"$f":"'2022-2023'!CC22","v":20.676109195925218},{"$f":"'2022-2023'!CD22","v":0},{"$f":"'2022-2023'!CE22","v":2.3641997822794827},89.945586683525889]
[null,"SP Energy Networks",{"$f":"'2022-2023'!CG22","v":4.2504246964388148},{"$f":"'2022-2023'!CH22","v":0},{"$f":"'2022-2023'!CI22","v":0},{"$f":"'2022-2023'!CJ22","v":0},{"$f":"'2022-2023'!CK22","v":0},{"$f":"'2022-2023'!CL22","v":0},{"$f":"'2022-2023'!CM22","v":0},{"$f":"'2022-2023'!CN22","v":0.28207217363549208},{"$f":"'2022-2023'!CO22","v":0},{"$f":"'2022-2023'!CP22","v":0},4.5324968700743069]
[null,"Welsh Government",{"$f":"'2022-2023'!CR22","v":212.33974358974356},{"$f":"'2022-2023'!CS22","v":4674.1452991452988},{"$f":"'2022-2023'!CT22","v":0},{"$f":"'2022-2023'!CU22","v":0},{"$f":"'2022-2023'!CV22","v":0},{"$f":"'2022-2023'!CW22","v":0},{"$f":"'2022-2023'!CX22","v":40.064102564102562},{"$f":"'2022-2023'!CY22","v":73.450854700854691},{"$f":"'2022-2023'!CZ22","v":0},{"$f":"'2022-2023'!DA22","v":0},4999.9999999999991]
[null,"WMCA",{"$f":"'2022-2023'!DC22","v":84.935897435897431},{"$f":"'2022-2023'!DD22","v":1869.6581196581196},{"$f":"'2022-2023'!DE22","v":0},{"$f":"'2022-2023'!DF22","v":0},{"$f":"'2022-2023'!DG22","v":0},{"$f":"'2022-2023'!DH22","v":0},{"$f":"'2022-2023'!DI22","v":16.025641025641026},{"$f":"'2022-2023'!DJ22","v":29.380341880341881},{"$f":"'2022-2023'!DK22","v":0},{"$f":"'2022-2023'!DL22","v":0},2000]
[null,"External Funding",{"$f":"SUM(C36:C42)","v":595.90260595958421},{"$f":"SUM(D36:D42)","v":6543.803418803418},17.233725370488482,28.028715734260114,0,2.2422972587408094,56.873506276668081,161.65685115966147,0,23.384554354469653,7429.1256749172908]
[null,"Licensee extra contribution",{"$f":"'2022-2023'!DN22","v":0},{"$f":"'2022-2023'!DO22","v":0},{"$f":"'2022-2023'!DP22","v":0},{"$f":"'2022-2023'!DQ22","v":0},{"$f":"'2022-2023'!DR22","v":0},{"$f":"'2022-2023'!DS22","v":0},{"$f":"'2022-2023'!DT22","v":0},{"$f":"'2022-2023'!DU22","v":0},{"$f":"'2022-2023'!DV22","v":0},{"$f":"'2022-2023'!DW22","v":0},0]
[null,"Initial Net Funding Required",{"$f":"C35-C43-C44","v":1430.4373940404159},{"$f":"D35-D43-D44","v":456.19658119658197},82.766274629511514,{"$f":"F35-F43-F44","v":221.97128426573988},0,17.757702741259191,18.126493723331919,473.07314884033855,0,36.615445645530343,2736.9443250827089]
[null,"Licensee Compulsory Contribution / Direct Benefits",{"$f":"'2022-2023'!AD22","v":333.78646442279711},{"$f":"'2022-2023'!AE22","v":0},{"$f":"'2022-2023'!AF22","v":19.538643620286191},{"$f":"'2022-2023'!AG22","v":48.846609050715479},{"$f":"'2022-2023'!AH22","v":0},{"$f":"'2022-2023'!AI22","v":3.9077287240572383},{"$f":"'2022-2023'!AJ22","v":2.9307965430429288},{"$f":"'2022-2023'!AK22","v":102.52512466872774},{"$f":"'2022-2023'!AL22","v":0},{"$f":"'2022-2023'!AM22","v":11.723186172171715},523.25855320179835]
[null,"Outstanding Funding Required",{"$f":"'2022-2023'!DY22","v":1096.6509296176187},{"$f":"'2022-2023'!DZ22","v":456.19658119658112},{"$f":"'2022-2023'!EA22","v":63.22763100922532},{"$f":"'2022-2023'!EB22","v":173.12467521502438},{"$f":"'2022-2023'!EC22","v":0},{"$f":"'2022-2023'!ED22","v":13.849974017201951},{"$f":"'2022-2023'!EE22","v":15.195697180288992},{"$f":"'2022-2023'!EF22","v":370.54802417161073},{"$f":"'2022-2023'!EG22","v":0},{"$f":"'2022-2023'!EH22","v":24.892259473358628},2213.6857718809097]
[]
[null,null,"2023/24"]
[null,null,"Cost type"]
[null,null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other","Total"]
[null,"Total Project Cost",{"$f":"'2023-2024'!G22","v":1747.655},{"$f":"'2023-2024'!H22","v":0},{"$f":"'2023-2024'!I22","v":136},{"$f":"'2023-2024'!J22","v":0},{"$f":"'2023-2024'!K22","v":0},{"$f":"'2023-2024'!L22","v":0},{"$f":"'2023-2024'!M22","v":75},{"$f":"'2023-2024'!N22","v":627.87},{"$f":"'2023-2024'!O22","v":0},{"$f":"'2023-2024'!P22","v":45},{"$f":"SUM(C52:L52)","v":2631.5250000000001}]
[null,"Guidehouse",{"$f":"'2023-2024'!AO22","v":36.376287057402187},{"$f":"'2023-2024'!AP22","v":0},{"$f":"'2023-2024'!AQ22","v":6.3258310784047485},{"$f":"'2023-2024'!AR22","v":0},{"$f":"'2023-2024'!AS22","v":0},{"$f":"'2023-2024'!AT22","v":0},{"$f":"'2023-2024'!AU22","v":0},{"$f":"'2023-2024'!AV22","v":0},{"$f":"'2023-2024'!AW22","v":0},{"$f":"'2023-2024'!AX22","v":3.3100278898629494},{"$f":"SUM(C53:L53)","v":46.012146025669885}]
[null,"Octopus Energy",{"$f":"'2023-2024'!AZ22","v":19.231258929642436},{"$f":"'2023-2024'!BA22","v":0},{"$f":"'2023-2024'!BB22","v":1.3395845819878529},{"$f":"'2023-2024'!BC22","v":0},{"$f":"'2023-2024'!BD22","v":0},{"$f":"'2023-2024'!BE22","v":0},{"$f":"'2023-2024'!BF22","v":0.3044510413608757},{"$f":"'2023-2024'!BG22","v":9.4962339147675277},{"$f":"'2023-2024'!BH22","v":0},{"$f":"'2023-2024'!BI22","v":0.3044510413608757},30.675979509119568]
[null,"Passiv",{"$f":"'2023-2024'!BK22","v":9.4591016624077504},{"$f":"'2023-2024'!BL22","v":0},{"$f":"'2023-2024'!BM22","v":0.4775454891346948},{"$f":"'2023-2024'!BN22","v":0},{"$f":"'2023-2024'!BO22","v":0},{"$f":"'2023-2024'!BP22","v":0},{"$f":"'2023-2024'!BQ22","v":0},{"$f":"'2023-2024'!BR22","v":0},{"$f":"'2023-2024'!BS22","v":0},{"$f":"'2023-2024'!BT22","v":0},9.936647151542445]
[null,"SERO",{"$f":"'2023-2024'!BV22","v":15.1539641311937},{"$f":"'2023-2024'!BW22","v":0},{"$f":"'2023-2024'!BX22","v":0.83326982803512806},{"$f":"'2023-2024'!BY22","v":0},{"$f":"'2023-2024'!BZ22","v":0},{"$f":"'2023-2024'!CA22","v":0},{"$f":"'2023-2024'!CB22","v":0.17855782029324174},{"$f":"'2023-2024'!CC22","v":6.7598419606615456},{"$f":"'2023-2024'!CD22","v":0},{"$f":"'2023-2024'!CE22","v":0.35711564058648348},23.282749380770099]
[null,"SP Energy Networks",{"$f":"'2023-2024'!CG22","v":1.1732536590857914},{"$f":"'2023-2024'!CH22","v":0},{"$f":"'2023-2024'!CI22","v":0},{"$f":"'2023-2024'!CJ22","v":0},{"$f":"'2023-2024'!CK22","v":0},{"$f":"'2023-2024'!CL22","v":0},{"$f":"'2023-2024'!CM22","v":0},{"$f":"'2023-2024'!CN22","v":0},{"$f":"'2023-2024'!CO22","v":0},{"$f":"'2023-2024'!CP22","v":0},{"$f":"SUM(C57:L57)","v":1.1732536590857914}]
[null,"Welsh Government",{"$f":"'2023-2024'!CR22","v":0},{"$f":"'2023-2024'!CS22","v":0},{"$f":"'2023-2024'!CT22","v":0},{"$f":"'2023-2024'!CU22","v":0},{"$f":"'2023-2024'!CV22","v":0},{"$f":"'2023-2024'!CW22","v":0},{"$f":"'2023-2024'!CX22","v":0},{"$f":"'2023-2024'!CY22","v":0},{"$f":"'2023-2024'!CZ22","v":0},{"$f":"'2023-2024'!DA22","v":0},0]
[null,"WMCA",{"$f":"'2023-2024'!DC22","v":0},{"$f":"'2023-2024'!DD22","v":0},{"$f":"'2023-2024'!DE22","v":0},{"$f":"'2023-2024'!DF22","v":0},{"$f":"'2023-2024'!DG22","v":0},{"$f":"'2023-2024'!DH22","v":0},{"$f":"'2023-2024'!DI22","v":0},{"$f":"'2023-2024'!DJ22","v":0},{"$f":"'2023-2024'!DK22","v":0},{"$f":"'2023-2024'!DL22","v":0},{"$f":"SUM(C59:L59)","v":0}]
[null,"External Funding",{"$f":"SUM(C53:C59)","v":81.393865439731869},{"$f":"SUM(D53:D59)","v":0},8.9762309775624249,0,0,0,0.48300886165411744,16.256075875429072,0,3.9715945718103089,{"$f":"SUM(C60:L60)","v":111.0807757261878}]
[null,"Licensee extra contribution",{"$f":"'2023-2024'!DN22","v":0},{"$f":"'2023-2024'!DO22","v":0},{"$f":"'2023-2024'!DP22","v":0},{"$f":"'2023-2024'!DQ22","v":0},{"$f":"'2023-2024'!DR22","v":0},{"$f":"'2023-2024'!DS22","v":0},{"$f":"'2023-2024'!DT22","v":0},{"$f":"'2023-2024'!DU22","v":0},{"$f":"'2023-2024'!DV22","v":0},{"$f":"'2023-2024'!DW22","v":0},0]
[null,"Initial Net Funding Required",{"$f":"C52-C60-C61","v":1666.2611345602681},0,127.02376902243758,0,0,0,74.516991138345887,611.61392412457099,0,41.028405428189693,2520.4442242738123]
[null,"Licensee Compulsory Contribution / Direct Benefits",{"$f":"'2023-2024'!AD22","v":88.274232096354154},{"$f":"'2023-2024'!AE22","v":0},{"$f":"'2023-2024'!AF22","v":6.8693738553113546},{"$f":"'2023-2024'!AG22","v":0},{"$f":"'2023-2024'!AH22","v":0},{"$f":"'2023-2024'!AI22","v":0},{"$f":"'2023-2024'!AJ22","v":3.7882576407967035},{"$f":"'2023-2024'!AK22","v":31.713777665693677},{"$f":"'2023-2024'!AL22","v":0},{"$f":"'2023-2024'!AM22","v":2.2729545844780219},132.91859584263389]
[null,"Outstanding Funding Required",{"$f":"'2023-2024'!DY22","v":1577.9869024639142},{"$f":"'2023-2024'!DZ22","v":0},{"$f":"'2023-2024'!EA22","v":120.15439516712621},{"$f":"'2023-2024'!EB22","v":0},{"$f":"'2023-2024'!EC22","v":0},{"$f":"'2023-2024'!ED22","v":0},{"$f":"'2023-2024'!EE22","v":70.728733497549186},{"$f":"'2023-2024'!EF22","v":579.90014645887732},{"$f":"'2023-2024'!EG22","v":0},{"$f":"'2023-2024'!EH22","v":38.755450843711671},{"$f":"SUM(C64:L64)","v":2387.5256284311786}]
[]
[null,null,"2024/25"]
[null,null,"Cost type"]
[null,null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other","Total"]
[null,"Total Project Cost",{"$f":"'2024-2025'!G22","v":1194.655},{"$f":"'2024-2025'!H22","v":0},{"$f":"'2024-2025'!I22","v":136},{"$f":"'2024-2025'!J22","v":0},{"$f":"'2024-2025'!K22","v":0},{"$f":"'2024-2025'!L22","v":0},{"$f":"'2024-2025'!M22","v":75},{"$f":"'2024-2025'!N22","v":215},{"$f":"'2024-2025'!O22","v":0},{"$f":"'2024-2025'!P22","v":15},{"$f":"SUM(C69:L69)","v":1635.655}]
[null,"Guidehouse",{"$f":"'2024-2025'!AO22","v":21.878972385381065},{"$f":"'2024-2025'!AP22","v":0},{"$f":"'2024-2025'!AQ22","v":2.6151832035202438},{"$f":"'2024-2025'!AR22","v":0},{"$f":"'2024-2025'!AS22","v":0},{"$f":"'2024-2025'!AT22","v":0},{"$f":"'2024-2025'!AU22","v":1.8245464210606355},{"$f":"'2024-2025'!AV22","v":1.8245464210606355},{"$f":"'2024-2025'!AW22","v":0},{"$f":"'2024-2025'!AX22","v":0.45613660526515887},28.599385036287735]
[null,"Octopus Energy",{"$f":"'2024-2025'!AZ22","v":15.309140678392646},{"$f":"'2024-2025'!BA22","v":0},{"$f":"'2024-2025'!BB22","v":3.1997717856226693},{"$f":"'2024-2025'!BC22","v":0},{"$f":"'2024-2025'!BD22","v":0},{"$f":"'2024-2025'!BE22","v":0},{"$f":"'2024-2025'!BF22","v":0},{"$f":"'2024-2025'!BG22","v":0},{"$f":"'2024-2025'!BH22","v":0},{"$f":"'2024-2025'!BI22","v":0.55809973005046554},19.067012194065782]
[null,"Passiv",{"$f":"'2024-2025'!BK22","v":5.8575103471534771},{"$f":"'2024-2025'!BL22","v":0},{"$f":"'2024-2025'!BM22","v":0.31872837246961555},{"$f":"'2024-2025'!BN22","v":0},{"$f":"'2024-2025'!BO22","v":0},{"$f":"'2024-2025'!BP22","v":0},{"$f":"'2024-2025'!BQ22","v":0},{"$f":"'2024-2025'!BR22","v":0},{"$f":"'2024-2025'!BS22","v":0},{"$f":"'2024-2025'!BT22","v":0},6.1762387196230923]
[null,"SERO",{"$f":"'2024-2025'!BV22","v":10.16373862542914},{"$f":"'2024-2025'!BW22","v":0},{"$f":"'2024-2025'!BX22","v":1.8540438044220995},{"$f":"'2024-2025'!BY22","v":0},{"$f":"'2024-2025'!BZ22","v":0},{"$f":"'2024-2025'!CA22","v":0},{"$f":"'2024-2025'!CB22","v":0.20449012548773154},{"$f":"'2024-2025'!CC22","v":2.0449012548773156},{"$f":"'2024-2025'!CD22","v":0},{"$f":"'2024-2025'!CE22","v":0.20449012548773154},14.471663935704019]
[null,"SP Energy Networks",{"$f":"'2024-2025'!CG22","v":0.72924947083990088},{"$f":"'2024-2025'!CH22","v":0},{"$f":"'2024-2025'!CI22","v":0},{"$f":"'2024-2025'!CJ22","v":0},{"$f":"'2024-2025'!CK22","v":0},{"$f":"'2024-2025'!CL22","v":0},{"$f":"'2024-2025'!CM22","v":0},{"$f":"'2024-2025'!CN22","v":0},{"$f":"'2024-2025'!CO22","v":0},{"$f":"'2024-2025'!CP22","v":0},0.72924947083990088]
[null,"Welsh Government",{"$f":"'2024-2025'!CR22","v":0},{"$f":"'2024-2025'!CS22","v":0},{"$f":"'2024-2025'!CT22","v":0},{"$f":"'2024-2025'!CU22","v":0},{"$f":"'2024-2025'!CV22","v":0},{"$f":"'2024-2025'!CW22","v":0},{"$f":"'2024-2025'!CX22","v":0},{"$f":"'2024-2025'!CY22","v":0},{"$f":"'2024-2025'!CZ22","v":0},{"$f":"'2024-2025'!DA22","v":0},0]
[null,"WMCA",{"$f":"'2024-2025'!DC22","v":0},{"$f":"'2024-2025'!DD22","v":0},{"$f":"'2024-2025'!DE22","v":0},{"$f":"'2024-2025'!DF22","v":0},{"$f":"'2024-2025'!DG22","v":0},{"$f":"'2024-2025'!DH22","v":0},{"$f":"'2024-2025'!DI22","v":0},{"$f":"'2024-2025'!DJ22","v":0},{"$f":"'2024-2025'!DK22","v":0},{"$f":"'2024-2025'!DL22","v":0},0]
[null,"External Funding",{"$f":"SUM(C70:C76)","v":53.938611507196235},{"$f":"SUM(D70:D76)","v":0},7.9877271660346283,0,0,0,2.0290365465483671,3.869447675937951,0,1.2187264608033561,69.043549356520543]
[null,"Licensee extra contribution",{"$f":"'2024-2025'!DN22","v":0},{"$f":"'2024-2025'!DO22","v":0},{"$f":"'2024-2025'!DP22","v":0},{"$f":"'2024-2025'!DQ22","v":0},{"$f":"'2024-2025'!DR22","v":0},{"$f":"'2024-2025'!DS22","v":0},{"$f":"'2024-2025'!DT22","v":0},{"$f":"'2024-2025'!DU22","v":0},{"$f":"'2024-2025'!DV22","v":0},{"$f":"'2024-2025'!DW22","v":0},0]
[null,"Initial Net Funding Required",{"$f":"C69-C77-C78","v":1140.7163884928038},{"$f":"D69-D77-D78","v":0},128.01227283396537,0,0,0,72.970963453451631,211.13055232406205,0,13.781273539196643,1566.6114506434797]
[null,"Licensee Compulsory Contribution",{"$f":"'2024-2025'!AD22","v":60.656658066887076},{"$f":"'2024-2025'!AE22","v":0},{"$f":"'2024-2025'!AF22","v":9.3041127607870742},{"$f":"'2024-2025'!AG22","v":0},{"$f":"'2024-2025'!AH22","v":0},{"$f":"'2024-2025'!AI22","v":0},{"$f":"'2024-2025'!AJ22","v":1.0261889074397508},{"$f":"'2024-2025'!AK22","v":10.603952043544092},{"$f":"'2024-2025'!AL22","v":0},{"$f":"'2024-2025'!AM22","v":1.0261889074397508},82.617100686097743]
[null,"Outstanding Funding Required",{"$f":"'2024-2025'!DY22","v":1080.0597304259168},{"$f":"'2024-2025'!DZ22","v":0},{"$f":"'2024-2025'!EA22","v":118.70816007317831},{"$f":"'2024-2025'!EB22","v":0},{"$f":"'2024-2025'!EC22","v":0},{"$f":"'2024-2025'!ED22","v":0},{"$f":"'2024-2025'!EE22","v":71.944774546011871},{"$f":"'2024-2025'!EF22","v":200.52660028051795},{"$f":"'2024-2025'!EG22","v":0},{"$f":"'2024-2025'!EH22","v":12.755084631756894},1483.9943499573817]
[]
[null,null,"2025/26"]
[null,null,"Cost type"]
[null,null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other","Total"]
[null,"Total Project Cost",{"$f":"'2025-2026'!G22","v":756.11},{"$f":"'2025-2026'!H22","v":0},{"$f":"'2025-2026'!I22","v":146},{"$f":"'2025-2026'!J22","v":0},{"$f":"'2025-2026'!K22","v":0},{"$f":"'2025-2026'!L22","v":0},{"$f":"'2025-2026'!M22","v":0},{"$f":"'2025-2026'!N22","v":20},{"$f":"'2025-2026'!O22","v":0},{"$f":"'2025-2026'!P22","v":20},{"$f":"SUM(C86:L86)","v":942.11}]
[null,"Guidehouse",{"$f":"'2025-2026'!AO22","v":0},{"$f":"'2025-2026'!AP22","v":0},{"$f":"'2025-2026'!AQ22","v":0},{"$f":"'2025-2026'!AR22","v":0},{"$f":"'2025-2026'!AS22","v":0},{"$f":"'2025-2026'!AT22","v":0},{"$f":"'2025-2026'!AU22","v":0},{"$f":"'2025-2026'!AV22","v":0},{"$f":"'2025-2026'!AW22","v":0},{"$f":"'2025-2026'!AX22","v":0}]
[null,"Octopus Energy",{"$f":"'2025-2026'!AZ22","v":0},{"$f":"'2025-2026'!BA22","v":0},{"$f":"'2025-2026'!BB22","v":0},{"$f":"'2025-2026'!BC22","v":0},{"$f":"'2025-2026'!BD22","v":0},{"$f":"'2025-2026'!BE22","v":0},{"$f":"'2025-2026'!BF22","v":0},{"$f":"'2025-2026'!BG22","v":0},{"$f":"'2025-2026'!BH22","v":0},{"$f":"'2025-2026'!BI22","v":0}]
[null,"Passiv",{"$f":"'2025-2026'!BK22","v":0},{"$f":"'2025-2026'!BL22","v":0},{"$f":"'2025-2026'!BM22","v":0},{"$f":"'2025-2026'!BN22","v":0},{"$f":"'2025-2026'!BO22","v":0},{"$f":"'2025-2026'!BP22","v":0},{"$f":"'2025-2026'!BQ22","v":0},{"$f":"'2025-2026'!BR22","v":0},{"$f":"'2025-2026'!BS22","v":0},{"$f":"'2025-2026'!BT22","v":0}]
[null,"SERO",{"$f":"'2025-2026'!BV22","v":0},{"$f":"'2025-2026'!BW22","v":0},{"$f":"'2025-2026'!BX22","v":0},{"$f":"'2025-2026'!BY22","v":0},{"$f":"'2025-2026'!BZ22","v":0},{"$f":"'2025-2026'!CA22","v":0},{"$f":"'2025-2026'!CB22","v":0},{"$f":"'2025-2026'!CC22","v":0},{"$f":"'2025-2026'!CD22","v":0},{"$f":"'2025-2026'!CE22","v":0}]
[null,"SP Energy Networks",{"$f":"'2025-2026'!CG22","v":0},{"$f":"'2025-2026'!CH22","v":0},{"$f":"'2025-2026'!CI22","v":0},{"$f":"'2025-2026'!CJ22","v":0},{"$f":"'2025-2026'!CK22","v":0},{"$f":"'2025-2026'!CL22","v":0},{"$f":"'2025-2026'!CM22","v":0},{"$f":"'2025-2026'!CN22","v":0},{"$f":"'2025-2026'!CO22","v":0},{"$f":"'2025-2026'!CP22","v":0},0]
[null,"Welsh Government",{"$f":"'2025-2026'!CR22","v":0},{"$f":"'2025-2026'!CS22","v":0},{"$f":"'2025-2026'!CT22","v":0},{"$f":"'2025-2026'!CU22","v":0},{"$f":"'2025-2026'!CV22","v":0},{"$f":"'2025-2026'!CW22","v":0},{"$f":"'2025-2026'!CX22","v":0},{"$f":"'2025-2026'!CY22","v":0},{"$f":"'2025-2026'!CZ22","v":0},{"$f":"'2025-2026'!DA22","v":0},0]
[null,"WMCA",{"$f":"'2025-2026'!DC22","v":0},{"$f":"'2025-2026'!DD22","v":0},{"$f":"'2025-2026'!DE22","v":0},{"$f":"'2025-2026'!DF22","v":0},{"$f":"'2025-2026'!DG22","v":0},{"$f":"'2025-2026'!DH22","v":0},{"$f":"'2025-2026'!DI22","v":0},{"$f":"'2025-2026'!DJ22","v":0},{"$f":"'2025-2026'!DK22","v":0},{"$f":"'2025-2026'!DL22","v":0},0]
[null,"External Funding",{"$f":"SUM(C87:C93)","v":0},{"$f":"SUM(D87:D93)","v":0},0,0,0,0,0,0,0,0,0]
[null,"Licensee extra contribution",{"$f":"'2025-2026'!DN22","v":0},{"$f":"'2025-2026'!DO22","v":0},{"$f":"'2025-2026'!DP22","v":0},{"$f":"'2025-2026'!DQ22","v":0},{"$f":"'2025-2026'!DR22","v":0},{"$f":"'2025-2026'!DS22","v":0},{"$f":"'2025-2026'!DT22","v":0},{"$f":"'2025-2026'!DU22","v":0},{"$f":"'2025-2026'!DV22","v":0},{"$f":"'2025-2026'!DW22","v":0},0]
[null,"Initial Net Funding Required",{"$f":"C86-C94-C95","v":756.11},{"$f":"D86-D94-D95","v":0},146,0,0,0,0,20,0,20,942.11]
[null,"Licensee Compulsory Contribution",{"$f":"'2025-2026'!AD22","v":38.19119313043727},{"$f":"'2025-2026'!AE22","v":0},{"$f":"'2025-2026'!AF22","v":7.3744748740842496},{"$f":"'2025-2026'!AG22","v":0},{"$f":"'2025-2026'!AH22","v":0},{"$f":"'2025-2026'!AI22","v":0},{"$f":"'2025-2026'!AJ22","v":0},{"$f":"'2025-2026'!AK22","v":1.0102020375457876},{"$f":"'2025-2026'!AL22","v":0},{"$f":"'2025-2026'!AM22","v":1.0102020375457876},47.586072079613096]
[null,"Outstanding Funding Required",{"$f":"'2025-2026'!DY22","v":717.91880686956279},{"$f":"'2025-2026'!DZ22","v":0},{"$f":"'2025-2026'!EA22","v":138.62552512591574},{"$f":"'2025-2026'!EB22","v":0},{"$f":"'2025-2026'!EC22","v":0},{"$f":"'2025-2026'!ED22","v":0},{"$f":"'2025-2026'!EE22","v":0},{"$f":"'2025-2026'!EF22","v":18.989797962454212},{"$f":"'2025-2026'!EG22","v":0},{"$f":"'2025-2026'!EH22","v":18.989797962454212},894.52392792038688]
[]
[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",{"$f":"'2026-2027'!G9","v":0},{"$f":"'2026-2027'!H9","v":0},{"$f":"'2026-2027'!I9","v":0},{"$f":"'2026-2027'!J9","v":0},{"$f":"'2026-2027'!K9","v":0},{"$f":"'2026-2027'!L9","v":0},{"$f":"'2026-2027'!M9","v":0},{"$f":"'2026-2027'!N9","v":0},{"$f":"'2026-2027'!O9","v":0},{"$f":"'2026-2027'!P9","v":0},{"$f":"SUM(C103:L103)","v":0}]
[null,"Project Partner 1",{"$f":"'2026-2027'!AK9","v":0},{"$f":"'2026-2027'!AL9","v":0},{"$f":"'2026-2027'!AM9","v":0},{"$f":"'2026-2027'!AN9","v":0},{"$f":"'2026-2027'!AO9","v":0},{"$f":"'2026-2027'!AP9","v":0},{"$f":"'2026-2027'!AQ9","v":0},{"$f":"'2026-2027'!AR9","v":0},{"$f":"'2026-2027'!AS9","v":0},{"$f":"'2026-2027'!AT9","v":0},0]
[null,"Project Partner 2",{"$f":"'2026-2027'!AV9","v":0},{"$f":"'2026-2027'!AW9","v":0},{"$f":"'2026-2027'!AX9","v":0},{"$f":"'2026-2027'!AY9","v":0},{"$f":"'2026-2027'!AZ9","v":0},{"$f":"'2026-2027'!BA9","v":0},{"$f":"'2026-2027'!BB9","v":0},{"$f":"'2026-2027'!BC9","v":0},{"$f":"'2026-2027'!BD9","v":0},{"$f":"'2026-2027'!BE9","v":0},0]
[null,"Project Partner 3",{"$f":"'2026-2027'!BG9","v":0},{"$f":"'2026-2027'!BH35","v":0},{"$f":"'2026-2027'!BI35","v":0},{"$f":"'2026-2027'!BJ35","v":0},{"$f":"'2026-2027'!BK35","v":0},{"$f":"'2026-2027'!BL35","v":0},{"$f":"'2026-2027'!BM35","v":0},{"$f":"'2026-2027'!BN35","v":0},{"$f":"'2026-2027'!BO35","v":0},{"$f":"'2026-2027'!BP35","v":0},0]
[null,"External Funding",{"$f":"SUM(C104:C106)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(L104:L106)","v":0},0]
[null,"Licensee extra contribution",{"$f":"'2026-2027'!BR9","v":0},{"$f":"'2026-2027'!BS9","v":0},{"$f":"'2026-2027'!BT9","v":0},{"$f":"'2026-2027'!BU9","v":0},{"$f":"'2026-2027'!BV9","v":0},{"$f":"'2026-2027'!BW9","v":0},{"$f":"'2026-2027'!BX9","v":0},{"$f":"'2026-2027'!BY9","v":0},{"$f":"'2026-2027'!BZ9","v":0},{"$f":"'2026-2027'!CA9","v":0},0]
[null,"Initial Net Funding Required",{"$f":"C103-C107-C108","v":0},{"$f":"D103-D107-D108","v":0},0,0,0,0,0,0,0,0,0]
[null,"Licensee Compulsory Contribution",{"$f":"'2026-2027'!Z9","v":0},{"$f":"'2026-2027'!AA9","v":0},{"$f":"'2026-2027'!AB9","v":0},{"$f":"'2026-2027'!AC9","v":0},{"$f":"'2026-2027'!AD9","v":0},{"$f":"'2026-2027'!AE9","v":0},{"$f":"'2026-2027'!AF9","v":0},{"$f":"'2026-2027'!AG9","v":0},{"$f":"'2026-2027'!AH9","v":0},{"$f":"'2026-2027'!AI9","v":0},0]
[null,"Outstanding Funding Required",{"$f":"'2026-2027'!CC9","v":0},{"$f":"'2026-2027'!CD9","v":0},{"$f":"'2026-2027'!CE9","v":0},{"$f":"'2026-2027'!CF9","v":0},{"$f":"'2026-2027'!CG9","v":0},{"$f":"'2026-2027'!CH9","v":0},{"$f":"'2026-2027'!CI9","v":0},{"$f":"'2026-2027'!CJ9","v":0},{"$f":"'2026-2027'!CK9","v":0},{"$f":"'2026-2027'!CL9","v":0},0]
[]
[null,null,"2027/28"]
[null,null,"Cost type"]
[null,null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other","Total"]
[null,"Total Project Cost",{"$f":"'2027-2028'!G9","v":0},{"$f":"'2027-2028'!H9","v":0},{"$f":"'2027-2028'!I9","v":0},{"$f":"'2027-2028'!J9","v":0},{"$f":"'2027-2028'!K9","v":0},{"$f":"'2027-2028'!L9","v":0},{"$f":"'2027-2028'!M9","v":0},{"$f":"'2027-2028'!N9","v":0},{"$f":"'2027-2028'!O9","v":0},{"$f":"'2027-2028'!P9","v":0},{"$f":"SUM(C116:L116)","v":0}]
[null,"Project Partner 1",{"$f":"'2027-2028'!AK9","v":0},{"$f":"'2027-2028'!AL9","v":0},{"$f":"'2027-2028'!AM9","v":0},{"$f":"'2027-2028'!AN9","v":0},{"$f":"'2027-2028'!AO9","v":0},{"$f":"'2027-2028'!AP9","v":0},{"$f":"'2027-2028'!AQ9","v":0},{"$f":"'2027-2028'!AR9","v":0},{"$f":"'2027-2028'!AS9","v":0},{"$f":"'2027-2028'!AT9","v":0},0]
[null,"Project Partner 2",{"$f":"'2027-2028'!AV9","v":0},{"$f":"'2027-2028'!AW9","v":0},{"$f":"'2027-2028'!AX9","v":0},{"$f":"'2027-2028'!AY9","v":0},{"$f":"'2027-2028'!AZ9","v":0},{"$f":"'2027-2028'!BA9","v":0},{"$f":"'2027-2028'!BB9","v":0},{"$f":"'2027-2028'!BC9","v":0},{"$f":"'2027-2028'!BD9","v":0},{"$f":"'2027-2028'!BE9","v":0},0]
[null,"Project Partner 3",{"$f":"'2027-2028'!BG9","v":0},{"$f":"'2027-2028'!BH9","v":0},{"$f":"'2027-2028'!BI9","v":0},{"$f":"'2027-2028'!BJ9","v":0},{"$f":"'2027-2028'!BK9","v":0},{"$f":"'2027-2028'!BL9","v":0},{"$f":"'2027-2028'!BM9","v":0},{"$f":"'2027-2028'!BN9","v":0},{"$f":"'2027-2028'!BO9","v":0},{"$f":"'2027-2028'!BP9","v":0},0]
[null,"External Funding",{"$f":"SUM(C117:C119)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(L117:L119)","v":0},0]
[null,"Licensee extra contribution",{"$f":"'2027-2028'!BR9","v":0},{"$f":"'2027-2028'!BS9","v":0},{"$f":"'2027-2028'!BT9","v":0},{"$f":"'2027-2028'!BU9","v":0},{"$f":"'2027-2028'!BV9","v":0},{"$f":"'2027-2028'!BW9","v":0},{"$f":"'2027-2028'!BX9","v":0},{"$f":"'2027-2028'!BY9","v":0},{"$f":"'2027-2028'!BZ9","v":0},{"$f":"'2027-2028'!CA9","v":0},0]
[null,"Initial Net Funding Required",{"$f":"C116-C120-C121","v":0},{"$f":"D116-D120-D121","v":0},0,0,0,0,0,0,0,0,0]
[null,"Licensee Compulsory Contribution",{"$f":"'2027-2028'!Z9","v":0},{"$f":"'2027-2028'!AA9","v":0},{"$f":"'2027-2028'!AB9","v":0},{"$f":"'2027-2028'!AC9","v":0},{"$f":"'2027-2028'!AD9","v":0},{"$f":"'2027-2028'!AE9","v":0},{"$f":"'2027-2028'!AF9","v":0},{"$f":"'2027-2028'!AG9","v":0},{"$f":"'2027-2028'!AH9","v":0},{"$f":"'2027-2028'!AI9","v":0},0]
[null,"Outstanding Funding Required",{"$f":"'2027-2028'!CC9","v":0},{"$f":"'2027-2028'!CD9","v":0},{"$f":"'2027-2028'!CE9","v":0},{"$f":"'2027-2028'!CF9","v":0},{"$f":"'2027-2028'!CG9","v":0},{"$f":"'2027-2028'!CH9","v":0},{"$f":"'2027-2028'!CI9","v":0},{"$f":"'2027-2028'!CJ9","v":0},{"$f":"'2027-2028'!CK9","v":0},{"$f":"'2027-2028'!CL9","v":0},0]
[]
[null,null,"2028/2029"]
[null,null,"Cost type"]
[null,null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other","Total"]
[null,"Total Project Cost",{"$f":"'2028-2029'!G9","v":0},{"$f":"'2028-2029'!H9","v":0},{"$f":"'2028-2029'!I9","v":0},{"$f":"'2028-2029'!J9","v":0},{"$f":"'2028-2029'!K9","v":0},{"$f":"'2028-2029'!L9","v":0},{"$f":"'2028-2029'!M9","v":0},{"$f":"'2028-2029'!N9","v":0},{"$f":"'2028-2029'!O9","v":0},{"$f":"'2028-2029'!P9","v":0},{"$f":"SUM(C129:L129)","v":0}]
[null,"Project Partner 1",{"$f":"'2028-2029'!AK9","v":0},{"$f":"'2028-2029'!AL9","v":0},{"$f":"'2028-2029'!AM9","v":0},{"$f":"'2028-2029'!AN9","v":0},{"$f":"'2028-2029'!AO9","v":0},{"$f":"'2028-2029'!AP9","v":0},{"$f":"'2028-2029'!AQ9","v":0},{"$f":"'2028-2029'!AR9","v":0},{"$f":"'2028-2029'!AS9","v":0},{"$f":"'2028-2029'!AT9","v":0},0]
[null,"Project Partner 2",{"$f":"'2028-2029'!AV9","v":0},{"$f":"'2028-2029'!AW9","v":0},{"$f":"'2028-2029'!AX9","v":0},{"$f":"'2028-2029'!AY9","v":0},{"$f":"'2028-2029'!AZ9","v":0},{"$f":"'2028-2029'!BA9","v":0},{"$f":"'2028-2029'!BB9","v":0},{"$f":"'2028-2029'!BC9","v":0},{"$f":"'2028-2029'!BD9","v":0},{"$f":"'2028-2029'!BE9","v":0},0]
[null,"Project Partner 3",{"$f":"'2028-2029'!BG9","v":0},{"$f":"'2028-2029'!BH9","v":0},{"$f":"'2028-2029'!BI9","v":0},{"$f":"'2028-2029'!BJ9","v":0},{"$f":"'2028-2029'!BK9","v":0},{"$f":"'2028-2029'!BL9","v":0},{"$f":"'2028-2029'!BM9","v":0},{"$f":"'2028-2029'!BN9","v":0},{"$f":"'2028-2029'!BO9","v":0},{"$f":"'2028-2029'!BP9","v":0},0]
[null,"External Funding",{"$f":"SUM(C130:C132)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(L130:L132)","v":0},0]
[null,"Licensee extra contribution",{"$f":"'2028-2029'!BR9","v":0},{"$f":"'2028-2029'!BS9","v":0},{"$f":"'2028-2029'!BT9","v":0},{"$f":"'2028-2029'!BU9","v":0},{"$f":"'2028-2029'!BV9","v":0},{"$f":"'2028-2029'!BW9","v":0},{"$f":"'2028-2029'!BX9","v":0},{"$f":"'2028-2029'!BY9","v":0},{"$f":"'2028-2029'!BZ9","v":0},{"$f":"'2028-2029'!CA9","v":0},0]
[null,"Initial Net Funding Required",{"$f":"C129-C133-C134","v":0},{"$f":"D129-D133-D134","v":0},0,0,0,0,0,0,0,0,0]
[null,"Licensee Compulsory Contribution",{"$f":"'2028-2029'!Z9","v":0},{"$f":"'2028-2029'!AA9","v":0},{"$f":"'2028-2029'!AB9","v":0},{"$f":"'2028-2029'!AC9","v":0},{"$f":"'2028-2029'!AD9","v":0},{"$f":"'2028-2029'!AE9","v":0},{"$f":"'2028-2029'!AF9","v":0},{"$f":"'2028-2029'!AG9","v":0},{"$f":"'2028-2029'!AH9","v":0},{"$f":"'2028-2029'!AI9","v":0},0]
[null,"Outstanding Funding Required",{"$f":"'2028-2029'!CC9","v":0},{"$f":"'2028-2029'!CD9","v":0},{"$f":"'2028-2029'!CE9","v":0},{"$f":"'2028-2029'!CF9","v":0},{"$f":"'2028-2029'!CG9","v":0},{"$f":"'2028-2029'!CH9","v":0},{"$f":"'2028-2029'!CI9","v":0},{"$f":"'2028-2029'!CJ9","v":0},{"$f":"'2028-2029'!CK9","v":0},{"$f":"'2028-2029'!CL9","v":0},0]

{"sheet":"Direct Benefits","index":3,"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,"2021/22","2022/23","2023/24","2024/25","2025/26","2026/27","2027/28","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":"2021-2022","index":4,"n_rows":255,"n_cols":90,"rows_kept":255,"cut":false,"hidden":false,"merged":[[3,80,3,89],[3,69,3,78],[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 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,"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"]
["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,{"$f":"SUM(R7:W7)","v":0},null,{"$f":"$R7*G7","v":0},{"$f":"$R7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$S7*G7","v":0},{"$f":"$S7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$T7*G7","v":0},{"$f":"$T7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$U7*G7","v":0},{"$f":"$U7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$V7*G7","v":0},{"$f":"$V7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$W7*G7","v":0},{"$f":"$W7*H7","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Cost",null,null,null,null,null,null,{"$f":"SUM(R8:W8)","v":0},null,{"$f":"$R8*G8","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$S8*G8","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$T8*G8","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$U8*G8","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$V8*G8","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$W8*G8","v":0},0,0,0,0,0,0,0,0,0]
[null,"Total",null,null,null,null,{"$f":"SUM(G7:G8)","v":0},{"$f":"SUM(H7:H8)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(G9:P9)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(Z7:Z8)","v":0},{"$f":"SUM(AA7:AA8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(AK7:AK8)","v":0},{"$f":"SUM(AL7:AL8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(AV7:AV8)","v":0},{"$f":"SUM(AW7:AW8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(BG7:BG8)","v":0},{"$f":"SUM(BH7:BH8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(BR7:BR8)","v":0},{"$f":"SUM(BS7:BS8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(CC7:CC8)","v":0},{"$f":"SUM(CD7:CD8)","v":0},0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Totals"]

{"sheet":"2022-2023","index":5,"n_rows":268,"n_cols":138,"rows_kept":268,"cut":false,"hidden":false,"merged":[[3,128,3,137],[3,117,3,126],[3,6,3,15],[3,17,3,27],[3,29,3,38],[3,40,3,49],[3,51,3,60],[3,62,3,71],[3,73,3,82],[3,84,3,93],[3,95,3,104],[3,106,3,115]]}
[null,"Project Costs in 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,null,null,"Licensee Compulsory Contribution/Direct Benefits",null,null,null,null,null,null,null,null,null,null,"Guidehouse",null,null,null,null,null,null,null,null,null,null,"Octopus Energy",null,null,null,null,null,null,null,null,null,null,"Passiv",null,null,null,null,null,null,null,null,null,null,"SERO",null,null,null,null,null,null,null,null,null,null,"SP Energy Networks",null,null,null,null,null,null,null,null,null,null,"Welsh Government",null,null,null,null,null,null,null,null,null,null,"West Midlands Combined Authority",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","Guidehouse","Octopus Energy","Passiv Systems","SERO","SP Energy Networks","Welsh Government","West Midlands Combined Authority#","Licensee Extra Contribution","Oustanding Funding Required","Total",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other"]
[null,"Description","Task","Project Workstream"]
[null,"Commercial Arrangements","Design M1 & M2","Workstream 1",null,null,80.78,0,0,0,0,0,0,14,0,0,null,0.19538643620286192,null,5.2250845794965986E-2,null,3.9403329704658048E-2,2.0148012402535147E-2,null,null,null,0.69281137589497888,{"$f":"SUM(R7:AA7)","v":1},null,{"$f":"$R7*G7","v":15.783316316467186},{"$f":"$R7*H7","v":0},0,0,0,0,0,2.7354101068400669,0,0,null,{"$f":"$S7*G7","v":0},{"$f":"$S7*H7","v":0},{"$f":"$S7*I7","v":0},{"$f":"$S7*J7","v":0},{"$f":"$S7*K7","v":0},{"$f":"$S7*L7","v":0},{"$f":"$S7*M7","v":0},{"$f":"$S7*N7","v":0},{"$f":"$S7*O7","v":0},{"$f":"$S7*P7","v":0},null,{"$f":"$T7*G7","v":4.2208233233173527},0,0,0,0,0,0,0.73151184112952383,0,0,null,{"$f":"$U7*G7","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$V7*G7","v":3.1830009735422773},{"$f":"$V7*H7","v":0},0,0,0,0,0,0.55164661586521269,0,0,null,{"$f":"$W7*G7","v":1.6275564418767892},{"$f":"$W7*H7","v":0},0,0,0,0,0,0.28207217363549208,0,0,null,{"$f":"$X7*G7","v":0},{"$f":"$X7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$Y7*G7","v":0},{"$f":"$Y7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$Z7*G7","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$AA7*G7","v":55.965302944796392},0,0,0,0,0,0,9.699359262529704,0,0]
[null,"Commercial Arrangements","Refine M1 & M2 & Design M3","Workstream 1",null,null,149.18,0,0,0,0,0,0,0,0,0,null,0.19538643620286192,0.32421381997235321,5.2250845794965986E-2,null,3.9403329704658048E-2,null,null,null,null,0.38874556832516083,{"$f":"SUM(R8:AA8)","v":1},null,{"$f":"$R8*G8","v":29.147748552742943},0,0,0,0,0,0,0,0,0,null,48.366217663475652,0,0,0,0,0,0,0,0,0,null,{"$f":"$T8*G8","v":7.7947811756930259},{"$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":5.8781887253408875},0,0,0,0,0,0,0,0,0,null,{"$f":"$W8*G8","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$X8*G8","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$Y8*G8","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$Z8*G8","v":0},{"$f":"$Z8*H8","v":0},{"$f":"$Z8*I8","v":0},{"$f":"$Z8*J8","v":0},{"$f":"$Z8*K8","v":0},{"$f":"$Z8*L8","v":0},{"$f":"$Z8*M8","v":0},{"$f":"$Z8*N8","v":0},{"$f":"$Z8*O8","v":0},{"$f":"$Z8*P8","v":0},null,{"$f":"$AA8*G8","v":57.993063882747492},{"$f":"$AA8*H8","v":0},{"$f":"$AA8*I8","v":0},{"$f":"$AA8*J8","v":0},{"$f":"$AA8*K8","v":0},{"$f":"$AA8*L8","v":0},{"$f":"$AA8*M8","v":0},{"$f":"$AA8*N8","v":0},{"$f":"$AA8*O8","v":0},{"$f":"$AA8*P8","v":0}]
[null,"Commercial Arrangements","Refine M1 & M2 & refine M3","Workstream 1",null,null,96.53,0,0,0,0,0,0,0,0,0,null,0.19538643620286192,null,null,null,3.9403329704658048E-2,null,null,null,null,0.76521023409248001,1,null,18.860652686662259,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,3.8036034163906414,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,73.865743896947095,0,0,0,0,0,0,0,0,0]
[null,"Integration and automation","Overall integration planning","Workstream 2",null,null,250.88,0,0,0,0,0,0,50,0,0,null,0.19538643620286192,null,5.2250845794965986E-2,2.0460687437416431E-2,3.9403329704658048E-2,null,null,null,null,0.69249870086009757,1,null,49.018549114574,0,0,0,0,0,0,9.7693218101430954,0,0,null,0,0,0,0,0,0,0,0,0,0,null,13.108692193041067,0,0,0,0,0,0,2.6125422897482995,0,0,null,5.1331772642990341,0,0,0,0,0,0,1.0230343718708215,0,0,null,9.8855073563046112,0,0,0,0,0,0,1.9701664852329024,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,173.73407407178127,0,0,0,0,0,0,34.624935043004882,0,0]
[null,"Integration and automation","Integration delivery and testing","Workstream 2",null,null,418.05,0,0,250,0,0,0,460.73,0,0,null,0.19538643620286192,null,5.2250845794965986E-2,2.0460687437416431E-2,3.9403329704658048E-2,null,null,null,null,0.69249870086009757,1,null,81.681299654606434,0,0,48.846609050715479,0,0,0,90.020392751744581,0,0,null,0,0,0,0,0,0,0,0,0,0,null,21.843466084585533,0,0,13.062711448741496,0,0,0,24.073532183114679,0,0,null,8.5535903832119384,0,0,5.115171859354108,0,0,0,9.4268525230408731,0,0,null,16.472561983032296,0,0,9.8508324261645122,0,0,0,18.154296094827103,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,289.4990818945638,0,0,173.12467521502438,0,0,0,319.05492644727275,0,0]
[null,"Customer Engagement and Experience","Engagement design","WorkStream 3",null,null,32.53,0,0,0,0,0,0,0,0,0,null,0.19538643620286192,null,5.2250845794965986E-2,null,3.9403329704658048E-2,null,null,null,null,0.71295938829751404,1,null,6.3559207696790985,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,1.6997200137102435,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,1.2817903152925263,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,23.192568901318133,0,0,0,0,0,0,0,0,0]
[null,"Customer Engagement and Experience","Engagement materials","WorkStream 3",null,null,23.15,0,0,0,0,0,0,0,0,30,null,0.19538643620286192,0.32421381997235321,null,null,3.9403329704658048E-2,null,null,null,null,0.4409964141201268,1,null,4.5231959980962531,0,0,0,0,0,0,0,0,5.8615930860858576,null,7.5055499323599761,0,0,0,0,0,0,0,0,9.7264145991705959,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0.91218708266283377,0,0,0,0,0,0,0,0,1.1820998911397413,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,10.209066986880934,0,0,0,0,0,0,0,0,13.229892423603804]
[null,"Customer Engagement and Experience","Engagement surveys and focus groups","WorkStream 3",null,null,45,0,0,0,0,0,15,0,0,0,null,0.19538643620286192,null,5.2250845794965986E-2,null,null,null,null,null,null,0.75236271800217214,1,null,8.7923896291287864,0,0,0,0,0,2.9307965430429288,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,2.3512880607734692,0,0,0,0,0,0.7837626869244898,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,33.856322310097745,0,0,0,0,0,11.285440770032583,0,0,0]
[null,"Customer Engagement and Experience","Engagement primary research","WorkStream 3",null,null,0,0,50,0,0,0,0,0,0,0,null,0.19538643620286192,null,null,null,null,null,null,null,null,0.80461356379713811,1,null,0,0,9.7693218101430954,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,40.230678189856903,0,0,0,0,0,0,0]
[null,"Trials","Overal Trial Design","Workstream 4",null,null,75.03,0,0,0,0,0,0,0,0,0,null,0.19538643620286192,null,5.2250845794965986E-2,null,null,2.0148012402535147E-2,null,null,null,0.73221470559963686,1,null,14.65984430830073,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,3.9203809599962982,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,1.5117053705622121,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,54.938069361140755,0,0,0,0,0,0,0,0,0]
[null,"Trials","Simulation modelling","Workstream 4",null,null,105.2,0,50,0,0,0,0,0,0,0,null,0.19538643620286192,0.32421381997235321,null,2.0460687437416431E-2,null,null,null,null,null,0.45993905638736843,1,null,20.554653088541073,0,9.7693218101430954,0,0,0,0,0,0,0,null,34.107293861091556,0,16.210690998617661,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,2.1524643184162087,0,1.0230343718708215,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,48.38558873195116,0,22.996952819368421,0,0,0,0,0,0,0]
[null,"Trials","Trial delivery and analysis ","Workstream 4",null,null,318,7000,0,0,0,0,60,110,0,0,null,null,null,null,null,null,null,0.66773504273504269,0.26709401709401709,null,6.5170940170940161E-2,1,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,212.33974358974356,4674.1452991452988,0,0,0,0,40.064102564102562,73.450854700854691,0,0,null,84.935897435897431,1869.6581196581196,0,0,0,0,16.025641025641026,29.380341880341881,0,0,null,0,0,0,0,0,0,0,0,0,0,null,20.724358974358971,456.19658119658112,0,0,0,0,3.9102564102564097,7.1688034188034173,0,0]
[null,"Trials","Business case update and transistion","Workstream 4",null,null,55.15,0,0,0,0,0,0,0,0,0,null,0.19538643620286192,0.32421381997235321,null,null,null,2.0148012402535147E-2,null,null,null,0.46025173142224973,1,null,10.775561956587834,0,0,0,0,0,0,0,0,0,null,17.880392171475279,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,1.1111628839998133,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,25.382882987937073,0,0,0,0,0,0,0,0,0]
[null,"PM Management and knowledge dissemination","PM Labour","WorkStream 5",null,null,271.27999999999997,0,0,0,0,20,0,0,0,0,null,0.19538643620286192,null,5.2250845794965986E-2,2.0460687437416431E-2,3.9403329704658048E-2,null,null,null,null,0.69249870086009757,1,null,53.004432413112376,0,0,0,0,3.9077287240572383,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,14.174609447258371,0,0,0,0,1.0450169158993197,0,0,0,0,null,5.5505752880223289,0,0,0,0,0.40921374874832861,0,0,0,0,null,10.689335282279634,0,0,0,0,0.78806659409316093,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,187.86104756932724,0,0,0,0,13.849974017201951,0,0,0,0]
[null,"PM Management and knowledge dissemination","Knowledge transfer and dissemination","WorkStream 5",null,null,105.58,0,0,0,0,0,0,0,0,30,"Total Cost",0.19538643620286192,0.32421381997235321,5.2250845794965986E-2,null,3.9403329704658048E-2,null,null,null,null,0.38874556832516083,{"$f":"SUM(R21:AA21)","v":1},null,20.628899934298161,0,0,0,0,0,0,0,0,5.8615930860858576,null,34.230495112681055,0,0,0,0,0,0,0,0,9.7264145991705959,null,{"$f":"$T21*G21","v":5.5166442990325084},0,0,0,0,0,0,0,0,1.5675253738489796,null,{"$f":"$U21*G21","v":0},0,0,0,0,0,0,0,0,0,null,4.1602035502177968,0,0,0,0,0,0,0,0,1.1820998911397413,null,0,0,0,0,0,0,0,0,0,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":"$Z21*G21","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$AA21*G21","v":41.043757103770481},0,0,0,0,0,0,0,0,11.662367049754824]
[null,"Total",null,null,null,null,{"$f":"SUM(G7:G21)","v":2026.3400000000001},{"$f":"SUM(H7:H21)","v":7000},100,250,0,20,75,634.73,0,60,{"$f":"SUM(G22:P22)","v":10166.07},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AD7:AD21)","v":333.78646442279711},{"$f":"SUM(AE7:AE21)","v":0},19.538643620286191,48.846609050715479,0,3.9077287240572383,2.9307965430429288,102.52512466872774,0,11.723186172171715,null,{"$f":"SUM(AO7:AO21)","v":142.0899487410835},{"$f":"SUM(AP7:AP21)","v":0},16.210690998617661,0,0,0,0,0,0,19.452829198341192,null,{"$f":"SUM(AZ7:AZ21)","v":74.630405557407869},{"$f":"SUM(BA7:BA21)","v":0},0,13.062711448741496,0,1.0450169158993197,0.7837626869244898,27.417586313992501,0,1.5675253738489796,null,{"$f":"SUM(BK7:BK21)","v":21.38980725394951},{"$f":"SUM(BL7:BL21)","v":0},1.0230343718708215,5.115171859354108,0,0.40921374874832861,0,10.449886894911694,0,0,null,{"$f":"SUM(BV7:BV21)","v":56.266378685063508},{"$f":"SUM(BW7:BW21)","v":0},0,9.8508324261645122,0,0.78806659409316093,0,20.676109195925218,0,2.3641997822794827,null,{"$f":"SUM(CG7:CG21)","v":4.2504246964388148},{"$f":"SUM(CH7:CH21)","v":0},0,0,0,0,0,0.28207217363549208,0,0,null,{"$f":"SUM(CR7:CR21)","v":212.33974358974356},{"$f":"SUM(CS7:CS21)","v":4674.1452991452988},0,0,0,0,40.064102564102562,73.450854700854691,0,0,null,{"$f":"SUM(DC7:DC21)","v":84.935897435897431},{"$f":"SUM(DD7:DD21)","v":1869.6581196581196},0,0,0,0,16.025641025641026,29.380341880341881,0,0,null,{"$f":"SUM(DN7:DN21)","v":0},{"$f":"SUM(DO7:DO21)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(DY7:DY21)","v":1096.6509296176187},{"$f":"SUM(DZ7:DZ21)","v":456.19658119658112},63.22763100922532,173.12467521502438,0,13.849974017201951,15.195697180288992,370.54802417161073,0,24.892259473358628]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Totals"]

{"sheet":"2023-2024","index":6,"n_rows":268,"n_cols":138,"rows_kept":268,"cut":false,"hidden":false,"merged":[[3,128,3,137],[3,117,3,126],[3,6,3,15],[3,17,3,27],[3,29,3,38],[3,40,3,49],[3,51,3,60],[3,62,3,71],[3,73,3,82],[3,84,3,93],[3,95,3,104],[3,106,3,115]]}
[null,"Project Costs in 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,null,null,"Licensee Compulsory Contribution/Direct Benefits",null,null,null,null,null,null,null,null,null,null,"Guidehouse",null,null,null,null,null,null,null,null,null,null,"Octopus Energy",null,null,null,null,null,null,null,null,null,null,"Passiv",null,null,null,null,null,null,null,null,null,null,"SERO",null,null,null,null,null,null,null,null,null,null,"SP Energy Networks",null,null,null,null,null,null,null,null,null,null,"Welsh Government",null,null,null,null,null,null,null,null,null,null,"West Midlands Combined Authority",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","Guidehouse","Octopus Energy","Passiv Systems","SERO","SP Energy Networks","Welsh Government","West Midlands Combined Authority#","Licensee Extra Contribution","Oustanding Funding Required","Total",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other"]
[null,"Description","Task","Project Workstream"]
[null,"Commercial Arrangements","Design M1 & M2","Workstream 1",null,null,1.7875000000000001,0,0,0,0,0,0,0,0,0,null,5.0510101877289375E-2,null,null,null,null,2.1273865078618157E-2,null,null,null,0.9282160330440925,{"$f":"SUM(R7:AA7)","v":1},null,{"$f":"$R7*G7","v":9.0286807105654759E-2},0,0,0,0,0,0,0,0,0,null,{"$f":"$S7*G7","v":0},{"$f":"$S7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$T7*G7","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$U7*G7","v":0},{"$f":"$U7*H7","v":0},{"$f":"$U7*I7","v":0},{"$f":"$U7*J7","v":0},{"$f":"$U7*K7","v":0},{"$f":"$U7*L7","v":0},{"$f":"$U7*M7","v":0},{"$f":"$U7*N7","v":0},{"$f":"$U7*O7","v":0},{"$f":"$U7*P7","v":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":3.8027033828029959E-2},{"$f":"$W7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$X7*G7","v":0},{"$f":"$X7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$Y7*G7","v":0},{"$f":"$Y7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$Z7*G7","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$AA7*G7","v":1.6591861590663155},{"$f":"$AA7*H7","v":0},{"$f":"$AA7*I7","v":0},0,0,0,0,0,0,0]
[null,"Commercial Arrangements","Refine M1 & M2 & Design M3","Workstream 1",null,null,30.024999999999999,0,0,0,0,0,0,5,0,0,null,5.0510101877289375E-2,null,2.0296736090725045E-2,null,1.1903854686216115E-2,null,null,null,null,0.91728930734576952,{"$f":"SUM(R8:AA8)","v":1},null,{"$f":"$R8*G8","v":1.5165658088656133},{"$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.25255050938644685},{"$f":"$R8*O8","v":0},{"$f":"$R8*P8","v":0},null,{"$f":"$S8*G8","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$T8*G8","v":0.60940950112401948},{"$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.10148368045362523},{"$f":"$T8*O8","v":0},{"$f":"$T8*P8","v":0},null,0,0,0,0,0,0,0,0,0,0,null,{"$f":"$V8*G8","v":0.35741323695363886},0,0,0,0,0,0,5.9519273431080578E-2,0,0,null,{"$f":"$W8*G8","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$X8*G8","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$Y8*G8","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$Z8*G8","v":0},{"$f":"$Z8*H8","v":0},{"$f":"$Z8*I8","v":0},{"$f":"$Z8*J8","v":0},{"$f":"$Z8*K8","v":0},{"$f":"$Z8*L8","v":0},{"$f":"$Z8*M8","v":0},{"$f":"$Z8*N8","v":0},{"$f":"$Z8*O8","v":0},{"$f":"$Z8*P8","v":0},null,{"$f":"$AA8*G8","v":27.541611453056728},{"$f":"$AA8*H8","v":0},0,0,0,0,0,4.5864465367288476,0,0]
[null,"Commercial Arrangements","Refine M1 & M2 & refine M3","Workstream 1",null,null,144.17500000000001,0,0,0,0,0,0,0,0,0,null,5.0510101877289375E-2,7.3556175330287771E-2,null,null,1.1903854686216115E-2,null,null,null,null,0.86402986810620674,1,null,7.2822939381581966,0,0,0,0,0,0,0,0,0,null,10.604961578244239,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,1.7162382493852086,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,124.57150623421236,0,0,0,0,0,0,0,0,0]
[null,"Integration and automation","Overall integration planning","Workstream 2",null,null,75.074999999999989,0,0,0,0,0,0,100,0,0,null,5.0510101877289375E-2,null,null,null,1.1903854686216115E-2,null,null,null,null,0.93758604343649454,1,null,3.7920458984374994,0,0,0,0,0,0,5.0510101877289371,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0.89368189056767477,0,0,0,0,0,0,1.1903854686216115,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,70.389272210994818,0,0,0,0,0,0,93.758604343649452,0,0]
[null,"Integration and automation","Integration delivery and testing","Workstream 2",null,null,359.1,0,0,0,0,0,0,462.87,0,0,null,5.0510101877289375E-2,null,2.0296736090725045E-2,null,1.1903854686216115E-2,null,null,null,null,0.91728930734576952,1,null,18.138177584134617,0,0,0,0,0,0,23.379610855940932,0,0,null,0,0,0,0,0,0,0,0,0,0,null,7.2885579301793637,0,0,0,0,0,0,9.3947502343139018,0,0,null,0,0,0,0,0,0,0,0,0,0,null,4.2746742178202073,0,0,0,0,0,0,5.5099372186088535,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,329.39859026786587,0,0,0,0,0,0,424.58570169113636,0,0]
[null,"Customer Engagement and Experience","Engagement design","WorkStream 3",null,null,7.15,0,0,0,0,0,0,0,0,0,null,5.0510101877289375E-2,null,null,null,1.1903854686216115E-2,null,null,null,null,0.93758604343649454,1,null,0.36114722842261904,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,8.5112561006445223E-2,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,6.7037402105709365,0,0,0,0,0,0,0,0,0]
[null,"Customer Engagement and Experience","Engagement materials","WorkStream 3",null,null,44.6,0,0,0,0,0,0,0,0,30,null,5.0510101877289375E-2,7.3556175330287771E-2,null,null,1.1903854686216115E-2,null,null,null,null,0.86402986810620674,1,null,2.2527505437271063,0,0,0,0,0,0,0,0,1.5153030563186813,null,3.2806054197308345,0,0,0,0,0,0,0,0,2.2066852599086331,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0.53091191900523871,0,0,0,0,0,0,0,0,0.35711564058648348,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,38.535732117536824,0,0,0,0,0,0,0,0,25.920896043186204]
[null,"Customer Engagement and Experience","Engagement surveys and focus groups","WorkStream 3",null,null,73.075000000000003,0,0,0,0,0,15,0,0,0,null,5.0510101877289375E-2,null,2.0296736090725045E-2,null,1.1903854686216115E-2,null,null,null,null,0.91728930734576952,1,null,3.6910256946829212,0,0,0,0,0,0.75765152815934067,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,1.4831839898297328,0,0,0,0,0,0.3044510413608757,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0.86987418119524262,0,0,0,0,0,0.17855782029324174,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,67.030916134292113,0,0,0,0,0,13.759339610186544,0,0,0]
[null,"Customer Engagement and Experience","Engagement primary research","WorkStream 3",null,null,32.174999999999997,0,50,0,0,0,0,0,0,0,null,5.0510101877289375E-2,null,null,null,1.1903854686216115E-2,null,null,null,null,0.93758604343649454,1,null,1.6251625279017854,0,2.5255050938644685,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0.38300652452900347,0,0.59519273431080577,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,30.16683094756921,0,46.879302171824726,0,0,0,0,0,0,0]
[null,"Trials","Overal Trial Design","Workstream 4",null,null,111.5,0,0,0,0,0,0,0,0,0,null,5.0510101877289375E-2,null,2.0296736090725045E-2,null,1.1903854686216115E-2,null,null,null,null,0.91728930734576952,1,null,5.631876359317765,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,2.2630860741158423,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,1.3272797975130968,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,102.2777577690533,0,0,0,0,0,0,0,0,0]
[null,"Trials","Simulation modelling","Workstream 4",null,null,137.375,0,20,0,0,0,0,0,0,0,null,5.0510101877289375E-2,7.3556175330287771E-2,null,2.3877274456734741E-2,1.1903854686216115E-2,null,null,null,null,0.84015259364947203,1,null,6.9388252453926276,0,1.0102020375457874,0,0,0,0,0,0,0,null,10.104779585998282,0,1.4711235066057555,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,3.2801405784939348,0,0.4775454891346948,0,0,0,0,0,0,0,null,1.6352920375189388,0,0.23807709372432231,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,115.41596255259623,0,16.803051872989442,0,0,0,0,0,0,0]
[null,"Trials","Trial delivery and analysis ","Workstream 4",null,null,304.45,0,0,0,0,0,60,60,0,0,null,5.0510101877289375E-2,null,null,null,null,null,null,null,null,0.94948989812271067,1,null,15.37780051654075,0,0,0,0,0,3.0306061126373627,3.0306061126373627,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,289.07219948345926,0,0,0,0,0,56.969393887362642,56.969393887362642,0,0]
[null,"Trials","Business case update and transistion","Workstream 4",null,null,53.362499999999997,0,0,0,0,0,0,0,0,0,null,5.0510101877289375E-2,7.3556175330287771E-2,null,null,null,2.1273865078618157E-2,null,null,null,0.8546598577138047,1,null,2.6953453114268542,0,0,0,0,0,0,0,0,0,null,3.925141406062481,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,1.1352266252577614,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,45.606786657252904,0,0,0,0,0,0,0,0,0]
[null,"PM Management and knowledge dissemination","PM Labour","WorkStream 5",null,null,258.78000000000003,0,0,0,0,0,0,0,0,0,null,5.0510101877289375E-2,null,2.0296736090725045E-2,2.3877274456734741E-2,1.1903854686216115E-2,null,null,null,null,0.8934120328890347,1,null,13.071004163804947,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,5.2523893655578275,0,0,0,0,0,0,0,0,0,null,6.1789610839138165,0,0,0,0,0,0,0,0,0,null,3.0804795156990066,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,231.19716587102442,0,0,0,0,0,0,0,0,0]
[null,"PM Management and knowledge dissemination","Knowledge transfer and dissemination","WorkStream 5",null,null,115.02500000000001,0,66,0,0,0,0,0,0,15,"Total Cost",5.0510101877289375E-2,7.3556175330287771E-2,2.0296736090725045E-2,null,null,null,null,null,null,0.85563698670169774,{"$f":"SUM(R21:AA21)","v":1},null,{"$f":"$R21*G21","v":5.8099244684352103},0,3.3336667239010986,0,0,0,0,0,0,0.75765152815934067,null,{"$f":"$S21*G21","v":8.4607990673663505},0,4.8547075717989925,0,0,0,0,0,0,1.1033426299543165,null,{"$f":"$T21*G21","v":2.3346320688356483},0,1.3395845819878529,0,0,0,0,0,0,0.3044510413608757,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,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":"$Z21*G21","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$AA21*G21","v":98.419644395362795},0,56.472041122312049,0,0,0,0,0,0,12.834554800525467]
[null,"Total",null,null,null,null,{"$f":"SUM(G7:G21)","v":1747.655},{"$f":"SUM(H7:H21)","v":0},136,0,0,0,75,627.87,0,45,{"$f":"SUM(G22:P22)","v":2631.5250000000001},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AD7:AD21)","v":88.274232096354154},{"$f":"SUM(AE7:AE21)","v":0},6.8693738553113546,0,0,0,3.7882576407967035,31.713777665693677,0,2.2729545844780219,null,{"$f":"SUM(AO7:AO21)","v":36.376287057402187},{"$f":"SUM(AP7:AP21)","v":0},6.3258310784047485,0,0,0,0,0,0,3.3100278898629494,null,{"$f":"SUM(AZ7:AZ21)","v":19.231258929642436},{"$f":"SUM(BA7:BA21)","v":0},1.3395845819878529,0,0,0,0.3044510413608757,9.4962339147675277,0,0.3044510413608757,null,{"$f":"SUM(BK7:BK21)","v":9.4591016624077504},{"$f":"SUM(BL7:BL21)","v":0},0.4775454891346948,0,0,0,0,0,0,0,null,{"$f":"SUM(BV7:BV21)","v":15.1539641311937},{"$f":"SUM(BW7:BW21)","v":0},0.83326982803512806,0,0,0,0.17855782029324174,6.7598419606615456,0,0.35711564058648348,null,{"$f":"SUM(CG7:CG21)","v":1.1732536590857914},{"$f":"SUM(CH7:CH21)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(CR7:CR21)","v":0},{"$f":"SUM(CS7:CS21)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(DC7:DC21)","v":0},{"$f":"SUM(DD7:DD21)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(DN7:DN21)","v":0},{"$f":"SUM(DO7:DO21)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(DY7:DY21)","v":1577.9869024639142},{"$f":"SUM(DZ7:DZ21)","v":0},120.15439516712621,0,0,0,70.728733497549186,579.90014645887732,0,38.755450843711671]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Totals"]

{"sheet":"2024-2025","index":7,"n_rows":268,"n_cols":138,"rows_kept":268,"cut":false,"hidden":false,"merged":[[3,128,3,137],[3,117,3,126],[3,6,3,15],[3,17,3,27],[3,29,3,38],[3,40,3,49],[3,51,3,60],[3,62,3,71],[3,84,3,93],[3,95,3,104],[3,106,3,115],[3,73,3,82]]}
[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,null,null,"Licensee Compulsory Contribution/Direct Benefits",null,null,null,null,null,null,null,null,null,null,"Guidehouse",null,null,null,null,null,null,null,null,null,null,"Octopus Energy",null,null,null,null,null,null,null,null,null,null,"Passiv ",null,null,null,null,null,null,null,null,null,null,"SERO",null,null,null,null,null,null,null,null,null,null,"SP Energy Networks",null,null,null,null,null,null,null,null,null,null,"Welsh Government",null,null,null,null,null,null,null,null,null,null,"West Midlands Combined Authority",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","Guidehouse","Octopus Energy","Passiv Systems","SERO","SP Energy Networks","Welsh Government","West Midlands Combined Authority#","Licensee Extra Contribution","Oustanding Funding Required","Total",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other"]
[null,"Description","Task","Project Workstream"]
[null,"Commercial Arrangements","Design M1 & M2","Workstream 1",null,null,1.7875000000000001,0,0,0,0,0,0,0,0,0,null,6.841259382931672E-2,null,null,null,null,1.1070200695861872E-2,null,null,null,0.92051720547482141,{"$f":"SUM(R7:AA7)","v":1},null,{"$f":"$R7*G7","v":0.12228751146990365},{"$f":"$R7*H7","v":0},{"$f":"$R7*I7","v":0},{"$f":"$R7*J7","v":0},{"$f":"$R7*K7","v":0},{"$f":"$R7*L7","v":0},{"$f":"$R7*M7","v":0},{"$f":"$R7*N7","v":0},{"$f":"$R7*O7","v":0},{"$f":"$R7*P7","v":0},null,{"$f":"$S7*G7","v":0},{"$f":"$S7*H7","v":0},{"$f":"$S7*I7","v":0},{"$f":"$S7*J7","v":0},{"$f":"$S7*K7","v":0},{"$f":"$S7*L7","v":0},{"$f":"$S7*M7","v":0},{"$f":"$S7*N7","v":0},{"$f":"$S7*O7","v":0},{"$f":"$S7*P7","v":0},null,{"$f":"$T7*G7","v":0},{"$f":"$T7*H7","v":0},{"$f":"$T7*I7","v":0},{"$f":"$T7*J7","v":0},{"$f":"$T7*K7","v":0},{"$f":"$T7*L7","v":0},{"$f":"$T7*M7","v":0},{"$f":"$T7*N7","v":0},{"$f":"$T7*O7","v":0},{"$f":"$T7*P7","v":0},null,{"$f":"$U7*G7","v":0},{"$f":"$U7*H7","v":0},{"$f":"$U7*I7","v":0},{"$f":"$U7*J7","v":0},{"$f":"$U7*K7","v":0},{"$f":"$U7*L7","v":0},{"$f":"$U7*M7","v":0},{"$f":"$U7*N7","v":0},{"$f":"$U7*O7","v":0},{"$f":"$U7*P7","v":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":1.9787983743853096E-2},{"$f":"$W7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$X7*G7","v":0},{"$f":"$X7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$Y7*G7","v":0},{"$f":"$Y7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$Z7*G7","v":0},{"$f":"$Z7*H7","v":0},{"$f":"$Z7*I7","v":0},{"$f":"$Z7*J7","v":0},{"$f":"$Z7*K7","v":0},{"$f":"$Z7*L7","v":0},{"$f":"$Z7*M7","v":0},{"$f":"$Z7*N7","v":0},{"$f":"$Z7*O7","v":0},{"$f":"$Z7*P7","v":0},null,{"$f":"$AA7*G7","v":1.6454245047862432},{"$f":"$AA7*H7","v":0},{"$f":"$AA7*I7","v":0},{"$f":"$AA7*J7","v":0},{"$f":"$AA7*K7","v":0},{"$f":"$AA7*L7","v":0},{"$f":"$AA7*M7","v":0},{"$f":"$AA7*N7","v":0},{"$f":"$AA7*O7","v":0},{"$f":"$AA7*P7","v":0}]
[null,"Commercial Arrangements","Refine M1 & M2 & Design M3","Workstream 1",null,null,0,0,0,0,0,0,0,0,0,0,null,6.841259382931672E-2,null,null,null,null,null,null,null,null,0.93158740617068325,{"$f":"SUM(R8:AA8)","v":1},null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,{"$f":"$V8*G8","v":0},0,0,0,0,0,0,0,0,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},0,0,0,0,0,0,0,0,0,null,{"$f":"$Y8*G8","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,"Commercial Arrangements","Refine M1 & M2 & refine M3","Workstream 1",null,null,8.5749999999999993,0,0,0,0,0,0,5,0,0,null,6.841259382931672E-2,null,null,null,null,null,null,null,null,0.93158740617068325,1,null,0.58663799208639078,0,0,0,0,0,0,0.34206296914658363,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,7.988362007913608,0,0,0,0,0,0,4.6579370308534163,0,0]
[null,"Integration and automation","Overall integration planning","Workstream 2",null,null,112,0,0,0,0,0,0,0,0,0,null,6.841259382931672E-2,3.0409107017677257E-2,3.7206648670031039E-2,null,null,null,null,null,null,0.86397165048297497,1,null,7.6622105088834722,0,0,0,0,0,0,0,0,0,null,3.4058199859798526,0,0,0,0,0,0,0,0,0,null,4.1671446510434764,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,96.764824854093192,0,0,0,0,0,0,0,0,0]
[null,"Integration and automation","Integration delivery and testing","Workstream 2",null,null,53.625,0,0,0,0,0,0,150,0,0,null,6.841259382931672E-2,null,null,null,1.3632675032515437E-2,null,null,null,null,0.91795473113816783,1,null,3.6686253440971091,0,0,0,0,0,0,10.261889074397509,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0.73105219861864035,0,0,0,0,0,0,2.0449012548773156,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,49.22532245728425,0,0,0,0,0,0,137.69320967072517,0,0]
[null,"Customer Engagement and Experience","Engagement design","WorkStream 3",null,null,10.725,0,0,0,0,0,0,0,0,0,null,6.841259382931672E-2,null,null,null,null,null,null,null,null,0.93158740617068325,1,null,0.73372506881942179,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,9.9912749311805769,0,0,0,0,0,0,0,0,0]
[null,"Customer Engagement and Experience","Engagement materials","WorkStream 3",null,null,8,0,0,0,0,0,0,0,0,0,null,6.841259382931672E-2,3.0409107017677257E-2,3.7206648670031039E-2,null,null,null,null,null,null,0.86397165048297497,1,null,0.54730075063453376,0,0,0,0,0,0,0,0,0,null,0.24327285614141805,0,0,0,0,0,0,0,0,0,null,0.29765318936024832,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,6.9117732038637998,0,0,0,0,0,0,0,0,0]
[null,"Customer Engagement and Experience","Engagement surveys and focus groups","WorkStream 3",null,null,44.475000000000001,0,0,0,0,0,15,0,0,0,null,6.841259382931672E-2,null,null,null,1.3632675032515437E-2,null,null,null,null,0.91795473113816783,1,null,3.0426501105588613,0,0,0,0,0,1.0261889074397508,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0.60631322207112404,0,0,0,0,0,0.20449012548773154,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,40.826036667370019,0,0,0,0,0,13.769320967072517,0,0,0]
[null,"Customer Engagement and Experience","Engagement primary research","WorkStream 3",null,null,21.45,0,50,0,0,0,0,0,0,0,null,6.841259382931672E-2,null,null,null,1.3632675032515437E-2,null,null,null,null,0.91795473113816783,1,null,1.4674501376388436,0,3.4206296914658361,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0.29242087944745609,0,0.68163375162577189,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,19.690128982913699,0,45.897736556908391,0,0,0,0,0,0,0]
[null,"Trials","Overal Trial Design","Workstream 4",null,null,82.899999999999991,0,0,0,0,0,0,0,0,0,null,6.841259382931672E-2,null,null,null,1.3632675032515437E-2,null,null,null,null,0.91795473113816783,1,null,5.6714040284503557,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,1.1301487601955296,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,76.098447211354099,0,0,0,0,0,0,0,0,0]
[null,"Trials","Simulation modelling","Workstream 4",null,null,115.925,0,20,0,0,0,0,0,0,0,null,6.841259382931672E-2,3.0409107017677257E-2,3.7206648670031039E-2,1.5936418623480778E-2,1.3632675032515437E-2,null,null,null,null,0.83440255682697873,1,null,7.9307299396635402,0,1.3682518765863345,0,0,0,0,0,0,0,null,3.5251757310242358,0,0.60818214035354512,0,0,0,0,0,0,0,null,4.3131807470733481,0,0.74413297340062079,0,0,0,0,0,0,0,null,1.8474293289270092,0,0.31872837246961555,0,0,0,0,0,0,0,null,1.5803678531443519,0,0.27265350065030874,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,96.728116400167508,0,16.688051136539574,0,0,0,0,0,0,0]
[null,"Trials","Trial delivery and analysis ","Workstream 4",null,null,308.02499999999998,0,0,0,0,0,60,60,0,0,null,null,3.0409107017677257E-2,null,null,null,null,null,null,null,0.96959089298232271,1,null,0,0,0,0,0,0,0,0,0,0,null,9.3667651891200361,0,0,0,0,0,1.8245464210606355,1.8245464210606355,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,298.65823481087995,0,0,0,0,0,58.175453578939361,58.175453578939361,0,0]
[null,"Trials","Business case update and transistion","Workstream 4",null,null,64.087500000000006,0,0,0,0,0,0,0,0,0,null,6.841259382931672E-2,3.0409107017677257E-2,3.7206648670031039E-2,null,1.3632675032515437E-2,1.1070200695861872E-2,null,null,null,0.83926877475459771,1,null,4.3843921070363354,0,0,0,0,0,0,0,0,0,null,1.9488436459953913,0,0,0,0,0,0,0,0,0,null,2.3844810966406143,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0.87368406114633312,0,0,0,0,0,0,0,0,0,null,0.70946148709604784,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,53.786637602085285,0,0,0,0,0,0,0,0,0]
[null,"PM Management and knowledge dissemination","PM Labour","WorkStream 5",null,null,251.63,0,0,0,0,0,0,0,0,0,null,6.841259382931672E-2,null,null,1.5936418623480778E-2,1.3632675032515437E-2,null,null,null,null,0.90201831251468712,1,null,17.214660985270967,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,4.0100810182264679,0,0,0,0,0,0,0,0,0,null,3.4303900184318592,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,226.97486797807071,0,0,0,0,0,0,0,0,0]
[null,"PM Management and knowledge dissemination","Knowledge transfer and dissemination","WorkStream 5",null,null,111.45,0,66,0,0,0,0,0,0,15,"Total Cost",6.841259382931672E-2,3.0409107017677257E-2,3.7206648670031039E-2,null,1.3632675032515437E-2,null,null,null,null,0.85033897545045956,{"$f":"SUM(R21:AA21)","v":1},null,7.6245835822773484,0,4.5152311927349036,0,0,0,0,0,0,1.0261889074397508,null,3.3890949771201302,0,2.0070010631666988,0,0,0,0,0,0,0.45613660526515887,null,4.1466809942749592,0,2.4556388122220487,0,0,0,0,0,0,0.55809973005046554,null,0,0,0,0,0,0,0,0,0,0,null,1.5193616323738455,0,0.8997565521460188,0,0,0,0,0,0,0.20449012548773154,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,94.770278813953723,0,56.122372379730329,0,0,0,0,0,0,12.755084631756894]
[null,"Total",null,null,null,null,{"$f":"SUM(G7:G21)","v":1194.655},{"$f":"SUM(H7:H21)","v":0},136,0,0,0,75,215,0,15,{"$f":"SUM(G22:P22)","v":1635.655},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AD7:AD21)","v":60.656658066887076},{"$f":"SUM(AE7:AE21)","v":0},9.3041127607870742,0,0,0,1.0261889074397508,10.603952043544092,0,1.0261889074397508,null,{"$f":"SUM(AO7:AO21)","v":21.878972385381065},{"$f":"SUM(AP7:AP21)","v":0},2.6151832035202438,0,0,0,1.8245464210606355,1.8245464210606355,0,0.45613660526515887,null,{"$f":"SUM(AZ7:AZ21)","v":15.309140678392646},{"$f":"SUM(BA7:BA21)","v":0},3.1997717856226693,0,0,0,0,0,0,0.55809973005046554,null,{"$f":"SUM(BK7:BK21)","v":5.8575103471534771},{"$f":"SUM(BL7:BL21)","v":0},0.31872837246961555,0,0,0,0,0,0,0,null,{"$f":"SUM(BV7:BV21)","v":10.16373862542914},{"$f":"SUM(BW7:BW21)","v":0},1.8540438044220995,0,0,0,0.20449012548773154,2.0449012548773156,0,0.20449012548773154,null,{"$f":"SUM(CG7:CG21)","v":0.72924947083990088},{"$f":"SUM(CH7:CH21)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(CR7:CR21)","v":0},{"$f":"SUM(CS7:CS21)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(DC7:DC21)","v":0},{"$f":"SUM(DD7:DD21)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(DN7:DN21)","v":0},{"$f":"SUM(DO7:DO21)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(DY7:DY21)","v":1080.0597304259168},{"$f":"SUM(DZ7:DZ21)","v":0},118.70816007317831,0,0,0,71.944774546011871,200.52660028051795,0,12.755084631756894]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Totals"]

{"sheet":"2025-2026","index":8,"n_rows":268,"n_cols":138,"rows_kept":268,"cut":false,"hidden":false,"merged":[[3,117,3,126],[3,128,3,137],[3,6,3,15],[3,17,3,27],[3,29,3,38],[3,40,3,49],[3,51,3,60],[3,106,3,115],[3,62,3,71],[3,73,3,82],[3,84,3,93],[3,95,3,104]]}
[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,null,null,"Licensee Compulsory Contribution/Direct Benefits",null,null,null,null,null,null,null,null,null,null,"Guidehouse",null,null,null,null,null,null,null,null,null,null,"Octopus Energy",null,null,null,null,null,null,null,null,null,null,"Passiv ",null,null,null,null,null,null,null,null,null,null,"SERO",null,null,null,null,null,null,null,null,null,null,"SP Energy Networks",null,null,null,null,null,null,null,null,null,null,"Welsh Government",null,null,null,null,null,null,null,null,null,null,"West Midlands Combined Authority",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","Guidehouse","Octopus Energy","Passiv Systems","SERO","SP Energy Networks","Welsh Government","West Midlands Combined Authority#","Licensee Extra Contribution","Oustanding Funding Required","Total",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other"]
[null,"Description","Task","Project Workstream"]
[null,"Commercial Arrangements","Design M1 & M2","Workstream 1",null,null,10.725,0,0,0,0,0,0,0,0,0,null,5.0510101877289382E-2,null,null,null,null,null,null,null,null,0.94948989812271067,{"$f":"SUM(R7:AA7)","v":1},null,{"$f":"$R7*G7","v":0.54172084263392861},{"$f":"$R7*H7","v":0},{"$f":"$R7*I7","v":0},0,0,0,0,0,0,0,null,{"$f":"$S7*G7","v":0},{"$f":"$S7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$T7*G7","v":0},{"$f":"$T7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$U7*G7","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$V7*G7","v":0},{"$f":"$V7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$W7*G7","v":0},{"$f":"$W7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$X7*G7","v":0},{"$f":"$X7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$Y7*G7","v":0},{"$f":"$Y7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$Z7*G7","v":0},{"$f":"$Z7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$AA7*G7","v":10.183279157366071},{"$f":"$AA7*H7","v":0},0,0,0,0,0,0,0,{"$f":"$AA7*P7","v":0}]
[null,"Commercial Arrangements","Refine M1 & M2 & Design M3","Workstream 1",null,null,0,0,0,0,0,0,0,0,0,0,null,5.0510101877289382E-2,null,null,null,null,null,null,null,null,0.94948989812271067,{"$f":"SUM(R8:AA8)","v":1},null,{"$f":"$R8*G8","v":0},{"$f":"$R8*H8","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$S8*G8","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$T8*G8","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$U8*G8","v":0},{"$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},0,0,0,0,0,0,0,0,0,null,{"$f":"$W8*G8","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$X8*G8","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$Y8*G8","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$Z8*G8","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$AA8*G8","v":0},0,0,0,0,0,0,0,0,0]
[null,"Commercial Arrangements","Refine M1 & M2 & refine M3","Workstream 1",null,null,25.725000000000001,0,0,0,0,0,0,5,0,0,null,5.0510101877289382E-2,null,null,null,null,null,null,null,null,0.94948989812271067,1,null,1.2993723707932694,0,0,0,0,0,0,0.25255050938644691,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,24.425627629206733,0,0,0,0,0,0,4.7474494906135529,0,0]
[null,"Integration and automation","Overall integration planning","Workstream 2",null,null,84,0,0,0,0,0,0,0,0,0,null,5.0510101877289382E-2,null,null,null,null,null,null,null,null,0.94948989812271067,1,null,4.2428485576923078,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,79.757151442307702,0,0,0,0,0,0,0,0,0]
[null,"Integration and automation","Integration delivery and testing","Workstream 2",null,null,25.024999999999999,0,0,0,0,0,0,0,0,0,null,5.0510101877289382E-2,null,null,null,null,null,null,null,null,0.94948989812271067,1,null,1.2640152994791667,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,23.760984700520833,0,0,0,0,0,0,0,0,0]
[null,"Customer Engagement and Experience","Engagement design","WorkStream 3",null,null,10.725,0,0,0,0,0,0,0,0,0,null,5.0510101877289382E-2,null,null,null,null,null,null,null,null,0.94948989812271067,1,null,0.54172084263392861,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,10.183279157366071,0,0,0,0,0,0,0,0,0]
[null,"Customer Engagement and Experience","Engagement materials","WorkStream 3",null,null,0,0,0,0,0,0,0,0,0,0,null,5.0510101877289382E-2,null,null,null,null,null,null,null,null,0.94948989812271067,1,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0]
[null,"Customer Engagement and Experience","Engagement surveys and focus groups","WorkStream 3",null,null,33.75,0,0,0,0,0,0,15,0,0,null,5.0510101877289382E-2,null,null,null,null,null,null,null,null,0.94948989812271067,1,null,1.7047159383585166,0,0,0,0,0,0,0.75765152815934078,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,32.045284061641482,0,0,0,0,0,0,14.242348471840661,0,0]
[null,"Customer Engagement and Experience","Engagement primary research","WorkStream 3",null,null,0,0,50,0,0,0,0,0,0,0,null,5.0510101877289382E-2,null,null,null,null,null,null,null,null,0.94948989812271067,1,null,0,0,2.525505093864469,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,47.474494906135533,0,0,0,0,0,0,0]
[null,"Trials","Overal Trial Design","Workstream 4",null,null,33.575000000000003,0,0,0,0,0,0,0,0,0,null,5.0510101877289382E-2,null,null,null,null,null,null,null,null,0.94948989812271067,1,null,1.695876670529991,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,31.879123329470012,0,0,0,0,0,0,0,0,0]
[null,"Trials","Simulation modelling","Workstream 4",null,null,36,0,30,0,0,0,0,0,0,0,null,5.0510101877289382E-2,null,null,null,null,null,null,null,null,0.94948989812271067,1,null,1.8183636675824177,0,1.5153030563186816,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,34.181636332417582,0,28.484696943681321,0,0,0,0,0,0,0]
[null,"Trials","Trial delivery and analysis ","Workstream 4",null,null,126.45,0,0,0,0,0,0,0,0,0,null,5.0510101877289382E-2,null,null,null,null,null,null,null,null,0.94948989812271067,1,null,6.3870023823832422,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,120.06299761761677,0,0,0,0,0,0,0,0,0]
[null,"Trials","Business case update and transistion","Workstream 4",null,null,95.325000000000003,0,0,0,0,0,0,0,0,0,null,5.0510101877289382E-2,null,null,null,null,null,null,null,null,0.94948989812271067,1,null,4.8148754614526101,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,90.510124538547402,0,0,0,0,0,0,0,0,0]
[null,"PM Management and knowledge dissemination","PM Labour","WorkStream 5",null,null,165.48500000000001,0,0,0,0,0,0,0,0,0,"Total Cost",5.0510101877289382E-2,null,null,null,null,null,null,null,null,0.94948989812271067,1,null,8.3586642091632335,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,157.12633579083678,0,0,0,0,0,0,0,0,0]
[null,"PM Management and knowledge dissemination","Knowledge transfer and dissemination","WorkStream 5",null,null,109.325,0,66,0,0,0,0,0,0,20,null,5.0510101877289382E-2,null,null,null,null,null,null,null,null,0.94948989812271067,1,null,5.5220168877346616,0,3.3336667239010991,0,0,0,0,0,0,1.0102020375457876,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,103.80298311226535,0,62.666333276098904,0,0,0,0,0,0,18.989797962454212]
[null,"Total",null,null,null,null,{"$f":"SUM(G7:G21)","v":756.11},{"$f":"SUM(H7:H21)","v":0},146,0,0,0,0,20,0,20,{"$f":"SUM(G22:P22)","v":942.11},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AD7:AD21)","v":38.19119313043727},{"$f":"SUM(AE7:AE21)","v":0},7.3744748740842496,0,0,0,0,1.0102020375457876,0,1.0102020375457876,null,{"$f":"SUM(AO7:AO21)","v":0},{"$f":"SUM(AP7:AP21)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(AZ7:AZ21)","v":0},{"$f":"SUM(BA7:BA21)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(BK7:BK21)","v":0},{"$f":"SUM(BL7:BL21)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(BV7:BV21)","v":0},{"$f":"SUM(BW7:BW21)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(CG7:CG21)","v":0},{"$f":"SUM(CH7:CH21)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(CR7:CR21)","v":0},{"$f":"SUM(CS7:CS21)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(DC7:DC21)","v":0},{"$f":"SUM(DD7:DD21)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(DN7:DN21)","v":0},{"$f":"SUM(DO7:DO21)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(DY7:DY21)","v":717.91880686956279},{"$f":"SUM(DZ7:DZ21)","v":0},138.62552512591574,0,0,0,0,18.989797962454212,0,18.989797962454212]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Totals"]

{"sheet":"2026-2027","index":9,"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,"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":"2028-2029","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 2028-2029"]
[]
[]
[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},{"$f":"$R7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$S7*G7","v":0},{"$f":"$S7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$T7*G7","v":0},{"$f":"$T7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$U7*G7","v":0},{"$f":"$U7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$V7*G7","v":0},{"$f":"$V7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$W7*G7","v":0},{"$f":"$W7*H7","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Cost",null,null,null,null,null,null,{"$f":"SUM(R8:W8)","v":0},null,{"$f":"$R8*G8","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$S8*G8","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$T8*G8","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$U8*G8","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$V8*G8","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$W8*G8","v":0},0,0,0,0,0,0,0,0,0]
[null,"Total",null,null,null,null,{"$f":"SUM(G7:G8)","v":0},{"$f":"SUM(H7:H8)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(G9:P9)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(Z7:Z8)","v":0},{"$f":"SUM(AA7:AA8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(AK7:AK8)","v":0},{"$f":"SUM(AL7:AL8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(AV7:AV8)","v":0},{"$f":"SUM(AW7:AW8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(BG7:BG8)","v":0},{"$f":"SUM(BH7:BH8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(BR7:BR8)","v":0},{"$f":"SUM(BS7:BS8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(CC7:CC8)","v":0},{"$f":"SUM(CD7:CD8)","v":0},0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Totals"]

{"sheet":"2027-2028","index":11,"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 2027-2028"]
[]
[]
[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},{"$f":"$R7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$S7*G7","v":0},{"$f":"$S7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$T7*G7","v":0},{"$f":"$T7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$U7*G7","v":0},{"$f":"$U7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$V7*G7","v":0},{"$f":"$V7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$W7*G7","v":0},{"$f":"$W7*H7","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Cost",null,null,null,null,null,null,{"$f":"SUM(R8:W8)","v":0},null,{"$f":"$R8*G8","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$S8*G8","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$T8*G8","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$U8*G8","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$V8*G8","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$W8*G8","v":0},0,0,0,0,0,0,0,0,0]
[null,"Total",null,null,null,null,{"$f":"SUM(G7:G8)","v":0},{"$f":"SUM(H7:H8)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(G9:P9)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(Z7:Z8)","v":0},{"$f":"SUM(AA7:AA8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(AK7:AK8)","v":0},{"$f":"SUM(AL7:AL8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(AV7:AV8)","v":0},{"$f":"SUM(AW7:AW8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(BG7:BG8)","v":0},{"$f":"SUM(BH7:BH8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(BR7:BR8)","v":0},{"$f":"SUM(BS7:BS8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(CC7:CC8)","v":0},{"$f":"SUM(CD7:CD8)","v":0},0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Totals"]

{"sheet":"Whole project","index":12,"n_rows":268,"n_cols":138,"rows_kept":268,"cut":false,"hidden":false,"merged":[[3,128,3,137],[3,117,3,126],[3,6,3,15],[3,17,3,27],[3,29,3,38],[3,40,3,49],[3,51,3,60],[3,106,3,115],[3,62,3,71],[3,73,3,82],[3,84,3,93],[3,95,3,104]]}
[null,"Whole Project"]
[]
[]
[null,null,null,null,null,null,"Total Cost £K",null,null,null,null,null,null,null,null,null,null,"Funding source %",null,null,null,null,null,null,null,null,null,null,null,"Licensee Compulsory Contribution/Direct Benefits",null,null,null,null,null,null,null,null,null,null,"Guidehouse",null,null,null,null,null,null,null,null,null,null,"Octopus Energy",null,null,null,null,null,null,null,null,null,null,"Passiv",null,null,null,null,null,null,null,null,null,null,"SERO",null,null,null,null,null,null,null,null,null,null,"SP Energy Networks",null,null,null,null,null,null,null,null,null,null,"Welsh Government",null,null,null,null,null,null,null,null,null,null,"West Midlands Combined Authority",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","Guidehouse\t\t\t\t\t\t\t\t\t","Octopus Energy\t\t\t\t\t\t\t\t\t","Passivc Systems\t\t\t\t\t\t\t\t\t","SERO\t\t\t\t\t\t\t\t\t","SP Energy Networks\t\t\t\t\t\t\t\t\t","Welsh Government","West Midlands Combined Authority","Licensee Extra Contribution","Oustanding Funding Required","Total",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other"]
[null,"Description","Task","Project Workstream"]
[null,"Commercial Arrangements","Design M1 & M2","Workstream 1",null,null,{"$f":"'2021-2022'!G7+'2022-2023'!G7+'2023-2024'!G7+'2024-2025'!G7+'2025-2026'!G7+'2026-2027'!G7+'2027-2028'!G7+'2028-2029'!G7","v":95.079999999999984},{"$f":"'2021-2022'!H7+'2022-2023'!H7+'2023-2024'!H7+'2024-2025'!H7+'2025-2026'!H7+'2026-2027'!H7+'2027-2028'!H7+'2028-2029'!H7","v":0},{"$f":"'2021-2022'!I7+'2022-2023'!I7+'2023-2024'!I7+'2024-2025'!I7+'2025-2026'!I7+'2026-2027'!I7+'2027-2028'!I7+'2028-2029'!I7","v":0},{"$f":"'2021-2022'!J7+'2022-2023'!J7+'2023-2024'!J7+'2024-2025'!J7+'2025-2026'!J7+'2026-2027'!J7+'2027-2028'!J7+'2028-2029'!J7","v":0},{"$f":"'2021-2022'!K7+'2022-2023'!K7+'2023-2024'!K7+'2024-2025'!K7+'2025-2026'!K7+'2026-2027'!K7+'2027-2028'!K7+'2028-2029'!K7","v":0},{"$f":"'2021-2022'!L7+'2022-2023'!L7+'2023-2024'!L7+'2024-2025'!L7+'2025-2026'!L7+'2026-2027'!L7+'2027-2028'!L7+'2028-2029'!L7","v":0},{"$f":"'2021-2022'!M7+'2022-2023'!M7+'2023-2024'!M7+'2024-2025'!M7+'2025-2026'!M7+'2026-2027'!M7+'2027-2028'!M7+'2028-2029'!M7","v":0},{"$f":"'2021-2022'!N7+'2022-2023'!N7+'2023-2024'!N7+'2024-2025'!N7+'2025-2026'!N7+'2026-2027'!N7+'2027-2028'!N7+'2028-2029'!N7","v":14},{"$f":"'2021-2022'!O7+'2022-2023'!O7+'2023-2024'!O7+'2024-2025'!O7+'2025-2026'!O7+'2026-2027'!O7+'2027-2028'!O7+'2028-2029'!O7","v":0},{"$f":"'2021-2022'!P7+'2022-2023'!P7+'2023-2024'!P7+'2024-2025'!P7+'2025-2026'!P7+'2026-2027'!P7+'2027-2028'!P7+'2028-2029'!P7","v":0},null,0.11241489570358554,null,null,null,null,1.7068739141390697E-2,null,null,null,0.87051636515502373,{"$f":"SUM(R7:AA7)","v":1},null,{"$f":"$R7*G7","v":10.68840828349691},{"$f":"$R7*H7","v":0},0,0,0,0,0,1.5738085398501975,0,0,null,{"$f":"$S7*G7","v":0},{"$f":"$S7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$T7*G7","v":0},{"$f":"$T7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$U7*G7","v":0},{"$f":"$U7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$Z7*G7","v":0},{"$f":"$Z7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$AA7*G7","v":82.768695998939648},0,0,0,0,0,0,12.187229112170332,0,0,null,{"$f":"$AB7*G7","v":95.079999999999984},0,0,0,0,0,0,14,0,0,null,{"$f":"$AC7*G7","v":0},{"$f":"$AC7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$Z7*G7","v":0},{"$f":"$Z7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$AA7*G7","v":82.768695998939648},{"$f":"$AA7*H7","v":0},0,0,0,0,0,12.187229112170332,0,0]
[null,"Commercial Arrangements","Refine M1 & M2 & Design M3","Workstream 1",null,null,{"$f":"'2021-2022'!G8+'2022-2023'!G8+'2023-2024'!G8+'2024-2025'!G8+'2025-2026'!G8+'2026-2027'!G8+'2027-2028'!G8+'2028-2029'!G8","v":179.20500000000001},{"$f":"'2021-2022'!H8+'2022-2023'!H8+'2023-2024'!H8+'2024-2025'!H8+'2025-2026'!H8+'2026-2027'!H8+'2027-2028'!H8+'2028-2029'!H8","v":0},{"$f":"'2021-2022'!I8+'2022-2023'!I8+'2023-2024'!I8+'2024-2025'!I8+'2025-2026'!I8+'2026-2027'!I8+'2027-2028'!I8+'2028-2029'!I8","v":0},{"$f":"'2021-2022'!J8+'2022-2023'!J8+'2023-2024'!J8+'2024-2025'!J8+'2025-2026'!J8+'2026-2027'!J8+'2027-2028'!J8+'2028-2029'!J8","v":0},{"$f":"'2021-2022'!K8+'2022-2023'!K8+'2023-2024'!K8+'2024-2025'!K8+'2025-2026'!K8+'2026-2027'!K8+'2027-2028'!K8+'2028-2029'!K8","v":0},{"$f":"'2021-2022'!L8+'2022-2023'!L8+'2023-2024'!L8+'2024-2025'!L8+'2025-2026'!L8+'2026-2027'!L8+'2027-2028'!L8+'2028-2029'!L8","v":0},{"$f":"'2021-2022'!M8+'2022-2023'!M8+'2023-2024'!M8+'2024-2025'!M8+'2025-2026'!M8+'2026-2027'!M8+'2027-2028'!M8+'2028-2029'!M8","v":0},{"$f":"'2021-2022'!N8+'2022-2023'!N8+'2023-2024'!N8+'2024-2025'!N8+'2025-2026'!N8+'2026-2027'!N8+'2027-2028'!N8+'2028-2029'!N8","v":5},{"$f":"'2021-2022'!O8+'2022-2023'!O8+'2023-2024'!O8+'2024-2025'!O8+'2025-2026'!O8+'2026-2027'!O8+'2027-2028'!O8+'2028-2029'!O8","v":0},{"$f":"'2021-2022'!P8+'2022-2023'!P8+'2023-2024'!P8+'2024-2025'!P8+'2025-2026'!P8+'2026-2027'!P8+'2027-2028'!P8+'2028-2029'!P8","v":0},null,0.11241489570358554,null,3.6500982218109906E-2,null,2.1971593499711804E-2,null,null,null,null,0.82911252857859274,{"$f":"SUM(R8:AA8)","v":1},null,{"$f":"$R8*G8","v":20.145311384561047},{"$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.56207447851792769},{"$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":6.5411585183963865},{"$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.18250491109054953},{"$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":"$Z8*G8","v":0},{"$f":"$Z8*H8","v":0},{"$f":"$Z8*I8","v":0},{"$f":"$Z8*J8","v":0},{"$f":"$Z8*K8","v":0},{"$f":"$Z8*L8","v":0},{"$f":"$Z8*M8","v":0},{"$f":"$Z8*N8","v":0},{"$f":"$Z8*O8","v":0},{"$f":"$Z8*P8","v":0},null,{"$f":"$AA8*G8","v":148.58111068392671},{"$f":"$AA8*H8","v":0},{"$f":"$AA8*I8","v":0},{"$f":"$AA8*J8","v":0},{"$f":"$AA8*K8","v":0},{"$f":"$AA8*L8","v":0},{"$f":"$AA8*M8","v":0},{"$f":"$AA8*N8","v":4.1455626428929637},{"$f":"$AA8*O8","v":0},{"$f":"$AA8*P8","v":0},null,{"$f":"$AB8*G8","v":179.20500000000001},{"$f":"$AB8*H8","v":0},{"$f":"$AB8*I8","v":0},{"$f":"$AB8*J8","v":0},{"$f":"$AB8*K8","v":0},{"$f":"$AB8*L8","v":0},{"$f":"$AB8*M8","v":0},{"$f":"$AB8*N8","v":5},{"$f":"$AB8*O8","v":0},{"$f":"$AB8*P8","v":0},null,{"$f":"$AC8*G8","v":0},{"$f":"$AC8*H8","v":0},{"$f":"$AC8*I8","v":0},{"$f":"$AC8*J8","v":0},{"$f":"$AC8*K8","v":0},{"$f":"$AC8*L8","v":0},{"$f":"$AC8*M8","v":0},{"$f":"$AC8*N8","v":0},{"$f":"$AC8*O8","v":0},{"$f":"$AC8*P8","v":0},null,{"$f":"$Z8*G8","v":0},{"$f":"$Z8*H8","v":0},{"$f":"$Z8*I8","v":0},{"$f":"$Z8*J8","v":0},{"$f":"$Z8*K8","v":0},{"$f":"$Z8*L8","v":0},{"$f":"$Z8*M8","v":0},{"$f":"$Z8*N8","v":0},{"$f":"$Z8*O8","v":0},{"$f":"$Z8*P8","v":0},null,{"$f":"$AA8*G8","v":148.58111068392671},{"$f":"$AA8*H8","v":0},{"$f":"$AA8*I8","v":0},{"$f":"$AA8*J8","v":0},{"$f":"$AA8*K8","v":0},{"$f":"$AA8*L8","v":0},{"$f":"$AA8*M8","v":0},{"$f":"$AA8*N8","v":4.1455626428929637},{"$f":"$AA8*O8","v":0},{"$f":"$AA8*P8","v":0}]
[null,"Commercial Arrangements","Refine M1 & M2 & refine M3","Workstream 1",null,null,{"$f":"'2021-2022'!G9+'2022-2023'!G9+'2023-2024'!G9+'2024-2025'!G9+'2025-2026'!G9+'2026-2027'!G9+'2027-2028'!G9+'2028-2029'!G9","v":275.005},{"$f":"'2021-2022'!H9+'2022-2023'!H9+'2023-2024'!H9+'2024-2025'!H9+'2025-2026'!H9+'2026-2027'!H9+'2027-2028'!H9+'2028-2029'!H9","v":0},{"$f":"'2021-2022'!I9+'2022-2023'!I9+'2023-2024'!I9+'2024-2025'!I9+'2025-2026'!I9+'2026-2027'!I9+'2027-2028'!I9+'2028-2029'!I9","v":0},{"$f":"'2021-2022'!J9+'2022-2023'!J9+'2023-2024'!J9+'2024-2025'!J9+'2025-2026'!J9+'2026-2027'!J9+'2027-2028'!J9+'2028-2029'!J9","v":0},{"$f":"'2021-2022'!K9+'2022-2023'!K9+'2023-2024'!K9+'2024-2025'!K9+'2025-2026'!K9+'2026-2027'!K9+'2027-2028'!K9+'2028-2029'!K9","v":0},{"$f":"'2021-2022'!L9+'2022-2023'!L9+'2023-2024'!L9+'2024-2025'!L9+'2025-2026'!L9+'2026-2027'!L9+'2027-2028'!L9+'2028-2029'!L9","v":0},{"$f":"'2021-2022'!M9+'2022-2023'!M9+'2023-2024'!M9+'2024-2025'!M9+'2025-2026'!M9+'2026-2027'!M9+'2027-2028'!M9+'2028-2029'!M9","v":0},{"$f":"'2021-2022'!N9+'2022-2023'!N9+'2023-2024'!N9+'2024-2025'!N9+'2025-2026'!N9+'2026-2027'!N9+'2027-2028'!N9+'2028-2029'!N9","v":10},{"$f":"'2021-2022'!O9+'2022-2023'!O9+'2023-2024'!O9+'2024-2025'!O9+'2025-2026'!O9+'2026-2027'!O9+'2027-2028'!O9+'2028-2029'!O9","v":0},{"$f":"'2021-2022'!P9+'2022-2023'!P9+'2023-2024'!P9+'2024-2025'!P9+'2025-2026'!P9+'2026-2027'!P9+'2027-2028'!P9+'2028-2029'!P9","v":0},null,0.11241489570358554,0.13126508405459389,null,null,2.1971593499711804E-2,null,null,null,null,0.73434842674210876,{"$f":"SUM(R9:AA9)","v":1},null,30.91465839296454,0,0,0,0,0,0,1.1241489570358554,0,0,null,36.098554440433595,0,0,0,0,0,0,1.3126508405459389,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,201.94948909621363,0,0,0,0,0,0,7.3434842674210881,0,0,null,275.005,0,0,0,0,0,0,10,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,201.94948909621363,0,0,0,0,0,0,7.3434842674210881,0,0]
[null,"Integration and automation","Overall integration planning","Workstream 2",null,null,{"$f":"'2021-2022'!G10+'2022-2023'!G10+'2023-2024'!G10+'2024-2025'!G10+'2025-2026'!G10+'2026-2027'!G10+'2027-2028'!G10+'2028-2029'!G10","v":521.95499999999993},{"$f":"'2021-2022'!H10+'2022-2023'!H10+'2023-2024'!H10+'2024-2025'!H10+'2025-2026'!H10+'2026-2027'!H10+'2027-2028'!H10+'2028-2029'!H10","v":0},{"$f":"'2021-2022'!I10+'2022-2023'!I10+'2023-2024'!I10+'2024-2025'!I10+'2025-2026'!I10+'2026-2027'!I10+'2027-2028'!I10+'2028-2029'!I10","v":0},{"$f":"'2021-2022'!J10+'2022-2023'!J10+'2023-2024'!J10+'2024-2025'!J10+'2025-2026'!J10+'2026-2027'!J10+'2027-2028'!J10+'2028-2029'!J10","v":0},{"$f":"'2021-2022'!K10+'2022-2023'!K10+'2023-2024'!K10+'2024-2025'!K10+'2025-2026'!K10+'2026-2027'!K10+'2027-2028'!K10+'2028-2029'!K10","v":0},{"$f":"'2021-2022'!L10+'2022-2023'!L10+'2023-2024'!L10+'2024-2025'!L10+'2025-2026'!L10+'2026-2027'!L10+'2027-2028'!L10+'2028-2029'!L10","v":0},{"$f":"'2021-2022'!M10+'2022-2023'!M10+'2023-2024'!M10+'2024-2025'!M10+'2025-2026'!M10+'2026-2027'!M10+'2027-2028'!M10+'2028-2029'!M10","v":0},{"$f":"'2021-2022'!N10+'2022-2023'!N10+'2023-2024'!N10+'2024-2025'!N10+'2025-2026'!N10+'2026-2027'!N10+'2027-2028'!N10+'2028-2029'!N10","v":150},{"$f":"'2021-2022'!O10+'2022-2023'!O10+'2023-2024'!O10+'2024-2025'!O10+'2025-2026'!O10+'2026-2027'!O10+'2027-2028'!O10+'2028-2029'!O10","v":0},{"$f":"'2021-2022'!P10+'2022-2023'!P10+'2023-2024'!P10+'2024-2025'!P10+'2025-2026'!P10+'2026-2027'!P10+'2027-2028'!P10+'2028-2029'!P10","v":0},null,0.11241489570358554,null,null,null,2.1971593499711804E-2,null,null,null,null,0.86561351079670268,1,null,58.675516886964978,0,0,0,0,0,0,16.862234355537829,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,451.81130002789286,0,0,0,0,0,0,129.84202661950539,0,0,null,521.95499999999993,0,0,0,0,0,0,150,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,451.81130002789286,0,0,0,0,0,0,129.84202661950539,0,0]
[null,"Integration and automation","Integration delivery and testing","Workstream 2",null,null,{"$f":"'2021-2022'!G11+'2022-2023'!G11+'2023-2024'!G11+'2024-2025'!G11+'2025-2026'!G11+'2026-2027'!G11+'2027-2028'!G11+'2028-2029'!G11","v":855.80000000000007},{"$f":"'2021-2022'!H11+'2022-2023'!H11+'2023-2024'!H11+'2024-2025'!H11+'2025-2026'!H11+'2026-2027'!H11+'2027-2028'!H11+'2028-2029'!H11","v":0},{"$f":"'2021-2022'!I11+'2022-2023'!I11+'2023-2024'!I11+'2024-2025'!I11+'2025-2026'!I11+'2026-2027'!I11+'2027-2028'!I11+'2028-2029'!I11","v":0},{"$f":"'2021-2022'!J11+'2022-2023'!J11+'2023-2024'!J11+'2024-2025'!J11+'2025-2026'!J11+'2026-2027'!J11+'2027-2028'!J11+'2028-2029'!J11","v":250},{"$f":"'2021-2022'!K11+'2022-2023'!K11+'2023-2024'!K11+'2024-2025'!K11+'2025-2026'!K11+'2026-2027'!K11+'2027-2028'!K11+'2028-2029'!K11","v":0},{"$f":"'2021-2022'!L11+'2022-2023'!L11+'2023-2024'!L11+'2024-2025'!L11+'2025-2026'!L11+'2026-2027'!L11+'2027-2028'!L11+'2028-2029'!L11","v":0},{"$f":"'2021-2022'!M11+'2022-2023'!M11+'2023-2024'!M11+'2024-2025'!M11+'2025-2026'!M11+'2026-2027'!M11+'2027-2028'!M11+'2028-2029'!M11","v":0},{"$f":"'2021-2022'!N11+'2022-2023'!N11+'2023-2024'!N11+'2024-2025'!N11+'2025-2026'!N11+'2026-2027'!N11+'2027-2028'!N11+'2028-2029'!N11","v":1073.5999999999999},{"$f":"'2021-2022'!O11+'2022-2023'!O11+'2023-2024'!O11+'2024-2025'!O11+'2025-2026'!O11+'2026-2027'!O11+'2027-2028'!O11+'2028-2029'!O11","v":0},{"$f":"'2021-2022'!P11+'2022-2023'!P11+'2023-2024'!P11+'2024-2025'!P11+'2025-2026'!P11+'2026-2027'!P11+'2027-2028'!P11+'2028-2029'!P11","v":0},null,0.11241489570358554,null,3.6500982218109906E-2,null,2.1971593499711804E-2,null,null,null,null,0.82911252857859274,1,null,96.20466774312851,0,0,28.103723925896386,0,0,0,120.68863202736942,0,0,null,0,0,0,0,0,0,0,0,0,0,null,31.237540582258461,0,0,9.125245554527476,0,0,0,39.187454509362794,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,709.55450195755975,0,0,207.2781321446482,0,0,0,890.13521068197713,0,0,null,855.80000000000007,0,0,250,0,0,0,1073.5999999999999,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,709.55450195755975,0,0,207.2781321446482,0,0,0,890.13521068197713,0,0]
[null,"Customer Engagement and Experience","Engagement design","WorkStream 3",null,null,{"$f":"'2021-2022'!G12+'2022-2023'!G12+'2023-2024'!G12+'2024-2025'!G12+'2025-2026'!G12+'2026-2027'!G12+'2027-2028'!G12+'2028-2029'!G12","v":61.13},{"$f":"'2021-2022'!H12+'2022-2023'!H12+'2023-2024'!H12+'2024-2025'!H12+'2025-2026'!H12+'2026-2027'!H12+'2027-2028'!H12+'2028-2029'!H12","v":0},{"$f":"'2021-2022'!I12+'2022-2023'!I12+'2023-2024'!I12+'2024-2025'!I12+'2025-2026'!I12+'2026-2027'!I12+'2027-2028'!I12+'2028-2029'!I12","v":0},{"$f":"'2021-2022'!J12+'2022-2023'!J12+'2023-2024'!J12+'2024-2025'!J12+'2025-2026'!J12+'2026-2027'!J12+'2027-2028'!J12+'2028-2029'!J12","v":0},{"$f":"'2021-2022'!K12+'2022-2023'!K12+'2023-2024'!K12+'2024-2025'!K12+'2025-2026'!K12+'2026-2027'!K12+'2027-2028'!K12+'2028-2029'!K12","v":0},{"$f":"'2021-2022'!L12+'2022-2023'!L12+'2023-2024'!L12+'2024-2025'!L12+'2025-2026'!L12+'2026-2027'!L12+'2027-2028'!L12+'2028-2029'!L12","v":0},{"$f":"'2021-2022'!M12+'2022-2023'!M12+'2023-2024'!M12+'2024-2025'!M12+'2025-2026'!M12+'2026-2027'!M12+'2027-2028'!M12+'2028-2029'!M12","v":0},{"$f":"'2021-2022'!N12+'2022-2023'!N12+'2023-2024'!N12+'2024-2025'!N12+'2025-2026'!N12+'2026-2027'!N12+'2027-2028'!N12+'2028-2029'!N12","v":0},{"$f":"'2021-2022'!O12+'2022-2023'!O12+'2023-2024'!O12+'2024-2025'!O12+'2025-2026'!O12+'2026-2027'!O12+'2027-2028'!O12+'2028-2029'!O12","v":0},{"$f":"'2021-2022'!P12+'2022-2023'!P12+'2023-2024'!P12+'2024-2025'!P12+'2025-2026'!P12+'2026-2027'!P12+'2027-2028'!P12+'2028-2029'!P12","v":0},null,0.11241489570358554,null,null,null,2.1971593499711804E-2,null,null,null,null,0.86561351079670268,1,null,6.8719225743601839,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,52.914953915002435,0,0,0,0,0,0,0,0,0,null,61.13,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,52.914953915002435,0,0,0,0,0,0,0,0,0]
[null,"Customer Engagement and Experience","Engagement materials","WorkStream 3",null,null,{"$f":"'2021-2022'!G13+'2022-2023'!G13+'2023-2024'!G13+'2024-2025'!G13+'2025-2026'!G13+'2026-2027'!G13+'2027-2028'!G13+'2028-2029'!G13","v":75.75},{"$f":"'2021-2022'!H13+'2022-2023'!H13+'2023-2024'!H13+'2024-2025'!H13+'2025-2026'!H13+'2026-2027'!H13+'2027-2028'!H13+'2028-2029'!H13","v":0},{"$f":"'2021-2022'!I13+'2022-2023'!I13+'2023-2024'!I13+'2024-2025'!I13+'2025-2026'!I13+'2026-2027'!I13+'2027-2028'!I13+'2028-2029'!I13","v":0},{"$f":"'2021-2022'!J13+'2022-2023'!J13+'2023-2024'!J13+'2024-2025'!J13+'2025-2026'!J13+'2026-2027'!J13+'2027-2028'!J13+'2028-2029'!J13","v":0},{"$f":"'2021-2022'!K13+'2022-2023'!K13+'2023-2024'!K13+'2024-2025'!K13+'2025-2026'!K13+'2026-2027'!K13+'2027-2028'!K13+'2028-2029'!K13","v":0},{"$f":"'2021-2022'!L13+'2022-2023'!L13+'2023-2024'!L13+'2024-2025'!L13+'2025-2026'!L13+'2026-2027'!L13+'2027-2028'!L13+'2028-2029'!L13","v":0},{"$f":"'2021-2022'!M13+'2022-2023'!M13+'2023-2024'!M13+'2024-2025'!M13+'2025-2026'!M13+'2026-2027'!M13+'2027-2028'!M13+'2028-2029'!M13","v":0},{"$f":"'2021-2022'!N13+'2022-2023'!N13+'2023-2024'!N13+'2024-2025'!N13+'2025-2026'!N13+'2026-2027'!N13+'2027-2028'!N13+'2028-2029'!N13","v":0},{"$f":"'2021-2022'!O13+'2022-2023'!O13+'2023-2024'!O13+'2024-2025'!O13+'2025-2026'!O13+'2026-2027'!O13+'2027-2028'!O13+'2028-2029'!O13","v":0},{"$f":"'2021-2022'!P13+'2022-2023'!P13+'2023-2024'!P13+'2024-2025'!P13+'2025-2026'!P13+'2026-2027'!P13+'2027-2028'!P13+'2028-2029'!P13","v":60},null,0.11241489570358554,0.13126508405459389,null,null,2.1971593499711804E-2,null,null,null,null,0.73434842674210876,1,null,8.515428349546605,0,0,0,0,0,0,0,0,6.7448937422151323,null,9.9433301171354866,0,0,0,0,0,0,0,0,7.8759050432756332,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,55.62689332571474,0,0,0,0,0,0,0,0,44.060905604526525,null,75.75,0,0,0,0,0,0,0,0,60,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,55.62689332571474,0,0,0,0,0,0,0,0,44.060905604526525]
[null,"Customer Engagement and Experience","Engagement surveys and focus groups","WorkStream 3",null,null,{"$f":"'2021-2022'!G14+'2022-2023'!G14+'2023-2024'!G14+'2024-2025'!G14+'2025-2026'!G14+'2026-2027'!G14+'2027-2028'!G14+'2028-2029'!G14","v":196.3},{"$f":"'2021-2022'!H14+'2022-2023'!H14+'2023-2024'!H14+'2024-2025'!H14+'2025-2026'!H14+'2026-2027'!H14+'2027-2028'!H14+'2028-2029'!H14","v":0},{"$f":"'2021-2022'!I14+'2022-2023'!I14+'2023-2024'!I14+'2024-2025'!I14+'2025-2026'!I14+'2026-2027'!I14+'2027-2028'!I14+'2028-2029'!I14","v":0},{"$f":"'2021-2022'!J14+'2022-2023'!J14+'2023-2024'!J14+'2024-2025'!J14+'2025-2026'!J14+'2026-2027'!J14+'2027-2028'!J14+'2028-2029'!J14","v":0},{"$f":"'2021-2022'!K14+'2022-2023'!K14+'2023-2024'!K14+'2024-2025'!K14+'2025-2026'!K14+'2026-2027'!K14+'2027-2028'!K14+'2028-2029'!K14","v":0},{"$f":"'2021-2022'!L14+'2022-2023'!L14+'2023-2024'!L14+'2024-2025'!L14+'2025-2026'!L14+'2026-2027'!L14+'2027-2028'!L14+'2028-2029'!L14","v":0},{"$f":"'2021-2022'!M14+'2022-2023'!M14+'2023-2024'!M14+'2024-2025'!M14+'2025-2026'!M14+'2026-2027'!M14+'2027-2028'!M14+'2028-2029'!M14","v":45},{"$f":"'2021-2022'!N14+'2022-2023'!N14+'2023-2024'!N14+'2024-2025'!N14+'2025-2026'!N14+'2026-2027'!N14+'2027-2028'!N14+'2028-2029'!N14","v":15},{"$f":"'2021-2022'!O14+'2022-2023'!O14+'2023-2024'!O14+'2024-2025'!O14+'2025-2026'!O14+'2026-2027'!O14+'2027-2028'!O14+'2028-2029'!O14","v":0},{"$f":"'2021-2022'!P14+'2022-2023'!P14+'2023-2024'!P14+'2024-2025'!P14+'2025-2026'!P14+'2026-2027'!P14+'2027-2028'!P14+'2028-2029'!P14","v":0},null,0.11241489570358554,null,3.6500982218109906E-2,null,2.1971593499711804E-2,null,null,null,null,0.82911252857859274,1,null,22.067044026613843,0,0,0,0,0,5.058670306661349,1.6862234355537831,0,0,null,0,0,0,0,0,0,0,0,0,0,null,7.1651428094149754,0,0,0,0,0,1.6425441998149457,0.54751473327164857,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,162.75478935997776,0,0,0,0,0,37.310063786036672,12.436687928678891,0,0,null,196.3,0,0,0,0,0,45,15,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,162.75478935997776,0,0,0,0,0,37.310063786036672,12.436687928678891,0,0]
[null,"Customer Engagement and Experience","Engagement primary research","WorkStream 3",null,null,{"$f":"'2021-2022'!G15+'2022-2023'!G15+'2023-2024'!G15+'2024-2025'!G15+'2025-2026'!G15+'2026-2027'!G15+'2027-2028'!G15+'2028-2029'!G15","v":53.625},{"$f":"'2021-2022'!H15+'2022-2023'!H15+'2023-2024'!H15+'2024-2025'!H15+'2025-2026'!H15+'2026-2027'!H15+'2027-2028'!H15+'2028-2029'!H15","v":0},{"$f":"'2021-2022'!I15+'2022-2023'!I15+'2023-2024'!I15+'2024-2025'!I15+'2025-2026'!I15+'2026-2027'!I15+'2027-2028'!I15+'2028-2029'!I15","v":200},{"$f":"'2021-2022'!J15+'2022-2023'!J15+'2023-2024'!J15+'2024-2025'!J15+'2025-2026'!J15+'2026-2027'!J15+'2027-2028'!J15+'2028-2029'!J15","v":0},{"$f":"'2021-2022'!K15+'2022-2023'!K15+'2023-2024'!K15+'2024-2025'!K15+'2025-2026'!K15+'2026-2027'!K15+'2027-2028'!K15+'2028-2029'!K15","v":0},{"$f":"'2021-2022'!L15+'2022-2023'!L15+'2023-2024'!L15+'2024-2025'!L15+'2025-2026'!L15+'2026-2027'!L15+'2027-2028'!L15+'2028-2029'!L15","v":0},{"$f":"'2021-2022'!M15+'2022-2023'!M15+'2023-2024'!M15+'2024-2025'!M15+'2025-2026'!M15+'2026-2027'!M15+'2027-2028'!M15+'2028-2029'!M15","v":0},{"$f":"'2021-2022'!N15+'2022-2023'!N15+'2023-2024'!N15+'2024-2025'!N15+'2025-2026'!N15+'2026-2027'!N15+'2027-2028'!N15+'2028-2029'!N15","v":0},{"$f":"'2021-2022'!O15+'2022-2023'!O15+'2023-2024'!O15+'2024-2025'!O15+'2025-2026'!O15+'2026-2027'!O15+'2027-2028'!O15+'2028-2029'!O15","v":0},{"$f":"'2021-2022'!P15+'2022-2023'!P15+'2023-2024'!P15+'2024-2025'!P15+'2025-2026'!P15+'2026-2027'!P15+'2027-2028'!P15+'2028-2029'!P15","v":0},null,0.11241489570358554,null,null,null,2.1971593499711804E-2,null,null,null,null,0.86561351079670268,1,null,6.0282487821047743,0,22.482979140717106,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,46.418524516473184,0,173.12270215934055,0,0,0,0,0,0,0,null,53.625,0,200,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,46.418524516473184,0,173.12270215934055,0,0,0,0,0,0,0]
[null,"Trials","Overal Trial Design","Workstream 4",null,null,{"$f":"'2021-2022'!G16+'2022-2023'!G16+'2023-2024'!G16+'2024-2025'!G16+'2025-2026'!G16+'2026-2027'!G16+'2027-2028'!G16+'2028-2029'!G16","v":303.005},{"$f":"'2021-2022'!H16+'2022-2023'!H16+'2023-2024'!H16+'2024-2025'!H16+'2025-2026'!H16+'2026-2027'!H16+'2027-2028'!H16+'2028-2029'!H16","v":0},{"$f":"'2021-2022'!I16+'2022-2023'!I16+'2023-2024'!I16+'2024-2025'!I16+'2025-2026'!I16+'2026-2027'!I16+'2027-2028'!I16+'2028-2029'!I16","v":0},{"$f":"'2021-2022'!J16+'2022-2023'!J16+'2023-2024'!J16+'2024-2025'!J16+'2025-2026'!J16+'2026-2027'!J16+'2027-2028'!J16+'2028-2029'!J16","v":0},{"$f":"'2021-2022'!K16+'2022-2023'!K16+'2023-2024'!K16+'2024-2025'!K16+'2025-2026'!K16+'2026-2027'!K16+'2027-2028'!K16+'2028-2029'!K16","v":0},{"$f":"'2021-2022'!L16+'2022-2023'!L16+'2023-2024'!L16+'2024-2025'!L16+'2025-2026'!L16+'2026-2027'!L16+'2027-2028'!L16+'2028-2029'!L16","v":0},{"$f":"'2021-2022'!M16+'2022-2023'!M16+'2023-2024'!M16+'2024-2025'!M16+'2025-2026'!M16+'2026-2027'!M16+'2027-2028'!M16+'2028-2029'!M16","v":0},{"$f":"'2021-2022'!N16+'2022-2023'!N16+'2023-2024'!N16+'2024-2025'!N16+'2025-2026'!N16+'2026-2027'!N16+'2027-2028'!N16+'2028-2029'!N16","v":0},{"$f":"'2021-2022'!O16+'2022-2023'!O16+'2023-2024'!O16+'2024-2025'!O16+'2025-2026'!O16+'2026-2027'!O16+'2027-2028'!O16+'2028-2029'!O16","v":0},{"$f":"'2021-2022'!P16+'2022-2023'!P16+'2023-2024'!P16+'2024-2025'!P16+'2025-2026'!P16+'2026-2027'!P16+'2027-2028'!P16+'2028-2029'!P16","v":0},null,0.11241489570358554,null,3.6500982218109906E-2,null,2.1971593499711804E-2,null,null,null,null,0.82911252857859274,1,null,34.062275472664936,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,11.059980116998393,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,251.22524172195648,0,0,0,0,0,0,0,0,0,null,303.005,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,251.22524172195648,0,0,0,0,0,0,0,0,0]
[null,"Trials","Simulation modelling","Workstream 4",null,null,{"$f":"'2021-2022'!G17+'2022-2023'!G17+'2023-2024'!G17+'2024-2025'!G17+'2025-2026'!G17+'2026-2027'!G17+'2027-2028'!G17+'2028-2029'!G17","v":394.5},{"$f":"'2021-2022'!H17+'2022-2023'!H17+'2023-2024'!H17+'2024-2025'!H17+'2025-2026'!H17+'2026-2027'!H17+'2027-2028'!H17+'2028-2029'!H17","v":0},{"$f":"'2021-2022'!I17+'2022-2023'!I17+'2023-2024'!I17+'2024-2025'!I17+'2025-2026'!I17+'2026-2027'!I17+'2027-2028'!I17+'2028-2029'!I17","v":120},{"$f":"'2021-2022'!J17+'2022-2023'!J17+'2023-2024'!J17+'2024-2025'!J17+'2025-2026'!J17+'2026-2027'!J17+'2027-2028'!J17+'2028-2029'!J17","v":0},{"$f":"'2021-2022'!K17+'2022-2023'!K17+'2023-2024'!K17+'2024-2025'!K17+'2025-2026'!K17+'2026-2027'!K17+'2027-2028'!K17+'2028-2029'!K17","v":0},{"$f":"'2021-2022'!L17+'2022-2023'!L17+'2023-2024'!L17+'2024-2025'!L17+'2025-2026'!L17+'2026-2027'!L17+'2027-2028'!L17+'2028-2029'!L17","v":0},{"$f":"'2021-2022'!M17+'2022-2023'!M17+'2023-2024'!M17+'2024-2025'!M17+'2025-2026'!M17+'2026-2027'!M17+'2027-2028'!M17+'2028-2029'!M17","v":0},{"$f":"'2021-2022'!N17+'2022-2023'!N17+'2023-2024'!N17+'2024-2025'!N17+'2025-2026'!N17+'2026-2027'!N17+'2027-2028'!N17+'2028-2029'!N17","v":0},{"$f":"'2021-2022'!O17+'2022-2023'!O17+'2023-2024'!O17+'2024-2025'!O17+'2025-2026'!O17+'2026-2027'!O17+'2027-2028'!O17+'2028-2029'!O17","v":0},{"$f":"'2021-2022'!P17+'2022-2023'!P17+'2023-2024'!P17+'2024-2025'!P17+'2025-2026'!P17+'2026-2027'!P17+'2027-2028'!P17+'2028-2029'!P17","v":0},null,0.11241489570358554,0.13126508405459389,null,3.6782695260431604E-2,2.1971593499711804E-2,null,null,null,null,0.69756573148167722,1,null,44.347676355064493,0,13.489787484430265,0,0,0,0,0,0,0,null,51.784075659537287,0,15.751810086551266,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,14.510773280240267,0,4.4139234312517921,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,275.18968106952167,0,83.707887777801261,0,0,0,0,0,0,0,null,394.5,0,120,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,275.18968106952167,0,83.707887777801261,0,0,0,0,0,0,0]
[null,"Trials","Trial delivery and analysis ","Workstream 4",null,null,{"$f":"'2021-2022'!G18+'2022-2023'!G18+'2023-2024'!G18+'2024-2025'!G18+'2025-2026'!G18+'2026-2027'!G18+'2027-2028'!G18+'2028-2029'!G18","v":1056.925},{"$f":"'2021-2022'!H18+'2022-2023'!H18+'2023-2024'!H18+'2024-2025'!H18+'2025-2026'!H18+'2026-2027'!H18+'2027-2028'!H18+'2028-2029'!H18","v":7000},{"$f":"'2021-2022'!I18+'2022-2023'!I18+'2023-2024'!I18+'2024-2025'!I18+'2025-2026'!I18+'2026-2027'!I18+'2027-2028'!I18+'2028-2029'!I18","v":0},{"$f":"'2021-2022'!J18+'2022-2023'!J18+'2023-2024'!J18+'2024-2025'!J18+'2025-2026'!J18+'2026-2027'!J18+'2027-2028'!J18+'2028-2029'!J18","v":0},{"$f":"'2021-2022'!K18+'2022-2023'!K18+'2023-2024'!K18+'2024-2025'!K18+'2025-2026'!K18+'2026-2027'!K18+'2027-2028'!K18+'2028-2029'!K18","v":0},{"$f":"'2021-2022'!L18+'2022-2023'!L18+'2023-2024'!L18+'2024-2025'!L18+'2025-2026'!L18+'2026-2027'!L18+'2027-2028'!L18+'2028-2029'!L18","v":0},{"$f":"'2021-2022'!M18+'2022-2023'!M18+'2023-2024'!M18+'2024-2025'!M18+'2025-2026'!M18+'2026-2027'!M18+'2027-2028'!M18+'2028-2029'!M18","v":180},{"$f":"'2021-2022'!N18+'2022-2023'!N18+'2023-2024'!N18+'2024-2025'!N18+'2025-2026'!N18+'2026-2027'!N18+'2027-2028'!N18+'2028-2029'!N18","v":230},{"$f":"'2021-2022'!O18+'2022-2023'!O18+'2023-2024'!O18+'2024-2025'!O18+'2025-2026'!O18+'2026-2027'!O18+'2027-2028'!O18+'2028-2029'!O18","v":0},{"$f":"'2021-2022'!P18+'2022-2023'!P18+'2023-2024'!P18+'2024-2025'!P18+'2025-2026'!P18+'2026-2027'!P18+'2027-2028'!P18+'2028-2029'!P18","v":0},null,null,null,null,null,null,null,0.5905331628660937,0.23621326514643748,null,0.17325357198746882,1,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,183.11603157285549,1212.7750039122818,0,0,0,0,31.185642957744388,39.848321557117828,0,0,null,1056.925,7000,0,0,0,0,180,230,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,183.11603157285549,1212.7750039122818,0,0,0,0,31.185642957744388,39.848321557117828,0,0]
[null,"Trials","Business case update and transistion","Workstream 4",null,null,{"$f":"'2021-2022'!G19+'2022-2023'!G19+'2023-2024'!G19+'2024-2025'!G19+'2025-2026'!G19+'2026-2027'!G19+'2027-2028'!G19+'2028-2029'!G19","v":267.92500000000001},{"$f":"'2021-2022'!H19+'2022-2023'!H19+'2023-2024'!H19+'2024-2025'!H19+'2025-2026'!H19+'2026-2027'!H19+'2027-2028'!H19+'2028-2029'!H19","v":0},{"$f":"'2021-2022'!I19+'2022-2023'!I19+'2023-2024'!I19+'2024-2025'!I19+'2025-2026'!I19+'2026-2027'!I19+'2027-2028'!I19+'2028-2029'!I19","v":0},{"$f":"'2021-2022'!J19+'2022-2023'!J19+'2023-2024'!J19+'2024-2025'!J19+'2025-2026'!J19+'2026-2027'!J19+'2027-2028'!J19+'2028-2029'!J19","v":0},{"$f":"'2021-2022'!K19+'2022-2023'!K19+'2023-2024'!K19+'2024-2025'!K19+'2025-2026'!K19+'2026-2027'!K19+'2027-2028'!K19+'2028-2029'!K19","v":0},{"$f":"'2021-2022'!L19+'2022-2023'!L19+'2023-2024'!L19+'2024-2025'!L19+'2025-2026'!L19+'2026-2027'!L19+'2027-2028'!L19+'2028-2029'!L19","v":0},{"$f":"'2021-2022'!M19+'2022-2023'!M19+'2023-2024'!M19+'2024-2025'!M19+'2025-2026'!M19+'2026-2027'!M19+'2027-2028'!M19+'2028-2029'!M19","v":0},{"$f":"'2021-2022'!N19+'2022-2023'!N19+'2023-2024'!N19+'2024-2025'!N19+'2025-2026'!N19+'2026-2027'!N19+'2027-2028'!N19+'2028-2029'!N19","v":0},{"$f":"'2021-2022'!O19+'2022-2023'!O19+'2023-2024'!O19+'2024-2025'!O19+'2025-2026'!O19+'2026-2027'!O19+'2027-2028'!O19+'2028-2029'!O19","v":0},{"$f":"'2021-2022'!P19+'2022-2023'!P19+'2023-2024'!P19+'2024-2025'!P19+'2025-2026'!P19+'2026-2027'!P19+'2027-2028'!P19+'2028-2029'!P19","v":0},null,0.11241489570358554,0.13126508405459389,null,null,null,1.7068739141390697E-2,null,null,null,0.73925128110042992,1,null,30.118760931383157,0,0,0,0,0,0,0,0,0,null,35.169197645327067,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,198.0638994888327,0,0,0,0,0,0,0,0,0,null,267.92500000000001,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,198.0638994888327,0,0,0,0,0,0,0,0,0]
[null,"PM Management and knowledge dissemination","PM Labour","WorkStream 5",null,null,{"$f":"'2021-2022'!G20+'2022-2023'!G20+'2023-2024'!G20+'2024-2025'!G20+'2025-2026'!G20+'2026-2027'!G20+'2027-2028'!G20+'2028-2029'!G20","v":947.17499999999995},{"$f":"'2021-2022'!H20+'2022-2023'!H20+'2023-2024'!H20+'2024-2025'!H20+'2025-2026'!H20+'2026-2027'!H20+'2027-2028'!H20+'2028-2029'!H20","v":0},{"$f":"'2021-2022'!I20+'2022-2023'!I20+'2023-2024'!I20+'2024-2025'!I20+'2025-2026'!I20+'2026-2027'!I20+'2027-2028'!I20+'2028-2029'!I20","v":0},{"$f":"'2021-2022'!J20+'2022-2023'!J20+'2023-2024'!J20+'2024-2025'!J20+'2025-2026'!J20+'2026-2027'!J20+'2027-2028'!J20+'2028-2029'!J20","v":0},{"$f":"'2021-2022'!K20+'2022-2023'!K20+'2023-2024'!K20+'2024-2025'!K20+'2025-2026'!K20+'2026-2027'!K20+'2027-2028'!K20+'2028-2029'!K20","v":0},{"$f":"'2021-2022'!L20+'2022-2023'!L20+'2023-2024'!L20+'2024-2025'!L20+'2025-2026'!L20+'2026-2027'!L20+'2027-2028'!L20+'2028-2029'!L20","v":20},{"$f":"'2021-2022'!M20+'2022-2023'!M20+'2023-2024'!M20+'2024-2025'!M20+'2025-2026'!M20+'2026-2027'!M20+'2027-2028'!M20+'2028-2029'!M20","v":0},{"$f":"'2021-2022'!N20+'2022-2023'!N20+'2023-2024'!N20+'2024-2025'!N20+'2025-2026'!N20+'2026-2027'!N20+'2027-2028'!N20+'2028-2029'!N20","v":0},{"$f":"'2021-2022'!O20+'2022-2023'!O20+'2023-2024'!O20+'2024-2025'!O20+'2025-2026'!O20+'2026-2027'!O20+'2027-2028'!O20+'2028-2029'!O20","v":0},{"$f":"'2021-2022'!P20+'2022-2023'!P20+'2023-2024'!P20+'2024-2025'!P20+'2025-2026'!P20+'2026-2027'!P20+'2027-2028'!P20+'2028-2029'!P20","v":0},null,0.11241489570358554,null,3.6500982218109906E-2,3.6782695260431604E-2,2.1971593499711804E-2,null,null,null,null,0.7923298333181612,1,null,106.47657883804362,0,0,0,0,2.2482979140717108,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,34.572817832438247,0,0,0,0,0.73001964436219813,0,0,0,0,null,34.839649383299303,0,0,0,0,0.73565390520863205,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,750.47500987312935,0,0,0,0,15.846596666363224,0,0,0,0,null,947.17499999999995,0,0,0,0,20,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,750.47500987312935,0,0,0,0,15.846596666363224,0,0,0,0]
[null,"PM Management and knowledge dissemination","Knowledge transfer and dissemination","WorkStream 5",null,null,{"$f":"'2021-2022'!G21+'2022-2023'!G21+'2023-2024'!G21+'2024-2025'!G21+'2025-2026'!G21+'2026-2027'!G21+'2027-2028'!G21+'2028-2029'!G21","v":441.38},{"$f":"'2021-2022'!H21+'2022-2023'!H21+'2023-2024'!H21+'2024-2025'!H21+'2025-2026'!H21+'2026-2027'!H21+'2027-2028'!H21+'2028-2029'!H21","v":0},{"$f":"'2021-2022'!I21+'2022-2023'!I21+'2023-2024'!I21+'2024-2025'!I21+'2025-2026'!I21+'2026-2027'!I21+'2027-2028'!I21+'2028-2029'!I21","v":198},{"$f":"'2021-2022'!J21+'2022-2023'!J21+'2023-2024'!J21+'2024-2025'!J21+'2025-2026'!J21+'2026-2027'!J21+'2027-2028'!J21+'2028-2029'!J21","v":0},{"$f":"'2021-2022'!K21+'2022-2023'!K21+'2023-2024'!K21+'2024-2025'!K21+'2025-2026'!K21+'2026-2027'!K21+'2027-2028'!K21+'2028-2029'!K21","v":0},{"$f":"'2021-2022'!L21+'2022-2023'!L21+'2023-2024'!L21+'2024-2025'!L21+'2025-2026'!L21+'2026-2027'!L21+'2027-2028'!L21+'2028-2029'!L21","v":0},{"$f":"'2021-2022'!M21+'2022-2023'!M21+'2023-2024'!M21+'2024-2025'!M21+'2025-2026'!M21+'2026-2027'!M21+'2027-2028'!M21+'2028-2029'!M21","v":0},{"$f":"'2021-2022'!N21+'2022-2023'!N21+'2023-2024'!N21+'2024-2025'!N21+'2025-2026'!N21+'2026-2027'!N21+'2027-2028'!N21+'2028-2029'!N21","v":0},{"$f":"'2021-2022'!O21+'2022-2023'!O21+'2023-2024'!O21+'2024-2025'!O21+'2025-2026'!O21+'2026-2027'!O21+'2027-2028'!O21+'2028-2029'!O21","v":0},{"$f":"'2021-2022'!P21+'2022-2023'!P21+'2023-2024'!P21+'2024-2025'!P21+'2025-2026'!P21+'2026-2027'!P21+'2027-2028'!P21+'2028-2029'!P21","v":80},"Total Cost",0.11241489570358554,0.13126508405459389,3.6500982218109906E-2,null,null,null,null,null,null,0.71981903802371061,1,null,49.617686665648584,0,22.258149349309935,0,0,0,0,0,0,8.993191656286843,null,57.937782800016649,0,25.990486642809589,0,0,0,0,0,0,10.501206724367512,null,16.110803531429351,0,7.2271944791857612,0,0,0,0,0,0,2.9200785774487925,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,317.71372700290539,0,142.5241695286947,0,0,0,0,0,0,57.585523041896849,null,441.38,0,198,0,0,0,0,0,0,80,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,317.71372700290539,0,142.5241695286947,0,0,0,0,0,0,57.585523041896849]
[null,"Total",null,null,null,null,{"$f":"SUM(G7:G21)","v":5724.7600000000011},{"$f":"SUM(H7:H21)","v":7000},518,250,0,20,225,1497.6,0,140,{"$f":"SUM(G22:P22)","v":15375.360000000002},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AD7:AD21)","v":524.7341846865462},0,58.230915974457304,28.103723925896386,0,2.2482979140717108,5.058670306661349,142.49712179386501,0,15.738085398501976,null,{"$f":"SUM(AO7:AO21)","v":190.93294066245011},0,41.742296729360859,0,0,0,0,1.3126508405459389,0,18.377111767643143,null,{"$f":"SUM(AZ7:AZ21)","v":106.68744339093581},0,7.2271944791857612,9.125245554527476,0,0.73001964436219813,1.6425441998149457,39.917474153724989,0,2.9200785774487925,null,{"$f":"SUM(BK7:BK21)","v":49.350422663539568},0,4.4139234312517921,0,0,0.73565390520863205,0,0,0,0,null,{"$f":"SUM(BV7:BV21)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(CG7:CG21)","v":3888.1638496109013},1212.7750039122818,399.35475946583648,207.2781321446482,0,15.846596666363224,68.495706743781057,1095.9385228097635,0,101.64642864642337,null,{"$f":"SUM(CR7:CR21)","v":5724.7600000000011},7000,518,250,0,20,225,1497.6,0,140,null,{"$f":"SUM(DC7:DC21)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(DN7:DN21)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(DY7:DY21)","v":3888.1638496109013},1212.7750039122818,399.35475946583648,207.2781321446482,0,15.846596666363224,68.495706743781057,1095.9385228097635,0,101.64642864642337]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Totals"]

{"sheet":"Project Direction","index":13,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,"Cost Category","Cost"]
[null,null,"Labour"]
[null,null,null,{"$f":"'Whole project'!DY22+'Whole project'!AD22+'Whole project'!DN22","v":4412.8980342974473}]
[null,null,"Equipment"]
[null,null,null,{"$f":"'Whole project'!DZ22+'Whole project'!AE22+'Whole project'!DO22","v":1212.7750039122818}]
[null,null,"Contractors"]
[null,null,null,{"$f":"'Whole project'!EA22+'Whole project'!AF22+'Whole project'!DP22","v":457.58567544029381}]
[null,null,"IT"]
[null,null,null,{"$f":"'Whole project'!EB22+'Whole project'!AG22+'Whole project'!DQ22","v":235.38185607054459}]
[null,null,"IPR Costs"]
[null,null,null,{"$f":"'Whole project'!EC22+'Whole project'!AH22+'Whole project'!DR22","v":0}]
[null,null,"Travel & Expenses"]
[null,null,null,{"$f":"'Whole project'!ED22+'Whole project'!AI22+'Whole project'!DS22","v":18.094894580434936}]
[null,null,"Payments to users"]
[null,null,null,{"$f":"'Whole project'!EE22+'Whole project'!AJ22+'Whole project'!DT22","v":73.554377050442412}]
[null,null,"Contingency"]
[null,null,null,{"$f":"'Whole project'!EF22+'Whole project'!AK22+'Whole project'!DU22","v":1238.4356446036286}]
[null,null,"Decommissioning"]
[null,null,null,{"$f":"'Whole project'!EG22+'Whole project'!AL22+'Whole project'!DV22","v":0}]
[null,null,"Other"]
[null,null,null,{"$f":"'Whole project'!EH22+'Whole project'!AM22+'Whole project'!DW22","v":117.38451404492535},"Check that = to Total Outstanding Funding Required + Licensee Compulsory Contribution + Licensee Extra Contribution"]
[null,null,"Total",{"$f":"SUM(D6:D24)","v":7766.11},{"$f":"IF(D25=('NIC Funding Request'!J79+'NIC Funding Request'!J37+'NIC Funding Request'!J66),\"OK\", \"ERROR\")","v":"OK"}]