ODK ACF-E Forms FSL MPM SURVEY

 ODK ACF‐E TOOLKIT ACF‐E FORMS
FSL MPM SURVEY FSL MPM survey “MARKET PRICE SURVEY (MPS)” form should be filled every time we conduct a Market price monitoring campaign. EXCEL SURVEY FILE NAME: fsl_mpm_v_1_0.xls XML SURVEY FILE NAME: fsl_mpm_v_1_0.xml EXCEL MOTHER SHEET FILE NAME: Mother FSL MPM V 1.0.xls ODK BRIEFCASE OUTPUT FILE NAME:  FSL MPM V 1.0.csv  FSL MPM Survey V 1.0‐mps‐section_c‐section_c_1_local.csv  FSL MPM Survey V 1.0‐mps‐section_d‐section_d_1_local.csv It has the following sections:
In this section you must insert the
market location , name and interviewer
name
SECTION A - INFORMATION
In this section you must specify the
currency you are going to use for insert
SECTION B - Price monitoring
prices
requirements
In this section you must insert the staple
SECTION C - Market Price monitoring foods present in the market
In this section you must insert the
income sources
SECTION D - Income sources
LANGUAGES: ‐ENGLISH ‐FRENCH ‐SPANISH 
WITH INTERNET: Connect to the server and download it as “Blank form” 
NO INTERNET: You should copy the “fsl_mpm_v_1_0.xml” file into odk/forms/ folder in the Device SD Card. Also you must create a folder within the odk/forms/ folder named “fsl_mpm_v_1_0.xml‐media” and paste there the form_logo.png file DATA ANALYSIS: Once you get the “FSL MPM V 1.0.csv”, “MPM Survey V 1.0‐mps‐section_c‐section_c_1_local.csv” and “FSL MPM Survey V 1.0‐mps‐section_d‐section_d_1_local.csv” files, you should transform text into columns and import the results to the mother sheet. This will be done in an automated way if you push the 3 buttons of the first sheet of Mother FSL MPM V 1.0.xls while you have opened all the .csv documents If you have any problem running the macro in the Mother sheet, you should transform text into columns and import the results to the mother sheet manually (Refer to the Annex 12 “ODK ACF‐E Transform text into columns procedure”) and: 
copy/Paste the FSL MPM V 1.0.csv in the” Imported output” sheet within the Mother MPM V 1.0.xls 
copy/Paste the MPM Survey V 1.0‐mps‐section_c‐section_c_1_local.csv in the “Staple foods” sheet within the Mother MPM V 1.0.xls 
copy/Paste the FSL MPM V 1.0.csv in the “Income sources” sheet within the Mother MPM V 1.0.xls