Tracking progress in Microsoft Excel

Nevada

MFP has a nice set of chart tools, but if I can do it myself, I will.
I copied my weight data into a worksheet, and have this so far:


This plots pounds, Forecast() by week, and one pound loss per week goal.

I weigh-in almost every day. It is telling me I should be eating more to stick to my goal.
I can see the week I traveled for work, and a weekend in Las Vegas.

Anybody else using Excel? What are you plotting? How do you smooth the weight data?

TheArchyBunker

I've never used it to plot my weight loss or chart it even. I used to use it for tracking calories and macros though. This is a pretty cool idea man.

zingeber

I use google sheets. Simpler interface, portable across devices as long as you have the app. There's an option to "smooth data"

PAV8888

I use trendweight and take the weight data into Excel. Feel free to link a sheet

CattOfTheGarage

I used to use it. I tend to use Libra just because it's easier to do it on my phone, but I like Excel's trend line options better. I don't think a running average (which is what Libra uses) works terribly well for weight loss, I think Excel's various polynomial options do a better job of smoothing, and without the big lag you get with a running average.

I must take my current results and put them in Excel and see what it says about them.

SusanMFindlay

I used to have a really detailed spreadsheet with all sorts of measurements and calculations. This time out, I just log weight, calories in, calories out (according to FitBit), daily steps and sodium.



Wanna guess where on the graph I started calorie counting again? (Hint: It's after the second birth.)