We are pleased to announce that as of March 4, 2025, an updated Rich Text Editor has been introduced in the MyFitnessPal Community. To learn more about the changes, please click here. We look forward to sharing this new feature with you!
How I Set Up My Excel Spreadsheet
ljoycew
Posts: 22 Member
Hi all,
Thought I'd share how I set up my Excel calorie counting spreadsheet. It's very simple and basic, but I thought this info might be useful for those who don't use Excel all that much.
Column A:
1. "DATE"
2. May 1, 2014
3. (and so on).
Column B:
1. "Calories Out"
2. 1635
3. (...and so on. I enter this number first thing in the morning, from the previous day's data, from my Vivofit.)
Column C:
1. "Calories In"
2. 1378
3. (...and so on. I enter this number first thing in the morning, from the previous day's data, from My Fitness Pal.)
Column
1. "Difference"
2. 257 (I get this by entering the formula "=B2-C2"
Column E:
1. "Percent Difference"
2. 84% (I get this by entering the formula "=(C2*100)/B2"
Column F:
1. "Weight"
2. (I enter that morning's weight here, just so I can look at it all in one place.)
That's it!
Thought I'd share how I set up my Excel calorie counting spreadsheet. It's very simple and basic, but I thought this info might be useful for those who don't use Excel all that much.
Column A:
1. "DATE"
2. May 1, 2014
3. (and so on).
Column B:
1. "Calories Out"
2. 1635
3. (...and so on. I enter this number first thing in the morning, from the previous day's data, from my Vivofit.)
Column C:
1. "Calories In"
2. 1378
3. (...and so on. I enter this number first thing in the morning, from the previous day's data, from My Fitness Pal.)
Column
1. "Difference"
2. 257 (I get this by entering the formula "=B2-C2"
Column E:
1. "Percent Difference"
2. 84% (I get this by entering the formula "=(C2*100)/B2"
Column F:
1. "Weight"
2. (I enter that morning's weight here, just so I can look at it all in one place.)
That's it!
0
Replies
-
Mine is very similar, but I'm a spreadsheet geek and have some add'l info on there;) But like you, I like having it all in one place. Plus, it's helping me know that on a normal day where I run say 3 miles, I should be eating 1700 calories. On long run days, I should be eating 2900 calories, etc. I like seeing it at glance, knowing it will fluctuate with whatever else I'm doing that day. Tracking the % of TDEE daily is interesting that you're doing, I might have to add that!;)
Column A - day of the week
Column B - date
Column C - TDEE (total calories per VivoFit)
Column D - calculation of 80% of TDEE (80% of column C)
Column E - calories ate (from mfp)
Column F - calculation of under/(over) 80% of TDEE (column D less column E)
Column G - calculation of under/(over) TDEE (column C less column E)
Then each column is totaled for the week, and below the total of column G, I calculate the % under/(over) TDEE (column E weekly total divided by column B weekly total)
Column H - weekly calculation of lb should have (lost)/gained (-column G weekly total divided by 3500)
Column I - weekly actual lb lost (weight that I track daily in column L less previous weeks total)
Column J - (over)/under weekly loss (column I weekly lost less column H weekly should have lost)
Column K - notes (detail what I ran that day, what workout I did, why I ate TDEE if I did for instance the day before a race, etc)
Column L - daily weight0 -
Both sweet plans. I sometimes think mfp has as many number crunching lovers than weight loss people.:happy:
(PS I am also a number cruncher)0
This discussion has been closed.