基于Excel-VBA的公路线路坐标正反算程序设计

Program design on the positive and inverse calculationof highway route coordinates based on Excel VBA

针对公路工程建设中存在着的线路坐标计算繁琐、坐标转换频繁、坐标计算难以适应复杂构型(如卵形曲线、“水滴形”曲线等)等特点,以高斯勒让德通用公式为理论基础和Excel VBA自定义函数为依据,编程实现线路坐标正、反算,达到了简单、快捷、方便的目的,为公路、铁路施工放样提供了一种可靠实用的计算工具。

In view of the characteristics of the complicated route coordinate calculation,the frequent coordinate conversion,and the coordinate calculation were difficulty to adapt the complex configuration such as the oval curve,"drop-shaped"curve,etc.in the highway construction engineering,based on the Gauss Legendre general formula and taking Excel VBA custom function as the basis,the positive and inverse calculation of the route coordinates were realized by programming to achieve the purpose of simple,fast and convenient,and provide a reliable and practical calculation tool for the highway and railway construction layout.