A few days ago I asked you guys what you would would like to see here at I Heart Publix.  You guys gave me some wonderful suggestions and I am in the process of implementing some of your great ideas.  One idea you guys had was to include a way to create a shopping list based on the weekly ad. 

While I love the idea of a list, I personally prefer a spreadsheet as it makes my whole shopping experience easier.  I like being able to see my list as well as the coupon calculations and ultimately what I will pay at the register.  So I created a spreadsheet that you all can use and print HERE on the site!! 

It is very simple to use–here are the steps: 
1. Use the quantity drop down to choose how many of an item you wish to purchase. If you are in an area with true BOGO–you will need to make sure to select BOGO quantities in sets of two to ensure your cost is accurate.

2. Use the poduct dropdown to choose the specific item you want to add to your list. The price and cost will automatically be calculated!!!


3. The spreadsheet will contain the prices from my ad in Metro Atlanta.  I know many of you in other areas may have slightly different prices. I have given you a way to adjust the price so that your spreadsheet will be accurate.  Simply type the additonal amount in the price adjustment box and your cost will adjust. NOTE: This is a completely optional step!  If no adjustments are entered the cost will be calulated based on the preset price.


4. Insert your total coupon discount per item in the corresponding line.  If you are using five $1 coupons on Kellogg’s Cereal then you would enter 5 into the coupon amount for that item. The cost will automatically adjust to display your discount!  

5. I have all the items listed in their specific category within the spreadsheet.  I have also included a section for you to add your own items! Just fill in the item, cost and coupon and it will be included in the calculations!!


6.  You will be able to see your expected total (not including tax) at the bottom of the spreadsheet.  You can then hit print and take your list and shop!!

It is super simple to use!!  I will admit that I just finished the spreadsheet so it may have a few bugs.  For example the submit button is useless–I just have not had a chance to remove it.  I would love some feedback.  PLEASE understand that I am not a computer pro…my background is psychology so I am somewhat limited in what I am able to do 🙂  BUT–I would love to hear your comments, ideas and suggestions! I know it will be impossible to please everyone but I have given it my best effort and I hope you all find this to be a useful tool!  

Go HERE to give it a try!