December 29, 2009
UPDATE–I have changed the file to an XLS format which should work with all versions of Excel–so try again if you were having issue.
Another request that MANY of you have made is how to get a copy of a simple spreadsheet. I personally need more than a shopping list…I need to have a detailed spreadsheet listing quantity, price, coupons and ultimately what my final cost should be. I love being able to see exactly what I am spending on each item and the final cost. I can print my spreadsheet and not only have my shopping list but a quick reference for price and a way to ensure what I see at checkout is in line with what I expect to pay!! Since the spreadsheet does the calculations all I need to do it a little typing–then print and shop!!
Here is an example of the spreadsheet I use.
|Product||quantity||price||minus Q||TOTAL||Q details|
|Barber Chicken||4||2.5||10||8||2||four $1/1 MQ + four $1/1 IP|
|Buitoni||5||1.2||6||5||1||five $1/1 insert|
|Betty Crocker||6||0.8||4.8||4.8||0||six $.40/1 IP|
|muellers||2||0.7||1.4||1||0.4||$1/2 home mailer|
|carnation evap milk||4||0.5||2||2||0||two $.50/2 insert|
I have created a simple spreadsheet that you can access HERE. If you would like to use it all you need to do is right click on the blue link and save it to your computer. Then you will fill in the product, quantity, price and coupon fields. You do not need to complete the TOTAL field as that will be automatically calculated! I have put in a couple of items as a sample–just replace my items with yours and you will be all set. After I shop I go back to my spreadsheet and reconcile with any differences. I can then see exactly how much money I spend per week (I actually pull that total into a separate spreadsheet so I can easily track my overall spending).
Feel free to give it a try! I know this may not be everyone’s cup of tea–but I thought I would offer a solution for those that would like to supercharge their basic shopping list