{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Home page","Self-Assesment","Sheet2","Results","Action Plan"],"not_rendered":{"charts":6,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Home page","index":0,"n_rows":51,"n_cols":41,"rows_kept":51,"cut":false,"hidden":false,"merged":[[0,40,1,40],[0,1,1,26],[3,2,8,31],[9,2,16,31]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end of page"]
[]
[]
[null,null,"Welcome to the Government Analytical Evaluation Capabilities Framework Interactive Tool"]
[]
[]
[]
[]
[]
[null,null,"This is an Excel based summary of the Evaluation Capabilities Framework, which aims to complement the slide version of the Framework by allowing you to self-assess your skills and knowledge gaps through rating your confidence in these areas.  You can complete a self-assessment of your level of capability and see this presented on a dashboard. There is also an Action Plan page for you to note your current skills and plan out how to build on your capabilities. \n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"end of page"]

{"sheet":"Self-Assesment","index":1,"n_rows":77,"n_cols":48,"rows_kept":77,"cut":false,"hidden":false,"merged":[[42,4,42,12],[13,13,14,29],[27,4,27,12],[28,4,28,12],[29,4,29,12],[22,4,22,12],[24,4,24,12],[25,4,25,12],[26,4,26,12],[16,4,16,12],[17,4,17,12],[18,4,18,12],[19,4,19,12],[20,4,20,12],[21,4,21,12],[23,4,23,12],[40,4,40,12],[41,4,41,12],[57,4,57,12],[44,4,44,12],[45,4,45,12],[46,4,46,12],[50,4,50,12],[51,4,51,12],[52,4,52,12],[53,4,53,12],[54,4,54,12],[55,4,55,12],[56,4,56,12],[47,4,47,12],[48,4,48,12],[49,4,49,12],[76,4,76,12],[70,4,70,12],[71,4,71,12],[72,4,72,12],[73,4,73,12],[74,4,74,12],[75,4,75,12],[69,4,69,12],[58,4,58,12],[59,4,59,12],[60,4,60,12],[61,4,61,12],[62,4,62,12],[63,4,63,12],[64,4,64,12],[65,4,65,12],[66,4,66,12],[67,4,67,12],[68,4,68,12],[38,2,39,3],[38,4,38,12],[16,2,18,3],[19,2,20,3],[24,2,25,3],[16,1,25,1],[26,1,30,1],[26,2,30,3],[36,2,37,3],[37,4,37,12],[30,4,30,12],[31,4,31,12],[32,4,32,12],[33,4,33,12],[35,4,35,12],[34,4,34,12],[31,2,33,3],[34,2,35,3],[16,39,17,41],[18,39,19,41],[20,39,21,41],[22,39,23,41],[24,39,25,41],[76,0,76,3],[0,47,2,55],[0,0,1,39],[21,2,23,3],[3,0,5,42],[7,1,10,41],[15,4,15,12],[15,1,15,3],[36,4,36,12],[43,4,43,12],[31,1,44,1],[34,39,35,41],[45,2,46,3],[47,2,50,3],[45,1,50,1],[42,2,43,3],[44,2,44,3],[40,2,41,3],[39,4,39,12],[38,39,39,41],[40,39,41,41],[42,39,43,41],[44,39,45,41],[26,39,27,41],[28,39,29,41],[30,39,31,41],[32,39,33,41],[36,39,37,41]]}
["Government Analytical Evaluation Capabilities Framework",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"End of assessment page"]
[]
[]
["Evaluation Manager Self-Assessment"]
[]
[]
[]
[null,"The assessment below and \"skill score\" (on the results page) are designed to help you think about your current evaluation capabilities and where you have strengths, or areas for development. For each statement select your level of experience: basic, working, detailed or expert knowledge. The results will help you think about where you might want to focus your learning and development. "]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"I would rate my current experience as…"]
[]
[null,"Skills area",null,null,"Evaluation skill or capability",null,null,null,null,null,null,null,null,"No knowledge or experience","T/F","Test","Score","Basic or limited  knowledge or experience","T/F","Test","Score","Working knowledge and practical experience ","T/F","Test","Score","Detailed knowledge and significant experience","T/F","Test","Score","Expert knowledge and experience","T/F","Test","Score","Test","Complete","More than 1?","Corrected Score","Section"]
[null,"Scoping","Understanding and communicating the rationale for evaluation",null,"Understands and champions the value of evaluation and how evaluation can support accountability, measure impact, and enable learning, and programme development.",null,null,null,null,null,null,null,null,null,false,{"$f":"IF(O17=TRUE,1,0)","v":0},{"$f":"P17*0","v":0},null,false,{"$f":"IF(S17=TRUE,1,0)","v":0},{"$f":"T17*1","v":0},null,false,{"$f":"IF(W17=TRUE,1,0)","v":0},{"$f":"X17*2","v":0},null,false,{"$f":"IF(AA17=TRUE,1,0)","v":0},{"$f":"AB17*3","v":0},null,false,{"$f":"IF(AE17=TRUE,1,0)","v":0},{"$f":"AF17*4","v":0},{"$f":"(IF(O17=TRUE,1,0))+(IF(S17=TRUE,1,0))+(IF(W17=TRUE,1,0))+(IF(AA17=TRUE,1,0))+(IF(AE17=TRUE,1,0))","v":0},{"$f":"IF(AH17>0,1,0)","v":0},{"$f":"IF(AH17>1,1,0)","v":0},{"$f":"(U17+Y17+AC17+AG17)","v":0},"S1","Please select only one option","Don't forget to answer every statement"]
[null,null,null,null,"Demonstrates knowledge and experience of a range of different methodological approaches to evaluating programmes and policies.",null,null,null,null,null,null,null,null,null,false,{"$f":"IF(O18=TRUE,1,0)","v":0},{"$f":"P18*0","v":0},null,false,{"$f":"IF(S18=TRUE,1,0)","v":0},{"$f":"T18*1","v":0},null,false,{"$f":"IF(W18=TRUE,1,0)","v":0},{"$f":"X18*2","v":0},null,false,{"$f":"IF(AA18=TRUE,1,0)","v":0},{"$f":"AB18*3","v":0},null,false,{"$f":"IF(AE18=TRUE,1,0)","v":0},{"$f":"AF18*4","v":0},{"$f":"(IF(O18=TRUE,1,0))+(IF(S18=TRUE,1,0))+(IF(W18=TRUE,1,0))+(IF(AA18=TRUE,1,0))+(IF(AE18=TRUE,1,0))","v":0},{"$f":"IF(AH18>0,1,0)","v":0},{"$f":"IF(AH18>1,1,0)","v":0},{"$f":"(U18+Y18+AC18+AG18)","v":0},"S1","Please select only one option"]
[null,null,null,null,"Defines research questions to address policy needs, and re-defines where necessary.",null,null,null,null,null,null,null,null,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,0,0,0,0,"S1","Please select only one option"]
[null,null,"Understanding the intervention and constructing a theory of change",null,"Can work with stakeholders to create a basic logic model, or theory of change, linking elements of the programme to observable outcomes.",null,null,null,null,null,null,null,null,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,0,0,0,0,"S2","Please select only one option"]
[null,null,null,null,"Uses the theory of change to guide evidence collection, analysis and interpretation of findings. ",null,null,null,null,null,null,null,null,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,0,0,0,0,"S2","Please select only one option"]
[null,null,"Identifying the right evaluation design for the policy",null,"Works closely with clients to identify evaluation purpose and requirements and ensures conscious and informed choices are made about level and type of evaluation design.",null,null,null,null,null,null,null,null,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,0,0,0,0,"S3","Please select only one option"]
[null,null,null,null,"Understands the range of methods which can be used to assess whether an intervention was effective in meeting its objectives, and can determine the most appropriate approach and methods for a particular evaluation.",null,null,null,null,null,null,null,null,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,0,0,0,0,"S3","Please select only one option","Don't forget to answer every statement"]
[null,null,null,null,"Ensure arrangements for access to monitoring data are in place (via the necessary data sharing agreements) to facilitate use of the data for monitoring and evaluation (e.g. linking and re-contact).",null,null,null,null,null,null,null,null,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,0,0,0,0,"S3","Please select only one option"]
[null,null,"Producing a proportionate and appropriate evaluation plan",null,"Designs evaluations for in-house work or commissioned projects and procures external evaluations where appropriate.",null,null,null,null,null,null,null,null,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,0,0,0,0,"S4","Please select only one option"]
[null,null,null,null,"Is able to develop, and consult on, high quality specification/ Terms of Reference to underpin evaluation.",null,null,null,null,null,null,null,null,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,0,0,0,0,"S4","Please select only one option"]
[null,"Leading and Management","Leading and management",null,"Demonstrates leadership and champions evaluation to maintain momentum and impact.",null,null,null,null,null,null,null,null,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,0,0,0,0,"L1","Please select only one option"]
[null,null,null,null,"Works collaboratively, manages relationships and supports others (e.g. contractors and colleagues) and works effectively across analytical disciplines.",null,null,null,null,null,null,null,null,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,0,0,0,0,"L1","Please select only one option"]
[null,null,null,null,"Is able to proactively influence stakeholders, and ensure buy in from less engaged evaluation users.",null,null,null,null,null,null,null,null,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,0,0,0,0,"L1","Please select only one option","Don't forget to answer every statement"]
[null,null,null,null,"Builds a culture of evaluation, learning and transparency into the policy and analytical teams they work in.",null,null,null,null,null,null,null,null,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,0,0,0,0,"L1","Please select only one option"]
[null,null,null,null,"Identifies and sets up appropriate governance and project management structures for input and quality assurance of evaluation products.",null,null,null,null,null,null,null,null,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,0,0,0,0,"L1","Please select only one option"]
[null,"Methods of Data Collection and Analysis","Use of monitoring and administrative data",null,"Understands the importance and role of using monitoring data in an evaluation, and when and how to use it.",null,null,null,null,null,null,null,null,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,0,0,0,0,"M1","Please select only one option"]
[null,null,null,null,"Is aware of legal, ethical and practical issues in ensuring programme monitoring (and other) data is collected and used effectively.",null,null,null,null,null,null,null,null,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,0,0,0,0,"M1","Please select only one option"]
[null,null,null,null,"Identifies sources and weighs up strengths and weaknesses of data and key metrics to help answer key evaluation questions.",null,null,null,null,null,null,null,null,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,0,0,0,0,"M1","Please select only one option"]
[null,null,"Methods of primary research and analysis",null,"Has a robust knowledge of qualitative and quantitative data collection and data analysis methodologies, and is able to demonstrate practical application of these, knowing how to design and apply specific methods.",null,null,null,null,null,null,null,null,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,0,0,0,0,"M2","Please select only one option","Don't forget to answer every statement"]
[null,null,null,null,"Ensures necessary quality assurance processes are built into data collection and analysis methods at appropriate stages.",null,null,null,null,null,null,null,null,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,0,0,0,0,"M2","Please select only one option"]
[null,null,"Process evaluation ",null,"Understands the value and role of process evaluation, and its link to monitoring and to impact evaluation, to understand how a programme is working and why.",null,null,null,null,null,null,null,null,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,0,0,0,0,"M3","Please select only one option"]
[null,null,null,null,"Times process evaluation deliverables to coincide with best opportunities to have impact. Identifies, and builds in, suitable interim products.",null,null,null,null,null,null,null,null,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,0,0,0,0,"M3","Please select only one option"]
[null,null,"Theory based methods to impact evaluation",null,"Is familiar with specific methods (e.g. contribution analysis, realist evaluation, process tracing, qualitative comparative analysis) and their appropriateness for addressing different evaluation questions. ",null,null,null,null,null,null,null,null,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,0,0,0,0,"M4","Please select only one option"]
[null,null,null,null,"Ensures theory based methods have robust approaches to testing hypotheses and causal claims.",null,null,null,null,null,null,null,null,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,0,0,0,0,"M4","Please select only one option"]
[null,null,"Experimental approaches to impact evaluation",null,"Appreciates the importance of the counterfactual and control groups in identifying attribution. ",null,null,null,null,null,null,null,null,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,0,0,0,0,"M5","Please select only one option","Don't forget to answer every statement"]
[null,null,null,null,"Can apply experimental or quasi-experimental methods for attributing impacts.",null,null,null,null,null,null,null,null,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,0,0,0,0,"M5","Please select only one option"]
[null,null,"Value for money evaluation",null,"Has a good understanding of the HMT Green Book guidance on economic appraisal, cost benefit analysis, and requirements for consideration of monitoring and evaluation throughout the project cycle.",null,null,null,null,null,null,null,null,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,0,0,0,0,"M6","Please select only one option"]
[null,null,null,null,"Understands economic approaches to project appraisal and evaluation, including different ways of measuring efficiency, equity and impacts.",null,null,null,null,null,null,null,null,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,0,0,0,0,"M6","Please select only one option"]
[null,null,"Research synthesis",null,"Understands range of approaches to synthesis and meta-analysis and the role of triangulation of evidence.",null,null,null,null,null,null,null,null,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,0,0,0,0,"M7","Please select only one option"]
[null,"Results and Dissemination","Reporting and presenting data",null,"Has clear knowledge of the format and style required to report evaluation results. Able to report evaluation information clearly in various formats (orally and in writing).",null,null,null,null,null,null,null,null,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,0,0,0,0,"D1","Please select only one option"]
[null,null,null,null,"Is clear about the limits of the evaluation and communicates these clearly and positively.",null,null,null,null,null,null,null,null,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,0,0,0,0,"D1","Please select only one option"]
[null,null,"Considering policy implications and sharing findings",null,"Develops a use and dissemination plan at the outset, based on which groups require what information -  at which point in time, and for what purpose.",null,null,null,null,null,null,null,null,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,0,0,0,0,"D2","Please select only one option"]
[null,null,null,null,"Tailors reporting and communication of findings to meet the needs of different audiences, improving the usability of findings by showing how they relate to specific audiences’ areas of interest.",null,null,null,null,null,null,null,null,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,0,0,0,0,"D2","Please select only one option"]
[null,null,null,null,"Is familiar with a variety of communication modes and tools (e.g. one page summaries, video outputs, infographics, data sharing, newsletters, social media posts, conference presentations and seminars) to maximise impact.",null,null,null,null,null,null,null,null,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,0,0,0,0,"D2","Please select only one option"]
[null,null,null,null,"Identifies policy implications of results and feeds these into policy design. Enabales future appraisal to influence decision making and identify learning.",null,null,null,null,null,null,null,null,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,null,false,0,0,0,0,0,0,"D2","Please select only one option"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AI17:AI51)","v":0},{"$f":"SUM(AJ17:AJ51)","v":0},{"$f":"SUM(AK17:AK51)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((AI52=35),1,0)","v":0},{"$f":"IF(AJ52>0,1,0)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["End of assessment page"]

{"sheet":"Sheet2","index":2,"n_rows":47,"n_cols":22,"rows_kept":47,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,"Split scores",null,null,null,null,null,null,null,"lowest","best",null,"Lowest ","best"]
[null,null,null,"raw","standardised","max",null,null,null,"Scoping",{"$f":"IF(E24=(MIN(E24:E27)),1,0)","v":1},{"$f":"IF(E24=(MAX(E24:E27)),1,0)","v":1},null,{"$f":"IF(K4=1,\"A\",\"\")","v":"A"},{"$f":"IF(L4=1,\"A\",\"\")","v":"A"}]
[null,"Scoping","Understanding and communication of the rationale for evaluation",{"$f":"SUMIFS('Self-Assesment'!$AK$17:$AK$51,'Self-Assesment'!$AL$17:$AL$51,\"S1\")","v":0},{"$f":"(D5/F5)*100","v":0},{"$f":"(COUNTIF('Self-Assesment'!$AL$17:$AL$51,\"S1\"))*4","v":12},"S",null,null,"Leading and Managing",{"$f":"IF(E25=(MIN(E24:E27)),1,0)","v":1},{"$f":"IF(E25=(MAX(E24:E27)),1,0)","v":1},null,{"$f":"IF(K5=1,\"B\",\"\")","v":"B"},{"$f":"IF(L5=1,\"B\",\"\")","v":"B"}]
[null,null,"Understand the intervention and construct a theory of change",{"$f":"SUMIFS('Self-Assesment'!$AK$17:$AK$51,'Self-Assesment'!$AL$17:$AL$51,\"S2\")","v":0},0,{"$f":"(COUNTIF('Self-Assesment'!$AL$17:$AL$51,\"S2\"))*4","v":8},"S",null,null,"Methods",{"$f":"IF(E26=(MIN(E24:E27)),1,0)","v":1},{"$f":"IF(E26=(MAX(E24:E27)),1,0)","v":1},null,{"$f":"IF(K6=1,\"C\",\"\")","v":"C"},{"$f":"IF(L6=1,\"C\",\"\")","v":"C"}]
[null,null,"Identifying the right evaluation design for the policy",{"$f":"SUMIFS('Self-Assesment'!$AK$17:$AK$51,'Self-Assesment'!$AL$17:$AL$51,\"S3\")","v":0},0,{"$f":"(COUNTIF('Self-Assesment'!$AL$17:$AL$51,\"S3\"))*4","v":12},"S",null,null,"Dissemination",{"$f":"IF(E27=(MIN(E24:E27)),1,0)","v":1},{"$f":"IF(E27=(MAX(E24:E27)),1,0)","v":1},null,{"$f":"IF(K7=1,\"D\",\"\")","v":"D"},{"$f":"IF(L7=1,\"D\",\"\")","v":"D"}]
[null,null,"Producing a proportionate and appropriate evaluation plan",{"$f":"SUMIFS('Self-Assesment'!$AK$17:$AK$51,'Self-Assesment'!$AL$17:$AL$51,\"S4\")","v":0},0,{"$f":"(COUNTIF('Self-Assesment'!$AL$17:$AL$51,\"S4\"))*4","v":8},"S",null,null,null,null,null,null,{"$f":"CONCATENATE(N4,N5,N6,N7)","v":"ABCD"},{"$f":"CONCATENATE(O4,O5,O6,O7)","v":"ABCD"}]
[null,"Leading and managing","Leading and managing",{"$f":"SUMIFS('Self-Assesment'!$AK$17:$AK$51,'Self-Assesment'!$AL$17:$AL$51,\"L1\")","v":0},0,{"$f":"(COUNTIF('Self-Assesment'!$AL$17:$AL$51,\"L1\"))*4","v":20},"L"]
[null,"Methods","Use of monitoring and administrative data",{"$f":"SUMIFS('Self-Assesment'!$AK$17:$AK$51,'Self-Assesment'!$AL$17:$AL$51,\"M1\")","v":0},0,{"$f":"(COUNTIF('Self-Assesment'!$AL$17:$AL$51,\"M1\"))*4","v":12},"M"]
[null,null,"Methods of primary research and analysis",{"$f":"SUMIFS('Self-Assesment'!$AK$17:$AK$51,'Self-Assesment'!$AL$17:$AL$51,\"M2\")","v":0},0,{"$f":"(COUNTIF('Self-Assesment'!$AL$17:$AL$51,\"M2\"))*4","v":8},"M",null,null,null,null,null,null,"A","Scoping",null,null,null,null,null,{"$f":"INDEX($O11:$O25,MATCH(N8,$N11:$N25,0))","v":"\"\""},{"$f":"INDEX($O11:$O25,MATCH(O8,$N11:$N25,0))","v":"\"\""}]
[null,null,"Experimental aproaches to impact evaluation",{"$f":"SUMIFS('Self-Assesment'!$AK$17:$AK$51,'Self-Assesment'!$AL$17:$AL$51,\"M3\")","v":0},0,{"$f":"(COUNTIF('Self-Assesment'!$AL$17:$AL$51,\"M3\"))*4","v":8},"M",null,null,null,null,null,null,"AB","Scoping & Leading and managing"]
[null,null,"Theory based approaches to impact evaluation",{"$f":"SUMIFS('Self-Assesment'!$AK$17:$AK$51,'Self-Assesment'!$AL$17:$AL$51,\"M4\")","v":0},0,{"$f":"(COUNTIF('Self-Assesment'!$AL$17:$AL$51,\"M4\"))*4","v":8},"M",null,null,null,"complete? ",{"$f":"'Self-Assesment'!AI53","v":0},null,"ABC","Scoping, Leading and managing & Methods"]
[null,null,"Process evaluation",{"$f":"SUMIFS('Self-Assesment'!$AK$17:$AK$51,'Self-Assesment'!$AL$17:$AL$51,\"M5\")","v":0},0,{"$f":"(COUNTIF('Self-Assesment'!$AL$17:$AL$51,\"M5\"))*4","v":8},"M",null,null,null,null,null,null,"ABD","Scoping, Leading and managing & Results and dissemination"]
[null,null,"Value for money evaluation",{"$f":"SUMIFS('Self-Assesment'!$AK$17:$AK$51,'Self-Assesment'!$AL$17:$AL$51,\"M6\")","v":0},0,{"$f":"(COUNTIF('Self-Assesment'!$AL$17:$AL$51,\"M6\"))*4","v":8},"M",null,null,null,null,null,null,"AC","Scoping & Methods"]
[null,null,"Research synthesis",{"$f":"SUMIFS('Self-Assesment'!$AK$17:$AK$51,'Self-Assesment'!$AL$17:$AL$51,\"M7\")","v":0},0,{"$f":"(COUNTIF('Self-Assesment'!$AL$17:$AL$51,\"M7\"))*4","v":4},"M",null,null,null,null,null,null,"ACD","Scoping, Methods & Results and dissemination"]
[null,"Dissemination","Reporting and presenting data",{"$f":"SUMIFS('Self-Assesment'!$AK$17:$AK$51,'Self-Assesment'!$AL$17:$AL$51,\"D1\")","v":0},0,{"$f":"(COUNTIF('Self-Assesment'!$AL$17:$AL$51,\"D1\"))*4","v":8},"D",null,null,null,null,null,null,"AD","Scoping & Results and dissemination"]
[null,null,"Considering policy implications and disseminating evaluation evidence",{"$f":"SUMIFS('Self-Assesment'!$AK$17:$AK$51,'Self-Assesment'!$AL$17:$AL$51,\"D2\")","v":0},0,{"$f":"(COUNTIF('Self-Assesment'!$AL$17:$AL$51,\"D2\"))*4","v":16},"D",null,null,null,null,null,null,"B","Leading and Managing"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"BC","Leading and managing, Methods & Results and dissemination"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"BCD","Leading and managing & Methods"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"BD","Leading and Managing & Results and dissemination",null,null,null,null,null,"abc"]
[null,null,null,"Competency score 1","Competency score 2","Competency score 3",null,null,null,null,null,null,null,"C","Methods",null,null,null,null,null,"acd"]
[null,null,"Max score","I am now","Stand now","Stand max","Category ",null,null,null,null,null,null,"CD","Methods & Results and dissemination",null,null,null,null,null,"bcd"]
[null,null,{"$f":"SUMIF($G$5:$G$18,\"S\",$F$5:$F$18)","v":40},{"$f":"SUMIF($G$5:$G$18,\"S\",$D$5:$D$18)","v":0},{"$f":"(D24/C24)*100","v":0},100,"Scoping",null,{"$f":"H34","v":"No knowledge or experience"},null,null,null,null,"D","Dissemination"]
[null,null,{"$f":"SUMIF($G$5:$G$18,\"L\",$F$5:$F$18)","v":20},{"$f":"SUMIF($G$5:$G$18,\"L\",$D$5:$D$18)","v":0},{"$f":"(D25/C25)*100","v":0},100,"Leading & managing",null,{"$f":"H36","v":"No knowledge or experience"},null,null,null,null,"ABCD","\"\""]
[null,null,{"$f":"SUMIF($G$5:$G$18,\"M\",$F$5:$F$18)","v":56},{"$f":"SUMIF($G$5:$G$18,\"M\",$D$5:$D$18)","v":0},0,100,"Methods",null,{"$f":"H44","v":"No knowledge or experience"}]
[null,null,{"$f":"SUMIF($G$5:$G$18,\"D\",$F$5:$F$18)","v":24},{"$f":"SUMIF($G$5:$G$18,\"D\",$D$5:$D$18)","v":0},0,100,"Results & dissemination",null,{"$f":"H47","v":"No knowledge or experience"}]
[]
[null,null,null,null,null,null,null,null,null,null,"As /100"]
[null,"Scoping","Understanding and communication of the rationale for evaluation",{"$f":"SUMIFS('Self-Assesment'!$AK$17:$AK$51,'Self-Assesment'!$AL$17:$AL$51,\"S1\")","v":0},{"$f":"COUNTIF('Self-Assesment'!$AL$17:$AL$51,J30)","v":3},{"$f":"D30/E30","v":0},{"$f":"ROUND(F30,1)","v":0},{"$f":"INDEX($M$30:$M$34,MATCH(I30,$L$30:$L$34,0))","v":"No knowledge or experience"},{"$f":"ROUND(F30,0)","v":0},"S1",{"$f":"F30/4","v":0},0,"No knowledge or experience"]
[null,null,"Understand the intervention and construct a theory of change",{"$f":"SUMIFS('Self-Assesment'!$AK$17:$AK$51,'Self-Assesment'!$AL$17:$AL$51,\"S2\")","v":0},{"$f":"COUNTIF('Self-Assesment'!$AL$17:$AL$51,J31)","v":2},{"$f":"D31/E31","v":0},{"$f":"ROUND(F31,1)","v":0},"No knowledge or experience",{"$f":"ROUND(F31,0)","v":0},"S2",{"$f":"F31/4","v":0},1,"Basic or limited  knowledge or experience"]
[null,null,"Identifying the right evaluation design for the policy",{"$f":"SUMIFS('Self-Assesment'!$AK$17:$AK$51,'Self-Assesment'!$AL$17:$AL$51,\"S3\")","v":0},{"$f":"COUNTIF('Self-Assesment'!$AL$17:$AL$51,J32)","v":3},0,0,"No knowledge or experience",0,"S3",0,2,"Working knowledge and practical experience "]
[null,null,"Producing a proportionate and appropriate evaluation plan",{"$f":"SUMIFS('Self-Assesment'!$AK$17:$AK$51,'Self-Assesment'!$AL$17:$AL$51,\"S4\")","v":0},{"$f":"COUNTIF('Self-Assesment'!$AL$17:$AL$51,J33)","v":2},0,0,"No knowledge or experience",0,"S4",0,3,"Detailed knowledge and significant experience"]
[null,null,"Overall",{"$f":"SUM(D30:D33)","v":0},{"$f":"SUM(E30:E33)","v":10},0,0,"No knowledge or experience",0,null,0,4,"Expert knowledge and experience"]
[null,"Leading and managing","Leading and managing",{"$f":"SUMIFS('Self-Assesment'!$AK$17:$AK$51,'Self-Assesment'!$AL$17:$AL$51,\"L1\")","v":0},{"$f":"COUNTIF('Self-Assesment'!$AL$17:$AL$51,J35)","v":5},0,0,"No knowledge or experience",0,"L1",0]
[null,null,"Overall",{"$f":"D35","v":0},{"$f":"E35","v":5},0,0,"No knowledge or experience",0,null,0]
[null,"Methods","Use of monitoring and administrative data",{"$f":"SUMIFS('Self-Assesment'!$AK$17:$AK$51,'Self-Assesment'!$AL$17:$AL$51,\"M1\")","v":0},{"$f":"COUNTIF('Self-Assesment'!$AL$17:$AL$51,J37)","v":3},0,0,"No knowledge or experience",0,"M1",0]
[null,null,"Methods of primary research and analysis",{"$f":"SUMIFS('Self-Assesment'!$AK$17:$AK$51,'Self-Assesment'!$AL$17:$AL$51,\"M2\")","v":0},{"$f":"COUNTIF('Self-Assesment'!$AL$17:$AL$51,J38)","v":2},0,0,"No knowledge or experience",0,"M2",0]
[null,null,"Experimental aproaches to impact evaluation",{"$f":"SUMIFS('Self-Assesment'!$AK$17:$AK$51,'Self-Assesment'!$AL$17:$AL$51,\"M3\")","v":0},{"$f":"COUNTIF('Self-Assesment'!$AL$17:$AL$51,J39)","v":2},0,0,"No knowledge or experience",0,"M3",0]
[null,null,"Theory based approaches to impact evaluation",{"$f":"SUMIFS('Self-Assesment'!$AK$17:$AK$51,'Self-Assesment'!$AL$17:$AL$51,\"M4\")","v":0},{"$f":"COUNTIF('Self-Assesment'!$AL$17:$AL$51,J40)","v":2},0,0,"No knowledge or experience",0,"M4",0]
[null,null,"Process evaluation",{"$f":"SUMIFS('Self-Assesment'!$AK$17:$AK$51,'Self-Assesment'!$AL$17:$AL$51,\"M5\")","v":0},{"$f":"COUNTIF('Self-Assesment'!$AL$17:$AL$51,J41)","v":2},0,0,"No knowledge or experience",0,"M5",0]
[null,null,"Value for money evaluation",{"$f":"SUMIFS('Self-Assesment'!$AK$17:$AK$51,'Self-Assesment'!$AL$17:$AL$51,\"M6\")","v":0},{"$f":"COUNTIF('Self-Assesment'!$AL$17:$AL$51,J42)","v":2},0,0,"No knowledge or experience",0,"M6",0]
[null,null,"Research synthesis",{"$f":"SUMIFS('Self-Assesment'!$AK$17:$AK$51,'Self-Assesment'!$AL$17:$AL$51,\"M7\")","v":0},{"$f":"COUNTIF('Self-Assesment'!$AL$17:$AL$51,J43)","v":1},0,0,"No knowledge or experience",0,"M7",0]
[null,null,"Overall",{"$f":"SUM(D37:D43)","v":0},{"$f":"SUM(E37:E43)","v":14},0,0,"No knowledge or experience",0,null,0]
[null,"Dissemination","Reporting and presenting data",{"$f":"SUMIFS('Self-Assesment'!$AK$17:$AK$51,'Self-Assesment'!$AL$17:$AL$51,\"D1\")","v":0},{"$f":"COUNTIF('Self-Assesment'!$AL$17:$AL$51,J45)","v":2},0,0,"No knowledge or experience",0,"D1",0]
[null,null,"Considering policy implications and disseminating evaluation evidence",{"$f":"SUMIFS('Self-Assesment'!$AK$17:$AK$51,'Self-Assesment'!$AL$17:$AL$51,\"D2\")","v":0},{"$f":"COUNTIF('Self-Assesment'!$AL$17:$AL$51,J46)","v":4},0,0,"No knowledge or experience",0,"D2",0]
[null,null,"Overall",{"$f":"SUM(D45:D46)","v":0},{"$f":"SUM(E45:E46)","v":6},0,0,"No knowledge or experience",0,null,0]

{"sheet":"Results","index":3,"n_rows":213,"n_cols":40,"rows_kept":213,"cut":false,"hidden":false,"merged":[[0,39,2,40],[19,17,20,29],[9,25,12,29],[14,25,17,29],[23,17,39,29],[14,17,15,24],[9,17,10,24],[25,31,39,35],[23,31,24,35],[0,0,1,28],[3,0,5,30],[46,2,47,13],[70,2,100,28],[103,2,133,28],[169,2,199,28],[136,2,166,34],[65,2,66,13],[67,2,67,18]]}
["Government Analytical Evaluation Capabilities Framework",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"End of page"]
[]
[]
["Your results"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Your single highest score was",null,null,null,null,null,null,null,{"$f":"Sheet2!V11","v":"\"\""}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Your single lowest score was",null,null,null,null,null,null,null,{"$f":"Sheet2!U11","v":"\"\""}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"To see the sub-sections please scroll down"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A note about using these results\n\nYour \"skill scores\" are designed to help you understand where your relative strengths and development needs are in evaluation. For each response you gave the following scores were given:\n0 - No knowledge or experience\n1 - Basic or limited knowledge or experience\n2-  Working knowledge and practical experience\n3 - Detailed knowledge and significant experience\n4 - Expert knowledge and experience\n\nYour overall self assessment skill score for each section is the total score as a proportion of the maximum possible. For the other sections an average is given.\n\nThe list that you completed is not exhaustive but can give you an indication of where you might want to focus your learning and development. The PowerPoint framework has a fuller list of capabilities. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Self-assessment score as a bar chart"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Sub-section scores"]
[]
[null,null,"The call outs are the average scores as their equivalent statement"]
[]
[]
[null,null,"Scoping"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Leading and managing"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Methods"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Results and dissemination"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["End of page"]

{"sheet":"Action Plan","index":4,"n_rows":32,"n_cols":35,"rows_kept":32,"cut":false,"hidden":false,"merged":[[18,5,18,10],[18,2,18,4],[18,1,21,1],[19,2,19,4],[20,2,20,4],[21,2,21,4],[19,5,19,10],[20,5,20,10],[21,5,21,10],[0,34,2,35],[0,0,1,25],[3,0,5,27],[7,1,12,25],[15,1,17,4],[15,5,17,10],[15,11,17,16],[15,17,17,18],[15,19,17,25],[22,5,22,10],[29,2,29,4],[29,5,29,10],[22,2,22,4],[30,2,30,4],[30,5,30,10],[31,2,31,4],[23,1,29,1],[30,1,31,1],[23,2,23,4],[24,2,24,4],[25,2,25,4],[26,2,26,4],[27,2,27,4],[28,2,28,4],[31,5,31,10],[18,11,18,16],[19,11,19,16],[20,11,20,16],[21,11,21,16],[22,11,22,16],[23,11,23,16],[24,11,24,16],[23,5,23,10],[24,5,24,10],[25,5,25,10],[26,5,26,10],[27,5,27,10],[28,5,28,10],[31,11,31,16],[25,11,25,16],[26,11,26,16],[18,17,18,18],[19,17,19,18],[20,17,20,18],[21,17,21,18],[22,17,22,18],[27,11,27,16],[28,11,28,16],[29,11,29,16],[30,11,30,16],[18,19,18,25],[19,19,19,25],[20,19,20,25],[21,19,21,25],[22,19,22,25],[27,17,27,18],[28,17,28,18],[29,17,29,18],[30,17,30,18],[23,17,23,18],[24,17,24,18],[25,17,25,18],[31,17,31,18],[29,19,29,25],[30,19,30,25],[31,19,31,25],[23,19,23,25],[24,19,24,25],[25,19,25,25],[26,19,26,25],[27,19,27,25],[28,19,28,25],[26,17,26,18]]}
["Government Analytical Evaluation Capabilities Framework",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end of sheet"]
[]
[]
["Your Action Plan "]
[]
[]
[]
[null,"Below is a simple Action Plan you may find helpful to fill out and use in your personal development. It may help structure some of your thoughts after reading the framework and/ or completing the self-assessment tool. "]
[]
[]
[]
[]
[]
[]
[]
[null,"Topic",null,null,null,"Development Actions",null,null,null,null,null,"Resources or support you think is required to complete this action",null,null,null,null,null,"Your timescale",null,"Outcomes "]
[]
[]
[null,"Scoping ","Understanding and communication of the rationale for evaluation"]
[null,null,"Understand the intervention and construct a theory of change",null,null,"To learn how to do a theory of change and get involved in the development of one in the department ",null,null,null,null,null,"The Magenta book, DfID's guidance on ToC, discuss with my line manager to see if upcoming project in the team or a corporate activity I can join on to. ",null,null,null,null,null,"Within 6 months "]
[null,null,"Identifying the right evaluation design for the policy"]
[null,null,"Producing a proportionate and appropriate evaluation plan"]
[null,"Leading and management","Leading and management"]
[null,"Methods","Use of monitoring and administrative data"]
[null,null,"Methods of primary research and analysis"]
[null,null,"Experimental approaches to impact evaluation"]
[null,null,"Theory based approaches to impact evaluation"]
[null,null,"Process evaluation"]
[null,null,"Value for money evaluation"]
[null,null,"Research synthesis"]
[null,"Dissemination","Reporting and presenting data"]
[null,null,"Considering policy implications and disseminating evaluation evidence"]