How am I supposed to decide if I need to bug out, or stay put and settle in? I had no idea how to answer the question, so I did what I do at work all day anyway. I made Excel spreadsheets. Why the hell not. First, I built a spreadsheet that calculates a value for bugging out versus a value for staying put. My idea was that the higher value would be the right choice. I used things that I thought might affect the decision, dealing with preparation, availability of resources, etc. I then averaged them for two groups, the stay and the bug out. I then divided them by another factor, based on relative closeness to a major population center, and number of people in that population center. Lets be honest, cities are going to be absolute mayhem when SHTF (Think post Katrina New Orleans). I filled out the spreadsheet for my values, and this is what I came up with.
Then, just toying around, I built a table, creating a score for distance vs. population, where a higher score is achieved the further you are from a city, and the smaller that city is. I then created two graphs to compare the effects of changing either distance or population changes. Check it out.
There is no science invovled in either of these. I don’t give a shit. If you want a copy of either to toy around with, or if you have suggestions on how I could improve either, shoot me an email at email@example.com.