竖曲线超高改正值（Excel模板）

1、凹型竖曲线-小桩号（前坡）变坡点桩号变坡点高程ri1i2tle竖曲线起点416.922240.648150002.374%3.200%61.950123.90.128354.970416.922240.648150002.374%3.200%61.95123.90.128354.970416.922240.648150002.374%3.200%61.95123.90.128354.970416.922240.648150002.374%3.200%61.95123.90.128354.970416.922240.648150002.374%3.200%61.95123.90.128354.9

2、70416.922240.648150002.374%3.200%61.95123.90.128354.970416.922240.648150002.374%3.200%61.95123.90.128354.970416.922240.648150002.374%3.200%61.95123.90.128354.970416.922240.648150002.374%3.200%61.95123.90.128354.970416.922240.648150002.374%3.200%61.95123.90.128354.970凹型竖曲线-大桩号（后坡）变坡点桩号变坡点高程ri1i2tle竖曲

3、线起点124102.532240.7915000-0.75%0.789%115.725231.450.446123986.805124102.532240.7915000-0.75%0.789%115.725231.450.446123986.805124102.532240.7915000-0.75%0.789%115.725231.450.446123986.805124102.532240.7915000-0.75%0.789%115.725231.450.446123986.805124102.532240.7915000-0.75%0.789%115.725231.450.44612

4、3986.805124102.532240.7915000-0.75%0.789%115.725231.450.446123986.805124102.532240.7915000-0.75%0.789%115.725231.450.446123986.805凸型竖曲线-前坡变坡点桩号变坡点高程ri1i2tle竖曲线起点55530.4426630002.439%-2.58%75.23150.450.94355455.215凸型竖曲线-前坡变坡点桩号变坡点高程ri1i2tle竖曲线起点5200134.393200000.000%-0.82%82.400164.80.1705117.6005200

5、134.393200000.00%-0.82%82.400164.80.1705117.6005200134.393200000.00%-0.82%82.400164.80.1705117.6005200134.393200000.00%-0.82%82.400164.80.1705117.6005200134.393200000.00%-0.82%82.400164.80.1705117.6005200134.393200000.00%-0.82%82.400164.80.1705117.6005200134.393200000.00%-0.82%82.400164.80.1705117.6

6、005200134.393200000.00%-0.82%82.400164.80.1705117.6005200134.393200000.00%-0.82%82.400164.80.1705117.6005200134.393200000.00%-0.82%82.400164.80.1705117.6005200134.393200000.00%-0.82%82.400164.80.1705117.6005200134.393200000.00%-0.82%82.400164.80.1705117.6005200134.393200000.00%-0.82%82.400164.80.170

7、5117.6005200134.393200000.00%-0.82%82.400164.80.1705117.6005200134.393200000.00%-0.82%82.400164.80.1705117.6005200134.393200000.00%-0.82%82.400164.80.1705117.6005200134.393200000.00%-0.82%82.400164.80.1705117.6005200134.393200000.00%-0.82%82.400164.80.1705117.6005200134.393200000.00%-0.82%82.400164.

8、80.1705117.6005200134.393200000.00%-0.82%82.400164.80.1705117.6005200134.393200000.00%-0.82%82.400164.80.1705117.6005200134.393200000.00%-0.82%82.400164.80.1705117.6005200134.393200000.00%-0.82%82.400164.80.1705117.600凸型竖曲线-后坡变坡点桩号变坡点高程ri1i2tle竖曲线起点4100134.393120001.398%0.00%83.880167.760.2934016.12

9、04100134.393120001.398%0.00%83.880167.760.2934016.1204100134.393120001.398%0.00%83.880167.760.2934016.1204100134.393120001.398%0.00%83.880167.760.2934016.1204100134.393120001.398%0.00%83.880167.760.2934016.1204100134.393120001.398%0.00%83.880167.760.2934016.1204100134.393120001.398%0.00%83.880167.76

10、0.2934016.1204100134.393120001.398%0.00%83.880167.760.2934016.1204100134.393120001.398%0.00%83.880167.760.2934016.1204100134.393120001.398%0.00%83.880167.760.2934016.1204100134.393120001.398%0.00%83.880167.760.2934016.1204100134.393120001.398%0.00%83.880167.760.2934016.1204100134.393120001.398%0.00%

11、83.880167.760.2934016.1204100134.393120001.398%0.00%83.880167.760.2934016.1204100134.393120001.398%0.00%83.880167.760.2934016.1204100134.393120001.398%0.00%83.880167.760.2934016.1204100134.393120001.398%0.00%83.880167.760.2934016.1204100134.393120001.398%0.00%83.880167.760.2934016.1204100134.3931200

12、01.398%0.00%83.880167.760.2934016.1204100134.393120001.40%0.00%83.880167.760.2934016.1204100134.393120001.40%0.00%83.880167.760.2934016.1204100134.393120001.40%0.00%83.880167.760.2934016.1204100134.393120001.40%0.00%83.880167.760.2934016.120凸型竖曲线-后坡-直坡上变坡点桩号变坡点高程ri1i2tle竖曲线起点55530.4426630001.398%-2.

13、576%59.610119.220.59255470.83055530.4426630001.40%-2.58%59.610119.220.59255470.83055530.4426630001.40%-2.58%59.610119.220.59255470.83055530.4426630001.40%-2.58%59.610119.220.59255470.83055530.4426630001.40%-2.58%59.610119.220.59255470.83055530.4426630001.40%-2.58%59.610119.220.59255470.83055530.4426

14、630001.40%-2.58%59.610119.220.59255470.830前坡竖曲线终点米数待求桩号变坡点桩号y改正前高程改正后高程478.870-79.970275.000416.9200.0002237.2792237.279478.870-78.970276.000416.9200.2082237.3032237.510478.870-77.970277.000416.9200.2032237.3262237.529478.870-76.970278.000416.9200.1972237.3502237.548478.870-75.970279.000416.9200.192

15、2237.3742237.566478.870-74.970280.000416.9200.1872237.3982237.585478.870-73.970281.000416.9200.1822237.4212237.604478.870-72.970282.000416.9200.1772237.4452237.622478.870-71.970283.000416.9200.1732237.4692237.641478.870-70.970284.000416.9200.1682237.4922237.660后坡竖曲线终点_x待求桩号变坡点桩号y改正前高程改正后高程124218.255

16、104.505124113.750124102.5300.3642240.8792241.243124218.25589.505124128.750124102.5300.2672240.9972241.264124218.25574.505124143.750124102.5300.1852241.1152241.300124218.25559.505124158.750124102.5300.1182241.2342241.352124218.25544.505124173.750124102.5300.0662241.3522241.418124218.25535.505124182.7

17、50124102.5300.0422241.4232241.465124218.25525.785124192.470124102.5300.0222241.5002241.522前坡竖曲线终点米数_x待求桩号变坡点桩号y改正前高程改正后高程55605.6655.47555460.69055530.4400.005264.299264.2941前坡竖曲线终点米数_x待求桩号变坡点桩号y改正前高程改正后高程5282.40057.60050605200.000134.393134.3935282.40017.60051005200.000134.393134.3935282.4007.600511

18、05200.000134.393134.3935282.4004.0405113.565200.000134.393134.3935282.40022.40051405200.0000.013134.393134.3805282.40032.40051505200.0000.026134.393134.3675282.40039.40051575200.0000.039134.393134.3545282.40044.40051625200.0000.049134.393134.3445282.40067.40051855200.0000.114134.393134.2795282.40075

19、.40051935200.0000.142134.393134.2515282.40081.40051995200.0000.166134.393134.2275282.40082.40052005200.0000.170134.393134.2235282.40050320.62755438.2275200.00063304.138134.393-63169.745凹型竖曲线-小桩号（前坡）凹型竖曲线-大桩号（后坡）凸型竖曲线-前坡凸型竖曲线-前坡5282.40050329.84155447.4415200.00063327.322134.393-63192.9295282.40050337

20、.10055454.7005200.00063345.591134.393-63211.1985282.40050329.55055447.1505200.00063326.590134.393-63192.1975282.40050322.35055439.9505200.00063308.473134.393-63174.0805282.40050315.40055433.0005200.00063290.987134.393-63156.5945282.40050308.80055426.4005200.00063274.384134.393-63139.9915282.40050302

