The “BodyKtor” Spreadsheet

My highest goal with strength training is to maintain a life long good health. So, in the end, I don’t lift weight to get bigger muscle or lose fat.

But, at a lower level, I still want to know what’s going on under the skin

The body composition, or as I call it, the “Body Key Indicators” or BKI, is/are an important element to follow. Excess of bodyfat is related to many health problems and the loss of muscle mass may lead to mobility problems (my favorite fear). With a quick observation of the general population, we can see a natural tendency to gain fat and lose muscle. The mobility problems are then multiplied: too much weight to carry around by an always weaker frame.

As with any aspect of my training, I have tools to measure progress. For example, I log every workout in my training Logbook. For my BKI, I work with the BodyKtor spreadsheet (you can download it for free by clicking the link).

The BodyKtor tool is an Excel spreadsheet containing 2 sheets: the Data sheet and the Chart sheet.

The Data sheet has 6 columns:

  1. Wk#
  2. Date
  3. BW (Body Weight)
  4. Fat % (I use my fat caliper and/or personal scale for this)
  5. FM (Fat Mass=BW * Fat %)
  6. LM (Lean Mass=BW – FM)

The Data sheet has currently 16 rows (filled with sample data) for readings. You can easily add rows, as with any spreadsheet. But if you want to see the added readings in the graph, you will have to modify the Data Range in the Source Data menu item of the graph contextual menu (right click on the graph).

The Chart sheet displays a 2-line graph with dates on the X Axis and weights on the Y Axis. The graph shows the evolution of 2 indicators, Body Weight and Lean Mass, over time.

I invite you to use this spreadsheet on a weekly basis. Feel free to modify it to suit your needs. You can also send me suggestions for improvements, I will post new versions in the future. Thanks.

I wish you all happy Holidays and a wonderful year 2010.

Until next post, Lift Consciously

Leave a Reply