excel计算大全公路坐标计算程序

平曲线要素计算交点号12345678交点坐标X190486.7476191525.1869191769.2021192300.1083192484.959192830.1687193722.5119195134.111196146.2484Y63115.077963703.151563762.611664027.213164320.178164291.39364736.133164561.223965469.0325交点桩号1193.391442.782035.042376.812685.333624.315012.046270.72偏角(度分秒)左(-)、右(+)-15.49426412.47487931.152889-62.30577731.152886-33.33176648.571105R1000100030030030020001800Lh1Lh2说明：白色区域为输入区域曲线要素值(m)A2q1A1#REF!#REF!#REF!#REF!#REF!q2LY2E80.08379.62879.62879.62879.62880.083154.559154.559155.00040.01839.79139.79139.79139.79140.018曲线控制桩号交点号ZH#REF!#REF!#REF!#REF!#REF!3624.315012.046270.72HY#REF!#REF!#REF!#REF!#REF!3624.315012.046270.72QZ#REF!#REF!#REF!#REF!#REF!3624.315012.04#VALUE!YHHZ直线长度(m)及方向(度分秒)方位角直线长交点间距备注(度)29.523113.6945926.4914857.7495355.233526.49147352.936641.8896412345678#REF!#REF!#REF!1193.39#REF!#REF!#REF!251.155#REF!#REF!#REF!593.191#REF!#REF!#REF!346.408#REF!#REF!#REF!346.4083624.313624.311387.73997.0315012.045012.041258.681422.39#VALUE!#VALUE!1359.61说明：桩号输入按正常输入即可，如“K10+234.56”、“K3+000”