Maybe I can give a few thoughts on Chile to help your search.
Average temperature may be confusing, given that Arica is currently too hot for agriculture, and Tierra del Fuego is too cold for agriculture, I think a temperature change would just change where the agriculture was happening (this seems really critical, changing Chile’s temperature rating can make it overtake Uruguay in your spreadsheet)
Chile already has desalination plants for the mining industry, which is promising for building more desalination plants to support agriculture (as I can’t predict what effect a nuclear winter would have on rain patterns)
[If this is about where to move to] The speed and transparency of the visa process is important, as a recent immigrant to Chile, I’d say transparency is good and speed is average (~3 months)
[If this is about where to move to] Population density and sentiment towards immigrants seem important—outside of the Region Metropolitano, there is very obviously space in Chile—and it is a great place to be an immigrant if (and only if) you have a white collar job
Not specific to Chile
Years of education is a component of HDI, if you have already completed your education, I don’t think this effects you so much (also caring about years in education rather than quantity learnt seems to be missing the point). As such I’d recommend using GDP per capita (PPP) and life expectancy
Crime is likely to spike in a crisis, I’d prefer to be somewhere with low current crime rates
I think you should penalise landlocked countries, as this does add a dependency on other countries and you need things to go right in more places
When I look at the top places in the Food Security Index, I have places like the UK in #3 spot, despite the fact that it imports a large share of it’s food. Even if I rank by the “natural resources and resilience” sub-index—I see net food importers surprisingly high in the list (and Norway and Finland are #1 and 2 in the natural resources and resilience sub-index. I would not like to be farming in Norway and Finland after global temperatures drop)
I am somewhat sceptical of the global peace index—just based on a quick investigation, it has the UK as more peaceful than Chile—scoring Chile worse in “ongoing conflict” and “safety and security”—this is despite the UK frequently deploys troops abroad, the UK has multiple regions that want to break away, and Chile has not been involved in a war since WW2 - I haven’t fully unpacked this, but to me it doesn’t pass a sniff test
After looking into how average temperatures are calculated, I get “Average yearly temperature is calculated by averaging the minimum and maximum daily temperatures in the country, averaged for the years 1961–1990, based on gridded climatologies from the Climatic Research Unit elaborated in 2011.”
This means a country like France, that is mostly quite warm, but also has Mont Blanc, where it will be cold at the top, would look significantly cooler than it is.
Maybe I can give a few thoughts on Chile to help your search.
Average temperature may be confusing, given that Arica is currently too hot for agriculture, and Tierra del Fuego is too cold for agriculture, I think a temperature change would just change where the agriculture was happening (this seems really critical, changing Chile’s temperature rating can make it overtake Uruguay in your spreadsheet)
Chile already has desalination plants for the mining industry, which is promising for building more desalination plants to support agriculture (as I can’t predict what effect a nuclear winter would have on rain patterns)
[If this is about where to move to] The speed and transparency of the visa process is important, as a recent immigrant to Chile, I’d say transparency is good and speed is average (~3 months)
[If this is about where to move to] Population density and sentiment towards immigrants seem important—outside of the Region Metropolitano, there is very obviously space in Chile—and it is a great place to be an immigrant if (and only if) you have a white collar job
Not specific to Chile
Years of education is a component of HDI, if you have already completed your education, I don’t think this effects you so much (also caring about years in education rather than quantity learnt seems to be missing the point). As such I’d recommend using GDP per capita (PPP) and life expectancy
Crime is likely to spike in a crisis, I’d prefer to be somewhere with low current crime rates
I think you should penalise landlocked countries, as this does add a dependency on other countries and you need things to go right in more places
When I look at the top places in the Food Security Index, I have places like the UK in #3 spot, despite the fact that it imports a large share of it’s food. Even if I rank by the “natural resources and resilience” sub-index—I see net food importers surprisingly high in the list (and Norway and Finland are #1 and 2 in the natural resources and resilience sub-index. I would not like to be farming in Norway and Finland after global temperatures drop)
I am somewhat sceptical of the global peace index—just based on a quick investigation, it has the UK as more peaceful than Chile—scoring Chile worse in “ongoing conflict” and “safety and security”—this is despite the UK frequently deploys troops abroad, the UK has multiple regions that want to break away, and Chile has not been involved in a war since WW2 - I haven’t fully unpacked this, but to me it doesn’t pass a sniff test
After looking into how average temperatures are calculated, I get “Average yearly temperature is calculated by averaging the minimum and maximum daily temperatures in the country, averaged for the years 1961–1990, based on gridded climatologies from the Climatic Research Unit elaborated in 2011.”
This means a country like France, that is mostly quite warm, but also has Mont Blanc, where it will be cold at the top, would look significantly cooler than it is.
I think using the average temperature of the capital city is more useful, as this gives you the temperature in the place that the people are (https://en.wikipedia.org/wiki/List_of_cities_by_average_temperature)