Spreadsheet for BMR/TDEE Deficit, Macro calcs, HRM zones
Options
Replies
-
Found an error that had been there for 1 version.
HRM tab, VO2max calc for MET value, checks if the HRMG is "1". Should be number 1, no quotes.
But I also took the time to add a second VO2max calc for males that had great validity in studies, and I think a better view of the Personal Calorie burn chart at the bottom. Allows more entries and variety.0 -
bump:noway:0
-
bump0
-
Bump, thanks0
-
Bump0
-
Anyone use OpenOffice download successfully with the spreadsheet?
Could use some suggestions if you have.
http://www.myfitnesspal.com/topics/show/717858-spreadsheet-bmr-tdee-and-deficit-calcs-macros-hrm?page=5#posts-119663520 -
Bump0
-
Awesome! Thank you!0
-
BUMP0
-
awesome, much thanks!0
-
Bump0
-
bump, thanks0
-
bump0
-
bump0
-
I just checked this out a bit especially looking at MFP tweeks. I have tried to research what my calorie goal on MFP should be after realizing I wasn't eating enough calories. It is interesting that this spreadsheet is within less than 50 calories of what I determined to be a good goal for me but with alot less effort than what I went through to determine what it should be. It gives me about 46 more calories daily. Thanks again.0
-
I just checked this out a bit especially looking at MFP tweeks. I have tried to research what my calorie goal on MFP should be after realizing I wasn't eating enough calories. It is interesting that this spreadsheet is within less than 50 calories of what I determined to be a good goal for me but with alot less effort than what I went through to determine what it should be. It gives me about 46 more calories daily. Thanks again.
And what's nice with the MFP Tweak tab and a non-sedentary type job, you can still use the Activity Calc on the Simple Setup tab and enter in work hours standing or moving a lot, and then see on the MFP Tweak tab what that is.
Even many with sedentary jobs are really Lightly Active by MFP terms.
At least you are setup now for when the weight or bodyfat% comes down and the stats change.0 -
Thank you!!0
-
Ok, for those that download as an Excel file, there is some formula on the HRM tab that doesn't convert well, and Excel is discarding or changing something.
I've been over the Excel and Google versions comparing and can't see anything that was changed except a bunch of parentheses are added, but the results are all the same.
So be aware there is an error on DL.
The Google spreadsheet has no problem of course since it was written there.
I made some formatting changes to numbers to day on the other tabs.
Well, I fixed something, not really sure what. Or Google converts to Excel without an issue.
Either way, last few times saving it and opening in Excel had no comments of an issue.
Also corrected some visual things to display numbers in text lines better, only about 4 of those total though.0 -
bump0
-
Awesome! Thank you!
Hope that's from actual usage and not just looking it over.
Starting to wonder if Google's Excel conversion is on the fly and changes accuracy sometimes.0
Categories
- All Categories
- 1.4M Health, Wellness and Goals
- 392.1K Introduce Yourself
- 43.6K Getting Started
- 259.9K Health and Weight Loss
- 175.7K Food and Nutrition
- 47.4K Recipes
- 232.3K Fitness and Exercise
- 403 Sleep, Mindfulness and Overall Wellness
- 6.4K Goal: Maintaining Weight
- 8.5K Goal: Gaining Weight and Body Building
- 152.8K Motivation and Support
- 7.9K Challenges
- 1.3K Debate Club
- 96.3K Chit-Chat
- 2.5K Fun and Games
- 3.4K MyFitnessPal Information
- 23 News and Announcements
- 999 Feature Suggestions and Ideas
- 2.4K MyFitnessPal Tech Support Questions