Coordinate Transformation Program Design base on VBA 

LIU Jingjing1 , YANG Tieli1,2, ZHANG Min1 , ZHAO Aina1 , PAN Shu1 

1 School of civil engineering, University of Science and Technology Liaoning, Anshan, CHINA 

2 China Academy of Surveying and Mapping, Beijing, China 

Abstract: The transformation between construction coordinate system and national unified coordinate is always needed in engineering surveying. According to different cases, there is not only the application of coordinate transformation model of the same type of plane coordinate system but also the model under different types of reference coordinate in the process of the coordinate transformation. In addition, the precision evaluation of coordinate transformation is an important factor, and is the key to affect if the result can be used. This paper analyzes the precision of coordinate transformation, implement the precision evaluation of coordinate transformation rely on software, research the problem of positioning which solved by conversion program when the observed value ｏｒ known result is false. Keywords: Engineering surveying; Coordinate transformation; Precision evaluation