【摘要】 利用Excel编制公路路线坐标和方位角计算程序,操作简单,阅读容易,可减轻劳动强度,提高工作质量与效率。文章根据《公路路线设计规范》延伸推导出高精度的缓和曲线计算公式,利用Excel电子表格对主要公式进行程序编制,并结合实例进行了编程演示,展现了利用Excel编制公路路线坐标和方位角计算程序的优势。更多还原

【Abstract】 Using Excel to construct coordinates and azimuths calculating program is easy to do and easy to read.It also reduces the work load and elevates the quality and efficiency of work.The article uses’Road Design Criterion’to derive accurate calculating formula for easement curve.It also performs sample run-through to show the advantages by using Excel.更多还原