3D Coordinate Translation and Rotation Formulas for Excel.

I used Solver to compute three Euler angles for rotations and three distances for translation, resulting in a 4 x 4 homogeneous transformation matrix, and then applied the same transformation to the other points.

A UDF calculates the rotation portion of the matrix.

I think this is correct, but haven't done it in a long time.