Anniversary of your join date…. That or Tnation is calling you a fat cake eater…. 
3 Likes
It puts me at 17.2 % which I also think is pretty accurate.
There’s the army method of measuring waist and neck which I found to be accurate too. If my memory is right, the studies also show this. What do you think @tareload ?
There are some people who made tape in the marines while having a beer belly and fatass neck. Then there was me who barely made weight or tape while having a 6 pack.
Here’s two time points with the various formulas and compared with various “direct measurement” techniques. Decent agreement and I like the tight SD (and I like bracketing what the formulas give). The formula labeled Dave Draper is “modified YMCA” formula. When you get that low BF it’s all how you look anyway. Obviously your mileage may vary given your metrics.
Here’s the formulas for you obsessive folks:
Cell D16 is the mean BF from all the formula results (cells D10:D14).
Hope all this detail gives someone who’s really interested an assist. But at the end of the day the waist-to-height ratio is such a simple shortcut.
1 Like
Pretty cool. Can you upload to a Google sheet with formula? Or at least paste formula as text to copy paste
| Calculator | |||
|---|---|---|---|
| waist | 34 | in | |
| neck | 17.5 | in | |
| height | 77 | in | |
| weight | 240 | lb | |
| LBM | =weight * (1-D16) | lb | |
| FAT | =weight * D16 | lb | |
| Navy Method | =(86.01 * LOG10(waist - neck) - 70.041 * LOG10(height) + 36.76) / 100 | ----> | waist, neck, height |
| Dave Draper | =(weight - (weight * 1.082 + 94.42 - waist * 4.15)) * 100 / weight / 100 | ----> | weight, waist |
| YMCA | =(-98.42 + 4.15 * waist - 0.082 * weight) / weight | ----> | weight, waist |
| Army | =(46.892 - (68.678 * LOG10(height)) + (76.462 * LOG10(waist-neck))) / 100 | ----> | waist, neck, height |
| Marine | =(0.74 * (waist * 2.54) - 1.2949 * (neck * 2.54) + 0.528) / 100 | ----> | waist, neck |
| mean | =AVERAGE(D10:D14) | ||
| SD | =STDEV(D10:D14) |
Excel based formulas with some named cells
3 Likes
11.9 and 6.6 - very huge difference in outcomes… so we should probably stick to ones that give an average between these?
Like I said, take the mean of all formulas and report mean with SD. Very simple to port to spreadsheet.
Sorry, i really dont understand what you are saying(english… like i just cant get the idea of this sentence).
edit - mean is like “being mean” and a port is where ships arrive, no? 
Formulas are set up for english units…pounds and inches. Sorry. Take care with the formulas and I’ve shared the formulas in excel to calculate using each of the 5 methods then at the bottom your can take the average (actually the mean) and also calculate the standard deviation if you have access to Microsoft Excel. Otherwise you could use whatever program you want.
ah so this one is the average between all the formulas, yes?
this is like - the difference between highest and lowest values?
Yes, mathematical mean.
In statistics, the standard deviation is a measure of the amount of variation or dispersion of a set of values
Gives you a sense of the spread between the 5 estimates.
one more idiotic question - how do i get it to work in excel? just copy in it?
Yes, I’ve gone to the trouble on writing out the equations in table above so you can just paste them into Excel and make sure you get the cell references correct. I’ve confirmed the equations as written in the table will paste into Excel and work properly.
the way the equations are written I have used named cells as I mentioned above:
Excel based formulas with some named cells
So for instance, your cell B1, you have to name that “waist”.
Cell B2, name that neck. Etc.
All the way down to “weight” reference.
Then make sure the mean and SD formulas are pointing to the correct cells.
Happy BDay.
i did that, now it says LBM is 240, fat = 0…
i am totally retarded, sorry
The LBM equation must be modified to point to the correct equation for Mean bodyfat. Go make sure your “mean” and “SD” formulas are working then point LBM and FAT to the appropriate cell for “mean” instead of “D16”.
mean equation should be AVERAGE(B7:B11) for you. Etc, etc.