Quote:
Originally Posted by halfamazing
Thanks for this man.
Hope you don't mind if I download and use it locally.
I'm going to adjust the Total Owed row to take into account any payments made and update it so it shows how much is left per statue.
(something trivial I noticed)... In 2018 your months go JUL, AUG, OCT (there's no September).
BTW, nice touch with the Status lol. I'm in the ":|" stage
|
I uh don't recognize September in 2018, it was definitely on purpose <.< >.> Thanks for the find, fixed ;p It's not trivial so I appreciate you pointing it out.
Sure I don't mind if you DL and use it locally, I actually plan on doing that though, a couple days after the payment date passes I plan on changing the text to red and removing it from the calculations so it won't show up in the total remaining or total owed on the last page. If you dled that's why I did the formula for the total remaining as addition for each cell individually instead of just a sum with the range.
Hopefully I can keep up with it, it's a bit of an ambitious spreadsheet, though the last page is the most effort. I think it's really helpful though to see how much you'll have to pay every month to make sure you don't go nuts so gonna try my best ;p I am also in :| territory too, although just barely.
Quote:
Originally Posted by Dark_Hado
2 payments left
April 22
June 22
|
Ah ok thanks, I'll get it added tomm. I assume it's for both the triple pack and singletons?