Incremental Volume of a Cone Calculator
Incremental Volume of a Cone Calculator
(OP)
Trying to write a formula in excel that will calculate the incremental volume of a cone inch by inch. The diameter of the top of the cone is 34' and the height is 18.75'. Total volume is 5674.50 cuft but I can't figure out how to write the formula so I can generate the volume as I move down the height of the cone. This is generating the volume of solids in the cone. Maybe it is because it is Monday, but I can't figure this out. Thanks.





RE: Incremental Volume of a Cone Calculator
RE: Incremental Volume of a Cone Calculator
RE: Incremental Volume of a Cone Calculator
RE: Incremental Volume of a Cone Calculator
I don't think you are exactly right. The volume of the cone's frustrum will be slightly larger than your approach predicts, because the volume of a cone is proportional to the cube of the height rather than to the square of the height.
RE: Incremental Volume of a Cone Calculator
A quick bit of algebra suggests that your approach underestimates the frustrum's volume by
pi * (tan(t))^2 * (delta H)^3 / 12
where t is the semi-angle at the cone's apex, and
"delta H" is the thickness of the frustrum.
RE: Incremental Volume of a Cone Calculator
Based on the given volume, base diameter and height, the minor radius is zero, so this is not a frustum, but a true cone.
RE: Incremental Volume of a Cone Calculator