竖曲线高程计算excel表格.xls

《竖曲线高程计算excel表格.xls》由会员分享，可在线阅读，更多相关《竖曲线高程计算excel表格.xls（120页珍藏版）》请在三一文库上搜索。

1、竖竖 曲曲 线线 要要 素素 变坡点 编号 变坡点桩号 竖曲线桩号 变坡点高 程 HB 竖曲线要素 起点KQ终点KZ切线长T半径R QDK680+010.8762710.6826.37 BD1K680+614.476314.476914.47641.46030012000 BD2K681+620.4761459.7411781.21116.31160.73510000 BD3K682+123.4762002.5942244.35819.905120.88212000 竖 曲 线 高 程 计 算 墩墩号号里里程程桥桥宽宽 左左边边距距右右边边距距中中桩桩高高程程左左边边桩桩高高程程右右边边桩桩高

2、高程程 30K680+010.87615.526.37026.3726.37 31K680+061.17615.527.628 32K680+111.47615.528.885 33K680+161.77615.530.143 34K680+212.07615.531.400 35K680+262.37615.532.658 36K680+312.67615.533.915 37K680+362.97615.535.074 38K680+413.27615.536.023 39K680+463.57615.536.761 40K680+513.87615.537.288 41K680+564.

3、17615.537.605 42K680+614.47615.537.710 43K680+664.77615.537.605 44K680+715.07615.537.288 45K680+765.37615.536.761 46K680+815.67615.536.023 47K680+865.97615.535.074 48K680+916.27615.533.915 49K680+966.57615.532.658 50K681+016.87615.531.400 51K681+067.17615.530.143 52K681+117.47615.528.885 53K681+167.

4、77615.527.628 54K681+218.07615.526.370 55K681+268.37615.525.113 56K681+318.67615.523.855 57K681+368.97615.522.598 58K681+419.27615.521.340 59K681+469.57615.520.087 60K681+519.87615.519.006 61K681+570.17615.518.177 62K681+620.47615.517.602 63K681+670.77615.517.279 64K681+721.07615.517.210 65K681+771.

5、37615.517.393 66K681+821.67615.517.748 67K681+871.97615.518.108 68K681+922.27615.518.467 69K681+972.57615.518.827 70K682+022.87615.519.169 71K682+073.17615.519.338 72K682+123.47615.519.296 73K682+173.77615.519.044 74K682+224.07615.518.580 75K682+274.37615.517.943 76K682+324.67615.517.289 77K682+374.

6、97615.513.9970.50316.63616.98516.651 K682+375.12615.513.9970.50316.63416.98316.649 78 K682+38015.513.9970.50316.57016.91816.585 K682+38515.513.9970.50316.50516.85116.520 K682+39015.513.9970.50316.44016.78416.455 K682+39515.513.9970.50316.37516.71716.390 K682+40015.513.9970.50316.31016.65016.325 K682

7、+40515.513.9970.50316.24516.58316.260 K682+41015.513.9970.50316.18016.51516.195 K682+41515.513.9970.50316.11516.44816.130 K682+42015.513.9970.50316.05016.38116.065 K682+42515.513.9970.50315.98516.31416.000 79 K682+43015.513.9970.50315.92016.24715.934 K682+43515.513.9970.50315.85516.18015.869 K682+44

8、015.515.790 K682+44515.515.725 K682+45015.515.660 K682+45515.515.595 K682+46015.515.530 K682+46515.515.465 K682+47015.515.400 K682+47515.515.335 80 K682+48015.515.270 K682+48515.515.205 K682+49015.515.140 K682+49515.515.075 K682+50015.515.010 K682+50515.514.945 K682+51015.514.880 K682+51515.514.815

9、K682+52015.514.750 K682+52515.514.685 81 K682+53015.514.620 K682+53515.514.555 K682+54015.514.490 K682+54515.514.425 K682+55015.514.360 K682+55515.514.295 K682+56015.514.230 K682+56515.514.165 K682+57015.514.100 K682+57515.514.035 82 K682+58015.513.970 K682+58515.513.905 K682+59015.513.840 K682+5951

