{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Table of Contents","StartOfAnalysis_Dataset","Analysis01_Variables","Analysis01_Data","Analysis01_PivotGrouping","Analysis01_PivotBinaries","Analysis01_Priorities","Analysis01_TabCategorical","Analysis01_MultipleR_Pivot","Analysis01_MultipleR_IF","Text01_Polytomous","Text02_Priorities","Analyses02_QuickOverview","Analyses02_PrioritiesByVulnerab","Analysis02_DistressIndex","Analysis02_Men_Women","NamedRanges"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":149,"comments":0,"pivot_tables":12},"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":"Table of Contents","index":0,"n_rows":29,"n_cols":2,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Table of Contents"]
[]
["Sheet","Comment"]
[]
["Starting point of analysis"]
["StartOfAnalysis_Dataset","Hypothetical shape of dataset after data management tasks were completed."]
[]
["Data and documentation"]
["Analysis01_Variables","Including (on the far right) the calculated variables."]
["Analysis01_Data"]
[]
["Formal: Demos of basic analyses, by data type and method"]
["Analysis01_PivotGrouping","Overview of sites, by living arrangement and vulnerability, with area filters. Can be used as template for other Pivot tables."]
["Analysis01_PivotBinaries","Frequencies of all binary variables that are not part of multiple-response questions. Variable names use original question numbers."]
["Analysis01_Priorities","Borda count calculations of all priority-type multiple-response variables, using the functions COUNTIF, INDIRECT, SUMPRODUCT."]
["Analysis01_TabCategorical","Tabulation of multiple categorical variables, side by side. Two methods."]
["Analysis01_MultipleR_Pivot","Multiple response (non-ranked)-type data tabulation, using a Pivot table. Difference between \"by sites\" and \"by choices\"."]
["Analysis01_MultipleR_IF","Multiple response (non-ranked)-type data tabulation - different method when missing values are a serious issue."]
["Text01_Polytomous","Formulas to transform unranked polytomously coded multi-response data into indicator variables"]
["Text02_Priorities","Formulas to transform  polytomously coded priority-type data into item-base variables"]
[]
["Substantive: Elements of quick needs analysis"]
["Analyses02_QuickOverview","Quick first overview: Vulnerability hotspots, by area and living arrangement. Pivot table, maximum of ordinal vulnerability."]
["Analyses02_PrioritiesByVulnerab","Priority needs, by men vs. women, and by vulnerability level. Calculated using the functions AVERAGEIF, INDIRECT."]
["Analysis02_DistressIndex","Ad-hoc distress index formed of ten binary or binarized indicators. Hotspot table, mean of ratio-level distress index."]
["Analysis02_Men_Women","Agreement between men's and women's (who had been interviewed separately) priorities."]
[]
["Auxiliary tables"]
["NamedRanges","Convenience table of all named ranges in the workbook."]

