{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Table of Contents","Variables","DataEntrySheet","DataEntryBlockTemplate","Formulas_in_Template","Livelih_Lists","WASH_Lists","Shelter_Lists","FoodSec_Lists","Health_Lists","Education_Lists","Return_Lists","Protect_Lists","ListOfNamedRanges","AddNamesMacroCode"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":33,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Table of Contents","index":0,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Table of Contents"]
[]
["Sheet","Comment"]
["Variables","Listing of the DataEntrySheet fields, with comments"]
["DataEntrySheet","Preformatted records: 1 site-level + 8 sectors each with 1 synthesis and 7 problem records = 65 records per site."]
["DataEntryBlockTemplate","Macro button: Clicking in will add to the DataEntrySheet another set of 65 preformatted records, with automated record numbering."]
["Formulas_in_Template","Lists the formulas used in the DataEntryBlockTemplate"]
["Livelih_Lists","Sector specific listings of problems and recommendations, with dynamic named ranges that add new options to the EntrySheet drop-down menus."]
["WASH_Lists","Ditto"]
["Shelter_Lists","Ditto"]
["FoodSec_Lists","Ditto"]
["Health_Lists","Ditto"]
["Education_Lists","Ditto"]
["Return_Lists","Ditto"]
["Protect_Lists","Ditto"]
["ListOfNamedRanges","Listing of all named ranges in the workbook, with their formulas."]
["AddNamesMacroCode","Convenience table for VBA macro authors wanting to adjust dynamic names to a different data entry workbook. Concatenates elements of the Add Names command."]

{"sheet":"Variables","index":1,"n_rows":44,"n_cols":7,"rows_kept":44,"cut":false,"hidden":false,"merged":[[2,0,32,0],[33,0,36,0],[37,0,42,0]]}
["Level","Segments","ColNo","VarName","VarLabel","Comment1","Comment2"]
["Database","Identifiers, convenience tags and meta-data",1,"RecordNo","Record number","The basic unit is the combination of site, sector and problem","Initially as running number; ultimately must have unique values."]
["Site",null,2,"SiteNo","Site number","For every site, initially there are 64 empty records.","Unused records will later be deleted."]
[null,null,3,"Keep_record","Indicator to keep record when empty records are cleaned out.","Says \"Yes\" if record: 1. is a site-level record, 2. if it is a \"Synthesis\" record (even if no problems were recorded for this site-sector combination), or if 3. a problem was recorded. Else \"No\".","Uses formula =IF(OR(RC[1]=\"Yes\", RC[2]=\"Yes\", ISBLANK(RC[35])=FALSE),\"Yes\", \"No\"), to automatically update when a problem is recorded."]
[null,null,4,"Site_level_record","Indicator of the unique site-level indicator.","Tags one (the first) among all preformatted records for a site."]
[null,null,5,"Synthesis_record","Indicator of site-sector synthesis record"]
[null,null,6,"Assess_Team_ID","Assessment team ID"]
[null,null,7,"Date_Assessed","Assessement date"]
[null,"Administrative units",8,"Province","Province",null,"The values of these variables are identical for all records for a given site. They are entered only once, in the cells with a red border."]
[null,null,9,"District","District"]
[null,null,10,"Site_Name","Name of the site"]
[null,null,11,"Site_p_code","Site p-code"]
[null,"Site-level target group variables",12,"Site_category","Site category"]
[null,null,13,"Urban_Rural","Urban vs. Rural"]
[null,null,14,"Total_population","Total site population"]
[null,null,15,"Total_IDPs","Total IDPs"]
[null,null,16,"Target_Group","Target group"]
[null,null,17,"Gender","Gender"]
[null,"Other site-level variables (e.g. HESPER Scale)",18,"SiteVar100",null,"Site-level variable placeholder"]
[null,null,19,"SiteVar101",null,"Site-level variable placeholder"]
[null,null,20,"SiteVar102",null,"Site-level variable placeholder"]
[null,null,21,"Hesper01",null,"HESPER Scale variable placeholder"]
[null,null,22,"Hesper02",null,"HESPER Scale variable placeholder"]
[null,null,23,"Hesper03",null,"HESPER Scale variable placeholder"]
[null,"Priority sectors and interventions for the entire site",24,"PrioritySector_1","Sector given first priority for this site"]
[null,null,25,"Intervention1","Recommended intervention in this sector"]
[null,null,26,"AT_comment1","Assessment team comment"]
[null,null,27,"PrioritySector_2","Sector given second priority for this site"]
[null,null,28,"Intervention2","Recommended intervention in this sector"]
[null,null,29,"AT_comment2","Assessment team comment"]
[null,null,30,"PrioritySector_3","Sector given third priority for this site"]
[null,null,31,"Intervention3","Recommended intervention in this sector"]
[null,null,32,"AT_comment3","Assessment team comment"]
["Sector","Sectors and sector-level variables",33,"Sector","Sector"]
[null,null,34,"Synthesis","Indicator of site-sector synthesis record","Tags one (the last) among all reserved records for a sector within a site. Same as in column 4."]
[null,null,35,"SectorVar1",null,"Site-sector-level variable placeholder"]
[null,null,36,"SectorVar2",null,"Site-sector-level variable placeholder"]
["Problem","Problems, severity and specific recommendations",37,"Subsector","Subsector","To be used only when an agreed-upon subsector set exists"]
[null,null,38,"Problem","Problem","A separate record is used for each problem recorded","Controlled by drop-down menu. Options are set in the [Sector]_Lists."]
[null,null,39,"Severity","Severity","Severity rating. Highest number = most severe. Missing: leave blank."]
[null,null,40,"Recommendation","Recommendation",null,"Controlled by drop-down menu. Options are set in the [Sector]_Lists."]
[null,"Recoding space",41,"Problem_recoded","Problem (recoded)","Automatic recoding facility for problem, looking up a replacement term from the dictrionary in [Sector]_Lists"]
[null,null,42,"Recommend_Recoded","Recommendation (recoded)","Automatic recoding facility for recommendation, looking up a replacement term from the dictrionary in [Sector]_Lists"]
["Records, all","Include record in Pivot table",43,"Include","[To be renamed when used]","Placeholder for a substantive tag for records to be included/ excluded in Pivot tables.","To be renamed when used, for the purpose used. Use 1 instead of \"Yes\", 0 instead of \"No\", so that it can be summed in Pivot tables."]

