![]() Indicates on which day of the week the big weekly grocery shopping is typically done. Here we define the rules for the automatic meal plan generation. Which fish meal haven't we had for a long time? → Simply filter & sort in the table.Ĭolumn Filtering: "Category" = Fish Column sorting: "Last served date" - ascending.What could I use them for? → Simply filter in the table.Ĭolumn Filtering: "Ingredients" contains "bell pepper". → Simply filter the columns of the table accordingly: "Contains meat" = 0 "Category " ! = Sweet dish "Popularity" > 1. What could I cook today? It should be something vegetarian, not sweet, and all family members should like it, or at least not dislike it.columns "Recipe URL", "Calories", etc.) Additional columns may only be added to the right of the original columns - not to the left or in the middle. You can also insert your own additional columns and fill them with your own data. They are currently not used during the automatic planning, but can be of interest for an ad hoc inspiration. This attribute is not used during the automatic planning, but is very useful for an ad hoc inspiration. ![]() homemade pizza may have salami in some sectors, other sectors may be vegetarian cooked lentils may be served optionally with or without sausage) may contain some meat in parts or optionally (e.g.a vegetarian meal with no meat contained.An integer that indicates whether (or how strongly) the meal contains meat. ![]() Therefore, we do not include such basic ingredients here. We assume that we always have some basic meals in stock at home, such as pasta, tinned tomatoes, salt, etc. Which ingredients (which we don't always have at home) do you have to buy for this meal? These ingredients are used to generate the shopping lists. The popularity plays an important role during the automatic planning, see the worksheet Rules. ![]() Okay for all family members, popular with some. At least acceptable for all family members. Some family members do not eat this meal at all. This value can be used to keep some meals in the collection but exclude them from the planning. We use the following scale, but you can also define others. An integer that indicates how popular the meal is among the family members, similar to a star rating. The effort plays an important role during the automatic planning, see the worksheet Rules. We use the scale from 1 to 3 (1 - easy, 2 - moderate, 3 - laborious), but if you wish, you can also use higher-level scales, e.g. An integer: from 1 for lowest cooking effort to X for highest cooking effort. Later, during the real use, the function should no longer be used in order to avoid data loss. This is very useful for initial playing-around and experimenting with the tool. It clears all dates in the two date columns. This button is located above the "Last serving date" column. if someone wishes to do a statistical analysis of their own meal history. It is potentially useful for archiving or analysis purposes, e.g. This text field collects all previous serving dates. This ensures a maximally varied meal plan. It is used to maximize the repetition distance for each meal. Is empty initially, but becomes increasingly important with a longer use. This is essential for planning, as will become clear later on the worksheet Rules. Both are just variants of the meal "pasta with tomato sauce". For example, we do not differentiate between "spaghetti with tomato sauce" and "penne with tomato sauce". Additional information on possible variants & side meals. When hidden, the data is retained and will still be used. If necessary, selected columns can be easily hidden or shown through the Excel standard functionality in order to improve the readability of the table. The meals are in the rows and their attributes in the columns. The meal collection is stored in a filterable table. Some of these are used during the automatic planning, some are potentially useful or interesting. Several attributes are defined for every meal. It contains the collection of all meals which we can cook. The Excel workbook is divided into four worksheets: Meals, Rules, Planning, and Language. VBA as a relatively primitive language with clear disadvantages compared to professional languages like C++, C#, etc.simple data storage, sorting, filtering, etc.no user interface needs to be programmed – the user interface is Excel.The implementation via Excel with Visual Basic macros has the following advantages and disadvantages: It targets one cooked meal per calendar day. This tool is used to generate a maximally diversified meal plan, based on your own meal collection, while adhering to certain rules.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |