I have no excel skills. Can you maybe just email or upload the one you have so i can just dload it? :d
Here’s the setup with row and column names so you can modify as per your sheet. Pretty simple just adjust cell references for your sheet. You can do it!
1 Like
I have the same excel sheet and use it for diets (but with only 4 methods). One is the caliper method in my table 
I always had the feeling we have some craziness in common when it comes to this stuff
1 Like
Brother from another Mother and Father. Nice to meet you!
As my spouse and I lament, you can’t teach insanity.
1 Like
so i tried coppying it into the same cells and now this happens… anyways, nevermind, i have no idea what to do with excel, i have never used it nor have i used any program in the office, and i really suck with technology…
imma just stick to the waist-height thingy 
1 Like
You made some type of typing error in your formula. Check for mistakes, oftentimes you something there that doesn’t belong in a mathematical equation.
I prob have some time to make this spreadsheet today. If I do I will email the the .xls file to you.
2 Likes
@hankthetank89 I made the spreadsheet. If you email me I will send you the file.
Mine for example and seems about right to me. If you put a gun to my head and said tell me your BF I would tell you 14% before using this calculator.
2 Likes
Looking good man. You can see that Marine “tape” method is really far off from the other 4. A quick outlier Q-test would lead me to throw that one out vs the others that agree pretty well. Then the mean would be 14.6% and SD is 1.1%. That’s about as tight as you can ask for with these empirical methods. I’m sure @Andrewgen_Receptors would be interested in this example given his previous experiences.
I think the methods that incorporate waist, weight, height or combination thereof tend to be most accurate but I’d have to go back and look at the training sets.
Thanks for playing and helping @hankthetank89 !
3 Likes
I was thinking the same thing
1 Like
One of the most accurate calculations out there for Relative Fat Mass (RFM) was developed by Cedars-Sinai (verified for accuracy against DEXA/BodPod)
First, measure your height in centimeters. Next, measure your waist circumference, placing the tape measure at the top of the hip bone. Then plug the numbers into one of the following sex-specific equations:
- Men: 64 – (20 x height/waist circumference) = RFM
- Women: 76 – (20 x height/waist circumference) = RFM
Still, probably going to be inaccurate as fuck for us lifting homies though
Looks like they claim it’s better than BMI.
https://www.nature.com/articles/s41598-018-29362-1
A quick look at RMSE shows it would be on par with equations I shared above. Perhaps someone can add to the spreadsheet and test it out. Thanks for sharing.
In conclusion, all of this points back to height-to-waist ratio being a very nice yardstick. Thanks!
1 Like
BTW, never heard back from your on the fT question you had. Did the post I share help?
1 Like
Dude, you’ve been posting like a madman so I probably missed it lol. Work and school have been crazy lately too so that probably didn’t help. I’ll go digging for it
Dude, good luck with the studies man! Aim high!
1 Like
I sent you an email
Appreciated! I was about 80 credits deep into a BS in Project Management with an AS in Engineering, then yeeted over to DeVry for a BS in Computer Information Systems with an AS in Information Technology and Cert in Programming.
I like making my life difficult apparently.
Do you remember which thread the fT question was on? having trouble finding it
1 Like
For your study break:
1 Like