摘要
Abstract
Surveying of Linear Engineering Projects typically involves the setting-out and mapping of longitudinal and cross sections for linear buildings(structures)such as highways,railways,subways,and power transmission lines.The alignment of such projects is never a straight line but rather a combination of multiple straight segments and curves.In subway alignments,horizontal curves are generally composed of straight lines,circular curves,and transition(spiral)curves.This paper introduces a custom function for coordinate inverse calculation(i.e.,determining chainage from coordinates)based on the intersection point method,using a conventional alignment consisting of straight lines,transition curves,and circular curves.To improve efficiency,numerous software tools are available today.Drawing on nearly a decade of experience in subway tunnel construction and operational monitoring,this study leverages Excel VBA for secondary development to expedite data processing.A custom Excel function was developed,taking the alignment parameters(based on the intersection point method)as inputs.By inputting measured point coordinates,the function automatically identifies the corresponding alignment segment(straight,transition,or circular curve)and computes the chainage.Since Excel functions are user-friendly and allow batch processing via copy-paste operations,this method enables batch calculation of chainages from coordinate data.This approach also facilitates subsequent tasks such as cross-section plotting and overbreak/underbreak analysis in tunnel construction.关键词
Excel VBA编程/坐标反算里程/自动反算/自定义函数/批量计算Key words
Excel VBA programming/coordinate-to-chainage inverse calculation/automatic inverse computation/custom functions/batch processing分类
交通工程
