Running Percentage

[Fred Swain]

I am a part of a 12 week biggest loser contest. I am trying to create a
spread sheet that will capture the percentage of weight lost each week by
just entering the current week’s weight.

For example:

A B C D
Name Starting Wt Week 1 WT Week 1 Loss % And so on for 12
weeks.


Is there a formula that would help me out

 

[Jacob Skaria]

The below data is in A114 with headers in Row 1
B2 is your starting weight.
B3 is for 1st week and so on..

C3 =(B2-B3)/100
and copy the formula down (weekly % loss)

D3 =($B$2-B3)/100
and copy the formula down (total % loss)

Format Col C and Col D to % style


Week Num Weight Weekly % Total %
Week0 85.5
Week1 85.3 0.20% 0.20%
Week2 85.1 0.20% 0.40%
Week3 84.9 0.20% 0.60%
Week4 84.7 0.20% 0.80%
Week5 84.5 0.20% 1.00%
Week6 83.0 1.50% 2.50%
Week7 82.5 0.50% 3.00%
Week8 82.0 0.50% 3.50%
Week9 81.5 0.50% 4.00%
Week10 81.0 0.50% 4.50%
Week11 80.5 0.50% 5.00%
Week12 80.0 0.50% 5.50%