Is there an excel spreadsheet that recalculates weight daily?
GatorDeb1
Posts: 245 Member
I'm looking to enter height, age, gender, starting weight once and then have it calculate bmr and daily deficit on its own, I.e. as days with a deficit go on the bmr goes down without me having to enter anything more than calories eaten and exercise done.
0
Replies
-
The precision nutrition site has a great calculator that makes an exportable CSV file for Excel based on your inputs and forecasts.0
-
I'm assuming that you have Excel or are you using the free version online?
If you have the paid version, go to the following:
-File
-Then select "More Templates" (it's on the far right-hand side of the page in blue font)
-Then in the search field, input "calorie amortization schedule"
-2 templates will pop up that you can choose from
Hopefully that helps!1 -
It's very easy to do. My homemade spreadsheet, which took about an hour to make, tracks "actual" and "projected" weight, along with cals, exercise, and (calculated) weight loss for the day (a formula, which is ((TDEE-net calories for the day)/3500). The projected weight column is simply a running total of calculated daily weight losses from one scale reading a year and a half ago. I also have a column "delta" that shows the deviation of actual weight from calculated weight; in other words, -1.2 means I am currently 1.2 pounds less than would be suggested by the TDEE based calculation; it now stands at -2.3 after 18 months, which only means my TDEE estimate is accurate.
My formula reduces my TDEE by 5 calories per pound lost, which is sort of equivalent to reducing BMR as your weight decreases. BMR is not a germane variable in a weight spreadsheet, but TDEE definitely is.3 -
Surely you want to track TDEE and not BMR if you are intending using the information to set an eating goal?1
-
lgfrie, that's a brilliant idea! I have an excel spreadsheet that I use and I never thought to do that. I will incorporate that into my spreadsheet.1
Categories
- All Categories
- 1.4M Health, Wellness and Goals
- 393.3K Introduce Yourself
- 43.8K Getting Started
- 260.2K Health and Weight Loss
- 175.9K Food and Nutrition
- 47.4K Recipes
- 232.5K Fitness and Exercise
- 422 Sleep, Mindfulness and Overall Wellness
- 6.5K Goal: Maintaining Weight
- 8.5K 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.7K MyFitnessPal Information
- 23 News and Announcements
- 1.1K Feature Suggestions and Ideas
- 2.6K MyFitnessPal Tech Support Questions