施工坐标与大地坐标转换excel表格

施工坐标与大地坐标转换EXCEL表格EXCEL表格计算方位角距离转换前原坐标方位角转换后坐标方位角角度差值348.372638347.97427270.39836522348°22′21.5″347°58′27.38″X02612308.1612611935.4YO402127.225504189.185X12612327.7512611954.961M3941.383424Y1402123.194504185.018N-120209.8517成果输出点号需转换R需转换V转换后X转换后Y12612308.161402127.2252611935.4504189.18522612327.751402123.1942611954.962504185.017932612347.341402119.1632611974.523504180.850842612366.931402115.1322611994.085504176.683752612386.521402111.1012612013.646504172.516662612406.111402107.072612033.208504168.349572612425.701402103.0392612052.769504164.182482612445.291402099.0082612072.331504160.0153转换前原坐标方位角转换后坐标方位角19.5919.561-4.031-4.1670.2057682490.213025919象限角0.2029357510.209888536方位角弧度表示6.0802495566.073296772方位角度表示348.372638347.9742727度、分、秒表示348°22′21.5″347°58′27.38″距离20.00020.000