{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["INTRO","P1","P2","P3","P4","P5","P6","P7","P8","P9","P10","P11","P12"],"not_rendered":{"charts":12,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"INTRO","index":0,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,1,26,1]]}
[]
[null,"Methodological Note:\nHow to use the Good Democratic Governance Benchmark\n\nIntroduction\nThis methodological note serves to introduce the self-assessment benchmark for the European Label of Governance Excellence (ELoGE) and explain how it is to be used.\nThe benchmark offers a structured and comprehensive framework for measuring and improving democratic governance practice at the local authority level. It promotes respect for the standards set out in CM/Rec(2023)5 on principles of good democratic governance. It enables public institutions at the local level  to conduct a thorough self-assessment of performance and identify opportunities for improvement in their democratic governance practice.\n\nPrinciples of Good Democratic Governance\nThe benchmark is based on the 12 principles of good democratic governance as outlined in Recommendation CM/Rec(2023)5 to member states on the principles of good democratic governance.\n\nKey Elements and Considerations\nThe benchmark is composed of 12 Principles – 36 Targets - 72 Indicators.\nThe benchmark indicators and targets have been developed based on the key elements and considerations provided in the Explanatory Memorandum to Recommendation CM/Rec(2023)5. \nThese elements guide both the implementation of the principles and the assessment of compliance with each of them.\n\nComponents of the Benchmark\nTargets and Indicators\nEach of the 12 principles has been broken down into three Targets based on criteria set out in the Explanatory Memorandum to CM/Rec(2023)5.   In order to demonstrate compliance with the Principle, the Targets should be met.   Each Target has been further sub-divided into two detailed Indicators, which represent measures or activities contributing to attainment of the respective Target.\n\nEvidence Sources\nTo assist local authorities in justifying their self-assessments, examples of three potential evidence sources are provided for each Indicator. These sources exemplify the types of evidence that a local authority could use to support its evaluation.\n- A Target should be understood as a specific level of achievement or compliance with an integral component of the principle.\n- An Indicator should be understood as a detailed measure or activity that contributes to achieving the respective Target.\n\nScoring Framework\nLocal authorities are required to indicate a level of compliance with each Indicator based on the (self-assessed/perceived) level of achievement.  In conducting the self-assessment, an X should be marked in the appropriate column of the benchmark. The scoring system ranges from 0 to 1, reflecting the perceived level of compliance  :\n\n- NOT AT ALL (0) - We are aware of the key issues but not planning nor action is taken.\t\n- PARTIALLY (0.33) - We acknowledge the key issues and designing answers, but only limited actions is taken.\t\n- SUFFICIENTLY (0.67) - We have well developed plans and activities to address key issues with significant examples of implementation.\t\n- FULLY (1) - We can show clear evidence of good practices which are monitored and integrated in our interventions.\n\nOverall Assessment\nIndicators are scored on a progressive scale from 0% - 33% - 67% - 100%. The Target score is calculated as an average of the composite Indicators. The overall score for each Principle is then calculated as the average of the composite Target scores.\nThe Excel tool will automatically calculate the average indicator score and the target score.\n\nOverall Compliance with the Principle\nOnce all six Indicators for each of the three Targets for a Principle have been assessed, the local authority is asked to express its perceived level of compliance with the overall Principle.\n\nEvidence Description\nFor each Indicator, the local authority is asked to provide a brief description of the evidence they could produce to substantiate their assessment. The evidence should be easily provided to the national ELoGE Stakeholders’ Platform  upon request.\n\nEstablishing a Benchmark Task-Force\nLocal authorities are encouraged to establish a \"Benchmark Task-Force\" composed of key stakeholders, including senior elected officials and staff members from across the local administration. This task force is responsible for completing the benchmark in a collaborative manner, ensuring a thorough and collective assessment.                                                                                                                                                                                                                                                                                                             \n"]

