Page 1 of 2

Posted: Wed Mar 12, 2008 7:55 pm
by caraf
I am really struggling to come up with a spreadsheet to work out how much of my husbands overtime I pay over, is there any chance I could have a copy of yours please, he is paid weekly and I am finding it difficult
help
thanks
carol
x

Posted: Wed Mar 12, 2008 8:20 pm
by Shining
Of course you can Carol but as I'm an IT tutor, it's got linking to my main expenditure sheet and updates automatically when I input entries. However, I'll send you it but the formulae won't work I'm afraid, I'll make you one, no problem if you can give me a couple of days, but it would involve me knowing your income etc.,? Just let me know how you would like it to work? I also have a summary sheet which is linked to both the income and expenditure and it's linked to my main expenditure sheet etc as this lists all payments made to IP and will total it up for each year of the IVA. All this isn't necessary, I'm just a sad person who likes messing around with spreadsheets and the like! Let me know what you want to do and like I say I don't mind sorting you one out or I'll send you my template and if it's not detailed enough for you, I'll amend it as necessary to suit you.

Posted: Wed Mar 12, 2008 8:24 pm
by caraf
Thank you very much. I like messing with spreadsheets to but cant seem to get my head round this one.
If you dont mind if I could have it all.
What information do you need from me

Posted: Wed Mar 12, 2008 8:25 pm
by caraf
I will get admin to send you my email address

Posted: Wed Mar 12, 2008 8:46 pm
by Shining
I'll show you mine if you like, I've nothing to hide! No money so why not eh? tell me if you want something like it or you can amend mine to fit your lifestyle, I don't break my budget down I'm afraid to include everything, I just use the figures, but you'll see how it works.

If however, you want it different and can't do it or need help just let me know, bearing in mind I do work so it won't be an instant turn around I'm afraid! But if I can help I will!

Posted: Wed Mar 12, 2008 8:49 pm
by caraf
Thats brilliant, if you could just send me your and I will change to to fit my lifestyle. I am an accounts manager so should be able to have a good shot at it. If I get stuck I can always ask ?

Posted: Wed Mar 12, 2008 8:50 pm
by Shining
When you get mine, so long as the linking works still after being mailed, change the figures in the income and you'll see it change on the uplift sheet and work out how much to send to IP automatically only if the amount is in the uplift bracket. As my hubby is paid on a Friday it totals it up after however many fridays there are in that month! How sad am I that I have it set up till December 08!

Posted: Wed Mar 12, 2008 8:52 pm
by caraf
I can do better than that my cashflow spreadsheets goes to next March, we must be very sad people together.
x

Posted: Wed Mar 12, 2008 8:55 pm
by Shining
I think with the right forumlae your spreadsheet will be fine. Mine is a basic spreadsheet that works for me.

Posted: Wed Mar 12, 2008 8:55 pm
by caraf
I have just read some of your blogg. I see you daughter is doing a GCSE in Textiles. My daugther is in year 11 just coming to the end of her gcse year and she has done textiles and I agree with you it costs a small fortune, she has made a prom dress, there is something she needs everyweek. Anyway its finished now i think, thank god ! She is doing all the theory now and beleive you me there is lots and lots and lots of it.

Posted: Wed Mar 12, 2008 8:56 pm
by caraf
Andy just replyed is going to send you my email address now

Posted: Wed Mar 12, 2008 8:58 pm
by Shining
Ok I'll wait for it and we'll communicate via email, Talk soon x

Posted: Wed Mar 12, 2008 9:01 pm
by angela18
What do you do with a spreadsheet and how does it work?

Posted: Wed Mar 12, 2008 9:09 pm
by Shining
I just put my Income into it and my expenditure and it works out how much I've got left and how much to pay over to my IP in respect of the uplift clause of my IVA, it's all very simple but works for me. To be honest, it replicates my bank account basically.

Posted: Wed Mar 12, 2008 9:13 pm
by angela18
ooh that sounds abit tricky!!