{"text_format":"1","workbook":"xlsx","n_sheets":28,"sheets":["CAMPA","Indications","WS1","WS2","WS3","WS4","WS5","WS6","WS7","WS8","WS9","WS10","WS11","WS12","WS13","WS14","WS15","Listas","WS16","WS17","WS Summary","WS18","WS19","WS20","WS21","WS22","WS23","WS24"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":17,"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":"CAMPA","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Indications","index":1,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Fill the WORKSHEETS left to right (WS1 -> WS24)"]
[]
[null,"Once you leave the Worksheets (3, 4, 5, 6), (15, 16, 17), (19, 20, 21, 22) they are locked, you can not edit more over them"]
[]
[]
[null,"For 13,3\" Screen, zoom at 90%"]
[]
[null,"Maximum 1000 VOC"]
[]
[null,"Maximum 50 \"Adaptation Options\" in WS22"]

{"sheet":"WS1","index":2,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[8,0,8,4],[9,0,9,4],[10,0,11,1],[10,2,10,4]]}
[14]
[]
[]
[]
[]
[null,null,0]
[]
[]
["Worksheet 1"]
["Identifying the objetives of climate adaptation and the timescale involved"]
[null,null,"Timescale (in years)"]
[null,null,"0-5","0-10","0-20+"]
["Overall objetive",null,null,null,null,null,{"$f":"COUNTA(C13:E13)","v":0}]
["Specific objectives",null,null,null,null,null,{"$f":"COUNTA(C14:E14)","v":0}]

{"sheet":"WS2","index":3,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[[8,0,8,1]]}
[]
[]
[]
[]
[]
[null,null,0]
[]
[]
["Worksheet 2: Intended scope of adaptation"]
["Factor influencing the geographical scope of the climate adaptation","If important, give details of location and importance"]
["All of the protected area or specific zones  (e.g. marine zone in large protected area)"]
["Nearby or connected protected areas"]
["Nearby or connected ecosystems or habitats that are not included in the\nprotected area boundaries"]
["Human communities living in the protected area that depend on the ecosystem services furnished by the protected area"]
["Human communities living near the protected area that depend on the ecosystem services furnished by the protected area"]
["Economic activities / industries / private sector activities that affect or are affected by the protected area"]
["Other factors"]

{"sheet":"WS3","index":4,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[1,11]
[1,13]
[1,15]
[]
["When finished, type \"Yes\" please"]
[null,0]
[]
[]
["Worksheet 3: Initial list of ecological targets"]
["Existing protected area conservation targets: Species"]
["1."]
["Existing protected area conservation targets: Habitats and Ecosystems"]
["1."]
["Other species, habitats and ecosystems not listed above"]
["1."]

{"sheet":"WS4","index":5,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[1,11]
[1,13]
[1,15]
[1,17]
["When finished, type \"Yes\" please"]
[null,0]
[]
[]
["Worksheet 4: Initial list of ecosystem service targets"]
["Provisioning services"]
["1."]
["Regulating services"]
["1."]
["Cultural services"]
["1."]
["Supporting services"]
["1."]

{"sheet":"WS5","index":6,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[7,0,7,1],[8,0,8,1]]}
[1,11,"1."]
[]
[]
[]
["When finished, type \"Yes\" please"]
[null,0]
[]
[]
["Worksheet 5: Initial list of socio-economic target groups (i.e. stakeholders who should be involved in the process)"]
["Social target group","Why they are identified"]
["1."]

{"sheet":"WS6","index":7,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[8,0,8,1]]}
[1,11,null,null,"WS3","WS4","WS5"]
[1,12,null,null,0,0,0]
[1,13]
[]
["When finished, type \"Yes\" please"]
[null,0]
[]
[null,{"$f":"COUNTIF(E2:G2, \"=1\")=3","v":false}]
["Worksheet 6: Prioritised list of targets"]
["Target groups","List and number targets"]
["Ecological targets (species, habitats and/or ecosystems)",null,{"$f":"COUNTA(B11)","v":0},{"$f":"IF(C11=1,SUM($C$10:C11),\"\")","v":""}]
["Ecosystem service targets (provisioning, regulating, cultural and/or supporting)",null,{"$f":"COUNTA(B12)","v":0},{"$f":"IF(C12=1,SUM($C$10:C12),\"\")","v":""}]
["Socio-economic target groups.",null,{"$f":"COUNTA(B13)","v":0},{"$f":"IF(C13=1,SUM($C$10:C13),\"\")","v":""}]

