arc 3 point center with excel

[mario]

French:

est-ce que quelqu'un aurais un fichier excel qui calcul le centre d'un arc avec 3 dimension d'un arc

 

merci

 

English:

 

somebody would have an Excel file which calculation the center of an arc with 3 dimension of an arc

 

thank's

[Guest]

not sure what you are asking, but by using analyze,area-volume you can find the center of gravity for any geometry.

[mcpgmr]

Yes I do. Let me dig it up. Might be on my pc or a cd at home.

[Span]

Mario, I just sent you one via email. I can't upload to the FTP so if anyone else wants it or wants to put it on the FTP let me know.

[Kannon]

I dont have an excel sheet, but cant one do it by create-arc-circ 3 pts?

 

then analyze the the circle for center of gravity?

[Guest]

quote:

---

then analyze the the circle for center of gravity?

---

that's what the fish said.

[Kannon]

Sorry del.. its just with all that gurgling.. I couldnt understand a d*mn word you said.

I was gonna say it first...

just not being sure...I wanted to wait til someone else said it...then jump on the bandwagon.

[Hardmill]

quote:

---

its just with all that gurgling.. I couldnt understand a d*mn word you said.

---

 

 

PEACE

[Guest]

gurgle.............................

 

sorry about that,it's a speech impediment and i think someone needs to change my water.

[John Summers]

MP.DLL can solve math problems as well as Excel.

Given 3 points P1x,P2x,P3x, this code will find the radius R, without using angles. You can translate this to Excel, but I don't know if it has a math library. This code works on similar triangles. Email me if you need more help.

v1x = vsb(p2x, p1x)

v2x = vsb(p3x, p2x)

v3x = vsb(p3x, p1x)

v1x = vnr(v1x)

l2 = lng(v2x)

l3 = lng(v3x)

vnx = vlh(v1x)

s1 = dot(v2x, vnx)

r = l2*l3/(2*s1)