{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Inici","Enquesta","Avaluació"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":27,"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":"Inici","index":0,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[[13,1,14,6],[18,3,18,6],[16,1,16,2],[18,1,18,2],[0,2,0,5],[2,1,2,6],[15,1,15,6],[16,3,16,6],[4,1,4,6],[6,1,7,6],[9,1,11,6]]}
[null,null,"Managers:\nDevelopment Cooperation Office. Department of International Affairs\nPlanning and Evaluation Service. Directorate of Corporate Strategy and Local Consensus Building"]
[]
[null,"Tool for self-evaluating the transversality of municipal development cooperation strategies"]
[]
[null,"           Before taking the test, we recommend entering the name of the City Council and the person(s) taking the self-evaluation. "]
[]
[null,"           To get started, click on the \"Test\" button. A list of 35 headings will be shown, grouped by dimensions and topics, which you must check off according to the estimated level of accomplishment: \"Null\", \"Low\", \"Medium\" or \"High\". It is important that you review the 35 headings and fill them in."]
[]
[]
[null,"Once the test has been taken, click on the \"Result\" button. This will generate a report with the summary grouped by dimensions and topics, and with an evaluation relative to the degree of accomplishment. If you score under 80% for any block, we recommend identifying the negative checkpoints with a view to implementing the appropriate improvements. We also recommend reviewing the key points that have not been rated positively in the summary. "]
[]
[]
[]
[null,"           You can save this report as a PDF and then, if necessary, print it. Reports are saved with the corresponding date so that several can be made over time and can be compared. By clicking \"Start New Test\", the initial values are reset. "]
[]
[]
[null,"City Council:"]
[]
[null,"Name and surname of the person taking the test:"]

{"sheet":"Enquesta","index":1,"n_rows":40,"n_cols":57,"rows_kept":40,"cut":false,"hidden":true,"merged":[[2,30,2,32],[2,39,2,41],[2,25,2,28],[2,36,2,37],[36,13,36,14],[31,13,31,14],[2,13,3,14],[4,13,4,14],[5,13,5,14],[6,13,6,14],[7,13,7,14],[8,13,8,14],[9,13,9,14],[10,13,10,14],[11,13,11,14],[12,13,12,14],[2,20,2,23],[23,13,23,14],[24,13,24,14],[25,13,25,14],[26,3,27,3],[26,13,26,14],[27,13,27,14],[13,13,13,14],[21,13,21,14],[22,13,22,14],[20,13,20,14],[14,13,14,14],[15,13,15,14],[16,13,16,14],[18,13,18,14],[2,3,3,3],[32,1,38,1],[32,2,36,2],[32,3,33,3],[32,13,32,14],[33,13,33,14],[34,3,35,3],[34,13,34,14],[35,13,35,14],[37,2,38,2],[37,13,37,14],[38,13,38,14],[29,13,29,14],[30,2,31,2],[4,1,17,1],[2,7,3,7],[2,8,3,8],[2,4,3,5],[23,1,31,1],[23,2,25,2],[28,2,29,2],[26,2,27,2],[17,13,17,14],[30,13,30,14],[19,13,19,14],[28,13,28,14],[0,2,0,6],[2,6,3,6],[4,2,5,2],[1,1,1,12],[18,1,22,1],[2,9,2,12],[6,2,8,2],[2,1,3,1],[2,2,3,2],[18,2,22,2],[9,2,11,2],[18,3,19,3],[14,3,15,3],[14,2,17,2],[12,2,13,2],[20,3,21,3]]}
[null,null,"Managers:\nDevelopment Cooperation Office. Department of International Affairs\nPlanning and Evaluation Service. Directorate of Corporate Strategy and Local Consensus Building"]
[null,"Tool for self-evaluating the transversality of municipal development cooperation strategies (DC)"]
[null,"Dimension","Topic","Item","Heading",null,"Example","Element crític","Ponderació","Degree of accomplishment",null,null,null,"Observacions",null,null,null,null,null,null,"VALORS",null,null,null,null,"COMPLIMENTS",null,null,null,null,"CRITICS VAL",null,null,null,null,null,"CRITICS COM",null,null,"CRITICS_COM"]
[null,null,null,null,null,null,null,null,null,"Null","Low","Medium","High",null,null,null,null,null,null,null,"R","I","T","D",null,"R","I","T","D",null,"R","T","D",null,null,null,"T","D",null,"R","T","D",null,"CRITICS_NO_COMP"]
[null,"1. Strong leadership, commitment to\n     continuity and political and\n     strategic framework","Mandate plan","DC Participation ",1,"The City Council's DC Department participates in designing the Mandate Plan.",null,null,0.33339999999999997,"l",null,null,null,null,null,"D1","T1","I1","R1",null,{"$f":"(0*ISTEXT(J5)+1/3*ISTEXT(K5)+2/3*ISTEXT(L5)+1*ISTEXT(M5)) *I5","v":0},{"$f":"SUMIFS($U$5:$U$39,$R$5:$R$39,R5)","v":0},{"$f":"SUMIFS($U$5:$U$39,$Q$5:$Q$39,Q5)","v":0},{"$f":"SUMIFS($U$5:$U$39,$P$5:$P$39,P5)","v":0},null,{"$f":"U5/SUMIFS($I$5:$I$39,$S$5:$S$39,S5)","v":0},{"$f":"V5/SUMIFS($I$5:$I$39,$R$5:$R$39,R5)","v":0},{"$f":"W5/SUMIFS($I$5:$I$39,$Q$5:$Q$39,Q5)","v":0},{"$f":"X5/SUMIFS($I$5:$I$39,$P$5:$P$39,P5)","v":0},null,{"$f":"1*(H5=\"Sí\")","v":0},{"$f":"COUNTIFS($H$5:$H$39,\"Sí\",$Q$5:$Q$39,Q5)","v":1},{"$f":"COUNTIFS($H$5:$H$39,\"Sí\",$P$5:$P$39,P5)","v":9},null,{"$f":"U5/I5","v":0},null,{"$f":"COUNTIFS($H$5:$H$39,\"Sí\",$Q$5:$Q$39,Q5,$AI$5:$AI$39,\">=0,5\")/AF5","v":0},{"$f":"COUNTIFS($H$5:$H$39,\"Sí\",$P$5:$P$39,P5,$AI$5:$AI$39,\">=0,5\")/AG5","v":0},null,{"$f":"1*(AI5>=0.5)","v":0},{"$f":"COUNTIFS($H$5:$H$39,\"Sí\",$Q$5:$Q$39,Q5,$AI$5:$AI$39,\">=0,5\")","v":0},{"$f":"COUNTIFS($H$5:$H$39,\"Sí\",$P$5:$P$39,P5,$AI$5:$AI$39,\">=0,5\")","v":0},null,{"$f":"IF(AND(AE5=1,AE5<>AN5),P5 & \" - \" & F5,\"\")","v":""},null,0,"Unfortunatelly you have not reached the points that verify the transversality of the municipal development cooperation strategies."]
[null,null,null,"Shared values, vision and commitment",2,"The Mandate Plan shares values, vision and commitment to the DC policy.",null,"Sí",0.66659999999999997,"l",null,null,null,null,null,"D1","T1","I2","R2",null,{"$f":"(0*ISTEXT(J6)+1/3*ISTEXT(K6)+2/3*ISTEXT(L6)+1*ISTEXT(M6)) *I6","v":0},{"$f":"SUMIFS($U$5:$U$39,$R$5:$R$39,R6)","v":0},{"$f":"SUMIFS($U$5:$U$39,$Q$5:$Q$39,Q6)","v":0},{"$f":"SUMIFS($U$5:$U$39,$P$5:$P$39,P6)","v":0},null,{"$f":"U6/SUMIFS($I$5:$I$39,$S$5:$S$39,S6)","v":0},{"$f":"V6/SUMIFS($I$5:$I$39,$R$5:$R$39,R6)","v":0},{"$f":"W6/SUMIFS($I$5:$I$39,$Q$5:$Q$39,Q6)","v":0},{"$f":"X6/SUMIFS($I$5:$I$39,$P$5:$P$39,P6)","v":0},null,{"$f":"1*(H6=\"Sí\")","v":1},{"$f":"COUNTIFS($H$5:$H$39,\"Sí\",$Q$5:$Q$39,Q6)","v":1},{"$f":"COUNTIFS($H$5:$H$39,\"Sí\",$P$5:$P$39,P6)","v":9},null,{"$f":"U6/I6","v":0},null,0,0,null,{"$f":"1*(AI6>=0.5)","v":0},{"$f":"COUNTIFS($H$5:$H$39,\"Sí\",$Q$5:$Q$39,Q6,$AI$5:$AI$39,\">=0,5\")","v":0},{"$f":"COUNTIFS($H$5:$H$39,\"Sí\",$P$5:$P$39,P6,$AI$5:$AI$39,\">=0,5\")","v":0},null,{"$f":"IF(AND(AE6=1,AE6<>AN6),P6 & \" - \" & F6,\"\")","v":"D1 - The Mandate Plan shares values, vision and commitment to the DC policy."},null,0.4,"You have fulfilled the points that verify the transversality of the municipal development cooperation strategies. Nonetheless, it is necessary to review of the key points without a positive verification.",null,null,null,null,null,null,null,null,null,"1, 2/3 , 1/3 0"]
[null,null,"Master Plan for Development Cooperation","Identifying the actors involved",3,"The Master Plan for DC clearly sets out all the actors involved.","International, youth, education, equality and other sectoral policies, and some internal services (such as those responsible for communication and press, monitoring and transparency, etc.) ",null,0.2,"l",null,null,null,null,null,"D1","T2","I3","R3",null,0,0,0,0,null,0,0,0,0,null,0,2,9,null,0,null,0,0,null,0,0,0,null,"",null,0.6,"You have fulfilled the points that verify the transversality of the municipal development cooperation strategies. The key points without a positive verification can be improved."]
[null,null,null,"Participation of the actors involved",4,"The Master Plan for DC integrates all the actors involved in the outlining of their priorities.","International, youth, education, equality and other sectoral policies, and some internal services (such as those responsible for communication and press, monitoring and transparency, etc.) ","Sí",0.4,"l",null,null,null,null,null,"D1","T2","I4","R4",null,0,0,0,0,null,0,0,0,0,null,1,2,9,null,0,null,0,0,null,0,0,0,null,"D1 - The Master Plan for DC integrates all the actors involved in the outlining of their priorities.",null,0.8,"Congratulations! You have achieved with profit the points that verify the transversality of the municipal development cooperation strategies."]
[null,null,null,"Shared goals, values, vision and commitment",5,"The Master Plan for DC shares goals, values, vision and commitment with the participating actors.","International, youth, education, equality and other sectoral policies, and some internal services (such as those responsible for communication and press, monitoring and transparency, etc.) ","Sí",0.4,"l",null,null,null,null,null,"D1","T2","I5","R5",null,0,0,0,0,null,0,0,0,0,null,1,2,9,null,0,null,0,0,null,0,0,0,null,"D1 - The Master Plan for DC shares goals, values, vision and commitment with the participating actors.",null,0,2,"xlThemeColorLight1"]
[null,null,"Other sectoral policies","Internal awareness",6,"Awareness-raising and training actions have been planned with a view to other sectoral policies incorporating DC objectives, values, vision and commitment.","International, youth, education, equality and other sectoral policies, and some internal services (such as those responsible for communication and press, monitoring and transparency, etc.) ","Sí",0.4,"l",null,null,null,null,null,"D1","T3","I6","R6",null,0,0,0,0,null,0,0,0,0,null,1,2,9,null,0,null,0,0,null,0,0,0,null,"D1 - Awareness-raising and training actions have been planned with a view to other sectoral policies incorporating DC objectives, values, vision and commitment.",null,0.4,6,"xlThemeColorAccent2"]
[null,null,null,"Shared goals, values, vision and commitment ",7,"The plans of other sectoral policies share objectives, values, vision and commitment with that of DC.","International, youth, education, equality and other sectoral policies, and some internal services (such as those responsible for communication and press, monitoring and transparency, etc.) ","Sí",0.4,"l",null,null,null,null,null,"D1","T3","I7","R7",null,0,0,0,0,null,0,0,0,0,null,1,2,9,null,0,null,0,0,null,0,0,0,null,"D1 - The plans of other sectoral policies share objectives, values, vision and commitment with that of DC.",null,0.6,10,"xlThemeColorAccent6"]
[null,null,null,"Complementarity and synergies",8,"The plans of other sectoral policies provide for mechanisms of complementarity and synergies with the DC.","International, youth, education, equality and other sectoral policies, and some internal services (such as those responsible for communication and press, monitoring and transparency, etc.) ",null,0.2,"l",null,null,null,null,null,"D1","T3","I8","R8",null,0,0,0,0,null,0,0,0,0,null,0,2,9,null,0,null,0,0,null,0,0,0,null,"",null,0.8,7,"xlThemeColorAccent3"]
[null,null,"Human and financial resources","Human resources",9,"The DC policy has sufficient planned human resources, whether they are spread out over one department or across several, to drive the planned actions.",null,"Sí",0.5,"l",null,null,null,null,null,"D1","T4","I9","R9",null,0,0,0,0,null,0,0,0,0,null,1,2,9,null,0,null,0,0,null,0,0,0,null,"D1 - The DC policy has sufficient planned human resources, whether they are spread out over one department or across several, to drive the planned actions."]
[null,null,null,"Financial resources",10,"The DC policy has sufficient financial resources, whether they are spread out over one department or across several, to drive the planned actions.",null,"Sí",0.5,"l",null,null,null,null,null,"D1","T4","I10","R10",null,0,0,0,0,null,0,0,0,0,null,1,2,9,null,0,null,0,0,null,0,0,0,null,"D1 - The DC policy has sufficient financial resources, whether they are spread out over one department or across several, to drive the planned actions."]
[null,null,"Monitoring                             and transparency","Information and monitoring systems",11,"The DC policy has been incorporated into the city council's general monitoring system.","Internal services responsible for monitoring and evaluating the Government Plan",null,0.2,"l",null,null,null,null,null,"D1","T5","I11","R11",null,0,0,0,0,null,0,0,0,0,null,0,2,9,null,0,null,0,0,null,0,0,0,null,""]
[null,null,null,null,12,"The DC policy has developed its own monitoring system with indicators involving other actors.","International, youth, education, equality and other sectoral policies","Sí",0.4,"l",null,null,null,null,null,"D1","T5","I11","R12",null,0,0,0,0,null,0,0,0,0,null,1,2,9,null,0,null,0,0,null,0,0,0,null,"D1 - The DC policy has developed its own monitoring system with indicators involving other actors.",null,0,"Congratulations! You have achieved with profit all the key points."]
[null,null,null,"Documentation and evaluation mechanisms",13,"During the roll-out of the DC policy, all actors are informed of the progress of the DC policy or the progress is documented.","International, youth, education, equality and other sectoral policies",null,0.2,"l",null,null,null,null,null,"D1","T5","I12","R13",null,0,0,0,0,null,0,0,0,0,null,0,2,9,null,0,null,0,0,null,0,0,0,null,"",null,1,{"$f":"\"There are  \" & NUM_CRITICS_KO & \" key points without a positive verification that are recommended to attain with special interest. They are the following:\"","v":"There are  20 key points without a positive verification that are recommended to attain with special interest. They are the following:"}]
[null,null,null,"Transparency",14,"Municipal transparency instruments make it possible to identify the results and monitor the DC policy.","Publication of the results of the DC policy on the transparency portal","Sí",0.4,"l",null,null,null,null,null,"D1","T5","I13","R14",null,0,0,0,0,null,0,0,0,0,null,1,2,9,null,0,null,0,0,null,0,0,0,null,"D1 - Municipal transparency instruments make it possible to identify the results and monitor the DC policy."]
[null,"2. Political and strategic dialogue","Relationship between actors","Formal relationship channels",15,"Shared workspaces have been launched to drive the DC policy.","Cooperation council, regular meetings, commissions and/or working groups, space for channelling information, etc.","Sí",0.5,"l",null,null,null,null,null,"D2","T6","I14","R15",null,0,0,0,0,null,0,0,0,0,null,1,3,3,null,0,null,0,0,null,0,0,0,null,"D2 - Shared workspaces have been launched to drive the DC policy."]
[null,null,null,null,16,"The workspaces created have worked according to the forecast (timeliness, frequency, usefulness).","Cooperation council, regular meetings, commissions and/or working groups, space for channelling information, etc.","Sí",0.5,"l",null,null,null,null,null,"D2","T6","I14","R16",null,0,0,0,0,null,0,0,0,0,null,1,3,3,null,0,null,0,0,null,0,0,0,null,"D2 - The workspaces created have worked according to the forecast (timeliness, frequency, usefulness)."]
[null,null,null,"Informal channels",17,"Informal channels for relationships between actors have been set up. ","Working lunch, telephone or e-mail communications, conversations in other spaces, etc.",null,0.5,"l",null,null,null,null,null,"D2","T6","I15","R17",null,0,0,0,0,null,0,0,0,0,null,0,3,3,null,0,null,0,0,null,0,0,0,null,{"$f":"IF(AND(AE21=1,AE21<>AN21),P21 & \" - \" & F21,\"\")","v":""}]
[null,null,null,null,18,"Informal channels make it possible to improve the roll-out of the DC policy.","Working lunch, telephone or e-mail communications, conversations in other spaces, etc.",null,0.5,"l",null,null,null,null,null,"D2","T6","I15","R18",null,0,0,0,0,null,0,0,0,0,null,0,3,3,null,0,null,0,0,null,0,0,0,null,""]
[null,null,null,"Challenges",19,"As a result of formal or informal mechanisms, new challenges that were not initially foreseen have been set out.","Working together has made it possible to identify unforeseen groups.","Sí",1,"l",null,null,null,null,null,"D2","T6","I16","R19",null,0,0,0,0,null,0,0,0,0,null,1,3,3,null,0,null,0,0,null,0,0,0,null,"D2 - As a result of formal or informal mechanisms, new challenges that were not initially foreseen have been set out."]
[null,"3. Implementation of guidelines\n   and tools, human and financial \n   resources","Implementation of guidelines and programmes","Implementation of programmes",20,"The different programmes and activities set forth in the DC policy are conducted with the actors involved.",null,"Sí",0.5,"l",null,null,null,null,null,"D3","T7","I17","R20",null,0,0,0,0,null,0,0,0,0,null,1,1,4,null,0,null,0,0,null,0,0,0,null,"D3 - The different programmes and activities set forth in the DC policy are conducted with the actors involved."]
[null,null,null,"Communication of ongoing activities",21,"Communication and the transfer of information in the roll-out flow in an agile and agreed manner between the actors involved.",null,null,0.25,"l",null,null,null,null,null,"D3","T7","I18","R21",null,0,0,0,0,null,0,0,0,0,null,0,1,4,null,0,null,0,0,null,0,0,0,null,""]
[null,null,null,"Opinions of specialists",22,"The roll-out of the programmes and the lines of action combine sectoral experts and specialised DC technicians.",null,null,0.25,"l",null,null,null,null,null,"D3","T7","I19","R22",null,0,0,0,0,null,0,0,0,0,null,0,1,4,null,0,null,0,0,null,0,0,0,null,""]
[null,null,"Human resources","Human resources",23,"Programmes and lines of action are executed with sufficient human resources.",null,"Sí",0.5,"l",null,null,null,null,null,"D3","T8","I20","R23",null,0,0,0,0,null,0,0,0,0,null,1,2,4,null,0,null,0,0,null,0,0,0,null,"D3 - Programmes and lines of action are executed with sufficient human resources."]
[null,null,null,null,24,"The human resources engaged in rolling out the actions have adequate knowledge and skills.",null,"Sí",0.5,"l",null,null,null,null,null,"D3","T8","I20","R24",null,0,0,0,0,null,0,0,0,0,null,1,2,4,null,0,null,0,0,null,0,0,0,null,"D3 - The human resources engaged in rolling out the actions have adequate knowledge and skills."]
[null,null,"Incentives and motivation","Employment incentives",25,"The human resources involved in DC projects have recognised incentives.","They have been reassigned from other tasks to engage in international projects; the new project or task in the field of DC is useful and may lead to the creation of synergies with the ordinary work that is already being carried out, etc.",null,0.5,"l",null,null,null,null,null,"D3","T9","I21","R25",null,0,0,0,0,null,0,0,0,0,null,0,0,4,null,0,null,{"$error":"#DIV/0!"},0,null,0,0,0,null,""]
[null,null,null,"Recognition",26,"The human resources involved in DC projects gain recognition.","They are likely to appear in publications, training, travel within the framework of international projects, presentation of awards and/or seminars and conferences (such as good practices), etc.",null,0.5,"l",null,null,null,null,null,"D3","T9","I22","R26",null,0,0,0,0,null,0,0,0,0,null,0,0,4,null,0,null,{"$error":"#DIV/0!"},0,null,0,0,0,null,""]
[null,null,"Financial resources","Intangible",27,"The human resources involved in DC projects perceive their participation as a tool for learning and personal satisfaction.",null,"Sí",0.66659999999999997,"l",null,null,null,null,null,"D3","T10","I23","R27",null,0,0,0,0,null,0,0,0,0,null,1,1,4,null,0,null,0,0,null,0,0,0,null,"D3 - The human resources involved in DC projects perceive their participation as a tool for learning and personal satisfaction."]
[null,null,null,"Financial resources",28,"Programmes and lines of action are executed with sufficient financial resources.",null,null,0.33339999999999997,"l",null,null,null,null,null,"D3","T10","I24","R28",null,0,0,0,0,null,0,0,0,0,null,0,1,4,null,0,null,0,0,null,0,0,0,null,{"$f":"IF(AND(AE32=1,AE32<>AN32),P32 & \" - \" & F32,\"\")","v":""}]
[null,"4. Accountability\n   and learning culture","Improvement and redefinition","Documentation and evaluation mechanisms",29,"During the roll-out of the actions or intervention of the DC policy, channels for the documentation and evaluation of the results involving all the actors are foreseen.","International, youth, education, equality and other sectoral policies",null,0.33339999999999997,"l",null,null,null,null,null,"D4","T11","I25","R29",null,0,0,0,0,null,0,0,0,0,null,0,3,4,null,0,null,0,0,null,0,0,0,null,""]
[null,null,null,null,30,"Once the DC policy has been rolled out, channels for the documentation and evaluation of the results involving all the actors are foreseen.","International, youth, education, equality and other sectoral policies","Sí",0.66659999999999997,"l",null,null,null,null,null,"D4","T11","I25","R30",null,0,0,0,0,null,0,0,0,0,null,1,3,4,null,0,null,0,0,null,0,0,0,null,"D4 - Once the DC policy has been rolled out, channels for the documentation and evaluation of the results involving all the actors are foreseen."]
[null,null,null,"Orientation of challenges and opportunities",31,"During the roll-out of the actions or interventions of the DC policy, all the actors are made aware of the challenges and opportunities for improvement detected.","International, youth, education, equality and other sectoral policies",null,0.33339999999999997,"l",null,null,null,null,null,"D4","T11","I26","R31",null,0,0,0,0,null,0,0,0,0,null,0,3,4,null,0,null,0,0,null,0,0,0,null,""]
[null,null,null,null,32,"At the end of the DC policy roll-out, all actors are made aware of the challenges and opportunities for improvement detected.","International, youth, education, equality and other sectoral policies","Sí",0.66659999999999997,"l",null,null,null,null,null,"D4","T11","I26","R32",null,0,0,0,0,null,0,0,0,0,null,1,3,4,null,0,null,0,0,null,0,0,0,null,"D4 - At the end of the DC policy roll-out, all actors are made aware of the challenges and opportunities for improvement detected."]
[null,null,null,"Improvement strategy",33,"Specific future-oriented improvement actions are jointly set out.",null,"Sí",1,"l",null,null,null,null,null,"D4","T11","I27","R33",null,0,0,0,0,null,0,0,0,0,null,1,3,4,null,0,null,0,0,null,0,0,0,null,"D4 - Specific future-oriented improvement actions are jointly set out."]
[null,null,"Accountability","Accountability before citizens",34,"Accountability of the results before citizens, whether jointly or in a coordinated manner between all the actors involved.",null,"Sí",0.66659999999999997,"l",null,null,null,null,null,"D4","T12","I28","R34",null,0,0,0,0,null,0,0,0,0,null,1,1,4,null,0,null,{"$f":"COUNTIFS($H$5:$H$39,\"Sí\",$Q$5:$Q$39,Q38,$AI$5:$AI$39,\">=0,5\")/AF38","v":0},{"$f":"COUNTIFS($H$5:$H$39,\"Sí\",$P$5:$P$39,P38,$AI$5:$AI$39,\">=0,5\")/AG38","v":0},null,0,0,0,null,"D4 - Accountability of the results before citizens, whether jointly or in a coordinated manner between all the actors involved."]
[null,null,null,"Shared responsibility",35,"The citizen-driven accountability exercise shares responsibilities for successes and failures.",null,null,0.33339999999999997,"l",null,null,null,null,null,"D4","T12","I29","R35",null,0,0,0,0,null,0,0,0,0,null,0,1,4,null,0,null,0,0,null,0,0,0,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(Z5:Z39)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"35-COUNTBLANK(AR5:AR39)","v":20}]

{"sheet":"Avaluació","index":2,"n_rows":121,"n_cols":9,"rows_kept":121,"cut":false,"hidden":true,"merged":[[92,2,92,6],[90,3,90,7],[84,2,84,7],[85,2,85,7],[86,2,86,7],[87,2,87,7],[88,2,88,7],[89,2,89,7],[69,2,69,7],[70,2,70,7],[71,2,71,7],[72,2,72,7],[83,2,83,7],[73,2,73,7],[74,2,74,7],[75,2,75,7],[76,2,76,7],[77,2,77,7],[78,2,78,7],[79,2,79,7],[80,2,80,7],[81,2,81,7],[82,2,82,7],[64,2,64,7],[65,2,65,7],[66,2,66,7],[67,2,67,7],[68,2,68,7],[58,2,58,7],[59,2,59,7],[60,2,60,7],[61,2,61,7],[62,2,62,7],[53,2,54,7],[57,2,57,7],[52,2,52,6],[56,2,56,7],[55,2,55,7],[23,2,23,4],[0,3,0,6],[1,2,1,14],[11,2,11,3],[0,1,0,2],[2,1,2,7],[12,2,13,7],[15,2,15,3],[19,2,19,4],[17,2,17,4],[21,2,21,4],[5,3,5,6],[7,3,7,6],[9,3,9,6]]}
[null,null,null,"Managers:\nDevelopment Cooperation Office. Department of International Affairs\nPlanning and Evaluation Service. Directorate of Corporate Strategy and Local Consensus Building"]
[]
[null,"Self-evaluating the transversality of municipal development cooperation strategies - Degree of accomplishment of the survey"]
[]
[]
[null,null,"City Council:",{"$f":"\"\"&ajuntament","v":""}]
[]
[null,null,"Name and surnames:",{"$f":"\"\"&nom_cognom","v":""}]
[]
[null,null,"Date:",{"$f":"NOW()","v":"2021-09-28T08:30:37.370"}]
[]
[null,null,"Degree of overall accomplishment ",null,null,{"$f":"MITJA_TOTAL","v":0},"l",{"$f":"VLOOKUP(F12,RANG_COLORS,2)","v":2}]
[null,null,{"$f":"VLOOKUP(MITJA_TOTAL,RANG_TEXT_MITJA_TOTAL,2)","v":"Unfortunatelly you have not reached the points that verify the transversality of the municipal development cooperation strategies."}]
[]
[]
[null,null,"Degree of accomplishment by dimensions"]
[]
[null,null,"1. Strong leadership, commitment to continuity and political and strategic framework",null,null,{"$f":"MITJA_DIM_1","v":0},"l",{"$f":"VLOOKUP(F18,RANG_COLORS,2)","v":2},{"$f":"PTG_CRITICS_D1","v":0}]
[]
[null,null,"2. Political and strategic dialogue",null,null,{"$f":"MITJA_DIM_2","v":0},"l",{"$f":"VLOOKUP(F20,RANG_COLORS,2)","v":2},{"$f":"PTG_CRITICS_D2","v":0}]
[]
[null,null,"3. Implementation of guidelines and tools, human and financial resources",null,null,{"$f":"MITJA_DIM_3","v":0},"l",{"$f":"VLOOKUP(F22,RANG_COLORS,2)","v":2},{"$f":"PTG_CRITICS_D3","v":0}]
[]
[null,null,"4. Accountability and learning culture",null,null,{"$f":"MITJA_DIM_4","v":0},"l",{"$f":"VLOOKUP(F24,RANG_COLORS,2)","v":2},{"$f":"PTG_CRITICS_D4","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Key points without a positive verification"]
[null,null,{"$f":"VLOOKUP(NUM_CRITICS_KO,RANG_CRITICS_TEXT,2)","v":"There are  20 key points without a positive verification that are recommended to attain with special interest. They are the following:"}]
[]
[null,null,"  D1 - The Mandate Plan shares values, vision and commitment to the DC policy."]
[null,null,"  D1 - The Master Plan for DC integrates all the actors involved in the outlining of their priorities."]
[null,null,"  D1 - The Master Plan for DC shares goals, values, vision and commitment with the participating actors."]
[null,null,"  D1 - Awareness-raising and training actions have been planned with a view to other sectoral policies incorporating DC objectives, values, vision and commitment."]
[null,null,"  D1 - The plans of other sectoral policies share objectives, values, vision and commitment with that of DC."]
[null,null,"  D1 - The DC policy has sufficient planned human resources, whether they are spread out over one department or across several, to drive the planned actions."]
[null,null,"  D1 - The DC policy has sufficient financial resources, whether they are spread out over one department or across several, to drive the planned actions."]
[null,null,"  D1 - The DC policy has developed its own monitoring system with indicators involving other actors."]
[null,null,"  D1 - Municipal transparency instruments make it possible to identify the results and monitor the DC policy."]
[null,null,"  D2 - Shared workspaces have been launched to drive the DC policy."]
[null,null,"  D2 - The workspaces created have worked according to the forecast (timeliness, frequency, usefulness)."]
[null,null,"  D2 - As a result of formal or informal mechanisms, new challenges that were not initially foreseen have been set out."]
[null,null,"  D3 - The different programmes and activities set forth in the DC policy are conducted with the actors involved."]
[null,null,"  D3 - Programmes and lines of action are executed with sufficient human resources."]
[null,null,"  D3 - The human resources engaged in rolling out the actions have adequate knowledge and skills."]
[null,null,"  D3 - The human resources involved in DC projects perceive their participation as a tool for learning and personal satisfaction."]
[null,null,"  D4 - Once the DC policy has been rolled out, channels for the documentation and evaluation of the results involving all the actors are foreseen."]
[null,null,"  D4 - At the end of the DC policy roll-out, all actors are made aware of the challenges and opportunities for improvement detected."]
[null,null,"  D4 - Specific future-oriented improvement actions are jointly set out."]
[null,null,"  D4 - Accountability of the results before citizens, whether jointly or in a coordinated manner between all the actors involved."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Accomplishment and key points by dimensions (graph)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Dimension","% Accomplishment ","% Accomplishment of key points"]
[null,null,{"$f":"C18","v":"1. Strong leadership, commitment to continuity and political and strategic framework"},{"$f":"F18","v":0},{"$f":"I18","v":0}]
[null,null,{"$f":"C20","v":"2. Political and strategic dialogue"},{"$f":"F20","v":0},{"$f":"I20","v":0}]
[null,null,{"$f":"C22","v":"3. Implementation of guidelines and tools, human and financial resources"},{"$f":"F22","v":0},{"$f":"I22","v":0}]
[null,null,{"$f":"C24","v":"4. Accountability and learning culture"},{"$f":"F24","v":0},{"$f":"I24","v":0}]