Partial Volume of a Cylinder Calculation

[CivCalc]

It's been a long time since I've attended school, over 33 years ago. So my question may seem basic to many here. I wish to calculate the partial volume of a cylinder for my excel spreadsheet project. The formula I've found is attached. (unable to type it)

But I do not fully understand this formula. Particulalry the R sq cos -1 section. Could somebody please explain how I use cos
Thank You

View attachment 7715

 

[MarkFL]

Hello, and welcome to MHB! (Wave)

I don't use Excel, but I imagine it would be something like:

V=L*(R^2*ACOS((R-D)/R)-(R-D)*SQRT(2*R*D-D^2))

 

[CivCalc]

Thanks for response. No doesn't work on excel but that's OK, I'll investigate further

 

[tkhunny]

Thanks for response. No doesn't work on excel but that's OK, I'll investigate further

The Basic Spreadsheet
View attachment 7728
B1:B3 are the desired input values.

The formula in B5
View attachment 7729
I added a few sets of parentheses to emphasize order of operations.

You COULD name the cell ranges and refer to their meanings, rather than the cell addresses.

 

[MarkFL]

Yeah, I figured what I gave was correct. :)