Money Saving Spreadsheet to use in addition to Martin's

EagerLearner

tigs78 wrote:

Thanks to EagerLearner, this is perfect - saves all those post it notes dotted around the place with random figures for my savings account!

I have a small techie question though...

On my chart the bottom dark green column does not show the total saved so far for that 'field' on the actual block itself wheras all the others do. It was showing when the original figures were there but it's not any more - any ideas how to get it to come back? I use Open Office if this makes a difference.

Thanks.

Hmmm - hard to say what caused that if it was working initially and has now stopped - maybe right-click on the chart and check the source data to make sure it's all correct? Have you tried deleting the data just from that particular category on the table, to refresh the chart? Then try to re-enter the data and see how you go. If all the other categories are showing the total on the chart, it's a strange one. Maybe the amount for that categoty on the chart was clicked on, then deleted by mistake? You could try downloading the spreadsheet again, then copying and pasting that tab again?

EagerLearner

tigs78 wrote:

Thanks to EagerLearner, this is perfect - saves all those post it notes dotted around the place with random figures for my savings account!

I have a small techie question though...

On my chart the bottom dark green column does not show the total saved so far for that 'field' on the actual block itself wheras all the others do. It was showing when the original figures were there but it's not any more - any ideas how to get it to come back? I use Open Office if this makes a difference.

Thanks.

Tigs - is your spreadsheet back to normal yet? PM me if not and we can go through things step by step.

Everyone - This spreadsheet has been amended further with formulas and to include even more detailed instructions - 1,778 MSER's have downloaded it as of today!

mleonard79

Hi eager Learner,

Thanks for pointing me to the spreadsheet - looks really detailed!! I don't know much about using excel but I've recently downloaded open office (since I don't have excel) and now that I can actually write my own details in the columns will be giving this a bash as soon as I have some time! Thanks for putting so much work into it :beer:

Regards

Michelle

COOLTRIKERCHICK

i just want to say thanks to eargerlearner and rex_mundi.. for all the helps and the link so i could down load excell...i am really looking forward to using this.....

just want to ask.... has anyone tweeked it for their own personal needs.. and if so.....what headings etc... have they done.......

as i would love to do it for my weekly shopping as well.......or is there one floating round for shopping.......

as you can see i am new to spread sheets computer things.....so sorry if my questions sound a bit....novice...shall we say....

EagerLearner

Hi CoolTrikerChic - you can rename the headings to whatever you like on the 'frills' section - however, that sheet does already have a shopping column which you can use to track spending?

Generally on the Frills section, the columns can have whatever headers you like, just type over them.

EagerLearner

Thread viewed 2407 times...

1895 downloads of spreadsheet...

35 thank yous....

Lots of saving money going on - enjoy and save those pennies!

EagerLearner

Over 2,000 downloads! If you download it, please press the thanks button and leave your comments about this spreadsheet on here! :T

Mercenary

How do I remove the yellow highlighting in the cells...and then redo it later on if necessary?
I'm an Excel n00b so am learning as I go along

nm I've found out now :cool:

EagerLearner

Mercenary wrote:

How do I remove the yellow highlighting in the cells...and then redo it later on if necessary?
I'm an Excel n00b so am learning as I go along

nm I've found out now :cool:

Hi Mercenary - you click the cell you want to un-highlight and then find on the toolbar the button like a paint can, and select the 'transparent' colour. But you probably already found that out

Hope you enjoy the spreadsheet and please let me know your feedback and any questions you have :T

Loubee_2

this is brilliant-thank you so much for letting us use it!!