Listen to the latest episode of the Jeromecast, JeromeCast Episode 98 Announcing the reform podcast, about the upcoming launch of the Reform Podcast.
A spreadsheet to help choose where to live
In December 2012, my wife and I were planning to leave Singapore. We had been discussing it for months, actually. We kept coming back to the same conversation, though – Where were we going to go? We’re lucky, in the sense that we have dual citizenship options (US/EU) and even some additional options (pre-approval for immigration in another country, Nordic pact open labor markets). So that opened a lot of the world to us. I’ve discussed this with a lot of people over the last couple of years, and I’ve been asked time and again to share my spreadsheet. So here’s the spreadsheet. But importantly, here’s the approach we used to figure out where to live.
- Actually step 0: make your own copy of this spreadsheet. You can copy/paste into OpenOffice, LibreOffice, Excel, Numbers, etc.
- Add as many possible candidate locations to the list as you think you can manage. We started with about 30. Definitely include random, out-of-the-way places that you’ve maybe visited or vacationed in and always wondered about. This is the time to consider them in earnest.
- Go through the evaluation criteria. Feel free to add/remove items that are more relevant for you. We focused on total quality of life, and for us, that meant Education, Weather, Travel, Housing, Cost of living, Social factors, Economy. On Economy, we focused really only on one thing – were there realistic job opportunities.
- For other items, you can look for PISA scores, news articles about each place, etc. Weather.com is good for climate information. Enter a place name, then choose monthly weather, and averages (usually a link at the bottom).
- Note that some items are more subjective, at least when we did it. We rated crime as high, moderate or low.
- Don’t get upset when you start having some disagreements here about the assessments. The only important thing is that you eventually come up with a scale that makes sense for all the people making the decisions.
- Next, figure out a weighting, absolute or implied, for the different factors. This will probably give you a good sense for how important each item is to you.
- Make an overall score. Or don’t. We actually didn’t, but I did set up the spreadsheet in a way that would make it easy and possible. Just add columns for weighting after each, and figure out a way to try to normalize to a score range, like possible points out of 100.
- Make your first round of cuts. This was tough for us. Inevitably, you will have some emotional attachment to at least one place that gets cut. This is just how it goes, unfortunately. There are lots of great places around the world, but the reality is that many will lack good schools or economic opportunity or who knows what.
- Do another round of research. This is a tip from my father, who often said, “When you’re trying to make a big decision, and you don’t know what to do yet, gather information.” He’s a data visionary apparently.
- Go back into your ratings. Re-assess. Discuss.
- Refine your scores.
- Make your second round of cuts. Ideally, at this point, you’ll be down to just 3 locations, maybe 4. You need this round to be manageable.
- I recommend visiting all the places, if that’s at all feasible. And, beyond that – try to go local as much as possible.
- Use sites that let you stay at people’s homes/apartments, etc, so you get a feel for what real living environments are like. If you’re lucky, you’ll even get a chance to talk to the owner to understand what utilities cost, what transportation is like, etc. And do some shopping in local grocery stores.
Hopefully this helps. It’s not a firm approach, but it’s a set of guidelines that might work for you. Ping me if you have questions or want to talk personally about how my wife and I used this approach to make our own decision.
i don’t think i’d like to live in a missile silo, nor do i believe that a nuclear (or zombie) apocalypse is coming. but some people do. the jeromecast talks about missile silo condo buyers.
I just watched an Aussie documentary / reality show about refugees and people’s views on them. The premise is to show folks with very strong anti-refugee sentiment, what life is really like for the people who do flee their home countries.
It really hit home for me, especially seeing the plight of the children. You can make a technical argument that the adults are often breaking the law getting on illegal people smuggling boats, and even that the adults know it. But the kids… They are only guilty of being born in the wrong place at the wrong time.
The other point that hit me hard is just watching how people struggle. I’m pretty sure that more than half of the world’s population is still just struggling for the basics: safety, shelter, food, water and peace. Everything else, including education, work, not to speak of happiness, is secondary.
If you are reading this, be thankful you are so lucky. Most aren’t.
listen to the latest jeromecast about a coal mine island, and why people lived there.
on the latest jeromecast about happiness vs success and in what order, i highlight a great tedxtalk on the subject. enjoy!
listen to the latest episode on speeding and harsh fines.