# calculating volume

Simon Desarte
Guest
Posts: n/a

 22nd Oct 2003
I am getting very frustrated with trying to put the formula for
calculating the volume of a solid cone and was wondering if anyone can
help me.

I can do it on paper but can't seem to get it to work in excel!
I have installed the analylis tool pack to give me all the SQRT
functions etc

I do have one criteria that is constant and that is the height of the
cone shape which will always be 10cm.

So I would like to enter the first circumference in cell A1 and then
the second circumference in cell B1 and get the answer in C1 (allowing
for the height to always be 10cm).

I.E. circ1= 25cm circ2= 30cm height = 10cm

Any help would be most appreciated

Kind regards

Simon

Kevin Stecyk
Guest
Posts: n/a

 22nd Oct 2003
Simon,

This looks a lot like a homework problem. Unfortunately, we don't do
homework.

But I will give you some hints:

The volume of a cone is 1/3(Area of Base)(height) = 1/3(pi r2)(height).

You are going to need to transform circumference to radius. (pi * 2 * r =
circ)

You are going to need to determine the heights of your cones. You know the
two radii and you know the distance between, so thus you know the cone
heights. You have one large cone less a smaller cone. In other words, you
need to calculate the volume of a cone as though it were not cut off
prematurely. That will be the large volume. And then you need to calculate
the volume of the portion that was cut off.

And then you can solve your question.

<<I can do it on paper but can't seem to get it to work in excel!>>

If you can do it on paper, you can do it Excel. Just put the same formulas
in place.

Good luck!

Kevin

"Simon Desarte" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I am getting very frustrated with trying to put the formula for
> calculating the volume of a solid cone and was wondering if anyone can
> help me.
>
> I can do it on paper but can't seem to get it to work in excel!
> I have installed the analylis tool pack to give me all the SQRT
> functions etc
>
> I do have one criteria that is constant and that is the height of the
> cone shape which will always be 10cm.
>
> So I would like to enter the first circumference in cell A1 and then
> the second circumference in cell B1 and get the answer in C1 (allowing
> for the height to always be 10cm).
>
> I.E. circ1= 25cm circ2= 30cm height = 10cm
>
> Any help would be most appreciated
>
> Kind regards
>
> Simon

Simon Desarte
Guest
Posts: n/a

 22nd Oct 2003
Thanks for your posting Kevin, If I give you a bit of background into
what I am trying to do it might make people realise it is not
homework.

I need to calculate the volume of peoples legs before and after
vigorous exercise (strange but true). I don't need it to be totally
accurate so a cut of cone formula is perfect.

I have uploaded my paper calculations here
http://simon_desarte.tripod.com/cone.gif

I want to put the bottom formula into excel but I can't seem to make
it work!

I can't seem to make any formula work in excel even =1/3(pi()
"height" for a number.

It comes back telling me that I have typed it in wrong.

Please can someone help me it is driving me crazy I admit to never
using excel before but I need to do the calculations on a computer.

Simon

"Kevin Stecyk" <(E-Mail Removed)> wrote in message news:<#StrG\$(E-Mail Removed)>...
> Simon,
>
> This looks a lot like a homework problem. Unfortunately, we don't do
> homework.
>
> But I will give you some hints:
>
> The volume of a cone is 1/3(Area of Base)(height) = 1/3(pi r2)(height).
>
> You are going to need to transform circumference to radius. (pi * 2 * r =
> circ)
>
> You are going to need to determine the heights of your cones. You know the
> two radii and you know the distance between, so thus you know the cone
> heights. You have one large cone less a smaller cone. In other words, you
> need to calculate the volume of a cone as though it were not cut off
> prematurely. That will be the large volume. And then you need to calculate
> the volume of the portion that was cut off.
>
> And then you can solve your question.
>
> <<I can do it on paper but can't seem to get it to work in excel!>>
>
> If you can do it on paper, you can do it Excel. Just put the same formulas
> in place.
>
> Good luck!
>
> Kevin
>
>
>
>
> "Simon Desarte" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > I am getting very frustrated with trying to put the formula for
> > calculating the volume of a solid cone and was wondering if anyone can
> > help me.
> >
> > I can do it on paper but can't seem to get it to work in excel!
> > I have installed the analylis tool pack to give me all the SQRT
> > functions etc
> >
> > I do have one criteria that is constant and that is the height of the
> > cone shape which will always be 10cm.
> >
> > So I would like to enter the first circumference in cell A1 and then
> > the second circumference in cell B1 and get the answer in C1 (allowing
> > for the height to always be 10cm).
> >
> > I.E. circ1= 25cm circ2= 30cm height = 10cm
> >
> > Any help would be most appreciated
> >
> > Kind regards
> >
> > Simon

Andy B
Guest
Posts: n/a

 22nd Oct 2003
Simon

I have set up the formula you have described and it works OK. I've used:

=25/PI()/2*10/3

This is just a long-hand version of what you require (for the 25cm cone).

Andy.

"Simon Desarte" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Thanks for your posting Kevin, If I give you a bit of background into
> what I am trying to do it might make people realise it is not
> homework.
>
> I need to calculate the volume of peoples legs before and after
> vigorous exercise (strange but true). I don't need it to be totally
> accurate so a cut of cone formula is perfect.
>
> I have uploaded my paper calculations here
> http://simon_desarte.tripod.com/cone.gif
>
> I want to put the bottom formula into excel but I can't seem to make
> it work!
>
> I can't seem to make any formula work in excel even =1/3(pi()
> "height" for a number.
>
> It comes back telling me that I have typed it in wrong.
>
> Please can someone help me it is driving me crazy I admit to never
> using excel before but I need to do the calculations on a computer.
>
>
> Simon
>
>
> "Kevin Stecyk" <(E-Mail Removed)> wrote in message

