MHB Partial Volume of a Cylinder Calculation

AI Thread Summary
The discussion revolves around calculating the partial volume of a cylinder for an Excel spreadsheet project. A user seeks clarification on a specific formula, particularly the R sq cos -1 section, and how to apply the cosine function within it. Another participant suggests a formula format for Excel, emphasizing the importance of parentheses for proper order of operations. Despite attempts, the original poster finds the provided formula does not work in Excel and decides to continue investigating. The conversation highlights the challenges of applying mathematical formulas in spreadsheet software.
CivCalc
Messages
2
Reaction score
0
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
 

Attachments

  • Formula.PNG
    Formula.PNG
    3 KB · Views: 132
Mathematics news on Phys.org
Hello, and welcome to MHB! (Wave)

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

Code:
V=L*(R^2*ACOS((R-D)/R)-(R-D)*SQRT(2*R*D-D^2))
 
Thanks for response. No doesn't work on excel but that's OK, I'll investigate further
 
CivCalc said:
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.
 

Attachments

  • Spreadsheet1.jpg
    Spreadsheet1.jpg
    8.6 KB · Views: 129
  • Spreadsheet2.jpg
    Spreadsheet2.jpg
    5.8 KB · Views: 122
Yeah, I figured what I gave was correct. :)
 
Suppose ,instead of the usual x,y coordinate system with an I basis vector along the x -axis and a corresponding j basis vector along the y-axis we instead have a different pair of basis vectors ,call them e and f along their respective axes. I have seen that this is an important subject in maths My question is what physical applications does such a model apply to? I am asking here because I have devoted quite a lot of time in the past to understanding convectors and the dual...
Insights auto threads is broken atm, so I'm manually creating these for new Insight articles. In Dirac’s Principles of Quantum Mechanics published in 1930 he introduced a “convenient notation” he referred to as a “delta function” which he treated as a continuum analog to the discrete Kronecker delta. The Kronecker delta is simply the indexed components of the identity operator in matrix algebra Source: https://www.physicsforums.com/insights/what-exactly-is-diracs-delta-function/ by...
Back
Top