Check out Mathlab / Matlab (?)
Many sites have maths functions.
David
in article 7zrZrVAO...@micrometric.co.uk, Neil Main at
Neil...@micrometric.co.uk wrote on 14/3/01 9:49 PM:
Suppose your points are (xa,ya) , (xb,yb) and (xc,yc)
Then I think the centre of the circle, (a,b) is :
a=(ya^2+xa^2-yc^2-xc^2-(ya-yc)*(ya^2+xa^2-yb^2-xb^2)/(ya-yb))/2/(xa-xc-(ya-y
c)*(xa-xb)/(ya-yb))
b=(ya^2+xa^2-yb^2-xb^2-2*b*(xa-xb))/(ya-yb)/2
Regards
Rog
Neil Main <Neil...@micrometric.co.uk> wrote in message
news:7zrZrVAO...@micrometric.co.uk...
b=(ya^2+xa^2-yb^2-xb^2-2*a*(xa-xb))/(ya-yb)/2
Rog
Roger Butler <roger....@marlborough-stirling.com> wrote in message
news:ZfJr6.5193$tA5.8...@news2.cableinet.net...
The equation of a circle is (x-a)^2 + (y-b)^2 = r^2, where the center is
at (a,b) and the radius is r.
Given three points on the circumference (x1, y1), (x2, y2), and (x3,
y3), you have three equations in three unknowns.
If you don't want to do this algebraically, here's one numerical
approach.
Designate three cells, say A1, B1, and C1 as being a, b, and r.
Enter the coordinates of the 3 points in a 3x2 range, say A2:B4.
Now, create three equations in three cells, say C2:C4, with the formulas
corr. to the equation of the circle, one for each data point. For
example, one of them should be =(x1-a)^2 + (y1-b)^2 - r^2.
Sum these results in another cell, say C5.
Use Solver to solve for C5=0 by changing a, b, and r. The constraints
should include C2:C4>0 and r>0. Note that a and b can take any values.
Assignment complete.
--
Regards,
Tushar Mehta
www.tushar-mehta.com
--
In <7zrZrVAO...@micrometric.co.uk>, Neil Main
<Neil...@micrometric.co.uk> wrote
Thanks everyone, done.
--
Neil Main
"Normal people believe that if it ain't broke, don't fix it. Engineers
believe that if it ain't broke, it doesn't have enough features yet."
----- Scott Adams, The Dilbert Principle
Rog
Tushar Mehta <ng_p...@bigfoot.com> wrote in message
news:MPG.151988ca3...@msnews.microsoft.com...