??Volume Calculator??
Posted by Timothy on October 24, 2001 11:14 AM
Can I use Excel 2000 to calculate volume(cm^3)of a hollow cylinder using the known OD, ID, and Height in millimeters?
Posted by Tom Urtis on October 24, 2001 11:25 AM
Cylinder volume
Let's see, if my memory in geometry is correct, to arrive at the volume of a cylinder, you would need to take the square root of the base's radius, multiply it by Pi, and then multiply that by the height of the cylinder. Let's say you have the radius in cell A1, and the height in cell A2. In A3, you could enter the formula:
=(PI()*(A1^2)*A2).
Posted by Tom Urtis on October 24, 2001 11:28 AM
Semi-correction
I said in the narrative that you would need to take the square root of the radius...that is incorrect...you would need to take the square...but the formula I believe is correct as I posted it.
HTH
Tom Urtis
Posted by Mark W. on October 24, 2001 11:29 AM
What's OD and ID? Outer diameter and inner diameter? Can I use Excel 2000 to calculate volume(cm^3)of a hollow cylinder using the known OD, ID, and Height in millimeters?
Posted by Aladin Akyurek on October 24, 2001 11:48 AM
According to http://thesaurus.maths.org/dictionary/map/word/2661,
a (right circular) clindir has volume:
pi*radius-squared*height
so this gives in Excel:
=PI()*A1^2*A2
where A1 houses the radius and A2 the height.
Right?
Posted by Aladin Akyurek on October 24, 2001 11:53 AM
Re: Semi-correction
Hope you're right, Tom. That would mean I somehow managed to pick up the right formula from the Web.
Aladin
Posted by Juan Pablo on October 24, 2001 12:24 PM
Isn't it a hollow cyilinder ?
Meaning... you have to have to substract one from the other ??
OD in A1, ID in A2 and Height in A3
=PI()*((A1/2)^2-(A2/2)^2)*A3
?
Juan Pablo Can I use Excel 2000 to calculate volume(cm^3)of a hollow cylinder using the known OD, ID, and Height in millimeters?
Posted by Mark W. on October 24, 2001 1:42 PM
Yes, but...
...does Timothy want the volume of material from
which the cylinder is constructed or the volume
of material that the cylinder can contain? The
answer would be more obvious to me if he would
confirm the meaning of OD and ID. Meaning... you have to have to substract one from the other ?? OD in A1, ID in A2 and Height in A3
Posted by Qroozn on October 24, 2001 3:12 PM
Re: Yes, but...
I was looking to see if someone else worked out that bit!
volume is pi*radius*readius*height = pir*r^2*h
where r=diameter/2
OD it outside diameter and, ID intenal diameter.
One question. the top and bottom of the cylinder.... what is the depth of the material used as this will also impact the volume.