10、5.513.775 K682+60015.513.710 K682+60515.513.645 K682+61015.513.580 K682+61515.513.515 K682+62015.513.450 K682+62515.513.385 83 K682+63015.513.320 K682+63515.513.255 K682+64015.513.190 K682+64515.513.125 K682+65015.513.060 K682+65515.512.995 K682+66015.512.930 K682+66515.512.865 K682+67015.512.800 K6

11、82+67515.512.735 84 K682+68015.512.670 K682+68515.512.605 K682+69015.512.540 K682+69515.512.475 K682+70015.512.410 K682+70515.512.345 K682+71015.512.280 K6802+710.6815.512.271 80 坡度I (%) 坡度 (%) 坡度角 (%) 凹凸判别符 矢距E 0.0002.5%0 3.7502.5%-2.5%0.05-1 1.292-2.5%0.7147% 0.0321 0.6090.7147%-1.3%0.020-1 注注: :横

12、横坡坡按按里里程程增增大大方方向向, ,顺顺时时针针坡坡度度为为负负 竖竖 曲曲 线线 要要 素素 竖曲线要素 竖竖 曲曲 线线 要要 素素 变坡点 编号 变坡点桩号 竖曲线桩号变坡点高 程 HB 竖曲线要素 起点KQ终点KZ切线长T半径R矢距E QDK682+710.68012.4310.000 BD1K682+950.000279031109.320160100001.280 BD2K683+660.0003414390622.810246120002.522 BD3K684+325.162425643958.17669.3573000.329 竖竖 曲曲 线线 高高 程程 计计 算算 墩

13、墩号号里里程程桥桥宽宽左左边边距距右右边边距距中中桩桩高高程程横横坡坡度度 左左边边桩桩H H右右边边桩桩H H ZK682+710.68015.512.431-2.00%12.43112.431 ZK682+71515.512.375-2.00%12.37512.375 ZK682+72015.512.310-2.00%12.31012.310 ZK682+72515.512.245-2.00%12.24512.245 ZK682+73015.512.180-2.00%12.18012.180 ZK682+73515.512.115-2.00%12.11512.115 ZK682+74015

14、.512.050-2.00%12.05012.050 ZK682+74515.511.985-2.00%11.98511.985 ZK682+75015.511.920-2.00%11.92011.920 ZK682+75515.511.855-2.00%11.85511.855 ZK682+76015.511.790-2.00%11.79011.790 ZK682+76515.511.725-2.00%11.72511.725 ZK682+77015.511.660-2.00%11.66011.660 ZK682+77515.511.595-2.00%11.59511.595 ZK682+7

15、8015.511.530-2.00%11.53011.530 ZK682+78515.511.465-2.00%11.46511.465 ZK682+79015.511.400-2.00%11.40011.400 ZK682+79515.511.336-2.00%11.33611.336 ZK682+80015.511.275-2.00%11.27511.275 ZK682+80515.511.216-2.00%11.21611.216 ZK682+81015.511.160-2.00%11.16011.160 ZK682+81515.511.106-2.00%11.10611.106 ZK6

16、82+82015.511.055-2.00%11.05511.055 ZK682+82515.511.006-2.00%11.00611.006 ZK682+83015.510.960-2.00%10.96010.960 ZK682+83515.510.916-2.00%10.91610.916 ZK682+84015.510.875-2.00%10.87510.875 ZK682+84515.510.836-2.00%10.83610.836 ZK682+85015.510.800-2.00%10.80010.800 ZK682+85515.50510.766-2.00%10.76610.7

17、66 ZK682+86015.51010.735-2.00%10.73510.735 ZK682+86515.51510.706-2.00%10.70610.706 ZK682+87015.52010.680-2.00%10.68010.680 ZK682+87515.53010.656-2.00%10.65610.656 ZK682+88015.54010.635-2.00%10.63510.635 ZK682+88515.55510.616-2.00%10.61610.616 ZK682+89015.57010.600-2.00%10.60010.600 ZK682+89515.59010

