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

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

作　　者：钟宏斌 刘庆元[1] Zhong Hongbin;Liu Qingyuan(School of Geosciences and Info-physics,Central South University,Changsha 410083,China;Changsha Metro Group Co.,Ltd.,Changsha 410009,China)

机构地区：[1]中南大学地球科学与信息物理学院,湖南长沙410083 [2]长沙市轨道交通集团有限公司,湖南长沙410009

出　　处：《矿山测量》2021年第1期43-48,共6页Mine Surveying

摘　　要：针对公路工程建设中存在着的线路坐标计算繁琐、坐标转换频繁、坐标计算难以适应复杂构型(如卵形曲线、“水滴形”曲线等)等特点,以高斯勒让德通用公式为理论基础和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.

关 键 词：线路放样 坐标正反算 Excel-VBA 程序设计 

分 类 号：P258[天文地球—测绘科学与技术]