Rotation and translation of coordinates

[twa14]

Rotation and translation of coordinates

WARNING!! WARNING!! THIS QUESTION ALSO POSTED ON MREXCEL.COM

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

3D Coordinate Translation and Rotation Formulas for Excel. (LINK NOT ALLOWED!)

excelforum.com/excel-for...for-excel.html

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.

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

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.

[AliGW]

Rule 08: Cross-posting Without Telling Us

Your post does not comply with Rule 8 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

Post a link to any other forums where you have asked the same question. If you have fewer than 10 posts here, you will not be able to post a link, but you must still tell us where else you have asked the question.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

No further help to be offered, please, until the OP has complied with this request.

[twa14]

When I posted a link I was informed that posting links was not allowed! The question asked refers to a previous question asked by another member and answered by "SHG" . SHG indicated that he had an answer to a second question posted on the same thread: Link: Oh Dear!

"You are not allowed to post any kinds of links, images or videos until you post a few times"

This may also answer my question, however "SHG" did not publish it. Thats all

I did post the question on another thread where "SHG" is also active, I did not get a reply.