(15-09-2010, 09:49 AM)marathondan Wrote: Then again EG, your method for tracking weight is also mightily impressive. I thought about explaining it to my wife once, but I felt that her regard for me as a human being might decline slightly if I did. If you have embedded a VBA macro for performing that little averaging routine, I may explode with excitement.
I'm actually in greatly slimmed-down weight-tracking mode at present. Usually, I used to log weekly and monthly averages. Weekly means weighing myself every day, removing the highest and lowest figure, then calculating the average of the remaining 5 days. I then examine the trends on a graph. In fact, I should reinstate this system. It's done with functions, though I do have secret VBA-driven buttons to move me around the sheet.
The trouble with being a number slut is that enthusiasm for the pastime is high when I'm losing weight, or doing plenty of exercise, but tends to tail off when I enter a fat, lazy period.