Would one of you scholars care to lead us through the derivation of this formula? I have gone through the formula for a cylinder partial volume, which is quite easy and straightforward. I guess if I take the time I may be able to do the same for a sphere. But I am much slower now, so I rely on code.
Just a note; if you find you want to know various geometry of a cylinder you can find same at my website. And, for a sphere, you can choose spherical heads with a 0 length cylinder. The various dimensions are calculated through a library, easy to access, and cannot be easily tampered with. You can do the same and still use your favorite spreadsheet tools. Don't stop learning when you master spreadsheet formulas. They are nasty to deal with, impossible to validate, and unrecoganizable after 2 months.
Bobby
Edited by Bobby Strain, 12 December 2015 - 10:31 PM.