Following a discussion at Eng-Tips and resulting comments I have updated my Section Properties spreadsheet to include calculation of the area and centroid of a “Lune” (the shape of a crescent moon). I have also added a “Re-draw Shape” button because in at least one case the automatic re-draw was not working. The download spreadsheet includes full open source code.
The screen-shot below shows the input and results for a Lune:
The results at the moment only include the angles of the two arc segments, the areas of the smaller radius segment and the lune, and the centroid position of the lune, measured from the centre of the larger arc. The second moments of area can be calculated using the “Group” function, as shown below.
1. Enter the section details (radius and arc angle from the x-axis, Theta) for the smaller radius circular segment, using Shape Type 4:
2. Scroll down to the Group Properties table and enter the shape X offset as the offset between the two segments. The “Elastic Modulus” should be entered as 1. After entering these details, click the “Create New Group” button:
3. Enter the section details for the larger radius segment:
4. Go back down to the Group Properties table, enter X offset as 0 and Elastic Modulus as -1 (so the shape properties are subtracted from the total) then click “Add shapes to group”. The Group Properties table will update, including Ix and Iy values:
A similar procedure allows any combination of the standard shapes to be generated, including multiple copies of any shape with different offsets and/or rotations from the origin. Shapes may also be rotated about their own centroid.
Newton Excel Bach, not (just) an Excel Blog 
Hello,
Please see shape example by link:
https://www.dropbox.com/s/2j851e520ggqo7z/Section%20Properties07-GROUP.xlsb?dl=0
Area of group elements seems not OK in sheet: Coords_Group
LikeLike
Hi metroxx,
It looks like the problem is your “Elastic Modulus” value. If you just want the section properties enter 1, rather than the actual material E value. The intention of the column is to get effective transformed section properties for different materials (steel and concrete for instance), or to generate holes by using 1 for the solid and -1 for the hole.
For two rectangles:
Select the rectangle shape (as you have)
Enter the offset values for the two shapes in the group properties input (say x = 20 and x = -20, with everything else zero).
Enter 1 under Elastic Modulus for both shapes.
Click “Create new group”
That should work.
LikeLike