Join Early Retirement Today
Closed Thread
 
Thread Tools Search this Thread Display Modes
Old 08-13-2015, 12:41 PM   #21
Dryer sheet wannabe
 
Join Date: Feb 2012
Posts: 10
Quote:
Originally Posted by RunningBum View Post
I see how I can sort the spreadsheet columns but I don't see how to change the formulas to weight the factors, if, say, I would want to filter out the super hot summers rather than the cold winters, and want to eliminate the Obama vote factor. So I don't know how to get results to show anything other than places that ponchoape might consider living. That's not a general "best places to ER list". Maybe I'm missing something in the spreadsheet options.
Google Spreadsheets are pretty decent, but they are not perfect. You should be able to open that spreadsheet link, select "File" -> "Download As" -> then select "Excel .xlsx"

Then this will allow you to download/open in Excel and mess with the filters and make more changes with more flexibility.

Hope that helps!!
__________________

__________________
ponchoape is offline  
Join the #1 Early Retirement and Financial Independence Forum Today - It's Totally Free!

Are you planning to be financially independent as early as possible so you can live life on your own terms? Discuss successful investing strategies, asset allocation models, tax strategies and other related topics in our online forum community. Our members range from young folks just starting their journey to financial independence, military retirees and even multimillionaires. No matter where you fit in you'll find that Early-Retirement.org is a great community to join. Best of all it's totally FREE!

You are currently viewing our boards as a guest so you have limited access to our community. Please take the time to register and you will gain a lot of great new features including; the ability to participate in discussions, network with our members, see fewer ads, upload photographs, create a retirement blog, send private messages and so much, much more!

Old 08-13-2015, 01:41 PM   #22
Moderator
rodi's Avatar
 
Join Date: Apr 2012
Location: San Diego
Posts: 8,817
Interesting exercise. I agree with the mild winters thing - but I'd (personally, just me) have to add in mild SUMMERS. I could not tolerate many (most) of your locations because humidity and temps regularly over 100 are deal breakers for me.

But it's a neat map for outlining your criteria.
__________________

__________________
Retired June 2014. No longer an enginerd - now I'm just a nerd.
micro pensions 7%, rental income 18%
rodi is offline  
Old 08-13-2015, 01:54 PM   #23
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
RunningBum's Avatar
 
Join Date: Jun 2007
Posts: 5,182
Quote:
Originally Posted by ponchoape View Post
Google Spreadsheets are pretty decent, but they are not perfect. You should be able to open that spreadsheet link, select "File" -> "Download As" -> then select "Excel .xlsx"

Then this will allow you to download/open in Excel and mess with the filters and make more changes with more flexibility.

Hope that helps!!
OK, thanks. Might try that for entertainment purposes, since I'm not looking to move.
__________________
RunningBum is offline  
Old 08-13-2015, 02:05 PM   #24
Recycles dryer sheets
 
Join Date: Dec 2014
Posts: 61
Wow, I chose the arrowhead region of Minnesota, that's about as far from any chosen location on the map....I'm going there anyway.
__________________
Del Q is offline  
Old 08-13-2015, 05:41 PM   #25
Thinks s/he gets paid by the post
target2019's Avatar
 
Join Date: Dec 2008
Posts: 3,708
Quote:
Originally Posted by ponchoape View Post
Google Spreadsheets are pretty decent, but they are not perfect. You should be able to open that spreadsheet link, select "File" -> "Download As" -> then select "Excel .xlsx"

Then this will allow you to download/open in Excel and mess with the filters and make more changes with more flexibility.

Hope that helps!!
For those that have gmail account, you can "Make a Copy" of the spreadsheet. It ends up on your google drive, and you can make changes there.
__________________
target2019 is online now  
Old 08-13-2015, 06:26 PM   #26
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
pb4uski's Avatar
 
Join Date: Nov 2010
Location: Vermont & Sarasota, FL
Posts: 16,428
I've considered McAllen/Brownsville TX area as a possible winter haven but wonder about how safe it is being so close to Mexico. Any experience here?
__________________
If something cannot endure laughter.... it cannot endure.
Patience is the art of concealing your impatience.
Slow and steady wins the race.
pb4uski is offline  
Old 08-13-2015, 06:29 PM   #27
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
REWahoo's Avatar
 
Join Date: Jun 2002
Location: Texas Hill Country
Posts: 42,107
I think audrey1 lives in that area. Maybe she'll comment.
__________________
Numbers is hard

When I hit 70, it hit back

Retired in 2005 at age 58, no pension
REWahoo is offline  
Old 08-13-2015, 06:48 PM   #28
Thinks s/he gets paid by the post
 
Join Date: May 2008
Posts: 3,422
Costs and weather are important factors but lifestyle and standard of living may not account for them.

Bigger cities tend to vote more liberal so you'd think the bias would be for bigger cities but of course they're also more expensive to live in, so they all are the dark pins.

You always get best cities lists all the time. This list is certainly a departure from that, other than it mostly picking out medium sized cities in the southern parts of the country.
__________________
explanade is offline  
Old 08-13-2015, 08:16 PM   #29
Thinks s/he gets paid by the post
 
Join Date: Feb 2014
Posts: 1,050
You need to add a "Medicaid Expanded Y/N" column. For some this is an important option that needs to be considered.
__________________
jim584672 is offline  
Old 08-13-2015, 10:46 PM   #30
Recycles dryer sheets
 
Join Date: May 2008
Location: Treasure Coast
Posts: 339
I guess if you think a liberal leaning place makes it better to retire in, but when I realized more voters for Obama improved the ranking of places, I threw up in my mouth a little.
__________________
45th Birthday is offline  
Old 08-13-2015, 11:33 PM   #31
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
audreyh1's Avatar
 
