{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","1. Introduction","2. CFM Case Overview","3. Progress Tracking","source"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":83,"n_cols":3,"rows_kept":83,"cut":false,"hidden":false,"merged":[[1,1,1,2],[7,1,7,2],[0,1,0,2],[77,1,77,2],[3,1,3,2],[38,1,38,2]]}
[null,"Instruction & Guideline"]
[null,"Before filling out this Excel sheet, please ensure you click \"Enable Content\" and accept at the top to access the full functionality of the CVP data template. This file type is in XLSM format, a macro-enabled Microsoft Excel workbook that contains scripts to automate tasks. It's important to keep it in this format, so there's no need to convert it to a regular XLSX file."]
[]
[null,"Data Security"]
[null,"Data privacy and security","All data entered into the database is treated as confidential from CVP  (Community Voices Platform). Access to individual organisation's reports and data is restricted to authorized CVP Leads only. Monthly data backups will be performed regularly to protect against data loss. Organization's names and other identifying info will be excluded from public reports. Only organization type level will be included in the data analysis level in dashboard."]
[null,"Exclude data to report","The CVP is designed to provide a high-level overview of issues and feedback raised by crisis-affected people in Myanmar. It cannot manage individual cases of feedback, or replace individual organization’s CFM functionality. As a result, the CVP excludes specific highly sensitive case types including Sexual Exploitation and Abuse (SEA), Gender-based Violence (GBV), Fraud, and Corruption in order to protect survivors and ensure these cases are effectively managed through appropriate channels.\n\nNote: CVP platform is mainly for the trend analysis, and it has some limitation to handle sensitive cases. But all these cases must report to the concerned channel."]
[]
[null,"Data Field Explanation"]
[null,"1. Introduction Sheet"]
[null,"Organization name","To write the full name of the organization"]
[null,"Organization type","Choosing the right organization type"]
[null,"Allow to display logo in dashboard","Permission to use logo in the dashboard to prvoide the data credit. Displaying logos on the dashboard will present as static session which will not connect with any of the data filtering."]
[null,"Have you reported these cases to another orgnaisation","Yes, No, question for the data "]
[null,"If share, please write the organization names","To write down all the organization name that the data is shared."]
[]
[null,"2. CFM Case Overview Sheet"]
[null,"Feedback Category","High level categories to understand the nature of feedback. Migration data field may require."]
[null,"Description Overview (Qualitative)","Organizations provide high level analysis of each category of feedback received, reporting process has guiding questions to inform analysis process."]
[null,"Key Quotes","Emphasizing the direct voice from the beneficary. Recommand to use bullet points."]
[null,"# Cases","Total number of cases"]
[null,"Location (Multi select)","Tags feedback to region/state level to enable more effective response."]
[null,"Cluster(s) (Multi select)","Cluster refers to the cluster(s) most related to the content of feedback received, not the sector of the organization that received it. Migration data field may require."]
[null,"Male %","Total percentage of male"]
[null,"Female %","Total percentage of female"]
[null,"Other %","Total percentage of other which will cover LGBTIQ+, and others."]
[null,"Unknown %","When male, female and other data are aggregated and not easy to disaggregated, it can be shown as N/a and put in this field."]
[null,"0˗17 %","Percentage of age range younger than 18 years old."]
[null,"18-59 %","Percentage of age range between 18 and 59."]
[null,"60+  %","Percentage of age range older than 60."]
[null,"Other","If the age range can't be migrate with the given range, please provide percentage in this column."]
[null,"PWD %","Total percentage of persons with disabilities involvement"]
[]
[null,"3. Progress Tracking Sheet"]
[null,"Progress status","The progress tracking status reveals whether a complaint has been resolved, is still being investigated, or has been closed. "]
[null,"Tracking summery","Organizations provide high level analysis of each progress status received, reporting process has guiding questions to inform analysis process. It must include the problem and progress."]
[null,"Location (Multi select)","Tags feedback to region/state level to enable more effective response."]
[null,"Cluster(s) (Multi select)","Cluster refers to the cluster(s) most related to the content of feedback received, not the sector of the organization that received it. Migration data field may require."]
[]
[null,"Category Explanation"]
[null,"Feedback Category (CFM Case Overview Sheet)"]
[null,"Requests for Information","This category is used for all feedback, regardless of they are phrased as a question, related to information, like: information about services, information about the general situation in the country or in the country of origin (if relevant), information about specific agencies or specific programs, information about how to register or access services, etc. This category should also be used for all questions that are answered directly at the first interaction. "]
[null,"Requests for Assistance or Services","This category is used for feedback that are specific requests for assistance and services. This includes new requests and follow up from previous requests. This category includes issues like requesting to be inserted into a beneficiaries list, to requesting specific services related to registration and access to sectoral interventions, including documentation services (exeption to this category are all feedback related to any other category in this list). This may also include techncial challenges or issues related to updating, receiving, validating, verifying, or legalizing documents necessary to access humanitarian aid and assistance. \nThis category should also be used for everything related to support with physical access, costs/finances, language and communication requests, and other specialised services."]
[null,"Complaints","This category should be used for all compliants, with the exclusion of everything related to Misconduct and PSEA. This category includes any complaints about services, goods or humanitarian staff or about general humanitarian operations. This category is used for all feeeback related to services used or available or unavailable. This includes feedback related to delayed, missed, refused, or reduced assistance, feedback about poor quality of services, and feedback about the quality of the staff and volunteers delivering assistance. "]
[null,"General Perceptions, Observations and Suggestions","This category should be used for all feedback that are relying an observation about the humanitarian situation or the response, and that do not require any actions or any provisions of services, information or support. This category is also used for suggestions about better ways to deliver aid or to address challenges and for positive feedback about services received or staff. "]
[null,"Reports of Incidents and Concerns Related to Access, Safety and Security","This category includes feedback and reports of incidents related to disputes over land, labour disputes, security Incidents or conflict, threats to dignity, threats to the physcial safety of persons or groups, and psychological and mental safety. This also includes on-going safety issues like circulation of weapons, and general criminal activities like theft, robbery, corruption or bribery and diversion of assistance. "]
[null,"Appreciation","This category includes positive reinforcement that acknowledges and values to contributions, efforts, or achievements."]
[null,"Other ","This category encompasses any feedback that doesn't neatly fit into the other categories."]
[]
[null,"Progress Status Category (Progress Tracking Sheet)"]
[null,"Some Progress","This category indicates that the task or project has made progress, but there's still work to be done to reach completion. While advancements have been made, there may be challenges or obstacles that need to be addressed to maintain momentum."]
[null,"Significant Progress","This category indicates that the task or project has made substantial advancements towards completion. Key milestones have been achieved, and the overall progress is notably positive."]
[null,"Fulfilled","The case is closed and 100% complete the resolution process."]
[null,"Other","This category encompasses any feedback that doesn't neatly fit into the other categories."]
[]
[null,"Cluster Category (CFM Case Overview Sheet and Progress Tracking Sheet)"]
[null,"Education","Select this option for feedback related to formal or informal education, both for adults and children. This sector is also marked when the feedback is related to vocational training, internships, fellowships or education grants, and in general professional development (see exception below under Complimentary Pathways)"]
[null,"CCCM","Select this option for feedback related to the coordinated activities implemented by various humanitarian actors to provide services  to displaced populations within any communal settings (i.e. camps, informal settlements, collective centres); including when the services are provided by national authorities and it is their responsibility to administer such sites."]
[null,"Early recovery","Select this option for feedback related to Early Recovery, which is a multidimensional process of recovery that begins in a humanitarian setting. It is guided by development principles that seek to build on humanitarian programs and catalyze sustainable development opportunities. This includes: emergency employment, conflict prevention and peacebuilding, disaster risk reduction, human mobility, rule of law, human rights, health, financial resilience. This sector should be marked only if the overall response has activated this specific cluster or a similar one. "]
[null,"Emergency telecommunications","Select this option for feedback related to communications services and voice and internet connectivity. This includes: telephony, support to broadcasters, like radio stations, internet connectivity, Security Communication Systems, and UAS coordination. This cluster can be deployed to support for affected population with services like: call centers; free internet spots; etc. This sector should be marked when the feedback is related to any of these services or needs. "]
[null,"Food security","Select this option for feedback related to one of the four pillars of food security (availability, access, utilization and stability). This includes any feedback related to physical and economic access to sufficient, safe and nutritious food, including: food distributions, food vauchers, market-based interventions, manipulation of food assistance, risks and security for beneficiaries accesing food, etc. "]
[null,"Health","Select this option for feedback related to health, health issues, maternal health, public health and related concerns, questions or misinformation about health. This sector is also marked when the feedback is related to hospitals, mental health facilities, retirements homes, clinics or health emergency services. This category should also be used for anyone reporting diseases, sick people or possible issues that may affect people' health, like pollution hazards or waste hazards. "]
[null,"Logistics","Select this option for feedback related to logistcal arrangements, like transportation for refugees or stateless and displaced people, temporary accomodations for migrants or refugees, arrangements of flights and trains to move people to safety. This sector is also marked if the feedback is related to posible logistical issues like roads being blocked,  access to trasportation, or requests for logistical support. "]
[null,"Protection","This option should be used to identify all feedback related to the protection of people, communities, groups and individuals. Protection here refers to both legal and physical protection, and encompasses all activities aimed at ensuring full respect for the rights of the individual in accordance with human rights law, international humanitarian law (which applies in situations of armed conflict) and refugee law. This may uncluded but it is not limited to specialized services, such as legal aid, family tracing and reunification services, facilitating refugee registration, etc. (See below for Child Protection)"]
[null,"Shelter","Select this option for feedback related to safe, dignified and appropriate shelter foir communities. This may include shelter material, like plastic sheeting, shelter kits, tents, or other solutions, and longer-term needs, transitional shelter, building or reconstruction of houses, capacity building, and related matters."]
[null,"WASH","Select this option for feedback related to water, sanitation and hygiene (WASH) activities of issues. This includes access to drinkable water, building of water wells, latrines, open defecation issues, hygiene education and capacity building. It also includes outbreak of diseases related to WASH, like Cholera. "]
[null,"Nutrition","Select this option for feedback related to interventions whose primary objective is to address nutrition and that target the immediate causes of undernutrition. This includes reports of children malnutrition, access to safe water and food, feedack on the nutritional status of food, food preparation and eating habits, and health status as related to food intake. "]
[null,"Cash assistance","Select this option for feedback related to a Cash and Voucher Assistance (CVA) program, from the request of information about it, to inquiries on criteria, to complaints about not being part of the beneficiaries pool. This sector is used to mark any type of feedback that relates to cash assistance regardless of if it is conditional or unconditional, inter-agency or managed by an individual agency or organization. This includes reporting issues and problems with the cash assistance received, changing information that will affect the cash amount provided and similar technical issues. "]
[null,"Livelihoods","Select this option for feedback related to activities undertaken by a typical household to ensure a living. For example, feedback related to crop and livestock, farm, off-farm and non-farm activities, including material to farm, seeds, machineries, capacity building, etc. This also includes markets related issues, like feedback related to incresase in prices of comodities, changes in the exchange rate, and devaluation/inflation issues. This sector should also be used for emplyment  related feedback, including requests for employment opportunities. "]
[null,"Local Integration","Select this option for feedback related to the complex and gradual process of legal, economic, social and cultural dimensiosn of integration of refugees/migrants/IDPs with a host population. This includes possible problems and violent clashes, issues related to the sharing of resources and discrimination. It also includes feedback related to activities implemented by humanitarian organizations aimed at improving local integration, like social cohesion activities, dialogues and community engagement activities generally aimed at social cohesion. "]
[null,"NFI","Select this option for feedback related to Core Relief Items (CRIs), also known as Non Food items (NFIs),  such as mattresses, blankets, plastic sheets, containers for water, cooking utensils and hygiene kits. Depending on the situation, NFI can also include fans, emergency lights, mosquito nets, soap, etc. "]
[null,"Housing, land and property","Select this option for feedback related to rights over immovable property, in the context of emergency response. HLP include laws, practices, customs, and attitudes that revolve around specific rights to land and property, including collective ownership, land related violence or conflict, access to land and property, farming land and its related ownership rights, etc. "]
[null,"Child protection","Select this option for feedback related to the safeguarding of children from violence, exploitation, abuse, and neglect. It includes signs of potential harm, the response to allegations or suspicions of abuse, request for providing support and services to protect children, and holding those who have harmed children accountable. "]
[null,"Mine Action","Select this option for feedback related to humanitarian activities or risks and challenges related to the impact of explosive ordnance. They include the removal and clearance of explosive items, provision of risk education to impacted communities, as well as support to persons injured physically or mentally by explosives items."]
[null,"Energy/environment","Select this option for feedback related to climate shocks, enviroment and sustainable energy. This includes issues related to women and girls collecting firewood, access to energy, including clean cooking, access to electricity and all the essential services it provides. This sector alos includes feedback related to energy requirements for connectivity, heating, cooling, and communication, including sustainable electricity and other energy related resources. This sector also refers to enviromental issues like, pollution, environmental risks and hazards for health, and the enviromental impact of humanitarian operations.  "]
[null,"Feedback mechanism ","Select this option for feedback related tot the mechanism itself. This would include complaints about not having received a response from feedback reported previously, or about not being able to report something to the feedback mechanism. This also includes appreciations for the system or reporting technical difficulties. "]
[null,"Other","This category encompasses any feedback that doesn't neatly fit into the other categories."]
[]
[null,"Reporting Instructions"]
[null,"Step 1: Data Extract & Cleaning","Transfer CFM case data from your organisation’s CFM data system to a new excel workbook. Identify and remove duplicate records to ensure each complaint is unique. Make sure to only transfer cases from the current reporting period. The following information are necessary for the CVP data standard and need to take the concerned column for the CVP:\n\nCase Overview\n- Complaint category\n- Description Overview (Qualitative)\n- Key Quotes\n- Number of cases\n- Location (State/Region level)\n- Cluster\n- Demographic data (Gender, Age range, PWD) \n\nProgress Tracking\n- Progress status\n- Cluster\n- Location (State/Region level)\n- Tracking Summery"]
[null,"Step 2: Data Migration","Once CFM data is extracted and cleaned, key data fields need to be changed or ‘migrated’ to CVP standard data fields. This enables CVP to combine data from different organisations and conduct analysis. \nParticipating organizations should migrate its data to CVP standards in the way that works best for them, making sure to document the process through internal knowledge management to ensure consistency across reporting periods.\nTo ‘migrate’ a data field to CVP standards, the following steps are suggested:\n\n1. Create a new column next to the data field to be migrated (e.g. location, cluster, feedback category, progress status)\n2. Label the new column with the corresponding CVP data label (location, cluster, feedback category, progress status)\n3. Filter CFM data for all cases that fit a specific option in the CVP data standards (e.g. location, cluster, feedback category, progress status)\n4. Copy and paste the correct CVP data standard option for all rows in the new column\n5. Delete the original column, so that only the column with CVP standard data remains\n\nCategory Migration\nMigrating CFM categories to CVP standard categories can be more challenging. It requires determining which CVP standard category fits best with each category used by the participating organization. To successfully migrate categories, the CVP team suggests the following steps: \n1. Build a category migration table, which matches each of the categories your organization uses to one of the CVP standard categories. \nExample:\nRegisteration (Organization category) => Request for information (CVP standard)\nData Subject Rights (Organization category) => Request for information (CVP standard)\nPoor Quality Assistance (Organization category) => Complaints (CVP standard)\nComment about Context (Organization category) => General Perceptions, Observations and Suggestions (CVP standard)\nPositive Feedback (Organization category) => Appreciation (CVP standard)\n\n· It is recommended to maintain a 1:1 relationship between categories. This means that 100% of cases which have the same organizational category will migrate to a single CVP category. This makes migration easier and replicable. \n· Remember to document the category migration table via internal knowledge management to ensure the process is consistent across reporting periods.\n2. Follow steps 1-5 above to migrate your organizational categories to the CVP standard categories."]
[null,"Step 3: Aggregation and Analysis","The CVP report is designed to be a ‘light touch’ summary report of key issues and feedback raised by affected people that is comparable across participating organizations. For this reason it is not required for participating organizations to provide case-by-case CFM reports to CVP. Instead, the CVP report: 1) Aggregates CFM cases by CVP category and 2) requests participating orgs. to share summaries of the issues raised within each category along with key demographic and metadata like location and relevant cluster(s) and fill in the reporting excel sheet. There are two sheets in the excel file as below:\n\n1. CFM Case Overview Sheet\n2. Progress Tracking Sheet"]
[null,"Step 4: Fill in the Case Summery Sheet","For each CVP feedback category represented in your report:\n1. Filter cases to include only one CVP standard category\n2. Review the case descriptions for each case\n3. Write a short summary of the issues that were raised or feedback provided in the CVP case\na. Summary should be 1-2 paragraphs\nb. For each issue or feedback, try to answer the following questions:\ni. WHAT is the issue/feedback?\nc. Try to include the all issues raised, not just the most commonly reported issues \nd. Bullet points are acceptable\n\nOnce the description summary is complete, add required demographic and metadata to each category summary by using pivot table in prepared excel sheet:\n1. Number of cases the summary represents\n2. Location(s) where the cases were received from\n3. Gender in percentage\n4. Age range in percentage\n\nWhen aggregation and analysis is complete, check to confirm your CVP report has:\n· 1 row per CVP feedback category\n· All data fields completed"]
[null,"Step 5: Fill in the Progress Tracking Sheet","For each CVP tracking status represented in your report:\n\n1.\tFilter cases to include only one CVP tracking status category\n2.\tReview the case resolution descriptions for each case, if the tracking status is not yet resolved, recommend to write the challenges.\n3.\tWrite a short summary of the resolution or challenges that were raised or feedback provided in the CVP case\na.\tSummary should be 1-2 paragraphs\nb.\tFor each resolution or challenges, try to answer the following questions:\ni.\tWHAT is the resolution/challenges?\nc.\tTry to include all resolution and challenges, not just the most commonly reported issues \nd.\tBullet points are acceptable\n\nOnce the progress tracking summary is complete, add required metadata including sector and location.\nWhen aggregation and analysis is complete, check to confirm your CVP report has:\n·\t1 row per CVP progress status\n·\tAll data fields completed"]

