Author Topic: One sheet to rule them all...  (Read 85360 times)

letstalkaboutdune

  • 5 O'Clock Shadow
  • *
  • Posts: 8
  • Location: Tucson, AZ, USA
Re: One sheet to rule them all...
« Reply #200 on: January 19, 2018, 01:28:54 PM »
Thank you for this awesome spreadsheet! Starting in January should keep things nice and clean for me. I did make a couple of edits, like removing the Invest sheet (already tracked through Fidelity and Personal Capital), and automatically pulling the monthly Income and Expenses data into the NW tab. Finally, since my discretionary and excess expenses will change each month, I grouped the non-standard categories into a row called "Other" in the FI tab, and that is calculated with whatever's left after the standard categories.

px4shooter

  • 5 O'Clock Shadow
  • *
  • Posts: 8
Re: One sheet to rule them all...
« Reply #201 on: February 08, 2018, 09:40:52 PM »
Thanks for the sheet!!

Awesome calculations, but I am stuck. I still have 3 properties with mortgages. I cannot see how to calculate the other sheets into the main page. I duplicated the mortgage page and set them up, but just having calculation issues.

Any excel tips on this type of setup?