Does anyone else track progress using excel?
mcbrainder
Posts: 73 Member
I created a spreadsheet that graphs quite a bit of info as I go, but I'm always wanting new ideas and to add to my own.
Does anyone else do this? Would anyone want to share ideas or show their spreadsheet? I'm really spreadsheet-happy and wanted to know who else does this.
Does anyone else do this? Would anyone want to share ideas or show their spreadsheet? I'm really spreadsheet-happy and wanted to know who else does this.
2
Replies
-
I track my measurements I excel but haven't done any graphs0
-
Yes I track daily weights, macros and calorie intake. From that I can calculate my average TDEE and see how different macros affect my scale weight.1
-
I use excel to track the miles I have walked, run and cycled0
-
I use Excel to track my weight and net calorie intake every day and to monitor my weight lifting progress.
Compute only the 7 moving ave for weight and a 7, 15 and 30 day moving ave for cals. Just compute a simple comparative graph of the weights lifted for squats, DL, BP & OHP over time to monitor strength gains.
Thought about tracking protein intake as as well but didn't bother doing that.1 -
Oh yes, Excel is king.
Date, weight, elapsed days, total loss, daily, weekly and four-weekly losses. BMI and target BMI per day. Projected weight and goal date at a rate of 0.5, 0.6, 0.7, 0.8, 0.6, 1.0kg/wk. BF% and FFM and seven day moving averages for those (only a BIA scale, so I know it's virtually meaningless). Weight conversions to lbs and stones for talking to those who don't use sensible measurements. Daily calories, macros and food goals with overall means, SDs and seven-day moving averages thereof. Comparison to NHS RDAs. Weight graphs with regression lines, r-squared values and regression equations.
Obsessed, moi?2 -
So.... where is the link to your spreadsheet(s)?
Here is one with some "random" example data (note that changing the body composition assumptions does create a significant difference. For example the "random" example would normally be configured for 1.75:1 to 1.85:1 loss and 1.5:1 gain.
https://docs.google.com/spreadsheets/d/14k_zGWeklpl05lNqSWN_SK1XzuwnmVHtUfW8Eao5kIE/edit?usp=sharing
0 -
I don't see a reason with MFP. I used to use Excel to track my Wendler stats because that required percentages but that's about it2
-
I use Google Sheets since it's easier to use on my phone.0
-
Awesome. Already got some good ideas. Once I figure out how to show mine here, I'll post a link.0
-
I keep a monthly budget and I cycle my calories sometimes, so excel is a must. Sometimes I do structured intermittent fasting, other times, like currently, I just eat to satisfaction allowing calories to fall where they may, and then once I reach 1000 calories "debt" I would have a fast day. It's been a week and I haven't had to take a fast day yet, but it's coming soon I think, I have 720 calories in debt. Who knows, though. Sometimes I'm just not hungry enough and end up reducing my debt
0
This discussion has been closed.
Categories
- All Categories
- 1.4M Health, Wellness and Goals
- 393.6K Introduce Yourself
- 43.8K Getting Started
- 260.3K Health and Weight Loss
- 175.9K Food and Nutrition
- 47.5K Recipes
- 232.5K Fitness and Exercise
- 431 Sleep, Mindfulness and Overall Wellness
- 6.5K Goal: Maintaining Weight
- 8.6K Goal: Gaining Weight and Body Building
- 153K Motivation and Support
- 8K Challenges
- 1.3K Debate Club
- 96.3K Chit-Chat
- 2.5K Fun and Games
- 3.8K MyFitnessPal Information
- 24 News and Announcements
- 1.1K Feature Suggestions and Ideas
- 2.6K MyFitnessPal Tech Support Questions