21、.35055419.9505200.00063258.160134.393-63123.7675282.40050296.15055413.7505200.00063242.568134.393-63108.1755282.40050290.10055407.7005200.00063227.354134.393-63092.9615282.40050338.90055456.5005200.00063350.121134.393-63215.728后坡竖曲线终点米数_x待求桩号变坡点桩号y改正前高程改正后高程4183.880183.88040004100.0001.409134.393132

22、.9844183.880133.88040504100.0000.747134.393133.6464183.88090.88040934100.0000.344134.393134.0494183.88083.88041004100.0000.293134.393134.1004183.88081.1204102.764100.0000.274134.393134.1194183.88076.3804107.54100.0000.243134.393134.1504183.88072.88041114100.0000.221134.393134.1724183.88053.880413041

23、00.0000.121134.393134.2724183.88033.88041504100.0000.048134.393134.3454183.88012.88041714100.0000.007134.393134.3864183.88080.3204103.564100.0000.269134.393134.1244183.88077.4404106.444100.0000.250134.393134.1434183.88074.0174109.8634100.0000.228134.393134.1654183.88078.1064105.7744100.0000.254134.3

24、93134.1394183.8803.88041804100.0000.001134.393134.3924183.8803.88041804100.0000.001134.393134.3924183.88033.88041504100.0000.048134.393134.3454183.88033.88041504100.0000.048134.393134.3454183.88033.88041504100.0000.048134.393134.3454183.88033.88041504100.0000.048134.393134.3454183.88033.88041504100.

25、0000.048134.393134.3454183.88033.88041504100.0000.048134.393134.3454183.88033.88041504100.0000.048134.393134.345后坡竖曲线终点米数_x待求桩号变坡点桩号y改正前高程改正后高程55590.05055611.73055530.4400.000263.906263.90655590.05055606.93055530.440264.030264.030凸型竖曲线-后坡凸型竖曲线-后坡-直坡上55590.05055611.7355530.440263.906263.90655590.0505

26、5626.7355530.440263.520263.52055590.05055641.7355530.440263.133263.13355590.05055653.7355530.440262.824262.82455590.05055665.155530.440262.531262.531桩号外边缘标高275.0002237.094276.0002237.325277.0002237.344278.0002237.363279.0002237.381280.0002237.400281.0002237.419282.0002237.437283.0002237.456284.00022

27、37.475桩号124113.7502241.058124128.7502241.079124143.7502241.115124158.7502241.167124173.7502241.233124182.7502241.280124192.4702241.33755419.95055426.400桩号55447.15055460.69055454.70055439.95055433.00055413.750桩号5060.000134.5785100.000134.578134.28850356.5005110.000134.578134.28850346.5005113.560134.5

28、78134.28850342.9405140.000134.565134.27550316.5005150.000134.552134.26250306.5005157.000134.539134.24950299.5005162.000134.529134.23950294.5005185.000134.464134.17450271.5005193.000134.436134.146 5199.000134.412134.1225200.000134.408134.11855438.227(63169.560)(63169.850)凹型竖曲线-大桩号（后坡）凸型竖曲线-前坡凸型竖曲线-前坡

29、55447.441(63192.744)(63193.034)55454.700(63211.013)(63211.303)1.80055447.150(63192.012)(63192.302)9.35055439.950(63173.895)(63174.185)16.55055433.000(63156.409)(63156.699)23.50055426.400(63139.806)(63140.096)30.10055419.950(63123.582)(63123.872)36.55055413.750(63107.990)(63108.280)42.75055407.700(63

30、092.776)(63093.066)48.80055456.500(63215.543)(63215.833)0.000桩号路面边沿高程4000.000132.8494050.000133.5114093.000133.9144100.000133.9654102.760133.9844107.500134.0454111.000134.0674130.000134.1674150.000134.2404171.000134.2814103.560134.0194106.440134.0384109.863134.0304105.774134.0344180.000134.2874180.0

31、00134.2874150.000134.2404150.000134.2404150.000134.2404150.000134.2404150.000134.2404150.000134.2404150.000134.240桩号55611.730264.09155606.930264.215凸型竖曲线-后坡凸型竖曲线-后坡-直坡上55611.730264.09155626.730263.70555641.730263.31855653.730263.00955665.100262.716凹型竖曲线-小桩号（前坡）变坡点桩号变坡点高程ri1i2tle竖曲线起点416.922240.64815

32、0002.374%3.200%61.950123.90.128354.970416.922240.648150002.374%3.200%61.95123.90.128354.970416.922240.648150002.374%3.200%61.95123.90.128354.970416.922240.648150002.374%3.200%61.95123.90.128354.970416.922240.648150002.374%3.200%61.95123.90.128354.970416.922240.648150002.374%3.200%61.95123.90.128354.

33、970416.922240.648150002.374%3.200%61.95123.90.128354.970416.922240.648150002.374%3.200%61.95123.90.128354.970416.922240.648150002.374%3.200%61.95123.90.128354.970416.922240.648150002.374%3.200%61.95123.90.128354.970凹型竖曲线-大桩号（后坡）变坡点桩号变坡点高程ri1i2tle竖曲线起点124102.532240.7915000-0.75%0.789%115.725231.450.4

34、46123986.805124102.532240.7915000-0.75%0.789%115.725231.450.446123986.805124102.532240.7915000-0.75%0.789%115.725231.450.446123986.805124102.532240.7915000-0.75%0.789%115.725231.450.446123986.805124102.532240.7915000-0.75%0.789%115.725231.450.446123986.805124102.532240.7915000-0.75%0.789%115.725231.

35、450.446123986.805124102.532240.7915000-0.75%0.789%115.725231.450.446123986.805凸型竖曲线-前坡变坡点桩号变坡点高程ri1i2tle竖曲线起点55530.4426630002.439%-2.58%75.23150.450.94355455.215凸型竖曲线-前坡变坡点桩号变坡点高程ri1i2tle竖曲线起点5200134.393200000.000%-0.82%82.400164.80.1705117.6005200134.393200000.00%-0.82%82.400164.80.1705117.60052001

36、34.393200000.00%-0.82%82.400164.80.1705117.6005200134.393200000.00%-0.82%82.400164.80.1705117.6005200134.393200000.00%-0.82%82.400164.80.1705117.6005200134.393200000.00%-0.82%82.400164.80.1705117.6005200134.393200000.00%-0.82%82.400164.80.1705117.6005200134.393200000.00%-0.82%82.400164.80.1705117.60

37、05200134.393200000.00%-0.82%82.400164.80.1705117.6005200134.393200000.00%-0.82%82.400164.80.1705117.6005200134.393200000.00%-0.82%82.400164.80.1705117.6005200134.393200000.00%-0.82%82.400164.80.1705117.6005200134.393200000.00%-0.82%82.400164.80.1705117.6005200134.393200000.00%-0.82%82.400164.80.1705

38、117.6005200134.393200000.00%-0.82%82.400164.80.1705117.6005200134.393200000.00%-0.82%82.400164.80.1705117.6005200134.393200000.00%-0.82%82.400164.80.1705117.6005200134.393200000.00%-0.82%82.400164.80.1705117.6005200134.393200000.00%-0.82%82.400164.80.1705117.6005200134.393200000.00%-0.82%82.400164.8

39、0.1705117.6005200134.393200000.00%-0.82%82.400164.80.1705117.6005200134.393200000.00%-0.82%82.400164.80.1705117.6005200134.393200000.00%-0.82%82.400164.80.1705117.600凸型竖曲线-后坡变坡点桩号变坡点高程ri1i2tle竖曲线起点5200134.393200000.00%-0.82%82.400164.80.1705117.6005200134.393200000.000%-0.82%82.400164.80.1705117.600

40、5200134.393200000.000%-0.82%82.400164.80.1705117.6005200134.393200000.000%-0.82%82.400164.80.1705117.6005200134.393200000.000%-0.82%82.400164.80.1705117.6005200134.393200000.000%-0.82%82.400164.80.1705117.6005200134.393200000.000%-0.82%82.400164.80.1705117.6005200134.393200000.000%-0.82%82.400164.80

41、.1705117.6005200134.393200000.000%-0.82%82.400164.80.1705117.6005200134.393200000.000%-0.82%82.400164.80.1705117.6005200134.393200000.000%-0.82%82.400164.80.1705117.6005200134.393200000.000%-0.82%82.400164.80.1705117.6005200134.393200000.000%-0.82%82.400164.80.1705117.6005200134.393200000.000%-0.82%

42、82.400164.80.1705117.6005200134.393200000.000%-0.82%82.400164.80.1705117.6005200134.393200000.000%-0.82%82.400164.80.1705117.6005200134.393200000.000%-0.82%82.400164.80.1705117.6005200134.393200000.000%-0.82%82.400164.80.1705117.6005200134.393200000.000%-0.82%82.400164.80.1705117.6005200134.39320000

43、0.00%-0.82%82.400164.80.1705117.6005200134.393200000.00%-0.82%82.400164.80.1705117.6005200134.393200000.00%-0.82%82.400164.80.1705117.6005200134.393200000.00%-0.82%82.400164.80.1705117.600凸型竖曲线-后坡-直坡上变坡点桩号变坡点高程ri1i2tle竖曲线起点55530.4426630000.000%-2.576%38.64077.280.24955491.80055530.4426630000.00%-2.5

44、8%38.64077.280.24955491.80055530.4426630000.00%-2.58%38.64077.280.24955491.80055530.4426630000.00%-2.58%38.64077.280.24955491.80055530.4426630000.00%-2.58%38.64077.280.24955491.80055530.4426630000.00%-2.58%38.64077.280.24955491.80055530.4426630000.00%-2.58%38.64077.280.24955491.800前坡竖曲线终点米数待求桩号变坡点桩号

45、y改正前高程改正后高程478.870-79.970275.000416.9200.0002237.2792237.279478.870-78.970276.000416.9200.2082237.3032237.510478.870-77.970277.000416.9200.2032237.3262237.529478.870-76.970278.000416.9200.1972237.3502237.548478.870-75.970279.000416.9200.1922237.3742237.566478.870-74.970280.000416.9200.1872237.398223

46、7.585478.870-73.970281.000416.9200.1822237.4212237.604478.870-72.970282.000416.9200.1772237.4452237.622478.870-71.970283.000416.9200.1732237.4692237.641478.870-70.970284.000416.9200.1682237.4922237.660后坡竖曲线终点_x待求桩号变坡点桩号y改正前高程改正后高程124218.255104.505124113.750124102.5300.3642240.8792241.243124218.25589

47、.505124128.750124102.5300.2672240.9972241.264124218.25574.505124143.750124102.5300.1852241.1152241.300124218.25559.505124158.750124102.5300.1182241.2342241.352124218.25544.505124173.750124102.5300.0662241.3522241.418124218.25535.505124182.750124102.5300.0422241.4232241.465124218.25525.785124192.4701

48、24102.5300.0222241.5002241.522前坡竖曲线终点米数_x待求桩号变坡点桩号y改正前高程改正后高程55605.6655.47555460.69055530.4400.005264.299264.2941前坡竖曲线终点米数_x待求桩号变坡点桩号y改正前高程改正后高程5282.40057.60050605200.000134.393134.3935282.40017.60051005200.000134.393134.3935282.4007.60051105200.000134.393134.3935282.4004.0405113.565200.000134.39313

49、4.3935282.40022.40051405200.0000.013134.393134.3805282.40032.40051505200.0000.026134.393134.3675282.40039.40051575200.0000.039134.393134.3545282.40044.40051625200.0000.049134.393134.3445282.40067.40051855200.0000.114134.393134.2795282.40075.40051935200.0000.142134.393134.2515282.40081.40051995200.00

50、00.166134.393134.2275282.40082.40052005200.0000.170134.393134.2235282.40067.1005184.7005200.0000.113134.393134.280凹型竖曲线-小桩号（前坡）凹型竖曲线-大桩号（后坡）凸型竖曲线-前坡凸型竖曲线-前坡5282.40050329.84155447.4415200.00063327.322134.393-63192.9295282.40050337.10055454.7005200.00063345.591134.393-63211.1985282.40050329.55055447.1

51、505200.00063326.590134.393-63192.1975282.40050322.35055439.9505200.00063308.473134.393-63174.0805282.40050315.40055433.0005200.00063290.987134.393-63156.5945282.40050308.80055426.4005200.00063274.384134.393-63139.9915282.40050302.35055419.9505200.00063258.160134.393-63123.7675282.40050296.15055413.7

52、505200.00063242.568134.393-63108.1755282.40050290.10055407.7005200.00063227.354134.393-63092.9615282.40050338.90055456.5005200.00063350.121134.393-63215.728后坡竖曲线终点米数_x待求桩号变坡点桩号y改正前高程改正后高程5282.40082.40052005200.0000.170134.393134.2235282.40078.0005204.45200.0000.152134.357134.2055282.40067.9005214.55

53、200.0000.115134.274134.1585282.40063.9005218.55200.0000.102134.241134.1385282.40053.40052295200.0000.071134.154134.0835282.40032.40052505200.0000.026133.981133.9555282.40029.40052535200.0000.022133.956133.9355282.4002.40052805200.0000.000133.734133.7345282.400-0.60052835200.0000.000133.709133.709528

54、2.400-7.60052905200.000133.651133.6515282.400-17.60053005200.000133.569133.5695282.400-67.60053505200.000133.157133.1575282.400-117.60054005200.000132.745132.7455282.400-130.60054135200.000132.638132.6385282.400-135.60054185200.000132.597132.5975282.400-167.60054505200.000132.333132.3335282.400-168.

55、7705451.175200.000132.323132.3235282.400-217.60055005200.000131.921131.9215282.400-238.7705521.175200.000131.747131.7475282.400-267.60055505200.000131.509131.5095282.400-317.60056005200.000131.097131.0975282.400-328.60056115200.000131.006131.0065282.400-356.60056395200.000130.776130.776后坡竖曲线终点米数_x待求

56、桩号变坡点桩号y改正前高程改正后高程55569.08055611.73055530.4400.000263.906263.90655569.08055606.93055530.440264.030264.030凸型竖曲线-后坡凸型竖曲线-后坡-直坡上55569.08055611.7355530.440263.906263.90655569.08055626.7355530.440263.520263.52055569.08055641.7355530.440263.133263.13355569.08055653.7355530.440262.824262.82455569.08055665.

57、155530.440262.531262.531桩号外边缘标高275.0002237.094276.0002237.325277.0002237.344278.0002237.363279.0002237.381280.0002237.400281.0002237.419282.0002237.437283.0002237.456284.0002237.475桩号124113.7502241.058124128.7502241.079124143.7502241.115124158.7502241.167124173.7502241.233124182.7502241.280124192.47

58、02241.33755419.95055426.400桩号55447.15055460.69055454.70055439.95055433.00055413.750桩号5060.000134.5785100.000134.578134.28850356.5005110.000134.578134.28850346.5005113.560134.578134.28850342.9405140.000134.565134.27550316.5005150.000134.552134.26250306.5005157.000134.539134.24950299.5005162.000134.52

59、9134.23950294.5005185.000134.464134.17450271.5005193.000134.436134.146 5199.000134.412134.1225200.000134.408134.1185184.700134.465134.175凹型竖曲线-大桩号（后坡）凸型竖曲线-前坡凸型竖曲线-前坡55447.441(63192.744)(63193.034)55454.700(63211.013)(63211.303)1.80055447.150(63192.012)(63192.302)9.35055439.950(63173.895)(63174.185)

60、16.55055433.000(63156.409)(63156.699)23.50055426.400(63139.806)(63140.096)30.10055419.950(63123.582)(63123.872)36.55055413.750(63107.990)(63108.280)42.75055407.700(63092.776)(63093.066)48.80055456.500(63215.543)(63215.833)0.000桩号路面边沿高程5200.000134.0885204.400134.0705214.500134.0235218.500134.0035229.