![]() NOTE: The On Hand column might not show the total amount that you have on hand. ![]() You can ignore those columns and formulas - they're just used for the shopping list. Those columns have formulas that calculate the amounts for the shopping list. If you download the Basic Meal Planner with Inventory, there are additional columns in the Meal_Ingredients table In columns G:J, formulas in the grey cells calculate the costs for the shopping list.In columns E:F, formula will display the ingredient information that you entered on the Recipe_Ingred sheet.For example, type a 2, if the recipe calls for 2 cans of beans. In column D, enter the quantity required for the selected recipe.Or, just type the missing ingredient in the cell, and no cost information will be calculated. If the ingredient isn't in the list, go to the Recipe_Ingred list and add it. In column C, select the name of an ingredient from the drop down list.Select the name of one of your meal items from the drop down list. NOTE: You don't need to enter ingredients that you usually have on hand, such as salt and pepper, or cooking oil. It has a list where you will enter the main ingredients In the screen shot below, ground beef is in the fridge freezer, and in the basement freezer, for a total of 3 pounds.Īfter you have entered the recipe names and ingredient costs, go the Meal_Ingredients worksheet. The Loc Qty column has a formula that sums the amounts for the 2 locations.If the ingredient is also stored in another location, enter that information in the Loc02 and Loc02 Qty columns.Enter the current quantity on hand in the Loc01 Qty column.On the Recipe_Ingred sheet, there are location columns at the left side of the Ingredients table.įor any ingredient that you want to track: You can edit this list, and add new locations, or delete storage locations that you don't need. ![]() On the Admin_Lists sheet, there's a small table with locations where you might store your ingredients at home.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |