Comments

You must log in or register to comment.

snorkleface OP t1_j5jenzl wrote

Source: I weighed myself every day, logged into Excel

Tool: Excel into Power BI for visualizations

I used a 3-day rolling average as my primary metric to smooth out the high variability day to day. While I hit my goal a few times on a single day, I only considered my goal met when the 3 day rolling number hit the line.

Starting a weight loss journey around the holidays is tough, but not impossible. You can see some of the big upswings when viewing at the week level are all around the big holidays and weekends where we had holiday "stuff" going on (eating and drinking a lot). Week 11 started the Monday after Christmas, the only WoW increase in weight up until that point.

Another interesting, but maybe not surprising, datapoint is my average by day. Mondays are always my heaviest (coming off of the weekend) and Thursdays are always my lightest (coming off Mon-Wed of healthy eating and exercise). By this logic Fridays should be my lightest, but about half the time I give up by Thursday night and have some wings and beer.

9

Any-Bottle-4910 t1_j5jezb0 wrote

Well done!! I started at 232 a year ago. I’m at 207 now with 205 being my lowest. You’re killing it! I know how hard it is.

7

no-stars-in-my-eyes t1_j5jgd3m wrote

Congratulations! I really like the fact that you didn't yo-yo diet like so many others do when they're trying to lose weight. This seems really healthy and you'll definitely keep it off because you worked it in to your daily routine!

3

snorkleface OP t1_j5jgykc wrote

Thank you! Depends how you interpret the chart haha, there's a lot of up and down swings.

I track every day to increase data accuracy and to keep myself accountable. But even if my day to days varied a lot, I tried to stick to the magic 0.5-1lb loss per week on average.

2

stickybuttflaps t1_j5js5k9 wrote

The y-axis isn't labeled and the x-axis has no scale at all.

0

snorkleface OP t1_j5jsvqq wrote

You're right, I built this for myself originally not intending for anyone else to see it.

The x-axis is labeled its just hard to see. It's called a "continuous axis" vs a "categorical" one. Categorical shows each data point (in this case a single day). Continuous auto-adjusts to show only the big-picture metric over time.

In other words, what my weight was on December 27th isn't important. What is important is my trend over time. Hope that makes sense.

2

Vmagnum t1_j5k5hy4 wrote

Are you me? I did the exact same thing several years ago starting at about the same weight and also using a 3-day rolling average. Lol. Good job 👍

4

CypherMcAfee t1_j5lnm5x wrote

is this an app? or you inserted your data?

congrats on the journey and keep going strong!

1