
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 05, 2020 01:49 PM
Goal
-
Track daily macro Protein/Carb/Fat against micro cal goals and see remaining calories if have not met for each day
-
Associate each food entry with a corresponding caloric allotment, e.g., On X day = 1000 cal, on other days = 1200 cal
The challenge I am running into is that I don’t know the best way to structure the table or formula.
Any suggestions, please?
Thanks for your help. :raised_hands:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 05, 2020 02:38 PM
The problem that I see with such a system is that the data entry would be extremely cumbersome. Not only would you have to enter all the foods and their associated calorie counts, you would also have to enter all the food eaten per day. There are many diet apps for counting calories, and human data entry is still a huge pain. In fact, some diet systems rely on the difficulty in data entry–they hope that the effort in entering the data is enough to make people decide not to eat that snack after all.
That said, I think you would need a table system: one for days, another for foods, and a junction table between them. Store the calorie count for each food item in the food table. In the junction table, store the day, the food item, and the number of servings. Have a system of lookups, rollups, and formula fields to do the calculations.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 11, 2024 11:02 PM
To calculate food costs for Taco Bell Bowl Menu, break down each ingredient (rice, beans, protein, etc.) into its cost per serving. Enter these into the food costing calculator to get the total dish cost. This helps in pricing menu items efficiently while maintaining profitability.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 11, 2025 06:20 AM
Figuring out the best way to structure your macro tracking is like ordering from Del Taco Menu—you want the right balance of protein, carbs, and fats, just like you want the right mix of tacos, burritos, and fries! Maybe structuring your table like a menu could help: each day gets a ‘caloric budget’ (like a meal price), and each food entry subtracts from that total. Just like customizing your order, you can tweak your macros to fit your goals while still enjoying what you eat!
