![]() ![]() I’ve tried various methods of meal planning including printables, notepads, sticky notes, whiteboards etc. – Staple ingredients (that you already have on hand) By storing the URL link you can directly click from the spreadsheet to the recipe page – handy if you use an iPad for cooking – Source (URL of the website, or if you have a lot of recipes in binders, the binder reference e.g.#4). if you haven’t eaten pork in a while, filter to only see pork recipes – Category (click the drop-down arrow to filter by category). I’ve added some useful info to the spreadsheet: Tips and examples are in the spreadsheets to help guide you/recommended use (hover your mouse over cells that have a red triangle in the corner) ![]() You can rename the spreadsheet as ‘Recipes to Try’ instead if you like. I’ve labelled this spreadsheet ‘Favorite Recipes List’ as everyone probably doesn’t organize their recipes the same way I do. Read more: How to organize recipes plus a free printable recipe binder ![]() If I like the recipe, then I print and add it to one of my recipe binders. I do still prefer recipes printed on paper so have been using this only for recipes I’m trying for the first time. I click the URL recipe link, place my iPad on it’s stand and start cooking. I made this spreadsheet a few months ago now, and have been using it in Google Sheets on my iPad. Subscribe to my YouTube channel for more planning videos! 1. To enlarge the screen of the video, click the square icon in the bottom right hand corner of the video (it will say ‘full screen’ when you hover your mouse over the icon). They will work in Microsoft Excel, Google Sheets (free online tool) and Numbers for Mac. If you’d like a copy of the spreadsheets I made, they’re available in my shop ( here) or my Etsy shop ( here). I hope you find this post helpful and that it gives you some ideas for tweaking your current meal planning method (or starting one!). Since Excel has proven so useful for budgeting and organizing all my brain dumping tasks, I decided to create some spreadsheets for meal planning, food inventory and grocery shopping. However, due to Coronavirus, people hoarding groceries leaving empty shelves and sometimes having to queue due to limits on the number of people allowed in a shop at one time I’ve had to be a bit more organized with my meal planning and grocery shopping beyond just the week ahead. You can learn all about the Excel weekly meal planner on my Contextures site, and download the Excel file there too.I live just down the road from 3 supermarkets so have always been a basket shopper. Now you enter the meals in a weekly calendar layout. This video shows a previous version of the planner, in which you entered the meals in a list. In the screen shot below, ground beef is in the fridge freezer, and in the basement freezer, for a total of 3 pounds. You’ll have to keep the weekly planner inventory up to date, by filling in that data in the meal planner workbook. Need Cost – total price of buying the quantity shown in the “Buy” column.Įxcel is a powerful tool, but it doesn’t magically know what’s in your pantry or fridge. ![]() Buy – a pivot table calculated field that shows the quantity you need to buy (the difference between recipe quantity and quantity on hand).On Hand – the total quantity in the inventory.The new shopping list pivot table also shows the quantities that you need for your meals, and the quantities that you have on hand (if any) Need to purchase – change that filter to False, to see everything By default, the list only shows items you.Use the Meal Item filter if you just want to see the items for a specific.There are two filters at the top of the pivot table – Meal Item, and Need. In the new Meal Planner with Inventory, the shopping list looks a little different. You can print the list, add any other grocery items that you need, and then head to the grocery store. To do that, just click the Shopping List button at the top of the weekly calendar sheet.Īll your items are summarized by category, in an Excel Pivot Table. There’s a weekly calendar layout, where you select meal items from drop down lists.Īfter you select all the meal items, it’s time to create your shopping list. Here’s a quick peek at the planner, and how it works. Now that we’re staying home for a while, with very little shopping, I updated the file, to include an inventory of the food we have on hand. There’s an Excel weekly meal planner on my website, to help you organize your meals, and create a shopping list. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |