Hey folks:

Here is an updated version of the bodyfat % calculator in Excel. This spreadsheet was upgraded to reset all the fields to zeros. Now no matter how the spreadsheet is closed (i.e. save the values, don't save the values, whatever) it will start up with zeros in the measurement fields. Just agree to enable the macro when the spreadsheet opens.

It's attached here.

Hey folks:

Here is an updated version of the bodyfat % calculator in Excel. This spreadsheet was upgraded to reset all the fields to zeros. Now no matter how the spreadsheet is closed (i.e. save the values, don't save the values, whatever) it will start up with zeros in the measurement fields. Just agree to enable the macro when the spreadsheet opens.

It's attached here.

Thanks Lefty. I don't know why I forgot about it. I already had it downloaded and everything. :doh:

Thanks a bunch for this. Least gives me an Idea where I am at, even though that is bad hehe.

What units are the measurements to be in (inches, cm, mm)? weight is in lbs or kg?

What units are the measurements to be in (inches, cm, mm)? weight is in lbs or kg?

Since I'm an american, and I live in America, I use american measures. :D Inches and pounds.

Oh, and don't use the measurements under my avatar to test my personal bf% because wehre the spreadsheet says waist, I use the measurement for the abdomen, which is what the calculation considers the waist.

This seems good, but I'm getting WEIRD results... could you give a bit more details on the fields?

This seems good, but I'm getting WEIRD results... could you give a bit more details on the fields?

Could you be a bit more specific? Which fields are you having trouble with? What do you mean by weird results? I'll be glad to help you with this simple method, if you tell me what the problem is.

Hey Jordan. This thing still works a treat. I managed to get Open Office on my Macbook to open the Excel file.

Am I correct in saying:

Waist = Abdomen (naval)
Hips = Widest around your butt
Forearm = untensed widest
Wrist = well thats obvious.

Excellent calculator. It gave me 10.75 which is close to what I think may be the truth.

It puts me at 17.4% which isn't far off either I reckon:)

Can someone answer some questions for me? For Bicep and Forearm measurements, should they be flexed or not? I remember seeing one site saying they should be flexed. Also, wow important are the following measurements?:
- Shoulders (Do you measure in front?)
- Pant Line (How is this measured?)
- Thigh (Just one leg?)
- Calf (Just one?)

It puts me at 17.4% which isn't far off either I reckon:)

The rate of error is about +-2% points. Consistent measuring will give a trend.

BTW Jedi, I like your avatar. Are you implying you have chicken legs? :lol:

The rate of error is about +-2% points. Consistent measuring will give a trend.

BTW Jedi, I like your avatar. Are you implying you have chicken legs? :lol:

quite the contrary :lol: in fact all my excess fat is in my legs....(and quite a bit of muscle) but a while back in M@'s journal I was discussing the merits of having a hen in an urban garden ;)

Hey Jordan. This thing still works a treat. I managed to get Open Office on my Macbook to open the Excel file.

Am I correct in saying:

Waist = Abdomen (naval)
Hips = Widest around your butt
Forearm = untensed widest
Wrist = well thats obvious.

Excellent calculator. It gave me 10.75 which is close to what I think may be the truth.

Those are accurate statements David. Although I tense my forearm. Either way, this method is mostly reliable when detecting a trend. As long as you keep your measurements consistent there should be a +-2% point variance from your actual bodyfat percentage.

Also, I learned here on the forums that the forearm and wrist measurements really shouldn't change and give the stability to the measure that the other two measurements revolve around. I think that's the theory, but I'm not sure I remember.

Can someone answer some questions for me? For Bicep and Forearm measurements, should they be flexed or not? I remember seeing one site saying they should be flexed. Also, wow important are the following measurements?:
- Shoulders (Do you measure in front?)
- Pant Line (How is this measured?)
- Thigh (Just one leg?)
- Calf (Just one?)

I don't see how some of these figure into the bodyfat % calculator but I"ll answer as best I can.

I do bicep and forearm tensed. Either way it's a +-2% variance from actual bodyfat %.

Shoulders I don't know how to measure accurately by yourself so I don't measure them. Pant line also I don't measure. Thigh is just one leg approximately 2 inches below the top. Calf is also just one.

I don't see how some of these figure into the bodyfat % calculator but I"ll answer as best I can.

I do bicep and forearm tensed. Either way it's a +-2% variance from actual bodyfat %.

Shoulders I don't know how to measure accurately by yourself so I don't measure them. Pant line also I don't measure. Thigh is just one leg approximately 2 inches below the top. Calf is also just one.

Thank you!

I don't think that's correct with the forearm. I was under the impression you were supposed to measure your forearm in the middle of the arm, NOT the widest part (which would be near your elbow, or at least it is for me).

I say this for two reasons: (1) A video on bodybuilding.com that showed where to make measurements said to do it in the middle of the forearm. (2) If I measure it in the middle, I get more consistent results with two other measurement techniques that DON'T do a forearm measurement ... otherwise I get a bf% that's consistently ~2-3% lower than the others.

(Note that I actually have 5 formulas that I use, one of them I know is wrong because it's based on BMR only; the other is the one the military supposedly uses and consistently gives me ~2% higher than the other three.)