{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["How to Use","Final Output","1. Cross-sector Partnerships","2. Shared Strategic Aims","3. Leadership","4. Governance","5. Monitoring & Evaluation","Backend"],"not_rendered":{"charts":2,"images":3,"macros":0,"external_links":0,"defined_names":0,"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":"How to Use","index":0,"n_rows":28,"n_cols":2,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,1,8,10],[28,1,28,7]]}
[null,"HiAP Pillars Self-Assessment Tool"]
[null,"Welcome to the MRP HiAP Pillars Self-Assessment Tool which has been designed to support mayoral regions to score and monitor their organisational and structural factors i.e., \"pillars\" for HiAP success from part 1 of the toolkit. This tool can be used:\n\n1. To understand existing organisational factors for HiAP. Some of these factors will be well-developed and some may be less developed. How regions use the results of this 'pillars audit' will depend on the local context. For example, regions might use the results of this audit to build on existing pillars, address gaps, or to monitor organisational progress towards HiAP over time.\n\n2. As a supportive mechanism to monitor and progress each pillar, for example:\n- Support cross-sector collaborative planning\n- Provide a systematic approach to developing organisation buy-in and agreeing a shared definition of what HiAP should look like\n- Bring  partners together to create and pursue shared strategic aims\n- Foster  organisational ownership and leadership\n- Provide structure to governance and accountability for HiAP\n- Support organisational M&E of HiAP to capture progress (this can support thinking for part 4 of the toolkit)\n- Support thinking for part 3 of the toolkit - developing HiAP strategy\n\nIn the tabs which follow, you can self-assess where your organisation scores for each 'Enabler' within each Pillar using a scoring system from 1-3 according to the guidelines below: \n1 = Needs more work\n2 = Enabler is progressing\n3 = Enabler is well developed"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,2]

{"sheet":"Final Output","index":1,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,2,6],[3,1,3,6],[4,1,4,2],[4,3,4,4],[4,5,4,6]]}
[null,"Pillars of HiAP: Final output"]
[null,"This tab capturs the output of the scoring process which is autopopulated using the scores you enter into the following tabs. You will find an overview in the table below.\n\nYour scores will also be displayed in the spider diagram on the right hand side, or in the line graph at the bottom of the page. These might be helpful to support conversations to help build on existing pillars, address gaps, or to monitor organisational progress towards HiAP over time. \n"]
[]
[null,"RAG Rating Scorecard"]
[null,"1. Needs more work",null,"2. Is progressing",null,"3. Is well developed"]
[]
[null,null,{"$f":"'1. Cross-sector Partnerships'!D3","v":"Starting Point"},{"$f":"'1. Cross-sector Partnerships'!H3","v":"End of Year 1"},{"$f":"'1. Cross-sector Partnerships'!L3","v":"End of Year 2"},{"$f":"'1. Cross-sector Partnerships'!P3","v":"End of Year 3"},{"$f":"'1. Cross-sector Partnerships'!T3","v":"End of Year 4"}]
[null,"Cross-sector partnership working",{"$f":"IFERROR(Backend!G11,\"No score found\")","v":"No score found"},{"$f":"IFERROR(Backend!H11,\"\")","v":""},{"$f":"IFERROR(Backend!I11,\"\")","v":""},{"$f":"IFERROR(Backend!J11,\"\")","v":""},{"$f":"IFERROR(Backend!K11,\"\")","v":""}]
[]
[null,"Shared strategic aims",{"$f":"IFERROR(Backend!G12,\"No score found\")","v":"No score found"},{"$f":"IFERROR(Backend!H12,\"\")","v":""},{"$f":"IFERROR(Backend!I12,\"\")","v":""},{"$f":"IFERROR(Backend!J12,\"\")","v":""},{"$f":"IFERROR(Backend!K12,\"\")","v":""}]
[]
[null,"Leadership",{"$f":"IFERROR(Backend!G13,\"No score found\")","v":"No score found"},{"$f":"IFERROR(Backend!G13,\"\")","v":""},{"$f":"IFERROR(Backend!I13,\"\")","v":""},{"$f":"IFERROR(Backend!I13,\"\")","v":""},{"$f":"IFERROR(Backend!J13,\"\")","v":""}]
[]
[null,"Governance and accountability",{"$f":"IFERROR(Backend!G14,\"No score found\")","v":"No score found"},{"$f":"IFERROR(Backend!H14,\"\")","v":""},{"$f":"IFERROR(Backend!I14,\"\")","v":""},{"$f":"IFERROR(Backend!J14,\"\")","v":""},{"$f":"IFERROR(Backend!K14,\"\")","v":""}]
[]
[null,"Monitoring and evaluation",{"$f":"IFERROR(Backend!G15,\"No score found\")","v":"No score found"},{"$f":"IFERROR(Backend!H15,\"\")","v":""},{"$f":"IFERROR(Backend!I15,\"\")","v":""},{"$f":"IFERROR(Backend!J15,\"\")","v":""},{"$f":"IFERROR(Backend!K15,\"\")","v":""}]
[]
[null,"Total",{"$f":"IF(Backend!G16=0,\"\",Backend!G16)","v":""},{"$f":"IF(Backend!H16=0,\"\",Backend!H16)","v":""},{"$f":"IF(Backend!I16=0,\"\",Backend!I16)","v":""},{"$f":"IF(Backend!J16=0,\"\",Backend!J16)","v":""},{"$f":"IF(Backend!K16=0,\"\",Backend!K16)","v":""}]