Join Date: Jan 2006
Location: Rio Grande Valley
Posts: 16,471
Quote:
Originally Posted by Big_Hitter View Post
well yeah you can't beat the rio grande valley with those criteria - I hope you like very hot, humid summers tho


I was dove hunting around McAllen one September and it was so hot the soles of my boots fell off in the field lol
It is really hot here right now, but it's not humid. Humidity drops into the 40s early in the afternoon and stays down during the evening.

Farther east on the TX coast it's way more humid.
__________________
Well, I thought I was retired. But it seems that now I'm working as a travel agent instead!
audreyh1 is online now  
Old 08-13-2015, 11:37 PM   #32
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
audreyh1's Avatar
 
Join Date: Jan 2006
Location: Rio Grande Valley
Posts: 16,471
Quote:
Originally Posted by pb4uski View Post
I've considered McAllen/Brownsville TX area as a possible winter haven but wonder about how safe it is being so close to Mexico. Any experience here?
Proximity to Mexico is not a safety problem. There is a high law enforcement presence watching the border. It's a very popular winter destination - 150,000 Winter Texans come down every winter - that's a population increase of 10%.

If you look at the crime statistics, McAllen, for example, is safer than many Texas cities. Few of us cross the border - that's where it's really dangerous.

The FBI's List of the Most Dangerous Cities in Texas - Texas Monthly
__________________
Well, I thought I was retired. But it seems that now I'm working as a travel agent instead!
audreyh1 is online now  
Old 08-14-2015, 12:23 AM   #33
Recycles dryer sheets
 
Join Date: Mar 2014
Posts: 257
Temple TX is not liberal. Nor are Waco or Round Rock.

Not sure where those stats come from.

I have worked in Austin, Temple, Round Rock and several other towns in the central TX corridor.

Just sayin'.


Sent from my iPhone using Early Retirement Forum
__________________
iac1003 is offline  
I did some research and came up with a list of the 50 Best US Cities for Earl...
Old 08-14-2015, 04:32 AM   #34
Recycles dryer sheets
wingfooted's Avatar
 
Join Date: Jul 2011
Location: Oregon - Dry Side
Posts: 218
I did some research and came up with a list of the 50 Best US Cities for Earl...

Nice list. I have varying criteria- conservative, Republican, cold weather a plus. So I can just take the map and re- label as 50 worst cities to retire.
__________________
wingfooted is offline  
Old 08-14-2015, 05:35 AM   #35
Administrator
Gumby's Avatar
 
Join Date: Apr 2006
Posts: 10,146
Let's knock off the political commentary (directed to the thread participants in general, not any particular person). Thank you.
__________________
Living an analog life in the Digital Age.
Gumby is offline  
Old 08-14-2015, 12:40 PM   #36
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
NW-Bound's Avatar
 
Join Date: Jul 2008
Posts: 19,420
The OP started the thread by using a political criterion to rank potential retirement places. That doomed the thread from start, and there's not much to salvage.
__________________
"Old age is the most unexpected of all things that can happen to a man" -- Leon Trotsky
NW-Bound is online now  
Old 08-14-2015, 01:13 PM   #37
Moderator
MichaelB's Avatar
 
Join Date: Jan 2008
Location: Rocky Inlets
Posts: 24,455
Quote:
Originally Posted by NW-Bound View Post
The OP started the thread by using a political criterion to rank potential retirement places. That doomed the thread from start, and there's not much to salvage.
Identifying the political leaning of an area is a valid criterion for selecting a retirement location. Gumby's warning was not about using it to rank, it was about discussing the politics. The thread is about location.
__________________
MichaelB is offline  
Old 08-14-2015, 03:16 PM   #38
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
Midpack's Avatar
 
Join Date: Jan 2008
Location: Chicagoland
Posts: 11,974
Quote:
Originally Posted by rodi View Post
Interesting exercise. I agree with the mild winters thing - but I'd (personally, just me) have to add in mild SUMMERS. I could not tolerate many (most) of your locations because humidity and temps regularly over 100 are deal breakers for me.

But it's a neat map for outlining your criteria.
+1
__________________
No one agrees with other people's opinions; they merely agree with their own opinions -- expressed by somebody else. Sydney Tremayne
Retired Jun 2011 at age 57

Target AA: 60% equity funds / 35% bond funds / 5% cash
Target WR: Approx 2.5% Approx 20% SI (secure income, SS only)
Midpack is offline  
Old 08-14-2015, 03:57 PM   #39
Full time employment: Posting here.
Silver's Avatar
 
Join Date: Sep 2010
Location: Orlando, Fl
Posts: 580
Side comment...I LOVE THE MODERATORS HERE!


Back to the thread.......
__________________
Silver is offline  
Old 08-14-2015, 03:57 PM   #40
Thinks s/he gets paid by the post
target2019's Avatar
 
Join Date: Dec 2008
Posts: 3,708
Thank you, Mods.

OP , how did you actually rank the cities.

I downloaded to a google sheet of my own, and was wondering how ya did that map.

Or, pick other criteria if it helps explain things.

Again, thanks for doing this project.
__________________

__________________
target2019 is online now  
Closed Thread


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Did some !&%^!!#$% person help you to retire early? Chuckanut Life after FIRE 60 02-16-2012 08:56 AM
Name Some US Cities With Rapid Transit? haha Health and Early Retirement 39 03-10-2007 02:22 PM
List of Best Cities to retire dowab Other topics 13 12-14-2005 08:55 PM

 

 
All times are GMT -6. The time now is 12:32 AM.
 
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.