{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Cover","Info","Results","E01","E02","E03","E04","E05","E06","E07","E08","E09","E10","About"],"not_rendered":{"charts":11,"images":38,"macros":1,"external_links":0,"defined_names":15,"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":"Cover","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Info","index":1,"n_rows":39,"n_cols":4,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,0,0,16383],[38,1,38,3],[39,1,39,3],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[37,1,37,3],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,2]]}
[]
[]
[null,"This Assessment",null,"Response"]
[null,"City name:"]
[null,"Type of city (municipality, metropolitan areas, etc):"]
[null,"Country:"]
[null,"Date of assessment:"]
[]
[null,"City Profile (Required)","Response","Source Date"]
[null,"Title of the highest level of authority (e.g. Mayor, etc)"]
[null,"Total city population:   "]
[null,"City square kilometers:"]
[null,"Population density (per square kilometer): "]
[null,"Population that are youth (15-24) (%):"]
[null,"Population that are senior citizens (65+) (%):"]
[null,"Gender (female-headed households):"]
[null,"Literacy rate (% literate population):"]
[null,"Poverty rate (% population not in poverty):"]
[null,"Ave. household income (USD):"]
[null,"Residents who are not citizens (%):"]
[null,"Most likely (probable) known disaster risk: "]
[null,"Most severe disaster (known): "]
[]
[null,"City Profile (Optional)","Response","Source Date"]
[null,"Total number of households: "]
[null,"Persons per unit:"]
[null,"Cost of living (USD):"]
[null,"Country’s GDP per capita (USD)"]
[null,"Gini coefficient:"]
[null,"City product per capita (USD):"]
[]
[null,"Local Government Disaster Risk Reduction and Resilience Team",null,"Response"]
[null,"Name of person leading / coordinating completion of the scorecard assessment:"]
[null,"Organization: "]
[null,"Contact details:"]
[null,"Willingness to share results or be used as an example / case study by UNDRR and partners:"]
[]
[null,"Stakeholder Information"]
[null,"Please list  all stakeholders that have supported this assessment below."]

{"sheet":"Results","index":2,"n_rows":162,"n_cols":13,"rows_kept":162,"cut":false,"hidden":false,"merged":[[117,1,117,3],[101,2,101,5],[110,2,110,5],[109,2,109,5],[115,1,115,2],[34,2,34,5],[94,2,94,5],[95,2,95,5],[96,2,96,5],[41,2,41,5],[42,2,42,5],[44,2,44,5],[53,2,53,5],[60,2,60,5],[68,2,68,5],[58,3,58,6],[39,3,39,6],[66,3,66,6],[74,3,74,6],[82,3,82,6],[78,2,78,5],[76,2,76,5],[77,2,77,5],[83,2,83,5],[99,3,99,5],[107,3,107,6],[102,2,102,5],[103,2,103,5],[84,2,84,5],[85,2,85,5],[86,2,86,5],[133,10,133,11],[134,10,134,19],[135,10,135,19],[136,10,136,20],[137,10,137,15],[138,10,138,15],[140,10,140,13],[141,10,141,13],[142,10,142,19],[143,10,143,13],[144,10,144,16],[145,10,145,16],[147,10,147,13],[148,10,148,12],[149,10,149,12],[150,10,150,18],[151,10,151,15],[152,10,152,18],[154,10,154,20],[156,10,156,14],[157,11,157,12],[158,11,158,20],[159,11,159,20],[160,11,160,21],[161,11,161,16],[162,11,162,16],[164,11,164,14],[165,11,165,14],[166,11,166,20],[167,11,167,14],[168,11,168,17],[169,11,169,17],[171,11,171,14],[172,11,172,13],[173,11,173,13],[174,11,174,19],[175,11,175,16],[176,11,176,19],[178,11,178,21],[180,11,180,15],[70,2,70,5],[71,2,71,5],[43,2,43,5],[61,2,61,5],[62,2,62,5],[63,2,63,5],[69,2,69,5]]}
[]
[]
[]
[]
[null,{"$f":"Info!B4&\" \"&IF(Info!D4=\"\",\"\",Info!D4)","v":"City name: "}]
[]
[null,{"$f":"Info!B6&\" \"&IF(Info!D6=\"\",\"\",Info!D6)","v":"Country: "}]
[]
[null,{"$f":"Info!B7&\" \"&IF(Info!D7=\"\",\"\",Info!D7)","v":"Date of assessment: "}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Essential 01: ",null,{"$f":"D122","v":"Organise for Disaster Resilience - Integration of the food system and governance (Essential 1)"}]
[]
[null,{"$f":"C134","v":"A.1.1"},{"$f":"E134","v":"To what extent does/do the governance mechanism(s)  for disaster risk management\n integrate the full breadth of food system needs?"},null,null,null,{"$f":"F134","v":0}]
[]
[]
[]
[]
[null,"Essential 02: ",null,{"$f":"D123","v":"Identify, Understand and Use Current and Future Risk Scenarios - Integration of food availability and access emergencies in disaster scenarios (Essential 2)"}]
[]
[null,{"$f":"C135","v":"A2.1"},{"$f":"E135","v":"To what extent is food production, availability, storage and access included in disaster risk planning \nfor disease outbreaks, pandemics, water shortages and other outburst events? "},null,null,null,{"$f":"F135","v":0}]
[null,{"$f":"C136","v":"A2.2"},{"$f":"E136","v":"To what extent are the food system logistical impacts \nand traceability included in disaster scenario planning? "},null,null,null,{"$f":"F136","v":0}]
[null,{"$f":"C137","v":"A2.3"},{"$f":"E137","v":"To what extent are slow onset events such as sea-level rise, \nshifting of seasons and rainfall variability included in disaster planning and preparedness scenarios? "},null,null,null,{"$f":"F137","v":0}]
[null,{"$f":"C138","v":"A2.4"},{"$f":"E138","v":"To what extent are pre-existing chronic health issues, \nnutritional and allergy needs included in food system disaster planning scenarios? "},null,null,null,{"$f":"F138","v":0}]
[]
[]
[]
[]
[]
[]
[null,"Essential 03:",null,{"$f":"D124","v":"Strengthen Financial Capacity for Resilience - Integration of the food system and finances (Essential 3)"}]
[]
[null,{"$f":"C139","v":"A3.1"},{"$f":"E139","v":"To what extent is emergency and regular funding identified\nand available to address food system risks and impacts of disasters? "},null,null,null,{"$f":"F139","v":0}]
[]
[]
[]
[]
[null,"Essential 04:",null,{"$f":"D125","v":"Pursue Resilient Urban Development and Design - Integration of the food system and land use/building codes (Essential 4)"}]
[]
[null,{"$f":"C140","v":"A4.1"},{"$f":"E140","v":"To what extent does land management and zoning consider the need for \nagriculture, aquaculture, and other food production areas to be less vulnerable and have the ability to continue operating after a disaster?"},null,null,null,{"$f":"F140","v":0}]
[null,{"$f":"C141","v":"A4.2"},{"$f":"E141","v":"To what extent do land zoning and \npolicies support urban farming before, during and after disasters?"},null,null,null,{"$f":"F141","v":0}]
[null,{"$f":"C142","v":"A4.3"},{"$f":"E142","v":"To what extent are food system facilities compliant \nwith land zoning and building codes related to disaster resilience?"},null,null,null,{"$f":"F142","v":0}]
[null,{"$f":"C143","v":"A4.4"},{"$f":"E143","v":"To what extent are land management and zoning considering the \nneed to sustain and preserve agriculture and production areas before, during and after disasters?"},null,null,null,{"$f":"F143","v":0}]
[]
[]
[null,"Essential 05:",null,{"$f":"D126","v":"Safeguard Natural Buffers to Enhance Ecosystems’ Protective Functions - Integration of food system and ecosystem services (Essential 5)"}]
[]
[null,{"$f":"C144","v":"A5.1"},{"$f":"E144","v":"To what extent are ecosystem and nature-based solutions that support\n subsistent living and overall food system benefits identified and protected from disaster risks? "},null,null,null,{"$f":"F144","v":0}]
[null,{"$f":"C145","v":"A5.2"},{"$f":"E145","v":"To what extent are biological risks to ecosystems\n identified and strategies in place to mitigate impacts on food systems?"},null,null,null,{"$f":"F145","v":0}]
[null,{"$f":"C146","v":"A5.3"},{"$f":"E146","v":"To what extent are disaster risk reduction and \nclimate adaptation strategies integrated to support food system resilience?"},null,null,null,{"$f":"F146","v":0}]
[null,{"$f":"C147","v":"A5.4"},{"$f":"E147","v":"To what extent does the food system protect ecosystems? "},null,null,null,{"$f":"F147","v":0}]
[]
[]
[null,"Essential 06:",null,{"$f":"D127","v":"Strengthen Institutional Capacity for Resilience - Integration of the food system and institutional capacity (Essential 6)"}]
[]
[null,{"$f":"C148","v":"A6.1"},{"$f":"E148","v":"To what extent are food system actors with \nrelevant competencies and skills available before, during and after a disaster?"},null,null,null,{"$f":"F148","v":0}]
[null,{"$f":"C149","v":"A6.2"},{"$f":"E149","v":"To what extent is food system data on vulnerabilities, \ngender needs and resilience capacities shared with stakeholders? "},null,null,null,{"$f":"F149","v":0}]
[null,{"$f":"C150","v":"A6.3"},{"$f":"E150","v":"To what extent does institutional capacity exist to support \ncommunity-based solutions to improve food system resilience?"},null,null,null,{"$f":"F150","v":0}]
[]
[]
[]
[null,"Essential 07: ",null,{"$f":"D128","v":"Understand and Strengthen Societal Capacity for Resilience - Integration of public health and societal capacity"}]
[null,{"$f":"C151","v":"A7.1"},{"$f":"E151","v":"To what extent do communities understand and are able to fulfill their roles in maintaining food systems before, during and after a disaster? "},null,null,null,{"$f":"F151","v":0}]
[null,{"$f":"C152","v":"A7.2"},{"$f":"E152","v":"To what extent do communities receive and\n act upon information about food supply, safety and access? "},null,null,null,{"$f":"F152","v":0}]
[null,{"$f":"C153","v":"A7.3"},{"$f":"E153","v":"To what extent are communities’ food needs addressed before, during and after a disaster?"},null,null,null,{"$f":"F153","v":0}]
[null,{"$f":"C154","v":"A7.4"},{"$f":"E154","v":"To what extent are public education programs\nin place to empower communities and support food systems?"},null,null,null,{"$f":"F154","v":0}]
[]
[]
[]
[]
[]
[null,"Essential 08:",null,{"$f":"D129","v":"Increase Infrastructure Resilience - Integration of public health and infrastructure resilience (Essential 8)"}]
[]
[null,{"$f":"C155","v":"A8.1"},{"$f":"E155","v":"To what extent is food system infrastructure resilient? "},null,null,null,{"$f":"F155","v":0}]
[null,{"$f":"C156","v":"A8.2"},{"$f":"E156","v":"To what extent can emergency systems \nhandle a sudden demand in food? "},null,null,null,{"$f":"F156","v":0}]
[null,{"$f":"C157","v":"A8.3"},{"$f":"E157","v":"To what extent can food service delivery continue at critical places, \nsuch as schools, hospitals and shelters, before, during and after a disaster?"},null,null,null,{"$f":"F157","v":0}]
[]
[]
[null,"Essential 09:",null,{"$f":"D130","v":"Ensure Effective Disaster Response - Integration of the food system and disaster response (Essential 9)"}]
[]
[null,{"$f":"C158","v":"A9.1"},{"$f":"E158","v":"To what extent are early warning systems designed \nto prepare food system actors to take early action before an event happens?"},null,null,null,{"$f":"F158","v":0}]
[null,{"$f":"C159","v":"A9.2"},{"$f":"E159","v":"To what extent are food system actors \nintegrated with emergency management? "},null,null,null,{"$f":"F159","v":0}]
[null,{"$f":"C160","v":"A9.3"},{"$f":"E160","v":"To what extent can food supplies be provided \nto people in need before, during and after a disaster. "},null,null,null,{"$f":"F160","v":0}]
[]
[]
[]
[null,"Essential 10: ",null,{"$f":"D131","v":"Expedite Recovery and Build Back Better - Integration of the food system and recovery/building back better (Essential 10)"}]
[]
[null,{"$f":"C161","v":"A10.1"},{"$f":"E161","v":"To what extent do multi-stakeholder food system plans\n and strategies exist to mitigate long-term impacts? "},null,null,null,{"$f":"F161","v":0}]
[null,{"$f":"C162","v":"A10.2"},{"$f":"E162","v":"To what extent do formalized mechanisms to learn from the performance \nof the food system systems before, during and after disasters exist?"},null,null,null,{"$f":"F162","v":0}]
[]
[]
[]
[]
[null,{"$f":"TODAY()","v":"2023-01-30"},null,null,null,null,null,{"$f":"Info!$B$4","v":"City name:"},{"$f":"IF(Info!D4=\"\",\"\",Info!D4)","v":""},null,{"$f":"Info!$B$6","v":"Country:"},{"$f":"IF(Info!D6=\"\",\"\",Info!D6)","v":""}]
[]
[]
[]
[]
[null,null,"Label","Name",null,"Essential","TotalScore","MaxScore","Label"]
[null,null,"E1",{"$f":"\"Organise for Disaster Resilience - \"&'E01'!I3","v":"Organise for Disaster Resilience - Integration of the food system and governance (Essential 1)"},null,"E1",{"$f":"SUMIFS($F$134:$F$311,$B$134:$B$311,F122)","v":0},{"$f":"COUNTIFS($B$134:$B$163,F122)*5","v":5},"01",null,{"$f":"SUM(G122:G131)","v":0},{"$f":"K122/K123","v":0},{"$f":"CONCATENATE(\"The overall score for this assessment is \",SUM(G122:G131),\" / \",SUM(H122:H131))","v":"The overall score for this assessment is 0 / 145"}]
[null,null,"E2",{"$f":"\"Identify, Understand and Use Current and Future Risk Scenarios - \"&'E02'!I3","v":"Identify, Understand and Use Current and Future Risk Scenarios - Integration of food availability and access emergencies in disaster scenarios (Essential 2)"},null,"E2",0,20,"02",null,{"$f":"SUM(H122:H131)","v":145},{"$f":"1-L122","v":1}]
[null,null,"E3",{"$f":"\"Strengthen Financial Capacity for Resilience - \"&'E03'!I3","v":"Strengthen Financial Capacity for Resilience - Integration of the food system and finances (Essential 3)"},null,"E3",0,5,"03"]
[null,null,"E4",{"$f":"\"Pursue Resilient Urban Development and Design - \"&'E04'!I3","v":"Pursue Resilient Urban Development and Design - Integration of the food system and land use/building codes (Essential 4)"},null,"E4",0,20,"04"]
[null,null,"E5",{"$f":"\"Safeguard Natural Buffers to Enhance Ecosystems’ Protective Functions - \"&'E05'!I3","v":"Safeguard Natural Buffers to Enhance Ecosystems’ Protective Functions - Integration of food system and ecosystem services (Essential 5)"},null,"E5",0,20,"05"]
[null,null,"E6",{"$f":"\"Strengthen Institutional Capacity for Resilience - \"&'E06'!I3","v":"Strengthen Institutional Capacity for Resilience - Integration of the food system and institutional capacity (Essential 6)"},null,"E6",0,15,"06"]
[null,null,"E7","Understand and Strengthen Societal Capacity for Resilience - Integration of public health and societal capacity",null,"E7",0,20,"07"]
[null,null,"E8",{"$f":"\"Increase Infrastructure Resilience - \"&'E08'!I3","v":"Increase Infrastructure Resilience - Integration of public health and infrastructure resilience (Essential 8)"},null,"E8",0,15,"08"]
[null,null,"E9",{"$f":"\"Ensure Effective Disaster Response - \"&'E09'!I3","v":"Ensure Effective Disaster Response - Integration of the food system and disaster response (Essential 9)"},null,"E9",0,15,"09"]
[null,null,"E10",{"$f":"\"Expedite Recovery and Build Back Better - \"&'E10'!I3","v":"Expedite Recovery and Build Back Better - Integration of the food system and recovery/building back better (Essential 10)"},null,"E10",0,10,"10"]
[]
[null,"Section","Ref",null,"Question","SelectedScore","ThisScore"]
[null,"E1",{"$f":"'E01'!G$5","v":"A.1.1"},"The food system is part of multisector and multilevel disaster risk management governance","To what extent does/do the governance mechanism(s)  for disaster risk management\n integrate the full breadth of food system needs?",{"$f":"IF(G134=\"\",0,IF(G134=0,0,6-G134))","v":0},{"$f":"OFFSET('E01'!$E$1,MATCH(C134,'E01'!G:G,0)+3,0)","v":0},null,null,null,"Remarks: "]
[null,"E2",{"$f":"'E02'!$G$5","v":"A2.1"},"Inclusion of food system \nimpacts as a disaster scenario ","To what extent is food production, availability, storage and access included in disaster risk planning \nfor disease outbreaks, pandemics, water shortages and other outburst events? ",{"$f":"IF(G135=\"\",0,IF(G135=0,0,6-G135))","v":0},{"$f":"OFFSET('E02'!$E$1,MATCH(C135,'E02'!G:G,0)+3,0)","v":0},null,null,null,"- On this page, firstly fix from section/Ref/Question section downward to reflect all questions in this Scorecard"]
[null,"E2",{"$f":"'E02'!$G$18","v":"A2.2"},"Inclusion of food system logistical \nimpacts in  disaster scenarios","To what extent are the food system logistical impacts \nand traceability included in disaster scenario planning? ",{"$f":"IF(G136=\"\",0,IF(G136=0,0,6-G136))","v":0},{"$f":"OFFSET('E02'!$E$1,MATCH(C136,'E02'!G:G,0)+3,0)","v":0},null,null,null,"- Column G downward, must double check the formula.  (Formula = offset(reference, rows, cols, [height],[width])"]
[null,"E2",{"$f":"'E02'!$G$31","v":"A2.3"},"Slow onset events and their impacts on food systems are included\n in disaster planning and preparedness scenarios  ","To what extent are slow onset events such as sea-level rise, \nshifting of seasons and rainfall variability included in disaster planning and preparedness scenarios? ",{"$f":"IF(G137=\"\",0,IF(G137=0,0,6-G137))","v":0},{"$f":"OFFSET('E02'!$E$1,MATCH(C137,'E02'!G:G,0)+3,0)","v":0},null,null,null,"- Column F downward, must adjust the formula. If the scoring bar is between 0-3, use \"4\"; if the scoring is between 0-5, use \"6\""]
[null,"E2","A2.4","Inclusion of pre-existing chronic health issues, \nnutritional and allergy needs in food system disaster planning ","To what extent are pre-existing chronic health issues, \nnutritional and allergy needs included in food system disaster planning scenarios? ",{"$f":"IF(G138=\"\",0,IF(G138=0,0,6-G138))","v":0},{"$f":"OFFSET('E02'!$E$1,MATCH(C138,'E02'!G:G,0)+3,0)","v":0},null,null,null,"E.G., =IF(G127=\"\",0,IF(G127=0,0,4-G127)) is for 0-3 scoring bar"]
[null,"E3",{"$f":"'E03'!$G$5","v":"A3.1"},"Funding for food systems is part of \ndisaster resilience activities and plans? ","To what extent is emergency and regular funding identified\nand available to address food system risks and impacts of disasters? ",{"$f":"IF(G139=\"\",0,IF(G139=0,0,6-G139))","v":0},{"$f":"OFFSET('E03'!$E$1,MATCH(C139,'E03'!G:G,0)+3,0)","v":0},null,null,null,"E.G., =IF(G127=\"\",0,IF(G127=0,0,6-G127)) is for 0-5 scoring bar"]
[null,"E4",{"$f":"'E04'!$G$5","v":"A4.1"},"Land management and zoning for agriculture, \naquaculture, and other food production areas ","To what extent does land management and zoning consider the need for \nagriculture, aquaculture, and other food production areas to be less vulnerable and have the ability to continue operating after a disaster?",{"$f":"IF(G140=\"\",0,IF(G140=0,0,6-G140))","v":0},{"$f":"OFFSET('E04'!$E$1,MATCH(C140,'E04'!G:G,0)+3,0)","v":0}]
[null,"E4","A4.2","Land zoning and policies for urban farming  ","To what extent do land zoning and \npolicies support urban farming before, during and after disasters?",0,{"$f":"OFFSET('E04'!$E$1,MATCH(C141,'E04'!G:G,0)+3,0)","v":0},null,null,null,"-Then, work on total score / max score section"]
[null,"E4","A4.3","Food system compliance\n with land zoning and building codes ","To what extent are food system facilities compliant \nwith land zoning and building codes related to disaster resilience?",0,{"$f":"OFFSET('E04'!$E$1,MATCH(C142,'E04'!G:G,0)+3,0)","v":0},null,null,null,"- Check Column D for the Essential titles"]
[null,"E4","A4.4","Land management and zoning to sustain and \npreserve agricultural areas in disaster situations","To what extent are land management and zoning considering the \nneed to sustain and preserve agriculture and production areas before, during and after disasters?",0,{"$f":"OFFSET('E04'!$E$1,MATCH(C143,'E04'!G:G,0)+3,0)","v":0},null,null,null,"- Check Column G.  The formular should not need fixing. (=SUMIFS($F$126:$F$1002,$B$126:$B$1002,F114)"]
[null,"E5",{"$f":"'E05'!$G$5","v":"A5.1"},"Preservation and management of ecosystems\n that provide food system benefits ","To what extent are ecosystem and nature-based solutions that support\n subsistent living and overall food system benefits identified and protected from disaster risks? ",0,{"$f":"OFFSET('E05'!$E$1,MATCH(C144,'E05'!G:G,0)+3,0)","v":0},null,null,null,"- Check Column H Maximum Score"]
[null,"E5","A5.2","Management of ecosystem and\n biological risks that may affect food systems","To what extent are biological risks to ecosystems\n identified and strategies in place to mitigate impacts on food systems?",0,{"$f":"OFFSET('E05'!$E$1,MATCH(C145,'E05'!G:G,0)+3,0)","v":0},null,null,null,"- Use formular =COUNTIFS($B$126:$B$1002,F114)*3, if scoring bar is 0-3"]
[null,"E5","A5.3","Integration of disaster risk reduction and \nclimate adaption strategies to support food systems","To what extent are disaster risk reduction and \nclimate adaptation strategies integrated to support food system resilience?",0,{"$f":"OFFSET('E05'!$E$1,MATCH(C146,'E05'!G:G,0)+3,0)","v":0},null,null,null,"- Use formular =COUNTIFS($B$126:$B$1002,F114)*5, if scoring bar is 0-5"]
[null,"E5","A5.4","Food systems \nprotect ecosystems","To what extent does the food system protect ecosystems? ",0,{"$f":"OFFSET('E05'!$E$1,MATCH(C147,'E05'!G:G,0)+3,0)","v":0}]
[null,"E6",{"$f":"'E06'!$G$5","v":"A6.1"},"Availability of food system actors with \nrelevant competencies and skills for disaster resilience","To what extent are food system actors with \nrelevant competencies and skills available before, during and after a disaster?",0,{"$f":"OFFSET('E06'!$E$1,MATCH(C148,'E06'!G:G,0)+3,0)","v":0},null,null,null,"- Then adjust the result display area above"]
[null,"E6",{"$f":"'E06'!$G$18","v":"A6.2"},"Sharing of food system\n data with stakeholders ","To what extent is food system data on vulnerabilities, \ngender needs and resilience capacities shared with stakeholders? ",0,{"$f":"OFFSET('E06'!$E$1,MATCH(C149,'E06'!G:G,0)+3,0)","v":0},null,null,null,"- Fix the list of indicators"]
[null,"E6",{"$f":"'E06'!$G$31","v":"A6.3"},"Institutional capacity to support community-based \nsolutions to improve food system resilience","To what extent does institutional capacity exist to support \ncommunity-based solutions to improve food system resilience?",{"$f":"IF(G150=\"\",0,IF(G150=0,0,6-G150))","v":0},{"$f":"OFFSET('E06'!$E$1,MATCH(C150,'E06'!G:G,0)+3,0)","v":0},null,null,null,"- Apply appropriate chart types"]
[null,"E7",{"$f":"'E07'!$G$5","v":"A7.1"},"The ability of a community to maintain\n food systems before, during and after a disaster","To what extent do communities understand and are able to fulfill their roles in maintaining food systems before, during and after a disaster? ",{"$f":"IF(G151=\"\",0,IF(G151=0,0,6-G151))","v":0},{"$f":"OFFSET('E07'!$E$1,MATCH(C151,'E07'!G:G,0)+3,0)","v":0},null,null,null,"- Change chart's axis value (3 maximum for 0-3 scoring bar, and 5 maximum for 0-5 scoring bar)"]
[null,"E7",{"$f":"'E07'!$G$18","v":"A7.2"},"Community access and willingness to act \non information about food supply, safety, and access ","To what extent do communities receive and\n act upon information about food supply, safety and access? ",0,{"$f":"OFFSET('E07'!$E$1,MATCH(C152,'E07'!G:G,0)+3,0)","v":0},null,null,null,"- Adjust the chart diaplay alignment across all essentials, etc."]
[null,"E7",{"$f":"'E07'!$G$31","v":"A7.3"},"Community’s ability to address food system \nneeds before, during and after a disaster","To what extent are communities’ food needs addressed before, during and after a disaster?",0,{"$f":"OFFSET('E07'!$E$1,MATCH(C153,'E07'!G:G,0)+3,0)","v":0},null,null,null,"- View from 'Page Break Preview' and further adjust page layout to fit nicely in the print area"]
[null,"E7","A7.4","Public education programs \nand community empowerment","To what extent are public education programs\nin place to empower communities and support food systems?",0,{"$f":"OFFSET('E07'!$E$1,MATCH(C154,'E07'!G:G,0)+3,0)","v":0}]
[null,"E8",{"$f":"'E08'!$G$5","v":"A8.1"},"Strengthening the structural and\n non-structural aspects of food systems ","To what extent is food system infrastructure resilient? ",0,{"$f":"OFFSET('E08'!$E$1,MATCH(C155,'E08'!G:G,0)+3,0)","v":0},null,null,null,"- Replace the title part, copyright year with launch year, check other texts, and the overall diagram (adjust axis value if needed)"]
[null,"E8",{"$f":"'E08'!$G$18","v":"A8.2"},"Surge capacity for \nfood supply and access ","To what extent can emergency systems \nhandle a sudden demand in food? ",{"$f":"IF(G156=\"\",0,IF(G156=0,0,6-G156))","v":0},{"$f":"OFFSET('E08'!$E$1,MATCH(C156,'E08'!G:G,0)+3,0)","v":0}]
[null,"E8",{"$f":"'E08'!$G$31","v":"A8.3"},"Continuity of food service \ndelivery to critical places","To what extent can food service delivery continue at critical places, \nsuch as schools, hospitals and shelters, before, during and after a disaster?",0,{"$f":"OFFSET('E08'!$E$1,MATCH(C157,'E08'!G:G,0)+3,0)","v":0},null,null,null,"- Once done, change font color in this section to white"]
[null,"E9",{"$f":"'E09'!$G$5","v":"A9.1"},"Early warning systems \nfor food system actors ","To what extent are early warning systems designed \nto prepare food system actors to take early action before an event happens?",0,{"$f":"OFFSET('E09'!$E$1,MATCH(C158,'E09'!G:G,0)+3,0)","v":0}]
[null,"E9",{"$f":"'E09'!$G$18","v":"A9.2"},"Integration of the food system \nactors with emergency management ","To what extent are food system actors \nintegrated with emergency management? ",0,{"$f":"OFFSET('E09'!$E$1,MATCH(C159,'E09'!G:G,0)+3,0)","v":0}]
[null,"E9",{"$f":"'E09'!$G$31","v":"A9.3"},"Ability to deliver food supplies to people in need","To what extent can food supplies be provided \nto people in need before, during and after a disaster. ",0,{"$f":"OFFSET('E09'!$E$1,MATCH(C160,'E09'!G:G,0)+3,0)","v":0}]
[null,"E10",{"$f":"'E10'!$G$5","v":"A10.1"},"Mitigating long-term impacts on the food system and well-being","To what extent do multi-stakeholder food system plans\n and strategies exist to mitigate long-term impacts? ",{"$f":"IF(G161=\"\",0,IF(G161=0,0,6-G161))","v":0},{"$f":"OFFSET('E10'!$E$1,MATCH(C161,'E10'!G:G,0)+3,0)","v":0}]
[null,"E10",{"$f":"'E10'!$G$18","v":"A10.2"},"Learning and improving ","To what extent do formalized mechanisms to learn from the performance \nof the food system systems before, during and after disasters exist?",0,{"$f":"OFFSET('E10'!$E$1,MATCH(C162,'E10'!G:G,0)+3,0)","v":0}]

{"sheet":"E01","index":3,"n_rows":38,"n_cols":9,"rows_kept":38,"cut":false,"hidden":false,"merged":[[4,2,4,3],[5,2,5,3],[6,2,6,3],[7,2,7,3],[8,2,13,3]]}
[]
[]
[null,"A.1 Integration of public health and governance (Essential 1)",null,null,null,null,{"$f":"TRIM(LEFT(B3,3))","v":"A.1"},null,"Integration of the food system and governance (Essential 1)"]
[]
[null,"A.1.1 The food system is part of multisector and multilevel disaster risk management governance",null,null,null,null,{"$f":"TRIM(LEFT(B5,6))","v":"A.1.1"},null,"The food system is part of multisector and multilevel disaster risk management governance"]
[null,"Question","Comments"]
[]
[null,"Response","Provide means of verification (explanation and evidence)"]
[null," ",null,null,null,{"$f":"IF(E9=1,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E9=2,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E9=3,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E9=4,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E9=5,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E9=6,TRUE,FALSE)","v":false}]
[null,"Actions to achieve maximum resilience","Responsible institution","Timescale"]
[null,null,null,null,null,null,{"$f":"TRIM(LEFT(B16,6))","v":""},null,{"$f":"TRIM(MID(B16,6,120))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"LEFT(B27,5)","v":""},null,{"$f":"TRIM(MID(B27,6,120))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"LEFT(B38,5)","v":""},null,{"$f":"TRIM(MID(B38,6,120))","v":""}]

{"sheet":"E02","index":4,"n_rows":54,"n_cols":9,"rows_kept":54,"cut":false,"hidden":false,"merged":[[44,2,44,3],[45,2,45,3],[46,2,46,3],[47,2,52,3],[5,2,5,3],[6,2,6,3],[7,2,7,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[8,2,13,3],[21,2,26,3],[34,2,39,3],[31,2,31,3],[32,2,32,3],[33,2,33,3]]}
[]
[]
[null,"A.2 Integration of food availability and access emergencies in disaster scenarios (Essential 2)",null,null,null,null,"A2",null,"Integration of food availability and access emergencies in disaster scenarios (Essential 2)"]
[]
[null,"A2.1 Inclusion of food system impacts as a disaster scenario ",null,null,null,null,"A2.1",null,"Inclusion of food system impacts as a disaster scenario "]
[null,"Question","Comments"]
[]
[null,"Response","Provide means of verification (explanation and evidence)"]
[null,null,null,null,null,{"$f":"IF(E9=1,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E9=2,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E9=3,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E9=4,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E9=5,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E9=6,TRUE,FALSE)","v":false}]
[null,"Actions to achieve maximum resilience","Responsible institution","Timescale"]
[]
[]
[null,"A2.2 Inclusion of food system logistical impacts in  disaster scenarios",null,null,null,null,"A2.2",null,"Inclusion of food system logistical impacts in  disaster scenarios"]
[null,"Question","Comments"]
[]
[null,"Response","Provide means of verification (explanation and evidence)"]
[null,null,null,null,null,{"$f":"IF(E22=1,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E22=2,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E22=3,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E22=4,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E22=5,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E22=6,TRUE,FALSE)","v":false}]
[null,"Actions to achieve maximum resilience","Responsible institution","Timescale"]
[]
[]
[null,"A2.3 Slow onset events and their impacts on food systems are included in disaster planning and preparedness scenarios  ",null,null,null,null,"A2.3",null,"Slow onset events and their impacts on food systems are included in disaster planning and preparedness scenarios "]
[null,"Question","Comments"]
[]
[null,"Response","Provide means of verification (explanation and evidence)"]
[null,null,null,null,null,{"$f":"IF(E35=1,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E35=2,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E35=3,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E35=4,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E35=5,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E35=6,TRUE,FALSE)","v":false}]
[null,"Actions to achieve maximum resilience","Responsible institution","Timescale"]
[]
[]
[null,"A2.4 Inclusion of pre-existing chronic health issues, nutritional and allergy needs in food system disaster planning ",null,null,null,null,"A2.4",null,"Inclusion of pre-existing chronic health issues, nutritional and allergy needs in food system disaster planning "]
[null,"Question","Comments"]
[]
[null,"Response","Provide means of verification (explanation and evidence)"]
[null,null,null,null,null,{"$f":"IF(E48=1,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E48=2,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E48=3,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E48=4,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E48=5,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E48=6,TRUE,FALSE)","v":false}]
[null,"Actions to achieve maximum resilience","Responsible institution","Timescale"]

{"sheet":"E03","index":5,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[4,1,4,3],[5,2,5,3],[6,2,6,3],[7,2,7,3],[8,2,13,3]]}
[]
[]
[null,"A3 Integration of the food system and finances (Essential 3)",null,null,null,null,"A3",null,"Integration of the food system and finances (Essential 3)"]
[]
[null,"A3.1 Funding for food systems is part of disaster resilience activities and plans? ",null,null,null,null,"A3.1",null,"Funding for food systems is part of disaster resilience activities and plans? "]
[null,"Question","Comments"]
[]
[null,"Response","Provide means of verification (explanation and evidence)"]
[null,null,null,null,null,{"$f":"IF(E9=1,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E9=2,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E9=3,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E9=4,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E9=5,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E9=6,TRUE,FALSE)","v":false}]
[null,"Actions to achieve maximum resilience","Responsible institution","Timescale"]

{"sheet":"E04","index":6,"n_rows":54,"n_cols":9,"rows_kept":54,"cut":false,"hidden":false,"merged":[[17,1,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[21,2,26,3],[4,1,4,3],[5,2,5,3],[6,2,6,3],[7,2,7,3],[8,2,13,3],[30,1,30,3],[31,2,31,3],[32,2,32,3],[33,2,33,3],[34,2,39,3],[43,1,43,3],[44,2,44,3],[45,2,45,3],[46,2,46,3],[47,2,52,3]]}
[]
[]
[null,"A4 Integration of the food system and land use/building codes (Essential 4)",null,null,null,null,"A4",null,"Integration of the food system and land use/building codes (Essential 4)"]
[]
[null,"A4.1 Land management and zoning for agriculture, aquaculture, and other food production areas  ",null,null,null,null,"A4.1",null,"Land management and zoning for agriculture, aquaculture, and other food production areas "]
[null,"Question","Comments"]
[]
[null,"Response","Provide means of verification (explanation and evidence)"]
[null,null,null,null,null,{"$f":"IF(E9=1,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E9=2,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E9=3,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E9=4,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E9=5,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E9=6,TRUE,FALSE)","v":false}]
[null,"Actions to achieve maximum resilience","Responsible institution","Timescale"]
[]
[]
[null,"A4.2 Land zoning and policies for urban farming  ",null,null,null,null,"A4.2",null,"Land zoning and policies for urban farming  "]
[null,"Question","Comments"]
[]
[null,"Response","Provide means of verification (explanation and evidence)"]
[null,null,null,null,null,{"$f":"IF(E22=1,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E22=2,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E22=3,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E22=4,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E22=5,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E22=6,TRUE,FALSE)","v":false}]
[null,"Actions to achieve maximum resilience","Responsible institution","Timescale"]
[]
[]
[null,"A4.3 Food system compliance with land zoning and building codes ",null,null,null,null,"A4.3",null,"Food system compliance with land zoning and building codes "]
[null,"Question","Comments"]
[]
[null,"Response","Provide means of verification (explanation and evidence)"]
[null,null,null,null,null,{"$f":"IF(E35=1,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E35=2,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E35=3,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E35=4,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E35=5,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E35=6,TRUE,FALSE)","v":false}]
[null,"Actions to achieve maximum resilience","Responsible institution","Timescale"]
[]
[]
[null,"A4.4 Land management and zoning to sustain and preserve agricultural areas in disaster situations",null,null,null,null,"A4.4",null,"Land management and zoning to sustain and preserve agricultural areas in disaster situations"]
[null,"Question","Comments"]
[]
[null,"Response","Provide means of verification (explanation and evidence)"]
[null,null,null,null,null,{"$f":"IF(E48=1,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E48=2,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E48=3,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E48=4,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E48=5,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E48=6,TRUE,FALSE)","v":false}]
[null,"Actions to achieve maximum resilience","Responsible institution","Timescale"]

{"sheet":"E05","index":7,"n_rows":54,"n_cols":9,"rows_kept":54,"cut":false,"hidden":false,"merged":[[4,1,4,3],[5,2,5,3],[6,2,6,3],[7,2,7,3],[8,2,13,3],[17,1,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[21,2,26,3],[30,1,30,3],[31,2,31,3],[32,2,32,3],[33,2,33,3],[34,2,39,3],[43,1,43,3],[44,2,44,3],[45,2,45,3],[46,2,46,3],[47,2,52,3]]}
[]
[]
[null,"A5 Integration of food system and ecosystem services (Essential 5)",null,null,null,null,"A5",null,"Integration of food system and ecosystem services (Essential 5)"]
[]
[null,"A5.1 Preservation and management of ecosystems that provide food system benefits",null,null,null,null,"A5.1",null,"Preservation and management of ecosystems that provide food system benefits "]
[null,"Question","Comments"]
[]
[null,"Response","Provide means of verification (explanation and evidence)"]
[null,null,null,null,null,{"$f":"IF(E9=1,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E9=2,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E9=3,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E9=4,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E9=5,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E9=6,TRUE,FALSE)","v":false}]
[null,"Actions to achieve maximum resilience","Responsible institution","Timescale"]
[]
[]
[null,"A5.2 Management of ecosystem and biological risks that may affect food systems",null,null,null,null,"A5.2",null,"Management of ecosystem and biological risks that may affect food systems"]
[null,"Question","Comments"]
[]
[null,"Response","Provide means of verification (explanation and evidence)"]
[null,null,null,null,null,{"$f":"IF(E22=1,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E22=2,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E22=3,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E22=4,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E22=5,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E22=6,TRUE,FALSE)","v":false}]
[null,"Actions to achieve maximum resilience","Responsible institution","Timescale"]
[]
[]
[null,"A5.3 Integration of disaster risk reduction and climate adaption strategies to support food systems",null,null,null,null,"A5.3",null,"Integration of disaster risk reduction and climate adaption strategies to support food systems"]
[null,"Question","Comments"]
[]
[null,"Response","Provide means of verification (explanation and evidence)"]
[null,null,null,null,null,{"$f":"IF(E35=1,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E35=2,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E35=3,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E35=4,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E35=5,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E35=6,TRUE,FALSE)","v":false}]
[null,"Actions to achieve maximum resilience","Responsible institution","Timescale"]
[]
[]
[null,"A5.4 Food systems protect ecosystems",null,null,null,null,"A5.4",null,"Food systems protect ecosystems"]
[null,"Question","Comments"]
[]
[null,"Response","Provide means of verification (explanation and evidence)"]
[null,null,null,null,null,{"$f":"IF(E48=1,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E48=2,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E48=3,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E48=4,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E48=5,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E48=6,TRUE,FALSE)","v":false}]
[null,"Actions to achieve maximum resilience","Responsible institution","Timescale"]

{"sheet":"E06","index":8,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[[4,1,4,3],[5,2,5,3],[6,2,6,3],[7,2,7,3],[17,1,17,3],[8,2,13,3],[18,2,18,3],[34,2,39,3],[21,2,26,3],[19,2,19,3],[20,2,20,3],[30,1,30,3],[31,2,31,3],[32,2,32,3],[33,2,33,3]]}
[]
[]
[null,"A6 Integration of the food system and institutional capacity (Essential 6)",null,null,null,null,"A6",null,"Integration of the food system and institutional capacity (Essential 6)"]
[]
[null,"A6.1 Availability of food system actors with relevant competencies and skills for disaster resilience",null,null,null,null,"A6.1",null,"Availability of food system actors with relevant competencies and skills for disaster resilience"]
[null,"Question","Comments"]
[]
[null,"Response","Provide means of verification (explanation and evidence)"]
[null,null,null,null,null,{"$f":"IF(E9=1,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E9=2,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E9=3,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E9=4,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E9=5,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E9=6,TRUE,FALSE)","v":false}]
[null,"Actions to achieve maximum resilience","Responsible institution","Timescale"]
[]
[]
[null,"A6.2 Sharing of food system data with stakeholders",null,null,null,null,"A6.2",null,"Sharing of food system data with stakeholders "]
[null,"Question","Comments"]
[]
[null,"Response","Provide means of verification (explanation and evidence)"]
[null,null,null,null,null,{"$f":"IF(E22=1,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E22=2,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E22=3,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E22=4,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E22=5,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E22=6,TRUE,FALSE)","v":false}]
[null,"Actions to achieve maximum resilience","Responsible institution","Timescale"]
[]
[]
[null,"A6.3 Institutional capacity to support community-based solutions to improve food system resilience",null,null,null,null,"A6.3",null,"Institutional capacity to support community-based solutions to improve food system resilience"]
[null,"Question","Comments"]
[]
[null,"Response","Provide means of verification (explanation and evidence)"]
[null,null,null,null,null,{"$f":"IF(E35=1,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E35=2,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E35=3,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E35=4,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E35=5,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E35=6,TRUE,FALSE)","v":false}]
[null,"Actions to achieve maximum resilience","Responsible institution","Timescale"]

{"sheet":"E07","index":9,"n_rows":55,"n_cols":9,"rows_kept":55,"cut":false,"hidden":false,"merged":[[4,1,4,3],[5,2,5,3],[6,2,6,3],[7,2,7,3],[17,1,17,3],[18,2,18,3],[8,2,13,3],[21,2,26,3],[34,2,39,3],[19,2,19,3],[20,2,20,3],[30,1,30,3],[31,2,31,3],[32,2,32,3],[33,2,33,3],[43,1,43,3],[44,2,44,3],[45,2,45,3],[46,2,46,3],[47,2,52,3]]}
[]
[]
[null,"A7 Integration of food system and societal capacity (Essential 7)",null,null,null,null,"A7",null,"Integration of public health and societal capacity (Essential 7)"]
[null,null,null,null,null,null,""]
[null,"A7.1 The ability of a community to maintain food systems before, during and after a disaster",null,null,null,null,"A7.1",null,"Integration of the food system and societal capacity"]
[null,"Question","Comments",null,null,null,""]
[null,null,null,null,null,null,""]
[null,"Response","Provide means of verification (explanation and evidence)",null,null,null,""]
[null,null,null,null,null,{"$f":"IF(E9=1,TRUE,FALSE)","v":false},""]
[null,null,null,null,null,{"$f":"IF(E9=2,TRUE,FALSE)","v":false},""]
[null,null,null,null,null,{"$f":"IF(E9=3,TRUE,FALSE)","v":false},""]
[null,null,null,null,null,{"$f":"IF(E9=4,TRUE,FALSE)","v":false},""]
[null,null,null,null,null,{"$f":"IF(E9=5,TRUE,FALSE)","v":false},""]
[null,null,null,null,null,{"$f":"IF(E9=6,TRUE,FALSE)","v":false},""]
[null,"Actions to achieve maximum resilience","Responsible institution","Timescale",null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,"A7.2 Community access and willingness to act on information about food supply, safety, and access",null,null,null,null,"A7.2",null,"Community access and willingness to act on information about food supply, safety, and access "]
[null,"Question","Comments",null,null,null,""]
[null,null,null,null,null,null,""]
[null,"Response","Provide means of verification (explanation and evidence)",null,null,null,""]
[null,null,null,null,null,{"$f":"IF(E22=1,TRUE,FALSE)","v":false},""]
[null,null,null,null,null,{"$f":"IF(E22=2,TRUE,FALSE)","v":false},""]
[null,null,null,null,null,{"$f":"IF(E22=3,TRUE,FALSE)","v":false},""]
[null,null,null,null,null,{"$f":"IF(E22=4,TRUE,FALSE)","v":false},""]
[null,null,null,null,null,{"$f":"IF(E22=5,TRUE,FALSE)","v":false},""]
[null,null,null,null,null,{"$f":"IF(E22=6,TRUE,FALSE)","v":false},""]
[null,"Actions to achieve maximum resilience","Responsible institution","Timescale",null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,"A7.3 Community’s ability to address food system needs before, during and after a disaster",null,null,null,null,"A7.3",null,"Community’s ability to address food system needs before, during and after a disaster"]
[null,"Question","Comments",null,null,null,""]
[null,null,null,null,null,null,""]
[null,"Response","Provide means of verification (explanation and evidence)",null,null,null,""]
[null,null,null,null,null,{"$f":"IF(E35=1,TRUE,FALSE)","v":false},""]
[null,null,null,null,null,{"$f":"IF(E35=2,TRUE,FALSE)","v":false},""]
[null,null,null,null,null,{"$f":"IF(E35=3,TRUE,FALSE)","v":false},""]
[null,null,null,null,null,{"$f":"IF(E35=4,TRUE,FALSE)","v":false},""]
[null,null,null,null,null,{"$f":"IF(E35=5,TRUE,FALSE)","v":false},""]
[null,null,null,null,null,{"$f":"IF(E35=6,TRUE,FALSE)","v":false},""]
[null,"Actions to achieve maximum resilience","Responsible institution","Timescale",null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,"A7.4 Public education programs and community empowerment",null,null,null,null,"A7.4",null,"Public education programs and community empowerment"]
[null,"Question","Comments",null,null,null,""]
[null,null,null,null,null,null,""]
[null,"Response","Provide means of verification (explanation and evidence)",null,null,null,""]
[null,null,null,null,null,{"$f":"IF(E48=1,TRUE,FALSE)","v":false},""]
[null,null,null,null,null,{"$f":"IF(E48=2,TRUE,FALSE)","v":false},""]
[null,null,null,null,null,{"$f":"IF(E48=3,TRUE,FALSE)","v":false},""]
[null,null,null,null,null,{"$f":"IF(E48=4,TRUE,FALSE)","v":false},""]
[null,null,null,null,null,{"$f":"IF(E48=5,TRUE,FALSE)","v":false},""]
[null,null,null,null,null,{"$f":"IF(E48=6,TRUE,FALSE)","v":false}]
[null,"Actions to achieve maximum resilience","Responsible institution","Timescale",null,null,""]
[null,null,null,null,null,null,""]

{"sheet":"E08","index":10,"n_rows":43,"n_cols":9,"rows_kept":43,"cut":false,"hidden":false,"merged":[[34,2,39,3],[21,2,26,3],[8,2,13,3],[33,2,33,3],[4,1,4,3],[5,2,5,3],[6,2,6,3],[7,2,7,3],[17,1,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[30,1,30,3],[31,2,31,3],[32,2,32,3]]}
[]
[]
[null,"A8 Integration of the food system and infrastructure resilience (Essential 8)",null,null,null,null,"A8",null,"Integration of public health and infrastructure resilience (Essential 8)"]
[null,null,null,null,null,null,""]
[null,"A8.1 Strengthening the structural and non-structural aspects of food systems ",null,null,null,null,"A8.1",null,"Strengthening of the structural and non-structural safety and functionality of public health infrastructure items not considered in Essential 8 "]
[null,"Question","Comments",null,null,null,""]
[null,null,null,null,null,null,""]
[null,"Response","Provide means of verification (explanation and evidence)",null,null,null,""]
[null,null,null,null,null,{"$f":"IF(E9=1,TRUE,FALSE)","v":false},""]
[null,null,null,null,null,{"$f":"IF(E9=2,TRUE,FALSE)","v":false},""]
[null,null,null,null,null,{"$f":"IF(E9=3,TRUE,FALSE)","v":false},""]
[null,null,null,null,null,{"$f":"IF(E9=4,TRUE,FALSE)","v":false},""]
[null,null,null,null,null,{"$f":"IF(E9=5,TRUE,FALSE)","v":false},""]
[null,null,null,null,null,{"$f":"IF(E9=6,TRUE,FALSE)","v":false},""]
[null,"Actions to achieve maximum resilience","Responsible institution","Timescale",null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,"A8.2 Surge capacity for food supply and access ",null,null,null,null,"A8.2",null,"Surge capacity for public health infrastructure, where not considered in Essential 8 "]
[null,"Question","Comments",null,null,null,""]
[null,null,null,null,null,null,""]
[null,"Response","Provide means of verification (explanation and evidence)",null,null,null,""]
[null,null,null,null,null,{"$f":"IF(E22=1,TRUE,FALSE)","v":false},""]
[null,null,null,null,null,{"$f":"IF(E22=2,TRUE,FALSE)","v":false},""]
[null,null,null,null,null,{"$f":"IF(E22=3,TRUE,FALSE)","v":false},""]
[null,null,null,null,null,{"$f":"IF(E22=4,TRUE,FALSE)","v":false},""]
[null,null,null,null,null,{"$f":"IF(E22=5,TRUE,FALSE)","v":false},""]
[null,null,null,null,null,{"$f":"IF(E22=6,TRUE,FALSE)","v":false},""]
[null,"Actions to achieve maximum resilience","Responsible institution","Timescale",null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,"A8.3 Continuity of food service delivery to critical places",null,null,null,null,"A8.3",null,"Continuity of care for those already sick, where not considered in Essential 8. "]
[null,"Question","Comments",null,null,null,""]
[null,null,null,null,null,null,""]
[null,"Response","Provide means of verification (explanation and evidence)",null,null,null,""]
[null,null,null,null,null,{"$f":"IF(E35=1,TRUE,FALSE)","v":false},""]
[null,null,null,null,null,{"$f":"IF(E35=2,TRUE,FALSE)","v":false},""]
[null,null,null,null,null,{"$f":"IF(E35=3,TRUE,FALSE)","v":false},""]
[null,null,null,null,null,{"$f":"IF(E35=4,TRUE,FALSE)","v":false},""]
[null,null,null,null,null,{"$f":"IF(E35=5,TRUE,FALSE)","v":false},""]
[null,null,null,null,null,{"$f":"IF(E35=6,TRUE,FALSE)","v":false},""]
[null,"Actions to achieve maximum resilience","Responsible institution","Timescale",null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]

{"sheet":"E09","index":11,"n_rows":44,"n_cols":9,"rows_kept":44,"cut":false,"hidden":false,"merged":[[34,2,39,3],[21,2,26,3],[30,1,30,3],[31,2,31,3],[32,2,32,3],[33,2,33,3],[19,2,19,3],[20,2,20,3],[4,1,4,3],[5,2,5,3],[6,2,6,3],[7,2,7,3],[17,1,17,3],[18,2,18,3],[8,2,13,3]]}
[]
[]
[null,"A9 Integration of the food system and disaster response (Essential 9)",null,null,null,null,"A9",null,"Integration of the food system and disaster response (Essential 9)"]
[null,null,null,null,null,null,""]
[null,"A9.1 Early warning systems for food system actors ",null,null,null,null,"A9.1",null,"Early warning systems for food system actors "]
[null,"Question","Comments",null,null,null,""]
[null,null,null,null,null,null,""]
[null,"Response","Provide means of verification (explanation and evidence)",null,null,null,""]
[null,null,null,null,null,{"$f":"IF(E9=1,TRUE,FALSE)","v":false},""]
[null,null,null,null,null,{"$f":"IF(E9=2,TRUE,FALSE)","v":false},""]
[null,null,null,null,null,{"$f":"IF(E9=3,TRUE,FALSE)","v":false},""]
[null,null,null,null,null,{"$f":"IF(E9=4,TRUE,FALSE)","v":false},""]
[null,null,null,null,null,{"$f":"IF(E9=5,TRUE,FALSE)","v":false},""]
[null,null,null,null,null,{"$f":"IF(E9=6,TRUE,FALSE)","v":false},""]
[null,"Actions to achieve maximum resilience","Responsible institution","Timescale",null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,"A9.2 Integration of the food system actors with emergency management ",null,null,null,null,"A9.2",null,"Integration of the food system actors with emergency management "]
[null,"Question","Comments",null,null,null,""]
[null,null,null,null,null,null,""]
[null,"Response","Provide means of verification (explanation and evidence)",null,null,null,""]
[null,null,null,null,null,{"$f":"IF(E22=1,TRUE,FALSE)","v":false},""]
[null,null,null,null,null,{"$f":"IF(E22=2,TRUE,FALSE)","v":false},""]
[null,null,null,null,null,{"$f":"IF(E22=3,TRUE,FALSE)","v":false},""]
[null,null,null,null,null,{"$f":"IF(E22=4,TRUE,FALSE)","v":false},""]
[null,null,null,null,null,{"$f":"IF(E22=5,TRUE,FALSE)","v":false},""]
[null,null,null,null,null,{"$f":"IF(E22=6,TRUE,FALSE)","v":false},""]
[null,"Actions to achieve maximum resilience","Responsible institution","Timescale",null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,"A9.3 Ability to deliver food supplies to people in need",null,null,null,null,"A9.3",null,"Ability to deliver food supplies to people in need. "]
[null,"Question","Comments",null,null,null,""]
[null,null,null,null,null,null,""]
[null,"Response","Provide means of verification (explanation and evidence)",null,null,null,""]
[null,null,null,null,null,{"$f":"IF(E35=1,TRUE,FALSE)","v":false},""]
[null,null,null,null,null,{"$f":"IF(E35=2,TRUE,FALSE)","v":false},""]
[null,null,null,null,null,{"$f":"IF(E35=3,TRUE,FALSE)","v":false},""]
[null,null,null,null,null,{"$f":"IF(E35=4,TRUE,FALSE)","v":false},""]
[null,null,null,null,null,{"$f":"IF(E35=5,TRUE,FALSE)","v":false},""]
[null,null,null,null,null,{"$f":"IF(E35=6,TRUE,FALSE)","v":false},""]
[null,"Actions to achieve maximum resilience","Responsible institution","Timescale",null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]

{"sheet":"E10","index":12,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":false,"merged":[[4,1,4,3],[5,2,5,3],[6,2,6,3],[7,2,7,3],[17,1,17,3],[21,2,26,3],[8,2,13,3],[19,2,19,3],[20,2,20,3],[18,2,18,3]]}
[]
[]
[null,"A10 Integration of the food system and recovery/building back better (Essential 10)",null,null,null,null,"A10",null,"Integration of the food system and recovery/building back better (Essential 10)"]
[]
[null,"A10.1 Mitigating long-term impacts on the food system and well-being",null,null,null,null,"A10.1",null,"Mitigating long-term impacts on the food system and well-being"]
[null,"Question","Comments"]
[]
[null,"Response","Provide means of verification (explanation and evidence)"]
[null,null,null,null,null,{"$f":"IF(E9=1,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E9=2,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E9=3,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E9=4,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E9=5,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E9=6,TRUE,FALSE)","v":false}]
[null,"Actions to achieve maximum resilience","Responsible institution","Timescale"]
[]
[]
[null,"A10.2 Learning and improving",null,null,null,null,"A10.2",null,"Learning and improving"]
[null,"Question","Comments"]
[]
[null,"Response","Provide means of verification (explanation and evidence)"]
[null,null,null,null,null,{"$f":"IF(E22=1,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E22=2,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E22=3,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E22=4,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E22=5,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E22=6,TRUE,FALSE)","v":false}]
[null,"Actions to achieve maximum resilience","Responsible institution","Timescale"]

{"sheet":"About","index":13,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}