Deals spreadsheet

[somerandomcheese]

Please find attached excel spreadsheet ( slimmed down ).

This is a "Value only" DB of the data I use for preparing my Alpha thread and my "Buy today..." thread.

I was going to extract a " Historical sale prices" thread but cannot get the forum wiki text to format it appropriately, so I generated this spread sheet for release instead.

First sheet is the DB of values, You can sort and otherwise filter the list to display what you need to see. The official thread is using "Week, Store, description". My favorite order is by "Description" alone.

Second sheet is a Pivot table, currently set for display of unit pricing for all items over the 4 weeks I've been doing this. Users who know how to use Pivot tables in Excel can garner all kinds of useful information.

Please note: My current process in a manual entry of the information from the weekly deals thread, I was not adjusting my values to match any changes, so there are some synchronization issues. Please check with the Official threads for the latest corrections.

I've included the deals for this week as they were at 9:00 this morning.

By the way, the forum limit of 2.00 MB for xls files is a bit small. Had to zip it...

Enjoy

[blondcouponlady]

wow this is alot of work thanks

[kasha100]

wow much better than my scap paper with good prices on it!

[blondcouponlady]

after looking threw this chart I'll stick too my scrap my paper... But its amazing you did this

[spiggsy]

Cool ... now I can do lookups on my coupons spreadsheet to plan shopping sprees
Are you going to release this every week? It will definitley get good use from me if you do, as I try and make the same sort of list for the weeks shopping too .... personally I add air miles and SDM points multipliers columns as it adds weight to my decisions.

[somerandomcheese]

Cool ... now I can do lookups on my coupons spreadsheet to plan shopping sprees
Are you going to release this every week? It will definitley get good use from me if you do, as I try and make the same sort of list for the weeks shopping too .... personally I add air miles and SDM points multipliers columns as it adds weight to my decisions.

I may not release the whole thing as the size will increase well over the Forum limit , But I will release the weekly additions in some format that can be cut and pasted to the bottom of the DB sheet. That way others can modify and add records as they see fit and it still can be populated with current deals.

I had a "Proposal/change request" post early May, which asked the community for suggestions on additional content and such. It is currently awaiting review by the Site Owner. Airmiles and other loyalty programs didn't even occur to me, should be a simple addition. Need only figure out the best place to put the information in my "Deal String"

Old Spice Deodorant {}@REX[] 1/$1.49 - $3.00 WUB2G0 ( ) = ($0.01)

[musique]

Thanks so much for sharing this! It is amazing. I love spreadsheets, but I have never attempted something of this scale!

[Saving $$$]

That is quite an extensive spreadsheet!

Thanks!

[meowtab]

wow..too complex for me. Love that it can help someone else though I am gonna stick with my paper and pen!

[anythingdeco]

My hubby got so excited when he saw this..he is always saying 'use the spreadsheet ..use the spreadsheet' ..lol!

[taylyn]

Amazing detail! Do you have a list of the store acronyms? For example, what is SOB-O?

[somerandomcheese]

Amazing detail! Do you have a list of the store acronyms? For example, what is SOB-O?

LONG Longo’s
MAXI Maxi
MET-O Metro flyer Quebec
NF-A No Frills - Alberta
NF-O No Frills - Ontario
PC-A Price Chopper
PC-O Price Chopper
PHSV-A Pharamsave
PROV Provigo
RCSS-O Real Canadian Superstore ON
RCSS-W Real Canadian Superstore WEST
REX Rexall
SAFE Safeway Canada
SDM-O Shoppers Drug Mart - ON
SDM-W Shoppers Drug Mart - WEST
SOB-A Sobeys - Atlantic
SOB-O Sobeys - Ontario
SUPERC Super C flyer Quebec
TB!S The Bargain Shop
TEST Test-mart
UNIP UniPrix
VALU Valu-mart
WM Walmart Canada
YIG Independent Grocer
ZEHR Zehrs
ZELLER Zellers

[ExtraC]

wow tonnes of work and effort thanks very much for all your hard work

[taylyn]

That's great - thanks so much!

[scottie54]

OMG that is sooooooo much work, & so Nice of you to Share !