# update plot with new data

i have several thousand Cartesian coordinated separated into two groups. The location of the two groups are relative to each other. I have created a new model for one of the groups and I would like to update the coordinates of one group but keep its same relative location to the first group. How do I systematically transpose one groups coordinates over another groups coordinates. (Please if possible be specific. I really need to do this not just think about possible solutions.)

Files

old correct: http://www.mediafire.com/?b2gt9w3ueul62tp

1st column relative id, 2nd column set identifier A and B do not move C moves, 3rd-6th corordiantes

from new:
15983   C   1.462   0.019   -0.001
15984   C   2.013   1.439   -0.001
15985   C   3.091   1.697   0.534
15986   C   1.997   -0.752  -1.21
....
needs to move and tilt to
15983   C   129.1   -3.714  83.947
15984   C   128.949 -2.886  85.217
15985   C   129.062 -3.407  86.326
15986   C   130.522 -3.577  83.397
15987   C   130.826 -4.508  82.244

maintaining the new structure


i'm looking for a way to find a vector x that i can find inside old C which I can multiply by the matrix new C (where Cs are not perfectly equal) but the results only need to be accurate to a few degrees of freedom. I just don't know how to find this matrix. :)

Since the matrix which needs to be chagned is set at 0 as the first element. I could add the minimum vector to each element and it gets me to the begining of the proposed position. Now I need to rotate the plot so that it is oriented the same as before.

How do I calculate the rotation change needed and change the rotation of several points?

-
Could you give some example with small numbers? –  Sigur Sep 21 '12 at 1:08
@Sigur thanks for the response...I uploaded two files and added them to the post to give you an idea of what i would like to do –  caseyr547 Sep 21 '12 at 1:19
Sorry. I didn't understand what you want. I can't see difference between those files, at least at beginning. Try to write here 2 or 3 lines of the old file and the new file. –  Sigur Sep 21 '12 at 1:27
@Sigur thanks I updated the question –  caseyr547 Sep 21 '12 at 1:36
Sorry. I tried but I don't know how to help you. Good luck. –  Sigur Sep 21 '12 at 1:39