说明:1、先根据ZY至QZ及QZ至YZ点间中桩的个数在表格之间内插出行数。
2、“蓝色”字体部分为每次要手工输入的内容。
57.29578
186********.466247
1937.41540753.387682
11951411.8411.810927
11921000
第二方案
18601080正切值弧度角度1937.415400.1682610.1666999.551172 11951411.8 5.790952 1.39980080.20261 119210000.0072850.0072850.417398转角方位角弧度
80.44882825109.0262317 1.40409691
189.4750680.10754248 3.30696359
269.5826025 4.70510394
Xi ZH1276.4690.000
280.000 3.531
290.00013.530
300.00023.522
HY1306.46929.970
QZ1310.61934.093
YH1314.76938.198
320.00024.757
330.00014.768
340.000 4.769
HZ1344.7690.000
HY1306.46929.970
QZ1
310.61934.093圆曲线段内
桩号缓和曲线段内圆曲
YH1314.76938.201
x y两点间距离
1860.0001080.000266.3531860.000
1916.0001340.400225.9151937.400
1770.0001512.800583.8031195.000
1195.0001411.800411.8111192.000
1192.0001000.0001555.913
圆曲线半径缓和曲线长切线角角度
150.00060.0000.20011.459
#DIV/0!#DIV/0!
#DIV/0!#DIV/0!
150.00050.0000.1679.549
300.000100.0000.1679.549
#DIV/0!#DIV/0!
#DIV/0!#DIV/0!
#DIV/0!#DIV/0!
#DIV/0!#DIV/0!
#DIV/0!#DIV/0!
第一方案
方位角度分秒1860.0001080.000正切值弧度
80.448828380.265581916.0001340.4000.2150540.211828 189.797395189.475061770.0001512.800-0.8468680.702673 269.582602269.345741195.0001411.800 5.693069 1.396918
1192.0001000.0000.0072850.007285
第二方案逐桩坐标
QD K0+000 X= 1860.000 Y= 1080.000
K0+050 X= 1868.296 Y= 1129.307
K0+100 X= 1876.593 Y= 1178.614
K0+150 X= 1884.889 Y= 1227.921
K0+200 X= 1893.186 Y= 1277.228
K0+250 X= 1901.482 Y= 1326.534
K0+280.3430 X= 1906.517 Y= 1356.457
圆曲线带缓和曲线
Yi ZH/HZ圆曲线R缓和曲线L
0.000276.46915030
0.002276.46915030
0.092276.46915030
0.483276.46915030
1.000276.46915030
1.475276.46915030
2.081276.46915030
0.563344.76915030
0.119344.76915030
0.004344.76915030
0.000344.76915030
HY切增值外移值
0.999306.46915030.00014.9950.25
1.471306.46915030.00014.9950.25
2.056306.46915030.00014.9950.25
1080.000466.4662471344.3841438.005
1540.000753.3876821195.0001411.800
1411.800411.8109271194.6791260.532
1000.000
内移值切增值转角弧度切线长曲线长
1.00029.960109.026 1.903241.756723345.430002
#DIV/0!#DIV/0!0.000#DIV/0!0.000000
#DIV/0!#DIV/0!0.000#DIV/0!0.000000
0.69424.97780.108 1.398151.665691259.721052
1.38949.9544
2.7620.746167.95042632
3.899561
#DIV/0!#DIV/0!0.000#DIV/0!0.000000
#DIV/0!#DIV/0!79.620 1.390#DIV/0!0.000000
#DIV/0!#DIV/0!0.000#DIV/0!0.000
#DIV/0!#DIV/0!0.000#DIV/0!0.000
#DIV/0!#DIV/0!0.000#DIV/0!0.000
0.0000.0000.000
角度方位角转角度分秒
12.13777.863 1.00052.39752.23492
40.260130.260 2.00052.397
80.038189.962 3.00059.70259.42072
0.417269.583 4.000-79.62079.37120
方位角度分秒
77.86377.51468
130.260130.15360
189.962189.57432
Y= 1080.000269.583269.34588
Y= 1129.307
Y= 1178.614
Y= 1227.921
Y= 1277.228
Y= 1326.534
Y= 1356.457
51.5350.30051.235 51.5350.65050.885 51.535 1.00050.535 51.535 1.08050.455 51.535 1.22050.315 51.535 1.43650.099 51.535 1.23050.305 51.535 1.48050.055 51.535 1.48850.047 51.535 1.51050.025 51.535 1.54049.995 51.535 1.54549.990 51.520 1.56049.960 51.520 1.51250.008 51.520 1.51350.007 51.520 1.55049.970 51.520 1.66749.853 51.520 1.66949.851 51.544 1.88449.660 51.544 1.70049.844 51.544 1.67049.874 51.544 1.62549.919 51.544 1.65549.889 51.544 1.66249.882
51.544 1.65049.894
51.544 1.64049.904 51.544 1.63049.914 51.544 1.15050.394 51.544 1.55049.994 51.544 1.51050.034 51.544 1.33050.214 51.544 1.37050.174 51.544 1.32050.224 51.544 1.15050.394 51.749 1.53050.219 51.749 1.54050.209 51.749 1.53050.219 51.749 1.54050.209 51.749 1.54050.209 51.749 1.51050.239 51.749 1.53050.219
151.665031
151.268340
外距切曲差110.113152138.083443
#DIV/0!#DIV/0!
#DIV/0!#DIV/0!
46.87274543.610331
23.66416112.001292
#DIV/0!#DIV/0!
#DIV/0!#DIV/0!
#DIV/0!#DIV/0!
#DIV/0!#DIV/0!
#DIV/0!#DIV/0!
0.0000.000