We are pleased to announce that on March 4, 2025, an updated Rich Text Editor will be introduced in the MyFitnessPal Community. To learn more about the upcoming changes, please click here. We look forward to sharing this new feature with you!
Help with calorie spreadsheet for weekly tracking

avskk
Posts: 1,787 Member
Can anyone set up or give me instructions for setting up one of those Excel spreadsheets that tracks daily consumption/goal/difference/expected loss to give a running total? I'm really working to maintain a weekly deficit right now, and I'm finding it hard to keep track with basic math -- clicking back over a week of days, adding and subtracting, blah blah I am dumb.
I'd prefer a Google Docs sheet if it's possible, but I do have access to actual Excel at work. I'm pretty ignorant about spreadsheets; I know the basics of entry and rows/columns but I find formulas and tabulating very confusing. I'd appreciate help with this so much I might sing a song about it.
I'd prefer a Google Docs sheet if it's possible, but I do have access to actual Excel at work. I'm pretty ignorant about spreadsheets; I know the basics of entry and rows/columns but I find formulas and tabulating very confusing. I'd appreciate help with this so much I might sing a song about it.
0
Replies
-
Hate doing this, but... bump.0
-
Maybe I'm misunderstanding. You are needing a spreadsheet to help you keep track of the calories you are eating? Isn't that what MFP is used for? I am sure I am not understanding what you're asking.0
-
I have a template that I use in Excel to keep track of: Daily calories, daily weigh-ins, weight loss with trendline equation, and observed TDEE over 7, 14, 30, 60 and 90-day periods. It unfortunately won't work in Google Docs (some of the formulas aren't recognized) but I can PM you a copy if you like.
1 -
I'm looking for something simpler -- three or four columns. Plug in my day's calories in the first column, Excel compares them magically with my TDEE and spits out my deficit/surplus in another column, totaling out with my weekly deficit/surplus at the bottom. Someone posted a screenshot of a spreadsheet like this in another thread just a few days ago, but I can't for the life of me remember who it was or which thread!0
-
No worries! That should be pretty simple to just create something, no?0
-
I just don't know how to set up to do the math for me. I mean, I could just use a blank sheet and do the math myself, but... you know, that kind of defeats the purpose.0
This discussion has been closed.
Categories
- All Categories
- 1.4M Health, Wellness and Goals
- 394.2K Introduce Yourself
- 43.9K Getting Started
- 260.4K Health and Weight Loss
- 176.1K Food and Nutrition
- 47.5K Recipes
- 232.6K Fitness and Exercise
- 440 Sleep, Mindfulness and Overall Wellness
- 6.5K Goal: Maintaining Weight
- 8.6K Goal: Gaining Weight and Body Building
- 153.1K Motivation and Support
- 8.1K Challenges
- 1.3K Debate Club
- 96.4K Chit-Chat
- 2.5K Fun and Games
- 4K MyFitnessPal Information
- 16 News and Announcements
- 1.2K Feature Suggestions and Ideas
- 2.7K MyFitnessPal Tech Support Questions