Author Topic: Google Sheets Can Do Maps - Where Can I FIRE Map  (Read 1052 times)

tarheeldan

  • Pencil Stache
  • ****
  • Posts: 620
Google Sheets Can Do Maps - Where Can I FIRE Map
« on: March 15, 2017, 12:32:50 PM »
I stumbled on the map feature and made a template:
https://docs.google.com/spreadsheets/d/1HteFXoLFbX0StRAXflAnoqKtv6qt2rj3FbZUL9QYtn0/edit?usp=sharing

You put in the size of your stash and it tells you where you can retire on 4% SWR. If you want to padd things, you can increase to a higher % of average household income in each country e.g. 125% or 150%.

shaybro

  • 5 O'Clock Shadow
  • *
  • Posts: 40
  • Location: PDX Suburb
Re: Google Sheets Can Do Maps - Where Can I FIRE Map
« Reply #1 on: March 15, 2017, 02:29:40 PM »
The resolution is a little coarse but the template will be useful for comparing cities or states within a country as long as you can find reliable information on household income. Thank you for sharing.

SwordGuy

  • Magnum Stache
  • ******
  • Posts: 2693
  • Location: Fayetteville, NC
Re: Google Sheets Can Do Maps - Where Can I FIRE Map
« Reply #2 on: March 15, 2017, 06:48:20 PM »
I can assure you that most readers of this blog do NOT want to live at the standard of living of the average person in many, if not most, countries.


respond2u

  • 5 O'Clock Shadow
  • *
  • Posts: 42
Re: Google Sheets Can Do Maps - Where Can I FIRE Map
« Reply #3 on: March 15, 2017, 07:35:36 PM »
I stumbled on the map feature and made a template:
https://docs.google.com/spreadsheets/d/1HteFXoLFbX0StRAXflAnoqKtv6qt2rj3FbZUL9QYtn0/edit?usp=sharing

You put in the size of your stash and it tells you where you can retire on 4% SWR. If you want to padd things, you can increase to a higher % of average household income in each country e.g. 125% or 150%.

That's cool, tarheel!

Luckyvik

  • Stubble
  • **
  • Posts: 116
  • Age: 47
Re: Google Sheets Can Do Maps - Where Can I FIRE Map
« Reply #4 on: March 15, 2017, 08:21:55 PM »
Thanks for sharing!


Sent from my iPhone using Tapatalk

HAPPYINAZ

  • Bristles
  • ***
  • Posts: 267
Re: Google Sheets Can Do Maps - Where Can I FIRE Map
« Reply #5 on: March 16, 2017, 11:32:58 AM »
That's cool, thanks!

GreenShirt

  • 5 O'Clock Shadow
  • *
  • Posts: 18
Re: Google Sheets Can Do Maps - Where Can I FIRE Map
« Reply #6 on: March 16, 2017, 11:40:45 AM »
This is super cool! If I wanted to use this for my own nefarious purposes, could you explain how you did it / link me to where you found out how to?

tarheeldan

  • Pencil Stache
  • ****
  • Posts: 620
Re: Google Sheets Can Do Maps - Where Can I FIRE Map
« Reply #7 on: March 16, 2017, 11:55:55 AM »
This is super cool! If I wanted to use this for my own nefarious purposes, could you explain how you did it / link me to where you found out how to?

Sure! There are two kinds:

Line map: https://developers.google.com/chart/interactive/docs/gallery/geochart

Satellite map, like the one used in the map of mustachians somewhere in the forum: https://developers.google.com/chart/interactive/docs/gallery/map

2Birds1Stone

  • Magnum Stache
  • ******
  • Posts: 2737
  • Age: 29
  • Location: New York
  • CFO
Re: Google Sheets Can Do Maps - Where Can I FIRE Map
« Reply #8 on: March 16, 2017, 01:17:28 PM »
I stumbled on the map feature and made a template:
https://docs.google.com/spreadsheets/d/1HteFXoLFbX0StRAXflAnoqKtv6qt2rj3FbZUL9QYtn0/edit?usp=sharing

You put in the size of your stash and it tells you where you can retire on 4% SWR. If you want to padd things, you can increase to a higher % of average household income in each country e.g. 125% or 150%.

Super neat, it appears however that changing the percentage value in the yellow field does not affect the results.
"A small house can hold as much happiness as a big one." - Fortune Cookie

35 Months Till "Gap Year" - Stop by, or stay a while.....
https://forum.mrmoneymustache.com/journals/fire-by-thirty-five-chronicles-36-months-till-sabbatical!/

tarheeldan

  • Pencil Stache
  • ****
  • Posts: 620
Re: Google Sheets Can Do Maps - Where Can I FIRE Map
« Reply #9 on: March 16, 2017, 01:29:14 PM »
I stumbled on the map feature and made a template:
https://docs.google.com/spreadsheets/d/1HteFXoLFbX0StRAXflAnoqKtv6qt2rj3FbZUL9QYtn0/edit?usp=sharing

You put in the size of your stash and it tells you where you can retire on 4% SWR. If you want to padd things, you can increase to a higher % of average household income in each country e.g. 125% or 150%.

Super neat, it appears however that changing the percentage value in the yellow field does not affect the results.

Blast! Forgot to copy down the formula :-) Good catch, fixed!

2Birds1Stone

  • Magnum Stache
  • ******
  • Posts: 2737
  • Age: 29
  • Location: New York
  • CFO
Re: Google Sheets Can Do Maps - Where Can I FIRE Map
« Reply #10 on: March 16, 2017, 08:25:52 PM »
Blast! Forgot to copy down the formula :-) Good catch, fixed!

Obliged =)
"A small house can hold as much happiness as a big one." - Fortune Cookie

35 Months Till "Gap Year" - Stop by, or stay a while.....
https://forum.mrmoneymustache.com/journals/fire-by-thirty-five-chronicles-36-months-till-sabbatical!/

themagicman

  • Bristles
  • ***
  • Posts: 311
  • Age: 26
  • Location: Atlanta, GA
Re: Google Sheets Can Do Maps - Where Can I FIRE Map
« Reply #11 on: March 17, 2017, 09:19:02 AM »
Thanks for sharing!

Lordy

  • Stubble
  • **
  • Posts: 101
Re: Google Sheets Can Do Maps - Where Can I FIRE Map
« Reply #12 on: March 17, 2017, 02:40:02 PM »
Very nicely done!

Also confirms my assumption that the required stash for Germany would be around 800K USD or 750K EUR :-)

yachi

  • Stubble
  • **
  • Posts: 106
Re: Google Sheets Can Do Maps - Where Can I FIRE Map
« Reply #13 on: March 17, 2017, 03:30:19 PM »
Thanks for sharing.  I now have dreams of chilling on a beach in Mexico, living off part of my 'Stache while allowing the rest to grow and support my US retirement.

tarheeldan

  • Pencil Stache
  • ****
  • Posts: 620
Re: Google Sheets Can Do Maps - Where Can I FIRE Map
« Reply #14 on: March 17, 2017, 09:06:02 PM »
Thanks for sharing.  I now have dreams of chilling on a beach in Mexico, living off part of my 'Stache while allowing the rest to grow and support my US retirement.
Right?! I foresee having to strongly fight the itch to do that in South East Asia when I get close to bare-bones FI (US) :-)