{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Summary","Instructions&Contents","Economic Case","Financial Case","Project Costs","Risk Retained","Outputs","Risk Register","Land values","GDP Deflators","B3"],"not_rendered":{"charts":5,"images":4,"macros":1,"external_links":3,"defined_names":23,"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":"Summary","index":0,"n_rows":45,"n_cols":7,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"East Riding Enterprise Zone Retained Business Rates Grant Documentation ",null,null,null,null,"Instructions & Contents"]
[null,"Appendix - Financial and outputs tables",null,null,null,null,"Instructions & Contents"]
[]
[null,null,null,null,null,null,"Output tables"]
[null,"Project name as it appears on your main business case/expression of interest form:",null,null,null,null,"Economic Case"]
[null,"Project name as it appears on your main business case/expression of interest form:",null,null,"enter the name of your project here",null,"Financial Case"]
[]
[null,"Select your project location",null,null,null,null,"Data"]
[null,"East Riding",null,null,"choose from one of the locations",null,"Project Costs"]
[null,null,null,null,null,null,"Outputs"]
[null,"Project reference (if known):",null,null,null,null,"Retained Risk"]
[null,"Ref",null,null,null,null,"Risk Register"]
[]
[null,"Date completed:"]
[]
[]
[null,"Name of person completing the form:"]
[]
[]
[null,"Name of organisation:"]
[]
[]
[null,"Email address:"]
[]
[]
[null,"Telephone number:"]
[]
[]
[]
[]
["Checks"]
[]
["Total spend = total funding"]
["is",{"$f":"ROUND(+'Financial Case'!C73,0)=0","v":true},null,null,"do not submit until this is green"]
["Checklist has been completed"]
["is",{"$f":"+AND('Instructions&Contents'!D11:D14)","v":false},null,null,"do not submit until this is green"]
["Value for money category"]
["is",{"$f":"+'Economic Case'!E73","v":{"$error":"#DIV/0!"}},null,null,"a poor vfm category is unlikely to be funded by the LEP. You may wish to consider whether there are any other benefits to include or and non-financial benefits that need to be included"]
[]
[null,{"$f":"+IF('Economic Case'!E68<1,\"A poor vfm category is unlikely to be funded by the LEP. You may wish to consider whether there are any other benefits you can include as part of the project to improve this rating or any non-financial benefits that can be included\",\"\")","v":{"$error":"#DIV/0!"}}]
[]
["Overall"]
["is",{"$f":"+B36=B38=TRUE","v":false},null,null,"do not submit until this is green"]

{"sheet":"Instructions&Contents","index":1,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[{"$f":"+Summary!$B$8","v":"Project name as it appears on your main business case/expression of interest form:"},null,null,null,"clicking on this in any worksheet will take you to the summary tab"]
[null,"Description",null,true]
[null,null,null,false]
[null,"Comments","Completed by","Completed?","Notes"]
[null,null,null,"update when completed"]
["Output tables"]
["Economic Case","This table shows the value for money outputs based on your data",null,null,"If the project has already undertaken a fully compliant Green Book process, or is being evaluated through (eg) WebTAG or FDGiA then please provide that economic case instead"]
["Financial Case","This table shows the financial summary based on your data",null,null,"This summarises the information you put in the tabs below."]
[]
["Data",null,null,null,"Comments (enter your comments below if appropriate)"]
["Project Costs","Enter your data on the costs and funding of the project. This should include (where relevant) future costs such as maintenance.","Applicant",false]
["Outputs","This form is where you need to quantify your expected outputs over the life of the project. It also allows you to value the benefits the project brings. Some are preset where we have national values but you can add others as you feel is appropriate. This links directly to the VfM case so it is important to include all outputs and concommitant benefits associated with your project.","Applicant",false]
["Retained Risk","this form allows you to include the risks that are not included in the project costs. This forms part fo the project assessment overall.","Applicant",false]
["Risk Register","This is a project specific risk register that you need to complete","Applicant",false]

{"sheet":"Economic Case","index":2,"n_rows":117,"n_cols":7,"rows_kept":117,"cut":false,"hidden":false,"merged":[[8,2,8,4],[5,0,5,4],[6,0,6,4],[108,0,108,4],[82,6,83,6],[70,2,70,4]]}
[{"$f":"+Summary!$B$8","v":"Project name as it appears on your main business case/expression of interest form:"},null,null,null,null,null,"Notes"]
["Economic Case"]
[]
[]
[]
["IF THE PROJECT HAS ALREADY UNDERTAKEN A FULLY COMPLIANT GREEN BOOK PROCESS PLEASE PROVIDE THAT REPORT INSTEAD OF COMPLETING THESE DETAILS."]
["THIS INCLUDES TRANSPORT PROJECTS EVALUATED THROUGH WEB-TAG OR ENVIRONMENT AGENCY SCHEMES."]
[]
[]
[null,null,"Undiscounted ",null,"Net Present Value"]
[null,null,"(£)",null,"(£)"]
[]
["Benefits for initial BCR",null,null,null,null,null,"This is attempting to capture the monetized market benefits"]
["Uplift in land value",null,{"$f":"+Outputs!BD79+Outputs!BD80+Outputs!BD81","v":0},null,{"$f":"+Outputs!BF79+Outputs!BF80+Outputs!BF81","v":0},null,"this links directly to the outputs sheet"]
[]
[null,"A",{"$f":"+SUM(C13:C15)","v":0},null,{"$f":"+SUM(E13:E15)","v":0}]
[]
["Benefits for adjusted BCR",null,null,null,null,null,"This is attempting to capture the monetized non-market benefits"]
[]
["Job Creation & Safeguarding (GVA per job)"]
["Jobs created",null,{"$f":"+Outputs!BD12","v":0},null,{"$f":"+Outputs!BF12","v":0},null,"this links directly to the outputs sheet"]
["Jobs Safeguarded",null,{"$f":"+Outputs!BD16","v":0},null,{"$f":"+Outputs!BF16","v":0},null,"this links directly to the outputs sheet"]
["less displacement",{"$f":"Outputs!AE20","v":0.25},{"$f":"SUM(C21:C22)*-$B$23","v":0},null,{"$f":"SUM(E21:E22)*-$B$23","v":0},null,"please amend %age if appropriate"]
[]
["Construction jobs",null,{"$f":"+Outputs!BD18","v":0},null,{"$f":"+Outputs!BF18","v":0},null,"this links directly to the outputs sheet"]
[]
["Housing"]
["Amenity value of new residential land",null,{"$f":"+Outputs!BD83","v":0},null,{"$f":"+Outputs!BF83","v":0},null,"this links directly to the outputs sheet"]
["New Homes Bonus",null,{"$f":"+Outputs!BD37","v":0},null,{"$f":"+Outputs!BF37","v":0},null,"this links directly to the outputs sheet. Note: directly benefits the LA. If included in project costs this needs to be set to £0"]
["Affordable Homes Bonus",null,{"$f":"+Outputs!BD38","v":0},null,{"$f":"+Outputs!BF38","v":0},null,{"$f":"+G29","v":"this links directly to the outputs sheet. Note: directly benefits the LA. If included in project costs this needs to be set to £0"}]
["Health benefits of additional affordable housing",null,{"$f":"+Outputs!BD40","v":0},null,{"$f":"+Outputs!BF40","v":0},null,"this links directly to the outputs sheet"]
[]
["Transport"]
["Walking & cycling",null,{"$f":"+Outputs!BD47","v":0},null,{"$f":"+Outputs!BF47","v":0},null,"this links directly to the outputs sheet"]
[]
["Skills"]
["Qualifications completed",null,{"$f":"+Outputs!BD63","v":0},null,{"$f":"+Outputs!BF63","v":0},null,"this links directly to the outputs sheet"]
["Apprenticeships completed",null,{"$f":"+Outputs!BD70","v":0},null,{"$f":"+Outputs!BF70","v":0},null,"this links directly to the outputs sheet"]
[]
["Others"]
["Commercial floorspace developed",null,{"$f":"+Outputs!BD86+Outputs!BD90+Outputs!BD94","v":0},null,{"$f":"+Outputs!BF86+Outputs!BF90+Outputs!BF94","v":0},null,"this links directly to the outputs sheet"]
[{"$f":"+Outputs!B113","v":"Community Space (D1 & D2 uses) Sqm"},null,{"$f":"+Outputs!BD113","v":0},null,{"$f":"+Outputs!BF113","v":0},null,"this links directly to the outputs sheet"]
[]
[{"$f":"+Outputs!B116","v":"uplift in business rates"},null,{"$f":"+Outputs!BD116","v":0},null,{"$f":"+Outputs!BF116","v":0},null,{"$f":"+$G$42","v":"this links directly to the outputs sheet"}]
[{"$f":"+Outputs!B117","v":"please list"},null,{"$f":"+Outputs!BD117","v":0},null,{"$f":"+Outputs!BF117","v":0},null,{"$f":"+$G$42","v":"this links directly to the outputs sheet"}]
[{"$f":"+Outputs!B118","v":"please list"},null,{"$f":"+Outputs!BD118","v":0},null,{"$f":"+Outputs!BF118","v":0},null,{"$f":"+$G$42","v":"this links directly to the outputs sheet"}]
[{"$f":"+Outputs!B119","v":"please list"},null,{"$f":"+Outputs!BD119","v":0},null,{"$f":"+Outputs!BF119","v":0},null,{"$f":"+$G$42","v":"this links directly to the outputs sheet"}]
[{"$f":"+Outputs!B120","v":"please list"},null,{"$f":"+Outputs!BD120","v":0},null,{"$f":"+Outputs!BF120","v":0},null,{"$f":"+$G$42","v":"this links directly to the outputs sheet"}]
[{"$f":"+Outputs!B121","v":"please list"},null,{"$f":"+Outputs!BD121","v":0},null,{"$f":"+Outputs!BF121","v":0},null,{"$f":"+$G$42","v":"this links directly to the outputs sheet"}]
[{"$f":"+Outputs!B122","v":"please list"},null,{"$f":"+Outputs!BD122","v":0},null,{"$f":"+Outputs!BF122","v":0},null,"this links directly to the outputs sheet"]
[{"$f":"+Outputs!B123","v":"please list"},null,{"$f":"+Outputs!BD123","v":0},null,{"$f":"+Outputs!BF123","v":0},null,"this links directly to the outputs sheet"]
[{"$f":"+Outputs!B124","v":"please list"},null,{"$f":"+Outputs!BD124","v":0},null,{"$f":"+Outputs!BF124","v":0},null,"this links directly to the outputs sheet"]
[]
[]
[null,"B",{"$f":"+SUM(C18:C54)","v":0},null,{"$f":"+SUM(E18:E54)","v":0}]
[]
["Public sector cost"]
["GBF Cost","C",{"$f":"+'Project Costs'!AG87","v":0},null,{"$f":"+'Project Costs'!AI87","v":0}]
["Other Public Sector cost","D",{"$f":"+C99","v":0},null,{"$f":"+E99","v":0}]
[null,"E",{"$f":"+SUM(C57:C59)","v":0},null,{"$f":"+SUM(E57:E59)","v":0}]
[]
["Private Sector Funding","F"]
[]
["Initial BCR - GBF Funding only",null,"= (A-D-F) / C",null,{"$f":"+(E16-E59-E62)/E58","v":{"$error":"#DIV/0!"}}]
["Initial BCR - public sector funding",null,"= A / E",null,{"$f":"+E16/E60","v":{"$error":"#DIV/0!"}}]
[]
["Adjusted BCR - GBF Only",null,"= (A+B-F) / C",null,{"$f":"+(E16+E55-E62)/E58","v":{"$error":"#DIV/0!"}}]
["Adjusted BCR - public sector funding",null,"= (A+B-F) / E",null,{"$f":"+(E16+E55-E62)/E60","v":{"$error":"#DIV/0!"}}]
[]
[]
["Significant non-monetised impacts",null,"include & explain any such benefits in the word document"]
[]
["value for money category",null,null,null,{"$f":"+IF(E68<1,\"poor value for money\",IF(E68<2,\"acceptable value for money\",\"good value for money\"))","v":{"$error":"#DIV/0!"}},null,"automatic calculation"]
[]
[]
[]
[]
["Costs"]
["Capital costs",null,{"$f":"+'Project Costs'!AG72","v":0},null,{"$f":"+'Project Costs'!AI72","v":0},null,"this links directly to the project costs sheet"]
["Revenue costs",null,{"$f":"+'Project Costs'!AG73","v":0},null,{"$f":"+'Project Costs'!AI73","v":0},null,"this links directly to the project costs sheet"]
[null,null,{"$f":"+SUM(C79:C80)","v":0},null,{"$f":"+SUM(E79:E80)","v":0}]
["Retained risk",null,null,null,{"$f":"+'Risk Retained'!D15","v":0},null,"this links directly to the risks retained sheet"]
["Optimism bias",null,{"$f":"+'Project Costs'!BH70","v":0},null,{"$f":"+'Project Costs'!BJ70","v":0},null,"this links directly to the project costs sheet - this is appropriate for straightforward projects. For more complex projects a full OB exercise would be required."]
[null,null,{"$f":"+SUM(C81:C83)","v":0},null,{"$f":"+SUM(E81:E83)","v":0}]
[]
["GBF Cost"]
["Getting Building Fund",null,{"$f":"'Project Costs'!AG87","v":0},null,{"$f":"'Project Costs'!AI87","v":0}]
[null,null,{"$f":"+SUM(C85:C87)","v":0},null,{"$f":"+SUM(E85:E87)","v":0}]
[]
["Other Public Sector cost"]
["Local Authority",null,{"$f":"+'Project Costs'!AG94","v":0},null,{"$f":"+'Project Costs'!AI94","v":0}]
["Other Government Agencies",null,{"$f":"+'Project Costs'!AG100","v":0},null,{"$f":"+'Project Costs'!AI100","v":0}]
["Other public",null,{"$f":"+'Project Costs'!AG106","v":0},null,{"$f":"+'Project Costs'!AI106","v":0}]
["Third sector",null,{"$f":"'Project Costs'!AG112","v":0},null,{"$f":"'Project Costs'!AI112","v":0}]
["European",null,{"$f":"+'Project Costs'!AG118","v":0},null,{"$f":"+'Project Costs'!AI118","v":0}]
[null,null,{"$f":"SUM(C91:C95)","v":0},null,{"$f":"SUM(E91:E95)","v":0}]
["Risk",1,{"$f":"$B97*'Economic Case'!C$82","v":0},null,{"$f":"$B97*'Economic Case'!E$82","v":0},null,"allocated between OPS & Private sector according to percentages input"]
["Optimism bias",1,{"$f":"$B98*'Economic Case'!C$83","v":0},null,{"$f":"$B98*'Economic Case'!E$83","v":0},null,"this needs to be properly considered as to where this sits"]
[null,null,{"$f":"+SUM(C96:C98)","v":0},null,{"$f":"+SUM(E96:E98)","v":0},null,"other public sector as default"]
[]
["Private sector"]
["Private sector",null,{"$f":"'Project Costs'!AG127","v":0},null,{"$f":"'Project Costs'!AI127","v":0}]
["Risk",{"$f":"100%-B97","v":0},{"$f":"$B103*'Economic Case'!C$82","v":0},null,{"$f":"$B103*'Economic Case'!E$82","v":0},null,"please amend %age if appropriate"]
["Optimism bias",{"$f":"100%-B98","v":0},{"$f":"$B104*'Economic Case'!C$83","v":0},null,{"$f":"$B104*'Economic Case'!E$83","v":0},null,"please amend %age if appropriate"]
[null,null,{"$f":"+SUM(C101:C104)","v":0},null,{"$f":"+SUM(E101:E104)","v":0}]
[]
[]
[]
[{"$f":"+A6&\" \"&A7","v":"IF THE PROJECT HAS ALREADY UNDERTAKEN A FULLY COMPLIANT GREEN BOOK PROCESS PLEASE PROVIDE THAT REPORT INSTEAD OF COMPLETING THESE DETAILS. THIS INCLUDES TRANSPORT PROJECTS EVALUATED THROUGH WEB-TAG OR ENVIRONMENT AGENCY SCHEMES."}]
[]
[]
[null,null,null,null,null,null,"Optimism Bias"]
[null,null,null,null,null,null,"There is a demonstrated, systematic, tendency for project appraisers to be overly optimistic. This is a worldwide phenomenon that affects both the private and public sectors. Many project parameters are affected by optimism – appraisers tend to overstate benefits, and understate timings and costs, both capital and operational."]
[null,null,null,null,null,null,"To redress this tendency, appraisers should make explicit adjustments for this bias. These will take the form of increasing estimates of the costs and decreasing, and delaying the receipt of, estimated benefits. Sensitivity analysis should be used to test assumptions about operating costs and expected benefits."]
[null,null,null,null,null,null,"Adjustments should be empirically based, (e.g. using data from past projects or similar projects elsewhere), and adjusted for the unique characteristics of the project in hand. Cross-departmental guidance for generic project categories is available, and should be used in the absence of more specific evidence.But if departments or agencies have a more robust evidence base for cost overruns and other instances of bias, this evidence should be used in preference. When such information is not available, departments are encouraged to collect data to inform their estimates of optimism, and in the meantime use the available data that best fits the case in hand."]
[null,null,null,null,null,null,"Adjusting for optimism should provide a better estimate, earlier on, of key project parameters. Enforcing these adjustments for optimism bias is designed to complement and encourage, rather than replace, existing good practice, in terms of calculating project specific risk adjustments.They are also designed to encourage more accurate costing. Accordingly, adjustments for optimism may be reduced as more reliable estimates of relevant costs are built up, and project specific risk work is undertaken. Both cost estimates and adjustments for optimism should be independently reviewed before decisions are taken."]
[null,null,null,null,null,null,"This model uses the assumptions developed in the Manchester New Economy Model but for more complex projects - and only where a full compliant Green Book exercise has been undertaken - then the outputs from that should be included instead of this form."]

{"sheet":"Financial Case","index":3,"n_rows":75,"n_cols":14,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
[{"$f":"+Summary!$B$8","v":"Project name as it appears on your main business case/expression of interest form:"}]
["financial case"]
[]
[null,null,"Total costs",null,"NPV",null,null,null,null,"Capital","Revenue"]
["Total project costs",null,null,null,null,null,null,null,null,{"$f":"+J12/SUM($J$12:$K$12)","v":{"$error":"#DIV/0!"}},{"$f":"+K12/SUM($J$12:$K$12)","v":{"$error":"#DIV/0!"}}]
[{"$f":"+'Project Costs'!A64","v":"Direct project costs"},null,{"$f":"+'Project Costs'!AG64","v":0},null,{"$f":"+'Project Costs'!AI64","v":0},null,null,null,null,{"$f":"+C6","v":0},{"$f":"+C6-J6","v":0}]
[{"$f":"+'Project Costs'!A65","v":"Ongoing maintenance costs"},null,{"$f":"+'Project Costs'!AG65","v":0},null,{"$f":"+'Project Costs'!AI65","v":0},null,null,null,null,null,{"$f":"+C7-J7","v":0}]
[{"$f":"+'Project Costs'!A66","v":"Other ongoing costs or (savings)"},null,{"$f":"+'Project Costs'!AG66","v":0},null,{"$f":"+'Project Costs'!AI66","v":0},null,null,null,null,null,0]
[{"$f":"+'Project Costs'!A67","v":"Grants to third parties"},null,{"$f":"+'Project Costs'!AG67","v":0},null,{"$f":"+'Project Costs'!AI67","v":0},null,null,null,null,{"$f":"+C9","v":0},0]
[{"$f":"+'Project Costs'!A68","v":"Project Overheads"},null,{"$f":"+'Project Costs'!AG68","v":0},null,{"$f":"+'Project Costs'!AI68","v":0},null,null,null,null,0,0]
[{"$f":"+'Project Costs'!A69","v":"Contingency"},null,{"$f":"+'Project Costs'!AG69","v":0},null,{"$f":"+'Project Costs'!AI69","v":0},null,null,null,null,0,0]
[null,null,{"$f":"+SUM(C6:C11)","v":0},null,{"$f":"+SUM(E6:E11)","v":0},null,null,null,null,{"$f":"+SUM(J6:J11)","v":0},0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["How funded",null,null,null,null,null,null,null,"Approved","Approved subject to conditions","Approved in principle","Request/bid submitted","Speculative","Total"]
[{"$f":"+'Project Costs'!A131","v":"Enterprise Zone Retained Business Rates Grant Fund"},null,{"$f":"+'Project Costs'!AG131","v":0},null,{"$f":"+'Project Costs'!AI131","v":0},null,{"$f":"+E64/$E$71","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"+C64","v":0},null,{"$f":"+SUM(I64:M64)","v":0}]
[{"$f":"+'Project Costs'!A132","v":"Local Authority"},null,{"$f":"+'Project Costs'!AG132","v":0},null,{"$f":"+'Project Costs'!AI132","v":0},null,{"$f":"+E65/$E$71","v":{"$error":"#DIV/0!"}},null,{"$f":"+'Project Costs'!AG152","v":0},{"$f":"+'Project Costs'!AG153","v":0},{"$f":"+'Project Costs'!AG154","v":0},{"$f":"+'Project Costs'!AG155","v":0},{"$f":"+'Project Costs'!AG156","v":0},0]
[{"$f":"+'Project Costs'!A133","v":"Other Government Agencies"},null,{"$f":"+'Project Costs'!AG133","v":0},null,{"$f":"+'Project Costs'!AI133","v":0},null,{"$error":"#DIV/0!"},null,{"$f":"+'Project Costs'!AG160","v":0},{"$f":"+'Project Costs'!AG161","v":0},{"$f":"+'Project Costs'!AG162","v":0},{"$f":"+'Project Costs'!AG163","v":0},{"$f":"+'Project Costs'!AG164","v":0},0]
[{"$f":"+'Project Costs'!A134","v":"Other public sector"},null,{"$f":"+'Project Costs'!AG134","v":0},null,{"$f":"+'Project Costs'!AI134","v":0},null,{"$error":"#DIV/0!"},null,{"$f":"+'Project Costs'!AG167","v":0},{"$f":"+'Project Costs'!AG168","v":0},{"$f":"+'Project Costs'!AG169","v":0},{"$f":"+'Project Costs'!AG170","v":0},{"$f":"+'Project Costs'!AG171","v":0},0]
[{"$f":"+'Project Costs'!A135","v":"Third sector"},null,{"$f":"+'Project Costs'!AG135","v":0},null,{"$f":"+'Project Costs'!AI135","v":0},null,{"$error":"#DIV/0!"},null,{"$f":"+'Project Costs'!AG174","v":0},{"$f":"+'Project Costs'!AG175","v":0},{"$f":"+'Project Costs'!AG176","v":0},{"$f":"+'Project Costs'!AG177","v":0},{"$f":"+'Project Costs'!AG178","v":0},0]
[{"$f":"+'Project Costs'!A136","v":"European Funding"},null,{"$f":"+'Project Costs'!AG136","v":0},null,{"$f":"+'Project Costs'!AI136","v":0},null,{"$error":"#DIV/0!"},null,{"$f":"+'Project Costs'!AG181","v":0},{"$f":"+'Project Costs'!AG182","v":0},{"$f":"+'Project Costs'!AG183","v":0},{"$f":"+'Project Costs'!AG184","v":0},{"$f":"+'Project Costs'!AG185","v":0},0]
[{"$f":"+'Project Costs'!A137","v":"Private sector"},null,{"$f":"+'Project Costs'!AG137","v":0},null,{"$f":"+'Project Costs'!AI137","v":0},null,{"$error":"#DIV/0!"},null,{"$f":"+'Project Costs'!AG188","v":0},{"$f":"+'Project Costs'!AG189","v":0},{"$f":"+'Project Costs'!AG190","v":0},{"$f":"+'Project Costs'!AG191","v":0},{"$f":"+'Project Costs'!AG192","v":0},0]
[null,null,{"$f":"+SUM(C64:C70)","v":0},null,{"$f":"+SUM(E64:E70)","v":0},null,null,null,{"$f":"+SUM(I64:I70)","v":0},0,0,0,0,0]
[]
["Difference",null,{"$f":"+C12-C71","v":0},null,{"$f":"+E12-E71","v":0},null,null,null,{"$f":"+I71/$N$71","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["GBF as a percentage of capital costs",null,{"$f":"+C64/SUM(C6,C9:C11)","v":{"$error":"#DIV/0!"}},null,{"$f":"+E64/SUM(E6,E9:E11)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Project Costs","index":4,"n_rows":199,"n_cols":62,"rows_kept":199,"cut":false,"hidden":false,"merged":[[56,1,60,1],[80,1,81,1],[84,1,86,1],[11,1,26,1],[28,1,32,1],[34,1,42,1],[44,1,48,1],[50,1,54,1],[7,4,8,4],[7,5,8,5],[7,0,8,0],[7,3,8,3],[7,1,8,1],[7,40,7,43],[7,44,7,58],[7,59,8,59],[7,61,8,61],[7,7,7,10],[7,11,7,31],[7,32,8,32],[7,34,8,34],[80,32,81,32],[80,34,81,34],[88,1,93,1],[95,1,99,1],[80,0,81,0],[80,3,81,3],[80,4,81,4],[80,5,81,5],[80,7,80,10],[101,1,105,1],[107,1,111,1],[113,1,117,1],[119,1,126,1],[80,11,80,31]]}
[{"$f":"+Summary!$B$8","v":"Project name as it appears on your main business case/expression of interest form:"}]
["Project Costs",null,null,null,"Independently audited cost data","current",null,0,0,null,null,2020,{"$f":"1+L2","v":2021},{"$f":"1+M2","v":2022},2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,{"$f":"1+X2","v":2033},{"$f":"1+Y2","v":2034},{"$f":"1+Z2","v":2035},{"$f":"1+AA2","v":2036},{"$f":"1+AB2","v":2037},{"$f":"1+AC2","v":2038},{"$f":"1+AD2","v":2039},2040]
[null,null,null,null,"Formal service delivery contract costs","1-2 years",null,0.05,0.05,null,null,{"$f":"1+L2","v":2021},{"$f":"1+M2","v":2022},{"$f":"1+N2","v":2023},2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,{"$f":"1+Y2","v":2034},2035,2036,2037,2038,2039,2040,2041]
[null,null,null,null,"Practitioner monitored costs","2-3 years",null,0.1,0.1]
[null,null,null,null,"Costs developed from ready reckoners","3-4 years",null,0.15,0.15]
[null,null,null,null,"Uncorroborated expert judgement","4/5 years",null,0.4,0.25]
[null,null,null,null,null,">5 years",null,null,0.4]
["Description of Costs","Notes",null,"Basis of calculation?","Data source","Age of data",null,{"$f":"+L9","v":"2020 / 2021"},null,null,null,"Profile (£)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total (£)",null,"NPV (£)",null,null,null,null,null,{"$f":"+L8","v":"Profile (£)"},null,null,null,"Profile (£m)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+AG8","v":"Total (£)"},null,{"$f":"+AI8","v":"NPV (£)"}]
[null,null,null,null,null,null,null,"Qtr 1","Qtr 2","Qtr 3","Qtr 4",{"$f":"+L2&\" / \"&L3","v":"2020 / 2021"},"2021 / 2022","2022 / 2023","2023 / 2024","2024 / 2025","2025 / 2026","2026 / 2027","2027 / 2028","2028 / 2029","2029 / 2030","2030 / 2031","2031 / 2032","2032 / 2033",{"$f":"+Y2&\" / \"&Y3","v":"2033 / 2034"},"2034 / 2035","2035 / 2036","2036 / 2037","2037 / 2038","2038 / 2039","2039 / 2040","2040 / 2041",null,null,null,null,null,null,null,null,"Qtr 1","Qtr 2","Qtr 3","Qtr 4",{"$f":"+L9","v":"2020 / 2021"},"2021 / 2022","2022 / 2023","2023 / 2024","2024 / 2025","2025 / 2026","2026 / 2027","2027 / 2028","2028 / 2029","2029 / 2030","2030 / 2031","2031 / 2032","2032 / 2033",{"$f":"+AE9","v":"2039 / 2040"},"2040 / 2041"]
[null,null,null,"explain how this has been derived. E.g. are they backed by quotes?","who produced the estimate? select from the list","how old is this data? select from the list",null,"£",{"$f":"+H10","v":"£"},{"$f":"+I10","v":"£"},"£","£","£","£","£","£","£","£","£","£","£","£","£","£",{"$f":"+X10","v":"£"},{"$f":"+Y10","v":"£"},{"$f":"+Z10","v":"£"},{"$f":"+AA10","v":"£"},{"$f":"+AB10","v":"£"},{"$f":"+AC10","v":"£"},{"$f":"+AD10","v":"£"},"£",null,null,null,null,null,null,null,null,{"$f":"+H10","v":"£"},{"$f":"+AO10","v":"£"},{"$f":"+AP10","v":"£"},"£","£","£","£","£","£","£","£","£","£","£","£","£","£","£","£"]
[]
["Direct project costs","detail a breakdown of the project costs so this could include for example purchasing land, construction costs, professional fees etc."]
["description",null,null,null,"Independently audited cost data","current",null,null,null,null,null,{"$f":"+SUM(H13:K13)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(L13:AF13)","v":0},null,null,null,{"$f":"+VLOOKUP($E13,$E$2:$I$7,4,0)","v":0},{"$f":"+VLOOKUP($F13,$F$2:$I$7,4,0)","v":0},{"$f":"IF(AG13<>0,MAX(AK13:AL13),0)","v":0},null,{"$f":"+$AM13*H13","v":0},{"$f":"+$AM13*I13","v":0},{"$f":"+$AM13*J13","v":0},{"$f":"+$AM13*K13","v":0},{"$f":"+SUM(AO13:AR13)","v":0},{"$f":"+$AM13*M13","v":0},{"$f":"+$AM13*N13","v":0},{"$f":"+$AM13*O13","v":0},{"$f":"+$AM13*P13","v":0},{"$f":"+$AM13*Q13","v":0},{"$f":"+$AM13*R13","v":0},{"$f":"+$AM13*S13","v":0},{"$f":"+$AM13*T13","v":0},{"$f":"+$AM13*U13","v":0},{"$f":"+$AM13*V13","v":0},{"$f":"+$AM13*W13","v":0},{"$f":"+$AM13*X13","v":0},{"$f":"+$AM13*AE13","v":0},{"$f":"+$AM13*AF13","v":0},{"$f":"+SUM(AS13:BG13)","v":0}]
["description",null,null,null,"Independently audited cost data","current",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,{"$f":"+$AM14*H14","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["description",null,null,null,"Independently audited cost data","current",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["description",null,null,null,"Independently audited cost data","current",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["description",null,null,null,"Independently audited cost data","current",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["description",null,null,null,"Independently audited cost data","current",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["description",null,null,null,"Independently audited cost data","current",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,{"$f":"IF(AG19<>0,MAX(AK19:AL19),0)","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["description",null,null,null,"Independently audited cost data","current",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["description",null,null,null,"Independently audited cost data","current",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["description",null,null,null,"Independently audited cost data","current",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["description",null,null,null,"Independently audited cost data","current",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["description",null,null,null,"Independently audited cost data","current",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["description",null,null,null,"Independently audited cost data","current",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["description",null,null,null,"Independently audited cost data","current",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"+SUM(H13:H26)","v":0},{"$f":"+SUM(I13:I26)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(Y13:Y26)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"+NPV(6.075%,M27:AF27)+L27","v":0},null,null,null,null,null,{"$f":"+SUM(AO13:AO26)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"+NPV(6.075%,AT27:BG27)+AS27","v":0}]
[]
["Ongoing maintenance costs","GBF can not fund these costs",null,null,null,null,null,null,null,null,null,{"$f":"+SUM(H29:K29)","v":0}]
["description",null,null,null,"Uncorroborated expert judgement",">5 years",null,null,null,null,null,{"$f":"+SUM(H30:K30)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(L30:AF30)","v":0},null,null,null,null,null,null,null,{"$f":"+$AM30*H30","v":0},0,0,0,{"$f":"+SUM(AO30:AR30)","v":0},{"$f":"+$AM30*M30","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"+$AM30*AE30","v":0},0,{"$f":"+SUM(AS30:BG30)","v":0}]
["description",null,null,null,"Uncorroborated expert judgement",">5 years",null,null,null,null,null,{"$f":"+SUM(H31:K31)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(L31:AF31)","v":0},null,null,null,null,null,null,null,0,0,0,0,{"$f":"+SUM(AO31:AR31)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(AS31:BG31)","v":0}]
["description",null,null,null,"Uncorroborated expert judgement",">5 years",null,null,null,null,null,{"$f":"+SUM(H32:K32)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(L32:AF32)","v":0},null,null,null,null,null,null,null,0,0,0,0,{"$f":"+SUM(AO32:AR32)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(AS32:BG32)","v":0}]
[null,null,null,null,null,null,null,{"$f":"+SUM(H30:H32)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(Y30:Y32)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"+NPV(6.075%,M33:AF33)+L33","v":0},null,null,null,null,null,{"$f":"+SUM(AO30:AO32)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"+NPV(6.075%,AT33:BG33)+AS33","v":0}]
[]
["Other ongoing costs or (savings)","GBF can not fund these costs. Enter savings as a negative",null,null,null,null,null,null,null,null,null,{"$f":"+SUM(H35:K35)","v":0}]
["description",null,null,null,"Uncorroborated expert judgement",">5 years",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(L36:AF36)","v":0},null,null,null,null,null,null,null,{"$f":"+$AM36*H36","v":0},{"$f":"+$AM36*I36","v":0},{"$f":"+$AM36*J36","v":0},{"$f":"+$AM36*K36","v":0},{"$f":"+SUM(AO36:AR36)","v":0},{"$f":"+$AM36*M36","v":0},{"$f":"+$AM36*N36","v":0},{"$f":"+$AM36*O36","v":0},{"$f":"+$AM36*P36","v":0},{"$f":"+$AM36*Q36","v":0},{"$f":"+$AM36*R36","v":0},{"$f":"+$AM36*S36","v":0},{"$f":"+$AM36*T36","v":0},{"$f":"+$AM36*U36","v":0},{"$f":"+$AM36*V36","v":0},{"$f":"+$AM36*W36","v":0},{"$f":"+$AM36*X36","v":0},{"$f":"+$AM36*AE36","v":0},{"$f":"+$AM36*AF36","v":0},{"$f":"+SUM(AS36:BG36)","v":0}]
["description",null,null,null,"Uncorroborated expert judgement",">5 years",null,null,null,null,null,{"$f":"+SUM(H37:K37)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(L37:AF37)","v":0},null,null,null,null,null,null,null,{"$f":"+$AM37*H37","v":0},0,0,0,{"$f":"+SUM(AO37:AR37)","v":0},{"$f":"+$AM37*M37","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"+$AM37*AE37","v":0},0,{"$f":"+SUM(AS37:BG37)","v":0}]
["description",null,null,null,"Uncorroborated expert judgement",">5 years",null,null,null,null,null,{"$f":"+SUM(H38:K38)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(L38:AF38)","v":0},null,null,null,null,null,null,null,0,0,0,0,{"$f":"+SUM(AO38:AR38)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(AS38:BG38)","v":0}]
["description",null,null,null,"Uncorroborated expert judgement",">5 years",null,null,null,null,null,{"$f":"+SUM(H39:K39)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(L39:AF39)","v":0},null,null,null,null,null,null,null,0,0,0,0,{"$f":"+SUM(AO39:AR39)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(AS39:BG39)","v":0}]
["description",null,null,null,"Uncorroborated expert judgement",">5 years",null,null,null,null,null,{"$f":"+SUM(H40:K40)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(L40:AF40)","v":0},null,null,null,null,null,null,null,0,0,0,0,{"$f":"+SUM(AO40:AR40)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(AS40:BG40)","v":0}]
["description",null,null,null,"Uncorroborated expert judgement",">5 years",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["description",null,null,null,"Uncorroborated expert judgement",">5 years",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"+SUM(H36:H42)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(Y36:Y42)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"+NPV(6.075%,M43:AF43)+L43","v":0},null,null,null,null,null,{"$f":"+SUM(AO36:AO42)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"+NPV(6.075%,AT43:BG43)+AS43","v":0}]
[]
["Grants to third parties","only if the scheme is to give grants directly to other organisations, please use this section",null,null,null,null,null,null,null,null,null,{"$f":"+SUM(H45:K45)","v":0}]
["description",null,null,null,"Uncorroborated expert judgement",">5 years",null,null,null,null,null,{"$f":"+SUM(H46:K46)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(L46:AF46)","v":0},null,null,null,null,null,null,null,{"$f":"+$AM46*H46","v":0},0,0,0,{"$f":"+SUM(AO46:AR46)","v":0},{"$f":"+$AM46*M46","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"+$AM46*AE46","v":0},0,{"$f":"+SUM(AS46:BG46)","v":0}]
["description",null,null,null,"Uncorroborated expert judgement",">5 years",null,null,null,null,null,{"$f":"+SUM(H47:K47)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(L47:AF47)","v":0},null,null,null,null,null,null,null,0,0,0,0,{"$f":"+SUM(AO47:AR47)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(AS47:BG47)","v":0}]
["description",null,null,null,"Uncorroborated expert judgement",">5 years",null,null,null,null,null,{"$f":"+SUM(H48:K48)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(L48:AF48)","v":0},null,null,null,null,null,null,null,0,0,0,0,{"$f":"+SUM(AO48:AR48)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(AS48:BG48)","v":0}]
[null,null,null,null,null,null,null,{"$f":"+SUM(H46:H48)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(Y46:Y48)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"+NPV(6.075%,M49:AF49)+L49","v":0},null,null,null,null,null,{"$f":"+SUM(AO46:AO48)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"+NPV(6.075%,AT49:BG49)+AS49","v":0}]
[]
["Project Overheads","eg project management costs or grant administration. NB these must be capital in nature",null,null,null,null,null,null,null,null,null,{"$f":"+SUM(H51:K51)","v":0}]
["description",null,null,null,"Uncorroborated expert judgement",">5 years",null,null,null,null,null,{"$f":"+SUM(H52:K52)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(L52:AF52)","v":0},null,null,null,{"$f":"+VLOOKUP($E52,$E$2:$I$7,4,0)","v":0.4},{"$f":"+VLOOKUP($F52,$F$2:$I$7,4,0)","v":0.4},{"$f":"IF(AG52<>0,MAX(AK52:AL52),0)","v":0},null,{"$f":"+$AM52*H52","v":0},0,0,0,{"$f":"+SUM(AO52:AR52)","v":0},{"$f":"+$AM52*M52","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"+$AM52*AE52","v":0},0,{"$f":"+SUM(AS52:BG52)","v":0}]
["description",null,null,null,"Uncorroborated expert judgement",">5 years",null,null,null,null,null,{"$f":"+SUM(H53:K53)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(L53:AF53)","v":0},null,null,null,{"$f":"+VLOOKUP($E53,$E$2:$I$7,4,0)","v":0.4},{"$f":"+VLOOKUP($F53,$F$2:$I$7,4,0)","v":0.4},{"$f":"IF(AG53<>0,MAX(AK53:AL53),0)","v":0},null,0,0,0,0,{"$f":"+SUM(AO53:AR53)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(AS53:BG53)","v":0}]
["description",null,null,null,"Uncorroborated expert judgement",">5 years",null,null,null,null,null,{"$f":"+SUM(H54:K54)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(L54:AF54)","v":0},null,null,null,{"$f":"+VLOOKUP($E54,$E$2:$I$7,4,0)","v":0.4},{"$f":"+VLOOKUP($F54,$F$2:$I$7,4,0)","v":0.4},{"$f":"IF(AG54<>0,MAX(AK54:AL54),0)","v":0},null,0,0,0,0,{"$f":"+SUM(AO54:AR54)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(AS54:BG54)","v":0}]
[null,null,null,null,null,null,null,{"$f":"+SUM(H52:H54)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(Y52:Y54)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"+NPV(6.075%,M55:AF55)+L55","v":0},null,null,null,null,null,{"$f":"+SUM(AO52:AO54)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"+NPV(6.075%,AT55:BG55)+AS55","v":0}]
[]
["Contingency","if there is a separate contingency please include it here rather than as part of the above costings",null,null,null,null,null,null,null,null,null,{"$f":"+SUM(H57:K57)","v":0}]
[null,null,null,null,"Uncorroborated expert judgement",">5 years",null,null,null,null,null,{"$f":"+SUM(H58:K58)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(L58:AF58)","v":0},null,null,null,{"$f":"+VLOOKUP($E58,$E$2:$I$7,4,0)","v":0.4},{"$f":"+VLOOKUP($F58,$F$2:$I$7,4,0)","v":0.4},{"$f":"IF(AG58<>0,MAX(AK58:AL58),0)","v":0},null,{"$f":"+$AM58*H58","v":0},0,0,0,{"$f":"+SUM(AO58:AR58)","v":0},{"$f":"+$AM58*M58","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"+$AM58*AE58","v":0},0,{"$f":"+SUM(AS58:BG58)","v":0}]
[null,null,null,null,"Uncorroborated expert judgement",">5 years",null,null,null,null,null,{"$f":"+SUM(H59:K59)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(L59:AF59)","v":0},null,null,null,{"$f":"+VLOOKUP($E59,$E$2:$I$7,4,0)","v":0.4},{"$f":"+VLOOKUP($F59,$F$2:$I$7,4,0)","v":0.4},{"$f":"IF(AG59<>0,MAX(AK59:AL59),0)","v":0},null,0,0,0,0,{"$f":"+SUM(AO59:AR59)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(AS59:BG59)","v":0}]
[null,null,null,null,"Uncorroborated expert judgement",">5 years",null,null,null,null,null,{"$f":"+SUM(H60:K60)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(L60:AF60)","v":0},null,null,null,{"$f":"+VLOOKUP($E60,$E$2:$I$7,4,0)","v":0.4},{"$f":"+VLOOKUP($F60,$F$2:$I$7,4,0)","v":0.4},{"$f":"IF(AG60<>0,MAX(AK60:AL60),0)","v":0},null,0,0,0,0,{"$f":"+SUM(AO60:AR60)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(AS60:BG60)","v":0}]
[null,null,null,null,null,null,null,{"$f":"+SUM(H58:H60)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(Y58:Y60)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"+NPV(6.075%,M61:AF61)+L61","v":0},null,null,null,null,null,{"$f":"+SUM(AO58:AO60)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"+NPV(6.075%,AT61:BG61)+AS61","v":0}]
[]
["Summary"]
[{"$f":"+A12","v":"Direct project costs"},null,null,null,null,null,null,{"$f":"+H27","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+Y27","v":0},0,0,0,0,0,0,0,0,null,{"$f":"+NPV(6.075%,M64:AF64)+L64","v":0},null,null,null,null,null,{"$f":"+AO27","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"+NPV(6.075%,AT64:BG64)+AS64","v":0}]
[{"$f":"+A29","v":"Ongoing maintenance costs"},null,null,null,null,null,null,{"$f":"+H33","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+Y33","v":0},0,0,0,0,0,0,0,0,null,0,null,null,null,null,null,{"$f":"+AO28","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"+NPV(6.075%,AT65:BG65)+AS65","v":0}]
[{"$f":"+A35","v":"Other ongoing costs or (savings)"},null,null,null,null,null,null,{"$f":"+H43","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+Y43","v":0},0,0,0,0,0,0,0,0,null,0,null,null,null,null,null,{"$f":"+AO29","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"+NPV(6.075%,AT66:BG66)+AS66","v":0}]
[{"$f":"+A45","v":"Grants to third parties"},null,null,null,null,null,null,{"$f":"+H49","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+Y49","v":0},0,0,0,0,0,0,0,0,null,0,null,null,null,null,null,{"$f":"+AO49","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[{"$f":"+A51","v":"Project Overheads"},null,null,null,null,null,null,{"$f":"+H55","v":0},{"$f":"+I55","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+Y55","v":0},0,0,0,0,0,0,0,0,null,0,null,null,null,null,null,{"$f":"+AO55","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[{"$f":"+A57","v":"Contingency"},null,null,null,null,null,null,{"$f":"+H61","v":0},{"$f":"+I61","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+Y61","v":0},0,0,0,0,0,0,0,0,null,0,null,null,null,null,null,{"$f":"+AO61","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,null,null,null,null,null,{"$f":"+SUM(H64:H69)","v":0},{"$f":"+SUM(I64:I69)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(Y64:Y69)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"+NPV(6.075%,M70:AF70)+L70","v":0},null,null,null,null,null,{"$f":"+SUM(AO64:AO69)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"+NPV(6.075%,AT70:BG70)+AS70","v":0}]
[]
["Capital",null,null,null,null,null,null,{"$f":"+H70-H73","v":0},{"$f":"+I70-I73","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+Y70-Y73","v":0},0,0,0,0,0,0,0,0,null,{"$f":"+NPV(6.075%,M72:AF72)+L72","v":0}]
["Revenue",null,null,null,null,null,null,{"$f":"+H65+H66","v":0},{"$f":"+I65+I66","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+Y65+Y66","v":0},0,0,0,0,0,0,0,{"$f":"+AG65+AG66","v":0},null,{"$f":"+NPV(6.075%,M73:AF73)+L73","v":0}]
[null,null,null,null,null,null,null,{"$f":"+SUM(H72:H73)","v":0},{"$f":"+SUM(I72:I73)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(Y72:Y73)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"+SUM(AI72:AI73)","v":0}]
[]
[null,null,null,"Approved"]
[null,null,null,"Approved subject to conditions"]
[null,null,null,"Approved in principle"]
[null,null,null,"Request/bid submitted"]
[null,null,null,"Speculative"]
["Name of Funder","Notes",null,"Status","Link to supporting notes",null,null,{"$f":"+L82","v":"2020 / 2021"},null,null,null,{"$f":"+L8","v":"Profile (£)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+AG8","v":"Total (£)"},null,{"$f":"+AI8","v":"NPV (£)"}]
[null,null,null,null,null,null,null,"Qtr 1","Qtr 2","Qtr 3","Qtr 4",{"$f":"+L9","v":"2020 / 2021"},{"$f":"+M9","v":"2021 / 2022"},"2022 / 2023","2023 / 2024","2024 / 2025","2025 / 2026","2026 / 2027","2027 / 2028","2028 / 2029","2029 / 2030","2030 / 2031","2031 / 2032","2032 / 2033",{"$f":"+Y9","v":"2033 / 2034"},"2034 / 2035","2035 / 2036","2036 / 2037","2037 / 2038","2038 / 2039","2039 / 2040","2040 / 2041"]
[null,null,null,"what is the status of this funding? Choose from the list",null,null,null,{"$f":"+H10","v":"£"},{"$f":"+H83","v":"£"},{"$f":"+I83","v":"£"},"£","£","£","£","£","£","£","£","£","£","£","£","£","£",{"$f":"+X83","v":"£"},{"$f":"+Y83","v":"£"},{"$f":"+Z83","v":"£"},{"$f":"+AA83","v":"£"},{"$f":"+AB83","v":"£"},{"$f":"+AC83","v":"£"},{"$f":"+AD83","v":"£"},"£"]
[]
["East Riding of Yorkshire Council ","can only fund capital"]
["Enterprise Zone Retained Business Rates Grant Fund",null,null,"Request/bid submitted",null,null,null,null,null,null,null,{"$f":"+SUM(H86:K86)","v":0},null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(L86:AF86)","v":0}]
[null,null,null,null,null,null,null,{"$f":"+SUM(H86:H86)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(Y86:Y86)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"+NPV(6.075%,M87:AF87)+L87","v":0}]
[]
["Local Authority","name each LA separately if there is more than one. We will need to see evidence of this in due course (eg Cabinet minute). Please include a reference or hyperlink where appropriate",null,null,null,null,null,null,null,null,null,{"$f":"+SUM(H89:K89)","v":0}]
["East Riding of Yorkshire Council",null,null,"Speculative",null,null,null,null,null,null,null,{"$f":"+SUM(H90:K90)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(L90:AF90)","v":0}]
["name",null,null,"Speculative",null,null,null,null,null,null,null,{"$f":"+SUM(H91:K91)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(L91:AF91)","v":0}]
["name",null,null,"Speculative",null,null,null,null,null,null,null,{"$f":"+SUM(H92:K92)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(L92:AF92)","v":0}]
["name",null,null,"Speculative",null,null,null,null,null,null,null,{"$f":"+SUM(H93:K93)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(L93:AF93)","v":0}]
[null,null,null,null,null,null,null,{"$f":"+SUM(H90:H93)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(Y90:Y93)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"+NPV(6.075%,M94:AF94)+L94","v":0}]
[]
["Other Government Agencies","e.g. Highways England, Environment Agency, Homes England etc. Again we will need to see evidence of commitments.",null,null,null,null,null,null,null,null,null,{"$f":"+SUM(H96:K96)","v":0}]
["name",null,null,"Speculative",null,null,null,null,null,null,null,{"$f":"+SUM(H97:K97)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(L97:AF97)","v":0}]
["name",null,null,"Speculative",null,null,null,null,null,null,null,{"$f":"+SUM(H98:K98)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(L98:AF98)","v":0}]
["name",null,null,"Speculative",null,null,null,null,null,null,null,{"$f":"+SUM(H99:K99)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(L99:AF99)","v":0}]
[null,null,null,null,null,null,null,{"$f":"+SUM(H97:H99)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(Y97:Y99)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"+NPV(6.075%,M100:AF100)+L100","v":0}]
[]
["Other public sector","list as appropriate. Evidence of commitment will also need to be provided for these in due course.",null,null,null,null,null,null,null,null,null,{"$f":"+SUM(H102:K102)","v":0}]
["name",null,null,"Speculative",null,null,null,null,null,null,null,{"$f":"+SUM(H103:K103)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(L103:AF103)","v":0}]
["name",null,null,"Speculative",null,null,null,null,null,null,null,{"$f":"+SUM(H104:K104)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(L104:AF104)","v":0}]
["uuu",null,null,"Speculative",null,null,null,null,null,null,null,{"$f":"+SUM(H105:K105)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(L105:AF105)","v":0}]
[null,null,null,null,null,null,null,{"$f":"+SUM(H103:H105)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(Y103:Y105)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"+NPV(6.075%,M106:AF106)+L106","v":0}]
[]
["Third sector","list as appropriate. Evidence of commitment will also need to be provided for these in due course.",null,null,null,null,null,null,null,null,null,{"$f":"+SUM(H108:K108)","v":0}]
["name",null,null,"Speculative",null,null,null,null,null,null,null,{"$f":"+SUM(H109:K109)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(L109:AF109)","v":0}]
["name",null,null,"Speculative",null,null,null,null,null,null,null,{"$f":"+SUM(H110:K110)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(L110:AF110)","v":0}]
["name",null,null,"Speculative",null,null,null,null,null,null,null,{"$f":"+SUM(H111:K111)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(L111:AF111)","v":0}]
[null,null,null,null,null,null,null,{"$f":"+SUM(H109:H111)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(Y109:Y111)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"+NPV(6.075%,M112:AF112)+L112","v":0}]
[]
["European Funding","list as appropriate. Evidence of commitment will also need to be provided for these in due course.",null,null,null,null,null,null,null,null,null,{"$f":"+SUM(H114:K114)","v":0}]
["name",null,null,"Speculative",null,null,null,null,null,null,null,{"$f":"+SUM(H115:K115)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(L115:AF115)","v":0}]
["name",null,null,"Speculative",null,null,null,null,null,null,null,{"$f":"+SUM(H116:K116)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(L116:AF116)","v":0}]
["name",null,null,"Speculative",null,null,null,null,null,null,null,{"$f":"+SUM(H117:K117)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(L117:AF117)","v":0}]
[null,null,null,null,null,null,null,{"$f":"+SUM(H115:H117)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(Y115:Y117)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"+NPV(6.075%,M118:AF118)+L118","v":0}]
[]
["Private sector","list as appropriate. Evidence of commitment will also need to be provided for these in due course where this is appropriate. Where sales receipts are expected we will need to understand the basis of calculation and  the liklihood of achieving your forecasts."]
["Private Sector Partners (see narrative for explanation)",null,null,"Approved in principle",null,null,null,null,null,null,null,{"$f":"+SUM(H121:K121)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(L121:AF121)","v":0}]
["name",null,null,"Speculative",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["name",null,null,"Speculative",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["name",null,null,"Speculative",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["name",null,null,"Speculative",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Speculative",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,{"$f":"+SUM(H121:H126)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(Y121:Y126)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"+NPV(6.075%,M127:AF127)+L127","v":0}]
[]
[]
["Summary"]
[{"$f":"+A86","v":"Enterprise Zone Retained Business Rates Grant Fund"},null,null,null,null,null,null,{"$f":"+H87","v":0},{"$f":"+I87","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+Y87","v":0},0,0,0,0,0,0,0,{"$f":"+SUM(L131:AF131)","v":0},null,{"$f":"+NPV(6.075%,M131:AF131)+L131","v":0}]
[{"$f":"+A89","v":"Local Authority"},null,null,null,null,null,null,{"$f":"+H94","v":0},{"$f":"+I94","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+Y94","v":0},0,0,0,0,0,0,0,0,null,0]
[{"$f":"+A96","v":"Other Government Agencies"},null,null,null,null,null,null,{"$f":"+H100","v":0},{"$f":"+I100","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+Y100","v":0},0,0,0,0,0,0,0,0,null,0]
[{"$f":"+A102","v":"Other public sector"},null,null,null,null,null,null,{"$f":"+H106","v":0},{"$f":"+I106","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+Y106","v":0},0,0,0,0,0,0,0,0,null,0]
[{"$f":"+A108","v":"Third sector"},null,null,null,null,null,null,{"$f":"+H112","v":0},{"$f":"+I112","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+Y112","v":0},0,0,0,0,0,0,0,0,null,0]
[{"$f":"+A114","v":"European Funding"},null,null,null,null,null,null,{"$f":"+H118","v":0},{"$f":"+I118","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+Y118","v":0},0,0,0,0,0,0,0,0,null,0]
[{"$f":"+A120","v":"Private sector"},null,null,null,null,null,null,{"$f":"+H127","v":0},{"$f":"+I127","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+Y127","v":0},0,0,0,0,0,0,0,{"$f":"+SUM(L137:AF137)","v":0},null,0]
[null,null,null,null,null,null,null,{"$f":"+SUM(H131:H137)","v":0},{"$f":"+SUM(I131:I137)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(Y131:Y137)","v":0},0,0,0,0,0,0,0,{"$f":"+SUM(AG131:AG137)","v":0},null,{"$f":"+NPV(6.075%,M138:AF138)+L138","v":0}]
[]
[]
[]
["Difference",null,null,null,null,null,null,{"$f":"+H70-H138","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+Y70-Y138","v":0},0,0,0,0,0,0,0,0,null,{"$f":"+AI70-AI138","v":0}]
[]
["if there is a difference here then the project can not progress - all funding needs to be shown, even if highly speculative"]
[]
[]
[]
[]
[]
["Analyses"]
[]
[null,null,null,"Local Authority"]
[null,null,null,"Approved",null,null,null,{"$f":"+SUMIF($D$89:$AG$93,$D153,H$89:H$93)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"+SUMIF($D$89:$AG$93,$D153,R$89:R$93)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Approved subject to conditions",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Approved in principle",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Request/bid submitted",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Speculative",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"+SUM(H152:H157)","v":0},{"$f":"+SUM(I152:I157)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(Y152:Y157)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,"Other Government Agencies"]
[null,null,null,"Approved",null,null,null,{"$f":"+SUMIF($D$97:$AG$99,$D160,H$97:H$99)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"+SUMIF($D$97:$AG$99,$D160,R$97:R$99)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Approved subject to conditions",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Approved in principle",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Request/bid submitted",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Speculative",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"+SUM(H159:H164)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(Y159:Y164)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,"Other public sector"]
[null,null,null,"Approved",null,null,null,{"$f":"+SUMIF($D$103:$AG$105,$D167,H$103:H$105)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"+SUMIF($D$103:$AG$105,$D167,R$103:R$105)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Approved subject to conditions",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Approved in principle",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Request/bid submitted",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Speculative",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"+SUM(H166:H171)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(Y166:Y171)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,"Third sector"]
[null,null,null,"Approved",null,null,null,{"$f":"+SUMIF($D$109:$AG$111,$D174,H$109:H$111)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"+SUMIF($D$109:$AG$111,$D174,R$109:R$111)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Approved subject to conditions",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Approved in principle",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Request/bid submitted",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Speculative",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"+SUM(H173:H178)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(Y173:Y178)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,"European Funding"]
[null,null,null,"Approved",null,null,null,{"$f":"+SUMIF($D$115:$AG$117,$D181,H$115:H$117)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"+SUMIF($D$115:$AG$117,$D181,R$115:R$117)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Approved subject to conditions",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Approved in principle",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Request/bid submitted",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Speculative",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"+SUM(H180:H185)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(Y180:Y185)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,"Private sector"]
[null,null,null,"Approved",null,null,null,{"$f":"+SUMIF($D$120:$AG$126,$D188,H$120:H$126)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"+SUMIF($D$120:$AG$126,$D188,R$120:R$126)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Approved subject to conditions",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Approved in principle",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Request/bid submitted",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Speculative",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"+SUM(H187:H192)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(Y187:Y192)","v":0},0,0,0,0,0,0,0,0]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+L9","v":"2020 / 2021"},{"$f":"+M9","v":"2021 / 2022"},"2022 / 2023","2023 / 2024","2024 / 2025","2025 / 2026","2026 / 2027","2027 / 2028","2028 / 2029","2029 / 2030","2030 / 2031","2031 / 2032","2032 / 2033",{"$f":"+Y9","v":"2033 / 2034"},"2034 / 2035","2035 / 2036","2036 / 2037","2037 / 2038","2038 / 2039","2039 / 2040","2040 / 2041",0]
[null,null,null,null,null,null,null,null,null,null,"Capital",{"$f":"+L72","v":0},{"$f":"+M72","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"+Y72","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,"Revenue",{"$f":"+L73","v":0},{"$f":"+M73","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"+Y73","v":0},0,0,0,0,0,0,0,0]

{"sheet":"Risk Retained","index":5,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[{"$f":"+Summary!$B$8","v":"Project name as it appears on your main business case/expression of interest form:"}]
["Retained risk"]
[]
["Description of risk","Financial impact if it does occur","Liklihood of occuring","Quantified Risk"]
["describe the risk - (eg need for a public enquiry)","how much would it cost if that happened","what is the %age chance that might happen"]
[null,null,null,{"$f":"+C6*B6","v":0}]
[null,null,null,{"$f":"+C7*B7","v":0}]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,{"$f":"+SUM(D5:D14)","v":0}]
[]
["e.g."]
["residents will object which could result in a public enquiry",1000000,0.05,{"$f":"+C18*B18","v":50000}]

{"sheet":"Outputs","index":6,"n_rows":132,"n_cols":58,"rows_kept":132,"cut":false,"hidden":false,"merged":[[111,0,123,0],[8,28,15,28],[3,2,3,5],[3,36,3,39],[26,0,35,0],[21,28,23,28]]}
[null,{"$f":"+Summary!$B$8","v":"Project name as it appears on your main business case/expression of interest form:"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inflation assumed"]
[null,"outputs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+(1+AO2)*(1+AN3)-1","v":0},{"$f":"+(1+AP2)*(1+AO3)-1","v":2.4999999999999911E-2},5.062499999999992E-2,7.6890624999999879E-2,0.10381289062499977,0.13140821289062465,0.15969341821289018,0.18868575366821227,0.21840289750991748,0.24886296994766521,0.28008454419635664,0.31208665780126554,0.34488882424629708,0.37851104485245446,0.41297382097376567]
[null,null,{"$f":"+G5","v":"2020 / 2021"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Notes (where appropriate)",null,"Each","Year","GDP","Each","Source",null,{"$f":"+AO5","v":"2020 / 2021"}]
[null,null,{"$f":"+'Project Costs'!H9","v":"Qtr 1"},{"$f":"+'Project Costs'!I9","v":"Qtr 2"},{"$f":"+'Project Costs'!J9","v":"Qtr 3"},{"$f":"+'Project Costs'!K9","v":"Qtr 4"},{"$f":"+'Project Costs'!L9","v":"2020 / 2021"},{"$f":"+'Project Costs'!M9","v":"2021 / 2022"},{"$f":"+'Project Costs'!N9","v":"2022 / 2023"},{"$f":"+'Project Costs'!O9","v":"2023 / 2024"},{"$f":"+'Project Costs'!P9","v":"2024 / 2025"},{"$f":"+'Project Costs'!Q9","v":"2025 / 2026"},{"$f":"+'Project Costs'!R9","v":"2026 / 2027"},{"$f":"+'Project Costs'!S9","v":"2027 / 2028"},{"$f":"+'Project Costs'!T9","v":"2028 / 2029"},{"$f":"+'Project Costs'!U9","v":"2029 / 2030"},{"$f":"+'Project Costs'!V9","v":"2030 / 2031"},{"$f":"+'Project Costs'!W9","v":"2031 / 2032"},{"$f":"+'Project Costs'!X9","v":"2032 / 2033"},{"$f":"+'Project Costs'!Y9","v":"2033 / 2034"},{"$f":"+'Project Costs'!Z9","v":"2034 / 2035"},{"$f":"+'Project Costs'!AA9","v":"2035 / 2036"},{"$f":"+'Project Costs'!AB9","v":"2036 / 2037"},{"$f":"+'Project Costs'!AC9","v":"2037 / 2038"},{"$f":"+'Project Costs'!AD9","v":"2038 / 2039"},{"$f":"+'Project Costs'!AE9","v":"2039 / 2040"},{"$f":"+'Project Costs'!AF9","v":"2040 / 2041"},"Total",null,null,null,null,null,"19/20",null,null,{"$f":"+C5","v":"Qtr 1"},"Qtr 2","Qtr 3","Qtr 4","2020 / 2021","2021 / 2022","2022 / 2023","2023 / 2024","2024 / 2025","2025 / 2026","2026 / 2027","2027 / 2028","2028 / 2029","2029 / 2030","2030 / 2031","2031 / 2032",{"$f":"+Y5","v":"2038 / 2039"},"2039 / 2040","2040 / 2041","Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"can include your own…","select from list","automatic calculation","automatic calculation","… but must be sourced"]
[]
[null,"Jobs"]
[null,"Jobs Created",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The total number of newly created and safeguarded permanent full-time equivalent jobs as a direct result of the intervention at predetermined employment sites. Employment sites include occupied newly developed commercial premises, the premises of supported enterprises, and any FE space directly improved or constructed by the intervention. Created and safeguarded jobs exclude those created solely to deliver the intervention (e.g. construction). A job is deemed as permanent if it lasts at least a year."]
[null,"lasting 3 or more years",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(G10:AA10)","v":0},null,null,{"$f":"VLOOKUP(Summary!B11,'Land values'!A33:B35,2,0)","v":47182.8},"2018-19",{"$f":"+VLOOKUP(AF10,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":0.96053025986743512},{"$f":"+AE10/AG10","v":49121.617476696469},"ONS (2018) Sub regional Productivity: Labour Productivity (GVA per hour worked and GVA per filled job) indices by UK NUTS2 and NUTS3 sub regions","economic benefit from a workless claimant entering work",{"$f":"+$AH10*(1+$AO$3)*C10","v":0},{"$f":"+$AH10*(1+$AO$3)*D10","v":0},{"$f":"+$AH10*(1+$AO$3)*E10","v":0},{"$f":"+$AH10*(1+$AO$3)*F10","v":0},{"$f":"+SUM(AK10:AN10)","v":0},{"$f":"+$AH10*(1+AP$3)*H10","v":0},{"$f":"+$AH10*(1+AQ$3)*I10","v":0},{"$f":"+$AH10*(1+AR$3)*J10","v":0},{"$f":"+$AH10*(1+AS$3)*K10","v":0},{"$f":"+$AH10*(1+AT$3)*L10","v":0},{"$f":"+$AH10*(1+AU$3)*M10","v":0},{"$f":"+$AH10*(1+AV$3)*N10","v":0},{"$f":"+$AH10*(1+AW$3)*O10","v":0},{"$f":"+$AH10*(1+AX$3)*P10","v":0},{"$f":"+$AH10*(1+AY$3)*Q10","v":0},{"$f":"+$AH10*(1+AZ$3)*R10","v":0},{"$f":"+$AH10*(1+BA$3)*Y10","v":0},{"$f":"+$AH10*(1+BB$3)*Z10","v":0},{"$f":"+$AH10*(1+BC$3)*AA10","v":0},{"$f":"+SUM(AO10:BC10)","v":0},null,{"$f":"+NPV(6.075%,AP10:BC10)+AO10","v":0}]
[null,"lasting up to 3 years",null,null,null,null,{"$f":"+SUM(C11:F11)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(G11:AA11)","v":0},null,null,{"$f":"AE10","v":47182.8},"2018-19",{"$f":"+VLOOKUP(AF11,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":0.96053025986743512},{"$f":"+AE11/AG11","v":49121.617476696469},"ONS (2018) Sub regional Productivity: Labour Productivity (GVA per hour worked and GVA per filled job) indices by UK NUTS2 and NUTS3 sub regions","economic benefit from a workless claimant entering work",{"$f":"+$AH11*(1+$AO$3)*C11","v":0},{"$f":"+$AH11*(1+$AO$3)*D11","v":0},{"$f":"+$AH11*(1+$AO$3)*E11","v":0},{"$f":"+$AH11*(1+$AO$3)*F11","v":0},{"$f":"+SUM(AK11:AN11)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(AO11:BC11)","v":0},null,{"$f":"+NPV(6.075%,AP11:BC11)+AO11","v":0}]
[null,null,{"$f":"+SUM(C9:C11)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(S9:S11)","v":0},0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,{"$f":"+SUM(AK9:AK11)","v":0},{"$f":"+SUM(AL9:AL11)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,"Jobs Safegaurded"]
[null,"lasting 3 or more years",null,null,null,null,{"$f":"+SUM(C14:F14)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(G14:AA14)","v":0},null,null,{"$f":"AE10","v":47182.8},"2018-19",{"$f":"+VLOOKUP(AF14,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":0.96053025986743512},{"$f":"+AE14/AG14","v":49121.617476696469},"ONS (2018) Sub regional Productivity: Labour Productivity (GVA per hour worked and GVA per filled job) indices by UK NUTS2 and NUTS3 sub regions","economic benefit from a workless claimant entering work",{"$f":"+$AH14*(1+$AO$3)*C14","v":0},{"$f":"+$AH14*(1+$AO$3)*D14","v":0},{"$f":"+$AH14*(1+$AO$3)*E14","v":0},{"$f":"+$AH14*(1+$AO$3)*F14","v":0},{"$f":"+SUM(AK14:AN14)","v":0},{"$f":"+$AH14*(1+AP$3)*H14","v":0},{"$f":"+$AH14*(1+AQ$3)*I14","v":0},{"$f":"+$AH14*(1+AR$3)*J14","v":0},{"$f":"+$AH14*(1+AS$3)*K14","v":0},{"$f":"+$AH14*(1+AT$3)*L14","v":0},{"$f":"+$AH14*(1+AU$3)*M14","v":0},{"$f":"+$AH14*(1+AV$3)*N14","v":0},{"$f":"+$AH14*(1+AW$3)*O14","v":0},{"$f":"+$AH14*(1+AX$3)*P14","v":0},{"$f":"+$AH14*(1+AY$3)*Q14","v":0},{"$f":"+$AH14*(1+AZ$3)*R14","v":0},{"$f":"+$AH14*(1+BA$3)*Y14","v":0},{"$f":"+$AH14*(1+BB$3)*Z14","v":0},{"$f":"+$AH14*(1+BC$3)*AA14","v":0},{"$f":"+SUM(AO14:BC14)","v":0},null,{"$f":"+NPV(6.075%,AP14:BC14)+AO14","v":0}]
[null,"lasting up to 3 years",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(G15:AA15)","v":0},null,null,{"$f":"AE10","v":47182.8},"2018-19",{"$f":"+VLOOKUP(AF15,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":0.96053025986743512},{"$f":"+AE15/AG15","v":49121.617476696469},"ONS (2018) Sub regional Productivity: Labour Productivity (GVA per hour worked and GVA per filled job) indices by UK NUTS2 and NUTS3 sub regions","economic benefit from a workless claimant entering work",{"$f":"+$AH15*(1+$AO$3)*C15","v":0},0,0,0,{"$f":"+SUM(AK15:AN15)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(AO15:BC15)","v":0},null,{"$f":"+NPV(6.075%,AP15:BC15)+AO15","v":0}]
[null,null,{"$f":"+SUM(C13:C15)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(S13:S15)","v":0},0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,{"$f":"+SUM(AK13:AK15)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"+SUM(BF13:BF15)","v":0}]
[null,"Apprenticeships Created",null,null,null,null,{"$f":"+SUM(C17:F17)","v":0},{"$f":"+SUM(H65:H69)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(S65:S69)","v":0},0,0,0,0,0,0,0,0,{"$f":"+SUM(G17:AA17)","v":0},"No of apprenticeship positions created as a direct result of the intervention. Valued below based on levels.",null,0,"2019-20",{"$f":"+VLOOKUP(AF17,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":1},{"$f":"+AE17/AG17","v":0},null,"Numbers also to be included in Skills section"]
[null,"Construction jobs",null,null,null,null,{"$f":"+SUM(C18:F18)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(G18:AA18)","v":0},null,null,0,"2019-20",{"$f":"+VLOOKUP(AF18,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":1},0,null,null,{"$f":"+$AH18*(1+$AO$3)*C18","v":0},{"$f":"+$AH18*(1+$AO$3)*D18","v":0},{"$f":"+$AH18*(1+$AO$3)*E18","v":0},{"$f":"+$AH18*(1+$AO$3)*F18","v":0},{"$f":"+SUM(AK18:AN18)","v":0},{"$f":"+$AH18*(1+AP$3)*H18","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"+$AH18*(1+BA$3)*Y18","v":0},{"$f":"+$AH18*(1+BB$3)*Z18","v":0},{"$f":"+$AH18*(1+BC$3)*AA18","v":0},{"$f":"+SUM(AO18:BC18)","v":0},null,{"$f":"+NPV(6.075%,AP18:BC18)+AO18","v":0}]
[]
[null,"Displacement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Displacement arises when the benefits of an intervention in terms of increased output or employment are offset by a reduction in output or employment elsewhere. This cell is your estimate of what percentage of the jobs have been displaced from other settings.",null,0.25]
[]
[null,"Housing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"At the impact site, the number of started & completed units. Complete refers to physical completion of the individual unit, or, in the case of flats, on physical completion of the block. Housing unit refers to one discrete unit (e.g. house, flat, live/work), regardless of size. Also complete details of new residential land in hectares below."]
[null,"Housing Units started",null,null,null,null,{"$f":"+SUM(C23:F23)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(G23:AA23)","v":0},null,null,0,"2019-20",{"$f":"+VLOOKUP(AF23,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":1},{"$f":"+AE23/AG23","v":0},null,null,{"$f":"+$AH23*(1+$AO$3)*C23","v":0},{"$f":"+$AH23*(1+$AO$3)*D23","v":0},{"$f":"+$AH23*(1+$AO$3)*E23","v":0},{"$f":"+$AH23*(1+$AO$3)*F23","v":0},{"$f":"+SUM(AK23:AN23)","v":0},{"$f":"+$AH23*(1+AP$3)*H23","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"+$AH23*(1+BA$3)*Y23","v":0},0,0,{"$f":"+SUM(AO23:BC23)","v":0},null,{"$f":"+NPV(6.075%,AP23:BC23)+AO23","v":0}]
[null,"Housing Units completed",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"2019-20",{"$f":"+VLOOKUP(AF24,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":1},{"$f":"+AE24/AG24","v":0},null,null,{"$f":"+$AH24*(1+$AO$3)*C24","v":0},0,0,0,{"$f":"+SUM(AK24:AN24)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"+NPV(6.075%,AP24:BC24)+AO24","v":0}]
[null,"Number of homes with improved broadband",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"+$AH25*(1+$AO$3)*C25","v":0},0,0,0,{"$f":"+SUM(AK25:AN25)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"+NPV(6.075%,AP25:BC25)+AO25","v":0}]
[]
["Houses by expected Council Tax Band","A",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,{"$f":"0.666666666666667*AE30","v":1166.5866666666673},"2019-20",{"$f":"+VLOOKUP(AF27,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":1},{"$f":"+AE27/AG27","v":1166.5866666666673},"NHB Calculator, MoHCLG",null,{"$f":"+$AH27*(1+$AO$3)*C27","v":0},{"$f":"+$AH27*(1+$AO$3)*D27","v":0},{"$f":"+$AH27*(1+$AO$3)*E27","v":0},{"$f":"+$AH27*(1+$AO$3)*F27","v":0},{"$f":"+SUM(AK27:AN27)","v":0},{"$f":"+$AH27*(1+AP$3)*SUM(G27:H27)","v":0},{"$f":"+$AH27*(1+AQ$3)*SUM(G27:I27)","v":0},{"$f":"+$AH27*(1+AR$3)*SUM(G27:J27)","v":0},{"$f":"+$AH27*(1+AS$3)*SUM(H27:K27)","v":0},{"$f":"+$AH27*(1+AT$3)*SUM(I27:L27)","v":0},{"$f":"+$AH27*(1+AU$3)*SUM(J27:M27)","v":0},{"$f":"+$AH27*(1+AV$3)*SUM(K27:N27)","v":0},{"$f":"+$AH27*(1+AW$3)*SUM(L27:O27)","v":0},{"$f":"+$AH27*(1+AX$3)*SUM(M27:P27)","v":0},{"$f":"+$AH27*(1+AY$3)*SUM(N27:Q27)","v":0},{"$f":"+$AH27*(1+AZ$3)*SUM(O27:R27)","v":0},{"$f":"+$AH27*(1+BA$3)*SUM(P27:Y27)","v":0},{"$f":"+$AH27*(1+BB$3)*SUM(Q27:Z27)","v":0},{"$f":"+$AH27*(1+BC$3)*SUM(R27:AA27)","v":0},0,null,{"$f":"+NPV(6.075%,AP27:BC27)+AO27","v":0}]
[null,"B",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,{"$f":"0.777777777777778*AE30","v":1361.0177777777783},"2019-20",{"$f":"+VLOOKUP(AF28,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":1},1361.0177777777783,"NHB Calculator, MoHCLG",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,"C",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,{"$f":"0.888888888888889*AE30","v":1555.4488888888891},"2019-20",{"$f":"+VLOOKUP(AF29,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":1},1555.4488888888891,"NHB Calculator, MoHCLG",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,"D",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,1749.88,"2019-20",{"$f":"+VLOOKUP(AF30,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":1},1749.88,"NHB Calculator, MoHCLG",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,"E",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,{"$f":"1.22222222222222*AE30","v":2138.7422222222185},"2019-20",{"$f":"+VLOOKUP(AF31,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":1},2138.7422222222185,"NHB Calculator, MoHCLG",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,"F",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,{"$f":"1.44444444444444*AE30","v":2527.6044444444369},"2019-20",{"$f":"+VLOOKUP(AF32,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":1},2527.6044444444369,"NHB Calculator, MoHCLG",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,"G",null,null,null,null,{"$f":"+SUM(C33:F33)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(G33:AA33)","v":0},null,null,{"$f":"1.66666666666667*AE30","v":2916.4666666666726},"2019-20",{"$f":"+VLOOKUP(AF33,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":1},2916.4666666666726,"NHB Calculator, MoHCLG",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,"H",null,null,null,null,{"$f":"+SUM(C34:F34)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(G34:AA34)","v":0},null,null,{"$f":"2*AE30","v":3499.76},"2019-20",{"$f":"+VLOOKUP(AF34,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":1},3499.76,"NHB Calculator, MoHCLG",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,"I",null,null,null,null,{"$f":"+SUM(C35:F35)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(G35:AA35)","v":0},null,null,{"$f":"2.33333333333333*AE30","v":4083.0533333333278},"2019-20",{"$f":"+VLOOKUP(AF35,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":1},{"$f":"+AE35/AG35","v":4083.0533333333278},"NHB Calculator, MoHCLG",null,{"$f":"+$AH35*(1+$AO$3)*C35","v":0},{"$f":"+$AH35*(1+$AO$3)*D35","v":0},{"$f":"+$AH35*(1+$AO$3)*E35","v":0},{"$f":"+$AH35*(1+$AO$3)*F35","v":0},{"$f":"+SUM(AK35:AN35)","v":0},{"$f":"+$AH35*(1+AP$3)*SUM(G35:H35)","v":0},{"$f":"+$AH35*(1+AQ$3)*SUM(G35:I35)","v":0},{"$f":"+$AH35*(1+AR$3)*SUM(G35:J35)","v":0},{"$f":"+$AH35*(1+AS$3)*SUM(H35:K35)","v":0},{"$f":"+$AH35*(1+AT$3)*SUM(I35:L35)","v":0},{"$f":"+$AH35*(1+AU$3)*SUM(J35:M35)","v":0},{"$f":"+$AH35*(1+AV$3)*SUM(K35:N35)","v":0},{"$f":"+$AH35*(1+AW$3)*SUM(L35:O35)","v":0},{"$f":"+$AH35*(1+AX$3)*SUM(M35:P35)","v":0},{"$f":"+$AH35*(1+AY$3)*SUM(N35:Q35)","v":0},{"$f":"+$AH35*(1+AZ$3)*SUM(O35:R35)","v":0},{"$f":"+$AH35*(1+BA$3)*SUM(P35:Y35)","v":0},{"$f":"+$AH35*(1+BB$3)*SUM(Q35:Z35)","v":0},{"$f":"+$AH35*(1+BC$3)*SUM(R35:AA35)","v":0},0,null,{"$f":"+NPV(6.075%,AP35:BC35)+AO35","v":0}]
[null,"Not analysed",{"$f":"+C24-SUM(C27:C34)","v":0},{"$f":"+D24-SUM(D27:D34)","v":0},{"$f":"+E24-SUM(E27:E34)","v":0},{"$f":"+F24-SUM(F27:F34)","v":0},{"$f":"+SUM(C36:F36)","v":0},{"$f":"+H24-SUM(H27:H34)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"+S24-SUM(S27:S34)","v":0},0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,{"$f":"+SUM(C27:C36)","v":0},{"$f":"+SUM(D27:D36)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(S27:S36)","v":0},0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,{"$f":"+SUM(AK27:AK36)","v":0},{"$f":"+SUM(AL27:AL36)","v":0},{"$f":"+SUM(AM27:AM36)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,"of which, Affordable",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(G38:AA38)","v":0},null,null,350,"2019-20",{"$f":"+VLOOKUP(AF38,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":1},{"$f":"+AE38/AG38","v":350},"NHB Calculator, MoHCLG",null,{"$f":"+$AH38*(1+$AO$3)*C38","v":0},{"$f":"+$AH38*(1+$AO$3)*D38","v":0},{"$f":"+$AH38*(1+$AO$3)*E38","v":0},{"$f":"+$AH38*(1+$AO$3)*F38","v":0},{"$f":"+SUM(AK38:AN38)","v":0},{"$f":"+$AH38*(1+AP$3)*SUM(G38:H38)","v":0},{"$f":"+$AH38*(1+AQ$3)*SUM(G38:I38)","v":0},{"$f":"+$AH38*(1+AR$3)*SUM(G38:J38)","v":0},0,0,0,0,0,0,0,0,{"$f":"+$AH38*(1+BA$3)*SUM(P38:Y38)","v":0},{"$f":"+$AH38*(1+BB$3)*SUM(Q38:Z38)","v":0},{"$f":"+$AH38*(1+BC$3)*SUM(R38:AA38)","v":0},0,null,{"$f":"+NPV(6.075%,AP38:BC38)+AO38","v":0}]
[null,"of which, Affordable & rented",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(G39:AA39)","v":0},null,null,null,"2019-20",null,null,null,null,{"$f":"+$AH39*(1+$AO$3)*C39","v":0},{"$f":"+$AH39*(1+$AO$3)*D39","v":0},{"$f":"+$AH39*(1+$AO$3)*E39","v":0},{"$f":"+$AH39*(1+$AO$3)*F39","v":0},{"$f":"+SUM(AK39:AN39)","v":0},{"$f":"+$AH39*(1+AP$3)*SUM(G39:H39)","v":0},{"$f":"+$AH39*(1+AQ$3)*SUM(G39:I39)","v":0},{"$f":"+$AH39*(1+AR$3)*SUM(G39:J39)","v":0},{"$f":"+$AH39*(1+AS$3)*SUM(H39:K39)","v":0},{"$f":"+$AH39*(1+AT$3)*SUM(I39:L39)","v":0},{"$f":"+$AH39*(1+AU$3)*SUM(J39:M39)","v":0},{"$f":"+$AH39*(1+AV$3)*SUM(K39:N39)","v":0},{"$f":"+$AH39*(1+AW$3)*SUM(L39:O39)","v":0},{"$f":"+$AH39*(1+AX$3)*SUM(M39:P39)","v":0},{"$f":"+$AH39*(1+AY$3)*SUM(N39:Q39)","v":0},{"$f":"+$AH39*(1+AZ$3)*SUM(O39:R39)","v":0},{"$f":"+$AH39*(1+BA$3)*SUM(P39:Y39)","v":0},{"$f":"+$AH39*(1+BB$3)*SUM(Q39:Z39)","v":0},{"$f":"+$AH39*(1+BC$3)*SUM(R39:AA39)","v":0},{"$f":"+SUM(AO39:BC39)","v":0},null,{"$f":"+NPV(6.075%,AP39:BC39)+AO39","v":0}]
[null,"Health benefits of additional affordable housing",{"$f":"+C39","v":0},{"$f":"+D39","v":0},{"$f":"+E39","v":0},{"$f":"+F39","v":0},0,{"$f":"+H39","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"+S39","v":0},0,0,0,0,0,0,0,0,0,"Health and Educational benefits to existing individuals to to less overcrowding and homelessness",null,125,"2019-20",{"$f":"+VLOOKUP(AF40,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":1},{"$f":"+AE40/AG40","v":125},"DCLG Appraisal Guide",null,{"$f":"+$AH40*(1+$AO$3)*C40","v":0},{"$f":"+$AH40*(1+$AO$3)*D40","v":0},{"$f":"+$AH40*(1+$AO$3)*E40","v":0},{"$f":"+$AH40*(1+$AO$3)*F40","v":0},{"$f":"+SUM(AK40:AN40)","v":0},{"$f":"+$AH40*(1+AP$3)*SUM($G40:H40)","v":0},{"$f":"+$AH40*(1+AQ$3)*SUM($G40:I40)","v":0},{"$f":"+$AH40*(1+AR$3)*SUM($G40:J40)","v":0},{"$f":"+$AH40*(1+AS$3)*SUM($G40:K40)","v":0},{"$f":"+$AH40*(1+AT$3)*SUM($G40:L40)","v":0},{"$f":"+$AH40*(1+AU$3)*SUM($G40:M40)","v":0},{"$f":"+$AH40*(1+AV$3)*SUM($G40:N40)","v":0},{"$f":"+$AH40*(1+AW$3)*SUM($G40:O40)","v":0},{"$f":"+$AH40*(1+AX$3)*SUM($G40:P40)","v":0},{"$f":"+$AH40*(1+AY$3)*SUM($G40:Q40)","v":0},{"$f":"+$AH40*(1+AZ$3)*SUM($G40:R40)","v":0},{"$f":"+$AH40*(1+BA$3)*SUM($G40:Y40)","v":0},{"$f":"+$AH40*(1+BB$3)*SUM($G40:Z40)","v":0},{"$f":"+$AH40*(1+BC$3)*SUM($G40:AA40)","v":0},0,null,{"$f":"+NPV(6.075%,AP40:BC40)+AO40","v":0}]
[]
[null,"Transport"]
[null,"Length of Road Resurfaced  (Km)",null,null,null,null,{"$f":"+SUM(C43:F43)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(G43:AA43)","v":0},"Length of road for which maintenance works are to be completed (km).",null,0,"2019-20",{"$f":"+VLOOKUP(AF43,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":1},{"$f":"+AE43/AG43","v":0},"expect this to be completed via WebTag",null,{"$f":"+$AH43*(1+$AO$3)*C43","v":0},{"$f":"+$AH43*(1+$AO$3)*D43","v":0},{"$f":"+$AH43*(1+$AO$3)*E43","v":0},{"$f":"+$AH43*(1+$AO$3)*F43","v":0},{"$f":"+SUM(AK43:AN43)","v":0},{"$f":"+$AH43*(1+AP$3)*H43","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"+$AH43*(1+BA$3)*Y43","v":0},0,0,{"$f":"+SUM(AO43:BC43)","v":0},null,{"$f":"+NPV(6.075%,AP43:BC43)+AO43","v":0}]
[null,"Length of Newly Built Road (Km)",null,null,null,null,{"$f":"+SUM(C44:F44)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(G44:AA44)","v":0},"Length of road open for public use (km).",null,0,"2019-20",{"$f":"+VLOOKUP(AF44,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":1},{"$f":"+AE44/AG44","v":0},"expect this to be completed via WebTag",null,{"$f":"+$AH44*(1+$AO$3)*C44","v":0},0,0,0,{"$f":"+SUM(AK44:AN44)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,"Length New Cycle Ways (Km)",null,null,null,null,{"$f":"+SUM(C45:F45)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(G45:AA45)","v":0},"Length of cycle way open for public use (km).",null,0,"2019-20",{"$f":"+VLOOKUP(AF45,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":1},{"$f":"+AE45/AG45","v":0},"expect this to be completed via WebTag",null,{"$f":"+$AH45*(1+$AO$3)*C45","v":0},0,0,0,{"$f":"+SUM(AK45:AN45)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[]
[null,"Investment in walking & cycling",null,null,null,null,{"$f":"+SUM(C47:F47)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(G47:AA47)","v":0},"Total investment cost",null,13,null,null,{"$f":"+AE47","v":13},"Department for Transport, Walking and cycling: the economic benefits, 2018",null,{"$f":"+$AH47*(1+$AO$3)*C47","v":0},{"$f":"+$AH47*(1+$AO$3)*D47","v":0},{"$f":"+$AH47*(1+$AO$3)*E47","v":0},{"$f":"+$AH47*(1+$AO$3)*F47","v":0},{"$f":"+SUM(AK47:AN47)","v":0},{"$f":"+$AH47*(1+AP$3)*H47","v":0},{"$f":"+$AH47*(1+AQ$3)*I47","v":0},{"$f":"+$AH47*(1+AR$3)*J47","v":0},{"$f":"+$AH47*(1+AS$3)*K47","v":0},{"$f":"+$AH47*(1+AT$3)*L47","v":0},{"$f":"+$AH47*(1+AU$3)*M47","v":0},{"$f":"+$AH47*(1+AV$3)*N47","v":0},{"$f":"+$AH47*(1+AW$3)*O47","v":0},{"$f":"+$AH47*(1+AX$3)*P47","v":0},{"$f":"+$AH47*(1+AY$3)*Q47","v":0},{"$f":"+$AH47*(1+AZ$3)*R47","v":0},{"$f":"+$AH47*(1+BA$3)*Y47","v":0},{"$f":"+$AH47*(1+BB$3)*Z47","v":0},{"$f":"+$AH47*(1+BC$3)*AA47","v":0},{"$f":"+SUM(AO47:BC47)","v":0},null,{"$f":"+NPV(6.075%,AP47:BC47)+AO47","v":0}]
[]
[]
[null,"Skills Capital"]
[null,"Area of new build floorspace (m2)",null,null,null,null,{"$f":"+SUM(C51:F51)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(G51:AA51)","v":0},null,null,0,"2019-20",{"$f":"+VLOOKUP(AF51,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":1},{"$f":"+AE51/AG51","v":0},null,null,{"$f":"+$AH51*(1+$AO$3)*C51","v":0},{"$f":"+$AH51*(1+$AO$3)*D51","v":0},{"$f":"+$AH51*(1+$AO$3)*E51","v":0},{"$f":"+$AH51*(1+$AO$3)*F51","v":0},{"$f":"+SUM(AK51:AN51)","v":0},{"$f":"+$AH51*(1+AP$3)*H51","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"+$AH51*(1+BA$3)*Y51","v":0},0,0,{"$f":"+SUM(AO51:BC51)","v":0},null,{"$f":"+NPV(6.075%,AP51:BC51)+AO51","v":0}]
[null,"Area of refurbished floorspace (m2)",null,null,null,null,{"$f":"+SUM(C52:F52)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(G52:AA52)","v":0},null,null,0,"2019-20",{"$f":"+VLOOKUP(AF52,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":1},{"$f":"+AE52/AG52","v":0},null,null,{"$f":"+$AH52*(1+$AO$3)*C52","v":0},0,0,0,{"$f":"+SUM(AK52:AN52)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(AO52:BC52)","v":0},null,{"$f":"+NPV(6.075%,AP52:BC52)+AO52","v":0}]
[null,"Area of new & refurbished floorspace (m2)",{"$f":"+SUM(C51:C52)","v":0},{"$f":"+SUM(D51:D52)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(S51:S52)","v":0},0,0,0,0,0,0,0,{"$f":"+SUM(AA51:AA52)","v":0},{"$f":"+SUM(AB51:AB52)","v":0},null,null,0,"2019-20",{"$f":"+VLOOKUP(AF53,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":1},{"$f":"+AE53/AG53","v":0},null,null,{"$f":"+SUM(AK51:AK52)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"+SUM(BF51:BF52)","v":0}]
[]
[null,"Skills"]
[null,"Number of New Learners Assisted",null,null,null,null,{"$f":"+SUM(C56:F56)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(G56:AA56)","v":0},null,null,0,"2019-20",{"$f":"+VLOOKUP(AF56,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":1},{"$f":"+AE56/AG56","v":0},null,null,{"$f":"+$AH56*(1+$AO$3)*C56","v":0},{"$f":"+$AH56*(1+$AO$3)*D56","v":0},{"$f":"+$AH56*(1+$AO$3)*E56","v":0},{"$f":"+$AH56*(1+$AO$3)*F56","v":0},{"$f":"+SUM(AK56:AN56)","v":0},{"$f":"+$AH56*(1+AP$3)*H56","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"+$AH56*(1+BA$3)*Y56","v":0},{"$f":"+$AH56*(1+BB$3)*Z56","v":0},{"$f":"+$AH56*(1+BC$3)*AA56","v":0},{"$f":"+SUM(AO56:BC56)","v":0},null,{"$f":"+NPV(6.075%,AP56:BC56)+AO56","v":0}]
[null,"Qualifications Completed"]
[null,"Level 1 qualifications completed",null,null,null,null,{"$f":"+SUM(C58:F58)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(G58:AA58)","v":0},null,null,0,"2010-11",{"$f":"+VLOOKUP(AF58,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":0.85394603651349099},{"$f":"+AE58/AG58","v":0},"New Economy, Manchester",null,{"$f":"+$AH58*(1+$AO$3)*C58","v":0},{"$f":"+$AH58*(1+$AO$3)*D58","v":0},{"$f":"+$AH58*(1+$AO$3)*E58","v":0},{"$f":"+$AH58*(1+$AO$3)*F58","v":0},{"$f":"+SUM(AK58:AN58)","v":0},{"$f":"+$AH58*(1+AP$3)*H58","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"+$AH58*(1+BA$3)*Y58","v":0},0,0,{"$f":"+SUM(AO58:BC58)","v":0},null,{"$f":"+NPV(6.075%,AP58:BC58)+AO58","v":0}]
[null,"Level 2 qualifications completed",null,null,null,null,{"$f":"+SUM(C59:F59)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(G59:AA59)","v":0},null,null,443,"2010-11",{"$f":"+VLOOKUP(AF59,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":0.85394603651349099},{"$f":"+AE59/AG59","v":518.76814348678261},"New Economy, Manchester",null,{"$f":"+$AH59*(1+$AO$3)*C59","v":0},0,0,0,{"$f":"+SUM(AK59:AN59)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(AO59:BC59)","v":0},null,{"$f":"+NPV(6.075%,AP59:BC59)+AO59","v":0}]
[null,"Level 3 qualifications completed",null,null,null,null,{"$f":"+SUM(C60:F60)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(G60:AA60)","v":0},null,null,921,"2010-11",{"$f":"+VLOOKUP(AF60,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":0.85394603651349099},{"$f":"+AE60/AG60","v":1078.5224834115729},"New Economy, Manchester",null,{"$f":"+$AH60*(1+$AO$3)*C60","v":0},0,0,0,{"$f":"+SUM(AK60:AN60)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(AO60:BC60)","v":0},null,{"$f":"+NPV(6.075%,AP60:BC60)+AO60","v":0}]
[null,"Level 4 qualifications completed",null,null,null,null,{"$f":"+SUM(C61:F61)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(G61:AA61)","v":0},null,null,3125,"2010-11",{"$f":"+VLOOKUP(AF61,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":0.85394603651349099},{"$f":"+AE61/AG61","v":3659.4818248221122},"New Economy, Manchester",null,{"$f":"+$AH61*(1+$AO$3)*C61","v":0},0,0,0,{"$f":"+SUM(AK61:AN61)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(AO61:BC61)","v":0},null,{"$f":"+NPV(6.075%,AP61:BC61)+AO61","v":0}]
[null,"Level 5+ qualifications completed",null,null,null,null,{"$f":"+SUM(C62:F62)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(G62:AA62)","v":0},null,null,3125,"2010-11",{"$f":"+VLOOKUP(AF62,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":0.85394603651349099},{"$f":"+AE62/AG62","v":3659.4818248221122},"New Economy, Manchester",null,{"$f":"+$AH62*(1+$AO$3)*C62","v":0},0,0,0,{"$f":"+SUM(AK62:AN62)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(AO62:BC62)","v":0},null,{"$f":"+NPV(6.075%,AP62:BC62)+AO62","v":0}]
[null,"total",{"$f":"+SUM(C58:C62)","v":0},{"$f":"+SUM(D58:D62)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(S58:S62)","v":0},0,0,0,0,0,0,0,{"$f":"+SUM(AA58:AA62)","v":0},{"$f":"+SUM(AB58:AB62)","v":0},null,null,null,null,null,null,null,null,{"$f":"+SUM(AK58:AK62)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"+SUM(BF58:BF62)","v":0}]
[null,"Apprenticeships completed"]
[null,"Level 1 qualifications completed",null,null,null,null,{"$f":"+SUM(C65:F65)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(G65:AA65)","v":0},null,null,0,"2010-11",{"$f":"+VLOOKUP(AF65,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":0.85394603651349099},{"$f":"+AE65/AG65","v":0},"New Economy, Manchester",null,{"$f":"+$AH65*(1+$AO$3)*C65","v":0},{"$f":"+$AH65*(1+$AO$3)*D65","v":0},{"$f":"+$AH65*(1+$AO$3)*E65","v":0},{"$f":"+$AH65*(1+$AO$3)*F65","v":0},{"$f":"+SUM(AK65:AN65)","v":0},{"$f":"+$AH65*(1+AP$3)*H65","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"+$AH65*(1+BA$3)*Y65","v":0},0,0,{"$f":"+SUM(AO65:BC65)","v":0},null,{"$f":"+NPV(6.075%,AP65:BC65)+AO65","v":0}]
[null,"Level 2 qualifications completed",null,null,null,null,{"$f":"+SUM(C66:F66)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,1208,"2010-11",{"$f":"+VLOOKUP(AF66,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":0.85394603651349099},{"$f":"+AE66/AG66","v":1414.6092942032355},"New Economy, Manchester",null,{"$f":"+$AH66*(1+$AO$3)*C66","v":0},0,0,0,{"$f":"+SUM(AK66:AN66)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(AO66:BC66)","v":0},null,{"$f":"+NPV(6.075%,AP66:BC66)+AO66","v":0}]
[null,"Level 3 qualifications completed",null,null,null,null,{"$f":"+SUM(C67:F67)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,1925,"2010-11",{"$f":"+VLOOKUP(AF67,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":0.85394603651349099},{"$f":"+AE67/AG67","v":2254.2408040904211},"New Economy, Manchester",null,{"$f":"+$AH67*(1+$AO$3)*C67","v":0},0,0,0,{"$f":"+SUM(AK67:AN67)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(AO67:BC67)","v":0},null,{"$f":"+NPV(6.075%,AP67:BC67)+AO67","v":0}]
[null,"Level 4 qualifications completed",null,null,null,null,{"$f":"+SUM(C68:F68)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,3125,"2010-11",{"$f":"+VLOOKUP(AF68,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":0.85394603651349099},{"$f":"+AE68/AG68","v":3659.4818248221122},"New Economy, Manchester",null,{"$f":"+$AH68*(1+$AO$3)*C68","v":0},0,0,0,{"$f":"+SUM(AK68:AN68)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(AO68:BC68)","v":0},null,{"$f":"+NPV(6.075%,AP68:BC68)+AO68","v":0}]
[null,"Level 5+ qualifications completed",null,null,null,null,{"$f":"+SUM(C69:F69)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,3125,"2010-11",{"$f":"+VLOOKUP(AF69,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":0.85394603651349099},{"$f":"+AE69/AG69","v":3659.4818248221122},"New Economy, Manchester",null,{"$f":"+$AH69*(1+$AO$3)*C69","v":0},0,0,0,{"$f":"+SUM(AK69:AN69)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(AO69:BC69)","v":0},null,{"$f":"+NPV(6.075%,AP69:BC69)+AO69","v":0}]
[null,null,{"$f":"+SUM(C65:C69)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(S65:S69)","v":0},0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,{"$f":"+SUM(AK65:AK69)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"+SUM(BF65:BF69)","v":0}]
[null,"Traineeships completed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"2019-20",{"$f":"+VLOOKUP(AF71,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":1},{"$f":"+AE71/AG71","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(AO71:BC71)","v":0},null,{"$f":"+NPV(6.075%,AP71:BC71)+AO71","v":0}]
[null,"Other learners supported",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"2019-20",{"$f":"+VLOOKUP(AF72,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":1},{"$f":"+AE72/AG72","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(AO72:BC72)","v":0},null,{"$f":"+NPV(6.075%,AP72:BC72)+AO72","v":0}]
[]
[]
[null,"Land & Property"]
[null,"Area of sites reclaimed (ha)",null,null,null,null,{"$f":"+SUM(C76:F76)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(G76:AA76)","v":0},null,null,0,"2019-20",{"$f":"+VLOOKUP(AF76,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":1},{"$f":"+AE76/AG76","v":0},null,null,{"$f":"+$AH76*(1+$AO$3)*C76","v":0},{"$f":"+$AH76*(1+$AO$3)*D76","v":0},{"$f":"+$AH76*(1+$AO$3)*E76","v":0},{"$f":"+$AH76*(1+$AO$3)*F76","v":0},{"$f":"+SUM(AK76:AN76)","v":0},{"$f":"+$AH76*(1+AP$3)*H76","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"+$AH76*(1+BA$3)*Y76","v":0},{"$f":"+$AH76*(1+BB$3)*Z76","v":0},{"$f":"+$AH76*(1+BC$3)*AA76","v":0},{"$f":"+SUM(AO76:BC76)","v":0},null,{"$f":"+NPV(6.075%,AP76:BC76)+AO76","v":0}]
[]
[null,"Area of new development sites (ha)"]
[null,"residential",null,null,null,null,{"$f":"+SUM(C79:F79)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,{"$f":"+'Land values'!C11","v":1945000},"2017-18",{"$f":"+VLOOKUP(AF79,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":0.96053025986743512},{"$f":"+AE79/AG79","v":2024923.1921839023},"Land Value estimates for policy appraisal, MoHCLG",null,{"$f":"+$AH79*(1+$AO$3)*C79","v":0},{"$f":"+$AH79*(1+$AO$3)*D79","v":0},{"$f":"+$AH79*(1+$AO$3)*E79","v":0},{"$f":"+$AH79*(1+$AO$3)*F79","v":0},{"$f":"+SUM(AK79:AN79)","v":0},{"$f":"+$AH79*(1+AP$3)*H79","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"+$AH79*(1+BA$3)*Y79","v":0},0,0,{"$f":"+SUM(AO79:BC79)","v":0},null,{"$f":"+NPV(6.075%,AP79:BC79)+AO79","v":0}]
[null,"industrial",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,{"$f":"+'Land values'!C12","v":440000},"2017-18",{"$f":"+VLOOKUP(AF80,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":0.96053025986743512},{"$f":"+AE80/AG80","v":458080.310828235},"Land Value estimates for policy appraisal, MoHCLG",null,{"$f":"+$AH80*(1+$AO$3)*C80","v":0},0,0,0,{"$f":"+SUM(AK80:AN80)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(AO80:BC80)","v":0},null,{"$f":"+NPV(6.075%,AP80:BC80)+AO80","v":0}]
["Previous use","industrial",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"select from the list the previous use of the land",null,{"$f":"-VLOOKUP(B81,'Land values'!B11:C13,2,0)","v":-440000},"2017-18",{"$f":"+VLOOKUP(AF81,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":0.96053025986743512},{"$f":"+AE81/AG81","v":-458080.310828235},"Land Value estimates for policy appraisal, MoHCLG","choose from list",{"$f":"+$AH81*(1+$AO$3)*C81","v":0},0,0,0,{"$f":"+SUM(AK81:AN81)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(AO81:BC81)","v":0},null,{"$f":"+NPV(6.075%,AP81:BC81)+AO81","v":0}]
[]
[null,"Amenity Value of new residential land",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Amenity benefit to existing individuals as a result of new development",null,{"$f":"+VLOOKUP(B84,'Land values'!A22:B28,2,0)","v":109138},"2016-17",{"$f":"+VLOOKUP(AF83,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":0.94421751394562159},{"$f":"+AE83/AG83","v":115585.65519923766},{"$f":"+AI40","v":"DCLG Appraisal Guide"},"choose from list",{"$f":"+$AH83*(1+$AO$3)*C83","v":0},{"$f":"+$AH83*(1+$AO$3)*D83","v":0},{"$f":"+$AH83*(1+$AO$3)*E83","v":0},{"$f":"+$AH83*(1+$AO$3)*F83","v":0},{"$f":"+SUM(AK83:AN83)","v":0},{"$f":"+$AH83*(1+AP$3)*H83","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"+$AH83*(1+BA$3)*Y83","v":0},{"$f":"+$AH83*(1+BB$3)*Z83","v":0},{"$f":"+$AH83*(1+BC$3)*AA83","v":0},{"$f":"+SUM(AO83:BC83)","v":0},null,{"$f":"+NPV(6.075%,AP83:BC83)+AO83","v":0}]
["Previous use","Urban core",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"select from the list the previous use of the land"]
[]
[null,"Commercial floorspace created (m2)",{"$f":"+SUM(C87:C88)","v":0},{"$f":"+SUM(D87:D88)","v":0},{"$f":"+SUM(E87:E88)","v":0},{"$f":"+SUM(F87:F88)","v":0},0,{"$f":"+SUM(H87:H88)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(S87:S88)","v":0},0,0,0,0,0,0,0,0,0,"please ensure jobs created or safeguarded / skills outputs are completed above",null,null,null,null,null,null,null,{"$f":"+SUM(AK87:AK88)","v":0},{"$f":"+SUM(AL87:AL88)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"+NPV(6.075%,AP86:BC86)+AO86","v":0}]
[null,"town centre",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,{"$f":"VLOOKUP(Summary!$B$11,'Land values'!$A$3:$F$5,4,0)/4830.9","v":91.080336997246903},"2017-18",{"$f":"+VLOOKUP(AF87,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":0.96053025986743512},{"$f":"+AE87/AG87","v":94.822975186452851},"Land Value estimates for policy appraisal, MoHCLG",null,{"$f":"+$AH87*(1+$AO$3)*C87","v":0},{"$f":"+$AH87*(1+$AO$3)*D87","v":0},{"$f":"+$AH87*(1+$AO$3)*E87","v":0},{"$f":"+$AH87*(1+$AO$3)*F87","v":0},{"$f":"+SUM(AK87:AN87)","v":0},{"$f":"+$AH87*(1+AP$3)*H87","v":0},{"$f":"+$AH87*(1+AQ$3)*I87","v":0},{"$f":"+$AH87*(1+AR$3)*J87","v":0},{"$f":"+$AH87*(1+AS$3)*K87","v":0},{"$f":"+$AH87*(1+AT$3)*L87","v":0},{"$f":"+$AH87*(1+AU$3)*M87","v":0},{"$f":"+$AH87*(1+AV$3)*N87","v":0},{"$f":"+$AH87*(1+AW$3)*O87","v":0},{"$f":"+$AH87*(1+AX$3)*P87","v":0},{"$f":"+$AH87*(1+AY$3)*Q87","v":0},{"$f":"+$AH87*(1+AZ$3)*R87","v":0},{"$f":"+$AH87*(1+BA$3)*Y87","v":0},{"$f":"+$AH87*(1+BB$3)*Z87","v":0},{"$f":"+$AH87*(1+BC$3)*AA87","v":0},{"$f":"+SUM(AO87:BC87)","v":0},null,{"$f":"+NPV(6.075%,AP87:BC87)+AO87","v":0}]
[null,"out of town",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,{"$f":"VLOOKUP(Summary!$B$11,'Land values'!$A$3:$F$5,5,0)/4830.9","v":179.05566250595129},"2017-18",{"$f":"+VLOOKUP(AF88,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":0.96053025986743512},{"$f":"+AE88/AG88","v":186.4133489460948},"Land Value estimates for policy appraisal, MoHCLG",null,{"$f":"+$AH88*(1+$AO$3)*C88","v":0},0,0,0,{"$f":"+SUM(AK88:AN88)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(AO88:BC88)","v":0},null,{"$f":"+NPV(6.075%,AP88:BC88)+AO88","v":0}]
[]
[null,"Commercial floorspace refurbished (m2)",{"$f":"+SUM(C91:C92)","v":0},{"$f":"+SUM(D91:D92)","v":0},{"$f":"+SUM(E91:E92)","v":0},{"$f":"+SUM(F91:F92)","v":0},0,{"$f":"+SUM(H91:H92)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(S91:S92)","v":0},0,0,0,0,0,0,0,null,0,{"$f":"+AC86","v":"please ensure jobs created or safeguarded / skills outputs are completed above"},null,null,null,null,null,null,null,{"$f":"+SUM(AK91:AK92)","v":0},{"$f":"+SUM(AL91:AL92)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"+NPV(6.075%,AP90:BC90)+AO90","v":0}]
[null,"town centre",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"2017-18",{"$f":"+VLOOKUP(AF91,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":0.96053025986743512},{"$f":"+AE91/AG91","v":0},null,null,{"$f":"+$AH91*(1+$AO$3)*C91","v":0},{"$f":"+$AH91*(1+$AO$3)*D91","v":0},{"$f":"+$AH91*(1+$AO$3)*E91","v":0},{"$f":"+$AH91*(1+$AO$3)*F91","v":0},{"$f":"+SUM(AK91:AN91)","v":0},{"$f":"+$AH91*(1+AP$3)*H91","v":0},{"$f":"+$AH91*(1+AQ$3)*I91","v":0},{"$f":"+$AH91*(1+AR$3)*J91","v":0},{"$f":"+$AH91*(1+AS$3)*K91","v":0},{"$f":"+$AH91*(1+AT$3)*L91","v":0},{"$f":"+$AH91*(1+AU$3)*M91","v":0},{"$f":"+$AH91*(1+AV$3)*N91","v":0},{"$f":"+$AH91*(1+AW$3)*O91","v":0},{"$f":"+$AH91*(1+AX$3)*P91","v":0},{"$f":"+$AH91*(1+AY$3)*Q91","v":0},{"$f":"+$AH91*(1+AZ$3)*R91","v":0},{"$f":"+$AH91*(1+BA$3)*Y91","v":0},{"$f":"+$AH91*(1+BB$3)*Z91","v":0},{"$f":"+$AH91*(1+BC$3)*AA91","v":0},{"$f":"+SUM(AO91:BC91)","v":0},null,{"$f":"+NPV(6.075%,AP91:BC91)+AO91","v":0}]
[null,"out of town",null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"2017-18",{"$f":"+VLOOKUP(AF92,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":0.96053025986743512},{"$f":"+AE92/AG92","v":0},null,null,{"$f":"+$AH92*(1+$AO$3)*C92","v":0},0,0,0,{"$f":"+SUM(AK92:AN92)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(AO92:BC92)","v":0},null,{"$f":"+NPV(6.075%,AP92:BC92)+AO92","v":0}]
[]
[null,"Commercial floorspace occupied (m2)",{"$f":"+SUM(C95:C96)","v":0},{"$f":"+SUM(D95:D96)","v":0},{"$f":"+SUM(E95:E96)","v":0},{"$f":"+SUM(F95:F96)","v":0},0,{"$f":"+SUM(H95:H96)","v":0},400,400,400,0,0,0,0,0,0,0,{"$f":"+SUM(S95:S96)","v":0},0,0,0,0,0,0,0,0,1200,{"$f":"+AC86","v":"please ensure jobs created or safeguarded / skills outputs are completed above"},null,null,null,null,null,null,null,{"$f":"+SUM(AK95:AK96)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"+NPV(6.075%,AP94:BC94)+AO94","v":0}]
[null,"town centre",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"2017-18",{"$f":"+VLOOKUP(AF95,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":0.96053025986743512},{"$f":"+AE95/AG95","v":0},null,null,{"$f":"+$AH95*(1+$AO$3)*C95","v":0},{"$f":"+$AH95*(1+$AO$3)*D95","v":0},{"$f":"+$AH95*(1+$AO$3)*E95","v":0},{"$f":"+$AH95*(1+$AO$3)*F95","v":0},{"$f":"+SUM(AK95:AN95)","v":0},{"$f":"+$AH95*(1+AP$3)*H95","v":0},{"$f":"+$AH95*(1+AQ$3)*I95","v":0},{"$f":"+$AH95*(1+AR$3)*J95","v":0},{"$f":"+$AH95*(1+AS$3)*K95","v":0},{"$f":"+$AH95*(1+AT$3)*L95","v":0},{"$f":"+$AH95*(1+AU$3)*M95","v":0},{"$f":"+$AH95*(1+AV$3)*N95","v":0},{"$f":"+$AH95*(1+AW$3)*O95","v":0},{"$f":"+$AH95*(1+AX$3)*P95","v":0},{"$f":"+$AH95*(1+AY$3)*Q95","v":0},{"$f":"+$AH95*(1+AZ$3)*R95","v":0},{"$f":"+$AH95*(1+BA$3)*Y95","v":0},{"$f":"+$AH95*(1+BB$3)*Z95","v":0},{"$f":"+$AH95*(1+BC$3)*AA95","v":0},{"$f":"+SUM(AO95:BC95)","v":0},null,{"$f":"+NPV(6.075%,AP95:BC95)+AO95","v":0}]
[null,"out of town",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"2017-18",{"$f":"+VLOOKUP(AF96,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":0.96053025986743512},{"$f":"+AE96/AG96","v":0},null,null,{"$f":"+$AH96*(1+$AO$3)*C96","v":0},0,0,0,{"$f":"+SUM(AK96:AN96)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(AO96:BC96)","v":0},null,{"$f":"+NPV(6.075%,AP96:BC96)+AO96","v":0}]
[null,null,null,null,null,null,null," "]
[null,"Number of additional commercial properties with broadband access",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"+AC86","v":"please ensure jobs created or safeguarded / skills outputs are completed above"},null,0,"2017-18",{"$f":"+VLOOKUP(AF98,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":0.96053025986743512},{"$f":"+AE98/AG98","v":0},null,null,{"$f":"+$AH98*(1+$AO$3)*C98","v":0},{"$f":"+$AH98*(1+$AO$3)*D98","v":0},{"$f":"+$AH98*(1+$AO$3)*E98","v":0},{"$f":"+$AH98*(1+$AO$3)*F98","v":0},{"$f":"+SUM(AK98:AN98)","v":0},{"$f":"+$AH98*(1+AP$3)*H98","v":0},{"$f":"+$AH98*(1+AQ$3)*I98","v":0},{"$f":"+$AH98*(1+AR$3)*J98","v":0},{"$f":"+$AH98*(1+AS$3)*K98","v":0},{"$f":"+$AH98*(1+AT$3)*L98","v":0},{"$f":"+$AH98*(1+AU$3)*M98","v":0},{"$f":"+$AH98*(1+AV$3)*N98","v":0},{"$f":"+$AH98*(1+AW$3)*O98","v":0},{"$f":"+$AH98*(1+AX$3)*P98","v":0},{"$f":"+$AH98*(1+AY$3)*Q98","v":0},{"$f":"+$AH98*(1+AZ$3)*R98","v":0},{"$f":"+$AH98*(1+BA$3)*Y98","v":0},{"$f":"+$AH98*(1+BB$3)*Z98","v":0},{"$f":"+$AH98*(1+BC$3)*AA98","v":0},{"$f":"+SUM(AO98:BC98)","v":0},null,{"$f":"+NPV(6.075%,AP98:BC98)+AO98","v":0}]
[]
[]
[null,"Flood Risk"]
[null,"Area of land with reduced liklihood of flooding (ha)",null,null,null,null,{"$f":"+SUM(C102:F102)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(G102:AA102)","v":0},"Area of land with a reduced likelihood of flooding as a result of the project",null,0,"2019-20",{"$f":"+VLOOKUP(AF102,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":1},{"$f":"+AE102/AG102","v":0},"expect this to be completed via EA",null,{"$f":"+$AH102*(1+$AO$3)*C102","v":0},{"$f":"+$AH102*(1+$AO$3)*D102","v":0},{"$f":"+$AH102*(1+$AO$3)*E102","v":0},{"$f":"+$AH102*(1+$AO$3)*F102","v":0},{"$f":"+SUM(AK102:AN102)","v":0},{"$f":"+$AH102*(1+AP$3)*H102","v":0},{"$f":"+$AH102*(1+AQ$3)*I102","v":0},{"$f":"+$AH102*(1+AR$3)*J102","v":0},{"$f":"+$AH102*(1+AS$3)*K102","v":0},{"$f":"+$AH102*(1+AT$3)*L102","v":0},{"$f":"+$AH102*(1+AU$3)*M102","v":0},{"$f":"+$AH102*(1+AV$3)*N102","v":0},{"$f":"+$AH102*(1+AW$3)*O102","v":0},{"$f":"+$AH102*(1+AX$3)*P102","v":0},{"$f":"+$AH102*(1+AY$3)*Q102","v":0},{"$f":"+$AH102*(1+AZ$3)*R102","v":0},{"$f":"+$AH102*(1+BA$3)*Y102","v":0},{"$f":"+$AH102*(1+BB$3)*Z102","v":0},{"$f":"+$AH102*(1+BC$3)*AA102","v":0},{"$f":"+SUM(AO102:BC102)","v":0},null,{"$f":"+NPV(6.075%,AP102:BC102)+AO102","v":0}]
[null,"Number of domestic properties with reduced liklihood of flooding",null,null,null,null,{"$f":"+SUM(C103:F103)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(G103:AA103)","v":0},"Number of homes  with a reduced likelihood of flooding as a result of the project",null,0,"2019-20",{"$f":"+VLOOKUP(AF103,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":1},{"$f":"+AE103/AG103","v":0},"expect this to be completed via EA",null,{"$f":"+$AH103*(1+$AO$3)*C103","v":0},0,0,0,{"$f":"+SUM(AK103:AN103)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(AO103:BC103)","v":0},null,{"$f":"+NPV(6.075%,AP103:BC103)+AO103","v":0}]
[null,"Number of commercial units with reduced liklihood of flooding",null,null,null,null,{"$f":"+SUM(C104:F104)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(G104:AA104)","v":0},"Number of commercial units with a reduced likelihood of flooding as a result of the project ",null,0,"2019-20",{"$f":"+VLOOKUP(AF104,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":1},{"$f":"+AE104/AG104","v":0},"expect this to be completed via EA",null,{"$f":"+$AH104*(1+$AO$3)*C104","v":0},0,0,0,{"$f":"+SUM(AK104:AN104)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(AO104:BC104)","v":0},null,{"$f":"+NPV(6.075%,AP104:BC104)+AO104","v":0}]
[]
[null,"Business & Enterprise",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+AC86","v":"please ensure jobs created or safeguarded / skills outputs are completed above"}]
[null,"Number of enterprises receiving grant support",null,null,null,null,{"$f":"+SUM(C107:F107)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(G107:AA107)","v":0},"Number of SMEs receiving grant funding support with the intention of improving performance (i.e. reduce costs, increase turnover/profit, innovation, exporting). To be counted where the support is at least £1,000.",null,0,"2019-20",{"$f":"+VLOOKUP(AF107,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":1},{"$f":"+AE107/AG107","v":0},null,null,{"$f":"+$AH107*(1+$AO$3)*C107","v":0},{"$f":"+$AH107*(1+$AO$3)*D107","v":0},{"$f":"+$AH107*(1+$AO$3)*E107","v":0},{"$f":"+$AH107*(1+$AO$3)*F107","v":0},{"$f":"+SUM(AK107:AN107)","v":0},{"$f":"+$AH107*(1+AP$3)*H107","v":0},{"$f":"+$AH107*(1+AQ$3)*I107","v":0},{"$f":"+$AH107*(1+AR$3)*J107","v":0},{"$f":"+$AH107*(1+AS$3)*K107","v":0},{"$f":"+$AH107*(1+AT$3)*L107","v":0},{"$f":"+$AH107*(1+AU$3)*M107","v":0},{"$f":"+$AH107*(1+AV$3)*N107","v":0},{"$f":"+$AH107*(1+AW$3)*O107","v":0},{"$f":"+$AH107*(1+AX$3)*P107","v":0},{"$f":"+$AH107*(1+AY$3)*Q107","v":0},{"$f":"+$AH107*(1+AZ$3)*R107","v":0},{"$f":"+$AH107*(1+BA$3)*Y107","v":0},{"$f":"+$AH107*(1+BB$3)*Z107","v":0},{"$f":"+$AH107*(1+BC$3)*AA107","v":0},{"$f":"+SUM(AO107:BC107)","v":0},null,{"$f":"+NPV(6.075%,AP107:BC107)+AO107","v":0}]
[null,"Number of enterprises receiving financial support other than grants",null,null,null,null,{"$f":"+SUM(C108:F108)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(G108:AA108)","v":0},"Number of SMEs receiving funding support in the form of equity or repayable loan instruments with the intention of improving performance (i.e. reduce costs, increase turnover/profit, innovation, exporting). Counted where amount of support is at least £1,000.",null,0,"2019-20",{"$f":"+VLOOKUP(AF108,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":1},{"$f":"+AE108/AG108","v":0},null,null,{"$f":"+$AH108*(1+$AO$3)*C108","v":0},0,0,0,{"$f":"+SUM(AK108:AN108)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(AO108:BC108)","v":0},null,{"$f":"+NPV(6.075%,AP108:BC108)+AO108","v":0}]
[null,"Number of enterprises receiving non financial support",null,null,null,null,{"$f":"+SUM(C109:F109)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(G109:AA109)","v":0},"Number of SMEs receiving support (inc. advice and training) with the intention of improving performance (i.e. reduce costs, increase turnover/profit, innovation, exporting). Value of the support should be a minimum of £1,000, calculated at Gross Grant Equivalent (see ERDF guidance) or a minimum of 2 days of consulting advice",null,0,"2019-20",{"$f":"+VLOOKUP(AF109,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":1},{"$f":"+AE109/AG109","v":0},null,null,{"$f":"+$AH109*(1+$AO$3)*C109","v":0},0,0,0,{"$f":"+SUM(AK109:AN109)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(AO109:BC109)","v":0},null,{"$f":"+NPV(6.075%,AP109:BC109)+AO109","v":0}]
[]
[]
["These boxes allow you to insert your own outputs and value them. However please discuss these with the relevant ERYC officer before inclusion in this form. ","Other outputs"]
[null,"Community Space (D1 & D2 uses) Sqm",null,null,null,null,{"$f":"+SUM(C113:F113)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(G113:AA113)","v":0},null,null,91,"2017-18",{"$f":"+VLOOKUP(AF113,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":0.96053025986743512},{"$f":"+AE113/AG113","v":94.739337012203137},"Land Value estimates for policy appraisal, MoHCLG",null,{"$f":"+$AH113*(1+$AO$3)*C113","v":0},{"$f":"+$AH113*(1+$AO$3)*D113","v":0},{"$f":"+$AH113*(1+$AO$3)*E113","v":0},{"$f":"+$AH113*(1+$AO$3)*F113","v":0},{"$f":"+SUM(AK113:AN113)","v":0},{"$f":"+$AH113*(1+AP$3)*H113","v":0},{"$f":"+$AH113*(1+AQ$3)*I113","v":0},{"$f":"+$AH113*(1+AR$3)*J113","v":0},{"$f":"+$AH113*(1+AS$3)*K113","v":0},{"$f":"+$AH113*(1+AT$3)*L113","v":0},{"$f":"+$AH113*(1+AU$3)*M113","v":0},{"$f":"+$AH113*(1+AV$3)*N113","v":0},{"$f":"+$AH113*(1+AW$3)*O113","v":0},{"$f":"+$AH113*(1+AX$3)*P113","v":0},{"$f":"+$AH113*(1+AY$3)*Q113","v":0},{"$f":"+$AH113*(1+AZ$3)*R113","v":0},{"$f":"+$AH113*(1+BA$3)*Y113","v":0},{"$f":"+$AH113*(1+BB$3)*Z113","v":0},{"$f":"+$AH113*(1+BC$3)*AA113","v":0},{"$f":"+SUM(AO113:BC113)","v":0},null,{"$f":"+NPV(6.075%,AP113:BC113)+AO113","v":0}]
[]
[]
[null,"uplift in business rates",null,null,null,null,{"$f":"+SUM(C116:F116)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(G116:AA116)","v":0},null,null,1,"2019-20",{"$f":"+VLOOKUP(AF116,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":1},1,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,"please list",null,null,null,null,{"$f":"+SUM(C117:F117)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(G117:AA117)","v":0},null,null,0,"2019-20",{"$f":"+VLOOKUP(AF117,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":1},0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,"please list",null,null,null,null,{"$f":"+SUM(C118:F118)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(G118:AA118)","v":0},null,null,0,"2019-20",{"$f":"+VLOOKUP(AF118,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":1},0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,"please list",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"2019-20",{"$f":"+VLOOKUP(AF119,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":1},0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,"please list",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"2019-20",{"$f":"+VLOOKUP(AF120,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":1},0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,"please list",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"2019-20",{"$f":"+VLOOKUP(AF121,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":1},{"$f":"+AE121/AG121","v":0},null,null,{"$f":"+$AH121*(1+$AO$3)*C121","v":0},{"$f":"+$AH121*(1+$AO$3)*D121","v":0},{"$f":"+$AH121*(1+$AO$3)*E121","v":0},{"$f":"+$AH121*(1+$AO$3)*F121","v":0},{"$f":"+SUM(AK121:AN121)","v":0},{"$f":"+$AH121*(1+AP$3)*H121","v":0},{"$f":"+$AH121*(1+AQ$3)*I121","v":0},{"$f":"+$AH121*(1+AR$3)*J121","v":0},{"$f":"+$AH121*(1+AS$3)*K121","v":0},{"$f":"+$AH121*(1+AT$3)*L121","v":0},{"$f":"+$AH121*(1+AU$3)*M121","v":0},{"$f":"+$AH121*(1+AV$3)*N121","v":0},{"$f":"+$AH121*(1+AW$3)*O121","v":0},{"$f":"+$AH121*(1+AX$3)*P121","v":0},{"$f":"+$AH121*(1+AY$3)*Q121","v":0},{"$f":"+$AH121*(1+AZ$3)*R121","v":0},{"$f":"+$AH121*(1+BA$3)*Y121","v":0},{"$f":"+$AH121*(1+BB$3)*Z121","v":0},{"$f":"+$AH121*(1+BC$3)*AA121","v":0},{"$f":"+SUM(AO121:BC121)","v":0},null,{"$f":"+NPV(6.075%,AP121:BC121)+AO121","v":0}]
[null,"please list",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"2019-20",{"$f":"+VLOOKUP(AF122,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":1},0,null,null,{"$f":"+$AH122*(1+$AO$3)*C122","v":0},0,0,0,{"$f":"+SUM(AK122:AN122)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(AO122:BC122)","v":0},null,{"$f":"+NPV(6.075%,AP122:BC122)+AO122","v":0}]
[null,"please list",null,null,null,null,{"$f":"+SUM(C123:F123)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(G123:AA123)","v":0},null,null,0,"2019-20",{"$f":"+VLOOKUP(AF123,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":1},0,null,null,{"$f":"+$AH123*(1+$AO$3)*C123","v":0},0,0,0,{"$f":"+SUM(AK123:AN123)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(AO123:BC123)","v":0},null,{"$f":"+NPV(6.075%,AP123:BC123)+AO123","v":0}]
[null,"please list",null,null,null,null,{"$f":"+SUM(C124:F124)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(G124:AA124)","v":0},null,null,0,"2019-20",{"$f":"+VLOOKUP(AF124,'GDP Deflators'!$B$8:$C$77,2,0)/'GDP Deflators'!$C$72","v":1},0,null,null,{"$f":"+$AH124*(1+$AO$3)*C124","v":0},0,0,0,{"$f":"+SUM(AK124:AN124)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(AO124:BC124)","v":0},null,{"$f":"+NPV(6.075%,AP124:BC124)+AO124","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Communities and Local Government (2010) Valuing the Benefits of Regeneration"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Potential additional benefits"]

{"sheet":"Risk Register","index":7,"n_rows":60,"n_cols":17,"rows_kept":60,"cut":false,"hidden":false,"merged":[[43,2,43,4],[44,2,44,4],[41,0,56,0],[38,2,38,4],[39,2,39,4],[40,2,40,4],[41,2,41,4],[42,2,42,4],[8,6,8,7],[0,12,0,13],[1,6,1,9],[4,2,4,13],[5,0,5,5],[5,6,5,9],[5,10,5,13],[51,2,51,4],[52,2,52,4],[53,2,53,4],[54,2,54,4],[57,0,59,0],[55,2,55,4],[56,2,56,4],[57,2,57,4],[58,2,58,4],[59,2,59,4],[45,2,45,4],[46,2,46,4],[47,2,47,4],[48,2,48,4],[50,2,50,4],[49,2,49,4]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Action Status (RAG)",null,null,null,"Action Status (RAG)"]
[null,null,null,null,null,null,"Risk Register",null,null,null,null,null,"R","No plans/not started or actions not working. Still at Significant Risk"]
[null,null,null,null,null,null,null,null,null,null,null,null,"A","Plans behind schedule. Still at Some Risk"]
[null,null,null,null,null,null,null,null,null,null,null,null,"G","Plans on track. Risk being controlled"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2]
[null,null,null,null,null,null,{"$f":"Summary!B8","v":"Project name as it appears on your main business case/expression of interest form:"},null,null,null,null,null,null,null,null,null,1]
[]
["Risk Ref No.","5 Case Guidance cat.","Risk Description","Risk Owner","Date Identified","Date Last Review","Impact (I)","Likelihood ","Risk Score (I x L)","Existing Controls","Additional Treatment Actions","Date Action Due","Action Status (R, A or G)","Action Owner","Comments"]
[null,"choose from list - see below for explanations of each category","There are three parts (a,b,c) to naming a risk - a) Failure of…, lack of…, development of… b) Leads to… c) Resulting in…",null,null,null,"choose from list - see below for explanations of each category",null,"calculates & colours automatically","The likelihood and impact of the risks need to be considered after the existing internal controls have been evaluated as to their effectiveness.","These are actions which are planned for the future and once implemented these will become part of the \"existing controls.\"",null,"enter R, A or G","The Action Owner is nominated by the Risk Owner and is responsible for the on-going and progress reporting of the action."]
[null,"Availability and performance risk",null,null,null,null,"Insignificant","Rare",{"$f":"VLOOKUP($G10,$G$41:$H$45,2,FALSE)*VLOOKUP($H10,$G$47:$H$51,2,FALSE)","v":1},null,null,null,"G"]
[null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($G11,$G$41:$H$45,2,FALSE)*VLOOKUP($H11,$G$47:$H$51,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,"G"]
[null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($G12,$G$41:$H$45,2,FALSE)*VLOOKUP($H12,$G$47:$H$51,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,"G"]
[null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,"G"]
[null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,"G"]
[null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,"G"]
[null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,"G"]
[null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($G17,$G$41:$H$45,2,FALSE)*VLOOKUP($H17,$G$47:$H$51,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,"G"]
[null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,"G"]
[null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,"G"]
[null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,"G"]
[null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,"G"]
[null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,"G"]
[null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,"G"]
[null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,"G"]
[null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,"G"]
[null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,"G"]
[null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,"G"]
[null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,"G"]
[null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,"G"]
[null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,"G"]
[null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,"G"]
[null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,"G"]
[null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,"G"]
[null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,"G"]
[]
[]
[]
[]
[null,"Generic Risks "]
[null,null,null,null,null,null,"Impact"]
["Business risk ","Reputational risk ","The risk that there will be an undermining of customer’s/media’s perception of the organisation’s ability to fulfil its business requirements – for example, adverse publicity concerning an operational problem",null,null,null,"Insignificant",1]
["Service risk","Design risk ","The risk that design cannot deliver the services to the required quality standards.",null,null,null,"Minor",2]
[null,"Planning risk ","The risk that the implementation of a project fails to adhere to the terms of the planning permission or that detailed planning cannot be obtained; or, if obtained, can only be implemented at costs greater than in the original budget.",null,null,null,"Moderate",3]
[null,"Build risk","The risk that the construction of physical assets is not completed on time, to budget and to specification.",null,null,null,"Major",4]
[null,"Project intelligence risk ","The risk that the quality of initial intelligence (for example, preliminary site investigation) will impact on the likelihood of unforeseen problems occurring.",null,null,null,"Catastrophic",5]
[null,"Decant risk ","The risk arising in accommodation projects relating to the need to decant staff/clients from one site to another.",null,null,null,"Likelihood"]
[null,"Environmental risk","The risk that the nature of the project has a major impact on its adjacent area and there is a strong likelihood of objection from the general public.",null,null,null,"Rare",1]
[null,"Procurement risk ","The risk that can arise from the contractual arrangements between two parties – for example, the capabilities of the contractor/ when a dispute occurs.",null,null,null,"Unlikely",2]
[null,"Operational risk ","The risk that operating costs vary from budget and that performance standards slip or that a service cannot be provided.",null,null,null,"Possible",3]
[null,"Availability and performance risk","The risk that the quantum of service provided is less than that required under the contract.",null,null,null,"Likely",4]
[null,"Demand risk","The risk that the demand for a service does not match the levels planned, projected or assumed. As the demand for a service may be partially controllable by the public body concerned, the  risk to the public sector may be less than perceived by the private sector.",null,null,null,"Almost Certain",5]
[null,"Volume risk","The risk that actual usage of the service varies from the levels forecast."]
[null,"Occupancy risk ","The risk that a property will remain untenanted –a form of demand risk."]
[null,"Maintenance risk ","The risk that the costs of keeping the assets in good condition vary from budget."]
[null,"Technology risk ","The risk that changes in technology result in services being provided using sub-optimal technical solutions."]
[null,"Funding risk","The risk that the availability of funding leads to delays and reductions in scope as a result of reduced monies."]
[null,"Residual value risk ","The risk relating to the uncertainty of the values of physical assets at the end of the contract period."]
["External environmental risks","Economic risk ","The risk that project outcomes are sensitive to economic influences – for example, where actual inflation differs from assumed inflation rates."]
[null,"Legislative risk","The risk that legislative change increases costs. This can be divided into secondary legislative risk(for example, changes to corporate taxes) and primary legislative risk (for example, specific changes which affect a particular project)."]
[null,"Policy risk ","The risk of changes in policy direction leading to unforeseen change. Again, this can either be general to all or specific to a particular project."]

{"sheet":"Land values","index":8,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[null,"https://www.gov.uk/government/publications/land-value-estimates-for-policy-appraisal-2017"]
[null,"Post permission residential site","agricultural land","industrial land","City centre office space","out of town office space"]
["East Riding",1945000,26000,440000,865000,440000]
["Hull",740000,26000,440000,865000,440000]
[{"$f":"+A3&\" and \"&A4","v":"East Riding and Hull"},null,26000,440000,865000,440000]
[]
[]
[]
[]
[]
[null,"residential",{"$f":"+VLOOKUP($B$15,$A$3:$B$5,2)","v":1945000}]
[null,"industrial",{"$f":"+VLOOKUP($B$15,$A$3:$D$5,4)","v":440000}]
[null,"agricultural",{"$f":"+VLOOKUP($B$15,$A$3:$C$5,3)","v":26000}]
[]
[null,{"$f":"+Summary!B11","v":"East Riding"}]
[]
[]
[]
[]
[]
[null,"Amenity benefit"]
["Urban core",109138]
["Urban fringe (Greenbelt)",1797]
["Urban fringe (Forested land)",5457]
["Rural",13392]
["Agricultural (Extensive)",6366]
["Agricultural (Intensive)",208]
["Natural & semi natural",13371]
[]
[]
[]
["GVA"]
["East Riding",{"$f":"'B3'!T47","v":47182.8}]
["Hull",{"$f":"'B3'!T46","v":46997.4}]
[{"$f":"+A33&\" and \"&A34","v":"East Riding and Hull"},{"$f":"AVERAGE(B33:B34)","v":47090.100000000006}]

{"sheet":"GDP Deflators","index":9,"n_rows":99,"n_cols":11,"rows_kept":99,"cut":false,"hidden":true,"merged":[[97,2,97,10],[98,2,98,10],[91,2,91,10],[92,2,92,10],[93,2,93,10],[94,2,94,10],[95,2,95,10],[96,2,96,10],[89,2,89,10],[78,2,78,10],[79,2,79,10],[80,2,80,10],[81,2,81,10],[82,2,82,10],[83,2,83,10],[84,2,84,10],[85,2,85,10],[86,2,86,10],[87,2,87,10],[88,2,88,10],[2,1,2,10],[3,1,3,10],[4,1,4,5],[4,7,4,10],[5,2,5,3],[5,8,5,9]]}
[null,"GDP DEFLATORS AT MARKET PRICES, AND MONEY GDP"]
[]
[null,"Outturn data are as at the Quarterly National Accounts from ONS - last updated 29 March 2018."]
[null,"Forecast data are consistent with OBR Spring Statement EFO data as at 13 March 2018"]
[null,"Financial year",null,null,null,null,null,"Calendar year"]
[null,null,"GDP deflator at market prices ",null,"Money GDP (3), (4)",null,null,null,"GDP deflator at market prices ",null,"Money GDP (3)"]
[null,"Financial year","2016-17 = 100","per cent change on previous year","Cash £ million\nNon-Season-ally Adjusted","Cash £ million\nSeasonally Adjusted",null,"Calendar year","2017 = 100","per cent change on previous year","Cash £ million\nNon-Seasonally Adjusted"]
[null,"1955-56",4.0268750000000004,null,19558,19573,null,"1955",3.9883000000000002,null,19154]
[null,"1956-57",4.2794999999999996,6.2734750892441209,21145,21120,null,"1956",4.2648999999999999,6.935285710703802,20827]
[null,"1957-58",4.4764500000000007,4.602173151069076,22497,22512,null,"1957",4.4356,4.0024385096954225,22090]
[null,"1958-59",4.5846999999999998,2.4182108590512357,23320,23292,null,"1958",4.5979999999999999,3.6612859590585236,23210]
[null,"1959-60",4.6071999999999997,0.4907627543786936,24837,24889,null,"1959",4.6311999999999998,0.72205306655067192,24353]
[null,"1960-61",4.7009249999999998,2.0343158534467802,26609,26629,null,"1960",4.6792999999999996,1.0386077042667088,26169]
[null,"1961-62",4.8727499999999999,3.6551317028031742,28115,28144,null,"1961",4.8563999999999998,3.7847541298912288,27891]
[null,"1962-63",5.02515,3.1275973526242904,29437,29452,null,"1962",5.0315000000000003,3.6055514372786526,29216]
[null,"1963-64",5.1095749999999995,1.6800493517606347,31907,31865,null,"1963",5.1051000000000002,1.4627844579151323,31090]
[null,"1964-65",5.3511000000000006,4.7269097723392086,34811,34878,null,"1964",5.2882999999999996,3.588568294450635,34007]
[null,"1965-66",5.6395499999999998,5.3904804619610767,37429,37385,null,"1965",5.6031000000000004,5.9527636480532662,36794]
[null,"1966-67",5.9274750000000003,5.1054605420645345,39926,39920,null,"1966",5.9027000000000003,5.3470400314111801,39367]
[null,"1967-68",6.0905249999999995,2.7507496868396619,42493,42602,null,"1967",6.0776000000000003,2.9630508072576967,41660]
[null,"1968-69",6.4092750000000001,5.2335389806297581,46763,46784,null,"1968",6.3331999999999997,4.2056074766355032,45792]
[null,"1969-70",6.8527749999999994,6.9196593998541074,50860,50915,null,"1969",6.7535999999999996,6.638034484936524,49776]
[null,"1970-71",7.528975,9.8675354144853813,57723,57809,null,"1970",7.4028999999999998,9.6141317223406819,56055]
[null,"1971-72",8.097525000000001,7.5514927330745687,64517,64419,null,"1971",8.0164000000000009,8.2872928176795728,62821]
[null,"1972-73",8.7857250000000011,8.4988931803236181,73845,73950,null,"1972",8.6219999999999999,7.5545132478419115,70499]
[null,"1973-74",9.5589250000000003,8.8006396740166473,82759,82781,null,"1973",9.3862000000000005,8.8633727673393725,81703]
[null,"1974-75",11.499874999999999,20.305107530396974,98107,98277,null,"1974",10.9039,16.169482857812529,92586]
[null,"1975-76",14.314875000000001,24.478526940510235,120739,120631,null,"1975",13.7537,26.135602857693119,115023]
[null,"1976-77",16.307425000000002,13.919436949327194,141816,142319,null,"1976",15.8805,15.463475283014747,136759]
[null,"1977-78",18.549975,13.751711260361446,165811,165602,null,"1977",18.081199999999999,13.857876011460593,159502]
[null,"1978-79",20.638849999999998,11.260796847435094,192055,192168,null,"1978",20.216200000000001,11.807844612083278,185857]
[null,"1979-80",24.11645,16.849776029187684,232269,232302,null,"1979",23.134799999999998,14.43693671412035,220658]
[null,"1980-81",28.729025,19.126260291212013,267153,267446,null,"1980",27.810099999999998,20.208949288517733,259654]
[null,"1981-82",31.754224999999998,10.530117189845454,297610,297044,null,"1981",31.238399999999999,12.327535679483354,289551]
[null,"1982-83",34.0916,7.3608315113973077,326887,327136,null,"1982",33.739600000000003,8.0068121286621725,318969]
[null,"1983-84",35.720075000000001,4.7767631909326687,357612,356885,null,"1983",35.61,5.5436341865345069,350868]
[null,"1984-85",37.751374999999996,5.6867181829825233,385624,384846,null,"1984",37.468499999999999,5.2190395956192059,377543]
[null,"1985-86",39.853549999999998,5.5684726715252166,423581,424134,null,"1985",39.4863,5.385323671884386,414414]
[null,"1986-87",41.505099999999999,4.1440473935195241,455385,456084,null,"1986",41.257199999999997,4.4848466430128866,446620]
[null,"1987-88",43.827725000000001,5.5959990459003883,510953,511248,null,"1987",43.4771,5.380636591916085,496124]
[null,"1988-89",46.690674999999992,6.5322806511175076,570118,571046,null,"1988",46.051600000000001,5.9215081042663851,555591]
[null,"1989-90",50.310275000000004,7.7522974341236521,628384,628126,null,"1989",49.6648,7.845981464270511,614508]
[null,"1990-91",54.447299999999998,8.2230220367509297,678505,680041,null,"1990",53.676600000000001,8.0777532578405662,668915]
[null,"1991-92",57.609624999999994,5.8080474146559986,714825,713484,null,"1991",57.234900000000003,6.629145661237863,705448]
[null,"1992-93",59.109949999999998,2.6042957231539066,737105,738923,null,"1992",59.034100000000002,3.1435365485044944,730561]
[null,"1993-94",60.56185,2.4562700526730303,780778,778210,null,"1993",60.640300000000003,2.7208003509835859,769143]
[null,"1994-95",61.355224999999997,1.3100243800346216,819004,819125,null,"1994",61.456000000000003,1.3451450602981838,809469]
[null,"1995-96",63.149175,2.9238748615134287,863504,862307,null,"1995",62.9514,2.4332856027076222,850162]
[null,"1996-97",65.650200000000012,3.9605030469519402,919295,921184,null,"1996",65.543000000000006,4.1168266313378368,907245]
[null,"1997-98",65.928124999999994,0.42334219850051019,963769,961299,null,"1997",66.249499999999998,1.0779183131684407,952285]
[null,"1998-99",66.954900000000009,1.5574157463146645,1008121,1010831,null,"1998",66.872299999999996,0.94008256666087753,996374]
[null,"1999-00",67.220100000000002,0.39608751562617966,1054782,1052319,null,"1999",67.4876,0.92011191479881038,1039891]
[null,"2000-01",68.529124999999993,1.9473713963531609,1107924,1104616,null,"2000",68.740300000000005,1.8561928413516029,1095651]
[null,"2001-02",69.383450000000011,1.2466597231469352,1147395,1151712,null,"2001",69.424300000000002,0.99504948334528287,1139479]
[null,"2002-03",70.994174999999998,2.3214830049528925,1211222,1206957,null,"2002",70.888900000000007,2.1096359632002111,1190601]
[null,"2003-04",72.421900000000008,2.0110452723762329,1272293,1273436,null,"2003",72.488299999999995,2.2562065429143185,1257474]
[null,"2004-05",74.471324999999993,2.8298415258367773,1336299,1335027,null,"2004",74.337699999999998,2.5513082800948608,1320128]
[null,"2005-06",76.286850000000001,2.4378846488900368,1420214,1420135,null,"2005",76.197900000000004,2.5023642108916553,1396274]
[null,"2006-07",78.453125,2.8396440539883332,1493214,1492031,null,"2006",78.311700000000002,2.7740921993913186,1474923]
[null,"2007-08",80.539674999999988,2.659613622784291,1569164,1571317,null,"2007",80.332899999999995,2.5809681056598097,1549821]
[null,"2008-09",82.594950000000011,2.5518789342023336,1573876,1573372,null,"2008",82.659800000000004,2.8965716412578271,1589931]
[null,"2009-10",83.956699999999998,1.6487085469510985,1557283,1557542,null,"2009",84.015500000000003,1.6400959111926219,1547563]
[null,"2010-11",85.394625000000005,1.7126983314017903,1622044,1621521,null,"2010",85.302700000000002,1.5320982437764443,1601927]
[null,"2011-12",86.697949999999992,1.5262377462281576,1668699,1666988,null,2011,87.043499999999995,2.0407325911137546,1659784]
[null,"2012-13",88.483649999999997,2.0596796118016698,1725624,1728156,null,2012,88.486999999999995,1.6583662191892563,1712321]
[null,"2013-14",90.190849999999998,1.9293959957574085,1806329,1803916,null,2013,90.162999999999997,1.8940635347565202,1782109]
[null,"2014-15",91.450299999999999,1.3964276864005618,1871789,1875048,null,2014,91.812799999999996,1.8297971451704125,1861964]
[null,"2015-16",92.237899999999996,0.86123282263699252,1934600,1934489,null,2015,92.346599999999995,0.58140041475698312,1916896]
[null,"2016-17",94.421774999999997,2.3676547276119693,2019484,2019115,null,2016,94.320599999999999,2.1375990020206523,1995479]
[null,"2017-18",96.053049999999999,1.7276470390436978,2085654,2086798,null,2017,96.105699999999999,1.8925876213679724,2071667]
[null,"2018-19",96.053049999999999,1.7276470390436978,2085654,2086798,null,2017,96.105699999999999,1.8925876213679724,2071667]
[null,"2019-20",100.00002499999999,1.9352140715411785,2216479,2218211,null,2019,100,1.8760474131124625,2216451]
[null,"2020-21","-",1.9701032301562691,2304464,2304392,null,"2020 (1), (2)","-",2.0491464622641757,2284094]
[null,"2021-22","-",2.1150077781338297,2393868,2393331,null,"2021 (1), (2)","-",2.008528858555124,2371006]
[null,"2022-23","-",2.1175224583591472,2478094,2478280,null,"2022 (1), (2)","-",2.1567423639307748,2457739]
[null,"2023-24","-",2.0741489746880291,2561641,2561492,null,"2023 (1), (2)","-",2.0678094530023117,2540162]
[null,"2024-25","-",2.1119376933925338,2654177,2653987,null,"2024 (1), (2)","-",2.1049669874452235,2629694]
[null,"Sources and footnotes:"]
[null,"GDP Deflator:","Financial years 1955-56 to 2019-20 taken from ONS series L8GG in data tables: Table N."]
[null,null,"https://www.ons.gov.uk/file?uri=%2feconomy%2fgrossdomesticproductgdp%2fdatasets%2fuksecondestimateofgdpdatatables%2fquarter1jantomar2020quarterlynationalaccounts/quarterlynationalaccountsdatatables.xls"]
[null,null,"Calendar years 1955 to 2019 taken from ONS series MNF2 in data tables: Table O."]
[null,null,"https://www.ons.gov.uk/file?uri=%2feconomy%2fgrossdomesticproductgdp%2fdatasets%2fuksecondestimateofgdpdatatables%2fquarter1jantomar2020quarterlynationalaccounts/quarterlynationalaccountsdatatables.xls"]
[null,null,"For years 2020-21 to 2024-25 (2019 to 2024): taken from the Office for Budget Responsibility (OBR) forecasts for GDP deflator increases as of March 2020 Supplementary Economy  tables."]
[null,null,"https://obr.uk/efo/economic-and-fiscal-outlook-march-2020/"]
[null,"Money GDP:","For years 1955-56 to 2019-20 (1955 to 2019): ONS data for money GDP not seasonally adjusted series BKTL in data tables: Table N."]
[null,null,"https://www.ons.gov.uk/file?uri=%2feconomy%2fgrossdomesticproductgdp%2fdatasets%2fuksecondestimateofgdpdatatables%2fquarter1jantomar2020quarterlynationalaccounts/quarterlynationalaccountsdatatables.xls"]
[null,null,"For years 1955-56 to 2019-20: ONS data for money GDP seasonally adjusted series YBHA in data tables: Table N."]
[null,null,"https://www.ons.gov.uk/file?uri=%2feconomy%2fgrossdomesticproductgdp%2fdatasets%2fuksecondestimateofgdpdatatables%2fquarter1jantomar2020quarterlynationalaccounts/quarterlynationalaccountsdatatables.xls"]
[null,null,"For years 2020-21 to 2024-25 (2020 to 2024): taken from the Office for Budget Responsibility (OBR) forecasts for GDP deflator increases as of March 2020 Supplementary Economy tables."]
[null,null,"https://obr.uk/efo/economic-and-fiscal-outlook-march-2020/"]
[null,"Footnotes:"]
[null,"(1)","For years 2020-21 to 2024-25 (2020 to 2024), this presentation only shows percentage changes in line with OBR data as of the Budget, March 2020."]
[null,"(2)","For years 2020-21 to 2024-25 (2020 to 2024), money GDP forecasts from the OBR as of the Budget, March 2020."]
[null,"(3)","Non-Seasonally adjusted money GDP (BKTL) from 1955-56 to 2019-20 (1955 to 2019) consistent with ONS Quarterly National Accounts release of 30 June 2020."]
[null,"(4)","Seasonally adjusted money GDP (YBHA) from 1955-56 to 2019-20 consistent with ONS First Quarterly Estimate of GDP release of 30 June 2020."]
[null,"(5)","For further information and the 'User's Guide' to these series, please visit the following page on the GOV.UK website at: "]
[null,null,"https://www.gov.uk/government/publications/gross-domestic-product-gdp-deflators-user-guide"]
[null,"(6)","For practical examples of how to use the GDP deflator series, please visit the following page on the GOV.UK website at: "]
[null,null,"https://www.gov.uk/government/publications/how-to-use-the-gdp-deflator-series-practical-examples"]

{"sheet":"B3","index":10,"n_rows":246,"n_cols":20,"rows_kept":246,"cut":false,"hidden":true,"merged":[]}
["Table B3: Nominal (smoothed) GVA (B) per filled job (£); NUTS 2 and NUTS 3 subregions,  2002 - 2018"]
["Including NUTS 1, England and UK figures for comparison purposes"]
[]
[null,null,null,2002,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018]
["NUTS level","NUTS code","Region name","£","£","£","£","£","£","£","£","£","£","£","£","£","£","£","£","£"]
["UK","UK","United Kingdom less Extra-Regio",36220.35,37970.949999999997,39437.33,41277.31,43217.03,45024.959999999999,45870.66,45894.73,46758.97,47696.63,48879.39,50289.65,51414.64,52315.66,53787.63,55346.84,56386.75]
["Other","E","England",36967.040000000001,38753.4,40248.519999999997,42141.120000000003,44132.86,45983.83,46831.57,46818.75,47657.56,48551.14,49705.74,51107.13,52254.95,53179.57,54674.15,56244.02,57289.65]
["NUTS1","UKC","North East",31800.44,33345.03,34624.22,35989.660000000003,37369.29,38571.730000000003,39190.769999999997,39281.21,40254.379999999997,41220.04,42274.42,43316.82,44204.04,44886.86,46085.45,47200.639999999999,47925.68]
["NUTS2","UKC1","Tees Valley and Durham",31825.53,33408.699999999997,34707.18,36067.269999999997,37447.82,38876.92,39910.410000000003,40374.129999999997,41438.89,42223.39,43026.39,43884.92,44713.49,45436.959999999999,46708.14,47885.22,48618.02]
["NUTS3","UKC11","Hartlepool and Stockton-on-Tees",34988.519999999997,36780.9,38291.629999999997,40072.22,42086.45,44287,45842.14,46331.88,47229.68,47647.73,48182.16,48909.54,49888.62,50800.5,52246.32,53330.5,53926.34]
["NUTS3","UKC12","South Teesside",27212.080000000002,28295.03,29056.18,30025.5,31421.68,33015.24,34279.800000000003,34941.230000000003,36107.1,36929.339999999997,37515.31,38146.54,38891.08,39799.46,41282.699999999997,42678.12,43570.38]
["NUTS3","UKC13","Darlington",36602.949999999997,38394.080000000002,39856.07,40571.82,40821.800000000003,40311.57,39527.440000000002,38897.65,39567.870000000003,41354.620000000003,43456.68,46587.19,48714.46,50465.45,51801.52,53510.3,54558.02]
["NUTS3","UKC14","Durham CC",31226.94,32961.379999999997,34459.54,35998.51,37267.39,38606.31,39656.36,40270.36,41507.01,42195.040000000001,42934.28,43312.98,43686.04,43844.68,44869.88,45862.23,46528.29]
["NUTS2","UKC2","Northumberland and Tyne and Wear",31782.85,33299.99,34565.64,35935.54,37314.44,38355.620000000003,38679.93,38506.81,39416.980000000003,40512.1,41743.82,42914.18,43842.84,44498.79,45649.77,46724.05,47445.09]
["NUTS3","UKC21","Northumberland",29801.57,31059.91,31969.06,33100.050000000003,34253.599999999999,35129.949999999997,35202.050000000003,34892.720000000001,35822.94,36843.43,37943.47,38789.760000000002,39961.120000000003,40916.78,42008.160000000003,42398.35,42484.06]
["NUTS3","UKC22","Tyneside",31667.71,33252.620000000003,34649.39,36128.300000000003,37578.160000000003,38566.879999999997,38766.620000000003,38470.01,39366.18,40460.25,41498.620000000003,42153.68,42471.77,42718.69,43740.3,44864.36,45627.41]
["NUTS3","UKC23","Sunderland",34148.89,35692.449999999997,36866.339999999997,38087.85,39443.129999999997,40826.29,41866.25,42278.58,43213.86,44317.88,46239.6,49432.86,52201.18,54021.73,55722.89,57335.45,58542.85]
["NUTS1","UKD","North West",33336.89,34930.44,36331.11,38121.910000000003,39980.120000000003,41553.08,42165.54,42031.76,42724.52,43487.56,44455.47,45660.13,46667.74,47588.33,49002.38,50460.59,51373.16]
["NUTS2","UKD1","Cumbria",30705.51,32051.73,33249.18,34965.68,36691.03,38158.879999999997,38847.75,38857.56,39475.980000000003,39895.589999999997,40555.120000000003,41754.22,42854.8,43869.02,44965.15,46137.25,46817.32]
["NUTS3","UKD11","West Cumbria",30852.44,32116.01,33283.86,35117.21,37135.56,38931.480000000003,40117.1,40515.25,41589.129999999997,42278.55,43294.23,44790.38,45915.55,46435.95,46787.55,47263.45,47624.08]
["NUTS3","UKD12","East Cumbria",30604.17,32008.86,33227.68,34864.120000000003,36385.47,37622.339999999997,37962.89,37694.300000000003,37991.01,38220.21,38643.089999999997,39644.71,40731.61,42080.89,43689.2,45340.76,46242.05]
["NUTS2","UKD3","Greater Manchester",32428.2,33915.71,35264.79,37156.6,39238.160000000003,41093.03,41867.050000000003,41840.94,42535,43383.77,44358.35,45512.35,46275.83,46996.39,48159.12,49451.72,50211.67]
["NUTS3","UKD33","Manchester",34433.730000000003,36511.33,38646.519999999997,41446.61,43991.56,46321.67,47349.53,47667.87,48500.45,49032.32,49206.42,49285.120000000003,49430.07,49857.21,51232.32,52716.18,53676.54]
["NUTS3","UKD34","Greater Manchester South West",36164.74,37846.089999999997,39397.660000000003,41622.5,43983.62,45919.12,46423.57,45788.6,46103.24,47197.42,49160.2,51516.95,52977.14,53686.32,54827.78,56064.49,56976.34]
["NUTS3","UKD35","Greater Manchester South East",30818.560000000001,32015.74,32879.4,34138,35698.58,37200.03,38045.65,38211.839999999997,39132.230000000003,40015.599999999999,41103.019999999997,42266.23,42993.78,43811.96,45064.04,46586.64,47342.35]
["NUTS3","UKD36","Greater Manchester North West",31431.85,32671.32,33681.129999999997,35149.449999999997,37012.31,38664.43,39165.230000000003,38916.550000000003,39346.910000000003,40147.300000000003,41010.29,42350.55,43351,44445.56,45664.43,46913.77,47563.22]
["NUTS3","UKD37","Greater Manchester North East",28089.97,29121.85,29992.35,31308.61,33052.32,34585.67,35339.449999999997,35383.79,36124.68,36966.480000000003,37794.44,38801.230000000003,39328.32,39922.949999999997,40564.160000000003,41378.589999999997,41720.57]
["NUTS2","UKD4","Lancashire",32337,34008.199999999997,35312.589999999997,36770.99,37953.94,38796.32,38758.730000000003,38117.67,38606.120000000003,39350.660000000003,40545.33,41973.08,43447.74,45007.3,46970.55,48744.639999999999,49716.959999999999]
["NUTS3","UKD41","Blackburn with Darwen",26058.11,27270.39,28255.040000000001,29463.83,30636.959999999999,31634.98,32298.58,32859.449999999997,34185.769999999997,35160.81,35668.75,36574.879999999997,37931.29,40166.9,42332.5,44098.48,44676.32]
["NUTS3","UKD42","Blackpool",29075.38,30907.599999999999,32174.35,33577.910000000003,33941.21,33946.82,32934.339999999997,31932.99,32196.84,32802.28,33535.660000000003,34413.81,35474.78,37113.980000000003,39345.33,41461.269999999997,42575.32]
["NUTS3","UKD44","Lancaster and Wyre",30595.79,32208.19,33686.449999999997,35435.31,36925.040000000001,37594.76,36988.019999999997,35686.36,36000.959999999999,37201.35,39238.18,41175.5,42308.28,42734.16,43270.23,44041.73,44581.96]
["NUTS3","UKD45","Mid Lancashire",33146.32,34795.019999999997,36107.660000000003,37546.620000000003,38938.449999999997,40110.79,40500.49,39937.33,40393.35,40901.370000000003,42199.42,43595.56,45490.86,47284.03,50001.73,52187.32,53567.14]
["NUTS3","UKD46","East Lancashire",37114.400000000001,39301.61,41234.75,43425.74,44948.12,45702.47,45032.39,43880.33,44116.52,45026.8,46364.75,48345.99,49872.47,51395.74,52818.13,54332.62,55072.14]
["NUTS3","UKD47","Chorley and West Lancashire",32464.43,33772.519999999997,34312.32,34782.31,35322.5,36214.68,36807.449999999997,36750.400000000001,37279.26,37692.6,38317.550000000003,39336.300000000003,40535.910000000003,42222.17,44364.54,46431.48,47525.83]
["NUTS2","UKD6","Cheshire",39787.089999999997,41603.440000000002,43202.82,45214.39,47377.9,49082.98,49455.17,49013.440000000002,49804.41,50984.25,52529.24,53964.79,54940.959999999999,55531.48,57221.15,59197.07,60684.87]
["NUTS3","UKD61","Warrington",37479.39,39341.14,40691.449999999997,42560.23,44313.120000000003,45802.17,45398.18,44002.86,43722.79,44282.1,45605.97,47701.59,49339.16,50558.52,51340.82,52544.68,53254.41]
["NUTS3","UKD62","Cheshire East",43480.19,45446.93,47297.72,49227.85,51206.5,52358.85,52500.39,52030.59,53410.84,55360.82,57950.23,60044.57,62023.77,63648.84,67221.149999999994,70403.199999999997,72661.09]
["NUTS3","UKD63","Cheshire West and Chester",37458.67,39049.089999999997,40508.300000000003,42649.13,45271.64,47725.1,48949.4,49293,50264.99,51059.23,51559.46,51692.53,51103.93,50264.91,50834.79,52203.46,53463.69]
["NUTS2","UKD7","Merseyside",32525.13,34193.49,35729.79,37503.82,39426.639999999999,41149.910000000003,42283.73,42642.239999999998,43480.25,43888.74,44240.05,45066.8,45970.239999999998,46746.18,47946.57,49096.29,49908.639999999999]
["NUTS3","UKD71","East Merseyside",36783.94,38506.400000000001,39768.42,41085.07,42574.44,44017.99,45091.49,45447.39,46309.21,46836.61,47291.78,48598.52,49548.38,50400.160000000003,51624.2,53232.57,54422.559999999998]
["NUTS3","UKD72","Liverpool",34070.959999999999,35941.61,37737.699999999997,39790.99,41836.050000000003,43631.24,44804.160000000003,45334.16,46360.83,46835.77,47065.86,47661.14,48293.32,48718.63,49503.34,50254.46,50807.14]
["NUTS3","UKD73","Sefton",24872.42,26261.15,27739.54,29556.61,31689.58,33670.300000000003,35115.300000000003,35547.17,36269.43,36375.879999999997,36516.35,36950.160000000003,37967.879999999997,39194.58,41123.96,42694.49,43697.66]
["NUTS3","UKD74","Wirral",30322.14,31696.04,32975.32,34557.879999999997,36381.96,37899.96,38574.26,38409.1,38840.94,39145.39,39705.93,40558.07,41749.24,42674.68,43963.58,44810.46,45355.7]
["NUTS1","UKE","Yorkshire and The Humber",32109.63,33565.15,34706.44,36261.07,37972.050000000003,39571.11,40090.019999999997,39754.839999999997,40128.06,40714.53,41565.379999999997,42589.07,43233.82,43720.160000000003,44733.98,46001.55,46868.66]
["NUTS2","UKE1","East Yorkshire and Northern Lincolnshire",33387.18,34865.57,36118.28,37913.5,40125.550000000003,42109.27,42872.09,42127.51,42015.63,42013.440000000002,42623.85,43627.12,44359.42,44926.83,45776.91,46832.76,47495.55]
["NUTS3","UKE11","Kingston upon Hull, City of",33216.14,34502.050000000003,35487.42,37321.160000000003,39987.699999999997,42971.76,44923.61,44770.65,44332.77,43278.65,42863.18,43322.04,44107.53,44889.61,45872.639999999999,46630.93,46997.4]
["NUTS3","UKE12","East Riding of Yorkshire",34555.64,36343.160000000003,38137.78,39998.9,41850.620000000003,42748.22,42409.2,40857.17,40576.370000000003,41007.43,42258.23,43787.5,44474.47,44759.57,45225.62,46350.57,47182.8]
["NUTS3","UKE13","North and North East Lincolnshire",32548.79,33946.89,34992.5,36700.120000000003,38825.39,40875.46,41593.96,41057.47,41374.699999999997,41866.589999999997,42766.99,43753.52,44489.83,45142.13,46239.53,47485.22,48241.77]
["NUTS2","UKE2","North Yorkshire",33195.93,34842.589999999997,36087.97,37309.379999999997,38495.57,39488.57,39555.06,38892.99,39058.29,39614.519999999997,40457.620000000003,41423.879999999997,41996.78,42497.41,43742.16,45310.64,46399.26]
["NUTS3","UKE21","York",39619.54,41735.24,43527.71,45506.02,46900.15,47681.45,47067.69,45918.37,45933.36,46639.38,47781.91,49311.75,50264.55,50908.17,51861.33,52937,53626.38]
["NUTS3","UKE22","North Yorkshire CC",30798.83,32273.08,33336.68,34329.769999999997,35475.089999999997,36556.620000000003,36851.46,36348.18,36541.660000000003,37033.050000000003,37769.910000000003,38580.75,39072.120000000003,39582.949999999997,40937.32,42653.85,43844.32]
["NUTS2","UKE3","South Yorkshire",30006.97,31211.11,32015.29,33234.49,34735.24,36269.21,36919.81,36936.68,37753.71,38711.93,39742.129999999997,40766.32,41265.040000000001,41653.82,42531.11,43814.27,44684.76]
["NUTS3","UKE31","Barnsley, Doncaster and Rotherham",28936.400000000001,29962,30501.07,31464.3,32877.57,34468.730000000003,35267.15,35293.46,36087.69,36995.99,38129.46,39223.33,39913.760000000002,40490.910000000003,41623.120000000003,43082.36,44055.27]
["NUTS3","UKE32","Sheffield",31246.12,32666.07,33795.54,35322.400000000001,36924.620000000003,38370.67,38825.629999999997,38812.53,39650.379999999997,40666.550000000003,41582.300000000003,42539.93,42833.16,43020.69,43606.25,44685.45,45433.93]
["NUTS2","UKE4","West Yorkshire",32338.83,33858.01,35116.75,36899.54,38740.449999999997,40457.769999999997,40983.120000000003,40730.19,41119.769999999997,41735.910000000003,42586.16,43643.65,44367.040000000001,44870.09,45924.62,47136.06,47984.36]
["NUTS3","UKE41","Bradford",28348.38,29827.11,31195.72,32813.660000000003,34439.49,35754.5,36277.21,36128.31,36891.69,37810.480000000003,38911.64,39835.24,40403.800000000003,40836.699999999997,41905.660000000003,43090.25,43866.82]
["NUTS3","UKE42","Leeds",36200.07,38074.78,39706.26,42102.89,44351.33,46582.44,47120.74,46966.559999999998,47271,47865.98,48590.68,49633.8,50395.6,50735.34,51612.38,52568.29,53310.91]
["NUTS3","UKE44","Calderdale and Kirklees",27985.31,29226.799999999999,30167.73,31623.25,33270.080000000002,34864.449999999997,35363.980000000003,34908.32,35078.050000000003,35582.449999999997,36659.4,38056.730000000003,39121.160000000003,39985.370000000003,41238.07,42651.519999999997,43550.34]
["NUTS3","UKE45","Wakefield",34797.120000000003,35754.76,36191.4,36900.089999999997,38082.54,39086.379999999997,39531.03,39254.699999999997,39688.660000000003,40152.61,40605.06,41340.79,41659.19,42101.35,43198.31,44589.24,45562.5]
["NUTS1","UKF","East Midlands",32250.77,33611.160000000003,34588.589999999997,35718.01,37116.26,38501.01,39352.79,39410.800000000003,40168.01,40899.32,42002.17,43351.49,44354.1,44935.39,45947.89,47108.93,47957.7]
["NUTS2","UKF1","Derbyshire and Nottinghamshire",32169.11,33627.07,34737.9,35943.5,37260.800000000003,38489.089999999997,39172.57,39226.120000000003,40068.46,40966.089999999997,42064.639999999999,43259.05,44039.47,44558.86,45622.05,46854.720000000001,47708.33]
["NUTS3","UKF11","Derby",39218.81,41134.449999999997,42812.05,44729.24,46397.05,47630,48177.39,48336.81,49241.4,49757.07,49727.7,49949.4,49889.95,49633.73,49653.74,49716.84,49891.5]
["NUTS3","UKF12","East Derbyshire",30606.48,31960.560000000001,33186.639999999999,34699.81,36361.85,37903.74,38723.410000000003,38812.160000000003,39317.08,39632.480000000003,40615.919999999998,42232.47,44080.79,45353.05,46746.85,47883.81,48591.27]
["NUTS3","UKF13","South and West Derbyshire",31654.48,32956.04,33765.57,34649.72,35597.54,36520.32,36871.769999999997,36790.230000000003,37404.620000000003,38275.800000000003,39680.58,41774.25,43632.95,44970.74,46176.74,47123.28,47572.98]
["NUTS3","UKF14","Nottingham",27773.49,29408.62,31001.43,32853.47,34742.44,36521.160000000003,37380.07,37254.82,37621.440000000002,38199.410000000003,39169.64,40125.56,40709.43,41440.980000000003,43425.41,46024.69,47815.83]
["NUTS3","UKF15","North Nottinghamshire",30838.79,32041.01,32790.949999999997,33466.14,34451.17,35328.58,35962.949999999997,36011.25,37130.04,38298.19,39533.43,40514.980000000003,40899.93,40961.980000000003,41459.839999999997,42087.63,42558.16]
["NUTS3","UKF16","South Nottinghamshire",36434.269999999997,37873.620000000003,38506.050000000003,38895.919999999998,39648.94,40711.69,41892.89,42518.97,44624.93,46818.35,48857.38,49966.67,49828.11,49445.11,50374.6,51979.5,53332.160000000003]
["NUTS2","UKF2","Leicestershire, Rutland and Northamptonshire",32378.28,33735.26,34781.29,36122.160000000003,37861.35,39560.949999999997,40615.300000000003,40707.86,41408.75,41923.800000000003,42877.53,44255.24,45500.94,46243.44,47351.96,48524.83,49425.37]
["NUTS3","UKF21","Leicester",27009.23,28534.82,29977.759999999998,31653.599999999999,33551.96,35380.480000000003,36589.21,36827.14,37554.54,38018.379999999997,38639.42,39435.08,40258.160000000003,41071.089999999997,42939.31,45081.35,46727.87]
["NUTS3","UKF22","Leicestershire CC and Rutland",36268.519999999997,37644.550000000003,38428.589999999997,39428.78,40814.31,42435.66,43565.02,43815.75,44743.59,45397.11,46577.78,48049.15,49290.33,49741.03,50473.55,51255.16,51922.38]
["NUTS3","UKF24","West Northamptonshire",32368.3,33627.46,34771.440000000002,36428.71,38583.79,40336.6,41102.550000000003,40964.019999999997,41542.5,42306.35,43463.65,45403.66,47141.18,48366.67,49523.11,50479.02,51115.79]
["NUTS3","UKF25","North Northamptonshire",30743.38,31903.040000000001,32720.15,33753.519999999997,35308.14,36839.919999999998,37907.15,37844.35,38240.89,38200.239999999998,38791.47,39925.83,41094.370000000003,41777.769999999997,42705.22,43770.41,44570.49]
["NUTS2","UKF3","Lincolnshire",32158.47,33219.01,33594.660000000003,33928.480000000003,34684.69,35730.32,36562.17,36548.43,37196.120000000003,37994.57,39480.49,41200.550000000003,42203.28,42526.16,43106.22,44009.32,44700.61]
["NUTS3","UKF30","Lincolnshire",32158.47,33219.01,33594.660000000003,33928.480000000003,34684.69,35730.32,36562.17,36548.43,37196.120000000003,37994.57,39480.49,41200.550000000003,42203.28,42526.16,43106.22,44009.32,44700.61]
["NUTS1","UKG","West Midlands",32275.07,33766.370000000003,34881.980000000003,36136.1,37389.980000000003,38576.660000000003,39206.18,39383.040000000001,40409.769999999997,41434.5,42574.720000000001,43911.78,45063.69,46032.89,47510.64,49008.53,50021.53]
["NUTS2","UKG1","Herefordshire, Worcestershire and Warwickshire",34146.51,35488.199999999997,36333.07,37232.120000000003,38195.85,38961.68,39344.14,39407.980000000003,40773.08,42394.89,44351.5,46451.5,47838.21,48584.6,49391.79,50436.71,51187.82]
["NUTS3","UKG11","Herefordshire, County of",31385.06,32087.55,31936.65,31686.49,31731.56,32006.14,32271.24,32428.52,33531.35,34500.980000000003,35881.86,37508.730000000003,39143.019999999997,39668.120000000003,39869.07,39848.519999999997,39998.870000000003]
["NUTS3","UKG12","Worcestershire",30582.73,31819.23,32829.550000000003,34054.75,35477.42,36680.61,37486.089999999997,37906.43,39440.589999999997,41102.85,42989.81,44847.99,45773.52,45838.48,45822.07,46203.46,46588.66]
["NUTS3","UKG13","Warwickshire",38706.199999999997,40377.800000000003,41353.68,42228.08,42943.5,43380.88,43355.15,42997.57,44240.95,46019.61,48224.69,50666.11,52314.19,53681.63,55400.54,57378.13,58644.83]
["NUTS2","UKG2","Shropshire and Staffordshire",30971.39,32485.89,33672.07,34977.01,36260.29,37346.31,37750.910000000003,37635.269999999997,38447.980000000003,39329.29,40205.599999999999,41140.269999999997,41818.589999999997,42432.86,43567.79,44874.21,45781.29]
["NUTS3","UKG21","Telford and Wrekin",34650.379999999997,36092.519999999997,36778.36,37525.64,38348.699999999997,39494.160000000003,40152.879999999997,40377.67,40914.46,41185.94,40827.660000000003,40887.33,41135.230000000003,42683.38,45959.49,49569.56,51915]
["NUTS3","UKG22","Shropshire CC",29208.16,30703.13,31993.45,33283,34729.199999999997,35769.43,36026.82,35419.71,35847.26,36599.24,37589.96,38534.79,38909.360000000001,39112.43,39736.44,40744.35,41466.92]
["NUTS3","UKG23","Stoke-on-Trent",25840.65,27304.89,28903.02,30999.13,33289.83,35307.440000000002,36229.22,36205.07,36646.65,37250.44,38017.81,38959.06,39598.839999999997,40177.22,41432.559999999998,42985.14,44089.2]
["NUTS3","UKG24","Staffordshire CC",32435.73,33989.96,35105.43,36271.39,37254.46,38048.29,38306.120000000003,38300.089999999997,39460.1,40624.32,41775.71,42904.27,43814.41,44376.86,45173.27,45977.16,46558.55]
["NUTS2","UKG3","West Midlands",32114.44,33657.39,34853.18,36240.559999999998,37615.47,39072.910000000003,39964.160000000003,40373.46,41346.83,42139.92,43001.64,44171.41,45467.05,46750.09,48761.8,50593.17,51793.78]
["NUTS3","UKG31","Birmingham",32586.14,34173.629999999997,35414.160000000003,36944.550000000003,38500.550000000003,40344.33,41513.21,42006.13,42640.75,43028.63,43615.61,44776.44,45937.61,46925.59,48600.21,50307.87,51525.02]
["NUTS3","UKG32","Solihull",43649.88,45183.57,46287.199999999997,48090.01,50628.86,53060.83,54555.040000000001,54956.61,56404.34,57320.13,58264.67,59844.19,62083.47,65295.839999999997,69767.48,73910.789999999994,76345.820000000007]
["NUTS3","UKG33","Coventry",34285.910000000003,36159.81,37728.230000000003,39471.15,40999.83,42537.43,43442.04,43929,45400.56,46769.97,48264.46,49923.95,52247.06,54370.78,56534.21,57408.5,57639.57]
["NUTS3","UKG36","Dudley",27486.13,28652.5,29640.32,30760.1,32113.25,33078.25,33481.74,33486.019999999997,34550.07,35717.980000000003,36786.22,37778.61,38575.879999999997,39522.11,41285.730000000003,43176.43,44455.23]
["NUTS3","UKG37","Sandwell",28407.71,30024.560000000001,31370.75,32453.58,33173.040000000001,33724.06,34147.54,34466.69,35246.42,35572.620000000003,35676.03,36378.79,37603.79,39246.18,41893.83,44476.02,46292.73]
["NUTS3","UKG38","Walsall",25490.46,26616.32,27409.68,28512.35,29657.71,30990.35,31969.62,32976.03,34640.61,36076.160000000003,37066.15,37798.86,38505.07,38924.519999999997,39865.440000000002,40486.339999999997,40923.29]
["NUTS3","UKG39","Wolverhampton",32002.09,33616.879999999997,34684.230000000003,35614.1,36146.129999999997,36869.089999999997,37128.269999999997,36951.839999999997,37353.71,37909.32,38928.81,39687.230000000003,39942.25,39776.18,40606.550000000003,41787.18,42667.93]
["NUTS1","UKH","East of England",35812.68,37482.230000000003,38736.730000000003,40301.230000000003,41844.480000000003,43314.98,43926.48,43727.55,44238.68,44739.07,45582.64,46805.919999999998,47892.77,48870.06,50465.55,52153.74,53274.32]
["NUTS2","UKH1","East Anglia",33618.86,35176.620000000003,36299.410000000003,37687.68,39058.15,40572.1,41409.660000000003,41614.99,42463.97,43347.19,44412.01,45552.78,46290.98,46789.97,47995.66,49369.96,50359.21]
["NUTS3","UKH11","Peterborough",35615.68,37616.43,39543.75,41922.639999999999,43569.120000000003,44623.99,44458.55,44278.93,45387.34,46464.01,46979.43,46479.37,45678.57,45050.26,46638.41,48883.98,50886.97]
["NUTS3","UKH12","Cambridgeshire CC",36446.959999999999,38330.639999999999,39672.089999999997,40812.300000000003,41698.47,42882.51,43840.95,44535.23,46091.519999999997,47442.42,48561.98,49305.27,49730.36,50186.09,51604.07,53278.61,54440.27]
["NUTS3","UKH14","Suffolk",34702.49,36386.47,37649.49,39369.519999999997,40905.769999999997,42460.87,42911.89,42485.08,42684.46,43347.07,44692.86,46388.77,47621.41,48408.26,49645.62,50755.19,51445.35]
["NUTS3","UKH15","Norwich and East Norfolk",28664.22,29947.15,30851.29,31957.66,33344.199999999997,35170.65,36793.410000000003,37728.51,38855.71,39761.230000000003,40802.71,42489.24,43692.93,44595.9,45585.66,46881.49,47794.1]
["NUTS3","UKH16","North and West Norfolk",28887.02,29922.7,30614.400000000001,31783.94,33403.629999999997,34920.86,35636.49,35524.589999999997,36193.699999999997,37227.53,38483.9,39905.14,40536.949999999997,40830.04,41553.68,42448.63,43123.41]
["NUTS3","UKH17","Breckland and South Norfolk",33486.61,34391.120000000003,34575.11,35284.410000000003,36677.370000000003,38576.120000000003,39813.870000000003,40024.769999999997,40387.699999999997,40291.79,40644.720000000001,41354.32,42081.82,42280.07,43110.74,43985.48,44682.23]
["NUTS2","UKH2","Bedfordshire and Hertfordshire",39565.629999999997,41272.410000000003,42599.73,44417.16,46376.54,48044.84,48487.9,47764.7,47800.52,47889.26,48529.48,49806.16,51200.68,52716.57,54880.11,57001.2,58291.39]
["NUTS3","UKH21","Luton",39976.14,41022.9,41347.25,42219.12,43953.97,45870.29,47117.52,47128.37,47791.16,47942.87,48697.02,50808.37,53669.61,56213.96,58351.11,59762.91,60591.18]
["NUTS3","UKH23","Hertfordshire",40478.089999999997,42484.6,44223.91,46495.31,48660.03,50325.84,50550.26,49560.17,49401.24,49334.21,49812.28,50925.27,52039.09,53251.54,55009.74,56829.64,57910.79]
["NUTS3","UKH24","Bedford",34323.14,35283.54,35980.83,37133.629999999997,39161.120000000003,40926.9,41933.050000000003,41644.69,41926.33,41968.82,42433.47,43448.53,44569.39,45790.04,47740.88,49812.73,51205.46]
["NUTS3","UKH25","Central Bedfordshire",37993.050000000003,39275.99,39824.699999999997,40625.620000000003,41603.230000000003,42869.23,43203.45,42895.64,43282.19,44181.97,45655.88,47185.24,49045.21,51706.84,56630.75,61458.09,64507.4]
["NUTS2","UKH3","Essex",34893.730000000003,36670.870000000003,38053.15,39635.57,41036.19,42215.01,42638.2,42377.32,42920.58,43307.34,44028.84,45269.23,46500.08,47566.53,49081.54,50720.2,51816.85]
["NUTS3","UKH31","Southend-on-Sea",24642.03,26136.33,27598.55,29303.46,30861.85,32265.39,33188.29,33662.1,34576.639999999999,35179.800000000003,35611.39,36282.42,36710.79,37044.53,37463.61,38087.230000000003,38455.18]
["NUTS3","UKH32","Thurrock",39109.360000000001,41358.44,43377.29,45724.24,47347.66,48241.65,48156.03,47348.68,47649.54,47275.17,47201.599999999999,47448.39,48911.91,51005.51,54003.18,56368.68,57580.61]
["NUTS3","UKH34","Essex Haven Gateway",29913.49,31529.23,32747.119999999999,33944.589999999997,34865.43,35793.61,36418.550000000003,36602.25,37397.019999999997,37965.599999999999,38580.43,39575.4,40568.07,41942.18,43938.15,46059.7,47325.89]
["NUTS3","UKH35","West Essex",38763.97,40673.43,42369.02,44315.05,46271.23,47631.97,47895.03,47309.48,47383.86,47204.93,47199.91,48260.86,49450.27,50667.8,52041.96,53581.7,54540.19]
["NUTS3","UKH36","Heart of Essex",37625.18,39649.589999999997,41169.269999999997,43060.1,44524.2,45767.839999999997,45728.19,44997.1,45349.32,45946.98,47265.7,48982.27,50568.45,51299.98,52512.75,53911.38,55128.31]
["NUTS3","UKH37","Essex Thames Gateway",39042.76,40514.9,41244.43,42232.82,43540.99,44828.49,45442.29,45073.68,45704.49,46307.69,47723.040000000001,49708.27,51265.96,51973.93,53120.55,54593.08,55794.77]
["NUTS1","UKI","London",49069.39,51831.08,54534.559999999998,58114.38,61686.29,64871.67,66104.759999999995,66109.070000000007,67218.77,68393.070000000007,69693.919999999998,71321.2,72841.56,74170.86,76270.98,78278.17,79585.83]
["NUTS2","UKI3","Inner London - West",54215.54,57916.93,61921.51,66989.100000000006,71681.850000000006,75794.11,77338.59,77225.39,78025.070000000007,78960.05,80422.990000000005,82631.25,84937.76,86961.45,90082.81,93025.34,94985.55]
["NUTS3","UKI31","Camden and City of London",64620.44,70035.649999999994,76667.48,84994.31,92344.7,98186.35,99749.53,98601.83,97794.48,96979.55,96691.57,97925.6,99424.14,100873.71,103423.99,105979.54,107682.74]
["NUTS3","UKI32","Westminster",55285,58378.3,61292.66,64936.36,68446.8,71539.25,72691.88,72614.06,74005.02,75409.509999999995,77054.11,78682.880000000005,80794.95,83433.240000000005,88172.98,92711.71,95591.7]
["NUTS3","UKI33","Kensington & Chelsea and Hammersmith & Fulham",37115.53,39063.980000000003,40628.99,42583.49,44857.91,47445.35,48931.46,49208.87,50741.3,53480.69,57983.93,63032.54,66747.87,68101.23,68877.41,69512.06,70200.95]
["NUTS3","UKI34","Wandsworth",33019.01,34961.94,36698.43,38889.14,40781.78,42664.32,43824.29,44540.75,46165.15,47433.25,49161.71,51496.89,54060.4,55553.279999999999,56680.27,57333.82,57849.25]
["NUTS2","UKI4","Inner London - East",50680.97,53204.97,55442.25,58604.28,61908.58,65130.23,66805.84,67713.23,69790.929999999993,71324.25,71898.17,72139.23,72215.97,72820.38,74347.649999999994,75989,76856.820000000007]
["NUTS3","UKI41","Hackney and Newham",38471.980000000003,40744.269999999997,42969.17,45754.04,48591.42,50830.96,51801.919999999998,51170.34,51789.11,51966.6,52294.28,52376.34,52791.25,53838.720000000001,55453.46,56668.71,56982.11]
["NUTS3","UKI42","Tower Hamlets",82769.77,86506.4,89257.49,94529.69,100106.38,107117.05,110554.68,112048.36,112948.43,112791.64,112088.56,112111.1,112111.37,112140.97,113640.69,115732.91,116995.2]
["NUTS3","UKI43","Haringey and Islington",47754.75,49859.72,51605.84,53570.64,56027.44,58310.36,60047.71,61246.01,63954.400000000001,65942.53,67077.73,67630.62,67976.570000000007,68321.05,69669.960000000006,71233.899999999994,72345.52]
["NUTS3","UKI44","Lewisham and Southwark",44502.95,46241.89,47361.23,49028.51,50541.5,51953.440000000002,52485,53566.239999999998,56100.54,58507.32,59254.11,59795.82,59492.36,59983.64,60820.27,62006.36,62550.75]
["NUTS3","UKI45","Lambeth",44465.64,47025.14,49596.99,53482.39,57747.59,61706.65,63395.65,63648.24,65916.45,67769.17,68905.59,68353.16,68970.19,70365.02,73604.070000000007,75669.61,76745.2]
["NUTS2","UKI5","Outer London - East and North East",41091.25,43155.56,45264.13,48185.599999999999,51454.38,53913.24,54371.040000000001,53597.51,54240.59,55414.86,56653.1,57814.03,58468.480000000003,58902.31,59784.51,60608,61080.160000000003]
["NUTS3","UKI51","Bexley and Greenwich",44531.76,46559.75,48302.05,50906.86,53902.95,56384.12,56920.1,56017.34,56954.11,59024.78,61748.95,63921.63,64984.11,65301.39,66123.070000000007,66623.89,66828.72]
["NUTS3","UKI52","Barking & Dagenham and Havering",39676.620000000003,41897.25,44299.27,47683.73,51152.67,54192.54,55288.53,55469.56,56516.93,57669.09,58821.43,59907.39,60236.22,59612.800000000003,59051.61,58787.07,58731.34]
["NUTS3","UKI53","Redbridge and Waltham Forest",37151.410000000003,39209.07,41551.15,44633.41,47966.49,49962.5,49947.47,48760.79,49131.86,49670.19,50080.11,50745.919999999998,51577.71,52621.8,54058.239999999998,55402.92,56241.38]
["NUTS3","UKI54","Enfield",43735.55,45620.41,47453.1,49919.57,53152.52,55496.160000000003,55716.19,54506.84,54619.97,55507.45,56062.16,56630.95,56852.52,57810.32,59733.11,61580.77,62546.7]
["NUTS2","UKI6","Outer London - South",42111.28,44229.06,45957.11,48327.91,50441.73,52451.25,52876.34,52598.559999999998,53266.07,54306.51,55676.49,57245.71,58430.62,58883.12,59935.519999999997,60986.04,61912.17]
["NUTS3","UKI61","Bromley",43375.89,45512.49,47505.71,49608.89,51395.74,52503.15,52941.24,53068.82,54764.04,56326.720000000001,57774.61,58899.47,59959.85,60897.8,63156.3,65524.480000000003,67356.17]
["NUTS3","UKI62","Croydon",40432.699999999997,42878.23,45299.66,48343.15,51077.66,53712.65,54752.94,54887.11,55221.16,56235.46,57701.27,60367.5,61759.66,62075.61,62310.02,63097.21,63930.22]
["NUTS3","UKI63","Merton, Kingston upon Thames and Sutton",42560.88,44456.32,45601.88,47694.21,49609.38,51735.65,51787.75,51065.14,51401.120000000003,52245.61,53565.32,54800.36,55933.29,56240.15,57167.8,57772.18,58344]
["NUTS2","UKI7","Outer London - West and North West",46959.11,49137.3,50979.91,53344.32,56012.65,58184.7,58791.519999999997,57957.04,58487.67,59285.03,60950.21,63336.94,65741.58,67451.3,69333.34,70993.7,72171.27]
["NUTS3","UKI71","Barnet",38942.57,41088.11,43025.13,45273.68,47230.57,48433.23,47890.94,46426.91,46492.67,47203.59,48529.54,49839.93,51254.71,52161.64,53873.58,55149.99,56178.59]
["NUTS3","UKI72","Brent",42376.37,44320.95,46400.01,49498.02,53283.74,56171.1,56919.32,55907.67,56110.64,56697.35,57782.29,59655.25,61416.83,62345.83,62431.9,61957.43,61554.98]
["NUTS3","UKI73","Ealing",43040.17,45007.69,46599.99,48498.2,50780.480000000003,52868.12,54107.07,53464.98,53555.05,53311.1,54381.39,56450.32,58590.559999999998,60039.98,61922.64,63751.8,65155.55]
["NUTS3","UKI74","Harrow and Hillingdon",48707.62,50819.44,52091.87,53697.61,55188.1,56526.99,56594.54,55917.599999999999,56508.82,57221.58,58091.42,60325.84,63138.3,66041.740000000005,68195.41,69529.22,70073.77]
["NUTS3","UKI75","Hounslow and Richmond upon Thames",54805.919999999998,57334.59,59848.82,63053.83,67216.12,70595.399999999994,72037.320000000007,71286.84,72340.289999999994,73883.72,77307.62,80941.23,83885.25,84972.21,87353.91,90554.15,93276.59]
["NUTS1","UKJ","South East",39129.26,40968.39,42437.8,44263.42,46251.4,48190.65,49241.61,49337.66,50244.89,51149,52333.8,53837.37,54890.53,55641.59,56906.44,58462.15,59546.98]
["NUTS2","UKJ1","Berkshire, Buckinghamshire and Oxfordshire",44734.16,46767.79,48257.42,50349.03,52391.839999999997,54479.11,55471.09,55712.3,56906.09,58018.04,59245.48,60798.63,61774.49,62355,63394.68,64916.03,66049.820000000007]
["NUTS3","UKJ11","Berkshire",51547.68,54231.9,56494.45,59352.800000000003,61923.95,64391.8,65482.7,65566,66620.77,67866.8,69418.25,71416.850000000006,72698.45,73638.179999999993,75240.22,77188.320000000007,78496.45]
["NUTS3","UKJ12","Milton Keynes",47728.160000000003,49932.4,51699.23,54212.79,56408.82,58017.06,58078.080000000002,57480.36,58175.16,58982.07,60433.48,62962.83,65237.71,66875.990000000005,68861.95,71655.710000000006,73811.289999999994]
["NUTS3","UKJ13","Buckinghamshire CC",40026.86,41477.879999999997,42369.88,44207.199999999997,46524.71,49104.82,50519.59,51088.99,52311.73,53201.55,53718.89,54383.68,54332.7,53992.31,54189.39,55016.9,55828.37]
["NUTS3","UKJ14","Oxfordshire",37153.43,38673.32,39514.639999999999,40634.03,41755.269999999997,43157.46,44080.35,44562.720000000001,45985.68,47125.9,48346.13,49610.53,50402.7,50665.59,51022.41,51742.01,52300.22]
["NUTS2","UKJ2","Surrey, East and West Sussex",38752.089999999997,40540.21,42016.87,43757.73,45828.11,47778.31,48832.59,48685.65,49267.38,49950.53,51074.45,52678.43,53825.1,54699.3,55908.78,57323.65,58229.99]
["NUTS3","UKJ21","Brighton and Hove",31094.720000000001,32299.78,33322.559999999998,34897.879999999997,37045.629999999997,39180.199999999997,40483.620000000003,40595.74,41096.480000000003,41668.69,42896.44,44658.74,45734.96,46327.06,47432.39,49138.2,50421.73]
["NUTS3","UKJ22","East Sussex CC",28798.6,29991.439999999999,30861.94,31805.53,32890.370000000003,33671.5,33980.44,33828.269999999997,34449.4,34961.99,35319.31,36011.629999999997,36858.76,37745.279999999999,38979.839999999997,40000.910000000003,40687.93]
["NUTS3","UKJ25","West Surrey",44569.71,46444.09,47924.25,49498.38,51571.92,53499.97,54700,54649.71,55503.25,56490.14,58111.91,60428.01,62263.5,63751.07,65534.01,67511.08,68756.479999999996]
["NUTS3","UKJ26","East Surrey",49427.37,52472.639999999999,55665.37,59140.43,62283.9,64968.39,65956.22,65598.05,65825.36,66794,68597.87,70993.649999999994,71726.37,71626.41,71353.45,71825.75,71865.05]
["NUTS3","UKJ27","West Sussex (South West)",33885.96,35477.07,36596.54,37899.79,39574.65,41456.800000000003,42764.84,42637.49,43057.45,43283.59,43905.62,44817.15,45594.62,46893.66,48756.39,50718.29,51681.27]
["NUTS3","UKJ28","West Sussex (North East)",37213.339999999997,39008.629999999997,40359.82,42155.8,44376.29,46673.25,47794.89,47396,47709.61,48082.85,48810.05,49945.54,51008.29,51805.38,53040.36,54238.79,55195.16]
["NUTS2","UKJ3","Hampshire and Isle of Wight",36231.69,37955.519999999997,39327.57,41019.839999999997,42932,44933.55,46180.61,46590.3,47694.04,48731.44,49962.5,51384.97,52422.12,53212.3,54798.13,56682.65,58023.83]
["NUTS3","UKJ31","Portsmouth",27582.93,29129.75,30621.919999999998,32735.29,34947.86,37031.11,38075.86,38162.230000000003,39006.980000000003,40039.769999999997,41729.06,43654.8,44923.97,45288.23,45659.67,46346.39,46936.25]
["NUTS3","UKJ32","Southampton",33613.69,35760.639999999999,37810.26,40502.89,43320.160000000003,46736.19,49435.15,51647.78,54090.2,55894.57,56194.53,56285.16,56006.43,56635.93,58392.82,60519.95,61910.21]
["NUTS3","UKJ34","Isle of Wight",25262.74,26926.5,28509.25,29996.13,31195.53,32345.35,33402.85,33968.33,34955.39,35465.21,36454.36,38040.660000000003,39543.199999999997,40155.42,40452.71,40838.93,41216.379999999997]
["NUTS3","UKJ35","South Hampshire",36075.129999999997,37338.639999999999,38126.57,39171.83,40711.17,42249.67,43110.59,43228.38,44296.480000000003,45551.12,47477.42,49526.85,51243.360000000001,51900.81,53198.29,54465.18,55588.25]
["NUTS3","UKJ36","Central Hampshire",36963.519999999997,38459.769999999997,39315.17,40324.47,41707.769999999997,43224.52,43948.71,43712.98,44214.94,44827.26,45572.33,46491.06,47248.51,48404.43,50603.38,53000.94,54468.43]
["NUTS3","UKJ37","North Hampshire",46190.41,48542.39,50666.95,53100.63,55596.35,58049.47,59793.69,60557.56,62016.09,63078.75,64583.27,66472.45,67748.210000000006,68566.350000000006,70648.94,73542.16,75717.100000000006]
["NUTS2","UKJ4","Kent",33927.089999999997,35672.61,37213.050000000003,38939.040000000001,40756.19,42328.83,43198.38,43114.080000000002,43880.84,44624.04,45703.79,46963.21,47933.2,48669.43,49957.05,51371.72,52340.24]
["NUTS3","UKJ41","Medway",30081.49,31693.14,33047.58,34706.300000000003,36765.83,39206.620000000003,41130.94,42007.29,43288.25,44531.45,46094.55,47990.44,49147.18,49560.82,50253.64,51357.91,52333.1]
["NUTS3","UKJ43","Kent Thames Gateway",39695.760000000002,41312.54,42465.59,43474.55,44983.44,46034.78,46423.89,45504.83,45539.8,45726.57,46490.39,47932.44,49066.58,49727,50543.79,51457.84,52151.35]
["NUTS3","UKJ44","East Kent",30344.23,32077.55,33821.629999999997,35606.720000000001,37107.83,38184.76,38846.33,39079.199999999997,40125.07,40968.959999999999,42030.77,43181.2,43947.839999999997,44236.09,44989.78,46083.46,46976.45]
["NUTS3","UKJ45","Mid Kent",31305,32684.2,33697.199999999997,34970.68,36478.22,38064.160000000003,38996.449999999997,38996.49,39471.82,39855.919999999998,40547.26,41625.050000000003,42733,43687.11,44876.02,45784.11,46258.11]
["NUTS3","UKJ46","West Kent",38010.53,40271.81,42491.16,45242.21,47957.07,50053.93,50815.55,50154.75,50977.83,51965.5,53374.720000000001,54346.12,55124.11,56395.64,59205.86,62157.95,63983.55]
["NUTS1","UKK","South West",33003.68,34517.599999999999,35691.53,37097.230000000003,38601.040000000001,39990.879999999997,40650.93,40535.89,41231.93,41916.300000000003,42896.57,43963.45,44836.95,45537.95,46830.79,48198.35,49090.12]
["NUTS2","UKK1","Gloucestershire, Wiltshire and Bath/Bristol area",35753.730000000003,37384.68,38677.800000000003,40340.949999999997,42217.3,44047.49,45019.95,45033.96,45925.16,46785.8,48043.59,49279.51,50174.18,50772.79,52053.19,53516.44,54490.559999999998]
["NUTS3","UKK11","Bristol, City of",30970.79,32772.61,34387.5,36224.32,38107.1,40085.620000000003,41408.69,41905.07,42772.38,43194.42,43599.839999999997,44116.49,44870.34,45810.69,47640.44,49361.98,50397.88]
["NUTS3","UKK12","Bath and North East Somerset, North Somerset and South Gloucestershire",39433.120000000003,40706.910000000003,41436.46,42728.77,44584.05,46394.81,47107.88,46704.25,47288.05,48090.62,49719.73,51596.92,53135.4,53755.64,54962.99,56197.93,57267.24]
["NUTS3","UKK13","Gloucestershire",34357.33,36030.86,37471.449999999997,39296.89,40940.97,42229.3,42685.01,42586.15,43547.14,44272.639999999999,45189.82,46123.94,46893.16,47453.87,48414.02,49603.69,50360.49]
["NUTS3","UKK14","Swindon",45028.56,47365.16,49484.63,52580.84,56679.55,60969.17,63682.78,63928.71,64850.25,65650.09,67298.259999999995,69910.69,72389.8,74730.16,77004.62,79109.73,80145.289999999994]
["NUTS3","UKK15","Wiltshire",33378.39,34749.54,35648.57,36519.769999999997,37567.089999999997,38716.75,39488.379999999997,39594.92,40986.46,42791.81,44971.97,45951.89,45554.49,44915.57,45596.73,47158.41,48215.47]
["NUTS2","UKK2","Dorset and Somerset",32588.97,33916.050000000003,34854.480000000003,35966.43,37280.15,38466.21,38947.11,38686.959999999999,39145.160000000003,39553.07,40194.79,41058.050000000003,41971.41,42837.52,44143.12,45419.88,46190.92]
["NUTS3","UKK21","Bournemouth and Poole",34995.230000000003,36519.730000000003,37758.120000000003,39270.15,41161.379999999997,43115.38,44194.32,44241.96,44387.98,44386.23,44327.75,44908.66,45516.15,46462.12,47841.99,49168.79,49859.7]
["NUTS3","UKK22","Dorset CC",33612.019999999997,35183.589999999997,36325.379999999997,37274.75,38010.81,38359.730000000003,38215.440000000002,37543.31,38011.230000000003,38578.99,39681.9,41017.96,42413.05,43668.67,45224.02,46743.42,47619.06]
["NUTS3","UKK23","Somerset",30277.07,31321.62,31949.4,32916.04,34250.050000000003,35518.300000000003,36061.949999999997,35910.379999999997,36549.46,37077.769999999997,37791.620000000003,38468.620000000003,39221.89,39759.519999999997,40832.559999999998,41896.03,42639.35]
["NUTS2","UKK3","Cornwall and Isles of Scilly",27596.82,29082.89,30269.96,31408.54,32160.639999999999,32645.03,32665.75,32310.71,32779.29,33390.9,34250.26,35225.58,36013.31,36885.4,38315.699999999997,39809.769999999997,40724.629999999997]
["NUTS3","UKK30","Cornwall and Isles of Scilly",27596.82,29082.89,30269.96,31408.54,32160.639999999999,32645.03,32665.75,32310.71,32779.29,33390.9,34250.26,35225.58,36013.31,36885.4,38315.699999999997,39809.769999999997,40724.629999999997]
["NUTS2","UKK4","Devon",29532.53,31005.91,32210.61,33556.31,34872.14,35954.870000000003,36401.93,36200.79,36790.83,37409.81,38205.550000000003,39114.94,39829.019999999997,40432.25,41641.25,42863.5,43697.18]
["NUTS3","UKK41","Plymouth",26236.11,27567.24,28820.639999999999,30129.65,31496.41,32682.52,33561.54,33927.89,34824.75,35569.379999999997,36525.11,37671.65,38791.14,39725.43,41397.61,42906.28,43939.61]
["NUTS3","UKK42","Torbay",26163.43,27504.9,28783.78,30363.95,31957.02,33147.019999999997,33619.129999999997,33274.239999999998,33307.14,33039.78,33113.14,33954.32,35008.14,35921.9,36808.97,37552.730000000003,37945.89]
["NUTS3","UKK43","Devon CC",31230.94,32776.9,33945.32,35255.65,36494.379999999997,37517.040000000001,37801.18,37416.720000000001,37984.94,38705.82,39564.519999999997,40392.160000000003,40893.24,41313.440000000002,42398.94,43586.13,44413.33]
["NUTS1","UKL","Wales",30584.84,31970.46,33027.370000000003,34242.800000000003,35545.910000000003,36681.300000000003,37070.94,36999.370000000003,37886.300000000003,39088.76,40264.47,41357.879999999997,41936.620000000003,42532.25,43766.8,45205.16,46132.14]
["NUTS2","UKL1","West Wales and The Valleys",29418.86,30739.87,31776.67,32881.339999999997,34135.61,35109.980000000003,35460.29,35318.71,36194.35,37306.550000000003,38389.230000000003,39375.54,39898.639999999999,40485,41768.239999999998,43332.9,44376.08]
["NUTS3","UKL11","Isle of Anglesey",29367.33,30609.99,31612.42,32706.36,34073.97,35080.93,35211.65,34579,34649.660000000003,35043.03,35298.230000000003,35591.949999999997,35498.39,36041.97,37503.78,39251.1,40266.699999999997]
["NUTS3","UKL12","Gwynedd",31496.86,32998.239999999998,34458.410000000003,36190.93,38140.449999999997,39466.49,39603.360000000001,38957.25,39104.14,39265.53,39024.17,38840.620000000003,38641.379999999997,38686.269999999997,39385.15,40325.79,41072.29]
["NUTS3","UKL13","Conwy and Denbighshire",26976.080000000002,28073.95,28883.96,29686.69,30607.68,31123.38,31110.22,30899.09,31705.49,32759.14,33795.21,34914.11,35631.760000000002,36160.82,37128.81,38362.46,39250.660000000003]
["NUTS3","UKL14","South West Wales",29061.360000000001,30320.959999999999,31256.46,31878.63,32890.839999999997,33430.31,33416.959999999999,32573.4,33220.199999999997,34426.800000000003,35998.74,37088.32,37469.57,37768.75,38742.629999999997,40132.199999999997,41051.61]
["NUTS3","UKL15","Central Valleys",28479.43,29886.880000000001,30829.61,31985.73,33185.660000000003,34748.9,36031.230000000003,36890.129999999997,38201.410000000003,39369.69,40326.769999999997,41531.29,42474.07,43511.33,44801.11,45897.440000000002,46401.120000000003]
["NUTS3","UKL16","Gwent Valleys",29327.66,30735.67,31811.01,33040.53,34054.620000000003,34806.21,34820.14,34764.51,35729.760000000002,37033.5,37979.949999999997,39032.089999999997,39668.550000000003,40757.269999999997,42474.78,44523.89,45826.99]
["NUTS3","UKL17","Bridgend and Neath Port Talbot",33754.18,35184.400000000001,36275.31,37447.71,38723.01,39448.47,39654.199999999997,39473.61,40700.46,41969.07,43091.22,43967.4,44179.77,44747.37,46701.87,49487.199999999997,51462.66]
["NUTS3","UKL18","Swansea",27780.77,29054.81,30253.31,31723.82,33440.39,35059.620000000003,35941.57,36208.97,37147.42,38409.919999999998,39895.18,41212.71,42113.98,42650.14,43967.49,45203.13,46079.94]
["NUTS2","UKL2","East Wales",32153.89,33631.32,34722.639999999999,36102.339999999997,37476.36,38839.32,39283.769999999997,39309.69,40203.120000000003,41526.92,42836.94,44090.36,44747.03,45340.82,46480.07,47715.3,48463.49]
["NUTS3","UKL21","Monmouthshire and Newport",32932.32,34501.919999999998,35790.550000000003,37364.46,38761.85,39977.410000000003,40055.269999999997,39857.379999999997,40565.57,41881.29,43232.2,44471.98,45041.55,45323.79,46256.160000000003,47335.14,48117.59]
["NUTS3","UKL22","Cardiff and Vale of Glamorgan",32925.64,34438.54,35565.040000000001,37093.300000000003,38747.519999999997,40425.629999999997,41011.14,41029.019999999997,42016.82,43647.78,45345.66,46938.43,47800.86,48522.48,49843.25,51244.52,52117.81]
["NUTS3","UKL23","Flintshire and Wrexham",33823.879999999997,35277.360000000001,36143.199999999997,37172.46,38162.449999999997,39349.129999999997,40061.14,40529.11,41765.870000000003,42949.45,43773.51,44576.43,44919.38,45510.5,46486.09,47517.57,47985.45]
["NUTS3","UKL24","Powys",24479.01,25666.7,26589.48,27561.91,28394.3,29047.360000000001,29020.1,28597.52,28820.7,29371.98,30185.07,31121.23,31770.92,32385.33,33368.269999999997,34418.89,35013.69]
["NUTS1","UKM","Scotland",32899.39,34582.480000000003,36105.800000000003,37911.949999999997,39825.75,41695.26,42893.67,43395.21,44520.05,45624.639999999999,46931.12,48489.14,49585.86,50254.53,51465.13,52869.83,53902.52]
["NUTS2","UKM5","North Eastern Scotland",38238.199999999997,39900.620000000003,41684.97,44541.4,48497.75,52411.16,55024.54,55805.26,57218.32,58518.01,60446.29,62540.14,63466.83,62818.98,62374.79,62472.86,63009.91]
["NUTS3","UKM50","Aberdeen City and Aberdeenshire",38238.199999999997,39900.620000000003,41684.97,44541.4,48497.75,52411.16,55024.54,55805.26,57218.32,58518.01,60446.29,62540.14,63466.83,62818.98,62374.79,62472.86,63009.91]
["NUTS2","UKM6","Highlands and Islands",30835.97,32595.61,34217.379999999997,35828.769999999997,37174.730000000003,38545.19,39684.639999999999,40698.49,42400.95,43871.05,45068.46,46116.04,46767.93,47288.639999999999,48413.58,49838.32,50804.44]
["NUTS3","UKM61","Caithness and Sutherland and Ross and Cromarty",32117.05,33998.18,35647.620000000003,37050.9,37839.93,38467.800000000003,39086.26,39866.199999999997,41692.370000000003,43182,44525.74,45701.78,46799.16,47953.53,49759.1,51719.98,52926.45]
["NUTS3","UKM62","Inverness and Nairn and Moray, Badenoch and Strathspey",30717.22,32458.34,34108.83,35846.769999999997,37397.980000000003,38943.339999999997,40248.03,41343.919999999998,43129.13,44605.1,45806.77,46986.02,47786.76,48591.99,49919.64,51544.73,52575.46]
["NUTS3","UKM63","Lochaber, Skye and Lochalsh, Arran and Cumbrae and Argyll and Bute",27371.08,29150.33,30806.69,32283.58,33305.300000000003,34481.89,35532.769999999997,36471.06,37797.86,39035.75,40237.46,41488.620000000003,42284.45,42835.92,43918.73,45345.87,46327.98]
["NUTS3","UKM64","Na h-Eileanan Siar",29490.59,31028.1,32608.85,34532.949999999997,36345.85,38320.980000000003,39942.35,41780.78,43802.62,44941.97,45000.1,44670.400000000001,44299.8,43760.46,43991.58,44569.09,45166.23]
["NUTS3","UKM65","Orkney Islands",37792.269999999997,40031.629999999997,41973.61,43879.13,45632.82,47546.64,49176.66,50173.02,52033.29,53241.8,53606.46,53197,52205.94,50740.18,49766.879999999997,49244.23,49278.55]
["NUTS3","UKM66","Shetland Islands",37713.550000000003,38750.93,39478.81,40726.43,43010.9,45156.26,45981.83,46156.25,47671.33,50227.89,52484.89,53467.040000000001,53160.35,52193.96,52767.57,53775.75,54740.66]
["NUTS2","UKM7","Eastern Scotland",35575.839999999997,37522.699999999997,39340.42,41540.949999999997,43820.89,46034.71,47309.93,47636.08,48473.61,49246.23,50352.65,52079.45,53754.46,55189.16,57139.839999999997,59002.96,60235.32]
["NUTS3","UKM71","Angus and Dundee City",30129.8,31610.12,32860.25,34280.01,35772.14,36997.339999999997,37550.85,37646.300000000003,39223.980000000003,41155.379999999997,43494.32,45109.55,45994.17,45784.37,46143.31,46556.22,47079.11]
["NUTS3","UKM72","Clackmannanshire and Fife",31718.62,33198.04,34413.4,36105.21,38575.480000000003,41452.660000000003,43666.82,44285.55,44900.38,44986.44,45270.98,46385.27,47730.17,49251.839999999997,50933.05,52475.21,53332.55]
["NUTS3","UKM73","East Lothian and Midlothian",30586.17,31809.38,32609.79,33452.769999999997,34451.07,35575.120000000003,36424.36,36891.43,37989.26,39099.839999999997,40394.949999999997,42078.61,43696.83,45286.27,47266.99,48942.48,49898.8]
["NUTS3","UKM75","City of Edinburgh",37992.51,40463.379999999997,43043.69,46190.96,49085.01,51849.38,53180.88,53364.86,53603.16,53919.77,55087.61,57596.86,60322.81,62645.62,65562.86,68165.7,69855.7]
["NUTS3","UKM76","Falkirk",38820.51,40923.47,43079.27,45697.17,48075.06,49823.44,50985.43,51432.61,52735.95,53198.84,53644.67,54071.73,54196.42,53839.5,55060.959999999999,57114.73,59100.25]
["NUTS3","UKM77","Perth and Kinross and Stirling",36458.86,38375.279999999999,39982.019999999997,41805.589999999997,43701.97,45562.8,46685.77,47161.45,48660.34,50494.400000000001,52675.75,55084.13,56722.01,57481.32,58302.02,59235.79,59912.53]
["NUTS3","UKM78","West Lothian",41835.56,43706.05,45261.5,47057.93,49121.49,50892.63,51621.06,51650.3,52434.14,52810.400000000001,52108.74,52219.1,53074.04,55516.93,58263.98,60647.79,61780.959999999999]
["NUTS2","UKM8","West Central Scotland",30946.73,32581.52,34025.769999999997,35552.26,36952.85,38170.129999999997,38840.300000000003,39154.720000000001,40264.49,41626.519999999997,42980.86,44370.7,44927.73,45301.89,46395.7,47917.7,49004.79]
["NUTS3","UKM81","East Dunbartonshire, West Dunbartonshire and Helensburgh and Lomond",28374.44,30312.720000000001,32219.5,33968.42,35083.919999999998,35904.82,36371.03,36876.269999999997,38080.980000000003,39168.42,40115.39,41463.879999999997,43109.13,44956,47266.79,49378.25,50645.65]
["NUTS3","UKM82","Glasgow City",30696.71,32337.67,33886.75,35778.160000000003,37600.589999999997,39110.25,39667.089999999997,39750.39,40686.43,42182.2,43596.66,44942.23,44920.17,44813.54,45548.92,47045.96,48135.8]
["NUTS3","UKM83","Inverclyde, East Renfrewshire and Renfrewshire",30507.17,31985.200000000001,33224.239999999998,34290.58,35336.449999999997,36249.24,37047.379999999997,37469.300000000003,38693.760000000002,39880.65,41270.29,42487.199999999997,42997.7,42768.34,43143.66,43951.05,44736.49]
["NUTS3","UKM84","North Lanarkshire",33805,35384.199999999997,36396.14,37072.6,37641.300000000003,38459.39,39440.85,40248.29,41725.21,43048.9,44437.599999999999,46216.04,48013.86,49698.58,51949.51,53932.45,55188.5]
["NUTS2","UKM9","Southern Scotland",27568.05,28688.42,29475.13,30361.01,31428.240000000002,32606.84,33554,34013.82,34929,35589.89,36602.080000000002,37881.93,39114.69,39802.31,40925.760000000002,42034.720000000001,42892.53]
["NUTS3","UKM91","Scottish Borders",25605.87,26621.33,27313.119999999999,27863.86,28597.52,29299.98,29962.81,30438.73,31582.51,32496.07,33739.910000000003,35331.64,37112.04,38364.81,39936.480000000003,41406.410000000003,42475.38]
["NUTS3","UKM92","Dumfries and Galloway",30191.73,31327.5,31855.11,32320.48,32970.36,33858.019999999997,34487.050000000003,34627.760000000002,35329.25,36068.97,37228.080000000002,38644.620000000003,39736.58,40193.54,40958.99,41803.96,42468.99]
["NUTS3","UKM93","East Ayrshire and North Ayrshire mainland",27345.67,28641.17,29853.75,31291.82,32679.279999999999,33905.660000000003,34504.85,34760.230000000003,35574.35,36530.42,37719.79,38912.300000000003,39539.769999999997,39414.44,39778.11,40343.769999999997,40971.599999999999]
["NUTS3","UKM94","South Ayrshire",26415,27575.39,28282.23,29087.57,29739.43,30577.83,31381.4,32078.91,33289.480000000003,33630.559999999998,33804.82,34153.26,35302.82,36538.47,38296.410000000003,39774.089999999997,40751.75]
["NUTS3","UKM95","South Lanarkshire",27641.69,28656,29343.58,30227.42,31588.07,33220.730000000003,34750.46,35411.61,36283.93,36712.04,37757.120000000003,39264.559999999998,40794.32,41734.17,43169.55,44540.6,45545.33]
["NUTS1","UKN","Northern Ireland",32224.19,33713.39,34869.51,36305.61,37771.1,39078.959999999999,39378.46,39054.71,39654.82,40765.57,42226.04,43774.12,44996.62,46188.7,47943.49,49668.72,50646.21]
["NUTS2","UKN0","Northern Ireland",32224.19,33713.39,34869.51,36305.61,37771.1,39078.959999999999,39378.46,39054.71,39654.82,40765.57,42226.04,43774.12,44996.62,46188.7,47943.49,49668.72,50646.21]
["NUTS3","UKN06","Belfast",33216.550000000003,35026.620000000003,36660.9,38733.96,40636.870000000003,42351.11,42570.93,42046.45,42151.12,43204.24,44689.62,46592.97,47893.41,49185.21,51319.48,53730.83,55317.42]
["NUTS3","UKN07","Armagh City, Banbridge and Craigavon",29913.82,31233.85,32247.41,33418.53,34662.620000000003,35640.36,35909.050000000003,35661.480000000003,36399.089999999997,37189.620000000003,38243.879999999997,39228.76,40138.910000000003,40976.22,42415.22,43839.37,44675.43]
["NUTS3","UKN08","Newry, Mourne and Down",28942.42,30166.15,31076.95,32101.17,33211.17,34041,34119.4,33709.01,34444.629999999997,35775.32,37693.4,39535.33,41074.39,42074.33,43294.71,44232.19,44722.73]
["NUTS3","UKN09","Ards and North Down",28951.7,30144.53,31043.79,32474.73,34211.550000000003,35740.89,36054.94,35465.480000000003,36050.9,37042.04,38485.269999999997,39274.94,39881.86,40441.550000000003,42343.43,44389.39,45786.47]
["NUTS3","UKN10","Derry City and Strabane",26375.31,27777.87,29178.04,30991.75,32706.15,33982.46,33990.68,33379.75,33516.93,34614.54,36088.97,37560.550000000003,38200.68,38690.910000000003,40001,41504.519999999997,42482.5]
["NUTS3","UKN11","Mid Ulster",39786.25,41203.839999999997,41945.55,42623.79,43283.15,43267.38,42243.44,40852.36,41203.360000000001,42135.57,43465.7,44522.3,45311.13,45780.33,47114.51,48520.36,49527.09]
["NUTS3","UKN12","Causeway Coast and Glens",29222.91,30419.07,31288.19,32522.11,33917.58,35437.03,36256.18,36879.49,38162.46,39488.39,40272.980000000003,40572.5,40640.519999999997,41301.93,43191.18,45148.59,46249.72]
["NUTS3","UKN13","Antrim and Newtownabbey",30860.58,32262.93,33155.360000000001,34384.04,35832.839999999997,37306.18,37515.910000000003,36877.360000000001,37173.58,38172.33,39650.28,41339.79,42866.16,44007.19,45389.05,46555.3,47297.93]
["NUTS3","UKN14","Lisburn and Castlereagh",32526.23,33734.65,34410.06,35350.14,36519.360000000001,37555.949999999997,37895.800000000003,37697.65,38974.26,40814.74,43131.57,45265.72,46555.02,47579.199999999997,49049.8,50769.23,51817.97]
["NUTS3","UKN15","Mid and East Antrim",43883.47,45665.8,46536.1,47139.64,48016.76,49800.7,52542.5,54825.27,57880.41,59311.75,60784.639999999999,63199.12,66918.080000000002,71894.55,75132.240000000005,76732.14,75906.490000000005]
["NUTS3","UKN16","Fermanagh and Omagh",29022.44,30460.37,31739.17,33293.980000000003,34737.410000000003,35775.43,35802.29,35178.21,35473.93,36140.980000000003,37254.199999999997,38349.589999999997,39299.5,40216.57,41724.269999999997,43113.52,43873.18]
[]
["Note 1: Data are nominal; ie, data are not adjusted for inflation."]
["Note 2: Data are smoothed using a weighted 5-year moving average"]
["Note 3: The GVA for Extra-Regio comprises compensation of employees and gross operating surplus which cannot be assigned to regions."]
[]
[]
["Source: Office for National Statistics"]