{"sheet":"WS7","index":8,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[8,0,8,6]]}
[11]
[]
[]
[]
[]
[]
[]
[]
["Optional: Worksheet 7: Background literature"]
["Author","Date","Title","Publisher","Format/ weblink","Summary","Comments"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTA(A11:G11)","v":0}]

{"sheet":"WS8","index":9,"n_rows":18,"n_cols":2,"rows_kept":18,"cut":false,"hidden":false,"merged":[[8,0,8,1]]}
[]
[]
[]
[]
[]
[]
[]
[]
["Worksheet 8: Baseline conditions"]
["Issue","Baseline conditions"]
["Climate (average conditions, extreme events, length of time for which data are available)"]
["Biophysical (hydrology, topography, soils, geology, etc.)"]
["Socio-economic (population, age distributions, incomes, livelihoods, poverty, use of natural resources, indigenous peoples, etc.)"]
["Ecological (ecosystems, habitats, species, ecosystem services, etc.)"]
["Environment (pollution levels and sources)"]
["Governance (local and regional structure and roles, land use/ development and other policies, administrative boundaries, plans and planning cycles, legislation, stakeholder groups, etc.)"]
["Environment (key drivers of environmental change in the area)                                                                                                                  ."]
["Other"]

{"sheet":"WS9","index":10,"n_rows":38,"n_cols":6,"rows_kept":38,"cut":false,"hidden":false,"merged":[[34,0,34,3],[8,0,8,3],[9,1,9,3],[11,0,11,3],[20,0,20,3],[30,0,30,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
["Worksheet 9: Non-climate threats to the protected area and surrounding area"]
["Non-climate threats or potential threats","Likely to be experienced in your area?"]
[null,"Yes","Unknown","No"]
["Environmental threats"]
["Anthropogenic threats in protected area (e.g. resource extraction)",null,null,null,null,{"$f":"COUNTA(B13:D13)","v":0}]
["Anthropogenic threats near protected area",null,null,null,null,{"$f":"COUNTA(B14:D14)","v":0}]
["Environmental pollution – water",null,null,null,null,0]
["Environmental pollution – soil",null,null,null,null,0]
["Environmental pollution – air",null,null,null,null,0]
["Deforestation and other conversion of natural ecosystems",null,null,null,null,0]
["Land degradation, erosion and loss of fertility",null,null,null,null,0]
["Other....",null,null,null,null,0]
["Social threats"]
["Rapid population change (increase, decrease, or changes in age distribution)",null,null,null,null,0]
["Changes in income",null,null,null,null,0]
["High level of crime",null,null,null,null,0]
["Social, cultural or religious tensions",null,null,null,null,0]
["Rapidly changing livelihood strategies",null,null,null,null,0]
["Migration in and out of the area",null,null,null,null,0]
["Low levels of education including literacy levels",null,null,null,null,0]
["High level of unemployment",null,null,null,null,0]
["Other....",null,null,null,null,0]
["Economic threats"]
["Rapid changes to gross domestic product (GDP)",null,null,null,null,0]
["Increasing industrial activity",null,null,null,null,0]
["Increasing development activity",null,null,null,null,0]
["Policy, legal and governance influences"]
["Unhelpful laws and policies",null,null,null,null,0]
["Perverse economic incentives",null,null,null,null,0]
["Rapid institutional or structural change",null,null,null,null,0]

{"sheet":"WS10","index":11,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[8,0,8,3]]}
[11]
[]
[]
[]
[]
[]
[]
[]
["Worksheet 10: Data on non-climate threats to the protected area and surrounding area"]
["Threat","Description of historic conditions and recent changes","Expected future changes (based on model outputs, projections and/or temporal analogue approach)","Data sources and comments on quality"]
[null,null,null,null,null,{"$f":"COUNTA(A11:D11)","v":0}]

{"sheet":"WS11","index":12,"n_rows":14,"n_cols":1,"rows_kept":14,"cut":false,"hidden":false,"merged":[[8,0,8,1],[9,0,9,1]]}
[11]
[]
[]
[]
[]
[]
[]
[]
["Worksheet 11: Non-climate scenarios"]
["Narrative describing non-climate scenarios"]
["Scenario Name"]
["Spatial and Temporal Limits of Scenario"]
["Key Issues included in Scenario"]
["Scenario Description"]

{"sheet":"WS12","index":13,"n_rows":42,"n_cols":6,"rows_kept":42,"cut":false,"hidden":false,"merged":[[8,0,8,3],[9,1,9,3],[11,0,11,3],[31,0,31,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
["Worksheet 12: Possible climate and oceanographic manifestations in the CMPA and surroundings"]
["Climate and Oceanographic Manifestation","Likely to be experienced in your area?"]
[null,"Yes","Unknown","No"]
["Terrestrial Parameters – will climate variability / climate change lead to changes in…"]
["Wind patterns",null,null,null,null,{"$f":"COUNTA(B13:D13)","v":0}]
["Cyclone / storm frequency",null,null,null,null,0]
["Cyclone / storm intensity",null,null,null,null,0]
["Sea-level rise",null,null,null,null,0]
["Storm surge",null,null,null,null,0]
["Rainfall – volume",null,null,null,null,0]
["Rainfall – annual patterns",null,null,null,null,0]
["Rainfall – intensity",null,null,null,null,0]
["Ambient Temperature °C – day time",null,null,null,null,0]
["Ambient Temperature °C – night time",null,null,null,null,0]
["Heat-wave",null,null,null,null,0]
["Drought",null,null,null,null,0]
["Flooding",null,null,null,null,0]
["Extreme tides",null,null,null,null,0]
["Fire",null,null,null,null,0]
["Surface water hydrology",null,null,null,null,0]
["Groundwater hydrology",null,null,null,null,0]
["Coastal erosion through changes to beach profiles or coastal morphology",null,null,null,null,0]
["Other....",null,null,null,null,0]
["Oceanographic Parameters – will climate variability / climate change lead to changes in …"]
["Sea surface temperature",null,null,null,null,0]
["Sea acidity",null,null,null,null,0]
["Upwellings",null,null,null,null,0]
["Salinity",null,null,null,null,0]
["Extreme waves",null,null,null,null,0]
["Solar radiation",null,null,null,null,0]
["Sedimentation",null,null,null,null,0]
["Chlorophyll",null,null,null,null,0]
["Humidity / evaporation",null,null,null,null,0]
["Other....",null,null,null,null,0]

{"sheet":"WS13","index":14,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[8,0,8,3]]}
[11]
[]
[]
[]
[]
[]
[]
[]
["Worksheet 13: Data on possible climate and oceanographic manifestations in the protected area and surroundings"]
["Climate and\noceanographic\nmanifestation","Description of\nhistoric climate\nconditions, climate\nvariability and recent\nchanges","Projected changes in climate\nconditions (based on model\noutputs and/or temporal\nanalogue approach) Note: can\nrefer to climate variability and\nchange","Comments on data\nsource/quality"]
[null,null,null,null,null,{"$f":"COUNTA(A11:D11)","v":0}]

{"sheet":"WS14","index":15,"n_rows":14,"n_cols":1,"rows_kept":14,"cut":false,"hidden":false,"merged":[[8,0,8,1],[9,0,9,1]]}
[11]
[]
[]
[]
[]
[]
[]
[]
["Worksheet 14: Climate scenarios (one filled in for each scenario)"]
["Narrative describing climate scenarios"]
["Scenario name"]
["Spatial and temporal limits of scenario"]
["Climate and oceanographic manifestations included in scenario"]
["Climate scenario description"]

{"sheet":"WS15","index":16,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[8,0,8,5],[9,0,9,5]]}
[12,0]
[]
[]
[]
[null,null,null,"When finished, type \"Yes\" please"]
[null,null,null,null,0]
[]
[]
["Worksheet 15: Identification of non-climate threats by target"]
["Target"]
["No","Target name","Threat description","Uncertainties","Data sources","Rank",null,{"$f":"IF(F11=\"\",0,1)","v":1},{"$f":"SUM(I12:I5011)","v":0},{"$f":"COUNTIF(J12:J5011, \"=1\")","v":0}]

{"sheet":"Listas","index":17,"n_rows":76,"n_cols":36,"rows_kept":76,"cut":false,"hidden":true,"merged":[[16,11,20,11],[16,12,20,12],[0,8,0,9],[0,11,0,14],[2,11,6,11],[2,12,6,12],[9,11,13,11],[9,12,13,12],[71,12,71,14],[72,12,72,14],[73,12,73,14],[0,35,0,37],[0,29,0,31],[12,29,12,31],[0,16,0,24],[26,12,26,14],[27,12,27,14],[28,12,28,14],[60,12,60,13]]}
["Ecological Targets",null,"Ecosystem Servivce Targets",null,"Socio-economic Targets",null,"Targets",null,"Non_Climate_T",null,null,"BLOQUES DE ENTRADA PARA HOJAS 15, 16, 17, & 19",null,null,null,null,"means: Marca de BordeExterno del bloque a copiar",null,null,null,null,null,null,null,null,null,null,"Adaptation Options",null,"Overall Impact and Resilience scores",null,null,null,null,null,"Summary"]
[null,null,null,null,null,null,null,null,null,null,null,"WS 15",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Resulting overall impact or resilience score","Interpretation for overall climate impact score","Interpretation for overall resilience score"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FG",{"$f":"IF(COUNT(Q3:Q7)=0,0,1)","v":0},{"$f":"IF(AND(COUNTIF(S3:S7,\"=FG\")=5,N3=\"\"),0,COUNTIF(S3:S7,\"=0\"))","v":0},null,null,null,null,null,null,null,null,-4,"The target is expected to experience a highly positive climate impact.","The target has very low resilience."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FG",null,null,null,null,null,null,null,null,null,null,-3,"The target is expected to experience a highly positive climate impact.","The target has very low resilience."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FG",null,null,null,null,null,null,null,null,null,null,-2,"The target is expected to experience a positive climate impact.","The target has low resilience."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FG",null,null,null,null,null,null,null,null,null,null,-1,"The target is expected to experience a positive climate impact.","The target has low resilience."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FG",null,null,null,null,null,null,null,null,null,null,0,"The target is expected to experience a neutral or negligible climate impact.","The target has medium level resilience."]
[null,null,null,null,null,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,"The target is expected to experience negative climate impact.","The target has high resilience."]
[null,null,null,null,null,null,null,null,null,null,null,"WS 16",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"The target is expected to experience negative climate impact.","The target has high resilience."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O10<>\"\", IF(ISERROR(VLOOKUP(AA10, Non_Climate_T, 2, FALSE)),\"--\", VLOOKUP(AA10, Non_Climate_T, 2, FALSE)), \"\")","v":""},null,{"$f":"IF(AND(O10<>\"\",Q10<>\"\"),O10+Q10,\"\")","v":""},null,null,null,null,"FG",{"$f":"IF(COUNT(R10:R14)=0,0,1)","v":0},{"$f":"IF(AND(COUNTIF(W10:W14,\"=FG\")=5,R10=\"\"),0,COUNTIF(W10:W14,\"=0\"))","v":0},null,null,null,null,3,"The target is expected to experience a highly negative climate impact.","The target has very high resilience."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FG",null,null,null,null,null,null,4,"The target is expected to experience a highly negative climate impact.","The target has very high resilience."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FG",null,null,null,null,null,null,"Overall Impact and Resilience scores"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FG",null,null,null,null,null,null,"Score","Interpretation for overall vulnerability score"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-8,"The target has very low relative vulnerability."]
[null,null,null,null,null,null,null,null,null,null,null,"WS 17",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-7,"The target has very low relative vulnerability."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O17<>\"\", IF(ISERROR(VLOOKUP(AA17, Non_Climate_T, 2, FALSE)),\"--\", VLOOKUP(AA17, Non_Climate_T, 2, FALSE)), \"\")","v":""},null,{"$f":"IF(AND(O17<>\"\",Q17<>\"\"),O17+Q17,\"\")","v":""},null,null,null,null,"FG",{"$f":"IF(COUNT(R17:R21)=0,0,1)","v":0},{"$f":"IF(AND(COUNTIF(W17:W21,\"=FG\")=5,R17=\"\"),0,COUNTIF(W17:W21,\"=0\"))","v":0},null,null,null,null,-6,"The target has very low relative vulnerability."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FG",null,null,null,null,null,null,-5,"The target has low relative vulnerability."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FG",null,null,null,null,null,null,-4,"The target has low relative vulnerability."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FG",null,null,null,null,null,null,-3,"The target has low relative vulnerability."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FG",null,null,null,null,null,null,-2,"The target has medium level relative vulnerability."]
[null,null,null,null,null,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,"The target has medium level relative vulnerability."]
[null,null,null,null,null,null,null,null,null,null,null,"WS 19",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"The target has medium level relative vulnerability."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(N24:Q24)>0, 1, 0)","v":0},null,null,null,null,null,null,null,null,null,null,1,"The target has medium level relative vulnerability."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"The target has medium level relative vulnerability."]
[null,null,null,null,null,null,null,null,null,null,null,"WS 20b",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"The target has high relative vulnerability."]
[null,null,null,null,null,null,null,null,null,null,null,"Target Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"The target has high relative vulnerability."]
[null,null,null,null,null,null,null,null,null,null,null,"Target Vulnerability",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"The target has high relative vulnerability."]
[null,null,null,null,null,null,null,null,null,null,null,"Level of confidence in\nthe accuracy of the VA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"The target has very high relative vulnerability."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"The target has very high relative vulnerability."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"The target has very high relative vulnerability."]
[null,null,null,null,null,null,null,null,null,null,null,"WS 21"]
[null,null,null,null,null,null,null,null,null,null,null,"Adaptation option","Reasons for selection","Which targets this addresses"]
[null,null,null,null,null,null,null,null,null,null,null,"Ecosystem options"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Social options"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Engineering options"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Cross-cutting options"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"WS 22"]
[null,null,null,null,null,null,null,null,null,null,null,"Issues influencing\ndecision","Adaptation\noption 1","Score"]
[null,null,null,null,null,null,null,null,null,null,null,"Benefits: what the action will provide"]
[null,null,null,null,null,null,null,null,null,null,null,"Adaptation benefits"]
[null,null,null,null,null,null,null,null,null,null,null,"Other ecological benefits"]
[null,null,null,null,null,null,null,null,null,null,null,"Socio-economic benefits"]
[null,null,null,null,null,null,null,null,null,null,null,"Opportunities: existing things that might make the option more attractive"]
[null,null,null,null,null,null,null,null,null,null,null,"Policy and legislation"]
[null,null,null,null,null,null,null,null,null,null,null,"Community support"]
[null,null,null,null,null,null,null,null,null,null,null,"Existing projects"]
[null,null,null,null,null,null,null,null,null,null,null,"Risks: which could undermine the action, either through it not working, or creating resistance from\ncommunities, or financial risks"]
[null,null,null,null,null,null,null,null,null,null,null,"Ecological / adaptation\nrisks"]
[null,null,null,null,null,null,null,null,null,null,null,"Social risks"]
[null,null,null,null,null,null,null,null,null,null,null,"Economic risks"]
[null,null,null,null,null,null,null,null,null,null,null,"Costs: in terms of money, time, resources, skills, and further collection of information and data"]
[null,null,null,null,null,null,null,null,null,null,null,"Capacity needs"]
[null,null,null,null,null,null,null,null,null,null,null,"Resource needs"]
[null,null,null,null,null,null,null,null,null,null,null,"Research and data needs"]
[null,null,null,null,null,null,null,null,null,null,null,"TOTAL",{"$f":"IF(N39>0, SUM(N46:N60), \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"WS 23"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Overall Scores"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N66<>\"\", VLOOKUP(N66, Impact, 2, TRUE), \"\")","v":""},null,{"$f":"IF(P66<>\"\", VLOOKUP(P66, Impact, 3, TRUE), \"\")","v":""},{"$f":"IF(AND(N66<>\"\", P66<>\"\"), N66-P66, \"\")","v":""},{"$f":"IF(R66<>\"\", VLOOKUP(R66, Vulnerability, 2, TRUE), \"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"When finished, type \"Yes\" please"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"WS 20b"]
[null,null,null,null,null,null,null,null,null,null,null,"Target Name"]
[null,null,null,null,null,null,null,null,null,null,null,"Target Vulnerability"]
[null,null,null,null,null,null,null,null,null,null,null,"Level of confidence in\nthe accuracy of the VA"]
[null,null,null,null,null,null,null,null,null,null,null,"Add a summary of the identified non-climate impacts acting on the target now and in the future (see Worksheet 15)","Add a summary of the identified likely climate impacts (resulting from variability and vulnerability as necessary), including comments on interactions with non-climate impacts (see column 9 in Worksheet 16)","Add a summary of the key internal and external adaptive capacity factors acting on the target(see column 9 in Worksheet 17)","Add a summary of the key data gaps and assumptions that have influenced VA results (refer to column 10 in Worksheets 16 and 17)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(M74,L76,M76,N76,O76)=5,1,0)","v":0}]

{"sheet":"WS16","index":18,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[[8,0,8,9],[9,0,9,1],[9,2,9,3],[9,4,9,5],[9,6,10,6],[9,7,9,9]]}
[12,0,null,null,null,null,null,{"$f":"IF(G1<>\"\", MEDIAN(G1:G5), \"\")","v":""},null,"WS15"]
[null,null,null,null,null,null,null,null,null,0]
[]
[]
[null,null,null,null,"When finished, type \"Yes\" please"]
[null,null,null,null,null,0]
[]
[]
["Worksheet 16: Identification and scoring of climate impacts by target"]
["Target",null,"Top five climate\nimpacts (see Table 6)",null,"Non-climate threats (see\nWorksheet 15)",null,"Cumulative climate\nimpact score","Narrative description of\nclimate impact"]
["No","Name","Climate\nimpact","Score","Non-climate threat acting threat acting on climate impact","Score",null,"Description\nof climate\nimpact","Uncertainties\n/ assumptions","Data sources",null,{"$f":"IF(G11=\"\",0,1)","v":0},{"$f":"SUM(M12:M5011)","v":0},{"$f":"COUNTIF(N12:N5011, \"=1\")","v":0}]

{"sheet":"WS17","index":19,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[[8,0,8,9],[9,0,9,1],[9,6,10,6],[9,2,9,3],[9,4,9,5],[9,7,9,9]]}
[12,0,null,null,null,null,null,{"$f":"IF(G1<>\"\", MEDIAN(G1:G5), \"\")","v":""},null,"WS15","WS16"]
[null,null,null,null,null,null,null,null,null,0,0]
[]
[]
[null,null,null,null,"When finished, type \"Yes\" please"]
[null,null,null,null,null,0]
[]
[]
["Worksheet 17: Identification and scoring of adaptive capacity and resilience factors by target"]
["Target",null,"Adaptive capacity and resilience factors",null,"Non-climate threat",null,"Cumulative score","Narrative section"]
["No","Name","Factors","Score","Non-climate threat name(s) acting on factor","Score",null,"Description of adaptive capacity and resilience factors","Uncertainties/\nAssumptions","Data sources",null,{"$f":"IF(G11=\"\",0,1)","v":0},{"$f":"SUM(M12:M5011)","v":0},{"$f":"COUNTIF(N12:N5011, \"=1\")","v":0}]

{"sheet":"WS Summary","index":20,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[8,0,8,7],[9,0,9,1],[9,2,10,3],[9,4,10,5],[9,6,10,7]]}
[12,1,"Falso"]
[]
[]
[]
[]
[]
[]
[]
["Overall Scores"]
["Target Identification",null,"Overall Climate Impact Score",null,"Overall Adaptive Capacity & Resilience Score",null,"Overall Vulnerability Score"]
["No.","Name"]

{"sheet":"WS18","index":21,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":false,"merged":[[8,0,8,1]]}
[]
[]
[]
[]
[]
[]
[]
[]
["Worksheet 18: Documenting the VA narrative"]
["Level of vulnerability","Relevant target(s)"]
["Very high or high vulnerability",""]
["Drivers of high vulnerability (i.e. exposure, sensitivity, resilience drivers)",""]
["Medium vulnerability",""]
["Drivers of medium vulnerability (i.e.\nexposure, sensitivity, resilience drivers)",""]
["Low or very low vulnerability",""]
["Drivers of low vulnerability (i.e. exposure,\nsensitivity, resilience drivers)",""]
["Overall vision of vulnerability and drivers for\nrelevant targets (< 100 words)",""]

{"sheet":"WS19","index":22,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[8,0,8,5]]}
[11,1,{"$f":"B1=H10","v":false},null,null,null,null,1]
[]
[]
[]
[]
[]
[]
[]
["Worksheet 19: Identifying targets that might require more detailed VA analysis"]
["Target Name","Summary of VA results","Did the VA results indicate a potentially ‘high’ or ‘very high’ degree of relative vulnerability?","Did the VA results indicate that the target could experience a ‘negative’ or ‘highly negative’ climate impact?","Did the VA results indicate that the target has ‘low’ or ‘very low’ adaptive capacity?","Are there one or more ‘unknowns’ or data gaps that affected the ability to draw conclusions?",null,{"$f":"SUM(H11:H1004)","v":0}]

{"sheet":"WS20","index":23,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[[8,0,8,3]]}
[10,0]
[]
[]
[]
[]
[]
[]
[]
["Worksheet 20: Summary results of VA analysis"]

{"sheet":"WS21","index":24,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[8,0,8,2]]}
[0,12,3]
[0,14,{"$f":"AND(A6=0, C3=4)","v":false}]
[0,16,{"$f":"SUM(D3:ALO3)","v":0}]
[0,18]
[null,"When finished, type \"Yes\" please"]
[{"$f":"COUNTIF(A1:A4,\"=0\")","v":4},null,0]
[{"$f":"SUM(A1:A4)","v":0}]
[]
["Worksheet 21: Recording initial climate adaptation options"]

{"sheet":"WS22","index":25,"n_rows":27,"n_cols":101,"rows_kept":27,"cut":false,"hidden":false,"merged":[[8,0,8,6]]}
[2,1]
[]
[]
[]
["When finished, type \"Yes\" please",{"$f":"SUM(C5:CW5)/12=B1","v":false},{"$f":"COUNT(C12:C14,C16:C18,C20:C22,C24:C26)","v":0},null,{"$f":"COUNT(E12:E14,E16:E18,E20:E22,E24:E26)","v":0},null,{"$f":"COUNT(G12:G14,G16:G18,G20:G22,G24:G26)","v":0},null,{"$f":"COUNT(I12:I14,I16:I18,I20:I22,I24:I26)","v":0},null,{"$f":"COUNT(K12:K14,K16:K18,K20:K22,K24:K26)","v":0},null,{"$f":"COUNT(M12:M14,M16:M18,M20:M22,M24:M26)","v":0},null,{"$f":"COUNT(O12:O14,O16:O18,O20:O22,O24:O26)","v":0},null,{"$f":"COUNT(Q12:Q14,Q16:Q18,Q20:Q22,Q24:Q26)","v":0},null,{"$f":"COUNT(S12:S14,S16:S18,S20:S22,S24:S26)","v":0},null,{"$f":"COUNT(U12:U14,U16:U18,U20:U22,U24:U26)","v":0},null,{"$f":"COUNT(W12:W14,W16:W18,W20:W22,W24:W26)","v":0},null,{"$f":"COUNT(Y12:Y14,Y16:Y18,Y20:Y22,Y24:Y26)","v":0},null,{"$f":"COUNT(AA12:AA14,AA16:AA18,AA20:AA22,AA24:AA26)","v":0},null,{"$f":"COUNT(AC12:AC14,AC16:AC18,AC20:AC22,AC24:AC26)","v":0},null,{"$f":"COUNT(AE12:AE14,AE16:AE18,AE20:AE22,AE24:AE26)","v":0},null,{"$f":"COUNT(AG12:AG14,AG16:AG18,AG20:AG22,AG24:AG26)","v":0},null,{"$f":"COUNT(AI12:AI14,AI16:AI18,AI20:AI22,AI24:AI26)","v":0},null,{"$f":"COUNT(AK12:AK14,AK16:AK18,AK20:AK22,AK24:AK26)","v":0},null,{"$f":"COUNT(AM12:AM14,AM16:AM18,AM20:AM22,AM24:AM26)","v":0},null,{"$f":"COUNT(AO12:AO14,AO16:AO18,AO20:AO22,AO24:AO26)","v":0},null,{"$f":"COUNT(AQ12:AQ14,AQ16:AQ18,AQ20:AQ22,AQ24:AQ26)","v":0},null,{"$f":"COUNT(AS12:AS14,AS16:AS18,AS20:AS22,AS24:AS26)","v":0},null,{"$f":"COUNT(AU12:AU14,AU16:AU18,AU20:AU22,AU24:AU26)","v":0},null,{"$f":"COUNT(AW12:AW14,AW16:AW18,AW20:AW22,AW24:AW26)","v":0},null,{"$f":"COUNT(AY12:AY14,AY16:AY18,AY20:AY22,AY24:AY26)","v":0},null,{"$f":"COUNT(BA12:BA14,BA16:BA18,BA20:BA22,BA24:BA26)","v":0},null,{"$f":"COUNT(BC12:BC14,BC16:BC18,BC20:BC22,BC24:BC26)","v":0},null,{"$f":"COUNT(BE12:BE14,BE16:BE18,BE20:BE22,BE24:BE26)","v":0},null,{"$f":"COUNT(BG12:BG14,BG16:BG18,BG20:BG22,BG24:BG26)","v":0},null,{"$f":"COUNT(BI12:BI14,BI16:BI18,BI20:BI22,BI24:BI26)","v":0},null,{"$f":"COUNT(BK12:BK14,BK16:BK18,BK20:BK22,BK24:BK26)","v":0},null,{"$f":"COUNT(BM12:BM14,BM16:BM18,BM20:BM22,BM24:BM26)","v":0},null,{"$f":"COUNT(BO12:BO14,BO16:BO18,BO20:BO22,BO24:BO26)","v":0},null,{"$f":"COUNT(BQ12:BQ14,BQ16:BQ18,BQ20:BQ22,BQ24:BQ26)","v":0},null,{"$f":"COUNT(BS12:BS14,BS16:BS18,BS20:BS22,BS24:BS26)","v":0},null,{"$f":"COUNT(BU12:BU14,BU16:BU18,BU20:BU22,BU24:BU26)","v":0},null,{"$f":"COUNT(BW12:BW14,BW16:BW18,BW20:BW22,BW24:BW26)","v":0},null,{"$f":"COUNT(BY12:BY14,BY16:BY18,BY20:BY22,BY24:BY26)","v":0},null,{"$f":"COUNT(CA12:CA14,CA16:CA18,CA20:CA22,CA24:CA26)","v":0},null,{"$f":"COUNT(CC12:CC14,CC16:CC18,CC20:CC22,CC24:CC26)","v":0},null,{"$f":"COUNT(CE12:CE14,CE16:CE18,CE20:CE22,CE24:CE26)","v":0},null,{"$f":"COUNT(CG12:CG14,CG16:CG18,CG20:CG22,CG24:CG26)","v":0},null,{"$f":"COUNT(CI12:CI14,CI16:CI18,CI20:CI22,CI24:CI26)","v":0},null,{"$f":"COUNT(CK12:CK14,CK16:CK18,CK20:CK22,CK24:CK26)","v":0},null,{"$f":"COUNT(CM12:CM14,CM16:CM18,CM20:CM22,CM24:CM26)","v":0},null,{"$f":"COUNT(CO12:CO14,CO16:CO18,CO20:CO22,CO24:CO26)","v":0},null,{"$f":"COUNT(CQ12:CQ14,CQ16:CQ18,CQ20:CQ22,CQ24:CQ26)","v":0},null,{"$f":"COUNT(CS12:CS14,CS16:CS18,CS20:CS22,CS24:CS26)","v":0},null,{"$f":"COUNT(CU12:CU14,CU16:CU18,CU20:CU22,CU24:CU26)","v":0},null,{"$f":"COUNT(CW12:CW14,CW16:CW18,CW20:CW22,CW24:CW26)","v":0}]
[null,0]
[]
[]
["Worksheet 22: A simple, comparative framework for analysing different adaptation options"]
["Issues influencing\ndecision"]
["Benefits: what the action will provide"]
["Adaptation benefits"]
["Other ecological benefits"]
["Socio-economic benefits"]
["Opportunities: existing things that might make the option more attractive"]
["Policy and legislation"]
["Community support"]
["Existing projects"]
["Risks: which could undermine the action, either through it not working, or creating resistance from\ncommunities, or financial risks"]
["Ecological / adaptation risks"]
["Social risks"]
["Economic risks"]
["Costs: in terms of money, time, resources, skills, and further collection of information and data"]
["Capacity needs"]
["Resource needs"]
["Research and data needs"]
["TOTAL"]

{"sheet":"WS23","index":26,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[8,0,8,5]]}
[11,1]
[]
[]
[]
[null,{"$f":"AND(A7*3=B7,A7<>0)","v":false}]
[]
[{"$f":"(A1-11)","v":0},{"$f":"SUM(D7:F7)","v":0},{"$f":"COUNTA(C11:C5020)","v":0},{"$f":"COUNTA(D11:D5020)","v":0},{"$f":"COUNTA(E11:E5020)","v":0},{"$f":"COUNTA(F11:F5020)","v":0}]
[]
["Worksheet 23: Information on each adaptation option"]
["Target","Adaptation\noption","Score","Adaptation action","Responsible","Period"]

{"sheet":"WS24","index":27,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[[20,0,20,3],[23,0,23,3],[8,0,8,3],[9,0,9,3],[10,0,10,3],[11,0,11,1],[12,0,12,1],[13,0,13,3],[14,0,14,1],[15,0,15,1],[16,0,16,3],[17,0,17,3]]}
[0,13,null,10,null,null,{"$f":"NOT(ISERROR(VLOOKUP(F1, Lista_CLI, 1, FALSE)))","v":false},{"$f":"NOT(ISERROR(VLOOKUP(F1, Lista_BIO, 1, FALSE)))","v":false},{"$f":"NOT(ISERROR(VLOOKUP(F1, Lista_SOC, 1, FALSE)))","v":false}]
[0,16,null,{"$f":"NOT(ISERROR(VLOOKUP(D1, filaGris, 1, FALSE)))","v":false},null,{"$f":"OR(G1, H1, I1)","v":false}]
[0,20,null,{"$f":"IF(D1<=B1, 1, IF(D1<=B2, 2, IF(D1<=B3, 3, IF(D1<=B4, 4, 5))))","v":1},null,null,"Lista_CLI","Lista_BIO","Lista_SOC"]
[0,23]
[0,26]
[]
[]
[]
["Worksheet 24: A monitoring framework for CAMPA"]
["Outputs of CAMPA project"]
["Keeping to the timetable"]
["Stages of adaptation action",null,"Target deadline","Actual time"]
[]
["Keeping to budget"]
["Budget by item",null,"Target cost","Actual cost"]
[]
["Outcomes of CAMPA project"]
["Climate adaptation actions"]
["Indicator","Way of measuring","Baseline data","Data at end of monitoring"]
[]
["Biodiversity impacts"]
["Indicator","Way of measuring","Baseline data","Data at end of monitoring"]
[]
["Socio-economic impacts"]
["Indicator","Way of measuring","Baseline data","Data at end of monitoring"]