Beautiful FI Spreadsheets?

[Genevieve]

I've decided it's time to make a nice and pretty FI spreadsheet with graphs to mark my progress to FI.

Does anyone have an Excel or Google doc template they love? Maybe make a screenshot to show us if making a template isn't easy.

What numbers do you like to use to mark your progress?

I looked up spreadsheet on the forums, but considering the number of nerds here, it brought up a ridiculous number of posts. Besides, this will be a nice chance to oogle over pretty spreadsheets.

[MDM]

If you find one in http://forum.mrmoneymustache.com/welcome-to-the-forum/spreadsheet-collection/, great!

Or, if you find a good one somewhere else, have it added to the above thread - the more the merrier (up to a point...). :)

[kpd905]

Find C40 in the journal section, he has some great stuff and has been willing to share everytime I ask.

[arebelspy]

Mine aren't pretty at all.  They're dirty hack jobs. Gritty as *.  But they get the job done.  ;)

I've learned way more making my own and improving them over time than I would have plugging my numbers into someone's pretty spreadsheet.

(Plus my situation is quite different than most.)

But some of the stuff people do looks pretty damn fantastic.  :D

[4alpacas]

I'm in the same boat as arebelspy.  My sheets are basic without visual appeal.  However, I've written every equation, created every graph, and filled in the categories to fit my life.  However, FliXFantatier's workbook makes me want to add something "pretty" to my sheets. 

[matchewed]

Function over form for me too, they turn ugly but I know how to use 'em.

[BBub]

Flix, that's a work of art.  I thought mine were pretty, but now I'm not so sure. 

I agree with others that tinkering and building your own is far more valuable than plugging numbers into an existing template.  I track all kinds of silly metrics, but the only one I really care about at this point (early accumulation phase) is Liquid Assets categorized into qualified and taxable.  When I get a little closer to FI others will become more important.  IMO, prioritizing which metrics to focus on is more important than having a mega spreadsheet.

[Genevieve]

@FliXFantatier Those are some beautiful spreadsheets.

I pulled the spreadsheets from the link that MDM provided and from C40's journal. I'm going to use those as a base to make my own spreadsheet.

Function is definitely more important, but pretty spreadsheets and graphs are fun too. It's like art, right? :P

Pretty stats ted talk:
http://www.ted.com/talks/hans_rosling_shows_the_best_stats_you_ve_ever_seen?language=en

[lifejoy]

@FliXFantatier Those are some beautiful spreadsheets.

I pulled the spreadsheets from the link that MDM provided and from C40's journal. I'm going to use those as a base to make my own spreadsheet.

Function is definitely more important, but pretty spreadsheets and graphs are fun too. It's like art, right? :P

Pretty stats ted talk:
http://www.ted.com/talks/hans_rosling_shows_the_best_stats_you_ve_ever_seen?language=en

Nice link

[marty998]

This (attached) is the (cleaned up, personal data changed) balance sheet that I use these days.

I have a P&L, prefer to keep things simple.


That line doesn't make any sense lol

meant to read "I don't have a P&L, because it was all too hard to capture and I prefer to keep things simple".

There is the danger laid bare of typing furiously fast and hitting post whilst running out of a train door so as not to miss my stop...

[aceyou]

My spreadsheets look ugly, but they give me exactly what I want.  But basically I'm just saying that to make myself feel better...secretly I'm jealous of how beautiful these spreadsheets of yours look!!!