Money Savings Spreadsheet

**stella** · 28-12-2010, 09:50 AM

Well done could be a New years res!!!!!!!

**zazen999** · 28-12-2010, 09:52 AM

Very nice!

However I am the spreadsheet queen.

I'd not have a separate sheet for spends - I'd ditch the top 3 lines, having one row with all your titles on it. I'd add a column for seed spend and totalise it in the top row. I'd have a column for misc spend and totalise it on the top row.

Then, instead of using 'sum' I'd use 'subtotal' and use number 9 to sum the totals. This way, you can select 'carrots' and filter on carrots to find out your total spend versus saving just on one crop [now we are getting really geeky]

Also, in another cell on the top column you can do a 'all over total' with the spends minus the savings which will show your total there, rather than having to keep inserting rows and having your total move down the page.

If you do it like this, with all the totals in the top row and only data in the rows below, then you can pivot table out your year's figures and really look at what you have saved.

I've had a fiddle and emailed it to you.....for perusal.....

**Bren In Pots** · 28-12-2010, 09:54 AM

Just downloaded the spreadsheet thanks Jono, and I'll give it a go next year to see how it compares to the scribbles I do in my journal.

**Suky** · 28-12-2010, 11:09 AM

Ooohh Zazen, that is really scarey! I almost understood some of what you wrote

**zazen999** · 28-12-2010, 11:24 AM

Originally posted by Suky View Post

Ooohh Zazen, that is really scarey! I almost understood some of what you wrote

Welcome

to my world!!!

**arpoet** · 28-12-2010, 11:34 AM

I've downloaded it, but i also will make some changes as i dont grow in kilos but good old fashioned lbs.
I will also add trip section so i cost my milage.. cor, now aint i the sad one
Roger

**chris** · 28-12-2010, 11:37 AM

I plan on doing it too, but not via a spread sheet, as I'll just get bored with it (spend too much time on a computer).. I've translocated a couple A4 notepads, and A4 day-by-page diaries from work, which from the new year will be my gardening diary, then as per mrs dobbie I'm going to do a balance sheet.

**Florence Fennel** · 28-12-2010, 01:13 PM

I think you're all wonderful. I just wouldn't be able to keep it up!

**zazen999** · 28-12-2010, 04:10 PM

Linkie for my amended doc if anyone wants it

https://docs.google.com/leaf?id=0B1x...ZWY3NmRm&hl=en

**Jono** · 28-12-2010, 04:48 PM

Originally posted by zazen999 View Post

Very nice!

However I am the spreadsheet queen.

I'd not have a separate sheet for spends - I'd ditch the top 3 lines, having one row with all your titles on it. I'd add a column for seed spend and totalise it in the top row. I'd have a column for misc spend and totalise it on the top row.

Then, instead of using 'sum' I'd use 'subtotal' and use number 9 to sum the totals. This way, you can select 'carrots' and filter on carrots to find out your total spend versus saving just on one crop [now we are getting really geeky]

Also, in another cell on the top column you can do a 'all over total' with the spends minus the savings which will show your total there, rather than having to keep inserting rows and having your total move down the page.

If you do it like this, with all the totals in the top row and only data in the rows below, then you can pivot table out your year's figures and really look at what you have saved.

I've had a fiddle and emailed it to you.....for perusal.....

Haha, Zazen this has made me laugh. I'm glad I've found some fellow spreadsheet fans. Thanks for your input, looks good. I feel a v2.0 coming on!

**Jono** · 28-12-2010, 04:49 PM

Originally posted by arpoet View Post

I've downloaded it, but i also will make some changes as i dont grow in kilos but good old fashioned lbs.
I will also add trip section so i cost my milage.. cor, now aint i the sad one
Roger

Mileage, great idea Roger!

**zazen999** · 28-12-2010, 04:50 PM

Originally posted by Jono View Post

Haha, Zazen this has made me laugh. I'm glad I've found some fellow spreadsheet fans. Thanks for your input, looks good. I feel a v2.0 coming on!

I earn a decent wage on top of my actual job as a self-employed spreadsheet worrier

**poly** · 28-12-2010, 05:05 PM

Originally posted by zazen999 View Post

Linkie for my amended doc if anyone wants it

https://docs.google.com/leaf?id=0B1x...ZWY3NmRm&hl=en

Not working for me, message reads "Sorry, the page (or document) you have requested is not available"

**zazen999** · 28-12-2010, 05:08 PM

Try again

https://docs.google.com/leaf?id=0B1x...thkey=CLXmvfEO

Announcement

Money Savings Spreadsheet

Money Savings Spreadsheet

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Latest Topics

Recent Blog Posts