I learned the MATCH trick from this sub (or maybe r/sheets I don't recall.) It's the opposite of how MATCH is normally used, so it's not very intuitive. Optionally, the function can be wrapped in UNIQUE and SORT functions to remove duplicates and make it easier to compare the list to your cupboards. The heart of the sheet is the function in cell G2, which FILTERs the list of ingredients by MATCHing each line of the recipe name/ID column against the list of recipes you want to make. In fact, rather than adapting the previous example (which was a rough and incomplete proof of concept, plus it normally would have been multiple sheets but I crammed it into a single one for the sake of linking to it), I think it would be better to start fresh, as shown here.Įnter the recipe name (or ID number since you're using a randomiser) & ingredient pairs as shown in columns A-B, plus a separate list of the recipe names/IDs you want to make. Some other food-related sheets you might be interested in: recipe categorizer/selector and nutritional information calculator. The data is not properly cleaned, and I have used the workaround of listing items available at home in negative quantities to make it easier to remove them from the shopping list. 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 |