{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Instructions","Sign-off Form","Risk Reporting","Used","Programme Progress Summary","Project Progress Summary","Project reporting"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":2,"comments":2,"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":"Instructions","index":0,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[[4,1,6,1]]}
[null,"Town Deals - Performance Reporting Template (Interim)"]
[]
[null,"Instructions for completion"]
[null,"Purpose\n\nThis template enables you to report on progress in the delivery of projects that have received Town Deals payments from DLUHC. \n\nIt is an interim arrangement in advance of the requirement, as explained in the main M&E Guidance document, to report formally twice a year on Inputs and Activities (Level 1), and Outputs (Level 2). This Interim Reporting Template is intentionally shorter and requires less detail than the twice yearly reporting to be introduced in the Spring, but it is necessary to enable us to release any further grant payments at the beginning of the 2022/23 financial year.  \n\nThis template provides a structure for reporting on some of the key indicators which will be used for monitoring of the Town Deals."]
[null,"Instructions for each tab:\n\n1) 'Sign-off Form' - this sheet is to be used by the Section 151 Officer to approve the information provided in the rest of this spreadsheet. \n\n2) 'Risk Reporting' - use this sheet to detail the risks related to your programme and project(s). This sheet provides space to report on the top 3 risks relating to the programme, as well as the top 3 risks specific to each individual project that has already received Town Deal funding from DLUHC.\n\n3) 'Programme Progress Summary' - use this sheet to report on the listed mandatory indicators only. These are programme-wide (i.e. an aggregate of all the funded projects).\n\n4) 'Project Progress Summary' - use the full name for each project in the project reporting table to list each of your projects and refer to the RAG guidance key to inform how you rate each project's progress in terms of delivery, financial and risks. Please add extra lines to the table if required to include all projects.?\n\n5) 'Project Reporting' - use this to report on progress in the delivery of projects that have received Town Deals payments from DLUHC. \n"]

{"sheet":"Sign-off Form","index":1,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,2],[1,1,1,2],[5,1,5,2]]}
[]
[null,"Sign Off Form"]
[null,"The below box is to be completed by the Accountable Body's Section 151 Officer, confirming the information provided in this spreadsheet."]
[]
[null,"Name of Town and Local Authority"]
[null,"Loughborough - Charnwood Borough Council"]
[]
[]
[null,"Section 151 Officer Approved"]
[null,"Name:","Simon Jackson"]
[null,"Signature:"]
[null,"Date:","16th February 2022"]

{"sheet":"Risk Reporting","index":2,"n_rows":101,"n_cols":21,"rows_kept":101,"cut":false,"hidden":false,"merged":[[5,17,5,20],[7,3,7,13],[2,1,2,15]]}
[]
[]
[null,"Programme and Project Risks Report"]
[null,null,null,"Please complete the tables below to list the top 3 risks for the programme as a whole and add the top 3 risks for each individual project."]
[null,null,null,"Please complete white cells only."]
[null,null,null,"Top 3 Programme Risks",null,null,null,null,"Please refer to categories guide >>>",null,null,null,null,null,null,null,null,"Categories Guide"]
[]
[]
[null,"Programme",null,"Risk ID","Risk Category","Short description of the Risk","Full Description","Consequences","Pre-mitigated Impact","Pre-mitigated Likelihood","Pre- mitigated Risk Score","Mitigations","Post Mitigated Impact","Post Mitigated Likelihood","Post - mitigated Risk Score","Proximity",null," Impact","Likelihood","Risk Score","Proximity"]
[null,"Town Deals",null,"Example >","External Stakeholder Management","Siloed Working","Working or communicating as a discrete silo and not learning from other Programmes","Loss of opportunity to aggregate knowledge across teams, programmes, partners.","3 - Medium Impact","4 - High",{"$f":"VALUE(LEFT(J10,1))*VALUE(LEFT(I10,1))","v":12},"Cross-function quarterly catchups","1 -Very Low Impact","2 - Low",{"$f":"VALUE(LEFT(N10,1))*VALUE(LEFT(M10,1))","v":2},"4 - Next 3 months",null,"5 - Major Impact","5 - Very High","21 to 25","5 - Next 6 weeks"]
[null,null,1,"PROG1","Programme Delivery","Business case completion","Project Leads do not complete business cases before June / July 2022","The town's  full allocation of Town Deal funding cannot be drawn down from DLUHC","4 - High Impact","2 - Low",{"$f":"VALUE(LEFT(J11,1))*VALUE(LEFT(I11,1))","v":8},"Business case development timelines in place and capacity support provided.","3 - Medium Impact","1 - Very Low",{"$f":"VALUE(LEFT(N11,1))*VALUE(LEFT(M11,1))","v":3},"3 - Next 6 months",null,"4 - High Impact","4 - High","15 to 20","4 - Next 3 months"]
[null,null,2,"PROG2","Programme Delivery","Capacity limitations","Either the Accountable Body or project lead orgtanisations are affected by capacity limitations due to staffing shortages or other priorities caused by the pandemic","Delays in progressing business cases and assurance work. Diffuclutly in providing support and information to the Town Deal Board. ","3 - Medium Impact","1 - Very Low",{"$f":"VALUE(LEFT(J12,1))*VALUE(LEFT(I12,1))","v":3},"Project Team in place and commitments made to resource the Town Deal programme by the Council's Cabinet","2 - Low Impact","1 - Very Low",{"$f":"VALUE(LEFT(N12,1))*VALUE(LEFT(M12,1))","v":2},"1 - Over 12 months",null,"3 - Medium Impact","3 - Medium","9 to 14","3 - Next 6 months"]
[null,null,3,"PROG3","External Stakeholder Management","Poor quality business cases","Project Leads are unable to produce business cases to the required 'Green Book' standards.","The town's  full allocation of Town Deal funding cannot be drawn down from DLUHC","4 - High Impact","3 - Medium",12,"Independent consultants in place to work with project leads and assurance checks also carried out by an independent consultancy","3 - Medium Impact","1 - Very Low",3,"3 - Next 6 months",null,"2 - Low Impact","2 - Low","4 to 8","2 - Next 12 months"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1 -Very Low Impact","1 - Very Low","1 to 3","1 - Over 12 months"]
[null,null,null,"Top 3 Project Risks Per Project which has already received funding. "]
[null,"Project Title #1\n(in full)",null,"Risk ID","Risk Category","Short description of the Risk","Full Description","Consequences","Pre-mitigated Impact","Pre-mitigated Likelihood","Pre- mitigated Risk Score","Mitigations","Post Mitigated Impact","Post Mitigated Likelihood","Post - mitigated Risk Score","Proximity"]
[null,"Loughborough Public Realm: Bedford Square Gateway",1,"BSG1","Financial and Programme","Unexpected issues arising during construction work","Unexpected issues arising during construction works that impact on project costs and construction programme","Project costs could increase and the construction programme could extend","3 - Medium Impact","3 - Medium",{"$f":"VALUE(LEFT(J17,1))*VALUE(LEFT(I17,1))","v":9},"Site investigations pre-construction.  Robust project management and early warning procedures. Undertake value engineering to bring project in on budget. Use of project contingency.","2 - Low Impact","2 - Low",{"$f":"VALUE(LEFT(N17,1))*VALUE(LEFT(M17,1))","v":4},"3 - Next 6 months"]
[null,null,2,"BSG2","Financial","Construction cost inflation","Continued increases in the price of construction materials, materials supply shortages and increases in labour costs could increase the overall cost of the project such that it exceeds the available budget","Cost of project exceeds available budget","2 - Low Impact","3 - Medium",{"$f":"VALUE(LEFT(J18,1))*VALUE(LEFT(I18,1))","v":6},"Robust project management and early warning procedures to identify any potential unforseen issues.  Value engineering to maintain budget. Use of contingency.","2 - Low Impact","2 - Low",{"$f":"VALUE(LEFT(N18,1))*VALUE(LEFT(M18,1))","v":4},"3 - Next 6 months"]
[null,null,3,"BSG3","Regulatory","COVID-19","Government imposed restrictions related to COVID-18","Construction programme could be impacted and additional disruption for local businesses and general public","2 - Low Impact","2 - Low",4,"Regular monitoring of regulations and independent H&S checks. Continue to adopt safe working practices carried out under previous lockdowns and at other times during the pandemic","2 - Low Impact","2 - Low",4,"2 - Next 12 months"]
[]
[null,"Project Title #2\n(in full)",null,"Risk ID","Risk Category","Short description of the Risk","Full Description","Consequences","Pre-mitigated Impact","Pre-mitigated Likelihood","Pre- mitigated Risk Score","Mitigations","Post Mitigated Impact","Post Mitigated Likelihood","Post - mitigated Risk Score","Proximity"]
[null,"Taylor's: Saving the last major bell foundry in Britain",1,"LB1","Financial","Build cost inflation","Futher increases in the price of building materials and labour could increase the overall cost of the project such that it exceeds the available budget","Cost of project exceeds available budget","3 - Medium Impact","3 - Medium",{"$f":"VALUE(LEFT(J22,1))*VALUE(LEFT(I22,1))","v":9},"Monitoring inflation and account for prices in pre-tender estimate.  Undertake value engineering to bring project in on budget and/or use project contingency","2 - Low Impact","2 - Low",{"$f":"VALUE(LEFT(N22,1))*VALUE(LEFT(M22,1))","v":4},"3 - Next 6 months"]
[null,null,2,"LB2","Financial and Programme","Unforeseen issues arising during works.","Unforseen issues arising during construction that have an impact on project cost and programme","Cost of project could increase and programme could extend","2 - Low Impact","3 - Medium",{"$f":"VALUE(LEFT(J23,1))*VALUE(LEFT(I23,1))","v":6},"Significant survey work undertaken to identify any potential unforseen issues.  Should they arise, the contingency could be used or value engineering undertaken to maintain budget","2 - Low Impact","2 - Low",{"$f":"VALUE(LEFT(N23,1))*VALUE(LEFT(M23,1))","v":4},"2 - Next 12 months"]
[null,null,3,"LB3","Regulatory","COVID-19","Further restrictions related to COVID","Construction programme could be impacted","2 - Low Impact","2 - Low",4,"Monitor regulations and continue to apply safe working practices developed during previous lock-downs","2 - Low Impact","2 - Low",4,"2 - Next 12 months"]
[]
[null,"Project Title #3\n(in full)",null,"Risk ID","Risk Category","Short description of the Risk","Full Description","Consequences","Pre-mitigated Impact","Pre-mitigated Likelihood","Pre- mitigated Risk Score","Mitigations","Post Mitigated Impact","Post Mitigated Likelihood","Post - mitigated Risk Score","Proximity"]
[null,"Careers and Enterprise Hub (Phase1)",1,"PROJECT COMPLETED",null,null,null,null,null,null,{"$f":"VALUE(LEFT(J27,1))*VALUE(LEFT(I27,1))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"VALUE(LEFT(N27,1))*VALUE(LEFT(M27,1))","v":{"$error":"#VALUE!"}}]
[null,null,2,null,null,null,null,null,null,null,{"$f":"VALUE(LEFT(J28,1))*VALUE(LEFT(I28,1))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"VALUE(LEFT(N28,1))*VALUE(LEFT(M28,1))","v":{"$error":"#VALUE!"}}]
[null,null,3,null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,{"$error":"#VALUE!"}]
[]
[null,"Project Title #4\n(in full)",null,"Risk ID","Risk Category","Short description of the Risk","Full Description","Consequences","Pre-mitigated Impact","Pre-mitigated Likelihood","Pre- mitigated Risk Score","Mitigations","Post Mitigated Impact","Post Mitigated Likelihood","Post - mitigated Risk Score","Proximity"]
[null,"Programme Management",1,"SEE PROG1, PROG2 AND PROG3 ABOVE",null,null,null,null,null,null,{"$f":"VALUE(LEFT(J32,1))*VALUE(LEFT(I32,1))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"VALUE(LEFT(N32,1))*VALUE(LEFT(M32,1))","v":{"$error":"#VALUE!"}}]
[null,null,2,null,null,null,null,null,null,null,{"$f":"VALUE(LEFT(J33,1))*VALUE(LEFT(I33,1))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"VALUE(LEFT(N33,1))*VALUE(LEFT(M33,1))","v":{"$error":"#VALUE!"}}]
[null,null,3,null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,{"$error":"#VALUE!"}]
[]
[null,"Project Title #5\n(in full)",null,"Risk ID","Risk Category","Short description of the Risk","Full Description","Consequences","Pre-mitigated Impact","Pre-mitigated Likelihood","Pre- mitigated Risk Score","Mitigations","Post Mitigated Impact","Post Mitigated Likelihood","Post - mitigated Risk Score","Proximity"]
[null,null,1,null,null,null,null,null,null,null,{"$f":"VALUE(LEFT(J37,1))*VALUE(LEFT(I37,1))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"VALUE(LEFT(N37,1))*VALUE(LEFT(M37,1))","v":{"$error":"#VALUE!"}}]
[null,null,2,null,null,null,null,null,null,null,{"$f":"VALUE(LEFT(J38,1))*VALUE(LEFT(I38,1))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"VALUE(LEFT(N38,1))*VALUE(LEFT(M38,1))","v":{"$error":"#VALUE!"}}]
[null,null,3,null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,{"$error":"#VALUE!"}]
[]
[null,"Project Title #6\n(in full)",null,"Risk ID","Risk Category","Short description of the Risk","Full Description","Consequences","Pre-mitigated Impact","Pre-mitigated Likelihood","Pre- mitigated Risk Score","Mitigations","Post Mitigated Impact","Post Mitigated Likelihood","Post - mitigated Risk Score","Proximity"]
[null,null,1,null,null,null,null,null,null,null,{"$f":"VALUE(LEFT(J42,1))*VALUE(LEFT(I42,1))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"VALUE(LEFT(N42,1))*VALUE(LEFT(M42,1))","v":{"$error":"#VALUE!"}}]
[null,null,2,null,null,null,null,null,null,null,{"$f":"VALUE(LEFT(J43,1))*VALUE(LEFT(I43,1))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"VALUE(LEFT(N43,1))*VALUE(LEFT(M43,1))","v":{"$error":"#VALUE!"}}]
[null,null,3,null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,{"$error":"#VALUE!"}]
[]
[null,"Project Title #7\n(in full)",null,"Risk ID","Risk Category","Short description of the Risk","Full Description","Consequences","Pre-mitigated Impact","Pre-mitigated Likelihood","Pre- mitigated Risk Score","Mitigations","Post Mitigated Impact","Post Mitigated Likelihood","Post - mitigated Risk Score","Proximity"]
[null,null,1,null,null,null,null,null,null,null,{"$f":"VALUE(LEFT(J47,1))*VALUE(LEFT(I47,1))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"VALUE(LEFT(N47,1))*VALUE(LEFT(M47,1))","v":{"$error":"#VALUE!"}}]
[null,null,2,null,null,null,null,null,null,null,{"$f":"VALUE(LEFT(J48,1))*VALUE(LEFT(I48,1))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"VALUE(LEFT(N48,1))*VALUE(LEFT(M48,1))","v":{"$error":"#VALUE!"}}]
[null,null,3,null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,{"$error":"#VALUE!"}]
[]
[null,"Project Title #8\n(in full)",null,"Risk ID","Risk Category","Short description of the Risk","Full Description","Consequences","Pre-mitigated Impact","Pre-mitigated Likelihood","Pre- mitigated Risk Score","Mitigations","Post Mitigated Impact","Post Mitigated Likelihood","Post - mitigated Risk Score","Proximity"]
[null,null,1,null,null,null,null,null,null,null,{"$f":"VALUE(LEFT(J52,1))*VALUE(LEFT(I52,1))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"VALUE(LEFT(N52,1))*VALUE(LEFT(M52,1))","v":{"$error":"#VALUE!"}}]
[null,null,2,null,null,null,null,null,null,null,{"$f":"VALUE(LEFT(J53,1))*VALUE(LEFT(I53,1))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"VALUE(LEFT(N53,1))*VALUE(LEFT(M53,1))","v":{"$error":"#VALUE!"}}]
[null,null,3,null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,{"$error":"#VALUE!"}]
[]
[null,"Project Title #9\n(in full)",null,"Risk ID","Risk Category","Short description of the Risk","Full Description","Consequences","Pre-mitigated Impact","Pre-mitigated Likelihood","Pre- mitigated Risk Score","Mitigations","Post Mitigated Impact","Post Mitigated Likelihood","Post - mitigated Risk Score","Proximity"]
[null,null,1,null,null,null,null,null,null,null,{"$f":"VALUE(LEFT(J57,1))*VALUE(LEFT(I57,1))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"VALUE(LEFT(N57,1))*VALUE(LEFT(M57,1))","v":{"$error":"#VALUE!"}}]
[null,null,2,null,null,null,null,null,null,null,{"$f":"VALUE(LEFT(J58,1))*VALUE(LEFT(I58,1))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"VALUE(LEFT(N58,1))*VALUE(LEFT(M58,1))","v":{"$error":"#VALUE!"}}]
[null,null,3,null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,{"$error":"#VALUE!"}]
[]
[null,"Project Title #10\n(in full)",null,"Risk ID","Risk Category","Short description of the Risk","Full Description","Consequences","Pre-mitigated Impact","Pre-mitigated Likelihood","Pre- mitigated Risk Score","Mitigations","Post Mitigated Impact","Post Mitigated Likelihood","Post - mitigated Risk Score","Proximity"]
[null,null,1,null,null,null,null,null,null,null,{"$f":"VALUE(LEFT(J62,1))*VALUE(LEFT(I62,1))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"VALUE(LEFT(N62,1))*VALUE(LEFT(M62,1))","v":{"$error":"#VALUE!"}}]
[null,null,2,null,null,null,null,null,null,null,{"$f":"VALUE(LEFT(J63,1))*VALUE(LEFT(I63,1))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"VALUE(LEFT(N63,1))*VALUE(LEFT(M63,1))","v":{"$error":"#VALUE!"}}]
[null,null,3,null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,{"$error":"#VALUE!"}]
[]
[null,"Project Title #11\n(in full)",null,"Risk ID","Risk Category","Short description of the Risk","Full Description","Consequences","Pre-mitigated Impact","Pre-mitigated Likelihood","Pre- mitigated Risk Score","Mitigations","Post Mitigated Impact","Post Mitigated Likelihood","Post - mitigated Risk Score","Proximity"]
[null,null,1,null,null,null,null,null,null,null,{"$f":"VALUE(LEFT(J67,1))*VALUE(LEFT(I67,1))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"VALUE(LEFT(N67,1))*VALUE(LEFT(M67,1))","v":{"$error":"#VALUE!"}}]
[null,null,2,null,null,null,null,null,null,null,{"$f":"VALUE(LEFT(J68,1))*VALUE(LEFT(I68,1))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"VALUE(LEFT(N68,1))*VALUE(LEFT(M68,1))","v":{"$error":"#VALUE!"}}]
[null,null,3,null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,{"$error":"#VALUE!"}]
[]
[null,"Project Title #12\n(in full)",null,"Risk ID","Risk Category","Short description of the Risk","Full Description","Consequences","Pre-mitigated Impact","Pre-mitigated Likelihood","Pre- mitigated Risk Score","Mitigations","Post Mitigated Impact","Post Mitigated Likelihood","Post - mitigated Risk Score","Proximity"]
[null,null,1,null,null,null,null,null,null,null,{"$f":"VALUE(LEFT(J72,1))*VALUE(LEFT(I72,1))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"VALUE(LEFT(N72,1))*VALUE(LEFT(M72,1))","v":{"$error":"#VALUE!"}}]
[null,null,2,null,null,null,null,null,null,null,{"$f":"VALUE(LEFT(J73,1))*VALUE(LEFT(I73,1))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"VALUE(LEFT(N73,1))*VALUE(LEFT(M73,1))","v":{"$error":"#VALUE!"}}]
[null,null,3,null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,{"$error":"#VALUE!"}]
[]
[null,"Project Title #13\n(in full)",null,"Risk ID","Risk Category","Short description of the Risk","Full Description","Consequences","Pre-mitigated Impact","Pre-mitigated Likelihood","Pre- mitigated Risk Score","Mitigations","Post Mitigated Impact","Post Mitigated Likelihood","Post - mitigated Risk Score","Proximity"]
[null,null,1,null,null,null,null,null,null,null,{"$f":"VALUE(LEFT(J77,1))*VALUE(LEFT(I77,1))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"VALUE(LEFT(N77,1))*VALUE(LEFT(M77,1))","v":{"$error":"#VALUE!"}}]
[null,null,2,null,null,null,null,null,null,null,{"$f":"VALUE(LEFT(J78,1))*VALUE(LEFT(I78,1))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"VALUE(LEFT(N78,1))*VALUE(LEFT(M78,1))","v":{"$error":"#VALUE!"}}]
[null,null,3,null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,{"$error":"#VALUE!"}]
[]
[null,"Project Title #14\n(in full)",null,"Risk ID","Risk Category","Short description of the Risk","Full Description","Consequences","Pre-mitigated Impact","Pre-mitigated Likelihood","Pre- mitigated Risk Score","Mitigations","Post Mitigated Impact","Post Mitigated Likelihood","Post - mitigated Risk Score","Proximity"]
[null,null,1,null,null,null,null,null,null,null,{"$f":"VALUE(LEFT(J82,1))*VALUE(LEFT(I82,1))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"VALUE(LEFT(N82,1))*VALUE(LEFT(M82,1))","v":{"$error":"#VALUE!"}}]
[null,null,2,null,null,null,null,null,null,null,{"$f":"VALUE(LEFT(J83,1))*VALUE(LEFT(I83,1))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"VALUE(LEFT(N83,1))*VALUE(LEFT(M83,1))","v":{"$error":"#VALUE!"}}]
[null,null,3,null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,{"$error":"#VALUE!"}]
[]
[null,"Project Title #15\n(in full)",null,"Risk ID","Risk Category","Short description of the Risk","Full Description","Consequences","Pre-mitigated Impact","Pre-mitigated Likelihood","Pre- mitigated Risk Score","Mitigations","Post Mitigated Impact","Post Mitigated Likelihood","Post - mitigated Risk Score","Proximity"]
[null,null,1,null,null,null,null,null,null,null,{"$f":"VALUE(LEFT(J87,1))*VALUE(LEFT(I87,1))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"VALUE(LEFT(N87,1))*VALUE(LEFT(M87,1))","v":{"$error":"#VALUE!"}}]
[null,null,2,null,null,null,null,null,null,null,{"$f":"VALUE(LEFT(J88,1))*VALUE(LEFT(I88,1))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"VALUE(LEFT(N88,1))*VALUE(LEFT(M88,1))","v":{"$error":"#VALUE!"}}]
[null,null,3,null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,{"$error":"#VALUE!"}]
[]
[null,"Project Title #16\n(in full)",null,"Risk ID","Risk Category","Short description of the Risk","Full Description","Consequences","Pre-mitigated Impact","Pre-mitigated Likelihood","Pre- mitigated Risk Score","Mitigations","Post Mitigated Impact","Post Mitigated Likelihood","Post - mitigated Risk Score","Proximity"]
[null,null,1,null,null,null,null,null,null,null,{"$f":"VALUE(LEFT(J92,1))*VALUE(LEFT(I92,1))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"VALUE(LEFT(N92,1))*VALUE(LEFT(M92,1))","v":{"$error":"#VALUE!"}}]
[null,null,2,null,null,null,null,null,null,null,{"$f":"VALUE(LEFT(J93,1))*VALUE(LEFT(I93,1))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"VALUE(LEFT(N93,1))*VALUE(LEFT(M93,1))","v":{"$error":"#VALUE!"}}]
[null,null,3,null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,{"$error":"#VALUE!"}]
[]
[null,"Project Title #17\n(in full)",null,"Risk ID","Risk Category","Short description of the Risk","Full Description","Consequences","Pre-mitigated Impact","Pre-mitigated Likelihood","Pre- mitigated Risk Score","Mitigations","Post Mitigated Impact","Post Mitigated Likelihood","Post - mitigated Risk Score","Proximity"]
[null,null,1,null,null,null,null,null,null,null,{"$f":"VALUE(LEFT(J97,1))*VALUE(LEFT(I97,1))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"VALUE(LEFT(N97,1))*VALUE(LEFT(M97,1))","v":{"$error":"#VALUE!"}}]
[null,null,2,null,null,null,null,null,null,null,{"$f":"VALUE(LEFT(J98,1))*VALUE(LEFT(I98,1))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"VALUE(LEFT(N98,1))*VALUE(LEFT(M98,1))","v":{"$error":"#VALUE!"}}]
[null,null,3,null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,{"$error":"#VALUE!"}]
[]
[null,"Town Deals"]

{"sheet":"Used","index":3,"n_rows":28,"n_cols":10,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
["Risk Categories",null,"Financial Impact Inputs","Reputational Impact Inputs","Delivery Impact Inputs",null,"Proximity Inputs",null,"Likelihood Inputs"]
["Poor Policy Design",null,"1- Marginal financial impact","1 - Extremely Low: Unlikely to result in criticism however, action to remediate is required","1 - Minor negative impact on delivery objectives",null,"5 - Remote",0.5,"1 - Low",0.5]
["Poor Delivery",null,"2 - Low financial impact","2 - Low: May lead to local external criticism","2 - Significant negative impact on delivery objectives",null,"4 - Distant: next 12 months",0.75,"2 - Medium",0.75]
["Litigation & Legislation",null,"3 - Medium financial impact","3 - Medium: May lead to widespread criticism","3 - Substantial negative impact of delivery objectives",null,"3 - Approaching: next 6 months",0.9,"3 - High",0.95]
["Property Development",null,"4 - Significant financial impact ","4 - High: Undermine credibility with public or key stakeholder in short term","4 - Major negative impact on delivery objectives",null,"2 - Close: next 3 months",0.95,"4 - Almost Certain",1]
["Change in Policy Focus",null,"5 - Major financial impact ","5 - Very High: Significant damage to credibility with public or key stakeholder for sustained period or at critical point","5 - Critical negative impact on delivery objectives",null,"1 - Imminent: next month",1]
["Funding Withdrawal",null,"6 - Critical financial impact","6 - Critical: Event would destroy credibility with public or key stakeholder","6 - Catastrophic negative impact on delivery objectives"]
["Geopolitical, Environmental or Economic Shock"]
["External Stakeholder Management"]
["Delivery Partner Risk"]
["Poor Governance"]
["People Deficiency"]
["Ineffective Culture",null,null,"Other Drop-Down Lists"]
["Information Technology & Infrastructure"]
["Premises & Estate Management",null,null,"Red"]
["Credit Losses",null,null,"Amber"]
["Investment Losses",null,null,"Green"]
["Security / Cyber / Technical Risk"]
["Business Continuity & Disaster Recovery",null,null,"N/A [please explain in cell to the right]"]
["Operations",null,null,"Image [please return via email]"]
["Reporting",null,null,"Numerical [please insert in cell to the right]"]
["Procurement & Outsourcing",null,null,"Other [please include or explain in cell to the right]"]
["People / Wellbeing"]
["Employee Conduct"]
["Financial Crime"]
["Regulatory"]
["Client Mistreatment"]
["Reputational Risk"]

{"sheet":"Programme Progress Summary","index":4,"n_rows":9,"n_cols":17,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,15],[8,2,8,15],[6,2,6,15],[4,2,4,15],[7,2,7,15],[5,2,5,15],[2,1,2,15],[3,2,3,15]]}
[]
[null,"Programme-level Progress Summary"]
[null,"Please provide an update by addressing each of the questions set out below, highlighting the key issues/challenges and also what has worked well/been successful across your programme",null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"Category","Commentary"]
[null,"Delivery progress\nHow well are your funded projects progressing? \nHow are these projects progressing against milestones? \nHow many of these projects have started, were these on time? \nPlease name them. ","Loughborough had one Accelerated Fund project - the Careers and Enteprise Hub Phase 1 - which was completed within the required spend period and opened to the public in April 2021. The town's capacity funding and Programme Management funding is being deployed effectively on matters such as consultancy support, communications about the town deal and Programme Manager costs. Although DLUHC released funding for the Bedford Square Gateway and Loughborough Bellfoundry projects in December 2021, Grant Agreements between the projects and the Accountable Body are not yet in place (delays were due to staffing absences in the Council's legal team). Accordingly, nil town deal funding has yet been locally released to either project. Agreements are expected to be signed by the end of February 2022 which will allow both projects to move forward on schedule. "]
[null,"Delivery challenges\nWhat are the most common challenges facing these projects?","At this point in time there are no specific challenges affecting our projects other than all projects expect that project delivery costs could increase due to national and international inflationary pressures and incresing labout costs. "]
[null,"Delivery successes\nWhat has worked well or been successful?","We have been successful in completing the Careers and Enterprise Hub Phase 1 Project using Accelerated Funding. Six projects have to date produced business cases and these have all been approved following independent assurance checks which ensure the business cases meet Green Book standards. We have used Programme Management finance to effectively support the progression of projects to business case phase and to support the assurance and other work of the Town Deal Board. "]
[null,"Stakeholder engagement\nWho has been engaged and how?","Loughborough continues to have in a place a Community Engagement and Stakeholders Reference Group and a Members Reference Group, both of which discuss town deal matters and their Chairs represent them on the Town Deal Board. The Groups contain councillors, local business people. stakeholders in town deal projects and representatives of the local community. Projects are rerquired to identify how they will engage with stakeholders in their PIDS and business cases and our Town Deal Communications and Engagement Plan is in place. We have been pro-active in communicating through the media / social media the progress of the Town Deal and its projects. "]
[null,"Finance\nAre these projects delivering to budget? Please list any changes. \nHave Freedoms & Flexibilities been used, if so why and when you plan to reconcile this? ","The Careers and Enterprise Hub Phase 1 project was delivered to budget. There is no forecast overspend on the use of Programme Management funding. Local Grant Agreements are not yet in place for Loughborough Bellfoundry and Bedford Square Gateway. It has not been necessary to use Freedoms and Flexibilities. "]

{"sheet":"Project Progress Summary","index":5,"n_rows":47,"n_cols":16,"rows_kept":47,"cut":false,"hidden":false,"merged":[[4,0,4,1],[4,18,4,19],[4,20,4,21],[4,22,4,23],[0,0,0,1],[0,18,0,19],[0,20,0,21],[0,22,0,23],[2,10,2,11],[2,1,2,8],[3,8,3,9],[3,1,3,2],[1,1,1,8],[0,25,0,26],[4,25,4,26],[5,18,5,19],[5,20,5,21],[5,22,5,23],[5,25,5,26],[8,25,8,26],[9,25,9,26],[8,18,8,19],[8,20,8,21],[8,22,8,23],[6,18,6,19],[6,20,6,21],[6,22,6,23],[6,25,6,26],[7,18,7,19],[7,20,7,21],[7,22,7,23],[7,25,7,26],[10,18,10,19],[10,20,10,21],[10,22,10,23],[9,18,9,19],[9,22,9,23],[9,20,9,21],[12,18,12,19],[12,20,12,21],[12,22,12,23],[12,25,12,26],[11,18,11,19],[11,20,11,21],[11,22,11,23],[11,25,11,26],[10,25,10,26],[13,25,13,26],[23,22,23,23],[23,25,23,26],[22,22,22,23],[22,25,22,26],[46,0,46,1],[46,18,46,19],[24,0,24,1],[24,18,24,19],[46,20,46,21],[24,20,24,21],[46,22,46,23],[46,25,46,26],[5,10,5,15],[45,18,45,19],[45,20,45,21],[45,22,45,23],[45,25,45,26],[24,22,24,23],[24,25,24,26],[13,18,13,19],[13,20,13,21],[13,22,13,23],[22,18,22,19],[22,20,22,21],[23,18,23,19],[23,20,23,21]]}
[]
[null,"Projects Progress Summary "]
[null,"Note: spend definition= 'It is for Section 151 Officers to determine, but expenditure must be within the total Town Deal award and must support the projects agreed by DLUHC' "]
[null,"Towns Fund FAQs (p.33) "]
[null,null,null,null,null,"Please refer to key for RAG descriptions >>>"]
[null,"Project Name","Fund","Start Date","Completion Date","Delivery (RAG)","Spend (RAG)","Risk (RAG)","RAG commentary",null,"RAG Guidance"]
["Example","1. The Dome Redevelopment","Town Deal","2021-04-01","2022-09-30",4,3,2,"Contractors scheduled to be on site in January. Running 4 months behind schedule, completion moved to Sept 22. Spend currently about 20% below financial forecast.",null,"Delivery","Score","Spend","Score","Risks","Score"]
[null,"Loughborough Public Realm: Bedford Square Gateway","Town Deal","Pending local TD Grant Agreement","2023-08-31",3,1,2,"Good progress has been made with early phases of the overall scheme which were not funded by the Town Deal.  Some slight delays in delivery are occuring due to issues with BT Openreach works scheduling but this I not expected to have any significant effect on the scheme's progress using Town Deal funding. ",null,"Major issues causing significant delays (more than 6 months); processes interrupted or not carried out as planned (e.g. planning permission not secured); or significant changes to project. Project likely to under-deliver on forecast outputs.",5,"A variance of over 50% against profiled financial forecast (total expenditure) or significant changes to project finances required (increases or decreases) due to poor or delayed delivery.",5,"Programme includes projects with significant risks that are both high impact and high likelihood. Risk response not yet planned.",5]
[null,"Taylor's: Saving the last major bell foundry in Britain","Town Deal","Pending local TD Grant Agreement","31/09/2023",2,1,2,"Procurement of works due to start at end of February subject to receipt of TD funds. Principal risk remains build cost inflation which is being monitored and accounted for in pre-tender budget estimates",null,"Issues arising causing long delays to the timetable (3 to 6 months) but no significant changes required to overall project. Outputs may still be deliverable but challenging.",4,"A variance of between 30% & 50% against profiled financial forecast (total expenditure). Budget changes have been required due to issues with project delivery.",4,"Programme includes projects with significant risks that are either high impact or high likelihood. Risk responses planned but not implemented.",4]
[null,"Careers and Enterprise Hub (Phase 1)","Town Deal","2020-09-01","2021-03-31",null,null,null,"This project using Accelerated Funding is complete. ",null,"Issues arising causing some short delays to the timetable (less than 3 months). Outputs still deliverable but require re-scheduling.",3,"A variance of between 15% & 30% against profiled financial forecast Some budget changes have been required.",3,"Programme includes projects with some risks that have medium impact and/or medium likelihood. Risk responses planned and implemented.",3]
[null,"Programme Management","Town Deal","2021-05-01","2026-03-31",1,1,1,"The programme is currwently running to schedule and there is no forecast overspend on programme management based on expenditure to date. ",null,"Minor issues have arisen causing only small delays.  Project is on track to deliver outputs.",2,"A variance of between 5% & 15% Small re-profiling changes to budget required.",2,"Programme includes projects with some risks that have medium impact but low likelihood. Risk responses planned and implemented.",2]
[null,null,null,null,null,null,null,null,null,null,"No problems. Project is on track to deliver outputs and keeping to schedule.",1,"A variance of up to 5%. Spend is largely on track with any minor slippage expected to be picked up by end of next quarter.",1,"All risks are tolerable with low impact and likelihood and do not require a response.",1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"FHSF","Town Deal"]

{"sheet":"Project reporting","index":6,"n_rows":205,"n_cols":9,"rows_kept":205,"cut":false,"hidden":false,"merged":[[193,2,194,2],[193,4,193,5],[193,6,193,7],[193,8,193,9],[194,4,194,5],[194,6,194,7],[194,8,194,9],[191,2,192,2],[191,4,191,5],[191,6,191,7],[191,8,191,9],[192,4,192,5],[192,6,192,7],[192,8,192,9],[183,2,184,2],[183,4,183,5],[183,6,183,7],[183,8,183,9],[184,4,184,5],[184,6,184,7],[184,8,184,9],[186,2,186,3],[189,2,190,2],[189,4,189,5],[189,6,189,7],[189,8,189,9],[190,4,190,5],[190,6,190,7],[190,8,190,9],[187,2,187,3],[187,4,188,5],[187,6,188,7],[187,8,188,9],[188,2,188,3],[177,2,178,2],[177,4,177,5],[177,6,177,7],[177,8,177,9],[178,4,178,5],[178,6,178,7],[178,8,178,9],[181,2,182,2],[181,4,181,5],[181,6,181,7],[181,8,181,9],[182,4,182,5],[182,6,182,7],[182,8,182,9],[179,2,180,2],[179,4,179,5],[179,6,179,7],[179,8,179,9],[180,4,180,5],[180,6,180,7],[180,8,180,9],[173,2,174,2],[174,4,174,5],[174,6,174,7],[174,8,174,9],[175,4,175,5],[175,6,175,7],[175,8,175,9],[175,2,176,2],[176,4,176,5],[176,6,176,7],[176,8,176,9],[173,4,173,5],[173,6,173,7],[173,8,173,9],[170,4,170,5],[170,6,170,7],[170,8,170,9],[171,4,171,5],[171,6,171,7],[171,8,171,9],[166,2,166,3],[163,2,164,2],[169,4,169,5],[169,6,169,7],[169,8,169,9],[169,2,170,2],[167,2,167,3],[167,4,168,5],[167,6,168,7],[167,8,168,9],[168,2,168,3],[164,4,164,5],[164,6,164,7],[164,8,164,9],[171,2,172,2],[172,4,172,5],[172,6,172,7],[172,8,172,9],[159,6,159,7],[159,8,159,9],[162,4,162,5],[162,6,162,7],[162,8,162,9],[163,4,163,5],[163,6,163,7],[163,8,163,9],[160,4,160,5],[160,6,160,7],[160,8,160,9],[161,4,161,5],[161,6,161,7],[161,8,161,9],[161,2,162,2],[155,2,156,2],[155,4,155,5],[155,6,155,7],[155,8,155,9],[156,4,156,5],[156,6,156,7],[156,8,156,9],[153,2,154,2],[153,4,153,5],[153,6,153,7],[153,8,153,9],[154,4,154,5],[154,6,154,7],[154,8,154,9],[157,2,158,2],[157,4,157,5],[157,6,157,7],[157,8,157,9],[158,4,158,5],[158,6,158,7],[158,8,158,9],[159,2,160,2],[159,4,159,5],[146,2,146,3],[147,2,147,3],[147,4,148,5],[147,6,148,7],[147,8,148,9],[148,2,148,3],[151,2,152,2],[151,4,151,5],[151,6,151,7],[151,8,151,9],[152,4,152,5],[152,6,152,7],[152,8,152,9],[149,2,150,2],[149,4,149,5],[149,6,149,7],[149,8,149,9],[150,4,150,5],[150,6,150,7],[150,8,150,9],[143,2,144,2],[143,4,143,5],[143,6,143,7],[143,8,143,9],[144,4,144,5],[144,6,144,7],[144,8,144,9],[141,2,142,2],[141,4,141,5],[141,6,141,7],[141,8,141,9],[142,4,142,5],[142,6,142,7],[142,8,142,9],[134,4,134,5],[134,6,134,7],[134,8,134,9],[135,4,135,5],[135,6,135,7],[135,8,135,9],[139,2,140,2],[139,4,139,5],[139,6,139,7],[139,8,139,9],[140,4,140,5],[140,6,140,7],[140,8,140,9],[135,2,136,2],[136,4,136,5],[136,6,136,7],[136,8,136,9],[137,4,137,5],[137,6,137,7],[137,8,137,9],[137,2,138,2],[138,4,138,5],[138,6,138,7],[138,8,138,9],[132,4,132,5],[132,6,132,7],[132,8,132,9],[133,4,133,5],[133,6,133,7],[133,8,133,9],[126,2,126,3],[127,2,127,3],[127,4,128,5],[127,6,128,7],[130,4,130,5],[130,6,130,7],[130,8,130,9],[131,4,131,5],[131,6,131,7],[131,8,131,9],[129,4,129,5],[129,6,129,7],[129,8,129,9],[129,2,130,2],[131,2,132,2],[127,8,128,9],[128,2,128,3],[133,2,134,2],[122,4,122,5],[122,6,122,7],[122,8,122,9],[123,4,123,5],[123,6,123,7],[123,8,123,9],[121,2,122,2],[121,4,121,5],[121,6,121,7],[121,8,121,9],[123,2,124,2],[124,4,124,5],[124,6,124,7],[124,8,124,9],[115,2,116,2],[117,2,118,2],[118,4,118,5],[118,6,118,7],[118,8,118,9],[119,4,119,5],[119,6,119,7],[119,8,119,9],[116,4,116,5],[116,6,116,7],[116,8,116,9],[117,4,117,5],[117,6,117,7],[117,8,117,9],[119,2,120,2],[120,4,120,5],[120,6,120,7],[120,8,120,9],[115,4,115,5],[115,6,115,7],[115,8,115,9],[111,2,112,2],[108,2,108,3],[113,2,114,2],[114,4,114,5],[114,6,114,7],[114,8,114,9],[112,4,112,5],[112,6,112,7],[112,8,112,9],[113,4,113,5],[113,6,113,7],[113,8,113,9],[111,4,111,5],[111,6,111,7],[111,8,111,9],[106,2,106,3],[107,2,107,3],[107,4,108,5],[107,6,108,7],[107,8,108,9],[109,2,110,2],[110,4,110,5],[110,6,110,7],[110,8,110,9],[109,4,109,5],[109,6,109,7],[109,8,109,9],[102,4,102,5],[102,6,102,7],[102,8,102,9],[103,4,103,5],[103,6,103,7],[103,8,103,9],[101,2,102,2],[103,2,104,2],[104,4,104,5],[104,6,104,7],[104,8,104,9],[97,2,98,2],[99,2,100,2],[99,4,99,5],[99,6,99,7],[99,8,99,9],[100,4,100,5],[100,6,100,7],[100,8,100,9],[101,4,101,5],[101,6,101,7],[101,8,101,9],[97,4,97,5],[97,6,97,7],[97,8,97,9],[98,4,98,5],[98,6,98,7],[98,8,98,9],[95,4,95,5],[95,6,95,7],[95,8,95,9],[96,4,96,5],[96,6,96,7],[96,8,96,9],[79,2,80,2],[81,2,82,2],[84,4,84,5],[84,6,84,7],[84,8,84,9],[82,4,82,5],[82,6,82,7],[82,8,82,9],[83,4,83,5],[83,6,83,7],[83,8,83,9],[80,4,80,5],[80,6,80,7],[80,8,80,9],[81,4,81,5],[81,6,81,7],[81,8,81,9],[83,2,84,2],[78,4,78,5],[78,6,78,7],[78,8,78,9],[79,4,79,5],[79,6,79,7],[79,8,79,9],[71,2,72,2],[73,2,74,2],[76,4,76,5],[76,6,76,7],[76,8,76,9],[77,4,77,5],[77,6,77,7],[77,8,77,9],[74,4,74,5],[74,6,74,7],[74,8,74,9],[75,4,75,5],[75,6,75,7],[75,8,75,9],[75,2,76,2],[77,2,78,2],[72,4,72,5],[72,6,72,7],[72,8,72,9],[73,4,73,5],[73,6,73,7],[73,8,73,9],[70,4,70,5],[70,6,70,7],[70,8,70,9],[71,4,71,5],[71,6,71,7],[71,8,71,9],[69,4,69,5],[69,6,69,7],[69,8,69,9],[66,2,66,3],[67,2,67,3],[67,4,68,5],[67,6,68,7],[67,8,68,9],[68,2,68,3],[69,2,70,2],[61,2,62,2],[61,4,61,5],[61,6,61,7],[61,8,61,9],[62,4,62,5],[62,6,62,7],[62,8,62,9],[63,4,63,5],[63,6,63,7],[63,8,63,9],[63,2,64,2],[64,4,64,5],[64,6,64,7],[64,8,64,9],[57,2,58,2],[59,4,59,5],[59,6,59,7],[59,8,59,9],[60,4,60,5],[60,6,60,7],[60,8,60,9],[57,4,57,5],[57,6,57,7],[57,8,57,9],[58,4,58,5],[58,6,58,7],[58,8,58,9],[59,2,60,2],[53,2,54,2],[55,4,55,5],[55,6,55,7],[55,8,55,9],[56,4,56,5],[56,6,56,7],[56,8,56,9],[53,4,53,5],[53,6,53,7],[53,8,53,9],[54,4,54,5],[54,6,54,7],[54,8,54,9],[55,2,56,2],[49,2,50,2],[51,4,51,5],[51,6,51,7],[51,8,51,9],[52,4,52,5],[52,6,52,7],[52,8,52,9],[49,4,49,5],[49,6,49,7],[49,8,49,9],[50,4,50,5],[50,6,50,7],[50,8,50,9],[51,2,52,2],[43,4,43,5],[43,6,43,7],[43,8,43,9],[43,2,44,2],[44,4,44,5],[44,6,44,7],[44,8,44,9],[46,2,46,3],[47,2,47,3],[47,4,48,5],[47,6,48,7],[47,8,48,9],[48,2,48,3],[41,2,42,2],[41,4,41,5],[41,6,41,7],[41,8,41,9],[42,4,42,5],[42,6,42,7],[42,8,42,9],[39,2,40,2],[39,4,39,5],[39,6,39,7],[39,8,39,9],[40,4,40,5],[40,6,40,7],[40,8,40,9],[32,8,32,9],[37,2,38,2],[37,4,37,5],[37,6,37,7],[37,8,37,9],[38,4,38,5],[38,6,38,7],[38,8,38,9],[35,2,36,2],[35,4,35,5],[35,6,35,7],[35,8,35,9],[36,4,36,5],[36,6,36,7],[36,8,36,9],[19,6,19,7],[19,8,19,9],[21,8,21,9],[15,8,15,9],[17,2,18,2],[29,2,30,2],[29,4,29,5],[29,6,29,7],[29,8,29,9],[30,4,30,5],[30,6,30,7],[30,8,30,9],[27,2,27,3],[27,4,28,5],[27,6,28,7],[27,8,28,9],[28,2,28,3],[22,4,22,5],[22,6,22,7],[22,8,22,9],[20,4,20,5],[20,6,20,7],[20,8,20,9],[26,2,26,3],[1,2,1,9],[7,6,8,7],[7,8,8,9],[8,2,8,3],[7,2,7,3],[6,2,6,3],[7,4,8,5],[21,6,21,7],[21,4,21,5],[17,4,17,5],[18,4,18,5],[18,6,18,7],[15,4,15,5],[17,8,17,9],[15,6,15,7],[16,4,16,5],[16,6,16,7],[16,8,16,9],[15,2,16,2],[18,8,18,9],[21,2,22,2],[17,6,17,7],[19,2,20,2],[19,4,19,5],[4,11,4,12],[9,2,10,2],[9,6,9,7],[9,8,9,9],[9,4,9,5],[11,4,11,5],[13,4,13,5],[14,4,14,5],[14,6,14,7],[14,8,14,9],[12,4,12,5],[12,6,12,7],[12,8,12,9],[10,4,10,5],[10,6,10,7],[10,8,10,9],[5,2,5,3],[11,2,12,2],[13,2,14,2],[11,8,11,9],[11,6,11,7],[13,6,13,7],[13,8,13,9],[195,2,196,2],[195,4,195,5],[195,6,195,7],[195,8,195,9],[196,4,196,5],[196,6,196,7],[196,8,196,9],[197,2,198,2],[197,4,197,5],[197,6,197,7],[197,8,197,9],[198,4,198,5],[198,6,198,7],[198,8,198,9],[203,2,204,2],[203,4,203,5],[203,6,203,7],[203,8,203,9],[204,4,204,5],[204,6,204,7],[204,8,204,9],[199,2,200,2],[199,4,199,5],[199,6,199,7],[199,8,199,9],[200,4,200,5],[200,6,200,7],[200,8,200,9],[201,2,202,2],[201,4,201,5],[201,6,201,7],[201,8,201,9],[202,4,202,5],[202,6,202,7],[202,8,202,9],[24,6,24,7],[24,8,24,9],[23,6,23,7],[23,8,23,9],[23,2,24,2],[23,4,23,5],[24,4,24,5],[87,4,88,5],[87,6,88,7],[87,8,88,9],[88,2,88,3],[33,2,34,2],[33,4,33,5],[33,6,33,7],[33,8,33,9],[34,4,34,5],[34,6,34,7],[34,8,34,9],[31,2,32,2],[31,4,31,5],[31,6,31,7],[31,8,31,9],[32,4,32,5],[32,6,32,7],[89,2,90,2],[91,2,92,2],[93,2,94,2],[95,2,96,2],[86,2,86,3],[89,4,89,5],[89,6,89,7],[89,8,89,9],[90,4,90,5],[90,6,90,7],[90,8,90,9],[87,2,87,3],[93,4,93,5],[93,6,93,7],[93,8,93,9],[94,4,94,5],[94,6,94,7],[94,8,94,9],[91,4,91,5],[91,6,91,7],[91,8,91,9],[92,4,92,5],[92,6,92,7],[92,8,92,9]]}
[]
[null,null,"Project Reporting"]
[]
[null,null,"Please complete white cells only."]
[null,null,"Note: spend definition= 'It is for Section 151 Officers to determine, but expenditure must be within the total Town Deal award and must support the projects agreed by DLUHC' "]
[null,null,"Towns Fund FAQs (p.33) "]
[]
[null,"Project #1","Loughborough Public Realm: Bedford Square Gateway",null,"2019/20",null,"2020/21",null,"2021/22"]
[null,null,"Outputs"]
[null,null,"£ Total TF CDEL Payment \nThis must exclude TF Accelerated Funding","Forecast approved by DLUHC",0,null,0,null,700000]
[null,null,null,"Actual",0,null,0,null,665000]
[null,null,"£ 5% CDEL TF Pre-payment \nTowns Fund FAQs p.46-49","Forecast",0,null,0,null,35000]
[null,null,null,"Spent/committed",0,null,0,null,0]
[null,null,"[A] £ TF RDEL Payment ","Forecast approved by DLUHC",0,null,0,null,0]
[null,null,null,"Actual",0,null,0,null,0]
[null,null,"[B] £ TF RDEL Programme Management Payment\nOnly complete if received separately","Forecast approved by DLUHC",0,null,0,null,0]
[null,null,null,"Actual",0,null,0,null,0]
[null,null,"£ Total TF RDEL Payment = [A] +[B]","Forecast approved by DLUHC",{"$f":"$E$14+$E$16","v":0},null,{"$f":"$G$14+$G$16","v":0},null,{"$f":"$I$14+$I$16","v":0}]
[null,null,null,"Actual",{"$f":"$E$15+$E$17","v":0},null,{"$f":"$G$15+$G$17","v":0},null,{"$f":"$I$15+$I$17","v":0}]
[null,null,"£ TF RDEL Capacity Funding \nThis relates to funding received in 2019/20 and, if relevant 2020/21","Forecast",0,null,0,null,0]
[null,null,null,"Actual",0,null,0,null,0]
[null,null,"£ TF Accelerated Funding","Forecast",0,null,0,null,0]
[null,null,null,"Actual",0,null,null,null,0]
[null,null,"% of Projects Starting on Time According to Delivery Plan","Forecast","n/a",null,"n/a",null,"n/a"]
[null,null,null,"Actual","n/a",null,"n/a",null,"n/a"]
[]
[]
[null,"Project #2","Taylor's: Saving the Last Major Bell Foundry in Britain",null,"2019/20",null,"2020/21",null,"2021/22"]
[null,null,"Outputs"]
[null,null,"£ Total TF CDEL Payment \nThis must exclude TF Accelerated Funding","Forecast approved by DLUHC",0,null,0,null,417500]
[null,null,null,"Actual",0,null,0,null,396625]
[null,null,"£ 5% CDEL TF Pre-payment \nTowns Fund FAQs p.46-49","Forecast",0,null,0,null,20875]
[null,null,null,"Spent/committed",0,null,0,null,0]
[null,null,"[A] £ TF RDEL Payment ","Forecast approved by DLUHC",0,null,0,null,0]
[null,null,null,"Actual",0,null,0,null,0]
[null,null,"[B] £ TF RDEL Programme Management Payment\nOnly complete if received separately","Forecast approved by DLUHC",0,null,0,null,0]
[null,null,null,"Actual",0,null,0,null,0]
[null,null,"£ Total TF RDEL Payment = [A] +[B]","Forecast approved by DLUHC",{"$f":"E$34+E$36","v":0},null,{"$f":"G$34+G$36","v":0},null,{"$f":"I$34+I$36","v":0}]
[null,null,null,"Actual",{"$f":"E$35+E$37","v":0},null,{"$f":"G$35+G$37","v":0},null,{"$f":"I$35+I$37","v":0}]
[null,null,"£ TF RDEL Capacity Funding \nThis relates to funding received in 2019/20 and, if relevant 2020/21","Forecast",0,null,0,null,0]
[null,null,null,"Actual",0,null,0,null,0]
[null,null,"£ TF Accelerated Funding","Forecast",0,null,0,null,0]
[null,null,null,"Actual",0,null,0,null,0]
[null,null,"% of Projects Starting on Time According to Delivery Plan","Forecast","n/a",null,"n/a",null,"n/a"]
[null,null,null,"Actual","n/a",null,"n/a",null,"n/a"]
[]
[]
[null,"Project #3","Careers and Enterprise Hub Phase 1 [Accelerated Funding project]",null,"2019/20",null,"2020/21",null,"2021/22"]
[null,null,"Outputs"]
[null,null,"£ Total TF CDEL Payment \nThis must exclude TF Accelerated Funding","Forecast approved by DLUHC",0,null,0,null,0]
[null,null,null,"Actual",0,null,0,null,0]
[null,null,"£ 5% CDEL TF Pre-payment \nTowns Fund FAQs p.46-49","Forecast",0,null,0,null,0]
[null,null,null,"Spent/committed",0,null,0,null,0]
[null,null,"[A] £ TF RDEL Payment ","Forecast approved by DLUHC",0,null,0,null,0]
[null,null,null,"Actual",0,null,0,null,0]
[null,null,"[B] £ TF RDEL Programme Management Payment\nOnly complete if received separately","Forecast approved by DLUHC",0,null,0,null,0]
[null,null,null,"Actual",0,null,0,null,0]
[null,null,"£ Total TF RDEL Payment = [A] +[B]","Forecast approved by DLUHC",{"$f":"E$54+E$56","v":0},null,{"$f":"G$54+G$56","v":0},null,{"$f":"I$54+I$56","v":0}]
[null,null,null,"Actual",{"$f":"E$55+E$57","v":0},null,{"$f":"G$55+G$57","v":0},null,{"$f":"I$55+I$57","v":0}]
[null,null,"£ TF RDEL Capacity Funding \nThis relates to funding received in 2019/20 and, if relevant 2020/21","Forecast",0,null,0,null,0]
[null,null,null,"Actual",0,null,0,null,0]
[null,null,"£ TF Accelerated Funding","Forecast",0,null,750000,null,0]
[null,null,null,"Actual",0,null,750000,null,0]
[null,null,"% of Projects Starting on Time According to Delivery Plan","Forecast","n/a",null,1,null,"n/a"]
[null,null,null,"Actual","n/a",null,1,null,"n/a"]
[]
[]
[null,"Project #4","Programme Management",null,"2019/20",null,"2020/21",null,"2021/22"]
[null,null,"Outputs"]
[null,null,"£ Total TF CDEL Payment \nThis must exclude TF Accelerated Funding","Forecast approved by DLUHC",0,null,0,null,0]
[null,null,null,"Actual",0,null,0,null,0]
[null,null,"£ 5% CDEL TF Pre-payment \nTowns Fund FAQs p.46-49","Forecast",0,null,0,null,0]
[null,null,null,"Spent/committed",0,null,0,null,0]
[null,null,"[A] £ TF RDEL Payment ","Forecast approved by DLUHC",0,null,0,null,170000]
[null,null,null,"Actual",0,null,0,null,0]
[null,null,"[B] £ TF RDEL Programme Management Payment\nOnly complete if received separately","Forecast approved by DLUHC",0,null,0,null,845000]
[null,null,null,"Actual",0,null,0,null,114822.44]
[null,null,"£ Total TF RDEL Payment = [A] +[B]","Forecast approved by DLUHC",{"$f":"E$74+E$76","v":0},null,{"$f":"G$74+G$76","v":0},null,{"$f":"I$74+I$76","v":1015000}]
[null,null,null,"Actual",{"$f":"E$75+E$77","v":0},null,{"$f":"G$75+G$77","v":0},null,{"$f":"I$75+I$77","v":114822.44}]
[null,null,"£ TF RDEL Capacity Funding \nThis relates to funding received in 2019/20 and, if relevant 2020/21","Forecast",0,null,70000,null,0]
[null,null,null,"Actual",0,null,70000,null,0]
[null,null,"£ TF Accelerated Funding","Forecast",0,null,0,null,0]
[null,null,null,"Actual",0,null,0,null,0]
[null,null,"% of Projects Starting on Time According to Delivery Plan","Forecast","n/a",null,"n/a",null,"n/a"]
[null,null,null,"Actual","n/a",null,"n/a",null,"n/a"]
[]
[]
[null,"Project #5","<Enter the full title of the project in the Grant Offer Letter here>",null,"2019/20",null,"2020/21",null,"2021/22"]
[null,null,"Outputs"]
[null,null,"£ Total TF CDEL Payment \nThis must exclude TF Accelerated Funding","Forecast approved by DLUHC"]
[null,null,null,"Actual"]
[null,null,"£ 5% CDEL TF Pre-payment \nTowns Fund FAQs p.46-49","Forecast"]
[null,null,null,"Spent/committed"]
[null,null,"[A] £ TF RDEL Payment ","Forecast approved by DLUHC"]
[null,null,null,"Actual"]
[null,null,"[B] £ TF RDEL Programme Management Payment\nOnly complete if received separately","Forecast approved by DLUHC"]
[null,null,null,"Actual"]
[null,null,"£ Total TF RDEL Payment = [A] +[B]","Forecast approved by DLUHC",{"$f":"E$94+E$96","v":0},null,{"$f":"G$94+G$96","v":0},null,{"$f":"I$94+I$96","v":0}]
[null,null,null,"Actual",{"$f":"E$95+E97","v":0},null,{"$f":"G$95+G97","v":0},null,{"$f":"I$95+I97","v":0}]
[null,null,"£ TF RDEL Capacity Funding \nThis relates to funding received in 2019/20 and, if relevant 2020/21","Forecast"]
[null,null,null,"Actual"]
[null,null,"£ TF Accelerated Funding","Forecast"]
[null,null,null,"Actual"]
[null,null,"% of Projects Starting on Time According to Delivery Plan","Forecast"]
[null,null,null,"Actual"]
[]
[]
[null,"Project #6","<Enter the full title of the project in the Grant Offer Letter here>",null,"2019/20",null,"2020/21",null,"2021/22"]
[null,null,"Outputs"]
[null,null,"£ Total TF CDEL Payment \nThis must exclude TF Accelerated Funding","Forecast approved by DLUHC"]
[null,null,null,"Actual"]
[null,null,"£ 5% CDEL TF Pre-payment \nTowns Fund FAQs p.46-49","Forecast"]
[null,null,null,"Spent/committed"]
[null,null,"[A] £ TF RDEL Payment ","Forecast approved by DLUHC"]
[null,null,null,"Actual"]
[null,null,"[B] £ TF RDEL Programme Management Payment\nOnly complete if received separately","Forecast approved by DLUHC"]
[null,null,null,"Actual"]
[null,null,"£ Total TF RDEL Payment = [A] +[B]","Forecast approved by DLUHC",{"$f":"E$114+E$116","v":0},null,{"$f":"G$114+G$116","v":0},null,{"$f":"I$114+I$116","v":0}]
[null,null,null,"Actual",{"$f":"E$115+E$117","v":0},null,{"$f":"G$115+G$117","v":0},null,{"$f":"I$115+I$117","v":0}]
[null,null,"£ TF RDEL Capacity Funding \nThis relates to funding received in 2019/20 and, if relevant 2020/21","Forecast"]
[null,null,null,"Actual"]
[null,null,"£ TF Accelerated Funding","Forecast"]
[null,null,null,"Actual"]
[null,null,"% of Projects Starting on Time According to Delivery Plan","Forecast"]
[null,null,null,"Actual"]
[]
[]
[null,"Project #7","<Enter the full title of the project in the Grant Offer Letter here>",null,"2019/20",null,"2020/21",null,"2021/22"]
[null,null,"Outputs"]
[null,null,"£ Total TF CDEL Payment \nThis must exclude TF Accelerated Funding","Forecast approved by DLUHC"]
[null,null,null,"Actual"]
[null,null,"£ 5% CDEL TF Pre-payment \nTowns Fund FAQs p.46-49","Forecast"]
[null,null,null,"Spent/committed"]
[null,null,"[A] £ TF RDEL Payment ","Forecast approved by DLUHC"]
[null,null,null,"Actual"]
[null,null,"[B] £ TF RDEL Programme Management Payment\nOnly complete if received separately","Forecast approved by DLUHC"]
[null,null,null,"Actual"]
[null,null,"£ Total TF RDEL Payment = [A] +[B]","Forecast approved by DLUHC",{"$f":"E$134+E$136","v":0},null,{"$f":"G$134+G$136","v":0},null,{"$f":"I$134+I$136","v":0}]
[null,null,null,"Actual",{"$f":"E$135+E$137","v":0},null,{"$f":"G$135+G$137","v":0},null,{"$f":"I$135+I$137","v":0}]
[null,null,"£ TF RDEL Capacity Funding \nThis relates to funding received in 2019/20 and, if relevant 2020/21","Forecast"]
[null,null,null,"Actual"]
[null,null,"£ TF Accelerated Funding","Forecast"]
[null,null,null,"Actual"]
[null,null,"% of Projects Starting on Time According to Delivery Plan","Forecast"]
[null,null,null,"Actual"]
[]
[]
[null,"Project #8","<Enter the full title of the project in the Grant Offer Letter here>",null,"2019/20",null,"2020/21",null,"2021/22"]
[null,null,"Outputs"]
[null,null,"£ Total TF CDEL Payment \nThis must exclude TF Accelerated Funding","Forecast approved by DLUHC"]
[null,null,null,"Actual"]
[null,null,"£ 5% CDEL TF Pre-payment \nTowns Fund FAQs p.46-49","Forecast"]
[null,null,null,"Spent/committed"]
[null,null,"[A] £ TF RDEL Payment ","Forecast approved by DLUHC"]
[null,null,null,"Actual"]
[null,null,"[B] £ TF RDEL Programme Management Payment\nOnly complete if received separately","Forecast approved by DLUHC"]
[null,null,null,"Actual"]
[null,null,"£ Total TF RDEL Payment = [A] +[B]","Forecast approved by DLUHC",{"$f":"E$154+E$156","v":0},null,{"$f":"G$154+G$156","v":0},null,{"$f":"I$154+I$156","v":0}]
[null,null,null,"Actual",{"$f":"E$155+E$157","v":0},null,{"$f":"G$155+G$157","v":0},null,{"$f":"I$155+I$157","v":0}]
[null,null,"£ TF RDEL Capacity Funding \nThis relates to funding received in 2019/20 and, if relevant 2020/21","Forecast"]
[null,null,null,"Actual"]
[null,null,"£ TF Accelerated Funding","Forecast"]
[null,null,null,"Actual"]
[null,null,"% of Projects Starting on Time According to Delivery Plan","Forecast"]
[null,null,null,"Actual"]
[]
[]
[null,"Project #9","<Enter the full title of the project in the Grant Offer Letter here>",null,"2019/20",null,"2020/21",null,"2021/22"]
[null,null,"Outputs"]
[null,null,"£ Total TF CDEL Payment \nThis must exclude TF Accelerated Funding","Forecast approved by DLUHC"]
[null,null,null,"Actual"]
[null,null,"£ 5% CDEL TF Pre-payment \nTowns Fund FAQs p.46-49","Forecast"]
[null,null,null,"Spent/committed"]
[null,null,"[A] £ TF RDEL Payment ","Forecast approved by DLUHC"]
[null,null,null,"Actual"]
[null,null,"[B] £ TF RDEL Programme Management Payment\nOnly complete if received separately","Forecast approved by DLUHC"]
[null,null,null,"Actual"]
[null,null,"£ Total TF RDEL Payment = [A] +[B]","Forecast approved by DLUHC",{"$f":"E$174+E$176","v":0},null,{"$f":"G$174+G$176","v":0},null,{"$f":"I$174+I$176","v":0}]
[null,null,null,"Actual",{"$f":"E$175+E$177","v":0},null,{"$f":"G$175+G$177","v":0},null,{"$f":"I$175+I$177","v":0}]
[null,null,"£ TF RDEL Capacity Funding \nThis relates to funding received in 2019/20 and, if relevant 2020/21","Forecast"]
[null,null,null,"Actual"]
[null,null,"£ TF Accelerated Funding","Forecast"]
[null,null,null,"Actual"]
[null,null,"% of Projects Starting on Time According to Delivery Plan","Forecast"]
[null,null,null,"Actual"]
[]
[]
[null,"Project #10","<Enter the full title of the project in the Grant Offer Letter here>",null,"2019/20",null,"2020/21",null,"2021/22"]
[null,null,"Outputs"]
[null,null,"£ Total TF CDEL Payment \nThis must exclude TF Accelerated Funding","Forecast approved by DLUHC"]
[null,null,null,"Actual"]
[null,null,"£ 5% CDEL TF Pre-payment \nTowns Fund FAQs p.46-49","Forecast"]
[null,null,null,"Spent/committed"]
[null,null,"[A] £ TF RDEL Payment ","Forecast approved by DLUHC"]
[null,null,null,"Actual"]
[null,null,"[B] £ TF RDEL Programme Management Payment\nOnly complete if received separately","Forecast approved by DLUHC"]
[null,null,null,"Actual"]
[null,null,"£ Total TF RDEL Payment = [A] +[B]","Forecast approved by DLUHC",{"$f":"E$194+E$196","v":0},null,{"$f":"G$194+G$196","v":0},null,{"$f":"I$194+I$196","v":0}]
[null,null,null,"Actual",{"$f":"E$195+E$197","v":0},null,{"$f":"G$195+G$197","v":0},null,{"$f":"I$195+I$197","v":0}]
[null,null,"£ TF RDEL Capacity Funding \nThis relates to funding received in 2019/20 and, if relevant 2020/21","Forecast"]
[null,null,null,"Actual"]
[null,null,"£ TF Accelerated Funding","Forecast"]
[null,null,null,"Actual"]
[null,null,"% of Projects Starting on Time According to Delivery Plan","Forecast"]
[null,null,null,"Actual"]