Hi MuskelGrothe. Many thanks for creating this useful tool! I've been trying to apply it to a commissioned piece of artwork, and run into a couple issues for which I have questions.
First, the example spreadsheet entries for the chest appear to use a width greater than the length (75 pixels versus 45 pixels). Your diagram shows chest width as the measurement from collarbone to abdomen, while the chest length is the measurement across from side-to-side, so by the diagram, length should be greater than width. Which is correct, or does it matter?
I messed up on that entry. But since cylindrical volume simplifies to =(1/4)*pi*w*h*d, it doesn't matter which dimension is which, due to the commutative law.
Second, your ratios width/depth for thighs, biceps, and calves don't give guidance for a normal, non-muscular woman. I tend to use the ratios closest to 1 in that case.
For volume, I think it the ratios are a little less important, especially for longer bones (limbs).
Third, the weight sheet contains an input for Target weight in pounds. Isn't that what we're trying to calculate? So what purpose does that serve? For now I've been putting in something that approximates 0.036 lb/in^3, erring on the low side for less muscular women and on the high side for more muscular women.
Target weight doesn't affect the computed weight at all. I just included it to help adjust the formula if needed. The idea was to compare a known weight of an individual with the computed result. The constant PoundsPerCubicInch and PPCIDev (PoundsPerCubicInch random deviation range) are used with the volume, calculated skeleton weight, and constant adult head weight to get the result. If you want to change the PoundsPerCubicInch or PPCIDev values, just type them in on the constant page. I got PoundsPerCubicInch by averaging out a sample set, and PPCIDev was the standard deviation of that set.
Also, I've put in a row for elliptical circumference using Ramanujan's approximation, which is
pi*[3(a+b) - sqrt((3a+b)(a+3b))]
where a and b are the major and minor radii. This seems to work out pretty well. An example formula is
=PI*(1.5*(C8+C9)-0.5*SQRT((3*C8+C9)*(3*C9+C8)))*$B18/$B17
which gives a circumference in inches.
I'll put a circumference measurement on the spreadsheet soon. Biceps, Forearms, Thighs, Calves, Waist, and Chest should be on it.
