Determine distance to Centre of Gravity of shape from 2 intersecting circles
Determine distance to Centre of Gravity of shape from 2 intersecting circles
(OP)
Hello. How can I determine the X distance to the centre of gravity of the area within the red arcs? See attachment. I need formula(e) to put in an excel spreadsheet.
Conditions:
Circles have different radii.
Centre of bigger circle is (0,0).
The included angle will always be less than 180 degrees.
Centres of both circles lie on the X axis.
Any suggestions would be much appreciated.
Thank you
Judge.
Conditions:
Circles have different radii.
Centre of bigger circle is (0,0).
The included angle will always be less than 180 degrees.
Centres of both circles lie on the X axis.
Any suggestions would be much appreciated.
Thank you
Judge.
RE: Determine distance to Centre of Gravity of shape from 2 intersecting circles
RE: Determine distance to Centre of Gravity of shape from 2 intersecting circles
(2) Note also that all four component shapes share a common axis of symmetry.
(3) Apply the parallel axis theorem multiple times, guided by the above "equation".
RE: Determine distance to Centre of Gravity of shape from 2 intersecting circles
RE: Determine distance to Centre of Gravity of shape from 2 intersecting circles
RE: Determine distance to Centre of Gravity of shape from 2 intersecting circles
I took the segment area and centroid equations from my Section Properties spreadsheet, which you can download from:
https://newtonexcelbach.wordpress.com/2014/11/02/s...
If you are using Excel 2013 I have just discovered that Microsoft have messed up the drawing function (again) by reverting to the conventions they used in 2003, so the link below might work better for the graphics:
http://interactiveds.com.au/software/Section%20Pro...
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Determine distance to Centre of Gravity of shape from 2 intersecting circles
I'm sure there must be a use for that somewhere.
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Determine distance to Centre of Gravity of shape from 2 intersecting circles
Defining d as the distance of the two center points, A1 as the area of the segment in the larger circle, A2 as the area of the segment in the smaller circle, xG=A2d/(A2-A1)
where, of course: A1=R2(α-sinαcosα), A2=r2(β-sinβcosβ), cosβ=(R2-r2-d2)/2dr, sinα=(r/R)sinβ
prex
http://www.xcalcs.com : Online engineering calculations
http://www.megamag.it : Magnetic brakes and launchers for fun rides
http://www.levitans.com : Air bearing pads
RE: Determine distance to Centre of Gravity of shape from 2 intersecting circles
Forget that bit, I must have been using an old version.
The attached spreadsheet allows groups of shapes to be combined, which allows the centroid calculation to be done automatically:
1. Calculate the angle from the arc centres to the top of the common chord for the two circles (Theta).
2. On the DefShapes sheet of the attached spreadsheet select Circular Segment and enter the R and Theta for the smaller circle.
3. Scroll down and in the Group properties table enter the X offset for the smaller circle, and set Elastic Modulus to 1. All other columns are zero, and the other rows should be blank. Click the Create New Group Button.
4. Go back to the main table and enter the R and Theta for the larger circle.
5. In the Group properties table set the offset to zero and Elastic Modulus to -1 and click the Add shapes to group button.
6. The Group properties results updates, showing the same centroid value (Xc) as calculated by the other spreadsheet.
7. The resulting shape can be plotted on the Coords_Group sheet. The group properties calculated on that sheet are not exact because they are based on curves made up of short straight lines (but it's pretty close).
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Determine distance to Centre of Gravity of shape from 2 intersecting circles
Yes that works.
I got: X' = (A2.Xc' - A1.Xc1)/(A2 - A1)
where Xc' = Xc2 - d
but A2.Xc2 = A1.Xc1 so A2.Xc' - A1.Xc1 = A2d
which is pretty cool.
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Determine distance to Centre of Gravity of shape from 2 intersecting circles
RE: Determine distance to Centre of Gravity of shape from 2 intersecting circles
It seems you each had the pivotal insight that, in Doug's words, "the two overlapping segments always have exactly the same first moment of area about their own arc centres". It is this insight that leads to Prex's comment that "the answer turns out to be quite simple". Great work, leading to a very elegant result. I was expecting reams of algebra, so didn't have the guts to wade in.
RE: Determine distance to Centre of Gravity of shape from 2 intersecting circles
I have now uploaded a revised version using Prex's simplified formula.
Also I did a search for centroid of a lune and found some Fortran code which claims to do that but actually returns the centroid of a circle segment!
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Determine distance to Centre of Gravity of shape from 2 intersecting circles
RobyEngIT.
Your formulae worked perfectly. To confirm the results, I drew a constrained sketch in NX. Tried a range of values, & compared the resultant XG value to that in the spreadsheet. Perfect every time. Many thanks.
Prex.
I revised my sheet with your simplified formula. Nice work. Thank you.
Doug.
Thanks mate. Awesome spreadsheet. I have added it to my arsenal.
Many thanks.
Judge.
RE: Determine distance to Centre of Gravity of shape from 2 intersecting circles
RE: Determine distance to Centre of Gravity of shape from 2 intersecting circles
Hmmm, I think that's why we all got into this business in the first place
It is better to have enough ideas for some of them to be wrong, than to be always right by having no ideas at all.
RE: Determine distance to Centre of Gravity of shape from 2 intersecting circles
More details and download link at:
https://newtonexcelbach.wordpress.com/2015/07/08/s...
Screen-shot attached.
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/