全线积木法道路坐标批量计算(EXCEL表格)

1、道道路路线线元元要要素素表表起点里程终点里程起点X起点Y起点方位角起点半径终点半径线元类型0161.99836380.48960004.91291.2601300直线161.998251.99836376.43660166.85991.260130300第一缓和曲线251.998422.43636369.69860256.516100.0141021300300圆曲线422.436482.43636295.18360407.260132.34455583000第二缓和曲线482.436542.43636251.75360448.620138.18320390-800第一缓和曲线542.4366

2、30.31136207.45460489.081136.0937109-800-800圆曲线630.311720.31136147.53860553.302129.5200209-8000第二缓和曲线720.311934.34936092.48660624.485126.383781400直线934.3491024.34935964.74060796.220126.38378140-550第一缓和曲线1024.3491302.82335913.02960869.849121.5721603-550-550圆曲线1302.8231362.82335830.40661132.67792.56463

3、56-5500第二缓和曲线1362.8231422.82335829.50261192.66389.49155480400第一缓和曲线1422.8231986.81335828.19061252.63394.0705408400400圆曲线1986.8132076.81335464.72361622.359174.54136284000第二缓和曲线2076.8133110.93135374.78261623.613181.205841900直线3110.931道道路路坐坐标标计计算算程程序序里程坐标计算结果(直线段)夹角(度.分秒):90.0000起始里程：K0+000.000序号里程中桩 坐

4、标左边桩计算点起始点 左边桩：20XYX起始点 右边桩：201036380.48960004.91236400.483里程间距2022036379.98960024.90636399.982夹角边桩与中桩夹角9034036379.48860044.89936399.482 中桩 X：36380.48946036378.98860064.89336398.982始点 Y：60004.91258036378.48760084.88736398.481计算左边20m 坐标X:36400.483610036377.98760104.88136397.981结果 坐标Y:60005.4127120363

5、77.48760124.87436397.480右边20m 坐标X:36360.495814036376.98660144.86836396.980 坐标Y:60004.412916036376.48660164.86236396.480作者QQ:15890319右夹角里程方向左边右边注意：1.计算前先在“线元参数表”输入正确平曲线参数。2.当夹角=90度,边桩等于中线偏距3.当夹角90度,边桩等于中线斜距左夹角夹角(度.分秒):90.0000坐标右边桩 坐标YXY60005.41236360.49560004.41260025.40636359.99560024.40560045.40036359.49460044.39960065.39436358.99460064.39360085.38736358.49460084.38760105.38136357.99360104.38060125.3753635