{"sheet":"DataEntrySheet","index":2,"n_rows":2,"n_cols":43,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Identifiers, convenience tags and meta-data",null,null,null,null,null,null,"Administrative units",null,null,null,"Site-level target group variables",null,null,null,null,null,"Other site-level variables (e.g. HESPER Scale)",null,null,null,null,null,"Priority sectors and interventions for the entire site",null,null,null,null,null,null,null,null,"Sectors and sector-level variables",null,null,null,"Problems, severity and specific recommendations",null,null,null,"Recoding space",null,"Include record in Pivot table"]
["RecordNo","SiteNo","Keep_record","Site_level_record","Synthesis_record","Assess_Team_ID","Date_Assessed","Province","District","Site_Name","Site_p_code","Site_category","Urban_Rural","Total_population","Total_IDPs","Target_Group","Gender","SiteVar100","SiteVar101","SiteVar102","Hesper01","Hesper02","Hesper03","PrioritySector_1","Intervention1","AT_comment1","PrioritySector_2","Intervention2","AT_comment2","PrioritySector_3","Intervention3","AT_comment3","Sector","Synthesis","SectorVar1","SectorVar2","Subsector","Problem","Severity","Recommendation","Problem_recoded","Recommend_Recoded","Include"]

{"sheet":"DataEntryBlockTemplate","index":3,"n_rows":68,"n_cols":43,"rows_kept":68,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Clicking the macro button will add enough additional pre-formatted records to the \"DataEntrySheet\" for one more site assessment."]
["Identifiers, convenience tags and meta-data",null,null,null,null,null,null,"Administrative units",null,null,null,"Site-level target group variables",null,null,null,null,null,"Other site-level variables (e.g. HESPER Scale)",null,null,null,null,null,"Priority sectors and interventions for the entire site",null,null,null,null,null,null,null,null,"Sectors and sector-level variables",null,null,null,"Problems, severity and specific recommendations",null,null,null,"Recoding space",null,"Include record in Pivot table"]
["RecordNo","SiteNo","Keep_record","Site_level_record","Synthesis_record","Assess_Team_ID","Date_Assessed","Province","District","Site_Name","Site_p_code","Site_category","Urban_Rural","Total_population","Total_IDPs","Target_Group","Gender","SiteVar100","SiteVar101","SiteVar102","Hesper01","Hesper02","Hesper03","PrioritySector_1","Intervention1","AT_comment1","PrioritySector_2","Intervention2","AT_comment2","PrioritySector_3","Intervention3","AT_comment3","Sector","Synthesis","SectorVar1","SectorVar2","Subsector","Problem","Severity","Recommendation","Problem_recoded","Recommend_Recoded","Include"]
[{"$f":"IF(3:3=\"RecordNo\",1,A3+1)","v":1},null,{"$f":"IF(OR(D4=\"Yes\", E4=\"Yes\", ISBLANK(AL4)=FALSE),\"Yes\", \"No\")","v":"Yes"},"Yes","No",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,1]
[{"$f":"A4+1","v":2},null,{"$f":"IF(OR(D5=\"Yes\", E5=\"Yes\", ISBLANK(AL5)=FALSE),\"Yes\", \"No\")","v":"No"},"No","No",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,"Livelihood","No",null,null,null,null,null,null,{"$f":"VLOOKUP($AL5,RecodeLivelih,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($AN5,RecRecodLivelih,3,FALSE)","v":{"$error":"#N/A"}},1]
[{"$f":"A5+1","v":3},null,"No","No","No",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,"Livelihood","No",null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},1]
[4,null,"No","No","No",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,"Livelihood","No",null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},1]
[5,null,"No","No","No",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,"Livelihood","No",null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},1]
[6,null,"No","No","No",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,"Livelihood","No",null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},1]
[7,null,"No","No","No",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,"Livelihood","No",null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},1]
[8,null,"No","No","No",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,"Livelihood","No",null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},1]
[9,null,"Yes","No","Yes",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,"Livelihood","Yes",null,null,null,"Synthesis",null,null,"Synthesis",null,1]
[10,null,"No","No","No",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,"WASH","No",null,null,null,null,null,null,{"$f":"VLOOKUP($AL13,RecodeWASH,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($AN13,RecRecodWASH,3,FALSE)","v":{"$error":"#N/A"}},1]
[11,null,"No","No","No",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,"WASH","No",null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},1]
[12,null,"No","No","No",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,"WASH","No",null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},1]
[13,null,"No","No","No",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,"WASH","No",null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},1]
[14,null,"No","No","No",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,"WASH","No",null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},1]
[15,null,"No","No","No",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,"WASH","No",null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},1]
[16,null,"No","No","No",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,"WASH","No",null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},1]
[17,null,"Yes","No","Yes",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,"WASH","Yes",null,null,null,"Synthesis",null,null,"Synthesis",null,1]
[18,null,"No","No","No",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,"Shelter","No",null,null,null,null,null,null,{"$f":"VLOOKUP($AL21,RecodeShelter,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($AN21,RecRecodShelter,3,FALSE)","v":{"$error":"#N/A"}},1]
[19,null,"No","No","No",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,"Shelter","No",null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},1]
[20,null,"No","No","No",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,"Shelter","No",null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},1]
[21,null,"No","No","No",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,"Shelter","No",null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},1]
[22,null,"No","No","No",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,"Shelter","No",null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},1]
[23,null,"No","No","No",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,"Shelter","No",null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},1]
[24,null,"No","No","No",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,"Shelter","No",null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},1]
[25,null,"Yes","No","Yes",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,"Shelter","Yes",null,null,null,"Synthesis",null,null,"Synthesis",null,1]
[26,null,"No","No","No",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,"Food Security","No",null,null,null,null,null,null,{"$f":"VLOOKUP($AL29,RecodeFoodSec,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($AN29,RecRecodFoodSec,3,FALSE)","v":{"$error":"#N/A"}},1]
[27,null,"No","No","No",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,"Food Security","No",null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},1]
[28,null,"No","No","No",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,"Food Security","No",null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},1]
[29,null,"No","No","No",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,"Food Security","No",null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},1]
[30,null,"No","No","No",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,"Food Security","No",null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},1]
[31,null,"No","No","No",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,"Food Security","No",null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},1]
[32,null,"No","No","No",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,"Food Security","No",null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},1]
[33,null,"Yes","No","Yes",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,"Food Security","Yes",null,null,null,"Synthesis",null,null,"Synthesis",null,1]
[34,null,"No","No","No",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,"Health","No",null,null,null,null,null,null,{"$f":"VLOOKUP($AL37,RecodeHealth,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($AN37,RecRecodHealth,3,FALSE)","v":{"$error":"#N/A"}},1]
[35,null,"No","No","No",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,"Health","No",null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},1]
[36,null,"No","No","No",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,"Health","No",null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},1]
[37,null,"No","No","No",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,"Health","No",null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},1]
[38,null,"No","No","No",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,"Health","No",null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},1]
[39,null,"No","No","No",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,"Health","No",null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},1]
[40,null,"No","No","No",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,"Health","No",null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},1]
[41,null,"Yes","No","Yes",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,"Health","Yes",null,null,null,"Synthesis",null,null,"Synthesis",null,1]
[42,null,"No","No","No",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,"Education","No",null,null,null,null,null,null,{"$f":"VLOOKUP($AL45,RecodeEducation,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($AN45,RecRecodEducation,3,FALSE)","v":{"$error":"#N/A"}},1]
[43,null,"No","No","No",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,"Education","No",null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},1]
[44,null,"No","No","No",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,"Education","No",null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},1]
[45,null,"No","No","No",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,"Education","No",null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},1]
[46,null,"No","No","No",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,"Education","No",null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},1]
[47,null,"No","No","No",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,"Education","No",null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},1]
[48,null,"No","No","No",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,"Education","No",null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},1]
[49,null,"Yes","No","Yes",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,"Education","Yes",null,null,null,"Synthesis",null,null,"Synthesis",null,1]
[50,null,"No","No","No",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,"Return","No",null,null,null,null,null,null,{"$f":"VLOOKUP($AL53,RecodeReturn,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($AN53,RecRecodReturn,3,FALSE)","v":{"$error":"#N/A"}},1]
[51,null,"No","No","No",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,"Return","No",null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},1]
[52,null,"No","No","No",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,"Return","No",null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},1]
[53,null,"No","No","No",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,"Return","No",null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},1]
[54,null,"No","No","No",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,"Return","No",null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},1]
[55,null,"No","No","No",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,"Return","No",null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},1]
[56,null,"No","No","No",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,"Return","No",null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},1]
[57,null,"Yes","No","Yes",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,"Return","Yes",null,null,null,"Synthesis",null,null,"Synthesis",null,1]
[58,null,"No","No","No",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,"Protection","No",null,null,null,null,null,null,{"$f":"VLOOKUP($AL61,RecodeProtect,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($AN61,RecRecodProtect,3,FALSE)","v":{"$error":"#N/A"}},1]
[59,null,"No","No","No",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,"Protection","No",null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},1]
[60,null,"No","No","No",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,"Protection","No",null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},1]
[61,null,"No","No","No",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,"Protection","No",null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},1]
[62,null,"No","No","No",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,"Protection","No",null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},1]
[63,null,"No","No","No",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,"Protection","No",null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},1]
[64,null,"No","No","No",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,"Protection","No",null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},1]
[65,null,"Yes","No","Yes",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,"Protection","Yes",null,null,null,"Synthesis",null,null,"Synthesis",null,1]

