基于Excel VBA的盾构中心线计算程序设计  

Calculation Program of Shield Centerline Based on Excel VBA

作　　者：苏小文[1] 高俊强[1] 

机构地区：[1]南京工业大学测绘学院

出　　处：《地理空间信息》2014年第6期129-131,5,共3页Geospatial Information

摘　　要：为克服现有盾构中心线计算软件难以解决曲线出洞和断链等问题,结合工程实际,采用Excel VBA进行二次开发。使用表明,程序计算准确,计算误差达mm级,且便于修改,很好地解决了以前计算方式的不足。Existing shield centerline calculation program is difficult to solve the practical problems of the break-out curve and chain breaking, combined with experience in engineering practice and actual demand, we conducted secondary development adopting Excel VBA. The procedure's interface of data calculation is user-friendly and easy. Verification by engineering practice, the calculation of procedure is accurate, and the calculation error comes to millimeter level. The procedure is easy to modify and can improve ei ciency as well as solve disadvantage of the previous calculation.

关 键 词：盾构中心线 EXCEL VBA 程序 

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