I use excel, but I added a trend (an exponentially smoothed moving average) which I stole wholesale from the hacker's diet. My graphs have weight and trend weight.
I have a planning tab that maps my loss to the weight loss curves from Ancel Key's Minnesota starvation experiment. The formula essentially says "you lose weight quickly at first, then your loss slows as you approach your goal" It tells me how many weeks I have left, if I'm losing on-target, how many pounds I hope to lose by the next "weigh-in". I can look forward and see when I'll probably hit various milestones, etc.
I have a tab that monitors my cycle-days, so I can see that I always gain weight up to the trend line when I ovulate, and again when my period is due. And then I lose it X days later in a pattern that looks like this...
It tracks exercise, and calculates some exercise trends.
I'm up to 9 tabs now, and it's complete and utter overkill, but I like to fiddle with it, and anytime I feel stuck, or like I'm doing poorly - I can find something in it to remind me that this is all ok.
Even today, when I'm 90% sure I'm going to blow my weekly target - my spreadsheet is full of successes and reminders that it just works this way sometimes. There are clear mathematical explanations for why this week's target was pretty questionable in the first place, and I can see that I'm STILL ahead of schedule.
|