{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Front Sheet","Second Tier Funding Request","Direct Benefits","Project Cost Summary","2014-15","2015-16","2016-17","2017-18","2018-19","2019-20","Whole project","Project Direction","Net benefits"],"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,"LCN Fund Second Tier Full Submission "]
[null,null,null,null,null," Spreadsheet "]
[]
[null,null,null,null,null,"(version 2.0)"]
[null,null,null,null,null,"Appendix A"]
[]
[]
[]
[null,null,"DNO Name:"]
[]
[null,null,"Submission Date:"]
[]
[]
[]
[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":"Second Tier Funding Request","index":1,"n_rows":90,"n_cols":11,"rows_kept":90,"cut":false,"hidden":false,"merged":[]}
["Second Tier Funding Request"]
[null," ","2014/15","2015/16","2016/17","2017/18","2018/19","2019/20","Total"]
["Total Project Cost","From Project Cost Summary sheet"]
[null,"Labour",{"$f":"'Project Cost Summary'!C18","v":0},{"$f":"'Project Cost Summary'!C31","v":0},{"$f":"'Project Cost Summary'!C44","v":0},{"$f":"'Project Cost Summary'!C57","v":0},{"$f":"'Project Cost Summary'!C70","v":0},{"$f":"'Project Cost Summary'!C83","v":0},{"$f":"SUM(C4:H4)","v":0}]
[null,"Equipment",{"$f":"'Project Cost Summary'!D18","v":0},{"$f":"'Project Cost Summary'!D31","v":0},{"$f":"'Project Cost Summary'!D44","v":0},{"$f":"'Project Cost Summary'!D57","v":0},{"$f":"'Project Cost Summary'!D70","v":0},{"$f":"'Project Cost Summary'!D83","v":0},{"$f":"SUM(C5:H5)","v":0}]
[null,"Contractors",{"$f":"'Project Cost Summary'!E18","v":0},{"$f":"'Project Cost Summary'!E31","v":0},{"$f":"'Project Cost Summary'!E44","v":0},{"$f":"'Project Cost Summary'!E57","v":0},{"$f":"'Project Cost Summary'!E70","v":0},{"$f":"'Project Cost Summary'!E83","v":0},0]
[null,"IT",{"$f":"'Project Cost Summary'!F18","v":0},{"$f":"'Project Cost Summary'!F31","v":0},{"$f":"'Project Cost Summary'!F44","v":0},{"$f":"'Project Cost Summary'!F57","v":0},{"$f":"'Project Cost Summary'!F70","v":0},{"$f":"'Project Cost Summary'!F83","v":0},0]
[null,"IPR Costs",{"$f":"'Project Cost Summary'!G18","v":0},{"$f":"'Project Cost Summary'!G31","v":0},{"$f":"'Project Cost Summary'!G44","v":0},{"$f":"'Project Cost Summary'!G57","v":0},{"$f":"'Project Cost Summary'!G70","v":0},{"$f":"'Project Cost Summary'!G83","v":0},0]
[null,"Travel & Expenses",{"$f":"'Project Cost Summary'!H18","v":0},{"$f":"'Project Cost Summary'!H31","v":0},{"$f":"'Project Cost Summary'!H44","v":0},{"$f":"'Project Cost Summary'!H57","v":0},{"$f":"'Project Cost Summary'!H70","v":0},{"$f":"'Project Cost Summary'!H83","v":0},0]
["Payments to users & Contigency",null,{"$f":"'Project Cost Summary'!I18+'Project Cost Summary'!J18","v":0},{"$f":"'Project Cost Summary'!I31+'Project Cost Summary'!J31","v":0},{"$f":"'Project Cost Summary'!I44+'Project Cost Summary'!J44","v":0},{"$f":"'Project Cost Summary'!I57+'Project Cost Summary'!J57","v":0},{"$f":"'Project Cost Summary'!I70+'Project Cost Summary'!J70","v":0},{"$f":"'Project Cost Summary'!J83+'Project Cost Summary'!K83","v":0},0]
[null,"Decommissioning",{"$f":"'Project Cost Summary'!K18","v":0},{"$f":"'Project Cost Summary'!K31","v":0},{"$f":"'Project Cost Summary'!K44","v":0},{"$f":"'Project Cost Summary'!K57","v":0},{"$f":"'Project Cost Summary'!K70","v":0},{"$f":"'Project Cost Summary'!K83","v":0},0]
[null,"Other",{"$f":"'Project Cost Summary'!L18","v":0},{"$f":"'Project Cost Summary'!L31","v":0},{"$f":"'Project Cost Summary'!L44","v":0},{"$f":"'Project Cost Summary'!L57","v":0},{"$f":"'Project Cost Summary'!L70","v":0},{"$f":"'Project Cost Summary'!L83","v":0},0]
[null,"Total",{"$f":"SUM(C4:C12)","v":0},0,0,0,0,0,{"$f":"SUM(C13:G13)","v":0}]
[]
["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'!C22","v":0},{"$f":"'Project Cost Summary'!C35","v":0},{"$f":"'Project Cost Summary'!C48","v":0},{"$f":"'Project Cost Summary'!C61","v":0},{"$f":"'Project Cost Summary'!C74","v":0},{"$f":"'Project Cost Summary'!C87","v":0},{"$f":"SUM(C16:H16)","v":0}]
[null,"Equipment",{"$f":"'Project Cost Summary'!D22","v":0},{"$f":"'Project Cost Summary'!D35","v":0},{"$f":"'Project Cost Summary'!D48","v":0},{"$f":"'Project Cost Summary'!D61","v":0},{"$f":"'Project Cost Summary'!D74","v":0},{"$f":"'Project Cost Summary'!D87","v":0},{"$f":"SUM(C17:H17)","v":0}]
[null,"Contractors",{"$f":"'Project Cost Summary'!E22","v":0},{"$f":"'Project Cost Summary'!E35","v":0},{"$f":"'Project Cost Summary'!E48","v":0},{"$f":"'Project Cost Summary'!E61","v":0},{"$f":"'Project Cost Summary'!E74","v":0},{"$f":"'Project Cost Summary'!E87","v":0},0]
[null,"IT",{"$f":"'Project Cost Summary'!F22","v":0},{"$f":"'Project Cost Summary'!F35","v":0},{"$f":"'Project Cost Summary'!F48","v":0},{"$f":"'Project Cost Summary'!F61","v":0},{"$f":"'Project Cost Summary'!F74","v":0},{"$f":"'Project Cost Summary'!F87","v":0},0]
[null,"IPR Costs",{"$f":"'Project Cost Summary'!G22","v":0},{"$f":"'Project Cost Summary'!G35","v":0},{"$f":"'Project Cost Summary'!G48","v":0},{"$f":"'Project Cost Summary'!G61","v":0},{"$f":"'Project Cost Summary'!G74","v":0},{"$f":"'Project Cost Summary'!G87","v":0},0]
[null,"Travel & Expenses",{"$f":"'Project Cost Summary'!H22","v":0},{"$f":"'Project Cost Summary'!H35","v":0},{"$f":"'Project Cost Summary'!H48","v":0},{"$f":"'Project Cost Summary'!H61","v":0},{"$f":"'Project Cost Summary'!H74","v":0},{"$f":"'Project Cost Summary'!H87","v":0},0]
["Payments to users & Contigency",null,{"$f":"'Project Cost Summary'!I22+'Project Cost Summary'!J22","v":0},{"$f":"'Project Cost Summary'!I35+'Project Cost Summary'!J35","v":0},{"$f":"'Project Cost Summary'!I48+'Project Cost Summary'!J48","v":0},{"$f":"'Project Cost Summary'!I61+'Project Cost Summary'!J61","v":0},{"$f":"'Project Cost Summary'!I74+'Project Cost Summary'!J74","v":0},{"$f":"'Project Cost Summary'!I87+'Project Cost Summary'!K87","v":0},0]
[null,"Decommissioning",{"$f":"'Project Cost Summary'!K22","v":0},{"$f":"'Project Cost Summary'!K35","v":0},{"$f":"'Project Cost Summary'!K48","v":0},{"$f":"'Project Cost Summary'!K61","v":0},{"$f":"'Project Cost Summary'!K74","v":0},{"$f":"'Project Cost Summary'!K87","v":0},0]
[null,"Other",{"$f":"'Project Cost Summary'!L22","v":0},{"$f":"'Project Cost Summary'!L35","v":0},{"$f":"'Project Cost Summary'!L48","v":0},{"$f":"'Project Cost Summary'!L61","v":0},{"$f":"'Project Cost Summary'!L74","v":0},{"$f":"'Project Cost Summary'!L87","v":0},0]
[null,"Total",{"$f":"SUM(C16:C24)","v":0},{"$f":"SUM(D16:D24)","v":0},{"$f":"SUM(E16:E24)","v":0},{"$f":"SUM(F16:F24)","v":0},{"$f":"SUM(G16:G24)","v":0},null,{"$f":"SUM(C25:G25)","v":0}]
[]
["DNO extra contribution","Any funding from the DNO which is in excess of the DNO Compulsory Contribution - from Project Cost Summary sheet"]
[null,"Labour",{"$f":"'Project Cost Summary'!C23","v":0},{"$f":"'Project Cost Summary'!C36","v":0},{"$f":"'Project Cost Summary'!C49","v":0},{"$f":"'Project Cost Summary'!C62","v":0},{"$f":"'Project Cost Summary'!C75","v":0},{"$f":"'Project Cost Summary'!C88","v":0},{"$f":"SUM(C28:H28)","v":0}]
[null,"Equipment",{"$f":"'Project Cost Summary'!D23","v":0},{"$f":"'Project Cost Summary'!D36","v":0},{"$f":"'Project Cost Summary'!D49","v":0},{"$f":"'Project Cost Summary'!D62","v":0},{"$f":"'Project Cost Summary'!D75","v":0},{"$f":"'Project Cost Summary'!D88","v":0},{"$f":"SUM(C29:H29)","v":0}]
[null,"Contractors",{"$f":"'Project Cost Summary'!E23","v":0},{"$f":"'Project Cost Summary'!E36","v":0},{"$f":"'Project Cost Summary'!E49","v":0},{"$f":"'Project Cost Summary'!E62","v":0},{"$f":"'Project Cost Summary'!E75","v":0},{"$f":"'Project Cost Summary'!E88","v":0},0]
[null,"IT",{"$f":"'Project Cost Summary'!F23","v":0},{"$f":"'Project Cost Summary'!F36","v":0},{"$f":"'Project Cost Summary'!F49","v":0},{"$f":"'Project Cost Summary'!F62","v":0},{"$f":"'Project Cost Summary'!F75","v":0},{"$f":"'Project Cost Summary'!E88","v":0},0]
[null,"IPR Costs",{"$f":"'Project Cost Summary'!G23","v":0},{"$f":"'Project Cost Summary'!G36","v":0},{"$f":"'Project Cost Summary'!G49","v":0},{"$f":"'Project Cost Summary'!G62","v":0},{"$f":"'Project Cost Summary'!G75","v":0},{"$f":"'Project Cost Summary'!F88","v":0},0]
[null,"Travel & Expenses",{"$f":"'Project Cost Summary'!H23","v":0},{"$f":"'Project Cost Summary'!H36","v":0},{"$f":"'Project Cost Summary'!H49","v":0},{"$f":"'Project Cost Summary'!H62","v":0},{"$f":"'Project Cost Summary'!H75","v":0},{"$f":"'Project Cost Summary'!G88","v":0},0]
["Payments to users & Contigency",null,{"$f":"'Project Cost Summary'!I23+'Project Cost Summary'!J23","v":0},{"$f":"'Project Cost Summary'!I36+'Project Cost Summary'!J36","v":0},{"$f":"'Project Cost Summary'!I49+'Project Cost Summary'!J49","v":0},{"$f":"'Project Cost Summary'!I62+'Project Cost Summary'!J62","v":0},{"$f":"'Project Cost Summary'!I75","v":0},{"$f":"'Project Cost Summary'!I88+'Project Cost Summary'!J88","v":0},0]
[null,"Decommissioning",{"$f":"'Project Cost Summary'!K23","v":0},{"$f":"'Project Cost Summary'!K36","v":0},{"$f":"'Project Cost Summary'!K49","v":0},{"$f":"'Project Cost Summary'!K62","v":0},{"$f":"'Project Cost Summary'!K75","v":0},{"$f":"'Project Cost Summary'!K88","v":0},0]
[null,"Other",{"$f":"'Project Cost Summary'!L23","v":0},{"$f":"'Project Cost Summary'!L36","v":0},{"$f":"'Project Cost Summary'!L49","v":0},{"$f":"'Project Cost Summary'!L62","v":0},{"$f":"'Project Cost Summary'!L75","v":0},{"$f":"'Project Cost Summary'!L88","v":0},0]
[null,"Total",{"$f":"SUM(C28:C36)","v":0},0,0,0,0,null,0]
[]
["Initial Net Funding Required",null,"calculated from the tables above"]
[null,"Labour",{"$f":"C4-C16-C28","v":0},0,0,0,0,{"$f":"H4-H16-H28","v":0},0]
[null,"Equipment",0,0,0,0,0,0,0]
[null,"Contractors",0,0,0,0,0,0,0]
[null,"IT",0,0,0,0,0,0,0]
[null,"IPR Costs",0,0,0,0,0,0,0]
[null,"Travel & Expenses",0,0,0,0,0,0,0]
["Payments to users & Contigency",null,0,0,0,0,0,0,0]
[null,"Decommissioning",0,0,0,0,0,0,0,"Check Total = to Initial Net Funding request "]
[null,"Other",0,0,0,0,0,0,0,"in Project Cost Summary"]
[null,"Total",0,0,0,0,0,0,{"$f":"I13-I25-I37","v":0},{"$f":"IF(I49='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},0,0,0,0,{"$f":"SUM(C52:H52)","v":0}]
[]
[]
[]
["DNO Compulsory Contribution / Direct Benefits",null,null,"from Project Cost Summary sheet"]
[null,"Labour",{"$f":"'Project Cost Summary'!C25","v":0},{"$f":"'Project Cost Summary'!C38","v":0},{"$f":"'Project Cost Summary'!C51","v":0},{"$f":"'Project Cost Summary'!C64","v":0},{"$f":"'Project Cost Summary'!C77","v":0},{"$f":"'Project Cost Summary'!C90","v":0},{"$f":"SUM(C57:H57)","v":0}]
[null,"Equipment",{"$f":"'Project Cost Summary'!D25","v":0},{"$f":"'Project Cost Summary'!D38","v":0},{"$f":"'Project Cost Summary'!D51","v":0},{"$f":"'Project Cost Summary'!D64","v":0},{"$f":"'Project Cost Summary'!D77","v":0},{"$f":"'Project Cost Summary'!D90","v":0},{"$f":"SUM(C58:H58)","v":0}]
[null,"Contractors",{"$f":"'Project Cost Summary'!E25","v":0},{"$f":"'Project Cost Summary'!E38","v":0},{"$f":"'Project Cost Summary'!E51","v":0},{"$f":"'Project Cost Summary'!E64","v":0},{"$f":"'Project Cost Summary'!E77","v":0},{"$f":"'Project Cost Summary'!E90","v":0},0]
[null,"IT",{"$f":"'Project Cost Summary'!F25","v":0},{"$f":"'Project Cost Summary'!F38","v":0},{"$f":"'Project Cost Summary'!F51","v":0},{"$f":"'Project Cost Summary'!F64","v":0},{"$f":"'Project Cost Summary'!F77","v":0},{"$f":"'Project Cost Summary'!F90","v":0},0]
[null,"IPR Costs",{"$f":"'Project Cost Summary'!G25","v":0},{"$f":"'Project Cost Summary'!G38","v":0},{"$f":"'Project Cost Summary'!G51","v":0},{"$f":"'Project Cost Summary'!G64","v":0},{"$f":"'Project Cost Summary'!G77","v":0},{"$f":"'Project Cost Summary'!G90","v":0},0]
[null,"Travel & Expenses",{"$f":"'Project Cost Summary'!H25","v":0},{"$f":"'Project Cost Summary'!H38","v":0},{"$f":"'Project Cost Summary'!H51","v":0},{"$f":"'Project Cost Summary'!H64","v":0},{"$f":"'Project Cost Summary'!H77","v":0},{"$f":"'Project Cost Summary'!H90","v":0},0]
["Payments to users & Contigency",null,{"$f":"'Project Cost Summary'!I25+'Project Cost Summary'!J25","v":0},{"$f":"'Project Cost Summary'!I38+'Project Cost Summary'!J38","v":0},{"$f":"'Project Cost Summary'!I51+'Project Cost Summary'!J51","v":0},{"$f":"'Project Cost Summary'!I64+'Project Cost Summary'!J64","v":0},{"$f":"'Project Cost Summary'!I77+'Project Cost Summary'!J77","v":0},{"$f":"'Project Cost Summary'!I90+'Project Cost Summary'!J90","v":0},0]
[null,"Decommissioning",{"$f":"'Project Cost Summary'!K25","v":0},{"$f":"'Project Cost Summary'!K38","v":0},{"$f":"'Project Cost Summary'!K51","v":0},{"$f":"'Project Cost Summary'!K64","v":0},{"$f":"'Project Cost Summary'!K77","v":0},{"$f":"'Project Cost Summary'!K90","v":0},0,"of Total Initial Net Funding Required"]
[null,"Other",{"$f":"'Project Cost Summary'!L25","v":0},{"$f":"'Project Cost Summary'!L38","v":0},{"$f":"'Project Cost Summary'!L51","v":0},{"$f":"'Project Cost Summary'!L64","v":0},{"$f":"'Project Cost Summary'!L77","v":0},{"$f":"'Project Cost Summary'!L90","v":0},0,{"$f":"IF(I66>=I49*0.1,\"OK\",\"ERROR\")","v":"OK"}]
[null,"Total",{"$f":"SUM(C57:C65)","v":0},{"$f":"SUM(D57:D65)","v":0},{"$f":"SUM(E57:E65)","v":0},{"$f":"SUM(F57:F65)","v":0},{"$f":"SUM(G57:G65)","v":0},null,{"$f":"SUM(C66:H66)","v":0},"Check that Total is = or > than "]
[null,null,null,null,null,null,null,null,null,"Total Direct Benefits"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I66>=I52,\"OK\",\"ERROR\")","v":"OK"}]
["Outstanding Funding required",null,"calculated from the tables above"]
[null,"Labour",{"$f":"C40-C57","v":0},0,0,0,0,{"$f":"H40-H57","v":0},{"$f":"SUM(C70:H70)","v":0}]
[null,"Equipment",0,0,0,0,0,0,{"$f":"SUM(C71:H71)","v":0}]
[null,"Contractors",0,0,0,0,0,0,0]
[null,"IT",0,0,0,0,0,0,0]
[null,"IPR Costs",0,0,0,0,0,0,0]
[null,"Travel & Expenses",0,0,0,0,0,0,0]
["Payments to users & Contigency",null,0,0,0,0,0,0,0]
[null,"Decommissioning",0,0,0,0,0,0,0,"Check that Total is =to "]
[null,"Other",0,0,0,0,0,0,0,"Total Outstanding Funding required"]
[null,"Total",0,0,0,0,0,0,{"$f":"SUM(I70:I78)","v":0},{"$f":"IF(I79='Project Cost Summary'!M13, \"OK\",\"ERROR\")","v":"OK"}]
[]
["balance",2.2737367544323206E-13,0,{"$f":"B81-C79-D79","v":2.2737367544323206E-13},{"$f":"D81-E79+D82","v":2.319211489520967E-13},{"$f":"E81-F79+E82","v":2.3651409719604999E-13},{"$f":"F81-G79+F82","v":2.4119844965753146E-13},{"$f":"G81-H79+G82","v":2.4597557512606729E-13},{"$f":"B81","v":2.2737367544323206E-13}]
["interest",null,0,{"$f":"((B81+D81)/2)*$D86","v":4.5474735088646413E-15},{"$f":"((D81+E81)/2)*$D86","v":4.5929482439532874E-15},{"$f":"((E81+F81)/2)*$D86","v":4.6843524614814674E-15},{"$f":"((F81+G81)/2)*$D86","v":4.7771254685358154E-15},{"$f":"((G81+H81)/2)*$D86","v":4.871740247835987E-15},{"$f":"SUM(D82:H82)","v":2.34736399306712E-14}]
[null,null,null,null,null,null,null,null,{"$f":"I81+I82","v":2.5084731537390328E-13},{"$f":"I79-I83","v":-2.5084731537390328E-13}]
[]
[null,"Bank of England interest rate",null,5.0000000000000001E-3,null,null,"SECOND TIER FUNDING REQUEST   £",null,{"$f":"I81","v":2.2737367544323206E-13}]
[null,"interest rate used in calculation",null,{"$f":"D85+1.5%","v":0.02}]
[null,"RPI adjustment","2014/15","2015/16","2016/17","2017/18","2018/19","2019/20","2020/21","2021/2022","2022/2023"]
[null,"Index",259.53672299999999,267.582361413,275.87741461680298,284.42961446992388,293.24693251849152,302.33758742656471,311.71005263678819,321.37306426852859,331.33562926085295]
[null,"Annual inflation ",3.0999999999999917E-2,3.0999999999999917E-2,3.0999999999999917E-2,3.0999999999999917E-2,3.0999999999999917E-2,3.0999999999999917E-2,3.0999999999999917E-2,3.0999999999999917E-2,3.0999999999999917E-2]
["n.b the Second Tier Funding Request calculation should use the Bank of England Base rate plus 1.5% on 31 June of the year in which the Full Submission is made."]

{"sheet":"Direct Benefits","index":2,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[6,1,7,1],[6,2,6,4]]}
["Direct Benefits"]
[]
["Direct Benefit: Any benefits of the Project accruing to the DNO during the Project Implementation and include the following"]
[null,"       - Revenue included in the DNO's Full Business Plan Questionnaire (FBPQ) for DPCR5 which will be saved through undertaking the project"]
[null,"       - Incentive payments generated as a result of the Project for the duration of the Project"]
[]
[null,"Description of Direct Benefit"]
[null,null,"2013/14","2014/15","Total"]
[null,null,null,null,{"$f":"SUM(C9:D9)","v":0}]
[null,null,null,null,{"$f":"SUM(C10:D10)","v":0}]
[null,"Total Direct Benefits",{"$f":"SUM(C9:C10)","v":0},{"$f":"SUM(D9:D10)","v":0},{"$f":"SUM(E9:E10)","v":0}]
[]
[]
[null,"n.b. These are Direct Benefits associated with the Project itself, not the wider deployment of the Solution and therefore should not exceed beyond the project or the DPCR5 period"]

