Use a single table for the raw data and a second table for the calculations. Keep the raw table as a named range—something like MealData—and reference it with structured references so the columns stay in sync as you add rows. Put the formulas in their own sheet; that way you can tweak logic without breaking the data sheet. If you need to reuse a calculation, make it a reusable named formula, and use array formulas (or LET) to avoid repeating the same expression over and over. Don’t mix data and calculations in the same cells, and stick to a consistent naming convention; it saves a lot of head‑scratching later.

Sounds good, just keep an eye on edge cases—spreadsheet quirks love to surface when you least expect them. Ping me if you hit a snag, but try not to overcomplicate the logic.