Need help working from home with your Bentley software? We're here to help - click here
I am using MS v8i ss2.
I would like to develop an excel calculator to apply a Helmert 3D Transformation to convert from site to state plane, northing-easting coordinates. I have a decent book (by JC Iliffe) and many white papers on the subject, but keep encountering math issues with my calculator. I am unsure about calculating the unknown parameters and would like a detailed example I can learn from. I was hoping a technical person in the forum could offer any suggestions of a Bentley site, other book references, blogs, etc. that may have more detailed calculations / examples.
Do a search online for '3D Helmert Transformation Excel' - several examples are returned. If the book you have does not explain the transformation process, I would get a different book.
Thanks for your suggestions. I understand the online excel spreadsheets, also the first resource I explored, but they are either 2d or of the Great Britain datum basis. The question I asked was in reference for a good book or similar reference. Although, I do not find a lot of material, I imagine a textbook will be the best resource, but thought I would check with the forum for any specific ideas if there are any.