{"sheet":"StartOfAnalysis_Dataset","index":1,"n_rows":66,"n_cols":119,"rows_kept":66,"cut":false,"hidden":false,"merged":[]}
["Identifiers",null,null,null,null,null,null,null,"Team observations",null,null,null,null,null,null,null,null,null,null,"Male groups",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Womens groups"]
["Record number","Assessment date","Team number","District","Upazila","Union","Urban vs. rural","Village","Living arrangement","Stagnant water: Settlement","Stagnant water: Shelter","Stagnant water: Water points","Stagnant water: Other","Garbage","Disease vectors","Latrines at site","Students truant","Open water sources","Site assessment by team","Priority for men: Livelihoods","Priority for men: Livestock feed","Priority for men: Rebuild homes","Priority for men: Children's schooling","Priority for men: Health care","Priority for men: Food","Priority for men: Safe drinking water","Priority for men: Water for wash and bath","Priority for men: Markets","Priority for men: Short-term financial support","Priority for men: Safety","Priority for men: Other","Lack of safe water serious (men)","Defecation, males, pre-disaster","Defecation, males, post-disaster","Shelter issues for men: Shelter not available","Shelter issues for men: Overcrowded","Shelter issues for men: Return home impossible","Shelter issues for men: No repair materials","Shelter issues for men: No manpower for repairs","Shelter issues for men: Land issues for men","Shelter issues for men: Lack of household items","Shelter issues for men: Lack of privacy","Shelter issues for men: Exposed to weather","Shelter issues for men: Other","Shelter priorities for men: Find shelter","Shelter priorities for men: Move out of shelter","Shelter priorities for men: Return home","Shelter priorities for men: Material for home repair","Shelter priorities for men: Manpower for home repair","Shelter priorities for men: Household items","Shelter priorities for men: Privacy","Shelter priorities for men: Protection from weather","Shelter priorities for men: Other","Coping priorities for men: Reduce meal size","Coping priorities for men: East less preferred food","Coping priorities for men: Eat wild foods","Coping priorities for men: Restrict adult male consumption","Coping priorities for men: Restrict adult female consumption","Coping priorities for men: Send children to relatives","Coping priorities for men: Borrow money","Coping priorities for men: Advance labor sale","Coping priorities for men: Buy food on creadit","Coping priorities for men: Sell livestock and poultry","Coping priorities for men: Sell household utensils","Coping priorities for men: Sell land or trees","Coping priorities for men: Outmigration","Coping priorities for men: Send children to work","Coping priorities for men: Other","Expected stay at shelter (men)","Safety of home and property (men)","Priority for women: Livelihoods","Priority for women: Livestock feed","Priority for women: Rebuild homes","Priority for women: Children's schooling","Priority for women: Health care","Priority for women: Food","Priority for women: Safe drinking water","Priority for women: Water for wash and bath","Priority for women: Markets","Priority for women: Short-term financial support","Priority for women: Safety","Priority for women: Other","Has electricity","Lack of safe water serious (women)","Daily water supply for household","Lack of safetoilets (women)","Defecation, females, pre-disaster","Defecation, females, post-disaster","Difficult women's hygiene","Shelter priorities for women: Find shelter","Shelter priorities for women: Move out of shelter","Shelter priorities for women: Return home","Shelter priorities for women: Material for home repair","Shelter priorities for women: Manpower for home repair","Shelter priorities for women: Household items","Shelter priorities for women: Privacy","Shelter priorities for women: Protection from weather","Shelter priorities for women: Other","School attendance high - pre-disaster","School attendance high - post-disaster","Expected stay at shelter wo(men)","Time for women to reach health care","Health priorities for women: None","Health priorities for women: Diarrhea","Health priorities for women: Skin disease","Health priorities for women: Snake bite","Health priorities for women: Safe birth","Health priorities for women: Other","Diarrhea increased","Women's safety issues","Child labor","Children missing","Food issues (women): None","Food issues (women): Not enough","Food issues (women): Not good enough","Food issues (women): No cooking facility","Food issues (women): No utensils","Food issues (women): No cooking fuel","Food issues (women): Other"]
["i_00_01","i_00_03","i_00_04","i_00_05","i_00_06","i_00_07","i_00_08","i_00_09","t_00_10","t_02_01","t_02_02","t_02_03","t_02_04","t_03_00","t_04_00","t_05_00","t_09_00","t_10_07","t_14_00","m_03_01","m_03_02","m_03_03","m_03_04","m_03_05","m_03_06","m_03_07","m_03_08","m_03_09","m_03_10","m_03_11","m_03_12","m_04_00","m_06_01","m_06_02","m_07_01","m_07_02","m_07_03","m_07_04","m_07_05","m_07_06","m_07_07","m_07_08","m_07_09","m_07_10","m_08_01","m_08_02","m_08_03","m_08_04","m_08_05","m_08_06","m_08_07","m_08_08","m_08_09","m_16_01","m_16_02","m_16_03","m_16_04","m_16_05","m_16_06","m_16_07","m_16_08","m_16_09","m_16_10","m_16_11","m_16_12","m_16_13","m_16_14","m_16_15","m_17_00","m_21_00","w_03_01","w_03_02","w_03_03","w_03_04","w_03_05","w_03_06","w_03_07","w_03_08","w_03_09","w_03_10","w_03_11","w_03_12","w_04_02","w_06_00","w_09_00","w_10_00","w_11_01","w_11_02","w_12_00","w_14_01","w_14_02","w_14_03","w_14_04","w_14_05","w_14_06","w_14_07","w_14_08","w_14_09","w_18_01","w_18_02","w_21_00","w_24_02","w_25_01","w_25_02","w_25_03","w_25_04","w_25_05","w_25_06","w_26_00","w_28_01","w_29_00","w_30_00","w_37_01","w_37_02","w_37_03","w_37_04","w_37_05","w_37_06","w_37_07"]
[1,"2011-09-11",10,"Jessore","Abhynagar","Paira","Rural","Ghoradari","4-Damaged or water-logged",1,0,0,0,0,1,1,0,1,"2-Vulnerable",2,1,0,0,0,0,0,0,0,3,0,0,1,"4-Sanitary latrines (household)","1-Open area",1,1,0,0,0,0,0,0,0,0,1,0,0,2,0,3,0,0,0,1,0,0,0,0,0,0,0,5,4,0,0,3,2,0,"0 - <1",null,3,2,0,0,1,0,0,0,0,0,0,0,1,1,"10 +",1,"4-Sanitary latrines (household)","1-Open area",1,3,0,0,0,0,2,1,0,0,1,1,"","c-30-60 minutes",0,3,2,0,0,1,1,0,1,1,0,1,1,0,0,0,0]
[2,"2011-09-09",10,"Jessore","Abhynagar","Siddiqpasa","Rural","Joyrabad","3-Marooned",1,0,1,0,1,1,1,0,0,"2-Vulnerable",3,0,1,0,0,0,2,0,0,0,0,0,1,"4-Sanitary latrines (household)","1-Open area",1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,0,0,0,0,0,4,0,0,1,5,0,3,0,0,"0 - <1",1,3,0,0,0,0,0,0,0,0,2,1,0,0,1,"10 +",1,"4-Sanitary latrines (household)","1-Open area",1,3,0,0,1,0,2,0,0,0,1,1,"","e-> 2 hours",0,0,3,2,0,1,0,1,0,0,0,1,1,0,0,0,0]
[3,"2011-09-09",10,"Jessore","Abhynagar","Siddiqpasa","Rural","Nolamara","4-Damaged or water-logged",1,0,1,0,1,1,1,0,0,"2-Vulnerable",3,0,0,0,0,0,1,0,0,0,2,0,1,"4-Sanitary latrines (household)","1-Open area",1,0,1,0,0,0,0,0,0,0,3,0,0,2,0,1,0,0,0,3,0,0,0,0,0,5,0,0,2,1,0,4,0,0,"0 - <1",1,3,0,0,0,0,2,0,0,0,1,0,0,0,0,"10 +",1,"4-Sanitary latrines (household)","2-Hanging or open latrine",1,1,0,0,2,0,3,0,0,0,1,1,"","e-> 2 hours",0,0,3,1,2,0,0,0,1,0,0,1,1,0,0,1,0]
[4,"2011-09-10",10,"Jessore","Abhynagar","Suvoyara","Rural","IsamotiPurbapasa","3-Marooned",1,0,1,0,0,1,1,0,1,"3-Seriously vulnerable",1,0,0,0,0,3,0,0,0,2,0,0,1,"3-Sanitary latrines (communal)","3-Sanitary latrines (communal)",1,1,1,0,0,0,0,0,0,0,3,0,0,1,0,2,0,0,0,0,0,0,2,3,0,0,0,4,0,0,0,5,1,0,"0 - <1",1,0,0,0,0,1,2,0,0,0,3,0,0,1,0,"10 +",1,"4-Sanitary latrines (household)","1-Open area",0,3,0,0,1,0,2,0,0,0,1,1,"","e-> 2 hours",0,0,3,0,2,1,0,0,0,0,0,1,1,0,0,0,0]
[5,"2011-09-10",10,"Jessore","Abhynagar","Suvoyara","Rural","Hindia","4-Damaged or water-logged",1,0,1,0,1,1,1,0,1,"2-Vulnerable",3,0,0,0,0,1,0,0,0,2,0,0,0,"4-Sanitary latrines (household)","3-Sanitary latrines (communal)",1,1,0,1,0,0,0,0,0,0,3,1,0,2,0,0,0,0,0,5,4,1,0,0,0,3,0,2,0,0,0,0,0,0,"0 - <1",null,0,0,0,0,1,3,0,0,0,2,0,0,1,1,"10 +",1,"2-Hanging or open latrine","1-Open area",1,2,0,0,2,0,3,0,0,0,1,0,"","c-30-60 minutes",0,1,3,2,0,0,0,0,1,0,0,1,1,0,0,0,0]
[6,"2011-09-10",11,"Jessore","Jhikargacha","Bakra","Rural","Dikdana","2-Roadside / embankments",1,0,1,1,1,1,1,1,0,"3-Seriously vulnerable",2,0,0,0,1,3,0,0,0,0,0,0,1,"4-Sanitary latrines (household)","5-Other",1,0,1,0,0,0,0,1,0,1,1,0,0,3,0,0,2,0,0,2,0,0,0,0,0,4,3,5,0,0,0,0,1,0,"2 - 3",1,1,0,2,0,0,3,0,0,0,0,0,0,1,1,"10 +",1,"4-Sanitary latrines (household)","4-Sanitary latrines (household)",1,1,0,0,2,0,0,1,0,0,1,0,"2 - 3","c-30-60 minutes",0,2,3,0,0,1,0,0,0,0,0,1,0,0,0,0,0]
[7,"2011-09-10",11,"Jessore","Jhikargacha","Bakra","Rural","Dikdana","3-Marooned",1,0,1,0,1,1,1,1,0,"1-Relatively normal",2,0,0,0,1,3,0,0,0,0,0,0,1,"4-Sanitary latrines (household)","5-Other",1,0,1,1,0,0,0,0,0,1,0,0,0,3,0,0,2,0,1,0,0,0,0,0,0,5,1,4,3,0,0,0,2,0,"0 - <1",null,1,0,0,0,0,3,2,0,0,1,0,0,0,1,"10 +",1,"4-Sanitary latrines (household)","1-Open area",1,3,0,0,2,0,0,1,0,0,1,0,"","e-> 2 hours",0,2,3,0,0,1,0,0,1,0,0,1,0,0,0,0,0]
[8,"2011-09-10",11,"Jessore","Jhikargacha","Nibeshkhola","Rural","Balla (Beside River)","5-Home undamaged",1,0,1,1,1,1,1,1,0,"3-Seriously vulnerable",3,0,0,0,1,0,0,0,0,0,0,2,1,"4-Sanitary latrines (household)","2-Hanging or open latrine",1,0,1,0,0,0,0,0,0,1,0,0,0,2,0,0,0,0,0,0,0,0,0,0,0,4,0,5,3,0,2,0,0,1,"0 - <1",null,0,0,2,0,0,3,0,0,0,0,0,1,0,1,"10 +",1,"4-Sanitary latrines (household)","1-Open area",1,0,0,0,3,1,0,0,2,0,1,0,"","e-> 2 hours",0,1,3,0,0,2,0,0,0,0,0,1,0,0,0,0,0]
[9,"2011-09-11",11,"Jessore","Jhikargacha","Ponisara","Rural","Purandapur (Purba Para)","5-Home undamaged",1,0,1,0,1,1,1,0,0,"3-Seriously vulnerable",2,0,0,0,1,3,0,0,0,0,0,0,1,"4-Sanitary latrines (household)","5-Other",1,0,0,1,0,0,0,1,0,0,0,0,0,3,0,1,2,0,0,0,0,0,0,0,0,5,1,2,4,0,3,0,0,0,"0 - <1",null,0,1,0,0,0,2,3,0,0,0,0,0,0,1,"10 +",0,"4-Sanitary latrines (household)","2-Hanging or open latrine",1,0,0,0,3,2,0,0,0,1,1,0,"","d-1 - 2 hours",0,0,3,2,0,1,0,0,0,0,1,0,0,0,0,0,0]
[10,"2011-09-09",11,"Jessore","Jhikargacha","Pourashara","Urban","Parbazar","1-Collective centers",0,1,1,0,1,1,1,1,0,"3-Seriously vulnerable",1,0,0,0,3,2,0,0,0,0,0,0,1,"4-Sanitary latrines (household)","3-Sanitary latrines (communal)",0,0,1,1,0,0,0,1,1,0,0,0,3,2,0,0,1,0,0,2,0,0,0,1,0,4,0,5,3,0,0,0,0,0,"1 - 2",1,1,0,3,0,0,2,0,0,0,0,0,0,0,1,"10 +",1,"4-Sanitary latrines (household)","4-Sanitary latrines (household)",1,2,0,1,3,0,0,0,0,0,1,0,"1 - 2","c-30-60 minutes",0,2,3,0,0,1,0,1,1,0,0,1,0,0,0,0,0]
[11,"2011-09-09",11,"Jessore","Jhikargacha","Pourashara","Urban","Saddampara","3-Marooned",1,0,1,0,1,1,1,1,0,"3-Seriously vulnerable",3,0,0,0,0,1,2,0,0,0,0,0,1,"4-Sanitary latrines (household)","2-Hanging or open latrine",0,0,0,1,0,0,1,0,1,1,0,0,0,3,0,0,1,2,0,0,1,0,0,3,0,4,0,5,0,0,0,0,2,0,"0 - <1",null,3,0,0,0,1,2,0,0,0,0,0,0,1,1,"10 +",1,"4-Sanitary latrines (household)","1-Open area",1,0,0,0,3,0,2,1,0,0,1,0,"","c-30-60 minutes",0,1,3,0,0,2,0,0,1,0,0,1,0,0,0,1,0]
[12,"2011-09-09",11,"Jessore","Jhikargacha","Pourashara","Rural","Shanti Bagar","4-Damaged or water-logged",1,1,1,0,1,1,1,1,0,"3-Seriously vulnerable",3,0,0,0,0,2,0,0,0,1,0,0,1,"4-Sanitary latrines (household)","2-Hanging or open latrine",0,0,1,1,0,0,0,0,0,1,0,0,0,3,0,0,1,0,0,3,2,0,0,1,0,1,0,4,0,0,0,0,0,0,"0 - <1",null,1,0,2,0,0,3,0,0,0,0,0,0,0,1,"10 +",1,"4-Sanitary latrines (household)","1-Open area",1,0,0,0,3,1,2,0,0,0,1,0,"","d-1 - 2 hours",0,2,3,0,0,1,0,0,1,0,0,1,0,0,0,1,0]
[13,"2011-09-09",9,"Jessore","Keshabpur","Biddyanandakati","Rural","Nehanpur","1-Collective centers",1,1,1,0,1,1,1,0,0,"3-Seriously vulnerable",2,0,0,0,0,3,1,0,0,0,0,0,1,"3-Sanitary latrines (communal)","2-Hanging or open latrine",1,1,1,0,0,0,0,0,0,0,2,0,0,3,0,0,1,0,0,0,0,0,0,0,0,5,1,4,0,3,2,0,0,0,"3 +",1,0,0,2,0,0,3,1,0,0,0,0,0,1,1,"10 +",1,"2-Hanging or open latrine","1-Open area",1,1,0,0,3,0,2,0,0,0,1,0,"3 +","e-> 2 hours",0,1,3,2,0,0,1,1,0,0,0,1,0,1,1,1,0]
[14,"2011-09-10",9,"Jessore","Keshabpur","Keshabpur Sadar","Rural","Basdanga","5-Home undamaged",1,1,0,0,1,1,1,1,0,"2-Vulnerable",3,1,0,0,0,2,0,0,0,0,0,0,0,"3-Sanitary latrines (communal)","2-Hanging or open latrine",1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5,0,0,0,0,2,1,0,4,3,0,0,0,0,"0 - <1",null,2,0,0,0,0,3,1,0,0,0,0,0,1,1,"10 +",1,"2-Hanging or open latrine","1-Open area",1,0,0,0,3,0,2,1,0,0,1,1,"","d-1 - 2 hours",0,2,3,1,0,0,1,0,0,0,0,1,0,1,0,1,0]
[15,"2011-09-11",9,"Jessore","Keshabpur","Mojidpur","Rural","Protappur","5-Home undamaged",1,1,0,0,0,1,1,1,0,"2-Vulnerable",2,0,0,0,0,1,3,0,0,0,0,0,0,"3-Sanitary latrines (communal)","2-Hanging or open latrine",0,0,0,0,0,0,0,0,0,0,0,0,0,3,1,2,0,0,0,5,4,0,0,0,0,3,0,0,2,1,0,0,0,0,"0 - <1",null,1,0,0,0,0,3,0,0,2,0,0,0,0,1,"10 +",1,"4-Sanitary latrines (household)","1-Open area",1,3,0,0,2,0,1,0,0,0,1,1,"","d-1 - 2 hours",0,3,2,0,1,0,1,0,1,0,0,1,1,1,0,0,0]
[16,"2011-09-11",9,"Jessore","Keshabpur","Pazia","Rural","Bagdanga","5-Home undamaged",1,0,0,0,1,1,1,1,0,"2-Vulnerable",2,1,0,0,0,3,0,0,0,0,0,0,0,"4-Sanitary latrines (household)","3-Sanitary latrines (communal)",1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5,1,0,0,0,0,5,4,0,3,2,0,0,0,0,"0 - <1",null,2,0,0,0,0,3,1,0,0,0,0,0,1,1,"10 +",1,"4-Sanitary latrines (household)","1-Open area",1,0,0,0,2,1,3,0,0,0,1,1,"","d-1 - 2 hours",0,2,3,0,0,1,0,0,0,0,0,1,1,1,0,0,0]
[17,"2011-09-08",9,"Jessore","Keshabpur","Sagardari","Rural","Sagardari","2-Roadside / embankments",1,0,1,0,1,1,1,1,0,"3-Seriously vulnerable",2,0,0,0,1,3,0,0,0,0,0,0,1,"4-Sanitary latrines (household)","1-Open area",0,1,1,0,0,0,0,1,0,0,2,0,0,3,0,1,0,0,0,2,1,0,0,0,0,0,0,5,4,0,3,0,0,0,"3 +",1,0,0,0,0,1,3,0,0,0,0,0,2,0,1,"10 +",1,"2-Hanging or open latrine","1-Open area",1,1,0,0,3,0,2,0,0,0,1,0,"3 +","d-1 - 2 hours",0,3,2,1,0,0,1,1,0,0,0,1,0,1,1,1,0]
[18,"2011-09-10",9,"Jessore","Keshabpur","Shuflakati","Rural","Poschim Sarutia","3-Marooned",1,0,1,0,1,1,1,1,0,"3-Seriously vulnerable",0,2,1,0,0,3,0,0,0,0,0,0,0,"3-Sanitary latrines (communal)","2-Hanging or open latrine",1,0,1,0,0,0,0,0,0,0,3,0,0,2,0,1,0,0,0,0,2,0,0,0,0,5,0,4,0,1,3,0,0,0,"0 - <1",1,0,0,0,0,1,3,2,0,0,0,0,0,1,1,"10 +",1,"4-Sanitary latrines (household)","1-Open area",1,1,0,0,3,0,2,0,0,0,1,0,"3 +","e-> 2 hours",0,2,3,1,0,0,0,0,0,0,0,1,1,1,1,1,0]
[19,"2011-09-10",9,"Jessore","Keshabpur","Shuflakati","Rural","Krishnagar","4-Damaged or water-logged",1,0,1,1,1,1,1,1,0,"3-Seriously vulnerable",1,0,0,0,0,3,2,0,0,0,0,0,0,"3-Sanitary latrines (communal)","5-Other",0,0,1,1,0,0,0,0,0,0,1,0,0,3,0,2,0,0,0,2,0,1,0,0,0,0,0,5,4,0,3,0,0,0,"3 +",null,0,0,0,0,0,3,1,0,2,0,0,0,1,1,"10 +",1,"2-Hanging or open latrine","1-Open area",1,0,0,0,3,0,2,0,1,0,1,0,"3 +","e-> 2 hours",0,0,3,2,1,0,0,1,0,0,0,1,0,1,0,1,0]
[20,"2011-09-10",8,"Jessore","Monirampur","Durbadunga","Rural","Ashanigar","3-Marooned",1,0,0,0,1,1,0,0,0,"3-Seriously vulnerable",1,0,0,0,0,2,0,0,0,3,0,0,1,"2-Hanging or open latrine","1-Open area",0,0,1,1,0,0,1,0,0,0,3,0,0,2,0,1,0,0,0,0,0,0,1,2,0,0,3,0,5,4,0,0,0,0,"3 +",1,0,0,0,0,0,2,1,0,0,3,0,0,1,1,"10 +",1,"2-Hanging or open latrine","1-Open area",1,2,0,0,1,0,3,0,0,0,1,1,"3 +","e-> 2 hours",0,2,3,0,0,1,1,1,1,0,0,1,0,1,0,1,0]
[21,"2011-09-09",8,"Jessore","Monirampur","Jhapa","Rural","2no Ward","4-Damaged or water-logged",1,0,1,0,1,1,1,0,0,"3-Seriously vulnerable",0,0,0,0,1,3,0,0,0,0,2,0,1,"1-Open area","1-Open area",0,0,1,1,0,0,1,0,0,0,3,0,0,2,0,1,0,0,0,0,0,2,4,3,0,5,1,0,0,0,0,0,0,0,"2 - 3",1,0,0,0,0,0,0,0,0,0,0,0,0,1,1,"10 +",1,"2-Hanging or open latrine","1-Open area",1,2,0,3,1,0,0,0,0,0,1,0,"3 +","e-> 2 hours",0,3,2,1,0,0,1,1,1,0,0,1,0,1,0,1,0]
[22,"2011-09-09",8,"Jessore","Monirampur","Jhapa","Rural","Jhapa","4-Damaged or water-logged",1,0,1,0,1,1,0,0,0,"3-Seriously vulnerable",1,0,2,0,0,3,0,0,0,0,0,0,1,"1-Open area","1-Open area",1,0,0,1,0,0,1,0,0,0,2,0,0,3,0,1,0,0,0,0,0,0,2,3,0,0,1,0,0,5,0,4,0,0,"3 +",1,1,0,0,0,0,2,0,0,0,3,0,0,0,1,"10 +",0,"4-Sanitary latrines (household)","2-Hanging or open latrine",1,2,0,3,0,0,0,1,0,0,1,1,"3 +","d-1 - 2 hours",0,3,2,0,0,1,1,0,1,0,0,0,0,1,0,0,0]
[23,"2011-09-10",8,"Jessore","Monirampur","Moshimnagar","Rural","Horotpur","2-Roadside / embankments",1,0,1,0,1,1,1,0,0,"2-Vulnerable",2,0,1,0,0,3,0,0,0,0,0,0,1,"1-Open area","1-Open area",1,0,1,0,0,0,0,0,0,0,1,0,3,2,0,0,0,0,0,0,0,0,0,0,0,5,0,0,2,0,1,4,3,0,"2 - 3",1,2,0,1,0,0,3,0,0,0,0,0,0,0,1,"10 +",1,"4-Sanitary latrines (household)","1-Open area",1,1,0,3,2,0,0,0,0,0,1,0,"2 - 3","c-30-60 minutes",0,3,2,1,0,0,1,0,1,0,0,1,1,0,0,0,0]
[24,"2011-09-09",8,"Jessore","Monirampur","Moshimnagar","Rural","Varatpur","3-Marooned",1,0,1,0,1,1,1,0,0,"2-Vulnerable",0,0,0,0,0,0,0,0,0,0,0,0,1,"3-Sanitary latrines (communal)","2-Hanging or open latrine",1,0,1,0,0,0,0,0,0,0,1,0,2,3,0,0,0,0,2,5,0,3,4,2,0,0,0,0,0,0,0,1,0,0,"3 +",1,1,0,0,0,0,3,1,0,0,2,0,0,0,1,"05 - 10",1,"2-Hanging or open latrine","1-Open area",1,0,0,2,3,0,1,0,0,0,1,0,"3 +","e-> 2 hours",0,3,2,1,3,0,1,1,1,0,0,1,0,1,0,1,0]
[25,"2011-09-09",7,"Kulna","Paikgacha","Horidhal","Rural","Horidaskathi","2-Roadside / embankments",0,0,0,0,0,1,1,0,0,"3-Seriously vulnerable",1,0,2,0,0,3,0,0,0,0,0,0,0,"3-Sanitary latrines (communal)","1-Open area",1,0,1,0,0,0,0,0,0,0,0,0,3,1,0,2,0,0,0,5,1,0,0,0,4,0,0,0,2,0,3,0,0,0,"3 +",1,0,1,0,0,3,0,0,0,0,0,0,2,0,1,"05 - 10",1,"2-Hanging or open latrine","1-Open area",1,0,0,3,2,0,1,0,0,0,1,0,"2 - 3","f-No access",0,2,3,0,0,1,1,1,0,0,0,1,1,1,0,1,0]
[26,"2011-09-10",7,"Kulna","Paikgacha","Horidhal","Rural","Noakathi","2-Roadside / embankments",1,0,0,0,1,1,0,0,1,"3-Seriously vulnerable",3,0,0,0,0,2,1,0,0,0,0,0,1,"3-Sanitary latrines (communal)","1-Open area",1,0,1,1,1,1,0,0,0,0,0,0,0,2,1,3,0,0,0,5,4,3,0,0,2,0,1,0,0,0,0,0,0,0,"0 - <1",null,1,0,2,0,0,3,0,0,0,0,0,0,1,1,"05 - 10",1,"4-Sanitary latrines (household)","2-Hanging or open latrine",1,0,0,0,3,0,2,1,0,0,1,0,"","f-No access",0,3,2,1,0,0,1,1,1,0,0,1,0,1,0,1,0]
[27,"2011-09-10",7,"Kulna","Paikgacha","Horikhali","Rural","ChandKhali 9No Katabunia","2-Roadside / embankments",1,0,0,0,1,1,1,1,0,"3-Seriously vulnerable",2,0,0,0,0,3,1,0,0,0,0,0,1,"2-Hanging or open latrine","1-Open area",1,1,1,0,0,0,0,0,0,0,0,0,0,3,1,2,0,0,0,5,4,0,0,0,0,0,0,3,0,0,0,2,1,0,"0 - <1",null,0,0,0,0,0,3,1,0,0,2,0,0,0,1,"05 - 10",1,"2-Hanging or open latrine","2-Hanging or open latrine",1,0,0,0,3,0,2,1,0,0,0,0,"","f-No access",0,1,2,3,0,0,1,1,1,1,0,1,1,0,0,0,0]
[28,"2011-09-09",7,"Kulna","Paikgacha","Kopilmoni","Rural","Kasimnagar","3-Marooned",1,0,1,0,1,1,1,0,0,"2-Vulnerable",1,0,2,0,0,3,0,0,0,0,0,0,1,"3-Sanitary latrines (communal)","1-Open area",1,1,1,0,0,0,0,0,0,0,2,0,0,3,0,0,0,1,0,5,0,0,4,0,0,0,0,3,2,0,0,1,0,0,"3 +",null,2,0,0,0,0,3,0,0,0,1,0,0,1,0,"10 +",1,"2-Hanging or open latrine","2-Hanging or open latrine",1,0,0,0,3,1,2,0,0,0,1,0,"","a-Health facility nearby",0,3,2,1,0,0,1,1,1,0,0,1,1,1,0,1,0]
[29,"2011-09-10",7,"Kulna","Paikgacha","Kopilmoni","Rural","Kazimusa","5-Home undamaged",0,0,0,0,1,1,1,0,0,"1-Relatively normal",2,0,0,0,0,3,1,0,0,0,0,0,1,"3-Sanitary latrines (communal)","4-Sanitary latrines (household)",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5,4,3,0,0,0,2,0,1,0,0,0,0,0,0,"0 - <1",null,0,0,2,0,1,3,0,0,0,0,0,0,1,1,"05 - 10",1,"4-Sanitary latrines (household)","5-Other",1,0,0,0,3,0,2,1,0,0,1,1,"","b-< 30 minutes",0,3,2,0,1,0,1,0,1,0,0,1,1,1,0,1,0]
[30,"2011-09-10",6,"Shatkira","Assasuni","Budhata","Rural","Behula","5-Home undamaged",1,0,0,1,1,1,1,0,0,"2-Vulnerable",3,2,0,0,1,3,0,0,0,0,0,0,0,"4-Sanitary latrines (household)","2-Hanging or open latrine",0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"0 - <1",null,1,0,0,0,0,0,0,2,0,0,0,3,1,1,"10 +",1,"4-Sanitary latrines (household)","1-Open area",1,0,0,0,0,0,0,0,0,0,1,1,"","c-30-60 minutes",0,3,2,0,0,1,0,0,1,0,0,1,1,1,0,1,0]
[31,"2011-09-09",6,"Shatkira","Assasuni","Dargapur","Rural","Sonai & Tokipur","4-Damaged or water-logged",1,0,0,0,1,0,1,0,0,"3-Seriously vulnerable",0,0,0,0,0,3,2,0,0,0,0,1,1,"4-Sanitary latrines (household)","2-Hanging or open latrine",1,0,0,0,0,0,0,0,0,0,3,0,0,0,0,0,0,0,0,2,0,0,0,0,0,5,0,4,0,0,0,0,1,3,"0 - <1",1,0,0,0,0,0,2,3,0,1,0,0,0,0,1,"10 +",1,"4-Sanitary latrines (household)","2-Hanging or open latrine",1,0,0,0,0,0,0,0,0,0,1,0,"","e-> 2 hours",0,2,3,0,0,1,1,1,0,0,0,1,1,1,0,0,0]
[32,"2011-09-10",6,"Shatkira","Assasuni","Kadakhati","Rural","Kadakati","1-Collective centers",0,0,0,0,1,1,1,1,0,"4-Extremely vulnerable",3,0,1,0,0,2,0,0,0,0,0,0,1,"4-Sanitary latrines (household)","3-Sanitary latrines (communal)",1,0,1,0,0,0,0,0,0,0,0,0,3,2,0,0,0,0,1,5,4,0,0,0,1,3,0,0,2,0,0,0,0,0,"2 - 3",1,0,0,3,0,0,1,2,0,0,0,0,0,0,0,"10 +",1,"4-Sanitary latrines (household)","3-Sanitary latrines (communal)",1,0,0,2,3,0,1,0,0,0,1,0,"2 - 3","d-1 - 2 hours",0,3,2,1,0,0,0,1,1,0,0,1,1,0,1,1,0]
[33,"2011-09-10",6,"Shatkira","Assasuni","Kadakhati","Rural","Kadakati","3-Marooned",1,0,0,0,1,1,1,1,0,"4-Extremely vulnerable",1,0,3,0,0,2,0,0,0,0,0,0,1,"4-Sanitary latrines (household)","2-Hanging or open latrine",1,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5,4,0,0,0,0,0,0,3,2,0,0,0,1,0,"0 - <1",null,0,0,3,0,0,1,2,0,0,0,0,0,0,1,"10 +",1,"2-Hanging or open latrine","2-Hanging or open latrine",1,0,0,3,2,0,1,0,0,0,1,0,"1 - 2","d-1 - 2 hours",0,1,2,3,0,0,0,1,1,0,0,1,1,1,1,1,0]
[34,"2011-09-10",6,"Shatkira","Assasuni","Kulia","Rural","Kochua","4-Damaged or water-logged",1,0,1,0,1,1,1,1,1,"2-Vulnerable",1,0,3,0,0,2,0,0,0,0,0,0,1,"4-Sanitary latrines (household)","1-Open area",1,0,0,0,0,0,0,0,0,0,1,0,3,2,0,0,0,0,0,3,2,0,0,0,0,5,0,0,4,0,0,0,0,0,"1 - 2",1,0,0,3,0,0,2,1,0,0,0,0,0,0,1,"10 +",1,"4-Sanitary latrines (household)","5-Other",1,2,0,3,1,0,0,0,0,0,1,0,"1 - 2","d-1 - 2 hours",0,3,1,2,0,0,1,1,1,0,0,1,1,1,0,1,0]
[35,"2011-09-10",6,"Shatkira","Assasuni","Shobnali","Rural","Katakhali","2-Roadside / embankments",1,1,0,0,1,1,0,1,0,"2-Vulnerable",1,0,3,0,0,2,0,0,0,0,0,0,0,"4-Sanitary latrines (household)","1-Open area",1,0,1,0,0,0,0,0,0,0,3,0,2,0,0,0,0,0,0,5,4,0,0,0,0,0,0,0,3,0,0,0,0,0,"2 - 3",1,0,0,3,0,0,2,1,0,0,0,0,0,0,1,"10 +",1,"4-Sanitary latrines (household)","1-Open area",1,0,0,3,2,0,1,0,0,0,1,0,"1 - 2","c-30-60 minutes",0,3,2,1,0,0,0,1,1,0,0,1,1,1,1,1,0]
[36,"2011-09-10",6,"Shatkira","Assasuni","Shobnali","Rural","Bodortola","3-Marooned",1,1,1,1,1,1,1,0,0,"4-Extremely vulnerable",0,0,0,0,0,3,0,0,0,0,0,0,0,"4-Sanitary latrines (household)","1-Open area",1,0,1,0,0,0,1,0,0,0,3,0,0,2,0,3,0,0,0,5,4,0,0,0,0,0,0,2,3,0,0,0,0,0,"0 - <1",null,0,0,3,0,0,2,1,0,0,0,0,0,0,1,"10 +",1,"4-Sanitary latrines (household)","2-Hanging or open latrine",1,0,0,3,2,0,0,0,0,1,1,0,"1 - 2","e-> 2 hours",0,1,0,3,0,2,1,1,1,0,0,1,1,1,1,1,0]
[37,"2011-09-10",5,"Shatkira","Debhata","Kulia","Rural","Gobrakhali","1-Collective centers",1,1,1,0,0,0,1,1,0,"4-Extremely vulnerable",1,0,2,0,0,3,0,0,0,0,0,0,null,"4-Sanitary latrines (household)","3-Sanitary latrines (communal)",0,0,1,1,1,0,0,1,1,0,0,0,2,3,0,0,0,1,0,3,0,0,0,0,0,5,4,0,0,0,0,2,1,0,"3 +",0,0,0,2,0,1,3,0,0,0,0,0,0,0,0,"10 +",1,"4-Sanitary latrines (household)","3-Sanitary latrines (communal)",1,0,0,3,2,0,3,0,0,0,1,0,"1 - 2","d-1 - 2 hours",0,3,2,0,0,1,0,1,0,0,0,1,1,1,1,1,0]
[38,"2011-09-11",5,"Shatkira","Debhata","Nowapara","Rural","Kaminiboshu","3-Marooned",0,0,1,0,1,1,1,1,0,"1-Relatively normal",1,0,2,0,0,3,0,0,0,0,0,0,1,"4-Sanitary latrines (household)","4-Sanitary latrines (household)",0,0,1,1,0,0,0,0,0,0,0,0,0,3,0,2,0,1,0,5,4,0,0,0,0,3,0,2,0,0,0,1,0,0,"0 - <1",null,0,0,2,0,0,3,0,0,0,1,0,0,0,0,"10 +",0,"4-Sanitary latrines (household)","4-Sanitary latrines (household)",1,0,0,0,3,2,0,0,0,1,1,1,"","c-30-60 minutes",0,2,3,1,0,0,0,1,0,0,0,1,1,1,0,0,0]
[39,"2011-09-11",5,"Shatkira","Debhata","Nowapara","Rural","Chachura hati","5-Home undamaged",1,0,0,0,0,1,1,1,0,"1-Relatively normal",0,2,0,0,1,3,0,0,0,0,0,0,0,"4-Sanitary latrines (household)","4-Sanitary latrines (household)",1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"0 - <1",null,0,1,2,0,0,3,0,0,0,0,0,0,0,0,"10 +",0,"4-Sanitary latrines (household)","4-Sanitary latrines (household)",0,0,0,0,3,2,0,0,0,1,1,0,"","b-< 30 minutes",0,2,3,0,0,1,0,1,0,0,0,1,1,0,0,0,0]
[40,"2011-09-11",5,"Shatkira","Debhata","Parulia","Rural","Polgoda","2-Roadside / embankments",1,0,0,0,0,1,0,0,0,"3-Seriously vulnerable",1,0,2,0,0,3,0,0,0,0,0,0,0,"4-Sanitary latrines (household)","2-Hanging or open latrine",0,0,1,1,0,0,1,0,1,0,0,0,3,2,0,0,0,0,0,4,5,0,0,0,1,0,0,3,0,0,0,2,0,0,"3 +",0,0,0,2,0,0,3,0,0,0,0,0,1,0,0,"10 +",1,"4-Sanitary latrines (household)","2-Hanging or open latrine",1,0,0,3,2,0,1,0,0,0,1,1,"1 - 2","b-< 30 minutes",0,3,2,0,0,1,0,1,0,0,0,1,1,1,1,0,0]
[41,"2011-09-09",5,"Shatkira","Debhata","Parulia","Rural","Soto Shatha","4-Damaged or water-logged",1,1,1,0,0,1,0,1,0,"4-Extremely vulnerable",0,0,2,0,0,3,0,0,0,1,0,0,null,"4-Sanitary latrines (household)","2-Hanging or open latrine",0,0,1,1,0,1,1,0,1,0,1,0,0,3,0,0,0,2,0,2,0,0,0,0,0,5,0,1,4,0,0,3,0,0,"3 +",0,0,0,2,0,3,0,1,0,0,0,0,0,0,1,"10 +",1,"4-Sanitary latrines (household)","2-Hanging or open latrine",1,0,0,0,3,0,0,2,1,0,1,0,"","e-> 2 hours",0,1,3,2,0,0,0,1,0,0,0,1,1,1,1,1,0]
[42,"2011-09-09",4,"Shatkira","Kalaroa","Deara","Rural","Deara Dakhil Madrasha","1-Collective centers",0,1,0,0,1,1,0,0,0,"3-Seriously vulnerable",2,0,3,0,1,0,0,0,0,0,0,0,0,"5-Other","3-Sanitary latrines (communal)",0,0,0,0,0,0,0,0,0,1,3,0,2,1,0,0,0,0,0,0,0,0,0,0,0,0,0,5,3,4,2,0,0,0,"3 +",1,0,1,2,0,0,3,0,0,0,0,0,0,1,1,"10 +",1,"4-Sanitary latrines (household)","1-Open area",1,1,2,3,0,0,0,0,0,0,1,0,"3 +","d-1 - 2 hours",0,3,2,1,0,0,1,1,0,0,0,1,1,0,0,1,0]
[43,"2011-09-09",4,"Shatkira","Kalaroa","Deara","Rural","Deara Matpara","2-Roadside / embankments",0,0,1,0,1,1,0,0,0,"2-Vulnerable",0,0,0,0,1,2,0,0,0,0,0,3,0,"4-Sanitary latrines (household)","1-Open area",1,0,0,0,0,0,0,0,0,0,3,0,0,2,0,0,0,0,0,3,2,0,0,0,0,0,0,5,4,0,0,0,0,0,"3 +",1,0,0,2,0,0,3,0,0,0,1,0,0,0,0,"10 +",1,"4-Sanitary latrines (household)","2-Hanging or open latrine",1,3,0,2,1,0,0,0,0,0,1,1,"3 +","e-> 2 hours",0,3,2,1,0,0,1,0,1,0,0,1,1,1,1,1,0]
[44,"2011-09-10",4,"Shatkira","Kalaroa","Joynagar","Rural","Dokkhin Khetropara","3-Marooned",1,0,0,0,1,1,1,0,0,"2-Vulnerable",0,0,0,0,3,1,0,0,0,0,0,2,1,"4-Sanitary latrines (household)","1-Open area",0,0,1,0,0,0,0,0,0,0,0,0,0,3,0,0,0,0,0,0,0,0,0,0,0,0,0,5,4,0,0,0,0,0,"1 - 2",1,0,1,0,0,0,3,2,0,0,0,0,0,0,1,"10 +",1,"4-Sanitary latrines (household)","1-Open area",1,0,0,0,3,1,2,0,0,0,1,1,"","c-30-60 minutes",0,3,2,0,0,1,1,0,1,0,0,1,1,0,0,1,0]
[45,"2011-09-10",4,"Shatkira","Kalaroa","Joynagar","Rural","Manik Nagar","5-Home undamaged",0,1,0,0,1,0,1,0,0,"1-Relatively normal",3,0,0,0,0,0,0,0,0,0,0,2,0,"4-Sanitary latrines (household)","4-Sanitary latrines (household)",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4,3,0,0,5,0,0,"3 +",null,3,2,0,0,0,0,0,0,0,1,0,0,1,0,"10 +",0,"4-Sanitary latrines (household)","4-Sanitary latrines (household)",1,3,0,0,2,0,0,0,0,1,1,1,"","d-1 - 2 hours",0,0,3,2,0,1,0,0,1,0,0,1,1,0,0,0,0]
[46,"2011-09-09",4,"Shatkira","Kalaroa","Pouroshava","Urban","Gopinathpur Poschim para","4-Damaged or water-logged",0,0,1,0,1,1,1,0,0,"1-Relatively normal",0,0,0,0,2,3,1,0,0,0,0,0,1,"4-Sanitary latrines (household)","1-Open area",0,0,0,0,0,0,0,0,0,0,3,0,0,0,2,1,0,0,0,0,0,0,0,0,0,0,0,5,4,0,0,0,0,0,"3 +",1,0,0,2,0,0,3,1,0,0,0,0,0,1,1,"10 +",1,"4-Sanitary latrines (household)","2-Hanging or open latrine",1,0,0,0,3,1,2,0,0,0,1,1,"","d-1 - 2 hours",0,2,3,1,0,0,0,1,1,0,0,1,1,0,0,1,0]
[47,"2011-09-09",3,"Shatkira","Shaktira_Sadar","Bolli","Rural","Rajjabari bad, Mukudpur vill","2-Roadside / embankments",1,1,1,0,1,1,1,0,1,"4-Extremely vulnerable",1,0,2,0,0,3,0,0,0,0,0,0,0,"4-Sanitary latrines (household)","2-Hanging or open latrine",0,0,1,0,0,0,1,0,0,0,0,0,3,2,0,1,0,0,0,5,4,0,0,0,0,2,0,1,3,0,0,0,0,0,"3 +",1,0,2,0,0,0,3,0,1,0,0,0,0,0,1,"10 +",1,"4-Sanitary latrines (household)","1-Open area",1,3,0,2,0,0,1,0,0,0,1,0,"2 - 3","d-1 - 2 hours",0,3,2,0,0,1,1,1,0,0,0,1,1,1,0,1,0]
[48,"2011-09-10",3,"Shatkira","Shaktira_Sadar","Brahamorajpur","Rural","Machkhola","4-Damaged or water-logged",1,1,1,0,1,1,1,1,1,"4-Extremely vulnerable",1,0,3,0,0,2,0,0,0,0,0,0,1,"4-Sanitary latrines (household)","2-Hanging or open latrine",1,1,1,0,0,0,1,1,0,0,0,1,0,3,0,2,0,0,0,5,1,4,0,0,0,0,0,2,3,0,0,0,0,0,"2 - 3",null,0,0,1,0,0,3,2,0,0,0,0,0,0,1,"10 +",1,"2-Hanging or open latrine","2-Hanging or open latrine",1,0,0,0,3,0,2,1,0,0,1,0,"2 - 3","b-< 30 minutes",0,0,3,0,1,2,0,0,0,0,0,1,1,1,1,1,0]
[49,"2011-09-10",3,"Shatkira","Shaktira_Sadar","Fringi","Rural","Gobordari","5-Home undamaged",0,0,0,0,1,1,1,0,0,"4-Extremely vulnerable",3,0,0,0,0,1,0,0,0,2,0,0,0,"4-Sanitary latrines (household)","3-Sanitary latrines (communal)",0,0,1,0,0,0,1,0,0,0,0,0,0,3,0,2,0,0,0,5,4,4,0,0,0,3,0,1,2,0,0,0,0,0,"2 - 3",null,0,0,0,1,0,3,2,0,0,0,0,0,0,1,"05 - 10",1,"2-Hanging or open latrine","2-Hanging or open latrine",1,0,0,0,3,0,0,2,1,0,1,0,"","a-Health facility nearby",0,3,2,0,0,1,1,1,0,0,0,1,1,0,0,1,0]
[50,"2011-09-09",3,"Shatkira","Shaktira_Sadar","Labsa","Rural","Soninathpur, Binerputa","3-Marooned",1,1,0,1,1,1,1,0,1,"4-Extremely vulnerable",0,0,1,0,0,2,0,0,0,0,3,0,0,"4-Sanitary latrines (household)","2-Hanging or open latrine",1,0,0,0,0,0,0,0,0,0,3,1,0,2,0,0,0,0,0,3,5,0,0,0,0,1,0,4,2,0,0,0,0,0,"3 +",null,0,0,2,0,0,1,0,0,0,0,0,3,0,1,"05 - 10",1,"4-Sanitary latrines (household)","2-Hanging or open latrine",1,0,0,0,3,0,1,2,0,0,1,0,"","c-30-60 minutes",0,2,3,1,0,0,1,1,0,0,0,1,1,1,0,1,0]
[51,"2011-09-09",3,"Shatkira","Shaktira_Sadar","Municipality","Rural","6 No Ward","1-Collective centers",1,1,1,0,1,1,1,0,1,"4-Extremely vulnerable",0,0,2,1,0,3,0,0,0,0,0,0,1,"4-Sanitary latrines (household)","2-Hanging or open latrine",1,0,1,0,0,0,0,0,0,0,3,0,2,0,0,0,0,0,0,5,4,2,0,0,0,0,0,0,3,0,0,0,1,0,"3 +",1,0,0,0,0,2,3,0,0,0,0,1,0,0,1,"10 +",1,"4-Sanitary latrines (household)","2-Hanging or open latrine",1,0,0,3,0,0,2,1,0,0,1,0,"1 - 2","e-> 2 hours",0,0,3,2,1,0,0,0,0,0,0,1,1,1,1,1,0]
[52,"2011-09-10",3,"Shatkira","Shaktira_Sadar","Municipality","Urban","6 No Ward","2-Roadside / embankments",0,0,0,0,1,1,0,0,1,"4-Extremely vulnerable",1,0,3,0,0,2,0,0,0,0,0,0,1,"4-Sanitary latrines (household)","3-Sanitary latrines (communal)",0,0,1,0,0,0,1,0,0,0,0,0,3,2,0,1,0,0,0,5,4,0,0,0,0,0,0,0,3,0,0,0,0,0,"2 - 3",1,1,0,2,0,0,3,0,0,0,0,0,0,0,0,"10 +",1,"4-Sanitary latrines (household)","1-Open area",1,0,0,3,2,0,1,0,0,0,1,0,"2 - 3","b-< 30 minutes",0,1,3,0,0,2,0,1,1,0,0,0,0,0,0,1,0]
[53,"2011-09-09",1,"Shatkira","Tala","Islam Kati","Rural","Narayanpur/ Bhanipur","2-Roadside / embankments",1,1,1,0,1,1,1,1,0,"4-Extremely vulnerable",0,0,2,0,0,3,0,0,0,1,0,0,0,"4-Sanitary latrines (household)","3-Sanitary latrines (communal)",0,0,1,0,0,0,0,0,1,0,1,0,3,2,0,0,0,0,0,5,0,0,0,1,2,4,0,3,0,0,0,0,0,0,"3 +",1,0,0,0,0,1,3,2,0,0,0,0,0,0,1,"10 +",1,"4-Sanitary latrines (household)","3-Sanitary latrines (communal)",1,0,2,0,3,0,0,1,0,0,1,0,"3 +","c-30-60 minutes",0,2,3,0,1,0,1,1,1,0,0,1,1,1,1,1,0]
[54,"2011-09-11",2,"Shatkira","Tala","Khalilinagar","Rural","Nagarghata","2-Roadside / embankments",1,1,1,0,1,1,1,0,0,"4-Extremely vulnerable",0,0,2,0,0,3,0,0,0,1,0,0,1,"3-Sanitary latrines (communal)","2-Hanging or open latrine",1,0,1,1,0,0,1,1,1,0,3,0,2,1,0,0,0,0,0,5,0,0,0,0,0,4,3,1,0,0,2,1,0,0,"3 +",1,0,0,3,0,0,2,1,0,0,0,0,0,0,1,"10 +",1,"4-Sanitary latrines (household)","3-Sanitary latrines (communal)",1,0,0,3,2,0,0,1,0,0,1,0,"3 +","d-1 - 2 hours",0,3,0,1,0,2,0,1,1,0,0,1,1,0,0,1,0]
[55,"2011-09-10",2,"Shatkira","Tala","Kholishakhali","Rural","Dolua College","1-Collective centers",1,1,0,0,1,1,1,1,0,"4-Extremely vulnerable",1,0,3,0,0,2,0,0,0,0,0,0,1,"3-Sanitary latrines (communal)","3-Sanitary latrines (communal)",0,1,1,1,1,0,1,1,0,0,2,0,3,1,0,0,0,0,0,3,0,0,0,0,0,5,0,0,2,0,4,0,1,0,"1 - 2",1,0,0,3,0,0,1,0,2,0,0,0,0,1,1,"10 +",1,"4-Sanitary latrines (household)","3-Sanitary latrines (communal)",1,3,0,0,1,2,0,0,0,0,1,0,"3 +","b-< 30 minutes",0,3,2,1,0,0,1,1,0,0,0,1,0,0,0,0,0]
[56,"2011-09-11",2,"Shatkira","Tala","Kumira","Rural","Raripara","3-Marooned",1,0,1,0,1,1,1,0,0,"2-Vulnerable",0,0,0,0,0,2,0,0,0,1,0,3,1,"3-Sanitary latrines (communal)","2-Hanging or open latrine",0,0,0,1,0,0,0,0,0,0,0,1,0,3,0,0,0,0,2,2,0,0,0,0,0,5,4,0,0,0,0,1,0,0,"3 +",null,3,0,0,0,2,1,0,0,0,0,0,0,1,1,"10 +",1,"4-Sanitary latrines (household)","3-Sanitary latrines (communal)",1,0,0,0,3,0,1,2,0,0,1,0,"2 - 3","e-> 2 hours",0,3,0,2,0,1,0,1,0,0,0,1,1,0,0,0,0]
[57,"2011-09-10",2,"Shatkira","Tala","Magura","Rural","Parmadra","4-Damaged or water-logged",1,0,1,0,1,1,1,0,0,"4-Extremely vulnerable",2,0,3,0,0,1,0,0,0,0,0,0,1,"3-Sanitary latrines (communal)","2-Hanging or open latrine",0,0,1,1,0,0,0,0,0,0,0,0,0,3,1,0,0,0,2,4,0,0,0,0,0,2,0,0,5,0,1,3,0,0,"3 +",0,0,0,0,0,2,3,1,0,0,0,0,0,0,1,"05 - 10",1,"4-Sanitary latrines (household)","3-Sanitary latrines (communal)",1,0,0,0,0,0,0,0,0,0,1,0,"3 +","e-> 2 hours",0,1,2,3,0,0,1,1,0,0,0,1,0,0,0,0,0]
[58,"2011-09-10",2,"Shatkira","Tala","Nagarghata","Rural","Nagarghata","5-Home undamaged",0,0,0,0,0,0,1,1,0,"2-Vulnerable",2,1,0,0,0,3,0,0,0,0,0,0,0,"4-Sanitary latrines (household)","3-Sanitary latrines (communal)",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"0 - <1",null,2,0,0,1,0,3,0,0,0,0,0,0,1,1,"05 - 10",0,"4-Sanitary latrines (household)","5-Other",1,0,0,0,0,0,0,0,0,0,1,0,"3 +","e-> 2 hours",0,3,0,2,0,1,1,1,0,0,0,1,0,0,0,0,0]
[59,"2011-09-10",1,"Shatkira","Tala","Sarulia","Rural","Kasipur","1-Collective centers",1,1,1,0,1,1,1,1,0,"3-Seriously vulnerable",0,0,0,0,1,3,2,0,0,0,0,0,0,"4-Sanitary latrines (household)","1-Open area",0,1,0,1,0,0,0,1,0,0,0,0,3,2,0,1,0,0,0,5,0,4,0,3,0,0,0,2,1,0,0,0,0,0,"3 +",1,0,0,1,0,0,3,2,0,0,0,0,0,0,1,"10 +",1,"4-Sanitary latrines (household)","3-Sanitary latrines (communal)",1,0,0,3,2,0,0,1,0,0,1,0,"3 +","a-Health facility nearby",0,2,3,1,0,0,1,1,1,0,0,1,1,1,0,1,0]
[60,"2011-09-11",1,"Shatkira","Tala","Sarulia","Rural","Boro Kasipur","3-Marooned",1,1,1,0,1,1,1,1,0,"3-Seriously vulnerable",2,0,1,0,0,3,0,0,0,0,0,0,0,"4-Sanitary latrines (household)","1-Open area",1,0,1,0,0,0,0,1,0,0,0,0,3,2,0,1,0,0,0,2,0,0,0,5,4,0,0,0,3,0,0,1,0,0,"3 +",0,1,0,0,0,0,3,2,0,0,0,0,0,0,1,"10 +",1,"4-Sanitary latrines (household)","5-Other",1,0,0,0,0,3,0,0,2,1,1,0,"3 +","c-30-60 minutes",0,1,2,3,0,0,1,1,1,0,0,1,1,0,0,1,0]
[61,"2011-09-10",1,"Shatkira","Tala","Tala Sadar","Rural","Monipur/ Shahpur","2-Roadside / embankments",1,1,1,0,1,1,1,1,0,"4-Extremely vulnerable",2,0,1,0,0,3,0,0,0,0,0,0,1,"4-Sanitary latrines (household)","5-Other",0,1,1,1,0,0,1,0,0,0,0,0,3,2,0,0,0,1,0,5,0,0,0,1,2,4,0,3,2,1,0,0,0,0,"3 +",1,0,0,2,0,0,3,1,0,0,0,0,0,0,1,"10 +",1,"4-Sanitary latrines (household)","3-Sanitary latrines (communal)",1,0,0,1,3,0,0,2,0,0,1,0,"3 +","e-> 2 hours",0,2,3,0,0,1,1,1,1,0,0,1,1,1,0,1,0]
[62,"2011-09-10",1,"Shatkira","Tala","Tala Sadar","Rural","Kismotghona","5-Home undamaged",1,1,0,0,1,1,1,1,0,"2-Vulnerable",2,0,0,0,0,3,0,0,0,1,0,0,1,"4-Sanitary latrines (household)","4-Sanitary latrines (household)",0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,5,3,0,0,0,0,4,0,0,1,0,0,2,0,0,"3 +",null,0,0,0,1,0,2,0,0,0,3,0,0,1,0,"10 +",0,"4-Sanitary latrines (household)","4-Sanitary latrines (household)",0,0,0,0,0,0,0,0,0,0,1,0,"","c-30-60 minutes",0,1,2,3,0,0,1,0,1,0,0,1,0,0,0,0,0]
[63,"2011-09-09",1,"Shatkira","Tala","Tentulia","Rural","Hatbas, Modonpur, Lakkhanpur","2-Roadside / embankments",1,1,1,0,1,1,1,1,0,"4-Extremely vulnerable",0,0,2,0,0,3,0,0,0,1,0,0,1,"4-Sanitary latrines (household)","3-Sanitary latrines (communal)",0,1,1,1,0,0,0,0,0,0,0,0,3,2,0,1,0,0,0,5,4,0,3,0,2,0,0,1,0,0,0,0,0,0,"3 +",1,0,0,1,0,0,3,2,0,0,0,0,0,0,1,"10 +",1,"4-Sanitary latrines (household)","3-Sanitary latrines (communal)",1,0,0,0,3,0,0,2,0,1,1,0,"3 +","c-30-60 minutes",0,2,3,1,0,0,1,1,0,0,0,1,1,1,1,1,0]

{"sheet":"Analysis01_Variables","index":2,"n_rows":132,"n_cols":15,"rows_kept":132,"cut":false,"hidden":false,"merged":[]}
["ColNo","Data sets by origin","Type of variable","Variable label","Variable name (question no.)","COUNTA","COUNT","MIN","MEDIAN","MEAN over non-blanks","MEAN, blanks = 0","MAX","SUM","Original question wording - Upper level. Also: for calculated variables, the formulas used (See in rows 121 - 132).","Original question wording - Lower level - or response options, numbered"]
[1,"Identifiers","Integer","Record number","i_00_01",{"$f":"COUNTA(INDIRECT($E2))","v":63},{"$f":"COUNT(INDIRECT($E2))","v":63},{"$f":"MIN(INDIRECT($E2))","v":1},{"$f":"MEDIAN(INDIRECT($E2))","v":32},{"$f":"AVERAGE(INDIRECT($E2))","v":32},{"$f":"IF(L2=0,\"\",SUM(INDIRECT($E2)) / 63)","v":32},{"$f":"MAX(INDIRECT($E2))","v":63},{"$f":"SUM(INDIRECT($E2))","v":2016},"Localisation","New Number"]
[2,null,"Date","Assessment date","i_00_03",63,63,"2011-09-08",{"$f":"MEDIAN(INDIRECT($E3))","v":"2011-09-10"},{"$f":"AVERAGE(INDIRECT($E3))","v":40795.793650793654},40795.793650793654,"2011-09-11",2570135,"Localisation","00.03 Date"]
[3,null,"Categorical","Team number","i_00_04",63,63,1,{"$f":"MEDIAN(INDIRECT($E4))","v":6},{"$f":"AVERAGE(INDIRECT($E4))","v":6.1269841269841274},6.1269841269841274,11,386,"Localisation","00.04 Team Number"]
[4,null,"Categorical","District","i_00_05",63,0,0,null,null,"",0,0,"Localisation","00.05 District"]
[5,null,"Categorical","Upazila","i_00_06",63,0,0,null,null,"",0,0,"Localisation","00.06 Upazilla"]
[6,null,"Categorical","Union","i_00_07",63,0,0,null,null,"",0,0,"Localisation","00.07 Union"]
[7,null,"Categorical","Urban vs. rural","i_00_08",63,0,0,null,null,"",0,0,"Localisation","00.08 Urban / Rural"]
[8,null,"Categorical","Village","i_00_09",63,0,0,null,null,"",0,0,"Localisation","00.09Village"]
[9,"Team observations","Grouping variable","Living arrangement","t_00_10",63,0,0,null,null,"",0,0,"Living Arrangement","00.10 Living Arrangement"]
[10,null,"Binary indicator","Stagnant water: Settlement","t_02_01",63,63,0,{"$f":"MEDIAN(INDIRECT($E11))","v":1},{"$f":"AVERAGE(INDIRECT($E11))","v":0.80952380952380953},0.80952380952380953,1,51,"02.00 There are problems with stagnant water: ( Tick all that apply) ","02.01in and around settlement"]
[11,null,"Binary indicator","Stagnant water: Shelter","t_02_02",63,63,0,0,0.36507936507936506,0.36507936507936506,1,23,"02.00 There are problems with stagnant water: ( Tick all that apply) ","02.02 in and around shelters"]
[12,null,"Binary indicator","Stagnant water: Water points","t_02_03",63,63,0,1,0.60317460317460314,0.60317460317460314,1,38,"02.00 There are problems with stagnant water: ( Tick all that apply) ","02.03 in and around water points/facilities"]
[13,null,"Binary indicator","Stagnant water: Other","t_02_04",63,63,0,0,9.5238095238095233E-2,9.5238095238095233E-2,1,6,"02.00 There are problems with stagnant water: ( Tick all that apply) ","02.04 other"]
[14,null,"Binary indicator","Garbage","t_03_00",63,63,0,1,0.8571428571428571,0.8571428571428571,1,54,null,"03.00 Is there a problem with garbage/waste around where people are staying?"]
[15,null,"Binary indicator","Disease vectors","t_04_00",63,63,0,1,0.93650793650793651,0.93650793650793651,1,59,null,"04.00 Are there vectors evident where people are staying (mosquitoes, rats etc)"]
[16,null,"Binary indicator","Latrines at site","t_05_00",63,63,0,1,0.8571428571428571,0.8571428571428571,1,54,null,"05.00 Are there latrines at the site?"]
[17,null,"Binary indicator","Students truant","t_09_00",63,63,0,0,0.47619047619047616,0.47619047619047616,1,30,null,"09.00 Were school aged children observed out of school during school hours on school days? "]
[18,null,"Binary indicator","Open water sources","t_10_07",63,63,0,0,0.15873015873015872,0.15873015873015872,1,10,null,"10.07 Water taken also from ponds, rivers, canals"]
[19,null,"Team's severity ranking","Site assessment by team","t_14_00",63,0,0,null,null,"",0,0,null,"14.00 Assessment team overall ranking of the situation at this site: (tick one only) "]
[20,"Men's groups","Priority type data","Priority for men: Livelihoods","m_03_01",63,63,0,{"$f":"MEDIAN(INDIRECT($E21))","v":1},{"$f":"AVERAGE(INDIRECT($E21))","v":1.3809523809523809},1.3809523809523809,3,87,"03.00 For men in this community, what is the top priority right now? (select three only, number them 1st, 2nd, 3rd)","03.01 resumption of livelihood activities"]
[21,null,null,"Priority for men: Livestock feed","m_03_02",63,63,0,0,0.15873015873015872,0.15873015873015872,2,10,"03.00 For men in this community, what is the top priority right now? (select three only, number them 1st, 2nd, 3rd)","03.02 feed for livestock"]
[22,null,null,"Priority for men: Rebuild homes","m_03_03",63,63,0,0,0.87301587301587302,0.87301587301587302,3,55,"03.00 For men in this community, what is the top priority right now? (select three only, number them 1st, 2nd, 3rd)","03.03 return/rebuild houses"]
[23,null,null,"Priority for men: Children's schooling","m_03_04",63,63,0,0,1.5873015873015872E-2,1.5873015873015872E-2,1,1,"03.00 For men in this community, what is the top priority right now? (select three only, number them 1st, 2nd, 3rd)","03.04 children return to school"]
[24,null,null,"Priority for men: Health care","m_03_05",63,63,0,0,0.30158730158730157,0.30158730158730157,3,19,"03.00 For men in this community, what is the top priority right now? (select three only, number them 1st, 2nd, 3rd)","03.05 health care"]
[25,null,null,"Priority for men: Food","m_03_06",63,63,0,3,2.2380952380952381,2.2380952380952381,3,141,"03.00 For men in this community, what is the top priority right now? (select three only, number them 1st, 2nd, 3rd)","03.06 food "]
[26,null,null,"Priority for men: Safe drinking water","m_03_07",63,63,0,0,0.30158730158730157,0.30158730158730157,3,19,"03.00 For men in this community, what is the top priority right now? (select three only, number them 1st, 2nd, 3rd)","03.07 access to clean drinking water"]
[27,null,null,"Priority for men: Water for wash and bath","m_03_08",63,63,0,null,null,"",0,0,"03.00 For men in this community, what is the top priority right now? (select three only, number them 1st, 2nd, 3rd)","03.08 access to water for washing/bathing"]
[28,null,null,"Priority for men: Markets","m_03_09",63,63,0,null,null,"",0,0,"03.00 For men in this community, what is the top priority right now? (select three only, number them 1st, 2nd, 3rd)","03.09 access to markets"]
[29,null,null,"Priority for men: Short-term financial support","m_03_10",63,63,0,{"$f":"MEDIAN(INDIRECT($E30))","v":0},{"$f":"AVERAGE(INDIRECT($E30))","v":0.30158730158730157},0.30158730158730157,3,19,"03.00 For men in this community, what is the top priority right now? (select three only, number them 1st, 2nd, 3rd)","03.10 short term financial support"]
[30,null,null,"Priority for men: Safety","m_03_11",63,63,0,{"$f":"MEDIAN(INDIRECT($E31))","v":0},{"$f":"AVERAGE(INDIRECT($E31))","v":0.1111111111111111},0.1111111111111111,3,7,"03.00 For men in this community, what is the top priority right now? (select three only, number them 1st, 2nd, 3rd)","03.11 concerns about safety and security"]
[31,null,null,"Priority for men: Other","m_03_12",63,63,0,{"$f":"MEDIAN(INDIRECT($E32))","v":0},{"$f":"AVERAGE(INDIRECT($E32))","v":0.20634920634920634},0.20634920634920634,3,13,"03.00 For men in this community, what is the top priority right now? (select three only, number them 1st, 2nd, 3rd)","03.12 other"]
[32,null,"Binary indicator","Lack of safe water serious (men)","m_04_00",61,61,0,{"$f":"MEDIAN(INDIRECT($E33))","v":1},{"$f":"AVERAGE(INDIRECT($E33))","v":0.63934426229508201},0.61904761904761907,1,39,null,"04.00 Is there a serious problem in your community because people do not have enough water that is safe for drinking and cooking?"]
[33,null,"Before - after pair of categorical","Defecation, males, pre-disaster","m_06_01",{"$f":"COUNTA(INDIRECT($E34))","v":63},{"$f":"COUNT(INDIRECT($E34))","v":0},{"$f":"MIN(INDIRECT($E34))","v":0},null,null,{"$f":"IF(L34=0,\"\",SUM(INDIRECT($E34)) / 63)","v":""},{"$f":"MAX(INDIRECT($E34))","v":0},{"$f":"SUM(INDIRECT($E34))","v":0},"Sanitation","06.01Where did men and boys  mostly defecate prior to the flooding/water-logging?"]
[34,null,"Before - after pair of categorical","Defecation, males, post-disaster","m_06_02",63,0,0,null,null,"",0,0,null,"06.02 Where do men and boys mostly defecate NOW?"]
[35,null,"Multiple response data","Shelter issues for men: Shelter not available","m_07_01",63,63,0,{"$f":"MEDIAN(INDIRECT($E36))","v":1},{"$f":"AVERAGE(INDIRECT($E36))","v":0.52380952380952384},0.52380952380952384,1,33,"07.00 What are the main problems with meeting shelter needs here? (select all that are mentioned by the group)","07.01 no shelter"]
[36,null,null,"Shelter issues for men: Overcrowded","m_07_02",63,63,0,0,0.19047619047619047,0.19047619047619047,1,12,"07.00 What are the main problems with meeting shelter needs here? (select all that are mentioned by the group)","07.02 communal shelters are overcrowded"]
[37,null,null,"Shelter issues for men: Return home impossible","m_07_03",63,63,0,1,0.65079365079365081,0.65079365079365081,1,41,"07.00 What are the main problems with meeting shelter needs here? (select all that are mentioned by the group)","07.03 homes uninhabitable"]
[38,null,null,"Shelter issues for men: No repair materials","m_07_04",63,63,0,0,0.36507936507936506,0.36507936507936506,1,23,"07.00 What are the main problems with meeting shelter needs here? (select all that are mentioned by the group)","07.04 materials for repair are not available"]
[39,null,null,"Shelter issues for men: No manpower for repairs","m_07_05",63,63,0,0,4.7619047619047616E-2,4.7619047619047616E-2,1,3,"07.00 What are the main problems with meeting shelter needs here? (select all that are mentioned by the group)","07.05 skills/labour for repair not available"]
[40,null,null,"Shelter issues for men: Land issues for men","m_07_06",63,63,0,0,3.1746031746031744E-2,3.1746031746031744E-2,1,2,"07.00 What are the main problems with meeting shelter needs here? (select all that are mentioned by the group)","07.06 potential grievances on land issues"]
[41,null,null,"Shelter issues for men: Lack of household items","m_07_07",63,63,0,0,0.23809523809523808,0.23809523809523808,1,15,"07.00 What are the main problems with meeting shelter needs here? (select all that are mentioned by the group)","07.07people lack basic household items "]
[42,null,null,"Shelter issues for men: Lack of privacy","m_07_08",63,63,0,0,0.15873015873015872,0.15873015873015872,1,10,"07.00 What are the main problems with meeting shelter needs here? (select all that are mentioned by the group)","07.08 shelters do not offer privacy"]
[43,null,null,"Shelter issues for men: Exposed to weather","m_07_09",63,63,0,0,0.1111111111111111,0.1111111111111111,1,7,"07.00 What are the main problems with meeting shelter needs here? (select all that are mentioned by the group)","07.09 shelters do not offer protection from weather/elements"]
[44,null,null,"Shelter issues for men: Other","m_07_10",63,63,0,0,0.12698412698412698,0.12698412698412698,1,8,"07.00 What are the main problems with meeting shelter needs here? (select all that are mentioned by the group)","07.10 other"]
[45,null,null,"Shelter priorities for men: Find shelter","m_08_01",63,63,0,0,1,1,3,63,"08.00 What are the top 3 shelter priorities for the male group in relation to shelter? (number 1st, 2nd, 3rd )  ","08.01 to acquire shelter / presently without shelter at all"]
[46,null,"Priority data","Shelter priorities for men: Move out of shelter","m_08_02",63,63,0,0,6.3492063492063489E-2,6.3492063492063489E-2,1,4,"08.00 What are the top 3 shelter priorities for the male group in relation to shelter? (number 1st, 2nd, 3rd )  ","08.02 to move out of a communal shelters "]
[47,null,null,"Shelter priorities for men: Return home","m_08_03",63,63,0,0,0.8571428571428571,0.8571428571428571,3,54,"08.00 What are the top 3 shelter priorities for the male group in relation to shelter? (number 1st, 2nd, 3rd )  ","08.03 return home "]
[48,null,null,"Shelter priorities for men: Material for home repair","m_08_04",63,63,0,2,1.8095238095238095,1.8095238095238095,3,114,"08.00 What are the top 3 shelter priorities for the male group in relation to shelter? (number 1st, 2nd, 3rd )  ","08.04 materials for repair of house"]
[49,null,null,"Shelter priorities for men: Manpower for home repair","m_08_05",63,63,0,0,9.5238095238095233E-2,9.5238095238095233E-2,2,6,"08.00 What are the top 3 shelter priorities for the male group in relation to shelter? (number 1st, 2nd, 3rd )  ","08.05 skills/labour for repair "]
[50,null,null,"Shelter priorities for men: Household items","m_08_06",63,63,0,0,0.60317460317460314,0.60317460317460314,3,38,"08.00 What are the top 3 shelter priorities for the male group in relation to shelter? (number 1st, 2nd, 3rd )  ","08.06 basic household items "]
[51,null,null,"Shelter priorities for men: Privacy","m_08_07",63,63,0,0,0.15873015873015872,0.15873015873015872,2,10,"08.00 What are the top 3 shelter priorities for the male group in relation to shelter? (number 1st, 2nd, 3rd )  ","08.07 shelter to give more privacy"]
[52,null,null,"Shelter priorities for men: Protection from weather","m_08_08",63,63,0,0,0.12698412698412698,0.12698412698412698,2,8,"08.00 What are the top 3 shelter priorities for the male group in relation to shelter? (number 1st, 2nd, 3rd )  ","08.08 Shelter to give mor protection from weather/elements"]
[53,null,null,"Shelter priorities for men: Other","m_08_09",63,63,0,0,0.12698412698412698,0.12698412698412698,2,8,"08.00 What are the top 3 shelter priorities for the male group in relation to shelter? (number 1st, 2nd, 3rd )  ","08.09 other"]
[54,null,"Priority data","Coping priorities for men: Reduce meal size","m_16_01",63,63,0,3,2.746031746031746,2.746031746031746,5,173,"16.00 What strategies are being used by the community here to cope with loss of livelihoods?","16.01 Reduced meal size"]
[55,null,null,"Coping priorities for men: East less preferred food","m_16_02",63,63,0,0,1.4444444444444444,1.4444444444444444,5,91,"16.00 What strategies are being used by the community here to cope with loss of livelihoods?","16.02 Eat less preferred food"]
[56,null,null,"Coping priorities for men: Eat wild foods","m_16_03",63,63,0,0,0.42857142857142855,0.42857142857142855,4,27,"16.00 What strategies are being used by the community here to cope with loss of livelihoods?","16.03  Eat wild food like roadside vegetables etc."]
[57,null,null,"Coping priorities for men: Restrict adult male consumption","m_16_04",63,63,0,0,0.31746031746031744,0.31746031746031744,4,20,"16.00 What strategies are being used by the community here to cope with loss of livelihoods?","16.04 Male adults restrict food consumption to feed the children"]
[58,null,null,"Coping priorities for men: Restrict adult female consumption","m_16_05",63,63,0,0,0.44444444444444442,0.44444444444444442,5,28,"16.00 What strategies are being used by the community here to cope with loss of livelihoods?","16.05 Female adults restrict food consumption to feed the children"]
[59,null,null,"Coping priorities for men: Send children to relatives","m_16_06",63,63,0,0,0.2857142857142857,0.2857142857142857,4,18,"16.00 What strategies are being used by the community here to cope with loss of livelihoods?","16.06 Send children to friend/relative’s house"]
[60,null,null,"Coping priorities for men: Borrow money","m_16_07",63,63,0,2,2.0793650793650795,2.0793650793650795,5,131,"16.00 What strategies are being used by the community here to cope with loss of livelihoods?","16.07 Borrow money at high interest"]
[61,null,null,"Coping priorities for men: Advance labor sale","m_16_08",63,63,0,0,0.44444444444444442,0.44444444444444442,4,28,"16.00 What strategies are being used by the community here to cope with loss of livelihoods?","16.08 Selling of advanced labour"]
[62,null,null,"Coping priorities for men: Buy food on creadit","m_16_09",63,63,0,1,1.9523809523809523,1.9523809523809523,5,123,"16.00 What strategies are being used by the community here to cope with loss of livelihoods?","16.09 Purchase food on credit"]
[63,null,null,"Coping priorities for men: Sell livestock and poultry","m_16_10",63,63,0,2,1.8095238095238095,1.8095238095238095,5,114,"16.00 What strategies are being used by the community here to cope with loss of livelihoods?","16.10 Selling of  livestock and poultry"]
[64,null,null,"Coping priorities for men: Sell household utensils","m_16_11",63,63,0,0,0.47619047619047616,0.47619047619047616,5,30,"16.00 What strategies are being used by the community here to cope with loss of livelihoods?","16.11 Selling of household utensils/utilities"]
[65,null,null,"Coping priorities for men: Sell land or trees","m_16_12",{"$f":"COUNTA(INDIRECT($E66))","v":63},{"$f":"COUNT(INDIRECT($E66))","v":63},{"$f":"MIN(INDIRECT($E66))","v":0},0,0.46031746031746029,{"$f":"IF(L66=0,\"\",SUM(INDIRECT($E66)) / 63)","v":0.46031746031746029},{"$f":"MAX(INDIRECT($E66))","v":4},{"$f":"SUM(INDIRECT($E66))","v":29},"16.00 What strategies are being used by the community here to cope with loss of livelihoods?","16.12 Selling of land/tree"]
[66,null,null,"Coping priorities for men: Outmigration","m_16_13",63,63,0,0,0.76190476190476186,0.76190476190476186,5,48,"16.00 What strategies are being used by the community here to cope with loss of livelihoods?","16.13 Out migration of household members"]
[67,null,null,"Coping priorities for men: Send children to work","m_16_14",63,63,0,0,0.26984126984126983,0.26984126984126983,3,17,"16.00 What strategies are being used by the community here to cope with loss of livelihoods?","16.14 Send children to work"]
[68,null,null,"Coping priorities for men: Other","m_16_15",63,63,0,0,6.3492063492063489E-2,6.3492063492063489E-2,3,4,"16.00 What strategies are being used by the community here to cope with loss of livelihoods?","16.15 Others (specify)"]
[69,null,"Ordered categorical indicator","Expected stay at shelter (men)","m_17_00",63,0,0,null,null,"",0,0,null,"17.00 How long do you think you will stay here before you will go back home? (tick one)"]
[70,null,"Binary indicator","Safety of home and property (men)","m_21_00",36,36,0,{"$f":"MEDIAN(INDIRECT($E71))","v":1},{"$f":"AVERAGE(INDIRECT($E71))","v":0.86111111111111116},0.49206349206349204,1,31,null,"21.00 Do you have security concerns for your house and property that you have left?"]
[71,"Women's groups","Priority data","Priority for women: Livelihoods","w_03_01",63,63,0,0,0.61904761904761907,0.61904761904761907,3,39,"03.00 For women in this community, what is the top priority right now? (select three only, number them 1st, 2nd, 3rd)","03.01 resumption of livelihood activities"]
[72,null,null,"Priority for women: Livestock feed","w_03_02",63,63,0,0,0.17460317460317459,0.17460317460317459,2,11,"03.00 For women in this community, what is the top priority right now? (select three only, number them 1st, 2nd, 3rd)","03.02 feed for livestock"]
[73,null,null,"Priority for women: Rebuild homes","w_03_03",63,63,0,0,0.98412698412698407,0.98412698412698407,3,62,"03.00 For women in this community, what is the top priority right now? (select three only, number them 1st, 2nd, 3rd)","03.03 return/rebuild houses"]
[74,null,null,"Priority for women: Children's schooling","w_03_04",63,63,0,0,4.7619047619047616E-2,4.7619047619047616E-2,1,3,"03.00 For women in this community, what is the top priority right now? (select three only, number them 1st, 2nd, 3rd)","03.04 children return to school"]
[75,null,null,"Priority for women: Health care","w_03_05",63,63,0,0,0.33333333333333331,0.33333333333333331,3,21,"03.00 For women in this community, what is the top priority right now? (select three only, number them 1st, 2nd, 3rd)","03.05 health care"]
[76,null,null,"Priority for women: Food","w_03_06",63,63,0,3,2.3015873015873014,2.3015873015873014,3,145,"03.00 For women in this community, what is the top priority right now? (select three only, number them 1st, 2nd, 3rd)","03.06 food "]
[77,null,null,"Priority for women: Safe drinking water","w_03_07",63,63,0,0,0.68253968253968256,0.68253968253968256,3,43,"03.00 For women in this community, what is the top priority right now? (select three only, number them 1st, 2nd, 3rd)","03.07 access to clean drinking water"]
[78,null,null,"Priority for women: Water for wash and bath","w_03_08",63,63,0,0,7.9365079365079361E-2,7.9365079365079361E-2,2,5,"03.00 For women in this community, what is the top priority right now? (select three only, number them 1st, 2nd, 3rd)","03.08 access to water for washing/bathing"]
[79,null,null,"Priority for women: Markets","w_03_09",63,63,0,0,7.9365079365079361E-2,7.9365079365079361E-2,2,5,"03.00 For women in this community, what is the top priority right now? (select three only, number them 1st, 2nd, 3rd)","03.09 access to markets"]
[80,null,null,"Priority for women: Short-term financial support","w_03_10",63,63,0,0,0.41269841269841268,0.41269841269841268,3,26,"03.00 For women in this community, what is the top priority right now? (select three only, number them 1st, 2nd, 3rd)","03.10 short term financial support"]
[81,null,null,"Priority for women: Safety","w_03_11",63,63,0,0,3.1746031746031744E-2,3.1746031746031744E-2,1,2,"03.00 For women in this community, what is the top priority right now? (select three only, number them 1st, 2nd, 3rd)","03.11 concerns about safety and security"]
[82,null,null,"Priority for women: Other","w_03_12",63,63,0,0,0.19047619047619047,0.19047619047619047,3,12,"03.00 For women in this community, what is the top priority right now? (select three only, number them 1st, 2nd, 3rd)","03.12 other"]
[83,null,"Binary indicator","Has electricity","w_04_02",63,63,0,0,0.36507936507936506,0.36507936507936506,1,23,null,"04.02Do you have electricity at this site NOW?"]
[84,null,"Binary indicator","Lack of safe water serious (women)","w_06_00",63,63,0,1,0.80952380952380953,0.80952380952380953,1,51,null,"06.00 Is there a serious problem in your community because people do not have enough water that is safe for drinking and cooking?"]
[85,null,"Ordered categorical indicator","Daily water supply for household","w_09_00",63,0,0,null,null,"",0,0,null,"09.00 Approximately how many liters  of drinking water do people here  have each day per family?"]
[86,null,"Binary indicator","Lack of safetoilets (women)","w_10_00",63,63,0,{"$f":"MEDIAN(INDIRECT($E87))","v":1},{"$f":"AVERAGE(INDIRECT($E87))","v":0.88888888888888884},0.88888888888888884,1,56,null,"10.00 Is there a serious problem in your community because people do not have easy and safe access to clean toilets?"]
[87,null,"Before - after pair of categorical","Defecation, females, pre-disaster","w_11_01",63,0,0,null,null,"",0,0,"Sanitation","11.01 Where did women and girls  mostly defecate prior to the flooding/water-logging?"]
[88,null,"Before - after pair of categorical","Defecation, females, post-disaster","w_11_02",63,0,0,null,null,"",0,0,null,"11.02 Where do women and girls mostly defecate NOW?"]
[89,null,"Binary indicator","Difficult women's hygiene","w_12_00",63,63,0,{"$f":"MEDIAN(INDIRECT($E90))","v":1},{"$f":"AVERAGE(INDIRECT($E90))","v":0.95238095238095233},0.95238095238095233,1,60,null,"12.00 Is there a serious problem in your community for women to keep clean ?"]
[90,null,"Priority type data","Shelter priorities for women: Find shelter","w_14_01",63,63,0,0,0.73015873015873012,0.73015873015873012,3,46,"14.00 What are the top 3 shelter priorities for the female group in relation to shelter? (number 1st, 2nd, 3rd )  ","14.01 to acquire shelter / presently without shelter at all"]
[91,null,null,"Shelter priorities for women: Move out of shelter","w_14_02",63,63,0,0,6.3492063492063489E-2,6.3492063492063489E-2,2,4,"14.00 What are the top 3 shelter priorities for the female group in relation to shelter? (number 1st, 2nd, 3rd )  ","14.02 to move out of a communal shelters "]
[92,null,null,"Shelter priorities for women: Return home","w_14_03",63,63,0,0,0.87301587301587302,0.87301587301587302,3,55,"14.00 What are the top 3 shelter priorities for the female group in relation to shelter? (number 1st, 2nd, 3rd )  ","14.03 return home "]
[93,null,null,"Shelter priorities for women: Material for home repair","w_14_04",63,63,0,2,1.9841269841269842,1.9841269841269842,3,125,"14.00 What are the top 3 shelter priorities for the female group in relation to shelter? (number 1st, 2nd, 3rd )  ","14.04 materials for repair of house"]
[94,null,null,"Shelter priorities for women: Manpower for home repair","w_14_05",63,63,0,0,0.26984126984126983,0.26984126984126983,3,17,"14.00 What are the top 3 shelter priorities for the female group in relation to shelter? (number 1st, 2nd, 3rd )  ","14.05 skills/labour for repair "]
[95,null,null,"Shelter priorities for women: Household items","w_14_06",63,63,0,1,0.98412698412698407,0.98412698412698407,3,62,"14.00 What are the top 3 shelter priorities for the female group in relation to shelter? (number 1st, 2nd, 3rd )  ","14.06 basic household items "]
[96,null,null,"Shelter priorities for women: Privacy","w_14_07",63,63,0,0,0.41269841269841268,0.41269841269841268,2,26,"14.00 What are the top 3 shelter priorities for the female group in relation to shelter? (number 1st, 2nd, 3rd )  ","14.07 shelter to give more privacy"]
[97,null,null,"Shelter priorities for women: Protection from weather","w_14_08",{"$f":"COUNTA(INDIRECT($E98))","v":63},{"$f":"COUNT(INDIRECT($E98))","v":63},{"$f":"MIN(INDIRECT($E98))","v":0},0,0.1111111111111111,{"$f":"IF(L98=0,\"\",SUM(INDIRECT($E98)) / 63)","v":0.1111111111111111},{"$f":"MAX(INDIRECT($E98))","v":2},{"$f":"SUM(INDIRECT($E98))","v":7},"14.00 What are the top 3 shelter priorities for the female group in relation to shelter? (number 1st, 2nd, 3rd )  ","14.08 Shelter to give mor protection from weather/elements"]
[98,null,null,"Shelter priorities for women: Other","w_14_09",63,63,0,0,0.1111111111111111,0.1111111111111111,1,7,"14.00 What are the top 3 shelter priorities for the female group in relation to shelter? (number 1st, 2nd, 3rd )  ","14.09other"]
[99,null,"Binary indicator","School attendance high - pre-disaster","w_18_01",63,63,0,1,0.98412698412698407,0.98412698412698407,1,62,null,"18.01 Did most (75% +) of the children from this community attend school before the flooding/water-logging?"]
[100,null,"Binary indicator","School attendance high - post-disaster","w_18_02",63,63,0,0,0.26984126984126983,0.26984126984126983,1,17,null,"18.02 Do most (75% +) of the children from this community attend school NOW? "]
[101,null,"Ordered categorical indicator","Expected stay at shelter wo(men)","w_21_00",63,0,0,null,null,"",0,0,null,"21.00 How long do you think you will stay here before you will go back home? (tick one)"]
[102,null,"Ordered categorical indicator","Time for women to reach health care","w_24_02",63,0,0,null,null,"",0,0,null,"24.02 Access to health for women care now?"]
[103,null,"Priority type data","Health priorities for women: None","w_25_01",63,63,0,null,null,"",0,0,"25.00 What are your main health concerns? (rank the first three, number them 1st, 2nd, 3rd)","25.01 No concern"]
[104,null,null,"Health priorities for women: Diarrhea","w_25_02",63,63,0,{"$f":"MEDIAN(INDIRECT($E105))","v":2},{"$f":"AVERAGE(INDIRECT($E105))","v":1.9523809523809523},1.9523809523809523,3,123,"25.00 What are your main health concerns? (rank the first three, number them 1st, 2nd, 3rd)","25.02 Diarrhea diseases"]
[105,null,null,"Health priorities for women: Skin disease","w_25_03",63,63,0,3,2.3650793650793651,2.3650793650793651,3,149,"25.00 What are your main health concerns? (rank the first three, number them 1st, 2nd, 3rd)","25.03 skin diseases"]
[106,null,null,"Health priorities for women: Snake bite","w_25_04",63,63,0,1,0.95238095238095233,0.95238095238095233,3,60,"25.00 What are your main health concerns? (rank the first three, number them 1st, 2nd, 3rd)","25.04 snake bite"]
[107,null,null,"Health priorities for women: Safe birth","w_25_05",63,63,0,0,0.20634920634920634,0.20634920634920634,3,13,"25.00 What are your main health concerns? (rank the first three, number them 1st, 2nd, 3rd)","25.05 access to safe child birthing support/facilities"]
[108,null,null,"Health priorities for women: Other","w_25_06",63,63,0,0,0.5714285714285714,0.5714285714285714,2,36,"25.00 What are your main health concerns? (rank the first three, number them 1st, 2nd, 3rd)","25.06 other, specify"]
[109,null,"Binary indicator","Diarrhea increased","w_26_00",63,63,0,1,0.52380952380952384,0.52380952380952384,1,33,null,"26.00 Has the incidence of diarrhea increased in the last 7 days?"]
[110,null,"Binary indicator","Women's safety issues","w_28_01",63,63,0,1,0.61904761904761907,0.61904761904761907,1,39,"28.00 Do you know of children being sent away for  any of the following since the floods?","28.01 Safety"]
[111,null,"Binary indicator","Child labor","w_29_00",63,63,0,1,0.53968253968253965,0.53968253968253965,1,34,null,"29.00 Are children here involved in laborious work? "]
[112,null,"Binary indicator","Children missing","w_30_00",63,63,0,0,3.1746031746031744E-2,3.1746031746031744E-2,1,2,null,"30.00 Have you heard of children missing/trafficked from water logged area ?"]
[113,null,"Multiple-choice data","Food issues (women): None","w_37_01",63,63,0,0,1.5873015873015872E-2,1.5873015873015872E-2,1,1,"37.00 Is there a problem in your community in relation to food NOW?","37.01 no problem"]
[114,null,null,"Food issues (women): Not enough","w_37_02",63,63,0,1,0.95238095238095233,0.95238095238095233,1,60,"37.00 Is there a problem in your community in relation to food NOW?","37.02 not enough food"]
[115,null,null,"Food issues (women): Not good enough","w_37_03",63,63,0,1,0.66666666666666663,0.66666666666666663,1,42,"37.00 Is there a problem in your community in relation to food NOW?","37.03 not good enough food"]
[116,null,null,"Food issues (women): No cooking facility","w_37_04",63,63,0,1,0.53968253968253965,0.53968253968253965,1,34,"37.00 Is there a problem in your community in relation to food NOW?","37.04 no cooking facilities"]
[117,null,null,"Food issues (women): No utensils","w_37_05",63,63,0,0,0.23809523809523808,0.23809523809523808,1,15,"37.00 Is there a problem in your community in relation to food NOW?","37.05 no utensils"]
[118,null,null,"Food issues (women): No cooking fuel","w_37_06",63,63,0,1,0.61904761904761907,0.61904761904761907,1,39,"37.00 Is there a problem in your community in relation to food NOW?","37.06 no fuel to cook with"]
[119,null,null,"Food issues (women): Other","w_37_07",63,63,0,0,0,"",0,0,"37.00 Is there a problem in your community in relation to food NOW?","37.07other"]
[120,"Calculated variables","Team's severity ranking","Site assessment by team (numeric)","t_14_00_code",63,63,1,3,2.7936507936507935,{"$f":"IF(L121=0,\"\",SUM(INDIRECT($E121)) / 63)","v":2.7936507936507935},4,176," =VALUE(LEFT(RC[-101],1))"]
[121,null,"Distress indicators","Food highest priority (women)","dw_03_06",63,63,0,1,0.60317460317460314,{"$f":"IF(L122=0,\"\",SUM(INDIRECT($E122)) / 63)","v":0.60317460317460314},1,38," =IF(R[-45]C =3,1,0)"]
[122,null,null,"Livelihoods highest priority (women)","dw_03_01",63,63,0,0,9.5238095238095233E-2,9.5238095238095233E-2,1,6," =IF(R[-51]C =3,1,0)"]
[123,null,null,"Lack of safe water serious","dw_06_00",63,63,0,1,0.80952380952380953,0.80952380952380953,1,51," =R[-39]C"]
[124,null,null,"Diarrhea has increased.","dw_26_00",63,63,0,1,0.52380952380952384,0.52380952380952384,1,33," =R[-15]C"]
[125,null,null,"Lack of safe toilets","dw_10_00",63,63,0,1,0.88888888888888884,0.88888888888888884,1,56," =R[-39]C"]
[126,null,null,"Women face safety issues.","dw_28_01",63,63,0,1,0.61904761904761907,0.61904761904761907,1,39," =R[-16]C"]
[127,null,null,"School attendance is low.","dw_18_02",63,63,0,1,0.73015873015873012,0.73015873015873012,1,46," =1 - R[-27]C"]
[128,null,null,"Significant child labor.","dw_29_00",63,63,0,1,0.53968253968253965,0.53968253968253965,1,34," =R[-17]C"]
[129,null,null,"No electricity","dw_04_02",63,63,0,1,0.63492063492063489,0.63492063492063489,1,40," =1-R[-46]C"]
[130,null,null,"Health care facility more than 60 minutes' travel","dw_24_02",63,63,0,1,0.61904761904761907,0.61904761904761907,1,39," =IF(OR(LEFT(R[-28]C,1) =\"d\",LEFT(R[-28]C,1) =\"e\",  LEFT(R[-28]C,1) =\"f\"),1,0)"]
[131,null,null,"Distress index","dw_distress",63,63,2,6,6.0634920634920633,6.0634920634920633,9,382," =SUM(R[-10]C:R[-1]C)"]

{"sheet":"Analysis01_Data","index":3,"n_rows":67,"n_cols":131,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
["Identifiers",null,null,null,null,null,null,null,"Team observations",null,null,null,null,null,null,null,null,null,null,"Male groups",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Womens groups",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculated variables"]
["Integer","Date","Categorical","Categorical","Categorical","Categorical","Categorical","Categorical","Grouping variable","Binary indicator","Binary indicator","Binary indicator","Binary indicator","Binary indicator","Binary indicator","Binary indicator","Binary indicator","Binary indicator","Team's severity ranking","Priority type data",null,null,null,null,null,null,null,null,null,null,null,"Binary indicator","Before - after pair of categorical","Before - after pair of categorical","Multiple response data",null,null,null,null,null,null,null,null,null,null,"Priority data",null,null,null,null,null,null,null,"Priority data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ordered categorical indicator","Binary indicator","Priority data",null,null,null,null,null,null,null,null,null,null,null,"Binary indicator","Binary indicator","Ordered categorical indicator","Binary indicator","Before - after pair of categorical","Before - after pair of categorical","Binary indicator","Priority type data",null,null,null,null,null,null,null,null,"Binary indicator","Binary indicator","Ordered categorical indicator","Ordered categorical indicator","Priority type data",null,null,null,null,null,"Binary indicator","Binary indicator","Binary indicator","Binary indicator","Multiple-choice data",null,null,null,null,null,null,"Team's severity ranking","Distress indicators"]
["Record number","Assessment date","Team number","District","Upazila","Union","Urban vs. rural","Village","Living arrangement","Stagnant water: Settlement","Stagnant water: Shelter","Stagnant water: Water points","Stagnant water: Other","Garbage","Disease vectors","Latrines at site","Students truant","Open water sources","Site assessment by team","Priority for men: Livelihoods","Priority for men: Livestock feed","Priority for men: Rebuild homes","Priority for men: Children's schooling","Priority for men: Health care","Priority for men: Food","Priority for men: Safe drinking water","Priority for men: Water for wash and bath","Priority for men: Markets","Priority for men: Short-term financial support","Priority for men: Safety","Priority for men: Other","Lack of safe water serious (men)","Defecation, males, pre-disaster","Defecation, males, post-disaster","Shelter issues for men: Shelter not available","Shelter issues for men: Overcrowded","Shelter issues for men: Return home impossible","Shelter issues for men: No repair materials","Shelter issues for men: No manpower for repairs","Shelter issues for men: Land issues for men","Shelter issues for men: Lack of household items","Shelter issues for men: Lack of privacy","Shelter issues for men: Exposed to weather","Shelter issues for men: Other","Shelter priorities for men: Find shelter","Shelter priorities for men: Move out of shelter","Shelter priorities for men: Return home","Shelter priorities for men: Material for home repair","Shelter priorities for men: Manpower for home repair","Shelter priorities for men: Household items","Shelter priorities for men: Privacy","Shelter priorities for men: Protection from weather","Shelter priorities for men: Other","Coping priorities for men: Reduce meal size","Coping priorities for men: East less preferred food","Coping priorities for men: Eat wild foods","Coping priorities for men: Restrict adult male consumption","Coping priorities for men: Restrict adult female consumption","Coping priorities for men: Send children to relatives","Coping priorities for men: Borrow money","Coping priorities for men: Advance labor sale","Coping priorities for men: Buy food on creadit","Coping priorities for men: Sell livestock and poultry","Coping priorities for men: Sell household utensils","Coping priorities for men: Sell land or trees","Coping priorities for men: Outmigration","Coping priorities for men: Send children to work","Coping priorities for men: Other","Expected stay at shelter (men)","Safety of home and property (men)","Priority for women: Livelihoods","Priority for women: Livestock feed","Priority for women: Rebuild homes","Priority for women: Children's schooling","Priority for women: Health care","Priority for women: Food","Priority for women: Safe drinking water","Priority for women: Water for wash and bath","Priority for women: Markets","Priority for women: Short-term financial support","Priority for women: Safety","Priority for women: Other","Has electricity","Lack of safe water serious (women)","Daily water supply for household","Lack of safetoilets (women)","Defecation, females, pre-disaster","Defecation, females, post-disaster","Difficult women's hygiene","Shelter priorities for women: Find shelter","Shelter priorities for women: Move out of shelter","Shelter priorities for women: Return home","Shelter priorities for women: Material for home repair","Shelter priorities for women: Manpower for home repair","Shelter priorities for women: Household items","Shelter priorities for women: Privacy","Shelter priorities for women: Protection from weather","Shelter priorities for women: Other","School attendance high - pre-disaster","School attendance high - post-disaster","Expected stay at shelter wo(men)","Time for women to reach health care","Health priorities for women: None","Health priorities for women: Diarrhea","Health priorities for women: Skin disease","Health priorities for women: Snake bite","Health priorities for women: Safe birth","Health priorities for women: Other","Diarrhea increased","Women's safety issues","Child labor","Children missing","Food issues (women): None","Food issues (women): Not enough","Food issues (women): Not good enough","Food issues (women): No cooking facility","Food issues (women): No utensils","Food issues (women): No cooking fuel","Food issues (women): Other","Site assessment by team (numeric)","Food highest priority (women)","Livelihoods highest priority (women)","Lack of safe water serious","Diarrhea has increased.","Lack of safe toilets","Women face safety issues.","School attendance is low.","Significant child labor.","No electricity","Health care facility more than 60 minutes' travel","Distress index"]
["i_00_01","i_00_03","i_00_04","i_00_05","i_00_06","i_00_07","i_00_08","i_00_09","t_00_10","t_02_01","t_02_02","t_02_03","t_02_04","t_03_00","t_04_00","t_05_00","t_09_00","t_10_07","t_14_00","m_03_01","m_03_02","m_03_03","m_03_04","m_03_05","m_03_06","m_03_07","m_03_08","m_03_09","m_03_10","m_03_11","m_03_12","m_04_00","m_06_01","m_06_02","m_07_01","m_07_02","m_07_03","m_07_04","m_07_05","m_07_06","m_07_07","m_07_08","m_07_09","m_07_10","m_08_01","m_08_02","m_08_03","m_08_04","m_08_05","m_08_06","m_08_07","m_08_08","m_08_09","m_16_01","m_16_02","m_16_03","m_16_04","m_16_05","m_16_06","m_16_07","m_16_08","m_16_09","m_16_10","m_16_11","m_16_12","m_16_13","m_16_14","m_16_15","m_17_00","m_21_00","w_03_01","w_03_02","w_03_03","w_03_04","w_03_05","w_03_06","w_03_07","w_03_08","w_03_09","w_03_10","w_03_11","w_03_12","w_04_02","w_06_00","w_09_00","w_10_00","w_11_01","w_11_02","w_12_00","w_14_01","w_14_02","w_14_03","w_14_04","w_14_05","w_14_06","w_14_07","w_14_08","w_14_09","w_18_01","w_18_02","w_21_00","w_24_02","w_25_01","w_25_02","w_25_03","w_25_04","w_25_05","w_25_06","w_26_00","w_28_01","w_29_00","w_30_00","w_37_01","w_37_02","w_37_03","w_37_04","w_37_05","w_37_06","w_37_07","t_14_00_code","dw_03_06","dw_03_01","dw_06_00","dw_26_00","dw_10_00","dw_28_01","dw_18_02","dw_29_00","dw_04_02","dw_24_02","dw_distress"]
[1,"2011-09-11",10,"Jessore","Abhynagar","Paira","Rural","Ghoradari","4-Damaged or water-logged",1,0,0,0,0,1,1,0,1,"2-Vulnerable",2,1,0,0,0,0,0,0,0,3,0,0,1,"4-Sanitary latrines (household)","1-Open area",1,1,0,0,0,0,0,0,0,0,1,0,0,2,0,3,0,0,0,1,0,0,0,0,0,0,0,5,4,0,0,3,2,0,"0 - <1",null,3,2,0,0,1,0,0,0,0,0,0,0,1,1,"10 +",1,"4-Sanitary latrines (household)","1-Open area",1,3,0,0,0,0,2,1,0,0,1,1,"","c-30-60 minutes",0,3,2,0,0,1,1,0,1,1,0,1,1,0,0,0,0,{"$f":"VALUE(LEFT($S5,1))","v":2},{"$f":"IF(BX5=3,1,0)","v":0},{"$f":"IF(BS5=3,1,0)","v":1},{"$f":"CF5","v":1},{"$f":"DE5","v":1},{"$f":"CH5","v":1},{"$f":"DF5","v":0},{"$f":"1 - CV5","v":0},{"$f":"DG5","v":1},{"$f":"1-CE5","v":0},{"$f":"IF(OR(LEFT(CX5,1)=\"d\",LEFT(CX5,1)=\"e\",  LEFT(CX5,1)=\"f\"),1,0)","v":0},{"$f":"SUM(DQ5:DZ5)","v":5}]
[2,"2011-09-09",10,"Jessore","Abhynagar","Siddiqpasa","Rural","Joyrabad","3-Marooned",1,0,1,0,1,1,1,0,0,"2-Vulnerable",3,0,1,0,0,0,2,0,0,0,0,0,1,"4-Sanitary latrines (household)","1-Open area",1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,0,0,0,0,0,4,0,0,1,5,0,3,0,0,"0 - <1",1,3,0,0,0,0,0,0,0,0,2,1,0,0,1,"10 +",1,"4-Sanitary latrines (household)","1-Open area",1,3,0,0,1,0,2,0,0,0,1,1,"","e-> 2 hours",0,0,3,2,0,1,0,1,0,0,0,1,1,0,0,0,0,{"$f":"VALUE(LEFT($S6,1))","v":2},{"$f":"IF(BX6=3,1,0)","v":0},{"$f":"IF(BS6=3,1,0)","v":1},{"$f":"CF6","v":1},{"$f":"DE6","v":0},{"$f":"CH6","v":1},{"$f":"DF6","v":1},{"$f":"1 - CV6","v":0},{"$f":"DG6","v":0},{"$f":"1-CE6","v":1},{"$f":"IF(OR(LEFT(CX6,1)=\"d\",LEFT(CX6,1)=\"e\",  LEFT(CX6,1)=\"f\"),1,0)","v":1},{"$f":"SUM(DQ6:DZ6)","v":6}]
[3,"2011-09-09",10,"Jessore","Abhynagar","Siddiqpasa","Rural","Nolamara","4-Damaged or water-logged",1,0,1,0,1,1,1,0,0,"2-Vulnerable",3,0,0,0,0,0,1,0,0,0,2,0,1,"4-Sanitary latrines (household)","1-Open area",1,0,1,0,0,0,0,0,0,0,3,0,0,2,0,1,0,0,0,3,0,0,0,0,0,5,0,0,2,1,0,4,0,0,"0 - <1",1,3,0,0,0,0,2,0,0,0,1,0,0,0,0,"10 +",1,"4-Sanitary latrines (household)","2-Hanging or open latrine",1,1,0,0,2,0,3,0,0,0,1,1,"","e-> 2 hours",0,0,3,1,2,0,0,0,1,0,0,1,1,0,0,1,0,2,0,1,0,0,1,0,0,1,1,1,5]
[4,"2011-09-10",10,"Jessore","Abhynagar","Suvoyara","Rural","IsamotiPurbapasa","3-Marooned",1,0,1,0,0,1,1,0,1,"3-Seriously vulnerable",1,0,0,0,0,3,0,0,0,2,0,0,1,"3-Sanitary latrines (communal)","3-Sanitary latrines (communal)",1,1,1,0,0,0,0,0,0,0,3,0,0,1,0,2,0,0,0,0,0,0,2,3,0,0,0,4,0,0,0,5,1,0,"0 - <1",1,0,0,0,0,1,2,0,0,0,3,0,0,1,0,"10 +",1,"4-Sanitary latrines (household)","1-Open area",0,3,0,0,1,0,2,0,0,0,1,1,"","e-> 2 hours",0,0,3,0,2,1,0,0,0,0,0,1,1,0,0,0,0,3,0,0,0,0,1,0,0,0,0,1,2]
[5,"2011-09-10",10,"Jessore","Abhynagar","Suvoyara","Rural","Hindia","4-Damaged or water-logged",1,0,1,0,1,1,1,0,1,"2-Vulnerable",3,0,0,0,0,1,0,0,0,2,0,0,0,"4-Sanitary latrines (household)","3-Sanitary latrines (communal)",1,1,0,1,0,0,0,0,0,0,3,1,0,2,0,0,0,0,0,5,4,1,0,0,0,3,0,2,0,0,0,0,0,0,"0 - <1",null,0,0,0,0,1,3,0,0,0,2,0,0,1,1,"10 +",1,"2-Hanging or open latrine","1-Open area",1,2,0,0,2,0,3,0,0,0,1,0,"","c-30-60 minutes",0,1,3,2,0,0,0,0,1,0,0,1,1,0,0,0,0,2,1,0,1,0,1,0,1,1,0,0,5]
[6,"2011-09-10",11,"Jessore","Jhikargacha","Bakra","Rural","Dikdana","2-Roadside / embankments",1,0,1,1,1,1,1,1,0,"3-Seriously vulnerable",2,0,0,0,1,3,0,0,0,0,0,0,1,"4-Sanitary latrines (household)","5-Other",1,0,1,0,0,0,0,1,0,1,1,0,0,3,0,0,2,0,0,2,0,0,0,0,0,4,3,5,0,0,0,0,1,0,"2 - 3",1,1,0,2,0,0,3,0,0,0,0,0,0,1,1,"10 +",1,"4-Sanitary latrines (household)","4-Sanitary latrines (household)",1,1,0,0,2,0,0,1,0,0,1,0,"2 - 3","c-30-60 minutes",0,2,3,0,0,1,0,0,0,0,0,1,0,0,0,0,0,3,1,0,1,0,1,0,1,0,0,0,4]
[7,"2011-09-10",11,"Jessore","Jhikargacha","Bakra","Rural","Dikdana","3-Marooned",1,0,1,0,1,1,1,1,0,"1-Relatively normal",2,0,0,0,1,3,0,0,0,0,0,0,1,"4-Sanitary latrines (household)","5-Other",1,0,1,1,0,0,0,0,0,1,0,0,0,3,0,0,2,0,1,0,0,0,0,0,0,5,1,4,3,0,0,0,2,0,"0 - <1",null,1,0,0,0,0,3,2,0,0,1,0,0,0,1,"10 +",1,"4-Sanitary latrines (household)","1-Open area",1,3,0,0,2,0,0,1,0,0,1,0,"","e-> 2 hours",0,2,3,0,0,1,0,0,1,0,0,1,0,0,0,0,0,1,1,0,1,0,1,0,1,1,1,1,7]
[8,"2011-09-10",11,"Jessore","Jhikargacha","Nibeshkhola","Rural","Balla (Beside River)","5-Home undamaged",1,0,1,1,1,1,1,1,0,"3-Seriously vulnerable",3,0,0,0,1,0,0,0,0,0,0,2,1,"4-Sanitary latrines (household)","2-Hanging or open latrine",1,0,1,0,0,0,0,0,0,1,0,0,0,2,0,0,0,0,0,0,0,0,0,0,0,4,0,5,3,0,2,0,0,1,"0 - <1",null,0,0,2,0,0,3,0,0,0,0,0,1,0,1,"10 +",1,"4-Sanitary latrines (household)","1-Open area",1,0,0,0,3,1,0,0,2,0,1,0,"","e-> 2 hours",0,1,3,0,0,2,0,0,0,0,0,1,0,0,0,0,0,3,1,0,1,0,1,0,1,0,1,1,6]
[9,"2011-09-11",11,"Jessore","Jhikargacha","Ponisara","Rural","Purandapur (Purba Para)","5-Home undamaged",1,0,1,0,1,1,1,0,0,"3-Seriously vulnerable",2,0,0,0,1,3,0,0,0,0,0,0,1,"4-Sanitary latrines (household)","5-Other",1,0,0,1,0,0,0,1,0,0,0,0,0,3,0,1,2,0,0,0,0,0,0,0,0,5,1,2,4,0,3,0,0,0,"0 - <1",null,0,1,0,0,0,2,3,0,0,0,0,0,0,1,"10 +",0,"4-Sanitary latrines (household)","2-Hanging or open latrine",1,0,0,0,3,2,0,0,0,1,1,0,"","d-1 - 2 hours",0,0,3,2,0,1,0,0,0,0,1,0,0,0,0,0,0,3,0,0,1,0,0,0,1,0,1,1,4]
[10,"2011-09-09",11,"Jessore","Jhikargacha","Pourashara","Urban","Parbazar","1-Collective centers",0,1,1,0,1,1,1,1,0,"3-Seriously vulnerable",1,0,0,0,3,2,0,0,0,0,0,0,1,"4-Sanitary latrines (household)","3-Sanitary latrines (communal)",0,0,1,1,0,0,0,1,1,0,0,0,3,2,0,0,1,0,0,2,0,0,0,1,0,4,0,5,3,0,0,0,0,0,"1 - 2",1,1,0,3,0,0,2,0,0,0,0,0,0,0,1,"10 +",1,"4-Sanitary latrines (household)","4-Sanitary latrines (household)",1,2,0,1,3,0,0,0,0,0,1,0,"1 - 2","c-30-60 minutes",0,2,3,0,0,1,0,1,1,0,0,1,0,0,0,0,0,3,0,0,1,0,1,1,1,1,1,0,6]
[11,"2011-09-09",11,"Jessore","Jhikargacha","Pourashara","Urban","Saddampara","3-Marooned",1,0,1,0,1,1,1,1,0,"3-Seriously vulnerable",3,0,0,0,0,1,2,0,0,0,0,0,1,"4-Sanitary latrines (household)","2-Hanging or open latrine",0,0,0,1,0,0,1,0,1,1,0,0,0,3,0,0,1,2,0,0,1,0,0,3,0,4,0,5,0,0,0,0,2,0,"0 - <1",null,3,0,0,0,1,2,0,0,0,0,0,0,1,1,"10 +",1,"4-Sanitary latrines (household)","1-Open area",1,0,0,0,3,0,2,1,0,0,1,0,"","c-30-60 minutes",0,1,3,0,0,2,0,0,1,0,0,1,0,0,0,1,0,3,0,1,1,0,1,0,1,1,0,0,5]
[12,"2011-09-09",11,"Jessore","Jhikargacha","Pourashara","Rural","Shanti Bagar","4-Damaged or water-logged",1,1,1,0,1,1,1,1,0,"3-Seriously vulnerable",3,0,0,0,0,2,0,0,0,1,0,0,1,"4-Sanitary latrines (household)","2-Hanging or open latrine",0,0,1,1,0,0,0,0,0,1,0,0,0,3,0,0,1,0,0,3,2,0,0,1,0,1,0,4,0,0,0,0,0,0,"0 - <1",null,1,0,2,0,0,3,0,0,0,0,0,0,0,1,"10 +",1,"4-Sanitary latrines (household)","1-Open area",1,0,0,0,3,1,2,0,0,0,1,0,"","d-1 - 2 hours",0,2,3,0,0,1,0,0,1,0,0,1,0,0,0,1,0,3,1,0,1,0,1,0,1,1,1,1,7]
[13,"2011-09-09",9,"Jessore","Keshabpur","Biddyanandakati","Rural","Nehanpur","1-Collective centers",1,1,1,0,1,1,1,0,0,"3-Seriously vulnerable",2,0,0,0,0,3,1,0,0,0,0,0,1,"3-Sanitary latrines (communal)","2-Hanging or open latrine",1,1,1,0,0,0,0,0,0,0,2,0,0,3,0,0,1,0,0,0,0,0,0,0,0,5,1,4,0,3,2,0,0,0,"3 +",1,0,0,2,0,0,3,1,0,0,0,0,0,1,1,"10 +",1,"2-Hanging or open latrine","1-Open area",1,1,0,0,3,0,2,0,0,0,1,0,"3 +","e-> 2 hours",0,1,3,2,0,0,1,1,0,0,0,1,0,1,1,1,0,3,1,0,1,1,1,1,1,0,0,1,7]
[14,"2011-09-10",9,"Jessore","Keshabpur","Keshabpur Sadar","Rural","Basdanga","5-Home undamaged",1,1,0,0,1,1,1,1,0,"2-Vulnerable",3,1,0,0,0,2,0,0,0,0,0,0,0,"3-Sanitary latrines (communal)","2-Hanging or open latrine",1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5,0,0,0,0,2,1,0,4,3,0,0,0,0,"0 - <1",null,2,0,0,0,0,3,1,0,0,0,0,0,1,1,"10 +",1,"2-Hanging or open latrine","1-Open area",1,0,0,0,3,0,2,1,0,0,1,1,"","d-1 - 2 hours",0,2,3,1,0,0,1,0,0,0,0,1,0,1,0,1,0,2,1,0,1,1,1,0,0,0,0,1,5]
[15,"2011-09-11",9,"Jessore","Keshabpur","Mojidpur","Rural","Protappur","5-Home undamaged",1,1,0,0,0,1,1,1,0,"2-Vulnerable",2,0,0,0,0,1,3,0,0,0,0,0,0,"3-Sanitary latrines (communal)","2-Hanging or open latrine",0,0,0,0,0,0,0,0,0,0,0,0,0,3,1,2,0,0,0,5,4,0,0,0,0,3,0,0,2,1,0,0,0,0,"0 - <1",null,1,0,0,0,0,3,0,0,2,0,0,0,0,1,"10 +",1,"4-Sanitary latrines (household)","1-Open area",1,3,0,0,2,0,1,0,0,0,1,1,"","d-1 - 2 hours",0,3,2,0,1,0,1,0,1,0,0,1,1,1,0,0,0,2,1,0,1,1,1,0,0,1,1,1,7]
[16,"2011-09-11",9,"Jessore","Keshabpur","Pazia","Rural","Bagdanga","5-Home undamaged",1,0,0,0,1,1,1,1,0,"2-Vulnerable",2,1,0,0,0,3,0,0,0,0,0,0,0,"4-Sanitary latrines (household)","3-Sanitary latrines (communal)",1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5,1,0,0,0,0,5,4,0,3,2,0,0,0,0,"0 - <1",null,2,0,0,0,0,3,1,0,0,0,0,0,1,1,"10 +",1,"4-Sanitary latrines (household)","1-Open area",1,0,0,0,2,1,3,0,0,0,1,1,"","d-1 - 2 hours",0,2,3,0,0,1,0,0,0,0,0,1,1,1,0,0,0,2,1,0,1,0,1,0,0,0,0,1,4]
[17,"2011-09-08",9,"Jessore","Keshabpur","Sagardari","Rural","Sagardari","2-Roadside / embankments",1,0,1,0,1,1,1,1,0,"3-Seriously vulnerable",2,0,0,0,1,3,0,0,0,0,0,0,1,"4-Sanitary latrines (household)","1-Open area",0,1,1,0,0,0,0,1,0,0,2,0,0,3,0,1,0,0,0,2,1,0,0,0,0,0,0,5,4,0,3,0,0,0,"3 +",1,0,0,0,0,1,3,0,0,0,0,0,2,0,1,"10 +",1,"2-Hanging or open latrine","1-Open area",1,1,0,0,3,0,2,0,0,0,1,0,"3 +","d-1 - 2 hours",0,3,2,1,0,0,1,1,0,0,0,1,0,1,1,1,0,3,1,0,1,1,1,1,1,0,1,1,8]
[18,"2011-09-10",9,"Jessore","Keshabpur","Shuflakati","Rural","Poschim Sarutia","3-Marooned",1,0,1,0,1,1,1,1,0,"3-Seriously vulnerable",0,2,1,0,0,3,0,0,0,0,0,0,0,"3-Sanitary latrines (communal)","2-Hanging or open latrine",1,0,1,0,0,0,0,0,0,0,3,0,0,2,0,1,0,0,0,0,2,0,0,0,0,5,0,4,0,1,3,0,0,0,"0 - <1",1,0,0,0,0,1,3,2,0,0,0,0,0,1,1,"10 +",1,"4-Sanitary latrines (household)","1-Open area",1,1,0,0,3,0,2,0,0,0,1,0,"3 +","e-> 2 hours",0,2,3,1,0,0,0,0,0,0,0,1,1,1,1,1,0,3,1,0,1,0,1,0,1,0,0,1,5]
[19,"2011-09-10",9,"Jessore","Keshabpur","Shuflakati","Rural","Krishnagar","4-Damaged or water-logged",1,0,1,1,1,1,1,1,0,"3-Seriously vulnerable",1,0,0,0,0,3,2,0,0,0,0,0,0,"3-Sanitary latrines (communal)","5-Other",0,0,1,1,0,0,0,0,0,0,1,0,0,3,0,2,0,0,0,2,0,1,0,0,0,0,0,5,4,0,3,0,0,0,"3 +",null,0,0,0,0,0,3,1,0,2,0,0,0,1,1,"10 +",1,"2-Hanging or open latrine","1-Open area",1,0,0,0,3,0,2,0,1,0,1,0,"3 +","e-> 2 hours",0,0,3,2,1,0,0,1,0,0,0,1,0,1,0,1,0,3,1,0,1,0,1,1,1,0,0,1,6]
[20,"2011-09-10",8,"Jessore","Monirampur","Durbadunga","Rural","Ashanigar","3-Marooned",1,0,0,0,1,1,0,0,0,"3-Seriously vulnerable",1,0,0,0,0,2,0,0,0,3,0,0,1,"2-Hanging or open latrine","1-Open area",0,0,1,1,0,0,1,0,0,0,3,0,0,2,0,1,0,0,0,0,0,0,1,2,0,0,3,0,5,4,0,0,0,0,"3 +",1,0,0,0,0,0,2,1,0,0,3,0,0,1,1,"10 +",1,"2-Hanging or open latrine","1-Open area",1,2,0,0,1,0,3,0,0,0,1,1,"3 +","e-> 2 hours",0,2,3,0,0,1,1,1,1,0,0,1,0,1,0,1,0,3,0,0,1,1,1,1,0,1,0,1,6]
[21,"2011-09-09",8,"Jessore","Monirampur","Jhapa","Rural","2no Ward","4-Damaged or water-logged",1,0,1,0,1,1,1,0,0,"3-Seriously vulnerable",0,0,0,0,1,3,0,0,0,0,2,0,1,"1-Open area","1-Open area",0,0,1,1,0,0,1,0,0,0,3,0,0,2,0,1,0,0,0,0,0,2,4,3,0,5,1,0,0,0,0,0,0,0,"2 - 3",1,0,0,0,0,0,0,0,0,0,0,0,0,1,1,"10 +",1,"2-Hanging or open latrine","1-Open area",1,2,0,3,1,0,0,0,0,0,1,0,"3 +","e-> 2 hours",0,3,2,1,0,0,1,1,1,0,0,1,0,1,0,1,0,3,0,0,1,1,1,1,1,1,0,1,7]
[22,"2011-09-09",8,"Jessore","Monirampur","Jhapa","Rural","Jhapa","4-Damaged or water-logged",1,0,1,0,1,1,0,0,0,"3-Seriously vulnerable",1,0,2,0,0,3,0,0,0,0,0,0,1,"1-Open area","1-Open area",1,0,0,1,0,0,1,0,0,0,2,0,0,3,0,1,0,0,0,0,0,0,2,3,0,0,1,0,0,5,0,4,0,0,"3 +",1,1,0,0,0,0,2,0,0,0,3,0,0,0,1,"10 +",0,"4-Sanitary latrines (household)","2-Hanging or open latrine",1,2,0,3,0,0,0,1,0,0,1,1,"3 +","d-1 - 2 hours",0,3,2,0,0,1,1,0,1,0,0,0,0,1,0,0,0,3,0,0,1,1,0,0,0,1,1,1,5]
[23,"2011-09-10",8,"Jessore","Monirampur","Moshimnagar","Rural","Horotpur","2-Roadside / embankments",1,0,1,0,1,1,1,0,0,"2-Vulnerable",2,0,1,0,0,3,0,0,0,0,0,0,1,"1-Open area","1-Open area",1,0,1,0,0,0,0,0,0,0,1,0,3,2,0,0,0,0,0,0,0,0,0,0,0,5,0,0,2,0,1,4,3,0,"2 - 3",1,2,0,1,0,0,3,0,0,0,0,0,0,0,1,"10 +",1,"4-Sanitary latrines (household)","1-Open area",1,1,0,3,2,0,0,0,0,0,1,0,"2 - 3","c-30-60 minutes",0,3,2,1,0,0,1,0,1,0,0,1,1,0,0,0,0,2,1,0,1,1,1,0,1,1,1,0,7]
[24,"2011-09-09",8,"Jessore","Monirampur","Moshimnagar","Rural","Varatpur","3-Marooned",1,0,1,0,1,1,1,0,0,"2-Vulnerable",0,0,0,0,0,0,0,0,0,0,0,0,1,"3-Sanitary latrines (communal)","2-Hanging or open latrine",1,0,1,0,0,0,0,0,0,0,1,0,2,3,0,0,0,0,2,5,0,3,4,2,0,0,0,0,0,0,0,1,0,0,"3 +",1,1,0,0,0,0,3,1,0,0,2,0,0,0,1,"05 - 10",1,"2-Hanging or open latrine","1-Open area",1,0,0,2,3,0,1,0,0,0,1,0,"3 +","e-> 2 hours",0,3,2,1,3,0,1,1,1,0,0,1,0,1,0,1,0,2,1,0,1,1,1,1,1,1,1,1,9]
[25,"2011-09-09",7,"Kulna","Paikgacha","Horidhal","Rural","Horidaskathi","2-Roadside / embankments",0,0,0,0,0,1,1,0,0,"3-Seriously vulnerable",1,0,2,0,0,3,0,0,0,0,0,0,0,"3-Sanitary latrines (communal)","1-Open area",1,0,1,0,0,0,0,0,0,0,0,0,3,1,0,2,0,0,0,5,1,0,0,0,4,0,0,0,2,0,3,0,0,0,"3 +",1,0,1,0,0,3,0,0,0,0,0,0,2,0,1,"05 - 10",1,"2-Hanging or open latrine","1-Open area",1,0,0,3,2,0,1,0,0,0,1,0,"2 - 3","f-No access",0,2,3,0,0,1,1,1,0,0,0,1,1,1,0,1,0,3,0,0,1,1,1,1,1,0,1,1,7]
[26,"2011-09-10",7,"Kulna","Paikgacha","Horidhal","Rural","Noakathi","2-Roadside / embankments",1,0,0,0,1,1,0,0,1,"3-Seriously vulnerable",3,0,0,0,0,2,1,0,0,0,0,0,1,"3-Sanitary latrines (communal)","1-Open area",1,0,1,1,1,1,0,0,0,0,0,0,0,2,1,3,0,0,0,5,4,3,0,0,2,0,1,0,0,0,0,0,0,0,"0 - <1",null,1,0,2,0,0,3,0,0,0,0,0,0,1,1,"05 - 10",1,"4-Sanitary latrines (household)","2-Hanging or open latrine",1,0,0,0,3,0,2,1,0,0,1,0,"","f-No access",0,3,2,1,0,0,1,1,1,0,0,1,0,1,0,1,0,3,1,0,1,1,1,1,1,1,0,1,8]
[27,"2011-09-10",7,"Kulna","Paikgacha","Horikhali","Rural","ChandKhali 9No Katabunia","2-Roadside / embankments",1,0,0,0,1,1,1,1,0,"3-Seriously vulnerable",2,0,0,0,0,3,1,0,0,0,0,0,1,"2-Hanging or open latrine","1-Open area",1,1,1,0,0,0,0,0,0,0,0,0,0,3,1,2,0,0,0,5,4,0,0,0,0,0,0,3,0,0,0,2,1,0,"0 - <1",null,0,0,0,0,0,3,1,0,0,2,0,0,0,1,"05 - 10",1,"2-Hanging or open latrine","2-Hanging or open latrine",1,0,0,0,3,0,2,1,0,0,0,0,"","f-No access",0,1,2,3,0,0,1,1,1,1,0,1,1,0,0,0,0,3,1,0,1,1,1,1,1,1,1,1,9]
[28,"2011-09-09",7,"Kulna","Paikgacha","Kopilmoni","Rural","Kasimnagar","3-Marooned",1,0,1,0,1,1,1,0,0,"2-Vulnerable",1,0,2,0,0,3,0,0,0,0,0,0,1,"3-Sanitary latrines (communal)","1-Open area",1,1,1,0,0,0,0,0,0,0,2,0,0,3,0,0,0,1,0,5,0,0,4,0,0,0,0,3,2,0,0,1,0,0,"3 +",null,2,0,0,0,0,3,0,0,0,1,0,0,1,0,"10 +",1,"2-Hanging or open latrine","2-Hanging or open latrine",1,0,0,0,3,1,2,0,0,0,1,0,"","a-Health facility nearby",0,3,2,1,0,0,1,1,1,0,0,1,1,1,0,1,0,2,1,0,0,1,1,1,1,1,0,0,6]
[29,"2011-09-10",7,"Kulna","Paikgacha","Kopilmoni","Rural","Kazimusa","5-Home undamaged",0,0,0,0,1,1,1,0,0,"1-Relatively normal",2,0,0,0,0,3,1,0,0,0,0,0,1,"3-Sanitary latrines (communal)","4-Sanitary latrines (household)",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5,4,3,0,0,0,2,0,1,0,0,0,0,0,0,"0 - <1",null,0,0,2,0,1,3,0,0,0,0,0,0,1,1,"05 - 10",1,"4-Sanitary latrines (household)","5-Other",1,0,0,0,3,0,2,1,0,0,1,1,"","b-< 30 minutes",0,3,2,0,1,0,1,0,1,0,0,1,1,1,0,1,0,1,1,0,1,1,1,0,0,1,0,0,5]
[30,"2011-09-10",6,"Shatkira","Assasuni","Budhata","Rural","Behula","5-Home undamaged",1,0,0,1,1,1,1,0,0,"2-Vulnerable",3,2,0,0,1,3,0,0,0,0,0,0,0,"4-Sanitary latrines (household)","2-Hanging or open latrine",0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"0 - <1",null,1,0,0,0,0,0,0,2,0,0,0,3,1,1,"10 +",1,"4-Sanitary latrines (household)","1-Open area",1,0,0,0,0,0,0,0,0,0,1,1,"","c-30-60 minutes",0,3,2,0,0,1,0,0,1,0,0,1,1,1,0,1,0,2,0,0,1,0,1,0,0,1,0,0,3]
[31,"2011-09-09",6,"Shatkira","Assasuni","Dargapur","Rural","Sonai & Tokipur","4-Damaged or water-logged",1,0,0,0,1,0,1,0,0,"3-Seriously vulnerable",0,0,0,0,0,3,2,0,0,0,0,1,1,"4-Sanitary latrines (household)","2-Hanging or open latrine",1,0,0,0,0,0,0,0,0,0,3,0,0,0,0,0,0,0,0,2,0,0,0,0,0,5,0,4,0,0,0,0,1,3,"0 - <1",1,0,0,0,0,0,2,3,0,1,0,0,0,0,1,"10 +",1,"4-Sanitary latrines (household)","2-Hanging or open latrine",1,0,0,0,0,0,0,0,0,0,1,0,"","e-> 2 hours",0,2,3,0,0,1,1,1,0,0,0,1,1,1,0,0,0,3,0,0,1,1,1,1,1,0,1,1,7]
[32,"2011-09-10",6,"Shatkira","Assasuni","Kadakhati","Rural","Kadakati","1-Collective centers",0,0,0,0,1,1,1,1,0,"4-Extremely vulnerable",3,0,1,0,0,2,0,0,0,0,0,0,1,"4-Sanitary latrines (household)","3-Sanitary latrines (communal)",1,0,1,0,0,0,0,0,0,0,0,0,3,2,0,0,0,0,1,5,4,0,0,0,1,3,0,0,2,0,0,0,0,0,"2 - 3",1,0,0,3,0,0,1,2,0,0,0,0,0,0,0,"10 +",1,"4-Sanitary latrines (household)","3-Sanitary latrines (communal)",1,0,0,2,3,0,1,0,0,0,1,0,"2 - 3","d-1 - 2 hours",0,3,2,1,0,0,0,1,1,0,0,1,1,0,1,1,0,4,0,0,0,0,1,1,1,1,1,1,6]
[33,"2011-09-10",6,"Shatkira","Assasuni","Kadakhati","Rural","Kadakati","3-Marooned",1,0,0,0,1,1,1,1,0,"4-Extremely vulnerable",1,0,3,0,0,2,0,0,0,0,0,0,1,"4-Sanitary latrines (household)","2-Hanging or open latrine",1,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5,4,0,0,0,0,0,0,3,2,0,0,0,1,0,"0 - <1",null,0,0,3,0,0,1,2,0,0,0,0,0,0,1,"10 +",1,"2-Hanging or open latrine","2-Hanging or open latrine",1,0,0,3,2,0,1,0,0,0,1,0,"1 - 2","d-1 - 2 hours",0,1,2,3,0,0,0,1,1,0,0,1,1,1,1,1,0,4,0,0,1,0,1,1,1,1,1,1,7]
[34,"2011-09-10",6,"Shatkira","Assasuni","Kulia","Rural","Kochua","4-Damaged or water-logged",1,0,1,0,1,1,1,1,1,"2-Vulnerable",1,0,3,0,0,2,0,0,0,0,0,0,1,"4-Sanitary latrines (household)","1-Open area",1,0,0,0,0,0,0,0,0,0,1,0,3,2,0,0,0,0,0,3,2,0,0,0,0,5,0,0,4,0,0,0,0,0,"1 - 2",1,0,0,3,0,0,2,1,0,0,0,0,0,0,1,"10 +",1,"4-Sanitary latrines (household)","5-Other",1,2,0,3,1,0,0,0,0,0,1,0,"1 - 2","d-1 - 2 hours",0,3,1,2,0,0,1,1,1,0,0,1,1,1,0,1,0,2,0,0,1,1,1,1,1,1,1,1,8]
[35,"2011-09-10",6,"Shatkira","Assasuni","Shobnali","Rural","Katakhali","2-Roadside / embankments",1,1,0,0,1,1,0,1,0,"2-Vulnerable",1,0,3,0,0,2,0,0,0,0,0,0,0,"4-Sanitary latrines (household)","1-Open area",1,0,1,0,0,0,0,0,0,0,3,0,2,0,0,0,0,0,0,5,4,0,0,0,0,0,0,0,3,0,0,0,0,0,"2 - 3",1,0,0,3,0,0,2,1,0,0,0,0,0,0,1,"10 +",1,"4-Sanitary latrines (household)","1-Open area",1,0,0,3,2,0,1,0,0,0,1,0,"1 - 2","c-30-60 minutes",0,3,2,1,0,0,0,1,1,0,0,1,1,1,1,1,0,2,0,0,1,0,1,1,1,1,1,0,6]
[36,"2011-09-10",6,"Shatkira","Assasuni","Shobnali","Rural","Bodortola","3-Marooned",1,1,1,1,1,1,1,0,0,"4-Extremely vulnerable",0,0,0,0,0,3,0,0,0,0,0,0,0,"4-Sanitary latrines (household)","1-Open area",1,0,1,0,0,0,1,0,0,0,3,0,0,2,0,3,0,0,0,5,4,0,0,0,0,0,0,2,3,0,0,0,0,0,"0 - <1",null,0,0,3,0,0,2,1,0,0,0,0,0,0,1,"10 +",1,"4-Sanitary latrines (household)","2-Hanging or open latrine",1,0,0,3,2,0,0,0,0,1,1,0,"1 - 2","e-> 2 hours",0,1,0,3,0,2,1,1,1,0,0,1,1,1,1,1,0,4,0,0,1,1,1,1,1,1,1,1,8]
[37,"2011-09-10",5,"Shatkira","Debhata","Kulia","Rural","Gobrakhali","1-Collective centers",1,1,1,0,0,0,1,1,0,"4-Extremely vulnerable",1,0,2,0,0,3,0,0,0,0,0,0,null,"4-Sanitary latrines (household)","3-Sanitary latrines (communal)",0,0,1,1,1,0,0,1,1,0,0,0,2,3,0,0,0,1,0,3,0,0,0,0,0,5,4,0,0,0,0,2,1,0,"3 +",0,0,0,2,0,1,3,0,0,0,0,0,0,0,0,"10 +",1,"4-Sanitary latrines (household)","3-Sanitary latrines (communal)",1,0,0,3,2,0,3,0,0,0,1,0,"1 - 2","d-1 - 2 hours",0,3,2,0,0,1,0,1,0,0,0,1,1,1,1,1,0,4,1,0,0,0,1,1,1,0,1,1,6]
[38,"2011-09-11",5,"Shatkira","Debhata","Nowapara","Rural","Kaminiboshu","3-Marooned",0,0,1,0,1,1,1,1,0,"1-Relatively normal",1,0,2,0,0,3,0,0,0,0,0,0,1,"4-Sanitary latrines (household)","4-Sanitary latrines (household)",0,0,1,1,0,0,0,0,0,0,0,0,0,3,0,2,0,1,0,5,4,0,0,0,0,3,0,2,0,0,0,1,0,0,"0 - <1",null,0,0,2,0,0,3,0,0,0,1,0,0,0,0,"10 +",0,"4-Sanitary latrines (household)","4-Sanitary latrines (household)",1,0,0,0,3,2,0,0,0,1,1,1,"","c-30-60 minutes",0,2,3,1,0,0,0,1,0,0,0,1,1,1,0,0,0,1,1,0,0,0,0,1,0,0,1,0,3]
[39,"2011-09-11",5,"Shatkira","Debhata","Nowapara","Rural","Chachura hati","5-Home undamaged",1,0,0,0,0,1,1,1,0,"1-Relatively normal",0,2,0,0,1,3,0,0,0,0,0,0,0,"4-Sanitary latrines (household)","4-Sanitary latrines (household)",1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"0 - <1",null,0,1,2,0,0,3,0,0,0,0,0,0,0,0,"10 +",0,"4-Sanitary latrines (household)","4-Sanitary latrines (household)",0,0,0,0,3,2,0,0,0,1,1,0,"","b-< 30 minutes",0,2,3,0,0,1,0,1,0,0,0,1,1,0,0,0,0,1,1,0,0,0,0,1,1,0,1,0,4]
[40,"2011-09-11",5,"Shatkira","Debhata","Parulia","Rural","Polgoda","2-Roadside / embankments",1,0,0,0,0,1,0,0,0,"3-Seriously vulnerable",1,0,2,0,0,3,0,0,0,0,0,0,0,"4-Sanitary latrines (household)","2-Hanging or open latrine",0,0,1,1,0,0,1,0,1,0,0,0,3,2,0,0,0,0,0,4,5,0,0,0,1,0,0,3,0,0,0,2,0,0,"3 +",0,0,0,2,0,0,3,0,0,0,0,0,1,0,0,"10 +",1,"4-Sanitary latrines (household)","2-Hanging or open latrine",1,0,0,3,2,0,1,0,0,0,1,1,"1 - 2","b-< 30 minutes",0,3,2,0,0,1,0,1,0,0,0,1,1,1,1,0,0,3,1,0,0,0,1,1,0,0,1,0,4]
[41,"2011-09-09",5,"Shatkira","Debhata","Parulia","Rural","Soto Shatha","4-Damaged or water-logged",1,1,1,0,0,1,0,1,0,"4-Extremely vulnerable",0,0,2,0,0,3,0,0,0,1,0,0,null,"4-Sanitary latrines (household)","2-Hanging or open latrine",0,0,1,1,0,1,1,0,1,0,1,0,0,3,0,0,0,2,0,2,0,0,0,0,0,5,0,1,4,0,0,3,0,0,"3 +",0,0,0,2,0,3,0,1,0,0,0,0,0,0,1,"10 +",1,"4-Sanitary latrines (household)","2-Hanging or open latrine",1,0,0,0,3,0,0,2,1,0,1,0,"","e-> 2 hours",0,1,3,2,0,0,0,1,0,0,0,1,1,1,1,1,0,4,0,0,1,0,1,1,1,0,1,1,6]
[42,"2011-09-09",4,"Shatkira","Kalaroa","Deara","Rural","Deara Dakhil Madrasha","1-Collective centers",0,1,0,0,1,1,0,0,0,"3-Seriously vulnerable",2,0,3,0,1,0,0,0,0,0,0,0,0,"5-Other","3-Sanitary latrines (communal)",0,0,0,0,0,0,0,0,0,1,3,0,2,1,0,0,0,0,0,0,0,0,0,0,0,0,0,5,3,4,2,0,0,0,"3 +",1,0,1,2,0,0,3,0,0,0,0,0,0,1,1,"10 +",1,"4-Sanitary latrines (household)","1-Open area",1,1,2,3,0,0,0,0,0,0,1,0,"3 +","d-1 - 2 hours",0,3,2,1,0,0,1,1,0,0,0,1,1,0,0,1,0,3,1,0,1,1,1,1,1,0,0,1,7]
[43,"2011-09-09",4,"Shatkira","Kalaroa","Deara","Rural","Deara Matpara","2-Roadside / embankments",0,0,1,0,1,1,0,0,0,"2-Vulnerable",0,0,0,0,1,2,0,0,0,0,0,3,0,"4-Sanitary latrines (household)","1-Open area",1,0,0,0,0,0,0,0,0,0,3,0,0,2,0,0,0,0,0,3,2,0,0,0,0,0,0,5,4,0,0,0,0,0,"3 +",1,0,0,2,0,0,3,0,0,0,1,0,0,0,0,"10 +",1,"4-Sanitary latrines (household)","2-Hanging or open latrine",1,3,0,2,1,0,0,0,0,0,1,1,"3 +","e-> 2 hours",0,3,2,1,0,0,1,0,1,0,0,1,1,1,1,1,0,2,1,0,0,1,1,0,0,1,1,1,6]
[44,"2011-09-10",4,"Shatkira","Kalaroa","Joynagar","Rural","Dokkhin Khetropara","3-Marooned",1,0,0,0,1,1,1,0,0,"2-Vulnerable",0,0,0,0,3,1,0,0,0,0,0,2,1,"4-Sanitary latrines (household)","1-Open area",0,0,1,0,0,0,0,0,0,0,0,0,0,3,0,0,0,0,0,0,0,0,0,0,0,0,0,5,4,0,0,0,0,0,"1 - 2",1,0,1,0,0,0,3,2,0,0,0,0,0,0,1,"10 +",1,"4-Sanitary latrines (household)","1-Open area",1,0,0,0,3,1,2,0,0,0,1,1,"","c-30-60 minutes",0,3,2,0,0,1,1,0,1,0,0,1,1,0,0,1,0,2,1,0,1,1,1,0,0,1,1,0,6]
[45,"2011-09-10",4,"Shatkira","Kalaroa","Joynagar","Rural","Manik Nagar","5-Home undamaged",0,1,0,0,1,0,1,0,0,"1-Relatively normal",3,0,0,0,0,0,0,0,0,0,0,2,0,"4-Sanitary latrines (household)","4-Sanitary latrines (household)",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4,3,0,0,5,0,0,"3 +",null,3,2,0,0,0,0,0,0,0,1,0,0,1,0,"10 +",0,"4-Sanitary latrines (household)","4-Sanitary latrines (household)",1,3,0,0,2,0,0,0,0,1,1,1,"","d-1 - 2 hours",0,0,3,2,0,1,0,0,1,0,0,1,1,0,0,0,0,1,0,1,0,0,0,0,0,1,0,1,3]
[46,"2011-09-09",4,"Shatkira","Kalaroa","Pouroshava","Urban","Gopinathpur Poschim para","4-Damaged or water-logged",0,0,1,0,1,1,1,0,0,"1-Relatively normal",0,0,0,0,2,3,1,0,0,0,0,0,1,"4-Sanitary latrines (household)","1-Open area",0,0,0,0,0,0,0,0,0,0,3,0,0,0,2,1,0,0,0,0,0,0,0,0,0,0,0,5,4,0,0,0,0,0,"3 +",1,0,0,2,0,0,3,1,0,0,0,0,0,1,1,"10 +",1,"4-Sanitary latrines (household)","2-Hanging or open latrine",1,0,0,0,3,1,2,0,0,0,1,1,"","d-1 - 2 hours",0,2,3,1,0,0,0,1,1,0,0,1,1,0,0,1,0,1,1,0,1,0,1,1,0,1,0,1,6]
[47,"2011-09-09",3,"Shatkira","Shaktira_Sadar","Bolli","Rural","Rajjabari bad, Mukudpur vill","2-Roadside / embankments",1,1,1,0,1,1,1,0,1,"4-Extremely vulnerable",1,0,2,0,0,3,0,0,0,0,0,0,0,"4-Sanitary latrines (household)","2-Hanging or open latrine",0,0,1,0,0,0,1,0,0,0,0,0,3,2,0,1,0,0,0,5,4,0,0,0,0,2,0,1,3,0,0,0,0,0,"3 +",1,0,2,0,0,0,3,0,1,0,0,0,0,0,1,"10 +",1,"4-Sanitary latrines (household)","1-Open area",1,3,0,2,0,0,1,0,0,0,1,0,"2 - 3","d-1 - 2 hours",0,3,2,0,0,1,1,1,0,0,0,1,1,1,0,1,0,4,1,0,1,1,1,1,1,0,1,1,8]
[48,"2011-09-10",3,"Shatkira","Shaktira_Sadar","Brahamorajpur","Rural","Machkhola","4-Damaged or water-logged",1,1,1,0,1,1,1,1,1,"4-Extremely vulnerable",1,0,3,0,0,2,0,0,0,0,0,0,1,"4-Sanitary latrines (household)","2-Hanging or open latrine",1,1,1,0,0,0,1,1,0,0,0,1,0,3,0,2,0,0,0,5,1,4,0,0,0,0,0,2,3,0,0,0,0,0,"2 - 3",null,0,0,1,0,0,3,2,0,0,0,0,0,0,1,"10 +",1,"2-Hanging or open latrine","2-Hanging or open latrine",1,0,0,0,3,0,2,1,0,0,1,0,"2 - 3","b-< 30 minutes",0,0,3,0,1,2,0,0,0,0,0,1,1,1,1,1,0,4,1,0,1,0,1,0,1,0,1,0,5]
[49,"2011-09-10",3,"Shatkira","Shaktira_Sadar","Fringi","Rural","Gobordari","5-Home undamaged",0,0,0,0,1,1,1,0,0,"4-Extremely vulnerable",3,0,0,0,0,1,0,0,0,2,0,0,0,"4-Sanitary latrines (household)","3-Sanitary latrines (communal)",0,0,1,0,0,0,1,0,0,0,0,0,0,3,0,2,0,0,0,5,4,4,0,0,0,3,0,1,2,0,0,0,0,0,"2 - 3",null,0,0,0,1,0,3,2,0,0,0,0,0,0,1,"05 - 10",1,"2-Hanging or open latrine","2-Hanging or open latrine",1,0,0,0,3,0,0,2,1,0,1,0,"","a-Health facility nearby",0,3,2,0,0,1,1,1,0,0,0,1,1,0,0,1,0,4,1,0,1,1,1,1,1,0,1,0,7]
[50,"2011-09-09",3,"Shatkira","Shaktira_Sadar","Labsa","Rural","Soninathpur, Binerputa","3-Marooned",1,1,0,1,1,1,1,0,1,"4-Extremely vulnerable",0,0,1,0,0,2,0,0,0,0,3,0,0,"4-Sanitary latrines (household)","2-Hanging or open latrine",1,0,0,0,0,0,0,0,0,0,3,1,0,2,0,0,0,0,0,3,5,0,0,0,0,1,0,4,2,0,0,0,0,0,"3 +",null,0,0,2,0,0,1,0,0,0,0,0,3,0,1,"05 - 10",1,"4-Sanitary latrines (household)","2-Hanging or open latrine",1,0,0,0,3,0,1,2,0,0,1,0,"","c-30-60 minutes",0,2,3,1,0,0,1,1,0,0,0,1,1,1,0,1,0,4,0,0,1,1,1,1,1,0,1,0,6]
[51,"2011-09-09",3,"Shatkira","Shaktira_Sadar","Municipality","Rural","6 No Ward","1-Collective centers",1,1,1,0,1,1,1,0,1,"4-Extremely vulnerable",0,0,2,1,0,3,0,0,0,0,0,0,1,"4-Sanitary latrines (household)","2-Hanging or open latrine",1,0,1,0,0,0,0,0,0,0,3,0,2,0,0,0,0,0,0,5,4,2,0,0,0,0,0,0,3,0,0,0,1,0,"3 +",1,0,0,0,0,2,3,0,0,0,0,1,0,0,1,"10 +",1,"4-Sanitary latrines (household)","2-Hanging or open latrine",1,0,0,3,0,0,2,1,0,0,1,0,"1 - 2","e-> 2 hours",0,0,3,2,1,0,0,0,0,0,0,1,1,1,1,1,0,4,1,0,1,0,1,0,1,0,1,1,6]
[52,"2011-09-10",3,"Shatkira","Shaktira_Sadar","Municipality","Urban","6 No Ward","2-Roadside / embankments",0,0,0,0,1,1,0,0,1,"4-Extremely vulnerable",1,0,3,0,0,2,0,0,0,0,0,0,1,"4-Sanitary latrines (household)","3-Sanitary latrines (communal)",0,0,1,0,0,0,1,0,0,0,0,0,3,2,0,1,0,0,0,5,4,0,0,0,0,0,0,0,3,0,0,0,0,0,"2 - 3",1,1,0,2,0,0,3,0,0,0,0,0,0,0,0,"10 +",1,"4-Sanitary latrines (household)","1-Open area",1,0,0,3,2,0,1,0,0,0,1,0,"2 - 3","b-< 30 minutes",0,1,3,0,0,2,0,1,1,0,0,0,0,0,0,1,0,4,1,0,0,0,1,1,1,1,1,0,6]
[53,"2011-09-09",1,"Shatkira","Tala","Islam Kati","Rural","Narayanpur/ Bhanipur","2-Roadside / embankments",1,1,1,0,1,1,1,1,0,"4-Extremely vulnerable",0,0,2,0,0,3,0,0,0,1,0,0,0,"4-Sanitary latrines (household)","3-Sanitary latrines (communal)",0,0,1,0,0,0,0,0,1,0,1,0,3,2,0,0,0,0,0,5,0,0,0,1,2,4,0,3,0,0,0,0,0,0,"3 +",1,0,0,0,0,1,3,2,0,0,0,0,0,0,1,"10 +",1,"4-Sanitary latrines (household)","3-Sanitary latrines (communal)",1,0,2,0,3,0,0,1,0,0,1,0,"3 +","c-30-60 minutes",0,2,3,0,1,0,1,1,1,0,0,1,1,1,1,1,0,4,1,0,1,1,1,1,1,1,1,0,8]
[54,"2011-09-11",2,"Shatkira","Tala","Khalilinagar","Rural","Nagarghata","2-Roadside / embankments",1,1,1,0,1,1,1,0,0,"4-Extremely vulnerable",0,0,2,0,0,3,0,0,0,1,0,0,1,"3-Sanitary latrines (communal)","2-Hanging or open latrine",1,0,1,1,0,0,1,1,1,0,3,0,2,1,0,0,0,0,0,5,0,0,0,0,0,4,3,1,0,0,2,1,0,0,"3 +",1,0,0,3,0,0,2,1,0,0,0,0,0,0,1,"10 +",1,"4-Sanitary latrines (household)","3-Sanitary latrines (communal)",1,0,0,3,2,0,0,1,0,0,1,0,"3 +","d-1 - 2 hours",0,3,0,1,0,2,0,1,1,0,0,1,1,0,0,1,0,4,0,0,1,0,1,1,1,1,1,1,7]
[55,"2011-09-10",2,"Shatkira","Tala","Kholishakhali","Rural","Dolua College","1-Collective centers",1,1,0,0,1,1,1,1,0,"4-Extremely vulnerable",1,0,3,0,0,2,0,0,0,0,0,0,1,"3-Sanitary latrines (communal)","3-Sanitary latrines (communal)",0,1,1,1,1,0,1,1,0,0,2,0,3,1,0,0,0,0,0,3,0,0,0,0,0,5,0,0,2,0,4,0,1,0,"1 - 2",1,0,0,3,0,0,1,0,2,0,0,0,0,1,1,"10 +",1,"4-Sanitary latrines (household)","3-Sanitary latrines (communal)",1,3,0,0,1,2,0,0,0,0,1,0,"3 +","b-< 30 minutes",0,3,2,1,0,0,1,1,0,0,0,1,0,0,0,0,0,4,0,0,1,1,1,1,1,0,0,0,5]
[56,"2011-09-11",2,"Shatkira","Tala","Kumira","Rural","Raripara","3-Marooned",1,0,1,0,1,1,1,0,0,"2-Vulnerable",0,0,0,0,0,2,0,0,0,1,0,3,1,"3-Sanitary latrines (communal)","2-Hanging or open latrine",0,0,0,1,0,0,0,0,0,0,0,1,0,3,0,0,0,0,2,2,0,0,0,0,0,5,4,0,0,0,0,1,0,0,"3 +",null,3,0,0,0,2,1,0,0,0,0,0,0,1,1,"10 +",1,"4-Sanitary latrines (household)","3-Sanitary latrines (communal)",1,0,0,0,3,0,1,2,0,0,1,0,"2 - 3","e-> 2 hours",0,3,0,2,0,1,0,1,0,0,0,1,1,0,0,0,0,2,0,1,1,0,1,1,1,0,0,1,6]
[57,"2011-09-10",2,"Shatkira","Tala","Magura","Rural","Parmadra","4-Damaged or water-logged",1,0,1,0,1,1,1,0,0,"4-Extremely vulnerable",2,0,3,0,0,1,0,0,0,0,0,0,1,"3-Sanitary latrines (communal)","2-Hanging or open latrine",0,0,1,1,0,0,0,0,0,0,0,0,0,3,1,0,0,0,2,4,0,0,0,0,0,2,0,0,5,0,1,3,0,0,"3 +",0,0,0,0,0,2,3,1,0,0,0,0,0,0,1,"05 - 10",1,"4-Sanitary latrines (household)","3-Sanitary latrines (communal)",1,0,0,0,0,0,0,0,0,0,1,0,"3 +","e-> 2 hours",0,1,2,3,0,0,1,1,0,0,0,1,0,0,0,0,0,4,1,0,1,1,1,1,1,0,1,1,8]
[58,"2011-09-10",2,"Shatkira","Tala","Nagarghata","Rural","Nagarghata","5-Home undamaged",0,0,0,0,0,0,1,1,0,"2-Vulnerable",2,1,0,0,0,3,0,0,0,0,0,0,0,"4-Sanitary latrines (household)","3-Sanitary latrines (communal)",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"0 - <1",null,2,0,0,1,0,3,0,0,0,0,0,0,1,1,"05 - 10",0,"4-Sanitary latrines (household)","5-Other",1,0,0,0,0,0,0,0,0,0,1,0,"3 +","e-> 2 hours",0,3,0,2,0,1,1,1,0,0,0,1,0,0,0,0,0,2,1,0,1,1,0,1,1,0,0,1,6]
[59,"2011-09-10",1,"Shatkira","Tala","Sarulia","Rural","Kasipur","1-Collective centers",1,1,1,0,1,1,1,1,0,"3-Seriously vulnerable",0,0,0,0,1,3,2,0,0,0,0,0,0,"4-Sanitary latrines (household)","1-Open area",0,1,0,1,0,0,0,1,0,0,0,0,3,2,0,1,0,0,0,5,0,4,0,3,0,0,0,2,1,0,0,0,0,0,"3 +",1,0,0,1,0,0,3,2,0,0,0,0,0,0,1,"10 +",1,"4-Sanitary latrines (household)","3-Sanitary latrines (communal)",1,0,0,3,2,0,0,1,0,0,1,0,"3 +","a-Health facility nearby",0,2,3,1,0,0,1,1,1,0,0,1,1,1,0,1,0,3,1,0,1,1,1,1,1,1,1,0,8]
[60,"2011-09-11",1,"Shatkira","Tala","Sarulia","Rural","Boro Kasipur","3-Marooned",1,1,1,0,1,1,1,1,0,"3-Seriously vulnerable",2,0,1,0,0,3,0,0,0,0,0,0,0,"4-Sanitary latrines (household)","1-Open area",1,0,1,0,0,0,0,1,0,0,0,0,3,2,0,1,0,0,0,2,0,0,0,5,4,0,0,0,3,0,0,1,0,0,"3 +",0,1,0,0,0,0,3,2,0,0,0,0,0,0,1,"10 +",1,"4-Sanitary latrines (household)","5-Other",1,0,0,0,0,3,0,0,2,1,1,0,"3 +","c-30-60 minutes",0,1,2,3,0,0,1,1,1,0,0,1,1,0,0,1,0,3,1,0,1,1,1,1,1,1,1,0,8]
[61,"2011-09-10",1,"Shatkira","Tala","Tala Sadar","Rural","Monipur/ Shahpur","2-Roadside / embankments",1,1,1,0,1,1,1,1,0,"4-Extremely vulnerable",2,0,1,0,0,3,0,0,0,0,0,0,1,"4-Sanitary latrines (household)","5-Other",0,1,1,1,0,0,1,0,0,0,0,0,3,2,0,0,0,1,0,5,0,0,0,1,2,4,0,3,2,1,0,0,0,0,"3 +",1,0,0,2,0,0,3,1,0,0,0,0,0,0,1,"10 +",1,"4-Sanitary latrines (household)","3-Sanitary latrines (communal)",1,0,0,1,3,0,0,2,0,0,1,0,"3 +","e-> 2 hours",0,2,3,0,0,1,1,1,1,0,0,1,1,1,0,1,0,4,1,0,1,1,1,1,1,1,1,1,9]
[62,"2011-09-10",1,"Shatkira","Tala","Tala Sadar","Rural","Kismotghona","5-Home undamaged",1,1,0,0,1,1,1,1,0,"2-Vulnerable",2,0,0,0,0,3,0,0,0,1,0,0,1,"4-Sanitary latrines (household)","4-Sanitary latrines (household)",0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,5,3,0,0,0,0,4,0,0,1,0,0,2,0,0,"3 +",null,0,0,0,1,0,2,0,0,0,3,0,0,1,0,"10 +",0,"4-Sanitary latrines (household)","4-Sanitary latrines (household)",0,0,0,0,0,0,0,0,0,0,1,0,"","c-30-60 minutes",0,1,2,3,0,0,1,0,1,0,0,1,0,0,0,0,0,2,0,0,0,1,0,0,1,1,0,0,3]
[63,"2011-09-09",1,"Shatkira","Tala","Tentulia","Rural","Hatbas, Modonpur, Lakkhanpur","2-Roadside / embankments",1,1,1,0,1,1,1,1,0,"4-Extremely vulnerable",0,0,2,0,0,3,0,0,0,1,0,0,1,"4-Sanitary latrines (household)","3-Sanitary latrines (communal)",0,1,1,1,0,0,0,0,0,0,0,0,3,2,0,1,0,0,0,5,4,0,3,0,2,0,0,1,0,0,0,0,0,0,"3 +",1,0,0,1,0,0,3,2,0,0,0,0,0,0,1,"10 +",1,"4-Sanitary latrines (household)","3-Sanitary latrines (communal)",1,0,0,0,3,0,0,2,0,1,1,0,"3 +","c-30-60 minutes",0,2,3,1,0,0,1,1,0,0,0,1,1,1,1,1,0,4,1,0,1,1,1,1,1,0,1,0,7]

{"sheet":"Analysis01_PivotGrouping","index":4,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Teams","(All)"]
["District","(All)"]
["Upazila","(All)"]
["Union","(All)"]
["Rural vs. Urban","(All)"]
[]
["Sites assessed","Severity"]
["Living arrangement","1-Relatively normal","2-Vulnerable","3-Seriously vulnerable","4-Extremely vulnerable","Grand Total"]
["1-Collective centers",0,0,4,4,8]
["2-Roadside / embankments",0,3,6,6,15]
["3-Marooned",2,5,5,3,15]
["4-Damaged or water-logged",1,4,5,3,13]
["5-Home undamaged",3,6,2,1,12]
["Grand Total",6,18,22,17,63]

{"sheet":"Analysis01_PivotBinaries","index":5,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[null,null,"Teams","(All)"]
[null,null,"District","(All)"]
[null,null,"Upazila","(All)"]
[null,null,"Union","(All)"]
[null,null,"Rural vs. Urban","(All)"]
[null,null,"Living arrangement","(All)"]
[null,null,"Severity","(All)"]
[]
[null,null,"Values","Total"]
["Stagnant water: Settlement","t_02_01","Average of t_02_01",0.80952380952380953]
["Stagnant water: Shelter","t_02_02","Average of t_02_02",0.36507936507936506]
["Stagnant water: Water points","t_02_03","Average of t_02_03",0.60317460317460314]
["Stagnant water: Other","t_02_04","Average of t_02_04",9.5238095238095233E-2]
["Garbage","t_03_00","Average of t_03_00",0.8571428571428571]
["Disease vectors","t_04_00","Average of t_04_00",0.93650793650793651]
["Latrines at site","t_05_00","Average of t_05_00",0.8571428571428571]
["Students truant","t_09_00","Average of t_09_00",0.47619047619047616]
["Open water sources","t_10_07","Average of t_10_07",0.15873015873015872]
["Lack of safe water serious (men)","m_04_00","Average of m_04_00",0.63934426229508201]
["Safety of home and property (men)","m_21_00","Average of m_21_00",0.86111111111111116]
["Has electricity","w_04_02","Average of w_04_02",0.36507936507936506]
["Lack of safe water serious (women)","w_06_00","Average of w_06_00",0.80952380952380953]
["Lack of safetoilets (women)","w_10_00","Average of w_10_00",0.88888888888888884]
["Difficult women's hygiene","w_12_00","Average of w_12_00",0.95238095238095233]
["School attendance high - pre-disaster","w_18_01","Average of w_18_01",0.98412698412698407]
["School attendance high - post-disaster","w_18_02","Average of w_18_02",0.26984126984126983]
["Diarrhea increased","w_26_00","Average of w_26_00",0.52380952380952384]
["Women's safety issues","w_28_01","Average of w_28_01",0.61904761904761907]
["Child labor","w_29_00","Average of w_29_00",0.53968253968253965]
["Children missing","w_30_00","Average of w_30_00",3.1746031746031744E-2]

{"sheet":"Analysis01_Priorities","index":6,"n_rows":72,"n_cols":20,"rows_kept":72,"cut":false,"hidden":false,"merged":[]}
["Variables",null,"Simple vote count",null,null,"Distribution of priority votes",null,null,null,null,null,null,null,"Borda count"]
[null,null,"Count of priority mentions","As a fraction of all voting participants",null,5,4,3,2,1,0,"NonMissing",null,"Sumproduct (Borda count)","Mean (mean Borda mean)","Percentage non-empty votes",null,"some priority"]
["Group interviews with men"]
["Priority for men: Livelihoods","m_03_01",{"$f":"COUNTIF(INDIRECT($B4),\">0\")","v":46},{"$f":"COUNTIF(INDIRECT($B4),\">0\") / COUNT(INDIRECT($B4))","v":0.73015873015873012},null,null,null,{"$f":"COUNTIF(INDIRECT($B4),H$2)","v":12},17,17,17,{"$f":"COUNT(INDIRECT($B4))","v":63},null,{"$f":"SUMPRODUCT($F$2:$K$2,$F4:$K4)","v":87},{"$f":"N4/L4","v":1.3809523809523809},{"$f":"SUM(H4:J15) / (63 * 3)","v":0.97354497354497349},null,{"$f":"SUM(H4:J4)/L4","v":0.73015873015873012},null,"Comparison between simple vote counts and Borda counts, for livelihood priorities:"]
["Priority for men: Livestock feed","m_03_02",{"$f":"COUNTIF(INDIRECT($B5),\">0\")","v":7},{"$f":"COUNTIF(INDIRECT($B5),\">0\") / COUNT(INDIRECT($B5))","v":0.1111111111111111},null,null,null,0,3,4,56,{"$f":"COUNT(INDIRECT($B5))","v":63},null,{"$f":"SUMPRODUCT($F$2:$K$2,$F5:$K5)","v":10},{"$f":"N5/L5","v":0.15873015873015872},null,null,0.1111111111111111]
["Priority for men: Rebuild homes","m_03_03",27,0.42857142857142855,null,null,null,8,12,7,36,63,null,55,0.87301587301587302,null,null,0.42857142857142855]
["Priority for men: Children's schooling","m_03_04",1,1.5873015873015872E-2,null,null,null,0,0,1,62,63,null,1,1.5873015873015872E-2,null,null,1.5873015873015872E-2]
["Priority for men: Health care","m_03_05",14,0.22222222222222221,null,null,null,2,1,11,49,63,null,19,0.30158730158730157,null,null,0.22222222222222221]
["Priority for men: Food","m_03_06",56,0.88888888888888884,null,null,null,35,15,6,7,63,null,141,2.2380952380952381,null,null,0.88888888888888884]
["Priority for men: Safe drinking water","m_03_07",12,0.19047619047619047,null,null,null,1,5,6,51,63,null,19,0.30158730158730157,null,null,0.19047619047619047]
["Priority for men: Water for wash and bath","m_03_08",0,0,null,null,null,0,0,0,63,63,null,0,0,null,null,0]
["Priority for men: Markets","m_03_09",0,0,null,null,null,0,0,0,63,63,null,0,0,null,null,0]
["Priority for men: Short-term financial support","m_03_10",12,0.19047619047619047,null,null,null,2,3,7,51,63,null,19,0.30158730158730157,null,null,0.19047619047619047]
["Priority for men: Safety","m_03_11",3,4.7619047619047616E-2,null,null,null,1,2,0,60,63,null,7,0.1111111111111111,null,null,4.7619047619047616E-2]
["Priority for men: Other","m_03_12",6,9.5238095238095233E-2,null,null,null,2,3,1,57,63,null,13,0.20634920634920634,null,null,9.5238095238095233E-2]
[]
["Shelter priorities for men: Find shelter","m_08_01",28,0.44444444444444442,null,null,null,{"$f":"COUNTIF(INDIRECT($B17),H$2)","v":15},5,8,35,63,null,63,{"$f":"N17/L17","v":1},{"$f":"SUM(H17:J25) / (63 * 3)","v":0.78306878306878303},null,{"$f":"SUM(H17:J17)/L17","v":0.44444444444444442}]
["Shelter priorities for men: Move out of shelter","m_08_02",4,6.3492063492063489E-2,null,null,null,0,0,4,59,63,null,4,6.3492063492063489E-2,null,null,6.3492063492063489E-2]
["Shelter priorities for men: Return home","m_08_03",20,0.31746031746031744,null,null,null,14,6,0,43,63,null,54,0.8571428571428571,null,null,0.31746031746031744]
["Shelter priorities for men: Material for home repair","m_08_04",49,0.77777777777777779,null,null,null,21,23,5,14,63,null,114,1.8095238095238095,null,null,0.77777777777777779]
["Shelter priorities for men: Manpower for home repair","m_08_05",5,7.9365079365079361E-2,null,null,null,0,1,4,58,63,null,6,9.5238095238095233E-2,null,null,7.9365079365079361E-2]
["Shelter priorities for men: Household items","m_08_06",24,0.38095238095238093,null,null,null,3,8,13,39,63,null,38,0.60317460317460314,null,null,0.38095238095238093]
["Shelter priorities for men: Privacy","m_08_07",7,0.1111111111111111,null,null,null,0,3,4,56,63,null,10,0.15873015873015872,null,null,0.1111111111111111]
["Shelter priorities for men: Protection from weather","m_08_08",6,9.5238095238095233E-2,null,null,null,0,2,4,57,63,null,8,0.12698412698412698,null,null,9.5238095238095233E-2]
["Shelter priorities for men: Other","m_08_09",5,7.9365079365079361E-2,null,null,null,0,3,2,58,63,null,8,0.12698412698412698,null,null,7.9365079365079361E-2]
[]
["Coping priorities for men: Reduce meal size","m_16_01",44,0.69841269841269837,null,{"$f":"COUNTIF(INDIRECT($B27),F$2)","v":25},2,7,9,1,19,63,null,173,2.746031746031746,{"$f":"SUM(F27:J41) / (63 * 5)","v":0.91428571428571426},null,{"$f":"SUM(F27:J27)/L27","v":0.69841269841269837}]
["Coping priorities for men: East less preferred food","m_16_02",28,0.44444444444444442,null,3,15,1,4,5,35,63,null,91,1.4444444444444444,null,null,0.44444444444444442]
["Coping priorities for men: Eat wild foods","m_16_03",10,0.15873015873015872,null,0,3,3,2,2,53,63,null,27,0.42857142857142855,null,null,0.15873015873015872]
["Coping priorities for men: Restrict adult male consumption","m_16_04",7,0.1111111111111111,null,0,3,1,2,1,56,63,null,20,0.31746031746031744,null,null,0.1111111111111111]
["Coping priorities for men: Restrict adult female consumption","m_16_05",12,0.19047619047619047,null,1,0,5,2,4,51,63,null,28,0.44444444444444442,null,null,0.19047619047619047]
["Coping priorities for men: Send children to relatives","m_16_06",8,0.12698412698412698,null,0,2,0,4,2,55,63,null,18,0.2857142857142857,null,null,0.12698412698412698]
["Coping priorities for men: Borrow money","m_16_07",34,0.53968253968253965,null,14,9,5,4,2,29,63,null,131,2.0793650793650795,null,null,0.53968253968253965]
["Coping priorities for men: Advance labor sale","m_16_08",13,0.20634920634920634,null,0,3,3,0,7,50,63,null,28,0.44444444444444442,null,null,0.20634920634920634]
["Coping priorities for men: Buy food on creadit","m_16_09",37,0.58730158730158732,null,11,8,6,6,6,26,63,null,123,1.9523809523809523,null,null,0.58730158730158732]
["Coping priorities for men: Sell livestock and poultry","m_16_10",39,0.61904761904761907,null,2,10,13,11,3,24,63,null,114,1.8095238095238095,null,null,0.61904761904761907]
["Coping priorities for men: Sell household utensils","m_16_11",11,0.17460317460317459,null,2,2,2,1,4,52,63,null,30,0.47619047619047616,null,null,0.17460317460317459]
["Coping priorities for men: Sell land or trees","m_16_12",12,0.19047619047619047,null,0,1,5,4,2,51,63,null,29,0.46031746031746029,null,null,0.19047619047619047]
["Coping priorities for men: Outmigration","m_16_13",19,0.30158730158730157,null,2,3,4,4,6,44,63,null,48,0.76190476190476186,null,null,0.30158730158730157]
["Coping priorities for men: Send children to work","m_16_14",12,0.19047619047619047,null,0,0,1,3,8,51,63,null,17,0.26984126984126983,null,null,0.19047619047619047]
["Coping priorities for men: Other","m_16_15",2,3.1746031746031744E-2,null,0,0,1,0,1,61,63,null,4,6.3492063492063489E-2,null,null,3.1746031746031744E-2]
[]
["Group interviews with women"]
["Priority for women: Livelihoods","w_03_01",22,0.34920634920634919,null,null,null,{"$f":"COUNTIF(INDIRECT($B44),H$2)","v":6},5,11,41,63,null,39,0.61904761904761907,{"$f":"SUM(H44:J55) / (63 * 3)","v":0.99470899470899465}]
["Priority for women: Livestock feed","w_03_02",8,0.12698412698412698,null,null,null,0,3,5,55,63,null,11,0.17460317460317459]
["Priority for women: Rebuild homes","w_03_03",29,0.46031746031746029,null,null,null,8,17,4,34,63,null,62,0.98412698412698407]
["Priority for women: Children's schooling","w_03_04",3,4.7619047619047616E-2,null,null,null,0,0,3,60,63,null,3,4.7619047619047616E-2]
["Priority for women: Health care","w_03_05",14,0.22222222222222221,null,null,null,2,3,9,49,63,null,21,0.33333333333333331]
["Priority for women: Food","w_03_06",56,0.88888888888888884,null,null,null,38,13,5,7,63,null,145,2.3015873015873014]
["Priority for women: Safe drinking water","w_03_07",28,0.44444444444444442,null,null,null,2,11,15,35,63,null,43,0.68253968253968256]
["Priority for women: Water for wash and bath","w_03_08",3,4.7619047619047616E-2,null,null,null,0,2,1,60,63,null,5,7.9365079365079361E-2]
["Priority for women: Markets","w_03_09",3,4.7619047619047616E-2,null,null,null,0,2,1,60,63,null,5,7.9365079365079361E-2]
["Priority for women: Short-term financial support","w_03_10",14,0.22222222222222221,null,null,null,4,4,6,49,63,null,26,0.41269841269841268]
["Priority for women: Safety","w_03_11",2,3.1746031746031744E-2,null,null,null,0,0,2,61,63,null,2,3.1746031746031744E-2]
["Priority for women: Other","w_03_12",6,9.5238095238095233E-2,null,null,null,2,2,2,57,63,null,12,0.19047619047619047]
[]
["Shelter priorities for women: Find shelter","w_14_01",22,0.34920634920634919,null,null,null,{"$f":"COUNTIF(INDIRECT($B57),H$2)","v":9},6,7,41,63,null,46,0.73015873015873012,{"$f":"SUM(H57:J65) / (63 * 3)","v":0.92063492063492058}]
["Shelter priorities for women: Move out of shelter","w_14_02",2,3.1746031746031744E-2,null,null,null,0,2,0,61,63,null,4,6.3492063492063489E-2]
["Shelter priorities for women: Return home","w_14_03",21,0.33333333333333331,null,null,null,15,4,2,42,63,null,55,0.87301587301587302]
["Shelter priorities for women: Material for home repair","w_14_04",52,0.82539682539682535,null,null,null,28,17,7,11,63,null,125,1.9841269841269842]
["Shelter priorities for women: Manpower for home repair","w_14_05",11,0.17460317460317459,null,null,null,1,4,6,52,63,null,17,0.26984126984126983]
["Shelter priorities for women: Household items","w_14_06",34,0.53968253968253965,null,null,null,5,18,11,29,63,null,62,0.98412698412698407]
["Shelter priorities for women: Privacy","w_14_07",20,0.31746031746031744,null,null,null,0,6,14,43,63,null,26,0.41269841269841268]
["Shelter priorities for women: Protection from weather","w_14_08",5,7.9365079365079361E-2,null,null,null,0,2,3,58,63,null,7,0.1111111111111111]
["Shelter priorities for women: Other","w_14_09",7,0.1111111111111111,null,null,null,0,0,7,56,63,null,7,0.1111111111111111]
[]
["Health priorities for women: None","w_25_01",0,0,null,null,null,{"$f":"COUNTIF(INDIRECT($B67),H$2)","v":0},0,0,63,63,null,0,0,{"$f":"SUM(H67:J72) / (63 * 3)","v":1.0052910052910053}]
["Health priorities for women: Diarrhea","w_25_02",55,0.87301587301587302,null,null,null,25,18,12,8,63,null,123,1.9523809523809523]
["Health priorities for women: Skin disease","w_25_03",{"$f":"COUNTIF(INDIRECT($B69),\">0\")","v":59},{"$f":"COUNTIF(INDIRECT($B69),\">0\") / COUNT(INDIRECT($B69))","v":0.93650793650793651},null,null,null,32,26,1,4,63,null,149,2.3650793650793651]
["Health priorities for women: Snake bite","w_25_04",37,0.58730158730158732,null,null,null,6,11,20,26,63,null,60,0.95238095238095233]
["Health priorities for women: Safe birth","w_25_05",9,0.14285714285714285,null,null,null,1,2,6,54,63,null,13,0.20634920634920634]
["Health priorities for women: Other","w_25_06",30,0.47619047619047616,null,null,null,0,6,24,33,63,null,36,0.5714285714285714]

{"sheet":"Analysis01_TabCategorical","index":7,"n_rows":39,"n_cols":12,"rows_kept":39,"cut":false,"hidden":false,"merged":[[7,1,9,1],[7,2,7,3],[7,5,7,6]]}
[null,"Tabulation of multiple variables that have (nearly) the same categories"]
[]
[null,"If all categories known and available:"]
[null,null,null,null,null,null,null,null,"Alternatives to using multiple Pivot tables,"]
[null,"Tabulate the four categorical variables side-by-side, using the standard functions",null,null,null,null,null,null,"then copy-paste (values only) results side by side."]
[null,"\"indirect\" and \"countif\", as well as mixed cell references."]
[]
[null,"Predominant defection mode","Men",null,null,"Women"]
[null,null,"Before","After",null,"Before","After"]
[null,null,"m_06_01","m_06_02",null,"w_11_01","w_11_02",null,"Names of the data ranges in the data sheet."]
[null,"1-Open area",{"$f":"COUNTIF(INDIRECT(C$10),$B11)","v":3},{"$f":"COUNTIF(INDIRECT(D$10),$B11)","v":20},null,0,26,null,"=COUNTIF(INDIRECT(R9C),RC2)"]
[null,"2-Hanging or open latrine",{"$f":"COUNTIF(INDIRECT(C$10),$B12)","v":2},{"$f":"COUNTIF(INDIRECT(D$10),$B12)","v":20},null,{"$f":"COUNTIF(INDIRECT(F$10),$B12)","v":14},17]
[null,"3-Sanitary latrines (communal)",{"$f":"COUNTIF(INDIRECT(C$10),$B13)","v":15},{"$f":"COUNTIF(INDIRECT(D$10),$B13)","v":13},null,0,10]
[null,"4-Sanitary latrines (household)",{"$f":"COUNTIF(INDIRECT(C$10),$B14)","v":42},{"$f":"COUNTIF(INDIRECT(D$10),$B14)","v":5},null,49,6]
[null,"5-Other",{"$f":"COUNTIF(INDIRECT(C$10),$B15)","v":1},{"$f":"COUNTIF(INDIRECT(D$10),$B15)","v":5},null,0,4]
[null,"Total",{"$f":"SUM(C11:C15)","v":63},{"$f":"SUM(D11:D15)","v":63},null,63,63]
[]
[null,"If not all categories across the concerned variables are obvious and easily available:"]
[]
[null,"Step 1: Extract the distinct items from the union of the data ranges,"]
[null,"with the help of the user-written functions \"union\" and \"Unique\":"]
[]
[null,{"$f":"unique(Union(m_06_01,m_06_02, w_11_01,w_11_02),ROW(B23)-ROW(B$22))","v":"4-Sanitary latrines (household)"},null,"=unique(Union(m_06_01,m_06_02, w_11_01,w_11_02),ROW(RC)-ROW(R22C))",null,null,null,null,null,null,null,"Remarks:"]
[null,{"$f":"unique(Union(m_06_01,m_06_02, w_11_01,w_11_02),ROW(B24)-ROW(B$22))","v":"1-Open area"},null,"Copy the formula down until it returns blanks in at least one cell.",null,null,null,null,null,null,null,"1. The function UNION unions the sets passed to it as named ranges."]
[null,{"$f":"unique(Union(m_06_01,m_06_02, w_11_01,w_11_02),ROW(B25)-ROW(B$22))","v":"3-Sanitary latrines (communal)"},null,null,null,null,null,null,null,null,null,"2. This unioned set is the first argument in UNIQUE; the seond"]
[null,{"$f":"unique(Union(m_06_01,m_06_02, w_11_01,w_11_02),ROW(B26)-ROW(B$22))","v":"5-Other"},null,null,null,null,null,null,null,null,null,"is a item number, which we conveniently produce by the difference between the row number and the row just above the greyed area."]
[null,{"$f":"unique(Union(m_06_01,m_06_02, w_11_01,w_11_02),ROW(B27)-ROW(B$22))","v":"2-Hanging or open latrine"},null,null,null,null,null,null,null,null,null,"Items appear in the order they are first encountered."]
[null,{"$f":"unique(Union(m_06_01,m_06_02, w_11_01,w_11_02),ROW(B28)-ROW(B$22))","v":""},null,"The only place in this workbook that uses user-defined functions. See VBA module."]
[null,{"$f":"unique(Union(m_06_01,m_06_02, w_11_01,w_11_02),ROW(B29)-ROW(B$22))","v":""}]
[null,{"$f":"unique(Union(m_06_01,m_06_02, w_11_01,w_11_02),ROW(B30)-ROW(B$22))","v":""}]
[]
[null,"Step 2: Copy the cells with visible values, paste them (values only), and sort in place."]
[null,"1-Open area"]
[null,"2-Hanging or open latrine"]
[null,"3-Sanitary latrines (communal)"]
[null,"4-Sanitary latrines (household)"]
[null,"5-Other"]
[]
[null,"Step 3: Build the table as in the first case."]

{"sheet":"Analysis01_MultipleR_Pivot","index":8,"n_rows":36,"n_cols":13,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Teams","(All)"]
[null,null,"Upazila","(All)"]
[null,null,"Union","(All)"]
[null,null,"Rural vs. Urban","(All)"]
[null,null,"Living arrangement","(All)"]
[]
[null,null,null,"District"]
[null,null,"Values","Jessore","Kulna","Shatkira","Grand Total"]
[null,null,"Count of i_00_01",24,5,34,63]
["Shelter issues for men: Shelter not available","m_07_01","Average of m_07_01",0.66666666666666663,0.8,0.38235294117647056,0.52380952380952384]
["Shelter issues for men: Overcrowded","m_07_02","Average of m_07_02",0.20833333333333334,0.4,0.14705882352941177,0.19047619047619047]
["Shelter issues for men: Return home impossible","m_07_03","Average of m_07_03",0.66666666666666663,0.8,0.61764705882352944,0.65079365079365081]
["Shelter issues for men: No repair materials","m_07_04","Average of m_07_04",0.41666666666666669,0.2,0.35294117647058826,0.36507936507936506]
["Shelter issues for men: No manpower for repairs","m_07_05","Average of m_07_05",0,0.2,5.8823529411764705E-2,4.7619047619047616E-2]
["Shelter issues for men: Land issues for men","m_07_06","Average of m_07_06",0,0.2,2.9411764705882353E-2,3.1746031746031744E-2]
["Shelter issues for men: Lack of household items","m_07_07","Average of m_07_07",0.16666666666666666,0,0.3235294117647059,0.23809523809523808]
["Shelter issues for men: Lack of privacy","m_07_08","Average of m_07_08",0.16666666666666666,0,0.17647058823529413,0.15873015873015872]
["Shelter issues for men: Exposed to weather","m_07_09","Average of m_07_09",8.3333333333333329E-2,0,0.14705882352941177,0.1111111111111111]
["Shelter issues for men: Other","m_07_10","Average of m_07_10",0.20833333333333334,0,8.8235294117647065E-2,0.12698412698412698]
[]
[null,null,"By sites",null,null,null,null,null,"By choices"]
[null,null,null,"Jessore","Kulna","Shatkira","Grand Total",null,null,"Jessore","Kulna","Shatkira","Grand Total"]
[null,null,"Shelter not available",0.66666666666666663,0.8,0.38235294117647056,0.52380952380952384,null,"Shelter not available",{"$f":"D25/D$36","v":0.25806451612903225},{"$f":"E25/E$36","v":0.30769230769230765},0.16455696202531647,0.21428571428571427]
[null,null,"Overcrowded",0.20833333333333334,0.4,0.14705882352941177,0.19047619047619047,null,"Overcrowded",{"$f":"D26/D$36","v":8.0645161290322578E-2},0.15384615384615383,6.3291139240506333E-2,7.7922077922077906E-2]
[null,null,"Return home impossible",0.66666666666666663,0.8,0.61764705882352944,0.65079365079365081,null,"Return home impossible",0.25806451612903225,0.30769230769230765,0.26582278481012661,0.26623376623376621]
[null,null,"No repair materials",0.41666666666666669,0.2,0.35294117647058826,0.36507936507936506,null,"No repair materials",0.16129032258064516,7.6923076923076913E-2,0.15189873417721522,0.14935064935064932]
[null,null,"No manpower for repairs",0,0.2,5.8823529411764705E-2,4.7619047619047616E-2,null,"No manpower for repairs",0,7.6923076923076913E-2,2.5316455696202535E-2,1.9480519480519477E-2]
[null,null,"Land issues for men",0,0.2,2.9411764705882353E-2,3.1746031746031744E-2,null,"Land issues for men",0,7.6923076923076913E-2,1.2658227848101267E-2,1.2987012987012984E-2]
[null,null,"Lack of household items",0.16666666666666666,0,0.3235294117647059,0.23809523809523808,null,"Lack of household items",6.4516129032258063E-2,0,0.13924050632911394,9.7402597402597393E-2]
[null,null,"Lack of privacy",0.16666666666666666,0,0.17647058823529413,0.15873015873015872,null,"Lack of privacy",6.4516129032258063E-2,0,7.5949367088607611E-2,6.4935064935064929E-2]
[null,null,"Exposed to weather",8.3333333333333329E-2,0,0.14705882352941177,0.1111111111111111,null,"Exposed to weather",3.2258064516129031E-2,0,6.3291139240506333E-2,4.5454545454545449E-2]
[null,null,"Other",0.20833333333333334,0,8.8235294117647065E-2,0.12698412698412698,null,"Other",8.0645161290322578E-2,0,3.7974683544303806E-2,5.1948051948051938E-2]
[null,null,"Sites",24,5,34,63,null,"Total",{"$f":"SUM(J25:J34)","v":0.99999999999999989},{"$f":"SUM(K25:K34)","v":0.99999999999999978},1.0000000000000002,0.99999999999999989]
[null,null,"Mean number of choices",{"$f":"SUM(D25:D34)","v":2.5833333333333335},{"$f":"SUM(E25:E34)","v":2.6000000000000005},2.3235294117647056,2.4444444444444446]

{"sheet":"Analysis01_MultipleR_IF","index":9,"n_rows":33,"n_cols":22,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Small demo (28 cases only) when multiple-choice data are missing [artificially deleted]:"]
["Missing data - Different case exclusion rules produce different results.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Auxiliary variables:"]
["To account for missing, Pivot tables are not suitable. Use condition fields with COUNTBLANK, and tabulate with INDIRECT and AVERAGEIF.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non-missing values per record when"]
["Record number","Shelter issues for men: Shelter not available","Shelter issues for men: Overcrowded","Shelter issues for men: Return home impossible","Shelter issues for men: No repair materials","Shelter issues for men: No manpower for repairs","Shelter issues for men: Land issues for men","Shelter issues for men: Lack of household items","Shelter issues for men: Lack of privacy","Shelter issues for men: Exposed to weather","Shelter issues for men: Other","All responses blank","Some missing",null,null,null,"Sites in the assessment","This question: \nExluding sites with all missing","This question:\nExcluding sites with any missing",null,"This question: \nExluding sites with all missing","This question:\nExcluding sites with any missing"]
["ix_00_01","mx_07_01","mx_07_02","mx_07_03","mx_07_04","mx_07_05","mx_07_06","mx_07_07","mx_07_08","mx_07_09","mx_07_10","mx_allmiss","mx_somemiss",null,"By sites:"]
[1,1,1,0,0,0,0,0,0,0,0,{"$f":"IF(COUNTBLANK($B6:$K6)=COLUMNS($B6:$K6),1,0)","v":0},{"$f":"IF(COUNTBLANK($B6:$K6)>0,1,0)","v":0},null,"Shelter not available","mx_07_01",null,{"$f":"AVERAGEIF(mx_allmiss,0,INDIRECT($P6))","v":0.69230769230769229},{"$f":"AVERAGEIF(mx_somemiss,0,INDIRECT($P6))","v":0.69565217391304346},null,{"$f":"IF(COUNTBLANK($B6:$K6)=COLUMNS($B6:$K6),0,COLUMNS($B6:$K6)-COUNTBLANK($B6:$K6))","v":10},{"$f":"IF(COUNTBLANK($B6:$K6)>0,0,COLUMNS($B6:$K6))","v":10}]
[2,1,0,1,0,0,0,0,0,0,0,{"$f":"IF(COUNTBLANK($B7:$K7)=COLUMNS($B7:$K7),1,0)","v":0},{"$f":"IF(COUNTBLANK($B7:$K7)>0,1,0)","v":0},null,"Overcrowded","mx_07_02",null,0.26923076923076922,0.30434782608695654,null,{"$f":"IF(COUNTBLANK($B7:$K7)=COLUMNS($B7:$K7),0,COLUMNS($B7:$K7)-COUNTBLANK($B7:$K7))","v":10},{"$f":"IF(COUNTBLANK($B7:$K7)>0,0,COLUMNS($B7:$K7))","v":10}]
[3,1,0,1,0,0,0,0,0,0,0,0,0,null,"Return home impossible","mx_07_03",null,0.69230769230769229,0.78260869565217395,null,10,10]
[4,1,1,1,0,0,0,0,0,0,0,0,0,null,"No repair materials","mx_07_04",null,0.42307692307692307,0.47826086956521741,null,10,10]
[5,1,1,0,1,0,0,0,0,0,0,0,0,null,"No manpower for repairs","mx_07_05",null,4.3478260869565216E-2,4.3478260869565216E-2,null,10,10]
[6,1,0,1,0,0,0,0,1,0,1,0,0,null,"Land issues for men","mx_07_06",null,4.3478260869565216E-2,4.3478260869565216E-2,null,10,10]
[7,1,0,1,1,0,0,0,0,0,1,0,0,null,"Lack of household items","mx_07_07",null,0.17391304347826086,0.17391304347826086,null,10,10]
[8,1,0,1,0,0,0,0,0,0,1,0,0,null,"Lack of privacy","mx_07_08",null,0.17391304347826086,0.17391304347826086,null,10,10]
[9,1,0,0,1,0,0,0,1,0,0,0,0,null,"Exposed to weather","mx_07_09",null,8.6956521739130432E-2,8.6956521739130432E-2,null,10,10]
[10,0,0,1,1,0,0,0,1,1,0,0,0,null,"Other","mx_07_10",null,0.21739130434782608,0.21739130434782608,null,10,10]
[11,0,0,0,1,0,0,1,0,1,1,0,0,null,"Mean number of choices",null,null,{"$f":"SUM(R6:R15)","v":2.8160535117056855},{"$f":"SUM(S6:S15)","v":3},null,10,10]
[12,0,0,1,1,0,0,0,0,0,1,0,0,null,"Cases","ix_00_01",{"$f":"COUNT(INDIRECT($P17))","v":28},{"$f":"COUNT(INDIRECT($P17))-SUM(mx_allmiss)","v":26},{"$f":"COUNT(INDIRECT($P17))-SUM(mx_somemiss)","v":23},null,10,10]
[13,1,1,1,0,0,0,0,0,0,0,0,0,null,"Mean number of non-missing",null,null,{"$f":"SUM(U6:U33)/10","v":24.2},{"$f":"SUM(V6:V33)/10","v":23},null,10,10]
[14,1,0,0,0,null,null,null,null,null,null,0,1,null,null,null,null,null,null,null,4,0]
[15,0,0,0,0,null,null,null,null,null,null,0,1,null,"By choices:",null,null,null,null,null,4,0]
[16,1,0,0,0,null,null,null,null,null,null,0,1,null,"Shelter not available",null,null,{"$f":"R6/R$16","v":0.24584323040380049},{"$f":"S6/S$16","v":0.2318840579710145},null,4,0]
[17,0,1,1,0,0,0,0,1,0,0,0,0,null,"Overcrowded",null,null,{"$f":"R7/R$16","v":9.5605700712589073E-2},0.10144927536231885,null,10,10]
[18,1,0,1,0,0,0,0,0,0,0,0,0,null,"Return home impossible",null,null,{"$f":"R8/R$16","v":0.24584323040380049},0.2608695652173913,null,10,10]
[19,0,0,1,1,0,0,0,0,0,0,0,0,null,"No repair materials",null,null,{"$f":"R9/R$16","v":0.1502375296912114},0.15942028985507248,null,10,10]
[20,0,0,1,1,0,0,1,0,0,0,0,0,null,"No manpower for repairs",null,null,{"$f":"R10/R$16","v":1.5439429928741092E-2},1.4492753623188406E-2,null,10,10]
[21,0,0,1,1,0,0,1,0,0,0,0,0,null,"Land issues for men",null,null,{"$f":"R11/R$16","v":1.5439429928741092E-2},1.4492753623188406E-2,null,10,10]
[22,1,0,0,1,0,0,1,0,0,0,0,0,null,"Lack of household items",null,null,{"$f":"R12/R$16","v":6.1757719714964368E-2},5.7971014492753624E-2,null,10,10]
[23,1,0,1,0,0,0,0,0,0,0,0,0,null,"Lack of privacy",null,null,{"$f":"R13/R$16","v":6.1757719714964368E-2},5.7971014492753624E-2,null,10,10]
[24,null,null,null,null,null,null,null,null,null,null,1,1,null,"Exposed to weather",null,null,{"$f":"R14/R$16","v":3.0878859857482184E-2},2.8985507246376812E-2,null,0,0]
[25,null,null,null,null,null,null,null,null,null,null,1,1,null,"Other",null,null,{"$f":"R15/R$16","v":7.7197149643705471E-2},7.2463768115942032E-2,null,0,0]
[26,1,0,1,1,1,1,0,0,0,0,0,0,null,"Total",null,null,{"$f":"SUM(R21:R30)","v":1},{"$f":"SUM(S21:S30)","v":1},null,10,10]
[27,1,1,1,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,10,10]
[28,1,1,1,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,10,10]

{"sheet":"Text01_Polytomous","index":10,"n_rows":47,"n_cols":11,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["Multiple-choice data: Initial entry as text, by order of recorded response"]
["The data type here is multiple-choice without preference or priority. It is a small segment from the Bangladesh data."]
[null,"Initial data entry:",null,null,null,null,"Transformed to indicator variables:"]
[]
[null,"Strictly standardized response categories:",null,null,null,null,"Working with exact search strings:"]
["RecordNo","Multiple response data: Shelter issues for men",null,null,null,null,"Multiple response data: Indicator form"]
[null,"Recorded 1st","Recorded 2nd","Recorded 3rd","Recorded 4th",null,"Not available","Overcrowded","Return home impossible","No repair materials"]
["recno","ShelterMen1","ShelterMen2","ShelterMen3","ShelterMen4",null,"m_07_01","m_07_02","m_07_03","m_07_04","[For convenience only:] Short name of variable in data table to which this indicator variable corresponds."]
[1,"Overcrowded","Not available",null,null,null,{"$f":"IF(ISERROR(MATCH(G$7,$B9:$E9,0))=FALSE,1,0)","v":1},{"$f":"IF(ISERROR(MATCH(H$7,$B9:$E9,0))=FALSE,1,0)","v":1},0,0]
[2,"Return home impossible","Not available",null,null,null,{"$f":"IF(ISERROR(MATCH(G$7,$B10:$E10,0))=FALSE,1,0)","v":1},0,1,0]
[3,"Return home impossible","Not available",null,null,null,1,0,1,0]
[4,"Not available","Overcrowded","Return home impossible",null,null,1,1,1,0]
[5,"No repair materials","Overcrowded","Not available",null,null,1,1,0,1]
[]
[null,null,null,null,null,null,"Formulas for the exact string in row 7:"]
[null,null,null,null,null,null," =IF(ISERROR(MATCH(R7C,RC2:RC5,0))=FALSE,1,0)"]
[]
[]
[]
["Categories with spelling variants, or free text, but with key semantic components.",null,null,null,null,null,"Working with approximate search strings:"]
["RecordNo","Multiple response data: Shelter issues for men",null,null,null,null,"Multiple response data: Indicator form"]
[null,"Recorded 1st","Recorded 2nd","Recorded 3rd","Recorded 4th",null,"avail","over","home","repair"]
["recno","ShelterMen1","ShelterMen2","ShelterMen3","ShelterMen4",null,"m_07_01","m_07_02","m_07_03","m_07_04","[For convenience only:] Short name of variable in data table to which this indicator variable corresponds."]
[1,"Overcrowded","Unavailable",null,null,null,{"$f":"IF(ISERROR(MATCH(\"*\"&G$22&\"*\",$B24:$D24,0))=FALSE,1,0)","v":1},{"$f":"IF(ISERROR(MATCH(\"*\"&H$22&\"*\",$B24:$D24,0))=FALSE,1,0)","v":1},0,0]
[2,"Return home not possible","Not available",null,null,null,{"$f":"IF(ISERROR(MATCH(\"*\"&G$22&\"*\",$B25:$D25,0))=FALSE,1,0)","v":1},0,1,0]
[3,"Return home impossible","Not available",null,null,null,1,0,1,0]
[4,"Not available","Oversold","We cannot go home.",null,null,1,1,1,0]
[5,"No repair materials","Overcrowded","Not available",null,null,1,1,0,1]
[]
[null,null,null,null,null,null,"Formulas for the partial string in row 22:"]
[null,null,null,null,null,null," =IF(ISERROR(MATCH(\"*\"&R22C&\"*\",RC2:RC4,0))=FALSE,1,0)"]
["When some response categories were entered in variants, but with some common substring, a formula flagging substrings can be helpful."]
[]
["How do the formulas work? Example: 2nd case (recno=2): This family cannot go home."]
["We reconstruct them from the inside:"]
[null,"Exact string",null,null,null,null,null,null,"See formulas in these cells:"]
[null,"Return home impossible"," =MATCH(R7C,RC2:RC5,0)",null,null,null,null,null,{"$f":"MATCH(I$7,$B37:$E37,0)","v":1}]
[null,"Return home impossible"," =ISERROR(MATCH(R7C,RC2:RC5,0))",null,null,null,null,null,{"$f":"ISERROR(MATCH(I$7,$B38:$E38,0))","v":false}]
[null,"Return home impossible"," =IF(ISERROR(MATCH(R7C,RC2:RC5,0))=FALSE,1,0)",null,null,null,null,null,{"$f":"IF(ISERROR(MATCH(I$7,$B39:$E39,0))=FALSE,1,0)","v":1}]
[]
[null,"Substring = \"home\""]
[null,"Return home not possible"," =MATCH(\"*\"&R22C&\"*\",RC2:RC4,0)",null,null,null,null,null,{"$f":"MATCH(\"*\"&I$22&\"*\",$B42:$D42,0)","v":1}]
[null,"Return home not possible"," =ISERROR(MATCH(\"*\"&R22C&\"*\",RC2:RC4,0))",null,null,null,null,null,{"$f":"ISERROR(MATCH(\"*\"&I$22&\"*\",$B43:$D43,0))","v":false}]
[null,"Return home not possible"," =IF(ISERROR(MATCH(\"*\"&R22C&\"*\",RC2:RC4,0))=FALSE,1,0)",null,null,null,null,null,{"$f":"IF(ISERROR(MATCH(\"*\"&I$22&\"*\",$B44:$D44,0))=FALSE,1,0)","v":1}]
[]
[null,"Note: ","In \"*\"&R22C&\"*\", & is the concatenation operator; *, within inverted commas, is a placeholder for any or no string."]
[null,null,"The same formula type, as in R44, is helpful to extract indicator variables from free-text cells, such as used to record \"Other:\" options."]

{"sheet":"Text02_Priorities","index":11,"n_rows":46,"n_cols":11,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
["Priority-type data: Initial entry as text, by priority"]
["The data type here is multiple-choice with priorities (up to 3). It is a small segment from the Bangladesh data; some cell contents were changed for demonstration purposes."]
[null,"Initial data entry:",null,null,null,null,"Transformed to item-based variables:"]
[]
[null,"Strictly standardized response categories:",null,null,null,null,"Working with exact search strings:"]
["RecordNo","Priority-type data: Shelter priorities for men",null,null,null,null,"Priority-type data: Code 1st as 3, 2nd as 2, 3rd as 1"]
[null,"1st (= highest) priority","2nd priority","3rd priority","Comment",null,"Find shelter","Move out of shelter","Return home","Material for home repair"]
["recno","ShelterMen1","ShelterMen2","ShelterMen3",null,null,"m_08_01","m_08_02","m_08_03","m_08_04","[For convenience only:] Short name of variable in data table to which this priority variable corresponds."]
[1,"Return home","Material for home repair","Find shelter",null,null,{"$f":"IF(COUNTBLANK($B9:$D9)=3,\"\",IF(ISERROR(MATCH(G$7,$B9:$D9,0))=FALSE,4-MATCH(G$7,$B9:$D9,0),0))","v":1},{"$f":"IF(COUNTBLANK($B9:$D9)=3,\"\",IF(ISERROR(MATCH(H$7,$B9:$D9,0))=FALSE,4-MATCH(H$7,$B9:$D9,0),0))","v":0},3,2]
[2,null,null,null,"Did not prioritize any option",null,{"$f":"IF(COUNTBLANK($B10:$D10)=3,\"\",IF(ISERROR(MATCH(G$7,$B10:$D10,0))=FALSE,4-MATCH(G$7,$B10:$D10,0),0))","v":""},"","",""]
[3,"Find shelter","Material for home repair","Return home",null,null,3,0,1,2]
[4,"Find shelter","Return home","Material for home repair",null,null,3,0,2,1]
[5,"Find shelter","Material for home repair",null,"Only 2 priorities",null,3,0,0,2]
[]
[null,null,null,null,null,null,"Formulas for the exact string in row 7:"]
[null,null,null,null,null,null," =IF(COUNTBLANK(RC2:RC4)=3,\"\",IF(ISERROR(MATCH(R7C,RC2:RC4,0))=FALSE,4-MATCH(R7C,RC2:RC4,0),0))"]
[]
[]
[]
["Categories with spelling variants, or free text, but with key semantic components.",null,null,null,null,null,"Working with approximate search strings:"]
["RecordNo","Priority-type data: Shelter priorities for men",null,null,null,null,"Priority-type data: Code 1st as 3, 2nd as 2, 3rd as 1"]
[null,"1st (= highest) priority","2nd priority","3rd priority","Comment",null,"find","move out","home","repair"]
["recno","ShelterMen1","ShelterMen2","ShelterMen3",null,null,"m_08_01","m_08_02","m_08_03","m_08_04","[For convenience only:] Short name of variable in data table to which this priority variable corresponds."]
[1,"Wants to go home.","Material for home repair","Find shelter",null,null,{"$f":"IF(COUNTBLANK($B24:$D24)=3,\"\",IF(ISERROR(MATCH(\"*\"&G$22&\"*\",$B24:$D24,0))=FALSE,4-MATCH(\"*\"&G$22&\"*\",$B24:$D24,0),0))","v":1},0,3,2]
[2,null,null,null,"Did not prioritize",null,"","","",""]
[3,"Find shelter","Material for home repair","Return home",null,null,3,0,2,2]
[4,"Find my family shelter","Return home","Home repair",null,null,3,0,2,1]
[5,"Find shelter","Materials for home repair",null,"Only 2 priorities",null,3,0,2,2]
[]
[null,null,null,null,null,null,"Formulas for the partial string in row 22:"]
[null,null,null,null,null,null," =IF(COUNTBLANK(RC2:RC4)=3,\"\",IF(ISERROR(MATCH(\"*\"&R22C&\"*\",RC2:RC4,0))=FALSE,4-MATCH(\"*\"&R22C&\"*\",RC2:RC4,0),0))"]
["When some response categories were entered in variants, but with some common substring, a formula flagging substrings can be helpful."]
[]
["How do the formulas work? Example: 1st case (recno=1): For this family, the highest priority is to return home."]
["We reconstruct them from the inside:"]
[null,"Exact string",null,null,null,null,null,null,"See formulas in these cells:"]
[null,"Return home"," =MATCH(R7C,RC2:RC4,0)",null,null,null,null,null,{"$f":"MATCH(I$7,$B37:$D37,0)","v":1}]
[null,"Return home"," =ISERROR(MATCH(R7C,RC2:RC4,0))",null,null,null,null,null,{"$f":"ISERROR(MATCH(I$7,$B38:$D38,0))","v":false}]
[null,"Return home"," =IF(ISERROR(MATCH(R7C,RC2:RC4,0))=FALSE,4-MATCH(R7C,RC2:RC4,0),0)",null,null,null,null,null,{"$f":"IF(ISERROR(MATCH(I$7,$B39:$D39,0))=FALSE,4-MATCH(I$7,$B39:$D39,0),0)","v":3}]
[null,"Return home"," =IF(COUNTBLANK(RC2:RC4)=3,\"\",IF(ISERROR(MATCH(R7C,RC2:RC4,0))=FALSE,4-MATCH(R7C,RC2:RC4,0),0))",null,null,null,null,null,{"$f":"IF(COUNTBLANK($B40:$D40)=3,\"\",IF(ISERROR(MATCH(I$7,$B40:$D40,0))=FALSE,4-MATCH(I$7,$B40:$D40,0),0))","v":3}]
[]
[null,"Substring = \"home\""]
[null,"Wants to go home."," =MATCH(\"*\"&R22C&\"*\",RC2:RC4,0)",null,null,null,null,null,{"$f":"MATCH(\"*\"&I$22&\"*\",$B43:$D43,0)","v":1}]
[null,"Wants to go home."," =ISERROR(MATCH(\"*\"&R22C&\"*\",RC2:RC4,0))",null,null,null,null,null,{"$f":"ISERROR(MATCH(\"*\"&I$22&\"*\",$B44:$D44,0))","v":false}]
[null,"Wants to go home."," =IF(ISERROR(MATCH(\"*\"&R22C&\"*\",RC2:RC4,0))=FALSE,4-MATCH(\"*\"&R22C&\"*\",RC2:RC4,0),0)",null,null,null,null,null,{"$f":"IF(ISERROR(MATCH(\"*\"&I$22&\"*\",$B45:$D45,0))=FALSE,4-MATCH(\"*\"&I$22&\"*\",$B45:$D45,0),0)","v":3}]
[null,"Wants to go home."," =IF(COUNTBLANK(RC2:RC4)=3,\"\",IF(ISERROR(MATCH(\"*\"&R22C&\"*\",RC2:RC4,0))=FALSE,4-MATCH(\"*\"&R22C&\"*\",RC2:RC4,0),0))",null,null,null,null,null,{"$f":"IF(COUNTBLANK($B46:$D46)=3,\"\",IF(ISERROR(MATCH(\"*\"&I$22&\"*\",$B46:$D46,0))=FALSE,4-MATCH(\"*\"&I$22&\"*\",$B46:$D46,0),0))","v":3}]

{"sheet":"Analyses02_QuickOverview","index":12,"n_rows":70,"n_cols":19,"rows_kept":70,"cut":false,"hidden":false,"merged":[]}
["Quick overview, by area and group (= current living arrangement)"]
[]
["By subdistrict:",null,null,null,null,null,null,null,null,"Full listing of sites"]
["Data field shows maximum vulnerability level in sub-group"]
["[Vulnerability was numerically recoded, see column 120 in the data sheet]",null,null,null,null,null,null,null,null,"District - Sub-district - Union - Village - site number"]
["Max of t_14_00_code",null,"t_00_10",null,null,null,null,null,null,"Max of t_14_00_code",null,null,null,null,"t_00_10"]
["District","Upazila (Sub-district)","1-Collective centers","2-Roadside / embankments","3-Marooned","4-Damaged or water-logged","5-Home undamaged","Grand Total",null,"District","Upazila","Union","Village","Site number","1-Collective centers","2-Roadside / embankments","3-Marooned","4-Damaged or water-logged","5-Home undamaged"]
["Jessore","Abhynagar",null,null,3,2,null,3,null,"Jessore","Abhynagar","Paira","Ghoradari",1,null,null,null,2]
[null,"Jhikargacha",3,3,3,3,3,3,null,null,null,"Siddiqpasa","Joyrabad",2,null,null,2]
[null,"Keshabpur",3,3,3,3,2,3,null,null,null,null,"Nolamara",3,null,null,null,2]
[null,"Monirampur",null,2,3,3,null,3,null,null,null,"Suvoyara","Hindia",5,null,null,null,2]
["Kulna","Paikgacha",null,3,2,null,1,3,null,null,null,null,"IsamotiPurbapasa",4,null,null,3]
["Shatkira","Assasuni",4,2,4,3,2,4,null,null,"Jhikargacha","Bakra","Dikdana",6,null,3]
[null,"Debhata",4,3,1,4,1,4,null,null,null,null,null,7,null,null,1]
[null,"Kalaroa",3,2,2,1,1,3,null,null,null,"Nibeshkhola","Balla (Beside River)",8,null,null,null,null,3]
[null,"Shaktira_Sadar",4,4,4,4,4,4,null,null,null,"Ponisara","Purandapur (Purba Para)",9,null,null,null,null,3]
[null,"Tala",4,4,3,4,2,4,null,null,null,"Pourashara","Parbazar",10,3]
["Grand Total",null,4,4,4,4,4,4,null,null,null,null,"Saddampara",11,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,"Shanti Bagar",12,null,null,null,3]
["Color added by conditional formatting.",null,null,null,null,null,null,null,null,null,"Keshabpur","Biddyanandakati","Nehanpur",13,3]
[null,null,"Legend:",null,null,null,null,null,null,null,null,"Keshabpur Sadar","Basdanga",14,null,null,null,null,2]
[null,null,1,"1-Relatively normal",null,null,null,null,null,null,null,"Mojidpur","Protappur",15,null,null,null,null,2]
[null,null,2,"2-Vulnerable",null,null,null,null,null,null,null,"Pazia","Bagdanga",16,null,null,null,null,2]
[null,null,3,"3-Seriously vulnerable",null,null,null,null,null,null,null,"Sagardari","Sagardari",17,null,3]
[null,null,4,"4-Extremely vulnerable",null,null,null,null,null,null,null,"Shuflakati","Krishnagar",19,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,"Poschim Sarutia",18,null,null,3]
["Technical note:",null,null,null,null,null,null,null,null,null,"Monirampur","Durbadunga","Ashanigar",20,null,null,3]
["When we copy-paste a Pivot table, the copy remembers the named database range",null,null,null,null,null,null,null,null,null,null,"Jhapa","2no Ward",21,null,null,null,3]
["on which it is based from the definition used for the orginal.",null,null,null,null,null,null,null,null,null,null,null,"Jhapa",22,null,null,null,3]
["When we add calculated variables to the data table and update the definition",null,null,null,null,null,null,null,null,null,null,"Moshimnagar","Horotpur",23,null,2]
["of \"Database\", the wizard of the copy Pivot will not show the new variables.",null,null,null,null,null,null,null,null,null,null,null,"Varatpur",24,null,null,2]
["The problem can be solved in two ways:",null,null,null,null,null,null,null,null,"Kulna","Paikgacha","Horidhal","Horidaskathi",25,null,3]
["1. Use \"Database\" as updated, but build the Pivot table from scratch (i.e. do not copy-paste).",null,null,null,null,null,null,null,null,null,null,null,"Noakathi",26,null,3]
["2. Use a copied Pivot table, but change in Pivot table tools - Data - Data source",null,null,null,null,null,null,null,null,null,null,"Horikhali","ChandKhali 9No Katabunia",27,null,3]
["the source range. First name the updated Database range by yet another name, then",null,null,null,null,null,null,null,null,null,null,"Kopilmoni","Kasimnagar",28,null,null,2]
["pass this name as the data source. In the above example, after extending \"Database\"",null,null,null,null,null,null,null,null,null,null,null,"Kazimusa",29,null,null,null,null,1]
["to include column 120, we gave it the name \"DatabaseCol120\".",null,null,null,null,null,null,null,null,"Shatkira","Assasuni","Budhata","Behula",30,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,"Dargapur","Sonai & Tokipur",31,null,null,null,3]
["At the beginning of the analysis, it is not known how many calculated variables ",null,null,null,null,null,null,null,null,null,null,"Kadakhati","Kadakati",32,4]
["will have to be added. This updating procedure may thus have to be repeated.",null,null,null,null,null,null,null,null,null,null,null,null,33,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,"Kulia","Kochua",34,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,"Shobnali","Bodortola",36,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,"Katakhali",35,null,2]
[null,null,null,null,null,null,null,null,null,null,"Debhata","Kulia","Gobrakhali",37,4]
[null,null,null,null,null,null,null,null,null,null,null,"Nowapara","Chachura hati",39,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,"Kaminiboshu",38,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,"Parulia","Polgoda",40,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,"Soto Shatha",41,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,"Kalaroa","Deara","Deara Dakhil Madrasha",42,3]
[null,null,null,null,null,null,null,null,null,null,null,null,"Deara Matpara",43,null,2]
[null,null,null,null,null,null,null,null,null,null,null,"Joynagar","Dokkhin Khetropara",44,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,"Manik Nagar",45,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,"Pouroshava","Gopinathpur Poschim para",46,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,"Shaktira_Sadar","Bolli","Rajjabari bad, Mukudpur vill",47,null,4]
[null,null,null,null,null,null,null,null,null,null,null,"Brahamorajpur","Machkhola",48,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,"Fringi","Gobordari",49,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,"Labsa","Soninathpur, Binerputa",50,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,"Municipality","6 No Ward",51,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,52,null,4]
[null,null,null,null,null,null,null,null,null,null,"Tala","Islam Kati","Narayanpur/ Bhanipur",53,null,4]
[null,null,null,null,null,null,null,null,null,null,null,"Khalilinagar","Nagarghata",54,null,4]
[null,null,null,null,null,null,null,null,null,null,null,"Kholishakhali","Dolua College",55,4]
[null,null,null,null,null,null,null,null,null,null,null,"Kumira","Raripara",56,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,"Magura","Parmadra",57,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,"Nagarghata","Nagarghata",58,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,"Sarulia","Boro Kasipur",60,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,"Kasipur",59,3]
[null,null,null,null,null,null,null,null,null,null,null,"Tala Sadar","Kismotghona",62,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,"Monipur/ Shahpur",61,null,4]
[null,null,null,null,null,null,null,null,null,null,null,"Tentulia","Hatbas, Modonpur, Lakkhanpur",63,null,4]

{"sheet":"Analyses02_PrioritiesByVulnerab","index":13,"n_rows":28,"n_cols":10,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Mean Borda count for priority needs,\nby severity level",null,"1-Relatively normal","2-Vulnerable","3-Seriously vulnerable","4-Extremely vulnerable",null,"All sites"]
["Sites",null,{"$f":"COUNTIF(t_14_00,C$1)","v":6},{"$f":"COUNTIF(t_14_00,D$1)","v":18},{"$f":"COUNTIF(t_14_00,E$1)","v":22},{"$f":"COUNTIF(t_14_00,F$1)","v":17},null,{"$f":"SUM(C2:G2)","v":63}]
["Group interviews with men",null,null,null,null,null,null,null,null,"Function used in columns 3 - 6:"]
["Priority for men: Livelihoods","m_03_01",{"$f":"AVERAGEIF(t_14_00,C$1,INDIRECT($B4))","v":1.3333333333333333},1.6666666666666667,1.5,0.94117647058823528,null,{"$f":"AVERAGE(INDIRECT($B4))","v":1.3809523809523809},null," =AVERAGEIF(t_14_00,R1C,INDIRECT(RC2))"]
["Priority for men: Livestock feed","m_03_02",0.33333333333333331,0.33333333333333331,9.0909090909090912E-2,0,null,{"$f":"AVERAGE(INDIRECT($B5))","v":0.15873015873015872},null,"See Help function for AVERAGEIF"]
["Priority for men: Rebuild homes","m_03_03",0.33333333333333331,0.55555555555555558,0.5,1.8823529411764706,null,0.87301587301587302,null,"Note: t_14_00 is the field name for the assessment teams' severity ratings."]
["Priority for men: Children's schooling","m_03_04",0,0,0,5.8823529411764705E-2,null,1.5873015873015872E-2]
["Priority for men: Health care","m_03_05",0.66666666666666663,0.27777777777777779,0.45454545454545453,0,null,0.30158730158730157,null,"Function used in column 8:"]
["Priority for men: Food","m_03_06",2.5,1.7222222222222223,2.4545454545454546,2.4117647058823528,null,2.2380952380952381,null," =AVERAGE(INDIRECT(RC2))"]
["Priority for men: Safe drinking water","m_03_07",0.33333333333333331,0.33333333333333331,0.5,0,null,0.30158730158730157]
["Priority for men: Water for wash and bath","m_03_08",0,0,0,0,null,0]
["Priority for men: Markets","m_03_09",0,0,0,0,null,0]
["Priority for men: Short-term financial support","m_03_10",0,0.3888888888888889,0.27272727272727271,0.35294117647058826,null,0.30158730158730157]
["Priority for men: Safety","m_03_11",0,0.1111111111111111,9.0909090909090912E-2,0.17647058823529413,null,0.1111111111111111]
["Priority for men: Other","m_03_12",0.33333333333333331,0.44444444444444442,0.13636363636363635,0,null,0.20634920634920634]
["Group interviews with women"]
["Priority for women: Livelihoods","w_03_01",{"$f":"AVERAGEIF(t_14_00,C$1,INDIRECT($B17))","v":0.66666666666666663},1.3888888888888888,0.40909090909090912,5.8823529411764705E-2,null,0.61904761904761907]
["Priority for women: Livestock feed","w_03_02",0.5,0.16666666666666666,0.13636363636363635,0.11764705882352941,null,0.17460317460317459]
["Priority for women: Rebuild homes","w_03_03",1.3333333333333333,0.5,0.81818181818181823,1.588235294117647,null,0.98412698412698407]
["Priority for women: Children's schooling","w_03_04",0,0.1111111111111111,0,5.8823529411764705E-2,null,4.7619047619047616E-2]
["Priority for women: Health care","w_03_05",0.16666666666666666,0.22222222222222221,0.31818181818181818,0.52941176470588236,null,0.33333333333333331]
["Priority for women: Food","w_03_06",2.5,2.1666666666666665,2.4090909090909092,2.2352941176470589,null,2.3015873015873014]
["Priority for women: Safe drinking water","w_03_07",0.5,0.3888888888888889,0.72727272727272729,1,null,0.68253968253968256]
["Priority for women: Water for wash and bath","w_03_08",0,0.1111111111111111,0,0.17647058823529413,null,7.9365079365079361E-2]
["Priority for women: Markets","w_03_09",0,0.1111111111111111,0.13636363636363635,0,null,7.9365079365079361E-2]
["Priority for women: Short-term financial support","w_03_10",0.5,0.66666666666666663,0.5,0,null,0.41269841269841268]
["Priority for women: Safety","w_03_11",0,5.5555555555555552E-2,0,5.8823529411764705E-2,null,3.1746031746031744E-2]
["Priority for women: Other","w_03_12",0,0.16666666666666666,0.27272727272727271,0.17647058823529413,null,0.19047619047619047]

{"sheet":"Analysis02_DistressIndex","index":14,"n_rows":41,"n_cols":25,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["Distress index"]
["We form a naïve distress index from binary indicators.",null,null,null,null,null,"Scroll right, then down"]
["The intent is to have a vulnerability measure derived from key informant data, as different from the teams' assessments."]
["For consistency (and availability), we use information gathered from women's groups only."]
[]
[null,"Domain","Indicator","Based on variable","Short name","Column in data table","Transformation formula",null,"Distress index"]
[null,null,null,null,null,null,null,null,"Index value","Sites with this value"]
[null,"Survival",null,null,null,null,null,null,0,{"$f":"COUNTIF(dw_distress,I8)","v":0}]
[null,null,"Food is the highest priority.","w_03_06","dw_03_06",121," =IF(R[-45]C =3,1,0)",null,1,0]
[null,null,"Livelihoods is the highest priority.","w_03_01","dw_03_01",122," =IF(R[-51]C =3,1,0)",null,2,1]
[null,"Health",null,null,null,null,null,null,3,4]
[null,null,"Lack of safe water serious.","w_06_00","dw_06_00",123," =R[-39]C",null,4,5]
[null,null,"Diarrhea has increased.","w_26_00","dw_26_00",124," =R[-15]C",null,5,10]
[null,"Safety",null,null,null,null,null,null,6,18]
[null,null,"Lack of safe toilets","w_10_00","dw_10_00",125," =R[-39]C",null,7,13]
[null,null,"Women face safety issues.","w_28_01","dw_28_01",126," =R[-16]C",null,8,9]
[null,"Children",null,null,null,null,null,null,9,3]
[null,null,"School attendance is low.","w_18_02","dw_18_02",127," =1 - R[-27]C",null,10,0]
[null,null,"Significant child labor.","w_29_00","dw_29_00",128," =R[-17]C",null,"Mean:",{"$f":"AVERAGE(dw_distress)","v":6.0634920634920633}]
[null,"Services"]
[null,null,"No electricity","w_04_02","dw_04_02",129," =1-R[-46]C"]
[null,null,"Health care facility more than 60 minutes' travel","w_24_02","dw_24_02",130," =IF(OR(LEFT(R[-28]C,1) =\"d\",LEFT(R[-28]C,1) =\"e\",  LEFT(R[-28]C,1) =\"f\"),1,0)"]
[]
[null,"Index"]
[null,null,null,null,"dw_distress",131," =SUM(R[-10]C:R[-1]C)"]
[null,null,null,null,null,null,null,null,"Validation of team assessments:",null,null,null,null,null,null,null,null,"Distress levels, by area and living arrangement:"]
[null,null,null,null,null,null,null,null,"Count of i_00_01","t_14_00",null,null,null,null,null,null,null,"Average of dw_distress",null,"t_00_10"]
[null,null,null,null,null,null,null,null,"dw_distress2","1-Relatively normal","2-Vulnerable","3-Seriously vulnerable","4-Extremely vulnerable","Grand Total",null,null,null,"District","Upazila \n(Sub-district)","1-Collective centers","2-Roadside / embankments","3-Marooned","4-Damaged or water-logged","5-Home undamaged","Grand Total"]
[null,null,null,null,null,null,null,null,"2-4",3,3,4,0,10,null,null,null,"Jessore","Abhynagar",null,null,4,5,null,4.5999999999999996]
[null,null,null,null,null,null,null,null,"5-6",2,11,7,8,28,null,null,null,null,"Jhikargacha",6,4,6,7,5,5.5714285714285712]
[null,null,null,null,null,null,null,null,"7-9",1,4,11,9,25,null,null,null,null,"Keshabpur",7,8,5,6,5.333333333333333,6]
[null,null,null,null,null,null,null,null,"Grand Total",6,18,22,17,63,null,null,null,null,"Monirampur",null,7,7.5,6,null,6.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kulna","Paikgacha",null,8,6,null,5,7]
[null,null,null,null,null,null,null,null,"Pearson collelation coefficient:",null,null,{"$f":"CORREL(dw_distress,t_14_00_code)","v":0.36948373187659489},null,null,null,null,null,"Shatkira","Assasuni",6,6,7.5,7.5,3,6.4285714285714288]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Debhata",6,4,3,6,4,4.5999999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kalaroa",7,6,6,6,3,5.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Shaktira_Sadar",6,7,6,5,7,6.333333333333333]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tala",6.5,7.75,7,8,4.5,6.8181818181818183]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grand Total",null,6.375,6.9333333333333336,6,6.1538461538461542,4.75,6.0634920634920633]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Note: Distress index treated as ratio-level variable."]

{"sheet":"Analysis02_Men_Women","index":15,"n_rows":52,"n_cols":12,"rows_kept":52,"cut":false,"hidden":false,"merged":[[5,10,5,11],[5,9,6,9]]}
["Example agreement on priorities between men and women of the same sites."]
["Pivot tables with conditional formatting. \"3\" is the highest priority. If \"0\", the option was not mentioned in the three priority choices."]
["Men's response appears in the rows, women's in the columns."]
[]
["Livelihoods:",null,null,null,null,null,null,null,null,"Comparison of means for all items:"]
["Sites assessed","w_03_01",null,null,null,null,null,null,null,"Priorities","Mean Borda count"]
["m_03_01",0,1,2,3,"Grand Total",null,null,null,null,"Men","Women"]
[0,15,1,0,1,17,null,null,null,"Livelihoods",1.3809523809523809,0.61904761904761907]
[1,13,3,1,0,17,null,null,null,"Rebuild homes",0.87301587301587302,0.98412698412698407]
[2,9,4,3,1,17,null,null,null,"Food",2.2380952380952381,2.3015873015873014]
[3,4,3,1,4,12,null,null,null,"Safe drinking water",0.30158730158730157,0.68253968253968256]
["Grand Total",41,11,5,6,63,null,null,null,"Short-term financial support",0.30158730158730157,0.41269841269841268]
[]
[]
["Rebuild homes:"]
["Sites assessed","w_03_03"]
["m_03_03",0,1,2,3,"Grand Total"]
[0,24,1,9,2,36]
[1,3,1,2,1,7]
[2,6,1,4,1,12]
[3,1,1,2,4,8]
["Grand Total",34,4,17,8,63]
[]
[]
["Food:"]
["Sites assessed","w_03_06"]
["m_03_06",0,1,2,3,"Grand Total"]
[0,3,0,1,3,7]
[1,0,0,1,5,6]
[2,0,5,4,6,15]
[3,4,0,7,24,35]
["Grand Total",7,5,13,38,63]
[]
[]
["Safe drinking water:"]
["Sites assessed","w_03_07"]
["m_03_07",0,1,2,3,"Grand Total"]
[0,29,11,10,1,51]
[1,3,3,0,0,6]
[2,2,1,1,1,5]
[3,1,0,0,0,1]
["Grand Total",35,15,11,2,63]
[]
[]
["Short-term financial support:"]
["Sites assessed","w_03_10"]
["m_03_10",0,1,2,3,"Grand Total"]
[0,41,6,3,1,51]
[1,6,0,0,1,7]
[2,1,0,1,1,3]
[3,1,0,0,1,2]
["Grand Total",49,6,4,4,63]

{"sheet":"NamedRanges","index":16,"n_rows":148,"n_cols":3,"rows_kept":148,"cut":false,"hidden":false,"merged":[]}
["Name","RefersToLocal","Cells"]
["Database","=Analysis01_Data!R4C1:R67C131",8384]
["DatabaseCol120","=Analysis01_Data!R4C1:R67C120",7680]
["DatabaseCol131","=Analysis01_Data!R4C1:R67C131",8384]
["dw_03_01","=Analysis01_Data!R5C122:R67C122",63]
["dw_03_06","=Analysis01_Data!R5C121:R67C121",63]
["dw_04_02","=Analysis01_Data!R5C129:R67C129",63]
["dw_06_00","=Analysis01_Data!R5C123:R67C123",63]
["dw_10_00","=Analysis01_Data!R5C125:R67C125",63]
["dw_18_02","=Analysis01_Data!R5C127:R67C127",63]
["dw_24_02","=Analysis01_Data!R5C130:R67C130",63]
["dw_26_00","=Analysis01_Data!R5C124:R67C124",63]
["dw_28_01","=Analysis01_Data!R5C126:R67C126",63]
["dw_29_00","=Analysis01_Data!R5C128:R67C128",63]
["dw_distress","=Analysis01_Data!R5C131:R67C131",63]
["i_00_01","=Analysis01_Data!R5C1:R67C1",63]
["i_00_03","=Analysis01_Data!R5C2:R67C2",63]
["i_00_04","=Analysis01_Data!R5C3:R67C3",63]
["i_00_05","=Analysis01_Data!R5C4:R67C4",63]
["i_00_06","=Analysis01_Data!R5C5:R67C5",63]
["i_00_07","=Analysis01_Data!R5C6:R67C6",63]
["i_00_08","=Analysis01_Data!R5C7:R67C7",63]
["i_00_09","=Analysis01_Data!R5C8:R67C8",63]
["ix_00_01","=Analysis01_MultipleR_IF!R6C1:R33C1",28]
["m_03_01","=Analysis01_Data!R5C20:R67C20",63]
["m_03_02","=Analysis01_Data!R5C21:R67C21",63]
["m_03_03","=Analysis01_Data!R5C22:R67C22",63]
["m_03_04","=Analysis01_Data!R5C23:R67C23",63]
["m_03_05","=Analysis01_Data!R5C24:R67C24",63]
["m_03_06","=Analysis01_Data!R5C25:R67C25",63]
["m_03_07","=Analysis01_Data!R5C26:R67C26",63]
["m_03_08","=Analysis01_Data!R5C27:R67C27",63]
["m_03_09","=Analysis01_Data!R5C28:R67C28",63]
["m_03_10","=Analysis01_Data!R5C29:R67C29",63]
["m_03_11","=Analysis01_Data!R5C30:R67C30",63]
["m_03_12","=Analysis01_Data!R5C31:R67C31",63]
["m_04_00","=Analysis01_Data!R5C32:R67C32",63]
["m_06_01","=Analysis01_Data!R5C33:R67C33",63]
["m_06_02","=Analysis01_Data!R5C34:R67C34",63]
["m_07_01","=Analysis01_Data!R5C35:R67C35",63]
["m_07_02","=Analysis01_Data!R5C36:R67C36",63]
["m_07_03","=Analysis01_Data!R5C37:R67C37",63]
["m_07_04","=Analysis01_Data!R5C38:R67C38",63]
["m_07_05","=Analysis01_Data!R5C39:R67C39",63]
["m_07_06","=Analysis01_Data!R5C40:R67C40",63]
["m_07_07","=Analysis01_Data!R5C41:R67C41",63]
["m_07_08","=Analysis01_Data!R5C42:R67C42",63]
["m_07_09","=Analysis01_Data!R5C43:R67C43",63]
["m_07_10","=Analysis01_Data!R5C44:R67C44",63]
["m_08_01","=Analysis01_Data!R5C45:R67C45",63]
["m_08_02","=Analysis01_Data!R5C46:R67C46",63]
["m_08_03","=Analysis01_Data!R5C47:R67C47",63]
["m_08_04","=Analysis01_Data!R5C48:R67C48",63]
["m_08_05","=Analysis01_Data!R5C49:R67C49",63]
["m_08_06","=Analysis01_Data!R5C50:R67C50",63]
["m_08_07","=Analysis01_Data!R5C51:R67C51",63]
["m_08_08","=Analysis01_Data!R5C52:R67C52",63]
["m_08_09","=Analysis01_Data!R5C53:R67C53",63]
["m_16_01","=Analysis01_Data!R5C54:R67C54",63]
["m_16_02","=Analysis01_Data!R5C55:R67C55",63]
["m_16_03","=Analysis01_Data!R5C56:R67C56",63]
["m_16_04","=Analysis01_Data!R5C57:R67C57",63]
["m_16_05","=Analysis01_Data!R5C58:R67C58",63]
["m_16_06","=Analysis01_Data!R5C59:R67C59",63]
["m_16_07","=Analysis01_Data!R5C60:R67C60",63]
["m_16_08","=Analysis01_Data!R5C61:R67C61",63]
["m_16_09","=Analysis01_Data!R5C62:R67C62",63]
["m_16_10","=Analysis01_Data!R5C63:R67C63",63]
["m_16_11","=Analysis01_Data!R5C64:R67C64",63]
["m_16_12","=Analysis01_Data!R5C65:R67C65",63]
["m_16_13","=Analysis01_Data!R5C66:R67C66",63]
["m_16_14","=Analysis01_Data!R5C67:R67C67",63]
["m_16_15","=Analysis01_Data!R5C68:R67C68",63]
["m_17_00","=Analysis01_Data!R5C69:R67C69",63]
["m_21_00","=Analysis01_Data!R5C70:R67C70",63]
["mx_07_01","=Analysis01_MultipleR_IF!R6C2:R33C2",28]
["mx_07_02","=Analysis01_MultipleR_IF!R6C3:R33C3",28]
["mx_07_03","=Analysis01_MultipleR_IF!R6C4:R33C4",28]
["mx_07_04","=Analysis01_MultipleR_IF!R6C5:R33C5",28]
["mx_07_05","=Analysis01_MultipleR_IF!R6C6:R33C6",28]
["mx_07_06","=Analysis01_MultipleR_IF!R6C7:R33C7",28]
["mx_07_07","=Analysis01_MultipleR_IF!R6C8:R33C8",28]
["mx_07_08","=Analysis01_MultipleR_IF!R6C9:R33C9",28]
["mx_07_09","=Analysis01_MultipleR_IF!R6C10:R33C10",28]
["mx_07_10","=Analysis01_MultipleR_IF!R6C11:R33C11",28]
["mx_allmiss","=Analysis01_MultipleR_IF!R6C12:R33C12",28]
["mx_somemiss","=Analysis01_MultipleR_IF!R6C13:R33C13",28]
["t_00_10","=Analysis01_Data!R5C9:R67C9",63]
["t_02_01","=Analysis01_Data!R5C10:R67C10",63]
["t_02_02","=Analysis01_Data!R5C11:R67C11",63]
["t_02_03","=Analysis01_Data!R5C12:R67C12",63]
["t_02_04","=Analysis01_Data!R5C13:R67C13",63]
["t_03_00","=Analysis01_Data!R5C14:R67C14",63]
["t_04_00","=Analysis01_Data!R5C15:R67C15",63]
["t_05_00","=Analysis01_Data!R5C16:R67C16",63]
["t_09_00","=Analysis01_Data!R5C17:R67C17",63]
["t_10_07","=Analysis01_Data!R5C18:R67C18",63]
["t_14_00","=Analysis01_Data!R5C19:R67C19",63]
["t_14_00_code","=Analysis01_Data!R5C120:R67C120",63]
["w_03_01","=Analysis01_Data!R5C71:R67C71",63]
["w_03_02","=Analysis01_Data!R5C72:R67C72",63]
["w_03_03","=Analysis01_Data!R5C73:R67C73",63]
["w_03_04","=Analysis01_Data!R5C74:R67C74",63]
["w_03_05","=Analysis01_Data!R5C75:R67C75",63]
["w_03_06","=Analysis01_Data!R5C76:R67C76",63]
["w_03_07","=Analysis01_Data!R5C77:R67C77",63]
["w_03_08","=Analysis01_Data!R5C78:R67C78",63]
["w_03_09","=Analysis01_Data!R5C79:R67C79",63]
["w_03_10","=Analysis01_Data!R5C80:R67C80",63]
["w_03_11","=Analysis01_Data!R5C81:R67C81",63]
["w_03_12","=Analysis01_Data!R5C82:R67C82",63]
["w_04_02","=Analysis01_Data!R5C83:R67C83",63]
["w_06_00","=Analysis01_Data!R5C84:R67C84",63]
["w_09_00","=Analysis01_Data!R5C85:R67C85",63]
["w_10_00","=Analysis01_Data!R5C86:R67C86",63]
["w_11_01","=Analysis01_Data!R5C87:R67C87",63]
["w_11_02","=Analysis01_Data!R5C88:R67C88",63]
["w_12_00","=Analysis01_Data!R5C89:R67C89",63]
["w_14_01","=Analysis01_Data!R5C90:R67C90",63]
["w_14_02","=Analysis01_Data!R5C91:R67C91",63]
["w_14_03","=Analysis01_Data!R5C92:R67C92",63]
["w_14_04","=Analysis01_Data!R5C93:R67C93",63]
["w_14_05","=Analysis01_Data!R5C94:R67C94",63]
["w_14_06","=Analysis01_Data!R5C95:R67C95",63]
["w_14_07","=Analysis01_Data!R5C96:R67C96",63]
["w_14_08","=Analysis01_Data!R5C97:R67C97",63]
["w_14_09","=Analysis01_Data!R5C98:R67C98",63]
["w_18_01","=Analysis01_Data!R5C99:R67C99",63]
["w_18_02","=Analysis01_Data!R5C100:R67C100",63]
["w_21_00","=Analysis01_Data!R5C101:R67C101",63]
["w_24_02","=Analysis01_Data!R5C102:R67C102",63]
["w_25_01","=Analysis01_Data!R5C103:R67C103",63]
["w_25_02","=Analysis01_Data!R5C104:R67C104",63]
["w_25_03","=Analysis01_Data!R5C105:R67C105",63]
["w_25_04","=Analysis01_Data!R5C106:R67C106",63]
["w_25_05","=Analysis01_Data!R5C107:R67C107",63]
["w_25_06","=Analysis01_Data!R5C108:R67C108",63]
["w_26_00","=Analysis01_Data!R5C109:R67C109",63]
["w_28_01","=Analysis01_Data!R5C110:R67C110",63]
["w_29_00","=Analysis01_Data!R5C111:R67C111",63]
["w_30_00","=Analysis01_Data!R5C112:R67C112",63]
["w_37_01","=Analysis01_Data!R5C113:R67C113",63]
["w_37_02","=Analysis01_Data!R5C114:R67C114",63]
["w_37_03","=Analysis01_Data!R5C115:R67C115",63]
["w_37_04","=Analysis01_Data!R5C116:R67C116",63]
["w_37_05","=Analysis01_Data!R5C117:R67C117",63]
["w_37_06","=Analysis01_Data!R5C118:R67C118",63]
["w_37_07","=Analysis01_Data!R5C119:R67C119",63]