{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Cover","Documentation -->","Style Guide","ToC","Inputs-->","InpActive","Calc-->","Indexation","Time","Innovation funding return","Outputs-->","Outputs","Integrity checks-->","Check"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":61,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Cover","index":0,"n_rows":45,"n_cols":6,"rows_kept":45,"cut":false,"hidden":false,"merged":[[34,4,35,4],[34,3,35,3],[34,2,35,2],[27,4,28,4],[27,3,28,3],[27,2,28,2],[31,4,33,4],[31,3,33,3],[31,2,33,2]]}
[{"$f":" RIGHT(CELL(\"filename\", $B$1), LEN(CELL(\"filename\", $B$1)) - SEARCH(\"]\", CELL(\"filename\", $B$1)))","v":"Cover"}]
[]
[null,"Workbook title:","PR19 Innovation Funding reconciliation model"]
[null,"Version:","2b"]
[null,"Filename:","PR19-Innovation-funding-reconciliation-model-Dec-2020-v2b.xlsm"]
[null,"Date:","2020-12-02"]
[null,"Author:","Ofwat"]
[null,"Author contact information:","OfwatPandO@ofwat.gov.uk"]
[]
[]
[null,"Summary of workbook:","The model is a whole of industry model with inputs and outputs for all companies housed within one model. "]
[null,null,"The model calculates the total amount of unused funds to be redistributed to individual companies’ customers. "]
[null,null,"This is done in line with the original allocation methodology set out in PR19 Final Determinations."]
[null,null,"Inputs and calculations are in outturn prices before being converted into real terms 2017-18 CPIH FYA. A time value of"]
[null,null,"money adjustment is also made discounted to 2024-25 prices."]
[]
[null,"Known limitations:","n/a"]
[]
[null,"Instructions:","Inputs are added at industry level on InpOverride. "]
[null,null,"Calculations are completed on the sheet 'Innovation funding return' to calculated any unused and uncommitted funding. "]
[null,null,"Unused funding is redistributed as per the original proportions ."]
[]
[null,"Changes","Below are details of changes to the model from the previously published version (version 1e 27/02/2020). "]
[null,null,"The changes fix issues that have been identified and implement improvements for clarity and ease of use."]
[]
[null,null,"Category","Sheet(s) in current model","Description of change(s) made","Model link(s)"]
[null,null,"Refinement","Innovation funding return","The formula for the proportion of innovation funding has been amended to remove the #REF error within it. ",{"$f":"'Innovation funding return'!F72","v":0.10493392088708854}]
[null,null,"Logic Update","InpActive, Innovation funding return","The inputs for innovation funding return have been amended from outturn prices to be in real prices (2017-18 CPIH FYA) in order to align funding to the allowances in the PR19 final determinations. These are coverted into nominal prices in the model.",{"$f":"InpActive!E28","v":"ANH - Allocated innovation funding - Real"}]
[null,null,null,null,null,{"$f":"'Innovation funding return'!$E$31","v":"ANH - Allocated innovation funding - Nominal"}]
[null,null,"Logic Update","Innovation funding return","Check has been amended to check if funding over the AMP is negative rather than in a single year. This applies to all companies and industry",{"$f":"'Innovation funding return'!E297","v":"Negative funding check"}]
[null,null,"Logic Update","Innovation funding return","The calculation of total unused funding has been amended to be total allocated funding less total funding transferred.",{"$f":"'Innovation funding return'!E219","v":"Total Transferred - Nominal"}]
[null,null,"Refinement","InpActive, Innovation funding return","Additional lines have been added to the model for awarded funding and expenditure for NAV bids",{"$f":"'Innovation funding return'!$E$130","v":"NAV - Bids Accepted & Funding Awarded - Nominal"}]
[null,null,null,null,null,{"$f":"'Innovation funding return'!$E$153","v":"NAV - Expenditure on innovation spend to date - Nominal"}]
[null,null,null,null,null,{"$f":"'Innovation funding return'!$E$214","v":"NAV - Allowed Future expenditure on innovation projects - Nominal"}]
[null,null,"Refinement","InpActive, Innovation funding return","Additional inputs included for adminstrative costs of the innovation fund",{"$f":"InpActive!E112","v":"ANH - Administrative charge for innovation fund - Nominal"}]
[null,null,null,null,null,{"$f":"'Innovation funding return'!E176","v":"ANH - Total spend to date - Nominal"}]
[null,null,"Refinement","InpActive","Check added to the model to ensure funding awarded is the same as funding transferred",{"$f":"InpActive!E89","v":"Total awarded check"}]
[]
[null,"References:","APR Table 9a"]
[]
[null,"Error Checks:",{"$f":"Check!B$8","v":0}]
[]
[]
[]
[null,"END OF SHEET"]

{"sheet":"Documentation -->","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Style Guide","index":2,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Style Guide"}]
[]
["SHEET TABS"]
[]
[null,null,null,null,null,null,null,"Light Yellow",null,"Input sheets"]
[]
[null,null,null,null,null,null,null,"No colour (default Excel tab colour)",null,"Calculation and documentation sheets"]
[]
[null,null,null,null,null,null,null,"Pale Blue",null,"Key output sheets"]
[]
[null,null,null,null,null,null,null,"Turquoise",null,"Quality control sheets"]
[]
[null,null,null,null,null,null,null,"Yellow",null,"To be completed, temporary, restructured, or deleted"]
[]
[]
["COLOUR"]
[]
[null,"Font colour only"]
[null,null,null,null,null,null,null,"Blue font",null,"Imported from another sheet"]
[]
[null,null,null,null,null,null,null,"Red font ",null,"Exported to another sheet (except from Input sheets)"]
[]
[null,null,null,null,null,null,null,"Black font",null,"Within sheet link or calculation"]
[]
[null,"Font + shade combinations"]
[null,null,null,null,null,null,null,"Black font + Light Yellow shade",null,"Inputs"]
[]
[null,null,null,null,null,null,null,"Black font + Light Yellow shade with grey stripe",null,"Inputs that are not expected to be changed"]
[]
[null,null,null,null,null,null,null,"Black font + Light Grey shade on entire row",null,"Within-worksheet counter-flow "]
[]
[null,null,null,null,null,null,null,"Blue font + Light Grey shade on entire row",null,"Between-worksheet counter-flow "]
[]
[null,null,null,null,null,null,null,"Empty Cell with Light Grey shade",null,"Empty cells being deliberately referenced"]
[]
[null,"Other"]
[null,null,null,null,null,null,null,"Black font + Pale Blue shade on entire row",null,"Section separator"]
[]
[null,null,null,null,null,null,null,"Light Turquoise shade",null,"Stored/dead/hard coded outputs"]
[]
[null,null,null,null,null,null,null,"Tan shade",null,"Pre-model time line actuals"]
[]
[null,null,null,null,null,null,null,"Yellow shade",null,"Work in progress / temporary"]
[]
[null,null,null,null,null,null,null,"Lime shade",null,"Values or logic to be reviewed"]
[]
[null,"Error checks"]
[null,null,null,null,null,null,null,"Green shade",null,"OK"]
[]
[null,null,null,null,null,null,null,"Red shade",null,"Error"]
[]
["End of sheet"]

{"sheet":"ToC","index":3,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"ToC"}]
[]
[null,"ASSUMPTIONS",null,"INPUTS",null,"CALCULATIONS",null,"OUTPUTS",null,"Quality Control"]
[]
[null,{"$f":"Cover!B1","v":0},null,{"$f":"InpActive!A1","v":"InpActive"},null,{"$f":"Indexation!A1","v":"Indexation"},null,{"$f":"Outputs!A1","v":"Outputs"},null,{"$f":"Check!A1","v":"Check"}]
[null,"Model documentation sheet",null,"Inputs sheet",null,"All the indexation related calculations are done in this sheet.",null,"Main ouput sheet showing total to be redistributed",null,"Contains all the model integrity checks and alerts"]
[]
[null,"Style Guide",null,null,null,{"$f":"Time!A1","v":"Time"}]
[null,"Explanation of different formatting types",null,null,null,"The model timeline and flag calculations are done in this sheet."]
[]
[null,{"$f":"$A$1","v":"ToC"},null,null,null,{"$f":"'Innovation funding return'!A1","v":"Innovation funding return"}]
[null,"Table of contents",null,null,null,"Calculated the total unused funding to be restributed"]
[]
[]
[]
[]
[]
["End of sheet"]

{"sheet":"Inputs-->","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"InpActive","index":5,"n_rows":210,"n_cols":16,"rows_kept":210,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"InpActive"}]
[null,null,null,null,{"$f":"Time!E$22","v":"Model Period BEG"},null,null,null,null,{"$f":"Time!J$22","v":"2019-04-01"},{"$f":"Time!K$22","v":"2020-04-01"},{"$f":"Time!L$22","v":"2021-04-01"},{"$f":"Time!M$22","v":"2022-04-01"},{"$f":"Time!N$22","v":"2023-04-01"},{"$f":"Time!O$22","v":"2024-04-01"},{"$f":"Time!P$22","v":"2025-04-01"}]
[null,null,null,null,{"$f":"Time!E$23","v":"Model Period END"},{"$f":"Check!F$8","v":0},"Error chks",null,null,{"$f":"Time!J$23","v":"2020-03-31"},{"$f":"Time!K$23","v":"2021-03-31"},{"$f":"Time!L$23","v":"2022-03-31"},{"$f":"Time!M$23","v":"2023-03-31"},{"$f":"Time!N$23","v":"2024-03-31"},{"$f":"Time!O$23","v":"2025-03-31"},{"$f":"Time!P$23","v":"2026-03-31"}]
[null,null,null,null,{"$f":"Time!E$59","v":"Pre Forecast vs Forecast"},null,null,null,null,{"$f":"Time!J$59","v":"Pre Fcst"},{"$f":"Time!K$59","v":"Forecast"},{"$f":"Time!L$59","v":"Forecast"},{"$f":"Time!M$59","v":"Forecast"},{"$f":"Time!N$59","v":"Forecast"},{"$f":"Time!O$59","v":"Forecast"},{"$f":"Time!P$59","v":"Post-Fcst"}]
[null,null,null,null,{"$f":"Time!E$101","v":"Financial Year Ending"},null,null,null,null,{"$f":"Time!J$101","v":2020},{"$f":"Time!K$101","v":2021},{"$f":"Time!L$101","v":2022},{"$f":"Time!M$101","v":2023},{"$f":"Time!N$101","v":2024},{"$f":"Time!O$101","v":2025},{"$f":"Time!P$101","v":2026}]
[null,null,null,null,{"$f":"Time!E$11","v":"Model column counter"},"Constant","Unit","Total",null,{"$f":"Time!J$11","v":1},{"$f":"Time!K$11","v":2},{"$f":"Time!L$11","v":3},{"$f":"Time!M$11","v":4},{"$f":"Time!N$11","v":5},{"$f":"Time!O$11","v":6},{"$f":"Time!P$11","v":7}]
[]
["TIME"]
[]
[null,null,null,null,"First date of time ruler","2019-04-01","date"]
[]
[null,null,null,null,"Last Pre Forecast Date","2020-03-31","date"]
[]
[null,null,null,null,"Acquisition date (midnight)","2020-03-31","date"]
[null,null,null,null,"Length of forecast period",5,"years"]
[null,null,null,null,"Last forecast date",{"$f":"DATE(YEAR(F14)+F15,MONTH(F14),DAY(F14))","v":"2025-03-31"},"date"]
[]
[]
[null,null,null,null,"Operation Start Date (midnight)","2021-03-31","date"]
[null,null,null,null,"Operation Finish Date (midnight)","2025-03-31","date"]
[null,null,null,null,"First Modelling Column Financial Year Number",2020,"year"]
[null,null,null,null,"Financial Year End Month Number",3,"month #"]
[]
[]
["INNOVATION FUNDING INPUTS"]
[]
[null,null,null,"Allocated innovation competition fund price control revenue"]
[null,null,null,null,"ANH - Allocated innovation funding - Real",null,"£m",{"$f":" SUM(K28:O28)","v":20.986784177417711},null,null,4.197356835483542,4.197356835483542,4.197356835483542,4.197356835483542,4.197356835483542]
[null,null,null,null,"HDD - Allocated innovation funding - Real",null,"£m",{"$f":" SUM(K29:O29)","v":0.45489564100882784},null,null,9.0979128201765569E-2,9.0979128201765569E-2,9.0979128201765569E-2,9.0979128201765569E-2,9.0979128201765569E-2]
[null,null,null,null,"NES - Allocated innovation funding - Real",null,"£m",11.78510500359587,null,null,2.3570210007191741,2.3570210007191741,2.3570210007191741,2.3570210007191741,2.3570210007191741]
[null,null,null,null,"NWT - Allocated innovation funding - Real",null,"£m",29.370061153780984,null,null,5.8740122307561968,5.8740122307561968,5.8740122307561968,5.8740122307561968,5.8740122307561968]
[null,null,null,null,"SRN - Allocated innovation funding - Real",null,"£m",13.297786739206252,null,null,2.6595573478412504,2.6595573478412504,2.6595573478412504,2.6595573478412504,2.6595573478412504]
[null,null,null,null,"SVE - Allocated innovation funding - Real",null,"£m",28.382107404963808,null,null,5.6764214809927616,5.6764214809927616,5.6764214809927616,5.6764214809927616,5.6764214809927616]
[null,null,null,null,"SWB - Allocated innovation funding - Real",null,"£m",8.8206411500853914,null,null,1.7641282300170782,1.7641282300170782,1.7641282300170782,1.7641282300170782,1.7641282300170782]
[null,null,null,null,"TMS - Allocated innovation funding - Real",null,"£m",34.32930907435577,null,null,6.8658618148711543,6.8658618148711543,6.8658618148711543,6.8658618148711543,6.8658618148711543]
[null,null,null,null,"WSH - Allocated innovation funding - Real",null,"£m",12.357734690289989,null,null,2.471546938057998,2.471546938057998,2.471546938057998,2.471546938057998,2.471546938057998]
[null,null,null,null,"WSX - Allocated innovation funding - Real",null,"£m",8.260459207972497,null,null,1.6520918415944994,1.6520918415944994,1.6520918415944994,1.6520918415944994,1.6520918415944994]
[null,null,null,null,"YKY - Allocated innovation funding - Real",null,"£m",17.59261305721526,null,null,3.5185226114430521,3.5185226114430521,3.5185226114430521,3.5185226114430521,3.5185226114430521]
[null,null,null,null,"AFW - Allocated innovation funding - Real",null,"£m",4.8432347733847161,null,null,0.96864695467694317,0.96864695467694317,0.96864695467694317,0.96864695467694317,0.96864695467694317]
[null,null,null,null,"BRL - Allocated innovation funding - Real",null,"£m",1.8912269294760475,null,null,0.37824538589520951,0.37824538589520951,0.37824538589520951,0.37824538589520951,0.37824538589520951]
[null,null,null,null,"PRT - Allocated innovation funding - Real",null,"£m",0.64951234319729489,null,null,0.12990246863945898,0.12990246863945898,0.12990246863945898,0.12990246863945898,0.12990246863945898]
[null,null,null,null,"SES - Allocated innovation funding - Real",null,"£m",0.984054038891783,null,null,0.19681080777835661,0.19681080777835661,0.19681080777835661,0.19681080777835661,0.19681080777835661]
[null,null,null,null,"SEW - Allocated innovation funding - Real",null,"£m",3.951513618490945,null,null,0.79030272369818899,0.79030272369818899,0.79030272369818899,0.79030272369818899,0.79030272369818899]
[null,null,null,null,"SSC - Allocated innovation funding - Real",null,"£m",2.0429609966668241,null,null,0.40859219933336482,0.40859219933336482,0.40859219933336482,0.40859219933336482,0.40859219933336482]
[]
[null,null,null,"Total Funding transferred to winning bids"]
[null,null,null,null,"ANH - Total Funding transferred to winning bids - Nominal",null,"£m",{"$f":" SUM(K47:O47)","v":0}]
[null,null,null,null,"HDD - Total Funding transferred to winning bids - Nominal",null,"£m",{"$f":" SUM(K48:O48)","v":0}]
[null,null,null,null,"NES - Total Funding transferred to winning bids - Nominal",null,"£m",0]
[null,null,null,null,"NWT - Total Funding transferred to winning bids - Nominal",null,"£m",0]
[null,null,null,null,"SRN - Total Funding transferred to winning bids - Nominal",null,"£m",0]
[null,null,null,null,"SVE - Total Funding transferred to winning bids - Nominal",null,"£m",0]
[null,null,null,null,"SWB - Total Funding transferred to winning bids - Nominal",null,"£m",0]
[null,null,null,null,"TMS - Total Funding transferred to winning bids - Nominal",null,"£m",0]
[null,null,null,null,"WSH - Total Funding transferred to winning bids - Nominal",null,"£m",0]
[null,null,null,null,"WSX - Total Funding transferred to winning bids - Nominal",null,"£m",0]
[null,null,null,null,"YKY - Total Funding transferred to winning bids - Nominal",null,"£m",0]
[null,null,null,null,"AFW - Total Funding transferred to winning bids - Nominal",null,"£m",0]
[null,null,null,null,"BRL - Total Funding transferred to winning bids - Nominal",null,"£m",0]
[null,null,null,null,"PRT - Total Funding transferred to winning bids - Nominal",null,"£m",0,null,null,0,0,0,0,0]
[null,null,null,null,"SES - Total Funding transferred to winning bids - Nominal",null,"£m",0]
[null,null,null,null,"SEW - Total Funding transferred to winning bids - Nominal",null,"£m",0]
[null,null,null,null,"SSC - Total Funding transferred to winning bids - Nominal",null,"£m",0]
[null,null,null,null,"Total Funding transferred to winning bids - Nominal",{"$f":" SUM(H47:H63)","v":0},"£m"]
[]
[null,null,null,"Bids accepted and awarded funding for innovation competition"]
[null,null,null,null,"ANH - Bids Accepted & Funding Awarded - Nominal",null,"£m",{"$f":" SUM(K67:O67)","v":0}]
[null,null,null,null,"HDD - Bids Accepted & Funding Awarded - Nominal",null,"£m",{"$f":" SUM(K68:O68)","v":0}]
[null,null,null,null,"NES - Bids Accepted & Funding Awarded - Nominal",null,"£m",0]
[null,null,null,null,"NWT - Bids Accepted & Funding Awarded - Nominal",null,"£m",0]
[null,null,null,null,"SRN - Bids Accepted & Funding Awarded - Nominal",null,"£m",0]
[null,null,null,null,"SVE - Bids Accepted & Funding Awarded - Nominal",null,"£m",0]
[null,null,null,null,"SWB - Bids Accepted & Funding Awarded - Nominal",null,"£m",0]
[null,null,null,null,"TMS - Bids Accepted & Funding Awarded - Nominal",null,"£m",0]
[null,null,null,null,"WSH - Bids Accepted & Funding Awarded - Nominal",null,"£m",0]
[null,null,null,null,"WSX - Bids Accepted & Funding Awarded - Nominal",null,"£m",0]
[null,null,null,null,"YKY - Bids Accepted & Funding Awarded - Nominal",null,"£m",0]
[null,null,null,null,"AFW - Bids Accepted & Funding Awarded - Nominal",null,"£m",0]
[null,null,null,null,"BRL - Bids Accepted & Funding Awarded - Nominal",null,"£m",0]
[null,null,null,null,"PRT - Bids Accepted & Funding Awarded - Nominal",null,"£m",0,null,null,0,0,0,0,0]
[null,null,null,null,"SES - Bids Accepted & Funding Awarded - Nominal",null,"£m",0]
[null,null,null,null,"SEW - Bids Accepted & Funding Awarded - Nominal",null,"£m",0]
[null,null,null,null,"SSC - Bids Accepted & Funding Awarded - Nominal",null,"£m",0]
[null,null,null,null,"NAV - Bids Accepted & Funding Awarded - Nominal",null,"£m",0]
[null,null,null,null,"Total Bids Accepted & Funding Awarded - Nominal",{"$f":" SUM(H68:H84)","v":0},"£m"]
[]
[null,null,null,null,{"$f":"E$64","v":"Total Funding transferred to winning bids - Nominal"},{"$f":"F$64","v":0},"£m"]
[null,null,null,null,{"$f":"E$85","v":"Total Bids Accepted & Funding Awarded - Nominal"},{"$f":"F$85","v":0},"£m"]
[null,null,null,null,"Total awarded check",{"$f":" IF(F87 = F88, 0, 1)","v":0},"check"]
[]
[null,null,null,"Expenditure on innovation projects (exc. innovation activities funded through totex)  to date"]
[null,null,null,null,"ANH - Expenditure on innovation spend to date - Nominal",null,"£m",{"$f":" SUM(K92:O92)","v":0}]
[null,null,null,null,"HDD - Expenditure on innovation spend to date - Nominal",null,"£m",{"$f":" SUM(K93:O93)","v":0}]
[null,null,null,null,"NES - Expenditure on innovation spend to date - Nominal",null,"£m",0]
[null,null,null,null,"NWT - Expenditure on innovation spend to date - Nominal",null,"£m",0]
[null,null,null,null,"SRN - Expenditure on innovation spend to date - Nominal",null,"£m",0]
[null,null,null,null,"SVE - Expenditure on innovation spend to date - Nominal",null,"£m",0]
[null,null,null,null,"SWB - Expenditure on innovation spend to date - Nominal",null,"£m",0]
[null,null,null,null,"TMS - Expenditure on innovation spend to date - Nominal",null,"£m",0]
[null,null,null,null,"WSH - Expenditure on innovation spend to date - Nominal",null,"£m",0]
[null,null,null,null,"WSX - Expenditure on innovation spend to date - Nominal",null,"£m",0]
[null,null,null,null,"YKY - Expenditure on innovation spend to date - Nominal",null,"£m",0]
[null,null,null,null,"AFW - Expenditure on innovation spend to date - Nominal",null,"£m",0]
[null,null,null,null,"BRL - Expenditure on innovation spend to date - Nominal",null,"£m",0]
[null,null,null,null,"PRT - Expenditure on innovation spend to date - Nominal",null,"£m",0,null,null,0,0,0,0,0]
[null,null,null,null,"SES - Expenditure on innovation spend to date - Nominal",null,"£m",0]
[null,null,null,null,"SEW - Expenditure on innovation spend to date - Nominal",null,"£m",0]
[null,null,null,null,"SSC - Expenditure on innovation spend to date - Nominal",null,"£m",0]
[null,null,null,null,"NAV - Expenditure on innovation spend to date - Nominal",null,"£m",0]
[]
[null,null,null,"Administrative charge for innovation fund"]
[null,null,null,null,"ANH - Administrative charge for innovation fund - Nominal",null,"£m",{"$f":" SUM(K112:O112)","v":0}]
[null,null,null,null,"HDD - Administrative charge for innovation fund - Nominal",null,"£m",{"$f":" SUM(K113:O113)","v":0}]
[null,null,null,null,"NES - Administrative charge for innovation fund - Nominal",null,"£m",0]
[null,null,null,null,"NWT - Administrative charge for innovation fund - Nominal",null,"£m",0]
[null,null,null,null,"SRN - Administrative charge for innovation fund - Nominal",null,"£m",0]
[null,null,null,null,"SVE - Administrative charge for innovation fund - Nominal",null,"£m",0]
[null,null,null,null,"SWB - Administrative charge for innovation fund - Nominal",null,"£m",0]
[null,null,null,null,"TMS - Administrative charge for innovation fund - Nominal",null,"£m",0]
[null,null,null,null,"WSH - Administrative charge for innovation fund - Nominal",null,"£m",0]
[null,null,null,null,"WSX - Administrative charge for innovation fund - Nominal",null,"£m",0]
[null,null,null,null,"YKY - Administrative charge for innovation fund - Nominal",null,"£m",0]
[null,null,null,null,"AFW - Administrative charge for innovation fund - Nominal",null,"£m",0]
[null,null,null,null,"BRL - Administrative charge for innovation fund - Nominal",null,"£m",0]
[null,null,null,null,"PRT - Administrative charge for innovation fund - Nominal",null,"£m",{"$f":" SUM(K125:O125)","v":0},null,null,0,0,0,0,0]
[null,null,null,null,"SES - Administrative charge for innovation fund - Nominal",null,"£m",0]
[null,null,null,null,"SEW - Administrative charge for innovation fund - Nominal",null,"£m",0]
[null,null,null,null,"SSC - Administrative charge for innovation fund - Nominal",null,"£m",0]
[]
[null,null,null,"Allowed future expenditure on innovation projects"]
[null,null,null,null,"ANH - Allowed Future expenditure on innovation projects - Nominal",null,"£m",{"$f":" SUM(K131:O131)","v":0}]
[null,null,null,null,"HDD - Allowed Future expenditure on innovation projects - Nominal",null,"£m",{"$f":" SUM(K132:O132)","v":0}]
[null,null,null,null,"NES - Allowed Future expenditure on innovation projects - Nominal",null,"£m",0]
[null,null,null,null,"NWT - Allowed Future expenditure on innovation projects - Nominal",null,"£m",0]
[null,null,null,null,"SRN - Allowed Future expenditure on innovation projects - Nominal",null,"£m",0]
[null,null,null,null,"SVE - Allowed Future expenditure on innovation projects - Nominal",null,"£m",0]
[null,null,null,null,"SWB - Allowed Future expenditure on innovation projects - Nominal",null,"£m",0]
[null,null,null,null,"TMS - Allowed Future expenditure on innovation projects - Nominal",null,"£m",0]
[null,null,null,null,"WSH - Allowed Future expenditure on innovation projects - Nominal",null,"£m",0]
[null,null,null,null,"WSX - Allowed Future expenditure on innovation projects - Nominal",null,"£m",0]
[null,null,null,null,"YKY - Allowed Future expenditure on innovation projects - Nominal",null,"£m",0]
[null,null,null,null,"AFW - Allowed Future expenditure on innovation projects - Nominal",null,"£m",0]
[null,null,null,null,"BRL - Allowed Future expenditure on innovation projects - Nominal",null,"£m",0]
[null,null,null,null,"PRT - Allowed Future expenditure on innovation projects - Nominal",null,"£m",0,null,null,0,0,0,0,0]
[null,null,null,null,"SES - Allowed Future expenditure on innovation projects - Nominal",null,"£m",0]
[null,null,null,null,"SEW - Allowed Future expenditure on innovation projects - Nominal",null,"£m",0]
[null,null,null,null,"SSC - Allowed Future expenditure on innovation projects - Nominal",null,"£m",0]
[null,null,null,null,"NAV - Allowed Future expenditure on innovation projects - Nominal",null,"£m",{"$f":" SUM(K148:O148)","v":0}]
[]
[]
["FINANCING INPUTS"]
[]
[null,"Model Tolerance"]
[null,null,null,null,"Financing cost index",null,"Index",null,null,null,4,3,2,1,0]
[]
[null,null,null,null,"ANH - WACC",null,"%"]
[null,null,null,null,"HDD - WACC",null,"%"]
[null,null,null,null,"NES - WACC",null,"%"]
[null,null,null,null,"NWT - WACC",null,"%"]
[null,null,null,null,"SRN - WACC",null,"%"]
[null,null,null,null,"SVE - WACC",null,"%"]
[null,null,null,null,"SWB - WACC",null,"%"]
[null,null,null,null,"TMS - WACC",null,"%"]
[null,null,null,null,"WSH - WACC",null,"%"]
[null,null,null,null,"WSX - WACC",null,"%"]
[null,null,null,null,"YKY - WACC",null,"%"]
[null,null,null,null,"AFW - WACC",null,"%"]
[null,null,null,null,"BRL - WACC",null,"%"]
[null,null,null,null,"PRT - WACC",3.1099999999999999E-2,"%"]
[null,null,null,null,"SES - WACC",null,"%"]
[null,null,null,null,"SEW - WACC",null,"%"]
[null,null,null,null,"SSC - WACC",null,"%"]
[]
["INDEXATION"]
[]
[null,null,null,"CPI(H) - base index 2017-18"]
[null,null,null,null,"Consumer price index (including housing costs) - Consumer Price Index (with housing) for April",103.2,"Index"]
[null,null,null,null,"Consumer price index (including housing costs) - Consumer Price Index (with housing) for May",103.5,"Index"]
[null,null,null,null,"Consumer price index (including housing costs) - Consumer Price Index (with housing) for June",103.5,"Index"]
[null,null,null,null,"Consumer price index (including housing costs) - Consumer Price Index (with housing) for July",103.5,"Index"]
[null,null,null,null,"Consumer price index (including housing costs) - Consumer Price Index (with housing) for August",104,"Index"]
[null,null,null,null,"Consumer price index (including housing costs) - Consumer Price Index (with housing) for September",104.3,"Index"]
[null,null,null,null,"Consumer price index (including housing costs) - Consumer Price Index (with housing) for October",104.4,"Index"]
[null,null,null,null,"Consumer price index (including housing costs) - Consumer Price Index (with housing) for November",104.7,"Index"]
[null,null,null,null,"Consumer price index (including housing costs) - Consumer Price Index (with housing) for December",105,"Index"]
[null,null,null,null,"Consumer price index (including housing costs) - Consumer Price Index (with housing) for January",104.5,"Index"]
[null,null,null,null,"Consumer price index (including housing costs) - Consumer Price Index (with housing) for February",104.9,"Index"]
[null,null,null,null,"Consumer price index (including housing costs) - Consumer Price Index (with housing) for March",105.1,"Index"]
[]
[null,null,null,"CPI(H) forecast periods"]
[null,null,null,null,"Consumer price index (including housing costs) - Consumer Price Index (with housing) for April",null,"Index",null,null,107.6,108.6,110.4,119,128.30000000000001,129.71129999999999,132.30552599999999]
[null,null,null,null,"Consumer price index (including housing costs) - Consumer Price Index (with housing) for May",null,"Index",null,null,107.9,108.6,111,119.7,129.1,130.52009999999999,133.13050199999998]
[null,null,null,null,"Consumer price index (including housing costs) - Consumer Price Index (with housing) for June",null,"Index",null,null,107.9,108.8,111.4,120.5,129.4,130.82339999999999,133.43986799999999]
[null,null,null,null,"Consumer price index (including housing costs) - Consumer Price Index (with housing) for July",null,"Index",null,null,108,109.2,111.4,121.2,127.866,129.01679399999998,131.59712987999998]
[null,null,null,null,"Consumer price index (including housing costs) - Consumer Price Index (with housing) for August",null,"Index",null,null,108.3,108.8,112.1,121.8,128.499,129.65549099999998,132.24860081999998]
[null,null,null,null,"Consumer price index (including housing costs) - Consumer Price Index (with housing) for September",null,"Index",null,null,108.4,109.2,112.4,122.3,129.0265,130.18773849999999,132.79149326999999]
[null,null,null,null,"Consumer price index (including housing costs) - Consumer Price Index (with housing) for October",null,"Index",null,null,108.3,109.2,113.4,124.3,128.15329999999997,129.17852639999998,131.76209692799998]
[null,null,null,null,"Consumer price index (including housing costs) - Consumer Price Index (with housing) for November",null,"Index",null,null,108.5,109.1,114.1,124.8,128.66879999999998,129.69815039999997,132.29211340799998]
[null,null,null,null,"Consumer price index (including housing costs) - Consumer Price Index (with housing) for December",null,"Index",null,null,108.5,109.4,114.7,125.3,129.18429999999998,130.21777439999997,132.82212988799998]
[null,null,null,null,"Consumer price index (including housing costs) - Consumer Price Index (with housing) for January",null,"Index",null,null,108.3,109.3,114.6,124.8,127.04640000000001,128.06277120000001,130.62402662400001]
[null,null,null,null,"Consumer price index (including housing costs) - Consumer Price Index (with housing) for February",null,"Index",null,null,108.6,109.4,115.4,126,128.268,129.29414399999999,131.88002688]
[null,null,null,null,"Consumer price index (including housing costs) - Consumer Price Index (with housing) for March",null,"Index",null,null,108.6,109.7,116.5,126.8,129.08240000000001,130.11505920000002,132.71736038400002]
[]
["NON CHANGEABLE INPUTS"]
[]
[null,"Model Tolerance"]
[]
[null,null,null,null,"Model Track Tolerance Level",1E-3,"tolerance"]
[]
["END OF SHEET"]

{"sheet":"Calc-->","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Indexation","index":7,"n_rows":47,"n_cols":16,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Indexation"}]
[null,null,null,null,{"$f":"Time!E$22","v":"Model Period BEG"},null,null,null,null,{"$f":"Time!J$22","v":"2019-04-01"},{"$f":"Time!K$22","v":"2020-04-01"},{"$f":"Time!L$22","v":"2021-04-01"},{"$f":"Time!M$22","v":"2022-04-01"},{"$f":"Time!N$22","v":"2023-04-01"},{"$f":"Time!O$22","v":"2024-04-01"},{"$f":"Time!P$22","v":"2025-04-01"}]
[null,null,null,null,{"$f":"Time!E$23","v":"Model Period END"},{"$f":"Check!F$8","v":0},"Error chks",null,null,{"$f":"Time!J$23","v":"2020-03-31"},{"$f":"Time!K$23","v":"2021-03-31"},{"$f":"Time!L$23","v":"2022-03-31"},{"$f":"Time!M$23","v":"2023-03-31"},{"$f":"Time!N$23","v":"2024-03-31"},{"$f":"Time!O$23","v":"2025-03-31"},{"$f":"Time!P$23","v":"2026-03-31"}]
[null,null,null,null,{"$f":"Time!E$59","v":"Pre Forecast vs Forecast"},null,null,null,null,{"$f":"Time!J$59","v":"Pre Fcst"},{"$f":"Time!K$59","v":"Forecast"},{"$f":"Time!L$59","v":"Forecast"},{"$f":"Time!M$59","v":"Forecast"},{"$f":"Time!N$59","v":"Forecast"},{"$f":"Time!O$59","v":"Forecast"},{"$f":"Time!P$59","v":"Post-Fcst"}]
[null,null,null,null,{"$f":"Time!E$101","v":"Financial Year Ending"},null,null,null,null,{"$f":"Time!J$101","v":2020},{"$f":"Time!K$101","v":2021},{"$f":"Time!L$101","v":2022},{"$f":"Time!M$101","v":2023},{"$f":"Time!N$101","v":2024},{"$f":"Time!O$101","v":2025},{"$f":"Time!P$101","v":2026}]
[null,null,null,null,{"$f":"Time!E$11","v":"Model column counter"},"Constant","Unit","Total",null,{"$f":"Time!J$11","v":1},{"$f":"Time!K$11","v":2},{"$f":"Time!L$11","v":3},{"$f":"Time!M$11","v":4},{"$f":"Time!N$11","v":5},{"$f":"Time!O$11","v":6},{"$f":"Time!P$11","v":7}]
[]
["CPIH INDEXATION"]
[]
[null,"Average CPI(H) - base index 2017-18"]
[null,null,null,null,{"$f":"InpActive!E177","v":"Consumer price index (including housing costs) - Consumer Price Index (with housing) for April"},{"$f":"InpActive!F177","v":103.2},{"$f":"InpActive!G177","v":"Index"}]
[null,null,null,null,{"$f":"InpActive!E178","v":"Consumer price index (including housing costs) - Consumer Price Index (with housing) for May"},{"$f":"InpActive!F178","v":103.5},{"$f":"InpActive!G178","v":"Index"}]
[null,null,null,null,{"$f":"InpActive!E179","v":"Consumer price index (including housing costs) - Consumer Price Index (with housing) for June"},{"$f":"InpActive!F179","v":103.5},{"$f":"InpActive!G179","v":"Index"}]
[null,null,null,null,{"$f":"InpActive!E180","v":"Consumer price index (including housing costs) - Consumer Price Index (with housing) for July"},{"$f":"InpActive!F180","v":103.5},{"$f":"InpActive!G180","v":"Index"}]
[null,null,null,null,{"$f":"InpActive!E181","v":"Consumer price index (including housing costs) - Consumer Price Index (with housing) for August"},{"$f":"InpActive!F181","v":104},{"$f":"InpActive!G181","v":"Index"}]
[null,null,null,null,{"$f":"InpActive!E182","v":"Consumer price index (including housing costs) - Consumer Price Index (with housing) for September"},{"$f":"InpActive!F182","v":104.3},{"$f":"InpActive!G182","v":"Index"}]
[null,null,null,null,{"$f":"InpActive!E183","v":"Consumer price index (including housing costs) - Consumer Price Index (with housing) for October"},{"$f":"InpActive!F183","v":104.4},{"$f":"InpActive!G183","v":"Index"}]
[null,null,null,null,{"$f":"InpActive!E184","v":"Consumer price index (including housing costs) - Consumer Price Index (with housing) for November"},{"$f":"InpActive!F184","v":104.7},{"$f":"InpActive!G184","v":"Index"}]
[null,null,null,null,{"$f":"InpActive!E185","v":"Consumer price index (including housing costs) - Consumer Price Index (with housing) for December"},{"$f":"InpActive!F185","v":105},{"$f":"InpActive!G185","v":"Index"}]
[null,null,null,null,{"$f":"InpActive!E186","v":"Consumer price index (including housing costs) - Consumer Price Index (with housing) for January"},{"$f":"InpActive!F186","v":104.5},{"$f":"InpActive!G186","v":"Index"}]
[null,null,null,null,{"$f":"InpActive!E187","v":"Consumer price index (including housing costs) - Consumer Price Index (with housing) for February"},{"$f":"InpActive!F187","v":104.9},{"$f":"InpActive!G187","v":"Index"}]
[null,null,null,null,{"$f":"InpActive!E188","v":"Consumer price index (including housing costs) - Consumer Price Index (with housing) for March"},{"$f":"InpActive!F188","v":105.1},{"$f":"InpActive!G188","v":"Index"}]
[null,null,null,null,"CPIH 2017-18 FYA - Base Year",{"$f":" AVERAGE(F11:F22)","v":104.21666666666665},"Index"]
[]
[null,"Average CPI(H) forecast periods"]
[null,null,null,null,{"$f":"InpActive!E191","v":"Consumer price index (including housing costs) - Consumer Price Index (with housing) for April"},{"$f":"InpActive!F191","v":0},{"$f":"InpActive!G191","v":"Index"},{"$f":"InpActive!H191","v":0},{"$f":"InpActive!I191","v":0},{"$f":"InpActive!J191","v":107.6},{"$f":"InpActive!K191","v":108.6},{"$f":"InpActive!L191","v":110.4},{"$f":"InpActive!M191","v":119},{"$f":"InpActive!N191","v":128.30000000000001},{"$f":"InpActive!O191","v":129.71129999999999},{"$f":"InpActive!P191","v":132.30552599999999}]
[null,null,null,null,{"$f":"InpActive!E192","v":"Consumer price index (including housing costs) - Consumer Price Index (with housing) for May"},{"$f":"InpActive!F192","v":0},{"$f":"InpActive!G192","v":"Index"},{"$f":"InpActive!H192","v":0},{"$f":"InpActive!I192","v":0},{"$f":"InpActive!J192","v":107.9},{"$f":"InpActive!K192","v":108.6},{"$f":"InpActive!L192","v":111},{"$f":"InpActive!M192","v":119.7},{"$f":"InpActive!N192","v":129.1},{"$f":"InpActive!O192","v":130.52009999999999},{"$f":"InpActive!P192","v":133.13050199999998}]
[null,null,null,null,{"$f":"InpActive!E193","v":"Consumer price index (including housing costs) - Consumer Price Index (with housing) for June"},{"$f":"InpActive!F193","v":0},{"$f":"InpActive!G193","v":"Index"},{"$f":"InpActive!H193","v":0},{"$f":"InpActive!I193","v":0},{"$f":"InpActive!J193","v":107.9},{"$f":"InpActive!K193","v":108.8},{"$f":"InpActive!L193","v":111.4},{"$f":"InpActive!M193","v":120.5},{"$f":"InpActive!N193","v":129.4},{"$f":"InpActive!O193","v":130.82339999999999},{"$f":"InpActive!P193","v":133.43986799999999}]
[null,null,null,null,{"$f":"InpActive!E194","v":"Consumer price index (including housing costs) - Consumer Price Index (with housing) for July"},{"$f":"InpActive!F194","v":0},{"$f":"InpActive!G194","v":"Index"},{"$f":"InpActive!H194","v":0},{"$f":"InpActive!I194","v":0},{"$f":"InpActive!J194","v":108},{"$f":"InpActive!K194","v":109.2},{"$f":"InpActive!L194","v":111.4},{"$f":"InpActive!M194","v":121.2},{"$f":"InpActive!N194","v":127.866},{"$f":"InpActive!O194","v":129.01679399999998},{"$f":"InpActive!P194","v":131.59712987999998}]
[null,null,null,null,{"$f":"InpActive!E195","v":"Consumer price index (including housing costs) - Consumer Price Index (with housing) for August"},{"$f":"InpActive!F195","v":0},{"$f":"InpActive!G195","v":"Index"},{"$f":"InpActive!H195","v":0},{"$f":"InpActive!I195","v":0},{"$f":"InpActive!J195","v":108.3},{"$f":"InpActive!K195","v":108.8},{"$f":"InpActive!L195","v":112.1},{"$f":"InpActive!M195","v":121.8},{"$f":"InpActive!N195","v":128.499},{"$f":"InpActive!O195","v":129.65549099999998},{"$f":"InpActive!P195","v":132.24860081999998}]
[null,null,null,null,{"$f":"InpActive!E196","v":"Consumer price index (including housing costs) - Consumer Price Index (with housing) for September"},{"$f":"InpActive!F196","v":0},{"$f":"InpActive!G196","v":"Index"},{"$f":"InpActive!H196","v":0},{"$f":"InpActive!I196","v":0},{"$f":"InpActive!J196","v":108.4},{"$f":"InpActive!K196","v":109.2},{"$f":"InpActive!L196","v":112.4},{"$f":"InpActive!M196","v":122.3},{"$f":"InpActive!N196","v":129.0265},{"$f":"InpActive!O196","v":130.18773849999999},{"$f":"InpActive!P196","v":132.79149326999999}]
[null,null,null,null,{"$f":"InpActive!E197","v":"Consumer price index (including housing costs) - Consumer Price Index (with housing) for October"},{"$f":"InpActive!F197","v":0},{"$f":"InpActive!G197","v":"Index"},{"$f":"InpActive!H197","v":0},{"$f":"InpActive!I197","v":0},{"$f":"InpActive!J197","v":108.3},{"$f":"InpActive!K197","v":109.2},{"$f":"InpActive!L197","v":113.4},{"$f":"InpActive!M197","v":124.3},{"$f":"InpActive!N197","v":128.15329999999997},{"$f":"InpActive!O197","v":129.17852639999998},{"$f":"InpActive!P197","v":131.76209692799998}]
[null,null,null,null,{"$f":"InpActive!E198","v":"Consumer price index (including housing costs) - Consumer Price Index (with housing) for November"},{"$f":"InpActive!F198","v":0},{"$f":"InpActive!G198","v":"Index"},{"$f":"InpActive!H198","v":0},{"$f":"InpActive!I198","v":0},{"$f":"InpActive!J198","v":108.5},{"$f":"InpActive!K198","v":109.1},{"$f":"InpActive!L198","v":114.1},{"$f":"InpActive!M198","v":124.8},{"$f":"InpActive!N198","v":128.66879999999998},{"$f":"InpActive!O198","v":129.69815039999997},{"$f":"InpActive!P198","v":132.29211340799998}]
[null,null,null,null,{"$f":"InpActive!E199","v":"Consumer price index (including housing costs) - Consumer Price Index (with housing) for December"},{"$f":"InpActive!F199","v":0},{"$f":"InpActive!G199","v":"Index"},{"$f":"InpActive!H199","v":0},{"$f":"InpActive!I199","v":0},{"$f":"InpActive!J199","v":108.5},{"$f":"InpActive!K199","v":109.4},{"$f":"InpActive!L199","v":114.7},{"$f":"InpActive!M199","v":125.3},{"$f":"InpActive!N199","v":129.18429999999998},{"$f":"InpActive!O199","v":130.21777439999997},{"$f":"InpActive!P199","v":132.82212988799998}]
[null,null,null,null,{"$f":"InpActive!E200","v":"Consumer price index (including housing costs) - Consumer Price Index (with housing) for January"},{"$f":"InpActive!F200","v":0},{"$f":"InpActive!G200","v":"Index"},{"$f":"InpActive!H200","v":0},{"$f":"InpActive!I200","v":0},{"$f":"InpActive!J200","v":108.3},{"$f":"InpActive!K200","v":109.3},{"$f":"InpActive!L200","v":114.6},{"$f":"InpActive!M200","v":124.8},{"$f":"InpActive!N200","v":127.04640000000001},{"$f":"InpActive!O200","v":128.06277120000001},{"$f":"InpActive!P200","v":130.62402662400001}]
[null,null,null,null,{"$f":"InpActive!E201","v":"Consumer price index (including housing costs) - Consumer Price Index (with housing) for February"},{"$f":"InpActive!F201","v":0},{"$f":"InpActive!G201","v":"Index"},{"$f":"InpActive!H201","v":0},{"$f":"InpActive!I201","v":0},{"$f":"InpActive!J201","v":108.6},{"$f":"InpActive!K201","v":109.4},{"$f":"InpActive!L201","v":115.4},{"$f":"InpActive!M201","v":126},{"$f":"InpActive!N201","v":128.268},{"$f":"InpActive!O201","v":129.29414399999999},{"$f":"InpActive!P201","v":131.88002688}]
[null,null,null,null,{"$f":"InpActive!E202","v":"Consumer price index (including housing costs) - Consumer Price Index (with housing) for March"},{"$f":"InpActive!F202","v":0},{"$f":"InpActive!G202","v":"Index"},{"$f":"InpActive!H202","v":0},{"$f":"InpActive!I202","v":0},{"$f":"InpActive!J202","v":108.6},{"$f":"InpActive!K202","v":109.7},{"$f":"InpActive!L202","v":116.5},{"$f":"InpActive!M202","v":126.8},{"$f":"InpActive!N202","v":129.08240000000001},{"$f":"InpActive!O202","v":130.11505920000002},{"$f":"InpActive!P202","v":132.71736038400002}]
[null,null,null,null,"CPIH: Financial year average - indices",null,"Index",null,null,{"$f":" AVERAGE(J26:J37)","v":108.24166666666663},{"$f":" AVERAGE(K26:K37)","v":109.10833333333335},{"$f":" AVERAGE(L26:L37)","v":113.11666666666667},123.04166666666664,128.54955833333329,129.70677075833336,{"$f":" AVERAGE(P26:P37)","v":132.30090617350001}]
[]
[null,"CPI(H): Fin year average - conversion from outurn to base year 2017-18 average"]
[]
[null,null,null,null,{"$f":" E$23","v":"CPIH 2017-18 FYA - Base Year"},{"$f":" F$23","v":104.21666666666665},"Index"]
[null,null,null,null,{"$f":" E$38","v":"CPIH: Financial year average - indices"},{"$f":" F$38","v":0},{"$f":" G$38","v":"Index"},{"$f":" H$38","v":0},null,{"$f":" J$38","v":108.24166666666663},109.10833333333335,113.11666666666667,123.04166666666664,128.54955833333329,129.70677075833336,132.30090617350001]
[null,null,null,null,"CPI(H): Fin year average - conversion from outturn to base year 2017-18 average - CALC",null,"%",null,null,{"$f":" IF($F42 = 0, 0, J43 / $F42)","v":1.0386214616983847},{"$f":" IF($F42 = 0, 0, K43 / $F42)","v":1.0469374700143934},{"$f":" IF($F42 = 0, 0, L43 / $F42)","v":1.0853990084759317},1.1806332960179113,1.2334836878298414,1.2445875972333285,{"$f":" IF($F42 = 0, 0, P43 / $F42)","v":1.2694793491779948}]
[]
[]
["End of sheet"]

{"sheet":"Time","index":8,"n_rows":104,"n_cols":16,"rows_kept":104,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Time"}]
[null,null,null,null,{"$f":"Time!E$22","v":"Model Period BEG"},null,null,null,null,{"$f":"Time!J$22","v":"2019-04-01"},{"$f":"Time!K$22","v":"2020-04-01"},{"$f":"Time!L$22","v":"2021-04-01"},{"$f":"Time!M$22","v":"2022-04-01"},{"$f":"Time!N$22","v":"2023-04-01"},{"$f":"Time!O$22","v":"2024-04-01"},{"$f":"Time!P$22","v":"2025-04-01"}]
[null,null,null,null,{"$f":"Time!E$23","v":"Model Period END"},{"$f":"Check!F$8","v":0},"Error chks",null,null,{"$f":"Time!J$23","v":"2020-03-31"},{"$f":"Time!K$23","v":"2021-03-31"},{"$f":"Time!L$23","v":"2022-03-31"},{"$f":"Time!M$23","v":"2023-03-31"},{"$f":"Time!N$23","v":"2024-03-31"},{"$f":"Time!O$23","v":"2025-03-31"},{"$f":"Time!P$23","v":"2026-03-31"}]
[null,null,null,null,{"$f":"Time!E$59","v":"Pre Forecast vs Forecast"},null,null,null,null,{"$f":"Time!J$59","v":"Pre Fcst"},{"$f":"Time!K$59","v":"Forecast"},{"$f":"Time!L$59","v":"Forecast"},{"$f":"Time!M$59","v":"Forecast"},{"$f":"Time!N$59","v":"Forecast"},{"$f":"Time!O$59","v":"Forecast"},{"$f":"Time!P$59","v":"Post-Fcst"}]
[null,null,null,null,{"$f":"Time!E$101","v":"Financial Year Ending"},null,null,null,null,{"$f":"Time!J$101","v":2020},{"$f":"Time!K$101","v":2021},{"$f":"Time!L$101","v":2022},{"$f":"Time!M$101","v":2023},{"$f":"Time!N$101","v":2024},{"$f":"Time!O$101","v":2025},{"$f":"Time!P$101","v":2026}]
[null,null,null,null,{"$f":"Time!E$11","v":"Model column counter"},"Constant","Unit","Total",null,{"$f":"Time!J$11","v":1},{"$f":"Time!K$11","v":2},{"$f":"Time!L$11","v":3},{"$f":"Time!M$11","v":4},{"$f":"Time!N$11","v":5},{"$f":"Time!O$11","v":6},{"$f":"Time!P$11","v":7}]
[]
["MODEL PERIOD"]
[]
[null,"Model Column Counter "]
[null,null,null,null,"Model column counter",null,"counter",null,null,{"$f":" I11 + 1","v":1},{"$f":" J11 + 1","v":2},{"$f":" K11 + 1","v":3},4,5,6,{"$f":" O11 + 1","v":7}]
[null,null,null,null,"Model Column Total",{"$f":" MAX(J11:P11)","v":7},"column"]
[]
[null,null,null,null,{"$f":" E$11","v":"Model column counter"},0,"counter",0,0,1,2,3,4,5,6,7]
[null,null,null,null,"First model column flag",null,"flag",{"$f":" SUM(J15:P15)","v":1},null,{"$f":" IF( J14 = 1, 1, 0)","v":1},{"$f":" IF( K14 = 1, 1, 0)","v":0},0,0,0,0,0]
[]
[null,null,null,null,{"$f":" InpActive!E$10","v":"First date of time ruler"},{"$f":" InpActive!F$10","v":"2019-04-01"},{"$f":" InpActive!G$10","v":"date"}]
[null,null,null,null,"First model period BEG",{"$f":" DATE(YEAR(F17), MONTH(F17), 1)","v":"2019-04-01"},"month"]
[]
[null,null,null,null,{"$f":" E$18","v":"First model period BEG"},{"$f":" F$18","v":"2019-04-01"},{"$f":" G$18","v":"month"}]
[null,null,null,null,{"$f":" E$15","v":"First model column flag"},0,"flag",1,0,1,0,0,0,0,0,0]
[null,null,null,null,"Model Period BEG",null,"date",null,null,{"$f":" IF( J21 = 1, $F20, I23 + 1)","v":"2019-04-01"},{"$f":" IF( K21 = 1, $F20, J23 + 1)","v":"2020-04-01"},"2021-04-01","2022-04-01","2023-04-01","2024-04-01",{"$f":" IF( P21 = 1, $F20, O23 + 1)","v":"2025-04-01"}]
[null,null,null,null,"Model Period END",null,"date",null,null,{"$f":" DATE(YEAR(J22), MONTH(J22) + 12, DAY(1) - 1)","v":"2020-03-31"},"2021-03-31","2022-03-31","2023-03-31","2024-03-31","2025-03-31","2026-03-31"]
[]
[null,null,null,null,{"$f":" E$23","v":"Model Period END"},"00:00:00","date","00:00:00","00:00:00","2020-03-31","2021-03-31","2022-03-31","2023-03-31","2024-03-31","2025-03-31","2026-03-31"]
[null,null,null,"less",{"$f":" E$22","v":"Model Period BEG"},"00:00:00","date","00:00:00","00:00:00","2019-04-01","2020-04-01","2021-04-01","2022-04-01","2023-04-01","2024-04-01","2025-04-01"]
[null,null,null,null,"Days in Model Period",null,"days",{"$f":" SUM(J27:P27)","v":2557},null,{"$f":" J25 - J26 + 1","v":366},365,365,365,366,365,365]
[]
[]
["PRE FORECAST PERIOD"]
[]
[null,null,null,null,{"$f":" InpActive!E$12","v":"Last Pre Forecast Date"},{"$f":" InpActive!F$12","v":"2020-03-31"},{"$f":" InpActive!G$12","v":"date"}]
[null,null,null,null,{"$f":" E$23","v":"Model Period END"},"00:00:00","date","00:00:00","00:00:00","2020-03-31","2021-03-31","2022-03-31","2023-03-31","2024-03-31","2025-03-31","2026-03-31"]
[null,null,null,null,"Last Pre Forecast Flag",null,"flag",{"$f":" SUM(J34:P34)","v":1},null,{"$f":" IF(J33 = $F32, 1, 0)","v":1},0,0,0,0,0,0]
[null,null,null,null,"Pre Forecast Period Flag",null,"flag",{"$f":" SUM(J35:P35)","v":1},null,{"$f":" IF($F32 >= J33, 1, 0)","v":1},{"$f":" IF($F32 >= K33, 1, 0)","v":0},0,0,0,0,0]
[null,null,null,null,"Pre Forecast Period Total",{"$f":" SUM(J35:P35)","v":1},"columns"]
[]
[null,null,null,null,{"$f":" InpActive!E$14","v":"Acquisition date (midnight)"},{"$f":" InpActive!F$14","v":"2020-03-31"},{"$f":" InpActive!G$14","v":"date"}]
[null,null,null,null,{"$f":" E$23","v":"Model Period END"},"00:00:00","date","00:00:00","00:00:00","2020-03-31","2021-03-31","2022-03-31","2023-03-31","2024-03-31","2025-03-31","2026-03-31"]
[null,null,null,null,"Acquisition / initial balance date flag",null,"flag",{"$f":" SUM(J40:P40)","v":1},null,{"$f":" IF(J39 = $F38, 1, 0)","v":1},0,0,0,0,0,0]
[]
[]
["FORECAST PERIOD"]
[]
[null,null,null,null,{"$f":" E$34","v":"Last Pre Forecast Flag"},0,"flag",1,0,1,0,0,0,0,0,0]
[null,null,null,null,"1st Forecast Period Flag",null,"flag",{"$f":" SUM(J46:P46)","v":1},null,{"$f":" I45","v":0},{"$f":" J45","v":1},0,0,0,0,{"$f":" O45","v":0}]
[]
[null,null,null,null,{"$f":"InpActive!E$16","v":"Last forecast date"},{"$f":"InpActive!F$16","v":"2025-03-31"},{"$f":"InpActive!G$16","v":"date"}]
[null,null,null,null,{"$f":" E$23","v":"Model Period END"},"00:00:00","date","00:00:00","00:00:00","2020-03-31","2021-03-31","2022-03-31","2023-03-31","2024-03-31","2025-03-31","2026-03-31"]
[null,null,null,null,"Last Forecast Period Flag",null,"flag",{"$f":" SUM(J50:P50)","v":1},null,{"$f":" IF(AND($F48 > I49, $F48 <= J49), 1, 0)","v":0},{"$f":" IF(AND($F48 > J49, $F48 <= K49), 1, 0)","v":0},0,0,0,1,{"$f":" IF(AND($F48 > O49, $F48 <= P49), 1, 0)","v":0}]
[]
[null,null,null,null,{"$f":" E$46","v":"1st Forecast Period Flag"},0,"flag",1,0,0,1,0,0,0,0,0]
[null,null,null,null,{"$f":" E$50","v":"Last Forecast Period Flag"},0,"flag",1,0,0,0,0,0,0,1,0]
[null,null,null,null,"Forecast Period Flag",null,"flag",{"$f":" SUM(J54:P54)","v":5},null,{"$f":" J52 - I53 + I54","v":0},{"$f":" K52 - J53 + J54","v":1},1,1,1,1,{"$f":" P52 - O53 + O54","v":0}]
[null,null,null,null,"Forecast Period Total ",{"$f":" SUM(J54:P54)","v":5},"columns"]
[]
[null,null,null,null,{"$f":" E$35","v":"Pre Forecast Period Flag"},0,"flag",1,0,1,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$54","v":"Forecast Period Flag"},0,"flag",5,0,0,1,1,1,1,1,0]
[null,null,null,null,"Pre Forecast vs Forecast",null,"flag",null,null,{"$f":" IF(J57 = 1, \"Pre Fcst\", IF(J58 = 1, \"Forecast\", \"Post-Fcst\"))","v":"Pre Fcst"},"Forecast","Forecast","Forecast","Forecast","Forecast","Post-Fcst"]
[]
[]
["POST FORECAST PERIOD"]
[]
[null,null,null,null,{"$f":" E$50","v":"Last Forecast Period Flag"},0,"flag",1,0,0,0,0,0,0,1,0]
[null,null,null,null,"1st Post Last Forecast Period Flag",null,"flag",{"$f":" SUM(J65:P65)","v":1},null,{"$f":" I64","v":0},{"$f":" J64","v":0},0,0,0,0,{"$f":" O64","v":1}]
[]
[null,null,null,null,{"$f":" E$65","v":"1st Post Last Forecast Period Flag"},0,"flag",1,0,0,0,0,0,0,0,1]
[null,null,null,null,"Post Forecast Period Flag",null,"flag",{"$f":" SUM(J68:P68)","v":1},null,{"$f":" I68 + J67","v":0},{"$f":" J68 + K67","v":0},0,0,0,0,{"$f":" O68 + P67","v":1}]
[null,null,null,null,"Post Forecast Period Total",{"$f":" SUM(J68:P68)","v":1},"columns"]
[]
[]
["MODELLING PERIOD CHECK"]
[]
[null,null,null,null,{"$f":" E$12","v":"Model Column Total"},{"$f":" F$12","v":7},{"$f":" G$12","v":"column"}]
[null,null,null,"less",{"$f":" E$36","v":"Pre Forecast Period Total"},{"$f":" F$36","v":1},{"$f":" G$36","v":"columns"}]
[null,null,null,"less",{"$f":" E$55","v":"Forecast Period Total "},{"$f":" F$55","v":5},{"$f":" G$55","v":"columns"}]
[null,null,null,"less",{"$f":" E$69","v":"Post Forecast Period Total"},{"$f":" F$69","v":1},{"$f":" G$69","v":"columns"}]
[null,null,null,null,"Modelling Period Check",{"$f":" IF(F74 - SUM(F75:F77) <> 0, 1, 0)","v":0},"check"]
[]
[]
["PARTIAL PERIOD FLAG (PPF)"]
[null,null,"This is an example of a part period flag. It is not currently used."]
[null,"Operation Partial Period Flag (PPF)"]
[null,null,null,null,{"$f":" E$18","v":"First model period BEG"},{"$f":" F$18","v":"2019-04-01"},{"$f":" G$18","v":"month"}]
[null,null,null,null,{"$f":"InpActive!E$20","v":"Operation Finish Date (midnight)"},{"$f":"InpActive!F$20","v":"2025-03-31"},{"$f":"InpActive!G$20","v":"date"}]
[null,null,null,null,{"$f":" E$22","v":"Model Period BEG"},"00:00:00","date","00:00:00","00:00:00","2019-04-01","2020-04-01","2021-04-01","2022-04-01","2023-04-01","2024-04-01","2025-04-01"]
[null,null,null,null,{"$f":" E$23","v":"Model Period END"},"00:00:00","date","00:00:00","00:00:00","2020-03-31","2021-03-31","2022-03-31","2023-03-31","2024-03-31","2025-03-31","2026-03-31"]
[null,null,null,null,"Days in Operation Period",null,"days",{"$f":" SUM(J88:P88)","v":2192},null,{"$f":" MAX(0, (MIN($F85, J87) - MAX($F84, J86) + 1))","v":366},365,365,365,366,365,0]
[]
[null,null,null,null,{"$f":" E$88","v":"Days in Operation Period"},0,"days",2192,0,366,365,365,365,366,365,0]
[null,null,null,null,{"$f":" E$27","v":"Days in Model Period"},0,"days",2557,0,366,365,365,365,366,365,365]
[null,null,null,null,"Operation Period PPF",null,"factor",{"$f":" SUM(J92:P92)","v":6},null,{"$f":" J90 / J91","v":1},1,1,1,1,1,0]
[]
[]
["FINANCIAL YEAR"]
[]
[null,null,null,null,{"$f":"InpActive!E21","v":"First Modelling Column Financial Year Number"},{"$f":"InpActive!F21","v":2020},{"$f":"InpActive!G21","v":"year"}]
[null,null,null,null,{"$f":"InpActive!E22","v":"Financial Year End Month Number"},{"$f":"InpActive!F22","v":3},{"$f":"InpActive!G22","v":"month #"}]
[null,null,null,null,{"$f":" E$23","v":"Model Period END"},"00:00:00","date","00:00:00","00:00:00","2020-03-31","2021-03-31","2022-03-31","2023-03-31","2024-03-31","2025-03-31","2026-03-31"]
[null,null,null,null,{"$f":" E$15","v":"First model column flag"},0,"flag",1,0,1,0,0,0,0,0,0]
[null,null,null,null,"Financial Year Ending",null,"year #",null,null,{"$f":" IF(J100 = 1, $F97, IF(J99 > (DATE(I101, $F98 + 1, 1) - 1), I101 + 1, I101))","v":2020},{"$f":" IF(K100 = 1, $F97, IF(K99 > (DATE(J101, $F98 + 1, 1) - 1), J101 + 1, J101))","v":2021},2022,2023,2024,2025,{"$f":" IF(P100 = 1, $F97, IF(P99 > (DATE(O101, $F98 + 1, 1) - 1), O101 + 1, O101))","v":2026}]
[]
[]
["END OF SHEET"]

{"sheet":"Innovation funding return","index":9,"n_rows":396,"n_cols":16,"rows_kept":396,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Innovation funding return"}]
[null,null,null,null,{"$f":"Time!E$22","v":"Model Period BEG"},null,null,null,null,{"$f":"Time!J$22","v":"2019-04-01"},{"$f":"Time!K$22","v":"2020-04-01"},{"$f":"Time!L$22","v":"2021-04-01"},{"$f":"Time!M$22","v":"2022-04-01"},{"$f":"Time!N$22","v":"2023-04-01"},{"$f":"Time!O$22","v":"2024-04-01"},{"$f":"Time!P$22","v":"2025-04-01"}]
[null,null,null,null,{"$f":"Time!E$23","v":"Model Period END"},{"$f":"Check!F$8","v":0},"Error chks",null,null,{"$f":"Time!J$23","v":"2020-03-31"},{"$f":"Time!K$23","v":"2021-03-31"},{"$f":"Time!L$23","v":"2022-03-31"},{"$f":"Time!M$23","v":"2023-03-31"},{"$f":"Time!N$23","v":"2024-03-31"},{"$f":"Time!O$23","v":"2025-03-31"},{"$f":"Time!P$23","v":"2026-03-31"}]
[null,null,null,null,{"$f":"Time!E$59","v":"Pre Forecast vs Forecast"},null,null,null,null,{"$f":"Time!J$59","v":"Pre Fcst"},{"$f":"Time!K$59","v":"Forecast"},{"$f":"Time!L$59","v":"Forecast"},{"$f":"Time!M$59","v":"Forecast"},{"$f":"Time!N$59","v":"Forecast"},{"$f":"Time!O$59","v":"Forecast"},{"$f":"Time!P$59","v":"Post-Fcst"}]
[null,null,null,null,{"$f":"Time!E$101","v":"Financial Year Ending"},null,null,null,null,{"$f":"Time!J$101","v":2020},{"$f":"Time!K$101","v":2021},{"$f":"Time!L$101","v":2022},{"$f":"Time!M$101","v":2023},{"$f":"Time!N$101","v":2024},{"$f":"Time!O$101","v":2025},{"$f":"Time!P$101","v":2026}]
[null,null,null,null,{"$f":"Time!E$11","v":"Model column counter"},"Constant","Unit","Total",null,{"$f":"Time!J$11","v":1},{"$f":"Time!K$11","v":2},{"$f":"Time!L$11","v":3},{"$f":"Time!M$11","v":4},{"$f":"Time!N$11","v":5},{"$f":"Time!O$11","v":6},{"$f":"Time!P$11","v":7}]
[]
[null,null,null,"Allocated Funding - Real"]
[null,null,null,null,{"$f":" InpActive!E28","v":"ANH - Allocated innovation funding - Real"},{"$f":" InpActive!F28","v":0},{"$f":" InpActive!G28","v":"£m"},{"$f":" InpActive!H28","v":20.986784177417711},{"$f":" InpActive!I28","v":0},{"$f":" InpActive!J28","v":0},{"$f":" InpActive!K28","v":4.197356835483542},{"$f":" InpActive!L28","v":4.197356835483542},{"$f":" InpActive!M28","v":4.197356835483542},{"$f":" InpActive!N28","v":4.197356835483542},{"$f":" InpActive!O28","v":4.197356835483542},{"$f":" InpActive!P28","v":0}]
[null,null,null,null,{"$f":" InpActive!E29","v":"HDD - Allocated innovation funding - Real"},{"$f":" InpActive!F29","v":0},{"$f":" InpActive!G29","v":"£m"},{"$f":" InpActive!H29","v":0.45489564100882784},{"$f":" InpActive!I29","v":0},{"$f":" InpActive!J29","v":0},{"$f":" InpActive!K29","v":9.0979128201765569E-2},{"$f":" InpActive!L29","v":9.0979128201765569E-2},{"$f":" InpActive!M29","v":9.0979128201765569E-2},{"$f":" InpActive!N29","v":9.0979128201765569E-2},{"$f":" InpActive!O29","v":9.0979128201765569E-2},{"$f":" InpActive!P29","v":0}]
[null,null,null,null,{"$f":" InpActive!E30","v":"NES - Allocated innovation funding - Real"},{"$f":" InpActive!F30","v":0},{"$f":" InpActive!G30","v":"£m"},{"$f":" InpActive!H30","v":11.78510500359587},{"$f":" InpActive!I30","v":0},{"$f":" InpActive!J30","v":0},{"$f":" InpActive!K30","v":2.3570210007191741},{"$f":" InpActive!L30","v":2.3570210007191741},{"$f":" InpActive!M30","v":2.3570210007191741},{"$f":" InpActive!N30","v":2.3570210007191741},{"$f":" InpActive!O30","v":2.3570210007191741},{"$f":" InpActive!P30","v":0}]
[null,null,null,null,{"$f":" InpActive!E31","v":"NWT - Allocated innovation funding - Real"},{"$f":" InpActive!F31","v":0},{"$f":" InpActive!G31","v":"£m"},{"$f":" InpActive!H31","v":29.370061153780984},{"$f":" InpActive!I31","v":0},{"$f":" InpActive!J31","v":0},{"$f":" InpActive!K31","v":5.8740122307561968},{"$f":" InpActive!L31","v":5.8740122307561968},{"$f":" InpActive!M31","v":5.8740122307561968},{"$f":" InpActive!N31","v":5.8740122307561968},{"$f":" InpActive!O31","v":5.8740122307561968},{"$f":" InpActive!P31","v":0}]
[null,null,null,null,{"$f":" InpActive!E32","v":"SRN - Allocated innovation funding - Real"},{"$f":" InpActive!F32","v":0},{"$f":" InpActive!G32","v":"£m"},{"$f":" InpActive!H32","v":13.297786739206252},{"$f":" InpActive!I32","v":0},{"$f":" InpActive!J32","v":0},{"$f":" InpActive!K32","v":2.6595573478412504},{"$f":" InpActive!L32","v":2.6595573478412504},{"$f":" InpActive!M32","v":2.6595573478412504},{"$f":" InpActive!N32","v":2.6595573478412504},{"$f":" InpActive!O32","v":2.6595573478412504},{"$f":" InpActive!P32","v":0}]
[null,null,null,null,{"$f":" InpActive!E33","v":"SVE - Allocated innovation funding - Real"},{"$f":" InpActive!F33","v":0},{"$f":" InpActive!G33","v":"£m"},{"$f":" InpActive!H33","v":28.382107404963808},{"$f":" InpActive!I33","v":0},{"$f":" InpActive!J33","v":0},{"$f":" InpActive!K33","v":5.6764214809927616},{"$f":" InpActive!L33","v":5.6764214809927616},{"$f":" InpActive!M33","v":5.6764214809927616},{"$f":" InpActive!N33","v":5.6764214809927616},{"$f":" InpActive!O33","v":5.6764214809927616},{"$f":" InpActive!P33","v":0}]
[null,null,null,null,{"$f":" InpActive!E34","v":"SWB - Allocated innovation funding - Real"},{"$f":" InpActive!F34","v":0},{"$f":" InpActive!G34","v":"£m"},{"$f":" InpActive!H34","v":8.8206411500853914},{"$f":" InpActive!I34","v":0},{"$f":" InpActive!J34","v":0},{"$f":" InpActive!K34","v":1.7641282300170782},{"$f":" InpActive!L34","v":1.7641282300170782},{"$f":" InpActive!M34","v":1.7641282300170782},{"$f":" InpActive!N34","v":1.7641282300170782},{"$f":" InpActive!O34","v":1.7641282300170782},{"$f":" InpActive!P34","v":0}]
[null,null,null,null,{"$f":" InpActive!E35","v":"TMS - Allocated innovation funding - Real"},{"$f":" InpActive!F35","v":0},{"$f":" InpActive!G35","v":"£m"},{"$f":" InpActive!H35","v":34.32930907435577},{"$f":" InpActive!I35","v":0},{"$f":" InpActive!J35","v":0},{"$f":" InpActive!K35","v":6.8658618148711543},{"$f":" InpActive!L35","v":6.8658618148711543},{"$f":" InpActive!M35","v":6.8658618148711543},{"$f":" InpActive!N35","v":6.8658618148711543},{"$f":" InpActive!O35","v":6.8658618148711543},{"$f":" InpActive!P35","v":0}]
[null,null,null,null,{"$f":" InpActive!E36","v":"WSH - Allocated innovation funding - Real"},{"$f":" InpActive!F36","v":0},{"$f":" InpActive!G36","v":"£m"},{"$f":" InpActive!H36","v":12.357734690289989},{"$f":" InpActive!I36","v":0},{"$f":" InpActive!J36","v":0},{"$f":" InpActive!K36","v":2.471546938057998},{"$f":" InpActive!L36","v":2.471546938057998},{"$f":" InpActive!M36","v":2.471546938057998},{"$f":" InpActive!N36","v":2.471546938057998},{"$f":" InpActive!O36","v":2.471546938057998},{"$f":" InpActive!P36","v":0}]
[null,null,null,null,{"$f":" InpActive!E37","v":"WSX - Allocated innovation funding - Real"},{"$f":" InpActive!F37","v":0},{"$f":" InpActive!G37","v":"£m"},{"$f":" InpActive!H37","v":8.260459207972497},{"$f":" InpActive!I37","v":0},{"$f":" InpActive!J37","v":0},{"$f":" InpActive!K37","v":1.6520918415944994},{"$f":" InpActive!L37","v":1.6520918415944994},{"$f":" InpActive!M37","v":1.6520918415944994},{"$f":" InpActive!N37","v":1.6520918415944994},{"$f":" InpActive!O37","v":1.6520918415944994},{"$f":" InpActive!P37","v":0}]
[null,null,null,null,{"$f":" InpActive!E38","v":"YKY - Allocated innovation funding - Real"},{"$f":" InpActive!F38","v":0},{"$f":" InpActive!G38","v":"£m"},{"$f":" InpActive!H38","v":17.59261305721526},{"$f":" InpActive!I38","v":0},{"$f":" InpActive!J38","v":0},{"$f":" InpActive!K38","v":3.5185226114430521},{"$f":" InpActive!L38","v":3.5185226114430521},{"$f":" InpActive!M38","v":3.5185226114430521},{"$f":" InpActive!N38","v":3.5185226114430521},{"$f":" InpActive!O38","v":3.5185226114430521},{"$f":" InpActive!P38","v":0}]
[null,null,null,null,{"$f":" InpActive!E39","v":"AFW - Allocated innovation funding - Real"},{"$f":" InpActive!F39","v":0},{"$f":" InpActive!G39","v":"£m"},{"$f":" InpActive!H39","v":4.8432347733847161},{"$f":" InpActive!I39","v":0},{"$f":" InpActive!J39","v":0},{"$f":" InpActive!K39","v":0.96864695467694317},{"$f":" InpActive!L39","v":0.96864695467694317},{"$f":" InpActive!M39","v":0.96864695467694317},{"$f":" InpActive!N39","v":0.96864695467694317},{"$f":" InpActive!O39","v":0.96864695467694317},{"$f":" InpActive!P39","v":0}]
[null,null,null,null,{"$f":" InpActive!E40","v":"BRL - Allocated innovation funding - Real"},{"$f":" InpActive!F40","v":0},{"$f":" InpActive!G40","v":"£m"},{"$f":" InpActive!H40","v":1.8912269294760475},{"$f":" InpActive!I40","v":0},{"$f":" InpActive!J40","v":0},{"$f":" InpActive!K40","v":0.37824538589520951},{"$f":" InpActive!L40","v":0.37824538589520951},{"$f":" InpActive!M40","v":0.37824538589520951},{"$f":" InpActive!N40","v":0.37824538589520951},{"$f":" InpActive!O40","v":0.37824538589520951},{"$f":" InpActive!P40","v":0}]
[null,null,null,null,{"$f":" InpActive!E41","v":"PRT - Allocated innovation funding - Real"},{"$f":" InpActive!F41","v":0},{"$f":" InpActive!G41","v":"£m"},{"$f":" InpActive!H41","v":0.64951234319729489},{"$f":" InpActive!I41","v":0},{"$f":" InpActive!J41","v":0},{"$f":" InpActive!K41","v":0.12990246863945898},{"$f":" InpActive!L41","v":0.12990246863945898},{"$f":" InpActive!M41","v":0.12990246863945898},{"$f":" InpActive!N41","v":0.12990246863945898},{"$f":" InpActive!O41","v":0.12990246863945898},{"$f":" InpActive!P41","v":0}]
[null,null,null,null,{"$f":" InpActive!E42","v":"SES - Allocated innovation funding - Real"},{"$f":" InpActive!F42","v":0},{"$f":" InpActive!G42","v":"£m"},{"$f":" InpActive!H42","v":0.984054038891783},{"$f":" InpActive!I42","v":0},{"$f":" InpActive!J42","v":0},{"$f":" InpActive!K42","v":0.19681080777835661},{"$f":" InpActive!L42","v":0.19681080777835661},{"$f":" InpActive!M42","v":0.19681080777835661},{"$f":" InpActive!N42","v":0.19681080777835661},{"$f":" InpActive!O42","v":0.19681080777835661},{"$f":" InpActive!P42","v":0}]
[null,null,null,null,{"$f":" InpActive!E43","v":"SEW - Allocated innovation funding - Real"},{"$f":" InpActive!F43","v":0},{"$f":" InpActive!G43","v":"£m"},{"$f":" InpActive!H43","v":3.951513618490945},{"$f":" InpActive!I43","v":0},{"$f":" InpActive!J43","v":0},{"$f":" InpActive!K43","v":0.79030272369818899},{"$f":" InpActive!L43","v":0.79030272369818899},{"$f":" InpActive!M43","v":0.79030272369818899},{"$f":" InpActive!N43","v":0.79030272369818899},{"$f":" InpActive!O43","v":0.79030272369818899},{"$f":" InpActive!P43","v":0}]
[null,null,null,null,{"$f":" InpActive!E44","v":"SSC - Allocated innovation funding - Real"},{"$f":" InpActive!F44","v":0},{"$f":" InpActive!G44","v":"£m"},{"$f":" InpActive!H44","v":2.0429609966668241},{"$f":" InpActive!I44","v":0},{"$f":" InpActive!J44","v":0},{"$f":" InpActive!K44","v":0.40859219933336482},{"$f":" InpActive!L44","v":0.40859219933336482},{"$f":" InpActive!M44","v":0.40859219933336482},{"$f":" InpActive!N44","v":0.40859219933336482},{"$f":" InpActive!O44","v":0.40859219933336482},{"$f":" InpActive!P44","v":0}]
[null,null,null,null,"Total Allocated Funding - Real",null,"£m",{"$f":" SUM(J26:P26)","v":199.99999999999997},null,{"$f":"SUM(J9:J25)","v":0},{"$f":"SUM(K9:K25)","v":39.999999999999993},39.999999999999993,39.999999999999993,39.999999999999993,39.999999999999993,0]
[]
[null,null,null,null,{"$f":"Indexation!E44","v":"CPI(H): Fin year average - conversion from outturn to base year 2017-18 average - CALC"},{"$f":"Indexation!F44","v":0},{"$f":"Indexation!G44","v":"%"},{"$f":"Indexation!H44","v":0},{"$f":"Indexation!I44","v":0},{"$f":"Indexation!J44","v":1.0386214616983847},{"$f":"Indexation!K44","v":1.0469374700143934},{"$f":"Indexation!L44","v":1.0853990084759317},{"$f":"Indexation!M44","v":1.1806332960179113},{"$f":"Indexation!N44","v":1.2334836878298414},{"$f":"Indexation!O44","v":1.2445875972333285},{"$f":"Indexation!P44","v":1.2694793491779948}]
[]
[null,null,null,"Allocated Funding - Nominal"]
[null,null,null,null,"ANH - Allocated innovation funding - Nominal",null,"£m",{"$f":" SUM(J31:P31)","v":24.307065775957895},null,{"$f":"J9 * J$28","v":0},{"$f":"K9 * K$28","v":4.3943701460887601},4.5558069474535108,4.9555392352402441,5.1773711885700324,5.2239782586053485,0]
[null,null,null,null,"HDD - Allocated innovation funding - Nominal",null,"£m",{"$f":" SUM(J32:P32)","v":0.5268638669804353},null,{"$f":"J10 * J$28","v":0},9.5249458303671597E-2,9.8748655542201025E-2,0.1074129879976866,0.11222127056985773,0.11323149456701836,0]
[null,null,null,null,"NES - Allocated innovation funding - Nominal",null,"£m",13.649605393436822,null,{"$f":"J11 * J$28","v":0},2.467653603263726,2.55830825713754,2.7827774728625143,2.9073469562594703,2.9335191039135724,0]
[null,null,null,null,"NWT - Allocated innovation funding - Nominal",null,"£m",34.016646012733766,null,{"$f":"J12 * J$28","v":0},6.1497235037014963,6.3756470510382721,6.9350544208472122,7.2454982687507474,7.3107227683960385,0]
[null,null,null,null,"SRN - Allocated innovation funding - Nominal",null,"£m",15.401605801633515,null,{"$f":"J13 * J$28","v":0},2.7843902411071086,2.8866809083317717,3.13996195753047,3.2805206054101781,3.3100520892539853,0]
[null,null,null,null,"SVE - Allocated innovation funding - Nominal",null,"£m",32.872389867862218,null,{"$f":"J14 * J$28","v":0},5.9428583440459182,6.1611822471610234,6.701772202691358,7.0017733020514816,7.064803771912433,0]
[null,null,null,null,"SWB - Allocated innovation funding - Nominal",null,"£m",10.21613901437793,null,{"$f":"J15 * J$28","v":0},1.8469319459150497,1.914783031684937,2.0827885268033071,2.1760233949661965,2.1956121150084398,0]
[null,null,null,null,"TMS - Allocated innovation funding - Nominal",null,"£m",39.760487679262312,null,{"$f":"J16 * J$28","v":0},7.1881279979296382,7.4521996061939122,8.1060650644948495,8.4689285515373598,8.5451664591065501,0]
[null,null,null,null,"WSH - Allocated innovation funding - Nominal",null,"£m",14.312829798951853,null,{"$f":"J17 * J$28","v":0},2.5875550983522611,2.6826145959698762,2.9179906077423907,3.048612831800332,3.0760566650869938,0]
[null,null,null,null,"WSX - Allocated innovation funding - Nominal",null,"£m",9.5673316888566866,null,{"$f":"J18 * J$28","v":0},1.7296368528703652,1.7931788467778458,1.9505146362660148,2.0378283374035773,2.0561730155388829,0]
[null,null,null,null,"YKY - Allocated innovation funding - Nominal",null,"£m",20.375908911897124,null,{"$f":"J19 * J$28","v":0},3.6836731610126257,3.8190009537604346,4.1540849478615591,4.3400402464754597,4.379109602787044,0]
[null,null,null,null,"AFW - Allocated innovation funding - Nominal",null,"£m",5.609474286762981,null,{"$f":"J20 * J$28","v":0},1.0141127920666257,1.051368444169585,1.1436168467779517,1.194810217860061,1.2055659858887575,0]
[null,null,null,null,"BRL - Allocated innovation funding - Nominal",null,"£m",2.1904345603125899,null,{"$f":"J21 * J$28","v":0},0.39599926735374857,0.41054716681125658,0.44656909665302802,0.4665595134986445,0.47075951599591193,0]
[null,null,null,null,"PRT - Allocated innovation funding - Nominal",null,"£m",0.75227052963079388,null,{"$f":"J22 * J$28","v":0},0.13599976186601925,0.1409960106598446,0.15336717971066782,0.16023257607560018,0.16167500131866205,0]
[null,null,null,null,"SES - Allocated innovation funding - Nominal",null,"£m",1.1397394688118787,null,{"$f":"J23 * J$28","v":0},0.20604860916696177,0.21361825561997547,0.23236139267930875,0.24276292098321733,0.24494829036241531,0]
[null,null,null,null,"SEW - Allocated innovation funding - Nominal",null,"£m",4.5766755224273288,null,{"$f":"J24 * J$28","v":0},0.82739753409406613,0.85779379269784262,0.93305770953172551,0.97482551812921037,0.98360096797448415,0]
[null,null,null,null,"SSC - Allocated innovation funding - Nominal",null,"£m",2.3661742029601003,null,{"$f":"J25 * J$28","v":0},0.4277704834376897,0.44348556802743444,0.48239755502615794,0.5039918128522245,0.5085287836165937,0]
[null,null,null,null,"Total Allocated Funding - Nominal",null,"£m",231.64164238285625,null,{"$f":"SUM(J31:J47)","v":0},{"$f":"SUM(K31:K47)","v":41.877498800575736},{"$f":"SUM(L31:L47)","v":43.415960339037269},{"$f":"SUM(M31:M47)","v":47.225331840716457},{"$f":"SUM(N31:N47)","v":49.339347513193651},{"$f":"SUM(O31:O47)","v":49.783503889333133},{"$f":"SUM(P31:P47)","v":0}]
[]
[null,null,null,"Proportion of Funding allocated"]
[]
[null,null,null,"Allocated Funding - Nominal"]
[null,null,null,null,{"$f":"E31","v":"ANH - Allocated innovation funding - Nominal"},{"$f":"F31","v":0},{"$f":"G31","v":"£m"},24.307065775957895,0,0,4.3943701460887601,4.5558069474535108,4.9555392352402441,5.1773711885700324,5.2239782586053485,0]
[null,null,null,null,{"$f":"E32","v":"HDD - Allocated innovation funding - Nominal"},0,"£m",0.5268638669804353,0,0,9.5249458303671597E-2,9.8748655542201025E-2,0.1074129879976866,0.11222127056985773,0.11323149456701836,0]
[null,null,null,null,{"$f":"E33","v":"NES - Allocated innovation funding - Nominal"},0,"£m",13.649605393436822,0,0,2.467653603263726,2.55830825713754,2.7827774728625143,2.9073469562594703,2.9335191039135724,0]
[null,null,null,null,{"$f":"E34","v":"NWT - Allocated innovation funding - Nominal"},0,"£m",34.016646012733766,0,0,6.1497235037014963,6.3756470510382721,6.9350544208472122,7.2454982687507474,7.3107227683960385,0]
[null,null,null,null,{"$f":"E35","v":"SRN - Allocated innovation funding - Nominal"},0,"£m",15.401605801633515,0,0,2.7843902411071086,2.8866809083317717,3.13996195753047,3.2805206054101781,3.3100520892539853,0]
[null,null,null,null,{"$f":"E36","v":"SVE - Allocated innovation funding - Nominal"},0,"£m",32.872389867862218,0,0,5.9428583440459182,6.1611822471610234,6.701772202691358,7.0017733020514816,7.064803771912433,0]
[null,null,null,null,{"$f":"E37","v":"SWB - Allocated innovation funding - Nominal"},0,"£m",10.21613901437793,0,0,1.8469319459150497,1.914783031684937,2.0827885268033071,2.1760233949661965,2.1956121150084398,0]
[null,null,null,null,{"$f":"E38","v":"TMS - Allocated innovation funding - Nominal"},0,"£m",39.760487679262312,0,0,7.1881279979296382,7.4521996061939122,8.1060650644948495,8.4689285515373598,8.5451664591065501,0]
[null,null,null,null,{"$f":"E39","v":"WSH - Allocated innovation funding - Nominal"},0,"£m",14.312829798951853,0,0,2.5875550983522611,2.6826145959698762,2.9179906077423907,3.048612831800332,3.0760566650869938,0]
[null,null,null,null,{"$f":"E40","v":"WSX - Allocated innovation funding - Nominal"},0,"£m",9.5673316888566866,0,0,1.7296368528703652,1.7931788467778458,1.9505146362660148,2.0378283374035773,2.0561730155388829,0]
[null,null,null,null,{"$f":"E41","v":"YKY - Allocated innovation funding - Nominal"},0,"£m",20.375908911897124,0,0,3.6836731610126257,3.8190009537604346,4.1540849478615591,4.3400402464754597,4.379109602787044,0]
[null,null,null,null,{"$f":"E42","v":"AFW - Allocated innovation funding - Nominal"},0,"£m",5.609474286762981,0,0,1.0141127920666257,1.051368444169585,1.1436168467779517,1.194810217860061,1.2055659858887575,0]
[null,null,null,null,{"$f":"E43","v":"BRL - Allocated innovation funding - Nominal"},0,"£m",2.1904345603125899,0,0,0.39599926735374857,0.41054716681125658,0.44656909665302802,0.4665595134986445,0.47075951599591193,0]
[null,null,null,null,{"$f":"E44","v":"PRT - Allocated innovation funding - Nominal"},0,"£m",0.75227052963079388,0,0,0.13599976186601925,0.1409960106598446,0.15336717971066782,0.16023257607560018,0.16167500131866205,0]
[null,null,null,null,{"$f":"E45","v":"SES - Allocated innovation funding - Nominal"},0,"£m",1.1397394688118787,0,0,0.20604860916696177,0.21361825561997547,0.23236139267930875,0.24276292098321733,0.24494829036241531,0]
[null,null,null,null,{"$f":"E46","v":"SEW - Allocated innovation funding - Nominal"},0,"£m",4.5766755224273288,0,0,0.82739753409406613,0.85779379269784262,0.93305770953172551,0.97482551812921037,0.98360096797448415,0]
[null,null,null,null,{"$f":"E47","v":"SSC - Allocated innovation funding - Nominal"},0,"£m",2.3661742029601003,0,0,0.4277704834376897,0.44348556802743444,0.48239755502615794,0.5039918128522245,0.5085287836165937,0]
[null,null,null,null,"Total Allocated Funding - Nominal",null,"£m",{"$f":" SUM(J70:P70)","v":231.64164238285625},null,{"$f":" SUM(J53:J69)","v":0},41.877498800575736,43.415960339037269,47.225331840716457,49.339347513193651,49.783503889333133,0]
[]
[null,null,null,null,"ANH - Proportion of Funding allocated",{"$f":" IF( $H$70 = 0, 0,H53 / $H$70)","v":0.10493392088708854},"%"]
[null,null,null,null,"HDD - Proportion of Funding allocated",2.2744782050441391E-3,"%"]
[null,null,null,null,"NES - Proportion of Funding allocated",5.8925525017979354E-2,"%"]
[null,null,null,null,"NWT - Proportion of Funding allocated",0.14685030576890493,"%"]
[null,null,null,null,"SRN - Proportion of Funding allocated",6.648893369603126E-2,"%"]
[null,null,null,null,"SVE - Proportion of Funding allocated",0.14191053702481907,"%"]
[null,null,null,null,"SWB - Proportion of Funding allocated",4.4103205750426956E-2,"%"]
[null,null,null,null,"TMS - Proportion of Funding allocated",0.17164654537177887,"%"]
[null,null,null,null,"WSH - Proportion of Funding allocated",6.1788673451449949E-2,"%"]
[null,null,null,null,"WSX - Proportion of Funding allocated",4.1302296039862491E-2,"%"]
[null,null,null,null,"YKY - Proportion of Funding allocated",8.7963065286076308E-2,"%"]
[null,null,null,null,"AFW - Proportion of Funding allocated",2.4216173866923579E-2,"%"]
[null,null,null,null,"BRL - Proportion of Funding allocated",9.4561346473802394E-3,"%"]
[null,null,null,null,"PRT - Proportion of Funding allocated",3.2475617159864745E-3,"%"]
[null,null,null,null,"SES - Proportion of Funding allocated",4.920270194458916E-3,"%"]
[null,null,null,null,"SEW - Proportion of Funding allocated",1.9757568092454724E-2,"%"]
[null,null,null,null,"SSC - Proportion of Funding allocated",1.0214804983334122E-2,"%"]
[null,null,null,null,"Total Allocated",{"$f":"SUM(F72:F88)","v":1},"%"]
[null,null,null,null,"Allocated funding proportion check",{"$f":" IF(OR(F89=1,F89=0), 0, 1)","v":0},"check"]
[]
[null,null,null,"Total Funding transferred to winning bids"]
[null,null,null,null,{"$f":" InpActive!E47","v":"ANH - Total Funding transferred to winning bids - Nominal"},{"$f":" InpActive!F47","v":0},{"$f":" InpActive!G47","v":"£m"},{"$f":" InpActive!H47","v":0},{"$f":" InpActive!I47","v":0},{"$f":" InpActive!J47","v":0},{"$f":" InpActive!K47","v":0},{"$f":" InpActive!L47","v":0},{"$f":" InpActive!M47","v":0},{"$f":" InpActive!N47","v":0},{"$f":" InpActive!O47","v":0},{"$f":" InpActive!P47","v":0}]
[null,null,null,null,{"$f":" InpActive!E48","v":"HDD - Total Funding transferred to winning bids - Nominal"},{"$f":" InpActive!F48","v":0},{"$f":" InpActive!G48","v":"£m"},{"$f":" InpActive!H48","v":0},{"$f":" InpActive!I48","v":0},{"$f":" InpActive!J48","v":0},{"$f":" InpActive!K48","v":0},{"$f":" InpActive!L48","v":0},{"$f":" InpActive!M48","v":0},{"$f":" InpActive!N48","v":0},{"$f":" InpActive!O48","v":0},{"$f":" InpActive!P48","v":0}]
[null,null,null,null,{"$f":" InpActive!E49","v":"NES - Total Funding transferred to winning bids - Nominal"},{"$f":" InpActive!F49","v":0},{"$f":" InpActive!G49","v":"£m"},{"$f":" InpActive!H49","v":0},{"$f":" InpActive!I49","v":0},{"$f":" InpActive!J49","v":0},{"$f":" InpActive!K49","v":0},{"$f":" InpActive!L49","v":0},{"$f":" InpActive!M49","v":0},{"$f":" InpActive!N49","v":0},{"$f":" InpActive!O49","v":0},{"$f":" InpActive!P49","v":0}]
[null,null,null,null,{"$f":" InpActive!E50","v":"NWT - Total Funding transferred to winning bids - Nominal"},{"$f":" InpActive!F50","v":0},{"$f":" InpActive!G50","v":"£m"},{"$f":" InpActive!H50","v":0},{"$f":" InpActive!I50","v":0},{"$f":" InpActive!J50","v":0},{"$f":" InpActive!K50","v":0},{"$f":" InpActive!L50","v":0},{"$f":" InpActive!M50","v":0},{"$f":" InpActive!N50","v":0},{"$f":" InpActive!O50","v":0},{"$f":" InpActive!P50","v":0}]
[null,null,null,null,{"$f":" InpActive!E51","v":"SRN - Total Funding transferred to winning bids - Nominal"},{"$f":" InpActive!F51","v":0},{"$f":" InpActive!G51","v":"£m"},{"$f":" InpActive!H51","v":0},{"$f":" InpActive!I51","v":0},{"$f":" InpActive!J51","v":0},{"$f":" InpActive!K51","v":0},{"$f":" InpActive!L51","v":0},{"$f":" InpActive!M51","v":0},{"$f":" InpActive!N51","v":0},{"$f":" InpActive!O51","v":0},{"$f":" InpActive!P51","v":0}]
[null,null,null,null,{"$f":" InpActive!E52","v":"SVE - Total Funding transferred to winning bids - Nominal"},{"$f":" InpActive!F52","v":0},{"$f":" InpActive!G52","v":"£m"},{"$f":" InpActive!H52","v":0},{"$f":" InpActive!I52","v":0},{"$f":" InpActive!J52","v":0},{"$f":" InpActive!K52","v":0},{"$f":" InpActive!L52","v":0},{"$f":" InpActive!M52","v":0},{"$f":" InpActive!N52","v":0},{"$f":" InpActive!O52","v":0},{"$f":" InpActive!P52","v":0}]
[null,null,null,null,{"$f":" InpActive!E53","v":"SWB - Total Funding transferred to winning bids - Nominal"},{"$f":" InpActive!F53","v":0},{"$f":" InpActive!G53","v":"£m"},{"$f":" InpActive!H53","v":0},{"$f":" InpActive!I53","v":0},{"$f":" InpActive!J53","v":0},{"$f":" InpActive!K53","v":0},{"$f":" InpActive!L53","v":0},{"$f":" InpActive!M53","v":0},{"$f":" InpActive!N53","v":0},{"$f":" InpActive!O53","v":0},{"$f":" InpActive!P53","v":0}]
[null,null,null,null,{"$f":" InpActive!E54","v":"TMS - Total Funding transferred to winning bids - Nominal"},{"$f":" InpActive!F54","v":0},{"$f":" InpActive!G54","v":"£m"},{"$f":" InpActive!H54","v":0},{"$f":" InpActive!I54","v":0},{"$f":" InpActive!J54","v":0},{"$f":" InpActive!K54","v":0},{"$f":" InpActive!L54","v":0},{"$f":" InpActive!M54","v":0},{"$f":" InpActive!N54","v":0},{"$f":" InpActive!O54","v":0},{"$f":" InpActive!P54","v":0}]
[null,null,null,null,{"$f":" InpActive!E55","v":"WSH - Total Funding transferred to winning bids - Nominal"},{"$f":" InpActive!F55","v":0},{"$f":" InpActive!G55","v":"£m"},{"$f":" InpActive!H55","v":0},{"$f":" InpActive!I55","v":0},{"$f":" InpActive!J55","v":0},{"$f":" InpActive!K55","v":0},{"$f":" InpActive!L55","v":0},{"$f":" InpActive!M55","v":0},{"$f":" InpActive!N55","v":0},{"$f":" InpActive!O55","v":0},{"$f":" InpActive!P55","v":0}]
[null,null,null,null,{"$f":" InpActive!E56","v":"WSX - Total Funding transferred to winning bids - Nominal"},{"$f":" InpActive!F56","v":0},{"$f":" InpActive!G56","v":"£m"},{"$f":" InpActive!H56","v":0},{"$f":" InpActive!I56","v":0},{"$f":" InpActive!J56","v":0},{"$f":" InpActive!K56","v":0},{"$f":" InpActive!L56","v":0},{"$f":" InpActive!M56","v":0},{"$f":" InpActive!N56","v":0},{"$f":" InpActive!O56","v":0},{"$f":" InpActive!P56","v":0}]
[null,null,null,null,{"$f":" InpActive!E57","v":"YKY - Total Funding transferred to winning bids - Nominal"},{"$f":" InpActive!F57","v":0},{"$f":" InpActive!G57","v":"£m"},{"$f":" InpActive!H57","v":0},{"$f":" InpActive!I57","v":0},{"$f":" InpActive!J57","v":0},{"$f":" InpActive!K57","v":0},{"$f":" InpActive!L57","v":0},{"$f":" InpActive!M57","v":0},{"$f":" InpActive!N57","v":0},{"$f":" InpActive!O57","v":0},{"$f":" InpActive!P57","v":0}]
[null,null,null,null,{"$f":" InpActive!E58","v":"AFW - Total Funding transferred to winning bids - Nominal"},{"$f":" InpActive!F58","v":0},{"$f":" InpActive!G58","v":"£m"},{"$f":" InpActive!H58","v":0},{"$f":" InpActive!I58","v":0},{"$f":" InpActive!J58","v":0},{"$f":" InpActive!K58","v":0},{"$f":" InpActive!L58","v":0},{"$f":" InpActive!M58","v":0},{"$f":" InpActive!N58","v":0},{"$f":" InpActive!O58","v":0},{"$f":" InpActive!P58","v":0}]
[null,null,null,null,{"$f":" InpActive!E59","v":"BRL - Total Funding transferred to winning bids - Nominal"},{"$f":" InpActive!F59","v":0},{"$f":" InpActive!G59","v":"£m"},{"$f":" InpActive!H59","v":0},{"$f":" InpActive!I59","v":0},{"$f":" InpActive!J59","v":0},{"$f":" InpActive!K59","v":0},{"$f":" InpActive!L59","v":0},{"$f":" InpActive!M59","v":0},{"$f":" InpActive!N59","v":0},{"$f":" InpActive!O59","v":0},{"$f":" InpActive!P59","v":0}]
[null,null,null,null,{"$f":" InpActive!E60","v":"PRT - Total Funding transferred to winning bids - Nominal"},{"$f":" InpActive!F60","v":0},{"$f":" InpActive!G60","v":"£m"},{"$f":" InpActive!H60","v":0},{"$f":" InpActive!I60","v":0},{"$f":" InpActive!J60","v":0},{"$f":" InpActive!K60","v":0},{"$f":" InpActive!L60","v":0},{"$f":" InpActive!M60","v":0},{"$f":" InpActive!N60","v":0},{"$f":" InpActive!O60","v":0},{"$f":" InpActive!P60","v":0}]
[null,null,null,null,{"$f":" InpActive!E61","v":"SES - Total Funding transferred to winning bids - Nominal"},{"$f":" InpActive!F61","v":0},{"$f":" InpActive!G61","v":"£m"},{"$f":" InpActive!H61","v":0},{"$f":" InpActive!I61","v":0},{"$f":" InpActive!J61","v":0},{"$f":" InpActive!K61","v":0},{"$f":" InpActive!L61","v":0},{"$f":" InpActive!M61","v":0},{"$f":" InpActive!N61","v":0},{"$f":" InpActive!O61","v":0},{"$f":" InpActive!P61","v":0}]
[null,null,null,null,{"$f":" InpActive!E62","v":"SEW - Total Funding transferred to winning bids - Nominal"},{"$f":" InpActive!F62","v":0},{"$f":" InpActive!G62","v":"£m"},{"$f":" InpActive!H62","v":0},{"$f":" InpActive!I62","v":0},{"$f":" InpActive!J62","v":0},{"$f":" InpActive!K62","v":0},{"$f":" InpActive!L62","v":0},{"$f":" InpActive!M62","v":0},{"$f":" InpActive!N62","v":0},{"$f":" InpActive!O62","v":0},{"$f":" InpActive!P62","v":0}]
[null,null,null,null,{"$f":" InpActive!E63","v":"SSC - Total Funding transferred to winning bids - Nominal"},{"$f":" InpActive!F63","v":0},{"$f":" InpActive!G63","v":"£m"},{"$f":" InpActive!H63","v":0},{"$f":" InpActive!I63","v":0},{"$f":" InpActive!J63","v":0},{"$f":" InpActive!K63","v":0},{"$f":" InpActive!L63","v":0},{"$f":" InpActive!M63","v":0},{"$f":" InpActive!N63","v":0},{"$f":" InpActive!O63","v":0},{"$f":" InpActive!P63","v":0}]
[null,null,null,null,"Total Transferred - Nominal",null,"£m",{"$f":" SUM(J110:P110)","v":0},null,{"$f":" SUM(J93:J109)","v":0},{"$f":" SUM(K93:K109)","v":0},{"$f":" SUM(L93:L109)","v":0},{"$f":" SUM(M93:M109)","v":0},{"$f":" SUM(N93:N109)","v":0},{"$f":" SUM(O93:O109)","v":0},{"$f":" SUM(P93:P109)","v":0}]
[]
[null,null,null,"Bids Accepted"]
[null,null,null,null,{"$f":" InpActive!E67","v":"ANH - Bids Accepted & Funding Awarded - Nominal"},{"$f":" InpActive!F67","v":0},{"$f":" InpActive!G67","v":"£m"},{"$f":" InpActive!H67","v":0},{"$f":" InpActive!I67","v":0},{"$f":" InpActive!J67","v":0},{"$f":" InpActive!K67","v":0},{"$f":" InpActive!L67","v":0},{"$f":" InpActive!M67","v":0},{"$f":" InpActive!N67","v":0},{"$f":" InpActive!O67","v":0},{"$f":" InpActive!P67","v":0}]
[null,null,null,null,{"$f":" InpActive!E68","v":"HDD - Bids Accepted & Funding Awarded - Nominal"},{"$f":" InpActive!F68","v":0},{"$f":" InpActive!G68","v":"£m"},{"$f":" InpActive!H68","v":0},{"$f":" InpActive!I68","v":0},{"$f":" InpActive!J68","v":0},{"$f":" InpActive!K68","v":0},{"$f":" InpActive!L68","v":0},{"$f":" InpActive!M68","v":0},{"$f":" InpActive!N68","v":0},{"$f":" InpActive!O68","v":0},{"$f":" InpActive!P68","v":0}]
[null,null,null,null,{"$f":" InpActive!E69","v":"NES - Bids Accepted & Funding Awarded - Nominal"},{"$f":" InpActive!F69","v":0},{"$f":" InpActive!G69","v":"£m"},{"$f":" InpActive!H69","v":0},{"$f":" InpActive!I69","v":0},{"$f":" InpActive!J69","v":0},{"$f":" InpActive!K69","v":0},{"$f":" InpActive!L69","v":0},{"$f":" InpActive!M69","v":0},{"$f":" InpActive!N69","v":0},{"$f":" InpActive!O69","v":0},{"$f":" InpActive!P69","v":0}]
[null,null,null,null,{"$f":" InpActive!E70","v":"NWT - Bids Accepted & Funding Awarded - Nominal"},{"$f":" InpActive!F70","v":0},{"$f":" InpActive!G70","v":"£m"},{"$f":" InpActive!H70","v":0},{"$f":" InpActive!I70","v":0},{"$f":" InpActive!J70","v":0},{"$f":" InpActive!K70","v":0},{"$f":" InpActive!L70","v":0},{"$f":" InpActive!M70","v":0},{"$f":" InpActive!N70","v":0},{"$f":" InpActive!O70","v":0},{"$f":" InpActive!P70","v":0}]
[null,null,null,null,{"$f":" InpActive!E71","v":"SRN - Bids Accepted & Funding Awarded - Nominal"},{"$f":" InpActive!F71","v":0},{"$f":" InpActive!G71","v":"£m"},{"$f":" InpActive!H71","v":0},{"$f":" InpActive!I71","v":0},{"$f":" InpActive!J71","v":0},{"$f":" InpActive!K71","v":0},{"$f":" InpActive!L71","v":0},{"$f":" InpActive!M71","v":0},{"$f":" InpActive!N71","v":0},{"$f":" InpActive!O71","v":0},{"$f":" InpActive!P71","v":0}]
[null,null,null,null,{"$f":" InpActive!E72","v":"SVE - Bids Accepted & Funding Awarded - Nominal"},{"$f":" InpActive!F72","v":0},{"$f":" InpActive!G72","v":"£m"},{"$f":" InpActive!H72","v":0},{"$f":" InpActive!I72","v":0},{"$f":" InpActive!J72","v":0},{"$f":" InpActive!K72","v":0},{"$f":" InpActive!L72","v":0},{"$f":" InpActive!M72","v":0},{"$f":" InpActive!N72","v":0},{"$f":" InpActive!O72","v":0},{"$f":" InpActive!P72","v":0}]
[null,null,null,null,{"$f":" InpActive!E73","v":"SWB - Bids Accepted & Funding Awarded - Nominal"},{"$f":" InpActive!F73","v":0},{"$f":" InpActive!G73","v":"£m"},{"$f":" InpActive!H73","v":0},{"$f":" InpActive!I73","v":0},{"$f":" InpActive!J73","v":0},{"$f":" InpActive!K73","v":0},{"$f":" InpActive!L73","v":0},{"$f":" InpActive!M73","v":0},{"$f":" InpActive!N73","v":0},{"$f":" InpActive!O73","v":0},{"$f":" InpActive!P73","v":0}]
[null,null,null,null,{"$f":" InpActive!E74","v":"TMS - Bids Accepted & Funding Awarded - Nominal"},{"$f":" InpActive!F74","v":0},{"$f":" InpActive!G74","v":"£m"},{"$f":" InpActive!H74","v":0},{"$f":" InpActive!I74","v":0},{"$f":" InpActive!J74","v":0},{"$f":" InpActive!K74","v":0},{"$f":" InpActive!L74","v":0},{"$f":" InpActive!M74","v":0},{"$f":" InpActive!N74","v":0},{"$f":" InpActive!O74","v":0},{"$f":" InpActive!P74","v":0}]
[null,null,null,null,{"$f":" InpActive!E75","v":"WSH - Bids Accepted & Funding Awarded - Nominal"},{"$f":" InpActive!F75","v":0},{"$f":" InpActive!G75","v":"£m"},{"$f":" InpActive!H75","v":0},{"$f":" InpActive!I75","v":0},{"$f":" InpActive!J75","v":0},{"$f":" InpActive!K75","v":0},{"$f":" InpActive!L75","v":0},{"$f":" InpActive!M75","v":0},{"$f":" InpActive!N75","v":0},{"$f":" InpActive!O75","v":0},{"$f":" InpActive!P75","v":0}]
[null,null,null,null,{"$f":" InpActive!E76","v":"WSX - Bids Accepted & Funding Awarded - Nominal"},{"$f":" InpActive!F76","v":0},{"$f":" InpActive!G76","v":"£m"},{"$f":" InpActive!H76","v":0},{"$f":" InpActive!I76","v":0},{"$f":" InpActive!J76","v":0},{"$f":" InpActive!K76","v":0},{"$f":" InpActive!L76","v":0},{"$f":" InpActive!M76","v":0},{"$f":" InpActive!N76","v":0},{"$f":" InpActive!O76","v":0},{"$f":" InpActive!P76","v":0}]
[null,null,null,null,{"$f":" InpActive!E77","v":"YKY - Bids Accepted & Funding Awarded - Nominal"},{"$f":" InpActive!F77","v":0},{"$f":" InpActive!G77","v":"£m"},{"$f":" InpActive!H77","v":0},{"$f":" InpActive!I77","v":0},{"$f":" InpActive!J77","v":0},{"$f":" InpActive!K77","v":0},{"$f":" InpActive!L77","v":0},{"$f":" InpActive!M77","v":0},{"$f":" InpActive!N77","v":0},{"$f":" InpActive!O77","v":0},{"$f":" InpActive!P77","v":0}]
[null,null,null,null,{"$f":" InpActive!E78","v":"AFW - Bids Accepted & Funding Awarded - Nominal"},{"$f":" InpActive!F78","v":0},{"$f":" InpActive!G78","v":"£m"},{"$f":" InpActive!H78","v":0},{"$f":" InpActive!I78","v":0},{"$f":" InpActive!J78","v":0},{"$f":" InpActive!K78","v":0},{"$f":" InpActive!L78","v":0},{"$f":" InpActive!M78","v":0},{"$f":" InpActive!N78","v":0},{"$f":" InpActive!O78","v":0},{"$f":" InpActive!P78","v":0}]
[null,null,null,null,{"$f":" InpActive!E79","v":"BRL - Bids Accepted & Funding Awarded - Nominal"},{"$f":" InpActive!F79","v":0},{"$f":" InpActive!G79","v":"£m"},{"$f":" InpActive!H79","v":0},{"$f":" InpActive!I79","v":0},{"$f":" InpActive!J79","v":0},{"$f":" InpActive!K79","v":0},{"$f":" InpActive!L79","v":0},{"$f":" InpActive!M79","v":0},{"$f":" InpActive!N79","v":0},{"$f":" InpActive!O79","v":0},{"$f":" InpActive!P79","v":0}]
[null,null,null,null,{"$f":" InpActive!E80","v":"PRT - Bids Accepted & Funding Awarded - Nominal"},{"$f":" InpActive!F80","v":0},{"$f":" InpActive!G80","v":"£m"},{"$f":" InpActive!H80","v":0},{"$f":" InpActive!I80","v":0},{"$f":" InpActive!J80","v":0},{"$f":" InpActive!K80","v":0},{"$f":" InpActive!L80","v":0},{"$f":" InpActive!M80","v":0},{"$f":" InpActive!N80","v":0},{"$f":" InpActive!O80","v":0},{"$f":" InpActive!P80","v":0}]
[null,null,null,null,{"$f":" InpActive!E81","v":"SES - Bids Accepted & Funding Awarded - Nominal"},{"$f":" InpActive!F81","v":0},{"$f":" InpActive!G81","v":"£m"},{"$f":" InpActive!H81","v":0},{"$f":" InpActive!I81","v":0},{"$f":" InpActive!J81","v":0},{"$f":" InpActive!K81","v":0},{"$f":" InpActive!L81","v":0},{"$f":" InpActive!M81","v":0},{"$f":" InpActive!N81","v":0},{"$f":" InpActive!O81","v":0},{"$f":" InpActive!P81","v":0}]
[null,null,null,null,{"$f":" InpActive!E82","v":"SEW - Bids Accepted & Funding Awarded - Nominal"},{"$f":" InpActive!F82","v":0},{"$f":" InpActive!G82","v":"£m"},{"$f":" InpActive!H82","v":0},{"$f":" InpActive!I82","v":0},{"$f":" InpActive!J82","v":0},{"$f":" InpActive!K82","v":0},{"$f":" InpActive!L82","v":0},{"$f":" InpActive!M82","v":0},{"$f":" InpActive!N82","v":0},{"$f":" InpActive!O82","v":0},{"$f":" InpActive!P82","v":0}]
[null,null,null,null,{"$f":" InpActive!E83","v":"SSC - Bids Accepted & Funding Awarded - Nominal"},{"$f":" InpActive!F83","v":0},{"$f":" InpActive!G83","v":"£m"},{"$f":" InpActive!H83","v":0},{"$f":" InpActive!I83","v":0},{"$f":" InpActive!J83","v":0},{"$f":" InpActive!K83","v":0},{"$f":" InpActive!L83","v":0},{"$f":" InpActive!M83","v":0},{"$f":" InpActive!N83","v":0},{"$f":" InpActive!O83","v":0},{"$f":" InpActive!P83","v":0}]
[null,null,null,null,{"$f":" InpActive!E84","v":"NAV - Bids Accepted & Funding Awarded - Nominal"},{"$f":" InpActive!F84","v":0},{"$f":" InpActive!G84","v":"£m"},{"$f":" InpActive!H84","v":0},{"$f":" InpActive!I84","v":0},{"$f":" InpActive!J84","v":0},{"$f":" InpActive!K84","v":0},{"$f":" InpActive!L84","v":0},{"$f":" InpActive!M84","v":0},{"$f":" InpActive!N84","v":0},{"$f":" InpActive!O84","v":0},{"$f":" InpActive!P84","v":0}]
[null,null,null,null,"Total Bids accepted - Nominal",null,"£m",{"$f":" SUM(J131:P131)","v":0},null,{"$f":" SUM(J113:J130)","v":0},{"$f":" SUM(K113:K130)","v":0},0,0,0,0,0]
[]
[null,null,null,"Total spend to date"]
[]
[null,null,null,"Project Costs"]
[null,null,null,null,{"$f":" InpActive!E92","v":"ANH - Expenditure on innovation spend to date - Nominal"},{"$f":" InpActive!F92","v":0},{"$f":" InpActive!G92","v":"£m"},{"$f":" InpActive!H92","v":0},{"$f":" InpActive!I92","v":0},{"$f":" InpActive!J92","v":0},{"$f":" InpActive!K92","v":0},{"$f":" InpActive!L92","v":0},{"$f":" InpActive!M92","v":0},{"$f":" InpActive!N92","v":0},{"$f":" InpActive!O92","v":0},{"$f":" InpActive!P92","v":0}]
[null,null,null,null,{"$f":" InpActive!E93","v":"HDD - Expenditure on innovation spend to date - Nominal"},{"$f":" InpActive!F93","v":0},{"$f":" InpActive!G93","v":"£m"},{"$f":" InpActive!H93","v":0},{"$f":" InpActive!I93","v":0},{"$f":" InpActive!J93","v":0},{"$f":" InpActive!K93","v":0},{"$f":" InpActive!L93","v":0},{"$f":" InpActive!M93","v":0},{"$f":" InpActive!N93","v":0},{"$f":" InpActive!O93","v":0},{"$f":" InpActive!P93","v":0}]
[null,null,null,null,{"$f":" InpActive!E94","v":"NES - Expenditure on innovation spend to date - Nominal"},{"$f":" InpActive!F94","v":0},{"$f":" InpActive!G94","v":"£m"},{"$f":" InpActive!H94","v":0},{"$f":" InpActive!I94","v":0},{"$f":" InpActive!J94","v":0},{"$f":" InpActive!K94","v":0},{"$f":" InpActive!L94","v":0},{"$f":" InpActive!M94","v":0},{"$f":" InpActive!N94","v":0},{"$f":" InpActive!O94","v":0},{"$f":" InpActive!P94","v":0}]
[null,null,null,null,{"$f":" InpActive!E95","v":"NWT - Expenditure on innovation spend to date - Nominal"},{"$f":" InpActive!F95","v":0},{"$f":" InpActive!G95","v":"£m"},{"$f":" InpActive!H95","v":0},{"$f":" InpActive!I95","v":0},{"$f":" InpActive!J95","v":0},{"$f":" InpActive!K95","v":0},{"$f":" InpActive!L95","v":0},{"$f":" InpActive!M95","v":0},{"$f":" InpActive!N95","v":0},{"$f":" InpActive!O95","v":0},{"$f":" InpActive!P95","v":0}]
[null,null,null,null,{"$f":" InpActive!E96","v":"SRN - Expenditure on innovation spend to date - Nominal"},{"$f":" InpActive!F96","v":0},{"$f":" InpActive!G96","v":"£m"},{"$f":" InpActive!H96","v":0},{"$f":" InpActive!I96","v":0},{"$f":" InpActive!J96","v":0},{"$f":" InpActive!K96","v":0},{"$f":" InpActive!L96","v":0},{"$f":" InpActive!M96","v":0},{"$f":" InpActive!N96","v":0},{"$f":" InpActive!O96","v":0},{"$f":" InpActive!P96","v":0}]
[null,null,null,null,{"$f":" InpActive!E97","v":"SVE - Expenditure on innovation spend to date - Nominal"},{"$f":" InpActive!F97","v":0},{"$f":" InpActive!G97","v":"£m"},{"$f":" InpActive!H97","v":0},{"$f":" InpActive!I97","v":0},{"$f":" InpActive!J97","v":0},{"$f":" InpActive!K97","v":0},{"$f":" InpActive!L97","v":0},{"$f":" InpActive!M97","v":0},{"$f":" InpActive!N97","v":0},{"$f":" InpActive!O97","v":0},{"$f":" InpActive!P97","v":0}]
[null,null,null,null,{"$f":" InpActive!E98","v":"SWB - Expenditure on innovation spend to date - Nominal"},{"$f":" InpActive!F98","v":0},{"$f":" InpActive!G98","v":"£m"},{"$f":" InpActive!H98","v":0},{"$f":" InpActive!I98","v":0},{"$f":" InpActive!J98","v":0},{"$f":" InpActive!K98","v":0},{"$f":" InpActive!L98","v":0},{"$f":" InpActive!M98","v":0},{"$f":" InpActive!N98","v":0},{"$f":" InpActive!O98","v":0},{"$f":" InpActive!P98","v":0}]
[null,null,null,null,{"$f":" InpActive!E99","v":"TMS - Expenditure on innovation spend to date - Nominal"},{"$f":" InpActive!F99","v":0},{"$f":" InpActive!G99","v":"£m"},{"$f":" InpActive!H99","v":0},{"$f":" InpActive!I99","v":0},{"$f":" InpActive!J99","v":0},{"$f":" InpActive!K99","v":0},{"$f":" InpActive!L99","v":0},{"$f":" InpActive!M99","v":0},{"$f":" InpActive!N99","v":0},{"$f":" InpActive!O99","v":0},{"$f":" InpActive!P99","v":0}]
[null,null,null,null,{"$f":" InpActive!E100","v":"WSH - Expenditure on innovation spend to date - Nominal"},{"$f":" InpActive!F100","v":0},{"$f":" InpActive!G100","v":"£m"},{"$f":" InpActive!H100","v":0},{"$f":" InpActive!I100","v":0},{"$f":" InpActive!J100","v":0},{"$f":" InpActive!K100","v":0},{"$f":" InpActive!L100","v":0},{"$f":" InpActive!M100","v":0},{"$f":" InpActive!N100","v":0},{"$f":" InpActive!O100","v":0},{"$f":" InpActive!P100","v":0}]
[null,null,null,null,{"$f":" InpActive!E101","v":"WSX - Expenditure on innovation spend to date - Nominal"},{"$f":" InpActive!F101","v":0},{"$f":" InpActive!G101","v":"£m"},{"$f":" InpActive!H101","v":0},{"$f":" InpActive!I101","v":0},{"$f":" InpActive!J101","v":0},{"$f":" InpActive!K101","v":0},{"$f":" InpActive!L101","v":0},{"$f":" InpActive!M101","v":0},{"$f":" InpActive!N101","v":0},{"$f":" InpActive!O101","v":0},{"$f":" InpActive!P101","v":0}]
[null,null,null,null,{"$f":" InpActive!E102","v":"YKY - Expenditure on innovation spend to date - Nominal"},{"$f":" InpActive!F102","v":0},{"$f":" InpActive!G102","v":"£m"},{"$f":" InpActive!H102","v":0},{"$f":" InpActive!I102","v":0},{"$f":" InpActive!J102","v":0},{"$f":" InpActive!K102","v":0},{"$f":" InpActive!L102","v":0},{"$f":" InpActive!M102","v":0},{"$f":" InpActive!N102","v":0},{"$f":" InpActive!O102","v":0},{"$f":" InpActive!P102","v":0}]
[null,null,null,null,{"$f":" InpActive!E103","v":"AFW - Expenditure on innovation spend to date - Nominal"},{"$f":" InpActive!F103","v":0},{"$f":" InpActive!G103","v":"£m"},{"$f":" InpActive!H103","v":0},{"$f":" InpActive!I103","v":0},{"$f":" InpActive!J103","v":0},{"$f":" InpActive!K103","v":0},{"$f":" InpActive!L103","v":0},{"$f":" InpActive!M103","v":0},{"$f":" InpActive!N103","v":0},{"$f":" InpActive!O103","v":0},{"$f":" InpActive!P103","v":0}]
[null,null,null,null,{"$f":" InpActive!E104","v":"BRL - Expenditure on innovation spend to date - Nominal"},{"$f":" InpActive!F104","v":0},{"$f":" InpActive!G104","v":"£m"},{"$f":" InpActive!H104","v":0},{"$f":" InpActive!I104","v":0},{"$f":" InpActive!J104","v":0},{"$f":" InpActive!K104","v":0},{"$f":" InpActive!L104","v":0},{"$f":" InpActive!M104","v":0},{"$f":" InpActive!N104","v":0},{"$f":" InpActive!O104","v":0},{"$f":" InpActive!P104","v":0}]
[null,null,null,null,{"$f":" InpActive!E105","v":"PRT - Expenditure on innovation spend to date - Nominal"},{"$f":" InpActive!F105","v":0},{"$f":" InpActive!G105","v":"£m"},{"$f":" InpActive!H105","v":0},{"$f":" InpActive!I105","v":0},{"$f":" InpActive!J105","v":0},{"$f":" InpActive!K105","v":0},{"$f":" InpActive!L105","v":0},{"$f":" InpActive!M105","v":0},{"$f":" InpActive!N105","v":0},{"$f":" InpActive!O105","v":0},{"$f":" InpActive!P105","v":0}]
[null,null,null,null,{"$f":" InpActive!E106","v":"SES - Expenditure on innovation spend to date - Nominal"},{"$f":" InpActive!F106","v":0},{"$f":" InpActive!G106","v":"£m"},{"$f":" InpActive!H106","v":0},{"$f":" InpActive!I106","v":0},{"$f":" InpActive!J106","v":0},{"$f":" InpActive!K106","v":0},{"$f":" InpActive!L106","v":0},{"$f":" InpActive!M106","v":0},{"$f":" InpActive!N106","v":0},{"$f":" InpActive!O106","v":0},{"$f":" InpActive!P106","v":0}]
[null,null,null,null,{"$f":" InpActive!E107","v":"SEW - Expenditure on innovation spend to date - Nominal"},{"$f":" InpActive!F107","v":0},{"$f":" InpActive!G107","v":"£m"},{"$f":" InpActive!H107","v":0},{"$f":" InpActive!I107","v":0},{"$f":" InpActive!J107","v":0},{"$f":" InpActive!K107","v":0},{"$f":" InpActive!L107","v":0},{"$f":" InpActive!M107","v":0},{"$f":" InpActive!N107","v":0},{"$f":" InpActive!O107","v":0},{"$f":" InpActive!P107","v":0}]
[null,null,null,null,{"$f":" InpActive!E108","v":"SSC - Expenditure on innovation spend to date - Nominal"},{"$f":" InpActive!F108","v":0},{"$f":" InpActive!G108","v":"£m"},{"$f":" InpActive!H108","v":0},{"$f":" InpActive!I108","v":0},{"$f":" InpActive!J108","v":0},{"$f":" InpActive!K108","v":0},{"$f":" InpActive!L108","v":0},{"$f":" InpActive!M108","v":0},{"$f":" InpActive!N108","v":0},{"$f":" InpActive!O108","v":0},{"$f":" InpActive!P108","v":0}]
[null,null,null,null,{"$f":" InpActive!E109","v":"NAV - Expenditure on innovation spend to date - Nominal"},{"$f":" InpActive!F109","v":0},{"$f":" InpActive!G109","v":"£m"},{"$f":" InpActive!H109","v":0},{"$f":" InpActive!I109","v":0},{"$f":" InpActive!J109","v":0},{"$f":" InpActive!K109","v":0},{"$f":" InpActive!L109","v":0},{"$f":" InpActive!M109","v":0},{"$f":" InpActive!N109","v":0},{"$f":" InpActive!O109","v":0},{"$f":" InpActive!P109","v":0}]
[]
[null,null,null,"Admin Costs"]
[null,null,null,null,{"$f":"InpActive!E112","v":"ANH - Administrative charge for innovation fund - Nominal"},{"$f":"InpActive!F112","v":0},{"$f":"InpActive!G112","v":"£m"},{"$f":"InpActive!H112","v":0},{"$f":"InpActive!I112","v":0},{"$f":"InpActive!J112","v":0},{"$f":"InpActive!K112","v":0},{"$f":"InpActive!L112","v":0},{"$f":"InpActive!M112","v":0},{"$f":"InpActive!N112","v":0},{"$f":"InpActive!O112","v":0},{"$f":"InpActive!P112","v":0}]
[null,null,null,null,{"$f":"InpActive!E113","v":"HDD - Administrative charge for innovation fund - Nominal"},{"$f":"InpActive!F113","v":0},{"$f":"InpActive!G113","v":"£m"},{"$f":"InpActive!H113","v":0},{"$f":"InpActive!I113","v":0},{"$f":"InpActive!J113","v":0},{"$f":"InpActive!K113","v":0},{"$f":"InpActive!L113","v":0},{"$f":"InpActive!M113","v":0},{"$f":"InpActive!N113","v":0},{"$f":"InpActive!O113","v":0},{"$f":"InpActive!P113","v":0}]
[null,null,null,null,{"$f":"InpActive!E114","v":"NES - Administrative charge for innovation fund - Nominal"},{"$f":"InpActive!F114","v":0},{"$f":"InpActive!G114","v":"£m"},{"$f":"InpActive!H114","v":0},{"$f":"InpActive!I114","v":0},{"$f":"InpActive!J114","v":0},{"$f":"InpActive!K114","v":0},{"$f":"InpActive!L114","v":0},{"$f":"InpActive!M114","v":0},{"$f":"InpActive!N114","v":0},{"$f":"InpActive!O114","v":0},{"$f":"InpActive!P114","v":0}]
[null,null,null,null,{"$f":"InpActive!E115","v":"NWT - Administrative charge for innovation fund - Nominal"},{"$f":"InpActive!F115","v":0},{"$f":"InpActive!G115","v":"£m"},{"$f":"InpActive!H115","v":0},{"$f":"InpActive!I115","v":0},{"$f":"InpActive!J115","v":0},{"$f":"InpActive!K115","v":0},{"$f":"InpActive!L115","v":0},{"$f":"InpActive!M115","v":0},{"$f":"InpActive!N115","v":0},{"$f":"InpActive!O115","v":0},{"$f":"InpActive!P115","v":0}]
[null,null,null,null,{"$f":"InpActive!E116","v":"SRN - Administrative charge for innovation fund - Nominal"},{"$f":"InpActive!F116","v":0},{"$f":"InpActive!G116","v":"£m"},{"$f":"InpActive!H116","v":0},{"$f":"InpActive!I116","v":0},{"$f":"InpActive!J116","v":0},{"$f":"InpActive!K116","v":0},{"$f":"InpActive!L116","v":0},{"$f":"InpActive!M116","v":0},{"$f":"InpActive!N116","v":0},{"$f":"InpActive!O116","v":0},{"$f":"InpActive!P116","v":0}]
[null,null,null,null,{"$f":"InpActive!E117","v":"SVE - Administrative charge for innovation fund - Nominal"},{"$f":"InpActive!F117","v":0},{"$f":"InpActive!G117","v":"£m"},{"$f":"InpActive!H117","v":0},{"$f":"InpActive!I117","v":0},{"$f":"InpActive!J117","v":0},{"$f":"InpActive!K117","v":0},{"$f":"InpActive!L117","v":0},{"$f":"InpActive!M117","v":0},{"$f":"InpActive!N117","v":0},{"$f":"InpActive!O117","v":0},{"$f":"InpActive!P117","v":0}]
[null,null,null,null,{"$f":"InpActive!E118","v":"SWB - Administrative charge for innovation fund - Nominal"},{"$f":"InpActive!F118","v":0},{"$f":"InpActive!G118","v":"£m"},{"$f":"InpActive!H118","v":0},{"$f":"InpActive!I118","v":0},{"$f":"InpActive!J118","v":0},{"$f":"InpActive!K118","v":0},{"$f":"InpActive!L118","v":0},{"$f":"InpActive!M118","v":0},{"$f":"InpActive!N118","v":0},{"$f":"InpActive!O118","v":0},{"$f":"InpActive!P118","v":0}]
[null,null,null,null,{"$f":"InpActive!E119","v":"TMS - Administrative charge for innovation fund - Nominal"},{"$f":"InpActive!F119","v":0},{"$f":"InpActive!G119","v":"£m"},{"$f":"InpActive!H119","v":0},{"$f":"InpActive!I119","v":0},{"$f":"InpActive!J119","v":0},{"$f":"InpActive!K119","v":0},{"$f":"InpActive!L119","v":0},{"$f":"InpActive!M119","v":0},{"$f":"InpActive!N119","v":0},{"$f":"InpActive!O119","v":0},{"$f":"InpActive!P119","v":0}]
[null,null,null,null,{"$f":"InpActive!E120","v":"WSH - Administrative charge for innovation fund - Nominal"},{"$f":"InpActive!F120","v":0},{"$f":"InpActive!G120","v":"£m"},{"$f":"InpActive!H120","v":0},{"$f":"InpActive!I120","v":0},{"$f":"InpActive!J120","v":0},{"$f":"InpActive!K120","v":0},{"$f":"InpActive!L120","v":0},{"$f":"InpActive!M120","v":0},{"$f":"InpActive!N120","v":0},{"$f":"InpActive!O120","v":0},{"$f":"InpActive!P120","v":0}]
[null,null,null,null,{"$f":"InpActive!E121","v":"WSX - Administrative charge for innovation fund - Nominal"},{"$f":"InpActive!F121","v":0},{"$f":"InpActive!G121","v":"£m"},{"$f":"InpActive!H121","v":0},{"$f":"InpActive!I121","v":0},{"$f":"InpActive!J121","v":0},{"$f":"InpActive!K121","v":0},{"$f":"InpActive!L121","v":0},{"$f":"InpActive!M121","v":0},{"$f":"InpActive!N121","v":0},{"$f":"InpActive!O121","v":0},{"$f":"InpActive!P121","v":0}]
[null,null,null,null,{"$f":"InpActive!E122","v":"YKY - Administrative charge for innovation fund - Nominal"},{"$f":"InpActive!F122","v":0},{"$f":"InpActive!G122","v":"£m"},{"$f":"InpActive!H122","v":0},{"$f":"InpActive!I122","v":0},{"$f":"InpActive!J122","v":0},{"$f":"InpActive!K122","v":0},{"$f":"InpActive!L122","v":0},{"$f":"InpActive!M122","v":0},{"$f":"InpActive!N122","v":0},{"$f":"InpActive!O122","v":0},{"$f":"InpActive!P122","v":0}]
[null,null,null,null,{"$f":"InpActive!E123","v":"AFW - Administrative charge for innovation fund - Nominal"},{"$f":"InpActive!F123","v":0},{"$f":"InpActive!G123","v":"£m"},{"$f":"InpActive!H123","v":0},{"$f":"InpActive!I123","v":0},{"$f":"InpActive!J123","v":0},{"$f":"InpActive!K123","v":0},{"$f":"InpActive!L123","v":0},{"$f":"InpActive!M123","v":0},{"$f":"InpActive!N123","v":0},{"$f":"InpActive!O123","v":0},{"$f":"InpActive!P123","v":0}]
[null,null,null,null,{"$f":"InpActive!E124","v":"BRL - Administrative charge for innovation fund - Nominal"},{"$f":"InpActive!F124","v":0},{"$f":"InpActive!G124","v":"£m"},{"$f":"InpActive!H124","v":0},{"$f":"InpActive!I124","v":0},{"$f":"InpActive!J124","v":0},{"$f":"InpActive!K124","v":0},{"$f":"InpActive!L124","v":0},{"$f":"InpActive!M124","v":0},{"$f":"InpActive!N124","v":0},{"$f":"InpActive!O124","v":0},{"$f":"InpActive!P124","v":0}]
[null,null,null,null,{"$f":"InpActive!E125","v":"PRT - Administrative charge for innovation fund - Nominal"},{"$f":"InpActive!F125","v":0},{"$f":"InpActive!G125","v":"£m"},{"$f":"InpActive!H125","v":0},{"$f":"InpActive!I125","v":0},{"$f":"InpActive!J125","v":0},{"$f":"InpActive!K125","v":0},{"$f":"InpActive!L125","v":0},{"$f":"InpActive!M125","v":0},{"$f":"InpActive!N125","v":0},{"$f":"InpActive!O125","v":0},{"$f":"InpActive!P125","v":0}]
[null,null,null,null,{"$f":"InpActive!E126","v":"SES - Administrative charge for innovation fund - Nominal"},{"$f":"InpActive!F126","v":0},{"$f":"InpActive!G126","v":"£m"},{"$f":"InpActive!H126","v":0},{"$f":"InpActive!I126","v":0},{"$f":"InpActive!J126","v":0},{"$f":"InpActive!K126","v":0},{"$f":"InpActive!L126","v":0},{"$f":"InpActive!M126","v":0},{"$f":"InpActive!N126","v":0},{"$f":"InpActive!O126","v":0},{"$f":"InpActive!P126","v":0}]
[null,null,null,null,{"$f":"InpActive!E127","v":"SEW - Administrative charge for innovation fund - Nominal"},{"$f":"InpActive!F127","v":0},{"$f":"InpActive!G127","v":"£m"},{"$f":"InpActive!H127","v":0},{"$f":"InpActive!I127","v":0},{"$f":"InpActive!J127","v":0},{"$f":"InpActive!K127","v":0},{"$f":"InpActive!L127","v":0},{"$f":"InpActive!M127","v":0},{"$f":"InpActive!N127","v":0},{"$f":"InpActive!O127","v":0},{"$f":"InpActive!P127","v":0}]
[null,null,null,null,{"$f":"InpActive!E128","v":"SSC - Administrative charge for innovation fund - Nominal"},{"$f":"InpActive!F128","v":0},{"$f":"InpActive!G128","v":"£m"},{"$f":"InpActive!H128","v":0},{"$f":"InpActive!I128","v":0},{"$f":"InpActive!J128","v":0},{"$f":"InpActive!K128","v":0},{"$f":"InpActive!L128","v":0},{"$f":"InpActive!M128","v":0},{"$f":"InpActive!N128","v":0},{"$f":"InpActive!O128","v":0},{"$f":"InpActive!P128","v":0}]
[null,null,null,null,"[BLANK]"]
[]
[null,null,null,"Total Costs"]
[null,null,null,null,"ANH - Total spend to date - Nominal",null,"£m",{"$f":" SUM(J176:P176)","v":0},null,{"$f":"J136+J156","v":0},{"$f":"K136+K156","v":0},0,0,0,0,0]
[null,null,null,null,"HDD - Total spend to date - Nominal",null,"£m",0,null,{"$f":"J137+J157","v":0},0,0,0,0,0,0]
[null,null,null,null,"NES - Total spend to date - Nominal",null,"£m",0,null,{"$f":"J138+J158","v":0},0,0,0,0,0,0]
[null,null,null,null,"NWT - Total spend to date - Nominal",null,"£m",0,null,{"$f":"J139+J159","v":0},0,0,0,0,0,0]
[null,null,null,null,"SRN - Total spend to date - Nominal",null,"£m",0,null,{"$f":"J140+J160","v":0},0,0,0,0,0,0]
[null,null,null,null,"SVE - Total spend to date - Nominal",null,"£m",0,null,{"$f":"J141+J161","v":0},0,0,0,0,0,0]
[null,null,null,null,"SWB - Total spend to date - Nominal",null,"£m",0,null,{"$f":"J142+J162","v":0},0,0,0,0,0,0]
[null,null,null,null,"TMS - Total spend to date - Nominal",null,"£m",0,null,{"$f":"J143+J163","v":0},0,0,0,0,0,0]
[null,null,null,null,"WSH - Total spend to date - Nominal",null,"£m",0,null,{"$f":"J144+J164","v":0},0,0,0,0,0,0]
[null,null,null,null,"WSX - Total spend to date - Nominal",null,"£m",0,null,{"$f":"J145+J165","v":0},0,0,0,0,0,0]
[null,null,null,null,"YKY - Total spend to date - Nominal",null,"£m",0,null,{"$f":"J146+J166","v":0},0,0,0,0,0,0]
[null,null,null,null,"AFW - Total spend to date - Nominal",null,"£m",0,null,{"$f":"J147+J167","v":0},0,0,0,0,0,0]
[null,null,null,null,"BRL - Total spend to date - Nominal",null,"£m",0,null,{"$f":"J148+J168","v":0},0,0,0,0,0,0]
[null,null,null,null,"PRT - Total spend to date - Nominal",null,"£m",0,null,{"$f":"J149+J169","v":0},0,0,0,0,0,0]
[null,null,null,null,"SES - Total spend to date - Nominal",null,"£m",0,null,{"$f":"J150+J170","v":0},0,0,0,0,0,0]
[null,null,null,null,"SEW - Total spend to date - Nominal",null,"£m",0,null,{"$f":"J151+J171","v":0},0,0,0,0,0,0]
[null,null,null,null,"SSC - Total spend to date - Nominal",null,"£m",0,null,{"$f":"J152+J172","v":0},0,0,0,0,0,0]
[null,null,null,null,"NAV - Total spend to date - Nominal",null,"£m",0,null,{"$f":"J153+J173","v":0},{"$f":"K153+K173","v":0},0,0,0,0,0]
[null,null,null,null,"Total spend to date - Nominal",null,"£m",{"$f":" SUM(J194:P194)","v":0},null,{"$f":" SUM(J176:J193)","v":0},{"$f":" SUM(K176:K193)","v":0},{"$f":" SUM(L176:L193)","v":0},{"$f":" SUM(M176:M193)","v":0},{"$f":" SUM(N176:N193)","v":0},{"$f":" SUM(O176:O193)","v":0},{"$f":" SUM(P176:P193)","v":0}]
[]
[null,null,null,"Allowed Future expenditure"]
[null,null,null,null,{"$f":" InpActive!E131","v":"ANH - Allowed Future expenditure on innovation projects - Nominal"},{"$f":" InpActive!F131","v":0},{"$f":" InpActive!G131","v":"£m"},{"$f":" InpActive!H131","v":0},{"$f":" InpActive!I131","v":0},{"$f":" InpActive!J131","v":0},{"$f":" InpActive!K131","v":0},{"$f":" InpActive!L131","v":0},{"$f":" InpActive!M131","v":0},{"$f":" InpActive!N131","v":0},{"$f":" InpActive!O131","v":0},{"$f":" InpActive!P131","v":0}]
[null,null,null,null,{"$f":" InpActive!E132","v":"HDD - Allowed Future expenditure on innovation projects - Nominal"},{"$f":" InpActive!F132","v":0},{"$f":" InpActive!G132","v":"£m"},{"$f":" InpActive!H132","v":0},{"$f":" InpActive!I132","v":0},{"$f":" InpActive!J132","v":0},{"$f":" InpActive!K132","v":0},{"$f":" InpActive!L132","v":0},{"$f":" InpActive!M132","v":0},{"$f":" InpActive!N132","v":0},{"$f":" InpActive!O132","v":0},{"$f":" InpActive!P132","v":0}]
[null,null,null,null,{"$f":" InpActive!E133","v":"NES - Allowed Future expenditure on innovation projects - Nominal"},{"$f":" InpActive!F133","v":0},{"$f":" InpActive!G133","v":"£m"},{"$f":" InpActive!H133","v":0},{"$f":" InpActive!I133","v":0},{"$f":" InpActive!J133","v":0},{"$f":" InpActive!K133","v":0},{"$f":" InpActive!L133","v":0},{"$f":" InpActive!M133","v":0},{"$f":" InpActive!N133","v":0},{"$f":" InpActive!O133","v":0},{"$f":" InpActive!P133","v":0}]
[null,null,null,null,{"$f":" InpActive!E134","v":"NWT - Allowed Future expenditure on innovation projects - Nominal"},{"$f":" InpActive!F134","v":0},{"$f":" InpActive!G134","v":"£m"},{"$f":" InpActive!H134","v":0},{"$f":" InpActive!I134","v":0},{"$f":" InpActive!J134","v":0},{"$f":" InpActive!K134","v":0},{"$f":" InpActive!L134","v":0},{"$f":" InpActive!M134","v":0},{"$f":" InpActive!N134","v":0},{"$f":" InpActive!O134","v":0},{"$f":" InpActive!P134","v":0}]
[null,null,null,null,{"$f":" InpActive!E135","v":"SRN - Allowed Future expenditure on innovation projects - Nominal"},{"$f":" InpActive!F135","v":0},{"$f":" InpActive!G135","v":"£m"},{"$f":" InpActive!H135","v":0},{"$f":" InpActive!I135","v":0},{"$f":" InpActive!J135","v":0},{"$f":" InpActive!K135","v":0},{"$f":" InpActive!L135","v":0},{"$f":" InpActive!M135","v":0},{"$f":" InpActive!N135","v":0},{"$f":" InpActive!O135","v":0},{"$f":" InpActive!P135","v":0}]
[null,null,null,null,{"$f":" InpActive!E136","v":"SVE - Allowed Future expenditure on innovation projects - Nominal"},{"$f":" InpActive!F136","v":0},{"$f":" InpActive!G136","v":"£m"},{"$f":" InpActive!H136","v":0},{"$f":" InpActive!I136","v":0},{"$f":" InpActive!J136","v":0},{"$f":" InpActive!K136","v":0},{"$f":" InpActive!L136","v":0},{"$f":" InpActive!M136","v":0},{"$f":" InpActive!N136","v":0},{"$f":" InpActive!O136","v":0},{"$f":" InpActive!P136","v":0}]
[null,null,null,null,{"$f":" InpActive!E137","v":"SWB - Allowed Future expenditure on innovation projects - Nominal"},{"$f":" InpActive!F137","v":0},{"$f":" InpActive!G137","v":"£m"},{"$f":" InpActive!H137","v":0},{"$f":" InpActive!I137","v":0},{"$f":" InpActive!J137","v":0},{"$f":" InpActive!K137","v":0},{"$f":" InpActive!L137","v":0},{"$f":" InpActive!M137","v":0},{"$f":" InpActive!N137","v":0},{"$f":" InpActive!O137","v":0},{"$f":" InpActive!P137","v":0}]
[null,null,null,null,{"$f":" InpActive!E138","v":"TMS - Allowed Future expenditure on innovation projects - Nominal"},{"$f":" InpActive!F138","v":0},{"$f":" InpActive!G138","v":"£m"},{"$f":" InpActive!H138","v":0},{"$f":" InpActive!I138","v":0},{"$f":" InpActive!J138","v":0},{"$f":" InpActive!K138","v":0},{"$f":" InpActive!L138","v":0},{"$f":" InpActive!M138","v":0},{"$f":" InpActive!N138","v":0},{"$f":" InpActive!O138","v":0},{"$f":" InpActive!P138","v":0}]
[null,null,null,null,{"$f":" InpActive!E139","v":"WSH - Allowed Future expenditure on innovation projects - Nominal"},{"$f":" InpActive!F139","v":0},{"$f":" InpActive!G139","v":"£m"},{"$f":" InpActive!H139","v":0},{"$f":" InpActive!I139","v":0},{"$f":" InpActive!J139","v":0},{"$f":" InpActive!K139","v":0},{"$f":" InpActive!L139","v":0},{"$f":" InpActive!M139","v":0},{"$f":" InpActive!N139","v":0},{"$f":" InpActive!O139","v":0},{"$f":" InpActive!P139","v":0}]
[null,null,null,null,{"$f":" InpActive!E140","v":"WSX - Allowed Future expenditure on innovation projects - Nominal"},{"$f":" InpActive!F140","v":0},{"$f":" InpActive!G140","v":"£m"},{"$f":" InpActive!H140","v":0},{"$f":" InpActive!I140","v":0},{"$f":" InpActive!J140","v":0},{"$f":" InpActive!K140","v":0},{"$f":" InpActive!L140","v":0},{"$f":" InpActive!M140","v":0},{"$f":" InpActive!N140","v":0},{"$f":" InpActive!O140","v":0},{"$f":" InpActive!P140","v":0}]
[null,null,null,null,{"$f":" InpActive!E141","v":"YKY - Allowed Future expenditure on innovation projects - Nominal"},{"$f":" InpActive!F141","v":0},{"$f":" InpActive!G141","v":"£m"},{"$f":" InpActive!H141","v":0},{"$f":" InpActive!I141","v":0},{"$f":" InpActive!J141","v":0},{"$f":" InpActive!K141","v":0},{"$f":" InpActive!L141","v":0},{"$f":" InpActive!M141","v":0},{"$f":" InpActive!N141","v":0},{"$f":" InpActive!O141","v":0},{"$f":" InpActive!P141","v":0}]
[null,null,null,null,{"$f":" InpActive!E142","v":"AFW - Allowed Future expenditure on innovation projects - Nominal"},{"$f":" InpActive!F142","v":0},{"$f":" InpActive!G142","v":"£m"},{"$f":" InpActive!H142","v":0},{"$f":" InpActive!I142","v":0},{"$f":" InpActive!J142","v":0},{"$f":" InpActive!K142","v":0},{"$f":" InpActive!L142","v":0},{"$f":" InpActive!M142","v":0},{"$f":" InpActive!N142","v":0},{"$f":" InpActive!O142","v":0},{"$f":" InpActive!P142","v":0}]
[null,null,null,null,{"$f":" InpActive!E143","v":"BRL - Allowed Future expenditure on innovation projects - Nominal"},{"$f":" InpActive!F143","v":0},{"$f":" InpActive!G143","v":"£m"},{"$f":" InpActive!H143","v":0},{"$f":" InpActive!I143","v":0},{"$f":" InpActive!J143","v":0},{"$f":" InpActive!K143","v":0},{"$f":" InpActive!L143","v":0},{"$f":" InpActive!M143","v":0},{"$f":" InpActive!N143","v":0},{"$f":" InpActive!O143","v":0},{"$f":" InpActive!P143","v":0}]
[null,null,null,null,{"$f":" InpActive!E144","v":"PRT - Allowed Future expenditure on innovation projects - Nominal"},{"$f":" InpActive!F144","v":0},{"$f":" InpActive!G144","v":"£m"},{"$f":" InpActive!H144","v":0},{"$f":" InpActive!I144","v":0},{"$f":" InpActive!J144","v":0},{"$f":" InpActive!K144","v":0},{"$f":" InpActive!L144","v":0},{"$f":" InpActive!M144","v":0},{"$f":" InpActive!N144","v":0},{"$f":" InpActive!O144","v":0},{"$f":" InpActive!P144","v":0}]
[null,null,null,null,{"$f":" InpActive!E145","v":"SES - Allowed Future expenditure on innovation projects - Nominal"},{"$f":" InpActive!F145","v":0},{"$f":" InpActive!G145","v":"£m"},{"$f":" InpActive!H145","v":0},{"$f":" InpActive!I145","v":0},{"$f":" InpActive!J145","v":0},{"$f":" InpActive!K145","v":0},{"$f":" InpActive!L145","v":0},{"$f":" InpActive!M145","v":0},{"$f":" InpActive!N145","v":0},{"$f":" InpActive!O145","v":0},{"$f":" InpActive!P145","v":0}]
[null,null,null,null,{"$f":" InpActive!E146","v":"SEW - Allowed Future expenditure on innovation projects - Nominal"},{"$f":" InpActive!F146","v":0},{"$f":" InpActive!G146","v":"£m"},{"$f":" InpActive!H146","v":0},{"$f":" InpActive!I146","v":0},{"$f":" InpActive!J146","v":0},{"$f":" InpActive!K146","v":0},{"$f":" InpActive!L146","v":0},{"$f":" InpActive!M146","v":0},{"$f":" InpActive!N146","v":0},{"$f":" InpActive!O146","v":0},{"$f":" InpActive!P146","v":0}]
[null,null,null,null,{"$f":" InpActive!E147","v":"SSC - Allowed Future expenditure on innovation projects - Nominal"},{"$f":" InpActive!F147","v":0},{"$f":" InpActive!G147","v":"£m"},{"$f":" InpActive!H147","v":0},{"$f":" InpActive!I147","v":0},{"$f":" InpActive!J147","v":0},{"$f":" InpActive!K147","v":0},{"$f":" InpActive!L147","v":0},{"$f":" InpActive!M147","v":0},{"$f":" InpActive!N147","v":0},{"$f":" InpActive!O147","v":0},{"$f":" InpActive!P147","v":0}]
[null,null,null,null,{"$f":" InpActive!E148","v":"NAV - Allowed Future expenditure on innovation projects - Nominal"},{"$f":" InpActive!F148","v":0},{"$f":" InpActive!G148","v":"£m"},{"$f":" InpActive!H148","v":0},{"$f":" InpActive!I148","v":0},{"$f":" InpActive!J148","v":0},{"$f":" InpActive!K148","v":0},{"$f":" InpActive!L148","v":0},{"$f":" InpActive!M148","v":0},{"$f":" InpActive!N148","v":0},{"$f":" InpActive!O148","v":0},{"$f":" InpActive!P148","v":0}]
[null,null,null,null,"Total allowed future expenditure - Nominal",null,"£m",{"$f":" SUM(J215:P215)","v":0},null,{"$f":" SUM(J197:J214)","v":0},{"$f":" SUM(K197:K214)","v":0},{"$f":" SUM(L197:L214)","v":0},{"$f":" SUM(M197:M214)","v":0},{"$f":" SUM(N197:N214)","v":0},{"$f":" SUM(O197:O214)","v":0},{"$f":" SUM(P197:P214)","v":0}]
[]
[null,null,null,"Total Unused funds"]
[null,null,null,null,{"$f":"E$48","v":"Total Allocated Funding - Nominal"},{"$f":"F$48","v":0},"£m",231.64164238285625,0,0,41.877498800575736,43.415960339037269,47.225331840716457,49.339347513193651,49.783503889333133,0]
[null,null,null,null,{"$f":"E$110","v":"Total Transferred - Nominal"},{"$f":"F$110","v":0},"£m",0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Total unused fund - Nominal",null,"£m",{"$f":" SUM(J220:P220)","v":231.64164238285625},null,{"$f":"J218-J219","v":0},{"$f":"K218-K219","v":41.877498800575736},{"$f":"L218-L219","v":43.415960339037269},47.225331840716457,49.339347513193651,49.783503889333133,{"$f":"P218-P219","v":0}]
[]
[null,null,null,"Total Underspend"]
[null,null,null,null,{"$f":" E$131","v":"Total Bids accepted - Nominal"},{"$f":" F$131","v":0},"£m",0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"E$194","v":"Total spend to date - Nominal"},{"$f":"F$194","v":0},"£m",0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$215","v":"Total allowed future expenditure - Nominal"},{"$f":" F$215","v":0},"£m",0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Total Underspend available - Nominal",null,"£m",{"$f":" SUM(J226:P226)","v":0},null,{"$f":" J223 - SUM(J224:J225)","v":0},{"$f":" K223 - SUM(K224:K225)","v":0},{"$f":" L223 - SUM(L224:L225)","v":0},0,0,0,0]
[]
[null,null,null,"Total returned to customers"]
[null,null,null,null,{"$f":" E$220","v":"Total unused fund - Nominal"},{"$f":" F$220","v":0},"£m",231.64164238285625,0,0,41.877498800575736,43.415960339037269,47.225331840716457,49.339347513193651,49.783503889333133,0]
[null,null,null,null,{"$f":" E$226","v":"Total Underspend available - Nominal"},{"$f":" F$226","v":0},"£m",0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Funds to be redistributed - Nominal",null,"£m",{"$f":" SUM(J231:P231)","v":231.64164238285625},null,{"$f":" SUM(J229:J230)","v":0},{"$f":" SUM(K229:K230)","v":41.877498800575736},43.415960339037269,47.225331840716457,49.339347513193651,49.783503889333133,0]
[]
[null,null,null,null,{"$f":" E$231","v":"Funds to be redistributed - Nominal"},{"$f":" F$231","v":0},"£m",231.64164238285625,0,0,41.877498800575736,43.415960339037269,47.225331840716457,49.339347513193651,49.783503889333133,0]
[null,null,null,null,{"$f":"Indexation!E$44","v":"CPI(H): Fin year average - conversion from outturn to base year 2017-18 average - CALC"},{"$f":"Indexation!F$44","v":0},{"$f":"Indexation!G$44","v":"%"},{"$f":"Indexation!H$44","v":0},{"$f":"Indexation!I$44","v":0},{"$f":"Indexation!J$44","v":1.0386214616983847},{"$f":"Indexation!K$44","v":1.0469374700143934},{"$f":"Indexation!L$44","v":1.0853990084759317},{"$f":"Indexation!M$44","v":1.1806332960179113},{"$f":"Indexation!N$44","v":1.2334836878298414},{"$f":"Indexation!O$44","v":1.2445875972333285},{"$f":"Indexation!P$44","v":1.2694793491779948}]
[null,null,null,null,"Funds to be redistributed - Real",null,"£m",{"$f":" SUM(J235:P235)","v":200},null,{"$f":" J233 / J234","v":0},{"$f":" K233 / K234","v":40},40,40,39.999999999999993,39.999999999999993,0]
[]
[null,null,null,"Proportion of Funding allocated"]
[null,null,null,null,{"$f":"E72","v":"ANH - Proportion of Funding allocated"},0.10493392088708854,"%"]
[null,null,null,null,"HDD - Proportion of Funding allocated",2.2744782050441391E-3,"%"]
[null,null,null,null,"NES - Proportion of Funding allocated",5.8925525017979354E-2,"%"]
[null,null,null,null,"NWT - Proportion of Funding allocated",0.14685030576890493,"%"]
[null,null,null,null,"SRN - Proportion of Funding allocated",6.648893369603126E-2,"%"]
[null,null,null,null,"SVE - Proportion of Funding allocated",0.14191053702481907,"%"]
[null,null,null,null,"SWB - Proportion of Funding allocated",4.4103205750426956E-2,"%"]
[null,null,null,null,"TMS - Proportion of Funding allocated",0.17164654537177887,"%"]
[null,null,null,null,"WSH - Proportion of Funding allocated",6.1788673451449949E-2,"%"]
[null,null,null,null,"WSX - Proportion of Funding allocated",4.1302296039862491E-2,"%"]
[null,null,null,null,"YKY - Proportion of Funding allocated",8.7963065286076308E-2,"%"]
[null,null,null,null,"AFW - Proportion of Funding allocated",2.4216173866923579E-2,"%"]
[null,null,null,null,"BRL - Proportion of Funding allocated",9.4561346473802394E-3,"%"]
[null,null,null,null,"PRT - Proportion of Funding allocated",3.2475617159864745E-3,"%"]
[null,null,null,null,"SES - Proportion of Funding allocated",4.920270194458916E-3,"%"]
[null,null,null,null,"SEW - Proportion of Funding allocated",1.9757568092454724E-2,"%"]
[null,null,null,null,"SSC - Proportion of Funding allocated",1.0214804983334122E-2,"%"]
[null,null,null,null,"Total Allocated",1,"%"]
[]
[null,null,null,null,{"$f":" E$235","v":"Funds to be redistributed - Real"},{"$f":" F$235","v":0},"£m",200,0,0,40,40,40,39.999999999999993,39.999999999999993,0]
[]
[null,null,null,"Proportion of Funding allocated"]
[null,null,null,null,"ANH - Total to be redistributed - Real",null,null,{"$f":" SUM(J260:P260)","v":20.986784177417704},null,{"$f":" J$257 * $F238","v":0},{"$f":" K$257 * $F238","v":4.197356835483542},4.197356835483542,4.197356835483542,4.1973568354835411,4.1973568354835411,0]
[null,null,null,null,"HDD - Total to be redistributed - Real",null,null,0.45489564100882784,null,0,{"$f":" K$257 * $F239","v":9.0979128201765569E-2},9.0979128201765569E-2,9.0979128201765569E-2,9.0979128201765555E-2,9.0979128201765555E-2,0]
[null,null,null,null,"NES - Total to be redistributed - Real",null,null,11.78510500359587,null,0,2.3570210007191741,2.3570210007191741,2.3570210007191741,2.3570210007191736,2.3570210007191736,0]
[null,null,null,null,"NWT - Total to be redistributed - Real",null,null,29.370061153780984,null,0,5.8740122307561968,5.8740122307561968,5.8740122307561968,5.8740122307561959,5.8740122307561959,0]
[null,null,null,null,"SRN - Total to be redistributed - Real",null,null,13.297786739206252,null,0,2.6595573478412504,2.6595573478412504,2.6595573478412504,2.65955734784125,2.65955734784125,0]
[null,null,null,null,"SVE - Total to be redistributed - Real",null,null,28.382107404963811,null,0,5.6764214809927624,5.6764214809927624,5.6764214809927624,5.6764214809927616,5.6764214809927616,0]
[null,null,null,null,"SWB - Total to be redistributed - Real",null,null,8.8206411500853896,null,0,1.7641282300170782,1.7641282300170782,1.7641282300170782,1.764128230017078,1.764128230017078,0]
[null,null,null,null,"TMS - Total to be redistributed - Real",null,null,34.32930907435577,null,0,6.8658618148711543,6.8658618148711543,6.8658618148711543,6.8658618148711534,6.8658618148711534,0]
[null,null,null,null,"WSH - Total to be redistributed - Real",null,null,12.357734690289989,null,0,2.471546938057998,2.471546938057998,2.471546938057998,2.4715469380579975,2.4715469380579975,0]
[null,null,null,null,"WSX - Total to be redistributed - Real",null,null,8.2604592079724988,null,0,1.6520918415944996,1.6520918415944996,1.6520918415944996,1.6520918415944994,1.6520918415944994,0]
[null,null,null,null,"YKY - Total to be redistributed - Real",null,null,17.59261305721526,null,0,3.5185226114430526,3.5185226114430526,3.5185226114430526,3.5185226114430517,3.5185226114430517,0]
[null,null,null,null,"AFW - Total to be redistributed - Real",null,null,4.8432347733847152,null,0,{"$f":" K$257 * $F249","v":0.96864695467694317},{"$f":" L$257 * $F249","v":0.96864695467694317},{"$f":" M$257 * $F249","v":0.96864695467694317},0.96864695467694295,0.96864695467694295,0]
[null,null,null,null,"BRL - Total to be redistributed - Real",null,null,1.8912269294760478,null,0,0.37824538589520956,0.37824538589520956,0.37824538589520956,0.37824538589520951,0.37824538589520951,0]
[null,null,null,null,"PRT - Total to be redistributed - Real",null,null,0.64951234319729489,null,0,0.12990246863945898,{"$f":" L$257 * $F251","v":0.12990246863945898},0.12990246863945898,0.12990246863945895,0.12990246863945895,0]
[null,null,null,null,"SES - Total to be redistributed - Real",null,null,0.98405403889178311,null,0,0.19681080777835663,{"$f":" L$257 * $F252","v":0.19681080777835663},0.19681080777835663,0.19681080777835661,0.19681080777835661,0]
[null,null,null,null,"SEW - Total to be redistributed - Real",null,null,3.951513618490945,null,0,0.79030272369818899,{"$f":" L$257 * $F253","v":0.79030272369818899},0.79030272369818899,0.79030272369818877,0.79030272369818877,0]
[null,null,null,null,"SSC - Total to be redistributed - Real",null,null,2.0429609966668241,null,0,0.40859219933336488,{"$f":" L$257 * $F254","v":0.40859219933336488},0.40859219933336488,0.40859219933336477,0.40859219933336477,0]
[null,null,null,null,"Total to be redistributed - Real",null,null,199.99999999999994,null,{"$f":" SUM(J260:J276)","v":0},{"$f":" SUM(K260:K276)","v":39.999999999999993},{"$f":" SUM(L260:L276)","v":39.999999999999993},39.999999999999993,39.999999999999986,39.999999999999986,0]
[]
[null,null,null,"Negative funding check"]
[null,null,null,null,"ANH - Negative funding check",{"$f":" IF(SUM(J260:P260) < 0, 1, 0)","v":0}]
[null,null,null,null,"HDD - Negative funding check",{"$f":" IF(SUM(J261:P261) < 0, 1, 0)","v":0}]
[null,null,null,null,"NES - Negative funding check",0]
[null,null,null,null,"NWT - Negative funding check",0]
[null,null,null,null,"SRN - Negative funding check",0]
[null,null,null,null,"SVE - Negative funding check",0]
[null,null,null,null,"SWB - Negative funding check",0]
[null,null,null,null,"TMS - Negative funding check",0]
[null,null,null,null,"WSH - Negative funding check",0]
[null,null,null,null,"WSX - Negative funding check",0]
[null,null,null,null,"YKY - Negative funding check",0]
[null,null,null,null,"AFW - Negative funding check",0]
[null,null,null,null,"BRL - Negative funding check",0]
[null,null,null,null,"PRT - Negative funding check",0]
[null,null,null,null,"SES - Negative funding check",{"$f":" IF(SUM(J274:P274) < 0, 1, 0)","v":0}]
[null,null,null,null,"SEW - Negative funding check",{"$f":" IF(SUM(J275:P275) < 0, 1, 0)","v":0}]
[null,null,null,null,"SSC - Negative funding check",0]
[null,null,null,null,"Negative funding check",{"$f":" SUM(F280:F296)","v":0},"check"]
[]
[null,null,null,"Time value of money adjustments"]
[]
[null,null,null,null,{"$f":" InpActive!E$154","v":"Financing cost index"},{"$f":" InpActive!F$154","v":0},{"$f":" InpActive!G$154","v":"Index"},{"$f":" InpActive!H$154","v":0},{"$f":" InpActive!I$154","v":0},{"$f":" InpActive!J$154","v":0},{"$f":" InpActive!K$154","v":4},{"$f":" InpActive!L$154","v":3},{"$f":" InpActive!M$154","v":2},{"$f":" InpActive!N$154","v":1},{"$f":" InpActive!O$154","v":0},{"$f":" InpActive!P$154","v":0}]
[]
[null,null,null,null,{"$f":" InpActive!E156","v":"ANH - WACC"},{"$f":" InpActive!F156","v":0},{"$f":" InpActive!G156","v":"%"}]
[null,null,null,null,{"$f":" InpActive!E157","v":"HDD - WACC"},{"$f":" InpActive!F157","v":0},{"$f":" InpActive!G157","v":"%"}]
[null,null,null,null,{"$f":" InpActive!E158","v":"NES - WACC"},{"$f":" InpActive!F158","v":0},{"$f":" InpActive!G158","v":"%"}]
[null,null,null,null,{"$f":" InpActive!E159","v":"NWT - WACC"},{"$f":" InpActive!F159","v":0},{"$f":" InpActive!G159","v":"%"}]
[null,null,null,null,{"$f":" InpActive!E160","v":"SRN - WACC"},{"$f":" InpActive!F160","v":0},{"$f":" InpActive!G160","v":"%"}]
[null,null,null,null,{"$f":" InpActive!E161","v":"SVE - WACC"},{"$f":" InpActive!F161","v":0},{"$f":" InpActive!G161","v":"%"}]
[null,null,null,null,{"$f":" InpActive!E162","v":"SWB - WACC"},{"$f":" InpActive!F162","v":0},{"$f":" InpActive!G162","v":"%"}]
[null,null,null,null,{"$f":" InpActive!E163","v":"TMS - WACC"},{"$f":" InpActive!F163","v":0},{"$f":" InpActive!G163","v":"%"}]
[null,null,null,null,{"$f":" InpActive!E164","v":"WSH - WACC"},{"$f":" InpActive!F164","v":0},{"$f":" InpActive!G164","v":"%"}]
[null,null,null,null,{"$f":" InpActive!E165","v":"WSX - WACC"},{"$f":" InpActive!F165","v":0},{"$f":" InpActive!G165","v":"%"}]
[null,null,null,null,{"$f":" InpActive!E166","v":"YKY - WACC"},{"$f":" InpActive!F166","v":0},{"$f":" InpActive!G166","v":"%"}]
[null,null,null,null,{"$f":" InpActive!E167","v":"AFW - WACC"},{"$f":" InpActive!F167","v":0},{"$f":" InpActive!G167","v":"%"}]
[null,null,null,null,{"$f":" InpActive!E168","v":"BRL - WACC"},{"$f":" InpActive!F168","v":0},{"$f":" InpActive!G168","v":"%"}]
[null,null,null,null,{"$f":" InpActive!E169","v":"PRT - WACC"},{"$f":" InpActive!F169","v":3.1099999999999999E-2},{"$f":" InpActive!G169","v":"%"}]
[null,null,null,null,{"$f":" InpActive!E170","v":"SES - WACC"},{"$f":" InpActive!F170","v":0},{"$f":" InpActive!G170","v":"%"}]
[null,null,null,null,{"$f":" InpActive!E171","v":"SEW - WACC"},{"$f":" InpActive!F171","v":0},{"$f":" InpActive!G171","v":"%"}]
[null,null,null,null,{"$f":" InpActive!E172","v":"SSC - WACC"},{"$f":" InpActive!F172","v":0},{"$f":" InpActive!G172","v":"%"}]
[]
[null,null,null,null,"ANH - Time value of money factor",null,"Factor",null,null,{"$f":"(1+$F303) ^ J$301","v":1},{"$f":"(1+$F303) ^ K$301","v":1},1,1,1,1,1]
[null,null,null,null,"HDD - Time value of money factor",null,"Factor",null,null,{"$f":"(1+$F304) ^ J$301","v":1},1,1,1,1,1,1]
[null,null,null,null,"NES - Time value of money factor",null,"Factor",null,null,{"$f":"(1+$F305) ^ J$301","v":1},1,1,1,1,1,1]
[null,null,null,null,"NWT - Time value of money factor",null,"Factor",null,null,{"$f":"(1+$F306) ^ J$301","v":1},1,1,1,1,1,1]
[null,null,null,null,"SRN - Time value of money factor",null,"Factor",null,null,{"$f":"(1+$F307) ^ J$301","v":1},1,1,1,1,1,1]
[null,null,null,null,"SVE - Time value of money factor",null,"Factor",null,null,{"$f":"(1+$F308) ^ J$301","v":1},1,1,1,1,1,1]
[null,null,null,null,"SWB - Time value of money factor",null,"Factor",null,null,{"$f":"(1+$F309) ^ J$301","v":1},1,1,1,1,1,1]
[null,null,null,null,"TMS - Time value of money factor",null,"Factor",null,null,{"$f":"(1+$F310) ^ J$301","v":1},1,1,1,1,1,1]
[null,null,null,null,"WSH - Time value of money factor",null,"Factor",null,null,{"$f":"(1+$F311) ^ J$301","v":1},1,1,1,1,1,1]
[null,null,null,null,"WSX - Time value of money factor",null,"Factor",null,null,{"$f":"(1+$F312) ^ J$301","v":1},1,1,1,1,1,1]
[null,null,null,null,"YKY - Time value of money factor",null,"Factor",null,null,{"$f":"(1+$F313) ^ J$301","v":1},1,1,1,1,1,1]
[null,null,null,null,"AFW - Time value of money factor",null,"Factor",null,null,{"$f":"(1+$F314) ^ J$301","v":1},1,1,1,1,1,1]
[null,null,null,null,"BRL - Time value of money factor",null,"Factor",null,null,{"$f":"(1+$F315) ^ J$301","v":1},1,1,1,1,1,1]
[null,null,null,null,"PRT - Time value of money factor",null,"Factor",null,null,{"$f":"(1+$F316) ^ J$301","v":1},1.1303245164191837,1.0962317102309997,1.0631672099999998,1.0310999999999999,1,1]
[null,null,null,null,"SES - Time value of money factor",null,"Factor",null,null,{"$f":"(1+$F317) ^ J$301","v":1},1,1,1,1,1,1]
[null,null,null,null,"SEW - Time value of money factor",null,"Factor",null,null,{"$f":"(1+$F318) ^ J$301","v":1},1,1,1,1,1,1]
[null,null,null,null,"SSC - Time value of money factor",null,"Factor",null,null,{"$f":"(1+$F319) ^ J$301","v":1},1,1,1,1,1,1]
[]
[null,null,null,"Total to be redistributed’ "]
[null,null,null,null,{"$f":"E260","v":"ANH - Total to be redistributed - Real"},0,0,20.986784177417704,0,0,4.197356835483542,4.197356835483542,4.197356835483542,4.1973568354835411,4.1973568354835411,0]
[null,null,null,null,{"$f":"E261","v":"HDD - Total to be redistributed - Real"},0,0,0.45489564100882784,0,0,9.0979128201765569E-2,9.0979128201765569E-2,9.0979128201765569E-2,9.0979128201765555E-2,9.0979128201765555E-2,0]
[null,null,null,null,{"$f":"E262","v":"NES - Total to be redistributed - Real"},0,0,11.78510500359587,0,0,2.3570210007191741,2.3570210007191741,2.3570210007191741,2.3570210007191736,2.3570210007191736,0]
[null,null,null,null,{"$f":"E263","v":"NWT - Total to be redistributed - Real"},0,0,29.370061153780984,0,0,5.8740122307561968,5.8740122307561968,5.8740122307561968,5.8740122307561959,5.8740122307561959,0]
[null,null,null,null,{"$f":"E264","v":"SRN - Total to be redistributed - Real"},0,0,13.297786739206252,0,0,2.6595573478412504,2.6595573478412504,2.6595573478412504,2.65955734784125,2.65955734784125,0]
[null,null,null,null,{"$f":"E265","v":"SVE - Total to be redistributed - Real"},0,0,28.382107404963811,0,0,5.6764214809927624,5.6764214809927624,5.6764214809927624,5.6764214809927616,5.6764214809927616,0]
[null,null,null,null,{"$f":"E266","v":"SWB - Total to be redistributed - Real"},0,0,8.8206411500853896,0,0,1.7641282300170782,1.7641282300170782,1.7641282300170782,1.764128230017078,1.764128230017078,0]
[null,null,null,null,{"$f":"E267","v":"TMS - Total to be redistributed - Real"},0,0,34.32930907435577,0,0,6.8658618148711543,6.8658618148711543,6.8658618148711543,6.8658618148711534,6.8658618148711534,0]
[null,null,null,null,{"$f":"E268","v":"WSH - Total to be redistributed - Real"},0,0,12.357734690289989,0,0,2.471546938057998,2.471546938057998,2.471546938057998,2.4715469380579975,2.4715469380579975,0]
[null,null,null,null,{"$f":"E269","v":"WSX - Total to be redistributed - Real"},0,0,8.2604592079724988,0,0,1.6520918415944996,1.6520918415944996,1.6520918415944996,1.6520918415944994,1.6520918415944994,0]
[null,null,null,null,{"$f":"E270","v":"YKY - Total to be redistributed - Real"},0,0,17.59261305721526,0,0,3.5185226114430526,3.5185226114430526,3.5185226114430526,3.5185226114430517,3.5185226114430517,0]
[null,null,null,null,{"$f":"E271","v":"AFW - Total to be redistributed - Real"},0,0,4.8432347733847152,0,0,0.96864695467694317,0.96864695467694317,0.96864695467694317,0.96864695467694295,0.96864695467694295,0]
[null,null,null,null,{"$f":"E272","v":"BRL - Total to be redistributed - Real"},0,0,1.8912269294760478,0,0,0.37824538589520956,0.37824538589520956,0.37824538589520956,0.37824538589520951,0.37824538589520951,0]
[null,null,null,null,{"$f":"E273","v":"PRT - Total to be redistributed - Real"},0,0,0.64951234319729489,0,0,0.12990246863945898,0.12990246863945898,0.12990246863945898,0.12990246863945895,0.12990246863945895,0]
[null,null,null,null,{"$f":"E274","v":"SES - Total to be redistributed - Real"},0,0,0.98405403889178311,0,0,0.19681080777835663,0.19681080777835663,0.19681080777835663,0.19681080777835661,0.19681080777835661,0]
[null,null,null,null,{"$f":"E275","v":"SEW - Total to be redistributed - Real"},0,0,3.951513618490945,0,0,0.79030272369818899,0.79030272369818899,0.79030272369818899,0.79030272369818877,0.79030272369818877,0]
[null,null,null,null,{"$f":"E276","v":"SSC - Total to be redistributed - Real"},0,0,2.0429609966668241,0,0,0.40859219933336488,0.40859219933336488,0.40859219933336488,0.40859219933336477,0.40859219933336477,0]
[null,null,null,null,{"$f":"E277","v":"Total to be redistributed - Real"},0,0,199.99999999999994,0,0,39.999999999999993,39.999999999999993,39.999999999999993,39.999999999999986,39.999999999999986,0]
[]
[null,null,null,null,{"$f":"E321","v":"ANH - Time value of money factor"},0,"Factor",0,0,1,1,1,1,1,1,1]
[null,null,null,null,{"$f":"E322","v":"HDD - Time value of money factor"},0,"Factor",0,0,1,1,1,1,1,1,1]
[null,null,null,null,{"$f":"E323","v":"NES - Time value of money factor"},0,"Factor",0,0,1,1,1,1,1,1,1]
[null,null,null,null,{"$f":"E324","v":"NWT - Time value of money factor"},0,"Factor",0,0,1,1,1,1,1,1,1]
[null,null,null,null,{"$f":"E325","v":"SRN - Time value of money factor"},0,"Factor",0,0,1,1,1,1,1,1,1]
[null,null,null,null,{"$f":"E326","v":"SVE - Time value of money factor"},0,"Factor",0,0,1,1,1,1,1,1,1]
[null,null,null,null,{"$f":"E327","v":"SWB - Time value of money factor"},0,"Factor",0,0,1,1,1,1,1,1,1]
[null,null,null,null,{"$f":"E328","v":"TMS - Time value of money factor"},0,"Factor",0,0,1,1,1,1,1,1,1]
[null,null,null,null,{"$f":"E329","v":"WSH - Time value of money factor"},0,"Factor",0,0,1,1,1,1,1,1,1]
[null,null,null,null,{"$f":"E330","v":"WSX - Time value of money factor"},0,"Factor",0,0,1,1,1,1,1,1,1]
[null,null,null,null,{"$f":"E331","v":"YKY - Time value of money factor"},0,"Factor",0,0,1,1,1,1,1,1,1]
[null,null,null,null,{"$f":"E332","v":"AFW - Time value of money factor"},0,"Factor",0,0,1,1,1,1,1,1,1]
[null,null,null,null,{"$f":"E333","v":"BRL - Time value of money factor"},0,"Factor",0,0,1,1,1,1,1,1,1]
[null,null,null,null,{"$f":"E334","v":"PRT - Time value of money factor"},0,"Factor",0,0,1,1.1303245164191837,1.0962317102309997,1.0631672099999998,1.0310999999999999,1,1]
[null,null,null,null,{"$f":"E335","v":"SES - Time value of money factor"},0,"Factor",0,0,1,1,1,1,1,1,1]
[null,null,null,null,{"$f":"E336","v":"SEW - Time value of money factor"},0,"Factor",0,0,1,1,1,1,1,1,1]
[null,null,null,null,{"$f":"E337","v":"SSC - Time value of money factor"},0,"Factor",0,0,1,1,1,1,1,1,1]
[]
[null,null,null,null,"ANH - Total to be redistributed - Real",null,"£m",{"$f":" SUM(J377:P377)","v":20.986784177417704},null,{"$f":" J340 * J359","v":0},{"$f":" K340 * K359","v":4.197356835483542},4.197356835483542,4.197356835483542,4.1973568354835411,4.1973568354835411,0]
[null,null,null,null,"HDD - Total to be redistributed - Real",null,"£m",{"$f":" SUM(J378:P378)","v":0.45489564100882784},null,{"$f":" J341 * J360","v":0},9.0979128201765569E-2,9.0979128201765569E-2,9.0979128201765569E-2,9.0979128201765555E-2,9.0979128201765555E-2,0]
[null,null,null,null,"NES - Total to be redistributed - Real",null,"£m",11.78510500359587,null,{"$f":" J342 * J361","v":0},2.3570210007191741,2.3570210007191741,2.3570210007191741,2.3570210007191736,2.3570210007191736,0]
[null,null,null,null,"NWT - Total to be redistributed - Real",null,"£m",29.370061153780984,null,{"$f":" J343 * J362","v":0},5.8740122307561968,5.8740122307561968,5.8740122307561968,5.8740122307561959,5.8740122307561959,0]
[null,null,null,null,"SRN - Total to be redistributed - Real",null,"£m",13.297786739206252,null,{"$f":" J344 * J363","v":0},2.6595573478412504,2.6595573478412504,2.6595573478412504,2.65955734784125,2.65955734784125,0]
[null,null,null,null,"SVE - Total to be redistributed - Real",null,"£m",28.382107404963811,null,{"$f":" J345 * J364","v":0},5.6764214809927624,5.6764214809927624,5.6764214809927624,5.6764214809927616,5.6764214809927616,0]
[null,null,null,null,"SWB - Total to be redistributed - Real",null,"£m",8.8206411500853896,null,{"$f":" J346 * J365","v":0},1.7641282300170782,1.7641282300170782,1.7641282300170782,1.764128230017078,1.764128230017078,0]
[null,null,null,null,"TMS - Total to be redistributed - Real",null,"£m",34.32930907435577,null,{"$f":" J347 * J366","v":0},6.8658618148711543,6.8658618148711543,6.8658618148711543,6.8658618148711534,6.8658618148711534,0]
[null,null,null,null,"WSH - Total to be redistributed - Real",null,"£m",12.357734690289989,null,{"$f":" J348 * J367","v":0},2.471546938057998,2.471546938057998,2.471546938057998,2.4715469380579975,2.4715469380579975,0]
[null,null,null,null,"WSX - Total to be redistributed - Real",null,"£m",8.2604592079724988,null,{"$f":" J349 * J368","v":0},1.6520918415944996,1.6520918415944996,1.6520918415944996,1.6520918415944994,1.6520918415944994,0]
[null,null,null,null,"YKY - Total to be redistributed - Real",null,"£m",17.59261305721526,null,{"$f":" J350 * J369","v":0},3.5185226114430526,3.5185226114430526,3.5185226114430526,3.5185226114430517,3.5185226114430517,0]
[null,null,null,null,"AFW - Total to be redistributed - Real",null,"£m",4.8432347733847152,null,{"$f":" J351 * J370","v":0},0.96864695467694317,0.96864695467694317,0.96864695467694317,0.96864695467694295,0.96864695467694295,0]
[null,null,null,null,"BRL - Total to be redistributed - Real",null,"£m",1.8912269294760478,null,{"$f":" J352 * J371","v":0},0.37824538589520956,0.37824538589520956,0.37824538589520956,0.37824538589520951,0.37824538589520951,0]
[null,null,null,null,"PRT - Total to be redistributed - Real",null,"£m",0.69118809961554872,null,{"$f":" J353 * J372","v":0},0.14683194504655464,0.14240320535986292,0.13810804515552608,0.1339424354141461,0.12990246863945895,0]
[null,null,null,null,"SES - Total to be redistributed - Real",null,"£m",0.98405403889178311,null,{"$f":" J354 * J373","v":0},0.19681080777835663,0.19681080777835663,0.19681080777835663,0.19681080777835661,0.19681080777835661,0]
[null,null,null,null,"SEW - Total to be redistributed - Real",null,"£m",3.951513618490945,null,{"$f":" J355 * J374","v":0},0.79030272369818899,0.79030272369818899,0.79030272369818899,0.79030272369818877,0.79030272369818877,0]
[null,null,null,null,"SSC - Total to be redistributed - Real",null,"£m",2.0429609966668241,null,{"$f":" J356 * J375","v":0},0.40859219933336488,0.40859219933336488,0.40859219933336488,0.40859219933336477,0.40859219933336477,0]
[null,null,null,null,"Industry - Total to be redistributed - Real",null,"£m",200.04167575641821,null,{"$f":" SUM(J377:J393)","v":0},{"$f":" SUM(K377:K393)","v":40.016929476407093},{"$f":" SUM(L377:L393)","v":40.012500736720398},{"$f":" SUM(M377:M393)","v":40.008205576516062},{"$f":" SUM(N377:N393)","v":40.004039966774677},{"$f":" SUM(O377:O393)","v":39.999999999999986},{"$f":" SUM(P377:P393)","v":0}]
[]
["END OF SHEET"]

{"sheet":"Outputs-->","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Outputs","index":11,"n_rows":30,"n_cols":16,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Outputs"}]
[null,null,null,null,{"$f":"Time!E$22","v":"Model Period BEG"},null,null,null,null,{"$f":"Time!J$22","v":"2019-04-01"},{"$f":"Time!K$22","v":"2020-04-01"},{"$f":"Time!L$22","v":"2021-04-01"},{"$f":"Time!M$22","v":"2022-04-01"},{"$f":"Time!N$22","v":"2023-04-01"},{"$f":"Time!O$22","v":"2024-04-01"},{"$f":"Time!P$22","v":"2025-04-01"}]
[null,null,null,null,{"$f":"Time!E$23","v":"Model Period END"},{"$f":"Check!F$8","v":0},"Error chks",null,null,{"$f":"Time!J$23","v":"2020-03-31"},{"$f":"Time!K$23","v":"2021-03-31"},{"$f":"Time!L$23","v":"2022-03-31"},{"$f":"Time!M$23","v":"2023-03-31"},{"$f":"Time!N$23","v":"2024-03-31"},{"$f":"Time!O$23","v":"2025-03-31"},{"$f":"Time!P$23","v":"2026-03-31"}]
[null,null,null,null,{"$f":"Time!E$59","v":"Pre Forecast vs Forecast"},null,null,null,null,{"$f":"Time!J$59","v":"Pre Fcst"},{"$f":"Time!K$59","v":"Forecast"},{"$f":"Time!L$59","v":"Forecast"},{"$f":"Time!M$59","v":"Forecast"},{"$f":"Time!N$59","v":"Forecast"},{"$f":"Time!O$59","v":"Forecast"},{"$f":"Time!P$59","v":"Post-Fcst"}]
[null,null,null,null,{"$f":"Time!E$101","v":"Financial Year Ending"},null,null,null,null,{"$f":"Time!J$101","v":2020},{"$f":"Time!K$101","v":2021},{"$f":"Time!L$101","v":2022},{"$f":"Time!M$101","v":2023},{"$f":"Time!N$101","v":2024},{"$f":"Time!O$101","v":2025},{"$f":"Time!P$101","v":2026}]
[null,null,null,null,{"$f":"Time!E$11","v":"Model column counter"},"Constant","Unit","Total",null,{"$f":"Time!J$11","v":1},{"$f":"Time!K$11","v":2},{"$f":"Time!L$11","v":3},{"$f":"Time!M$11","v":4},{"$f":"Time!N$11","v":5},{"$f":"Time!O$11","v":6},{"$f":"Time!P$11","v":7}]
[]
[]
[]
[null,null,null,null,{"$f":"'Innovation funding return'!E377","v":"ANH - Total to be redistributed - Real"},{"$f":"'Innovation funding return'!H377","v":20.986784177417704},{"$f":"'Innovation funding return'!G377","v":"£m"}]
[null,null,null,null,{"$f":"'Innovation funding return'!E378","v":"HDD - Total to be redistributed - Real"},{"$f":"'Innovation funding return'!H378","v":0.45489564100882784},{"$f":"'Innovation funding return'!G378","v":"£m"}]
[null,null,null,null,{"$f":"'Innovation funding return'!E379","v":"NES - Total to be redistributed - Real"},{"$f":"'Innovation funding return'!H379","v":11.78510500359587},{"$f":"'Innovation funding return'!G379","v":"£m"}]
[null,null,null,null,{"$f":"'Innovation funding return'!E380","v":"NWT - Total to be redistributed - Real"},{"$f":"'Innovation funding return'!H380","v":29.370061153780984},{"$f":"'Innovation funding return'!G380","v":"£m"}]
[null,null,null,null,{"$f":"'Innovation funding return'!E381","v":"SRN - Total to be redistributed - Real"},{"$f":"'Innovation funding return'!H381","v":13.297786739206252},{"$f":"'Innovation funding return'!G381","v":"£m"}]
[null,null,null,null,{"$f":"'Innovation funding return'!E382","v":"SVE - Total to be redistributed - Real"},{"$f":"'Innovation funding return'!H382","v":28.382107404963811},{"$f":"'Innovation funding return'!G382","v":"£m"}]
[null,null,null,null,{"$f":"'Innovation funding return'!E383","v":"SWB - Total to be redistributed - Real"},{"$f":"'Innovation funding return'!H383","v":8.8206411500853896},{"$f":"'Innovation funding return'!G383","v":"£m"}]
[null,null,null,null,{"$f":"'Innovation funding return'!E384","v":"TMS - Total to be redistributed - Real"},{"$f":"'Innovation funding return'!H384","v":34.32930907435577},{"$f":"'Innovation funding return'!G384","v":"£m"}]
[null,null,null,null,{"$f":"'Innovation funding return'!E385","v":"WSH - Total to be redistributed - Real"},{"$f":"'Innovation funding return'!H385","v":12.357734690289989},{"$f":"'Innovation funding return'!G385","v":"£m"}]
[null,null,null,null,{"$f":"'Innovation funding return'!E386","v":"WSX - Total to be redistributed - Real"},{"$f":"'Innovation funding return'!H386","v":8.2604592079724988},{"$f":"'Innovation funding return'!G386","v":"£m"}]
[null,null,null,null,{"$f":"'Innovation funding return'!E387","v":"YKY - Total to be redistributed - Real"},{"$f":"'Innovation funding return'!H387","v":17.59261305721526},{"$f":"'Innovation funding return'!G387","v":"£m"}]
[null,null,null,null,{"$f":"'Innovation funding return'!E388","v":"AFW - Total to be redistributed - Real"},{"$f":"'Innovation funding return'!H388","v":4.8432347733847152},{"$f":"'Innovation funding return'!G388","v":"£m"}]
[null,null,null,null,{"$f":"'Innovation funding return'!E389","v":"BRL - Total to be redistributed - Real"},{"$f":"'Innovation funding return'!H389","v":1.8912269294760478},{"$f":"'Innovation funding return'!G389","v":"£m"}]
[null,null,null,null,{"$f":"'Innovation funding return'!E390","v":"PRT - Total to be redistributed - Real"},{"$f":"'Innovation funding return'!H390","v":0.69118809961554872},{"$f":"'Innovation funding return'!G390","v":"£m"}]
[null,null,null,null,{"$f":"'Innovation funding return'!E391","v":"SES - Total to be redistributed - Real"},{"$f":"'Innovation funding return'!H391","v":0.98405403889178311},{"$f":"'Innovation funding return'!G391","v":"£m"}]
[null,null,null,null,{"$f":"'Innovation funding return'!E392","v":"SEW - Total to be redistributed - Real"},{"$f":"'Innovation funding return'!H392","v":3.951513618490945},{"$f":"'Innovation funding return'!G392","v":"£m"}]
[null,null,null,null,{"$f":"'Innovation funding return'!E393","v":"SSC - Total to be redistributed - Real"},{"$f":"'Innovation funding return'!H393","v":2.0429609966668241},{"$f":"'Innovation funding return'!G393","v":"£m"}]
[]
[null,null,null,null,{"$f":"'Innovation funding return'!E394","v":"Industry - Total to be redistributed - Real"},{"$f":"'Innovation funding return'!H394","v":200.04167575641821},{"$f":"'Innovation funding return'!G394","v":"£m"}]
[]
["END OF SHEET"]

{"sheet":"Integrity checks-->","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Check","index":13,"n_rows":18,"n_cols":16,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Check"}]
[null,null,null,null,{"$f":"Time!E$22","v":"Model Period BEG"},null,null,null,null,{"$f":"Time!J$22","v":"2019-04-01"},{"$f":"Time!K$22","v":"2020-04-01"},{"$f":"Time!L$22","v":"2021-04-01"},{"$f":"Time!M$22","v":"2022-04-01"},{"$f":"Time!N$22","v":"2023-04-01"},{"$f":"Time!O$22","v":"2024-04-01"},{"$f":"Time!P$22","v":"2025-04-01"}]
[null,null,null,null,{"$f":"Time!E$23","v":"Model Period END"},{"$f":"Check!F$8","v":0},"Error chks",null,null,{"$f":"Time!J$23","v":"2020-03-31"},{"$f":"Time!K$23","v":"2021-03-31"},{"$f":"Time!L$23","v":"2022-03-31"},{"$f":"Time!M$23","v":"2023-03-31"},{"$f":"Time!N$23","v":"2024-03-31"},{"$f":"Time!O$23","v":"2025-03-31"},{"$f":"Time!P$23","v":"2026-03-31"}]
[null,null,null,null,{"$f":"Time!E$59","v":"Pre Forecast vs Forecast"},null,null,null,null,{"$f":"Time!J$59","v":"Pre Fcst"},{"$f":"Time!K$59","v":"Forecast"},{"$f":"Time!L$59","v":"Forecast"},{"$f":"Time!M$59","v":"Forecast"},{"$f":"Time!N$59","v":"Forecast"},{"$f":"Time!O$59","v":"Forecast"},{"$f":"Time!P$59","v":"Post-Fcst"}]
[null,null,null,null,{"$f":"Time!E$101","v":"Financial Year Ending"},null,null,null,null,{"$f":"Time!J$101","v":2020},{"$f":"Time!K$101","v":2021},{"$f":"Time!L$101","v":2022},{"$f":"Time!M$101","v":2023},{"$f":"Time!N$101","v":2024},{"$f":"Time!O$101","v":2025},{"$f":"Time!P$101","v":2026}]
[null,null,null,null,{"$f":"Time!E$11","v":"Model column counter"},"Constant","Unit","Total",null,{"$f":"Time!J$11","v":1},{"$f":"Time!K$11","v":2},{"$f":"Time!L$11","v":3},{"$f":"Time!M$11","v":4},{"$f":"Time!N$11","v":5},{"$f":"Time!O$11","v":6},{"$f":"Time!P$11","v":7}]
[]
[null,null,null,null,"Total error checks",{"$f":" SUM(F10:F16)","v":0},"check"]
[]
["[Do not delete]"]
[]
[null,null,null,null,{"$f":"'Innovation funding return'!E297","v":"Negative funding check"},{"$f":"'Innovation funding return'!F297","v":0},{"$f":"'Innovation funding return'!G297","v":"check"}]
[null,null,null,null,{"$f":"'Innovation funding return'!E90","v":"Allocated funding proportion check"},{"$f":"'Innovation funding return'!F90","v":0},{"$f":"'Innovation funding return'!G90","v":"check"}]
[null,null,null,null,{"$f":"InpActive!E89","v":"Total awarded check"},{"$f":"InpActive!F89","v":0},{"$f":"InpActive!G89","v":"check"}]
[]
["[Do not delete]"]
[]
["END OF SHEET"]