Share via

How do i create a meal tracking spreadsheet?

Anonymous
2023-08-31T02:53:15+00:00

In word, I have a table of food with calories, fat, protein, and carbs of each food item. I somehow want to make a spreadsheet that when I enter a food item I eat it subtracts the info from my daily calories and macros and possibly workout the calories burnt from the info. For example, if my maintenance is 2500 calories and my goal is to hit 200g of protein, 100g of fat, and 150 g of protein I want to enter it kind of like this - I enter one party pie and it finds from the list it has 84 calories, 8.6g of carbs, 4 g fat and 3.4g protein. So let's say that's all I had for the day, I'd want it to say during the day that I had x amount of protein, x amount of fat, carbs, and calories, and tell me how many calories I burnt today on food, eg 2500 - 84 = 2416 so I had this many calories today with this much macros and burnt 2416 calories. I could also link this to microsoft access i believe but feel like I need to have excel as the starter.

So, where should I start? I've already got the table in Word that looks like so.

Summarized, I only want to enter the food and have Excel work out that out of 200g of protein, I had x amount today, with the rest of the macros and the amount of calories I have eaten and burnt that day. Let me know if you have questions. Thank you.

Diet Info

Food Calories Carbs Fat Protein
Belvita milk and cereal biscuits. 1 pack – 4 biscuits 213 35.5g 7.5g 3.6g
Granny smith apple – green – whole apple 63 15g 0.2g 0.5g
Greek style yogurt – farmers union – 125 grams – 4 tablespoons average 153 6.5g 11.8g 5.6g
Fueld chipotle fried chicken ready meal 684 56g 31.1g 40.2g
Hoki fish lemon crumb – 1 – 71g 161.5 14.85g 7.3g 8.75g
Hoki fish lemon crumb – 2 323 29.7g 14.6g 17.5g
1 premium king island beef sausage roll 105 10.5g 5.6g 3.2g
1 premium kind island beef party pie 84 8.6g 4g 3.4 g
1 chicken breast schnitzel (lilydale brand) 190 8.7g 9.9g 16.2g
3 oreo vanilla cookies (normal size) 137 19.4g 6g 1.3g
Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-08-31T03:34:25+00:00

    Hello Aiden,

    I'm Shalom and I'd happily help you with your question. In this forum, we are Microsoft consumers just like yourself.

    You can create a meal tracking spreadsheet in Microsoft Excel to track your daily food intake and calculate your remaining calories and macros. Here’s how you can get started:

    Open a new Excel workbook and create a table with columns for food, calories, carbs, fat, and protein. You can copy the data from your Word table and paste it into the Excel table.

    Create another table to track your daily food intake. This table should have columns for the date, food, serving size, calories, carbs, fat, and protein.

    Use formulas to calculate the total calories and macros for each food item based on the serving size. For example, if you ate 2 servings of Belvita milk and cereal biscuits, the formula for calculating the total calories would be =2*213, where 213 is the number of calories in one serving.

    Use formulas to calculate your remaining calories and macros for the day. For example, if your maintenance is 2500 calories and you’ve eaten 1000 calories so far, the formula for calculating your remaining calories would be =2500-1000.

    Use data validation to create a drop-down list of food items in the daily food intake table. This will make it easier to enter your food intake data.

    Use conditional formatting to highlight cells that are below or above your daily goals.

    I hope this helps you get started with creating a meal tracking spreadsheet in Excel. Let me know if you have any questions.

    Best Regards, Shalom

    0 comments