First, thanks for the brain workout, I couldn't get it yesterday but came in fresh today and banged it out.
We'll be solving for "D", which represents the dimension you're looking for.
"r" for the arc radius
"y" for the arc angle
D=[r x tan(90-(y/2))]-r
I don't know how to input it into excel, so good luck with that. Gotta admit, I'm feeling pretty groovy after figuring it out. I tend to avoid the maths as much as possible, har har!
What about solving the area of the green triangle, then deleting the area of the overlapping red circle?
I'm sure there is some really smart way to solve it with Calculus, but I'd use a circle and triangle... Actually, I'd solve it in CAD.
I was hoping to make an Excel sheet our inspectors could use to "fill in" the angle and rad to solve for X.
WORKS LIKE A CHARM! Thanks for your time.
AttachmentsMATERIAL REMOVED BY RADII.xlsx, 21.9 KB
Was attached in last comment
[C19] "ANGLE B"
[E19] "RAD A"
[D21]=SUM(D18*PI()/180) <-- converts to radians -- excel works in radians--
[G19]=SUM((E19*D19)-E19) <-- answer "x"
Nevermind, I figured out how to 'unprotect' it...I really need to get better at excel!
Sweet! Would you mind sharing the Excel formula? I did one, but it was kind of clunky and had some extra cells just for converting degrees to radians, I'd be interested in seeing a more elegant Excel solution.