I’m going to use a diet tracking sheet I made for my colleague as an example.
After the set-up phase, the only thing remaining to you is listing the foods and portion sizes. In fact, Excel can take care of most of the calculations necessary. So let’s make a diet tracking sheet in Excel! Setting up an Excel sheet for tracking You’ll get to add “Good command of Excel” to your CV after all. You could use one of the bazillion mobile apps, but I’d still recommend the good old Microsoft Excel. Luckily, we are not forced to rely on a pen and a notebook anymore. List the foods that you eat along with their amounts, and calculate the calories and macronutrients out of that data. Eating exactly 2000 calories a day with 150 grams of protein to a 50 kcal / 10 gram error margin – that’s something completely different.
Excel food and calorie tracker how to#
Eating healthy is easy – everybody knows how to do that at least on the conceptual level. No way around that, unless you’re a) the Terminator or b) some kind of a nutrition- savant.
You know your daily target numbers for total calories plus protein.īut how to make sure you are actually hitting them? How to track your dietĪt least in the beginning, you’ll have to write down what you eat and make some calculations. So you’ve decided to get more fit and made yourself a diet plan. Let’s directly continue where we left off. How to make a diet tracking sheet in Excel
0 kommentar(er)
