Geometrical calcs

[RichLear]

Hi all, this is maybe a bit of an odd one. I have three points, each of which has an X and Y coordinate associated with it. They are around 50m apart. From each of the three points I will measure a range, effectively putting a circle of a measured radius around each of the points. I want to calculate the X and Y position of the intersect of the three circles. I could do it using something like AutoCAD but was hoping to be able to use Excel. Could anyone point me in the right direction? Thanks very much

 

[JamesCanale]

Stole the formula from stack exchange:

Find intersection point of 3 circles

so first of all, I just want to point out that I am a beginner, so cut me some slack. As the title says I have 3 circles. I know the coordinates of each center and the radius of each circle. What I

math.stackexchange.com

MrExcelPlayground18.xlsx
	B	C	D	E	F	G	H
1	x	y	r			Intersection
2	0	0	26.93			10	25
3	40	10	33.54
4	25	26	15.03
5
6	10	25
Sheet24

Cell Formulas
Range	Formula
D2:D4	D2	=SQRT((C2-$H$2)^2+(B2-$G$2)^2)
B6	B6	=-((C3-C4)*((C3^2-C2^2)+(B3^2-B2^2)+(D2^2-D3^2))-(C2-C3)*((C4^2-C3^2)+(B4^2-B3^2)+(D3^2-D4^2)))/(2*((B2-B3)*(C3-C4)-(B3-B4)*(C2-C3)))
C6	C6	=-((B3-B4)*((B3^2-B2^2)+(C3^2-C2^2)+(D2^2-D3^2))-(B2-B3)*((B4^2-B3^2)+(C4^2-C3^2)+(D3^2-D4^2)))/(2*((C2-C3)*(B3-B4)-(C3-C4)*(B2-B3)))

 

[RichLear]

perfect - just what I was looking for, thanks