Have you tried GLP1 medications and found it didn't work for you? We'd like to hear about your experiences, what you tried, why it didn't work and how you're doing now. Click here to tell us your story
Proof that weighing daily is confusing unless you look at the big picture. (Spreadsheet!)
Lottiotta
Posts: 162 Member
I've been losing weight pretty consistently for a few weeks with a combination of calorie-tracking and my Fitbit. According to MFP and Fitbit I'm eating at maintenance and don't really have a calorie deficit on average, but I'm losing about .25 kg per week. My start weight was 62 kg and my goal weight is... uncertain, but probably 59 kg or a smidge lower.
Anyway, when I heard that weight can fluctuate by several lbs per day based on water intake, salt intake, hormone levels, recent exercise, etc., my "let's make a spreadsheet" reflex kicked in. This one, I enter my weight every day in the morning before breakfast, and that varies a LOT - but then, in another column, it tells me what my average weight for the past two weeks of entries is. And then it puts everything on a graph, so I can compare my calorie intake vs. burn, my weight every day, and my 14-day weight average.
{LINK TO SPREADSHEET}
In this graph, the red line is my calorie "balance" and you can pretty much ignore that. The good bit is the thick green line, which is my 14-day average weight, and the thin grey line "behind" it is my day-to-day weight. See how it's all over the shop, but the thick green average line is steadily declining? If you don't look at the big (14-day) picture, it's very easy to think that there's no rhyme or reason to your weight. One week's worth of daily weight recording doesn't mean much at all, but a 14-day average over time will show you trends.
When my 14-day average weight changes, that's when I log the weight in MFP.
So I'm posting a link to my spreadsheet here, so people can:
The moral of the story: weighing yourself daily is a path to madness - unless you obsessively spreadsheet everything!
Anyway, when I heard that weight can fluctuate by several lbs per day based on water intake, salt intake, hormone levels, recent exercise, etc., my "let's make a spreadsheet" reflex kicked in. This one, I enter my weight every day in the morning before breakfast, and that varies a LOT - but then, in another column, it tells me what my average weight for the past two weeks of entries is. And then it puts everything on a graph, so I can compare my calorie intake vs. burn, my weight every day, and my 14-day weight average.
{LINK TO SPREADSHEET}
In this graph, the red line is my calorie "balance" and you can pretty much ignore that. The good bit is the thick green line, which is my 14-day average weight, and the thin grey line "behind" it is my day-to-day weight. See how it's all over the shop, but the thick green average line is steadily declining? If you don't look at the big (14-day) picture, it's very easy to think that there's no rhyme or reason to your weight. One week's worth of daily weight recording doesn't mean much at all, but a 14-day average over time will show you trends.
When my 14-day average weight changes, that's when I log the weight in MFP.
So I'm posting a link to my spreadsheet here, so people can:
- see how weight can fluctuate a lot day-to-day but *on average* consistently go down .1 kg every few days for many weeks. (I'm almost 2 kg down from my start weight, and it's taken me a little bit over 6 weeks.)
- copy the spreadsheet to their own Google Drive or download it to their computer to use themselves.
The moral of the story: weighing yourself daily is a path to madness - unless you obsessively spreadsheet everything!
0
Replies
-
Thank you for sharing this!0
-
elga_thres wrote: »Thank you for sharing this!
No problem!0 -
I weigh everyday just so I can log it. If you don't record it you can't report on it later. It's good to see the progress over time. Yes it varies each day and you can just ignore the ups and downs, that's usually water weight. It can also be very encouraging to see a low number pop out there sometimes. It's easy for me to ignore the high numbers and enjoy the low numbers.
My glass is half full.0 -
As someone who was becoming a little scale-obsessed, I really appreciate that you've tracked and posted this. I'm going to take this as a lesson to cool my jets on the scale.0
-
Or you can be consistent with calorie intake on a daily basis, as well as water intake, and you won't have the problem of your weight fluctuating from day to day.0
-
Or you can be consistent with calorie intake on a daily basis, as well as water intake, and you won't have the problem of your weight fluctuating from day to day.
That doesn't take into account hormones, salt, and exercise. But even if it did, I'd still rather have a spreadsheet 'cause it's easier!0 -
justrollme wrote: »As someone who was becoming a little scale-obsessed, I really appreciate that you've tracked and posted this. I'm going to take this as a lesson to cool my jets on the scale.
Happy to have helped! Also I like your avatar, it tickles me. :P0 -
Interesting, though my weight doesn't fluctuate that much from day to day (this far, ha).0
-
That's interesting!0
-
If you have a fitbit or withings Aria scale that is linked to MFP, make an account on trendweight.com
If you don't, make an account on fitbit.com (you don't need to own a fitbit for this), synch to MFP, then make an account in trendweight.com
And you get lovely trend charts of your weight that help you track your fluctuations and ongoing weight
Like this
0 -
@rabbitjb That does look a lot tidier than my graph! I'll try it out. (I might not stick with it though - I find it motivating to see how weight loss is affected by calories.)
Thanks for taking the time to put in some screenshots.
I am an excel geek and love your graph @Lottiotta so don't stop, because the calorie overlay isn't available on trendweight
The thing with trendweight is so long as you log your weights in MFP and have synched them all up, it's automatic...any time you go in to trendweight it just sits there0 -
Trend weight is also a weighted moving average giving more weight to recent days than older values, I think. A straight 14 day moving average responds more to the difference between today and 2 weeks ago as all the other points are the same.
So you could put another line on the excel and tweak the EWMA parameters to see which is best.0 -
I am an excel geek and love your graph @Lottiotta so don't stop, because the calorie overlay isn't available on trendweight
The thing with trendweight is so long as you log your weights in MFP and have synched them all up, it's automatic...any time you go in to trendweight it just sits there
I already had a Fitbit account and I like the weight input thing in the MFP app, so it turns out TrendWeight is much easier for me than I thought it would be! I like how it shows the weird little fluctuations, it's different from my spreadsheet graph. I do still like that I can poke my spreadsheet and graph to show whatever I want (like calorie intake), so I'm definitely going to keep doing it - and now I've set up TrendWeight it'll just keep going in the background.
So, thank you!0 -
Thanks for posting the excel file. I've been using trendweight but I like the calorie information on your spreadsheet. Comes in handy.0
-
Or you can be consistent with calorie intake on a daily basis, as well as water intake, and you won't have the problem of your weight fluctuating from day to day.
Not true at all! No matter how "good" or rigid you are with you calorie intake, there are other variables that will play into your scale weight. Salt, hormones, heat (I swell in the heat), undigested food in your belly, water that you haven't yet peed out, as well as many other factors all play a part in your scale weight as well. You can think you have been perfect, but the scale might still show a gain. You have to always understand that weight loss is not linear, no matter how much you want it to be. The trick is to look at your overall trend, not the individual day-to-day weights.0 -
This is really cool to look at! I weight weekly as I find the fluctuations difficult to deal with, but seeing it on a graph with a trendline looks really good. I might give this a go!0
-
I am both a scientist and a data geek, so I'm absolutely loving this thread. I mean, really, really loving it. Going to check out trendweight.0
Categories
- All Categories
- 1.4M Health, Wellness and Goals
- 392.8K Introduce Yourself
- 43.7K Getting Started
- 260.1K Health and Weight Loss
- 175.8K Food and Nutrition
- 47.4K Recipes
- 232.5K Fitness and Exercise
- 413 Sleep, Mindfulness and Overall Wellness
- 6.5K Goal: Maintaining Weight
- 8.5K Goal: Gaining Weight and Body Building
- 152.9K Motivation and Support
- 7.9K Challenges
- 1.3K Debate Club
- 96.3K Chit-Chat
- 2.5K Fun and Games
- 3.6K MyFitnessPal Information
- 23 News and Announcements
- 1.1K Feature Suggestions and Ideas
- 2.5K MyFitnessPal Tech Support Questions