Excel and the bathroom scales.
Ignore the predicted which is a bit complicated to explain.
Start by getting the actual numbers on one sheet and show the graph on another.
1st Sheet
Column A holds the dates
Column A 1st row = Start date
Column A All subsequent rows = Row above + 7
Column B holds the target
Column B 1st row = Start weight in pounds (or kilos or whatever)
Column B All subsequent rows = Row above - 2 (or whatever you want as the weekly target. I changed mine after a few weeks when the easy weight disappear to Row above -1)
Column C holds the actual
Column C 1st row = Start weight
Column C Subsequent rows = Actual weight on the date shown in the same row on column A
Column D holds the target
Column D all rows fixed at the target unless you want to move your target over time
Sheet 2
Generate a graph based on sheet 1 and fiddle with the axis until you are happy
If you only look at the trend graph, and don't study the detail or even look at the reading for the day why even bother taking it? Just take the trend ones.
Because, as I said, a weekly reading may not be accurate because of yesterdays daily fluctuation, so taking it daily makes the trend more accurate.
And, as I inferred, and WCA has just said
I know (logically) that daily variances make daily weighing kind of irrelevant but seeing an increase one day will give me the emotional kick to not slip again that evening.
Using scales that link to an app is a lot less work than WCA and his excel spreadsheet, I just step on my scales after my morning shower for a few seconds and that is it. I can see any daily gain if I want, but it is backed by the trending graph as well.
From daily weighing I know that baked potatoes seem to hold some sort of magic for me and help me to drop weight, even though I smoother them in butter. And I know that a Ritter marzipan bar is equal to one pound extra weight the next day. I wouldn't know this if I did weekly weighing.
