Can a clever spreadsheet person please check this for me - SV650.org

07-10-12, 11:12 PM

Now I'm hitched I'm finally taking a real interest in money matters for the future.

Can someone who knows spreadsheets and has a few minutes to spare please look at mine and see if it all looks like it works ok and if there is anything I may have forgotten to include.

It took me about 5 hours of head scratching to get to this point.

Thanks.

It's a dropbox file so should be safe.

BTW the numbers are fictional and the coloured sections should change the other results.

http://dl.dropbox.com/u/111369957/test.xls

flymo · 08-10-12, 07:40 AM

I presume that .xlr is a Microsoft Works spreadsheet file? I cant open it to view, Works is not widely used, you may get more success by saving in a more popular file format. Perhaps .xls or .xlsx (Excel) or Open Document format (.odf or ods)

Bri w · 08-10-12, 07:47 AM

Sorry, it just opens with millions of question marks...

JamesMio · 08-10-12, 10:28 AM

If this is a budget spreadsheet - this might've saved you a fair bit of bother...

http://www.moneysavingexpert.com/ban...udget-planning

08-10-12, 01:16 PM

Thanks James but I've tried a few online things before and I haven't found them all that easy to use.

jchu1988 · 08-10-12, 08:22 PM

Hi, just had a look,

A23, A24 and B23/24 might make more if they were swapped around?

B28, where is there a E23*100, ie where does that $50 comes from? I assume its that extra 100 per month for misc?

Also might want to include a total payments(savings) + outgoing (flat, expenses) + spending money to see whether the maths adds up.

jchu1988 · 08-10-12, 08:35 PM

Btw, does the "payment to joint household account" include the "total outgoing for flat"?

I assume if the numbers put in are correct, then you are running into deficit.
Income: 24K
Outgoing: 13.2K (Payments to joint household account) + 7.2K (total joing savings) + 4.8K (spending money) = 25.2K
The issue is from the extra $100 per month for misc, which adds up as the extra $1200 in outgoing.

08-10-12, 10:53 PM

I think I've ironed out all of the wrinkles.

The additional payment isn't included in the outgoings box, it's just a little bit extra I'd like us to put in for unknown household things we might need or indeed just a little breathing space.

Here's the latest:
http://dl.dropbox.com/u/111369957/test.xls

jchu1988 · 09-10-12, 05:32 AM

Looks good.

09-10-12, 09:38 AM

Thanks very much.

Now to see if we can stick to it...

07-10-12, 11:12 PM	#1
monkey Guest Posts: n/a	Can a clever spreadsheet person please check this for me Now I'm hitched I'm finally taking a real interest in money matters for the future. Can someone who knows spreadsheets and has a few minutes to spare please look at mine and see if it all looks like it works ok and if there is anything I may have forgotten to include. It took me about 5 hours of head scratching to get to this point. Thanks. It's a dropbox file so should be safe. BTW the numbers are fictional and the coloured sections should change the other results. http://dl.dropbox.com/u/111369957/test.xls Last edited by monkey; 08-10-12 at 10:47 PM.

08-10-12, 07:40 AM	#2
flymo Member Mega Poster Join Date: Jan 2008 Location: North West Posts: 3,124	Re: Can a clever spreadsheet person please check this for me I presume that .xlr is a Microsoft Works spreadsheet file? I cant open it to view, Works is not widely used, you may get more success by saving in a more popular file format. Perhaps .xls or .xlsx (Excel) or Open Document format (.odf or ods)

08-10-12, 07:47 AM	#3
Bri w Member Join Date: Jun 2009 Location: Turre, Almeria Posts: 668	Re: Can a clever spreadsheet person please check this for me Sorry, it just opens with millions of question marks... __________________ *"It's not the years in your life, it's the life in your years."* Currently - Fighting the urge... seen a nice Triumph America Previously - Honda CB125, Honda CB400-4 & BSA B40, Moto Guzzi 850, Yamaha RD250, Suzuki GT380, Kawasaki Z1B, Kawasaki Z650, Honda VFR, Triumph Street Triple R.

08-10-12, 10:28 AM	#4
JamesMio Member Mega Poster Join Date: Jul 2007 Location: Scotland's Deep South Posts: 1,461	Re: Can a clever spreadsheet person please check this for me If this is a budget spreadsheet - this might've saved you a fair bit of bother... http://www.moneysavingexpert.com/ban...udget-planning __________________ "That **** on the push-bike." Creatomatic

08-10-12, 01:16 PM	#5
monkey Guest Posts: n/a	Re: Can a clever spreadsheet person please check this for me Thanks James but I've tried a few online things before and I haven't found them all that easy to use. Last edited by monkey; 08-10-12 at 10:53 PM.

08-10-12, 08:22 PM	#6
jchu1988 Member Join Date: May 2011 Location: Droylsden & sheffield Posts: 44	Re: Can a clever spreadsheet person please check this for me Hi, just had a look, A23, A24 and B23/24 might make more if they were swapped around? B28, where is there a E23*100, ie where does that $50 comes from? I assume its that extra 100 per month for misc? Also might want to include a total payments(savings) + outgoing (flat, expenses) + spending money to see whether the maths adds up.

08-10-12, 08:35 PM	#7
jchu1988 Member Join Date: May 2011 Location: Droylsden & sheffield Posts: 44	Re: Can a clever spreadsheet person please check this for me Btw, does the "payment to joint household account" include the "total outgoing for flat"? I assume if the numbers put in are correct, then you are running into deficit. Income: 24K Outgoing: 13.2K (Payments to joint household account) + 7.2K (total joing savings) + 4.8K (spending money) = 25.2K The issue is from the extra $100 per month for misc, which adds up as the extra $1200 in outgoing.

08-10-12, 10:53 PM	#8
monkey Guest Posts: n/a	Re: Can a clever spreadsheet person please check this for me I think I've ironed out all of the wrinkles. The additional payment isn't included in the outgoings box, it's just a little bit extra I'd like us to put in for unknown household things we might need or indeed just a little breathing space. Here's the latest: http://dl.dropbox.com/u/111369957/test.xls

09-10-12, 05:32 AM	#9
jchu1988 Member Join Date: May 2011 Location: Droylsden & sheffield Posts: 44	Re: Can a clever spreadsheet person please check this for me Looks good.

09-10-12, 09:38 AM	#10
monkey Guest Posts: n/a	Re: Can a clever spreadsheet person please check this for me Thanks very much. Now to see if we can stick to it...

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
rear suspension linkage spreadsheet	erik	SV Talk, Tuning & Tweaking	1	22-02-09 09:03 AM
Flexi-time Spreadsheet	andyb	Idle Banter	6	15-03-07 02:11 PM
exhaust spreadsheet-cant find it	james160987	Exhausts	2	08-05-06 08:59 PM
I must be clever!?	Davies	Bikes - Talk & Issues	7	21-03-06 08:11 AM
That really wasn't clever	Stig	Soho Massive	38	20-03-05 08:12 AM