Rotation and translation of coordinates

[twa14]

I would like to ask “SHG” a question as it relates to an old post of his, namely:

https://www.excelforum.com/excel-fo...nslation-and-rotation-formulas-for-excel.html

This was a very nice solution to the posted problem, however I also saw this as a possible solution to a problem I had come across myself.

The problem concerns the construction of an in-situ concrete bridge deck. The deck is shaped as a segment of a circle with radius to the setting out line\Master String of 350m. The bridge deck is to cross a motorway and cannot be built at the required location as the motorway has to remain open during construction. The plan is to build the deck on temporary columns at a location close to the final location and transport the completed deck to its final destination during a weekend possession.

I have the following information: Coordinates are on the Master string with radius 350m. Coordinates of the centre points are given in the table below as Xcp,Ycp

Final Location	X	Y	Z	Xcp	Ycp	Radius
Abutment1	110285.205	478353.155	3.745	109952.570	478462.034	350.000
Column	110299.604	478416.560	4.047
Abutment 2	110302.551	478465.733	3.841
Temporary Location
Abutment1	110246.983	478454.145	3.745	109900.000	478500.000	350.000
Column	110249.478	478519.116	4.047
Abutment 2	110243.332	478567.992	3.841

<tbody>
</tbody>

I thought that having 3 coordinates for permanent and temporary situation would mean that as the structure is rotated and translated to its temporary situation and eventually back again that the excel sheet would enable me to calculate coordinates in the temporary situation using coordinates from the permanent situation. However on using the solver to get the Rms error, this gives 4.980 instead of zero? I am probably missing something in the VBA, I am unfortunately not very expert in it. I am hoping that you can comment on whatever it is that I am doing wrong.

http://tinypic.com/m/k3ueit/4

 

[twa14]

To "SHG". Just wondering if you had seen my post "https://www.mrexcel.com/forum/members/twa14.html" My post refers to an old post of yours from 2013. In this you tantalisingly refer to a solution of a problem which may be the same as my problem, you state "I did do a solution, BTW, but it required VBA." I would definitely like to see this solution if still available. The link can be found on the post above. My apologies if I am in some way breaking protocol.

 

[Fluff]

Cross posted https://www.excelforum.com/excel-ge...d-translation-of-coordinates.html#post4852381

Cross-Posting
While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[twa14]

I think its pretty clear from my post? The links are plain for all to see? The question is directed to "SHG" as it has to do with his posts on the other forum! What am I missing here?

 

[Fluff]

Whilst you put a link to the thread you wanted help with, you did not mention that you had also asked the same question on the other board.
Please take a moment to read the rules.

 

[twa14]

"you did not mention that you had also asked the same question on the other board."

The link is to "Excelforum" not "MrExcel"?

 

[Fluff]

You supplied a link to the post that you were interested in, you did not supply a link to your own post on ExcelForum.
As mentioned before, please take a few minutes to read the rules and, in future, comply with them. Thank you

 

[twa14]

Duplicate thread on Excelforum:

https://www.excelforum.com/excel-ge...d-translation-of-coordinates.html#post4852381