{"sheet":"Project Cost Summary","index":3,"n_rows":91,"n_cols":15,"rows_kept":91,"cut":false,"hidden":false,"merged":[[80,2,80,12],[54,2,54,12],[67,2,67,12],[1,2,1,12],[28,2,28,12],[27,2,27,12],[15,2,15,12],[14,2,14,12],[53,2,53,12],[66,2,66,12],[41,2,41,12],[40,2,40,12],[2,2,2,12],[79,2,79,12]]}
["Project Cost Summary"]
[null,null,"Total"]
[null,null,"Cost type"]
[null,null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","Decommissioning","Other","Total"]
[null,"Total Project Cost",{"$f":"SUM(C18+C31+C44+C57+C70)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(C5:L5)","v":0}]
[null,"Project Partner 1",{"$f":"SUM(C19+C32+C45+C58+C71)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(C6:L6)","v":0}]
[null,"Project Partner 2",{"$f":"SUM(C20+C33+C46+C59+C72)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Project Partner 3",{"$f":"SUM(C21+C34+C47+C60+C73)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"External Funding",{"$f":"SUM(C6:C8)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(C9:L9)","v":0}]
[null,"DNO extra contribution",{"$f":"C23+C36+C49+C62+C75","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Initial Net Funding Required",{"$f":"C24+C37+C50+C63+C76","v":0},0,0,0,0,0,0,0,0,0,0,null,"Check Total Initial Net Funding Required matches that on the Second Tier Funding Request tab"]
[null,"DNO Compulsory Contribution / Direct Benefits",{"$f":"C25+C38+C51+C64+C77","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"IF(ABS(M11-'Second Tier Funding Request'!I49)<0.01,\"OK\",\"ERROR\")","v":"OK"}]
[null,"Outstanding Funding Required",{"$f":"C26+C39+C52+C65+C78","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(C13:L13)","v":0}]
[]
[null,null,"2014/15"]
[null,null,"Cost type"]
[null,null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","Decommissioning","Other","Total"]
[null,"Total Project Cost",{"$f":"'2014-15'!G9","v":0},{"$f":"'2014-15'!H9","v":0},{"$f":"'2014-15'!I9","v":0},{"$f":"'2014-15'!J9","v":0},{"$f":"'2014-15'!K9","v":0},{"$f":"'2014-15'!L9","v":0},{"$f":"'2014-15'!M9","v":0},{"$f":"'2014-15'!N9","v":0},{"$f":"'2014-15'!O9","v":0},{"$f":"'2014-15'!P9","v":0},{"$f":"SUM(C18:L18)","v":0}]
[null,"Project Partner 1",{"$f":"'2014-15'!AK9","v":0},{"$f":"'2014-15'!AL9","v":0},{"$f":"'2014-15'!AM9","v":0},{"$f":"'2014-15'!AN9","v":0},{"$f":"'2014-15'!AO9","v":0},{"$f":"'2014-15'!AP9","v":0},{"$f":"'2014-15'!AQ9","v":0},{"$f":"'2014-15'!AR9","v":0},{"$f":"'2014-15'!AS9","v":0},{"$f":"'2014-15'!AT9","v":0},0]
[null,"Project Partner 2",{"$f":"'2014-15'!AV9","v":0},{"$f":"'2014-15'!AW9","v":0},{"$f":"'2014-15'!AX9","v":0},{"$f":"'2014-15'!AY9","v":0},{"$f":"'2014-15'!AZ9","v":0},{"$f":"'2014-15'!BA9","v":0},{"$f":"'2014-15'!BB9","v":0},{"$f":"'2014-15'!BC9","v":0},{"$f":"'2014-15'!BD9","v":0},{"$f":"'2014-15'!BE9","v":0},0]
[null,"Project Partner 3",{"$f":"'2014-15'!BG9","v":0},{"$f":"'2014-15'!BH9","v":0},{"$f":"'2014-15'!BI9","v":0},{"$f":"'2014-15'!BJ9","v":0},{"$f":"'2014-15'!BK9","v":0},{"$f":"'2014-15'!BL9","v":0},{"$f":"'2014-15'!BM9","v":0},{"$f":"'2014-15'!BN9","v":0},{"$f":"'2014-15'!BO9","v":0},{"$f":"'2014-15'!BP9","v":0},0]
[null,"External Funding",{"$f":"SUM(C19:C21)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"DNO extra contribution",{"$f":"'2014-15'!BR9","v":0},{"$f":"'2014-15'!BS9","v":0},{"$f":"'2014-15'!BT9","v":0},{"$f":"'2014-15'!BU9","v":0},{"$f":"'2014-15'!BV9","v":0},{"$f":"'2014-15'!BW9","v":0},{"$f":"'2014-15'!BX9","v":0},{"$f":"'2014-15'!BY9","v":0},{"$f":"'2014-15'!BZ9","v":0},{"$f":"'2014-15'!CA9","v":0},0]
[null,"Initial Net Funding Required",{"$f":"C18-C22-C23","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"DNO Compulsory Contribution / Direct Benefits",{"$f":"'2014-15'!Z9","v":0},{"$f":"'2014-15'!AA9","v":0},{"$f":"'2014-15'!AB9","v":0},{"$f":"'2014-15'!AC9","v":0},{"$f":"'2014-15'!AD9","v":0},{"$f":"'2014-15'!AE9","v":0},{"$f":"'2014-15'!AF9","v":0},{"$f":"'2014-15'!AG9","v":0},{"$f":"'2014-15'!AH9","v":0},{"$f":"'2014-15'!AI9","v":0},0]
[null,"Outstanding Funding Required",{"$f":"'2014-15'!CC9","v":0},{"$f":"'2014-15'!CD9","v":0},{"$f":"'2014-15'!CE9","v":0},{"$f":"'2014-15'!CF9","v":0},{"$f":"'2014-15'!CG9","v":0},{"$f":"'2014-15'!CH9","v":0},{"$f":"'2014-15'!CI9","v":0},{"$f":"'2014-15'!CJ9","v":0},{"$f":"'2014-15'!CK9","v":0},{"$f":"'2014-15'!CL9","v":0},0]
[]
[null,null,"2015/16"]
[null,null,"Cost type"]
[null,null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","Decommissioning","Other","Total"]
[null,"Total Project Cost",{"$f":"'2015-16'!G9","v":0},{"$f":"'2015-16'!H9","v":0},{"$f":"'2015-16'!I9","v":0},{"$f":"'2015-16'!J9","v":0},{"$f":"'2015-16'!K9","v":0},{"$f":"'2015-16'!L9","v":0},{"$f":"'2015-16'!M9","v":0},{"$f":"'2015-16'!N9","v":0},{"$f":"'2015-16'!O9","v":0},{"$f":"'2015-16'!P9","v":0},{"$f":"SUM(C31:L31)","v":0}]
[null,"Project Partner 1",{"$f":"'2015-16'!AK9","v":0},{"$f":"'2015-16'!AL9","v":0},{"$f":"'2015-16'!AM9","v":0},{"$f":"'2015-16'!AN9","v":0},{"$f":"'2015-16'!AO9","v":0},{"$f":"'2015-16'!AP9","v":0},{"$f":"'2015-16'!AQ9","v":0},{"$f":"'2015-16'!AR9","v":0},{"$f":"'2015-16'!AS9","v":0},{"$f":"'2015-16'!AT9","v":0},0]
[null,"Project Partner 2",{"$f":"'2015-16'!AV9","v":0},{"$f":"'2015-16'!AW9","v":0},{"$f":"'2015-16'!AX9","v":0},{"$f":"'2015-16'!AY9","v":0},{"$f":"'2015-16'!AZ9","v":0},{"$f":"'2015-16'!BA9","v":0},{"$f":"'2015-16'!BB9","v":0},{"$f":"'2015-16'!BC9","v":0},{"$f":"'2015-16'!BD9","v":0},{"$f":"'2015-16'!BE9","v":0},0]
[null,"Project Partner 3",{"$f":"'2015-16'!BG9","v":0},{"$f":"'2015-16'!BH9","v":0},{"$f":"'2015-16'!BI9","v":0},{"$f":"'2015-16'!BJ9","v":0},{"$f":"'2015-16'!BK9","v":0},{"$f":"'2015-16'!BL9","v":0},{"$f":"'2015-16'!BM9","v":0},{"$f":"'2015-16'!BN9","v":0},{"$f":"'2015-16'!BO9","v":0},{"$f":"'2015-16'!BP9","v":0},0]
[null,"External Funding",{"$f":"SUM(C32:C34)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"DNO extra contribution",{"$f":"'2015-16'!BR9","v":0},{"$f":"'2015-16'!BS9","v":0},{"$f":"'2015-16'!BT9","v":0},{"$f":"'2015-16'!BU9","v":0},{"$f":"'2015-16'!BV9","v":0},{"$f":"'2015-16'!BW9","v":0},{"$f":"'2015-16'!BX9","v":0},{"$f":"'2015-16'!BY9","v":0},{"$f":"'2015-16'!BZ9","v":0},{"$f":"'2015-16'!CA9","v":0},0]
[null,"Initial Net Funding Required",{"$f":"C31-C35-C36","v":0},{"$f":"D31-D35-D36","v":0},0,0,0,0,0,0,0,0,0]
[null,"DNO Compulsory Contribution / Direct Benefits",{"$f":"'2015-16'!Z9","v":0},{"$f":"'2015-16'!AA9","v":0},{"$f":"'2015-16'!AB9","v":0},{"$f":"'2015-16'!AC9","v":0},{"$f":"'2015-16'!AD9","v":0},{"$f":"'2015-16'!AE9","v":0},{"$f":"'2015-16'!AF9","v":0},{"$f":"'2015-16'!AG9","v":0},{"$f":"'2015-16'!AH9","v":0},{"$f":"'2015-16'!AI9","v":0},0]
[null,"Outstanding Funding Required",{"$f":"'2015-16'!CC9","v":0},{"$f":"'2015-16'!CD9","v":0},{"$f":"'2015-16'!CE9","v":0},{"$f":"'2015-16'!CF9","v":0},{"$f":"'2015-16'!CG9","v":0},{"$f":"'2015-16'!CH9","v":0},{"$f":"'2015-16'!CI9","v":0},{"$f":"'2015-16'!CJ9","v":0},{"$f":"'2015-16'!CK9","v":0},{"$f":"'2015-16'!CL9","v":0},0]
[]
[null,null,"2016/17"]
[null,null,"Cost type"]
[null,null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","Decommissioning","Other","Total"]
[null,"Total Project Cost",{"$f":"'2016-17'!G9","v":0},{"$f":"'2016-17'!H9","v":0},{"$f":"'2016-17'!I9","v":0},{"$f":"'2016-17'!J9","v":0},{"$f":"'2016-17'!K9","v":0},{"$f":"'2016-17'!L9","v":0},{"$f":"'2016-17'!M9","v":0},{"$f":"'2016-17'!N9","v":0},{"$f":"'2016-17'!O9","v":0},{"$f":"'2016-17'!P9","v":0},{"$f":"SUM(C44:L44)","v":0}]
[null,"Project Partner 1",{"$f":"'2016-17'!AK9","v":0},{"$f":"'2016-17'!AL9","v":0},{"$f":"'2016-17'!AM9","v":0},{"$f":"'2016-17'!AN9","v":0},{"$f":"'2016-17'!AO9","v":0},{"$f":"'2016-17'!AP9","v":0},{"$f":"'2016-17'!AQ9","v":0},{"$f":"'2016-17'!AR9","v":0},{"$f":"'2016-17'!AS9","v":0},{"$f":"'2016-17'!AT9","v":0},0]
[null,"Project Partner 2",{"$f":"'2016-17'!AV9","v":0},{"$f":"'2016-17'!AW9","v":0},{"$f":"'2016-17'!AX9","v":0},{"$f":"'2016-17'!AY9","v":0},{"$f":"'2016-17'!AZ9","v":0},{"$f":"'2016-17'!BA9","v":0},{"$f":"'2016-17'!BB9","v":0},{"$f":"'2016-17'!BC9","v":0},{"$f":"'2016-17'!BD9","v":0},{"$f":"'2016-17'!BE9","v":0},0]
[null,"Project Partner 3",{"$f":"'2016-17'!BG9","v":0},{"$f":"'2016-17'!BH9","v":0},{"$f":"'2016-17'!BI9","v":0},{"$f":"'2016-17'!BJ9","v":0},{"$f":"'2016-17'!BK9","v":0},{"$f":"'2016-17'!BL9","v":0},{"$f":"'2016-17'!BM9","v":0},{"$f":"'2016-17'!BN9","v":0},{"$f":"'2016-17'!BO9","v":0},{"$f":"'2016-17'!BP9","v":0},0]
[null,"External Funding",{"$f":"SUM(C45:C47)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"DNO extra contribution",{"$f":"'2016-17'!BR9","v":0},{"$f":"'2016-17'!BS9","v":0},{"$f":"'2016-17'!BT9","v":0},{"$f":"'2016-17'!BU9","v":0},{"$f":"'2016-17'!BV9","v":0},{"$f":"'2016-17'!BW9","v":0},{"$f":"'2016-17'!BX9","v":0},{"$f":"'2016-17'!BY9","v":0},{"$f":"'2016-17'!BZ9","v":0},{"$f":"'2016-17'!CA9","v":0},0]
[null,"Initial Net Funding Required",{"$f":"C44-C48-C49","v":0},{"$f":"D44-D48-D49","v":0},0,{"$f":"F44-F48-F49","v":0},0,0,0,0,0,0,0]
[null,"DNO Compulsory Contribution / Direct Benefits",{"$f":"'2016-17'!Z9","v":0},{"$f":"'2016-17'!AA9","v":0},{"$f":"'2016-17'!AB9","v":0},{"$f":"'2016-17'!AC9","v":0},{"$f":"'2016-17'!AD9","v":0},{"$f":"'2016-17'!AE9","v":0},{"$f":"'2016-17'!AF9","v":0},{"$f":"'2016-17'!AG9","v":0},{"$f":"'2016-17'!AH9","v":0},{"$f":"'2016-17'!AI9","v":0},0]
[null,"Outstanding Funding Required",{"$f":"'2016-17'!CC9","v":0},{"$f":"'2016-17'!CD9","v":0},{"$f":"'2016-17'!CE9","v":0},{"$f":"'2016-17'!CF9","v":0},{"$f":"'2016-17'!CG9","v":0},{"$f":"'2016-17'!CH9","v":0},{"$f":"'2016-17'!CI9","v":0},{"$f":"'2016-17'!CJ9","v":0},{"$f":"'2016-17'!CK9","v":0},{"$f":"'2016-17'!CL9","v":0},0]
[]
[null,null,"2017/18"]
[null,null,"Cost type"]
[null,null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","Decommissioning","Other","Total"]
[null,"Total Project Cost",{"$f":"'2017-18'!G9","v":0},{"$f":"'2017-18'!H9","v":0},{"$f":"'2017-18'!I9","v":0},{"$f":"'2017-18'!J9","v":0},{"$f":"'2017-18'!K9","v":0},{"$f":"'2017-18'!L9","v":0},{"$f":"'2017-18'!M9","v":0},{"$f":"'2017-18'!N9","v":0},{"$f":"'2017-18'!O9","v":0},{"$f":"'2017-18'!P9","v":0},{"$f":"SUM(C57:L57)","v":0}]
[null,"Project Partner 1",{"$f":"'2017-18'!AK9","v":0},{"$f":"'2017-18'!AL9","v":0},{"$f":"'2017-18'!AM9","v":0},{"$f":"'2017-18'!AN9","v":0},{"$f":"'2017-18'!AO9","v":0},{"$f":"'2017-18'!AP9","v":0},{"$f":"'2017-18'!AQ9","v":0},{"$f":"'2017-18'!AR9","v":0},{"$f":"'2017-18'!AS9","v":0},{"$f":"'2017-18'!AT9","v":0},{"$f":"SUM(C58:L58)","v":0}]
[null,"Project Partner 2",{"$f":"'2017-18'!AV9","v":0},{"$f":"'2017-18'!AW9","v":0},{"$f":"'2017-18'!AX9","v":0},{"$f":"'2017-18'!AY9","v":0},{"$f":"'2017-18'!AZ9","v":0},{"$f":"'2017-18'!BA9","v":0},{"$f":"'2017-18'!BB9","v":0},{"$f":"'2017-18'!BC9","v":0},{"$f":"'2017-18'!BD9","v":0},{"$f":"'2017-18'!BE9","v":0},0]
[null,"Project Partner 3",{"$f":"'2017-18'!BG9","v":0},{"$f":"'2017-18'!BH9","v":0},{"$f":"'2017-18'!BI9","v":0},{"$f":"'2017-18'!BJ9","v":0},{"$f":"'2017-18'!BK9","v":0},{"$f":"'2017-18'!BL9","v":0},{"$f":"'2017-18'!BM9","v":0},{"$f":"'2017-18'!BN9","v":0},{"$f":"'2017-18'!BO9","v":0},{"$f":"'2017-18'!BP9","v":0},{"$f":"SUM(C60:L60)","v":0}]
[null,"External Funding",{"$f":"SUM(C58:C60)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"DNO extra contribution",{"$f":"'2017-18'!BR9","v":0},{"$f":"'2017-18'!BS9","v":0},{"$f":"'2017-18'!BT9","v":0},{"$f":"'2017-18'!BU9","v":0},{"$f":"'2017-18'!BV9","v":0},{"$f":"'2017-18'!BW9","v":0},{"$f":"'2017-18'!BX9","v":0},{"$f":"'2017-18'!BY9","v":0},{"$f":"'2017-18'!BZ9","v":0},{"$f":"'2017-18'!CA9","v":0},0]
[null,"Initial Net Funding Required",{"$f":"C57-C61-C62","v":0},{"$f":"D57-D61-D62","v":0},0,0,0,0,0,0,0,0,0]
[null,"DNO Compulsory Contribution / Direct Benefits",{"$f":"'2017-18'!Z9","v":0},{"$f":"'2017-18'!AA9","v":0},{"$f":"'2017-18'!AB9","v":0},{"$f":"'2017-18'!AC9","v":0},{"$f":"'2017-18'!AD9","v":0},{"$f":"'2017-18'!AE9","v":0},{"$f":"'2017-18'!AF9","v":0},{"$f":"'2017-18'!AG9","v":0},{"$f":"'2017-18'!AH9","v":0},{"$f":"'2017-18'!AI9","v":0},0]
[null,"Outstanding Funding Required",{"$f":"'2017-18'!CC9","v":0},{"$f":"'2017-18'!CD9","v":0},{"$f":"'2017-18'!CE9","v":0},{"$f":"'2017-18'!CF9","v":0},{"$f":"'2017-18'!CG9","v":0},{"$f":"'2017-18'!CH9","v":0},{"$f":"'2017-18'!CI9","v":0},{"$f":"'2017-18'!CJ9","v":0},{"$f":"'2017-18'!CK9","v":0},{"$f":"'2017-18'!CL9","v":0},{"$f":"SUM(C65:L65)","v":0}]
[]
[null,null,"2018/19"]
[null,null,"Cost type"]
[null,null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","Decommissioning","Other","Total"]
[null,"Total Project Cost",{"$f":"'2018-19'!G9","v":0},{"$f":"'2018-19'!H9","v":0},{"$f":"'2018-19'!I9","v":0},{"$f":"'2018-19'!J9","v":0},{"$f":"'2018-19'!K9","v":0},{"$f":"'2018-19'!L9","v":0},{"$f":"'2018-19'!M9","v":0},{"$f":"'2018-19'!N9","v":0},{"$f":"'2018-19'!O9","v":0},{"$f":"'2018-19'!P9","v":0},{"$f":"SUM(C70:L70)","v":0}]
[null,"Project Partner 1",{"$f":"'2018-19'!AK9","v":0},{"$f":"'2018-19'!AL9","v":0},{"$f":"'2018-19'!AM9","v":0},{"$f":"'2018-19'!AN9","v":0},{"$f":"'2018-19'!AO9","v":0},{"$f":"'2018-19'!AP9","v":0},{"$f":"'2018-19'!AQ9","v":0},{"$f":"'2018-19'!AR9","v":0},{"$f":"'2018-19'!AS9","v":0},{"$f":"'2018-19'!AT9","v":0},0]
[null,"Project Partner 2",{"$f":"'2018-19'!AV9","v":0},{"$f":"'2018-19'!AW9","v":0},{"$f":"'2018-19'!AX9","v":0},{"$f":"'2018-19'!AY9","v":0},{"$f":"'2018-19'!AZ9","v":0},{"$f":"'2018-19'!BA9","v":0},{"$f":"'2018-19'!BB9","v":0},{"$f":"'2018-19'!BC9","v":0},{"$f":"'2018-19'!BD9","v":0},{"$f":"'2018-19'!BE9","v":0},0]
[null,"Project Partner 3",{"$f":"'2018-19'!BG9","v":0},{"$f":"'2018-19'!BH9","v":0},{"$f":"'2018-19'!BI9","v":0},{"$f":"'2018-19'!BJ9","v":0},{"$f":"'2018-19'!BK9","v":0},{"$f":"'2018-19'!BL9","v":0},{"$f":"'2018-19'!BM9","v":0},{"$f":"'2018-19'!BN9","v":0},{"$f":"'2018-19'!BO9","v":0},{"$f":"'2018-19'!BP9","v":0},0]
[null,"External Funding",{"$f":"SUM(C71:C73)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"DNO extra contribution",{"$f":"'2018-19'!BR9","v":0},{"$f":"'2018-19'!BS9","v":0},{"$f":"'2018-19'!BT9","v":0},{"$f":"'2018-19'!BU9","v":0},{"$f":"'2018-19'!BV9","v":0},{"$f":"'2018-19'!BW9","v":0},{"$f":"'2018-19'!BX9","v":0},{"$f":"'2018-19'!BY9","v":0},{"$f":"'2018-19'!BZ9","v":0},{"$f":"'2018-19'!CA9","v":0},0]
[null,"Initial Net Funding Required",{"$f":"C70-C74-C75","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"DNO Compulsory Contribution",{"$f":"'2018-19'!Z9","v":0},{"$f":"'2018-19'!AA9","v":0},{"$f":"'2018-19'!AB9","v":0},{"$f":"'2018-19'!AC9","v":0},{"$f":"'2018-19'!AD9","v":0},{"$f":"'2018-19'!AE9","v":0},{"$f":"'2018-19'!AF9","v":0},{"$f":"'2018-19'!AG9","v":0},{"$f":"'2018-19'!AH9","v":0},{"$f":"'2018-19'!AI9","v":0},0]
[null,"Outstanding Funding Required",{"$f":"'2018-19'!CC9","v":0},{"$f":"'2018-19'!CD9","v":0},{"$f":"'2018-19'!CE9","v":0},{"$f":"'2018-19'!CF9","v":0},{"$f":"'2018-19'!CG9","v":0},{"$f":"'2018-19'!CH9","v":0},{"$f":"'2018-19'!CI9","v":0},{"$f":"'2018-19'!CJ9","v":0},{"$f":"'2018-19'!CK9","v":0},{"$f":"'2018-19'!CL9","v":0},0]
[]
[null,null,"2019/20"]
[null,null,"Cost type"]
[null,null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","Decommissioning","Other","Total"]
[null,"Total Project Cost",{"$f":"'2019-20'!G9","v":0},{"$f":"'2019-20'!H9","v":0},{"$f":"'2019-20'!I9","v":0},{"$f":"'2019-20'!J9","v":0},{"$f":"'2019-20'!K9","v":0},{"$f":"'2019-20'!L9","v":0},{"$f":"'2019-20'!M9","v":0},{"$f":"'2019-20'!N9","v":0},{"$f":"'2019-20'!O9","v":0},{"$f":"'2019-20'!P9","v":0},{"$f":"SUM(C83:L83)","v":0}]
[null,"Project Partner 1",{"$f":"'2019-20'!AK9","v":0},{"$f":"'2019-20'!AL9","v":0},{"$f":"'2019-20'!AM9","v":0},{"$f":"'2019-20'!AN9","v":0},{"$f":"'2019-20'!AO9","v":0},{"$f":"'2019-20'!AP9","v":0},{"$f":"'2019-20'!AQ9","v":0},{"$f":"'2019-20'!AR9","v":0},{"$f":"'2019-20'!AS9","v":0},{"$f":"'2019-20'!AT9","v":0},0]
[null,"Project Partner 2",{"$f":"'2019-20'!AV9","v":0},{"$f":"'2019-20'!AW9","v":0},{"$f":"'2019-20'!AX9","v":0},{"$f":"'2019-20'!AY9","v":0},{"$f":"'2019-20'!AZ9","v":0},{"$f":"'2019-20'!BA9","v":0},{"$f":"'2019-20'!BB9","v":0},{"$f":"'2019-20'!BC9","v":0},{"$f":"'2019-20'!BD9","v":0},{"$f":"'2019-20'!BE9","v":0},0]
[null,"Project Partner 3",{"$f":"'2019-20'!BG9","v":0},{"$f":"'2019-20'!BH9","v":0},{"$f":"'2019-20'!BI9","v":0},{"$f":"'2019-20'!BJ9","v":0},{"$f":"'2019-20'!BK9","v":0},{"$f":"'2019-20'!BL9","v":0},{"$f":"'2019-20'!BM9","v":0},{"$f":"'2019-20'!BN9","v":0},{"$f":"'2019-20'!BO9","v":0},{"$f":"'2019-20'!BP9","v":0},0]
[null,"External Funding",{"$f":"SUM(C84:C86)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"DNO extra contribution",{"$f":"'2019-20'!BR9","v":0},{"$f":"'2019-20'!BS9","v":0},{"$f":"'2019-20'!BT9","v":0},{"$f":"'2019-20'!BU9","v":0},{"$f":"'2019-20'!BV9","v":0},{"$f":"'2019-20'!BW9","v":0},{"$f":"'2019-20'!BX9","v":0},{"$f":"'2019-20'!BY9","v":0},{"$f":"'2019-20'!BZ9","v":0},{"$f":"'2019-20'!CA9","v":0},0]
[null,"Initial Net Funding Required",{"$f":"C83-C87-C88","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"DNO Compulsory Contribution",{"$f":"'2019-20'!Z9","v":0},{"$f":"'2019-20'!AA9","v":0},{"$f":"'2019-20'!AB9","v":0},{"$f":"'2019-20'!AC9","v":0},{"$f":"'2019-20'!AD9","v":0},{"$f":"'2019-20'!AE9","v":0},{"$f":"'2019-20'!AF9","v":0},{"$f":"'2019-20'!AG9","v":0},{"$f":"'2019-20'!AH9","v":0},{"$f":"'2019-20'!AI9","v":0},0]
[null,"Outstanding Funding Required",{"$f":"'2019-20'!CC9","v":0},{"$f":"'2019-20'!CD9","v":0},{"$f":"'2019-20'!CE9","v":0},{"$f":"'2019-20'!CF9","v":0},{"$f":"'2019-20'!CG9","v":0},{"$f":"'2019-20'!CH9","v":0},{"$f":"'2019-20'!CI9","v":0},{"$f":"'2019-20'!CJ9","v":0},{"$f":"'2019-20'!CK9","v":0},{"$f":"'2019-20'!CL9","v":0},0]

{"sheet":"2014-15","index":4,"n_rows":255,"n_cols":90,"rows_kept":255,"cut":false,"hidden":false,"merged":[[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],[3,69,3,78]]}
[null,"Project Costs in 2014-15"]
[]
[]
[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,"DNO 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,"DNO 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","Contigency","Decommissioning","Other",null,"DNO Compulsory Contribution\n/Direct Benefits","Project Partner 1","Project Partner 2","Project Partner 3","DNO Extra Contribution","Oustanding Funding Required","Total",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","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":"2015-16","index":5,"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 2015-16"]
[]
[]
[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,"DNO 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,"DNO 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","Contigency","Decommissioning","Other",null,"DNO Compulsory Contribution\n/Direct Benefits","Project Partner 1","Project Partner 2","Project Partner 3","DNO Extra Contribution","Oustanding Funding Required","Total",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","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":"2016-17","index":6,"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 2016-17"]
[]
[]
[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,"DNO 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,"DNO 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","Contigency","Decommissioning","Other",null,"DNO Compulsory Contribution\n/Direct Benefits","Project Partner 1","Project Partner 2","Project Partner 3","DNO Extra Contribution","Oustanding Funding Required","Total",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","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":"2017-18","index":7,"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 2017-18"]
[]
[]
[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,"DNO 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,"DNO 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","Contigency","Decommissioning","Other",null,"DNO Compulsory Contribution\n/Direct Benefits","Project Partner 1","Project Partner 2","Project Partner 3","DNO Extra Contribution","Oustanding Funding Required","Total",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","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":"2018-19","index":8,"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 2018-19"]
[]
[]
[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,"DNO 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,"DNO 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","Contigency","Decommissioning","Other",null,"DNO Compulsory Contribution\n/Direct Benefits","Project Partner 1","Project Partner 2","Project Partner 3","DNO Extra Contribution","Oustanding Funding Required","Total",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","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":"2019-20","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 2019-20"]
[]
[]
[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,"DNO 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,"DNO 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","Contigency","Decommissioning","Other",null,"DNO Compulsory Contribution\n/Direct Benefits","Project Partner 1","Project Partner 2","Project Partner 3","DNO Extra Contribution","Oustanding Funding Required","Total",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","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":10,"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 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,"DNO 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,"DNO 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","Contigency","Decommissioning","Other",null,"DNO Compulsory Contribution\n/Direct Benefits","Project Partner 1","Project Partner 2","Project Partner 3","DNO Extra Contribution","Oustanding Funding Required","Total",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contigency","Decommissioning","Other"]
[null,"Description","Task","Project Workstream"]
[null,null,null,null,null,null,{"$f":"'2014-15'!G7+'2015-16'!G7+'2016-17'!G7+'2017-18'!G7+'2018-19'!G7+'2019-20'!G7","v":0},{"$f":"'2014-15'!H7+'2015-16'!H7+'2016-17'!H7+'2017-18'!H7+'2018-19'!H7+'2019-20'!H7","v":0},{"$f":"'2014-15'!I7+'2015-16'!I7+'2016-17'!I7+'2017-18'!I7+'2018-19'!I7+'2019-20'!I7","v":0},{"$f":"'2014-15'!J7+'2015-16'!J7+'2016-17'!J7+'2017-18'!J7+'2018-19'!J7+'2019-20'!J7","v":0},{"$f":"'2014-15'!K7+'2015-16'!K7+'2016-17'!K7+'2017-18'!K7+'2018-19'!K7+'2019-20'!K7","v":0},{"$f":"'2014-15'!L7+'2015-16'!L7+'2016-17'!L7+'2017-18'!L7+'2018-19'!L7+'2019-20'!L7","v":0},{"$f":"'2014-15'!M7+'2015-16'!M7+'2016-17'!M7+'2017-18'!M7+'2018-19'!M7+'2019-20'!M7","v":0},{"$f":"'2014-15'!N7+'2015-16'!N7+'2016-17'!N7+'2017-18'!N7+'2018-19'!N7+'2019-20'!N7","v":0},{"$f":"'2014-15'!O7+'2015-16'!O7+'2016-17'!O7+'2017-18'!O7+'2018-19'!O7+'2019-20'!O7","v":0},{"$f":"'2014-15'!P7+'2015-16'!P7+'2016-17'!P7+'2017-18'!P7+'2018-19'!P7+'2019-20'!P7","v":0},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,{"$f":"'2014-15'!G8+'2015-16'!G8+'2016-17'!G8+'2017-18'!G8+'2018-19'!G8+'2019-20'!G8","v":0},{"$f":"'2014-15'!H8+'2015-16'!H8+'2016-17'!H8+'2017-18'!H8+'2018-19'!H8+'2019-20'!H8","v":0},{"$f":"'2014-15'!I8+'2015-16'!I8+'2016-17'!I8+'2017-18'!I8+'2018-19'!I8+'2019-20'!I8","v":0},{"$f":"'2014-15'!J8+'2015-16'!J8+'2016-17'!J8+'2017-18'!J8+'2018-19'!J8+'2019-20'!J8","v":0},{"$f":"'2014-15'!K8+'2015-16'!K8+'2016-17'!K8+'2017-18'!K8+'2018-19'!K8+'2019-20'!K8","v":0},{"$f":"'2014-15'!L8+'2015-16'!L8+'2016-17'!L8+'2017-18'!L8+'2018-19'!L8+'2019-20'!L8","v":0},{"$f":"'2014-15'!M8+'2015-16'!M8+'2016-17'!M8+'2017-18'!M8+'2018-19'!M8+'2019-20'!M8","v":0},{"$f":"'2014-15'!N8+'2015-16'!N8+'2016-17'!N8+'2017-18'!N8+'2018-19'!N8+'2019-20'!N8","v":0},{"$f":"'2014-15'!O8+'2015-16'!O8+'2016-17'!O8+'2017-18'!O8+'2018-19'!O8+'2019-20'!O8","v":0},{"$f":"'2014-15'!P8+'2015-16'!P8+'2016-17'!P8+'2017-18'!P8+'2018-19'!P8+'2019-20'!P8","v":0},"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":"Project Direction","index":11,"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'!CC9","v":0}]
[null,null,"Equipment"]
[null,null,null,{"$f":"'Whole project'!CD9","v":0}]
[null,null,"Contractors"]
[null,null,null,{"$f":"'Whole project'!CE9","v":0}]
[null,null,"IT"]
[null,null,null,{"$f":"'Whole project'!CF9","v":0}]
[null,null,"IPR Costs"]
[null,null,null,{"$f":"'Whole project'!CG9","v":0}]
[null,null,"Travel & Expenses"]
[null,null,null,{"$f":"'Whole project'!CH9","v":0}]
[null,null,"Payments to users"]
[null,null,null,{"$f":"'Whole project'!CI9","v":0}]
[null,null,"Contigency"]
[null,null,null,{"$f":"'Whole project'!CJ9","v":0}]
[null,null,"Decommissioning"]
[null,null,null,{"$f":"'Whole project'!CK9","v":0}]
[null,null,"Other"]
[null,null,null,{"$f":"'Whole project'!CL9","v":0},"Check that = to Total Outstanding Funding Required"]
[null,null,"Total",{"$f":"SUM(D6:D24)","v":0},{"$f":"IF(D25='Second Tier Funding Request'!I79,\"OK\", \"ERROR\")","v":"OK"}]

{"sheet":"Net benefits","index":12,"n_rows":56,"n_cols":28,"rows_kept":56,"cut":false,"hidden":false,"merged":[[40,1,40,2],[46,1,46,2],[13,1,13,2],[7,1,7,2]]}
[]
[null,"Net Benefits"]
[]
[null,"DNOs can provide notes alongside costing in order to aid understanding of why these costs are required. This should be supplemented by a fuller qualitative account of the Base Case method and Method in the appendices. "]
[]
[null,"Method 1 - "]
[]
["(a)","Base Case costs"]
[null,"Description of cost","Cost (£)"]
[]
[]
[null,"Total",{"$f":"SUM(C10:C11)","v":0}]
[]
["(b)","Method costs"]
[null,"Description of cost","Cost (£)"]
[]
[]
[null,"Total",{"$f":"SUM(C16:C17)","v":0}]
[]
[null,"Net financial benefit",{"$f":"C12-C18","v":0}]
[]
["(c)","Capacity released (kW)"]
[]
["(d)","Base Case time (months)"]
[]
["(e)","Method time (months)"]
[]
[]
["(f)","Year",2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040]
[null,"Total sites where method replicated"]
[]
[]
[null,"Method 2 - "]
[]
["(a)","Capacity released (kW)"]
[]
["(b)","Base Case time (months)"]
[]
["(c)","Method time (months)"]
[]
["(d)","Base Case costs"]
[null,"Description of cost","Cost (£)"]
[]
[]
[null,"Total",{"$f":"SUM(C43:C44)","v":0}]
[]
["(e)","Method costs"]
[null,"Description of cost","Cost (£)"]
[]
[]
[null,"Total",{"$f":"SUM(C49:C50)","v":0}]
[]
[null,"Net financial benefit",{"$f":"C45-C51","v":0}]
[]
["(f)","Year",2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040]
[null,"Total sites where method replicated"]