Forum Discussion
Weight loss in lbs. and body fat %
serene06 In the attached I expanded the file/table to include ID and week and formatted as a table to use structured references. The formulas find the value for the row with the same ID AND says "start" under the Week and subtract from there. I do this all under 1 table as it does make a number of things easier (i.e. any kind of group metrics like my clients lost a total of or average of ...).
i also added another tab to help you pull ONLY a single person's info. I used a pivot table but you could also use the FILTER() functions.
serene06 alternatively I would suggest you redo your sheet into columns.
| Date | Weight (lbs) | Body Fat(%) | Weight Loss | Body Fat% Change | Current Weight Loss: | -2.7 | (negative means weight gain) | |
| start | 166.4 | 35.1 | 0 | 0 | Current Body Fat % decrease: | 3 | (negative means body fat gain) | |
| W2 | 168.8 | 31.3 | -2.4 | 3.8 | ||||
| W4 | 169.1 | 32.1 | -2.7 | 3 |
The attached is prettier but basically this will let you 'track' your weight better. If you use actual dates in that 1st column you could track avg weight loss / day. If you want you can easily make a graph of either your weight over time or your weight loss/change over time (or body fat %).
Thanks for your response. This was helpful.
Thus, I am tracking several individual weights and body fat %s. What is the best way to capture this in Excel. In addition, how do I copy the formula for each individual?
serene06 In the attached I expanded the file/table to include ID and week and formatted as a table to use structured references. The formulas find the value for the row with the same ID AND says "start" under the Week and subtract from there. I do this all under 1 table as it does make a number of things easier (i.e. any kind of group metrics like my clients lost a total of or average of ...).
i also added another tab to help you pull ONLY a single person's info. I used a pivot table but you could also use the FILTER() functions.
- Thanks for your help!