{"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":10,"images":46,"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":49,"n_cols":4,"rows_kept":49,"cut":false,"hidden":false,"merged":[[0,0,0,16383],[49,1,49,3],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[39,1,39,2],[40,1,40,2],[41,1,41,2],[42,1,42,2],[43,1,43,2],[45,1,45,3],[46,1,46,3]]}
[]
[]
[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 (Required)","Total numbers and/or \n% of the total population","Source of the information"]
[null,"Population of persons with disabilities (estimated prevalence)"]
[null,"Information disaggregated by income (below the poverty line)"]
[null,"Information disaggregated by sex"]
[null,"Information disaggregated by age"]
[null,"Information disaggregated by type of disability(physical impairment, sensory impairment, cognitive impairment, intellectual impairment, mental illness, and some form of chronic disease)"]
[null,"Information disaggregated by neighbourhood or block"]
[]
[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,"Situation of persons with disabilities in the city / local government"]
[]
[]
[null,"Stakeholder Information"]

{"sheet":"Results","index":2,"n_rows":145,"n_cols":13,"rows_kept":145,"cut":false,"hidden":false,"merged":[[59,2,59,5],[35,2,35,5],[104,1,104,3],[88,2,88,5],[95,2,95,5],[96,2,96,5],[102,1,102,2],[86,3,86,5],[93,3,93,6],[89,2,89,5],[90,2,90,5],[75,2,75,5],[76,2,76,5],[34,2,34,5],[83,2,83,5],[41,2,41,5],[42,2,42,5],[49,2,49,5],[56,2,56,5],[54,3,54,6],[39,3,39,6],[62,3,62,6],[67,3,67,6],[73,3,73,6],[69,2,69,5],[70,2,70,5],[64,2,64,5],[58,2,58,5],[57,2,57,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":"D109","v":"Organise for Disaster Resilience - Inclusion of persons with disabilities in disaster risk governance"}]
[]
[null,{"$f":"C121","v":"Q 1.1"},{"$f":"E121","v":"Leave No One Behind"},null,null,null,{"$f":"F121","v":0}]
[null,{"$f":"C122","v":"Q 1.2"},{"$f":"E122","v":"Organisation, Coordination and Participation"},null,null,null,{"$f":"F122","v":0}]
[]
[]
[]
[null,"Essential 02: ",null,{"$f":"D110","v":"Identify, Understand and Use Current and Future Risk Scenarios - Inclusion of persons with disabilities in disaster risk scenarios"}]
[]
[null,{"$f":"C123","v":"Q 2.1"},{"$f":"E123","v":"Design of Disability-Inclusive Risk Analyses and Risk Scenarios"},null,null,null,{"$f":"F123","v":0}]
[null,{"$f":"C124","v":"Q 2.2"},{"$f":"E124","v":"Cascading Effects"},null,null,null,{"$f":"F124","v":0}]
[]
[]
[]
[]
[null,"Essential 03:",null,{"$f":"D111","v":"Strengthen Financial Capacity for Resilience - Inclusion of persons with disabilities in financial mechanisms"}]
[]
[null,{"$f":"C125","v":"Q 3.1"},{"$f":"E125","v":"Inclusive Financial Mechanisms"},null,null,null,{"$f":"F125","v":0}]
[]
[]
[]
[]
[null,"Essential 04:",null,{"$f":"D112","v":"Pursue Resilient Urban Development and Design - Inclusion of persons with disabilities in land use/building codes"}]
[]
[null,{"$f":"C126","v":"Q 4.1"},{"$f":"E126","v":"Inclusive Resilient Urban Design"},null,null,null,{"$f":"F126","v":0}]
[null,{"$f":"C127","v":"Q 4.2"},{"$f":"E127","v":"Building Codes and Standards"},null,null,null,{"$f":"F127","v":0}]
[null,{"$f":"C128","v":"Q 4.3"},{"$f":"E128","v":"Building Codes and Standards"},null,null,null,{"$f":"F128","v":0}]
[null,{"$f":"C129","v":"Q 4.4"},{"$f":"E129","v":"Removal of Environmental Barriers"},null,null,null,{"$f":"F129","v":0}]
[]
[]
[null,"Essential 05:",null,{"$f":"D113","v":"Safeguard Natural Buffers to Enhance Ecosystems’ Protective Functions - Management of ecosystem services with consideration for persons with disabilities "}]
[]
[null,null,"-- no question --"]
[]
[]
[null,"Essential 06:",null,{"$f":"D114","v":"Strengthen Institutional Capacity for Resilience - Inclusion of persons with disabilities in institutional capacity"}]
[]
[null,{"$f":"C130","v":"Q 6.1"},{"$f":"E130","v":"Capacity Building and Inclusion for Resilience"},null,null,null,{"$f":"F130","v":0}]
[null,{"$f":"C131","v":"Q 6.2"},{"$f":"E131","v":"Accessible Language"},null,null,null,{"$f":"F131","v":0}]
[]
[]
[null,"Essential 07: ",null,{"$f":"D115","v":"Understand and Strengthen Societal Capacity for Resilience - Inclusion of persons with disabilities in societal capacity"}]
[]
[null,{"$f":"C132","v":"Q 7.1"},{"$f":"E132","v":"Active Participation of Organisations of Persons with Disabilities"},null,null,null,{"$f":"F132","v":0}]
[null,{"$f":"C133","v":"Q 7.2"},{"$f":"E133","v":"Capacity Building by and for Organisations of Persons with Disabilities"},null,null,null,{"$f":"F133","v":0}]
[]
[]
[]
[]
[null,"Essential 08:",null,{"$f":"D116","v":"Increase Infrastructure Resilience - Inclusion of persons with disabilities in infrastructure resilience"}]
[]
[null,{"$f":"C134","v":"Q 8.1"},{"$f":"E134","v":"Protection from Violence"},null,null,null,{"$f":"F134","v":0}]
[]
[]
[null,"Essential 09:",null,{"$f":"D117","v":"Ensure Effective Disaster Response - Inclusion of persons with disabilities in disaster response"}]
[]
[null,{"$f":"C135","v":"Q 9.1"},{"$f":"E135","v":"Inclusive Detection, Monitoring and Early Warnings"},null,null,null,{"$f":"F135","v":0}]
[null,{"$f":"C136","v":"Q 9.2"},{"$f":"E136","v":"Drills"},null,null,null,{"$f":"F136","v":0}]
[null,{"$f":"C137","v":"Q 9.3"},{"$f":"E137","v":"Awareness Campaigns and Multi-scenario Drills"},null,null,null,{"$f":"F137","v":0}]
[]
[]
[null,"Essential 10: ",null,{"$f":"D118","v":"Expedite Recovery and Build Back Better - Inclusion of persons with disabilities in recovery/building back better"}]
[]
[null,{"$f":"C138","v":"Q 10.1"},{"$f":"E138","v":"Inclusive Reconstruction and Rehabilitation"},null,null,null,{"$f":"F138","v":0}]
[null,{"$f":"C139","v":"Q 10.2"},{"$f":"E139","v":"Compilation of Lessons Learned"},null,null,null,{"$f":"F139","v":0}]
[]
[]
[]
[]
[]
[null,{"$f":"TODAY()","v":"2023-01-12"},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 - Inclusion of persons with disabilities in disaster risk governance"},null,"E1",{"$f":"SUMIFS($F$121:$F$997,$B$121:$B$997,F109)","v":0},{"$f":"COUNTIFS($B$121:$B$997,F109)*3","v":6},"01",null,{"$f":"SUM(G109:G118)","v":0},{"$f":"K109/K110","v":0},{"$f":"CONCATENATE(\"The overall score for this assessment is \",SUM(G109:G118),\" / \",SUM(H109:H118))","v":"The overall score for this assessment is 0 / 57"}]
[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 - Inclusion of persons with disabilities in disaster risk scenarios"},null,"E2",0,{"$f":"COUNTIFS($B$121:$B$997,F110)*3","v":6},"02",null,{"$f":"SUM(H109:H118)","v":57},{"$f":"1-L109","v":1}]
[null,null,"E3",{"$f":"\"Strengthen Financial Capacity for Resilience - \"&'E03'!I3","v":"Strengthen Financial Capacity for Resilience - Inclusion of persons with disabilities in financial mechanisms"},null,"E3",0,3,"03"]
[null,null,"E4",{"$f":"\"Pursue Resilient Urban Development and Design - \"&'E04'!I3","v":"Pursue Resilient Urban Development and Design - Inclusion of persons with disabilities in land use/building codes"},null,"E4",0,12,"04"]
[null,null,"E5",{"$f":"\"Safeguard Natural Buffers to Enhance Ecosystems’ Protective Functions - \"&'E05'!I4","v":"Safeguard Natural Buffers to Enhance Ecosystems’ Protective Functions - Management of ecosystem services with consideration for persons with disabilities "},null,"E5",0,0,"05"]
[null,null,"E6",{"$f":"\"Strengthen Institutional Capacity for Resilience - \"&'E06'!I3","v":"Strengthen Institutional Capacity for Resilience - Inclusion of persons with disabilities in institutional capacity"},null,"E6",0,6,"06"]
[null,null,"E7",{"$f":"\"Understand and Strengthen Societal Capacity for Resilience - \"&'E07'!I3","v":"Understand and Strengthen Societal Capacity for Resilience - Inclusion of persons with disabilities in societal capacity"},null,"E7",0,6,"07"]
[null,null,"E8",{"$f":"\"Increase Infrastructure Resilience - \"&'E08'!I3","v":"Increase Infrastructure Resilience - Inclusion of persons with disabilities in infrastructure resilience"},null,"E8",0,3,"08"]
[null,null,"E9",{"$f":"\"Ensure Effective Disaster Response - \"&'E09'!I3","v":"Ensure Effective Disaster Response - Inclusion of persons with disabilities in disaster response"},null,"E9",0,9,"09"]
[null,null,"E10",{"$f":"\"Expedite Recovery and Build Back Better - \"&'E10'!I3","v":"Expedite Recovery and Build Back Better - Inclusion of persons with disabilities in recovery/building back better"},null,"E10",0,6,"10"]
[]
[null,"Section","Ref",null,"Question","SelectedScore","ThisScore"]
[null,"E1",{"$f":"'E01'!G$5","v":"Q 1.1"},null,{"$f":"'E01'!I$5","v":"Leave No One Behind"},{"$f":"IF(G121=\"\",0,IF(G121=0,0,4-G121))","v":0},{"$f":"OFFSET('E01'!$E$1,MATCH(C121,'E01'!G:G,0)+3,0)","v":0},null,"Remarks: "]
[null,"E1",{"$f":"'E01'!G$16","v":"Q 1.2"},null,{"$f":"'E01'!I$16","v":"Organisation, Coordination and Participation"},0,{"$f":"OFFSET('E01'!$E$1,MATCH(C122,'E01'!G:G,0)+3,0)","v":0},null,"- On this page, firstly fix from Row 126 downward to reflect all questions in this Scorecard"]
[null,"E2",{"$f":"'E02'!G$5","v":"Q 2.1"},null,{"$f":"'E02'!I$5","v":"Design of Disability-Inclusive Risk Analyses and Risk Scenarios"},0,{"$f":"OFFSET('E02'!$E$1,MATCH(C123,'E02'!G:G,0)+3,0)","v":0},null,"- Column G from G127 downward, must double check the formula.  (Formula = offset(reference, rows, cols, [height],[width])"]
[null,"E2",{"$f":"'E02'!G$16","v":"Q 2.2"},null,{"$f":"'E02'!I$16","v":"Cascading Effects"},0,{"$f":"OFFSET('E02'!$E$1,MATCH(C124,'E02'!G:G,0)+3,0)","v":0},null,"- Column F from F127 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,"E3",{"$f":"'E03'!G$5","v":"Q 3.1"},null,{"$f":"'E03'!I$5","v":"Inclusive Financial Mechanisms"},0,{"$f":"OFFSET('E03'!$E$1,MATCH(C125,'E03'!G:G,0)+3,0)","v":0},null,"E.G., =IF(G127=\"\",0,IF(G127=0,0,4-G127)) is for 0-3 scoring bar"]
[null,"E4",{"$f":"'E04'!G$5","v":"Q 4.1"},null,{"$f":"'E04'!I$5","v":"Inclusive Resilient Urban Design"},0,{"$f":"OFFSET('E04'!$E$1,MATCH(C126,'E04'!G:G,0)+3,0)","v":0},null,"E.G., =IF(G127=\"\",0,IF(G127=0,0,6-G127)) is for 0-5 scoring bar"]
[null,"E4",{"$f":"'E04'!G$16","v":"Q 4.2"},null,{"$f":"'E04'!I$16","v":"Building Codes and Standards"},0,{"$f":"OFFSET('E04'!$E$1,MATCH(C127,'E04'!G:G,0)+3,0)","v":0}]
[null,"E4",{"$f":"'E04'!G$27","v":"Q 4.3"},null,{"$f":"'E04'!I$27","v":"Building Codes and Standards"},0,{"$f":"OFFSET('E04'!$E$1,MATCH(C128,'E04'!G:G,0)+3,0)","v":0},null,"-Then, work on Row 114 - 123"]
[null,"E4",{"$f":"'E04'!G$38","v":"Q 4.4"},null,{"$f":"'E04'!I$38","v":"Removal of Environmental Barriers"},0,{"$f":"OFFSET('E04'!$E$1,MATCH(C129,'E04'!G:G,0)+3,0)","v":0},null,"- Check Column D (D114:D123) for the Essential titles"]
[null,"E6",{"$f":"'E06'!G$5","v":"Q 6.1"},null,{"$f":"'E06'!I$5","v":"Capacity Building and Inclusion for Resilience"},0,{"$f":"OFFSET('E06'!$E$1,MATCH(C130,'E06'!G:G,0)+3,0)","v":0},null,"- Check Column G (G114:G123).  The formular should not need fixing. (=SUMIFS($F$126:$F$1002,$B$126:$B$1002,F114)"]
[null,"E6",{"$f":"'E06'!G$16","v":"Q 6.2"},null,{"$f":"'E06'!I$16","v":"Accessible Language"},0,{"$f":"OFFSET('E06'!$E$1,MATCH(C131,'E06'!G:G,0)+3,0)","v":0},null,"- Check Column H (H114:H123) Maximum Score"]
[null,"E7",{"$f":"'E07'!G$5","v":"Q 7.1"},null,{"$f":"'E07'!I$5","v":"Active Participation of Organisations of Persons with Disabilities"},0,{"$f":"OFFSET('E07'!$E$1,MATCH(C132,'E07'!G:G,0)+3,0)","v":0},null,"- Use formular =COUNTIFS($B$126:$B$1002,F114)*3, if scoring bar is 0-3"]
[null,"E7",{"$f":"'E07'!G$16","v":"Q 7.2"},null,{"$f":"'E07'!I$16","v":"Capacity Building by and for Organisations of Persons with Disabilities"},0,{"$f":"OFFSET('E07'!$E$1,MATCH(C133,'E07'!G:G,0)+3,0)","v":0},null,"- Use formular =COUNTIFS($B$126:$B$1002,F114)*5, if scoring bar is 0-5"]
[null,"E8",{"$f":"'E08'!G$5","v":"Q 8.1"},null,{"$f":"'E08'!I$5","v":"Protection from Violence"},0,{"$f":"OFFSET('E08'!$E$1,MATCH(C134,'E08'!G:G,0)+3,0)","v":0}]
[null,"E9",{"$f":"'E09'!G$5","v":"Q 9.1"},null,{"$f":"'E09'!I$5","v":"Inclusive Detection, Monitoring and Early Warnings"},0,{"$f":"OFFSET('E09'!$E$1,MATCH(C135,'E09'!G:G,0)+3,0)","v":0},null,"- Then adjust the result display area above"]
[null,"E9",{"$f":"'E09'!G$16","v":"Q 9.2"},null,{"$f":"'E09'!I$16","v":"Drills"},0,{"$f":"OFFSET('E09'!$E$1,MATCH(C136,'E09'!G:G,0)+3,0)","v":0},null,"- Fix the list of indicators"]
[null,"E9",{"$f":"'E09'!G$27","v":"Q 9.3"},null,{"$f":"'E09'!I$27","v":"Awareness Campaigns and Multi-scenario Drills"},0,{"$f":"OFFSET('E09'!$E$1,MATCH(C137,'E09'!G:G,0)+3,0)","v":0},null,"- Apply appropriate chart types"]
[null,"E10",{"$f":"'E10'!G$5","v":"Q 10.1"},null,{"$f":"'E10'!I$5","v":"Inclusive Reconstruction and Rehabilitation"},0,{"$f":"OFFSET('E10'!$E$1,MATCH(C138,'E10'!G:G,0)+3,0)","v":0},null,"- Change chart's axis value (3 maximum for 0-3 scoring bar, and 5 maximum for 0-5 scoring bar)"]
[null,"E10",{"$f":"'E10'!G$16","v":"Q 10.2"},null,{"$f":"'E10'!I$16","v":"Compilation of Lessons Learned"},0,{"$f":"OFFSET('E10'!$E$1,MATCH(C139,'E10'!G:G,0)+3,0)","v":0},null,"- Adjust the chart diaplay alignment across all essentials, etc."]
[null,null,null,null,null,null,null,null,"- View from 'Page Break Preview' and further adjust page layout to fit nicely in the print area"]
[]
[]
[null,null,null,null,null,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,null,null,null,null,null,null,null,"- Once done, change font color from Row 107 downward to white"]

{"sheet":"E01","index":3,"n_rows":38,"n_cols":9,"rows_kept":38,"cut":false,"hidden":false,"merged":[[19,2,22,3],[7,2,7,3],[8,2,11,3],[5,2,5,3],[6,2,6,3],[16,2,16,3],[17,2,17,3],[18,2,18,3]]}
[]
[]
[null,"E1 Inclusion of persons with disabilities in disaster risk governance",null,null,null,null,{"$f":"TRIM(LEFT(B3,3))","v":"E1"},null,{"$f":"TRIM(MID(B3,4,80))","v":"Inclusion of persons with disabilities in disaster risk governance"}]
[]
[null,"Q 1.1 Leave No One Behind",null,null,null,null,{"$f":"TRIM(LEFT(B5,6))","v":"Q 1.1"},null,{"$f":"TRIM(MID(B5,6,120))","v":"Leave No One Behind"}]
[null,"Question","Comments"]
[]
[null,"Response","Provide means of verification (explanation and evidence)"]
[null,null,null,null,null,{"$f":"IF($E$9=1,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF($E$9=2,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF($E$9=3,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF($E$9=4,TRUE,FALSE)","v":false}]
[null,"Actions to achieve maximum resilience","Responsible institution","Timescale"]
[]
[]
[null,"Q 1.2 Organisation, Coordination and Participation",null,null,null,null,{"$f":"TRIM(LEFT(B16,6))","v":"Q 1.2"},null,{"$f":"TRIM(MID(B16,6,120))","v":"Organisation, Coordination and Participation"}]
[null,"Question","Comments"]
[]
[null,"Response","Provide means of verification (explanation and evidence)"]
[null,null,null,null,null,{"$f":"IF($E$20=1,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF($E$20=2,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF($E$20=3,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF($E$20=4,TRUE,FALSE)","v":false}]
[null,"Actions to achieve maximum resilience","Responsible institution","Timescale"]
[]
[]
[null,null,null,null,null,null,{"$f":"LEFT(B27,5)","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"LEFT(B38,5)","v":""}]

{"sheet":"E02","index":4,"n_rows":38,"n_cols":9,"rows_kept":38,"cut":false,"hidden":false,"merged":[[18,2,18,3],[8,2,11,3],[19,2,22,3],[5,2,5,3],[6,2,6,3],[7,2,7,3],[16,2,16,3],[17,2,17,3]]}
[]
[]
[null,"E2 Inclusion of persons with disabilities in disaster risk scenarios",null,null,null,null,{"$f":"TRIM(LEFT(B3,3))","v":"E2"},null,{"$f":"TRIM(MID(B3,4,80))","v":"Inclusion of persons with disabilities in disaster risk scenarios"}]
[]
[null,"Q 2.1 Design of Disability-Inclusive Risk Analyses and Risk Scenarios",null,null,null,null,{"$f":"TRIM(LEFT(B5,6))","v":"Q 2.1"},null,{"$f":"TRIM(MID(B5,6,120))","v":"Design of Disability-Inclusive Risk Analyses and Risk Scenarios"}]
[null,"Question","Comments"]
[]
[null,"Response","Provide means of verification (explanation and evidence)"]
[null,null,null,null,null,{"$f":"IF($E$9=1,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF($E$9=2,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF($E$9=3,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF($E$9=4,TRUE,FALSE)","v":false}]
[null,"Actions to achieve maximum resilience","Responsible institution","Timescale"]
[]
[]
[null,"Q 2.2 Cascading Effects",null,null,null,null,{"$f":"TRIM(LEFT(B16,6))","v":"Q 2.2"},null,{"$f":"TRIM(MID(B16,6,120))","v":"Cascading Effects"}]
[null,"Question","Comments"]
[]
[null,"Response","Provide means of verification (explanation and evidence)"]
[null,null,null,null,null,{"$f":"IF($E$20=1,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E20=2,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E20=3,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E20=4,TRUE,FALSE)","v":false}]
[null,"Actions to achieve maximum resilience","Responsible institution","Timescale"]
[]
[]
[null,null,null,null,null,null,{"$f":"LEFT(B27,5)","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"LEFT(B38,5)","v":""}]

{"sheet":"E03","index":5,"n_rows":38,"n_cols":9,"rows_kept":38,"cut":false,"hidden":false,"merged":[[4,1,4,3],[5,2,5,3],[6,2,6,3],[7,2,7,3],[8,2,11,3]]}
[]
[]
[null,"E3 Inclusion of persons with disabilities in financial mechanisms",null,null,null,null,{"$f":"TRIM(LEFT(B3,3))","v":"E3"},null,{"$f":"TRIM(MID(B3,4,80))","v":"Inclusion of persons with disabilities in financial mechanisms"}]
[]
[null,"Q 3.1 Inclusive Financial Mechanisms",null,null,null,null,{"$f":"TRIM(LEFT(B5,6))","v":"Q 3.1"},null,{"$f":"TRIM(MID(B5,6,120))","v":"Inclusive Financial Mechanisms"}]
[null,"Question","Comments"]
[]
[null,"Response","Provide means of verification (explanation and evidence)"]
[null,null,null,null,null,{"$f":"IF($E$9=1,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF($E$9=2,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF($E$9=3,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF($E$9=4,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,null,null,null,null,null,{"$f":"LEFT(B27,5)","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"LEFT(B38,5)","v":""}]

{"sheet":"E04","index":6,"n_rows":46,"n_cols":9,"rows_kept":46,"cut":false,"hidden":false,"merged":[[28,2,28,3],[29,2,29,3],[30,2,33,3],[4,1,4,3],[5,2,5,3],[8,2,11,3],[6,2,6,3],[7,2,7,3],[15,1,15,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[19,2,21,3],[26,1,26,3],[27,2,27,3],[37,1,37,3],[38,2,38,3],[39,2,39,3],[40,2,40,3],[41,2,44,3]]}
[]
[]
[null,"E4 Inclusion of persons with disabilities in land use/building codes",null,null,null,null,{"$f":"TRIM(LEFT(B3,3))","v":"E4"},null,{"$f":"TRIM(MID(B3,4,80))","v":"Inclusion of persons with disabilities in land use/building codes"}]
[]
[null,"Q 4.1 Inclusive Resilient Urban Design",null,null,null,null,{"$f":"TRIM(LEFT(B5,6))","v":"Q 4.1"},null,{"$f":"TRIM(MID(B5,6,120))","v":"Inclusive Resilient Urban Design"}]
[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,"Actions to achieve maximum resilience","Responsible institution","Timescale"]
[]
[]
[null,"Q 4.2 Building Codes and Standards",null,null,null,null,{"$f":"TRIM(LEFT(B16,6))","v":"Q 4.2"},null,{"$f":"TRIM(MID(B16,6,120))","v":"Building Codes and Standards"}]
[null,"Question","Comments"]
[]
[null,"Response","Provide means of verification (explanation and evidence)"]
[null,null,null,null,null,{"$f":"IF($E$20=1,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF($E$20=2,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF($E$20=3,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF($E$20=4,TRUE,FALSE)","v":false}]
[null,"Actions to achieve maximum resilience","Responsible institution","Timescale"]
[]
[]
[null,"Q 4.3 Building Codes and Standards",null,null,null,null,{"$f":"LEFT(B27,5)","v":"Q 4.3"},null,{"$f":"TRIM(MID(B27,6,120))","v":"Building Codes and Standards"}]
[null,"Question","Comments"]
[]
[null,"Response","Provide means of verification (explanation and evidence)"]
[null,null,null,null,null,{"$f":"IF($E$31=1,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF($E$31=2,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF($E$31=3,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF($E$31=4,TRUE,FALSE)","v":false}]
[null,"Actions to achieve maximum resilience","Responsible institution","Timescale"]
[]
[]
[" ","Q 4.4 Removal of Environmental Barriers",null,null,null,null,{"$f":"LEFT(B38,5)","v":"Q 4.4"},null,{"$f":"TRIM(MID(B38,6,120))","v":"Removal of Environmental Barriers"}]
[null,"Question","Comments"]
[]
[null,"Response","Provide means of verification (explanation and evidence)"]
[null,null,null,null,null,{"$f":"IF(E42=1,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E42=2,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E42=3,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E42=4,TRUE,FALSE)","v":false}]
[null,"Actions to achieve maximum resilience","Responsible institution","Timescale"]

{"sheet":"E05","index":7,"n_rows":4,"n_cols":9,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"E5 Management of ecosystem services with consideration for persons with disabilities ",null,null,null,null,null,null,"Management of ecosystem services with consideration for persons with disabilities "]

{"sheet":"E06","index":8,"n_rows":38,"n_cols":9,"rows_kept":38,"cut":false,"hidden":false,"merged":[[4,1,4,3],[5,2,5,3],[6,2,6,3],[7,2,7,3],[8,2,11,3],[19,2,22,3],[15,1,15,3],[16,2,16,3],[17,2,17,3],[18,2,18,3]]}
[]
[]
[null,"E6 Inclusion of persons with disabilities in institutional capacity",null,null,null,null,{"$f":"TRIM(LEFT(B3,3))","v":"E6"},null,{"$f":"TRIM(MID(B3,4,80))","v":"Inclusion of persons with disabilities in institutional capacity"}]
[]
[null,"Q 6.1 Capacity Building and Inclusion for Resilience",null,null,null,null,{"$f":"TRIM(LEFT(B5,6))","v":"Q 6.1"},null,{"$f":"TRIM(MID(B5,6,120))","v":"Capacity Building and Inclusion for 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,"Actions to achieve maximum resilience","Responsible institution","Timescale"]
[]
[]
[null,"Q 6.2 Accessible Language",null,null,null,null,{"$f":"TRIM(LEFT(B16,6))","v":"Q 6.2"},null,{"$f":"TRIM(MID(B16,6,120))","v":"Accessible Language"}]
[null,"Question","Comments"]
[]
[null,"Response","Provide means of verification (explanation and evidence)"]
[null,null,null,null,null,{"$f":"IF(E20=1,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E20=2,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E20=3,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E20=4,TRUE,FALSE)","v":false}]
[null,"Actions to achieve maximum resilience","Responsible institution","Timescale"]
[]
[]
[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":"E07","index":9,"n_rows":38,"n_cols":9,"rows_kept":38,"cut":false,"hidden":false,"merged":[[4,1,4,3],[5,2,5,3],[6,2,6,3],[7,2,7,3],[15,1,15,3],[16,2,16,3],[8,2,11,3],[19,2,22,3],[17,2,17,3],[18,2,18,3]]}
[]
[]
[null,"E7 Inclusion of persons with disabilities in societal capacity",null,null,null,null,{"$f":"TRIM(LEFT(B3,3))","v":"E7"},null,{"$f":"TRIM(MID(B3,4,80))","v":"Inclusion of persons with disabilities in societal capacity"}]
[]
[null,"Q 7.1 Active Participation of Organisations of Persons with Disabilities",null,null,null,null,{"$f":"TRIM(LEFT(B5,6))","v":"Q 7.1"},null,{"$f":"TRIM(MID(B5,6,120))","v":"Active Participation of Organisations of Persons with Disabilities"}]
[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,"Actions to achieve maximum resilience","Responsible institution","Timescale"]
[]
[]
[null,"Q 7.2 Capacity Building by and for Organisations of Persons with Disabilities",null,null,null,null,{"$f":"TRIM(LEFT(B16,6))","v":"Q 7.2"},null,{"$f":"TRIM(MID(B16,6,120))","v":"Capacity Building by and for Organisations of Persons with Disabilities"}]
[null,"Question","Comments"]
[]
[null,"Response","Provide means of verification (explanation and evidence)"]
[null,null,null,null,null,{"$f":"IF(E20=1,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E20=2,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E20=3,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E20=4,TRUE,FALSE)","v":false}]
[null,"Actions to achieve maximum resilience","Responsible institution","Timescale"]
[]
[]
[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":"E08","index":10,"n_rows":38,"n_cols":10,"rows_kept":38,"cut":false,"hidden":false,"merged":[[8,2,11,3],[4,1,4,3],[5,2,5,3],[6,2,6,3],[7,2,7,3]]}
[]
[]
[null,"E8 Inclusion of persons with disabilities in infrastructure resilience",null,null,null,null,{"$f":"TRIM(LEFT(B3,3))","v":"E8"},null,{"$f":"TRIM(MID(B3,4,80))","v":"Inclusion of persons with disabilities in infrastructure resilience"},{"$f":"TRIM(MID(C3,4,80))","v":""}]
[]
[null,"Q 8.1 Protection from Violence",null,null,null,null,{"$f":"TRIM(LEFT(B5,6))","v":"Q 8.1"},null,{"$f":"TRIM(MID(B5,6,120))","v":"Protection from Violence"},{"$f":"TRIM(MID(C5,6,120))","v":""}]
[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,"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":""},{"$f":"TRIM(MID(C16,6,120))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"LEFT(B27,5)","v":""},null,{"$f":"TRIM(MID(B27,6,120))","v":""},{"$f":"TRIM(MID(C27,6,120))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"LEFT(B38,5)","v":""},null,{"$f":"TRIM(MID(B38,6,120))","v":""},{"$f":"TRIM(MID(C38,6,120))","v":""}]

{"sheet":"E09","index":11,"n_rows":38,"n_cols":9,"rows_kept":38,"cut":false,"hidden":false,"merged":[[30,2,33,3],[19,2,22,3],[26,1,26,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[17,2,17,3],[18,2,18,3],[4,1,4,3],[5,2,5,3],[6,2,6,3],[7,2,7,3],[15,1,15,3],[16,2,16,3],[8,2,11,3]]}
[]
[]
[null,"E9 Inclusion of persons with disabilities in disaster response",null,null,null,null,{"$f":"TRIM(LEFT(B3,3))","v":"E9"},null,{"$f":"TRIM(MID(B3,4,80))","v":"Inclusion of persons with disabilities in disaster response"}]
[]
[null,"Q 9.1 Inclusive Detection, Monitoring and Early Warnings",null,null,null,null,{"$f":"TRIM(LEFT(B5,6))","v":"Q 9.1"},null,{"$f":"TRIM(MID(B5,6,120))","v":"Inclusive Detection, Monitoring and Early Warnings"}]
[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,"Actions to achieve maximum resilience","Responsible institution","Timescale"]
[]
[]
[null,"Q 9.2 Drills",null,null,null,null,{"$f":"TRIM(LEFT(B16,6))","v":"Q 9.2"},null,{"$f":"TRIM(MID(B16,6,120))","v":"Drills"}]
[null,"Question","Comments"]
[]
[null,"Response","Provide means of verification (explanation and evidence)"]
[null,null,null,null,null,{"$f":"IF(E20=1,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E20=2,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E20=3,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E20=4,TRUE,FALSE)","v":false}]
[null,"Actions to achieve maximum resilience","Responsible institution","Timescale"]
[]
[]
[null,"Q 9.3 Awareness Campaigns and Multi-scenario Drills",null,null,null,null,{"$f":"LEFT(B27,5)","v":"Q 9.3"},null,{"$f":"TRIM(MID(B27,6,120))","v":"Awareness Campaigns and Multi-scenario Drills"}]
[null,"Question","Comments"]
[]
[null,"Response","Provide means of verification (explanation and evidence)"]
[null,null,null,null,null,{"$f":"IF(E31=1,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E31=2,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E31=3,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E31=4,TRUE,FALSE)","v":false}]
[null,"Actions to achieve maximum resilience","Responsible institution","Timescale"]
[]
[]
[null,null,null,null,null,null,{"$f":"LEFT(B38,5)","v":""},null,{"$f":"TRIM(MID(B38,6,120))","v":""}]

{"sheet":"E10","index":12,"n_rows":38,"n_cols":9,"rows_kept":38,"cut":false,"hidden":false,"merged":[[16,2,16,3],[17,2,17,3],[18,2,18,3],[19,2,22,3],[4,1,4,3],[5,2,5,3],[6,2,6,3],[7,2,7,3],[8,2,11,3],[15,1,15,3]]}
[]
[]
[null,"E10 Inclusion of persons with disabilities in recovery/building back better",null,null,null,null,{"$f":"TRIM(LEFT(B3,3))","v":"E10"},null,{"$f":"TRIM(MID(B3,4,80))","v":"Inclusion of persons with disabilities in recovery/building back better"}]
[]
[null,"Q 10.1 Inclusive Reconstruction and Rehabilitation",null,null,null,null,{"$f":"TRIM(LEFT(B5,6))","v":"Q 10.1"},null,{"$f":"TRIM(MID(B5,8,120))","v":"Inclusive Reconstruction and Rehabilitation"}]
[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,"Actions to achieve maximum resilience","Responsible institution","Timescale"]
[]
[]
[null,"Q 10.2 Compilation of Lessons Learned",null,null,null,null,{"$f":"TRIM(LEFT(B16,6))","v":"Q 10.2"},null,{"$f":"TRIM(MID(B16,8,120))","v":"Compilation of Lessons Learned"}]
[null,"Question","Comments"]
[]
[null,"Response","Provide means of verification (explanation and evidence)"]
[null,null,null,null,null,{"$f":"IF(E20=1,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E20=2,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E20=3,TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"IF(E20=4,TRUE,FALSE)","v":false}]
[null,"Actions to achieve maximum resilience","Responsible institution","Timescale"]
[]
[]
[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":"About","index":13,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}