Forum Discussion
Recipe nutrition database/pivot table
Im not new to excel but very new to tables, databases, and pivot tables. My knowledge base is very limited on what Ive done so far. I am trying to develop a way that I can choose certain recipes whic...
No not a chef. Im a maintenance manager that dabbles with excel to show information to my crew with graphs. Someone at one point created a pivot table that I use to see our downtime. I also like using excel to automate some math functions. This is a new realm for me in excel. What I would like to be able to do is pick what Im eating each day to make sure I dont go over daily values. So lets say Im going to the store. I pick what Im going to eat each day, check the values, and also know what I need to buy. We make most of our food from scratch. No boxed dinners and limit the amount of processed ingredients. Thats why the recipes would have the ingredients. I will be more than happy to use any tool that best suites this. That is why I reached out to ask. I very much appreciate your help. Ill look all these ideas over once I get home. You've provided a lot of information to go over.
Thanks, that's a helpful description of the context. I take all that to mean that this could be an informal record keeping solely for your personal use. In that case, you might look for nutrition tracking spreadsheets that others have already created. Weight Watchers might have something (a friend profited from their disciplines toward losing weight, and i know some of it involved tracking things as you're doing).
In other words, you don't need to re-invent the wheel, although it is fun to tweak and improve what others have done,
- https://1drv.ms/x/c/5c44253842f5d23a/ERuw6QnAvj9FuyKVpA797lEB-pS6JI8SnN_IZt8lkLrsoA?e=AWzO7y
This will get me by once I input all the data. I knew it would be something simple like you explained for just putting the same name of the recipe in each row for its ingredients. Now that I can see how this can work I still want to look at the other things you suggested. Thank you for your help
