{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Instructions","Organization Profile","Organizational Management","Technical Competency","Networking,Collab & Co-Creation","Evidence Uptake","Dataset","Dashboard","FAQs","Data processing"],"not_rendered":{"charts":48,"images":7,"macros":1,"external_links":0,"defined_names":23,"comments":0,"pivot_tables":16},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Health Policy and System Research Institutions"]
[null,null,"Capacity Assessment Tool"]
[]
[null,null,"Introduction to the Tool"]
[null,null,"This framework has been thoughtfully developed to assist institutions in quickly evaluating their capacity for conducting robust research and evaluations. Its primary purpose is to help organizations identify areas of improvement and prioritize their development efforts. We understand that conducting robust research and evaluations is vital for evidence-based decision-making, and our tool is here to support Health Policy and System Research Institutions (HPSRIs) in achieving this goal. Reading through the following.  section will provide you with a deeper understanding of the framework's purpose, development process, and the benefits it can bring to your organization."]
[null,null,"\nPurpose and scope"]
[null,null,"The goal of this assessment tool is to promote reflective self-assessment and facilitate a culture of learning within your organization. The Capacity Assessment framework is designed to evaluate an organization's capacity on Health Policy and System Research (HPSR) and the evidence from assessment can be used to identify areas for improvement, prioritize capacity development efforts and evaluate the progress over time. These institutions may include private or non-governmental organizations, academic institutions and government agencies that are primarily engaged with HPSR. By embracing this self-assessment process, you can continuously enhance your organization's research and evaluation practices, leading to evidence-informed decision-making and improved health policy and system outcomes."]
[null,null,"\nAssessment Process"]
[null,null,"Honesty and objectivity are paramount when completing this assessment. We encourage you to accurately reflect your organization's capacity without any bias or exaggeration. Take your time to carefully consider your answers and provide thoughtful and detailed responses for each competency. This will ensure a comprehensive and accurate assessment of your organization's capacity. Before submitting the tool, review your responses to ensure completeness and accuracy, answering all questions fully and providing accurate scores and remarks."]
[null,null,"\nAppropriate People for Completing the Tool"]
[null,null,"This tool should be completed by appropriate personnel within your organization. It is ideal to have representatives from different areas such as research, finance, administration, HR, and operations teams among others. By involving individuals with knowledge and expertise in various aspects of your organization, you can ensure a more comprehensive and accurate assessment. Having both management and technical staff present for all domains can serve as an important learning activity and increase awareness of how the organization functions together."]
[null,null,"\nTool Adaptability"]
[null,null,"We understand that each organization is unique, and priorities may vary. Therefore, the Capacity Assessment Tool is designed to be adaptable. You have the flexibility to select specific domains or subdomains based on your organization's needs. Modify the tool as necessary to align with your requirements, ensuring that it captures the essence of your organization's capacity and performance accurately."]
[null,null,"\nMeasure of Capacity "]
[null,null,"Capacity of the organizations will be measured in terms of basic capacity, medium capacity, and advanced capacity.  \n\nBasic capacity/skills: The research staffs or organization possesses limited to no capability to carry out the health policy and system research related activities and requires technical support and supervision through the research process.\n\nMedium Capacity/ skills: The research staffs or organization is fully equipped to assume primary responsibility for the activity, proficiently managing the majority of components or steps of the health policy and system research. They locate or take support from relevant expert in market if any assistance is needed. Technical support is only required to offer backing, supervision, and to address any residual capacity gaps. Additionally, it offers supplementary guidance and support, particularly for crafting new materials and addressing novel, rare, or unexpected circumstances.\n\nAdvanced capacity/skills: The research staffs or organization has achieved a high level of competence to successfully conceptualize, execute and accomplish the health policy and system research related activities complying with acceptable or high quality standards. While they might still engage an international expert for exceptionally technical tasks or for validation, guidance, or supervision, they no longer require technical support or guidance for any aspect of the activity's implementation.\n\n**Note: The option to select basic,medium or advanced might still appear when you select no for certain practices or processes. This is because the organizational may have the capacity to conduct certain activities or processes but might not be currently practicing them. "]

{"sheet":"Organization Profile","index":1,"n_rows":45,"n_cols":16,"rows_kept":45,"cut":false,"hidden":false,"merged":[[2,1,2,7],[33,4,33,7]]}
[]
[]
[null,"PART-I: Organizational profile "]
[]
[null,"P1 ","Name of the Organization"]
[]
[null,"P2","Location of head office (Province)"]
[]
[null,"P3","Nature of organization "]
[]
[null,"P3.1","If other, specify"]
[]
[null,"P4","Area of work"]
[null,"P4.1","Offering educational degrees"]
[null,"P4.2","Conducting training for research or capacity development"]
[null,"P4.3","Policy making"]
[null,"P4.4","Programme implementation"]
[null,"P4.5","Generating evidence/ conducting research"]
[null,"P4.6","Service delivery"]
[null,"P4.7","Knowledge brokering/research communication"]
[null,"P4.8.1","If other specify: "]
[null,"P4.8.2","If other specify: "]
[null,"P4.8.3","If other specify: "]
[]
[null,"P5","Staff in the organization"]
[null,"P5.1","Number of part-time staff"]
[null,"P5.2","Number of full-time staff"]
[]
[null,"P6","Number of staffs by type"]
[null,"P6.1","Leadership position such as Director/Executive officers/Senior level managers (looking at overall management of organization "]
[null,"P6.2","Number of Admin and finance staff"]
[null,"P6.3","Number of research staff"]
[null,"P6.4","Number of support staff"]
[null,"P6.5","Total number of staff",{"$f":"SUM(D26:D27)","v":0},{"$f":"IF(ISBLANK(D33), \"\", IF(P34=TRUE,\"\", \"This total number of staff doesn’t match\"))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D26:D27)=SUM(D30:D33)","v":true}]
[]
[null,"P7","Does your organization hire external experts/ consultants to provide technical support in specific area of work?"]
[]
[]
[null,"P8","Availability of basic amenities/ services"]
[null,"P8.1","Sufficient workspace for staff"]
[null,"P8.2","Continuous electricity supply"]
[null,"P8.3","Laptop in the ratio of 1:1 for staffs engaged in table works"]
[null,"P8.4","Electricity backup"]
[null,"P8.5","Uninterrupted internet service during office hours"]
[null,"P8.6","Drinking water supply"]

{"sheet":"Organizational Management","index":2,"n_rows":90,"n_cols":5,"rows_kept":90,"cut":false,"hidden":false,"merged":[[0,0,0,4],[2,0,2,1],[82,0,83,0],[81,0,81,4],[49,0,49,4],[63,0,63,4],[5,3,9,4]]}
["Domain 1: Organizational management"]
[]
["Subdomain 1: Policy environment in the organization"]
["S.No","Organizational policies/ mechanisms\n[Column B]","O1.1 Does your organization have the following policy documents that clearly spell the following components of organizational management or have specified system in functional state?","O 1.2 When was the last time the policy, guidelines, plans, mechanisms updated (in years ago)","O 1.3 What is the implementation status of policies, policy provisions, guidelines or plans listed in column B?"]
["O1.1"]
["O1.1.1","Vision Statement"]
["O1.1.2","Mission Statement"]
["O1.1.3","Organogram"]
["O1.1.4","Scope of work"]
["O1.1.5","Clear communication channels (clarity on whom to communicate based on nature of issue)"]
["O1.1.6","Risk management policy outlining strategies for identification, proritization and mitigation of potential risk to employees"]
["O1.1.7","Whistleblowing policy (for reporting of suspected misconduct, financial fraud and other  illegal acts)"]
["O1.1.8","Policies for the protection of Intellectual Property (IP) "]
["O1.1.9","Policy outlining organizations strategies for organizational growth and development (the business development policy)"]
["O1.1.10","Mechanisms for continuous engagement with policy makers or programme implementers"]
[]
["O1.3","HR management "]
["O1.2.1","Policy outlining strategies for recruitment of competent professionals from market"]
["O1.2.1","Policy outlining strategies for rretention of qualified professionals/staffs"]
["O1.2.2","Policies/guideline/plan for capacity development"]
["O1.2.3","Mechanism for performance appraisal"]
["O1.2.4","Gender and social inclusion policy"]
[]
[]
["O1.3","Infrastructures, logistics and procurement"]
["O1.3.1","Functional inventory management system"]
["O1.3.2","Policies guiding process for procurement of necessary goods and equipment"]
[]
["O1.4","Ethical conduct of research"]
["O1.4.1","Guidelines or standard operating procedures for research ethics (depending on country context, organization may adopt national ethical guideline without having separate policy. In that case, organization should respond Yes in Column C)"]
["O1.4.2","A focal person or unit for ethical matters in research  within the organization"]
["O1.4.3","A mechanism for investigation on violation of research ethics in research projects undertaken by your organization aligning with national ethical guidelines"]
["O1.4.4","Infrastructure/server for safely storing participants details or confidential information relating to research"]
["O1.4.5","Policy for storage and disposal of participants details or other confidential information relating to research"]
["O1.4.6","Protection policies or guidelines for the researcher"]
["O1.4.7","Policy or provisions regarding to insurance for researchers"]
[]
["O1.5","Privacy and confidentiality (other than research ethics)"]
["O1.5.1","System for classifying document as sensitive and non-sensitive"]
["O1.5.2","Written document on naming convention for files and storage provisions"]
["O1.5.3","System for back up of important documents"]
[]
["O1.6","Publications, branding and visibility"]
["O1.6.1","Guidelines for authorship and acknowledgment in research publications"]
["O1.6.2","Standard formats for knowledge products like policy brief, evidence brief, discussion papers and report"]
["O1.6.3","Branding and visibility protocol "]
["O1.6.4","Mechanisms for quality assurance of research products"]
[]
["Subdomain 2. Leadership and management"]
["Instruction: The table below presents questions pertaining to leadership and management within your organization. It presents a series of activities or steps related to leadership and management [Column B]. \n·         For each activity listed in Column B, please indicate whether your organization undertakes the specified activities on a regular basis in Column C. \n·         Additionally, rate your organizational competency levels in activities/ standards listed in D and provide justification for the respective rating in Column E. "]
["SN ","Activities\n[Column B]"," O 2.1 Which of the following activities (Column B, row 69 to 76) related to leadership and management does your organization usually undertake?Select appropriate response (yes, no) from the dropdown menu) [Column C]","O 2.2 How would you rate the competency of the staff (relevant only) in your organization in undertaking the set of activities listed in Column B? [Column D]","O 2.3 Justification\n[Column E]"]
[null,"Activities","Select from the dropdown","Select from the dropdown","O 2.3 Justification"]
["a","Identify market needs and align organizational priorities with market needs","Yes","Basic "]
["e","Consider diversity and inclusion in recruitment process","No","Advanced "]
["b","Make use of project management software to track progress or deviation from the project timeline","Yes","Medium "]
["a","Identification of project risk and development of risk management/ mitigation plan","No","Basic "]
["e","Systematically archiving documents for easy retrieval","Yes","Advanced "]
["b","Conduct periodic  capacity assessment identifying capacity gaps among employees","No","Medium "]
["a","Develop plan for capacity development for employees addressing gaps in capacity assessment","Yes","Basic "]
["e","Implement mentorship and other leadership grooming provisions","No","Advanced "]
["b","Engage with external experts and advisory committees to review and provide tguidance on research activities","Yes","Medium "]
[]
["Subdomain 3: Day to day operation and administration"]
["Instruction: The table below presents questions pertaining to day to day operation and administration within your organization. It presents a a list of infrastructures, technology or mechanism that could facilitate the smooth functioning of day to day operation and administration in Column B. \n·         For each listed items in Column B, please indicate whether your organization has specific infrastructure, technology or mechanism in Column C. \n·         Additionally, rate your organizational copacity levels in activities/ standards listed in D and provide justification for the respective rating in Column E. "]
[null,"Infrastructures, technology and mechanism"]
["S. No","Activities\n[Column B]","Q 3.1 Does your organization have the following infrastructures, technologies or mechanism for research activities? [Column C]","O 3.2 How would you rate the capacity to ensure provisions relating to day to day operation or administration on items listed in Column B, Row 52 to 55) [Column D]","O 3.3 Justification\n[Column E]"]
[null,null,"Select from the dropdown","Select from the dropdown","O 3.3 Justification"]
["a","Necessary physical facilities and spaces to support multiple research project/ diverse set of activities"]
["b","Digital platforms available to facilitate online collaboration, data analysis, and information sharing"]
["c","Technological infrastructure (hardware, software, networks) to support routine research activities"]
["d","Protocols for sharing resources and coordinating logistics in collaborative projects"]
["a","Experts for project monitoring and evaluation (at organizational level rather than specific research project)"]
["b","Standard guideline, tool and templates for field monitoring and supervision "]
["c","Information management system (electronic or manual) for monitoring research projects"]
["d","Process in place to track deviations from planned project timelines"]
["a","Mechanism to identify and address potential challenges during project evaluation"]
["b","Mechanisms to involve external experts/policy makers/other stakeholders in  monitoring and evaluating research projects"]
[]
[]
[]
["4. Financial Management and sustainability","Financial"]
["Instruction: The table below presents questions pertaining to financial management and sustainability of your organization. It presents a series of standards and steps related to leadership and management [Column B]. \n•\tFor each activity listed in Column B, please indicate whether your organization undertakes the specified activities on a regular basis in Column C. \n•\tAdditionally, rate your organizational competency levels in activities/ standards listed in Column D and and provide justification for the respective rating in Column E. "]
["SN ","Activities \n[Column B]","O 4.1 Which of the activities relating to financial management and sustainability do research team members in your organization usually undertake? [Column C]","O 4.2 How would you rate the average skills of your research team members in your organization in undertaking the set of activities listed in Column B? [Column D]","O 4.3 Justification\n[Column E]"]
[null,null,"Select from the dropdown","Select from the dropdown","O 4.3 Justification"]
["g","Ensure compliance with funding regulations and requirements set by different funding sources"]
["a","Maintain or take initiatives to maintain diversity in business portfolio for organizational sustainability"]
["b","Engage in long-term financial planning to secure funding for continuous research endeavors and innovation"]
["c","Keep record of all financial and administrative activities"]
["f","Have contingency plans to address potential shocks in financial status of the organization"]
["h","Undertake procurement of goods and logistics in timely manner"]

{"sheet":"Technical Competency","index":3,"n_rows":181,"n_cols":6,"rows_kept":181,"cut":false,"hidden":false,"merged":[[169,0,169,6],[170,0,171,6],[135,0,135,6],[151,0,151,6],[152,0,152,6],[153,0,153,6],[168,0,168,6],[137,3,137,4],[133,0,133,6],[134,0,134,6],[72,2,72,3],[68,0,68,6],[69,0,69,6],[82,0,82,6],[83,0,83,6],[84,0,84,6],[120,0,120,6],[100,0,100,6],[101,0,101,6],[102,0,102,6],[121,0,121,6],[123,3,123,4],[53,2,54,2],[0,0,0,6],[119,0,119,6],[1,0,1,5],[2,0,2,5],[53,3,54,4],[72,4,72,5],[104,3,104,4],[86,3,86,4]]}
["Domain 2: Technical Competency"]
["Domain 2 of your assessment investigates the technical competency of your organization. It scrutinizes various dimensions of technical expertise and capabilities within your research team, encompassing education, methodological expertise, specific technical skills, and experience. This domain aims to provide a thorough understanding of the proficiency levels and qualifications of your research staff, ensuring they possess the essential skills required for conducting high-quality health policy and systems research. It involves sub-domains such as ethics and safeguarding, research conceptualization, literature review, referencing and citation, research design and methods, research implementation, data management and analysis, technical writing and dissemination and quality check mechanism, monitoring and evaluation. "]
["Instruction: In the table below, please indicate the number of research staff with specified educational level, methodological expertise, specific technical skills and experience.  "]
[]
["T1.1","Education","Number of staffs "]
[null,"Certificate level courses"]
[null,"Bachelor or below"]
[null,"Master"]
[null," PhD /Post-doc"]
["T 1.2. ","How many researchers do you have with the following background or expertise, as specified below.","Number of staffs "]
[null,"Medicine/ dentistry"]
[null,"Epidemiology"]
[null,"Pharmacy"]
[null,"Nursing"]
[null,"Veterinary"]
[null,"Public health"]
[null,"Data science/ Statistics"]
[null,"Environment"]
[null,"Economics"]
[null,"Sociology/ Anthropology"]
[null,"Political science"]
[null,"Communication"]
[null,"Others, please specify: "]
[null,"Others, please specify: "]
[null,"Others, please specify: "]
[]
[]
["T 1.2. ","Methodological expertise"]
[null,"Quantitative studies"]
[null,"Qualitative studies"]
[null," Mixed method studies"]
["T 1.3 ",null,"T 1.3 Does your organization staffs with expertise in following area of research","T 1.4 Does your organization undertake the research/analysis specified in Column C, row 32 to 42?","T 1.5 If yes in question, T 1.3, specify the number of research undertaken in last 5 years"]
[null,"Implementation research"]
[null,"Operational research"]
[null,"Tool development and validation studies"]
[null,"Policy analysis"]
[null,"Cost estimation/economic evaluations"]
[null,"Scoping review/ narrative review"]
[null,"Systematic review/Meta analysis"]
[null,"Undertaking large scale surveys"]
[null,"Undertaking participatory research"]
[null,"Evaluation of complex health system interventions"]
[]
[]
[]
["T 1.6 ","Experience by number of years"]
[null,"Number of employees with <5 years of experience"]
[null,"Number of employees with 5-10 years of experience"]
[null,"Number of employees with  > 10 years of experience"]
[]
[]
[]
["Subdomain 3: Ethics and Safeguarding (Research integrity and ethics)"]
[null,null,"T 3.1 Which of the following steps do you undertake in your organization regarding maintenance of ethical standards in research?","T 3.2 How would you rate the average skills of your research team members in undertaking the set of activities listed in Column B"]
["T 3.1","Activities\n[Column- B]"]
[null,null,"Select from the dropdown","Select from the dropdown","T 3.3 Justification "]
["a","Obtain ethical clearance from relevant authority before undertaking any research involving human participants as per national ethical guideline"]
["b","Obtain written or verbal informed consent from all participants in research involving human subject"]
["c","Require mandatory ethical training to all research team members "]
["d","Practice declaration of the conflict of interest of research team members before undertaking research activities"]
["ef","Monitoring compliance to ethical standards in research project  (Monitor study procedures, maintenance of privacy, confidentiality and participant welfare to ensure adherence to ethical guidelines)"]
["g","Conduct continuous ethical review (on periodic basis) of ongoing research to ensure adherence to ethical standards"]
["h","Have mechanisms in place within the organization, aligning with national ethical guideline for handling research misconduct "]
["i","Report any violation of ethical principles to relevant ethical review boards or institutional review committees"]
[]
[]
["Subdomain 4:  Research conceptualization"]
[]
["Instruction: The table below presents a series of activities or steps involved in conceptual conceptualization process in Column B. "]
["   For each activity listed in Column B, please indicate whether your organization undertakes the specified activities on a regular basis in Column C, and specify the number of activities conducted in the last one year in column D."]
["Additionally, rate your organizational competency levels in activities/ standards listed in Column E and provide justification for the respective rating in Column F. "]
[]
["SN ","Activities\n[Column- B]","T 4.1 Which of the following activities do research team members in your organization usually complete during the research conceptualization phase? ",null,"T 4.2 How would you rate the average skills of your research team members in undertaking the set of activities listed in Column B? "]
[null,"Activities","Select from the dropdown menu","If yes, no. in last 1 year ","Select from the dropdown menu","T 4.3 Justification "]
["a","Convene policy makers and other stakeholders to identify potential research areas "]
["b","Analyze policy and programme documents for identification of research needs "]
["c","Organize events to collaboratively prioritize research agenda for at least 3 years engaging policy makers and other stakeholders "]
["d","Identify relevant government entities /officials and obtain feedback on the research proposal from government authorities/bodies related to subject matter (other than ethical clearance process of ERB-NHRC)"]
[]
[]
[]
["Subdomain 5: Literature review, referencing and citation"]
["Instruction: The table below presents a series of standards and steps related to literature review, referencing and citation in Column B"]
["·         For each activity listed in Column B, please indicate whether your organization undertakes the specified activities on a regular basis in Column C."]
["·         Additionally, rate your organizational competency levels in activities/ standards in Column D and provide justification for rating in Column E. "]
[]
["SN ","Steps/standards ","T 5.1 Which of the steps or standards does your organization usually complete during literature review? (usually means: the majority of research staff for the majority of times","T 5.2 How would you rate the average skills of your research team members in undertaking the set of activities listed in Column B?  "]
[null,"Steps/standards ","Select from the dropdown menu","Select from the dropdown menu","Justification "]
["A","B","C","D","E"]
["a","Define search topic/question in advance before searching for literatures "]
["b","Develop search strategy "]
["c","Run systematic search in different databases "]
["d","Maintain library of relevant literatures  "]
["e","Evaluate the quality of evidence using a defined set of criteria "]
["f","Prepare summary of the evidence "]
["g","Adopt standard styles for referencing and citation  "]
["h","Use reference managers for improving efficiency and quality of work"]
[]
[]
["Subdomain 6: Research design and methods"]
["Instruction: the table below presents a series of standards and steps related to research design and methods in Column B"]
["·         For each activity listed in Column B, please indicate whether your organization undertakes the specified activities on a regular basis in Column C and specify the number of activities conducted in the last one year Column D"]
["·         Additionally, rate your organizational competency levels in activities/ standards listed in Column E and provide justification for the respective rating in Column F."]
[]
["SN ","Activities","T 6.1 Which of the following activities do research team members in your organization usually complete during the research design phase? ","T 6.2 How would you rate the average skills of your research team members in undertaking the set of activities listed in Column B? "]
[null,"Activities","Select from the dropdown menu","Select from the dropdown menu","T 6.3 Justification"]
["A","B","C","D","E"]
["a","Organize workshops/events to collaboratively design the research project (policy makers and other stakeholders) "]
["b","Identify relevant government entities /officials and obtain feedback on the research proposal from government authorities/bodies related to subject matter "]
["c","Estimate study sample size independently or have mechanism/capability to secure mechanism for sampling including sample size estimation, domain analysis based on sample efficiency and logistical feasibility (quantitative study)  "]
["d","Employ theoretical methods in determining sample size for qualitative studies through internal team or have roster/mechanism to secure relevant expert (qualitative study) "]
["e","Identify appropriate data collection methods (for example, household survey, focused group discussion, qualitative interviews, observation schedule)"]
["f","Develop data collection tool ensuring consistency, coherence, and in alignment with the research objective  "]
["g","Establishing or ensuring validity and reliability of the data collection tool through cognitive interviews, pretesting, statistical analysis and other approaches as appropriate techniques "]
["h","Consider Gender Equality and Social Inclusion issues in designing research projects "]
[]
[]
[]
["Subdomain 7: Research implementation"]
["Instruction: The table below presents a series of standards and steps related to research implementation in Column B."]
["·         For each activity listed in Column B, please indicate whether your organization undertakes the specified activities on a regular basis in Column C "]
["·         Additionally, rate your organizational competency levels in activities/ standards in Column D and provide justification for the respective rating in Column E."]
[]
["SN ","Activities","T 7.1 Which of the following activities do research team members in your organization usually complete during the research implementation? ","T 7.2 How would you rate the average skills of your research team members in undertaking the set of activities listed in Column B? "]
[null,"Activities","Select from the dropdown menu","Select from the dropdown menu","T 7.3 Justification "]
["A","B","C","D","E"]
["a","Define competency criteria and recruit appropriate field/research staffs required for the project "]
["b","Develop field/implementation guide for field enumerators "]
["c","Conduct training of the field staffs on implementation of research protocol, tools, modules and methodologies and ethical compliance "]
["d","Measure or assess training effectiveness "]
[]
[]
["Subdomain 8: Data management and analysis"]
["Instruction: The table below presents a series of standards and steps related to data management and analysis in Column B"]
["·         For each activity listed in Column B, please indicate whether your organization undertakes the specified activities on a regular basis in Column C."]
["·         Additionally, rate your organizational competency levels in activities/ standards listed in Column D and provide justification for the respective rating in Column E. "]
[]
["SN","Activities","T 8.1 Which of the following activities do research team members in your organization usually complete during data management and analysis process? ","T 8.2 How would you rate the average skills of your research team members in undertaking the activities listed in Column B?  "]
[null,null,"Select from the dropdown menu","Select from the dropdown menu","T 8.3 Justification "]
["A","B","C","D","E"]
["a","Use statistical software for quantitative data analysis "]
["b","Perform basic quantitative data analysis (descriptive analysis including measure of central tendency, frequency and graphical presentation of data and bivariate analysis) "]
["c","Perform advanced quantitative data analysis involving advanced statistical analysis (for example regression analysis) depending on the nature of data "]
["d","Use software for qualitative data analysis/data organization "]
["e","Analyze qualitative data to identify patterns, themes, and insights, leading to a deeper understanding of the underlying phenomena. "]
["f","Appropriately combine qualitative and quantitative method in data  analysis stage "]
["g","Manage security and storage provisions preventing unauthorized access, data loss, and ensuring confidentiality adhering to the national ethical guidelines  "]
["h","Perform analysis from equity perspective including gender equity and social inclusion analysis "]
[]
[]
["Subdomain 9: Scientific writing"]
["Instruction: The table below presents a series of standards and steps related to technical writing and dissemination in Column B"]
["·         For each activity listed in Column B, please indicate whether your organization undertakes the specified activities on a regular basis in Column C and specify the number of activities conducted in the last one year in column D."]
["·         Additionally, rate your organizational competency levels in activities/ standards in Column E and provide justification for the respective rating in Column F. "]
[]
["SN ","Activities","T 9.1 Which of the following activities do research team members in your organization usually complete during technical writing and dissemination? ","If yes, no. in last 1 year ","T 9.2 How would you rate the average skills of your research team members in undertaking the activities listed in Column B?   "]
[null,"Activities","Select from the dropdown menu","If yes, no. in last 1 year ","Select from the dropdown menu","T 9.3 Justification "]
["A","B","C","D","E","F"]
["a","Develop strategic and feasible plan for writing study reports and manuscripts "]
["b","Write technically sound, clear and understandable research report summarizing research methodology, methods and policy/programme implications that does not require extensive editing "]
["c","Engage policy makers and/or programme managers in preparing the technical report "]
["d","Develop manuscript with researchers in your organization as first author "]
["e","Develop manuscript with researchers in your organization as co-authors (other than first author) "]
[]
[]
[]
[]
["Subdomain 10: Quality check mechanism, monitoring and evaluation"]
["Instruction: The table below presents a series of standards and steps related to quality check mechanism, monitoring and evaluation in Column B"]
["·         For each activity listed in Column B, please indicate whether your organization undertakes the specified activities on a regular basis in Column C  and specify the number of activities conducted in the last one year in column D."]
["·         Additionally, rate your organizational competency levels in activities/ standards listed in Column E and provide justification for the respective rating in Column F. "]
[]
[]
["SN ","Activities","T 10.1 Which of the following activities do research team members in your organization usually complete during quality check mechanism, monitoring and evaluation? ","If yes, no. in last 1 year ","T 10.2 How would you rate the average skills of your research team members in undertaking the activities listed in Column B?  "]
[null,"Activities","Select from the dropdown menu",null,"Select from the dropdown menu","Justification "]
["A","B","C","D","E","F"]
["a","Document lessons learnt during pretesting and implementation phase of research "]
["b","Set up and implement quality control mechanism including cross validation of data collected "]
["c","Real-time monitoring of field data to evaluate target against the timeline "]
["d","Organize joint monitoring event with policy makers/programme managers or other stakeholders "]
["e","Review progress/ preliminary results with policy makers/programme managers or other stakeholders "]

{"sheet":"Networking,Collab & Co-Creation","index":4,"n_rows":57,"n_cols":5,"rows_kept":57,"cut":false,"hidden":false,"merged":[[1,0,1,4],[48,3,48,4],[2,0,2,4],[46,0,46,4]]}
[]
["Domain 3: Networking, Collaboration and Co-creation"]
["Domain 3 of your assessment focuses on the critical aspects of networking, collaboration, and co-creation within your research organization. It investigates your organization's ability to establish and maintain meaningful partnerships and collaborations with a variety of stakeholders. Additionally, this domain explores how effectively your organization engages with these stakeholders to co-create knowledge and influence policy and practice. It investigates subdomains such as stakeholder engagement, inter-sectoral collaboration, networking, and co-creation among others."]
[]
["N 1.1","Does your organization partner or collaborate with the following type of institutions/organizations in jointly managing or implementing the research projects?","Select the appropriate response from the dropdown menu"]
[null,"Government bodies"]
[null,"Academic institutions within country"]
[null,"Academic institutions outside country"]
[null,"Research organizations within country"]
[null,"Research organizations outside country"]
[null,"Local organizations in study site (may overlap with research organizations above)"]
[null,"Other (please specify) "]
[]
["N 1.2","Does your organization engage following stakeholders in co-creation process in research projects?"]
[null,"Government stakeholders/policymakers"]
[null,"Local community/ community representatives"]
[null,"Academia"]
[null,"NGOs/CSOs/charity organizations"]
[null,"Private organizations"]
[null,"Public hospitals/health facilities/ service delivery units"]
[null,"Private hospitals/health facilities/ service delivery units"]
[null,"Other (please specify) "]
[]
["N 1.3","How does your organization prioritize stakeholders for engagement?\n \n"]
[null,"By relevance to the research topics"]
[null,"Based on power they possess in influencing policy/programme decisions"]
[null,"By funding availability"]
[null,"Business portfolio/ goodwill of the organization"]
[null,"Other (please specify)"]
[]
["N 1.4 ","In undertaking the research projects, does your organization engage stakeholders from sectors other than health?"]
["N1.4.1","Agriculture"]
["N1.4.2","Environment"]
["N1.4.3","Infrastructure development (Including road, water supply, sewage system etc.)"]
["N1.4.4","Livlihood / employment/ household economy"]
["N1.4.5","Other (please specify)"]
[]
["N 1.6","What are the major challenges your organization faces when engaging stakeholders? "]
["N1.6.1","Limited stakeholder interest"]
["N1.6.2","Limited participation of stakeholders"]
["N1.6.3","Difficulty in aligning stakeholder interests with research goals/conflicting interest of research team and stakeholders"]
["N1.6.4","Resource constraints for stakeholder engagement"]
["N1.6.5","Complex political or social contexts"]
["N1.6.6","Other (please specify): "]
[]
[]
["Instruction: The table below presents a series of standards and steps related to networking, collaboration and co-creation.  \n•\tFor each activity listed in Column B, please indicate whether your organization undertakes the specified activities on a regular basis in Column C. \n•\tAdditionally, rate your organizational competency levels in activities/ standards in Column D and provide justification for the respective rating in Column E.  "]
[]
["SN  ","Activities ","N 1.7  Which of the following activities do research team members in your organization usually complete during research networking, collaboration, and co-creation","N 1.8 How would you rate the average skills of your research team members in undertaking the set of activities listed in Column B?  "]
[null,null,"Select from the dropdown menu","Select from the dropdown menu","N 1.9 Justification  "]
["A ","B ","C","D","E"]
["A ","Identify and map stakeholders relevant to the research projects or organization's scope of work"]
["b","Maintain a database of potential collaborators and their areas of expertise"]
["c","Collaborate with national organizations (research, academics or other)"]
["d","Collaborate with international organizations (research, academics or other)"]
["e","Form or work in consortium at national level for bidding / applying for research calls /grants"]
["f","Form  or work in consortium at innational level for bidding / applying for research calls /grants"]

{"sheet":"Evidence Uptake","index":5,"n_rows":68,"n_cols":6,"rows_kept":68,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5]]}
["Domain 4: Evidence to Policy Translation"]
["Domain 4 of your assessment evaluates your organization's ability to translate research into practical policies and practices. This domain covers subdomains such as policy and guideline framework, peer review of research outputs, adapting findings to the local context, production of knowledge products, effective communication channels, tailored advocacy efforts, mechanisms for policy influence, response time to policy requests, and barriers to translation. It aims to assess your organization's policies, development of knowledge product, advocacy and policy influence mechanisms, and challenges in the translation process among several other key aspects."]
[]
["P 1","Knowledge products","P 1.1 Which of the following knowledge products does your organization produce?","P 1.2 What is the number of products developed/ event organized (specified from column B, Row 5 to 13)","P 1.3 How do you rate your organizational competency in developing the specified knowledge products or organizing events specified?","P 1.4 Justification"]
["a","Policy briefs/ project briefs tailored to the need of policy makers/ programme implementers"]
["b","Prepare non-technical summary of the research findings in national/local language "]
["c","Discussion papers"]
["d","Newspaper articles"]
["e","Blog post"]
["f","Infographics "]
["g","Video summary of the research findings"]
["h","Scientific papers"]
["i","Other (Please specify): "]
["i","Other (Please specify): "]
["i","Other (Please specify): "]
[]
["P2","Events","How often does your institution organize knowledge sharing or dissemination events specified ? Question for Column C","P 2.2 What is the number of knowledge sharing or dissemination events organized by your organization in past one year? Column D","P 2.3 How do you rate your organizational competency in organizing knowledge sharing/ dissemination events specified? Column E","P 2.4 Justification for assigning specific rating on competency in Column E (Column F)"]
["a","Webinars and seminars to share the learnings"]
["b","Social media campaigns based on findings from evidence generated"]
["c","Interaction/ discussion with policy makers about evidence and their applicability"]
["d","Organize dissemination events with local stakeholders/beneficiaries "]
["e","Organize dissemination events with policy makers and other stakeholders at policy making level"]
["f","Organize dissemination events with policy makers and other stakeholders at programme implementing level"]
["g","Document the impact and effectiveness of HPSR programs in influencing policy decisions and healthcare outcomes"]
["h","Deliver presentations at national level conferences, seminars, summits etc."]
["i","Deliver presentations at international level conferences, seminars and summits "]
["j","Organize events/ discussions responding to the evidence gap highlighted or evidence requested by policy makers/ programme implementers"]
[null,null,"Yes",null,"NA "]
["P 1.2 ","Which communication channels have been most effective for your organization in bridging the gap between research and practice?","Yes",null,"Basic "]
[null,"Policy briefs","Yes",null,"Medium "]
[null,"Webinars and seminars","Yes",null,"Advanced "]
[null,"Social media campaigns","Yes",null,"NA "]
[null,"One-on-one consultations","Yes",null,"Basic "]
[null,"Other (please specify)","Yes",null,"Medium "]
[null,null,"Yes",null,"Advanced "]
[null,null,"Yes",null,"NA "]
["P 1.3"," In what ways does your organization tailor advocacy efforts to influence specific policies or stakeholder groups?","Yes",null,"Basic "]
[null,"Customized policy briefs","Yes",null,"Medium "]
[null,"Targeted engagement with key policymakers","Yes",null,"Advanced "]
[null,"Grassroots advocacy campaigns","Yes",null,"NA "]
[null,"Collaborative advocacy with partner organizations","Yes",null,"Basic "]
[null,"Other (please specify)","Yes",null,"Medium "]
[null,null,"Yes",null,"Advanced "]
[null,null,"Yes",null,"NA "]
["P 1.4"," Which mechanism has proven most effective in influencing policy in your organization?","Yes",null,"Basic "]
[null,"Formal policy platforms","Yes",null,"Medium "]
[null,"Informal dialogues with policymakers","Yes",null,"Advanced "]
[null,"Public engagement and awareness campaigns","Yes",null,"NA "]
[null,"Research communication through media","Yes",null,"Basic "]
[null,"Other (please specify) ","Yes",null,"Medium "]
[null,null,"Yes",null,"Advanced "]
[null,null,"Yes",null,"NA "]
["P 1.6 ","How are research findings typically adapted to suit the local context?","Yes",null,"Basic "]
[null,"Translation of research reports into local languages","Yes",null,"Medium "]
[null,"Incorporation of local case studies and examples","Yes",null,"Advanced "]
[null,"Collaboration with local stakeholders for contextualization","Yes",null,"NA "]
[null,"Development of policy briefs or summaries","Yes",null,"Basic "]
[null,"Other (please specify)","Yes",null,"Medium "]
[null,null,"Yes",null,"Advanced "]
["P 1.8 ","What do you perceive as the most significant barriers or obstacles in translating research evidence into policy and practice? ","Yes",null,"NA "]
[null,"Lack of policy receptivity","Yes",null,"Basic "]
[null,"Limited research funding","Yes",null,"Medium "]
[null,"Complexity of research findings","Yes"]
[null,"Political factors","Yes"]
[null,"Other (please specify) ","Yes"]
[null,null,"Yes"]
[null,null,"Yes"]
[null,null,"Yes"]

