Wednesday, 30 Jul 2008
Adjustments to Google Docs
Some of you know I track my physical results pretty intensively in the documents that are linked on the right of my blog. Today I’ve made a few adjustments to both:
The Physical Activity and Caloric Balance has been adjusted to reflect a few realizations.
- Adjusted the per minute rate for physical activity
- Incorporated BMR calculator
- Reordered the worksheets to flow in order of calculations
I’ve rewritten parts of How I Calculate Calories… FAQ to reflect the calculation changes that I’ve made above and to be more consistent with the logic within the worksheets.
These are pretty substantial changes that affect the way I calculate the caloric balance on a daily basis. Previously I was using “band-aid” remedies to adjust for why I felt I was not losing weight when the spreadsheet specifically said I was calorically negative throughout a whole week. For example, I would decrease the per minute rate for certain physical activities or I would cut the daily caloric needs to reflect my lack of weight loss. With the deduction of BMR from the per minute physical activity rate, these band-aid solutions should no longer necessary and I can stick with the cold hard numbers as generated by the formulae.
My hope is that the model created by the spreadsheets can accurately reflect what I am experiencing on a week-to-week basis with my actual results. If this is effective then I may publish this workbook to the public so that others can use this too.
posted at 2:33pm