{"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":62,"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":33,"n_cols":2,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Cover"}]
[]
["Workbook title:","PR19 Innovation Funding reconciliation mode"]
["Version:","v1e"]
["Filename:","PR19 Innovation Funding reconciliation model 1e"]
["Date:","2019-02-27"]
["Author:","Ofwat"]
["Author contact information:","PR19Reconciliationrulebook@ofwat.gov.uk"]
[]
[]
["Summary of workbook:","The model is a whole of industry model with inputs and outputs for all companies housed within one model. "]
[null,"The model calculates the total amount of unused funds to be redistributed to individual companies’ customers. "]
[null,"This is done in line with the original allocation methodology set out in PR19 Final Determinations."]
[null,"Inputs and calculations are in outturn prices before being converted into real terms 2017-18 CPIH FYA. A time value of"]
[null,"money adjustment is also made discounted to 2024-25 prices."]
[]
["Known limitations:","n/a"]
[]
["Instructions:","Inputs are added at industry level on InpOverride. "]
[null,"Calculations are completed on the sheet 'Innovation funding return' to calculated any unused and uncommitted funding. "]
[null,"Unused funding is redistributed as per the original proportions ."]
[]
["Amendments:","n/a"]
[]
["References:","APR Table 9a"]
[]
["Error Checks:",{"$f":"Check!B$8","v":0}]
[]
["Feedback:","We would welcome feedback on this workbook. Please send any feedback to the following email address:"]
[null,"PR19Reconciliationrulebook@ofwat.gov.uk"]
[]
[]
["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!A1","v":"Cover"},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":183,"n_cols":16,"rows_kept":183,"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 - Nominal",null,"£m",{"$f":" SUM(K28:O28)","v":0}]
[null,null,null,null,"HDD - Allocated innovation funding - Nominal",null,"£m",{"$f":" SUM(K29:O29)","v":0}]
[null,null,null,null,"NES - Allocated innovation funding - Nominal",null,"£m",0]
[null,null,null,null,"NWT - Allocated innovation funding - Nominal",null,"£m",0]
[null,null,null,null,"SRN - Allocated innovation funding - Nominal",null,"£m",0]
[null,null,null,null,"SVE - Allocated innovation funding - Nominal",null,"£m",0]
[null,null,null,null,"SWB - Allocated innovation funding - Nominal",null,"£m",0]
[null,null,null,null,"TMS - Allocated innovation funding - Nominal",null,"£m",0]
[null,null,null,null,"WSH - Allocated innovation funding - Nominal",null,"£m",0]
[null,null,null,null,"WSX - Allocated innovation funding - Nominal",null,"£m",0]
[null,null,null,null,"YKY - Allocated innovation funding - Nominal",null,"£m",0]
[null,null,null,null,"AFW - Allocated innovation funding - Nominal",null,"£m",0]
[null,null,null,null,"BRL - Allocated innovation funding - Nominal",null,"£m",0]
[null,null,null,null,"PRT - Allocated innovation funding - Nominal",null,"£m",0]
[null,null,null,null,"SES - Allocated innovation funding - Nominal",null,"£m",0]
[null,null,null,null,"SEW - Allocated innovation funding - Nominal",null,"£m",0]
[null,null,null,null,"SSC - Allocated innovation funding - Nominal",null,"£m",0]
[]
[null,null,null,"Total Funding transferred to innovation fund"]
[null,null,null,null,"ANH - Total Funding transferred to innovation fund - Nominal",null,"£m",{"$f":" SUM(K47:O47)","v":0}]
[null,null,null,null,"HDD - Total Funding transferred to innovation fund - Nominal",null,"£m",{"$f":" SUM(K48:O48)","v":0}]
[null,null,null,null,"NES - Total Funding transferred to innovation fund - Nominal",null,"£m",0]
[null,null,null,null,"NWT - Total Funding transferred to innovation fund - Nominal",null,"£m",0]
[null,null,null,null,"SRN - Total Funding transferred to innovation fund - Nominal",null,"£m",0]
[null,null,null,null,"SVE - Total Funding transferred to innovation fund - Nominal",null,"£m",0]
[null,null,null,null,"SWB - Total Funding transferred to innovation fund - Nominal",null,"£m",0]
[null,null,null,null,"TMS - Total Funding transferred to innovation fund - Nominal",null,"£m",0]
[null,null,null,null,"WSH - Total Funding transferred to innovation fund - Nominal",null,"£m",0]
[null,null,null,null,"WSX - Total Funding transferred to innovation fund - Nominal",null,"£m",0]
[null,null,null,null,"YKY - Total Funding transferred to innovation fund - Nominal",null,"£m",0]
[null,null,null,null,"AFW - Total Funding transferred to innovation fund - Nominal",null,"£m",0]
[null,null,null,null,"BRL - Total Funding transferred to innovation fund - Nominal",null,"£m",0]
[null,null,null,null,"PRT - Total Funding transferred to innovation fund - Nominal",null,"£m",0]
[null,null,null,null,"SES - Total Funding transferred to innovation fund - Nominal",null,"£m",0]
[null,null,null,null,"SEW - Total Funding transferred to innovation fund - Nominal",null,"£m",0]
[null,null,null,null,"SSC - Total Funding transferred to innovation fund - Nominal",null,"£m",0]
[]
[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(K66:O66)","v":0}]
[null,null,null,null,"HDD - Bids Accepted & Funding Awarded - Nominal",null,"£m",{"$f":" SUM(K67:O67)","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,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,"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(K85:O85)","v":0}]
[null,null,null,null,"HDD - Expenditure on innovation spend to date - Nominal",null,"£m",{"$f":" SUM(K86:O86)","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,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,"Allowed future expenditure on innovation projects"]
[null,null,null,null,"ANH - Allowed Future expenditure on innovation projects - Nominal",null,"£m",{"$f":" SUM(K104:O104)","v":0}]
[null,null,null,null,"HDD - Allowed Future expenditure on innovation projects - Nominal",null,"£m",{"$f":" SUM(K105:O105)","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,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]
[]
[]
["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",null,"%"]
[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,109.70335473997172,111.89742183477122,114.1726572294514,116.57028303126997,119.0182589749267,121.39862415442524]
[null,null,null,null,"Consumer price index (including housing costs) - Consumer Price Index (with housing) for May",null,"Index",null,null,107.9,109.88453874941817,112.08222952440661,114.37056169674494,116.77234349237666,119.22456270571664,121.60905395983097]
[null,null,null,null,"Consumer price index (including housing costs) - Consumer Price Index (with housing) for June",null,"Index",null,null,107.9,110.06602199898684,112.26734243896665,114.56880920745294,116.97475420080953,119.4312240390266,121.81984851980714]
[null,null,null,null,"Consumer price index (including housing costs) - Consumer Price Index (with housing) for July",null,"Index",null,null,108,110.24780498289711,112.45276108255513,114.7674003561996,117.17751576367986,119.63824359471722,122.03100846661157]
[null,null,null,null,"Consumer price index (including housing costs) - Consumer Price Index (with housing) for August",null,"Index",null,null,108.3,110.42988819618461,112.63848596010838,114.96633573863983,117.38062878915133,119.8456219937236,122.24253443359807]
[null,null,null,null,"Consumer price index (including housing costs) - Consumer Price Index (with housing) for September",null,"Index",null,null,108.4699996176289,110.61227213470256,112.8245175773967,115.16561595146101,117.58409388644176,120.05335985805712,122.45442705521826]
[null,null,null,null,"Consumer price index (including housing costs) - Consumer Price Index (with housing) for October",null,"Index",null,null,108.64026608539625,110.79495729512315,113.01085644102571,115.36524159238483,117.78791166582499,120.2614578108074,122.66668696702355]
[null,null,null,null,"Consumer price index (including housing costs) - Consumer Price Index (with housing) for November",null,"Index",null,null,108.81079982217945,110.97794417493883,113.1975030584377,115.56521326016906,117.99208273863269,120.46991647614406,122.87931480566695]
[null,null,null,null,"Consumer price index (including housing costs) - Consumer Price Index (with housing) for December",null,"Index",null,null,108.98160124751338,111.1612332724637,113.38445793791308,115.76553155460934,118.19660771725621,120.67873647931867,123.09231120890504]
[null,null,null,null,"Consumer price index (including housing costs) - Consumer Price Index (with housing) for January",null,"Index",null,null,109.1615932223871,111.3448250868349,113.58099615723886,115.96619707654096,118.40148721514839,120.88791844666659,123.30567681559992]
[null,null,null,null,"Consumer price index (including housing costs) - Consumer Price Index (with housing) for February",null,"Index",null,null,109.34188246864102,111.52872011801389,113.7778750517538,116.16721042784071,118.60672184682544,121.09746300560886,123.51941226572104]
[null,null,null,null,"Consumer price index (including housing costs) - Consumer Price Index (with housing) for March",null,"Index",null,null,109.52246947724298,111.7129188667879,113.97509521197706,116.36857221142867,118.81231222786873,121.30737078465407,123.73351820034715]
[]
["NON CHANGEABLE INPUTS"]
[]
[null,"Model Tolerance"]
[null,null,null,null,"Model Check Tolerance Level",1E-4,"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!E149","v":"Consumer price index (including housing costs) - Consumer Price Index (with housing) for April"},{"$f":"InpActive!F149","v":103.2},{"$f":"InpActive!G149","v":"Index"}]
[null,null,null,null,{"$f":"InpActive!E150","v":"Consumer price index (including housing costs) - Consumer Price Index (with housing) for May"},{"$f":"InpActive!F150","v":103.5},{"$f":"InpActive!G150","v":"Index"}]
[null,null,null,null,{"$f":"InpActive!E151","v":"Consumer price index (including housing costs) - Consumer Price Index (with housing) for June"},{"$f":"InpActive!F151","v":103.5},{"$f":"InpActive!G151","v":"Index"}]
[null,null,null,null,{"$f":"InpActive!E152","v":"Consumer price index (including housing costs) - Consumer Price Index (with housing) for July"},{"$f":"InpActive!F152","v":103.5},{"$f":"InpActive!G152","v":"Index"}]
[null,null,null,null,{"$f":"InpActive!E153","v":"Consumer price index (including housing costs) - Consumer Price Index (with housing) for August"},{"$f":"InpActive!F153","v":104},{"$f":"InpActive!G153","v":"Index"}]
[null,null,null,null,{"$f":"InpActive!E154","v":"Consumer price index (including housing costs) - Consumer Price Index (with housing) for September"},{"$f":"InpActive!F154","v":104.3},{"$f":"InpActive!G154","v":"Index"}]
[null,null,null,null,{"$f":"InpActive!E155","v":"Consumer price index (including housing costs) - Consumer Price Index (with housing) for October"},{"$f":"InpActive!F155","v":104.4},{"$f":"InpActive!G155","v":"Index"}]
[null,null,null,null,{"$f":"InpActive!E156","v":"Consumer price index (including housing costs) - Consumer Price Index (with housing) for November"},{"$f":"InpActive!F156","v":104.7},{"$f":"InpActive!G156","v":"Index"}]
[null,null,null,null,{"$f":"InpActive!E157","v":"Consumer price index (including housing costs) - Consumer Price Index (with housing) for December"},{"$f":"InpActive!F157","v":105},{"$f":"InpActive!G157","v":"Index"}]
[null,null,null,null,{"$f":"InpActive!E158","v":"Consumer price index (including housing costs) - Consumer Price Index (with housing) for January"},{"$f":"InpActive!F158","v":104.5},{"$f":"InpActive!G158","v":"Index"}]
[null,null,null,null,{"$f":"InpActive!E159","v":"Consumer price index (including housing costs) - Consumer Price Index (with housing) for February"},{"$f":"InpActive!F159","v":104.9},{"$f":"InpActive!G159","v":"Index"}]
[null,null,null,null,{"$f":"InpActive!E160","v":"Consumer price index (including housing costs) - Consumer Price Index (with housing) for March"},{"$f":"InpActive!F160","v":105.1},{"$f":"InpActive!G160","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!E163","v":"Consumer price index (including housing costs) - Consumer Price Index (with housing) for April"},{"$f":"InpActive!F163","v":0},{"$f":"InpActive!G163","v":"Index"},{"$f":"InpActive!H163","v":0},{"$f":"InpActive!I163","v":0},{"$f":"InpActive!J163","v":107.6},{"$f":"InpActive!K163","v":109.70335473997172},{"$f":"InpActive!L163","v":111.89742183477122},{"$f":"InpActive!M163","v":114.1726572294514},{"$f":"InpActive!N163","v":116.57028303126997},{"$f":"InpActive!O163","v":119.0182589749267},{"$f":"InpActive!P163","v":121.39862415442524}]
[null,null,null,null,{"$f":"InpActive!E164","v":"Consumer price index (including housing costs) - Consumer Price Index (with housing) for May"},{"$f":"InpActive!F164","v":0},{"$f":"InpActive!G164","v":"Index"},{"$f":"InpActive!H164","v":0},{"$f":"InpActive!I164","v":0},{"$f":"InpActive!J164","v":107.9},{"$f":"InpActive!K164","v":109.88453874941817},{"$f":"InpActive!L164","v":112.08222952440661},{"$f":"InpActive!M164","v":114.37056169674494},{"$f":"InpActive!N164","v":116.77234349237666},{"$f":"InpActive!O164","v":119.22456270571664},{"$f":"InpActive!P164","v":121.60905395983097}]
[null,null,null,null,{"$f":"InpActive!E165","v":"Consumer price index (including housing costs) - Consumer Price Index (with housing) for June"},{"$f":"InpActive!F165","v":0},{"$f":"InpActive!G165","v":"Index"},{"$f":"InpActive!H165","v":0},{"$f":"InpActive!I165","v":0},{"$f":"InpActive!J165","v":107.9},{"$f":"InpActive!K165","v":110.06602199898684},{"$f":"InpActive!L165","v":112.26734243896665},{"$f":"InpActive!M165","v":114.56880920745294},{"$f":"InpActive!N165","v":116.97475420080953},{"$f":"InpActive!O165","v":119.4312240390266},{"$f":"InpActive!P165","v":121.81984851980714}]
[null,null,null,null,{"$f":"InpActive!E166","v":"Consumer price index (including housing costs) - Consumer Price Index (with housing) for July"},{"$f":"InpActive!F166","v":0},{"$f":"InpActive!G166","v":"Index"},{"$f":"InpActive!H166","v":0},{"$f":"InpActive!I166","v":0},{"$f":"InpActive!J166","v":108},{"$f":"InpActive!K166","v":110.24780498289711},{"$f":"InpActive!L166","v":112.45276108255513},{"$f":"InpActive!M166","v":114.7674003561996},{"$f":"InpActive!N166","v":117.17751576367986},{"$f":"InpActive!O166","v":119.63824359471722},{"$f":"InpActive!P166","v":122.03100846661157}]
[null,null,null,null,{"$f":"InpActive!E167","v":"Consumer price index (including housing costs) - Consumer Price Index (with housing) for August"},{"$f":"InpActive!F167","v":0},{"$f":"InpActive!G167","v":"Index"},{"$f":"InpActive!H167","v":0},{"$f":"InpActive!I167","v":0},{"$f":"InpActive!J167","v":108.3},{"$f":"InpActive!K167","v":110.42988819618461},{"$f":"InpActive!L167","v":112.63848596010838},{"$f":"InpActive!M167","v":114.96633573863983},{"$f":"InpActive!N167","v":117.38062878915133},{"$f":"InpActive!O167","v":119.8456219937236},{"$f":"InpActive!P167","v":122.24253443359807}]
[null,null,null,null,{"$f":"InpActive!E168","v":"Consumer price index (including housing costs) - Consumer Price Index (with housing) for September"},{"$f":"InpActive!F168","v":0},{"$f":"InpActive!G168","v":"Index"},{"$f":"InpActive!H168","v":0},{"$f":"InpActive!I168","v":0},{"$f":"InpActive!J168","v":108.4699996176289},{"$f":"InpActive!K168","v":110.61227213470256},{"$f":"InpActive!L168","v":112.8245175773967},{"$f":"InpActive!M168","v":115.16561595146101},{"$f":"InpActive!N168","v":117.58409388644176},{"$f":"InpActive!O168","v":120.05335985805712},{"$f":"InpActive!P168","v":122.45442705521826}]
[null,null,null,null,{"$f":"InpActive!E169","v":"Consumer price index (including housing costs) - Consumer Price Index (with housing) for October"},{"$f":"InpActive!F169","v":0},{"$f":"InpActive!G169","v":"Index"},{"$f":"InpActive!H169","v":0},{"$f":"InpActive!I169","v":0},{"$f":"InpActive!J169","v":108.64026608539625},{"$f":"InpActive!K169","v":110.79495729512315},{"$f":"InpActive!L169","v":113.01085644102571},{"$f":"InpActive!M169","v":115.36524159238483},{"$f":"InpActive!N169","v":117.78791166582499},{"$f":"InpActive!O169","v":120.2614578108074},{"$f":"InpActive!P169","v":122.66668696702355}]
[null,null,null,null,{"$f":"InpActive!E170","v":"Consumer price index (including housing costs) - Consumer Price Index (with housing) for November"},{"$f":"InpActive!F170","v":0},{"$f":"InpActive!G170","v":"Index"},{"$f":"InpActive!H170","v":0},{"$f":"InpActive!I170","v":0},{"$f":"InpActive!J170","v":108.81079982217945},{"$f":"InpActive!K170","v":110.97794417493883},{"$f":"InpActive!L170","v":113.1975030584377},{"$f":"InpActive!M170","v":115.56521326016906},{"$f":"InpActive!N170","v":117.99208273863269},{"$f":"InpActive!O170","v":120.46991647614406},{"$f":"InpActive!P170","v":122.87931480566695}]
[null,null,null,null,{"$f":"InpActive!E171","v":"Consumer price index (including housing costs) - Consumer Price Index (with housing) for December"},{"$f":"InpActive!F171","v":0},{"$f":"InpActive!G171","v":"Index"},{"$f":"InpActive!H171","v":0},{"$f":"InpActive!I171","v":0},{"$f":"InpActive!J171","v":108.98160124751338},{"$f":"InpActive!K171","v":111.1612332724637},{"$f":"InpActive!L171","v":113.38445793791308},{"$f":"InpActive!M171","v":115.76553155460934},{"$f":"InpActive!N171","v":118.19660771725621},{"$f":"InpActive!O171","v":120.67873647931867},{"$f":"InpActive!P171","v":123.09231120890504}]
[null,null,null,null,{"$f":"InpActive!E172","v":"Consumer price index (including housing costs) - Consumer Price Index (with housing) for January"},{"$f":"InpActive!F172","v":0},{"$f":"InpActive!G172","v":"Index"},{"$f":"InpActive!H172","v":0},{"$f":"InpActive!I172","v":0},{"$f":"InpActive!J172","v":109.1615932223871},{"$f":"InpActive!K172","v":111.3448250868349},{"$f":"InpActive!L172","v":113.58099615723886},{"$f":"InpActive!M172","v":115.96619707654096},{"$f":"InpActive!N172","v":118.40148721514839},{"$f":"InpActive!O172","v":120.88791844666659},{"$f":"InpActive!P172","v":123.30567681559992}]
[null,null,null,null,{"$f":"InpActive!E173","v":"Consumer price index (including housing costs) - Consumer Price Index (with housing) for February"},{"$f":"InpActive!F173","v":0},{"$f":"InpActive!G173","v":"Index"},{"$f":"InpActive!H173","v":0},{"$f":"InpActive!I173","v":0},{"$f":"InpActive!J173","v":109.34188246864102},{"$f":"InpActive!K173","v":111.52872011801389},{"$f":"InpActive!L173","v":113.7778750517538},{"$f":"InpActive!M173","v":116.16721042784071},{"$f":"InpActive!N173","v":118.60672184682544},{"$f":"InpActive!O173","v":121.09746300560886},{"$f":"InpActive!P173","v":123.51941226572104}]
[null,null,null,null,{"$f":"InpActive!E174","v":"Consumer price index (including housing costs) - Consumer Price Index (with housing) for March"},{"$f":"InpActive!F174","v":0},{"$f":"InpActive!G174","v":"Index"},{"$f":"InpActive!H174","v":0},{"$f":"InpActive!I174","v":0},{"$f":"InpActive!J174","v":109.52246947724298},{"$f":"InpActive!K174","v":111.7129188667879},{"$f":"InpActive!L174","v":113.97509521197706},{"$f":"InpActive!M174","v":116.36857221142867},{"$f":"InpActive!N174","v":118.81231222786873},{"$f":"InpActive!O174","v":121.30737078465407},{"$f":"InpActive!P174","v":123.73351820034715}]
[null,null,null,null,"CPIH: Financial year average - indices",null,"Index",null,null,{"$f":" AVERAGE(J26:J37)","v":108.55238432841576},{"$f":" AVERAGE(K26:K37)","v":110.7053733013603},{"$f":" AVERAGE(L26:L37)","v":112.92412852304592},115.26744552524362,117.68806188127378,120.15951118078063,{"$f":" AVERAGE(P26:P37)","v":122.56270140439625}]
[]
[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.55238432841576},110.7053733013603,112.92412852304592,115.26744552524362,117.68806188127378,120.15951118078063,122.56270140439625]
[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.0416029201511188},{"$f":" IF($F42 = 0, 0, K43 / $F42)","v":1.0622616980779815},{"$f":" IF($F42 = 0, 0, L43 / $F42)","v":1.083551529087279},1.1060365794841864,1.1292633476533549,1.1529778779540762,{"$f":" IF($F42 = 0, 0, P43 / $F42)","v":1.1760374355131578}]
[]
[]
["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":286,"n_cols":16,"rows_kept":286,"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 - Nominal"]
[null,null,null,null,{"$f":" InpActive!E28","v":"ANH - Allocated innovation funding - Nominal"},{"$f":" InpActive!F28","v":0},{"$f":" InpActive!G28","v":"£m"},{"$f":" InpActive!H28","v":0},{"$f":" InpActive!I28","v":0},{"$f":" InpActive!J28","v":0},{"$f":" InpActive!K28","v":0},{"$f":" InpActive!L28","v":0},{"$f":" InpActive!M28","v":0},{"$f":" InpActive!N28","v":0},{"$f":" InpActive!O28","v":0},{"$f":" InpActive!P28","v":0}]
[null,null,null,null,{"$f":" InpActive!E29","v":"HDD - Allocated innovation funding - Nominal"},{"$f":" InpActive!F29","v":0},{"$f":" InpActive!G29","v":"£m"},{"$f":" InpActive!H29","v":0},{"$f":" InpActive!I29","v":0},{"$f":" InpActive!J29","v":0},{"$f":" InpActive!K29","v":0},{"$f":" InpActive!L29","v":0},{"$f":" InpActive!M29","v":0},{"$f":" InpActive!N29","v":0},{"$f":" InpActive!O29","v":0},{"$f":" InpActive!P29","v":0}]
[null,null,null,null,{"$f":" InpActive!E30","v":"NES - Allocated innovation funding - Nominal"},{"$f":" InpActive!F30","v":0},{"$f":" InpActive!G30","v":"£m"},{"$f":" InpActive!H30","v":0},{"$f":" InpActive!I30","v":0},{"$f":" InpActive!J30","v":0},{"$f":" InpActive!K30","v":0},{"$f":" InpActive!L30","v":0},{"$f":" InpActive!M30","v":0},{"$f":" InpActive!N30","v":0},{"$f":" InpActive!O30","v":0},{"$f":" InpActive!P30","v":0}]
[null,null,null,null,{"$f":" InpActive!E31","v":"NWT - Allocated innovation funding - Nominal"},{"$f":" InpActive!F31","v":0},{"$f":" InpActive!G31","v":"£m"},{"$f":" InpActive!H31","v":0},{"$f":" InpActive!I31","v":0},{"$f":" InpActive!J31","v":0},{"$f":" InpActive!K31","v":0},{"$f":" InpActive!L31","v":0},{"$f":" InpActive!M31","v":0},{"$f":" InpActive!N31","v":0},{"$f":" InpActive!O31","v":0},{"$f":" InpActive!P31","v":0}]
[null,null,null,null,{"$f":" InpActive!E32","v":"SRN - Allocated innovation funding - Nominal"},{"$f":" InpActive!F32","v":0},{"$f":" InpActive!G32","v":"£m"},{"$f":" InpActive!H32","v":0},{"$f":" InpActive!I32","v":0},{"$f":" InpActive!J32","v":0},{"$f":" InpActive!K32","v":0},{"$f":" InpActive!L32","v":0},{"$f":" InpActive!M32","v":0},{"$f":" InpActive!N32","v":0},{"$f":" InpActive!O32","v":0},{"$f":" InpActive!P32","v":0}]
[null,null,null,null,{"$f":" InpActive!E33","v":"SVE - Allocated innovation funding - Nominal"},{"$f":" InpActive!F33","v":0},{"$f":" InpActive!G33","v":"£m"},{"$f":" InpActive!H33","v":0},{"$f":" InpActive!I33","v":0},{"$f":" InpActive!J33","v":0},{"$f":" InpActive!K33","v":0},{"$f":" InpActive!L33","v":0},{"$f":" InpActive!M33","v":0},{"$f":" InpActive!N33","v":0},{"$f":" InpActive!O33","v":0},{"$f":" InpActive!P33","v":0}]
[null,null,null,null,{"$f":" InpActive!E34","v":"SWB - Allocated innovation funding - Nominal"},{"$f":" InpActive!F34","v":0},{"$f":" InpActive!G34","v":"£m"},{"$f":" InpActive!H34","v":0},{"$f":" InpActive!I34","v":0},{"$f":" InpActive!J34","v":0},{"$f":" InpActive!K34","v":0},{"$f":" InpActive!L34","v":0},{"$f":" InpActive!M34","v":0},{"$f":" InpActive!N34","v":0},{"$f":" InpActive!O34","v":0},{"$f":" InpActive!P34","v":0}]
[null,null,null,null,{"$f":" InpActive!E35","v":"TMS - Allocated innovation funding - Nominal"},{"$f":" InpActive!F35","v":0},{"$f":" InpActive!G35","v":"£m"},{"$f":" InpActive!H35","v":0},{"$f":" InpActive!I35","v":0},{"$f":" InpActive!J35","v":0},{"$f":" InpActive!K35","v":0},{"$f":" InpActive!L35","v":0},{"$f":" InpActive!M35","v":0},{"$f":" InpActive!N35","v":0},{"$f":" InpActive!O35","v":0},{"$f":" InpActive!P35","v":0}]
[null,null,null,null,{"$f":" InpActive!E36","v":"WSH - Allocated innovation funding - Nominal"},{"$f":" InpActive!F36","v":0},{"$f":" InpActive!G36","v":"£m"},{"$f":" InpActive!H36","v":0},{"$f":" InpActive!I36","v":0},{"$f":" InpActive!J36","v":0},{"$f":" InpActive!K36","v":0},{"$f":" InpActive!L36","v":0},{"$f":" InpActive!M36","v":0},{"$f":" InpActive!N36","v":0},{"$f":" InpActive!O36","v":0},{"$f":" InpActive!P36","v":0}]
[null,null,null,null,{"$f":" InpActive!E37","v":"WSX - Allocated innovation funding - Nominal"},{"$f":" InpActive!F37","v":0},{"$f":" InpActive!G37","v":"£m"},{"$f":" InpActive!H37","v":0},{"$f":" InpActive!I37","v":0},{"$f":" InpActive!J37","v":0},{"$f":" InpActive!K37","v":0},{"$f":" InpActive!L37","v":0},{"$f":" InpActive!M37","v":0},{"$f":" InpActive!N37","v":0},{"$f":" InpActive!O37","v":0},{"$f":" InpActive!P37","v":0}]
[null,null,null,null,{"$f":" InpActive!E38","v":"YKY - Allocated innovation funding - Nominal"},{"$f":" InpActive!F38","v":0},{"$f":" InpActive!G38","v":"£m"},{"$f":" InpActive!H38","v":0},{"$f":" InpActive!I38","v":0},{"$f":" InpActive!J38","v":0},{"$f":" InpActive!K38","v":0},{"$f":" InpActive!L38","v":0},{"$f":" InpActive!M38","v":0},{"$f":" InpActive!N38","v":0},{"$f":" InpActive!O38","v":0},{"$f":" InpActive!P38","v":0}]
[null,null,null,null,{"$f":" InpActive!E39","v":"AFW - Allocated innovation funding - Nominal"},{"$f":" InpActive!F39","v":0},{"$f":" InpActive!G39","v":"£m"},{"$f":" InpActive!H39","v":0},{"$f":" InpActive!I39","v":0},{"$f":" InpActive!J39","v":0},{"$f":" InpActive!K39","v":0},{"$f":" InpActive!L39","v":0},{"$f":" InpActive!M39","v":0},{"$f":" InpActive!N39","v":0},{"$f":" InpActive!O39","v":0},{"$f":" InpActive!P39","v":0}]
[null,null,null,null,{"$f":" InpActive!E40","v":"BRL - Allocated innovation funding - Nominal"},{"$f":" InpActive!F40","v":0},{"$f":" InpActive!G40","v":"£m"},{"$f":" InpActive!H40","v":0},{"$f":" InpActive!I40","v":0},{"$f":" InpActive!J40","v":0},{"$f":" InpActive!K40","v":0},{"$f":" InpActive!L40","v":0},{"$f":" InpActive!M40","v":0},{"$f":" InpActive!N40","v":0},{"$f":" InpActive!O40","v":0},{"$f":" InpActive!P40","v":0}]
[null,null,null,null,{"$f":" InpActive!E41","v":"PRT - Allocated innovation funding - Nominal"},{"$f":" InpActive!F41","v":0},{"$f":" InpActive!G41","v":"£m"},{"$f":" InpActive!H41","v":0},{"$f":" InpActive!I41","v":0},{"$f":" InpActive!J41","v":0},{"$f":" InpActive!K41","v":0},{"$f":" InpActive!L41","v":0},{"$f":" InpActive!M41","v":0},{"$f":" InpActive!N41","v":0},{"$f":" InpActive!O41","v":0},{"$f":" InpActive!P41","v":0}]
[null,null,null,null,{"$f":" InpActive!E42","v":"SES - Allocated innovation funding - Nominal"},{"$f":" InpActive!F42","v":0},{"$f":" InpActive!G42","v":"£m"},{"$f":" InpActive!H42","v":0},{"$f":" InpActive!I42","v":0},{"$f":" InpActive!J42","v":0},{"$f":" InpActive!K42","v":0},{"$f":" InpActive!L42","v":0},{"$f":" InpActive!M42","v":0},{"$f":" InpActive!N42","v":0},{"$f":" InpActive!O42","v":0},{"$f":" InpActive!P42","v":0}]
[null,null,null,null,{"$f":" InpActive!E43","v":"SEW - Allocated innovation funding - Nominal"},{"$f":" InpActive!F43","v":0},{"$f":" InpActive!G43","v":"£m"},{"$f":" InpActive!H43","v":0},{"$f":" InpActive!I43","v":0},{"$f":" InpActive!J43","v":0},{"$f":" InpActive!K43","v":0},{"$f":" InpActive!L43","v":0},{"$f":" InpActive!M43","v":0},{"$f":" InpActive!N43","v":0},{"$f":" InpActive!O43","v":0},{"$f":" InpActive!P43","v":0}]
[null,null,null,null,{"$f":" InpActive!E44","v":"SSC - Allocated innovation funding - Nominal"},{"$f":" InpActive!F44","v":0},{"$f":" InpActive!G44","v":"£m"},{"$f":" InpActive!H44","v":0},{"$f":" InpActive!I44","v":0},{"$f":" InpActive!J44","v":0},{"$f":" InpActive!K44","v":0},{"$f":" InpActive!L44","v":0},{"$f":" InpActive!M44","v":0},{"$f":" InpActive!N44","v":0},{"$f":" InpActive!O44","v":0},{"$f":" InpActive!P44","v":0}]
[null,null,null,null,"Total Allocated Funding - Nominal",null,"£m",{"$f":" SUM(J26:P26)","v":0},null,{"$f":" SUM(J9:J25)","v":0},0,0,0,0,0,0]
[]
[null,null,null,"Proportion of Funding allocated"]
[null,null,null,null,"ANH - Proportion of Funding allocated",{"$f":" IF( $H$26 = 0, 0,#REF! / $H$26)","v":0},"%"]
[null,null,null,null,"HDD - Proportion of Funding allocated",{"$f":" IF( $H$26 = 0, 0,#REF! / $H$26)","v":0},"%"]
[null,null,null,null,"NES - Proportion of Funding allocated",{"$f":" IF( $H$26 = 0, 0,#REF! / $H$26)","v":0},"%"]
[null,null,null,null,"NWT - Proportion of Funding allocated",{"$f":" IF( $H$26 = 0, 0,#REF! / $H$26)","v":0},"%"]
[null,null,null,null,"SRN - Proportion of Funding allocated",{"$f":" IF( $H$26 = 0, 0,#REF! / $H$26)","v":0},"%"]
[null,null,null,null,"SVE - Proportion of Funding allocated",{"$f":" IF( $H$26 = 0, 0,#REF! / $H$26)","v":0},"%"]
[null,null,null,null,"SWB - Proportion of Funding allocated",{"$f":" IF( $H$26 = 0, 0,#REF! / $H$26)","v":0},"%"]
[null,null,null,null,"TMS - Proportion of Funding allocated",{"$f":" IF( $H$26 = 0, 0,#REF! / $H$26)","v":0},"%"]
[null,null,null,null,"WSH - Proportion of Funding allocated",{"$f":" IF( $H$26 = 0, 0,#REF! / $H$26)","v":0},"%"]
[null,null,null,null,"WSX - Proportion of Funding allocated",{"$f":" IF( $H$26 = 0, 0,#REF! / $H$26)","v":0},"%"]
[null,null,null,null,"YKY - Proportion of Funding allocated",{"$f":" IF( $H$26 = 0, 0,#REF! / $H$26)","v":0},"%"]
[null,null,null,null,"AFW - Proportion of Funding allocated",{"$f":" IF( $H$26 = 0, 0,#REF! / $H$26)","v":0},"%"]
[null,null,null,null,"BRL - Proportion of Funding allocated",{"$f":" IF( $H$26 = 0, 0,#REF! / $H$26)","v":0},"%"]
[null,null,null,null,"PRT - Proportion of Funding allocated",{"$f":" IF( $H$26 = 0, 0,#REF! / $H$26)","v":0},"%"]
[null,null,null,null,"SES - Proportion of Funding allocated",{"$f":" IF( $H$26 = 0, 0,#REF! / $H$26)","v":0},"%"]
[null,null,null,null,"SEW - Proportion of Funding allocated",{"$f":" IF( $H$26 = 0, 0,#REF! / $H$26)","v":0},"%"]
[null,null,null,null,"SSC - Proportion of Funding allocated",{"$f":" IF( $H$26 = 0, 0,#REF! / $H$26)","v":0},"%"]
[null,null,null,null,"Total Allocated",{"$f":"SUM(F29:F45)","v":0},"%"]
[]
[null,null,null,"Total Funding transferred to innovation fund"]
[null,null,null,null,{"$f":" InpActive!E47","v":"ANH - Total Funding transferred to innovation fund - 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 innovation fund - 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 innovation fund - 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 innovation fund - 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 innovation fund - 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 innovation fund - 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 innovation fund - 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 innovation fund - 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 innovation fund - 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 innovation fund - 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 innovation fund - 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 innovation fund - 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 innovation fund - 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 innovation fund - 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 innovation fund - 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 innovation fund - 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 innovation fund - 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(J66:P66)","v":0},null,{"$f":" SUM(J49:J65)","v":0},{"$f":" SUM(K49:K65)","v":0},{"$f":" SUM(L49:L65)","v":0},{"$f":" SUM(M49:M65)","v":0},{"$f":" SUM(N49:N65)","v":0},{"$f":" SUM(O49:O65)","v":0},{"$f":" SUM(P49:P65)","v":0}]
[]
[null,null,null,"Bids Accepted"]
[null,null,null,null,{"$f":" InpActive!E66","v":"ANH - Bids Accepted & Funding Awarded - Nominal"},{"$f":" InpActive!F66","v":0},{"$f":" InpActive!G66","v":"£m"},{"$f":" InpActive!H66","v":0},{"$f":" InpActive!I66","v":0},{"$f":" InpActive!J66","v":0},{"$f":" InpActive!K66","v":0},{"$f":" InpActive!L66","v":0},{"$f":" InpActive!M66","v":0},{"$f":" InpActive!N66","v":0},{"$f":" InpActive!O66","v":0},{"$f":" InpActive!P66","v":0}]
[null,null,null,null,{"$f":" InpActive!E67","v":"HDD - 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":"NES - 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":"NWT - 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":"SRN - 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":"SVE - 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":"SWB - 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":"TMS - 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":"WSH - 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":"WSX - 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":"YKY - 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":"AFW - 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":"BRL - 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":"PRT - 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":"SES - 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":"SEW - 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":"SSC - 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,"Total Bids accepted - Nominal",null,"£m",{"$f":" SUM(J86:P86)","v":0},null,{"$f":" SUM(J69:J85)","v":0},{"$f":" SUM(K69:K85)","v":0},{"$f":" SUM(L69:L85)","v":0},{"$f":" SUM(M69:M85)","v":0},{"$f":" SUM(N69:N85)","v":0},{"$f":" SUM(O69:O85)","v":0},{"$f":" SUM(P69:P85)","v":0}]
[]
[null,null,null,"Total project spend to date"]
[null,null,null,null,{"$f":" InpActive!E85","v":"ANH - Expenditure on innovation spend to date - Nominal"},{"$f":" InpActive!F85","v":0},{"$f":" InpActive!G85","v":"£m"},{"$f":" InpActive!H85","v":0},{"$f":" InpActive!I85","v":0},{"$f":" InpActive!J85","v":0},{"$f":" InpActive!K85","v":0},{"$f":" InpActive!L85","v":0},{"$f":" InpActive!M85","v":0},{"$f":" InpActive!N85","v":0},{"$f":" InpActive!O85","v":0},{"$f":" InpActive!P85","v":0}]
[null,null,null,null,{"$f":" InpActive!E86","v":"HDD - Expenditure on innovation spend to date - Nominal"},{"$f":" InpActive!F86","v":0},{"$f":" InpActive!G86","v":"£m"},{"$f":" InpActive!H86","v":0},{"$f":" InpActive!I86","v":0},{"$f":" InpActive!J86","v":0},{"$f":" InpActive!K86","v":0},{"$f":" InpActive!L86","v":0},{"$f":" InpActive!M86","v":0},{"$f":" InpActive!N86","v":0},{"$f":" InpActive!O86","v":0},{"$f":" InpActive!P86","v":0}]
[null,null,null,null,{"$f":" InpActive!E87","v":"NES - Expenditure on innovation spend to date - Nominal"},{"$f":" InpActive!F87","v":0},{"$f":" InpActive!G87","v":"£m"},{"$f":" InpActive!H87","v":0},{"$f":" InpActive!I87","v":0},{"$f":" InpActive!J87","v":0},{"$f":" InpActive!K87","v":0},{"$f":" InpActive!L87","v":0},{"$f":" InpActive!M87","v":0},{"$f":" InpActive!N87","v":0},{"$f":" InpActive!O87","v":0},{"$f":" InpActive!P87","v":0}]
[null,null,null,null,{"$f":" InpActive!E88","v":"NWT - Expenditure on innovation spend to date - Nominal"},{"$f":" InpActive!F88","v":0},{"$f":" InpActive!G88","v":"£m"},{"$f":" InpActive!H88","v":0},{"$f":" InpActive!I88","v":0},{"$f":" InpActive!J88","v":0},{"$f":" InpActive!K88","v":0},{"$f":" InpActive!L88","v":0},{"$f":" InpActive!M88","v":0},{"$f":" InpActive!N88","v":0},{"$f":" InpActive!O88","v":0},{"$f":" InpActive!P88","v":0}]
[null,null,null,null,{"$f":" InpActive!E89","v":"SRN - Expenditure on innovation spend to date - Nominal"},{"$f":" InpActive!F89","v":0},{"$f":" InpActive!G89","v":"£m"},{"$f":" InpActive!H89","v":0},{"$f":" InpActive!I89","v":0},{"$f":" InpActive!J89","v":0},{"$f":" InpActive!K89","v":0},{"$f":" InpActive!L89","v":0},{"$f":" InpActive!M89","v":0},{"$f":" InpActive!N89","v":0},{"$f":" InpActive!O89","v":0},{"$f":" InpActive!P89","v":0}]
[null,null,null,null,{"$f":" InpActive!E90","v":"SVE - Expenditure on innovation spend to date - Nominal"},{"$f":" InpActive!F90","v":0},{"$f":" InpActive!G90","v":"£m"},{"$f":" InpActive!H90","v":0},{"$f":" InpActive!I90","v":0},{"$f":" InpActive!J90","v":0},{"$f":" InpActive!K90","v":0},{"$f":" InpActive!L90","v":0},{"$f":" InpActive!M90","v":0},{"$f":" InpActive!N90","v":0},{"$f":" InpActive!O90","v":0},{"$f":" InpActive!P90","v":0}]
[null,null,null,null,{"$f":" InpActive!E91","v":"SWB - Expenditure on innovation spend to date - Nominal"},{"$f":" InpActive!F91","v":0},{"$f":" InpActive!G91","v":"£m"},{"$f":" InpActive!H91","v":0},{"$f":" InpActive!I91","v":0},{"$f":" InpActive!J91","v":0},{"$f":" InpActive!K91","v":0},{"$f":" InpActive!L91","v":0},{"$f":" InpActive!M91","v":0},{"$f":" InpActive!N91","v":0},{"$f":" InpActive!O91","v":0},{"$f":" InpActive!P91","v":0}]
[null,null,null,null,{"$f":" InpActive!E92","v":"TMS - 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":"WSH - 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":"WSX - 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":"YKY - 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":"AFW - 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":"BRL - 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":"PRT - 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":"SES - 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":"SEW - 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":"SSC - 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,"Total project spend - Nominal",null,"£m",{"$f":" SUM(J106:P106)","v":0},null,{"$f":" SUM(J89:J105)","v":0},{"$f":" SUM(K89:K105)","v":0},{"$f":" SUM(L89:L105)","v":0},{"$f":" SUM(M89:M105)","v":0},{"$f":" SUM(N89:N105)","v":0},{"$f":" SUM(O89:O105)","v":0},{"$f":" SUM(P89:P105)","v":0}]
[]
[null,null,null,"Allowed Future expenditure"]
[null,null,null,null,{"$f":" InpActive!E104","v":"ANH - Allowed Future expenditure on innovation projects - 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":"HDD - Allowed Future expenditure on innovation projects - 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":"NES - Allowed Future expenditure on innovation projects - 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":"NWT - Allowed Future expenditure on innovation projects - 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":"SRN - Allowed Future expenditure on innovation projects - 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":"SVE - Allowed Future expenditure on innovation projects - 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,null,{"$f":" InpActive!E110","v":"SWB - Allowed Future expenditure on innovation projects - Nominal"},{"$f":" InpActive!F110","v":0},{"$f":" InpActive!G110","v":"£m"},{"$f":" InpActive!H110","v":0},{"$f":" InpActive!I110","v":0},{"$f":" InpActive!J110","v":0},{"$f":" InpActive!K110","v":0},{"$f":" InpActive!L110","v":0},{"$f":" InpActive!M110","v":0},{"$f":" InpActive!N110","v":0},{"$f":" InpActive!O110","v":0},{"$f":" InpActive!P110","v":0}]
[null,null,null,null,{"$f":" InpActive!E111","v":"TMS - Allowed Future expenditure on innovation projects - Nominal"},{"$f":" InpActive!F111","v":0},{"$f":" InpActive!G111","v":"£m"},{"$f":" InpActive!H111","v":0},{"$f":" InpActive!I111","v":0},{"$f":" InpActive!J111","v":0},{"$f":" InpActive!K111","v":0},{"$f":" InpActive!L111","v":0},{"$f":" InpActive!M111","v":0},{"$f":" InpActive!N111","v":0},{"$f":" InpActive!O111","v":0},{"$f":" InpActive!P111","v":0}]
[null,null,null,null,{"$f":" InpActive!E112","v":"WSH - Allowed Future expenditure on innovation projects - 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":"WSX - Allowed Future expenditure on innovation projects - 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":"YKY - Allowed Future expenditure on innovation projects - 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":"AFW - Allowed Future expenditure on innovation projects - 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":"BRL - Allowed Future expenditure on innovation projects - 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":"PRT - Allowed Future expenditure on innovation projects - 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":"SES - Allowed Future expenditure on innovation projects - 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":"SEW - Allowed Future expenditure on innovation projects - 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":"SSC - Allowed Future expenditure on innovation projects - 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,"Total allowed future expenditure - Nominal",null,"£m",{"$f":" SUM(J126:P126)","v":0},null,{"$f":" SUM(J109:J125)","v":0},{"$f":" SUM(K109:K125)","v":0},{"$f":" SUM(L109:L125)","v":0},{"$f":" SUM(M109:M125)","v":0},{"$f":" SUM(N109:N125)","v":0},{"$f":" SUM(O109:O125)","v":0},{"$f":" SUM(P109:P125)","v":0}]
[]
[null,null,null,"Total Unused funds"]
[null,null,null,null,{"$f":"E$66","v":"Total Transferred - Nominal"},{"$f":"F$66","v":0},"£m",0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"E$86","v":"Total Bids accepted - Nominal"},{"$f":"F$86","v":0},"£m",0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Total unused fund - Nominal",null,"£m",{"$f":" SUM(J131:P131)","v":0},null,{"$f":"J129-J130","v":0},{"$f":"K129-K130","v":0},{"$f":"L129-L130","v":0},0,0,0,{"$f":"P129-P130","v":0}]
[]
[null,null,null,"Total Underspend"]
[null,null,null,null,{"$f":" E$86","v":"Total Bids accepted - Nominal"},{"$f":" F$86","v":0},"£m",0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"E$106","v":"Total project spend - Nominal"},{"$f":"F$106","v":0},"£m",0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$126","v":"Total allowed future expenditure - Nominal"},{"$f":" F$126","v":0},"£m",0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Total Underspend - Nominal",null,"£m",{"$f":" SUM(J137:P137)","v":0},null,{"$f":" J134 - SUM(J135:J136)","v":0},{"$f":" K134 - SUM(K135:K136)","v":0},{"$f":" L134 - SUM(L135:L136)","v":0},0,0,0,0]
[]
[null,null,null,"Total returned to customers"]
[null,null,null,null,{"$f":" E$131","v":"Total unused fund - Nominal"},{"$f":" F$131","v":0},"£m",0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$137","v":"Total Underspend - Nominal"},{"$f":" F$137","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(J142:P142)","v":0},null,{"$f":" SUM(J140:J141)","v":0},{"$f":" SUM(K140:K141)","v":0},0,0,0,0,0]
[]
[null,null,null,null,{"$f":" E$142","v":"Funds to be redistributed - Nominal"},{"$f":" F$142","v":0},"£m",0,0,0,0,0,0,0,0,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.0416029201511188},{"$f":"Indexation!K$44","v":1.0622616980779815},{"$f":"Indexation!L$44","v":1.083551529087279},{"$f":"Indexation!M$44","v":1.1060365794841864},{"$f":"Indexation!N$44","v":1.1292633476533549},{"$f":"Indexation!O$44","v":1.1529778779540762},{"$f":"Indexation!P$44","v":1.1760374355131578}]
[null,null,null,null,"Funds to be redistributed - Real",null,"£m",{"$f":" SUM(J146:P146)","v":0},null,{"$f":" J144 / J145","v":0},{"$f":" K144 / K145","v":0},0,0,0,0,0]
[]
[null,null,null,"Proportion of Funding allocated"]
[null,null,null,null,{"$f":"E29","v":"ANH - Proportion of Funding allocated"},0,"%"]
[null,null,null,null,"HDD - Proportion of Funding allocated",0,"%"]
[null,null,null,null,"NES - Proportion of Funding allocated",0,"%"]
[null,null,null,null,"NWT - Proportion of Funding allocated",0,"%"]
[null,null,null,null,"SRN - Proportion of Funding allocated",0,"%"]
[null,null,null,null,"SVE - Proportion of Funding allocated",0,"%"]
[null,null,null,null,"SWB - Proportion of Funding allocated",0,"%"]
[null,null,null,null,"TMS - Proportion of Funding allocated",0,"%"]
[null,null,null,null,"WSH - Proportion of Funding allocated",0,"%"]
[null,null,null,null,"WSX - Proportion of Funding allocated",0,"%"]
[null,null,null,null,"YKY - Proportion of Funding allocated",0,"%"]
[null,null,null,null,"AFW - Proportion of Funding allocated",0,"%"]
[null,null,null,null,"BRL - Proportion of Funding allocated",0,"%"]
[null,null,null,null,"PRT - Proportion of Funding allocated",0,"%"]
[null,null,null,null,"SES - Proportion of Funding allocated",0,"%"]
[null,null,null,null,"SEW - Proportion of Funding allocated",0,"%"]
[null,null,null,null,"SSC - Proportion of Funding allocated",0,"%"]
[null,null,null,null,"Total Allocated",0,"%"]
[]
[null,null,null,null,{"$f":" E$146","v":"Funds to be redistributed - Real"},{"$f":" F$146","v":0},"£m",0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Proportion of Funding allocated"]
[null,null,null,null,"ANH - Total to be redistributed - Real",null,null,{"$f":" SUM(J171:P171)","v":0},null,{"$f":" J$168 * $F149","v":0},{"$f":" K$168 * $F149","v":0},0,0,0,0,0]
[null,null,null,null,"HDD - Total to be redistributed - Real",null,null,0,null,0,{"$f":" K$168 * $F150","v":0},0,0,0,0,0]
[null,null,null,null,"NES - Total to be redistributed - Real",null,null,0,null,0,0,0,0,0,0,0]
[null,null,null,null,"NWT - Total to be redistributed - Real",null,null,0,null,0,0,0,0,0,0,0]
[null,null,null,null,"SRN - Total to be redistributed - Real",null,null,0,null,0,0,0,0,0,0,0]
[null,null,null,null,"SVE - Total to be redistributed - Real",null,null,0,null,0,0,0,0,0,0,0]
[null,null,null,null,"SWB - Total to be redistributed - Real",null,null,0,null,0,0,0,0,0,0,0]
[null,null,null,null,"TMS - Total to be redistributed - Real",null,null,0,null,0,0,0,0,0,0,0]
[null,null,null,null,"WSH - Total to be redistributed - Real",null,null,0,null,0,0,0,0,0,0,0]
[null,null,null,null,"WSX - Total to be redistributed - Real",null,null,0,null,0,0,0,0,0,0,0]
[null,null,null,null,"YKY - Total to be redistributed - Real",null,null,0,null,0,0,0,0,0,0,0]
[null,null,null,null,"AFW - Total to be redistributed - Real",null,null,0,null,0,{"$f":" K$168 * $F160","v":0},0,0,0,0,0]
[null,null,null,null,"BRL - Total to be redistributed - Real",null,null,0,null,0,0,0,0,0,0,0]
[null,null,null,null,"PRT - Total to be redistributed - Real",null,null,0,null,0,0,0,0,0,0,0]
[null,null,null,null,"SES - Total to be redistributed - Real",null,null,0,null,0,0,0,0,0,0,0]
[null,null,null,null,"SEW - Total to be redistributed - Real",null,null,0,null,0,0,0,0,0,0,0]
[null,null,null,null,"SSC - Total to be redistributed - Real",null,null,0,null,0,0,0,0,0,0,0]
[null,null,null,null,"Total to be redistributed - Real",null,null,0,null,{"$f":" SUM(J171:J187)","v":0},{"$f":" SUM(K171:K187)","v":0},{"$f":" SUM(L171:L187)","v":0},0,0,0,0]
[null,null,null,null,"Negative funding check",{"$f":" IF(SUM(J189:P189) <> 0, 1, 0)","v":0},"check",{"$f":" SUM(J189:P189)","v":0},null,{"$f":" COUNTIF(J171:J187, \"<0\")","v":0},{"$f":" COUNTIF(K171:K187, \"<0\")","v":0},0,0,0,0,0]
[]
[null,null,null,null,{"$f":" InpActive!E$126","v":"Financing cost index"},{"$f":" InpActive!F$126","v":0},{"$f":" InpActive!G$126","v":"Index"},{"$f":" InpActive!H$126","v":0},{"$f":" InpActive!I$126","v":0},{"$f":" InpActive!J$126","v":0},{"$f":" InpActive!K$126","v":4},{"$f":" InpActive!L$126","v":3},{"$f":" InpActive!M$126","v":2},{"$f":" InpActive!N$126","v":1},{"$f":" InpActive!O$126","v":0},{"$f":" InpActive!P$126","v":0}]
[]
[null,null,null,null,{"$f":" InpActive!E128","v":"ANH - WACC"},{"$f":" InpActive!F128","v":0},{"$f":" InpActive!G128","v":"%"}]
[null,null,null,null,{"$f":" InpActive!E129","v":"HDD - WACC"},{"$f":" InpActive!F129","v":0},{"$f":" InpActive!G129","v":"%"}]
[null,null,null,null,{"$f":" InpActive!E130","v":"NES - WACC"},{"$f":" InpActive!F130","v":0},{"$f":" InpActive!G130","v":"%"}]
[null,null,null,null,{"$f":" InpActive!E131","v":"NWT - WACC"},{"$f":" InpActive!F131","v":0},{"$f":" InpActive!G131","v":"%"}]
[null,null,null,null,{"$f":" InpActive!E132","v":"SRN - WACC"},{"$f":" InpActive!F132","v":0},{"$f":" InpActive!G132","v":"%"}]
[null,null,null,null,{"$f":" InpActive!E133","v":"SVE - WACC"},{"$f":" InpActive!F133","v":0},{"$f":" InpActive!G133","v":"%"}]
[null,null,null,null,{"$f":" InpActive!E134","v":"SWB - WACC"},{"$f":" InpActive!F134","v":0},{"$f":" InpActive!G134","v":"%"}]
[null,null,null,null,{"$f":" InpActive!E135","v":"TMS - WACC"},{"$f":" InpActive!F135","v":0},{"$f":" InpActive!G135","v":"%"}]
[null,null,null,null,{"$f":" InpActive!E136","v":"WSH - WACC"},{"$f":" InpActive!F136","v":0},{"$f":" InpActive!G136","v":"%"}]
[null,null,null,null,{"$f":" InpActive!E137","v":"WSX - WACC"},{"$f":" InpActive!F137","v":0},{"$f":" InpActive!G137","v":"%"}]
[null,null,null,null,{"$f":" InpActive!E138","v":"YKY - WACC"},{"$f":" InpActive!F138","v":0},{"$f":" InpActive!G138","v":"%"}]
[null,null,null,null,{"$f":" InpActive!E139","v":"AFW - WACC"},{"$f":" InpActive!F139","v":0},{"$f":" InpActive!G139","v":"%"}]
[null,null,null,null,{"$f":" InpActive!E140","v":"BRL - WACC"},{"$f":" InpActive!F140","v":0},{"$f":" InpActive!G140","v":"%"}]
[null,null,null,null,{"$f":" InpActive!E141","v":"PRT - WACC"},{"$f":" InpActive!F141","v":0},{"$f":" InpActive!G141","v":"%"}]
[null,null,null,null,{"$f":" InpActive!E142","v":"SES - WACC"},{"$f":" InpActive!F142","v":0},{"$f":" InpActive!G142","v":"%"}]
[null,null,null,null,{"$f":" InpActive!E143","v":"SEW - WACC"},{"$f":" InpActive!F143","v":0},{"$f":" InpActive!G143","v":"%"}]
[null,null,null,null,{"$f":" InpActive!E144","v":"SSC - WACC"},{"$f":" InpActive!F144","v":0},{"$f":" InpActive!G144","v":"%"}]
[]
[null,null,null,null,"ANH - Time value of money factor",null,"Factor",null,null,{"$f":"(1+$F193) ^ J$191","v":1},{"$f":"(1+$F193) ^ K$191","v":1},1,1,1,1,1]
[null,null,null,null,"HDD - Time value of money factor",null,"Factor",null,null,{"$f":"(1+$F194) ^ J$191","v":1},1,1,1,1,1,1]
[null,null,null,null,"NES - Time value of money factor",null,"Factor",null,null,{"$f":"(1+$F195) ^ J$191","v":1},1,1,1,1,1,1]
[null,null,null,null,"NWT - Time value of money factor",null,"Factor",null,null,{"$f":"(1+$F196) ^ J$191","v":1},1,1,1,1,1,1]
[null,null,null,null,"SRN - Time value of money factor",null,"Factor",null,null,{"$f":"(1+$F197) ^ J$191","v":1},1,1,1,1,1,1]
[null,null,null,null,"SVE - Time value of money factor",null,"Factor",null,null,{"$f":"(1+$F198) ^ J$191","v":1},1,1,1,1,1,1]
[null,null,null,null,"SWB - Time value of money factor",null,"Factor",null,null,{"$f":"(1+$F199) ^ J$191","v":1},1,1,1,1,1,1]
[null,null,null,null,"TMS - Time value of money factor",null,"Factor",null,null,{"$f":"(1+$F200) ^ J$191","v":1},1,1,1,1,1,1]
[null,null,null,null,"WSH - Time value of money factor",null,"Factor",null,null,{"$f":"(1+$F201) ^ J$191","v":1},1,1,1,1,1,1]
[null,null,null,null,"WSX - Time value of money factor",null,"Factor",null,null,{"$f":"(1+$F202) ^ J$191","v":1},1,1,1,1,1,1]
[null,null,null,null,"YKY - Time value of money factor",null,"Factor",null,null,{"$f":"(1+$F203) ^ J$191","v":1},1,1,1,1,1,1]
[null,null,null,null,"AFW - Time value of money factor",null,"Factor",null,null,{"$f":"(1+$F204) ^ J$191","v":1},1,1,1,1,1,1]
[null,null,null,null,"BRL - Time value of money factor",null,"Factor",null,null,{"$f":"(1+$F205) ^ J$191","v":1},1,1,1,1,1,1]
[null,null,null,null,"PRT - Time value of money factor",null,"Factor",null,null,{"$f":"(1+$F206) ^ J$191","v":1},1,1,1,1,1,1]
[null,null,null,null,"SES - Time value of money factor",null,"Factor",null,null,{"$f":"(1+$F207) ^ J$191","v":1},1,1,1,1,1,1]
[null,null,null,null,"SEW - Time value of money factor",null,"Factor",null,null,{"$f":"(1+$F208) ^ J$191","v":1},1,1,1,1,1,1]
[null,null,null,null,"SSC - Time value of money factor",null,"Factor",null,null,{"$f":"(1+$F209) ^ J$191","v":1},1,1,1,1,1,1]
[]
[null,null,null,{"$f":"D170","v":"Proportion of Funding allocated"}]
[null,null,null,null,{"$f":"E171","v":"ANH - Total to be redistributed - Real"},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"E172","v":"HDD - Total to be redistributed - Real"},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"E173","v":"NES - Total to be redistributed - Real"},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"E174","v":"NWT - Total to be redistributed - Real"},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"E175","v":"SRN - Total to be redistributed - Real"},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"E176","v":"SVE - Total to be redistributed - Real"},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"E177","v":"SWB - Total to be redistributed - Real"},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"E178","v":"TMS - Total to be redistributed - Real"},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"E179","v":"WSH - Total to be redistributed - Real"},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"E180","v":"WSX - Total to be redistributed - Real"},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"E181","v":"YKY - Total to be redistributed - Real"},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"E182","v":"AFW - Total to be redistributed - Real"},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"E183","v":"BRL - Total to be redistributed - Real"},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"E184","v":"PRT - Total to be redistributed - Real"},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"E185","v":"SES - Total to be redistributed - Real"},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"E186","v":"SEW - Total to be redistributed - Real"},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"E187","v":"SSC - Total to be redistributed - Real"},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"E188","v":"Total to be redistributed - Real"},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":"E211","v":"ANH - Time value of money factor"},0,"Factor",0,0,1,1,1,1,1,1,1]
[null,null,null,null,{"$f":"E212","v":"HDD - Time value of money factor"},0,"Factor",0,0,1,1,1,1,1,1,1]
[null,null,null,null,{"$f":"E213","v":"NES - Time value of money factor"},0,"Factor",0,0,1,1,1,1,1,1,1]
[null,null,null,null,{"$f":"E214","v":"NWT - Time value of money factor"},0,"Factor",0,0,1,1,1,1,1,1,1]
[null,null,null,null,{"$f":"E215","v":"SRN - Time value of money factor"},0,"Factor",0,0,1,1,1,1,1,1,1]
[null,null,null,null,{"$f":"E216","v":"SVE - Time value of money factor"},0,"Factor",0,0,1,1,1,1,1,1,1]
[null,null,null,null,{"$f":"E217","v":"SWB - Time value of money factor"},0,"Factor",0,0,1,1,1,1,1,1,1]
[null,null,null,null,{"$f":"E218","v":"TMS - Time value of money factor"},0,"Factor",0,0,1,1,1,1,1,1,1]
[null,null,null,null,{"$f":"E219","v":"WSH - Time value of money factor"},0,"Factor",0,0,1,1,1,1,1,1,1]
[null,null,null,null,{"$f":"E220","v":"WSX - Time value of money factor"},0,"Factor",0,0,1,1,1,1,1,1,1]
[null,null,null,null,{"$f":"E221","v":"YKY - Time value of money factor"},0,"Factor",0,0,1,1,1,1,1,1,1]
[null,null,null,null,{"$f":"E222","v":"AFW - Time value of money factor"},0,"Factor",0,0,1,1,1,1,1,1,1]
[null,null,null,null,{"$f":"E223","v":"BRL - Time value of money factor"},0,"Factor",0,0,1,1,1,1,1,1,1]
[null,null,null,null,{"$f":"E224","v":"PRT - Time value of money factor"},0,"Factor",0,0,1,1,1,1,1,1,1]
[null,null,null,null,{"$f":"E225","v":"SES - Time value of money factor"},0,"Factor",0,0,1,1,1,1,1,1,1]
[null,null,null,null,{"$f":"E226","v":"SEW - Time value of money factor"},0,"Factor",0,0,1,1,1,1,1,1,1]
[null,null,null,null,{"$f":"E227","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(J267:P267)","v":0},null,{"$f":" J230 * J249","v":0},{"$f":" K230 * K249","v":0},0,0,0,0,0]
[null,null,null,null,"HDD - Total to be redistributed - Real",null,"£m",{"$f":" SUM(J268:P268)","v":0},null,{"$f":" J231 * J250","v":0},0,0,0,0,0,0]
[null,null,null,null,"NES - Total to be redistributed - Real",null,"£m",0,null,{"$f":" J232 * J251","v":0},0,0,0,0,0,0]
[null,null,null,null,"NWT - Total to be redistributed - Real",null,"£m",0,null,{"$f":" J233 * J252","v":0},0,0,0,0,0,0]
[null,null,null,null,"SRN - Total to be redistributed - Real",null,"£m",0,null,{"$f":" J234 * J253","v":0},0,0,0,0,0,0]
[null,null,null,null,"SVE - Total to be redistributed - Real",null,"£m",0,null,{"$f":" J235 * J254","v":0},0,0,0,0,0,0]
[null,null,null,null,"SWB - Total to be redistributed - Real",null,"£m",0,null,{"$f":" J236 * J255","v":0},0,0,0,0,0,0]
[null,null,null,null,"TMS - Total to be redistributed - Real",null,"£m",0,null,{"$f":" J237 * J256","v":0},0,0,0,0,0,0]
[null,null,null,null,"WSH - Total to be redistributed - Real",null,"£m",0,null,{"$f":" J238 * J257","v":0},0,0,0,0,0,0]
[null,null,null,null,"WSX - Total to be redistributed - Real",null,"£m",0,null,{"$f":" J239 * J258","v":0},0,0,0,0,0,0]
[null,null,null,null,"YKY - Total to be redistributed - Real",null,"£m",0,null,{"$f":" J240 * J259","v":0},0,0,0,0,0,0]
[null,null,null,null,"AFW - Total to be redistributed - Real",null,"£m",0,null,{"$f":" J241 * J260","v":0},0,0,0,0,0,0]
[null,null,null,null,"BRL - Total to be redistributed - Real",null,"£m",0,null,{"$f":" J242 * J261","v":0},0,0,0,0,0,0]
[null,null,null,null,"PRT - Total to be redistributed - Real",null,"£m",0,null,{"$f":" J243 * J262","v":0},0,0,0,0,0,0]
[null,null,null,null,"SES - Total to be redistributed - Real",null,"£m",0,null,{"$f":" J244 * J263","v":0},0,0,0,0,0,0]
[null,null,null,null,"SEW - Total to be redistributed - Real",null,"£m",0,null,{"$f":" J245 * J264","v":0},0,0,0,0,0,0]
[null,null,null,null,"SSC - Total to be redistributed - Real",null,"£m",0,null,{"$f":" J246 * J265","v":0},0,0,0,0,0,0]
[null,null,null,null,"Industry - Total to be redistributed - Real",null,"£m",0,null,{"$f":" SUM(J267:J283)","v":0},{"$f":" SUM(K267:K283)","v":0},{"$f":" SUM(L267:L283)","v":0},{"$f":" SUM(M267:M283)","v":0},{"$f":" SUM(N267:N283)","v":0},{"$f":" SUM(O267:O283)","v":0},{"$f":" SUM(P267:P283)","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'!E267","v":"ANH - Total to be redistributed - Real"},{"$f":"'Innovation funding return'!H267","v":0},{"$f":"'Innovation funding return'!G267","v":"£m"}]
[null,null,null,null,{"$f":"'Innovation funding return'!E268","v":"HDD - Total to be redistributed - Real"},{"$f":"'Innovation funding return'!H268","v":0},{"$f":"'Innovation funding return'!G268","v":"£m"}]
[null,null,null,null,{"$f":"'Innovation funding return'!E269","v":"NES - Total to be redistributed - Real"},{"$f":"'Innovation funding return'!H269","v":0},{"$f":"'Innovation funding return'!G269","v":"£m"}]
[null,null,null,null,{"$f":"'Innovation funding return'!E270","v":"NWT - Total to be redistributed - Real"},{"$f":"'Innovation funding return'!H270","v":0},{"$f":"'Innovation funding return'!G270","v":"£m"}]
[null,null,null,null,{"$f":"'Innovation funding return'!E271","v":"SRN - Total to be redistributed - Real"},{"$f":"'Innovation funding return'!H271","v":0},{"$f":"'Innovation funding return'!G271","v":"£m"}]
[null,null,null,null,{"$f":"'Innovation funding return'!E272","v":"SVE - Total to be redistributed - Real"},{"$f":"'Innovation funding return'!H272","v":0},{"$f":"'Innovation funding return'!G272","v":"£m"}]
[null,null,null,null,{"$f":"'Innovation funding return'!E273","v":"SWB - Total to be redistributed - Real"},{"$f":"'Innovation funding return'!H273","v":0},{"$f":"'Innovation funding return'!G273","v":"£m"}]
[null,null,null,null,{"$f":"'Innovation funding return'!E274","v":"TMS - Total to be redistributed - Real"},{"$f":"'Innovation funding return'!H274","v":0},{"$f":"'Innovation funding return'!G274","v":"£m"}]
[null,null,null,null,{"$f":"'Innovation funding return'!E275","v":"WSH - Total to be redistributed - Real"},{"$f":"'Innovation funding return'!H275","v":0},{"$f":"'Innovation funding return'!G275","v":"£m"}]
[null,null,null,null,{"$f":"'Innovation funding return'!E276","v":"WSX - Total to be redistributed - Real"},{"$f":"'Innovation funding return'!H276","v":0},{"$f":"'Innovation funding return'!G276","v":"£m"}]
[null,null,null,null,{"$f":"'Innovation funding return'!E277","v":"YKY - Total to be redistributed - Real"},{"$f":"'Innovation funding return'!H277","v":0},{"$f":"'Innovation funding return'!G277","v":"£m"}]
[null,null,null,null,{"$f":"'Innovation funding return'!E278","v":"AFW - Total to be redistributed - Real"},{"$f":"'Innovation funding return'!H278","v":0},{"$f":"'Innovation funding return'!G278","v":"£m"}]
[null,null,null,null,{"$f":"'Innovation funding return'!E279","v":"BRL - Total to be redistributed - Real"},{"$f":"'Innovation funding return'!H279","v":0},{"$f":"'Innovation funding return'!G279","v":"£m"}]
[null,null,null,null,{"$f":"'Innovation funding return'!E280","v":"PRT - Total to be redistributed - Real"},{"$f":"'Innovation funding return'!H280","v":0},{"$f":"'Innovation funding return'!G280","v":"£m"}]
[null,null,null,null,{"$f":"'Innovation funding return'!E281","v":"SES - Total to be redistributed - Real"},{"$f":"'Innovation funding return'!H281","v":0},{"$f":"'Innovation funding return'!G281","v":"£m"}]
[null,null,null,null,{"$f":"'Innovation funding return'!E282","v":"SEW - Total to be redistributed - Real"},{"$f":"'Innovation funding return'!H282","v":0},{"$f":"'Innovation funding return'!G282","v":"£m"}]
[null,null,null,null,{"$f":"'Innovation funding return'!E283","v":"SSC - Total to be redistributed - Real"},{"$f":"'Innovation funding return'!H283","v":0},{"$f":"'Innovation funding return'!G283","v":"£m"}]
[]
[null,null,null,null,{"$f":"'Innovation funding return'!E284","v":"Industry - Total to be redistributed - Real"},{"$f":"'Innovation funding return'!H284","v":0},{"$f":"'Innovation funding return'!G284","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":16,"n_cols":16,"rows_kept":16,"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:F14)","v":0},"check"]
[]
["[Do not delete]"]
[]
[null,null,null,null,{"$f":"'Innovation funding return'!E189","v":"Negative funding check"},{"$f":"'Innovation funding return'!F189","v":0},{"$f":"'Innovation funding return'!G189","v":"check"}]
[]
["[Do not delete]"]
[]
["END OF SHEET"]