{"sheet":"1. Introduction","index":1,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Introduction"]
["Organization name\n(Organization name will not present in any part of the report)"]
["Organization type"]
["Allow to display logo in dashboard\n(Displaying logos on the dashboard will present as static session which will not connect with any of the data filtering)"]
["Have you reported these cases to another orgnaisation (e.g. a UN donor)"]
["If share, please write the organization names"]

{"sheet":"2. CFM Case Overview","index":2,"n_rows":22,"n_cols":16,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,7,0,10],[0,11,0,14],[0,0,0,6]]}
["Case Summery Datasheet",null,null,null,null,null,null,"Gender in Percentage",null,null,null,"Age range in percentage"]
["No","Feedback Category","Description Overview (Qualitative)","Key Quotes","# Cases","Location (Multi select)","Cluster(s) (Multi select)","Male %","Female %","Other %","Unknown %","0-17 %","18-59 %","60+ %","Other %","PWD %"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]

{"sheet":"3. Progress Tracking","index":3,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Progress Tracking Sheet"]
["No","Status","Progress Summary","Location (Multi select)","Cluster(s) (Multi select)"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]

{"sheet":"source","index":4,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
["Region/State","Sector","Category","Progress status","Yes No","Organization type"]
["Ayeyarwaddy","Education","Requests for Information","Some Progress","Yes","UN"]
["Bago (East)","CCCM","Requests for Assistance or Services","Significant Progress","No","INGO"]
["Bago (West)","Early recovery","Complaints","Fulfilled",null,"NNGO"]
["Chin","Emergency telecommunications","General Perceptions, Observations and Suggestions","Other",null,"IFRC"]
["Kachin","Food security","Reports of Incidents and Concerns Related to Access, Safety and Security",null,null,"CBO/CSO"]
["Kayah","Health","Appreciation"]
["Kayin","Logistics","Other "]
["Magway","Protection"]
["Mandalay","Shelter"]
["Mon","WASH"]
["Nay Pyi Taw","Nutrition"]
["Rakhine","Cash assistance"]
["Sagaing","Livelihoods"]
["Shan (East)","Local Integration"]
["Shan (North)","NFI"]
["Shan (South)","Housing, land and property"]
["Tanintharyi","Child protection"]
["Yangon","Mine Action"]
[null,"Energy/environment"]
[null,"Feedback mechanism "]
[null,"Other"]