Macro meal planner template reddit3/30/2024 ![]() Each quadrant of the sheet would probably be a separate sheet in the real version. I made a rough and incomplete example here, using a small subset of a list of Indian recipes I found on Kaggle. Make sure to also deduct any ingredients used in recipes from the amount available at home before clearing the sheet each week and reusing it for the next week Optionally, add other bells and whistles like a recipe lookup page, nice formatting, images, etc.Īfter each shopping trip, update the amount of ingredients available at home to subtract the amount of each ingredient available at home and display the positive amounts as a shopping list Use QUERY or SUMIFS to add together the amounts of all the ingredients ![]() Use QUERY or FILTER to pull all the ingredients for each selected recipe into a single list For example, if the recipe lists rice in cups, you need to record the amount of rice you have left at home in cups or translate "5-pound bag" into a number of cups. Note that the units either must be the same as the ones used in the recipes, or you need a way to automatically convert them. Make an inventory of all the ingredients in your home, then enter, clean, and organize them as well. consistent punctuation/capitalization/abbreviation (formulas will treat "tsp", "Tsp", "tsp.", "teaspoon", "teaspoons", "Teaspoon", and "Teaspoons" as separate) and standardizing the units This would involve many different steps and a lot of time/effort, at least if you want the result to be useful:Įnter the data from them into a spreadsheetĬlean and organize the data, e.g. Points Leaderboard #Ĭlick Here to see the full list. Please be patient, sometimes it takes a couple of minutes. OPs must reply to the best solution with "Solution Verified" to change the flair to 'Solved' and award the user a ClippyPoint. You can use this Google Form link to request a shared google sheet be emailed to you that you can use to provide a sample of your issue. Providing a sample of data will make it easier for others to help you. ![]() Google's Function List Provide your data! Submissions Submission Guide Wiki Resources Help and support with your functions, formulas, formatting, and Apps Scripts macros in Google Sheets.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |