All;
I shall soon be posting an updated version (not massively different from the previous version, but a few of the tweaks requested are in there). Changes will include:
I am sure there are other tweaks, but I can't remember them now!!
- Ability to enter your target Body Fat %age (healthy is ~15% for males, and ~22% for women). The sheet will then calculate an "estimated" weight at which your Body Fat %age will hit that target.
- It has an editable area where you can define the "steps" of the diet you are following. It will be setup to the Cambridge steps, but they will be editable so someone following a different diet can change.
- The Body Fat %age calculation is corrected.
- The graphs all show a "target" line, and that is calculated based on the setup figures you enter, so your graph line slowly approached the "target" line as you lose weight - yet another visual spur-on.
I am just trying to fix the annoying habit of the graphs to just drop off to zero when you have no more data. I have got the Measurements chart to behave itself, but I can't remember what I did so I can't fix the other graphs! Doh!
Steve
Here we go Claire - just fill in the yellow boxes as you go. It does the rest.
When you get past 30 weeks, just cut-n-insert the last row of figures into the block (right click the last line (e.g. 42), Copy, and then right click the following line (e.g. 43) and Insert Copied Cells). The graph automagically adjusts itself.
Could you please tell me how to get the spreadsheet?