{"sheet":"P1","index":1,"n_rows":48,"n_cols":22,"rows_kept":48,"cut":false,"hidden":false,"merged":[[36,8,40,8],[36,7,40,7],[29,15,34,15],[24,15,28,15],[24,8,28,8],[36,15,40,15],[15,5,22,5],[8,8,14,8],[8,7,14,7],[8,15,14,15],[15,15,22,15],[15,8,22,8],[15,7,22,7],[4,6,6,6],[4,7,6,7],[4,8,6,8],[7,2,7,8],[4,2,6,3],[41,6,45,6],[41,5,45,5],[1,1,3,3],[1,4,3,4],[8,5,14,5],[8,6,14,6],[15,4,22,4],[8,4,14,4],[4,4,6,4],[23,2,23,8],[24,7,28,7],[24,6,28,6],[24,5,28,5],[24,4,28,4],[15,6,22,6],[4,5,6,5],[4,21,6,21],[4,15,6,15],[4,19,6,19],[41,15,45,15],[36,5,40,5],[29,8,34,8],[29,7,34,7],[29,6,34,6],[29,5,34,5],[36,6,40,6],[35,2,35,15],[41,4,45,4],[36,4,40,4],[29,4,34,4],[41,8,45,8],[41,7,45,7]]}
[]
[null,"Principle 1 - Democratic participation",null,null,"There should be effective and inclusive democratic participation, including regular, free, and fair elections to legislatures, assemblies and other public institutions, and meaningful engagement by government and public institutions with those whom they serve.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CELL(\"contents\",Q48)>0,P48,\"--\")","v":0.44444444444444442},null,"Average Indicator score"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P47","v":0.66666666666666663},null,"Statement score"]
[]
[null,null,"Target",null,"Indicator","NOT AT ALL","PARTIALLY","SUFFICIENTLY","FULLY",null,null,null,null,null,null,"Indicator score",null,null,null,"Target score",null,"Not at all - We are aware of the key issues but not planning nor action is taken.\nPartially - We acknowledge the key issues and designing answers, but only limited actions is taken.\nSufficiently - We have well developed plans and activities to address key issues with significant examples of implementation.\t\nFully - We can show clear evidence of good practices which are monitored and integrated in our interventions."]
[]
[]
[null,"1.1","People are at the centre of policy and decision-making processes. There is a balanced participation of all genders in political and public decision-making, and the broad participation of all people, including the less privileged and the vulnerable is fostered.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J9:M9,J16:M16)","v":4},{"$f":"(((R8-(2))*(1-0))/(8-(2)))+0","v":0.33333333333333331},{"$f":"IF(CELL(\"contents\",U8)>0,S8,\"\")","v":0.33333333333333331},{"$f":"COUNTIF(F9:I16,\"x\")","v":2},"Suggested evidences"]
[null,null,null,"1.1.1","Participatory democratic mechanisms - such as public consultations, citizens' assemblies, townhall meetings, participatory budgeting initiatives, including participatory budgeting for green initiatives, and referenda - organised regularly by the local authority."," ","x",null,null,{"$f":"IF(F9=\"x\",1,0)","v":0},{"$f":"IF(G9=\"x\",2,0)","v":2},{"$f":"IF(H9=\"x\",3,0)","v":0},{"$f":"IF(I9=\"x\",4,0)","v":0},{"$f":"SUM(J9:M9)","v":2},{"$f":"(((N9-(1))*(1-0))/(4-(1)))+0","v":0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q9)>0,O9,\"--\")","v":0.33333333333333331},{"$f":"COUNTIF(F9:I9,\"x\")","v":1},null,null,null,null,"Reports of regular stakeholders mapping and assessment."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Records of public consultations, including meeting minutes, attendance logs, and feedback received."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Records of participatory mechanisms implemented, including questions posed, participants list, project proposals, etc. "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Existence of dedicated functions/appointed councillors to coordination of  participation processes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Existence of external collaborations for the creation of participation processes."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Existence of permanent committees and public assemblies on topics of public/general interest including environmental topics"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,null,null,"1.1.2","The local authority collects disaggregated data to measure representation of all genders, the less privileged and the vulnerable in policy and decision-making bodies.",null,"x",null,null,0,2,0,0,{"$f":"SUM(J16:M16)","v":2},{"$f":"(((N16-(1))*(1-0))/(4-(1)))+0","v":0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q16)>0,O16,\"--\")","v":0.33333333333333331},1,null,null,null,null,"Reports detailing the composition of policy and decision-making bodies, including gender breakdown."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gender diversity statistics over time to track improvements."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minutes of meetings showing discussions or actions taken to address gender representation issues."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statistics on gender diversity  to monitor improvements."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reports on the implementation of any local authority policies in the field of gender mainstreaming "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reports of the activities of any appointed councils (e.g., equal opportunities/gender policy, migrants, disability, Guarantor for the Rights of Prisoners and Women Prisoners) "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mechanisms to include underrepresented groups in environmental decision-making processes."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,"1.2","People have the opportunity to access and engage in policy and decision-making processes directly or through legitimate intermediate bodies that represent their interests, ensuring decisions reflect the will of the majority while respecting the rights and legitimate interests of the minority.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J25:M25,J30:M30)","v":5},{"$f":"(((R24-(2))*(1-0))/(8-(2)))+0","v":0.5},{"$f":"IF(CELL(\"contents\",U24)>0,S24,\"\")","v":0.5},{"$f":"COUNTIF(F25:I30,\"x\")","v":2}]
[null,null,null,"1.2.1","The local authority engages with legitimate intermediate bodies (i.e., private or public) composed of representatives from diverse backgrounds and demographics within the community in decision-making processes.",null,null,"x",null,0,0,3,0,3,0.66666666666666663,{"$f":"IF(CELL(\"contents\",Q25)>0,O25,\"--\")","v":0.66666666666666663},1,null,null,null,null,"Agreements or memoranda of understanding with intermediate bodies (i.e., private or public) specifying their roles and responsibilities in decision-making."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Documentation of meetings and interactions between the local authority and intermediate bodies (i.e., private or public)."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reports or testimonials from representatives of diverse backgrounds within the community about their involvement in decision-making processes."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Regular consultations and feedback mechanisms on public policies, including environmental policies."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,null,null,"1.2.2","The local authority actively seeks input from a broad spectrum of community representatives and stakeholders, including marginalised or under-represented groups.",null,"x",null,null,0,2,0,0,2,0.33333333333333331,{"$f":"IF(CELL(\"contents\",Q30)>0,O30,\"--\")","v":0.33333333333333331},1,null,null,null,null,"Records of outreach efforts, such as community surveys, focus groups, or consultations with marginalised or underrepresented groups."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Documentation of initiatives aimed at promoting inclusivity in participation, such as language accessibility measures or arrangements for people with disabilities."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reports summarising the input received from various community groups and how it influenced decision-making"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Publicly accessible platforms to share environmental information and collect public feedback."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Efforts to engage civil society and partner with NGOs with expertise in environmental issues."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,"1.3","Elections are conducted freely and fairly, without any fraud, in accordance with national laws, European standards and electoral heritage, as summarised for instance in the Code of good practice in electoral matters of the European Commission for Democracy through Law (the Venice Commission).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J37:M37,J42:M42)","v":5},{"$f":"(((R36-(2))*(1-0))/(8-(2)))+0","v":0.5},{"$f":"IF(CELL(\"contents\",U36)>0,S36,\"\")","v":0.5},{"$f":"COUNTIF(F37:I42,\"x\")","v":2}]
[null,null,null,"1.3.1","Voter education and awareness-raising programmes implemented by the local authority to educate the public about the electoral process, the importance of voting, and how to participate effectively in elections. ",null,null,"x",null,0,0,3,0,3,0.66666666666666663,{"$f":"IF(CELL(\"contents\",Q37)>0,O37,\"--\")","v":0.66666666666666663},1,null,null,null,null,"Educational materials and resources developed, such as brochures, pamphlets, and online content."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Records of voter education programmes conducted, including dates, locations, and participant feedback."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data on voter registration rates and voter turnout in local elections before and after implementing voter education initiatives."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Information on Environmental decision-making processes published."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,null,null,"1.3.2","Actions to strengthen election monitoring, ensure integrity and transparency in campaign processes, and maintain the accuracy and security of voter registration systems implemented by the local authorities within the scope of its competences. ",null,"x",null,null,0,2,0,0,2,0.33333333333333331,{"$f":"IF(CELL(\"contents\",Q42)>0,O42,\"--\")","v":0.33333333333333331},1,null,null,null,null,"Records of polling station setup and management, including locations, staffing, accessibility measures also for independent observers, list representatives at elections (i.e., if provided)  and vote-counting procedures."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Documentation of campaign regulations and guidelines in place, outlining rules for campaign financing, advertising, and conduct."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Records demonstrating efforts to maintain the accuracy and security of voter registration systems, such as regular audits and security protocols."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Access to environmental information should be ensured through these channels."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,null,"How much do you agree with the following statement",null,"Our local authority ensures effective and inclusive democratic participation by consistently holding regular, free, and fair elections for our legislatures, assemblies, and other public institutions. It is committed to engaging meaningfully with people, valuing their input in all our decision-making processes.",null,null,"x",null,0,0,3,0,3,0.66666666666666663,{"$f":"IF(CELL(\"contents\",Q47)>0,O47,\"--\")","v":0.66666666666666663},{"$f":"COUNTIF(F47:I47,\"x\")","v":1},{"$f":"T2*T3","v":0.29629629629629628}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average",{"$f":"AVERAGE(P9,P16,P25,P30,P37,P42)","v":0.44444444444444442},{"$f":"COUNTIF(F9:I42,\"x\")","v":6}]

{"sheet":"P2","index":2,"n_rows":43,"n_cols":22,"rows_kept":43,"cut":false,"hidden":false,"merged":[[30,2,30,8],[30,9,30,15],[36,15,40,15],[31,4,35,4],[31,5,35,5],[31,6,35,6],[31,7,35,7],[31,8,35,8],[31,15,35,15],[36,4,40,4],[36,5,40,5],[36,6,40,6],[36,7,40,7],[36,8,40,8],[20,15,24,15],[25,4,29,4],[25,5,29,5],[25,6,29,6],[25,7,29,7],[25,8,29,8],[25,15,29,15],[19,2,19,8],[20,4,24,4],[20,5,24,5],[20,6,24,6],[20,7,24,7],[20,8,24,8],[14,15,18,15],[4,21,6,21],[7,2,7,8],[8,4,13,4],[8,5,13,5],[8,6,13,6],[8,7,13,7],[8,8,13,8],[8,15,13,15],[4,19,6,19],[14,4,18,4],[14,5,18,5],[14,6,18,6],[14,7,18,7],[14,8,18,8],[1,1,3,3],[1,4,3,4],[4,2,6,3],[4,4,6,4],[4,15,6,15],[4,5,6,5],[4,6,6,6],[4,7,6,7],[4,8,6,8]]}
[]
[null,"Principle 2 - Human Rights",null,null,"The respect for human rights which protect everyone, and which embody the values of fairness, dignity, equality and respect should be ensured, in accordance with European and international standards, including the Statute of the Council of Europe (ETS No. 1) and the European Convention on Human Rights (ETS No. 5).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CELL(\"contents\",Q43)>0,P43,\"--\")","v":"--"},null,"Average Indicator score"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P42","v":"--"},null,"Statement score"]
[]
[null,null,"Target",null,"Indicator",{"$f":"'P1'!F5","v":"NOT AT ALL"},{"$f":"'P1'!G5","v":"PARTIALLY"},{"$f":"'P1'!H5","v":"SUFFICIENTLY"},{"$f":"'P1'!I5","v":"FULLY"},{"$f":"'P1'!J5","v":0},{"$f":"'P1'!K5","v":0},{"$f":"'P1'!L5","v":0},{"$f":"'P1'!M5","v":0},{"$f":"'P1'!N5","v":0},{"$f":"'P1'!O5","v":0},{"$f":"'P1'!P5","v":"Indicator score"},{"$f":"'P1'!Q5","v":0},{"$f":"'P1'!R5","v":0},{"$f":"'P1'!S5","v":0},{"$f":"'P1'!T5","v":"Target score"},null,"Not at all - We are aware of the key issues but not planning nor action is taken.\nPartially - We acknowledge the key issues and designing answers, but only limited actions is taken.\nSufficiently - We have well developed plans and activities to address key issues with significant examples of implementation.\t\nFully - We can show clear evidence of good practices which are monitored and integrated in our interventions."]
[null,null,null,null,null,null,null,null,null,{"$f":"'P1'!J6","v":0},{"$f":"'P1'!K6","v":0},{"$f":"'P1'!L6","v":0},{"$f":"'P1'!M6","v":0},{"$f":"'P1'!N6","v":0},{"$f":"'P1'!O6","v":0},null,{"$f":"'P1'!Q6","v":0},{"$f":"'P1'!R6","v":0},{"$f":"'P1'!S6","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"'P1'!J7","v":0},{"$f":"'P1'!K7","v":0},{"$f":"'P1'!L7","v":0},{"$f":"'P1'!M7","v":0},{"$f":"'P1'!N7","v":0},{"$f":"'P1'!O7","v":0},null,{"$f":"'P1'!Q7","v":0},{"$f":"'P1'!R7","v":0},{"$f":"'P1'!S7","v":0}]
[null,"2.1","Appropriate legislation, institutions, procedures, practices, and norms ensure the robust development, promotion, protection, and effective enjoyment of human rights, including environmental rights.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J9:M9,J15:M15)","v":0},{"$f":"(((R8-(2))*(1-0))/(8-(2)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",U8)>0,S8,\"\")","v":""},{"$f":"COUNTIF(F9:I15,\"x\")","v":0},"Suggested evidences"]
[null,null,null,"2.1.1","Regular human rights impact assessments, including of environmental wellbeing, of local policies and regulations are carried out, possibly in collaboration with local human rights organisations and environmental organisations.\n",null,null,null,null,{"$f":"IF(F9=\"x\",1,0)","v":0},{"$f":"IF(G9=\"x\",2,0)","v":0},{"$f":"IF(H9=\"x\",3,0)","v":0},{"$f":"IF(I9=\"x\",4,0)","v":0},{"$f":"SUM(J9:M9)","v":0},{"$f":"(((N9-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q9)>0,O9,\"--\")","v":"--"},{"$f":"COUNTIF(F9:I9,\"x\")","v":0},null,null,null,null,"Reports/studies on Human Impact Assessment at local level."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Collaboration with human rights organisations, Civil Society Organisations, external stakeholders in initiatives, projects, etc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reports or statements of integration/update of policies, highlighting specific changes that were implemented based on the assessment findings."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Evidence on Environmental Impact Assessment of policies at local level (e.g., quality of the air, overall health of the environment, etc.)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Evidence of policies to promote energy efficiency in housing and public buildings"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,null,null,"2.1.2","Robust monitoring, reporting, and complaint mechanisms, including the presence of an Ombuds Institution, are established to address human rights and environmental infringements. ",null,null,null,null,{"$f":"IF(F15=\"x\",1,0)","v":0},{"$f":"IF(G15=\"x\",2,0)","v":0},{"$f":"IF(H15=\"x\",3,0)","v":0},{"$f":"IF(I15=\"x\",4,0)","v":0},{"$f":"SUM(J15:M15)","v":0},{"$f":"(((N15-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q15)>0,O15,\"--\")","v":"--"},{"$f":"COUNTIF(F15:I15,\"x\")","v":0},null,null,null,null,"Annual reports or summaries from the local Ombuds Institution or a similar oversight body."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Records of individual complaint cases, including documentation of the complaint, the investigation process, and the resolution."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Municipalities' participation in national or international human rights reporting mechanisms and/or networks."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Evidence of environmental rights monitoring and reporting."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,"2.2","Equality for all is actively promoted to build more inclusive societies that offer adequate protection from discrimination and hate and where diversity is respected.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J21:M21,J26:M26)","v":0},{"$f":"(((R20-(2))*(1-0))/(8-(2)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",U20)>0,S20,\"\")","v":""},{"$f":"COUNTIF(F21:I26,\"x\")","v":0}]
[null,null,null,"2.2.1","Diversity and inclusion training programmes, including human rights aspects of the environment, capacity-building activities or awareness raising initiatives for local authority employees and community stakeholders are delivered.",null,null,null,null,{"$f":"IF(F21=\"x\",1,0)","v":0},{"$f":"IF(G21=\"x\",2,0)","v":0},{"$f":"IF(H21=\"x\",3,0)","v":0},{"$f":"IF(I21=\"x\",4,0)","v":0},{"$f":"SUM(J21:M21)","v":0},{"$f":"(((N21-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q21)>0,O21,\"--\")","v":"--"},{"$f":"COUNTIF(F21:I21,\"x\")","v":0},null,null,null,null,"Attendance documentation for diversity and inclusion training sessions conducted for municipality employees and community stakeholders. "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Feedback surveys from participants to trainings, capacity building or awareness raising activities. "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Educational and promotional materials, such as presentation slides, handouts, or online course content."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reports on the implementation of local authority policies in relation to human rights aspects of the environment."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,null,null,"2.2.2","Regulations have been drafted by the local authority to implement existing international and national anti-discrimination legislation, including access to a healthy environment..",null,null,null,null,{"$f":"IF(F26=\"x\",1,0)","v":0},{"$f":"IF(G26=\"x\",2,0)","v":0},{"$f":"IF(H26=\"x\",3,0)","v":0},{"$f":"IF(I26=\"x\",4,0)","v":0},{"$f":"SUM(J26:M26)","v":0},{"$f":"(((N26-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q26)>0,O26,\"--\")","v":"--"},{"$f":"COUNTIF(F26:I26,\"x\")","v":0},null,null,null,null,"Municipal laws and policies explicitly prohibit discrimination on various grounds."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cases of discriminatory practices are investigated and sanctioned by municipal authorities."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Documentation showcases mechanisms available at the municipal level to address cases of discrimination."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Evidence of regulations protecting the right to a clean, healthy and sustainable environment."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,"2.3","Diversity and inclusion in society of all people, including all genders and the less privileged and vulnerable, are actively supported through dedicated strategies and plans, that specify objectives, targets, and monitoring mechanisms.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J32:M32,J37:M37)","v":0},{"$f":"(((R31-(2))*(1-0))/(8-(2)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",U31)>0,S31,\"\")","v":""},{"$f":"COUNTIF(F32:I37,\"x\")","v":0}]
[null,null,null,"2.3.1","Diversity and Inclusion Strategies adopted and implemented (at local or regional level).",null,null,null,null,{"$f":"IF(F32=\"x\",1,0)","v":0},{"$f":"IF(G32=\"x\",2,0)","v":0},{"$f":"IF(H32=\"x\",3,0)","v":0},{"$f":"IF(I32=\"x\",4,0)","v":0},{"$f":"SUM(J32:M32)","v":0},{"$f":"(((N32-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q32)>0,O32,\"--\")","v":"--"},{"$f":"COUNTIF(F32:I32,\"x\")","v":0},null,null,null,null,"Strategic plans for promoting diversity and inclusion, that include objectives, targets, and monitoring mechanisms, including also gender equality, support for less privileged and vulnerable groups, and other diversity-related goals. "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Progress reports on the implementation of such strategic plans."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Case studies that can illustrate examples of success stories and Targets of the strategies and plans. "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Evidence of initiatives of green participatory budgeting for environmental projects."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,null,null,"2.3.2","Community engagement initiatives adopted and implemented, including initiatives for environmental projects, and promoting harmony with nature.",null,null,null,null,{"$f":"IF(F37=\"x\",1,0)","v":0},{"$f":"IF(G37=\"x\",2,0)","v":0},{"$f":"IF(H37=\"x\",3,0)","v":0},{"$f":"IF(I37=\"x\",4,0)","v":0},{"$f":"SUM(J37:M37)","v":0},{"$f":"(((N37-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q37)>0,O37,\"--\")","v":"--"},{"$f":"COUNTIF(F37:I37,\"x\")","v":0},null,null,null,null,"Activity reports and summaries of initiatives"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attendance records"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Feedback surveys and forms."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Evidence of initiatives of participatory budgeting, for instance around issues of environmental concern."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,null,"How much do you agree with the following statement?",null,"Our local authority upholds and champions the respect for human rights for all, ensuring values of fairness, dignity, equality, and respect are at the forefront of our actions. We adhere to European and international standards, including the Council of Europe Statute and the European Convention on Human Rights and Fundamental Freedoms.",null,null,null,null,{"$f":"IF(F42=\"x\",1,0)","v":0},{"$f":"IF(G42=\"x\",2,0)","v":0},{"$f":"IF(H42=\"x\",3,0)","v":0},{"$f":"IF(I42=\"x\",4,0)","v":0},{"$f":"SUM(J42:M42)","v":0},{"$f":"(((N42-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q42)>0,O42,\"--\")","v":"--"},{"$f":"COUNTIF(F42:I42,\"x\")","v":0},{"$f":"T2*T3","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average",{"$f":"AVERAGE(P9,P15,P21,P26,P32,P37)","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(F9:I37,\"x\")","v":0}]

{"sheet":"P3","index":3,"n_rows":42,"n_cols":22,"rows_kept":42,"cut":false,"hidden":false,"merged":[[31,2,31,8],[31,9,31,15],[36,15,39,15],[32,4,35,4],[32,5,35,5],[32,6,35,6],[32,7,35,7],[32,8,35,8],[32,15,35,15],[36,4,39,4],[36,5,39,5],[36,6,39,6],[36,7,39,7],[36,8,39,8],[21,15,25,15],[26,5,30,5],[26,6,30,6],[26,7,30,7],[26,8,30,8],[26,15,30,15],[15,15,19,15],[4,21,6,21],[7,2,7,8],[8,5,14,5],[8,6,14,6],[8,7,14,7],[8,8,14,8],[8,15,14,15],[4,19,6,19],[15,5,19,5],[15,6,19,6],[15,7,19,7],[15,8,19,8],[8,4,11,4],[4,15,6,15],[4,5,6,5],[26,4,29,4],[1,1,3,3],[1,4,3,4],[4,2,6,3],[4,4,6,4],[20,2,20,8],[21,4,25,4],[21,5,25,5],[21,6,25,6],[21,7,25,7],[21,8,25,8],[4,6,6,6],[4,7,6,7],[4,8,6,8],[12,4,14,4],[15,4,18,4]]}
[]
[null,"Principle 3 - Rule of law",null,null,"The rule of law should be respected, thus providing everyone with legal certainty, including foreseeable law, in which everyone is treated in a dignified, equal, rational, and proportional manner, within a framework in which the separation of powers and the independence of the judiciary are guaranteed throughout the country.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CELL(\"contents\",Q42)>0,P42,\"--\")","v":"--"},null,"Average Indicator score"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P41","v":"--"},null,"Statement score"]
[]
[null,null,"Target",null,"Indicator",{"$f":"'P1'!F5","v":"NOT AT ALL"},{"$f":"'P1'!G5","v":"PARTIALLY"},{"$f":"'P1'!H5","v":"SUFFICIENTLY"},{"$f":"'P1'!I5","v":"FULLY"},{"$f":"'P1'!J5","v":0},{"$f":"'P1'!K5","v":0},{"$f":"'P1'!L5","v":0},{"$f":"'P1'!M5","v":0},{"$f":"'P1'!N5","v":0},{"$f":"'P1'!O5","v":0},{"$f":"'P1'!P5","v":"Indicator score"},{"$f":"'P1'!Q5","v":0},{"$f":"'P1'!R5","v":0},{"$f":"'P1'!S5","v":0},{"$f":"'P1'!T5","v":"Target score"},null,"Not at all - We are aware of the key issues but not planning nor action is taken.\nPartially - We acknowledge the key issues and designing answers, but only limited actions is taken.\nSufficiently - We have well developed plans and activities to address key issues with significant examples of implementation.\t\nFully - We can show clear evidence of good practices which are monitored and integrated in our interventions."]
[null,null,null,null,null,null,null,null,null,{"$f":"'P1'!J6","v":0},{"$f":"'P1'!K6","v":0},{"$f":"'P1'!L6","v":0},{"$f":"'P1'!M6","v":0},{"$f":"'P1'!N6","v":0},{"$f":"'P1'!O6","v":0},null,{"$f":"'P1'!Q6","v":0},{"$f":"'P1'!R6","v":0},{"$f":"'P1'!S6","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"'P1'!J7","v":0},{"$f":"'P1'!K7","v":0},{"$f":"'P1'!L7","v":0},{"$f":"'P1'!M7","v":0},{"$f":"'P1'!N7","v":0},{"$f":"'P1'!O7","v":0},null,{"$f":"'P1'!Q7","v":0},{"$f":"'P1'!R7","v":0},{"$f":"'P1'!S7","v":0}]
[null,"3.1","Legality prevails and legal certainly is guaranteed, including a transparent, accountable, and democratic process for enacting laws. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J9:M9,J16:M16)","v":0},{"$f":"(((R8-(2))*(1-0))/(8-(2)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",U8)>0,S8,\"\")","v":""},{"$f":"COUNTIF(F9:I16,\"x\")","v":0},"Suggested evidences"]
[null,null,null,"3.1.1","Resolutions, procedures, regulation including environmental laws, and other decisions are adopted in accordance with the rules laid down by law and published in an open and accessible format.",null,null,null,null,{"$f":"IF(F9=\"x\",1,0)","v":0},{"$f":"IF(G9=\"x\",2,0)","v":0},{"$f":"IF(H9=\"x\",3,0)","v":0},{"$f":"IF(I9=\"x\",4,0)","v":0},{"$f":"SUM(J9:M9)","v":0},{"$f":"(((N9-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q9)>0,O9,\"--\")","v":"--"},{"$f":"COUNTIF(F9:I9,\"x\")","v":0},null,null,null,null,"Outreach documentation (invitations, leaflets, newsletters, etc.)."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Meeting records at public meetings, hearings, or consultations related to the development or amendment of local laws and policies."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Information material on feedback and input integration, such as leaflets and brochures."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Defined means of access to retained documents"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Well-defined time limits for access to documents"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Records of environmental decision-making processes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,null,null,"3.1.2","Transparency and accountability reports that outline key legislative actions, decisions, and their impacts on the local community, along with information on the decision-making process.",null,null,null,null,{"$f":"IF(F16=\"x\",1,0)","v":0},{"$f":"IF(G16=\"x\",2,0)","v":0},{"$f":"IF(H16=\"x\",3,0)","v":0},{"$f":"IF(I16=\"x\",4,0)","v":0},{"$f":"SUM(J16:M16)","v":0},{"$f":"(((N16-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q16)>0,O16,\"--\")","v":"--"},{"$f":"COUNTIF(F16:I16,\"x\")","v":0},null,null,null,null,"Reports summarising the local authorities' legal and policies actions and decisions, including the description of the process (council discussions, votes, etc.)."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Documentation and information material (such as reports, studies) that illustrate the potential impact of actions and decisions on the local community (for example socio-economic study for a new Urban plan)."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Decisions records/databases/registries/logs that are publicly accessible (online and/or offline)."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Streaming and audio-visual recording of meetings of deliberative bodies."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,"3.2","Measures are in place to ensure equality of the law and non-discrimination, and to prevent any misuse of powers, including legal safeguards against arbitrariness and abuse of power by public authorities.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J22:M22,J27:M27)","v":0},{"$f":"(((R21-(2))*(1-0))/(8-(2)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",U21)>0,S21,\"\")","v":""},{"$f":"COUNTIF(F22:I27,\"x\")","v":0}]
[null,null,null,"3.2.1","Local legal framework ensures equality before the law and freedom from discrimination at the municipal level, including on human rights aspect of the environment.",null,null,null,null,{"$f":"IF(F22=\"x\",1,0)","v":0},{"$f":"IF(G22=\"x\",2,0)","v":0},{"$f":"IF(H22=\"x\",3,0)","v":0},{"$f":"IF(I22=\"x\",4,0)","v":0},{"$f":"SUM(J22:M22)","v":0},{"$f":"(((N22-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q22)>0,O22,\"--\")","v":"--"},{"$f":"COUNTIF(F22:I22,\"x\")","v":0},null,null,null,null,"Accessibility monitoring systems/metrics/indicators considering, for instance, data on the availability of services in various neighbourhoods/districts, access for people with disabilities, the possibility of obtaining information in several languages, etc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Service quality reports considering response time, service availability."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Feedback records on municipal services including residents' comments, complaints, suggestions."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Records of remedies related to environmental issues."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,null,null,"3.2.2","There are effective and proportionate remedies for inappropriate decisions or omissions and any resulting actions or inactions. ",null,null,null,null,{"$f":"IF(F27=\"x\",1,0)","v":0},{"$f":"IF(G27=\"x\",2,0)","v":0},{"$f":"IF(H27=\"x\",3,0)","v":0},{"$f":"IF(I27=\"x\",4,0)","v":0},{"$f":"SUM(J27:M27)","v":0},{"$f":"(((N27-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q27)>0,O27,\"--\")","v":"--"},{"$f":"COUNTIF(F27:I27,\"x\")","v":0},null,null,null,null,"Accessible and public documentation illustrating the legal safeguards framework in place at local authority level preventing the abuse of power by public officials."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Capacity-building, trainings or awareness raising initiatives for employees and public officials on promoting equality, non-discrimination, and ethical conduct in the execution of their duties."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Accessibility of information on the institutional organisation chart in order to identify responsibilities"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Community awareness initiatives informing residents on their rights and existing legal safeguards, such as legal protections and complaints/reporting mechanisms."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,"3.3","Administrative acts/decisions need to be motivated. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J33:M33,J37:M37)","v":0},{"$f":"(((R32-(2))*(1-0))/(8-(2)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",U32)>0,S32,\"\")","v":""},{"$f":"COUNTIF(F33:I37,\"x\")","v":0}]
[null,null,null,"3.3.1","Periodic evaluation of administrative decisions made by the local authority to assess compliance with legal requirements and the motivation provided. ",null,null,null,null,{"$f":"IF(F33=\"x\",1,0)","v":0},{"$f":"IF(G33=\"x\",2,0)","v":0},{"$f":"IF(H33=\"x\",3,0)","v":0},{"$f":"IF(I33=\"x\",4,0)","v":0},{"$f":"SUM(J33:M33)","v":0},{"$f":"(((N33-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q33)>0,O33,\"--\")","v":"--"},{"$f":"COUNTIF(F33:I33,\"x\")","v":0},null,null,null,null,"Audit plans detailing how the local authority intends to conduct systematic audits of administrative decisions."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Audit reports on administrative decisions, publicly accessible through the local authority's official website or administrative office."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Decision templates allowing for integration of adequate motivation and compliance with legal requirement."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,null,null,"3.3.2","Capacity-building and training programmes for municipal staff involved in making administrative decisions,  including training on environmental regulations.",null,null,null,null,{"$f":"IF(F37=\"x\",1,0)","v":0},{"$f":"IF(G37=\"x\",2,0)","v":0},{"$f":"IF(H37=\"x\",3,0)","v":0},{"$f":"IF(I37=\"x\",4,0)","v":0},{"$f":"SUM(J37:M37)","v":0},{"$f":"(((N37-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q37)>0,O37,\"--\")","v":"--"},{"$f":"COUNTIF(F37:I37,\"x\")","v":0},null,null,null,null,"Training programme documentation."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Feedback surveys and forms from participants. "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Monitoring systems for capacity-building and training programmes. "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,null,"How much do you agree with the following statement?",null,"Our local authority upholds its commitment to the Rule of Law, providing a secure legal framework for stakeholders and residents alike. We ensure equal treatment, motivated decision-making, and the separation of powers to guarantee transparency and fairness in our local governance, fostering an environment conducive to growth and community well-being.",null,null,null,null,{"$f":"IF(F41=\"x\",1,0)","v":0},{"$f":"IF(G41=\"x\",2,0)","v":0},{"$f":"IF(H41=\"x\",3,0)","v":0},{"$f":"IF(I41=\"x\",4,0)","v":0},{"$f":"SUM(J41:M41)","v":0},{"$f":"(((N41-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q41)>0,O41,\"--\")","v":"--"},{"$f":"COUNTIF(F41:I41,\"x\")","v":0},{"$f":"T2*T3","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average",{"$f":"AVERAGE(P9,P16,P22,P27,P33,P37)","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(F9:I37,\"x\")","v":0}]

{"sheet":"P4","index":4,"n_rows":41,"n_cols":22,"rows_kept":41,"cut":false,"hidden":false,"merged":[[34,15,38,15],[29,2,29,15],[30,4,33,4],[30,5,33,5],[30,6,33,6],[30,7,33,7],[30,8,33,8],[30,15,33,15],[34,4,38,4],[34,5,38,5],[34,6,38,6],[34,7,38,7],[34,8,38,8],[18,15,23,15],[24,4,28,4],[24,5,28,5],[24,6,28,6],[24,7,28,7],[24,8,28,8],[24,15,28,15],[17,2,17,8],[18,4,23,4],[18,5,23,5],[18,6,23,6],[18,7,23,7],[18,8,23,8],[13,15,16,15],[4,21,6,21],[7,2,7,8],[8,4,12,4],[8,5,12,5],[8,6,12,6],[8,7,12,7],[8,8,12,8],[8,15,12,15],[4,19,6,19],[13,4,16,4],[13,5,16,5],[13,6,16,6],[13,7,16,7],[13,8,16,8],[1,1,3,3],[1,4,3,4],[4,2,6,3],[4,4,6,4],[4,15,6,15],[4,5,6,5],[4,6,6,6],[4,7,6,7],[4,8,6,8]]}
[]
[null,"Principle 4 - Public Ethics",null,null,"The highest standards of public ethics should be strictly observed, enabling everyone to have confidence that government, public institutions and public officials are serving the public good.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CELL(\"contents\",Q41)>0,P41,\"--\")","v":"--"},null,"Average Indicator score"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P40","v":"--"},null,"Statement score"]
[]
[null,null,"Target",null,"Indicator",{"$f":"'P1'!F5","v":"NOT AT ALL"},{"$f":"'P1'!G5","v":"PARTIALLY"},{"$f":"'P1'!H5","v":"SUFFICIENTLY"},{"$f":"'P1'!I5","v":"FULLY"},{"$f":"'P1'!J5","v":0},{"$f":"'P1'!K5","v":0},{"$f":"'P1'!L5","v":0},{"$f":"'P1'!M5","v":0},{"$f":"'P1'!N5","v":0},{"$f":"'P1'!O5","v":0},{"$f":"'P1'!P5","v":"Indicator score"},{"$f":"'P1'!Q5","v":0},{"$f":"'P1'!R5","v":0},{"$f":"'P1'!S5","v":0},{"$f":"'P1'!T5","v":"Target score"},null,"Not at all - We are aware of the key issues but not planning nor action is taken.\nPartially - We acknowledge the key issues and designing answers, but only limited actions is taken.\nSufficiently - We have well developed plans and activities to address key issues with significant examples of implementation.\t\nFully - We can show clear evidence of good practices which are monitored and integrated in our interventions."]
[null,null,null,null,null,null,null,null,null,{"$f":"'P1'!J6","v":0},{"$f":"'P1'!K6","v":0},{"$f":"'P1'!L6","v":0},{"$f":"'P1'!M6","v":0},{"$f":"'P1'!N6","v":0},{"$f":"'P1'!O6","v":0},null,{"$f":"'P1'!Q6","v":0},{"$f":"'P1'!R6","v":0},{"$f":"'P1'!S6","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"'P1'!J7","v":0},{"$f":"'P1'!K7","v":0},{"$f":"'P1'!L7","v":0},{"$f":"'P1'!M7","v":0},{"$f":"'P1'!N7","v":0},{"$f":"'P1'!O7","v":0},null,{"$f":"'P1'!Q7","v":0},{"$f":"'P1'!R7","v":0},{"$f":"'P1'!S7","v":0}]
[null,"4.1","A comprehensive public ethics framework is established, encompassing strategies, legislation, regulations, codes of conduct, and guidance. This framework prioritises the public good , including environmental aspects, over individual interests in policy and decision-making processes and ensures ethical practice throughout public institutions and among officials. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J9:M9,J14:M14)","v":0},{"$f":"(((R8-(2))*(1-0))/(8-(2)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",U8)>0,S8,\"\")","v":""},{"$f":"COUNTIF(F9:I14,\"x\")","v":0},"Suggested evidences"]
[null,null,null,"4.1.1","Code of Conduct for local authority officials, detailing ethical standards and practices. ",null,null,null,null,{"$f":"IF(F9=\"x\",1,0)","v":0},{"$f":"IF(G9=\"x\",2,0)","v":0},{"$f":"IF(H9=\"x\",3,0)","v":0},{"$f":"IF(I9=\"x\",4,0)","v":0},{"$f":"SUM(J9:M9)","v":0},{"$f":"(((N9-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q9)>0,O9,\"--\")","v":"--"},{"$f":"COUNTIF(F9:I9,\"x\")","v":0},null,null,null,null,"A published copy of the Code of Conduct available on the local authority's official website."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Compliance of the Code of Conduct with overall environmental protection and sustainability principles. "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Records of dissemination activities, such as workshops or seminars, introducing the Code of Conduct to officials."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Feedback forms or surveys from local authority officials acknowledging receipt and understanding of the Code of Conduct."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Evidence of consideration for environmental aspects (such as right to water) within the ethical frameworks."]
[null,null,null,"4.1.2","Regular training sessions and workshops for local authority officials on the principles and application of the public ethics framework. ",null,null,null,null,{"$f":"IF(F14=\"x\",1,0)","v":0},{"$f":"IF(G14=\"x\",2,0)","v":0},{"$f":"IF(H14=\"x\",3,0)","v":0},{"$f":"IF(I14=\"x\",4,0)","v":0},{"$f":"SUM(J14:M14)","v":0},{"$f":"(((N14-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q14)>0,O14,\"--\")","v":"--"},{"$f":"COUNTIF(F14:I14,\"x\")","v":0},null,null,null,null,"Training schedules and attendance records showcasing regularity and participation."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Training materials and modules tailored to the public ethics framework."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Post-training evaluations or assessments verifying the effectiveness and comprehension of the training content."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,"4.2","Clear procedures for addressing complaints and grievances related to breaches of ethical standards and strategies to identify, resolve, or manage conflicts of interest, even post-tenure. This includes putting into place robust measures to prevent and combat corruption, including its criminalisation, fostering public awareness, and promoting ethical behaviour.  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J19:M19,J25:M25)","v":0},{"$f":"(((R18-(2))*(1-0))/(8-(2)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",U18)>0,S18,\"\")","v":""},{"$f":"COUNTIF(F19:I25,\"x\")","v":0}]
[null,null,null,"4.2.1","Local authority ethics committee established to address reported breaches of ethical standards and manage conflicts of interest.",null,null,null,null,{"$f":"IF(F19=\"x\",1,0)","v":0},{"$f":"IF(G19=\"x\",2,0)","v":0},{"$f":"IF(H19=\"x\",3,0)","v":0},{"$f":"IF(I19=\"x\",4,0)","v":0},{"$f":"SUM(J19:M19)","v":0},{"$f":"(((N19-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q19)>0,O19,\"--\")","v":"--"},{"$f":"COUNTIF(F19:I19,\"x\")","v":0},null,null,null,null,"Official documentation or charter establishing the ethics committee."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Meeting minutes or records from the ethics committee sessions."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Possibility of reporting on environmental damages at local level given through established reporting mechanisms."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Case logs or reports detailing the breaches reviewed and actions taken by the committee."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Possibility of reporting on environmental damages in established reporting mechanisms. "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,null,null,"4.2.2","Public awareness campaigns on ethical standards, anti-corruption measures and reporting mechanisms.",null,null,null,null,{"$f":"IF(F25=\"x\",1,0)","v":0},{"$f":"IF(G25=\"x\",2,0)","v":0},{"$f":"IF(H25=\"x\",3,0)","v":0},{"$f":"IF(I25=\"x\",4,0)","v":0},{"$f":"SUM(J25:M25)","v":0},{"$f":"(((N25-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q25)>0,O25,\"--\")","v":"--"},{"$f":"COUNTIF(F25:I25,\"x\")","v":0},null,null,null,null,"Campaign materials such as brochures, posters, or digital content tailored to ethical standards and anti-corruption."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Records of public engagement events or workshops promoting ethical behaviour."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Analytics or metrics showcasing the reach and impact of the awareness campaigns, such as website visits or feedback forms."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Public awareness campaigns on ethical standards, anti-corruption measures, and reporting mechanisms, including environmental ethics."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,"4.3","Clear procedures are in place for handling complaints and grievances from the people and from public officials and protective measures are in place to safeguard whistle-blowers, ensuring they face no direct or indirect retaliation from their current or former public organisation or its officials.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J31:M31,J35:M35)","v":0},{"$f":"(((R30-(2))*(1-0))/(8-(2)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",U30)>0,S30,\"\")","v":""},{"$f":"COUNTIF(F31:I35,\"x\")","v":0}]
[null,null,null,"4.3.1","Complaints procedure for people and public officials to report suspected breaches of ethical standards and conflicts of interest, including those reporting environmental violations.",null,null,null,null,{"$f":"IF(F31=\"x\",1,0)","v":0},{"$f":"IF(G31=\"x\",2,0)","v":0},{"$f":"IF(H31=\"x\",3,0)","v":0},{"$f":"IF(I31=\"x\",4,0)","v":0},{"$f":"SUM(J31:M31)","v":0},{"$f":"(((N31-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q31)>0,O31,\"--\")","v":"--"},{"$f":"COUNTIF(F31:I31,\"x\")","v":0},null,null,null,null,"A published copy of the whistle-blower protection policy available on the local authority's official website"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Records of training or information sessions introducing the policy to local authority employees."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Case logs or reports detailing instances where the policy was invoked and the Targets."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,null,null,"4.3.2","Whistle-blower protection policy offering a confidential reporting platform or hotline within the local authority for whistle-blowers, ensuring anonymity and security.",null,null,null,null,{"$f":"IF(F35=\"x\",1,0)","v":0},{"$f":"IF(G35=\"x\",2,0)","v":0},{"$f":"IF(H35=\"x\",3,0)","v":0},{"$f":"IF(I35=\"x\",4,0)","v":0},{"$f":"SUM(J35:M35)","v":0},{"$f":"(((N35-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q35)>0,O35,\"--\")","v":"--"},{"$f":"COUNTIF(F35:I35,\"x\")","v":0},null,null,null,null,"Documentation or user guides related to the confidential reporting platform or hotline."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Usage statistics or logs showcasing the activity on the platform or hotline."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Testimonials or feedback from users attesting to the platform's or hotline's confidentiality and effectiveness."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Evidence of whistle-blower protection in environmental reporting."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,null,"How much do you agree with the following statement?",null,"Our local authority upholds the principles of Public Ethics, integral to our governance framework. We maintain the highest standards of public ethics to ensure that our institution and its officials consistently serve the public good. Our determined commitment to transparency, accountability, and integrity underpins the confidence of our community in our dedication to their interests, reinforcing public trust and enhancing the effectiveness of our local authority in serving our constituents' needs.",null,null,null,null,{"$f":"IF(F40=\"x\",1,0)","v":0},{"$f":"IF(G40=\"x\",2,0)","v":0},{"$f":"IF(H40=\"x\",3,0)","v":0},{"$f":"IF(I40=\"x\",4,0)","v":0},{"$f":"SUM(J40:M40)","v":0},{"$f":"(((N40-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q40)>0,O40,\"--\")","v":"--"},{"$f":"COUNTIF(F40:I40,\"x\")","v":0},{"$f":"T2*T3","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average",{"$f":"AVERAGE(P9,P14,P19,P25,P31,P35)","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(F9:I35,\"x\")","v":0}]

{"sheet":"P5","index":5,"n_rows":44,"n_cols":22,"rows_kept":44,"cut":false,"hidden":false,"merged":[[37,15,41,15],[31,2,31,15],[32,4,36,4],[32,5,36,5],[32,6,36,6],[32,7,36,7],[32,8,36,8],[32,15,36,15],[37,4,41,4],[37,5,41,5],[37,6,41,6],[37,7,41,7],[37,8,41,8],[21,15,25,15],[26,4,30,4],[26,5,30,5],[26,6,30,6],[26,7,30,7],[26,8,30,8],[26,15,30,15],[20,2,20,8],[21,4,25,4],[21,5,25,5],[21,6,25,6],[21,7,25,7],[21,8,25,8],[14,15,19,15],[4,21,6,21],[7,2,7,8],[8,4,13,4],[8,5,13,5],[8,6,13,6],[8,7,13,7],[8,8,13,8],[8,15,13,15],[4,19,6,19],[14,4,19,4],[14,5,19,5],[14,6,19,6],[14,7,19,7],[14,8,19,8],[1,1,3,3],[1,4,3,4],[4,2,6,3],[4,4,6,4],[4,15,6,15],[4,5,6,5],[4,6,6,6],[4,7,6,7],[4,8,6,8]]}
[]
[null,"Principle 5 –  Accountability",null,null,"Accountability mechanisms should be in place to ensure that government, public institutions and public officials take responsibility for their actions and decisions and can be held to account, and that they accept any consequences or proportionate sanctions for inappropriate decisions or omissions.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CELL(\"contents\",Q44)>0,P44,\"--\")","v":"--"},null,"Average Indicator score"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P43","v":"--"},null,"Statement score"]
[]
[null,null,"Target",null,"Indicator",{"$f":"'P1'!F5","v":"NOT AT ALL"},{"$f":"'P1'!G5","v":"PARTIALLY"},{"$f":"'P1'!H5","v":"SUFFICIENTLY"},{"$f":"'P1'!I5","v":"FULLY"},{"$f":"'P1'!J5","v":0},{"$f":"'P1'!K5","v":0},{"$f":"'P1'!L5","v":0},{"$f":"'P1'!M5","v":0},{"$f":"'P1'!N5","v":0},{"$f":"'P1'!O5","v":0},{"$f":"'P1'!P5","v":"Indicator score"},{"$f":"'P1'!Q5","v":0},{"$f":"'P1'!R5","v":0},{"$f":"'P1'!S5","v":0},{"$f":"'P1'!T5","v":"Target score"},null,"Not at all - We are aware of the key issues but not planning nor action is taken.\nPartially - We acknowledge the key issues and designing answers, but only limited actions is taken.\nSufficiently - We have well developed plans and activities to address key issues with significant examples of implementation.\t\nFully - We can show clear evidence of good practices which are monitored and integrated in our interventions."]
[null,null,null,null,null,null,null,null,null,{"$f":"'P1'!J6","v":0},{"$f":"'P1'!K6","v":0},{"$f":"'P1'!L6","v":0},{"$f":"'P1'!M6","v":0},{"$f":"'P1'!N6","v":0},{"$f":"'P1'!O6","v":0},null,{"$f":"'P1'!Q6","v":0},{"$f":"'P1'!R6","v":0},{"$f":"'P1'!S6","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"'P1'!J7","v":0},{"$f":"'P1'!K7","v":0},{"$f":"'P1'!L7","v":0},{"$f":"'P1'!M7","v":0},{"$f":"'P1'!N7","v":0},{"$f":"'P1'!O7","v":0},null,{"$f":"'P1'!Q7","v":0},{"$f":"'P1'!R7","v":0},{"$f":"'P1'!S7","v":0}]
[null,"5.1","Accountability framework clearly identifies, and documents matters for which the local authority and their public officials are accountable and the extent to which they are legally and financially responsible. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J9:M9,J15:M15)","v":0},{"$f":"(((R8-(2))*(1-0))/(8-(2)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",U8)>0,S8,\"\")","v":""},{"$f":"COUNTIF(F9:I15,\"x\")","v":0},"Suggested evidences"]
[null,null,null,"5.1.1","Accountability framework for local officials outlines appropriate legislation, institutions, procedures, practices, and norms of conduct.",null,null,null,null,{"$f":"IF(F9=\"x\",1,0)","v":0},{"$f":"IF(G9=\"x\",2,0)","v":0},{"$f":"IF(H9=\"x\",3,0)","v":0},{"$f":"IF(I9=\"x\",4,0)","v":0},{"$f":"SUM(J9:M9)","v":0},{"$f":"(((N9-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q9)>0,O9,\"--\")","v":"--"},{"$f":"COUNTIF(F9:I9,\"x\")","v":0},null,null,null,null,"The local accountability document is published on the official website, ensuring it's easily accessible to the public (e.g., Performance reports, Staff objective report, etc.)."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Records of accountability workshops held for council staff, demonstrating efforts to implement the document's principles."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Public Feedback Log."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Documentation concerning civil servants' bonuses published on the official website. "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Evidence of accountability in environmental decision-making and policy implementation."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,null,null,"5.1.2","Comprehensive system of record-keeping, retention, classification and archiving of official documents.",null,null,null,null,{"$f":"IF(F15=\"x\",1,0)","v":0},{"$f":"IF(G15=\"x\",2,0)","v":0},{"$f":"IF(H15=\"x\",3,0)","v":0},{"$f":"IF(I15=\"x\",4,0)","v":0},{"$f":"SUM(J15:M15)","v":0},{"$f":"(((N15-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q15)>0,O15,\"--\")","v":"--"},{"$f":"COUNTIF(F15:I15,\"x\")","v":0},null,null,null,null,"Revised Legislation Document published on the official website."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Documentation of Legislation Review Process."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Public Accessibility Assessment of the ease with which residents can access and understand the revised legislation."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Existence of a Code of Conduct and Transparency"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Evidence of environmental record-keeping practices."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,"5.2","Decisions are reported on, explained, examined and, where appropriate, questioned, or sanctioned.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J22:M22,J27:M27)","v":0},{"$f":"(((R21-(2))*(1-0))/(8-(2)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",U21)>0,S21,\"\")","v":""},{"$f":"COUNTIF(F22:I27,\"x\")","v":0}]
[null,null,null,"5.2.1","Rules and regulations set out the categories, content, and frequency of accounts to be provided by representatives and bodies, to ensure that up-to-date and meaningful information, including accounts of activity, remains constantly available.",null,null,null,null,{"$f":"IF(F22=\"x\",1,0)","v":0},{"$f":"IF(G22=\"x\",2,0)","v":0},{"$f":"IF(H22=\"x\",3,0)","v":0},{"$f":"IF(I22=\"x\",4,0)","v":0},{"$f":"SUM(J22:M22)","v":0},{"$f":"(((N22-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q22)>0,O22,\"--\")","v":"--"},{"$f":"COUNTIF(F22:I22,\"x\")","v":0},null,null,null,null,"An online platform where residents can access detailed information about council decisions, including documentation and explanations."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Accessible archive minutes of stakeholder meetings discussing decisions."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Public Queries Register of citizens questions about"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Records of environmental decisions and reviews."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,null,null,"5.2.2","Regular reviews involving external stakeholders, including environmental actors, are organised to ensure decision examination and sanction mechanisms.",null,null,null,null,{"$f":"IF(F27=\"x\",1,0)","v":0},{"$f":"IF(G27=\"x\",2,0)","v":0},{"$f":"IF(H27=\"x\",3,0)","v":0},{"$f":"IF(I27=\"x\",4,0)","v":0},{"$f":"SUM(J27:M27)","v":0},{"$f":"(((N27-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q27)>0,O27,\"--\")","v":"--"},{"$f":"COUNTIF(F27:I27,\"x\")","v":0},null,null,null,null,"Stakeholder Meeting Minutes."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Records of Sanction Actions."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"External Stakeholder Feedback"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Records of environmental decisions and reviews."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,"5.3","There are effective and proportionate remedies for inappropriate decisions or omissions and any resulting actions or inactions.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J33:M33,J38:M38)","v":0},{"$f":"(((R32-(2))*(1-0))/(8-(2)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",U32)>0,S32,\"\")","v":""},{"$f":"COUNTIF(F33:I38,\"x\")","v":0}]
[null,null,null,"5.3.1","Mechanisms to address improper decisions and train designated authorities for efficient remedies.",null,null,null,null,{"$f":"IF(F33=\"x\",1,0)","v":0},{"$f":"IF(G33=\"x\",2,0)","v":0},{"$f":"IF(H33=\"x\",3,0)","v":0},{"$f":"IF(I33=\"x\",4,0)","v":0},{"$f":"SUM(J33:M33)","v":0},{"$f":"(((N33-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q33)>0,O33,\"--\")","v":"--"},{"$f":"COUNTIF(F33:I33,\"x\")","v":0},null,null,null,null,"Remediation Case Studies showcasing the effectiveness of remediation protocols."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Training Records."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Remediation Target Stats."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Evidence of remedies and training related to environmental issues"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,null,null,"5.3.2","Information leaflets and campaigns explain available remedies and how residents can access them.",null,null,null,null,{"$f":"IF(F38=\"x\",1,0)","v":0},{"$f":"IF(G38=\"x\",2,0)","v":0},{"$f":"IF(H38=\"x\",3,0)","v":0},{"$f":"IF(I38=\"x\",4,0)","v":0},{"$f":"SUM(J38:M38)","v":0},{"$f":"(((N38-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q38)>0,O38,\"--\")","v":"--"},{"$f":"COUNTIF(F38:I38,\"x\")","v":0},null,null,null,null,"Campaign Materials explaining the available remedies and how residents can access them."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Public Engagement Monitoring Stats."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Resident Queries and Response Records."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Evidence of remedies and training related to environmental issues."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,null,"How much do you agree with the following statement?",null,"Our local authority places a strong emphasis on Accountability within our governance structure. We have established robust accountability arrangements that demand government, public institutions, and our officials take responsibility for their actions and decisions. We ensure that they are held accountable and accept consequences or proportionate sanctions for inappropriate decisions or omissions. This commitment to accountability underscores our dedication to transparency, fairness, and effective governance, reinforcing our accountability to the community we serve.",null,null,null,null,{"$f":"IF(F43=\"x\",1,0)","v":0},{"$f":"IF(G43=\"x\",2,0)","v":0},{"$f":"IF(H43=\"x\",3,0)","v":0},{"$f":"IF(I43=\"x\",4,0)","v":0},{"$f":"SUM(J43:M43)","v":0},{"$f":"(((N43-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q43)>0,O43,\"--\")","v":"--"},{"$f":"COUNTIF(F43:I43,\"x\")","v":0},{"$f":"T2*T3","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average",{"$f":"AVERAGE(P9,P15,P22,P27,P33,P38)","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(F9:I38,\"x\")","v":0}]

{"sheet":"P6","index":6,"n_rows":42,"n_cols":22,"rows_kept":42,"cut":false,"hidden":false,"merged":[[36,15,39,15],[30,2,30,15],[31,4,35,4],[31,5,35,5],[31,6,35,6],[31,7,35,7],[31,8,35,8],[31,15,35,15],[36,4,39,4],[36,5,39,5],[36,6,39,6],[36,7,39,7],[36,8,39,8],[19,15,24,15],[25,4,29,4],[25,5,29,5],[25,6,29,6],[25,7,29,7],[25,8,29,8],[25,15,29,15],[18,2,18,8],[19,4,24,4],[19,5,24,5],[19,6,24,6],[19,7,24,7],[19,8,24,8],[14,15,17,15],[4,21,6,21],[7,2,7,8],[8,4,13,4],[8,5,13,5],[8,6,13,6],[8,7,13,7],[8,8,13,8],[8,15,13,15],[4,19,6,19],[14,4,17,4],[14,5,17,5],[14,6,17,6],[14,7,17,7],[14,8,17,8],[1,1,3,3],[1,4,3,4],[4,2,6,3],[4,4,6,4],[4,15,6,15],[4,5,6,5],[4,6,6,6],[4,7,6,7],[4,8,6,8]]}
[]
[null,"Principle 6 - Openess and Transparency",null,null,"Openness and transparency should be ensured, by making the decision-making processes of government, public institutions and public officials publicly available and accessible – subject to the limitations set down in law, necessary in a democratic society and proportionate to the aims such limitations seek to protect – including by utilising, as appropriate, modern digital tools.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CELL(\"contents\",Q42)>0,P42,\"--\")","v":"--"},null,"Average Indicator score"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P41","v":"--"},null,"Statement score"]
[]
[null,null,"Target",null,"Indicator",{"$f":"'P1'!F5","v":"NOT AT ALL"},{"$f":"'P1'!G5","v":"PARTIALLY"},{"$f":"'P1'!H5","v":"SUFFICIENTLY"},{"$f":"'P1'!I5","v":"FULLY"},{"$f":"'P1'!J5","v":0},{"$f":"'P1'!K5","v":0},{"$f":"'P1'!L5","v":0},{"$f":"'P1'!M5","v":0},{"$f":"'P1'!N5","v":0},{"$f":"'P1'!O5","v":0},{"$f":"'P1'!P5","v":"Indicator score"},{"$f":"'P1'!Q5","v":0},{"$f":"'P1'!R5","v":0},{"$f":"'P1'!S5","v":0},{"$f":"'P1'!T5","v":"Target score"},null,"Not at all - We are aware of the key issues but not planning nor action is taken.\nPartially - We acknowledge the key issues and designing answers, but only limited actions is taken.\nSufficiently - We have well developed plans and activities to address key issues with significant examples of implementation.\t\nFully - We can show clear evidence of good practices which are monitored and integrated in our interventions."]
[null,null,null,null,null,null,null,null,null,{"$f":"'P1'!J6","v":0},{"$f":"'P1'!K6","v":0},{"$f":"'P1'!L6","v":0},{"$f":"'P1'!M6","v":0},{"$f":"'P1'!N6","v":0},{"$f":"'P1'!O6","v":0},null,{"$f":"'P1'!Q6","v":0},{"$f":"'P1'!R6","v":0},{"$f":"'P1'!S6","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"'P1'!J7","v":0},{"$f":"'P1'!K7","v":0},{"$f":"'P1'!L7","v":0},{"$f":"'P1'!M7","v":0},{"$f":"'P1'!N7","v":0},{"$f":"'P1'!O7","v":0},null,{"$f":"'P1'!Q7","v":0},{"$f":"'P1'!R7","v":0},{"$f":"'P1'!S7","v":0}]
[null,"6.1","Information is conveyed clearly and inclusively, ensuring accuracy and security, and tailored to user needs.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J9:M9,J15:M15)","v":0},{"$f":"(((R8-(2))*(1-0))/(8-(2)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",U8)>0,S8,\"\")","v":""},{"$f":"COUNTIF(F9:I15,\"x\")","v":0},"Suggested evidences"]
[null,null,null,"6.1.1","Inclusive and accessible Information Portal ensures residents can easily access vital local information and services, including training on environmental policies and sustainable practices.\n \t\n \t.",null,null,null,null,{"$f":"IF(F9=\"x\",1,0)","v":0},{"$f":"IF(G9=\"x\",2,0)","v":0},{"$f":"IF(H9=\"x\",3,0)","v":0},{"$f":"IF(I9=\"x\",4,0)","v":0},{"$f":"SUM(J9:M9)","v":0},{"$f":"(((N9-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q9)>0,O9,\"--\")","v":"--"},{"$f":"COUNTIF(F9:I9,\"x\")","v":0},null,null,null,null,"Website stats monitoring. "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"User feedback on navigation ease, information accessibility, etc.."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Record of registered users."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Documentation of training programmes focused on environmental policies and sustainability"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Records of performance evaluations including assessments of environmental competence."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,null,null,"6.1.2","Periodic review system for municipal information, ensures accurate, up-to-date, and secure information.",null,null,null,null,{"$f":"IF(F15=\"x\",1,0)","v":0},{"$f":"IF(G15=\"x\",2,0)","v":0},{"$f":"IF(H15=\"x\",3,0)","v":0},{"$f":"IF(I15=\"x\",4,0)","v":0},{"$f":"SUM(J15:M15)","v":0},{"$f":"(((N15-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q15)>0,O15,\"--\")","v":"--"},{"$f":"COUNTIF(F15:I15,\"x\")","v":0},null,null,null,null,"Logs of information updates, including dates and responsible personnel."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Internal or external audit findings and corrective actions to demonstrate transparency and accuracy."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reports on data security measures demonstrate commitment to data protection."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,"6.2","Public access to decisions, policy implementation, and Targets enables people to follow and contribute effectively to the work of the local authority, either directly or through representative bodies",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J20:M20,J26:M26)","v":0},{"$f":"(((R19-(2))*(1-0))/(8-(2)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",U19)>0,S19,\"\")","v":""},{"$f":"COUNTIF(F20:I26,\"x\")","v":0}]
[null,null,null,"6.2.1","Dedicated section on the municipal website, provides easy citizen access to council meeting records, decisions, and policies. It includes plain-language summaries for better comprehension.",null,null,null,null,{"$f":"IF(F20=\"x\",1,0)","v":0},{"$f":"IF(G20=\"x\",2,0)","v":0},{"$f":"IF(H20=\"x\",3,0)","v":0},{"$f":"IF(I20=\"x\",4,0)","v":0},{"$f":"SUM(J20:M20)","v":0},{"$f":"(((N20-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q20)>0,O20,\"--\")","v":"--"},{"$f":"COUNTIF(F20:I20,\"x\")","v":0},null,null,null,null,"Section Analytics"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Plain Language Summaries."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Accessibility Compliance Records, Accessibility audit records."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Presence of audio-visual documentation of deliberative body meetings"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Budget reports showing allocations for environmental management and sustainability."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,null,null,"6.2.2","Regular opportunities are provided to present progress reports on key initiatives and to allow citizens to interact directly with local officials.",null,null,null,null,{"$f":"IF(F26=\"x\",1,0)","v":0},{"$f":"IF(G26=\"x\",2,0)","v":0},{"$f":"IF(H26=\"x\",3,0)","v":0},{"$f":"IF(I26=\"x\",4,0)","v":0},{"$f":"SUM(J26:M26)","v":0},{"$f":"(((N26-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q26)>0,O26,\"--\")","v":"--"},{"$f":"COUNTIF(F26:I26,\"x\")","v":0},null,null,null,null,"Attendance Records including participant feedback."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Meeting Minutes published capturing citizen input and actions taken."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pre- and post-event surveys to gauge citizen expectations and satisfaction."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Records of partnerships with environmental organisations and sustainability initiatives."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,"6.3","E-governance services, via ICT channels, prioritise ease of use, quality, and data security while addressing e-literacy and privacy concerns where possible and cost-effective.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J32:M32,J37:M37)","v":0},{"$f":"(((R31-(2))*(1-0))/(8-(2)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",U31)>0,S31,\"\")","v":""},{"$f":"COUNTIF(F32:I37,\"x\")","v":0}]
[null,null,null,"6.3.1","Digital solutions simplify access to essential municipal services. Guidance and features designed to improve accessibility and address inadequate digital literacy levels, including green technologies and sustainable practices.",null,null,null,null,{"$f":"IF(F32=\"x\",1,0)","v":0},{"$f":"IF(G32=\"x\",2,0)","v":0},{"$f":"IF(H32=\"x\",3,0)","v":0},{"$f":"IF(I32=\"x\",4,0)","v":0},{"$f":"SUM(J32:M32)","v":0},{"$f":"(((N32-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q32)>0,O32,\"--\")","v":"--"},{"$f":"COUNTIF(F32:I32,\"x\")","v":0},null,null,null,null,"Adoption Rates on the number of residents using digital solutions to access services."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"User Feedback on usability."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Helpdesk Inquiries."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Documentation of initiatives promoting green technologies and innovation in sustainability."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,null,null,"6.3.2","Strong data protection policy and regular cybersecurity audits safeguard citizens' personal information when using online services. ",null,null,null,null,{"$f":"IF(F37=\"x\",1,0)","v":0},{"$f":"IF(G37=\"x\",2,0)","v":0},{"$f":"IF(H37=\"x\",3,0)","v":0},{"$f":"IF(I37=\"x\",4,0)","v":0},{"$f":"SUM(J37:M37)","v":0},{"$f":"(((N37-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q37)>0,O37,\"--\")","v":"--"},{"$f":"COUNTIF(F37:I37,\"x\")","v":0},null,null,null,null,"Incident Reports and records."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Training Participation records on data treatment and protection."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cybersecurity Audits."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,null,"How much do you agree with the following statement?",null,"Our local authority firmly upholds the principle of Openness and Transparency within our governance framework. We are committed to ensuring that our decision-making processes are openly and transparently conducted. We make this information publicly available and accessible, in accordance with legal provisions, safeguarding democratic values. Embracing modern digital tools where appropriate, we strive to enhance accessibility and inclusivity, facilitating active citizen engagement and reinforcing our dedication to democratic accountability and open governance.",null,null,null,null,{"$f":"IF(F41=\"x\",1,0)","v":0},{"$f":"IF(G41=\"x\",2,0)","v":0},{"$f":"IF(H41=\"x\",3,0)","v":0},{"$f":"IF(I41=\"x\",4,0)","v":0},{"$f":"SUM(J41:M41)","v":0},{"$f":"(((N41-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q41)>0,O41,\"--\")","v":"--"},{"$f":"COUNTIF(F41:I41,\"x\")","v":0},{"$f":"T2*T3","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average",{"$f":"AVERAGE(P9,P15,P20,P26,P32,P37)","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(F9:I37,\"x\")","v":0}]

{"sheet":"P7","index":7,"n_rows":40,"n_cols":22,"rows_kept":40,"cut":false,"hidden":false,"merged":[[34,15,37,15],[28,2,28,15],[29,4,33,4],[29,5,33,5],[29,6,33,6],[29,7,33,7],[29,8,33,8],[29,15,33,15],[34,4,37,4],[34,5,37,5],[34,6,37,6],[34,7,37,7],[34,8,37,8],[19,15,22,15],[23,4,27,4],[23,5,27,5],[23,6,27,6],[23,7,27,7],[23,8,27,8],[23,15,27,15],[18,2,18,8],[19,4,22,4],[19,5,22,5],[19,6,22,6],[19,7,22,7],[19,8,22,8],[13,15,17,15],[4,21,6,21],[7,2,7,8],[8,4,12,4],[8,5,12,5],[8,6,12,6],[8,7,12,7],[8,8,12,8],[8,15,12,15],[4,19,6,19],[13,4,17,4],[13,5,17,5],[13,6,17,6],[13,7,17,7],[13,8,17,8],[1,1,3,3],[1,4,3,4],[4,2,6,3],[4,4,6,4],[4,15,6,15],[4,5,6,5],[4,6,6,6],[4,7,6,7],[4,8,6,8]]}
[]
[null,"Principio 7 - Efficient, effective and sound administration",null,null,"There should be efficient, effective and sound administration throughout government and public institutions, involving all public officials, in order to promote the well-being of all those they serve, without discrimination, including through optimising the use of public resources.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CELL(\"contents\",Q40)>0,P40,\"--\")","v":"--"},null,"Average Indicator score"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P39","v":"--"},null,"Statement score"]
[]
[null,null,"Target",null,"Indicator",{"$f":"'P1'!F5","v":"NOT AT ALL"},{"$f":"'P1'!G5","v":"PARTIALLY"},{"$f":"'P1'!H5","v":"SUFFICIENTLY"},{"$f":"'P1'!I5","v":"FULLY"},{"$f":"'P1'!J5","v":0},{"$f":"'P1'!K5","v":0},{"$f":"'P1'!L5","v":0},{"$f":"'P1'!M5","v":0},{"$f":"'P1'!N5","v":0},{"$f":"'P1'!O5","v":0},{"$f":"'P1'!P5","v":"Indicator score"},{"$f":"'P1'!Q5","v":0},{"$f":"'P1'!R5","v":0},{"$f":"'P1'!S5","v":0},{"$f":"'P1'!T5","v":"Target score"},null,"Not at all - We are aware of the key issues but not planning nor action is taken.\nPartially - We acknowledge the key issues and designing answers, but only limited actions is taken.\nSufficiently - We have well developed plans and activities to address key issues with significant examples of implementation.\t\nFully - We can show clear evidence of good practices which are monitored and integrated in our interventions."]
[null,null,null,null,null,null,null,null,null,{"$f":"'P1'!J6","v":0},{"$f":"'P1'!K6","v":0},{"$f":"'P1'!L6","v":0},{"$f":"'P1'!M6","v":0},{"$f":"'P1'!N6","v":0},{"$f":"'P1'!O6","v":0},null,{"$f":"'P1'!Q6","v":0},{"$f":"'P1'!R6","v":0},{"$f":"'P1'!S6","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"'P1'!J7","v":0},{"$f":"'P1'!K7","v":0},{"$f":"'P1'!L7","v":0},{"$f":"'P1'!M7","v":0},{"$f":"'P1'!N7","v":0},{"$f":"'P1'!O7","v":0},null,{"$f":"'P1'!Q7","v":0},{"$f":"'P1'!R7","v":0},{"$f":"'P1'!S7","v":0}]
[null,"7.1","Strategic and operational plans shall clearly define objectives and targets within a defined timeframe, optimising the utilisation of available resources in both technical and allocative terms, while promoting efficient coordination across governmental levels in accordance with the principles of local democracy and subsidiarity, including environmental sustainability goals, thereby guaranteeing the delivery of high-quality services at all levels.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J9:M9,J14:M14)","v":0},{"$f":"(((R8-(2))*(1-0))/(8-(2)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",U8)>0,S8,\"\")","v":""},{"$f":"COUNTIF(F9:I14,\"x\")","v":0},"Suggested evidences"]
[null,null,null,"7.1.1","The local authority publishes an annual report highlighting the progress made in achieving the objectives and targets defined in the strategic and operational plans within the planned timeframe. The report includes a detailed indication of the distribution and use of resources, demonstrating efficiency.",null,null,null,null,{"$f":"IF(F9=\"x\",1,0)","v":0},{"$f":"IF(G9=\"x\",2,0)","v":0},{"$f":"IF(H9=\"x\",3,0)","v":0},{"$f":"IF(I9=\"x\",4,0)","v":0},{"$f":"SUM(J9:M9)","v":0},{"$f":"(((N9-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q9)>0,O9,\"--\")","v":"--"},{"$f":"COUNTIF(F9:I9,\"x\")","v":0},null,null,null,null,"Completed projects and objectives records."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Budgets showing resource use, including the transparent allocation of funds for environmental initiatives."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"User and stakeholder feedback."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Existence of balance sheets (i.e., final, gender ...) complementary to the profit and loss account."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,null,null,"7.1.2","The local authority periodically reviews the effectiveness of the services provided through the review of records and through meetings with staff and stakeholders.",null,null,null,null,{"$f":"IF(F14=\"x\",1,0)","v":0},{"$f":"IF(G14=\"x\",2,0)","v":0},{"$f":"IF(H14=\"x\",3,0)","v":0},{"$f":"IF(I14=\"x\",4,0)","v":0},{"$f":"SUM(J14:M14)","v":0},{"$f":"(((N14-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q14)>0,O14,\"--\")","v":"--"},{"$f":"COUNTIF(F14:I14,\"x\")","v":0},null,null,null,null,"Meeting minutes and action plans."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Feedback surveys from attendees."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reports on service improvements."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Published financial reports detailing environmental expenditures."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,"7.2","Performance management systems are established and executed in alignment with predetermined objectives and targets, while regular internal and external audits are conducted at all administrative levels.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J20:M20,J24:M24)","v":0},{"$f":"(((R19-(2))*(1-0))/(8-(2)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",U19)>0,S19,\"\")","v":""},{"$f":"COUNTIF(F20:I24,\"x\")","v":0}]
[null,null,null,"7.2.1","Periodic performance reports published using KPIs to measure performance management systems with predetermined objectives and targets, including resource efficiency.",null,null,null,null,{"$f":"IF(F20=\"x\",1,0)","v":0},{"$f":"IF(G20=\"x\",2,0)","v":0},{"$f":"IF(H20=\"x\",3,0)","v":0},{"$f":"IF(I20=\"x\",4,0)","v":0},{"$f":"SUM(J20:M20)","v":0},{"$f":"(((N20-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q20)>0,O20,\"--\")","v":"--"},{"$f":"COUNTIF(F20:I20,\"x\")","v":0},null,null,null,null,"Reports with key indicators chosen for the evaluation."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Actions taken based on reports."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Staff training records."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,null,null,"7.2.2","Regular internal and external audits carried out and audit findings and recommendations made publicly available.",null,null,null,null,{"$f":"IF(F24=\"x\",1,0)","v":0},{"$f":"IF(G24=\"x\",2,0)","v":0},{"$f":"IF(H24=\"x\",3,0)","v":0},{"$f":"IF(I24=\"x\",4,0)","v":0},{"$f":"SUM(J24:M24)","v":0},{"$f":"(((N24-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q24)>0,O24,\"--\")","v":"--"},{"$f":"COUNTIF(F24:I24,\"x\")","v":0},null,null,null,null,"Audit reports with recommendations."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Audit reports assessing resource use and achievement of environmental objectives."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Actions in response to audits."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Publicly available audit summaries."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,"7.3","Ensure good administration through quality legislation, compliant processes, and accessible offices that specify enforceable rights.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J30:M30,J35:M35)","v":0},{"$f":"(((R29-(2))*(1-0))/(8-(2)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",U29)>0,S29,\"\")","v":""},{"$f":"COUNTIF(F30:I35,\"x\")","v":0}]
[null,null,null,"7.3.1","Periodic report summarising legislative updates and improvements made to administrative processes that enhance clarity, accessibility, and fairness published.",null,null,null,null,{"$f":"IF(F30=\"x\",1,0)","v":0},{"$f":"IF(G30=\"x\",2,0)","v":0},{"$f":"IF(H30=\"x\",3,0)","v":0},{"$f":"IF(I30=\"x\",4,0)","v":0},{"$f":"SUM(J30:M30)","v":0},{"$f":"(((N30-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q30)>0,O30,\"--\")","v":"--"},{"$f":"COUNTIF(F30:I30,\"x\")","v":0},null,null,null,null,"Reports on legislative changes and their impact on administrative improvements."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reports of measures taken to promote energy efficiency in public buildings."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Documentation of staff training programmes."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"User and stakeholder feedback."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,null,null,"7.3.2","Citizen feedback mechanisms enable the local authority to gather input and monitor the practical implementation of enforceable rights.",null,null,null,null,{"$f":"IF(F35=\"x\",1,0)","v":0},{"$f":"IF(G35=\"x\",2,0)","v":0},{"$f":"IF(H35=\"x\",3,0)","v":0},{"$f":"IF(I35=\"x\",4,0)","v":0},{"$f":"SUM(J35:M35)","v":0},{"$f":"(((N35-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q35)>0,O35,\"--\")","v":"--"},{"$f":"COUNTIF(F35:I35,\"x\")","v":0},null,null,null,null,"Detailed records of citizen feedback, including volume and trends."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reports on actions taken in response to citizen input in policy changes or service improvements."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Evidence of successful public awareness campaigns. promoting the feedback mechanism."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,null,"How much do you agree with the following statement?",null,"Our local authority places paramount importance on the principle of Efficient, Effective, and Sound Administration in our governance practices. We are dedicated to fostering an administration that is not only efficient and effective but also serves the well-being of all our constituents without discrimination. This commitment extends to the optimal utilisation of public resources, ensuring they are managed responsibly and in a manner that maximises their benefit for the community. By upholding these principles, we aim to provide administrative and decision-making processes that are responsive, accountable, and dedicated to enhancing the quality of life for all our residents.",null,null,null,null,{"$f":"IF(F39=\"x\",1,0)","v":0},{"$f":"IF(G39=\"x\",2,0)","v":0},{"$f":"IF(H39=\"x\",3,0)","v":0},{"$f":"IF(I39=\"x\",4,0)","v":0},{"$f":"SUM(J39:M39)","v":0},{"$f":"(((N39-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q39)>0,O39,\"--\")","v":"--"},{"$f":"COUNTIF(F39:I39,\"x\")","v":0},{"$f":"T2*T3","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average",{"$f":"AVERAGE(P9,P14,P20,P24,P30,P35)","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(F9:I35,\"x\")","v":0}]

{"sheet":"P8","index":8,"n_rows":38,"n_cols":22,"rows_kept":38,"cut":false,"hidden":false,"merged":[[32,15,35,15],[28,4,31,4],[28,5,31,5],[28,6,31,6],[28,7,31,7],[28,8,31,8],[28,15,31,15],[32,4,35,4],[32,5,35,5],[32,6,35,6],[32,7,35,7],[32,8,35,8],[19,15,22,15],[23,4,26,4],[23,5,26,5],[23,6,26,6],[23,7,26,7],[23,8,26,8],[23,15,26,15],[18,2,18,8],[19,4,22,4],[19,5,22,5],[19,6,22,6],[19,7,22,7],[19,8,22,8],[12,7,17,7],[12,8,17,8],[12,15,17,15],[7,2,7,8],[8,4,11,4],[8,5,11,5],[8,6,11,6],[8,7,11,7],[8,8,11,8],[8,15,11,15],[4,21,6,21],[27,2,27,8],[27,9,27,15],[1,1,3,3],[1,4,3,4],[4,2,6,3],[4,4,6,4],[4,15,6,15],[4,5,6,5],[4,6,6,6],[4,7,6,7],[4,8,6,8],[4,19,6,19],[12,4,17,4],[12,5,17,5],[12,6,17,6]]}
[]
[null,"Principle 8 - Leadership, capability and capacity",null,null,"There should be consistent and sustainable efforts towards strengthening the organisational leadership of government and public institutions, and the capabilities and capacities of all public officials, so that the fundamentals of good democratic governance are effective.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CELL(\"contents\",Q38)>0,P38,\"--\")","v":"--"},null,"Average Indicator score"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P37","v":"--"},null,"Statement score"]
[]
[null,null,"Target",null,"Indicator",{"$f":"'P1'!F5","v":"NOT AT ALL"},{"$f":"'P1'!G5","v":"PARTIALLY"},{"$f":"'P1'!H5","v":"SUFFICIENTLY"},{"$f":"'P1'!I5","v":"FULLY"},{"$f":"'P1'!J5","v":0},{"$f":"'P1'!K5","v":0},{"$f":"'P1'!L5","v":0},{"$f":"'P1'!M5","v":0},{"$f":"'P1'!N5","v":0},{"$f":"'P1'!O5","v":0},{"$f":"'P1'!P5","v":"Indicator score"},{"$f":"'P1'!Q5","v":0},{"$f":"'P1'!R5","v":0},{"$f":"'P1'!S5","v":0},{"$f":"'P1'!T5","v":"Target score"},null,"Not at all - We are aware of the key issues but not planning nor action is taken.\nPartially - We acknowledge the key issues and designing answers, but only limited actions is taken.\nSufficiently - We have well developed plans and activities to address key issues with significant examples of implementation.\t\nFully - We can show clear evidence of good practices which are monitored and integrated in our interventions."]
[null,null,null,null,null,null,null,null,null,{"$f":"'P1'!J6","v":0},{"$f":"'P1'!K6","v":0},{"$f":"'P1'!L6","v":0},{"$f":"'P1'!M6","v":0},{"$f":"'P1'!N6","v":0},{"$f":"'P1'!O6","v":0},null,{"$f":"'P1'!Q6","v":0},{"$f":"'P1'!R6","v":0},{"$f":"'P1'!S6","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"'P1'!J7","v":0},{"$f":"'P1'!K7","v":0},{"$f":"'P1'!L7","v":0},{"$f":"'P1'!M7","v":0},{"$f":"'P1'!N7","v":0},{"$f":"'P1'!O7","v":0},null,{"$f":"'P1'!Q7","v":0},{"$f":"'P1'!R7","v":0},{"$f":"'P1'!S7","v":0}]
[null,"8.1","The local authority operates with a clear vision inspired by the Principles of Good Democratic Governance and embodies a proactive, innovative, learning, inclusive, safe, and representative approach that reflects the diversity of the society it serves.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J9:M9,J13:M13)","v":0},{"$f":"(((R8-(2))*(1-0))/(8-(2)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",U8)>0,S8,\"\")","v":""},{"$f":"COUNTIF(F9:I13,\"x\")","v":0},"Suggested evidences"]
[null,null,null,"8.1.1","Periodic reports address progress towards promoting diversity and inclusion, showcasing initiatives and Targets.",null,null,null,null,{"$f":"IF(F9=\"x\",1,0)","v":0},{"$f":"IF(G9=\"x\",2,0)","v":0},{"$f":"IF(H9=\"x\",3,0)","v":0},{"$f":"IF(I9=\"x\",4,0)","v":0},{"$f":"SUM(J9:M9)","v":0},{"$f":"(((N9-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q9)>0,O9,\"--\")","v":"--"},{"$f":"COUNTIF(F9:I9,\"x\")","v":0},null,null,null,null,"Periodic reports showcasing the diversity within the local authority's workforce."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Documentation of diversity-related training sessions provided to staff."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Records of community engagement initiatives that reflect the authority's commitment to inclusivity."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"..."]
[null,null,null,"8.1.2","Local authority organises regular staff workshops and training sessions on innovation and continuous learning.",null,null,null,null,{"$f":"IF(F13=\"x\",1,0)","v":0},{"$f":"IF(G13=\"x\",2,0)","v":0},{"$f":"IF(H13=\"x\",3,0)","v":0},{"$f":"IF(I13=\"x\",4,0)","v":0},{"$f":"SUM(J13:M13)","v":0},{"$f":"(((N13-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q13)>0,O13,\"--\")","v":"--"},{"$f":"COUNTIF(F13:I13,\"x\")","v":0},null,null,null,null,"Records of innovation workshops and training sessions."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Capacity-building activities fostering green administration"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Activities and policies to drive innovation and stimulate environmentally conscious initiatives"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attendees' Satisfaction Surveys or feedback forms "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reports highlighting innovative ideas or projects initiated by staff following the workshops."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,"8.2","The local authority endorses human resource policies which create capability systems aligning competences with goals, fostering merit-based talent development. Regular assessments identify skills and organisational capacity, supported by comprehensive training plans for capability enhancement.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J20:M20,J24:M24)","v":0},{"$f":"(((R19-(2))*(1-0))/(8-(2)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",U19)>0,S19,\"\")","v":""},{"$f":"COUNTIF(F20:I24,\"x\")","v":0}]
[null,null,null,"8.2.1","Competency alignment records enable local authority to track staff skills in relation to strategic objectives.",null,null,null,null,{"$f":"IF(F20=\"x\",1,0)","v":0},{"$f":"IF(G20=\"x\",2,0)","v":0},{"$f":"IF(H20=\"x\",3,0)","v":0},{"$f":"IF(I20=\"x\",4,0)","v":0},{"$f":"SUM(J20:M20)","v":0},{"$f":"(((N20-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q20)>0,O20,\"--\")","v":"--"},{"$f":"COUNTIF(F20:I20,\"x\")","v":0},null,null,null,null,"Records showing the alignment of staff skills with strategic objectives, with identified areas for improvement."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Evidence of talent development programmes and promotions based on merit."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Employee testimonials or feedback indicating how their skills have contributed to achieving local authority goals."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,null,null,"8.2.2","The local authority runs a programme of training sessions for employees and attendance records to support skills improvement.",null,null,null,null,{"$f":"IF(F24=\"x\",1,0)","v":0},{"$f":"IF(G24=\"x\",2,0)","v":0},{"$f":"IF(H24=\"x\",3,0)","v":0},{"$f":"IF(I24=\"x\",4,0)","v":0},{"$f":"SUM(J24:M24)","v":0},{"$f":"(((N24-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q24)>0,O24,\"--\")","v":"--"},{"$f":"COUNTIF(F24:I24,\"x\")","v":0},null,null,null,null,"Training calendars."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attendance records."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Employee surveys or assessments to evaluate the effectiveness of training."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,"8.3","The required structures, processes, and capacities for researching, planning, funding, implementing, and evaluating capacity-building programmes are established and supported. Performance appraisal and management measures and procedures are in place to assess, reward, and enhance individual performance while also fostering professional and personal development.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J29:M29,J33:M33)","v":0},{"$f":"(((R28-(2))*(1-0))/(8-(2)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",U28)>0,S28,\"\")","v":""},{"$f":"COUNTIF(F29:I33,\"x\")","v":0}]
[null,null,null,"8.3.1","Regular evaluations of capacity-building programmes carried out to measure their impact and inform improvements.",null,null,null,null,{"$f":"IF(F29=\"x\",1,0)","v":0},{"$f":"IF(G29=\"x\",2,0)","v":0},{"$f":"IF(H29=\"x\",3,0)","v":0},{"$f":"IF(I29=\"x\",4,0)","v":0},{"$f":"SUM(J29:M29)","v":0},{"$f":"(((N29-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q29)>0,O29,\"--\")","v":"--"},{"$f":"COUNTIF(F29:I29,\"x\")","v":0},null,null,null,null,"Reports on the results and impact of specific capacity-building programmes."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Testimonials from staff."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reports on key performance indicators attributed to capacity-building efforts."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,null,null,"8.3.2","Performance appraisal records and individual development plans for local authority staff are used to assess and enhance employee performance and development.",null,null,null,null,{"$f":"IF(F33=\"x\",1,0)","v":0},{"$f":"IF(G33=\"x\",2,0)","v":0},{"$f":"IF(H33=\"x\",3,0)","v":0},{"$f":"IF(I33=\"x\",4,0)","v":0},{"$f":"SUM(J33:M33)","v":0},{"$f":"(((N33-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q33)>0,O33,\"--\")","v":"--"},{"$f":"COUNTIF(F33:I33,\"x\")","v":0},null,null,null,null,"Performance appraisal records and development plans for employees."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Examples of employee achievements."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Documentation of promotions or career advancements and other types of rewards."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,null,"How much do you agree with the following statement?",null," Our local authority is determined in its commitment to the principle of Leadership, Capability, and Capacity. We consistently invest in strengthening the leadership skills of our elected representatives, as well as enhancing the capabilities and capacities of all our public officials and employees. By fostering effective leadership, building capability, and nurturing the capacity of our officials, we strive to create a local authority that is well-equipped to serve our community with excellence and meet the highest standards of democratic governance.",null,null,null,null,{"$f":"IF(F37=\"x\",1,0)","v":0},{"$f":"IF(G37=\"x\",2,0)","v":0},{"$f":"IF(H37=\"x\",3,0)","v":0},{"$f":"IF(I37=\"x\",4,0)","v":0},{"$f":"SUM(J37:M37)","v":0},{"$f":"(((N37-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q37)>0,O37,\"--\")","v":"--"},{"$f":"COUNTIF(F37:I37,\"x\")","v":0},{"$f":"T2*T3","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average",{"$f":"AVERAGE(P9,P13,P20,P24,P29,P33)","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(F9:I33,\"x\")","v":0}]

{"sheet":"P9","index":9,"n_rows":38,"n_cols":22,"rows_kept":38,"cut":false,"hidden":false,"merged":[[27,2,27,8],[27,9,27,15],[32,15,35,15],[28,4,31,4],[28,5,31,5],[28,6,31,6],[28,7,31,7],[28,8,31,8],[28,15,31,15],[32,4,35,4],[32,5,35,5],[32,6,35,6],[32,7,35,7],[32,8,35,8],[19,15,22,15],[23,4,26,4],[23,5,26,5],[23,6,26,6],[23,7,26,7],[23,8,26,8],[23,15,26,15],[18,2,18,8],[19,4,22,4],[19,5,22,5],[19,6,22,6],[19,7,22,7],[19,8,22,8],[13,15,17,15],[4,21,6,21],[7,2,7,8],[8,5,12,5],[8,6,12,6],[8,7,12,7],[8,8,12,8],[8,15,12,15],[4,19,6,19],[13,4,17,4],[13,5,17,5],[13,6,17,6],[13,7,17,7],[13,8,17,8],[8,4,11,4],[1,1,3,3],[1,4,3,4],[4,2,6,3],[4,4,6,4],[4,15,6,15],[4,5,6,5],[4,6,6,6],[4,7,6,7],[4,8,6,8]]}
[]
[null,"Principle 9 - Responsiveness",null,null,"Government, public institutions and public officials should be responsive to the legitimate expectations and needs of those whom they serve.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CELL(\"contents\",Q38)>0,P38,\"--\")","v":"--"},null,"Average Indicator score"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P37","v":"--"},null,"Statement score"]
[]
[null,null,"Target",null,"Outuput",{"$f":"'P1'!F5","v":"NOT AT ALL"},{"$f":"'P1'!G5","v":"PARTIALLY"},{"$f":"'P1'!H5","v":"SUFFICIENTLY"},{"$f":"'P1'!I5","v":"FULLY"},{"$f":"'P1'!J5","v":0},{"$f":"'P1'!K5","v":0},{"$f":"'P1'!L5","v":0},{"$f":"'P1'!M5","v":0},{"$f":"'P1'!N5","v":0},{"$f":"'P1'!O5","v":0},{"$f":"'P1'!P5","v":"Indicator score"},{"$f":"'P1'!Q5","v":0},{"$f":"'P1'!R5","v":0},{"$f":"'P1'!S5","v":0},{"$f":"'P1'!T5","v":"Target score"},null,"Not at all - We are aware of the key issues but not planning nor action is taken.\nPartially - We acknowledge the key issues and designing answers, but only limited actions is taken.\nSufficiently - We have well developed plans and activities to address key issues with significant examples of implementation.\t\nFully - We can show clear evidence of good practices which are monitored and integrated in our interventions."]
[null,null,null,null,null,null,null,null,null,{"$f":"'P1'!J6","v":0},{"$f":"'P1'!K6","v":0},{"$f":"'P1'!L6","v":0},{"$f":"'P1'!M6","v":0},{"$f":"'P1'!N6","v":0},{"$f":"'P1'!O6","v":0},null,{"$f":"'P1'!Q6","v":0},{"$f":"'P1'!R6","v":0},{"$f":"'P1'!S6","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"'P1'!J7","v":0},{"$f":"'P1'!K7","v":0},{"$f":"'P1'!L7","v":0},{"$f":"'P1'!M7","v":0},{"$f":"'P1'!N7","v":0},{"$f":"'P1'!O7","v":0},null,{"$f":"'P1'!Q7","v":0},{"$f":"'P1'!R7","v":0},{"$f":"'P1'!S7","v":0}]
[null,"9.1","People's legitimate expectations and needs are systematically recognised and integrated into public service planning and delivery through transparent processes.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J9:M9,J14:M14)","v":0},{"$f":"(((R8-(2))*(1-0))/(8-(2)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",U8)>0,S8,\"\")","v":""},{"$f":"COUNTIF(F9:I14,\"x\")","v":0},"Suggested evidences"]
[null,null,null,"9.1.1","Regular community needs assessments to identify specific local needs and expectations, including on environment issues.",null,null,null,null,{"$f":"IF(F9=\"x\",1,0)","v":0},{"$f":"IF(G9=\"x\",2,0)","v":0},{"$f":"IF(H9=\"x\",3,0)","v":0},{"$f":"IF(I9=\"x\",4,0)","v":0},{"$f":"SUM(J9:M9)","v":0},{"$f":"(((N9-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q9)>0,O9,\"--\")","v":"--"},{"$f":"COUNTIF(F9:I9,\"x\")","v":0},null,null,null,null,"Documented community needs assessments."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Meeting minutes or survey summaries from assessments."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Organisation of working groups with representative stakeholders."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Case studies showing how identified needs were addressed."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,null,null,"9.1.2","Established public consultation mechanism (e.g., platform or advisory committee) to gather input from residents on service priorities and improvements needed.",null,null,null,null,{"$f":"IF(F14=\"x\",1,0)","v":0},{"$f":"IF(G14=\"x\",2,0)","v":0},{"$f":"IF(H14=\"x\",3,0)","v":0},{"$f":"IF(I14=\"x\",4,0)","v":0},{"$f":"SUM(J14:M14)","v":0},{"$f":"(((N14-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q14)>0,O14,\"--\")","v":"--"},{"$f":"COUNTIF(F14:I14,\"x\")","v":0},null,null,null,null,"Meeting minutes or reports from consultation mechanism."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Records of feedback gathered online, including participant numbers and key themes."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Proof of actions taken in response to resident input."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Records of community input on environmental issues."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,"9.2","Effective procedures are in place to oversee public service provision, including mechanisms for citizen complaints and engagement with Ombuds institutions.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J20:M20,J24:M24)","v":0},{"$f":"(((R19-(2))*(1-0))/(8-(2)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",U19)>0,S19,\"\")","v":""},{"$f":"COUNTIF(F20:I24,\"x\")","v":0}]
[null,null,null,"9.2.1","Dedicated online portal or helpline for citizens to submit complaints and feedback.",null,null,null,null,{"$f":"IF(F20=\"x\",1,0)","v":0},{"$f":"IF(G20=\"x\",2,0)","v":0},{"$f":"IF(H20=\"x\",3,0)","v":0},{"$f":"IF(I20=\"x\",4,0)","v":0},{"$f":"SUM(J20:M20)","v":0},{"$f":"(((N20-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q20)>0,O20,\"--\")","v":"--"},{"$f":"COUNTIF(F20:I20,\"x\")","v":0},null,null,null,null,"Stats or records of the user-friendly online portal."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Logs of complaints received."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sample responses or resolutions to complaints."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,null,null,"9.2.2","Accessible annual report on the number and types of complaints received, resolutions reached and actions taken to address systemic issues.",null,null,null,null,{"$f":"IF(F24=\"x\",1,0)","v":0},{"$f":"IF(G24=\"x\",2,0)","v":0},{"$f":"IF(H24=\"x\",3,0)","v":0},{"$f":"IF(I24=\"x\",4,0)","v":0},{"$f":"SUM(J24:M24)","v":0},{"$f":"(((N24-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q24)>0,O24,\"--\")","v":"--"},{"$f":"COUNTIF(F24:I24,\"x\")","v":0},null,null,null,null,"Copies of transparent annual reports on complaints."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Documentation of actions or policy changes due to these reports."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Feedback from citizens regarding report usefulness."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,"9.3","Timely handling of monitoring Targets and complaints is seamlessly integrated across all stages of policy and decision-making.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J29:M29,J33:M33)","v":0},{"$f":"(((R28-(2))*(1-0))/(8-(2)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",U28)>0,S28,\"\")","v":""},{"$f":"COUNTIF(F29:I33,\"x\")","v":0}]
[null,null,null,"9.3.1","Cross-service task force responsible for reviewing monitoring results and complaints ensuring their integration into policy discussions.",null,null,null,null,{"$f":"IF(F29=\"x\",1,0)","v":0},{"$f":"IF(G29=\"x\",2,0)","v":0},{"$f":"IF(H29=\"x\",3,0)","v":0},{"$f":"IF(I29=\"x\",4,0)","v":0},{"$f":"SUM(J29:M29)","v":0},{"$f":"(((N29-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q29)>0,O29,\"--\")","v":"--"},{"$f":"COUNTIF(F29:I29,\"x\")","v":0},null,null,null,null,"Organisational chart with task force details. "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Task force meeting records."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sample policy documents influenced by task force input."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,null,null,"9.3.2","Regular progress reports on monitoring Targets and complaints and their influence on policy changes and decisions.",null,null,null,null,{"$f":"IF(F33=\"x\",1,0)","v":0},{"$f":"IF(G33=\"x\",2,0)","v":0},{"$f":"IF(H33=\"x\",3,0)","v":0},{"$f":"IF(I33=\"x\",4,0)","v":0},{"$f":"SUM(J33:M33)","v":0},{"$f":"(((N33-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q33)>0,O33,\"--\")","v":"--"},{"$f":"COUNTIF(F33:I33,\"x\")","v":0},null,null,null,null,"Published progress reports on monitoring Targets and complaints."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Records of policy changes citing monitoring and complaints."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stakeholder feedback on report impact on local policies and decisions."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,null,"How much do you agree with the following statement?",null,"Our local authority places a strong emphasis on Responsiveness as a cornerstone of our governance approach. We are committed to ensuring that our government, public institutions, and public officials have the capacity and willingness to respond to the legitimate expectations and needs of our community members. Responsiveness is at the core of our mission to provide effective and accountable governance that meets the diverse needs of our residents. By actively engaging with them, listening to their concerns, and tailoring our policies and services accordingly, we demonstrate our commitment to serving their best interests.",null,null,null,null,{"$f":"IF(F37=\"x\",1,0)","v":0},{"$f":"IF(G37=\"x\",2,0)","v":0},{"$f":"IF(H37=\"x\",3,0)","v":0},{"$f":"IF(I37=\"x\",4,0)","v":0},{"$f":"SUM(J37:M37)","v":0},{"$f":"(((N37-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q37)>0,O37,\"--\")","v":"--"},{"$f":"COUNTIF(F37:I37,\"x\")","v":0},{"$f":"T2*T3","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average",{"$f":"AVERAGE(P9,P14,P20,P24,P29,P33)","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(F9:I33,\"x\")","v":0}]

{"sheet":"P10","index":10,"n_rows":37,"n_cols":22,"rows_kept":37,"cut":false,"hidden":false,"merged":[[31,15,34,15],[26,2,26,15],[27,4,30,4],[27,5,30,5],[27,6,30,6],[27,7,30,7],[27,8,30,8],[27,15,30,15],[31,4,34,4],[31,5,34,5],[31,6,34,6],[31,7,34,7],[31,8,34,8],[18,15,21,15],[22,4,25,4],[22,5,25,5],[22,6,25,6],[22,7,25,7],[22,8,25,8],[22,15,25,15],[17,2,17,8],[18,4,21,4],[18,5,21,5],[18,6,21,6],[18,7,21,7],[18,8,21,8],[13,15,16,15],[4,21,6,21],[7,2,7,8],[8,4,12,4],[8,5,12,5],[8,6,12,6],[8,7,12,7],[8,8,12,8],[8,15,12,15],[4,19,6,19],[13,4,16,4],[13,5,16,5],[13,6,16,6],[13,7,16,7],[13,8,16,8],[1,1,3,3],[1,4,3,4],[4,2,6,3],[4,4,6,4],[4,15,6,15],[4,5,6,5],[4,6,6,6],[4,7,6,7],[4,8,6,8]]}
[]
[null,"Principle 10 – Sound financial and economic management",null,null,"There should be sound financial and economic management throughout government and public institutions, and by all public officials, in order to ensure the optimal use of public resources and the implementation of policies that promote the well-being and prosperity of everyone.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CELL(\"contents\",Q37)>0,P37,\"--\")","v":0.49999999999999994},null,"Average Indicator score"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P36","v":"--"},null,"Statement score"]
[]
[null,null,"Target",null,"Indicator",{"$f":"'P1'!F5","v":"NOT AT ALL"},{"$f":"'P1'!G5","v":"PARTIALLY"},{"$f":"'P1'!H5","v":"SUFFICIENTLY"},{"$f":"'P1'!I5","v":"FULLY"},{"$f":"'P1'!J5","v":0},{"$f":"'P1'!K5","v":0},{"$f":"'P1'!L5","v":0},{"$f":"'P1'!M5","v":0},{"$f":"'P1'!N5","v":0},{"$f":"'P1'!O5","v":0},{"$f":"'P1'!P5","v":"Indicator score"},{"$f":"'P1'!Q5","v":0},{"$f":"'P1'!R5","v":0},{"$f":"'P1'!S5","v":0},{"$f":"'P1'!T5","v":"Target score"},null,"Not at all - We are aware of the key issues but not planning nor action is taken.\nPartially - We acknowledge the key issues and designing answers, but only limited actions is taken.\nSufficiently - We have well developed plans and activities to address key issues with significant examples of implementation.\t\nFully - We can show clear evidence of good practices which are monitored and integrated in our interventions."]
[null,null,null,null,null,null,null,null,null,{"$f":"'P1'!J6","v":0},{"$f":"'P1'!K6","v":0},{"$f":"'P1'!L6","v":0},{"$f":"'P1'!M6","v":0},{"$f":"'P1'!N6","v":0},{"$f":"'P1'!O6","v":0},null,{"$f":"'P1'!Q6","v":0},{"$f":"'P1'!R6","v":0},{"$f":"'P1'!S6","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"'P1'!J7","v":0},{"$f":"'P1'!K7","v":0},{"$f":"'P1'!L7","v":0},{"$f":"'P1'!M7","v":0},{"$f":"'P1'!N7","v":0},{"$f":"'P1'!O7","v":0},null,{"$f":"'P1'!Q7","v":0},{"$f":"'P1'!R7","v":0},{"$f":"'P1'!S7","v":0}]
[null,"10.1","Economic and financial policies, clearly linked to other plans and strategies, set objectives and measures to support long-term economic growth without negatively impacting on societal and environmental wellbeing, including intergenerational equity.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J9:M9,J14:M14)","v":5},{"$f":"(((R8-(2))*(1-0))/(8-(2)))+0","v":0.5},{"$f":"IF(CELL(\"contents\",U8)>0,S8,\"\")","v":0.5},{"$f":"COUNTIF(F9:I14,\"x\")","v":2},"Suggested evidences"]
[null,null,null,"10.1.1","Comprehensive local economic strategy aligning economic and financial policies with the Local authority development plans, including open and transparent procurement practices.."," ",null,"x",null,{"$f":"IF(F9=\"x\",1,0)","v":0},{"$f":"IF(G9=\"x\",2,0)","v":0},{"$f":"IF(H9=\"x\",3,0)","v":3},{"$f":"IF(I9=\"x\",4,0)","v":0},{"$f":"SUM(J9:M9)","v":3},{"$f":"(((N9-(1))*(1-0))/(4-(1)))+0","v":0.66666666666666663},{"$f":"IF(CELL(\"contents\",Q9)>0,O9,\"--\")","v":0.66666666666666663},{"$f":"COUNTIF(F9:I9,\"x\")","v":1},null,null,null,null,"Published strategy report."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Evidence of policy integration in budgetary decisions and projects."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annual progress reports demonstrating policy implementation."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Procurement rules and procedures."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,null,null,"10.1.2","Regular sustainability impact assessments on Economic Policies evaluating the societal and environmental impact of economic and financial policies",null,"x",null,null,{"$f":"IF(F14=\"x\",1,0)","v":0},{"$f":"IF(G14=\"x\",2,0)","v":2},{"$f":"IF(H14=\"x\",3,0)","v":0},{"$f":"IF(I14=\"x\",4,0)","v":0},{"$f":"SUM(J14:M14)","v":2},{"$f":"(((N14-(1))*(1-0))/(4-(1)))+0","v":0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q14)>0,O14,\"--\")","v":0.33333333333333331},{"$f":"COUNTIF(F14:I14,\"x\")","v":1},null,null,null,null,"Regular sustainability impact assessment reports."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summaries of findings, alongside stakeholder engagement records."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Documentation illustrating how financial policies align with local development plans."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,"10.2","Audits, both internal and external, are understood as important to monitor and provide assurance on the soundness and coherence of financial management, and the assessment and management of risk.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J19:M19,J23:M23)","v":5},{"$f":"(((R18-(2))*(1-0))/(8-(2)))+0","v":0.5},{"$f":"IF(CELL(\"contents\",U18)>0,S18,\"\")","v":0.5},{"$f":"COUNTIF(F19:I23,\"x\")","v":2}]
[null,null,null,"10.2.1","Annual external financial audits are carried out to measure the municipality's financial management practices.",null,null,"x",null,{"$f":"IF(F19=\"x\",1,0)","v":0},{"$f":"IF(G19=\"x\",2,0)","v":0},{"$f":"IF(H19=\"x\",3,0)","v":3},{"$f":"IF(I19=\"x\",4,0)","v":0},{"$f":"SUM(J19:M19)","v":3},{"$f":"(((N19-(1))*(1-0))/(4-(1)))+0","v":0.66666666666666663},{"$f":"IF(CELL(\"contents\",Q19)>0,O19,\"--\")","v":0.66666666666666663},{"$f":"COUNTIF(F19:I19,\"x\")","v":1},null,null,null,null,"Published external audit reports detailing financial management findings and recommendations."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contracts with independent audit firms, affirming regular audits."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Records of actions taken in response to audit recommendations."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,null,null,"10.2.2","Implement a system to continuously monitor and update key risk indicators, provide regular updates on the status of potential risks and actions taken to manage them.",null,"x",null,null,{"$f":"IF(F23=\"x\",1,0)","v":0},{"$f":"IF(G23=\"x\",2,0)","v":2},{"$f":"IF(H23=\"x\",3,0)","v":0},{"$f":"IF(I23=\"x\",4,0)","v":0},{"$f":"SUM(J23:M23)","v":2},{"$f":"(((N23-(1))*(1-0))/(4-(1)))+0","v":0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q23)>0,O23,\"--\")","v":0.33333333333333331},{"$f":"COUNTIF(F23:I23,\"x\")","v":1},null,null,null,null,"Regularly updated risk indicator reports indicating potential risks and management actions."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Documentation of cross-department meetings on risk management."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Records of specific projects initiated due to risk monitoring."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,"10.3","Cooperation and partnership mechanisms are sought after to identify economies of scales, fair sharing of burdens and benefits and reduction of risks.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J28:M28,J32:M32)","v":0},{"$f":"(((R27-(2))*(1-0))/(8-(2)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",U27)>0,S27,\"\")","v":""},{"$f":"COUNTIF(F28:I32,\"x\")","v":0}]
[null,null,null,"10.3.1","Inter-municipal cooperation settings for the joint delivery of services.",null,null,null,null,{"$f":"IF(F28=\"x\",1,0)","v":0},{"$f":"IF(G28=\"x\",2,0)","v":0},{"$f":"IF(H28=\"x\",3,0)","v":0},{"$f":"IF(I28=\"x\",4,0)","v":0},{"$f":"SUM(J28:M28)","v":0},{"$f":"(((N28-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q28)>0,O28,\"--\")","v":"--"},{"$f":"COUNTIF(F28:I28,\"x\")","v":0},null,null,null,null,"Signed inter-municipal agreements on joint service delivery."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reports on cost savings and service quality improvements."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Evidence of ongoing inter-municipal collaboration mechanisms."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,null,null,"10.3.2","Inter-municipal agreements on risk mitigation, such as natural disasters or economic downturns. ",null,null,null,null,{"$f":"IF(F32=\"x\",1,0)","v":0},{"$f":"IF(G32=\"x\",2,0)","v":0},{"$f":"IF(H32=\"x\",3,0)","v":0},{"$f":"IF(I32=\"x\",4,0)","v":0},{"$f":"SUM(J32:M32)","v":0},{"$f":"(((N32-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q32)>0,O32,\"--\")","v":"--"},{"$f":"COUNTIF(F32:I32,\"x\")","v":0},null,null,null,null,"Reports highlighting the success of joint risk reduction projects."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Records of shared resources during actual risk events."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Evidence of resource pooling and support among local authorities during crises."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,null,"How much do you agree with the following statement?",null,"Our local authority places a strong emphasis on Sound Financial and Economic Management within our governance framework. We are dedicated to upholding sound financial practices and economic management. Our commitment extends to all public officials, ensuring the optimal utilization of public resources. Our policies are designed to foster the well-being and prosperity of all residents in our community. By maintaining fiscal responsibility and pursuing economic policies that promote the welfare of our residents, we aim to create a stable and prosperous environment for all.",null,null,null,null,{"$f":"IF(F36=\"x\",1,0)","v":0},{"$f":"IF(G36=\"x\",2,0)","v":0},{"$f":"IF(H36=\"x\",3,0)","v":0},{"$f":"IF(I36=\"x\",4,0)","v":0},{"$f":"SUM(J36:M36)","v":0},{"$f":"(((N36-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q36)>0,O36,\"--\")","v":"--"},{"$f":"COUNTIF(F36:I36,\"x\")","v":0},{"$f":"T2*T3","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average",{"$f":"AVERAGE(P9,P14,P19,P23,P28,P32)","v":0.49999999999999994},{"$f":"COUNTIF(F9:I32,\"x\")","v":4}]

{"sheet":"P11","index":11,"n_rows":38,"n_cols":22,"rows_kept":38,"cut":false,"hidden":false,"merged":[[32,15,35,15],[27,2,27,15],[28,4,31,4],[28,5,31,5],[28,6,31,6],[28,7,31,7],[28,8,31,8],[28,15,31,15],[32,4,35,4],[32,5,35,5],[32,6,35,6],[32,7,35,7],[32,8,35,8],[19,15,22,15],[23,4,26,4],[23,5,26,5],[23,6,26,6],[23,7,26,7],[23,8,26,8],[23,15,26,15],[18,2,18,8],[19,4,22,4],[19,5,22,5],[19,6,22,6],[19,7,22,7],[19,8,22,8],[4,19,7,19],[13,4,17,4],[13,5,17,5],[13,6,17,6],[13,7,17,7],[13,8,17,8],[13,15,17,15],[8,2,8,8],[9,4,12,4],[9,5,12,5],[9,6,12,6],[9,7,12,7],[9,8,12,8],[9,15,12,15],[1,1,3,3],[1,4,3,4],[4,2,7,3],[4,4,7,4],[4,15,7,15],[4,5,7,5],[4,6,7,6],[4,7,7,7],[4,8,7,8]]}
[]
[null,"Principle 11 - Sustainability and long-term orientation",null,null,"Efforts should be made to maximise the sustainability of decisions and actions taken by government, public institutions and public officials, and to take into account their potential impact on future generations and the ability of those generations to address their own needs.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CELL(\"contents\",Q38)>0,P38,\"--\")","v":"--"},null,"Average Indicator score"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P37","v":"--"},null,"Statement score"]
[]
[null,null,"Target",null,"Indicator",{"$f":"'P1'!F5","v":"NOT AT ALL"},{"$f":"'P1'!G5","v":"PARTIALLY"},{"$f":"'P1'!H5","v":"SUFFICIENTLY"},{"$f":"'P1'!I5","v":"FULLY"},{"$f":"'P1'!J5","v":0},{"$f":"'P1'!K5","v":0},{"$f":"'P1'!L5","v":0},{"$f":"'P1'!M5","v":0},{"$f":"'P1'!N5","v":0},{"$f":"'P1'!O5","v":0},{"$f":"'P1'!P5","v":"Indicator score"},{"$f":"'P1'!Q5","v":0},{"$f":"'P1'!R5","v":0},{"$f":"'P1'!S5","v":0},{"$f":"'P1'!T5","v":"Target score"},null,"Not at all - We are aware of the key issues but not planning nor action is taken."]
[null,null,null,null,null,null,null,null,null,{"$f":"'P1'!J6","v":0},{"$f":"'P1'!K6","v":0},{"$f":"'P1'!L6","v":0},{"$f":"'P1'!M6","v":0},{"$f":"'P1'!N6","v":0},{"$f":"'P1'!O6","v":0},null,{"$f":"'P1'!Q6","v":0},{"$f":"'P1'!R6","v":0},{"$f":"'P1'!S6","v":0},null,null,"Partially - We acknowledge the key issues and designing answers, but only limited actions is taken."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sufficiently - We have well developed plans and activities to address key issues with significant examples of implementation."]
[null,null,null,null,null,null,null,null,null,{"$f":"'P1'!J7","v":0},{"$f":"'P1'!K7","v":0},{"$f":"'P1'!L7","v":0},{"$f":"'P1'!M7","v":0},{"$f":"'P1'!N7","v":0},{"$f":"'P1'!O7","v":0},null,{"$f":"'P1'!Q7","v":0},{"$f":"'P1'!R7","v":0},{"$f":"'P1'!S7","v":0},null,null,"Fully - We can show clear evidence of good practices which are monitored and integrated in our interventions."]
[null,"11.1","Current policy and decision-making processes reference resilience, sustainability, and intergenerational equity and acknowledge the impacts on the administration, the community, and the environment currently and in the future.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J10:M10,J14:M14)","v":0},{"$f":"(((R9-(2))*(1-0))/(8-(2)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",U9)>0,S9,\"\")","v":""},{"$f":"COUNTIF(F10:I14,\"x\")","v":0},"Suggested evidences"]
[null,null,null,"11.1.1","Comprehensive assessment framework integrating resilience, sustainability, and intergenerational equity considerations into the local policy and decision-making processes implemented based on key performance indicators (KPIs).",null,null,null,null,{"$f":"IF(F10=\"x\",1,0)","v":0},{"$f":"IF(G10=\"x\",2,0)","v":0},{"$f":"IF(H10=\"x\",3,0)","v":0},{"$f":"IF(I10=\"x\",4,0)","v":0},{"$f":"SUM(J10:M10)","v":0},{"$f":"(((N10-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q10)>0,O10,\"--\")","v":"--"},{"$f":"COUNTIF(F10:I10,\"x\")","v":0},null,null,null,null,"Regular reports on the impact of policies and decisions on the administration, community, and environment over time."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Specific examples where policies were modified based on assessment results to better align with resilience, sustainability, and intergenerational equity principles."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maintain records of stakeholder engagement activities, showing how their input has influenced decision-making and policy adjustments."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,null,null,"11.1.2","Targeted public engagement and education programmes aimed at increasing awareness and understanding of resilience, sustainability, and intergenerational equity organised regularly for the benefit of the local community.",null,null,null,null,{"$f":"IF(F14=\"x\",1,0)","v":0},{"$f":"IF(G14=\"x\",2,0)","v":0},{"$f":"IF(H14=\"x\",3,0)","v":0},{"$f":"IF(I14=\"x\",4,0)","v":0},{"$f":"SUM(J14:M14)","v":0},{"$f":"(((N14-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q14)>0,O14,\"--\")","v":"--"},{"$f":"COUNTIF(F14:I14,\"x\")","v":0},null,null,null,null,"Attendance Logs of community attendance at workshops, seminars, and events in the public engagement and education programmes."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Educational Materials."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Knowledge assessment."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Awareness raising and education on the environ¬ment are accessible to everyone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,"11.2","Policy and decision-making processes acknowledge and strive to preserve the historical, cultural, and societal aspects of the context they are targeting.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J20:M20,J24:M24)","v":0},{"$f":"(((R19-(2))*(1-0))/(8-(2)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",U19)>0,S19,\"\")","v":""},{"$f":"COUNTIF(F20:I24,\"x\")","v":0}]
[null,null,null,"11.2.1","The local authority has a cultural preservation strategy used to assess the potential cultural, historical, and societal impacts of proposed policies and decisions.",null,null,null,null,{"$f":"IF(F20=\"x\",1,0)","v":0},{"$f":"IF(G20=\"x\",2,0)","v":0},{"$f":"IF(H20=\"x\",3,0)","v":0},{"$f":"IF(I20=\"x\",4,0)","v":0},{"$f":"SUM(J20:M20)","v":0},{"$f":"(((N20-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q20)>0,O20,\"--\")","v":"--"},{"$f":"COUNTIF(F20:I20,\"x\")","v":0},null,null,null,null,"Cultural preservation assessment Reports."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Policy integration documentation demonstrating how recs are incorporated in the decision-making process."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reports of gathering feedback efforts from relevant stakeholders, such as local historians, cultural organisations, and community groups."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,null,null,"11.2.2","The local authority involves the community in decisions that have an impact on historical and cultural heritage and community life.",null,null,null,null,{"$f":"IF(F24=\"x\",1,0)","v":0},{"$f":"IF(G24=\"x\",2,0)","v":0},{"$f":"IF(H24=\"x\",3,0)","v":0},{"$f":"IF(I24=\"x\",4,0)","v":0},{"$f":"SUM(J24:M24)","v":0},{"$f":"(((N24-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q24)>0,O24,\"--\")","v":"--"},{"$f":"COUNTIF(F24:I24,\"x\")","v":0},null,null,null,null,"Community Consultation Summaries."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Community Engagement Plans."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Community Participation Metrics."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,"11.3","Strategic planning processes are in place; they include key stakeholders and are being developed beyond electoral cycles to address the future requirements of people and the communities.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J29:M29,J33:M33)","v":0},{"$f":"(((R28-(2))*(1-0))/(8-(2)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",U28)>0,S28,\"\")","v":""},{"$f":"COUNTIF(F29:I33,\"x\")","v":0}]
[null,null,null,"11.3.1","The local authority has a long-term, community-centred plan that extends beyond electoral cycles, identifying future requirements of the community, reflecting on the nature, content, and implications of the right to a clean, healthy, and sustainable environment as a human right.",null,null,null,null,{"$f":"IF(F29=\"x\",1,0)","v":0},{"$f":"IF(G29=\"x\",2,0)","v":0},{"$f":"IF(H29=\"x\",3,0)","v":0},{"$f":"IF(I29=\"x\",4,0)","v":0},{"$f":"SUM(J29:M29)","v":0},{"$f":"(((N29-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q29)>0,O29,\"--\")","v":"--"},{"$f":"COUNTIF(F29:I29,\"x\")","v":0},null,null,null,null,"Long-term plan outlining the vision, goals, and strategies for the future, and it should extend beyond electoral cycles."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Community Surveys and Feedback."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Periodic progress reports and milestones achieved in the implementation of the long-term plan."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,null,null,"11.3.2","Regular training programmes organised for local stakeholders and local authority staff to equip them with the skills and knowledge needed to implement and sustain long-term planning processes. ",null,null,null,null,{"$f":"IF(F33=\"x\",1,0)","v":0},{"$f":"IF(G33=\"x\",2,0)","v":0},{"$f":"IF(H33=\"x\",3,0)","v":0},{"$f":"IF(I33=\"x\",4,0)","v":0},{"$f":"SUM(J33:M33)","v":0},{"$f":"(((N33-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q33)>0,O33,\"--\")","v":"--"},{"$f":"COUNTIF(F33:I33,\"x\")","v":0},null,null,null,null,"Training Plans and Attendance Records."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Knowledge assessments."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Case studies of successful planning."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,null,"How much do you agree with the following statement?",null,"Our local authority is deeply committed to the Principle of Sustainability and Long-Term Orientation as a core aspect of our governance philosophy. We diligently work to maximise the sustainability of our decisions and actions, whether by government, public institutions, or public officials. Our commitment extends to considering the potential impact of our choices on future generations and their ability to meet their own needs. We strive to strike a balance between addressing current challenges and safeguarding the well-being and resources that will be crucial for the prosperity of future generations. Our long-term orientation guides our policies and practices, ensuring that we act as responsible stewards of our community's resources and a guardian of its future.",null,null,null,null,{"$f":"IF(F37=\"x\",1,0)","v":0},{"$f":"IF(G37=\"x\",2,0)","v":0},{"$f":"IF(H37=\"x\",3,0)","v":0},{"$f":"IF(I37=\"x\",4,0)","v":0},{"$f":"SUM(J37:M37)","v":0},{"$f":"(((N37-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q37)>0,O37,\"--\")","v":"--"},{"$f":"COUNTIF(F37:I37,\"x\")","v":0},{"$f":"T2*T3","v":{"$error":"#VALUE!"}}]
[null,null,null,null,"L'orientamento a lungo termine è un aspetto fondamentale della nostra filosofia di governance. Lavoriamo diligentemente per massimizzare la sostenibilità delle nostre decisioni e azioni, sia da parte del governo, delle istituzioni pubbliche o dei funzionari pubblici. Il nostro impegno si estende a considerare il potenziale impatto delle nostre scelte sulle generazioni future e sulla loro capacità di soddisfare i propri bisogni. Cerchiamo di trovare un equilibrio tra affrontare le sfide attuali e salvaguardare il benessere e le risorse che saranno fondamentali per la prosperità delle generazioni future. Il nostro orientamento a lungo termine guida le nostre politiche e pratiche, assicurandoci di agire come amministratori responsabili delle risorse della nostra comunità e custodi del suo futuro.",null,null,null,null,null,null,null,null,null,"Average",{"$f":"AVERAGE(P10,P14,P20,P24,P29,P33)","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(F10:I33,\"x\")","v":0}]