{"sheet":"1. Cross-sector Partnerships","index":2,"n_rows":22,"n_cols":22,"rows_kept":22,"cut":false,"hidden":false,"merged":[[20,21,20,22],[21,21,21,22],[19,1,21,3],[19,18,19,20],[20,18,20,20],[21,18,21,20],[19,15,19,17],[20,15,20,17],[21,15,21,17],[19,12,19,14],[20,12,20,14],[21,12,21,14],[19,9,19,11],[20,9,20,11],[21,9,21,11],[19,6,19,8],[20,6,20,8],[21,6,21,8],[16,21,16,22],[17,21,17,22],[15,6,15,8],[16,6,16,8],[17,6,17,8],[15,9,15,11],[16,9,16,11],[17,9,17,11],[15,12,15,14],[16,12,16,14],[17,12,17,14],[15,15,15,17],[16,15,16,17],[17,15,17,17],[15,18,15,20],[16,18,16,20],[17,18,17,20],[2,19,2,22],[2,11,2,14],[2,15,2,18],[2,3,2,6],[2,7,2,10],[4,0,6,0],[2,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[3,3,3,4],[3,5,3,6],[3,7,3,8],[3,9,3,10],[3,21,3,22],[3,19,3,20],[3,13,3,14],[3,17,3,18],[3,11,3,12],[3,15,3,16],[5,19,5,20],[6,19,6,20],[11,0,13,0],[15,0,17,0],[19,0,21,0],[19,4,21,4],[2,0,3,0],[15,4,17,4],[5,11,5,12],[4,13,6,14],[4,17,6,18],[12,12,12,14],[13,12,13,14],[11,6,11,8],[11,9,11,11],[12,9,12,11],[13,9,13,11],[12,6,12,8],[13,6,13,8],[9,6,9,10],[9,11,9,15],[11,1,13,3],[15,1,17,3],[13,18,13,20],[11,15,11,17],[12,15,12,17],[11,4,13,4],[12,21,12,22],[13,21,13,22],[11,18,11,20],[12,18,12,20],[4,11,4,12],[4,3,4,4],[5,3,5,4],[6,3,6,4],[4,5,6,6],[9,16,9,20],[8,6,8,20],[13,15,13,17],[11,12,11,14],[6,7,6,8],[4,7,4,8],[5,7,5,8],[4,9,6,10],[6,15,6,16],[6,11,6,12],[4,15,4,16],[5,15,5,16],[4,21,6,22],[4,19,4,20]]}
[null,"Pillar 1. Cross-sector partnership working"]
[null,"Scores will autopopulate this monitoring table using your scores for your self assessment across the enabler tables below. Please start with enabler 1.  "]
["You can change you can edit the monitoring milestones to suit your needs","Monitoring milestone",null,"Starting Point",null,null,null,"End of Year 1",null,null,null,"End of Year 2",null,null,null,"End of Year 3",null,null,null,"End of Year 4"]
[null,null,null,"Self-assessment score",null,"Overall",null,"Self-assessment score",null,"Overall",null,"Self-assessment score",null,"Overall",null,"Self-assessment score",null,"Overall",null,"Self-assessment score",null,"Overall"]
["Enablers","Embedded public health intelligence",null,{"$f":"IF(ISNUMBER(G13), G13, 0)","v":0},null,{"$f":"IF(SUM(D5:D7)/3=0, \"Enter score below\", SUM(D5:D7)/3)","v":"Enter score below"},null,{"$f":"IF(ISNUMBER(J13), J13, 0)","v":0},null,{"$f":"IF(SUM(H5:H7)/3=0, \"Enter score below\", SUM(H5:H7)/3)","v":"Enter score below"},null,{"$f":"IF(ISNUMBER(M13), M13, 0)","v":0},null,{"$f":"IF(SUM(L5:L7)/3=0, \"Enter score below\", SUM(L5:L7)/3)","v":"Enter score below"},null,{"$f":"IF(ISNUMBER(P13), P13, 0)","v":0},null,{"$f":"IF(SUM(P5:P7)/3=0, \"Enter score below\", SUM(P5:P7)/3)","v":"Enter score below"},null,{"$f":"IF(ISNUMBER(S13), S13, 0)","v":0},null,{"$f":"IF(SUM(T5:T7)/3=0, \"Enter score below\", SUM(T5:T7)/3)","v":"Enter score below"}]
[null,"Cross-organisational framing",null,{"$f":"IF(ISNUMBER(G17), G17, 0)","v":0},null,null,null,{"$f":"IF(ISNUMBER(J17), J17, 0)","v":0},null,null,null,{"$f":"IF(ISNUMBER(M17), M17, 0)","v":0},null,null,null,{"$f":"IF(ISNUMBER(P17), P17, 0)","v":0},null,null,null,{"$f":"IF(ISNUMBER(S17), S17, 0)","v":0}]
[null,"Alignment with non-health priorities ",null,{"$f":"IF(ISNUMBER(G21), G21, 0)","v":0},null,null,null,{"$f":"IF(ISNUMBER(J21), J21, 0)","v":0},null,null,null,{"$f":"IF(ISNUMBER(M21), M21, 0)","v":0},null,null,null,{"$f":"IF(ISNUMBER(P21), P21, 0)","v":0},null,null,null,{"$f":"IF(ISNUMBER(S21), S21, 0)","v":0}]
[]
[null,null,null,null,null,null,"RAG Rating Scoring System"]
[null,null,null,null,null,null,"1. Needs more work",null,null,null,null,"2. Is progressing",null,null,null,null,"3. Is well developed"]
[]
["Enabler 1","Embedding public health intelligence and skills in the form of dedicated resource, such as shared posts for individuals that can work across departments, or co-developed training/resources which identify mutual benefits between health and other teams’ priorities. ",null,null,"Scorecard","Milestone",{"$f":"D3","v":"Starting Point"},null,null,{"$f":"H3","v":"End of Year 1"},null,null,{"$f":"L3","v":"End of Year 2"},null,null,{"$f":"P3","v":"End of Year 3"},null,null,{"$f":"T3","v":"End of Year 4"}]
[null,null,null,null,null,"Score",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter your self-assessment score using the drop down list"]
[null,null,null,null,null,"Rationale and agreed actions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Use this free text box to provide rationale for your score and any agreed actions at each review milestone. This might support evaluating progress made and informing future assessments."]
[]
["Enabler 2","Co-developing a cross-organisational framing of a HiAP model with an agreed definition that is flexible in application and effectively articulates the health impact of the combined authority (CA) can enhance inter-sectoral collaboration by developing a shared understanding and goals.",null,null,"Scorecard","Milestone",{"$f":"G12","v":"Starting Point"},null,null,{"$f":"J12","v":"End of Year 1"},null,null,{"$f":"M12","v":"End of Year 2"},null,null,{"$f":"P12","v":"End of Year 3"},null,null,{"$f":"S12","v":"End of Year 4"}]
[null,null,null,null,null,"Score",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter your self-assessment score using the drop down list"]
[null,null,null,null,null,"Rationale and agreed actions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Use this free text box to provide rationale for your score and any agreed actions at each review milestone. This might support evaluating progress made and informing future assessments."]
[]
["Enabler 3","Aligning the HiAP approach with different departments' portfolio priorities and adopting the specific language and framing of target sectors can help to ensure that HiAP principles resonate more effectively with diverse stakeholders; By communicating in terms that are familiar and relevant to each department, it is easier to highlight how health considerations can enhance their primary objectives (i.e. the co-benefits).",null,null,"Scorecard","Milestone","Starting Point",null,null,"End of Year 1",null,null,"End of Year 2",null,null,"End of Year 3",null,null,"End of Year 4"]
[null,null,null,null,null,"Score",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter your self-assessment score using the drop down list"]
[null,null,null,null,null,"Rationale and agreed actions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Use this free text box to provide rationale for your score and any agreed actions at each review milestone. This might support evaluating progress made and informing future assessments."]

{"sheet":"2. Shared Strategic Aims","index":3,"n_rows":22,"n_cols":22,"rows_kept":22,"cut":false,"hidden":false,"merged":[[19,9,19,11],[20,9,20,11],[21,9,21,11],[19,6,19,8],[20,6,20,8],[21,6,21,8],[19,1,21,3],[19,0,21,0],[16,21,16,22],[17,21,17,22],[16,18,16,20],[20,21,20,22],[21,21,21,22],[19,18,19,20],[20,18,20,20],[21,18,21,20],[19,15,19,17],[20,15,20,17],[21,15,21,17],[19,12,19,14],[20,12,20,14],[21,12,21,14],[15,15,15,17],[16,15,16,17],[17,15,17,17],[11,0,13,0],[12,21,12,22],[13,21,13,22],[11,1,13,3],[11,18,11,20],[12,18,12,20],[13,18,13,20],[11,15,11,17],[12,15,12,17],[13,15,13,17],[11,12,11,14],[12,12,12,14],[13,12,13,14],[11,9,11,11],[12,9,12,11],[13,9,13,11],[11,6,11,8],[12,6,12,8],[13,6,13,8],[15,0,17,0],[15,18,15,20],[2,0,3,0],[19,4,21,4],[15,4,17,4],[15,12,15,14],[16,12,16,14],[17,12,17,14],[15,9,15,11],[16,9,16,11],[17,9,17,11],[15,6,15,8],[16,6,16,8],[17,6,17,8],[15,1,17,3],[11,4,13,4],[8,6,8,20],[9,6,9,10],[9,11,9,15],[9,16,9,20],[4,0,6,0],[4,5,6,6],[4,9,6,10],[4,13,6,14],[4,17,6,18],[17,18,17,20],[4,21,6,22],[6,3,6,4],[6,7,6,8],[2,1,3,2],[6,15,6,16],[6,19,6,20],[6,1,6,2],[6,11,6,12],[4,19,4,20],[5,1,5,2],[5,3,5,4],[5,7,5,8],[5,11,5,12],[5,15,5,16],[5,19,5,20],[4,1,4,2],[4,3,4,4],[4,7,4,8],[4,11,4,12],[4,15,4,16],[2,19,2,22],[3,3,3,4],[3,5,3,6],[3,7,3,8],[3,21,3,22],[3,9,3,10],[3,11,3,12],[3,13,3,14],[3,15,3,16],[3,17,3,18],[3,19,3,20],[2,3,2,6],[2,7,2,10],[2,11,2,14],[2,15,2,18]]}
[null,"Pillars of HiAP: 2. Shared Strategic Aims"]
[null,"Scores will autopopulate this monitoring table using your scores for your self assessment across the enabler tables below. Please start with enabler 1.  "]
["You can change you can edit the monitoring milestones to suit your needs","Reporting Period",null,{"$f":"'1. Cross-sector Partnerships'!D3","v":"Starting Point"},null,null,null,{"$f":"'1. Cross-sector Partnerships'!H3","v":"End of Year 1"},null,null,null,{"$f":"'1. Cross-sector Partnerships'!L3","v":"End of Year 2"},null,null,null,{"$f":"'1. Cross-sector Partnerships'!P3","v":"End of Year 3"},null,null,null,{"$f":"'1. Cross-sector Partnerships'!T3","v":"End of Year 4"}]
[null,null,null,"Self-assessment score",null,"Overall",null,"Self-assessment score",null,"Overall",null,"Self-assessment score",null,"Overall",null,"Self-assessment score",null,"Overall",null,"Self-assessment score",null,"Overall"]
["Enablers","Within the mayoral regional authority",null,{"$f":"IF(ISNUMBER(G13), G13, 0)","v":0},null,{"$f":"IF(SUM(D5:D7)/3=0, \"Enter score below\", SUM(D5:D7)/3)","v":"Enter score below"},null,{"$f":"IF(ISNUMBER(J13), J13, 0)","v":0},null,{"$f":"IF(SUM(H5:H7)/3=0, \"Enter score below\", SUM(H5:H7)/3)","v":"Enter score below"},null,{"$f":"IF(ISNUMBER(M13), M13, 0)","v":0},null,{"$f":"IF(SUM(L5:L7)/3=0, \"Enter score below\", SUM(L5:L7)/3)","v":"Enter score below"},null,{"$f":"IF(ISNUMBER(P13), P13, 0)","v":0},null,{"$f":"IF(SUM(P5:P7)/3=0, \"Enter score below\", SUM(P5:P7)/3)","v":"Enter score below"},null,{"$f":"IF(ISNUMBER(S13), S13, 0)","v":0},null,{"$f":"IF(SUM(T5:T7)/3=0, \"Enter score below\", SUM(T5:T7)/3)","v":"Enter score below"}]
[null,"With wider system partners",null,{"$f":"IF(ISNUMBER(G17),G17, 0)","v":0},null,null,null,{"$f":"IF(ISNUMBER(J17),J17, 0)","v":0},null,null,null,{"$f":"IF(ISNUMBER(M17),M17, 0)","v":0},null,null,null,{"$f":"IF(ISNUMBER(P17),P17, 0)","v":0},null,null,null,{"$f":"IF(ISNUMBER(S17),S17, 0)","v":0}]
[null,"Both within the MR and with wider system partners",null,{"$f":"IF(ISNUMBER(G21),G21, 0)","v":0},null,null,null,{"$f":"IF(ISNUMBER(J21),J21, 0)","v":0},null,null,null,{"$f":"IF(ISNUMBER(M21),M21, 0)","v":0},null,null,null,{"$f":"IF(ISNUMBER(P21),P21, 0)","v":0},null,null,null,{"$f":"IF(ISNUMBER(S21),S21, 0)","v":0}]
[]
[null,null,null,null,null,null,"RAG Rating Scoring System"]
[null,null,null,null,null,null,"1. Needs more work",null,null,null,null,"2. Is progressing",null,null,null,null,"3. Is well developed"]
[]
["Enabler 1","Within the Mayoral Region Authority:\n• Articulating the potential health impact in relation to mayoral and regional priorities\n\n• Collaborating with the governance, structures, and forums created around mayoral priorities\n\n• Developing “win-win” cases to explain the contribution of health\n\n• Ensuring that potential health benefits feature in the prioritisation processes\n\n• Establishing good relationships at a senior level with lead politicians and officers\n\n• Gaining trust with key stakeholders and identifying “in-roads”\n\n• Measuring and demonstrating impact",null,null,"Scorecard","Milestone",{"$f":"D3","v":"Starting Point"},null,null,{"$f":"H3","v":"End of Year 1"},null,null,{"$f":"L3","v":"End of Year 2"},null,null,{"$f":"P3","v":"End of Year 3"},null,null,{"$f":"T3","v":"End of Year 4"}]
[null,null,null,null,null,"Score",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter your self-assessment score using the drop down list"]
[null,null,null,null,null,"Rationale and agreed actions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Use this free text box to provide rationale for your score and any agreed actions at each review milestone. This might support evaluating progress made and informing future assessments."]
[]
["Enabler 2","With wider system partners:\n\n• Engaging in shared priority setting with partners, considering evolving devolution arrangements, can build trust and optimise alignment towards a regional population health approach with shared goals such as inclusive growth, reducing youth unemployment, increasing active travel, etc.\n\n• Implementing outcome-focused approaches that demonstrate the value add of a HiAP approach to cross-organisational working and showcase its wider benefits for improving population can help to secure buy-in from wider senior and non-health leaders",null,null,"Scorecard","Milestone",{"$f":"G12","v":"Starting Point"},null,null,{"$f":"J12","v":"End of Year 1"},null,null,{"$f":"M12","v":"End of Year 2"},null,null,{"$f":"P12","v":"End of Year 3"},null,null,{"$f":"S12","v":"End of Year 4"}]
[null,null,null,null,null,"Score",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter your self-assessment score using the drop down list"]
[null,null,null,null,null,"Rationale and agreed actions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Use this free text box to provide rationale for your score and any agreed actions at each review milestone. This might support evaluating progress made and informing future assessments."]
[]
["Enabler 3","Both wthin mayoral region authorities and with wider system partners:\n\n• Recognising and celebrating the short-term goals that are achieved across sectors in pursuit of improved health outcomes can assist with strengthening relationships, as well as building momentum and ",null,null,"Scorecard","Milestone",{"$f":"G16","v":"Starting Point"},null,null,{"$f":"J16","v":"End of Year 1"},null,null,{"$f":"M16","v":"End of Year 2"},null,null,{"$f":"P16","v":"End of Year 3"},null,null,{"$f":"S16","v":"End of Year 4"}]
[null,null,null,null,null,"Score",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter your self-assessment score using the drop down list"]
[null,null,null,null,null,"Rationale and agreed actions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Use this free text box to provide rationale for your score and any agreed actions at each review milestone. This might support evaluating progress made and informing future assessments."]

{"sheet":"3. Leadership","index":4,"n_rows":22,"n_cols":22,"rows_kept":22,"cut":false,"hidden":false,"merged":[[19,1,21,3],[19,0,21,0],[13,6,13,8],[11,1,13,3],[8,6,8,20],[9,6,9,10],[9,11,9,15],[9,16,9,20],[15,18,15,20],[16,18,16,20],[17,18,17,20],[15,15,15,17],[16,15,16,17],[17,15,17,17],[15,12,15,14],[16,12,16,14],[17,12,17,14],[15,9,15,11],[16,9,16,11],[17,9,17,11],[15,6,15,8],[16,6,16,8],[17,6,17,8],[11,0,13,0],[12,21,12,22],[13,21,13,22],[16,21,16,22],[17,21,17,22],[15,1,17,3],[15,0,17,0],[11,18,11,20],[12,18,12,20],[13,18,13,20],[11,15,11,17],[12,15,12,17],[13,15,13,17],[11,12,11,14],[12,12,12,14],[13,12,13,14],[11,9,11,11],[12,9,12,11],[13,9,13,11],[11,6,11,8],[20,21,20,22],[21,21,21,22],[20,18,20,20],[21,18,21,20],[20,15,20,17],[21,15,21,17],[20,12,20,14],[21,12,21,14],[19,18,19,20],[19,15,19,17],[19,12,19,14],[20,9,20,11],[21,9,21,11],[19,6,19,8],[20,6,20,8],[21,6,21,8],[19,4,21,4],[15,4,17,4],[12,6,12,8],[11,4,13,4],[6,15,6,16],[4,9,6,10],[4,11,4,12],[4,13,6,14],[4,15,4,16],[2,7,2,10],[2,11,2,14],[2,15,2,18],[19,9,19,11],[2,3,2,6],[4,0,6,0],[4,1,4,2],[4,3,4,4],[4,5,6,6],[4,7,4,8],[6,3,6,4],[6,7,6,8],[6,11,6,12],[3,21,3,22],[2,1,3,2],[6,19,6,20],[4,17,6,18],[4,19,4,20],[2,0,3,0],[4,21,6,22],[5,1,5,2],[5,3,5,4],[5,7,5,8],[5,11,5,12],[5,15,5,16],[5,19,5,20],[6,1,6,2],[2,19,2,22],[3,3,3,4],[3,5,3,6],[3,7,3,8],[3,9,3,10],[3,11,3,12],[3,13,3,14],[3,15,3,16],[3,17,3,18],[3,19,3,20]]}
[null,"Pillars of HiAP: 3. Leadership"]
[null,"Scores will autopopulate this monitoring table using your scores for your self assessment across the enabler tables below. Please start with enabler 1.  "]
["You can change you can edit the monitoring milestones to suit your needs","Reporting Period",null,{"$f":"'1. Cross-sector Partnerships'!D3","v":"Starting Point"},null,null,null,{"$f":"'1. Cross-sector Partnerships'!H3","v":"End of Year 1"},null,null,null,{"$f":"'1. Cross-sector Partnerships'!L3","v":"End of Year 2"},null,null,null,{"$f":"'1. Cross-sector Partnerships'!P3","v":"End of Year 3"},null,null,null,{"$f":"'1. Cross-sector Partnerships'!T3","v":"End of Year 4"}]
[null,null,null,"Self-assessment score",null,"Overall",null,"Self-assessment score",null,"Overall",null,"Self-assessment score",null,"Overall",null,"Self-assessment score",null,"Overall",null,"Self-assessment score",null,"Overall"]
["Enablers","Health Leadership",null,{"$f":"IF(ISNUMBER(G13), G13, 0)","v":0},null,{"$f":"IF(SUM(D5:D7)/3=0, \"Enter score below\", SUM(D5:D7)/3)","v":"Enter score below"},null,{"$f":"IF(ISNUMBER(J13), J13, 0)","v":0},null,{"$f":"IF(SUM(H5:H7)/3=0, \"Enter score below\", SUM(H5:H7)/3)","v":"Enter score below"},null,{"$f":"IF(ISNUMBER(M13), M13, 0)","v":0},null,{"$f":"IF(SUM(L5:L7)/3=0, \"Enter score below\", SUM(L5:L7)/3)","v":"Enter score below"},null,{"$f":"IF(ISNUMBER(P13), P13, 0)","v":0},null,{"$f":"IF(SUM(P5:P7)/3=0, \"Enter score below\", SUM(P5:P7)/3)","v":"Enter score below"},null,{"$f":"IF(ISNUMBER(S13), S13, 0)","v":0},null,{"$f":"IF(SUM(T5:T7)/3=0, \"Enter score below\", SUM(T5:T7)/3)","v":"Enter score below"}]
[null,"Organisational Leadership",null,{"$f":"IF(ISNUMBER(G17), G17, 0)","v":0},null,null,null,{"$f":"IF(ISNUMBER(J17), J17, 0)","v":0},null,null,null,{"$f":"IF(ISNUMBER(M17), M17, 0)","v":0},null,null,null,{"$f":"IF(ISNUMBER(P17), P17, 0)","v":0},null,null,null,{"$f":"IF(ISNUMBER(S17), S17, 0)","v":0}]
[null,"Political Leadership",null,{"$f":"IF(ISNUMBER(G21), G21, 0)","v":0},null,null,null,{"$f":"IF(ISNUMBER(J21), J21, 0)","v":0},null,null,null,{"$f":"IF(ISNUMBER(M21), M21, 0)","v":0},null,null,null,{"$f":"IF(ISNUMBER(P21), P21, 0)","v":0},null,null,null,{"$f":"IF(ISNUMBER(S21), S21, 0)","v":0}]
[]
[null,null,null,null,null,null,"RAG Rating Scoring System"]
[null,null,null,null,null,null,"1. Needs more work",null,null,null,null,"2. Is progressing",null,null,null,null,"3. Is well developed"]
[]
["Enabler 1","Catalysing action via cross-system health leadership from different organisations and networks across the region (e.g. Integrated Care Systems, local authorities, the Office for Health Improvement and Disparities, etc.) to support a population health management approach, rather than framing needs solely in relation to organisational delivery responsibilities.",null,null,"Scorecard","Milestone",{"$f":"D3","v":"Starting Point"},null,null,{"$f":"H3","v":"End of Year 1"},null,null,{"$f":"L3","v":"End of Year 2"},null,null,{"$f":"P3","v":"End of Year 3"},null,null,{"$f":"T3","v":"End of Year 4"}]
[null,null,null,null,null,"Score",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter your self-assessment score using the drop down list"]
[null,null,null,null,null,"Rationale and agreed actions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Use this free text box to provide rationale for your score and any agreed actions at each review milestone. This might support evaluating progress made and informing future assessments."]
[]
["Enabler 2","Building leadership for HiAP amongst leaders from different sectors in the first, second and third tiers of an organisation is integral to embedding HiAP and stimulating action across CA strategies and agendas. ",null,null,"Scorecard","Milestone",{"$f":"G12","v":"Starting Point"},null,null,{"$f":"J12","v":"End of Year 1"},null,null,{"$f":"M12","v":"End of Year 2"},null,null,{"$f":"P12","v":"End of Year 3"},null,null,{"$f":"S12","v":"End of Year 4"}]
[null,null,null,null,null,"Score",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter your self-assessment score using the drop down list"]
[null,null,null,null,null,"Rationale and agreed actions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Use this free text box to provide rationale for your score and any agreed actions at each review milestone. This might support evaluating progress made and informing future assessments."]
[]
["Enabler 3","Political leadership through a mandate from the mayor or deputy mayor can be an effective starting point and is a vital ingredient for driving HiAP forward and securing widespread buy-in across the CA.",null,null,"Scorecard","Milestone",{"$f":"G12","v":"Starting Point"},null,null,{"$f":"J12","v":"End of Year 1"},null,null,{"$f":"M12","v":"End of Year 2"},null,null,{"$f":"P12","v":"End of Year 3"},null,null,{"$f":"S12","v":"End of Year 4"}]
[null,null,null,null,null,"Score",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter your self-assessment score using the drop down list"]
[null,null,null,null,null,"Rationale and agreed actions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Use this free text box to provide rationale for your score and any agreed actions at each review milestone. This might support evaluating progress made and informing future assessments."]

{"sheet":"4. Governance","index":5,"n_rows":12,"n_cols":22,"rows_kept":12,"cut":false,"hidden":false,"merged":[[6,6,6,20],[7,6,7,10],[7,11,7,15],[7,16,7,20],[11,12,11,14],[9,9,9,11],[10,9,10,11],[11,9,11,11],[9,6,9,8],[10,6,10,8],[11,6,11,8],[10,21,10,22],[11,21,11,22],[9,1,11,3],[9,0,11,0],[9,18,9,20],[10,18,10,20],[11,18,11,20],[9,15,9,17],[10,15,10,17],[11,15,11,17],[9,12,9,14],[10,12,10,14],[2,0,3,0],[9,4,11,4],[3,21,3,22],[4,1,4,2],[4,3,4,4],[4,5,4,6],[4,7,4,8],[4,9,4,10],[4,11,4,12],[4,13,4,14],[4,15,4,16],[2,1,3,2],[4,17,4,18],[4,19,4,20],[4,21,4,22],[2,19,2,22],[3,3,3,4],[3,15,3,16],[3,17,3,18],[3,19,3,20],[2,3,2,6],[2,7,2,10],[2,11,2,14],[2,15,2,18],[3,5,3,6],[3,7,3,8],[3,9,3,10],[3,11,3,12],[3,13,3,14]]}
[null,"Pillars of HiAP: 4. Governance & Accountability"]
[null,"Scores will autopopulate this monitoring table using your scores for your self assessment across the enabler table below. Please start with enabler 1.  "]
["You can change you can edit the monitoring milestones to suit your needs","Reporting Period",null,{"$f":"'1. Cross-sector Partnerships'!D3","v":"Starting Point"},null,null,null,{"$f":"'1. Cross-sector Partnerships'!H3","v":"End of Year 1"},null,null,null,{"$f":"'1. Cross-sector Partnerships'!L3","v":"End of Year 2"},null,null,null,{"$f":"'1. Cross-sector Partnerships'!P3","v":"End of Year 3"},null,null,null,{"$f":"'1. Cross-sector Partnerships'!T3","v":"End of Year 4"}]
[null,null,null,"Self-assessment score",null,"Overall",null,"Self-assessment score",null,"Overall",null,"Self-assessment score",null,"Overall",null,"Self-assessment score",null,"Overall",null,"Self-assessment score",null,"Overall"]
["Enablers","Recognise the synergies",null,{"$f":"IF(ISNUMBER(G11), G11, 0)","v":0},null,{"$f":"IF(D5=0,\"Enter score below\",D5)","v":"Enter score below"},null,{"$f":"IF(ISNUMBER(J11), J11, 0)","v":0},null,{"$f":"IF(H5=0,\"Enter score below\",H5)","v":"Enter score below"},null,{"$f":"IF(ISNUMBER(M11), M11, 0)","v":0},null,{"$f":"IF(L5=0,\"Enter score below\",L5)","v":"Enter score below"},null,{"$f":"IF(ISNUMBER(P11), P11, 0)","v":0},null,{"$f":"IF(P5=0,\"Enter score below\",P5)","v":"Enter score below"},null,{"$f":"IF(ISNUMBER(S11), S11, 0)","v":0},null,{"$f":"IF(T5=0,\"Enter score below\",T5)","v":"Enter score below"}]
[]
[null,null,null,null,null,null,"RAG Rating Scoring System"]
[null,null,null,null,null,null,"1. Needs more work",null,null,null,null,"2. Is progressing",null,null,null,null,"3. Is well developed"]
[]
["Enabler 1","Recognising the synergies between HiAP and other prevention-oriented approaches by engaging with existing or co-developing organisational or regional frameworks and strategies such as those on climate action, equality, diversity, and inclusion, and inclusive growth can help to identify areas for mutual benefit and fostering collaboration.",null,null,"Scorecard","Milestone",{"$f":"D3","v":"Starting Point"},null,null,{"$f":"H3","v":"End of Year 1"},null,null,{"$f":"L3","v":"End of Year 2"},null,null,{"$f":"P3","v":"End of Year 3"},null,null,{"$f":"T3","v":"End of Year 4"}]
[null,null,null,null,null,"Score",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter your self-assessment score using the drop down list"]
[null,null,null,null,null,"Rationale and agreed actions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Use this free text box to provide rationale for your score and any agreed actions at each review milestone. This might support evaluating progress made and informing future assessments."]

{"sheet":"5. Monitoring & Evaluation","index":6,"n_rows":27,"n_cols":22,"rows_kept":27,"cut":false,"hidden":false,"merged":[[26,18,26,20],[26,15,26,17],[26,21,26,22],[9,6,9,20],[10,6,10,10],[10,11,10,15],[10,16,10,20],[20,9,20,11],[21,9,21,11],[22,9,22,11],[20,6,20,8],[21,6,21,8],[22,6,22,8],[13,21,13,22],[14,21,14,22],[26,12,26,14],[26,9,26,11],[26,6,26,8],[21,21,21,22],[22,21,22,22],[25,21,25,22],[17,21,17,22],[18,21,18,22],[16,18,16,20],[20,18,20,20],[21,18,21,20],[22,18,22,20],[20,15,20,17],[21,15,21,17],[22,15,22,17],[20,12,20,14],[21,12,21,14],[22,12,22,14],[24,18,24,20],[25,18,25,20],[24,15,24,17],[25,15,25,17],[24,12,24,14],[25,12,25,14],[24,9,24,11],[25,9,25,11],[24,6,24,8],[25,6,25,8],[18,18,18,20],[16,15,16,17],[17,15,17,17],[18,15,18,17],[16,12,16,14],[12,1,14,3],[12,0,14,0],[12,18,12,20],[13,18,13,20],[14,18,14,20],[12,15,12,17],[13,15,13,17],[14,15,14,17],[12,12,12,14],[13,12,13,14],[14,12,14,14],[12,9,12,11],[13,9,13,11],[14,9,14,11],[12,6,12,8],[13,6,13,8],[14,6,14,8],[12,4,14,4],[17,18,17,20],[20,0,22,0],[24,0,26,0],[16,0,18,0],[17,12,17,14],[18,12,18,14],[16,9,16,11],[17,9,17,11],[18,9,18,11],[16,6,16,8],[17,6,17,8],[16,4,18,4],[18,6,18,8],[20,4,22,4],[16,1,18,3],[20,1,22,3],[24,1,26,3],[24,4,26,4],[4,17,7,18],[4,21,7,22],[6,19,6,20],[4,19,4,20],[5,19,5,20],[7,7,7,8],[7,11,7,12],[7,15,7,16],[7,19,7,20],[4,15,4,16],[2,1,3,2],[7,1,7,2],[5,1,5,2],[5,3,5,4],[5,7,5,8],[5,11,5,12],[5,15,5,16],[6,1,6,2],[4,1,4,2],[4,3,4,4],[4,7,4,8],[7,3,7,4],[4,9,7,10],[4,13,7,14],[2,23,3,24],[4,0,7,0],[4,5,7,6],[2,19,2,22],[3,3,3,4],[3,5,3,6],[3,7,3,8],[3,9,3,10],[3,11,3,12],[3,13,3,14],[3,15,3,16],[3,17,3,18],[3,19,3,20],[2,3,2,6],[2,7,2,10],[2,11,2,14],[2,15,2,18],[3,21,3,22],[2,0,3,0],[6,3,6,4],[6,7,6,8],[6,11,6,12],[6,15,6,16],[4,11,4,12]]}
[null,"Pillars of HiAP: 5. Monitoring & Evaluation"]
[null,"Scores will autopopulate this monitoring table using your scores for your self assessment across the enabler tables below. Please start with enabler 1.  "]
["You can change you can edit the monitoring milestones to suit your needs","Reporting Period",null,{"$f":"'1. Cross-sector Partnerships'!D3","v":"Starting Point"},null,null,null,{"$f":"'1. Cross-sector Partnerships'!H3","v":"End of Year 1"},null,null,null,{"$f":"'1. Cross-sector Partnerships'!L3","v":"End of Year 2"},null,null,null,{"$f":"'1. Cross-sector Partnerships'!P3","v":"End of Year 3"},null,null,null,{"$f":"'1. Cross-sector Partnerships'!T3","v":"End of Year 4"}]
[null,null,null,"Self-assessment score",null,"Overall",null,"Self-assessment score",null,"Overall",null,"Self-assessment score",null,"Overall",null,"Self-assessment score",null,"Overall",null,"Self-assessment score",null,"Overall"]
["Enablers","Health lens analysis",null,{"$f":"IF(ISNUMBER(G14), G14, 0)","v":0},null,{"$f":"IF(SUM(D5:D8)/4=0, \"Enter score below\", SUM(D5:D8)/4)","v":"Enter score below"},null,{"$f":"IF(ISNUMBER(J14), J14, 0)","v":0},null,{"$f":"IF(SUM(H5:H8)/4=0, \"Enter score below\", SUM(H5:H8)/4)","v":"Enter score below"},null,{"$f":"IF(ISNUMBER(M14), M14, 0)","v":0},null,{"$f":"IF(SUM(L5:L8)/4=0, \"Enter score below\", SUM(L5:L8)/4)","v":"Enter score below"},null,{"$f":"IF(ISNUMBER(P14), P14, 0)","v":0},null,{"$f":"IF(SUM(P5:P8)/4=0, \"Enter score below\", SUM(P5:P8)/4)","v":"Enter score below"},null,{"$f":"IF(ISNUMBER(S14), S14, 0)","v":0},null,{"$f":"IF(SUM(T5:T8)/4=0, \"Enter score below\", SUM(T5:T8)/4)","v":"Enter score below"}]
[null,"Outcomes evaluation",null,{"$f":"IF(ISNUMBER(G18), G18, 0)","v":0},null,null,null,{"$f":"IF(ISNUMBER(J18), J18, 0)","v":0},null,null,null,{"$f":"IF(ISNUMBER(M18), M18, 0)","v":0},null,null,null,{"$f":"IF(ISNUMBER(P18), P18, 0)","v":0},null,null,null,{"$f":"IF(ISNUMBER(S18), S18, 0)","v":0}]
[null,"Organisation-wide evaluative framework",null,{"$f":"IF(ISNUMBER(G22), G22, 0)","v":0},null,null,null,{"$f":"IF(ISNUMBER(J22), J22, 0)","v":0},null,null,null,{"$f":"IF(ISNUMBER(M22), M22, 0)","v":0},null,null,null,{"$f":"IF(ISNUMBER(P22), P22, 0)","v":0},null,null,null,{"$f":"IF(ISNUMBER(S22), S22, 0)","v":0}]
[null,"Using data",null,{"$f":"IF(ISNUMBER(G26), G26, 0)","v":0},null,null,null,{"$f":"IF(ISNUMBER(J26), J26, 0)","v":0},null,null,null,{"$f":"IF(ISNUMBER(M26), M26, 0)","v":0},null,null,null,{"$f":"IF(ISNUMBER(P26), P26, 0)","v":0},null,null,null,{"$f":"IF(ISNUMBER(S26), S26, 0)","v":0}]
[]
[null,null,null,null,null,null,"RAG Rating Scoring System"]
[null,null,null,null,null,null,"1. Needs more work",null,null,null,null,"2. Is progressing",null,null,null,null,"3. Is well developed"]
[]
["Enabler 1","Utilising health lens analysis and health impact assessments iteratively and flexibly before, during, and after policy development, planning, and implementation across CA levers to take a systematic look at the potential and actual impact on health outcomes; This method enables an active research approach that embeds learning by doing and can help integrate HiAP across under-researched cross-policy areas. ",null,null,"Scorecard","Milestone",{"$f":"D3","v":"Starting Point"},null,null,{"$f":"H3","v":"End of Year 1"},null,null,{"$f":"L3","v":"End of Year 2"},null,null,{"$f":"P3","v":"End of Year 3"},null,null,{"$f":"T3","v":"End of Year 4"}]
[null,null,null,null,null,"Score",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter your self-assessment score using the drop down list"]
[null,null,null,null,null,"Rationale and agreed actions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Use this free text box to provide rationale for your score and any agreed actions at each review milestone. This might support evaluating progress made and informing future assessments."]
[]
["Enabler 2","Utilising HiAP outcomes evaluation to demonstrate effectiveness, promote continuous learning and improvement, guide programme evolution, effectively allocate resources and promote stakeholder engagement.",null,null,"Scorecard","Milestone",{"$f":"G13","v":"Starting Point"},null,null,{"$f":"J13","v":"End of Year 1"},null,null,{"$f":"M13","v":"End of Year 2"},null,null,{"$f":"P13","v":"End of Year 3"},null,null,{"$f":"S13","v":"End of Year 4"}]
[null,null,null,null,null,"Score",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter your self-assessment score using the drop down list"]
[null,null,null,null,null,"Rationale and agreed actions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Use this free text box to provide rationale for your score and any agreed actions at each review milestone. This might support evaluating progress made and informing future assessments."]
[]
["Enabler 3","Framing the HiAP approach within a long-term CA-wide evaluative framework that provides a structured data collation and analysis mechanism to understand the effectiveness of HiAP efforts on the region’s health; Longer-term outcomes should be supported by the contribution of shorter-term measurements.",null,null,"Scorecard","Milestone",{"$f":"G17","v":"Starting Point"},null,null,{"$f":"J17","v":"End of Year 1"},null,null,{"$f":"M17","v":"End of Year 2"},null,null,{"$f":"P17","v":"End of Year 3"},null,null,{"$f":"S17","v":"End of Year 4"}]
[null,null,null,null,null,"Score",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter your self-assessment score using the drop down list"]
[null,null,null,null,null,"Rationale and agreed actions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Use this free text box to provide rationale for your score and any agreed actions at each review milestone. This might support evaluating progress made and informing future assessments."]
[]
["Enabler 4","Using data to illustrate how the wider determinants impact health outcomes and their interconnectedness with CA levers can strengthen the rationale for HiAP and help build the business case for action.",null,null,"Scorecard","Milestone",{"$f":"G21","v":"Starting Point"},null,null,{"$f":"J21","v":"End of Year 1"},null,null,{"$f":"M21","v":"End of Year 2"},null,null,{"$f":"P21","v":"End of Year 3"},null,null,{"$f":"S21","v":"End of Year 4"}]
[null,null,null,null,null,"Score",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter your self-assessment score using the drop down list"]
[null,null,null,null,null,"Rationale and agreed actions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Use this free text box to provide rationale for your score and any agreed actions at each review milestone. This might support evaluating progress made and informing future assessments."]

{"sheet":"Backend","index":7,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["Column1","Starting point","End of Year 1","End of Year 2","End of Year 3","End of Year 4",null,null,"Drop down list"]
["Cross-sector Partnerships",{"$f":"'1. Cross-sector Partnerships'!F5","v":"Enter score below"},{"$f":"'1. Cross-sector Partnerships'!J5","v":"Enter score below"},{"$f":"'1. Cross-sector Partnerships'!N5","v":"Enter score below"},{"$f":"'1. Cross-sector Partnerships'!R5","v":"Enter score below"},{"$f":"'1. Cross-sector Partnerships'!V5","v":"Enter score below"},null,null,"User Input"]
["Shared Strategic Aims",{"$f":"'2. Shared Strategic Aims'!F5","v":"Enter score below"},{"$f":"'2. Shared Strategic Aims'!J5","v":"Enter score below"},{"$f":"'2. Shared Strategic Aims'!N5","v":"Enter score below"},{"$f":"'2. Shared Strategic Aims'!R5","v":"Enter score below"},{"$f":"'2. Shared Strategic Aims'!V5","v":"Enter score below"},null,null,1]
["Leadership",{"$f":"'3. Leadership'!F5","v":"Enter score below"},{"$f":"'3. Leadership'!J5","v":"Enter score below"},{"$f":"'3. Leadership'!N5","v":"Enter score below"},{"$f":"'3. Leadership'!R5","v":"Enter score below"},{"$f":"'3. Leadership'!V5","v":"Enter score below"},null,null,2]
["Governance",{"$f":"'4. Governance'!F5","v":"Enter score below"},{"$f":"'4. Governance'!J5","v":"Enter score below"},{"$f":"'4. Governance'!N5","v":"Enter score below"},{"$f":"'4. Governance'!R5","v":"Enter score below"},{"$f":"'4. Governance'!V5","v":"Enter score below"},null,null,3]
["M&E",{"$f":"'5. Monitoring & Evaluation'!F5","v":"Enter score below"},{"$f":"'5. Monitoring & Evaluation'!J5","v":"Enter score below"},{"$f":"'5. Monitoring & Evaluation'!N5","v":"Enter score below"},{"$f":"'5. Monitoring & Evaluation'!R5","v":"Enter score below"},{"$f":"'5. Monitoring & Evaluation'!V5","v":"Enter score below"}]
["Total",{"$f":"SUM(B2:B6)/5","v":0},{"$f":"SUM(C2:C6)/5","v":0},0,0,0]
[null,"f","j","n","r","v"]
[]
["Decimal adjust","Starting point","End of Year 1","End of Year 2","End of Year 3","End of Year 4"]
["Cross-sector Partnerships",{"$f":"IF(B2=0, TEXT(B2, \"0\"), IF(B2-INT(B2)=0, TEXT(B2, \"0\"), IF(B2*10-INT(B2*10)=0, TEXT(B2, \"0.0\"), TEXT(B2, \"0.00\"))))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(B2=0, 0, IF(B2-INT(B2)=0, ROUND(B2, 0), IF(B2*10-INT(B2*10)=0, ROUND(B2, 1), ROUND(B2, 2))))","v":{"$error":"#VALUE!"}},{"$f":"IF(C2=0, 0, IF(C2-INT(C2)=0, ROUND(C2, 0), IF(C2*10-INT(C2*10)=0, ROUND(C2, 1), ROUND(C2, 2))))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Shared Strategic Aims",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(C3=0, 0, IF(C3-INT(C3)=0, ROUND(C3, 0), IF(C3*10-INT(C3*10)=0, ROUND(C3, 1), ROUND(C3, 2))))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Leadership",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(C4=0, 0, IF(C4-INT(C4)=0, ROUND(C4, 0), IF(C4*10-INT(C4*10)=0, ROUND(C4, 1), ROUND(C4, 2))))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Governance",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(C5=0, 0, IF(C5-INT(C5)=0, ROUND(C5, 0), IF(C5*10-INT(C5*10)=0, ROUND(C5, 1), ROUND(C5, 2))))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Monitoring & Evaluation",{"$f":"IF(B6=0, TEXT(B6, \"0\"), IF(B6-INT(B6)=0, TEXT(B6, \"0\"), IF(B6*10-INT(B6*10)=0, TEXT(B6, \"0.0\"), TEXT(B6, \"0.00\"))))","v":{"$error":"#VALUE!"}},{"$f":"IF(C6=0, TEXT(C6, \"0\"), IF(C6-INT(C6)=0, TEXT(C6, \"0\"), IF(C6*10-INT(C6*10)=0, TEXT(C6, \"0.0\"), TEXT(C6, \"0.00\"))))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(C6=0, 0, IF(C6-INT(C6)=0, ROUND(C6, 0), IF(C6*10-INT(C6*10)=0, ROUND(C6, 1), ROUND(C6, 2))))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Total","0","0","0","0","0",0,{"$f":"IF(C7=0, 0, IF(C7-INT(C7)=0, ROUND(C7, 0), IF(C7*10-INT(C7*10)=0, ROUND(C7, 1), ROUND(C7, 2))))","v":0},0,0,0]
[]
[null,null,{"$f":"'1. Cross-sector Partnerships'!D3","v":"Starting Point"},{"$f":"'1. Cross-sector Partnerships'!H3","v":"End of Year 1"},{"$f":"'1. Cross-sector Partnerships'!L3","v":"End of Year 2"},{"$f":"'1. Cross-sector Partnerships'!P3","v":"End of Year 3"},{"$f":"'1. Cross-sector Partnerships'!T3","v":"End of Year 4"}]
[null,"Cross-sector partnership working",{"$f":"IFERROR(Backend!$B$11,\"No score found\")","v":"No score found"},{"$f":"IFERROR(Backend!$C$11, IF(OR($C$6=\"No score found\", $C$6=\"\"), \"\", \"No score found\"))","v":"No score found"},{"$f":"IFERROR(Backend!$D$11, IF(OR($D$6=\"No score found\", $D$6=\"\"), \"\", \"No score found\"))","v":"No score found"},{"$f":"IFERROR(Backend!$E$11, IF(OR($E$6=\"No score found\", $E$6=\"\"), \"\", \"No score found\"))","v":"No score found"},{"$f":"IFERROR(Backend!$F$11, IF(OR($F$6=\"No score found\", $F$6=\"\"), \"\", \"No score found\"))","v":"No score found"}]
[null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(C19), C19, IF(C19=\"No score found\", \"\", \"\"))","v":""}]