Real Men Sow

The 2011 GYO Money Saving Experiment Spreadsheet

how much do i save grpwing my own?I’ve made a spreadsheet, which I’d like to share with you in the hope I will find someone as geeky as me.

I love spreadsheets. They’re just so smart and neat, and bring out the part of me that wishes I was remotely organised.

So I’ve made one to work out how much I save from growing my own fruit and veg next year, much to Ailsa’s bemusement.

I’m no Microsoft Excel wizard, but the spreadsheet works out how much I save per picking against a manually entered current market value, depending on the weight of the produce. To get the shop price of the fruit or veg, I found banging ‘price of x’ in to Google soon brought up a value from one of the big supermarkets.

I’ve also added two other sections for the price of seeds purchased, and miscellaneous costs like allotment rent and tools, should I wish to include them.

My accountant mate Russell has checked the spreadsheet over, and it’s working properly, so from New Year’s Day I’m away. The year of the geek can begin!

If you’re reading this, then firstly, thank you! If you would also like to make use of the spreadsheet to calculate your own savings, then please feel free to download it by clicking here.

I’ve also put together a few pointers which will hopefully answer any questions you might have. There are also some entries in the spreadsheet so you can see how it works.

Please let me know if you find this useful, or if you have any suggestions to make it better. I’d be chuffed to hear from you.

Tagged , ,

Related Posts

Sign up to receive a RMS weekly bite size summary, featuring all posts from the previous seven days, hints and tips and other interesting snippets from the world of veg growing.

9 Comments

  1. Real Men Sow / a cheery allotment blog » Blog Archive » How Much Money Can Growing My Own Save Me? January UpdateJanuary 31, 2011 at 9:58 pmReply

    [...] to my Veg Savings 2011 Spreadsheet, GYOing during January saved me a grand total [...]

  2. Savings « Balcony AllotmentFebruary 19, 2011 at 10:02 pmReply

    [...] couple of interesting reads: Real Men Sow – How Much Money Can Growing My Own Save Me Why the ‘Good Life’ could save you £1500 a [...]

  3. Tim HoltApril 15, 2011 at 2:37 pmReply

    What a brilliant idea! I might just join you in trying to keep track of this…

    • Jono

      JonoApril 18, 2011 at 8:55 pmReplyAuthor

      Hi Tim.

      I’ve found it really interesting so far. At the end, I’m going to create a little diagram based on a small garden, recommended what to grow for greatest savings.

      Be great to hear how you get on.

      Jono.

  4. LeaApril 29, 2011 at 8:40 amReply

    Just wondering, does your spread sheet work out the cost of the seed per plant or per packet?
    It’s a great spread sheet so thanks for producing it! :-)

    • Jono

      JonoMay 1, 2011 at 1:15 pmReplyAuthor

      Hi Lea.

      It works it out per packet, but in theory you could work out a rough price per seed by dividing the amount of seeds in the pack (normally stated somewhere) by the price.

  5. AnnaMay 1, 2011 at 5:31 pmReply

    I worked out in my little grey computer that soft red fruit is the dearest produce that we use. So concentrating on raspberries and strawberries although still waiting on the cherry tree

  6. Real Men Sow » Blog Archive » Are Tomatoes Really Worth that Much?? How Much Money Can Growing Your Own Save Me? August UpdateSeptember 3, 2011 at 9:15 amReply

    [...] you can imagine my surprise when my spreadsheet told me that the 3.3kg of ripe, red tomatoes I’d just harvested were worth nearly 14 [...]

Leave a reply

Your email address will not be published.

About Real Men Sow

meIn 2007, I took on a redundant allotment plot with my gardening-mad mum Jan. As all good mums do, she went along with it, but I don’t think she held out much hope.

However, three years on, and she now lets me do stuff without watching over my shoulder, so I must be doing something right. [ read more ]

Buy My Book on Amazon!

me

Sign Here for Updates!

Sign up to receive a regular RMS bite size summary, featuring all recent posts, hints and tips and other interesting snippets from the world of veg growing.

Allotment Cakes for the Weekend

  • Allotment Cakes for the Weekend #14 – Courgette, Lime and Coconut Cake
  • Allotment Cakes for the Weekend #13 – Jamie Oliver’s Squash Muffins
  • An Allotment Cake for the Weekend #12 – Lemon Curd & Blueberry Loaf Cake
  • An Allotment Cake For the Weekend #11 – Apple and Cinnamon Flapjacks
  • An Allotment Cake For the Weekend #10 – Fresh Ginger and Apple Cake
  • Good Food Magazine Marrow and Pecan Cake
  • A Rhubarbey Roundup, and Whatever Happened to Allotment Cakes for the Weekend?
  • (Not) An Allotment Cake for the Weekend #7 Rhubarb Crumble Ice Cream

Saving £500 a year!

During 2011, I kept a diary of how much money I save from growing my own fruit and vegetables. After totalling all my outgoings, I saved approximately £500 over the year. I made a spreadsheet to calculate these savings - it’s nothing too complicated, as I’m no Excel guru, but hopefully someone else will find it as useful (and strangely fun) as me. For more info, visit my Money Saving Experiment page by clicking here.

Archive

The Veggy Social

As Featured In…

Flickr Stream