{"sheet":"P12","index":12,"n_rows":41,"n_cols":22,"rows_kept":41,"cut":false,"hidden":false,"merged":[[35,15,38,15],[29,2,29,15],[30,4,34,4],[30,5,34,5],[30,6,34,6],[30,7,34,7],[30,8,34,8],[30,15,34,15],[35,4,38,4],[35,5,38,5],[35,6,38,6],[35,7,38,7],[35,8,38,8],[19,15,23,15],[24,4,28,4],[24,5,28,5],[24,6,28,6],[24,7,28,7],[24,8,28,8],[24,15,28,15],[18,2,18,8],[19,4,23,4],[19,5,23,5],[19,6,23,6],[19,7,23,7],[19,8,23,8],[4,19,6,19],[13,4,17,4],[13,5,17,5],[13,6,17,6],[13,7,17,7],[13,8,17,8],[13,15,17,15],[7,2,7,8],[8,4,12,4],[8,5,12,5],[8,6,12,6],[8,7,12,7],[8,8,12,8],[8,15,12,15],[1,1,3,3],[1,4,3,4],[4,2,6,3],[4,4,6,4],[4,15,6,15],[4,5,6,5],[4,6,6,6],[4,7,6,7],[4,8,6,8]]}
[]
[null,"Principle 12 - Openess to change and innovation",null,null,"Government, public institutions and public officials should be ready to proactively embrace change and innovation, where this would improve the resilience and quality of public services, taking into account evolving expectations and realities and by engaging widely with others to draw on good practice and enhance knowledge.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CELL(\"contents\",Q41)>0,P41,\"--\")","v":"--"},null,"Average Indicator score"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P40","v":"--"},null,"Statement score"]
[]
[null,null,"Target",null,"Indicator","NOT AT ALL","PARTIALLY","SUFFICIENTLY","FULLY",null,null,null,null,"Punteggio indicatore",null,"Indicator score",null,null,null,"Target score",null,"Not at all - We are aware of the key issues but not planning nor action is taken."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Partially - We acknowledge the key issues and designing answers, but only limited actions is taken."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sufficiently - We have well developed plans and activities to address key issues with significant examples of implementation.                                                                                                                                                                                            Fully - We can show clear evidence of good practices which are monitored and integrated in our interventions."]
[null,"12.1"," A climate favourable to adaptions, to changes of context and external environment and to the peoples’ needs and preferences, as well as to cultural change, based on flexibility, self-evaluation, and continuous learning, is created within public institutions in the interest of achieving better results.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J9:M9,J14:M14)","v":0},{"$f":"(((R8-(2))*(1-0))/(8-(2)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",U8)>0,S8,\"\")","v":""},{"$f":"COUNTIF(F9:I14,\"x\")","v":0},"Suggested evidences"]
[null,null,null,"12.1.1","Comprehensive guidelines for conducting regular self-evaluations, fostering decision-making flexibility, and implementing continuous learning mechanisms established / adopted.",null,null,null,null,{"$f":"IF(F9=\"x\",1,0)","v":0},{"$f":"IF(G9=\"x\",2,0)","v":0},{"$f":"IF(H9=\"x\",3,0)","v":0},{"$f":"IF(I9=\"x\",4,0)","v":0},{"$f":"SUM(J9:M9)","v":0},{"$f":"(((N9-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q9)>0,O9,\"--\")","v":"--"},{"$f":"COUNTIF(F9:I9,\"x\")","v":0},null,null,null,null,"Reports/studies on Human Impact Assessment at local level."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Collaboration with human rights organisations and external stakeholders in initiatives, projects, etc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reports or statements of integration/update of policies, highlighting specific changes that were implemented based on the assessment findings."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Records of initiatives promoting innovation in environmental sustainability."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,null,null,"12.1.2","Innovation and openness promoted through capacity-building initiatives, encompassing change management and cultural competence programmes.",null,null,null,null,{"$f":"IF(F14=\"x\",1,0)","v":0},{"$f":"IF(G14=\"x\",2,0)","v":0},{"$f":"IF(H14=\"x\",3,0)","v":0},{"$f":"IF(I14=\"x\",4,0)","v":0},{"$f":"SUM(J14:M14)","v":0},{"$f":"(((N14-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q14)>0,O14,\"--\")","v":"--"},{"$f":"COUNTIF(F14:I14,\"x\")","v":0},null,null,null,null,"Capacity-Building Programme Documentation."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Innovation Success Stories."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Staff Surveys and Feedback."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Documentation of staff proposals and implementations of environmental innovations."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,"12.2","The local authority engages in knowledge-sharing with other public and private actors as well as with civil society, at all levels, including internationally.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J20:M20,J25:M25)","v":0},{"$f":"(((R19-(2))*(1-0))/(8-(2)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",U19)>0,S19,\"\")","v":""},{"$f":"COUNTIF(F20:I25,\"x\")","v":0}]
[null,null,null,"12.2.1","Cross-sector knowledge exchanges organised regularly with other public and private actors, civil society organizations, including environmental organisations,  and experts.",null,null,null,null,{"$f":"IF(F20=\"x\",1,0)","v":0},{"$f":"IF(G20=\"x\",2,0)","v":0},{"$f":"IF(H20=\"x\",3,0)","v":0},{"$f":"IF(I20=\"x\",4,0)","v":0},{"$f":"SUM(J20:M20)","v":0},{"$f":"(((N20-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q20)>0,O20,\"--\")","v":"--"},{"$f":"COUNTIF(F20:I20,\"x\")","v":0},null,null,null,null,"Knowledge Exchange Reports."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Collaborative Project Agreements."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Insights from participants in knowledge exchange activities."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Records of best practices in environmental sustainability being identified and evaluated."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,null,null,"12.2.2","The local authority develops and participates in international partnerships and projects,\nwith the aim of bringing valuable international knowledge and experience to the benefit of the local community. ",null,null,null,null,{"$f":"IF(F25=\"x\",1,0)","v":0},{"$f":"IF(G25=\"x\",2,0)","v":0},{"$f":"IF(H25=\"x\",3,0)","v":0},{"$f":"IF(I25=\"x\",4,0)","v":0},{"$f":"SUM(J25:M25)","v":0},{"$f":"(((N25-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q25)>0,O25,\"--\")","v":"--"},{"$f":"COUNTIF(F25:I25,\"x\")","v":0},null,null,null,null,"Documentation of international partnership projects."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reports on international partnerships' local impact."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statements from international partners on collaborations."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Policies and incentives to drive creation of environmentally conscious initiatives."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,"12.3","The local authority can identify, adapt, and implement successful practices so as to innovate in terms of knowledge, institutional settings, management, tools, and methodologies whenever needed.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J31:M31,J36:M36)","v":0},{"$f":"(((R30-(2))*(1-0))/(8-(2)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",U30)>0,S30,\"\")","v":""},{"$f":"COUNTIF(F31:I36,\"x\")","v":0}]
[null,null,null,"12.3.1","Inter-departmental cooperation promoted to develop and implement innovative solutions.",null,null,null,null,{"$f":"IF(F31=\"x\",1,0)","v":0},{"$f":"IF(G31=\"x\",2,0)","v":0},{"$f":"IF(H31=\"x\",3,0)","v":0},{"$f":"IF(I31=\"x\",4,0)","v":0},{"$f":"SUM(J31:M31)","v":0},{"$f":"(((N31-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q31)>0,O31,\"--\")","v":"--"},{"$f":"COUNTIF(F31:I31,\"x\")","v":0},null,null,null,null,"Cross-Departmental Project Case Studies."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Records of meetings fostering cross-departmental collaboration."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Staff feedback on cross-departmental cooperation experiences."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Records of best practices in environmental sustainability being identified and evaluated."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,null,null,"12.3.2","Local community members, businesses, and organisations offered a platform to propose innovative solutions or practices to address specific local challenges or improve services, including addressing environmental issues. ",null,null,null,null,{"$f":"IF(F36=\"x\",1,0)","v":0},{"$f":"IF(G36=\"x\",2,0)","v":0},{"$f":"IF(H36=\"x\",3,0)","v":0},{"$f":"IF(I36=\"x\",4,0)","v":0},{"$f":"SUM(J36:M36)","v":0},{"$f":"(((N36-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q36)>0,O36,\"--\")","v":"--"},{"$f":"COUNTIF(F36:I36,\"x\")","v":0},null,null,null,null,"Records of community-sourced innovative proposals."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Examples of community-inspired innovations in action."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Feedback on community involvement in innovation."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,null,"How much do you agree with the following statement?",null,"Our local authority is fully committed to the Principle of Openness to Change and Innovation as a fundamental aspect of our governance approach. We actively promote a culture of readiness for change and innovation among our government, public institutions, and public officials. Embracing new ideas and approaches, we continuously seek ways to enhance the resilience and quality of our public services. We understand the importance of evolving with changing expectations and realities and actively engage with others to draw on good practices and enhance knowledge. Our dedication to openness and innovation is a testament to our commitment to providing the best possible services to our community, adapting to meet their evolving needs.",null,null,null,null,{"$f":"IF(F40=\"x\",1,0)","v":0},{"$f":"IF(G40=\"x\",2,0)","v":0},{"$f":"IF(H40=\"x\",3,0)","v":0},{"$f":"IF(I40=\"x\",4,0)","v":0},{"$f":"SUM(J40:M40)","v":0},{"$f":"(((N40-(1))*(1-0))/(4-(1)))+0","v":-0.33333333333333331},{"$f":"IF(CELL(\"contents\",Q40)>0,O40,\"--\")","v":"--"},{"$f":"COUNTIF(F40:I40,\"x\")","v":0},{"$f":"T2*T3","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average",{"$f":"AVERAGE(P9,P14,P20,P25,P31,P36)","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(F9:I36,\"x\")","v":0}]