Defining a plane
Defining a plane
(OP)
I'm attempting to create an excel spreadsheet that will help me define a plane, based on 3 corner points of a stair landing. I want to do this to determine the overall deflection in relation to the local structure, not to the building structure. This stair is 28' tall and has 6 landings and is only supported by the outside stringers, therefore I am getting proportionately more deflection in the center of the stair. I'm trying to create a spreadsheet that when I enter coordinates and deflections of N1-N3 and add N4 it will give me deflection based against the plane created by N1-N3. Is there a simple way to do this in excel does anyone know? Please let me know as soon as you can. Thanks.
RC
RC






RE: Defining a plane
RC
All that is necessary for the triumph of evil is that good men do nothing.
Edmund Burke
www.tbastructures.com
RE: Defining a plane
If you have the coordinates and the deflections, you have everything: what are you looking for?
After rereading your first post, I understand that you want to calculate the distance of a point in space from a plane defined by three other points.
In this case:
-represent your plane with the standard equation
ax+by+cz+d=0
-the standard equation is obtained by elaborating the matrix equation:
| x y z 1 |
| x1 y1 z1 1 |
| x2 y2 z2 1 |=0
| x3 y3 z3 1 |
The distance is now given by:
δ=|ax4+by4+cz4+d|/√(a2+b2+c2)
prex
http://www.xcalcs.com : Online tools for structural design
http://www.megamag.it : Magnetic brakes for fun rides
http://www.levitans.com : Air bearing pads
RE: Defining a plane
RC
RC
All that is necessary for the triumph of evil is that good men do nothing.
Edmund Burke
www.tbastructures.com
RE: Defining a plane
As an example:
a=y1z2-z1y2+z1y3-y1z3+y2z3-z2y3
Good luck!
prex
http://www.xcalcs.com : Online tools for structural design
http://www.megamag.it : Magnetic brakes for fun rides
http://www.levitans.com : Air bearing pads
RE: Defining a plane
Thanks a lot for your patience on this.
I haven't done matrix work in a year or two and was having a hard time recalling how to do it.
Thanks again.
RC
All that is necessary for the triumph of evil is that good men do nothing.
Edmund Burke
www.tbastructures.com