# Equation to calculate distance of 2 points on 2 different planes

1. ## Equation to calculate distance of 2 points on 2 different planes

Hi Everyone ,

I have 2 plane (ABCDEFG) and (A1 B1 C1 D1 E1 F1 G1)
I have x,y,z for A,B,C,D,E,F,G where is z=0
I have x,y,z for A1,B1,C1 which are AA1#BB1#CC1
All lines AA1,BB1,CC1,DD1,EE1,FF2,GG1 are perpendicular with plane (ABCDEFG)
How do I find the distance of DD1,EE1,FF1 and GG1 ?
Is there a equation for it ?

Mark

2. ## Re: Equation to calculate distance of 2 points on 2 different planes

You will need to tell us the equation you would use to work it out and then we can help you to convert it to an Excel formula. This is an Excel forum, not an equation forum.

3. ## Re: Equation to calculate distance of 2 points on 2 different planes

Thanks AliGW for the comment but i believe there are many excellent math people here in this forum

Regards,
Mark

4. ## Re: Equation to calculate distance of 2 points on 2 different planes

There may be, but that's not what the forum was set up for.

I've moved the thread out of the Excel forum, as it is not an Excel query.

5. ## Re: Equation to calculate distance of 2 points on 2 different planes

As it's already in water cooler:

I assume that D1 E1 etc are in the same plane as A1 B1 and C1. If not - we cannot do anything about it.
If you have all coordinates of A1, B1 and C1 you can "draw" two wectors A1B1 and B1C1 and their vector product will be the vector perpendicular to A1B1C1 plane. if this vector is say [m,n,o] then each point on the plane perpendicular to this vector and passing through A1 (x0,y0,z0) will obey:
m(x−x0) + n(y−y0) + o(z−z0) = 0
so z will be (as we remember z0 is 0)
= -(m(x−x0) + n(y−y0)) / o

to implement it in excel - see the yellow banner near the top of the page

6. ## Re: Equation to calculate distance of 2 points on 2 different planes

Originally Posted by AliGW
There may be, but that's not what the forum was set up for.

I've moved the thread out of the Excel forum, as it is not an Excel query.
Got it !

Thanks
Mark

7. ## Re: Equation to calculate distance of 2 points on 2 different planes

Thanks Kaper
Much appreciate!!!

Mark

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1