Need Help, this is driving me nuts

[heitorfjr]

OK, I'm not a math or computer person but my wife is something like tha
and she can't do it (I guess she is not that great, this seems to b
simple enough). Basically I was trying to use an excell spreadsheet t
keep my fitness progress and I found something on the internet, but th
problem is that it's very limited from what I want, which in turn i
much simpler than the template I found.

I started working out and just wanted to keep track of my bod
measurements (chest, biceps, etc) and this template does it, excep
that it measures the difference as negative. Example: Today my righ
biceps measures 12 inches and next week it measures 13, the differenc
should be +1. This template calculates as a negative so the resul
would be -1 instead. Other than that the spreadsheet is perfect.

Also can I add more rows for body parts that are not listed and delet
other functions I don't care for like the total or bmi at the botton o
the template?

This is the spreadsheet:

http://office.microsoft.com/en-us/templates/TC011684031033.aspx?CategoryID=CT010482871033


Thank

 

[Bob Phillips]

That is because it is showing loss, and a gain is a negative loss. Just
change it around, change E8 to say Month gain, then change the formula in E8
to
=OFFSET(E8,0,-1)-OFFSET(E8,0,-2)

the formula in F8 to

=OFFSET($F8,0,-2)-$C8

and copy both cells down to row 15

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[heitorfjr]

Thank you very much, you people are geniuses.

Now I'm trying to save the spreadsheet on my computer but when I try t
open it, it freezes the computer. Why is that happening? Could be th
macro