{"sheet":"Formulas_in_Template","index":4,"n_rows":39,"n_cols":4,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["Address","Formula","ValueCurrent","Comment"]
["R5C41"," =VLOOKUP(RC38,RecodeLivelih,3,FALSE)",{"$error":"#N/A"},"Imports the corresponding recoded value of the \"Problem\" listed in the sheet Livelih_Lists"]
["R5C42"," =VLOOKUP(RC40,RecRecodLivelih,3,FALSE)",{"$error":"#N/A"},"Imports the corresponding recoded value of the \"Recommendations\" listed in the sheet Livelih_Lists"]
["R6C41"," =VLOOKUP(RC38,RecodeLivelih,3,FALSE)",{"$error":"#N/A"}]
["R6C42"," =VLOOKUP(RC40,RecRecodLivelih,3,FALSE)",{"$error":"#N/A"}]
[null,"Etc. until"]
["R11C41"," =VLOOKUP(RC38,RecodeLivelih,3,FALSE)",{"$error":"#N/A"}]
["R11C42"," =VLOOKUP(RC40,RecRecodLivelih,3,FALSE)",{"$error":"#N/A"},"Correspondingly, for the other sectors"]
["R13C41"," =VLOOKUP(RC38,RecodeWASH,3,FALSE)",{"$error":"#N/A"},"Etc."]
["R13C42"," =VLOOKUP(RC40,RecRecodWASH,3,FALSE)",{"$error":"#N/A"}]
[null,"Etc. until"]
["R19C41"," =VLOOKUP(RC38,RecodeWASH,3,FALSE)",{"$error":"#N/A"}]
["R19C42"," =VLOOKUP(RC40,RecRecodWASH,3,FALSE)",{"$error":"#N/A"}]
["R21C41"," =VLOOKUP(RC38,RecodeShelter,3,FALSE)",{"$error":"#N/A"}]
["R21C42"," =VLOOKUP(RC40,RecRecodShelter,3,FALSE)",{"$error":"#N/A"}]
[null,"Etc. until"]
["R27C41"," =VLOOKUP(RC38,RecodeShelter,3,FALSE)",{"$error":"#N/A"}]
["R27C42"," =VLOOKUP(RC40,RecRecodShelter,3,FALSE)",{"$error":"#N/A"}]
[null,"and likewise for the other sectors,"]
[null,"Etc. until"]
["R67C41"," =VLOOKUP(RC38,RecodeProtect,3,FALSE)",{"$error":"#N/A"}]
["R67C42"," =VLOOKUP(RC40,RecRecodProtect,3,FALSE)",{"$error":"#N/A"}]
["R4C1"," =IF(R[-1]=\"RecordNo\",1,R[-1]C+1)",1,"Sets the record number to 1 in the first record of the first site, else 1 + the previous record number."]
["R5C1"," =R[-1]C+1",2,"Sets the record number to 2 in the second record of the first site, else 1 + the previous record number."]
["R6C1"," =R[-1]C+1",3,"Etc."]
[null,"Etc. until"]
["R68C1"," =R[-1]C+1",65,"Currently 65 records are pre-formatted per site."]
["R4C3"," =IF(OR(RC[1]=\"Yes\", RC[2]=\"Yes\", ISBLANK(RC[35])=FALSE),\"Yes\", \"No\")","Yes","Keep_record: Site level record"]
["R5C3"," =IF(OR(RC[1]=\"Yes\", RC[2]=\"Yes\", ISBLANK(RC[35])=FALSE),\"Yes\", \"No\")","No","Keep_record: Problem level record (blank)"]
["R6C3"," =IF(OR(RC[1]=\"Yes\", RC[2]=\"Yes\", ISBLANK(RC[35])=FALSE),\"Yes\", \"No\")","No","Keep_record: Problem level record (blank)"]
["R7C3"," =IF(OR(RC[1]=\"Yes\", RC[2]=\"Yes\", ISBLANK(RC[35])=FALSE),\"Yes\", \"No\")","No","Keep_record: Problem level record (blank)"]
["R8C3"," =IF(OR(RC[1]=\"Yes\", RC[2]=\"Yes\", ISBLANK(RC[35])=FALSE),\"Yes\", \"No\")","No","Keep_record: Problem level record (blank)"]
["R9C3"," =IF(OR(RC[1]=\"Yes\", RC[2]=\"Yes\", ISBLANK(RC[35])=FALSE),\"Yes\", \"No\")","No","Keep_record: Problem level record (blank)"]
["R10C3"," =IF(OR(RC[1]=\"Yes\", RC[2]=\"Yes\", ISBLANK(RC[35])=FALSE),\"Yes\", \"No\")","No","Keep_record: Problem level record (blank)"]
["R11C3"," =IF(OR(RC[1]=\"Yes\", RC[2]=\"Yes\", ISBLANK(RC[35])=FALSE),\"Yes\", \"No\")","No","Keep_record: Problem level record (blank)"]
["R12C3"," =IF(OR(RC[1]=\"Yes\", RC[2]=\"Yes\", ISBLANK(RC[35])=FALSE),\"Yes\", \"No\")","Yes","Keep_record: Sector \"synthesis\" level record (blank)"]
[null,"Etc. until"]
["R67C3"," =IF(OR(RC[1]=\"Yes\", RC[2]=\"Yes\", ISBLANK(RC[35])=FALSE),\"Yes\", \"No\")","No","Keep_record: Last problem level record (blank) in template block"]
["R68C3"," =IF(OR(RC[1]=\"Yes\", RC[2]=\"Yes\", ISBLANK(RC[35])=FALSE),\"Yes\", \"No\")","Yes","Keep_record: Last sector \"synthesis\" level record (blank) in template block"]

{"sheet":"Livelih_Lists","index":5,"n_rows":3,"n_cols":8,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Problems","Frequency","Problems_Recoded",null,null,"Recommendations","Frequency","Recommend_Recoded"]
["DefineLivelihProblem1",{"$f":"COUNTIF(Problem,A2)","v":{"$error":"#NAME?"}},"RecodeProblem1",null,null,"DefineLivelihRecomm1",{"$f":"COUNTIF(Recommendation,F2)","v":{"$error":"#NAME?"}},"RecodeRecommendation1"]
["DefineLivelihProblem2",null,"RecodeProblem2",null,null,"DefineLivelihRecomm2",null,"RecodeRecommendation2"]

{"sheet":"WASH_Lists","index":6,"n_rows":3,"n_cols":8,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Problems","Frequency","Problems_Recoded",null,null,"Recommendations","Frequency","Recommend_Recoded"]
["DefineWASHProblem1",{"$f":"COUNTIF(Problem,A2)","v":{"$error":"#NAME?"}},"RecodeProblem1",null,null,"DefineWASHRecomm1",{"$f":"COUNTIF(Recommendation,F2)","v":{"$error":"#NAME?"}},"RecodeRecommendation1"]
["DefineWASHProblem2",null,"RecodeProblem2",null,null,"DefineWASHRecomm2",null,"RecodeRecommendation2"]

{"sheet":"Shelter_Lists","index":7,"n_rows":3,"n_cols":8,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Problems","Frequency","Problems_Recoded",null,null,"Recommendations","Frequency","Recommend_Recoded"]
["DefineShelterProblem1",{"$f":"COUNTIF(Problem,A2)","v":{"$error":"#NAME?"}},"RecodeProblem1",null,null,"DefineShelterRecomm1",{"$f":"COUNTIF(Recommendation,F2)","v":{"$error":"#NAME?"}},"RecodeRecommendation1"]
["DefineShelterProblem2",null,"RecodeProblem2",null,null,"DefineShelterRecomm2",null,"RecodeRecommendation2"]

{"sheet":"FoodSec_Lists","index":8,"n_rows":3,"n_cols":8,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Problems","Frequency","Problems_Recoded",null,null,"Recommendations","Frequency","Recommend_Recoded"]
["DefineFoodSecProblem1",{"$f":"COUNTIF(Problem,A2)","v":{"$error":"#NAME?"}},"RecodeProblem1",null,null,"DefineFoodSecRecomm1",{"$f":"COUNTIF(Recommendation,F2)","v":{"$error":"#NAME?"}},"RecodeRecommendation1"]
["DefineFoodSecProblem2",null,"RecodeProblem2",null,null,"DefineFoodSecRecomm2",null,"RecodeRecommendation2"]

{"sheet":"Health_Lists","index":9,"n_rows":3,"n_cols":8,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Problems","Frequency","Problems_Recoded",null,null,"Recommendations","Frequency","Recommend_Recoded"]
["DefineHealthProblem1",{"$f":"COUNTIF(Problem,A2)","v":{"$error":"#NAME?"}},"RecodeProblem1",null,null,"DefineHealthRecomm1",{"$f":"COUNTIF(Recommendation,F2)","v":{"$error":"#NAME?"}},"RecodeRecommendation1"]
["DefineHealthProblem2",null,"RecodeProblem2",null,null,"DefineHealthRecomm2",null,"RecodeRecommendation2"]

{"sheet":"Education_Lists","index":10,"n_rows":3,"n_cols":8,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Problems","Frequency","Problems_Recoded",null,null,"Recommendations","Frequency","Recommend_Recoded"]
["DefineEducationProblem1",{"$f":"COUNTIF(Problem,A2)","v":{"$error":"#NAME?"}},"RecodeProblem1",null,null,"DefineEducationRecomm1",{"$f":"COUNTIF(Recommendation,F2)","v":{"$error":"#NAME?"}},"RecodeRecommendation1"]
["DefineEducationProblem2",null,"RecodeProblem2",null,null,"DefineEducationRecomm2",null,"RecodeRecommendation2"]

{"sheet":"Return_Lists","index":11,"n_rows":3,"n_cols":8,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Problems","Frequency","Problems_Recoded",null,null,"Recommendations","Frequency","Recommend_Recoded"]
["DefineReturnProblem1",{"$f":"COUNTIF(Problem,A2)","v":{"$error":"#NAME?"}},"RecodeProblem1",null,null,"DefineReturnRecomm1",{"$f":"COUNTIF(Recommendation,F2)","v":{"$error":"#NAME?"}},"RecodeRecommendation1"]
["DefineReturnProblem2",null,"RecodeProblem2",null,null,"DefineReturnRecomm2",null,"RecodeRecommendation2"]

{"sheet":"Protect_Lists","index":12,"n_rows":3,"n_cols":8,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Problems","Frequency","Problems_Recoded",null,null,"Recommendations","Frequency","Recommend_Recoded"]
["DefineProtectProblem1",{"$f":"COUNTIF(Problem,A2)","v":{"$error":"#NAME?"}},"RecodeProblem1",null,null,"DefineProtectRecomm1",{"$f":"COUNTIF(Recommendation,F2)","v":{"$error":"#NAME?"}},"RecodeRecommendation1"]
["DefineProtectProblem2",null,"RecodeProblem2",null,null,"DefineProtectRecomm2",null,"RecodeRecommendation2"]

{"sheet":"ListOfNamedRanges","index":13,"n_rows":34,"n_cols":5,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Name","RefersToLocal","Visible","Cells_at_present","Comment"]
["BasicBlock","=DataEntryBlockTemplate!R4C1:R68C43",true,2795,"The template for the currently 65 empty records added at the bottom of the sheet \"DataEntrySheet\" when the macro \"AddBasicBlockToEntryTable\" is run."]
["ProblemsEducation","=OFFSET(Education_Lists!R2C1,0,0,COUNTA(Education_Lists!C1) - 1,1)",true,2,"Range dynamically updates as new elements added to list."]
["ProblemsFoodSec","=OFFSET(FoodSec_Lists!R2C1,0,0,COUNTA(FoodSec_Lists!C1) - 1,1)",true,2,"Ditto for all below using the function OFFSET."]
["ProblemsHealth","=OFFSET(Health_Lists!R2C1,0,0,COUNTA(Health_Lists!C1) - 1,1)",true,2]
["ProblemsLivelih","=OFFSET(Livelih_Lists!R2C1,0,0,COUNTA(Livelih_Lists!C1) - 1,1)",true,2]
["ProblemsProtect","=OFFSET(Protect_Lists!R2C1,0,0,COUNTA(Protect_Lists!C1) - 1,1)",true,2]
["ProblemsReturn","=OFFSET(Return_Lists!R2C1,0,0,COUNTA(Return_Lists!C1) - 1,1)",true,2]
["ProblemsShelter","=OFFSET(Shelter_Lists!R2C1,0,0,COUNTA(Shelter_Lists!C1) - 1,1)",true,2]
["ProblemsWASH","=OFFSET(WASH_Lists!R2C1,0,0,COUNTA(WASH_Lists!C1) - 1,1)",true,2]
["RecodeEducation","=OFFSET(Education_Lists!R2C1,0,0,COUNTA(Education_Lists!C1) - 1,3)",true,6]
["RecodeFoodSec","=OFFSET(FoodSec_Lists!R2C1,0,0,COUNTA(FoodSec_Lists!C1) - 1,3)",true,6]
["RecodeHealth","=OFFSET(Health_Lists!R2C1,0,0,COUNTA(Health_Lists!C1) - 1,3)",true,6]
["RecodeLivelih","=OFFSET(Livelih_Lists!R2C1,0,0,COUNTA(Livelih_Lists!C1) - 1,3)",true,6]
["RecodeProtect","=OFFSET(Protect_Lists!R2C1,0,0,COUNTA(Protect_Lists!C1) - 1,3)",true,6]
["RecodeReturn","=OFFSET(Return_Lists!R2C1,0,0,COUNTA(Return_Lists!C1) - 1,3)",true,6]
["RecodeShelter","=OFFSET(Shelter_Lists!R2C1,0,0,COUNTA(Shelter_Lists!C1) - 1,3)",true,6]
["RecodeWASH","=OFFSET(WASH_Lists!R2C1,0,0,COUNTA(WASH_Lists!C1) - 1,3)",true,6]
["RecommEducation","=OFFSET(Education_Lists!R2C6,0,0,COUNTA(Education_Lists!C6) - 1,1)",true,2]
["RecommFoodSec","=OFFSET(FoodSec_Lists!R2C6,0,0,COUNTA(FoodSec_Lists!C6) - 1,1)",true,2]
["RecommHealth","=OFFSET(Health_Lists!R2C6,0,0,COUNTA(Health_Lists!C6) - 1,1)",true,2]
["RecommLivelih","=OFFSET(Livelih_Lists!R2C6,0,0,COUNTA(Livelih_Lists!C6) - 1,1)",true,2]
["RecommProtect","=OFFSET(Protect_Lists!R2C6,0,0,COUNTA(Protect_Lists!C6) - 1,1)",true,2]
["RecommReturn","=OFFSET(Return_Lists!R2C6,0,0,COUNTA(Return_Lists!C6) - 1,1)",true,2]
["RecommShelter","=OFFSET(Shelter_Lists!R2C6,0,0,COUNTA(Shelter_Lists!C6) - 1,1)",true,2]
["RecommWASH","=OFFSET(WASH_Lists!R2C6,0,0,COUNTA(WASH_Lists!C6) - 1,1)",true,2]
["RecRecodEducation","=OFFSET(Education_Lists!R2C6,0,0,COUNTA(Education_Lists!C6) - 1,3)",true,6]
["RecRecodFoodSec","=OFFSET(FoodSec_Lists!R2C6,0,0,COUNTA(FoodSec_Lists!C6) - 1,3)",true,6]
["RecRecodHealth","=OFFSET(Health_Lists!R2C6,0,0,COUNTA(Health_Lists!C6) - 1,3)",true,6]
["RecRecodLivelih","=OFFSET(Livelih_Lists!R2C6,0,0,COUNTA(Livelih_Lists!C6) - 1,3)",true,6]
["RecRecodProtect","=OFFSET(Protect_Lists!R2C6,0,0,COUNTA(Protect_Lists!C6) - 1,3)",true,6]
["RecRecodReturn","=OFFSET(Return_Lists!R2C6,0,0,COUNTA(Return_Lists!C6) - 1,3)",true,6]
["RecRecodShelter","=OFFSET(Shelter_Lists!R2C6,0,0,COUNTA(Shelter_Lists!C6) - 1,3)",true,6]
["RecRecodWASH","=OFFSET(WASH_Lists!R2C6,0,0,COUNTA(WASH_Lists!C6) - 1,3)",true,6]

{"sheet":"AddNamesMacroCode","index":14,"n_rows":41,"n_cols":10,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["FixedCommandPart","FunctionInList","SectorAbbrev","RefersToFixedPart","SectorAbbrev","DynamicPart1","SectorAbbrev","DynamicPart2","Concatenation","StaticCopyForMacroCode"]
[]
["ActiveWorkbook.Names.Add Name:=\"","Problems","Livelih","\", RefersToR1C1:=\"=OFFSET(","Livelih","_Lists!R2C1,0,0,COUNTA(","Livelih","_Lists!C1) - 1,1)\"",{"$f":"CONCATENATE(A3,B3,C3,D3,E3,F3,G3,H3)","v":"ActiveWorkbook.Names.Add Name:=\"ProblemsLivelih\", RefersToR1C1:=\"=OFFSET(Livelih_Lists!R2C1,0,0,COUNTA(Livelih_Lists!C1) - 1,1)\""},"ActiveWorkbook.Names.Add Name:=\"ProblemsLivelih\", RefersToR1C1:=\"=OFFSET(Livelih_Lists!R2C1,0,0,COUNTA(Livelih_Lists!C1) - 1,1)\""]
["ActiveWorkbook.Names.Add Name:=\"","Recode","Livelih","\", RefersToR1C1:=\"=OFFSET(","Livelih","_Lists!R2C1,0,0,COUNTA(","Livelih","_Lists!C1) - 1,3)\"",{"$f":"CONCATENATE(A4,B4,C4,D4,E4,F4,G4,H4)","v":"ActiveWorkbook.Names.Add Name:=\"RecodeLivelih\", RefersToR1C1:=\"=OFFSET(Livelih_Lists!R2C1,0,0,COUNTA(Livelih_Lists!C1) - 1,3)\""},"ActiveWorkbook.Names.Add Name:=\"RecodeLivelih\", RefersToR1C1:=\"=OFFSET(Livelih_Lists!R2C1,0,0,COUNTA(Livelih_Lists!C1) - 1,3)\""]
["ActiveWorkbook.Names.Add Name:=\"","Recomm","Livelih","\", RefersToR1C1:=\"=OFFSET(","Livelih","_Lists!R2C6,0,0,COUNTA(","Livelih","_Lists!C6) - 1,1)\"","ActiveWorkbook.Names.Add Name:=\"RecommLivelih\", RefersToR1C1:=\"=OFFSET(Livelih_Lists!R2C6,0,0,COUNTA(Livelih_Lists!C6) - 1,1)\"","ActiveWorkbook.Names.Add Name:=\"RecommLivelih\", RefersToR1C1:=\"=OFFSET(Livelih_Lists!R2C6,0,0,COUNTA(Livelih_Lists!C6) - 1,1)\""]
["ActiveWorkbook.Names.Add Name:=\"","RecRecod","Livelih","\", RefersToR1C1:=\"=OFFSET(","Livelih","_Lists!R2C6,0,0,COUNTA(","Livelih","_Lists!C6) - 1,3)\"","ActiveWorkbook.Names.Add Name:=\"RecRecodLivelih\", RefersToR1C1:=\"=OFFSET(Livelih_Lists!R2C6,0,0,COUNTA(Livelih_Lists!C6) - 1,3)\"","ActiveWorkbook.Names.Add Name:=\"RecRecodLivelih\", RefersToR1C1:=\"=OFFSET(Livelih_Lists!R2C6,0,0,COUNTA(Livelih_Lists!C6) - 1,3)\""]
[]
["ActiveWorkbook.Names.Add Name:=\"","Problems","WASH","\", RefersToR1C1:=\"=OFFSET(","WASH","_Lists!R2C1,0,0,COUNTA(","WASH","_Lists!C1) - 1,1)\"",{"$f":"CONCATENATE(A8,B8,C8,D8,E8,F8,G8,H8)","v":"ActiveWorkbook.Names.Add Name:=\"ProblemsWASH\", RefersToR1C1:=\"=OFFSET(WASH_Lists!R2C1,0,0,COUNTA(WASH_Lists!C1) - 1,1)\""},"ActiveWorkbook.Names.Add Name:=\"ProblemsWASH\", RefersToR1C1:=\"=OFFSET(WASH_Lists!R2C1,0,0,COUNTA(WASH_Lists!C1) - 1,1)\""]
["ActiveWorkbook.Names.Add Name:=\"","Recode","WASH","\", RefersToR1C1:=\"=OFFSET(","WASH","_Lists!R2C1,0,0,COUNTA(","WASH","_Lists!C1) - 1,3)\"",{"$f":"CONCATENATE(A9,B9,C9,D9,E9,F9,G9,H9)","v":"ActiveWorkbook.Names.Add Name:=\"RecodeWASH\", RefersToR1C1:=\"=OFFSET(WASH_Lists!R2C1,0,0,COUNTA(WASH_Lists!C1) - 1,3)\""},"ActiveWorkbook.Names.Add Name:=\"RecodeWASH\", RefersToR1C1:=\"=OFFSET(WASH_Lists!R2C1,0,0,COUNTA(WASH_Lists!C1) - 1,3)\""]
["ActiveWorkbook.Names.Add Name:=\"","Recomm","WASH","\", RefersToR1C1:=\"=OFFSET(","WASH","_Lists!R2C6,0,0,COUNTA(","WASH","_Lists!C6) - 1,1)\"","ActiveWorkbook.Names.Add Name:=\"RecommWASH\", RefersToR1C1:=\"=OFFSET(WASH_Lists!R2C6,0,0,COUNTA(WASH_Lists!C6) - 1,1)\"","ActiveWorkbook.Names.Add Name:=\"RecommWASH\", RefersToR1C1:=\"=OFFSET(WASH_Lists!R2C6,0,0,COUNTA(WASH_Lists!C6) - 1,1)\""]
["ActiveWorkbook.Names.Add Name:=\"","RecRecod","WASH","\", RefersToR1C1:=\"=OFFSET(","WASH","_Lists!R2C6,0,0,COUNTA(","WASH","_Lists!C6) - 1,3)\"","ActiveWorkbook.Names.Add Name:=\"RecRecodWASH\", RefersToR1C1:=\"=OFFSET(WASH_Lists!R2C6,0,0,COUNTA(WASH_Lists!C6) - 1,3)\"","ActiveWorkbook.Names.Add Name:=\"RecRecodWASH\", RefersToR1C1:=\"=OFFSET(WASH_Lists!R2C6,0,0,COUNTA(WASH_Lists!C6) - 1,3)\""]
[]
["ActiveWorkbook.Names.Add Name:=\"","Problems","Shelter","\", RefersToR1C1:=\"=OFFSET(","Shelter","_Lists!R2C1,0,0,COUNTA(","Shelter","_Lists!C1) - 1,1)\"",{"$f":"CONCATENATE(A13,B13,C13,D13,E13,F13,G13,H13)","v":"ActiveWorkbook.Names.Add Name:=\"ProblemsShelter\", RefersToR1C1:=\"=OFFSET(Shelter_Lists!R2C1,0,0,COUNTA(Shelter_Lists!C1) - 1,1)\""},"ActiveWorkbook.Names.Add Name:=\"ProblemsShelter\", RefersToR1C1:=\"=OFFSET(Shelter_Lists!R2C1,0,0,COUNTA(Shelter_Lists!C1) - 1,1)\""]
["ActiveWorkbook.Names.Add Name:=\"","Recode","Shelter","\", RefersToR1C1:=\"=OFFSET(","Shelter","_Lists!R2C1,0,0,COUNTA(","Shelter","_Lists!C1) - 1,3)\"",{"$f":"CONCATENATE(A14,B14,C14,D14,E14,F14,G14,H14)","v":"ActiveWorkbook.Names.Add Name:=\"RecodeShelter\", RefersToR1C1:=\"=OFFSET(Shelter_Lists!R2C1,0,0,COUNTA(Shelter_Lists!C1) - 1,3)\""},"ActiveWorkbook.Names.Add Name:=\"RecodeShelter\", RefersToR1C1:=\"=OFFSET(Shelter_Lists!R2C1,0,0,COUNTA(Shelter_Lists!C1) - 1,3)\""]
["ActiveWorkbook.Names.Add Name:=\"","Recomm","Shelter","\", RefersToR1C1:=\"=OFFSET(","Shelter","_Lists!R2C6,0,0,COUNTA(","Shelter","_Lists!C6) - 1,1)\"","ActiveWorkbook.Names.Add Name:=\"RecommShelter\", RefersToR1C1:=\"=OFFSET(Shelter_Lists!R2C6,0,0,COUNTA(Shelter_Lists!C6) - 1,1)\"","ActiveWorkbook.Names.Add Name:=\"RecommShelter\", RefersToR1C1:=\"=OFFSET(Shelter_Lists!R2C6,0,0,COUNTA(Shelter_Lists!C6) - 1,1)\""]
["ActiveWorkbook.Names.Add Name:=\"","RecRecod","Shelter","\", RefersToR1C1:=\"=OFFSET(","Shelter","_Lists!R2C6,0,0,COUNTA(","Shelter","_Lists!C6) - 1,3)\"","ActiveWorkbook.Names.Add Name:=\"RecRecodShelter\", RefersToR1C1:=\"=OFFSET(Shelter_Lists!R2C6,0,0,COUNTA(Shelter_Lists!C6) - 1,3)\"","ActiveWorkbook.Names.Add Name:=\"RecRecodShelter\", RefersToR1C1:=\"=OFFSET(Shelter_Lists!R2C6,0,0,COUNTA(Shelter_Lists!C6) - 1,3)\""]
[]
["ActiveWorkbook.Names.Add Name:=\"","Problems","FoodSec","\", RefersToR1C1:=\"=OFFSET(","FoodSec","_Lists!R2C1,0,0,COUNTA(","FoodSec","_Lists!C1) - 1,1)\"",{"$f":"CONCATENATE(A18,B18,C18,D18,E18,F18,G18,H18)","v":"ActiveWorkbook.Names.Add Name:=\"ProblemsFoodSec\", RefersToR1C1:=\"=OFFSET(FoodSec_Lists!R2C1,0,0,COUNTA(FoodSec_Lists!C1) - 1,1)\""},"ActiveWorkbook.Names.Add Name:=\"ProblemsFoodSec\", RefersToR1C1:=\"=OFFSET(FoodSec_Lists!R2C1,0,0,COUNTA(FoodSec_Lists!C1) - 1,1)\""]
["ActiveWorkbook.Names.Add Name:=\"","Recode","FoodSec","\", RefersToR1C1:=\"=OFFSET(","FoodSec","_Lists!R2C1,0,0,COUNTA(","FoodSec","_Lists!C1) - 1,3)\"",{"$f":"CONCATENATE(A19,B19,C19,D19,E19,F19,G19,H19)","v":"ActiveWorkbook.Names.Add Name:=\"RecodeFoodSec\", RefersToR1C1:=\"=OFFSET(FoodSec_Lists!R2C1,0,0,COUNTA(FoodSec_Lists!C1) - 1,3)\""},"ActiveWorkbook.Names.Add Name:=\"RecodeFoodSec\", RefersToR1C1:=\"=OFFSET(FoodSec_Lists!R2C1,0,0,COUNTA(FoodSec_Lists!C1) - 1,3)\""]
["ActiveWorkbook.Names.Add Name:=\"","Recomm","FoodSec","\", RefersToR1C1:=\"=OFFSET(","FoodSec","_Lists!R2C6,0,0,COUNTA(","FoodSec","_Lists!C6) - 1,1)\"","ActiveWorkbook.Names.Add Name:=\"RecommFoodSec\", RefersToR1C1:=\"=OFFSET(FoodSec_Lists!R2C6,0,0,COUNTA(FoodSec_Lists!C6) - 1,1)\"","ActiveWorkbook.Names.Add Name:=\"RecommFoodSec\", RefersToR1C1:=\"=OFFSET(FoodSec_Lists!R2C6,0,0,COUNTA(FoodSec_Lists!C6) - 1,1)\""]
["ActiveWorkbook.Names.Add Name:=\"","RecRecod","FoodSec","\", RefersToR1C1:=\"=OFFSET(","FoodSec","_Lists!R2C6,0,0,COUNTA(","FoodSec","_Lists!C6) - 1,3)\"","ActiveWorkbook.Names.Add Name:=\"RecRecodFoodSec\", RefersToR1C1:=\"=OFFSET(FoodSec_Lists!R2C6,0,0,COUNTA(FoodSec_Lists!C6) - 1,3)\"","ActiveWorkbook.Names.Add Name:=\"RecRecodFoodSec\", RefersToR1C1:=\"=OFFSET(FoodSec_Lists!R2C6,0,0,COUNTA(FoodSec_Lists!C6) - 1,3)\""]
[]
["ActiveWorkbook.Names.Add Name:=\"","Problems","Health","\", RefersToR1C1:=\"=OFFSET(","Health","_Lists!R2C1,0,0,COUNTA(","Health","_Lists!C1) - 1,1)\"",{"$f":"CONCATENATE(A23,B23,C23,D23,E23,F23,G23,H23)","v":"ActiveWorkbook.Names.Add Name:=\"ProblemsHealth\", RefersToR1C1:=\"=OFFSET(Health_Lists!R2C1,0,0,COUNTA(Health_Lists!C1) - 1,1)\""},"ActiveWorkbook.Names.Add Name:=\"ProblemsHealth\", RefersToR1C1:=\"=OFFSET(Health_Lists!R2C1,0,0,COUNTA(Health_Lists!C1) - 1,1)\""]
["ActiveWorkbook.Names.Add Name:=\"","Recode","Health","\", RefersToR1C1:=\"=OFFSET(","Health","_Lists!R2C1,0,0,COUNTA(","Health","_Lists!C1) - 1,3)\"",{"$f":"CONCATENATE(A24,B24,C24,D24,E24,F24,G24,H24)","v":"ActiveWorkbook.Names.Add Name:=\"RecodeHealth\", RefersToR1C1:=\"=OFFSET(Health_Lists!R2C1,0,0,COUNTA(Health_Lists!C1) - 1,3)\""},"ActiveWorkbook.Names.Add Name:=\"RecodeHealth\", RefersToR1C1:=\"=OFFSET(Health_Lists!R2C1,0,0,COUNTA(Health_Lists!C1) - 1,3)\""]
["ActiveWorkbook.Names.Add Name:=\"","Recomm","Health","\", RefersToR1C1:=\"=OFFSET(","Health","_Lists!R2C6,0,0,COUNTA(","Health","_Lists!C6) - 1,1)\"","ActiveWorkbook.Names.Add Name:=\"RecommHealth\", RefersToR1C1:=\"=OFFSET(Health_Lists!R2C6,0,0,COUNTA(Health_Lists!C6) - 1,1)\"","ActiveWorkbook.Names.Add Name:=\"RecommHealth\", RefersToR1C1:=\"=OFFSET(Health_Lists!R2C6,0,0,COUNTA(Health_Lists!C6) - 1,1)\""]
["ActiveWorkbook.Names.Add Name:=\"","RecRecod","Health","\", RefersToR1C1:=\"=OFFSET(","Health","_Lists!R2C6,0,0,COUNTA(","Health","_Lists!C6) - 1,3)\"","ActiveWorkbook.Names.Add Name:=\"RecRecodHealth\", RefersToR1C1:=\"=OFFSET(Health_Lists!R2C6,0,0,COUNTA(Health_Lists!C6) - 1,3)\"","ActiveWorkbook.Names.Add Name:=\"RecRecodHealth\", RefersToR1C1:=\"=OFFSET(Health_Lists!R2C6,0,0,COUNTA(Health_Lists!C6) - 1,3)\""]
[]
["ActiveWorkbook.Names.Add Name:=\"","Problems","Education","\", RefersToR1C1:=\"=OFFSET(","Education","_Lists!R2C1,0,0,COUNTA(","Education","_Lists!C1) - 1,1)\"",{"$f":"CONCATENATE(A28,B28,C28,D28,E28,F28,G28,H28)","v":"ActiveWorkbook.Names.Add Name:=\"ProblemsEducation\", RefersToR1C1:=\"=OFFSET(Education_Lists!R2C1,0,0,COUNTA(Education_Lists!C1) - 1,1)\""},"ActiveWorkbook.Names.Add Name:=\"ProblemsEducation\", RefersToR1C1:=\"=OFFSET(Education_Lists!R2C1,0,0,COUNTA(Education_Lists!C1) - 1,1)\""]
["ActiveWorkbook.Names.Add Name:=\"","Recode","Education","\", RefersToR1C1:=\"=OFFSET(","Education","_Lists!R2C1,0,0,COUNTA(","Education","_Lists!C1) - 1,3)\"",{"$f":"CONCATENATE(A29,B29,C29,D29,E29,F29,G29,H29)","v":"ActiveWorkbook.Names.Add Name:=\"RecodeEducation\", RefersToR1C1:=\"=OFFSET(Education_Lists!R2C1,0,0,COUNTA(Education_Lists!C1) - 1,3)\""},"ActiveWorkbook.Names.Add Name:=\"RecodeEducation\", RefersToR1C1:=\"=OFFSET(Education_Lists!R2C1,0,0,COUNTA(Education_Lists!C1) - 1,3)\""]
["ActiveWorkbook.Names.Add Name:=\"","Recomm","Education","\", RefersToR1C1:=\"=OFFSET(","Education","_Lists!R2C6,0,0,COUNTA(","Education","_Lists!C6) - 1,1)\"","ActiveWorkbook.Names.Add Name:=\"RecommEducation\", RefersToR1C1:=\"=OFFSET(Education_Lists!R2C6,0,0,COUNTA(Education_Lists!C6) - 1,1)\"","ActiveWorkbook.Names.Add Name:=\"RecommEducation\", RefersToR1C1:=\"=OFFSET(Education_Lists!R2C6,0,0,COUNTA(Education_Lists!C6) - 1,1)\""]
["ActiveWorkbook.Names.Add Name:=\"","RecRecod","Education","\", RefersToR1C1:=\"=OFFSET(","Education","_Lists!R2C6,0,0,COUNTA(","Education","_Lists!C6) - 1,3)\"","ActiveWorkbook.Names.Add Name:=\"RecRecodEducation\", RefersToR1C1:=\"=OFFSET(Education_Lists!R2C6,0,0,COUNTA(Education_Lists!C6) - 1,3)\"","ActiveWorkbook.Names.Add Name:=\"RecRecodEducation\", RefersToR1C1:=\"=OFFSET(Education_Lists!R2C6,0,0,COUNTA(Education_Lists!C6) - 1,3)\""]
[]
["ActiveWorkbook.Names.Add Name:=\"","Problems","Return","\", RefersToR1C1:=\"=OFFSET(","Return","_Lists!R2C1,0,0,COUNTA(","Return","_Lists!C1) - 1,1)\"",{"$f":"CONCATENATE(A33,B33,C33,D33,E33,F33,G33,H33)","v":"ActiveWorkbook.Names.Add Name:=\"ProblemsReturn\", RefersToR1C1:=\"=OFFSET(Return_Lists!R2C1,0,0,COUNTA(Return_Lists!C1) - 1,1)\""},"ActiveWorkbook.Names.Add Name:=\"ProblemsReturn\", RefersToR1C1:=\"=OFFSET(Return_Lists!R2C1,0,0,COUNTA(Return_Lists!C1) - 1,1)\""]
["ActiveWorkbook.Names.Add Name:=\"","Recode","Return","\", RefersToR1C1:=\"=OFFSET(","Return","_Lists!R2C1,0,0,COUNTA(","Return","_Lists!C1) - 1,3)\"",{"$f":"CONCATENATE(A34,B34,C34,D34,E34,F34,G34,H34)","v":"ActiveWorkbook.Names.Add Name:=\"RecodeReturn\", RefersToR1C1:=\"=OFFSET(Return_Lists!R2C1,0,0,COUNTA(Return_Lists!C1) - 1,3)\""},"ActiveWorkbook.Names.Add Name:=\"RecodeReturn\", RefersToR1C1:=\"=OFFSET(Return_Lists!R2C1,0,0,COUNTA(Return_Lists!C1) - 1,3)\""]
["ActiveWorkbook.Names.Add Name:=\"","Recomm","Return","\", RefersToR1C1:=\"=OFFSET(","Return","_Lists!R2C6,0,0,COUNTA(","Return","_Lists!C6) - 1,1)\"","ActiveWorkbook.Names.Add Name:=\"RecommReturn\", RefersToR1C1:=\"=OFFSET(Return_Lists!R2C6,0,0,COUNTA(Return_Lists!C6) - 1,1)\"","ActiveWorkbook.Names.Add Name:=\"RecommReturn\", RefersToR1C1:=\"=OFFSET(Return_Lists!R2C6,0,0,COUNTA(Return_Lists!C6) - 1,1)\""]
["ActiveWorkbook.Names.Add Name:=\"","RecRecod","Return","\", RefersToR1C1:=\"=OFFSET(","Return","_Lists!R2C6,0,0,COUNTA(","Return","_Lists!C6) - 1,3)\"","ActiveWorkbook.Names.Add Name:=\"RecRecodReturn\", RefersToR1C1:=\"=OFFSET(Return_Lists!R2C6,0,0,COUNTA(Return_Lists!C6) - 1,3)\"","ActiveWorkbook.Names.Add Name:=\"RecRecodReturn\", RefersToR1C1:=\"=OFFSET(Return_Lists!R2C6,0,0,COUNTA(Return_Lists!C6) - 1,3)\""]
[]
["ActiveWorkbook.Names.Add Name:=\"","Problems","Protect","\", RefersToR1C1:=\"=OFFSET(","Protect","_Lists!R2C1,0,0,COUNTA(","Protect","_Lists!C1) - 1,1)\"",{"$f":"CONCATENATE(A38,B38,C38,D38,E38,F38,G38,H38)","v":"ActiveWorkbook.Names.Add Name:=\"ProblemsProtect\", RefersToR1C1:=\"=OFFSET(Protect_Lists!R2C1,0,0,COUNTA(Protect_Lists!C1) - 1,1)\""},"ActiveWorkbook.Names.Add Name:=\"ProblemsProtect\", RefersToR1C1:=\"=OFFSET(Protect_Lists!R2C1,0,0,COUNTA(Protect_Lists!C1) - 1,1)\""]
["ActiveWorkbook.Names.Add Name:=\"","Recode","Protect","\", RefersToR1C1:=\"=OFFSET(","Protect","_Lists!R2C1,0,0,COUNTA(","Protect","_Lists!C1) - 1,3)\"",{"$f":"CONCATENATE(A39,B39,C39,D39,E39,F39,G39,H39)","v":"ActiveWorkbook.Names.Add Name:=\"RecodeProtect\", RefersToR1C1:=\"=OFFSET(Protect_Lists!R2C1,0,0,COUNTA(Protect_Lists!C1) - 1,3)\""},"ActiveWorkbook.Names.Add Name:=\"RecodeProtect\", RefersToR1C1:=\"=OFFSET(Protect_Lists!R2C1,0,0,COUNTA(Protect_Lists!C1) - 1,3)\""]
["ActiveWorkbook.Names.Add Name:=\"","Recomm","Protect","\", RefersToR1C1:=\"=OFFSET(","Protect","_Lists!R2C6,0,0,COUNTA(","Protect","_Lists!C6) - 1,1)\"","ActiveWorkbook.Names.Add Name:=\"RecommProtect\", RefersToR1C1:=\"=OFFSET(Protect_Lists!R2C6,0,0,COUNTA(Protect_Lists!C6) - 1,1)\"","ActiveWorkbook.Names.Add Name:=\"RecommProtect\", RefersToR1C1:=\"=OFFSET(Protect_Lists!R2C6,0,0,COUNTA(Protect_Lists!C6) - 1,1)\""]
["ActiveWorkbook.Names.Add Name:=\"","RecRecod","Protect","\", RefersToR1C1:=\"=OFFSET(","Protect","_Lists!R2C6,0,0,COUNTA(","Protect","_Lists!C6) - 1,3)\"","ActiveWorkbook.Names.Add Name:=\"RecRecodProtect\", RefersToR1C1:=\"=OFFSET(Protect_Lists!R2C6,0,0,COUNTA(Protect_Lists!C6) - 1,3)\"","ActiveWorkbook.Names.Add Name:=\"RecRecodProtect\", RefersToR1C1:=\"=OFFSET(Protect_Lists!R2C6,0,0,COUNTA(Protect_Lists!C6) - 1,3)\""]