Shopping List
Posted on August 8, 2009
Filed Under Finance |
This excel template is a complete version of my previous grocery list template where in this template I put price and shopping mart consideration in the list to ease you finding the cheapest price of your shopping items or the most cheapest shopping mart for majority of your grocery shopping list items.
The guidance on using this shopping list are as follows :
1. Go into “Item pool” worksheet. You can enlarge the screenshot by clicking the item pool worksheet picture below. I put many grocery item samples inside for your references.
2. Put all of your grocery item in Item list column, and put your item category name in the same column but put word “Cat” next to the item category name to differentiate between item category name and item name. Blue color will be revealed automatically to ease you see the difference.
3. Put your item price in five available shopping mart price column, and the unit reference in price reference column. There is extra columns at the right side of the table that will find the cheapest price with its shopping mart. And there is a color guidance in those five columns which will turn the cell of the cheapest item price into blue color.
4. Create your shopping list by filling “v” character for selected item in Checklist column. Once you finished filling Checklist column, watch Checklist Item box at the right side, next to the shopping table. You will see a reference number to guide you printing the correct shopping list worksheet. You can see in my example that the number show 174, which mean you should use the worksheet “Shopping List 195? as your printable shopping list. The number 195, 140 and 80 is the maximum item that will be revealed in the shopping list worksheet.
5. Select your shopping mart to shop your item. There are six options you can select, based on cheapest price (option 6) or based on your preferred shopping mart.
6. Once you select the shopping mart, you can check the predicted total budget on the total budget box at the bottom right side of in the shopping list worksheets. You can use the information to decide whether you will go from mart to mart to find the cheapest item or just shop in one shopping mart if the price difference is still within your shopping budget.
7. I put additional box in those shopping list worksheets as empty rows to put your replacement item, if you cannot find your item, or if you want to add other item that you might remember or your kids and husbands wants you to buy something for them while you are already on the way there or already in the store.
Feel free to modify or adjust the spreadsheet based on your needs and don’t forget to give me any feedback :-). You can download the file here.
You can read and download my other templates below :
- Checkbook Register
- House Affordability Calculators
- Mileage Log
- Cost of Goods Sold Calculator
- Depreciation Calculator
- Car Loan Calculator
- Travel Expenses Daily Tracker
- Time Sheets
Comments
12 Responses to “Shopping List”
Leave a Reply
Thank you man, I’ve been following this site for a while & I’m amazed about your wonderful work. You have my blessing for sharing your work. Something will continue to live after you’re gone. Bless you
m happy
Hi Man,
Your pages really rocks. For those whose think about the wonders with xl sheets. Hmmm.. I am the one too. And I salute you all the works you done and make it into share to others like me..
..
Keep it up all the time.
Take care and cheers.
rgds,
madhu
This is fabulous !!! thank you
I love the shopping list! Is it possible to have it add the quantity to the list that gets printed? The formula to do that is over my head! Thanks!
VERY GOOD JOB ON YOUR SPREADSHEETS..ITS AWESOME..AND I NEED TO SAVE MONEY REALLY BAD THIS YEAR!! THANKS YOU AGAIN!!! AND GOD BLESS.
Hi, i just downloaded the excel sheet for shopping. I was clicking on the radio button and all the radio buttons are selected and the same is not going out. I would like to know if there is any macros connected to it….
Hello! This spreadsheet is WONDERFUL!! Thank you for making this available. I was wondering if it would be possible to add a Total field to each of the shopping lists to know how much the shopping list costs? Thank you!!
hey i luv tis its sooooooooooooo helpful
I can’t figure out how to enter new cells in the Item Pool and have them show up on the Shopping List page. Any help? I’ve got items not listed that I want to enter, but they are not getting linked to the shopping list page.
Many of the questions posted here are questions which I have. Such as when I fill out Qty and Target price on the Item Pool it doesn’t total it on the shopping list. Even when I change the quantity on the shopping list page it doesn’t change the budget total at the bottom of the page.
Also, When I add a Cat on the Item Pool page it doesn’t list correctly on the shopping list page. Sometimes it shows up twice on the shopping list page.
All of the formulas are way above my head. I wish I better at the formulas. I know how I want it to work. I just can’t make the changes to do that.
You have don’t a great job on this.
Sam
Do we have to hand write (or type) in the quantity we want? Or should it copy over from the “price Reference: quantity) column of ‘Item Pool’ page? I’d like to have listed how many pounds or cans or pieces of an item I need. I don’t understand what the “price reference” columns are for.