MSE-ers really do love a good spreadsheet!

rictus123

I was very obsessed with throwing the figures about and changing things up....not so much now as i have that little expenses i dont really need a spread sheet...will be starting up again after this month though!! Love it.

QueenB.

OK i will have to very honest, i am not a big lover of computers and only go on for short bursts of time so i have never had a spreadsheet:o.

I like paper, old fashioned and not quite as flexible but it is my comfort blanki so to speak. I can sit for ages with my accounts book and a calculator and when i really want to be uplifted i count my pennies jar:o

LondonGirl252

Hi, my names LondonGirl and Im addicted to my speadsheet



It's true. I love it. It has graphs, clever calculations.... you name it! Im an excel geek at the best of times but my financial one is my finest piece of work! I have over 10 tabs and all sorts of fun things! I must look at it 10 times a day when I'm at on a PC.

Ms-Pacman

LondonGirl252 wrote: »

Hi, my names LondonGirl and Im addicted to my speadsheet



It's true. I love it. It has graphs, clever calculations.... you name it! Im an excel geek at the best of times but my financial one is my finest piece of work! I have over 10 tabs and all sorts of fun things! I must look at it 10 times a day when I'm at on a PC.

Hi, I think I might be your twin!
I get to take it further as my work is pretty much working on spreadsheets!

gallygirl

Glad it's not just me, I :heart2::heart2::heart2::heart2::heart2::lovethoug:lovethoug:lovethoug:lovethoug:lovethoug:heart2::heart2::heart2::heart2::heart2: my spreadsheets. My finances are quite complicated. The ones I use regularly are:

• main bank account - set up for year, with DD's linked from another sheet
• Halifax bank account - even although I only have £1000 in & out and £5 in & out
• list of mag subs, with reminders to cancel, free gifts & how much I sold the gifts for
• tax rebate due for year
• current account no. 3 - linked to btl's
• IHT calculations
• SIPP & other investments & projections
• a fair few which are actually just note pads - insurance policy details, reminders etc.
• my favourites - 4 sheets for mortgages, all with daily interest calculations, monthly payments etc. All linked to show total debt on a daily basis, with savings offset (they've also got their own page). Some are sad enough to have hourly interest . All show any overpayments and my no.1 target has a record of all overpayments, where the money came from, what impact each op has on end date of mortgage, how many days and % of a year saved this year & to date, also accumulated interest. All link to a monthly summary, showing month on month change, equity and progress (or lack of :cool:) against various mortgage free challenges.
• I use the overall mortgage balance to colour in bricks on an excel house showing how much I own.

Off to [STRIKE]play[/STRIKE] do some financial planning for a little while

mssloan

I created a spreadsheet called 'The Mountain' back in 2008 and I've been using it to track my credit debt and loans since then. I found it an excellent way to stop myself from staying a 'head-in-the-sand' approach which I did in the past (and got myself into a right mess).

Fortunately, for me, the nightmare is nearly over, as tomorrow I will be calling my bank to settle my loans and I'll be paying off my credit cards.


mssloan

lillibet_dripping

rising_from_the_ashes wrote: »

Hi Lilli - I'm using this one http://forums.moneysavingexpert.com/showpost.php?p=39711066&postcount=360 which was Cheryl's spreadsheet for 2011

Is this the one you can't get to work?

Once you open it, it may open on the screen as a webpage but if you look to the right hand side there's a "download" button which will then open it in Excel and you can save it off.

There's a version for both excel 2007 and 97 - 03

HTH

Hi Rising
Thanks for that - that is exactly the one I was looking for. Just didn't understand about the downloading bit:o
I've got a day off work today - guess what I will be doing all day?!!!!!:j

DizzyDizzy

Bored wrote: »

Oh, and I keep it on google docs so I don't have to worry about losing it and I can access it from any computer, anywhere I am.

This sounds great! I lost my last spreadsheet when my computer died, and haven't had the motivation to restart it again!

If it's kept in google docs that means I can't lose it again, ever?

Is it secure enough? Not that my finances would interest anyone much!

rising_from_the_ashes

lillibet_dripping wrote: »

Hi Rising
Thanks for that - that is exactly the one I was looking for. Just didn't understand about the downloading bit:o
I've got a day off work today - guess what I will be doing all day?!!!!!:j

At the very right of the web page there's a blue "share" button ... next to that is a "download" button.

If you click that, you should get a box saying something like "you have chosen to open ....", choose the "open with Microsoft Office Excel (default)" option and click OK.

The spreadsheet should then download & open in Excel and you can do a "save as" to rename/save it onto your pc.

HTH:)

downsizer3

Okay.I might be starting an avalanche here (quietly hoping so!) but which spreadsheets do you all use?
I have a mortgage overpayment one which is fab - charts progress and resultant interest saved etc but I don't have a monthly expenditure one. So. What do you recommend as a good one to start with?
Thanks!