18、.586-2.00%10.58610.586 ZK682+90015.61010.575-2.00%10.57510.575 ZK682+90515.63510.566-2.00%10.56610.566 ZK682+91015.66010.560-2.00%10.56010.560 ZK682+91515.69510.556-2.00%10.55610.556 ZK682+92015.73010.555-2.00%10.55510.555 ZK682+92515.77010.556-2.00%10.55610.556 ZK682+93015.81010.560-2.00%10.56010.5

19、60 ZK682+93515.86510.566-2.00%10.56610.566 ZK682+94015.92010.575-2.00%10.57510.575 ZK682+94515.98010.586-2.00%10.58610.586 ZK682+95016.04010.600-2.00%10.60010.600 ZK682+95516.11510.616-2.00%10.61610.616 ZK682+96016.19010.635-2.00%10.63510.635 ZK682+96516.27510.656-2.00%10.65610.656 ZK682+97016.36010

20、.680-2.00%10.68010.680 ZK682+97516.46010.706-2.00%10.70610.706 ZK682+98016.56010.735-2.00%10.73510.735 ZK682+98516.67210.766-2.00%10.76610.766 ZK682+99010.800-2.00%10.80010.800 ZK682+99510.836-2.00%10.83610.836 ZK683+00010.875-2.00%10.87510.875 ZK683+00510.916-2.00%10.91610.916 ZK683+01010.960-2.00%

21、10.96010.960 ZK683+01511.006-2.00%11.00611.006 ZK683+02011.055-2.00%11.05511.055 ZK683+02511.106-2.00%11.10611.106 ZK683+03011.160-2.00%11.16011.160 ZK683+03511.216-2.00%11.21611.216 ZK683+04011.275-2.00%11.27511.275 ZK683+04511.336-2.00%11.33611.336 ZK683+05011.400-2.00%11.40011.400 ZK683+05511.466

22、-2.00%11.46611.466 ZK683+06011.535-2.00%11.53511.535 ZK683+06511.606-2.00%11.60611.606 ZK683+07011.680-2.00%11.68011.680 ZK683+07511.756-2.00%11.75611.756 ZK683+08011.835-2.00%11.83511.835 ZK683+08511.916-2.00%11.91611.916 ZK683+09012.000-2.00%12.00012.000 ZK683+09512.086-2.00%12.08612.086 ZK683+100

23、12.175-2.00%12.17512.175 ZK683+10512.266-2.00%12.26612.266 ZK683+11012.360-2.00%12.36012.360 ZK683+11512.455-2.00%12.45512.455 ZK683+12012.550-2.00%12.55012.550 ZK683+12512.645-2.00%12.64512.645 ZK683+13012.740-2.00%12.74012.740 ZK683+13512.835-2.00%12.83512.835 ZK683+14012.930-2.00%12.93012.930 ZK6

24、83+14513.025-2.00%13.02513.025 ZK683+15013.120-2.00%13.12013.120 ZK683+15513.215-2.125%13.21513.215 ZK683+16023.13013.310-2.250%13.31013.310 ZK683+16523.29513.405-2.375%13.40513.405 0ZK683+168.20023.40513.466-2.455%13.46613.466 ZK683+169.02023.40513.481-2.476%13.48113.481 1 ZK683+17023.46013.500-2.5

25、00%13.50013.500 ZK683+17523.63013.595-2.625%13.59513.595 ZK683+18023.80013.690-2.750%13.69013.690 ZK683+18523.96513.785-2.875%13.78513.785 ZK683+19024.13013.880-3.00%13.88013.880 ZK683+193.20024.19713.941-3.00%13.94113.941 2 ZK683+19524.23513.975-3.00%13.97513.975 ZK683+20024.34014.070-3.00%14.07014

26、.070 ZK683+20524.44514.165-3.00%14.16514.165 ZK683+21024.55014.260-3.00%14.26014.260 ZK683+21524.51714.355-3.00%14.35514.355 ZK683+218.17024.50014.415-3.00%14.41514.415 ZK683+218.26012.2514.417-3.00%14.41714.417 3 ZK683+22012.2514.450-3.00%14.45014.450 ZK683+22512.2514.545-3.00%14.54514.545 ZK683+23

27、012.2514.640-3.00%14.64014.640 ZK683+23512.2514.735-3.00%14.73514.735 ZK683+24012.2514.830-3.00%14.83014.830 ZK683+24512.2514.925-3.00%14.92514.925 ZK683+25012.2515.020-3.00%15.02015.020 ZK683+25512.2515.115-3.00%15.11515.115 ZK683+26012.2515.210-3.00%15.21015.210 ZK683+26412.2515.286-3.00%15.28615.

28、286 4 ZK683+26512.2515.305-3.00%15.30515.305 ZK683+27012.2515.400-3.00%15.40015.400 ZK683+27512.2515.495-3.00%15.49515.495 ZK683+28012.2515.590-3.00%15.59015.590 ZK683+28512.2515.685-3.00%15.68515.685 ZK683+29012.2515.780-3.00%15.78015.780 ZK683+29512.2515.875-3.00%15.87515.875 ZK683+30012.2515.970-

29、3.00%15.97015.970 ZK683+30512.2516.065-3.00%16.06516.065 ZK683+307.83012.2516.119-3.00%16.11916.119 5 ZK683+31012.2516.160-3.00%16.16016.160 ZK683+31512.2516.255-3.00%16.25516.255 ZK683+32012.2516.350-3.00%16.35016.350 ZK683+32512.2516.445-3.00%16.44516.445 ZK683+33012.2516.540-3.00%16.54016.540 ZK6

30、83+33512.2516.635-3.00%16.63516.635 ZK683+34012.2516.730-3.00%16.73016.730 ZK683+34512.2516.825-3.00%16.82516.825 ZK683+34812.2516.882-3.00%16.88216.882 6 ZK683+35012.2516.920-3.00%16.92016.920 ZK683+35512.2517.015-3.00%17.01517.015 ZK683+36012.2517.110-3.00%17.11017.110 ZK683+36512.2517.205-3.00%17

31、.20517.205 ZK683+37012.2517.300-3.00%17.30017.300 ZK683+37512.2517.395-3.00%17.39517.395 ZK683+38012.2517.490-3.00%17.49017.490 ZK683+38512.2517.585-3.00%17.58517.585 ZK683+39012.2517.680-3.00%17.68017.680 ZK683+393.74012.2517.751-3.00%17.75117.751 ZK683+39512.2517.775-3.00%17.77517.775 ZK683+40012.

32、2517.870-3.00%17.87017.870 ZK683+40512.2517.965-3.00%17.96517.965 ZK683+41012.2518.060-3.00%18.06018.060 ZK683+41512.2518.155-3.00%18.15518.155 ZK683+42012.2518.249-3.00%18.24918.249 ZK683+42512.2518.340-3.00%18.34018.340 ZK683+43012.2518.429-3.00%18.42918.429 ZK683+43512.2518.517-3.00%18.51718.517

33、ZK683+44012.2518.602-3.00%18.60218.602 ZK683+44512.2518.685-3.00%18.68518.685 ZK683+45012.2518.766-3.00%18.76618.766 ZK683+45512.2518.845-3.00%18.84518.845 ZK683+46012.2518.922-3.00%18.92218.922 ZK683+46512.2518.997-3.00%18.99718.997 ZK683+47012.2519.069-3.00%19.06919.069 ZK683+47512.2519.140-3.00%1

34、9.14019.140 ZK683+48012.2519.209-3.00%19.20919.209 ZK683+48512.2519.275-3.00%19.27519.275 ZK683+49012.2519.339-3.00%19.33919.339 ZK683+49512.2519.402-3.00%19.40219.402 ZK683+50012.2519.462-3.00%19.46219.462 ZK683+50512.2519.520-3.00%19.52019.520 ZK683+51012.2519.576-3.00%19.57619.576 ZK683+51512.251

35、9.630-3.00%19.63019.630 ZK683+52012.2519.682-3.00%19.68219.682 ZK683+52512.2519.732-3.00%19.73219.732 ZK683+53012.2519.779-3.00%19.77919.779 ZK683+53512.2519.825-3.00%19.82519.825 ZK683+54012.2519.869-3.00%19.86919.869 ZK683+54512.2519.910-3.00%19.91019.910 ZK683+55012.2519.949-3.00%19.94919.949 ZK6

36、83+55512.2519.987-3.00%19.98719.987 ZK683+56012.2520.022-3.00%20.02220.022 ZK683+56512.2520.055-3.00%20.05520.055 ZK683+57012.2520.086-3.00%20.08620.086 ZK683+57512.2520.115-3.00%20.11520.115 ZK683+58012.2520.142-3.00%20.14220.142 ZK683+58512.2520.167-3.00%20.16720.167 ZK683+59012.2520.189-3.00%20.1

37、8920.189 ZK683+59512.2520.210-3.00%20.21020.210 ZK683+60012.2520.229-3.00%20.22920.229 ZK683+60512.2520.245-3.00%20.24520.245 ZK683+61012.2520.259-3.00%20.25920.259 ZK683+61512.2520.272-3.00%20.27220.272 ZK683+62012.2520.282-3.00%20.28220.282 ZK683+62512.2520.290-3.00%20.29020.290 ZK683+63012.2520.2

38、96-3.00%20.29620.296 ZK683+63512.2520.300-3.00%20.30020.300 ZK683+64012.2520.302-3.00%20.30220.302 ZK683+64512.2520.302-3.00%20.30220.302 ZK683+65012.2520.299-3.00%20.29920.299 ZK683+65512.2520.295-3.00%20.29520.295 ZK683+66012.2520.289-3.00%20.28920.289 ZK683+66512.2520.280-3.00%20.28020.280 ZK683+

39、67012.2520.269-3.00%20.26920.269 ZK683+67512.2520.257-3.00%20.25720.257 ZK683+68012.2520.242-3.00%20.24220.242 ZK683+68512.2520.225-3.00%20.22520.225 ZK683+69012.2520.206-3.00%20.20620.206 ZK683+69512.2520.185-3.00%20.18520.185 ZK683+70012.2520.162-3.00%20.16220.162 ZK683+70512.2520.137-3.00%20.1372

40、0.137 ZK683+71012.2520.109-3.00%20.10920.109 ZK683+71512.2520.080-3.00%20.08020.080 ZK683+72012.2520.049-3.00%20.04920.049 ZK683+72512.2520.015-3.00%20.01520.015 ZK683+73012.2519.979-3.00%19.97919.979 ZK683+73512.2519.942-3.00%19.94219.942 ZK683+74012.2519.902-3.00%19.90219.902 ZK683+74512.2519.860-

41、3.00%19.86019.860 ZK683+75012.2519.816-3.00%19.81619.816 ZK683+75512.2519.770-3.00%19.77019.770 ZK683+76012.2519.722-3.00%19.72219.722 ZK683+76512.2519.672-3.00%19.67219.672 ZK683+77012.2519.619-3.00%19.61919.619 ZK683+77512.2519.565-3.00%19.56519.565 ZK683+78012.2519.509-3.00%19.50919.509 ZK683+785

42、12.2519.450-3.00%19.45019.450 ZK683+79012.2519.389-3.00%19.38919.389 ZK683+79512.2519.327-3.00%19.32719.327 ZK683+80012.2519.262-3.00%19.26219.262 ZK683+80512.2519.195-3.00%19.19519.195 ZK683+81012.2519.126-3.00%19.12619.126 ZK683+81512.2519.055-3.00%19.05519.055 ZK683+82012.2518.982-3.00%18.98218.9

43、82 ZK683+82512.2518.907-3.00%18.90718.907 ZK683+83012.2518.829-3.00%18.82918.829 ZK683+83512.2518.750-3.00%18.75018.750 ZK683+84012.2518.669-3.00%18.66918.669 ZK683+84512.2518.585-3.00%18.58518.585 ZK683+85012.2518.499-3.00%18.49918.499 ZK683+85512.2518.412-3.00%18.41218.412 ZK683+86012.2518.322-3.0

44、0%18.32218.322 ZK683+86512.2518.230-3.00%18.23018.230 ZK683+87012.2518.136-3.00%18.13618.136 ZK683+87512.2518.040-3.00%18.04018.040 ZK683+88012.2517.942-3.00%17.94217.942 ZK683+88512.2517.842-3.00%17.84217.842 ZK683+89012.2517.739-3.00%17.73917.739 ZK683+89512.2517.635-3.00%17.63517.635 ZK683+90012.

45、2517.529-3.00%17.52917.529 ZK683+90512.2517.420-3.00%17.42017.420 ZK683+91012.2517.310-3.00%17.31017.310 ZK683+91512.2517.200-3.00%17.20017.200 ZK683+92012.2517.090-3.00%17.09017.090 ZK683+92512.2516.980-3.00%16.98016.980 ZK683+93012.2516.870-3.00%16.87016.870 ZK683+93512.2516.760-3.00%16.76016.760

46、ZK683+94012.2516.650-3.00%16.65016.650 ZK683+94512.2516.540-3.00%16.54016.540 20ZK683+948.70012.2516.458-3.00%16.45816.458 ZK683+95012.2516.430-3.00%16.43016.430 ZK683+95512.2516.320-3.00%16.32016.320 ZK683+96012.2516.210-3.00%16.21016.210 ZK683+96512.2516.100-3.00%16.10016.100 ZK683+97012.2515.990-

47、3.00%15.99015.990 ZK683+97512.2515.880-3.00%15.88015.880 ZK683+98012.2515.770-3.00%15.77015.770 ZK683+98512.2515.660-3.00%15.66015.660 ZK683+99012.2515.550-3.00%15.55015.550 ZK683+99512.2515.440-3.00%15.44015.440 21ZK683+988.70012.2515.578-3.00%15.57815.578 ZK684+00012.2515.330-3.00%15.33015.330 ZK6

48、84+00512.2515.220-3.00%15.22015.220 ZK684+01012.2515.110-3.00%15.11015.110 ZK684+01512.2515.000-3.00%15.00015.000 ZK684+02012.2514.890-3.00%14.89014.890 ZK684+02512.2514.780-3.00%14.78014.780 ZK684+03012.2514.670-3.00%14.67014.670 ZK684+03512.2514.560-3.00%14.56014.560 ZK684+04012.2514.450-3.00%14.4

49、5014.450 ZK684+04512.2514.340-3.00%14.34014.340 ZK684+05012.2514.230-3.00%14.23014.230 22ZK684+054.70012.2514.126-3.00%14.12614.126 ZK684+05512.2514.120-3.00%14.12014.120 ZK684+06012.2514.010-3.00%14.01014.010 ZK684+06512.2513.900-3.00%13.90013.900 ZK684+07012.2513.790-3.00%13.79013.790 ZK684+07512.2513.680-3.00%13.68013.680 ZK684+08012.2513.570-3.00%13.57013.570 ZK684+08512.2513.460-3.00%13.46013.460 ZK684+09012.2513.350-3.00%13.35013.350 23ZK684+094.70012.2513.246-3.00%13.24613.246 ZK684+09512.2513.240-3.00%13.24013.240 ZK684+10012.2513.130-2.