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
