曲线要素等计算公式表格.xls

交点桩号 K718+785.246 交点坐标X 3082416.9530 交点坐标Y 518517.9709 曲线半径R 11000 曲线偏角 4.43966666742622.8 偏向 1 缓和曲线长度L 410410 第一计算方位角A1 258.75281392584510.1 切线长度T 631.413631.413 曲线长度l 1262.355 直缓点桩号ZH K718+153.833 缓圆点桩号HY K718+563.833 曲中桩号QZ K718+785.010 圆缓点桩号YH K719+006.188 缓直点桩号HZ K719+416.188 第二计算方位角A2 263.1924806 XYXY 第一计算边直线段 3082954.551521151.6460.000K716+100.000 0.0003082954.551521151.646 K716+100.000 3082940.689521151.6460.000K716+100.000 0.0003082940.689521151.646 3082940.689521151.6460.000K716+100.000 0.0003082940.689521151.646 3082940.689521151.6460.000K716+100.000 0.0003082940.689521151.646 3082940.689521151.6460.000K716+100.000 0.0003082940.689521151.646 3178088.903999616.8250.000K228+265.899 0.0003178088.903999616.825 第一计算边缓和段 3082540.105519137.25820.900K718+153.833 24.0003082519.607519141.334 K718+153.833 3082529.157519082.1680.000K718+210.000 0.0003082529.157519082.168 3082529.157519082.16820.000K718+210.000 25.0003082509.539519086.062 3082529.157519082.16820.000K718+210.000 25.0003082509.539519086.062 3082529.157519082.16824.000K718+210.000 26.0003082505.616519086.841 3082529.157519082.168K718+210.000 28.0003082529.157519082.168 3082529.157519082.16824.000K718+210.000 27.0003082505.616519086.841 3082529.157519082.16815.000K718+210.000 20.0003082514.444519085.088 3082529.157519082.16815.000K718+210.000 3082514.444519085.088 3082529.157519082.16823.000K718+210.000 3082506.597519086.646 3082529.157519082.168K718+210.000 18.0003082529.157519082.168 右边桩距 左边桩坐标 注:红块内的数据为需要输入的数,D、E、F栏内的数据为需要输入的数，其余均为自动计算值.在计算新的里程或加桩里程坐标时,一定要先将最右边的K、L两栏往下拖，再将X、Y值往下拖，计算才正确。 注：左偏为-1，右偏为+1 中桩坐标 左边桩距桩号 XYXY 右边桩距左边桩距桩号 3082529.157519082.16815.000K718+210.000 3082514.444519085.088 3082529.157519082.168K718+210.000 23.0003082529.157519082.168 3082529.157519082.168K718+210.000 19.0003082529.157519082.168 3082529.157519082.168K718+210.000 22.0003082529.157519082.168 圆曲线 3082462.639518734.64920.000K718+563.833 3082442.953518738.184 K718+563.833 3098858.181526276.8982.850K144+480.000 2.8503098859.624526279.356 3098857.314526277.40722.000K144+481.006 3098868.449526296.381 3098840.924526287.00725.000K144+500.000 10.1503098853.541526308.590 3098857.923526277.05020.000K144+480.300 10.1503098868.047526294.298 3085021.519524045.99724.000K228+790.000 23.0003085003.480524061.827 3098806.615526306.98129.000K144+539.700 10.1503098821.160526332.070 3084897.438523902.11229.000K228+980.000 3084875.314523920.860 3084856.847523853.932K229+043.000 25.0003084856.847523853.932 3084845.941523840.89123.000K229+060.000 22.0003084828.286523855.632 3084833.136523825.527K229+080.000 22.0003084833.136523825.527 3084820.359523810.141K229+100.000 26.0003084820.359523810.141 3084815.894523804.75027.000K229+107.000 3084795.095523821.966 3084807.610523794.73114.000K229+120.000 19.0003084796.815523803.645 3084801.246523787.01719.000K229+130.000 3084786.585523799.102 3084794.890523779.297K229+140.000 26.0003084794.890523779.297 3084782.197523763.84123.000K229+160.000 3084764.409523778.422 3084764.923523742.714K229+187.290 29.0003084764.923523742.714 3084706.633523670.62124.000K229+280.000 28.0003084687.907523685.632 3084610.543523549.00223.000K229+435.000 28.0003084592.396523563.133 3084525.093523437.81520.000K229+575.230 25.0003084509.158523449.901 3084525.093523437.81523.000K229+575.230 27.0003084506.767523451.714 3084514.831523424.26220.000K229+592.230 25.0003084498.877523436.323 3084514.831523424.2628.000K229+592.230 13.0003084508.449523429.087 3084487.442523387.8788.000K229+637.770 13.0003084481.041523392.676 3084487.442523387.87820.000K229+637.770 25.0003084471.439523399.873 3084477.257523374.26720.000K229+654.770 25.0003084461.235523386.237 3084477.257523374.26723.000K229+654.770 28.0003084458.832523388.033 3084462.180523354.03822.000K229+680.000 27.0003084444.525523367.165 3084451.452523339.58414.000K229+698.000 31.0003084440.203523347.919 3084438.371523321.89513.000K229+720.000 18.0003084427.911523329.614 XYXY 右边桩距左边桩距桩号 3084391.106523257.35114.000K229+800.000 3084379.780523265.582 3084379.363523241.162K229+820.000 21.0003084379.363523241.162 3084355.965523208.719K229+860.000 20.0003084355.965523208.719 3084344.310523192.46516.000K229+880.000 3084331.299523201.777 3084332.685523176.19122.000K229+900.000 26.0003084314.772523188.962 3084307.215523140.313K229+944.000 25.0003084307.215523140.313 3084303.753523135.41223.000K229+950.000 3084284.964523148.679 3098727.564526352.37422.000K144+630.857 22.0003098738.440526371.498 第二计算边缓和段 3082393.235518297.803K719+006.188 3082393.235518297.803 K719+006.188 # #13.000K144+634.411 # # # #13.000K144+654.331 19.000# # # #18.000K230+135.000 22.000# # # #18.000K230+157.380 22.000# # # #20.000K230+157.380 25.000# # # #20.000K230+174.380 25.000# # # #8.000K230+174.380 13.000# # # #8.000K230+214.000 13.000# # # #8.000K149+340.000 13.000# # 第二计算边直线段 3082342.109517891.009K719+416.188 3082342.109517891.009 K719+416.188 3149908.5691083888.5608.000K149+400.000 13.0003149900.6251083889.509 2990586.639-250735.4818.000K1493+500.000 13.0002990578.696-250734.533 3150457.2951088485.1818.000K144+770.743 13.0003150449.3511088486.129 3140270.0721003147.8278.000K230+714.000 13.0003140262.1291003148.776 3167617.5911232235.284 3167617.5911232235.284 3167617.5911232235.284 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 XYXY 右边桩距左边桩距桩号 42622.80 对应弦和切线方位角 XY 3082954.551521151.646 3082940.689521151.646 3082940.689521151.646 3082940.689521151.646 3082940.689521151.646 3178088.903999616.825 3082563.644519132.5770.0000.000 3082529.157519082.16856.16756.167 3082553.678519077.30056.16756.167 3082553.678519077.30056.16756.167 3082554.659519077.10656.16756.167 3082556.621519076.71656.16756.167 3082555.640519076.91156.16756.167 3082548.774519078.27456.16756.167 3082529.157519082.16856.16756.167 3082529.157519082.16856.16756.167 3082546.812519078.66356.16756.167 右边桩坐标 注:红块内的数据为需要输入的数,D、E、F栏内的数据为需要输入的数，其余均为自动计算值.在计算新的里程或加桩里程坐标时,一定要先将最右边的K、L两栏往下拖，再将X、Y值往下拖，计算才正确。 XY 3082529.157519082.16856.16756.167 3082551.716519077.69056.16756.167 3082547.793519078.46956.16756.167 3082550.736519077.88556.16756.167 3082462.639518734.6490.000409.994 3098856.739526274.440# 409.994 3098857.314526277.407# 409.994 3098835.802526278.245# 409.994 3098852.784526268.296# 409.994 3085038.807524030.827# 409.994 3098801.524526298.200# 409.994 3084897.438523902.112# 409.994 3084876.012523837.879# 409.994 3084862.828523826.790# 409.994 3084850.049523811.458# 409.994 3084840.377523793.549# 409.994 3084815.894523804.750# 409.994 3084822.261523782.633# 409.994 3084801.246523787.017# 409.994 3084814.968523762.779# 409.994 3084782.197523763.841# 409.994 3084787.397523724.386# 409.994 3084728.480523653.108# 409.994 3084632.635523531.799# 409.994 3084545.012523422.708# 409.994 3084546.606523421.499# 409.994 3084534.773523409.186# 409.994 3084525.201523416.422# 409.994 3084497.845523380.081# 409.994 3084507.447523372.884# 409.994 3084497.285523359.304# 409.994 3084499.688523357.509# 409.994 3084483.847523337.928# 409.994 3084476.359523321.128# 409.994 3084452.855523311.208# 409.994 XY 3084391.106523257.351# 409.994 3084396.373523228.847# 409.994 3084372.208523197.049# 409.994 3084344.310523192.465# 409.994 3084353.856523161.098# 409.994 3084327.629523125.881# 409.994 3084303.753523135.412# 409.994 3098716.688526333.250# 409.994 3082393.235518297.803410.000409.994 # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # 3082342.109517891.0090.0000.000 3149921.4771083887.019 2990599.547-250737.022 3150470.2031088483.640 3140282.9811003146.286 XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY XY 交点桩号 K713+630.241 交点坐标X 3083436.6700 交点坐标Y 523645.7504 曲线半径R 9000 曲线偏角 7.87083333375215.0 偏向 -1 缓和曲线长度L 530530 第一计算方位角A1 266.62363892663725.1 切线长度T 884.230884.230 曲线长度l 1766.348 直缓点桩号ZH K712+746.011 缓圆点桩号HY K713+276.011 曲中桩号QZ K713+629.185 圆缓点桩号YH K713+982.359 缓直点桩号HZ K714+512.359 第二计算方位角A2 258.7528056 XY 第一计算边直线段 3083295.400521180.2780.000K716+100.000 K716+100.000 3083291.215521180.2780.000K716+100.000 3083291.215521180.2780.000K716+100.000 3083291.215521180.2780.000K716+100.000 3083291.215521180.2780.000K716+100.000 3112021.9691008167.6030.000K228+265.899 第一计算边缓和段 3083488.746524528.44520.900K712+746.011 K712+746.011 3079969.974522729.8380.000K718+200.000 3079969.974522729.83820.000K718+200.000 3079969.974522729.83820.000K718+200.000 3079969.974522729.83824.000K718+200.000 3079969.974522729.838K718+200.000 3079969.974522729.83824.000K718+200.000 3079969.974522729.83815.000K718+200.000 3079969.974522729.83815.000K718+200.000 3079969.974522729.83823.000K718+200.000 3079969.974522729.838K718+200.000 3079969.974522729.83815.000K718+200.000 3079969.974522729.838K718+200.000 3079969.974522729.838K718+200.000 3079969.974522729.838K718+200.000 圆曲线 3083452.342523999.71720.000K713+276.011 K713+276.011 3083138.625527275.4512.850K144+480.000 3083138.903527274.48422.000K144+481.006 3083144.118527256.22025.000K144+500.000 3083138.708527275.16320.000K144+480.300 3065991.716521823.80824.000K228+790.000 3083154.895527218.01129.000K144+539.700 3065930.909522003.81129.000K228+980.000 3065911.587522063.775K229+043.000 3065906.445522079.97923.000K229+060.000 3065900.435522099.054K229+080.000 3065894.468522118.143K229+100.000 3065892.389522124.82827.000K229+107.000 3065888.543522137.24614.000K229+120.000 3065885.596522146.80219.000K229+130.000 3065882.660522156.361K229+140.000 3065876.820522175.48923.000K229+160.000 3065868.919522201.610K229+187.290 3065842.672522290.52724.000K229+280.000 3065800.840522439.77323.000K229+435.000 注:红块内的数据为需要输入的数,D、E、F栏内的数据为需要输入的数，其余均为自动计算值.在计算新的里程或加桩里程坐标时,一定要先将最右边的K、L两栏往下拖，再将X、Y值往下拖，计算才正确。 注：左偏为-1，右偏为+1 中桩坐标 左边桩距桩号 3065765.214522575.40120.000K229+575.230 3065765.214522575.40123.000K229+575.230 3065761.039522591.88020.000K229+592.230 3065761.039522591.8808.000K229+592.230 3065750.007522636.0648.000K229+637.770 3065750.007522636.06420.000K229+637.770 3065745.947522652.57220.000K229+654.770 3065745.947522652.57223.000K229+654.770 3065739.978522677.08622.000K229+680.000 3065735.762522694.58514.000K229+698.000 3065730.656522715.98413.000K229+720.000 3065712.530522793.90414.000K229+800.000 3065708.107522813.408K229+820.000 3065699.391522852.447K229+860.000 3065695.098522871.98116.000K229+880.000 3065690.849522891.52422.000K229+900.000 3065681.653522934.552K229+944.000 3065680.415522940.42323.000K229+950.000 3083179.001527130.10022.000K144+630.857 第二计算边缓和段 3083362.470523299.293K713+982.359 K713+982.359 3085203.443519536.57213.000K719+100.000 3085203.443519536.572K719+100.000 3085203.443519536.57218.000K719+100.000 3085203.443519536.57218.000K719+100.000 3085203.443519536.57220.000K719+100.000 3085203.443519536.57220.000K719+100.000 3085203.443519536.5728.000K719+100.000 3085203.443519536.5728.000K719+100.000 3085203.443519536.5728.000K719+100.000 第二计算边直线段 3083264.208522778.503K714+512.359 K714+512.359 3083096.723521936.2828.000K715+371.071 3083096.723521936.2828.000K715+371.071 3083096.723521936.2828.000K715+371.071 3083096.723521936.2828.000K715+371.071 3083096.723521936.2828.000K715+371.071 3082915.542521025.1948.000K716+300.000 3082901.680520955.4888.000K716+371.071 对应弦和切线方位角 XYXY 0.0003083295.400521180.2783083295.400521180.278 0.0003083291.215521180.2783083291.215521180.278 0.0003083291.215521180.2783083291.215521180.278 0.0003083291.215521180.2783083291.215521180.278 0.0003083291.215521180.2783083291.215521180.278 0.0003112021.9691008167.6033112021.9691008167.603 24.0003083467.883524529.6763083512.705524527.0320.0000.000 0.0003079969.974522729.8383079969.974522729.8385453.9893951.803 25.0003079989.962522729.1303079944.990522730.7225453.9893951.803 25.0003079989.962522729.1303079944.990522730.7225453.9893951.803 26.0003079993.959522728.9893079943.991522730.7575453.9893951.803 28.0003079969.974522729.8383079941.992522730.8285453.9893951.803 27.0003079993.959522728.9893079942.991522730.7925453.9893951.803 20.0003079984.965522729.3073079949.987522730.5455453.9893951.803 3079984.965522729.3073079969.974522729.8385453.9893951.803 3079992.960522729.0243079969.974522729.8385453.9893951.803 18.0003079969.974522729.8383079951.986522730.4745453.9893951.803 3079984.965522729.3073079969.974522729.8385453.9893951.803 23.0003079969.974522729.8383079946.989522730.6515453.9893951.803 19.0003079969.974522729.8383079950.986522730.5095453.9893951.803 22.0003079969.974522729.8383079947.988522730.6155453.9893951.803 3083432.420524001.4833083452.342523999.7170.000529.980 2.8503083135.886527274.6653083141.365527276.237# 529.980 3083117.755527268.4213083138.903527274.484# 529.980 10.1503083120.072527249.3813083153.881527258.997# 529.980 10.1503083119.483527269.6493083148.465527277.961# 529.980 23.0003066014.372521831.7293065970.005521816.218# 529.980 10.1503083126.966527210.2003083164.670527220.745# 529.980 3065958.480522012.8023065930.909522003.811# 529.980 25.0003065911.587522063.7753065887.765522056.191# 529.980 22.0003065928.375522086.9153065885.470522073.344# 529.980 22.0003065900.435522099.0543065879.445522092.467# 529.980 26.0003065894.468522118.1433065869.644522110.413# 529.980 3065918.174522132.8353065892.389522124.828# 529.980 19.0003065901.919522141.3783065870.389522131.637# 529.980 3065903.755522152.3903065885.596522146.802# 529.980 26.0003065882.660522156.3613065857.801522148.741# 529.980 3065898.825522182.1813065876.820522175.489# 529.980 29.0003065868.919522201.6103065841.148522193.257# 529.980 28.0003065865.725522297.2033065815.777522282.738# 529.980 28.0003065823.039522445.7903065773.815522432.449# 529.980 注:红块内的数据为需要输入的数,D、E、F栏内的数据为需要输入的数，其余均为自动计算值.在计算新的里程或加桩里程坐标时,一定要先将最右边的K、L两栏往下拖，再将X、Y值往下拖，计算才正确。 右边桩距 左边桩坐标右边桩坐标 25.0003065784.597522580.3