Wednesday, July 25, 2012

Weight tracking/exercise spreadsheet+

We started a protein diet with Mana a couple weeks ago and over the time I put together a spreadsheet to track your weight + fat/water/muscle percentages. The setup is simple, you just enter your height in cm. Then just enter a date of measurement together with the measured values and it gives you your current BMI. In addition to that for each of the measured values you get:

  • total difference between the first value (when you started tracking) and the current value - good for motivation ;-)
  • you can specify a target value for any of the measured variables and the spreadsheet calculates an estimated date when you reach your target (linearly considering the progress so far)
  • nice charts!
Here is a link to the spreadsheet with some sample values - just create your own copy and good luck!
https://docs.google.com/spreadsheet/ccc?key=0AnJ2BfrzQpQGdFRkcDB6XzVCLVU5RlpWZ2hoSEhvcGc