Author Topic: Google Sheet that translates your data into a FIRE Dashboard  (Read 3089 times)

fuegoSS

  • 5 O'Clock Shadow
  • *
  • Posts: 1
Google Sheet that translates your data into a FIRE Dashboard
« on: September 26, 2021, 04:26:39 PM »
For the last few years, I have been working on creating a FIRE Spreadsheet and Dashboard to extract more value from my financial data. The objective was to translate the data into actionable FIRE insights with high-quality visualizations, metrics, and stats. After a lot of work and user-testing, it is now ready to share.

In a nutshell, the Spreadsheet and Dashboard:
- Uses transactions and net worth data as input. With one click, the spreadsheet can be optimized for manual data entry or to receive input from third-party account aggregators (e.g., Mint, Personal Capital).
- Transforms the input data via a combination of custom Google Script, spreadsheet formulas, and minimal user input.
- Outputs a collection of key metrics and professionally built charts that allow you to track and plan your progress towards FIRE.

You can check a complete summary of the features and screenshots here.

I created an installation and user guide that details every section. You can check it here

If you are interested, I am selling it via my Etsy shop (here) and I will be running a promotion (50% off) for a few days.

Thanks for reading!
« Last Edit: November 03, 2021, 05:45:26 PM by fuegoSS »

SESW Tech

  • 5 O'Clock Shadow
  • *
  • Posts: 21
  • Age: 43
  • Location: Corona del Mar, CA
Re: Google Sheet that translates your Mint.com data into a FIRE Dashboard
« Reply #1 on: October 09, 2021, 06:57:08 AM »
This is great - thanks!

 

Wow, a phone plan for fifteen bucks!