![]() 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. Thanks for stopping by! Your support is appreciated.This tool is used to generate a maximally diversified meal plan, based on your own meal collection, while adhering to certain rules. I want you to be happy doing business with me so any questions are welcome. We are always trying to improve our products so any recommendations or thoughts are greatly appreciated. If you need something custom made, feel free to reach out. We take pride in creating simple, but comprehensive products at an affordable price. Here is where you can find alternative meal planner variations. Please do not copy, share, redistribute or resell these spreadsheets. These products are meant for personal and not commercial use. Due to the type of product, these digital products are non-refundable. Support: If you need help with this product or have inquiries, contact us. ![]() If there are any issues, here's an article about how to download digital items.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |