保捱科技网
您的当前位置:首页曲线要素计算、整桩号整桩距法(偏角法)、整桩号整桩距法(支距法)的excel公式表格

曲线要素计算、整桩号整桩距法(偏角法)、整桩号整桩距法(支距法)的excel公式表格

来源:保捱科技网
整桩号整桩距法(支距法)

桩距5

JD桩号3000

已知条件

半径R缓和曲线LS曲线偏角PJ直缓ZH3504533.45522871.21

缓圆HY

2916.21

主点桩号曲中QZ2996.838

计算过程

柱号支距柱号支距柱号支距(ZH-HY)2871.21287528802885202529002905291029152916.21结束

xy3.7908.790.0113.790.0318.790.0723.790.1428.790.2533.790.4138.780.6243.770.44.98

0.96

(HY-QZ)2916.2129202925293029352940294529502955296029652970297529802985299029952996.8375结束

x44.9848.7653.7558.7263.6968.6573.678.5483.4788.3993.398.18103.06107.92112.76117.58122.38124.14

y129.51129.78130.19130.67131.22131.85132.54133.31134.14135.05136.03137.07138.19139.37140.63141.95143.34143.87

(QZ-YH)2996.837530003005301030153020302530303035304030453050305530603065307030753077.465结束

x124.14121.11116.3111.47106.63101.7796.9287.0982.1777.2472.2967.3462.3857.452.4347.4444.98

圆缓YH缓直HZ3077.4653122.465支距

柱号y(YH-HZ)15.323077.46514.42308013.05308511.74309010.530959.3431008.2431057.2131106.2531155.3731204.553122.4653.8结束

3.132.521.991.521.130.96

变量

曲线要素

内移值P切线增长q切线长T曲线长L外距E切曲差D0.24122.497128.79251.25516.015

6.325

支距xy44.980.92.450.8137.460.5632.460.3627.460.2222.460.1217.460.0612.460.027.4602.460

0

说明填写桩距,已知条件是引用的曲线要素计算表中的结果。

因篇幅问题不能全部显示,请点此查看更多更全内容