Learn from millions of experts
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.
Variables are:
"r" for the arc radius
"y" for the arc angleFormula:
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.
Attachments
MATERIAL REMOVED BY RADII.xlsx, 21.9 KB
Download
Was attached in last comment
[C19] "ANGLE B"
[E19] "RAD A"
[D18]=SUM(90-(C19/2))
[D21]=SUM(D18*PI()/180) <-- converts to radians -- excel works in radians--
[D19]=TAN(D21)
[G19]=SUM((E19*D19)-E19) <-- answer "x"Thanks again
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.