基于Access VBA的高斯投影程序设计

The Program Design of Gauss Projection Based on the Access VBA

测量工作中,经常需要进行不同椭球下的高斯投影正算、反算与换带计算,如果用手工完成,不仅计算量庞大,而且容易出错。文中首先介绍了高斯投影的公式,然后利用Access在处理批量数据的优势,结合VBA编写了计算程序,实现了任意椭球下的高斯投影正算、反算与邻带坐标换算的单点和批量计算。通过实例验证了程序的准确性及实用性,可以满足工程需要。

In the work of measurement , we often need Gaussian positive operator and Gaussian inverse operator , convertible calcula-tion from different ellipsoids .If done by hand , the calculated amount is huge , and prone to error .This paper firstly introduces the Gauss projection formula , then utilizes the Access in dealing with the advantages of batch data , combines with VBA to write the calcu-lation program, and then achieves single point and batch calculation of Gaussian positive operator and Gaussian inverse operator and adjacent zone coordinate conversion under the random ellipsoid .This paper verifies the accuracy and practicability of the program through the examples , thus, can meet the needs of Engineering .