news:<#StrG\$(E-Mail Removed)>...
> > Simon,
> >
> > This looks a lot like a homework problem. Unfortunately, we don't do
> > homework.
> >
> > But I will give you some hints:
> >
> > The volume of a cone is 1/3(Area of Base)(height) = 1/3(pi r2)(height).
> >
> > You are going to need to transform circumference to radius. (pi * 2 * r

=
> > circ)
> >
> > You are going to need to determine the heights of your cones. You know

the
> > two radii and you know the distance between, so thus you know the cone
> > heights. You have one large cone less a smaller cone. In other words,

you
> > need to calculate the volume of a cone as though it were not cut off
> > prematurely. That will be the large volume. And then you need to

calculate
> > the volume of the portion that was cut off.
> >
> > And then you can solve your question.
> >
> > <<I can do it on paper but can't seem to get it to work in excel!>>
> >
> > If you can do it on paper, you can do it Excel. Just put the same

formulas
> > in place.
> >
> > Good luck!
> >
> > Kevin
> >
> >
> >
> >
> > "Simon Desarte" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > > I am getting very frustrated with trying to put the formula for
> > > calculating the volume of a solid cone and was wondering if anyone can
> > > help me.
> > >
> > > I can do it on paper but can't seem to get it to work in excel!
> > > I have installed the analylis tool pack to give me all the SQRT
> > > functions etc
> > >
> > > I do have one criteria that is constant and that is the height of the
> > > cone shape which will always be 10cm.
> > >
> > > So I would like to enter the first circumference in cell A1 and then
> > > the second circumference in cell B1 and get the answer in C1 (allowing
> > > for the height to always be 10cm).
> > >
> > > I.E. circ1= 25cm circ2= 30cm height = 10cm
> > >
> > > Any help would be most appreciated
> > >
> > > Kind regards
> > >
> > > Simon

Kevin Stecyk
Guest
Posts: n/a

 22nd Oct 2003
Simon,

I will send you a spreadsheet with the math already figured out.

Regards,
Kevin

"Simon Desarte" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Thanks for your posting Kevin, If I give you a bit of background into
> what I am trying to do it might make people realise it is not
> homework.
>
> I need to calculate the volume of peoples legs before and after
> vigorous exercise (strange but true). I don't need it to be totally
> accurate so a cut of cone formula is perfect.
>
> I have uploaded my paper calculations here
> http://simon_desarte.tripod.com/cone.gif
>
> I want to put the bottom formula into excel but I can't seem to make
> it work!
>
> I can't seem to make any formula work in excel even =1/3(pi()
> "height" for a number.
>
> It comes back telling me that I have typed it in wrong.
>
> Please can someone help me it is driving me crazy I admit to never
> using excel before but I need to do the calculations on a computer.
>
>
> Simon
>
>
> "Kevin Stecyk" <(E-Mail Removed)> wrote in message

news:<#StrG\$(E-Mail Removed)>...
> > Simon,
> >
> > This looks a lot like a homework problem. Unfortunately, we don't do
> > homework.
> >
> > But I will give you some hints:
> >
> > The volume of a cone is 1/3(Area of Base)(height) = 1/3(pi r2)(height).
> >
> > You are going to need to transform circumference to radius. (pi * 2 * r

=
> > circ)
> >
> > You are going to need to determine the heights of your cones. You know

the
> > two radii and you know the distance between, so thus you know the cone
> > heights. You have one large cone less a smaller cone. In other words,

you
> > need to calculate the volume of a cone as though it were not cut off
> > prematurely. That will be the large volume. And then you need to

calculate
> > the volume of the portion that was cut off.
> >
> > And then you can solve your question.
> >
> > <<I can do it on paper but can't seem to get it to work in excel!>>
> >
> > If you can do it on paper, you can do it Excel. Just put the same

formulas
> > in place.
> >
> > Good luck!
> >
> > Kevin
> >
> >
> >
> >
> > "Simon Desarte" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > > I am getting very frustrated with trying to put the formula for
> > > calculating the volume of a solid cone and was wondering if anyone can
> > > help me.
> > >
> > > I can do it on paper but can't seem to get it to work in excel!
> > > I have installed the analylis tool pack to give me all the SQRT
> > > functions etc
> > >
> > > I do have one criteria that is constant and that is the height of the
> > > cone shape which will always be 10cm.
> > >
> > > So I would like to enter the first circumference in cell A1 and then
> > > the second circumference in cell B1 and get the answer in C1 (allowing
> > > for the height to always be 10cm).
> > >
> > > I.E. circ1= 25cm circ2= 30cm height = 10cm
> > >
> > > Any help would be most appreciated
> > >
> > > Kind regards
> > >
> > > Simon

tansikamalar@gmail.com
Guest
Posts: n/a

 17th Aug 2012
Cone is a three dimensional shape that has a single elliptical or circular base and an apex.
Volume of cone formula is explained in http://www.easycalculation.com/maths...nary/cone.html.

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post =?Utf-8?B?RWxib3dlcw==?= Microsoft Excel Worksheet Functions 2 8th Jun 2007 02:48 PM =?Utf-8?B?S2VuIEQu?= Microsoft Access Queries 1 14th Apr 2006 02:44 PM Jim Smith Microsoft Excel Worksheet Functions 0 17th Feb 2006 08:48 PM Walterius Microsoft Excel Worksheet Functions 6 4th Jun 2005 11:21 PM RICHARD Microsoft Excel Programming 0 15th Mar 2005 02:41 PM

Features

Newsgroups

All times are GMT +1. The time now is 09:13 PM.