Results 1 to 4 of 4

20031209, 15:29 #1
 Join Date
 Feb 2001
 Location
 Ontario, Canada
 Posts
 80
 Thanks
 0
 Thanked 0 Times in 0 Posts
Mathematical Calculation puzzle? (Excel  ANY)
I have an interesting puzzle/riddle to solve. I am using this forum simply because I want the result in Excel. I need to determine the area of an odd shape given two parameters. The formulas/method to determine this would be helpful in an Excel spreadsheet as there are many values of the two variables. I am attaching a GIF of the shape for reference. The only two variables supplied are "T" or thickness, and "W" or width. The radius of the edge is simply T*3/4.
Any help would be most appreciated!!
Drew

20031209, 17:35 #2
 Join Date
 Jul 2002
 Location
 Pittsburgh, Pennsylvania, USA
 Posts
 11,225
 Thanks
 14
 Thanked 342 Times in 335 Posts
Re: Mathematical Calculation puzzle? (Excel  ANY)
<P ID="edit" class=small>(Edited by sdckapr on 09Dec03 12:35. OOPs made a mistake, Corrected it here)</P>Given your "W", "T" and your "RF" (radius factor) of 0.75 you can calculate:
x = SQRT((RF^20.5^2)*T^2) = The distance from the center of "radius" to the end of rectangular section.
alpha =2*ASIN(0.5/RF) = the angle of the "PieSections"
AreaPie =alpha/2*(RF*T)^2 = Area of each end "pie segment"
AreaTriangle =x*T/2 = Area of each "triangle" in the pie (the pie without the circular cap)
AreaCap = AreaPie  AreaTriangle
AreaRectangle =T*(W2*(RF*Tx))= area of the rectangular area
Total area = AreaRectangle +2*AreaCap
In one formula this is:
Area =T*(W2*T*RF+SQRT((RF^20.5^2)*T^2))+2*ASIN(0.5/RF)*(RF*T)^2
Steve

20031209, 17:43 #3
 Join Date
 Feb 2001
 Location
 Ontario, Canada
 Posts
 80
 Thanks
 0
 Thanked 0 Times in 0 Posts
Re: Mathematical Calculation puzzle? (Excel  ANY)
Hi!! Thanks for the help!! You know, I copied the data into an Excel worksheet, began testing it and it didn't come out right. I looked it over step by step figuring, "Something must be wrong, but where. Hmmmm.." So, when i reviewed the last formula (AreaRectangle) I realized there was an error. I corrected my worksheet and all worked well. So, I thought I'd come on here and let you know there was a minor error, and LOandBEHOLD, you ALREADY CORRECTED IT!!!
Thanks for following up!! I appreciate the help!! And thanks for forcing me to walk through it rather than simply taking it for granted. I am better off for it.
Drew

20031209, 17:55 #4
 Join Date
 Jul 2002
 Location
 Pittsburgh, Pennsylvania, USA
 Posts
 11,225
 Thanks
 14
 Thanked 342 Times in 335 Posts
Re: Mathematical Calculation puzzle? (Excel  ANY)
Yes, I had removed the 2 "x"s originally from the length. I wanted to subtract the radius then add the "x" back.
I am glad it worked out.
Steve