Second Purse Challenge 2012

MunniMuncha

HelenPie wrote: »

Ah, yes - I've been generally absent recently so a lot of skim reading and late catch ups

Why do you have to update twice? I have quite a simple spreadsheet that I use to record my stock and it works out my amounts owed and purse balances from that....is yours a bit fancy?

kerri_dfw wrote: »

No I'm just not very good with spreadsheets I think. Maybe I need to overhaul mine and make it less complicated, that way I can just put in how much I've used, what I've bought, and it'll tell me what I owe the purse. Then maybe I need a column for how much I've put into the purse. That sounds soooo much simpler actually! Will start on it now

Hello girls (and not forgetting any guys out there too), have been away for the weekend so trying to catch up with everyone's posts.

I'm glad you mention this about spreadsheets as I was going to post about this anyway. I have a system like yours Helen where it works out the money side of things for me (used the one on page 1 but in excel) but am finding it very complicated when I buy something at one price and then again at another price so have it in two places. I then get myself confused as to which one is which (which I know in the long term it'll work itself out when I use the stuff up) but my biggest thing that confuses me is when I pay back 2nd purse and take these amounts off spreadsheet, don't know what has been paid for and what hasn't if I forget to update stock (iyswim). What do others do?

HelenPie

MunniMuncha wrote: »

Hello girls (and not forgetting any guys out there too), have been away for the weekend so trying to catch up with everyone's posts.

I'm glad you mention this about spreadsheets as I was going to post about this anyway. I have a system like yours Helen where it works out the money side of things for me (used the one on page 1 but in excel) but am finding it very complicated when I buy something at one price and then again at another price so have it in two places. I then get myself confused as to which one is which (which I know in the long term it'll work itself out when I use the stuff up) but my biggest thing that confuses me is when I pay back 2nd purse and take these amounts off spreadsheet, don't know what has been paid for and what hasn't if I forget to update stock (iyswim). What do others do?

I actually repeat the item further down the list and strike-through items that are out of stock. For example, I'd bought cat food on 21/01, 2 boxes for £5. When I'd used these, I crossed out the item so I can see that I'm out. I have later entries, for example I bought 8 boxes on 03/03 for £24. This line is still active.

It's not particularly elegant, and may get messy as the list gets long, but I will just hide the rows at that stage.

Again, I'm happy to share my sheet with anyone that wants it. Just pm me your email address and I'll share it via google docs or will happily email.

As far as knowing what's used/not used, I update my sheet based on how many item's I think I've 'sold' to myself, which works out how much I owe SP. I then do a quick stock take every now and then to make sure that what's left matches the spreadsheet.

H x

jakes-mum

Well due to having fish chips and beans for tea tonight (due to cronic earache so really couldnt be arrised) my total spend for GB today is . . . . 50p :eek: and that was from SOS :eek: hoping tomorrow will be a NSD at supermarkets too as im holding out for thursday when Mr C has their 15% off day again

kerri_dfw

I've got shocking signal in this hotel room with my dongle grrrr, I'm on edge whatever that is, I thought the best was 3G but that keeps breaking. Still not spending £15 for one night thank you very much!

I've redone my entire spreadsheet after using it for awhile, I've taken elements of Helens which is fabby by the way (it taught me how to use the forumae better ) I'll update the front spreadsheet so it's less complicated when I get back to normal internet hope you're all ok xx

HelenPie

kerri_dfw wrote: »

I've got shocking signal in this hotel room with my dongle grrrr, I'm on edge whatever that is, I thought the best was 3G but that keeps breaking. Still not spending £15 for one night thank you very much!

I've redone my entire spreadsheet after using it for awhile, I've taken elements of Helens which is fabby by the way (it taught me how to use the forumae better ) I'll update the front spreadsheet so it's less complicated when I get back to normal internet hope you're all ok xx

Happy I could help

fozziebeartoo

Thanks to my printer and lots of coupons, I managed to get a Sainsbugs shop down from £34.90 to £11.33 and almost ALL of it for Sallys Stores too!:j

Carte D'or is down to £2.00 and I had £1 vouchers.

Velvet Tissues BOGOF at £1.99 and had £1 off.

Fairy Liquid 2 for £2.50 and had 2 x £1 off.

Kleenex Facial Wipes down to £1.99 each but voucher for BOGOF took £2.99 off.

Dettol No Touch was half price so free with coupon

Oral B toothpaste was 29p when I used a £1 voucher.

Also got more Wrights bread mixes for between 5p and 15p.

That is my best coupon shop ever!

So far..............:rotfl:

mooomin

Where did you get the Fairy coupon from? I need to buy some today

Mothership

fozziebeartoo wrote: »

Thanks to my printer and lots of coupons, I managed to get a Sainsbugs shop down from £34.90 to £11.33 and almost ALL of it for Sallys Stores too!:j

Carte D'or is down to £2.00 and I had £1 vouchers.

Velvet Tissues BOGOF at £1.99 and had £1 off.

Fairy Liquid 2 for £2.50 and had 2 x £1 off.

Kleenex Facial Wipes down to £1.99 each but voucher for BOGOF took £2.99 off.

Dettol No Touch was half price so free with coupon

Oral B toothpaste was 29p when I used a £1 voucher.

Also got more Wrights bread mixes for between 5p and 15p.

That is my best coupon shop ever!

So far..............:rotfl:

Fantastic! Fozziebear

I'm just back from M&S My daughter gave me a £5 off a £25 spend I got ...

1st Purse
1 x £6 meal deal, chicken pie , apple pie and mash.
1 other £6 deal 2 packs Sticky BBQ Chicken + Makerel.
2 Santini tomato Salads @ £1 each
3 Packs Lemon Sole
Y Sticker. Profiteroles £2.50, long stem broccoli 80p, Rosemary Potatoes 50p.
I spent £21 got lots of nice treats ( a wee break from cooking for me YAY!

Then I went into @ad@

I got a huge boneless leg of welsh Lamb with herbs butter and garlic for £4.20 and a pack of parsnips for 50p. + 2 boxes of mushrooms @ 40p each and 2 jugs of milk £2.

Total Spend £28.50

2nd Purse

6 Bottles of Fruit and Barley orange @ 60p each = £3.60

MunniMuncha

HelenPie wrote: »

I actually repeat the item further down the list and strike-through items that are out of stock. For example, I'd bought cat food on 21/01, 2 boxes for £5. When I'd used these, I crossed out the item so I can see that I'm out. I have later entries, for example I bought 8 boxes on 03/03 for £24. This line is still active.

It's not particularly elegant, and may get messy as the list gets long, but I will just hide the rows at that stage.

Again, I'm happy to share my sheet with anyone that wants it. Just pm me your email address and I'll share it via google docs or will happily email.

As far as knowing what's used/not used, I update my sheet based on how many item's I think I've 'sold' to myself, which works out how much I owe SP. I then do a quick stock take every now and then to make sure that what's left matches the spreadsheet.

H x

I do something similar but make the line solid red when it has been sold. If you hide something that has been used up, does that affect the formulas at all? I would love to see your spreadsheet but am not familiar with google docs so use excel.

I also do it a new tab each month so that the list doesn't get too long. Like you say it is very messy and would love to know if there is a way of keeping it a bit more tidy, but maybe there isn't a way and it is just one of those things. Thanks HP for your help:T:T

Rosielady

Brought in M&S yesterday

Orange pot au chocolat base 49p
Blackcurrant & Cassis mousse base 49p

all is need is cream to be added, very quick and easy. serves 4 , both on special price as the label says new , but Ithink these were around at Christmas.

Biryani paste again 49p