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

tarheeldan

  • Pencil Stache
  • ****
  • Posts: 907
  • Location: Plano, TX
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%.

TreesBikesLove

  • 5 O'Clock Shadow
  • *
  • Posts: 69
  • 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

  • Walrus Stache
  • *******
  • Posts: 8955
  • 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

  • Stubble
  • **
  • Posts: 119
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: 237
  • Age: 45
  • Location: Sydney, Australia
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: 382
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: 68
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: 907
  • Location: Plano, TX
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

  • Walrus Stache
  • *******
  • Posts: 7916
  • Age: 1
  • Location: Earth
  • K Thnx Bye
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.

tarheeldan

  • Pencil Stache
  • ****
  • Posts: 907
  • Location: Plano, TX
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

  • Walrus Stache
  • *******
  • Posts: 7916
  • Age: 1
  • Location: Earth
  • K Thnx Bye
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 =)

themagicman

  • Bristles
  • ***
  • Posts: 401
  • Age: 33
  • 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: 157
  • Location: Germany
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

  • Handlebar Stache
  • *****
  • Posts: 1141
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: 907
  • Location: Plano, TX
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) :-)