{"sheet":"Dataset","index":6,"n_rows":717,"n_cols":16,"rows_kept":717,"cut":false,"hidden":true,"merged":[]}
["Number of staffs"]
[null,{"$f":"'Organization Profile'!C26:D33","v":"Number of part-time staff"},0]
[null,"Number of full-time staff",0]
[null,0,0]
[null,"Number of staffs by type",0]
[null,"Leadership position such as Director/Executive officers/Senior level managers (looking at overall management of organization ",0,"Leadership Position",{"$f":"C6:C9","v":0}]
[null,"Number of Admin and finance staff",0,"Admin and Finance",0]
[null,"Number of research staff",0,"Research staff",0]
[null,"Number of support staff",0,"Support staff",0]
[]
[]
[null,null,"Availability","items"]
[null,{"$f":"'Organization Profile'!C14:D21","v":"Offering educational degrees"},0,{"$f":"IF(C13=\"Yes\", B13,\"\")","v":""}]
["Area of work","Conducting training for research or capacity development",0,{"$f":"IF(C14=\"Yes\", B14,\"\")","v":""}]
[null,"Policy making",0,""]
[null,"Programme implementation",0,""]
[null,"Generating evidence/ conducting research",0,""]
[null,"Service delivery",0,""]
[null,"Knowledge brokering/research communication",0,""]
[null,"If other specify: ",0,""]
[null,null,null,""]
[]
[]
[]
[]
[]
[]
[]
["Availability of amenities"]
[null,{"$f":"'Organization Profile'!C40:D45","v":"Sufficient workspace for staff"},0,null,{"$f":"B30","v":"Sufficient workspace for staff"},{"$f":"VLOOKUP(C30,'Data processing'!$A$1:$B$13,2,)","v":{"$error":"#N/A"}}]
[null,"Continuous electricity supply",0,null,{"$f":"B31","v":"Continuous electricity supply"},{"$f":"VLOOKUP(C31,'Data processing'!$A$1:$B$13,2,)","v":{"$error":"#N/A"}}]
[null,"Laptop in the ratio of 1:1 for staffs engaged in table works",0,null,"Laptop in the ratio of 1:1 for staffs engaged in table works",{"$f":"VLOOKUP(C32,'Data processing'!$A$1:$B$13,2,)","v":{"$error":"#N/A"}}]
[null,"Electricity backup",0,null,"Electricity backup",{"$f":"VLOOKUP(C33,'Data processing'!$A$1:$B$13,2,)","v":{"$error":"#N/A"}}]
[null,"Uninterrupted internet service during office hours",0,null,"Uninterrupted internet service during office hours",{"$f":"VLOOKUP(C34,'Data processing'!$A$1:$B$13,2,)","v":{"$error":"#N/A"}}]
[null,"Drinking water supply",0,null,"Drinking water supply",{"$f":"VLOOKUP(C35,'Data processing'!$A$1:$B$13,2,)","v":{"$error":"#N/A"}}]
[]
[null,null,null,null,"count_errror",{"$f":"COUNTIF(F30:F35, \"#N/A\")","v":6}]
[null,null,null,null,"Score",{"$f":"SUMIF(F30:F35,\"<>#N/A\")","v":0}]
[null,null,null,null,"Total count",{"$f":"6-F37","v":0}]
[null,null,null,null,"Percent",{"$f":"F38/F39*100","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Organizational Management"]
["Leadership and management"]
[null,{"$f":"'Organizational Management'!A51:E61","v":"SN "},"Activities\n[Column B]"," O 2.1 Which of the following activities (Column B, row 69 to 76) related to leadership and management does your organization usually undertake?Select appropriate response (yes, no) from the dropdown menu) [Column C]","O 2.2 How would you rate the competency of the staff (relevant only) in your organization in undertaking the set of activities listed in Column B? [Column D]","O 2.3 Justification\n[Column E]",null,null,null,null,null,"Empty",{"$f":"COUNTIF(D63:D71, 0)","v":0}]
[null,0,"Activities","Select from the dropdown","Select from the dropdown","O 2.3 Justification",null,"Activities","Available","Score",{"$f":"E63","v":"Select from the dropdown"},"Available",{"$f":"COUNTIF(D64:D72, \"Yes\")","v":5}]
[null,"a","Identify market needs and align organizational priorities with market needs","Yes","Basic ",0,null,{"$f":"C64","v":"Identify market needs and align organizational priorities with market needs"},{"$f":"D64","v":"Yes"},{"$f":"VLOOKUP(E64,'Data processing'!A$1:B$13,2,FALSE)","v":1},"Basic ","Not available",{"$f":"COUNTIF(D64:D72, \"No\")","v":4}]
[null,"e","Consider diversity and inclusion in recruitment process","No","Advanced ",0,null,"Consider diversity and inclusion in recruitment process","No",{"$f":"VLOOKUP(E65,'Data processing'!A$1:B$13,2,FALSE)","v":3},"Advanced ","total questions",{"$f":"COUNTA(H64:H72)","v":9},null,"Available",{"$f":"COUNTIF(D64:D72, \"Yes\")","v":5}]
[null,"b","Make use of project management software to track progress or deviation from the project timeline","Yes","Medium ",0,null,"Make use of project management software to track progress or deviation from the project timeline","Yes",{"$f":"VLOOKUP(E66,'Data processing'!A$1:B$13,2,FALSE)","v":2},"Medium ","Available activitite s",{"$f":"COUNTIF(I64:I72, \"Yes\")","v":5},null,"Not available",{"$f":"COUNTIF(D64:D72, \"No\")","v":4}]
[null,"a","Identification of project risk and development of risk management/ mitigation plan","No","Basic ",0,null,"Identification of project risk and development of risk management/ mitigation plan","No",{"$f":"VLOOKUP(E67,'Data processing'!A$1:B$13,2,FALSE)","v":1},"Basic "]
[null,"e","Systematically archiving documents for easy retrieval","Yes","Advanced ",0,null,"Systematically archiving documents for easy retrieval","Yes",{"$f":"VLOOKUP(E68,'Data processing'!A$1:B$13,2,FALSE)","v":3},"Advanced ","Max possible score",{"$f":"(M65-M64-M62)*3","v":15}]
[null,"b","Conduct periodic  capacity assessment identifying capacity gaps among employees","No","Medium ",0,null,"Conduct periodic  capacity assessment identifying capacity gaps among employees","No",{"$f":"VLOOKUP(E69,'Data processing'!A$1:B$13,2,FALSE)","v":2},"Medium ","Min possible score",{"$f":"(M65-M64-M62)*1","v":5}]
[null,"a","Develop plan for capacity development for employees addressing gaps in capacity assessment","Yes","Basic ",0,null,"Develop plan for capacity development for employees addressing gaps in capacity assessment","Yes",{"$f":"VLOOKUP(E70,'Data processing'!A$1:B$13,2,FALSE)","v":1},"Basic ","Total score",{"$f":"SUMIF(J64:J72, \"<>#N/A\")","v":18}]
[null,"e","Implement mentorship and other leadership grooming provisions","No","Advanced ",0,null,"Implement mentorship and other leadership grooming provisions","No",{"$f":"VLOOKUP(E71,'Data processing'!A$1:B$13,2,FALSE)","v":3},"Advanced "]
[null,"b","Engage with external experts and advisory committees to review and provide tguidance on research activities","Yes","Medium ",0,null,"Engage with external experts and advisory committees to review and provide tguidance on research activities","Yes",{"$f":"VLOOKUP(E72,'Data processing'!A$1:B$13,2,FALSE)","v":2},"Medium "]
[null,null,null,"Select from the dropdown","Medium "]
[]
[null,null,null,"Leadership and management related activities"]
[null,null,null,"Make use of project management software to track progress or deviation from the project timeline"]
[null,null,null,"Conduct periodic  capacity assessment identifying capacity gaps among employees"]
[null,null,null,"Engage with external experts and advisory committees to review and provide tguidance on research activities"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Infrastructures, technology and mechanism"]
[null,{"$f":"'Organizational Management'!A66:E77","v":"S. No"},"Activities\n[Column B]","Q 3.1 Does your organization have the following infrastructures, technologies or mechanism for research activities? [Column C]","O 3.2 How would you rate the capacity to ensure provisions relating to day to day operation or administration on items listed in Column B, Row 52 to 55) [Column D]","O 3.3 Justification\n[Column E]",null,null,null,null,null,"Empty",{"$f":"COUNTIF(D91:D99, 0)","v":8}]
[null,0,0,"Select from the dropdown","Select from the dropdown","O 3.3 Justification",null,"Activities","Available","Score",{"$f":"E91","v":"Select from the dropdown"},"Available",{"$f":"COUNTIF(D92:D100, \"Yes\")","v":0}]
[null,"a","Necessary physical facilities and spaces to support multiple research project/ diverse set of activities",0,0,0,null,{"$f":"C92","v":"Necessary physical facilities and spaces to support multiple research project/ diverse set of activities"},{"$f":"D92","v":0},{"$f":"VLOOKUP(E92,'Data processing'!A$1:B$13,2,FALSE)","v":{"$error":"#N/A"}},0,"Not available",{"$f":"COUNTIF(D92:D100, \"No\")","v":0}]
[null,"b","Digital platforms available to facilitate online collaboration, data analysis, and information sharing",0,0,0,null,"Digital platforms available to facilitate online collaboration, data analysis, and information sharing",0,{"$f":"VLOOKUP(E93,'Data processing'!A$1:B$13,2,FALSE)","v":{"$error":"#N/A"}},0,"total questions",{"$f":"COUNTA(H92:H100)","v":9}]
[null,"c","Technological infrastructure (hardware, software, networks) to support routine research activities",0,0,0,null,"Technological infrastructure (hardware, software, networks) to support routine research activities",0,{"$f":"VLOOKUP(E94,'Data processing'!A$1:B$13,2,FALSE)","v":{"$error":"#N/A"}},0,"Available activitite s",{"$f":"COUNTIF(I92:I100, \"Yes\")","v":0}]
[null,"d","Protocols for sharing resources and coordinating logistics in collaborative projects",0,0,0,null,"Protocols for sharing resources and coordinating logistics in collaborative projects",0,{"$f":"VLOOKUP(E95,'Data processing'!A$1:B$13,2,FALSE)","v":{"$error":"#N/A"}},0]
[null,"a","Experts for project monitoring and evaluation (at organizational level rather than specific research project)",0,0,0,null,"Experts for project monitoring and evaluation (at organizational level rather than specific research project)",0,{"$f":"VLOOKUP(E96,'Data processing'!A$1:B$13,2,FALSE)","v":{"$error":"#N/A"}},0,"Max possible score",{"$f":"(M93-M92-M90)*3","v":3}]
[null,"b","Standard guideline, tool and templates for field monitoring and supervision ",0,0,0,null,"Standard guideline, tool and templates for field monitoring and supervision ",0,{"$f":"VLOOKUP(E97,'Data processing'!A$1:B$13,2,FALSE)","v":{"$error":"#N/A"}},0,"Min possible score",{"$f":"(M93-M92-M90)*1","v":1}]
[null,"c","Information management system (electronic or manual) for monitoring research projects",0,0,0,null,"Information management system (electronic or manual) for monitoring research projects",0,{"$f":"VLOOKUP(E98,'Data processing'!A$1:B$13,2,FALSE)","v":{"$error":"#N/A"}},0,"Total score",{"$f":"SUMIF(J92:J100, \"<>#N/A\")","v":0}]
[null,"d","Process in place to track deviations from planned project timelines",0,0,0,null,"Process in place to track deviations from planned project timelines",0,{"$f":"VLOOKUP(E99,'Data processing'!A$1:B$13,2,FALSE)","v":{"$error":"#N/A"}},0]
[null,"a","Mechanism to identify and address potential challenges during project evaluation",0,0,0,null,"Mechanism to identify and address potential challenges during project evaluation",0,{"$f":"VLOOKUP(E100,'Data processing'!A$1:B$13,2,FALSE)","v":{"$error":"#N/A"}},0]
[null,"b","Mechanisms to involve external experts/policy makers/other stakeholders in  monitoring and evaluating research projects",0,0,0,null,"Mechanisms to involve external experts/policy makers/other stakeholders in  monitoring and evaluating research projects",0,{"$f":"VLOOKUP(E101,'Data processing'!A$1:B$13,2,FALSE)","v":{"$error":"#N/A"}},0]
[]
[]
[]
[]
[null,null,null,"Select from the dropdown",0]
[]
[null,null,null,"Row Labels"]
[null,null,null,"Digital platforms available to facilitate online collaboration, data analysis, and information sharing"]
[null,null,null,"Experts for project monitoring and evaluation (at organizational level rather than specific research project)"]
[null,null,null,"Information management system (electronic or manual) for monitoring research projects"]
[null,null,null,"Mechanism to identify and address potential challenges during project evaluation"]
[null,null,null,"Mechanisms to involve external experts/policy makers/other stakeholders in  monitoring and evaluating research projects"]
[null,null,null,"Necessary physical facilities and spaces to support multiple research project/ diverse set of activities"]
[null,null,null,"Process in place to track deviations from planned project timelines"]
[null,null,null,"Protocols for sharing resources and coordinating logistics in collaborative projects"]
[null,null,null,"Standard guideline, tool and templates for field monitoring and supervision "]
[null,null,null,"Technological infrastructure (hardware, software, networks) to support routine research activities"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["financial management and sustainability",null,null,null,null,null,null,null,null,null,null,"Empty",{"$f":"COUNTIF(C140:C147, 0)","v":6}]
[null,{"$f":"'Organizational Management'!B84:E90","v":0},"Select from the dropdown","Select from the dropdown","O 4.3 Justification","Activities","Available","Score","Rate",null,null,"Available",{"$f":"COUNTIF(C141:C146, \"Yes\")","v":0}]
[null,"Ensure compliance with funding regulations and requirements set by different funding sources",0,0,0,{"$f":"B141","v":"Ensure compliance with funding regulations and requirements set by different funding sources"},{"$f":"C141","v":0},{"$f":"VLOOKUP(D141,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK(D141),\"\",D141)","v":0},null,null,"Not available",{"$f":"COUNTIF(C141:C146, \"No\")","v":0}]
[null,"Maintain or take initiatives to maintain diversity in business portfolio for organizational sustainability",0,0,0,{"$f":"B142","v":"Maintain or take initiatives to maintain diversity in business portfolio for organizational sustainability"},{"$f":"C142","v":0},{"$f":"VLOOKUP(D142,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK(D142),\"\",D142)","v":0},null,null,"total questions",{"$f":"COUNTA(H141:H147)","v":6},null,"Available",{"$f":"COUNTIF(G141:G147, \"Yes\")","v":0}]
[null,"Engage in long-term financial planning to secure funding for continuous research endeavors and innovation",0,0,0,"Engage in long-term financial planning to secure funding for continuous research endeavors and innovation",0,{"$f":"VLOOKUP(D143,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},0,null,null,"Available activitite s",{"$f":"COUNTIF(I141:I147, \"Yes\")","v":0},null,"Not available",{"$f":"COUNTIF(G141:G147, \"No\")","v":0}]
[null,"Keep record of all financial and administrative activities",0,0,0,"Keep record of all financial and administrative activities",0,{"$f":"VLOOKUP(D144,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},0]
[null,"Have contingency plans to address potential shocks in financial status of the organization",0,0,0,"Have contingency plans to address potential shocks in financial status of the organization",0,{"$f":"VLOOKUP(D145,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(OR(ISBLANK(D145),D145=0),\"\",D145)","v":""},null,null,"Max possible score",{"$f":"(M142-M141-M139)*3","v":0}]
[null,"Undertake procurement of goods and logistics in timely manner",0,0,0,"Undertake procurement of goods and logistics in timely manner",0,{"$f":"VLOOKUP(D146,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(OR(ISBLANK(D146),D146=0),\"\",D146)","v":""},null,null,"Min possible score",{"$f":"(M142-M141-M139)*1","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Total score",{"$f":"SUMIF(H141:H147, \"<>#N/A\")","v":0}]
[]
[null,"Rate","(All)"]
[]
[null,"Row Labels"]
[null,"Engage in long-term financial planning to secure funding for continuous research endeavors and innovation"]
[null,"Ensure compliance with funding regulations and requirements set by different funding sources"]
[null,"Have contingency plans to address potential shocks in financial status of the organization"]
[null,"Keep record of all financial and administrative activities"]
[null,"Maintain or take initiatives to maintain diversity in business portfolio for organizational sustainability"]
[null,"Undertake procurement of goods and logistics in timely manner"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"expert ","(All)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"undertaken","(All)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Row Labels","Sum of number"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Cost estimation/economic evaluations",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Evaluation of complex health system interventions",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Implementation research",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Operational research",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Policy analysis",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Scoping review/ narrative review",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Systematic review/Meta analysis",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Tool development and validation studies",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Undertaking large scale surveys",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Undertaking participatory research",0]
[]
[]
[]
[]
[" Undertaken the following type of studies/analysis in the last five years"]
[null,"Study/Activities","expert ","undertaken","number",null,{"$f":"B178","v":"Study/Activities"},"number"]
[null,{"$f":"'Technical Competency'!B33:E42","v":"Implementation research"},0,0,0,null,{"$f":"B179","v":"Implementation research"},{"$f":"E179","v":0}]
[null,"Operational research",0,0,0,null,"Operational research",{"$f":"E180","v":0}]
[null,"Tool development and validation studies",0,0,0,null,"Tool development and validation studies",0]
[null,"Policy analysis",0,0,0,null,"Policy analysis",0]
[null,"Cost estimation/economic evaluations",0,0,0,null,"Cost estimation/economic evaluations",0]
[null,"Scoping review/ narrative review",0,0,0,null,"Scoping review/ narrative review",0]
[null,"Systematic review/Meta analysis",0,0,0,null,"Systematic review/Meta analysis",{"$f":"E185","v":0}]
[null,"Undertaking large scale surveys",0,0,0,null,"Undertaking large scale surveys",0]
[null,"Undertaking participatory research",0,0,0,null,"Undertaking participatory research",0]
[null,"Evaluation of complex health system interventions",0,0,0,null,"Evaluation of complex health system interventions",0]
[]
["Ethics and safeguarding"]
[]
[null,{"$f":"'Technical Competency'!A54:E64","v":0},0,"T 3.1 Which of the following steps do you undertake in your organization regarding maintenance of ethical standards in research?","T 3.2 How would you rate the average skills of your research team members in undertaking the set of activities listed in Column B",0]
[null,"T 3.1","Activities\n[Column- B]",0,0,0]
[null,0,0,"Select from the dropdown","Select from the dropdown","T 3.3 Justification ","Activities","Available","Rate","Score",null,"Empty",{"$f":"COUNTIF(D195:D203, 0)","v":8}]
[null,"a","Obtain ethical clearance from relevant authority before undertaking any research involving human participants as per national ethical guideline",0,0,0,{"$f":"C195","v":"Obtain ethical clearance from relevant authority before undertaking any research involving human participants as per national ethical guideline"},0,0,{"$f":"VLOOKUP(I195,'Data processing'!A$1:B$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"E195","v":0},"Available",{"$f":"COUNTIF(D195:D203, \"Yes\")","v":0}]
[null,"b","Obtain written or verbal informed consent from all participants in research involving human subject",0,0,0,"Obtain written or verbal informed consent from all participants in research involving human subject",0,{"$f":"E196","v":0},{"$f":"VLOOKUP(I196,'Data processing'!A$1:B$13,2,FALSE)","v":{"$error":"#N/A"}},0,"Not available",{"$f":"COUNTIF(D195:D202, \"No\")","v":0}]
[null,"c","Require mandatory ethical training to all research team members ",0,0,0,"Require mandatory ethical training to all research team members ",0,0,{"$f":"VLOOKUP(I197,'Data processing'!A$1:B$13,2,FALSE)","v":{"$error":"#N/A"}},0,"total questions",{"$f":"COUNTA(C195:C202)","v":8}]
[null,"d","Practice declaration of the conflict of interest of research team members before undertaking research activities",0,0,0,"Practice declaration of the conflict of interest of research team members before undertaking research activities",0,0,{"$f":"VLOOKUP(I198,'Data processing'!A$1:B$13,2,FALSE)","v":{"$error":"#N/A"}},0,"Available activitite s",{"$f":"COUNTIF(H195:H202, \"Yes\")","v":0}]
[null,"ef","Monitoring compliance to ethical standards in research project  (Monitor study procedures, maintenance of privacy, confidentiality and participant welfare to ensure adherence to ethical guidelines)",0,0,0,"Monitoring compliance to ethical standards in research project  (Monitor study procedures, maintenance of privacy, confidentiality and participant welfare to ensure adherence to ethical guidelines)",0,0,{"$f":"VLOOKUP(I199,'Data processing'!A$1:B$13,2,FALSE)","v":{"$error":"#N/A"}},0]
[null,"g","Conduct continuous ethical review (on periodic basis) of ongoing research to ensure adherence to ethical standards",0,0,0,"Conduct continuous ethical review (on periodic basis) of ongoing research to ensure adherence to ethical standards",0,0,{"$f":"VLOOKUP(I200,'Data processing'!A$1:B$13,2,FALSE)","v":{"$error":"#N/A"}},0,"Max possible score",{"$f":"(M197-M196-M194)*3","v":0}]
[null,"h","Have mechanisms in place within the organization, aligning with national ethical guideline for handling research misconduct ",0,0,0,"Have mechanisms in place within the organization, aligning with national ethical guideline for handling research misconduct ",0,0,{"$f":"VLOOKUP(I201,'Data processing'!A$1:B$13,2,FALSE)","v":{"$error":"#N/A"}},0,"Min possible score",{"$f":"(M197-M196-M194)*1","v":0}]
[null,"i","Report any violation of ethical principles to relevant ethical review boards or institutional review committees",0,0,0,"Report any violation of ethical principles to relevant ethical review boards or institutional review committees",0,0,{"$f":"VLOOKUP(I202,'Data processing'!A$1:B$13,2,FALSE)","v":{"$error":"#N/A"}},0,"Total score",{"$f":"SUMIF(J195:J203, \"<>#N/A\")","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,null,"Rate",0]
[]
[null,null,null,null,null,null,"Row Labels"]
[null,null,null,null,null,null,"Conduct continuous ethical review (on periodic basis) of ongoing research to ensure adherence to ethical standards"]
[null,null,null,null,null,null,"Have mechanisms in place within the organization, aligning with national ethical guideline for handling research misconduct "]
[null,null,null,null,null,null,"Monitoring compliance to ethical standards in research project  (Monitor study procedures, maintenance of privacy, confidentiality and participant welfare to ensure adherence to ethical guidelines)"]
[null,null,null,null,null,null,"Obtain ethical clearance from relevant authority before undertaking any research involving human participants as per national ethical guideline"]
[null,null,null,null,null,null,"Obtain written or verbal informed consent from all participants in research involving human subject"]
[null,null,null,null,null,null,"Practice declaration of the conflict of interest of research team members before undertaking research activities"]
[null,null,null,null,null,null,"Report any violation of ethical principles to relevant ethical review boards or institutional review committees"]
[null,null,null,null,null,null,"Require mandatory ethical training to all research team members "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["activities or steps involved in conceptual conceptualization process"]
[]
[null,{"$f":"'Technical Competency'!B74:F78","v":"Activities"},"Select from the dropdown menu","If yes, no. in last 1 year ","Select from the dropdown menu","T 4.3 Justification ","score","Count of NA col1",{"$f":"COUNTIF(C245:C248,\"0\")","v":4}]
[null,"Convene policy makers and other stakeholders to identify potential research areas ",0,0,0,0,{"$f":"VLOOKUP(E245,'Data processing'!A$1:B$13,2,FALSE)","v":{"$error":"#N/A"}},"Count of NA col2",{"$f":"COUNTIF(E245:E248,\"0\")","v":4},null,"Available",{"$f":"COUNTIF(F245:F247, \"Yes\")","v":0}]
[null,"Analyze policy and programme documents for identification of research needs ",0,0,0,0,{"$f":"VLOOKUP(E246,'Data processing'!A$1:B$13,2,FALSE)","v":{"$error":"#N/A"}},"total questions",{"$f":"COUNTA(B245:B248)","v":4},null,"Not available",{"$f":"COUNTIF(F245:F247, \"No\")","v":0}]
[null,"Organize events to collaboratively prioritize research agenda for at least 3 years engaging policy makers and other stakeholders ",0,0,0,0,{"$f":"VLOOKUP(E247,'Data processing'!A$1:B$13,2,FALSE)","v":{"$error":"#N/A"}},"Available activitite s",{"$f":"COUNTIF(C245:C248, \"Yes\")","v":0}]
[null,"Identify relevant government entities /officials and obtain feedback on the research proposal from government authorities/bodies related to subject matter (other than ethical clearance process of ERB-NHRC)",0,0,0,0,{"$f":"VLOOKUP(E248,'Data processing'!A$1:B$13,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,"Max possible score",{"$f":"(I246-I245)*3","v":0}]
[null,null,null,null,null,null,null,"Min possible score",{"$f":"(I246-I245)*1","v":0}]
[null,null,null,null,null,null,null,"Total score",{"$f":"SUMIF(G245:G248, \"<>#N/A\")","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Research conceptualization"]
[{"$f":"'Technical Competency'!A73:F78","v":"SN "},"Activities\n[Column- B]","T 4.1 Which of the following activities do research team members in your organization usually complete during the research conceptualization phase? ",0,"T 4.2 How would you rate the average skills of your research team members in undertaking the set of activities listed in Column B? ",0]
[0,"Activities","Select from the dropdown menu","If yes, no. in last 1 year ","Select from the dropdown menu","T 4.3 Justification ","Score","Count of NA col1",{"$f":"COUNTIF(C284:C287,\"0\")","v":4}]
["a","Convene policy makers and other stakeholders to identify potential research areas ",0,0,0,0,{"$f":"VLOOKUP(E284,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},"Count of NA col2",{"$f":"COUNTIF(E284:E287,\"0\")","v":4},null,"Available",{"$f":"COUNTIF(C284:C287, \"Yes\")","v":0}]
["b","Analyze policy and programme documents for identification of research needs ",0,0,0,0,{"$f":"VLOOKUP(E285,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},"total questions",{"$f":"COUNTA(B284:B287)","v":4},null,"Not available",{"$f":"COUNTIF(C284:C287, \"No\")","v":0}]
["c","Organize events to collaboratively prioritize research agenda for at least 3 years engaging policy makers and other stakeholders ",0,0,0,0,{"$f":"VLOOKUP(E286,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},"Available activitite s",{"$f":"COUNTIF(C284:C287, \"Yes\")","v":0}]
["d","Identify relevant government entities /officials and obtain feedback on the research proposal from government authorities/bodies related to subject matter (other than ethical clearance process of ERB-NHRC)",0,0,0,0,{"$f":"VLOOKUP(E287,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,"Max possible score",{"$f":"(I285-I284)*3","v":0}]
[null,null,null,null,null,null,null,"Min possible score",{"$f":"(I285-I284)*1","v":0}]
[null,null,null,null,null,null,null,"Total score",{"$f":"SUMIF(G284:G287, \"<>#N/A\")","v":0}]
[]
["SN","Activities","Presence","Rate"]
[{"$f":"A284:A287","v":"a"},{"$f":"B284:B287","v":"Convene policy makers and other stakeholders to identify potential research areas "},{"$f":"C284:C287","v":0},{"$f":"E284:E287","v":0}]
["b","Analyze policy and programme documents for identification of research needs ",0,0]
["c","Organize events to collaboratively prioritize research agenda for at least 3 years engaging policy makers and other stakeholders ",0,0]
["d","Identify relevant government entities /officials and obtain feedback on the research proposal from government authorities/bodies related to subject matter (other than ethical clearance process of ERB-NHRC)",0,0]
["Rate",0]
[]
["Research Conceptualization"]
["Analyze policy and programme documents for identification of research needs "]
["Convene policy makers and other stakeholders to identify potential research areas "]
["Organize events to collaboratively prioritize research agenda for at least 3 years engaging policy makers and other stakeholders "]
["Identify relevant government entities /officials and obtain feedback on the research proposal from government authorities/bodies related to subject matter (other than ethical clearance process of ERB-NHRC)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Subdomain 5: Literature review, referencing and citation"]
[{"$f":"'Technical Competency'!A87:E97","v":"SN "},"Steps/standards ","T 5.1 Which of the steps or standards does your organization usually complete during literature review? (usually means: the majority of research staff for the majority of times","T 5.2 How would you rate the average skills of your research team members in undertaking the set of activities listed in Column B?  ",0]
[0,"Steps/standards ","Select from the dropdown menu","Select from the dropdown menu","Justification ",null,null,"Count of NA col1",{"$f":"COUNTIF(C325:C332,\"0\")","v":8}]
["A","B","C","D","E","Score",null,"Count of NA col2",{"$f":"COUNTIF(D325:D332,\"0\")","v":8},null,"Available",{"$f":"COUNTIF(C325:C332, \"Yes\")","v":0}]
["a","Define search topic/question in advance before searching for literatures ",0,0,0,{"$f":"VLOOKUP(D325,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},null,"total questions",{"$f":"COUNTA(B325:B332)","v":8},null,"Not available",{"$f":"COUNTIF(C325:C332, \"No\")","v":0}]
["b","Develop search strategy ",0,0,0,{"$f":"VLOOKUP(D326,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},null,"Available activitite s",{"$f":"COUNTIF(C324:C332, \"Yes\")","v":0}]
["c","Run systematic search in different databases ",0,0,0,{"$f":"VLOOKUP(D327,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}}]
["d","Maintain library of relevant literatures  ",0,0,0,{"$f":"VLOOKUP(D328,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},null,"Max possible score",{"$f":"(I325-I324)*3","v":0}]
["e","Evaluate the quality of evidence using a defined set of criteria ",0,0,0,{"$f":"VLOOKUP(D329,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},null,"Min possible score",{"$f":"(I325-I324)*1","v":0}]
["f","Prepare summary of the evidence ",0,0,0,{"$f":"VLOOKUP(D330,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},null,"Total score",{"$f":"SUMIF(F324:F332, \"<>#N/A\")","v":0}]
["g","Adopt standard styles for referencing and citation  ",0,0,0,{"$f":"VLOOKUP(D331,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}}]
["h","Use reference managers for improving efficiency and quality of work",0,0,0,{"$f":"VLOOKUP(D332,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[]
[]
["D","(All)"]
[]
["Literature review, referencing and citation"]
["Adopt standard styles for referencing and citation  "]
["Define search topic/question in advance before searching for literatures "]
["Develop search strategy "]
["Evaluate the quality of evidence using a defined set of criteria "]
["Maintain library of relevant literatures  "]
["Prepare summary of the evidence "]
["Run systematic search in different databases "]
["Use reference managers for improving efficiency and quality of work"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Research design and methods"]
[]
[]
[{"$f":"'Technical Competency'!A105:F115","v":"SN "},"Activities","T 6.1 Which of the following activities do research team members in your organization usually complete during the research design phase? ","T 6.2 How would you rate the average skills of your research team members in undertaking the set of activities listed in Column B? ",0,0]
[0,"Activities","Select from the dropdown menu","Select from the dropdown menu","T 6.3 Justification",0]
["A","B","C","D","E",0,"Score"]
["a","Organize workshops/events to collaboratively design the research project (policy makers and other stakeholders) ",0,0,0,0,{"$f":"VLOOKUP(D366,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},"Count of NA col1",{"$f":"COUNTIF(C366:C374,\"0\")","v":8}]
["b","Identify relevant government entities /officials and obtain feedback on the research proposal from government authorities/bodies related to subject matter ",0,0,0,0,{"$f":"VLOOKUP(D367,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},"Count of NA col2",{"$f":"COUNTIF(D366:D373,\"0\")","v":8},null,"Available",{"$f":"COUNTIF(C366:C373, \"Yes\")","v":0}]
["c","Estimate study sample size independently or have mechanism/capability to secure mechanism for sampling including sample size estimation, domain analysis based on sample efficiency and logistical feasibility (quantitative study)  ",0,0,0,0,{"$f":"VLOOKUP(D368,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},"total questions",{"$f":"COUNTA(B366:B373)","v":8},null,"Not available",{"$f":"COUNTIF(C366:C373, \"No\")","v":0}]
["d","Employ theoretical methods in determining sample size for qualitative studies through internal team or have roster/mechanism to secure relevant expert (qualitative study) ",0,0,0,0,{"$f":"VLOOKUP(D369,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},"Available activitite s",{"$f":"COUNTIF(C366:C373, \"Yes\")","v":0}]
["e","Identify appropriate data collection methods (for example, household survey, focused group discussion, qualitative interviews, observation schedule)",0,0,0,0,{"$f":"VLOOKUP(D370,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}}]
["f","Develop data collection tool ensuring consistency, coherence, and in alignment with the research objective  ",0,0,0,0,{"$f":"VLOOKUP(D371,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},"Max possible score",{"$f":"(I368-I367)*3","v":0}]
["g","Establishing or ensuring validity and reliability of the data collection tool through cognitive interviews, pretesting, statistical analysis and other approaches as appropriate techniques ",0,0,0,0,{"$f":"VLOOKUP(D372,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},"Min possible score",{"$f":"(I368-I367)*1","v":0}]
["h","Consider Gender Equality and Social Inclusion issues in designing research projects ",0,0,0,0,{"$f":"VLOOKUP(D373,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},"Total score",{"$f":"SUMIF(G366:G374, \"<>#N/A\")","v":0}]
[null,null,null,null,null,null,{"$f":"VLOOKUP(D374,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[]
[]
[]
[]
[]
[{"$f":"A365:F374","v":"A"},"B","C","D","E",0]
["a","Organize workshops/events to collaboratively design the research project (policy makers and other stakeholders) ",0,0,0,0]
["b","Identify relevant government entities /officials and obtain feedback on the research proposal from government authorities/bodies related to subject matter ",0,0,0,0]
["c","Estimate study sample size independently or have mechanism/capability to secure mechanism for sampling including sample size estimation, domain analysis based on sample efficiency and logistical feasibility (quantitative study)  ",0,0,0,0]
["d","Employ theoretical methods in determining sample size for qualitative studies through internal team or have roster/mechanism to secure relevant expert (qualitative study) ",0,0,0,0]
["e","Identify appropriate data collection methods (for example, household survey, focused group discussion, qualitative interviews, observation schedule)",0,0,0,0]
["f","Develop data collection tool ensuring consistency, coherence, and in alignment with the research objective  ",0,0,0,0]
["g","Establishing or ensuring validity and reliability of the data collection tool through cognitive interviews, pretesting, statistical analysis and other approaches as appropriate techniques ",0,0,0,0]
["h","Consider Gender Equality and Social Inclusion issues in designing research projects ",0,0,0,0]
[0,0,0,0,0,0]
[]
[]
["D",0]
[]
["Research design and methods"]
["Consider Gender Equality and Social Inclusion issues in designing research projects "]
["Develop data collection tool ensuring consistency, coherence, and in alignment with the research objective  "]
["Employ theoretical methods in determining sample size for qualitative studies through internal team or have roster/mechanism to secure relevant expert (qualitative study) "]
["Establishing or ensuring validity and reliability of the data collection tool through cognitive interviews, pretesting, statistical analysis and other approaches as appropriate techniques "]
["Estimate study sample size independently or have mechanism/capability to secure mechanism for sampling including sample size estimation, domain analysis based on sample efficiency and logistical feasibility (quantitative study)  "]
["Identify relevant government entities /officials and obtain feedback on the research proposal from government authorities/bodies related to subject matter "]
["Organize workshops/events to collaboratively design the research project (policy makers and other stakeholders) "]
["Identify appropriate data collection methods (for example, household survey, focused group discussion, qualitative interviews, observation schedule)"]
[0]
[]
[]
[]
[]
[]
[]
[]
["Research Implementation"]
[{"$f":"'Technical Competency'!A126:E130","v":"A"},"B","C","D","E",null,"Score"]
["a","Define competency criteria and recruit appropriate field/research staffs required for the project ",0,0,0,null,{"$f":"VLOOKUP(D414,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},"Count of NA col1",{"$f":"COUNTIF(C414:C418,\"0\")","v":4}]
["b","Develop field/implementation guide for field enumerators ",0,0,0,null,{"$f":"VLOOKUP(D415,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},"Count of NA col2",{"$f":"COUNTIF(D414:D419,\"0\")","v":4},null,"Available",{"$f":"COUNTIF(C414:C418, \"Yes\")","v":0}]
["c","Conduct training of the field staffs on implementation of research protocol, tools, modules and methodologies and ethical compliance ",0,0,0,null,{"$f":"VLOOKUP(D416,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},"total questions",{"$f":"COUNTA(B414:B417)","v":4},null,"Not available",{"$f":"COUNTIF(C414:C418, \"No\")","v":0}]
["d","Measure or assess training effectiveness ",0,0,0,null,{"$f":"VLOOKUP(D417,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},"Available activitite s",{"$f":"COUNTIF(C414:C417, \"Yes\")","v":0}]
[null,null,null,null,null,null,{"$f":"VLOOKUP(D418,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,"Max possible score",{"$f":"(I416-I415)*3","v":0}]
[null,null,null,null,null,null,null,"Min possible score",{"$f":"(I416-I415)*1","v":0}]
[]
["D","(All)"]
[null,null,null,null,null,null,null,"Total score",{"$f":"SUMIF(G414:G424, \"<>#N/A\")","v":0}]
["Row Labels"]
["Conduct training of the field staffs on implementation of research protocol, tools, modules and methodologies and ethical compliance "]
["Define competency criteria and recruit appropriate field/research staffs required for the project "]
["Develop field/implementation guide for field enumerators "]
["Measure or assess training effectiveness "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"'Technical Competency'!A140:E148","v":"A"},"B","C","D","E","Score"]
["a","Use statistical software for quantitative data analysis ",0,0,0,{"$f":"VLOOKUP(D443,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},"Count of NA col1",{"$f":"COUNTIF(C443:C450,\"0\")","v":8}]
["b","Perform basic quantitative data analysis (descriptive analysis including measure of central tendency, frequency and graphical presentation of data and bivariate analysis) ",0,0,0,{"$f":"VLOOKUP(D444,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},"Count of NA col2",{"$f":"COUNTIF(D443:D450,\"0\")","v":8},null,null,"Available",{"$f":"COUNTIF(C443:C450, \"Yes\")","v":0}]
["c","Perform advanced quantitative data analysis involving advanced statistical analysis (for example regression analysis) depending on the nature of data ",0,0,0,{"$f":"VLOOKUP(D445,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},"total questions",{"$f":"COUNTA(B443:B450)","v":8},null,null,"Not available",{"$f":"COUNTIF(C443:C450, \"No\")","v":0}]
["d","Use software for qualitative data analysis/data organization ",0,0,0,{"$f":"VLOOKUP(D446,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},"Available activitite s",{"$f":"COUNTIF(B444:B447, \"Yes\")","v":0}]
["e","Analyze qualitative data to identify patterns, themes, and insights, leading to a deeper understanding of the underlying phenomena. ",0,0,0,{"$f":"VLOOKUP(D447,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}}]
["f","Appropriately combine qualitative and quantitative method in data  analysis stage ",0,0,0,{"$f":"VLOOKUP(D448,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},"Max possible score",{"$f":"(H445-H444)*3","v":0}]
["g","Manage security and storage provisions preventing unauthorized access, data loss, and ensuring confidentiality adhering to the national ethical guidelines  ",0,0,0,{"$f":"VLOOKUP(D449,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},"Min possible score",{"$f":"(H445-H444)*1","v":0}]
["h","Perform analysis from equity perspective including gender equity and social inclusion analysis ",0,0,0,{"$f":"VLOOKUP(D450,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},"Total score",{"$f":"SUMIF(F443:F451, \"<>#N/A\")","v":0}]
[null,"D",0]
[]
[null,"Data management and analysis"]
[null,"Analyze qualitative data to identify patterns, themes, and insights, leading to a deeper understanding of the underlying phenomena. "]
[null,"Manage security and storage provisions preventing unauthorized access, data loss, and ensuring confidentiality adhering to the national ethical guidelines  "]
[null,"Perform advanced quantitative data analysis involving advanced statistical analysis (for example regression analysis) depending on the nature of data "]
[null,"Perform analysis from equity perspective including gender equity and social inclusion analysis "]
[null,"Perform basic quantitative data analysis (descriptive analysis including measure of central tendency, frequency and graphical presentation of data and bivariate analysis) "]
[null,"Use software for qualitative data analysis/data organization "]
[null,"Use statistical software for quantitative data analysis "]
[null,"Appropriately combine qualitative and quantitative method in data  analysis stage "]
[]
[{"$f":"'Technical Competency'!A151","v":"Subdomain 9: Scientific writing"}]
[{"$f":"'Technical Competency'!A158:F163","v":"A"},"B","C","D","E","F","Count of NA col1",{"$f":"COUNTIF(C465:C469,\"0\")","v":5},"score"]
["a","Develop strategic and feasible plan for writing study reports and manuscripts ",0,0,0,0,"Count of NA col2",{"$f":"COUNTIF(E465:E469,\"0\")","v":5},{"$f":"VLOOKUP(E465,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},null,"Available",{"$f":"COUNTIF(C465:C469, \"Yes\")","v":0}]
["b","Write technically sound, clear and understandable research report summarizing research methodology, methods and policy/programme implications that does not require extensive editing ",0,0,0,0,"total questions",{"$f":"COUNTA(B465:B469)","v":5},{"$f":"VLOOKUP(E466,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},null,"Not available",{"$f":"COUNTIF(C465:C469, \"No\")","v":0}]
["c","Engage policy makers and/or programme managers in preparing the technical report ",0,0,0,0,"Available activitite s",{"$f":"COUNTIF(C465:C469, \"Yes\")","v":0},{"$f":"VLOOKUP(E467,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}}]
["d","Develop manuscript with researchers in your organization as first author ",0,0,0,0,null,null,{"$f":"VLOOKUP(E468,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}}]
["e","Develop manuscript with researchers in your organization as co-authors (other than first author) ",0,0,0,0,"Max possible score",{"$f":"(H466-H465)*3","v":0},{"$f":"VLOOKUP(E469,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"Min possible score",{"$f":"(H466-H465)*1","v":0},{"$f":"VLOOKUP(E470,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"Total score",{"$f":"SUMIF(I465:I470,\"<>#N/A\")","v":0}]
["E","(All)"]
[]
["Row Labels"]
["Develop manuscript with researchers in your organization as co-authors (other than first author) "]
["Develop manuscript with researchers in your organization as first author "]
["Develop strategic and feasible plan for writing study reports and manuscripts "]
["Engage policy makers and/or programme managers in preparing the technical report "]
["Write technically sound, clear and understandable research report summarizing research methodology, methods and policy/programme implications that does not require extensive editing "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"'Technical Competency'!A176:F181","v":"A"},"B","C","D","E","F","Count of NA col1",{"$f":"COUNTIF(C493:C497,\"0\")","v":5},"score"]
["a","Document lessons learnt during pretesting and implementation phase of research ",0,0,0,0,"Count of NA col2",{"$f":"COUNTIF(E493:E497,\"0\")","v":5},{"$f":"VLOOKUP(E493,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},null,"Available",{"$f":"COUNTIF(C493:C497, \"Yes\")","v":0}]
["b","Set up and implement quality control mechanism including cross validation of data collected ",0,0,0,0,"total questions",{"$f":"COUNTA(B493:B497)","v":5},{"$f":"VLOOKUP(E494,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},null,"Not available",{"$f":"COUNTIF(C493:C497, \"No\")","v":0}]
["c","Real-time monitoring of field data to evaluate target against the timeline ",0,0,0,0,"Available activitite s",{"$f":"COUNTIF(C493:C497, \"Yes\")","v":0},{"$f":"VLOOKUP(E495,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}}]
["d","Organize joint monitoring event with policy makers/programme managers or other stakeholders ",0,0,0,0,null,null,{"$f":"VLOOKUP(E496,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}}]
["e","Review progress/ preliminary results with policy makers/programme managers or other stakeholders ",0,0,0,0,"Max possible score",{"$f":"(H494-H493)*3","v":0},{"$f":"VLOOKUP(E497,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"Min possible score",{"$f":"(H494-H493)*1","v":0}]
[null,null,null,null,null,null,"Total score",{"$f":"SUMIF(I493:I497,\"<>#N/A\")","v":0}]
[]
[]
["E","(All)"]
[]
["Quality check mechanism, monitoring and evaluation"]
["Document lessons learnt during pretesting and implementation phase of research "]
["Organize joint monitoring event with policy makers/programme managers or other stakeholders "]
["Real-time monitoring of field data to evaluate target against the timeline "]
["Review progress/ preliminary results with policy makers/programme managers or other stakeholders "]
["Set up and implement quality control mechanism including cross validation of data collected "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Network and colaboration"]
[]
["Network and collaboration"]
[{"$f":"'Networking,Collab & Co-Creation'!A51:E57","v":"A "},"B ","C","D","E",null,"Count of NA col1",{"$f":"COUNTIF(C525:C535,\"0\")","v":6},"score","score"]
["A ","Identify and map stakeholders relevant to the research projects or organization's scope of work",0,0,0,null,"Count of NA col2",{"$f":"COUNTIF(D525:D535,\"0\")","v":6},{"$f":"VLOOKUP(D525,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(I525), 0,I525)","v":0},"Available",{"$f":"COUNTIF(C525:C535, \"Yes\")","v":0}]
["b","Maintain a database of potential collaborators and their areas of expertise",0,0,0,null,"total questions",{"$f":"COUNTA(B525:B535)","v":6},{"$f":"VLOOKUP(D526,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(I526), 0,I526)","v":0},"Not available",{"$f":"COUNTIF(C525:C535, \"No\")","v":0}]
["c","Collaborate with national organizations (research, academics or other)",0,0,0,null,"Available activitite s",{"$f":"COUNTIF(C525:C535, \"Yes\")","v":0},{"$f":"VLOOKUP(D527,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},0]
["d","Collaborate with international organizations (research, academics or other)",0,0,0,null,null,null,{"$f":"VLOOKUP(D528,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},0]
["e","Form or work in consortium at national level for bidding / applying for research calls /grants",0,0,0,null,"Max possible score",{"$f":"(H526-H525)*3","v":0},{"$f":"VLOOKUP(D529,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},0]
["f","Form  or work in consortium at innational level for bidding / applying for research calls /grants",0,0,0,null,"Min possible score",{"$f":"(H526-H525)*1","v":0},{"$f":"VLOOKUP(D530,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,null,"Total score",{"$f":"SUM(J525:J535)","v":0},{"$f":"VLOOKUP(D531,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(D532,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(D533,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(D534,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(D535,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},0]
[]
[]
["D","(All)"]
[]
["Series of standards and steps related to networking, collaboration and co-creation.  "]
["Maintain a database of potential collaborators and their areas of expertise"]
["Identify and map stakeholders relevant to the research projects or organization's scope of work"]
["Collaborate with national organizations (research, academics or other)"]
["Collaborate with international organizations (research, academics or other)"]
["Form or work in consortium at national level for bidding / applying for research calls /grants"]
["Form  or work in consortium at innational level for bidding / applying for research calls /grants"]
["(blank)"]
[]
[]
[]
[]
[]
[]
[]
[]
["Evidence uptake"]
[]
[{"$f":"'Evidence Uptake'!A4:F15","v":"P 1"},"Knowledge products","P 1.1 Which of the following knowledge products does your organization produce?","P 1.2 What is the number of products developed/ event organized (specified from column B, Row 5 to 13)","P 1.3 How do you rate your organizational competency in developing the specified knowledge products or organizing events specified?","P 1.4 Justification","Count of NA col1",{"$f":"COUNTIF(C559:C571,\"0\")","v":11},"score","score"]
["a","Policy briefs/ project briefs tailored to the need of policy makers/ programme implementers",0,0,0,0,"Count of NA col2",{"$f":"COUNTIF(D559:D571,\"0\")","v":11},{"$f":"VLOOKUP(E559,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(I559), 0,I559)","v":0},"Available",{"$f":"COUNTIF(C559:C569, \"Yes\")","v":0}]
["b","Prepare non-technical summary of the research findings in national/local language ",0,0,0,0,"total questions",{"$f":"COUNTA(B559:B571)","v":11},{"$f":"VLOOKUP(E560,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(I560), 0,I560)","v":0},"Not available",{"$f":"COUNTIF(C559:C569, \"No\")","v":0}]
["c","Discussion papers",0,0,0,0,"Available activitite s",{"$f":"COUNTIF(C559:C571, \"Yes\")","v":0},{"$f":"VLOOKUP(E561,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},0]
["d","Newspaper articles",0,0,0,0,null,null,{"$f":"VLOOKUP(E562,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},0]
["e","Blog post",0,0,0,0,"Max possible score",{"$f":"(H560-H559)*3","v":0},{"$f":"VLOOKUP(E563,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},0]
["f","Infographics ",0,0,0,0,"Min possible score",{"$f":"(H560-H559)*1","v":0},{"$f":"VLOOKUP(E564,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},0]
["g","Video summary of the research findings",0,0,0,0,"Total score",{"$f":"SUM(J559:J570)","v":0},{"$f":"VLOOKUP(E565,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},0]
["h","Scientific papers",0,0,0,0,null,null,{"$f":"VLOOKUP(E566,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},0]
["i","Other (Please specify): ",0,0,0,0,null,null,{"$f":"VLOOKUP(E567,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},0]
["i","Other (Please specify): ",0,0,0,0,null,null,{"$f":"VLOOKUP(E568,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},0]
["i","Other (Please specify): ",0,0,0,0,null,null,{"$f":"VLOOKUP(E569,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"Dashboard!J152:K155","v":"Operational research"},0]
["Policy analysis",0]
["Scoping review/ narrative review",0]
["Systematic review/Meta analysis",0]
[]
[]
[]
[]
[]
[]
["Study type"]
[{"$f":"RIGHT(A603,LEN(A603))","v":"Policy analysis"},{"$f":"B603","v":0}]
[{"$f":"RIGHT(A604,LEN(A604))","v":"Scoping review/ narrative review"},{"$f":"B604","v":0}]
["Systematic review/Meta analysis",0]
["",0]
["",0]
["",0]
["",0]
[]
[]
[]
[]
[]
[]
["Row Labels"]
["Blog post"]
["Discussion papers"]
["Infographics "]
["Newspaper articles"]
["Other (Please specify): "]
["Policy briefs/ project briefs tailored to the need of policy makers/ programme implementers"]
["Prepare non-technical summary of the research findings in national/local language "]
["Scientific papers"]
["Video summary of the research findings"]
["Grand Total"]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"'Evidence Uptake'!A17:F27","v":"P2"},"Events","How often does your institution organize knowledge sharing or dissemination events specified ? Question for Column C","P 2.2 What is the number of knowledge sharing or dissemination events organized by your organization in past one year? Column D","P 2.3 How do you rate your organizational competency in organizing knowledge sharing/ dissemination events specified? Column E","P 2.4 Justification for assigning specific rating on competency in Column E (Column F)","Count of NA col1",{"$f":"COUNTIF(C645:C657,\"0\")","v":10},"score","score"]
["a","Webinars and seminars to share the learnings",0,0,0,0,"Count of NA col2",{"$f":"COUNTIF(E645:E657,\"0\")","v":10},{"$f":"VLOOKUP(E645,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(I645), 0,I645)","v":0},"Available",{"$f":"COUNTIF(C645:C655, \"Yes\")","v":0}]
["b","Social media campaigns based on findings from evidence generated",0,0,0,0,"total questions",{"$f":"COUNTA(B645:B657)","v":10},{"$f":"VLOOKUP(E646,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},0,"Not available",{"$f":"COUNTIF(C645:C655, \"No\")","v":0}]
["c","Interaction/ discussion with policy makers about evidence and their applicability",0,0,0,0,"Available activitite s",{"$f":"COUNTIF(C645:C657, \"Yes\")","v":0},{"$f":"VLOOKUP(E647,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},0]
["d","Organize dissemination events with local stakeholders/beneficiaries ",0,0,0,0,null,null,{"$f":"VLOOKUP(E648,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},0]
["e","Organize dissemination events with policy makers and other stakeholders at policy making level",0,0,0,0,"Max possible score",{"$f":"(H646-H645)*3","v":0},{"$f":"VLOOKUP(E649,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},0]
["f","Organize dissemination events with policy makers and other stakeholders at programme implementing level",0,0,0,0,"Min possible score",{"$f":"(H646-H645)*1","v":0},{"$f":"VLOOKUP(E650,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},0]
["g","Document the impact and effectiveness of HPSR programs in influencing policy decisions and healthcare outcomes",0,0,0,0,"Total score",{"$f":"SUM(J645:J656)","v":0},{"$f":"VLOOKUP(E651,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},0]
["h","Deliver presentations at national level conferences, seminars, summits etc.",0,0,0,0,null,null,{"$f":"VLOOKUP(E652,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},0]
["i","Deliver presentations at international level conferences, seminars and summits ",0,0,0,0,null,null,{"$f":"VLOOKUP(E653,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},0]
["j","Organize events/ discussions responding to the evidence gap highlighted or evidence requested by policy makers/ programme implementers",0,0,0,0,null,null,{"$f":"VLOOKUP(E654,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(E655,'Data processing'!$A$9:$B$13,2,FALSE)","v":{"$error":"#N/A"}},0]
[]
[]
[]
[]
[]
[null,"P 2.3 How do you rate your organizational competency in organizing knowledge sharing/ dissemination events specified? Column E","(All)"]
[]
[null,"Row Labels"]
[null,"Deliver presentations at international level conferences, seminars and summits "]
[null,"Deliver presentations at national level conferences, seminars, summits etc."]
[null,"Interaction/ discussion with policy makers about evidence and their applicability"]
[null,"Organize dissemination events with local stakeholders/beneficiaries "]
[null,"Organize dissemination events with policy makers and other stakeholders at policy making level"]
[null,"Organize dissemination events with policy makers and other stakeholders at programme implementing level"]
[null,"Organize events/ discussions responding to the evidence gap highlighted or evidence requested by policy makers/ programme implementers"]
[null,"Social media campaigns based on findings from evidence generated"]
[null,"Webinars and seminars to share the learnings"]
[null,"Document the impact and effectiveness of HPSR programs in influencing policy decisions and healthcare outcomes"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Overall"]
["Organizational  managemrent"]
[null,"Leadership and management",{"$f":"M70","v":18}]
[null,"Infrastructures, technology and mechanism",{"$f":"M98","v":0}]
[null,"Financial management and sustainability",{"$f":"M147","v":0}]
[]
[]
[]
[null,"Ethics and safeguarding",{"$f":"M202","v":0}]
[null,"Activities or steps involved in conceptual conceptualization process",{"$f":"I251","v":0}]
[null,"Research conceptualization",{"$f":"I289","v":0}]
[null,"Literature review, referencing and citation",{"$f":"I330","v":0}]
[null,"Research design and methods",{"$f":"I373","v":0}]
[null,"Research Implementation",{"$f":"I423","v":0}]
[null,"Scientific Writing",{"$f":"H471","v":0}]
[null,"Quality check mechanism, monitoring and evaluation",{"$f":"H499","v":0}]
[]
[]
[]
[]
[]
[]
[null,"Netwporking, Collaboration and Co-Creation",{"$f":"H531","v":0}]
[]
[null,"Evidence uptake-Knowledge",{"$f":"H565","v":0}]
[null,"Evidence uptake-Events",{"$f":"H651","v":0}]

{"sheet":"Dashboard","index":7,"n_rows":350,"n_cols":11,"rows_kept":350,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Staffs"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null," Leadership and management"]
[]
[null,null,null,null,null,null,null,null,"if(isblank(",{"$f":"IF(ISBLANK(Dataset!D75), \"\",Dataset!D75)","v":"Leadership and management related activities"}]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(J65),J65=\"\"),\"\",\">>\")","v":">>"},{"$f":"IF(ISBLANK(Dataset!D76), \"\",Dataset!D76)","v":"Make use of project management software to track progress or deviation from the project timeline"}]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(J66),J66=\"\"),\"\",\">>\")","v":">>"},{"$f":"IF(ISBLANK(Dataset!D77), \"\",Dataset!D77)","v":"Conduct periodic  capacity assessment identifying capacity gaps among employees"}]
[null,null,null,null,null,null,null,null,">>",{"$f":"IF(ISBLANK(Dataset!D78), \"\",Dataset!D78)","v":"Engage with external experts and advisory committees to review and provide tguidance on research activities"}]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(Dataset!D79), \"\",Dataset!D79)","v":""}]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(Dataset!D80), \"\",Dataset!D80)","v":""}]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(Dataset!D81), \"\",Dataset!D81)","v":""}]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(Dataset!D123), \"\",Dataset!D123)","v":""}]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(Dataset!D124), \"\",Dataset!D124)","v":""}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Dataset!D125), \"\",Dataset!D125)","v":""}]
[]
[]
[null,{"$f":"J80","v":"Infrastructures, technology and mechanism"}]
[]
[]
[null,null,null,null,null,null,null,null,"if(isblank(",{"$f":"Dataset!$A$89","v":"Infrastructures, technology and mechanism"}]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(J81),J81=\"\"),\"\",\">>\")","v":">>"},{"$f":"IF(ISBLANK(Dataset!D109), \"\",Dataset!D109)","v":"Digital platforms available to facilitate online collaboration, data analysis, and information sharing"}]
[null,null,null,null,null,null,null,null,">>",{"$f":"IF(ISBLANK(Dataset!D110), \"\",Dataset!D110)","v":"Experts for project monitoring and evaluation (at organizational level rather than specific research project)"}]
[null,null,null,null,null,null,null,null,">>",{"$f":"IF(ISBLANK(Dataset!D111), \"\",Dataset!D111)","v":"Information management system (electronic or manual) for monitoring research projects"}]
[null,null,null,null,null,null,null,null,">>",{"$f":"IF(ISBLANK(Dataset!D112), \"\",Dataset!D112)","v":"Mechanism to identify and address potential challenges during project evaluation"}]
[null,null,null,null,null,null,null,null,">>",{"$f":"IF(ISBLANK(Dataset!D113), \"\",Dataset!D113)","v":"Mechanisms to involve external experts/policy makers/other stakeholders in  monitoring and evaluating research projects"}]
[null,null,null,null,null,null,null,null,">>",{"$f":"IF(ISBLANK(Dataset!D114), \"\",Dataset!D114)","v":"Necessary physical facilities and spaces to support multiple research project/ diverse set of activities"}]
[null,null,null,null,null,null,null,null,">>",{"$f":"IF(ISBLANK(Dataset!D115), \"\",Dataset!D115)","v":"Process in place to track deviations from planned project timelines"}]
[null,null,null,null,null,null,null,null,">>",{"$f":"IF(ISBLANK(Dataset!D116), \"\",Dataset!D116)","v":"Protocols for sharing resources and coordinating logistics in collaborative projects"}]
[null,null,null,null,null,null,null,null,">>",{"$f":"IF(ISBLANK(Dataset!D117), \"\",Dataset!D117)","v":"Standard guideline, tool and templates for field monitoring and supervision "}]
[null,null,null,null,null,null,null,null,">>",{"$f":"IF(ISBLANK(Dataset!D118), \"\",Dataset!D118)","v":"Technological infrastructure (hardware, software, networks) to support routine research activities"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Dataset!D119), \"\",Dataset!D119)","v":""}]
[null,"Financial management and sustainability "]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"B92","v":"Financial management and sustainability "}]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(J95),J95=\"\"),\"\",\">>\")","v":">>"},{"$f":"IF(ISBLANK(Dataset!B152), \"\",Dataset!B152)","v":"Engage in long-term financial planning to secure funding for continuous research endeavors and innovation"}]
[null,null,null,null,null,null,null,null,">>",{"$f":"IF(ISBLANK(Dataset!B153), \"\",Dataset!B153)","v":"Ensure compliance with funding regulations and requirements set by different funding sources"}]
[null,null,null,null,null,null,null,null,">>",{"$f":"IF(ISBLANK(Dataset!B154), \"\",Dataset!B154)","v":"Have contingency plans to address potential shocks in financial status of the organization"}]
[null,null,null,null,null,null,null,null,">>",{"$f":"IF(ISBLANK(Dataset!B155), \"\",Dataset!B155)","v":"Keep record of all financial and administrative activities"}]
[null,null,null,null,null,null,null,null,">>",{"$f":"IF(ISBLANK(Dataset!B156), \"\",Dataset!B156)","v":"Maintain or take initiatives to maintain diversity in business portfolio for organizational sustainability"}]
[null,null,null,null,null,null,null,null,">>",{"$f":"IF(ISBLANK(Dataset!B157), \"\",Dataset!B157)","v":"Undertake procurement of goods and logistics in timely manner"}]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(Dataset!B158), \"\",Dataset!B158)","v":""}]
[]
[]
[]
[]
[]
[null,"Number of research staff with specified educational level, methodological expertise, specific technical skills and experience"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null," Undertaken the following type of studies/analysis in the last five years"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Research/Analysis","Number"]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(J149),J149=\"\"),\"\",\">>\")","v":">>"},{"$f":"IF(ISBLANK(Dataset!M163), \"\",Dataset!M163)","v":"Cost estimation/economic evaluations"},{"$f":"IF(ISBLANK(Dataset!N163), \"\",Dataset!N163)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(J150),J150=\"\"),\"\",\">>\")","v":">>"},{"$f":"IF(ISBLANK(Dataset!M164), \"\",Dataset!M164)","v":"Evaluation of complex health system interventions"},{"$f":"IF(ISBLANK(Dataset!N164), \"\",Dataset!N164)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(J151),J151=\"\"),\"\",\">>\")","v":">>"},{"$f":"IF(ISBLANK(Dataset!M165), \"\",Dataset!M165)","v":"Implementation research"},{"$f":"IF(ISBLANK(Dataset!N165), \"\",Dataset!N165)","v":0}]
[null,null,null,null,null,null,null,null,">>",{"$f":"IF(ISBLANK(Dataset!M166), \"\",Dataset!M166)","v":"Operational research"},{"$f":"IF(ISBLANK(Dataset!N166), \"\",Dataset!N166)","v":0}]
[null,null,null,null,null,null,null,null,">>",{"$f":"IF(ISBLANK(Dataset!M167), \"\",Dataset!M167)","v":"Policy analysis"},{"$f":"IF(ISBLANK(Dataset!N167), \"\",Dataset!N167)","v":0}]
[null,null,null,null,null,null,null,null,">>",{"$f":"IF(ISBLANK(Dataset!M168), \"\",Dataset!M168)","v":"Scoping review/ narrative review"},{"$f":"IF(ISBLANK(Dataset!N168), \"\",Dataset!N168)","v":0}]
[null,null,null,null,null,null,null,null,">>",{"$f":"IF(ISBLANK(Dataset!M169), \"\",Dataset!M169)","v":"Systematic review/Meta analysis"}]
[null,null,null,null,null,null,null,null,">>",{"$f":"IF(ISBLANK(Dataset!M170), \"\",Dataset!M170)","v":"Tool development and validation studies"}]
[null,null,null,null,null,null,null,null,">>",{"$f":"IF(ISBLANK(Dataset!M171), \"\",Dataset!M171)","v":"Undertaking large scale surveys"}]
[null,null,null,null,null,null,null,null,">>",{"$f":"IF(ISBLANK(Dataset!M172), \"\",Dataset!M172)","v":"Undertaking participatory research"}]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(Dataset!M173), \"\",Dataset!M173)","v":""}]
[]
[]
[null,"Steps/standards do research team members in your organization usually undertake in terms of ethics and safeguarding"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Dataset!A190), \"\", Dataset!A190)","v":"Ethics and safeguarding"}]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(J167),J167=\"\"),\"\",\">>\")","v":">>"},{"$f":"IF(ISBLANK(Dataset!G210), \"\",Dataset!G210)","v":"Conduct continuous ethical review (on periodic basis) of ongoing research to ensure adherence to ethical standards"}]
[null,null,null,null,null,null,null,null,">>",{"$f":"IF(ISBLANK(Dataset!G211), \"\",Dataset!G211)","v":"Have mechanisms in place within the organization, aligning with national ethical guideline for handling research misconduct "}]
[null,null,null,null,null,null,null,null,">>",{"$f":"IF(ISBLANK(Dataset!G212), \"\",Dataset!G212)","v":"Monitoring compliance to ethical standards in research project  (Monitor study procedures, maintenance of privacy, confidentiality and participant welfare to ensure adherence to ethical guidelines)"}]
[null,null,null,null,null,null,null,null,">>",{"$f":"IF(ISBLANK(Dataset!G213), \"\",Dataset!G213)","v":"Obtain ethical clearance from relevant authority before undertaking any research involving human participants as per national ethical guideline"}]
[null,null,null,null,null,null,null,null,">>",{"$f":"IF(ISBLANK(Dataset!G214), \"\",Dataset!G214)","v":"Obtain written or verbal informed consent from all participants in research involving human subject"}]
[null,null,null,null,null,null,null,null,">>",{"$f":"IF(ISBLANK(Dataset!G215), \"\",Dataset!G215)","v":"Practice declaration of the conflict of interest of research team members before undertaking research activities"}]
[null,null,null,null,null,null,null,null,">>",{"$f":"IF(ISBLANK(Dataset!G216), \"\",Dataset!G216)","v":"Report any violation of ethical principles to relevant ethical review boards or institutional review committees"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Dataset!G217), \"\",Dataset!G217)","v":"Require mandatory ethical training to all research team members "}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Dataset!G219), \"\",Dataset!G219)","v":""}]
[]
[null,"Research Conceptualization"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Dataset!A299), \"\", Dataset!A299)","v":"Research Conceptualization"},"Number"]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(J182),J182=\"\"),\"\",\">>\")","v":">>"},{"$f":"IF(ISBLANK(Dataset!A300),\"\",Dataset!A300)","v":"Analyze policy and programme documents for identification of research needs "},{"$f":"IF(I182=\">>\",VLOOKUP(J182,Dataset!$B$245:$D$248,3,FALSE),\"\")","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(J183),J183=\"\"),\"\",\">>\")","v":">>"},{"$f":"IF(ISBLANK(Dataset!A301),\"\",Dataset!A301)","v":"Convene policy makers and other stakeholders to identify potential research areas "},{"$f":"IF(I183=\">>\",VLOOKUP(J183,Dataset!$B$245:$D$248,3,FALSE),\"\")","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(J184),J184=\"\"),\"\",\">>\")","v":">>"},{"$f":"IF(ISBLANK(Dataset!A302),\"\",Dataset!A302)","v":"Organize events to collaboratively prioritize research agenda for at least 3 years engaging policy makers and other stakeholders "},{"$f":"IF(I184=\">>\",VLOOKUP(J184,Dataset!$B$245:$D$248,3,FALSE),\"\")","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(J185),J185=\"\"),\"\",\">>\")","v":">>"},{"$f":"IF(ISBLANK(Dataset!A303),\"\",Dataset!A303)","v":"Identify relevant government entities /officials and obtain feedback on the research proposal from government authorities/bodies related to subject matter (other than ethical clearance process of ERB-NHRC)"},{"$f":"IF(I185=\">>\",VLOOKUP(J185,Dataset!$B$245:$D$248,3,FALSE),\"\")","v":0}]
[]
[]
[]
[]
[]
[null," Literature review, referencing and citation"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"Dataset!$A$338","v":"Literature review, referencing and citation"}]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(J196),J196=\"\"),\"\",\">>\")","v":">>"},{"$f":"IF(ISBLANK(Dataset!A339),\"\",Dataset!A339)","v":"Adopt standard styles for referencing and citation  "}]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(J197),J197=\"\"),\"\",\">>\")","v":">>"},{"$f":"IF(ISBLANK(Dataset!A340),\"\",Dataset!A340)","v":"Define search topic/question in advance before searching for literatures "}]
[null,null,null,null,null,null,null,null,">>",{"$f":"IF(ISBLANK(Dataset!A341),\"\",Dataset!A341)","v":"Develop search strategy "}]
[null,null,null,null,null,null,null,null,">>",{"$f":"IF(ISBLANK(Dataset!A342),\"\",Dataset!A342)","v":"Evaluate the quality of evidence using a defined set of criteria "}]
[null,null,null,null,null,null,null,null,">>",{"$f":"IF(ISBLANK(Dataset!A343),\"\",Dataset!A343)","v":"Maintain library of relevant literatures  "}]
[null,null,null,null,null,null,null,null,">>",{"$f":"IF(ISBLANK(Dataset!A344),\"\",Dataset!A344)","v":"Prepare summary of the evidence "}]
[null,null,null,null,null,null,null,null,">>",{"$f":"IF(ISBLANK(Dataset!A345),\"\",Dataset!A345)","v":"Run systematic search in different databases "}]
[null,null,null,null,null,null,null,null,">>",{"$f":"IF(ISBLANK(Dataset!A346),\"\",Dataset!A346)","v":"Use reference managers for improving efficiency and quality of work"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Dataset!A347),\"\",Dataset!A347)","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Dataset!A348),\"\",Dataset!A348)","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Dataset!A349),\"\",Dataset!A349)","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Dataset!A350),\"\",Dataset!A350)","v":""}]
[]
[]
[]
[null,"Research design and methods"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"Dataset!A395","v":"Research design and methods"}]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(J216),J216=\"\"),\"\",\">>\")","v":">>"},{"$f":"IF(ISBLANK( Dataset!A396),\"\", Dataset!A396)","v":"Consider Gender Equality and Social Inclusion issues in designing research projects "}]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(J217),J217=\"\"),\"\",\">>\")","v":">>"},{"$f":"IF(ISBLANK( Dataset!A397),\"\", Dataset!A397)","v":"Develop data collection tool ensuring consistency, coherence, and in alignment with the research objective  "}]
[null,null,null,null,null,null,null,null,">>",{"$f":"IF(ISBLANK( Dataset!A398),\"\", Dataset!A398)","v":"Employ theoretical methods in determining sample size for qualitative studies through internal team or have roster/mechanism to secure relevant expert (qualitative study) "}]
[null,null,null,null,null,null,null,null,">>",{"$f":"IF(ISBLANK( Dataset!A399),\"\", Dataset!A399)","v":"Establishing or ensuring validity and reliability of the data collection tool through cognitive interviews, pretesting, statistical analysis and other approaches as appropriate techniques "}]
[null,null,null,null,null,null,null,null,">>",{"$f":"IF(ISBLANK( Dataset!A400),\"\", Dataset!A400)","v":"Estimate study sample size independently or have mechanism/capability to secure mechanism for sampling including sample size estimation, domain analysis based on sample efficiency and logistical feasibility (quantitative study)  "}]
[null,null,null,null,null,null,null,null,">>",{"$f":"IF(ISBLANK( Dataset!A401),\"\", Dataset!A401)","v":"Identify relevant government entities /officials and obtain feedback on the research proposal from government authorities/bodies related to subject matter "}]
[null,null,null,null,null,null,null,null,">>",{"$f":"IF(ISBLANK( Dataset!A402),\"\", Dataset!A402)","v":"Organize workshops/events to collaboratively design the research project (policy makers and other stakeholders) "}]
[null,null,null,null,null,null,null,null,">>",{"$f":"IF(ISBLANK( Dataset!A403),\"\", Dataset!A403)","v":"Identify appropriate data collection methods (for example, household survey, focused group discussion, qualitative interviews, observation schedule)"}]
[null,{"$f":"Dataset!A412","v":"Research Implementation"}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Dataset!A412), \"\", Dataset!A412)","v":"Research Implementation"}]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(J229),J229=\"\"),\"\",\">>\")","v":">>"},{"$f":"IF(ISBLANK(Dataset!A425), \"\",Dataset!A425)","v":"Conduct training of the field staffs on implementation of research protocol, tools, modules and methodologies and ethical compliance "}]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(J230),J230=\"\"),\"\",\">>\")","v":">>"},{"$f":"IF(ISBLANK(Dataset!A426), \"\",Dataset!A426)","v":"Define competency criteria and recruit appropriate field/research staffs required for the project "}]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(J231),J231=\"\"),\"\",\">>\")","v":">>"},{"$f":"IF(ISBLANK(Dataset!A427), \"\",Dataset!A427)","v":"Develop field/implementation guide for field enumerators "}]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(J232),J232=\"\"),\"\",\">>\")","v":">>"},{"$f":"IF(ISBLANK(Dataset!A428), \"\",Dataset!A428)","v":"Measure or assess training effectiveness "}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Dataset!A429), \"\",Dataset!A429)","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Dataset!A430), \"\",Dataset!A430)","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Dataset!A431), \"\",Dataset!A431)","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Dataset!A432), \"\",Dataset!A432)","v":""}]
[]
[]
[]
[]
[]
[]
[null,"Data management and analysis"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Dataset!B453), \"\", Dataset!B453)","v":"Data management and analysis"}]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(J248),J248=\"\"),\"\",\">>\")","v":">>"},{"$f":"IF(ISBLANK(Dataset!B454), \"\", Dataset!B454)","v":"Analyze qualitative data to identify patterns, themes, and insights, leading to a deeper understanding of the underlying phenomena. "}]
[null,null,null,null,null,null,null,null,">>",{"$f":"IF(ISBLANK(Dataset!B455), \"\", Dataset!B455)","v":"Manage security and storage provisions preventing unauthorized access, data loss, and ensuring confidentiality adhering to the national ethical guidelines  "}]
[null,null,null,null,null,null,null,null,">>",{"$f":"IF(ISBLANK(Dataset!B456), \"\", Dataset!B456)","v":"Perform advanced quantitative data analysis involving advanced statistical analysis (for example regression analysis) depending on the nature of data "}]
[null,null,null,null,null,null,null,null,">>",{"$f":"IF(ISBLANK(Dataset!B457), \"\", Dataset!B457)","v":"Perform analysis from equity perspective including gender equity and social inclusion analysis "}]
[null,null,null,null,null,null,null,null,">>",{"$f":"IF(ISBLANK(Dataset!B458), \"\", Dataset!B458)","v":"Perform basic quantitative data analysis (descriptive analysis including measure of central tendency, frequency and graphical presentation of data and bivariate analysis) "}]
[null,null,null,null,null,null,null,null,">>",{"$f":"IF(ISBLANK(Dataset!B459), \"\", Dataset!B459)","v":"Use software for qualitative data analysis/data organization "}]
[null,null,null,null,null,null,null,null,">>",{"$f":"IF(ISBLANK(Dataset!B460), \"\", Dataset!B460)","v":"Use statistical software for quantitative data analysis "}]
[null,null,null,null,null,null,null,null,">>",{"$f":"IF(ISBLANK(Dataset!B461), \"\", Dataset!B461)","v":"Appropriately combine qualitative and quantitative method in data  analysis stage "}]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(Dataset!B462), \"\", Dataset!B462)","v":""}]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(Dataset!B463), \"\", Dataset!B463)","v":""}]
[null,"Scientific writing"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Dashboard!B258),\"\",Dashboard!B258)","v":"Scientific writing"},"Number"]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(J264),J264=\"\"),\"\",\">>\")","v":">>"},{"$f":"IF(ISBLANK(Dataset!$A$475),\"\",Dataset!A475)","v":"Develop manuscript with researchers in your organization as co-authors (other than first author) "},{"$f":"IF(I264=\">>\",VLOOKUP(J264,Dataset!$B$464:$D$469,3,FALSE),\"\")","v":0}]
[null,null,null,null,null,null,null,null,">>",{"$f":"IF(ISBLANK(Dataset!$A$475),\"\",Dataset!A476)","v":"Develop manuscript with researchers in your organization as first author "},{"$f":"IF(I265=\">>\",VLOOKUP(J265,Dataset!$B$464:$D$469,3,FALSE),\"\")","v":0}]
[null,null,null,null,null,null,null,null,">>",{"$f":"IF(ISBLANK(Dataset!$A$475),\"\",Dataset!A477)","v":"Develop strategic and feasible plan for writing study reports and manuscripts "},{"$f":"IF(I266=\">>\",VLOOKUP(J266,Dataset!$B$464:$D$469,3,FALSE),\"\")","v":0}]
[null,null,null,null,null,null,null,null,">>",{"$f":"IF(ISBLANK(Dataset!$A$475),\"\",Dataset!A478)","v":"Engage policy makers and/or programme managers in preparing the technical report "},{"$f":"IF(I267=\">>\",VLOOKUP(J267,Dataset!$B$464:$D$469,3,FALSE),\"\")","v":0}]
[null,null,null,null,null,null,null,null,">>",{"$f":"IF(ISBLANK(Dataset!$A$475),\"\",Dataset!A479)","v":"Write technically sound, clear and understandable research report summarizing research methodology, methods and policy/programme implications that does not require extensive editing "},{"$f":"IF(I268=\">>\",VLOOKUP(J268,Dataset!$B$464:$D$469,3,FALSE),\"\")","v":0}]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(Dataset!A480),\"\",Dataset!A480)","v":""}]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(Dataset!A481),\"\",Dataset!A481)","v":""}]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(Dataset!A482),\"\",Dataset!A482)","v":""}]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(Dataset!A483),\"\",Dataset!A483)","v":""}]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(Dataset!A484),\"\",Dataset!A484)","v":""}]
[]
[]
[]
[]
[null,"Quick check mechanism, monitoring and evaluation"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Dataset!$A$504:$A$512),\"\",Dataset!$A$504:$A$512)","v":"Quality check mechanism, monitoring and evaluation"},"Number"]
[null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(I284),I284=\"\"),\"\",\">>\")","v":">>"},{"$f":"IF(OR(ISBLANK(J284),J284=\"\"),\"\",\">>\")","v":">>"},"Document lessons learnt during pretesting and implementation phase of research ",{"$f":"IF(I284=\">>\",VLOOKUP(J284,Dataset!$B$492:$D$497,3,FALSE),\"\")","v":0}]
[null,null,null,null,null,null,null,">>",{"$f":"IF(OR(ISBLANK(J285),J285=\"\"),\"\",\">>\")","v":">>"},"Organize joint monitoring event with policy makers/programme managers or other stakeholders ",{"$f":"IF(I285=\">>\",VLOOKUP(J285,Dataset!$B$492:$D$497,3,FALSE),\"\")","v":0}]
[null,null,null,null,null,null,null,">>",">>","Real-time monitoring of field data to evaluate target against the timeline ",{"$f":"IF(I286=\">>\",VLOOKUP(J286,Dataset!$B$492:$D$497,3,FALSE),\"\")","v":0}]
[null,null,null,null,null,null,null,">>",">>","Review progress/ preliminary results with policy makers/programme managers or other stakeholders ",{"$f":"IF(I287=\">>\",VLOOKUP(J287,Dataset!$B$492:$D$497,3,FALSE),\"\")","v":0}]
[null,null,null,null,null,null,null,null,">>","Set up and implement quality control mechanism including cross validation of data collected ",{"$f":"IF(I288=\">>\",VLOOKUP(J288,Dataset!$B$492:$D$497,3,FALSE),\"\")","v":0}]
[null,null,null,null,null,null,null,null,null,"",{"$f":"IF(I289=\">>\",VLOOKUP(J289,Dataset!$B$492:$D$497,3,FALSE),\"\")","v":""}]
[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":"_xlfn.CONCAT(\"TOTAL number= \", SUM(K284:K290))","v":"TOTAL number= 0"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Dataset!A540:A551),\"\",Dataset!A540:A551)","v":"Series of standards and steps related to networking, collaboration and co-creation.  "}]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(J303),J303=\"\"),\"\",\">>\")","v":">>"},"Maintain a database of potential collaborators and their areas of expertise"]
[null,null,null,null,null,null,null,null,">>","Identify and map stakeholders relevant to the research projects or organization's scope of work"]
[null,null,null,null,null,null,null,null,">>","Collaborate with national organizations (research, academics or other)"]
[null,null,null,null,null,null,null,null,">>","Collaborate with international organizations (research, academics or other)"]
[null,null,null,null,null,null,null,null,">>","Form or work in consortium at national level for bidding / applying for research calls /grants"]
[null,null,null,null,null,null,null,null,">>","Form  or work in consortium at innational level for bidding / applying for research calls /grants"]
[null,null,null,null,null,null,null,null,">>","(blank)"]
[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,"Knowledge"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Knowledge"]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(J323),J323=\"\"),\"\",\">>\")","v":">>"},{"$f":"IF(ISBLANK(Dataset!A627:A635),\"\",Dataset!A627:A635)","v":"Blog post"}]
[null,null,null,null,null,null,null,null,">>","Discussion papers"]
[null,null,null,null,null,null,null,null,">>","Infographics "]
[null,null,null,null,null,null,null,null,">>","Newspaper articles"]
[null,null,null,null,null,null,null,null,">>","Other (Please specify): "]
[null,null,null,null,null,null,null,null,">>","Policy briefs/ project briefs tailored to the need of policy makers/ programme implementers"]
[null,null,null,null,null,null,null,null,">>","Prepare non-technical summary of the research findings in national/local language "]
[null,null,null,null,null,null,null,null,">>","Scientific papers"]
[null,null,null,null,null,null,null,null,">>","Video summary of the research findings"]
[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,"Events"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Events"]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(J341),J341=\"\"),\"\",\">>\")","v":">>"},{"$f":"IF(ISBLANK(Dataset!B664:B673),\"\",Dataset!B664:B673)","v":"Deliver presentations at international level conferences, seminars and summits "}]
[null,null,null,null,null,null,null,null,null,"Deliver presentations at national level conferences, seminars, summits etc."]
[null,null,null,null,null,null,null,null,null,"Interaction/ discussion with policy makers about evidence and their applicability"]
[null,null,null,null,null,null,null,null,null,"Organize dissemination events with local stakeholders/beneficiaries "]
[null,null,null,null,null,null,null,null,null,"Organize dissemination events with policy makers and other stakeholders at policy making level"]
[null,null,null,null,null,null,null,null,null,"Organize dissemination events with policy makers and other stakeholders at programme implementing level"]
[null,null,null,null,null,null,null,null,null,"Organize events/ discussions responding to the evidence gap highlighted or evidence requested by policy makers/ programme implementers"]
[null,null,null,null,null,null,null,null,null,"Social media campaigns based on findings from evidence generated"]
[null,null,null,null,null,null,null,null,null,"Webinars and seminars to share the learnings"]
[null,null,null,null,null,null,null,null,null,"Document the impact and effectiveness of HPSR programs in influencing policy decisions and healthcare outcomes"]

{"sheet":"FAQs","index":8,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["SN","FAQs","Asnswer"]
[1,"Why my dashboard is not updated ?","It is because you have not refereshed the dashboard. You can refresh dashboard by clicking the \"Refresh Dashboard\" button"]
[2,"Why it displays error on clicking \"Refresh Dashboard\"? And How to solve this issue","In the beginning, you have not enabled \"MACROS\" in your excel sheet because of which the macros is not able to load. To solve this issue, you first need to go to \"File\"  >> \"OPTIONS\" >>  \"TRUST CENTER\"  >> \"TRUST CENTER SETTING\" >>  \"MACROS SETTING\" >>  Select \" \"Enable VBA macros\", put check mark to \"enable Excel 4.0 macros when VBA macros enabled\"  and put check mark to \"TRUST access ot the VBA project object model\""]
[3,"Even if Macros is enabled why is the dasboard not syncing?","Close the file. Right click >> Show more options or >> Properties >> Unblock >> Apply >> Ok and open the file again"]

{"sheet":"Data processing","index":9,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["Category 1 ",null,null,null,"Yes","No",null,"Yes_","No_"]
["Available",1,null,null,"Basic ","Not Applicable",null,"Fully implemented","Not applicable"]
["Not available ",0,null,null,"Medium ","Basic ",null,"Partially implemented"]
[null,null,null,null,"Advanced ","Medium ",null,"Not implemented"]
["Category 2",null,null,null,null,"Advanced "]
["Yes",1]
["No",0]
[]
["Rate No"]
["NA ",0]
["Basic ",1]
["Medium ",2]
["Advanced ",3]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Partially implemented","Not Implemented"]