We’d like to remind Forumites to please avoid political debate on the Forum.
This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
Anyone else addicted to Excel spreadsheets?
immoral_angeluk
Posts: 24,506 Forumite
I seem to have found a new addiction to excel spreadsheets and formulas...
So far in my 'budget workbook' I have a daily spend sheet which works out how much you've spent altogther and how much we've got left out of our budget with a little table which says how much money we'll have leftover after that, bills etc has gone. Next I've done a monthly budget sheet up until december with the bills, wages, tax credits etc andany 'one offs' like birthdays etc so we can see how much is left over which also works out how much we could save towards our citi card to pay it off by december.. Finally I've done a big sheet with all the days of the month up to december with what goes in and out baring in mind weekends, bank holidays etc..
I've now come to a stumbling block as I can't think of anything else to do a spreadsheet for!
Am I a nerd??? What has everyone else got?
So far in my 'budget workbook' I have a daily spend sheet which works out how much you've spent altogther and how much we've got left out of our budget with a little table which says how much money we'll have leftover after that, bills etc has gone. Next I've done a monthly budget sheet up until december with the bills, wages, tax credits etc andany 'one offs' like birthdays etc so we can see how much is left over which also works out how much we could save towards our citi card to pay it off by december.. Finally I've done a big sheet with all the days of the month up to december with what goes in and out baring in mind weekends, bank holidays etc..
I've now come to a stumbling block as I can't think of anything else to do a spreadsheet for!
Am I a nerd??? What has everyone else got?
Total 'Failed Business' Debt £29,043
Que sera, sera.
Que sera, sera.
0
Comments
-
They seem to be really helpful to lots of people, but I dont understand them! lol
I dont know how to put one together or how it really works 
sf xBe who you are and say what you feel because those who mind don't matter and those who matter don't mind.
Personal Finance Blogger + YouTuber / In pursuit of FIRE
0 -
I am SOOO addicted to my debt spreadsheet. I just keep coming up with new pretty graphs to show how much I have repaid, how much is left, the rate of repayment, expected debt-free date, etc, etc, etc :-)
When I am debt free I think I will stop being so obsessive about it!Official DFW Nerd Club - Member no. 503
Debt: February 2006: -£26,773.76
May 2008: £0.00 Woooooo-oooo hoooooo!!:j
Nowsaving for house deposit:
March 2009: +£19,000 (approx)0 -
I've got pretty much the same and it's interesting (!) to look back since I started it in October 2005!!
The new exciting bit for me is I have incorporated the savings accounts (ISA, Reg Saver, other) so I can watch it growing as one amount - up to £2,800 since 1st March. :j
Nerd - probably, money wise - definitely. And I say there's nothing wrong with that.
Back on the DFW Wagon:
CC - £3,300 on 0% til 04/2020
CC - £4,500 on 0% til 02/2019
Loan - £12,063.84 as at 4/1/180 -
No idea how they work or how to do one, dare not even try :eek: - thick or what? lol
Plain pen and paper works for me lol.
Hats off to you though :T0 -
TBH I had no idea what I was doing and just started playing around. It soon clicks (Maybe I did learn something at college afterall.. lol) and in no time I had all sorts of things going on.. lol.Total 'Failed Business' Debt £29,043
Que sera, sera.
0 -
Oh, I can relate to this! I made myself a snowball spreadsheet and keep track of the total interest that I'll have paid by my debt-free date. Then when I overpay, I can see that total interest going down - that's my biggest motivator!0
-
How do you work out the interest then? Was trying to do a snowball calculator but it was never working it out right!Total 'Failed Business' Debt £29,043
Que sera, sera.
0 -
Taught how to do them in college last year, I use them for all sorts of stuff. I put all our DD on them and then as they come out of bank delete them, so I know how much is still to come out.
I did one last summer holidays for the kids as ideas to keept them entertained, so a column would say things like park or museum and next to that cost is free and then other palces I would put the admission charge.0 -
I am an addict too:p
Amongst many many others, I have one showing the real level of my debt (including my DF date) that is linked to another where I imput potential overpayments (this one is linked to my ISA account) that shows different potential DF dates. Obiously - given my addiction - this one is linked to the one where I keep my extra income like ebay, amazon and so on....:D2009: Headphones, Nintendo DSi , Baking Kit
2010: Jan:T-shirt, 2xBooks, Headphones, Elvis CD, Buffera, Scarf Feb:CD, 2xBooks, Mascara, 3xT-shirts Mar: Lip balm, 2xBooks, 2xCD, mask, Koala, 6xCinema tickets, Chocolate box, Drive Backup Pro Apr: Elemis cream, Elemis Skin Buff
0 -
How do you link them? i've been trying to do a debt one but can't get my head around it.. any tips?Total 'Failed Business' Debt £29,043
Que sera, sera.
0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 352.3K Banking & Borrowing
- 253.6K Reduce Debt & Boost Income
- 454.3K Spending & Discounts
- 245.3K Work, Benefits & Business
- 601.1K Mortgages, Homes & Bills
- 177.6K Life & Family
- 259.2K Travel & Transport
- 1.5M Hobbies & Leisure
- 16K Discuss & Feedback
- 37.7K Read-Only Boards