3d Helmert Transformation

Hello,

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.

Parents Reply Children
  • Mark,

    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.