Sarah's OMAD Journal
Replies
-
I can see why you like the app you're using, seems like it helps keep everything in check. Your down trend is awesome!1
-
That is a nice little tool! It's good to realize that we don't lose or gain that fast so scale readings don't cause us to stress too much! Congrats on your improvements
1 -
@minigrrll what site/software are you using? I love how it projects into the future based on your current data
is there anyway to make it work with weekly entries instead of daily? I would lose my mind weighting in everyday haha
I think the whole idea is to weigh daily when you use it - that's how it gets a moving average rather than using just a once a week weigh in where your weight could be anywhere at that particular point in time. The website is: https://trendweight.com and it's based on the Hacker's Diet which was a diet that was around in the 90's I think. I remember reading it!
There are others that do a similar thing - the apps Libra for Android and Happy Scale for iPhones are a couple I can think of...
thanks, I'll check out Libra then, what caught my attention was the date you reach your goal weight, that's neat, but it seems a daily input is necesary0 -
It would still extrapolate the missing readings, but the data wouldn't be nearly as accurate or useful...0
-
I just set up my Trend Weight account, and I am liking it. I will use this over Libra for now on.1
-
You can also calculate a moving average very easily in excel. Just set the current moving average weight to the average of the last how ever many weigh-ins. It will do extrapolation also.1
-
tlblanksfit wrote: »I just set up my Trend Weight account, and I am liking it. I will use this over Libra for now on.You can also calculate a moving average very easily in excel. Just set the current moving average weight to the average of the last how ever many weigh-ins. It will do extrapolation also.
I am so into all the data that I use Libra and Trendweight and do a moving average and extrapolation in Excel. I have forecasts that show me losing a pound a week, 1.5 pounds a week, 2 pounds a week and the real moving average. Then I have the rows for important dates highlighted a different color. Though, now I read that back it sounds just a touch obsessive!
In my defense, I have both a math degree and a computer science degree and I'm an information analyst/Informaticist, so I'm going with "it's totally out of my control" (much like the drinking, lol)...
0 -
tlblanksfit wrote: »I just set up my Trend Weight account, and I am liking it. I will use this over Libra for now on.You can also calculate a moving average very easily in excel. Just set the current moving average weight to the average of the last how ever many weigh-ins. It will do extrapolation also.
I am so into all the data that I use Libra and Trendweight and do a moving average and extrapolation in Excel. I have forecasts that show me losing a pound a week, 1.5 pounds a week, 2 pounds a week and the real moving average. Then I have the rows for important dates highlighted a different color. Though, now I read that back it sounds just a touch obsessive!
In my defense, I have both a math degree and a computer science degree and I'm an information analyst/Informaticist, so I'm going with "it's totally out of my control" (much like the drinking, lol)...
I'm an engineer so I can relate! Now stop that drinking if you don't want to! It is within your control!
One thing with the backwards moving average is that in essence it is a discrete filter (hence it smooths the data out) but it also causes a lag in the data that you can see if you plot the raw data along with the filtered data (which I'm sure you know about).
That's a great combination (CS and Math). I did a BSME and an MSEE (control theory). Take care.0 -
I will have to look up and see how to do the moving average and extrapolation in Excel. I love making the spreadsheets but have to learn more how to work with the data.0
-
tlblanksfit wrote: »I will have to look up and see how to do the moving average and extrapolation in Excel. I love making the spreadsheets but have to learn more how to work with the data.
Moving averages - you just take the last x measurements and divide by x.
So=SUM(J32:J38)/7
for a 7 day moving average (average of the last 7 days weights). Copy that formula down and you get the next average etc etc. You can choose how many days to include.
I'm sure there are ways to do it automatically in Excel these days too...
I think there is a trend function for extrapolation.
My formula (this is the one for predicting what my weight will be on any day in the future if I carry on losing at the rate I'm losing now) is crazy(=IF(N38<>"",IF(G38="",IF(N38+(K39/7)>=130,N38+(K39/7),""),IF(G38+(K39/7)>=130,G38+(K39/7),"")),""))
but that's because I'm checking to see if values are blank and then using other values and I want to stop if it goes under 130 lbs (hahahahahaha - in my dreams...) etc. etc.
Gotta love Excel!!
0 -
Yay!
Back down to Sunday's weight - hopefully it sticks around this time.
1 -
Awesome, way to go, Sarah!0
-
tlblanksfit wrote: »I will have to look up and see how to do the moving average and extrapolation in Excel. I love making the spreadsheets but have to learn more how to work with the data.
Moving averages - you just take the last x measurements and divide by x.
So=SUM(J32:J38)/7
for a 7 day moving average (average of the last 7 days weights). Copy that formula down and you get the next average etc etc. You can choose how many days to include.
I'm sure there are ways to do it automatically in Excel these days too...
I think there is a trend function for extrapolation.
My formula (this is the one for predicting what my weight will be on any day in the future if I carry on losing at the rate I'm losing now) is crazy(=IF(N38<>"",IF(G38="",IF(N38+(K39/7)>=130,N38+(K39/7),""),IF(G38+(K39/7)>=130,G38+(K39/7),"")),""))
but that's because I'm checking to see if values are blank and then using other values and I want to stop if it goes under 130 lbs (hahahahahaha - in my dreams...) etc. etc.
Gotta love Excel!!
Can do a central point moving average ()instead of a backwards moving average) also with no lag in the filtered data but then the last data points wont have info to average in since that hasn't happened yet and filtered data past the central point will be more noisy.0 -
Just keeping it simple with the last 7 days... I actually don't mind the lag because then when I do have a little gain, as long as it's under the trend line, I'm happy!1
-
And of course that low weight didn't stick around as I am quite possibly the slowest loser EVA! Anyway, Trendweight took a few days off my goal date (was May 3rd yesterday and now is April 26th), so I'll take that as a win!
I did eat a massive amount of roast veggies yesterday and I put a fair amount of seasoning salt on them, so I'm laying the blame on the salt. Looking for a drop tomorrow (my "official" weigh day) though.
1 -
Oh, nice that it upped your goal day! I've got Hapoy Weight app installed on my phone now. I like it so far 1
-
Just a quick stop to update my weight (official weigh-in day today). Work is outta control!
Trendweight is even more happy with me today...
And my chart - it sure would be nice to see 10 pounds lost...
1 -
Nice loss!1
-
Awesome and next week you'll be in the 80's 0
-
You are doing great!1
-
Nice steady loss. Extrapolate a year and see where your at!0
-
Nice steady loss. Extrapolate a year and see where your at!
I have extrapolations for current rate of loss (stops at Feb 22 as that would put me at 130 - which I have never weighed in my entire adult life), 1lbs per week (about 137 this time next year), 1.5 per week (stops at March 6 at 130) and 2 per week (stops at Jan 26 at 130). So we shall see!!
My goal is 154 btw, but I might go into the 140s when I get there. Last time I was in the 140s, I felt too thin, but I also had much more muscle than I have now, so it might be ok.
0 -
Thanks everybody. I had a weird weekend. I gained a massive amount over the weekend, but then dropped it all and hit a new low today! Like Brenda predicted, I dropped into the 180s - just... and I'm not really counting it until my trend gets there, but it is nice to see finally!!1
-
I changed the setting on Trendweight to be in pounds because I wanted to see that 189!!
1 -
Awesome, awesome, awesome! I know you are tickled! I find it a bit extra exciting because you and I are not too far in weight, and our goals are similar, too. I root for everyone, just seems cool to be going through these stages in particular, together. 0
-
good progress, do you count calories, as in weighing your food, or just wing it with one meal a day. eyeballing portions?0
-
wsandy8512 wrote: »Awesome, awesome, awesome! I know you are tickled! I find it a bit extra exciting because you and I are not too far in weight, and our goals are similar, too. I root for everyone, just seems cool to be going through these stages in particular, together.
Absolutely!!1 -
good progress, do you count calories, as in weighing your food, or just wing it with one meal a day. eyeballing portions?
I do both - depends how motivated I am to use mfp for logging! I generally do log on weekdays and then am more lax on the weekend - both with logging and with how long my eating (drinking) window is. I pretty much stick to a strict one meal (not necessarily one plate though - I won't finish a meal feeling hungry), an hour or less on the weekdays and then stretch that out to a few hours on the weekend to include some alcohol.
If the weekends start slowing me down significantly though, I'll rethink that.
I find that the weekend slackness helps with my state of mind though - I'm don't do well with feeling deprived and having been on so many diets in my life it has become old! I'd rather lose slowly while feeling satisfied and "normal" than crash and burn losing quickly and never feeling full.2 -
got it, I loled at "drinking window" , eventually you d probably will have to bring some structure to the weekends but ride it as long as you can haha
0
This discussion has been closed.